PROFESSIONAL SUMMARY

• 7 years of ETL and data integration experience in developing ETL Mappings, Mapplets, Workflows, Worklets and Scripts using Informatica Power Center 9.x/8.x
• Extensive experience in Analysis, Design, Development, Testing, Implementation and Maintenance of Data Warehousing projects across different domains like order management, manufacturing, healthcare and pharmaceutical.
• Extensively used ETL methodologies for supporting data Extraction, Transformation and Loading ETL process in a corporate-wide-ETL solution using Informatica Power Center.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, complex SQL queries using SQL Server.
• Expertise in Data Modeling using Star and Snowflake Schema, Fact and Dimensions tables.
• Experience in integration of various data sources like Oracle, DB2, Sybase, SQL server and MS access and non-relational sources like flat files into staging area.
• Hands on experience on informatica web services WSDL/XSLT/XML .
• Experience in creating reusable transformations Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank and mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Strong experience in performance tuning, debugging and error handling of mappings, sources and targets for better performance.
• Experience in developing Data Marts.
• Experience in writing and using stored procedures.
• Experience in dealing with various relational and dimensional data models like star schema.
• Expertise with all ODI tools - Topology, Security Manager, Designer and Operator.
• Strong knowledge in writing efficient complex SQL Queries in Oracle 11g/10g/9i and in PL/SQL for stored procedures, triggers, indexes, cursor, and functions.
• Experienced in Agile /Scrum based system development.
• Expertise in Health care domain like Medicare, Medicaid and Insurances compliance within HIPAA regulation and requirement.
• Expertise in creating mappings to read from Flat files, RDBMS and to load into RDBMS tables.
• Expertise in using Microsoft Team Foundation Server TFS as the tool to track Agile progress.
• Experienced in UNIX work environment, file transfers, job scheduling and error handling
• Worked on integrating data from flat files
• Optimizing the SQL to improve the performances and Good experience with UNIX Shell Scripting.
• Ability to work in-groups as well as independently with minimum supervision and initiative to learn new technologies and tools quickly with good communication skills.

TECHNICAL SKILLS

• ETL Tools: Informatica Power Center 9.1/8.6 Designer, Workflow Manager, Workflow Monitor, Repository manager
• Databases: MS Access, SQL Server 2000/2008, Oracle 9i 10g
• Database Tools: Toad 10.1.1, SQL Developer, Interactive SQL
• Program Languages: SQL, PL/SQL, UNIX, C, C , .NET, C , Oracle EBS,
• Operating systems: Windows 95/98/NT/2000/XP, UNIX
• Web technologies: HTML, CSS, XML
• Test Management Tools: HP Quality Center QC , Microsoft Team Foundation Server TFS
• Project Management Data Modelling Tools: MS-Project, Microsoft Visio
• Methodologies: Agile/ Scrum, Waterfall, Rapid Application Development RAD , UML, Business Modeling, Process Modeling, Data Warehouse and Data Modeling, UDT and DT studio.

PROFESSIONAL EXPERIENCE

Confidential

Role: Sr. Informatica Developer

Confidential Health System enjoys national recognition as a model for high quality integrated health service delivery has been listed in Best Hospitals in America, and its physicians have been listed in The Best Doctors in America. The company provides services for patients in the areas of heart disease, gastrointestinal disorders, kidney and pancreas diseases, liver diseases, cancer, neurology, transplantation, lung diseases, obstetric and gynecologic conditions, plastic or reconstructive surgery, psychiatric, rehabilitation, surgery, organ transplant, urologic conditions. The goal of the project was tracking history of outpatient, inpatient and drug history and their billing methods.

Responsibilities:

• Collaborated with Business analysts for requirements gathering, analysis, ETL design and development for extracting data from the heterogeneous source systems like MS SQL Server, Oracle, flat files, XML files and loading into Staging and Data Ware House Star Schema.
• Prepared technical design/specifications for data Extraction, Transformation and Loading.
• Designed and developed the data transformations for source system data extraction data staging, movement and aggregation information and analytics delivery and data quality handling, system testing, performance tuning.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Integrated Oracle EBS with Informatica Power Center and OBIEE. Configured DAC for Finance.
• Worked closely with Facets 4.48, 4.51 and different EDI transaction file like 837, 834, 835, 270, 271 to understand the source structure and the source data pattern.
• Involved on various HIPPA claims validation and verification process to understand the source data.
• Involved in massive data cleansing prior to data staging.
• Used informatica Web Services to support the feeds. Created and used WSDL
• Designed and developed ETL routines, using Informatica Power Center within the Informatica Mappings, usage of Lookups, Aggregator, Java,XML, Ranking, Mapplets, connected and unconnected stored procedures / functions / Lookups, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers were extensively done.
• Created Data Marts for both kinds of applications, CRM and financial and used effective querying and formatting tools to present the data to the end users.
• Created complex mappings with shared objects/Reusable Transformations/Mapplets using mapping/Mapplet Parameters/Variables.
• Installed ODI. Set up the ODI connection with Oracle, MS SQL Server and flat files.
• Created sequential/concurrent Sessions/ Batches for data loading process and used Pre Post Session SQL Script to meet business logic.
• Configured workflows with Email Task, which would send mail with session, log for Failure of a sessions and for Target Failed Rows.
• Extensively used pmcmd commands on command prompt and executed Unix Shell scripts to automate workflows and to populate parameter files.
• Perform code reviews and executing unit testing.
• Worked with UNIX shell scripts extensively for job execution and automation.
• Used SQL tools like Query Analyzer and TOAD to run SQL queries and validate the data.
• Tuning the Mappings for Optimum Performance, Dependencies, Batch testing Batch Design and TWS scheduling.
• Worked UDT transformations using DT Studio.
• Worked in Agile/Scrum environment and utilized Microsoft Team Foundation Server TFS to manage the team's software development lifecycle including deriving product backlog items, assigning sprint work items to developers and conducting sprint review meetings.
• Prepared test scenarios and test cases in HP Quality Center and involved in unit testing of mappings, system testing and user acceptance testing.

Environment: Informatica Power Center 9.1, Oracle 11g, Toad 10.1.1, SQL 2012, Control-M, UDT, Teradata 12.0, Flat Files, UNIX, Windows XP, HP Quality Center, Agile/ Scrum, Oracle EBS.

Confidential

Role: Informatica Developer

Kaiser Permanente is one of the nation's largest not-for-profit health plans, serving approximately 9.5 million members. Among the innovations it has brought to U.S. health care are: prepaid health plans which spread the cost to make it more affordable physician group practice to maximize their abilities to care for patients putting as many services as possible under one roof.

Responsibilities:

• Worked with Data Modeler to understand the business requirements and business rules
• Prepared ETL Specifications to help develop mapping.
• Extracted data from various sources Flat files, SQL Server, DB2 Databases .
• Designed and developed Informatica Mappings and sessions based on business user requirements and business rules.
• Worked extensively on Source Analyzer, Mapping Designer, and Warehouse Designer Developed several Mappings using corresponding Sources, Targets and Transformations, Web Services.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database, created Automated scripts, defined storage parameters for the objects in the Database.
• Created mappings to read from Flat files, RDBMS and to load into RDBMS tables.
• Based on business Rules Debugged code, tested and validated data after processes are run in development.
• Created ODI design documents from the existing Informatica mappings. Used these design documents in development of ODI interfaces/packages.
• Did SQL and PL/SQL programming for ODI and oracle.
• Used ODI commands like ODIFile Move, odiFileAppend, odiFilecopy etc.
• Analysed EDI interfaces to understand the source system and source data.
• Prepared and maintained mapping specification documentation.
• Modified the existing mappings for the updated logic and better performance.
• Developed Logical Data Flow Diagrams in Visio for every mapping that is developed. Assisted QA Team to fix and find solutions for the production issues.
• Worked on Unstructured Data Transport UDT.
• Involved in Unit testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.

Environment: Informatica 9.1, DB2, ERWIN, Oracle 10g, SQL Server 2008, Visual Basic.Net, MS Access, MS Visio, Business objects 6.5,Toad, SQL ,UNIX, Windows 2000, HP Quality Center, Oracle EBS.

Confidential

Role: ETL Informatica Developer

Confidential is a research-based, growth-oriented global enterprise with core competencies in the fields of health care, nutrition and high-tech materials. The project is meant for automating and standardizing the operations of the dealers for stock list. The System generates reports for covering purchase order status, purchase order history by department, purchase order history by supplier, and item exception reports etc.

Responsibilities:

• Gathered business scope and technical requirements.
• Worked with Power Center Designer tools in developing mappings and Mapplets to extract and load the data from flat files and Oracle source to Oracle target .
• Created different transformations for loading the data into targets using various transformations.
• Created reusable transformations and Mapplets to use the transformation logic in multiple mappings.
• Worked on Repository manager to create and manage user profiles.
• Wrote Data loading stored procedures, functions using PL/SQL from Source systems into operational data storage.
• Scheduled Sessions on the Informatica Server using Informatica workflow Manager.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Involved in fine tuning queries for better performance includes indexing and pre-joining and materializing views .
• Created views and altered some of the dimensional tables to satisfy their reporting needs.
• Created reports like, Reports by Department, Reports by Supplier, Reports by Period, Demographic reports and Comparative reports.
• Created different types of reports such as Master/Detail, Cross Tab and Chart.
• Used Analyzer and Explorer to view reports from different prospect like Slice and Dice and Drill down.
• Worked on Unstructured Data Transport UDT.
• Involved in Unit testing, System testing to check whether the data loading into target is accurate, which was extracted from different source systems.

Environment: Informatica 9.1, XML, DB2, Workflow Manager, Informatica Power Connect, Workflow Monitor, Ms-Access 2007,Ms-Visio, Teradata, Oracle 9i, SQL Server 2000, PL/SQL Developer,VB.Net, Business objects 6.5,Toad ,Windows 2000, UNIX, C .

Confidential

Role: Informatica Developer

Confidential is a leading provider of comprehensive disease management services for chronic disease, high-cost episodic conditions and clinical homecare services. Their goal was to create a marketing data mart to cater the reporting needs of Sr. Management. The management wanted to view the pattern and sequence in which region was doing good. The final accepted system provided the management with the knowledge of each reason and the average ratio.

Responsibilities:

• Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business.
• Developed various transformations, mappings and sessions in Informatica to load data from source to target database.
• Used various Transformations like Aggregator, Joiner, Expression, Filter, Update, Lookup, Sorter and Stored Procedure transformations to develop robust mappings in the Informatica Designer.
• Created Reusable Transformations and Mapplets to use in Multiple Mappings and also worked with shortcuts.
• Implemented performance tuning logic on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance.
• Involved in Dimensional modeling to Design and develop STAR Schemas by using ERWIN 4.0, identifying Fact and Dimension Tables.
• Used Debugger to debug mappings to gain troubleshooting information about data and error conditions.
• Analysed EDI interfaces to understand the source system and source data.
• Scheduled the sessions to extract, transform and load data in to warehouse database on Business requirements.
• Worked on Unstructured Data Transport UDT transformations.
• Optimized the performance of the mappings by various tests on sources, targets and transformations.

Environment: Informatica 7.1, Cognos XML, DB2,ERWIN, Oracle 9i, SQL Server 2005, Visual Basic.Net, Ms-Access, Business objects 6.5,Toad, SQL ,UNIX, Windows 2000.

Confidential

Role: ETL Developer

Confidential is the Confidential. A database was maintained for the sales, weekly schedules and monthly schedules. The project required regular updating and maintenance of the database.

Responsibilities:

• Involved in the requirements definition and analysis in support of Data Warehousing efforts.
• Involved in logical and physical database design using ERWIN.
• Worked extensively on Informatica tools -Repository Manager, Designer and Workflow Manager.
• Involved in Extraction, Transformation and Loading ETL Process.
• Created the Source and Target Definitions using Informatica Power Center Designer.
• Developed and tested all the backend programs, Informatica mappings and update processes.
• Created and monitored workflows and sessions using Informatica Power Center Server.
• Tuned the mappings oracle queries to increase its efficiency and performance.
• Used Informatica Workflow Manager to create workflows.
• Workflow Monitor was used to monitor and run workflows.
• Created UNIX scripts and use in Informatica with command tasks.
• Set up batches and sessions to schedule loads at regular intervals in Informatica.

Environment: Informatica Power Center 7.1, Windows 2000, Oracle 9i, PL/SQL, SQL Developer, UNIX shell scripting, Erwin.