SUMMARY

• Eight Plus 8 Years of Total IT experience in the designing, developing and maintaining large business applications such as data migration, integration, conversion, data warehouse and Testing
• Extensive Experience in Business Requirements Analysis, Application Design, Data Modeling, Development, Implementations and Testing of Data warehousing and Database business systems.
• Six Plus 6 Years of Data warehousing ETL experience implementing Data Warehousing Applications including Analysis, Architecture, Design, Development, Support using Oracle Data Integrator 11g/10.1.3.x, Informatica Power Center / PowerMart 8.6/8.1/7.1.x/7.0/6.2/5.1/4.7, ETL, Datamart, OLAP, OLTP, CA Autosys, BMC Control M, IBM Maestro. Data Cleansing experience with First Logic Ace, DataRight, Merge/Purge , Trillium 7.0 Converter, Poster, Geo-Coder, Matcher , JAVA, UNIX, Tidal, WEBLOGIC,
• Expertise in data warehousing, ETL architecture, Data Profiling using ODI and Informatica
• Extensive experience in creation of ETL Mappings, ODI Jobs and Transformations using Developed effectively different types of SCD's that are based on the specifications.
• Experience in integration of various data sources like SQL Server, Oracle, Teradata, Flat files, DB2 Mainframes into the staging area
• Good understanding in database and data warehousing concepts OLTP OLAP . Experience with logical and physical data modeling and database design using Erwin.
• Experience in functions, cursors, triggers, views, materialized views.
• Expert in implementing business rules by creating ETL Routines.
• Experienced in working with the tools like TOAD, SQL Server Management studio and SQL plus for development and customization.
• Six Plus 6 years of Data Modeling experience using Erwin, Power Designer, Visio, Oracle Designer. In-depth experience in Star / Snow Flake Schema, Conceptual, Logical and Physical Modeling.
• Six Plus 6 Years of Business Intelligence experience using OBIEE, Business Objects XI/6.5/6.0/5.1/5.0, OBIEE, Cognos Series 7.0/6.0, QlikView 9.0/8.0/7.0, MS Excel, MS Access Reports.
• Eight Plus 8 years of extensive Database experience using Oracle 11g/10g/9i/8i/, MS SQL Server 2008/2000/7.0/6.5, Teradata V2R6/V2R5, DB2 8.0/7.0/6.0, MS Access7.0/2000, SQL, PL/SQL, SQL Plus, SQL Loader and Developer 2000. Hands on Working knowledge in Oracle and PL/SQL Writing Stored Procedures, Packages,
• Worked with Oracle, SQL Server DB2 UDB Stored Procedures, Table Partitions, triggers, SQL queries, PL/SQL packages, IBM SQL Procedural Language and loading data into Data Warehouse/Data Marts using Informatica, DB2 Load, Import Utilities, SQL Loader. Worked with Teradata Procedures.

TECHNICAL SUMMARY

PROFESSIONAL SUMMARY

Confidential

SR. DW ODI DEVELOPER

RESPONSIBILITIES:

• Collected requirements from Business Users, analyzed and prepared the technical specifications.
• Used ETL ODI to extract data from different source systems, cleanse Transform, and Load data into databases.
• Assisted in Installation configuration of Oracle Data integrator in the Windows environment.
• Created ODI Interfaces under Projects for the data transformations as per the technical specifications.
• Designed interfaces for different subject areas CLAIMS, DENIED CLAIMS, PROCEUDRE, PROVIDER, REFERENCE, MEMBER.
• Used Filter, lookup, joins in the mappings with execution location on source.
• Worked on Loading and Integration KM in Flow tab in ODI Interfaces.
• Worked on the heterogeneous source by applying joins with execution location as Target.
• Worked on Insert and Update of the Target by associating the Update Key on the Target.
• Implemented Data Integrity by applying Mandatory Columns in Control Tab, Constraint Key, Reference key, complex reference using expression, Condition by using expression.
• Corrected the erroneous records of target by checking control and errors.
• Developed SCD 1 and SCD 2 to capture new changes while maintaining the historic information with ODI.
• Worked on ODI Topology, created Data Server, Physical Schema Data and Work under data server, Logical Schema as alias for Physical Schema.
• Created Context DEV, UAT and PROD to attach more than Physical Schemas to Logical Schema.
• Implemented CDC through ODI Journalization Knowledge Modules KM's .
• Used ODI Scheduler to schedule the jobs in daily routine.
• Built PLSQL procedures, functions as a part of custom transformations and used it in the ODI Package.
• Created ODI Scenario from Packages as the changes in packages and procedure are not reflected in it
• Tuned and optimized interfaces to reduce ETL run times thereby ensuring the interfaces ran within the designated load window.
• Worked extensively with Oracle SQL and PL/SQL Coding.
• Responsible for Error Handling and bug fixing.
• Extensively worked on UNIT TESTING and created different unit test case documents for different subject areas.
• HEALTH CARE CLAIMS RELATED RESPONSIBILITIES
• Worked with HIPAA Transactions and EDI transaction sets 834, 835, 837, 824, 820, 270, 276, 271, 278
• Extensively worked Claims, Enrollment, Eligibility verification for Members and Providers, benefits setup, and backend payment cycle.
• Extensively worked with the suite of Healthcare Applications such as Membership, Provider, Eligibility, Group, Product, Enrollment, Provider, Claims, Correspondence and Letters, Facilities, Customer Service and Health Care Regulatory standards.
• Extensively worked on different claims like ICD-9 codes relates to diagnosis, procedure and service related programs, other claims like Procedure Modifier Codes like CPT Current Procedural Terminology and HCPCS codes

Environment: ODI 11g/10.1.3.4/10.1.3.3, HIPAA, Epic Systems, Oracle 11g/10g, AS400, DB2 8.0, SQL Server 2008/2005 Enterprise Manager, Query Analyzer , Reflection FTP, Cognos, QlikView 8.5, T-SQL, UNIX AIX VERSION 5, Visio 2003, Erwin, UNIX, Maestro, Siebel

Confidential

SR. DW INFORMATICA / ODI DEVELOPER

Responsibilities:

• All phases of SDLC from requirement, design, development, testing and rollout to the field user and support for production environment.
• Participation in Database Design and Database Architecture
• Data Modeling Modeling of stage ER pattern schemas and Data Mart Star Schemas
• Involved in data design and modeling by specifying the physical infrastructure, system study, design, and development by applying Ralph Kimball methodology of dimensional modeling.
• Design facts, dimensions and reference tables and building the relations, constraints and indicator fields
• Responsible for the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Meta Data management.
• Created the ER Entity Relationship diagrams maintained corresponding documentation for corporate data dictionary with all attributes, table names and constraints.
• Extensively used Erwin 7.2/4.1 for data modeling and Dimensional Data Modeling.
• Design, develop, review and test the ETL process to handle extraction Transformations and Loading requirements of the data.
• Worked with Informatica and ODI for ETL
• Configured Oracle Data integrator ODI Master Repository Work Repository on Oracle Database.
• Created ODI Interfaces under Projects to populate the target.
• Created Filter on the source with the execution location on source.
• Worked on Loading and Integration KM in Flow tab in ODI Interfaces.
• Worked on the heterogeneous source by applying joins with execution location as Target.
• Worked on Insert and Update of the Target by associating the Update Key on the Target.
• Created ODI Datastores in the Model to store the metadata Reverse Engineered from Sources.
• Worked on ODI Topology, created Data Server, Physical Schema Data and Work under data server, Logical Schema as alias for Physical Schema.
• Developed ETL mappings in Informatica PowerCenter Designer using various transformations like Source Qualifier, Normalizer, Expression, Connected and Unconnected Lookup, Update Strategy, Sequence Generator etc.
• Created and Configured Workflows, Worklets, and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Developed Several Complex mappings.
• Used Informatica to automate the process of Extract, Transform and Load data from Mainframe Systems DB2 tables and datasets to target warehouse
• Extracted data from heterogeneous data sources like Oracle, DB2, Flat Files and XML Files.
• Created data maps for EBCIDIC files at Mainframe to access through power Center.
• Imported Source definitions from PowerExchange and sourced the EBCIDIC files datasets from mainframes and loaded to tables in UDB
• Used Trillium to cleanse the data.
• Created Mapplets and used them in different Mappings for maintaining the standards.
• Created parameter files using mappings.
• Used debugger to test the mapping and fixed the bugs
• Used Session Task, Command Task, and Event Raise/Event Wait etc. to develop Workflows.
• Imported various Sources, Targets and Transformations using Informatica Power Center Designer.
• Developed the Test Scripts and performed the Unit Tests on the ETL mappings.
• Identified proper partitioning methods for performance enhancements.
• Developed and scheduled Workflows using workflow designer in Workflow manager and Maestro.
• Involved in analyzing source systems and designing the processes for Extracting Transforming and Loading the data to Data marts.
• Wrote the shell scripts to process the PL/SQL procedures and wrote the PL/SQL program Functions, Procedures for data extracting, transforming and loading.
• Responsible to tune ETL procedures and STAR schemas to optimize load and query Performance by using various data and index caches.
• Writing Oracle packages, PL/SQL stored procedures, Functions and call them through Informatica and/or Unix scripts
• Used PowerConnect to extract data from Oracle Apps.
• Extensive Unix Shell Scripting.
• Responsible for Performance tuning for better performance.
• Performed OBIEE QlikView Reporting
• Prepare unit and integration test plans, code review, testing, debugging, deployment of Informatica Jobs into production environment
• Used Informatica PowerConnect to connect to Oracle Applications sources.
• Provided Production support.

Environment: ODI 10.1.3.4/10.1.3.3, Informatica Power Center 8.6/8.5/8.1, Erwin 7.2/4.5, Cognos 8.0, Work Flow Manager, Work Flow Monitor, Maestro, IWR, Erwin, Unix Shell Scripting, XML, Oracle 11g, DB2 8.0, Mainframes, MS Access, Trillium, MS Excel, Flat Files, SQL Server 2008/2005, PL/SQL, Windows NT 4.0, Sun Solaris 2.6

Confidential

SR. ETL DEVELOPER / DESIGNER

Responsibilities:

• Participating in User meetings, gathering requirements and translating user inputs into Technical Specification documents.
• Design and Technical specifications Documentation.
• Involved in full SDLC right form gathering requirements, designing, analyzing, modeling, developing, testing and implementation needed for loading and updating the warehouse.
• Worked closely with the Systems Analysts/Business Analysts to understand and analyze the requirement
• Involved in Building the ETL architecture and Source to Target mapping to load data into Data warehouse
• Analyzed the Functional Specs provided by the Architect and created Technical Specs documents for all the mappings.
• Developed Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
• Worked on Informatica - Source Analyzer, Warehouse Designer, Mapping Designer Mapplet, and Transformation Developer.
• Designed and Customized data models for Data warehouse supporting data from multiple sources on real time
• Used most of the transformations such as the Source Qualifier, Expression, Aggregator, Connected unconnected lookups, Filter, Router, Sequence Generator, Sorter, Joiner.
• Responsible for loading data from source systems into target tables using various transformation Aggregator, Expression, Lookup, Java, Sequence Generator, Update Strategy etc
• Using Workflow manager for Workflow and Session Management, database connection management of jobs to be run.
• Extracted data from SAP and DB2 sources using Informatica PowerConnect
• Developing Informatica mappings tuning them when necessary.
• Extensively used Pre-Sql and Post-Sql scripts for loading the data into the targets according to the requirement.
• Created Unix shell scripts to modify the Client Description tables according to the requirement
• Created Mapplets to be re-used in the Informatica mappings.
• Assisted in Creating various Stored Procedures and functions using PL/SQL for data cleansing operations. Used IDQ / IDE for Data Cleansing, Analysis and Profiling.
• Handle slowly changing dimension Type I, Type II and Type III based on the business requirements
• Worked with IMS Data.
• Extensively worked on solving Performance issues both mapping level and session level.
• Troubleshoot problems by checking sessions and error logs, extensively used Debugger Process to test data and applying Break Points while Session is running.
• Extensively worked with File Transfer Protocol FTP clients for data transfer
• Involved in the analysis, design, implementation, testing of applications.
• Developed Stored Procedures when necessary.
• Using TOAD as a Productivity tool.
• Performance tuning of SQL queries. SQL and PL/SQL Coding.
• Develop Autosys Scripts to schedule Informatica jobs.
• Used Business Objects / OBIEE for reporting purposes.
• Used QlikView for internal reporting.
• Involved in doing Unit Testing, Integration Testing and System Testing, provided Production support.

Environment: Informatica PowerCenter 8.6/8.1, IDQ, IDE, PowerConnect for DB2/SAP, Erwin 7.2, BO XI, OBIEE, IMS Data, Autosys, Oracle 11g/10g, TOAD 8.6, QlikView, DB2, SAP R/3, SQL Server 2008, Unix Scripting, SQL, PL/SQL, T-SQL, Windows NT/2000, HP-Unix, Autosys, ODI

Confidential

ETL INFORMATICA DEVELOPER

Responsibilities:

• Requirements gathering and business analysis by attending business meetings
• Conducted end user interviews to gather reporting and analysis requirements
• Assisted in Logical and physical modeling, followed Star schema to build Claims Datamart
• Maintained warehouse metadata, naming standards, and warehouse standards for future application development
• Created ER Entity Relationship diagrams and maintained corresponding documentation for corporate data dictionary with all attributes, table names, and constraints
• Extensively used Erwin for Dimensional data modeling
• Designed Source to Target mappings from primarily Flat files to Oracle database using Informatica
• Created Project and corresponding Source and Target modules in Informatica
• Developed complex mappings in Informatica using different transformations such as Expressions, Aggregators, Filters, Lookup, and Stored Procedure to ensure movement of data between various applications
• Documented development and execution of Data Mappings/Mapplets, and Informatica sessions as per the business requirement
• Tuned Informatica Mappings and Sessions for optimum performance
• Migration of all Informatica Powercenter mappings to Oracle Warehouse Builder 9i and deployed successfully
• Used Repository manager to create Repository, User groups, Users and managed users by setting up their privileges and profile.
• Developed Complex mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Look up connected and unconnected , Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Update Strategy Rank and Router transformations. Used debugger to test the mapping and fixed the bugs.
• Analyzing the source data and deciding on appropriate extraction, transformation and loading strategy
• Identifying and tracking the slowly changing dimensions, heterogeneous Sources and determining the hierarchies in dimensions.
• Using Workflow manager for Workflow and Session Management, database connection management and Scheduling of jobs to be run in the batch process.
• Developing number of Complex Informatica Mappings, Mapplets and Reusable Transformations for weekly Loading of Data. Used Autosys for scheduling.
• Used Cognos for reporting
• Extensively used Toad for creating Source and Target table structures

Environment: Informatica PowerCenter 7.1/6.2, Oracle 9i/8i, Erwin 4.2/4.0, PL/SQL, SQL Loader, Toad 8.5, Oracle Discoverer, Oracle Developer, Cognos 7.0, Autosys, Windows NT 4.0, Sun Solaris