SUMMARY:

• 5 plus Years of IT experience in development, Implementation and Testing of various projects using Data Warehousing tools.
• Extensively worked in Extraction/Transformation/Loading of the legacy data to Data warehouse using Informatica (Power Center 9.1.5.6/8.5.6 ),Informatica Power Exchange 9.6.5, including Designer, Repository Manager, Server Manager, Workflow Manager and Workflow Monitor
• Knowledge in architecture design of Extract, Transform, Load environment using Informatica Power Center
• Strong experience in designing and developing Business Intelligence solutions in Data warehouse/Decision support systems using ETL tools.
• Experience in designing/developing complex mappings, from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and Normalizer.
• Sources worked on include Flat Files, Excel files and Databases
• Extensive experience developing complex mappings with Custom Transformations, XML Sources, Web Services Consumer.
• Extensively worked on performance tuning of Informatica Mappings and Sessions by implementing parallelism, partitioning and caching
• Involved in design calls with source systems and clients.
• Experience in extracting data from Oracle, XML, Flat Files and DB2.
• Writing technical specifications, test plans and test data to support ETL processes.
• Improved performance by using Explain Plan, Creating appropriate indexes, queries optimization, utilizing table spaces and partitioning schemes.
• Hands on Experience in SQL, UNIX, Data Relationships, Data extraction & Validation.
• Resolving data issues, complete unit testing and complete system documentation for ETL processes
• Hands on Experience in Data warehouse Testing.
• Involved in development of Test cases and executing the Test cases.
• Involved extensively in GUI, System Testing and Regression Testing.
• Competent in writing and executing Test Plans, Requirements Traceability Matrices (RTM), Test Cases and Test Scripts from Requirements, Use Cases and various project documentation
• Proven skills in research, analysis, solution validation, and implementation throughout Software Development Life Cycle (SDLC) with excellent problem - solving skills
• Experience on Test management and Defect tracking tools like HP Quality Center and Bugzilla
• Ability to quickly analyze and -up with an efficient industry standard solution for a given problem come
• Expert working with windows workstation setting, and have excellent knowledge of the Microsoft office suite - Word, Excel, PowerPoint, SharePoint, Outlook, OneNote
• Proven team player with strong interpersonal skills and handling multiple projects with varying priorities
• Excellent written, verbal, and interpersonal skills & possess to communicate verbally and in writing with all levels of technical and non-technical personnel

TECHNICAL SKILLS:

Operating System/Browsers: Windows XP, Windows 7, Windows 8, Unix, Internet Explorer (IE), Firefox, Safari, Chrome.

Database/RDBMS: Oracle 10g/11g, SQL* Navigator, SYBASE, Teradata, DB2, TOAD, SQL, SQL Plus, Developer, SQL, MSSQL 2000

Microsoft and Other Tools: Microsoft Office, Word, Excel, PowerPoint, Visio, SharePointDrop box, MS SharePointETL Tools Informatica Power Centre 9.6.5.1/8.6 , Informatica Power Exchange 9.5.6.

OLAP: Business Objects

Data/Object Modeling Tools: Oracle Designer

PROFESSIONAL EXPERIENCE:

Confidential, Melville

Informatica Designer/Developer

Responsibilities:

• Designed the ETL processes using Informatica to load data from Flat Files, XML Files and Excel files to Oracle Staging area.
• Designed and developed Mappings with various transformations such as Connected and Unconnected Lookup, XML Source Qualifier, Filter, Joiner, Router, Stored Procedure, Sorter, Expression, Aggregator, and Union transformations.
• Interacting with Users and participating in gathering the requirements.
• Designing the Technical Design Specifications for all interfaces.
• Worked extensively with designer tool to develop Mappings, Mapplets, and Reusable transformations to extract, transform and load the data.
• Developed and scheduled Workflows, Worklets using Workflow Manager.
• Implemented Performance Tuning Logics wherever possible to provide maximum efficiency and performance.
• Involved in creating shared and re-usable objects in the shared folder and update the objects with the new requirements and changes.
• Designed and developed efficient Error Handling methods and implemented throughout the mappings.
• Session performance was improved with pipeline partitioning and increasing block size, data cache size, sequence buffer length and target based commit interval.
• Performed Unit testing and System testing of Informatica mappings. Efficient documentation was done for all mappings and sessions.

Environment: Informatica Power Center 9.5.6, Informtica Power Exchange 9.5.6, Oracle 11g, Toad, Teradata, UNIX, Flat files, ODBC, XML, MQ Series, MS Excel.

Confidential, SFO, CA

Data Analysis/ Informatica Developer

Responsibilities:

• Interacted with the management and user community to understand and gather requirements.
• Created physical and logical structures of the database and tables using Oracle
• Developed mappings using Source qualifier, Aggregators, Connected & unconnected Lookups, Stored Procedures, Filters, Sorter & Update strategy Transformations using Power Center7.0/6.2.
• Worked with various transformations like Aggregator, Expression, Filter Source Qualifier, Joiner, Sorter, Router and Look Up and Stored Procedure etc to in corporate the business rules into the mappings.
• Performed various Aggregate Function like AVG, MIN, MAX, COUNT, FIRST, LAST, STD DEVIATION, MEAN AND MEDIAN
• Used XML Transformation to move data from XML files from staging to Targets of Claimant Data.
• Involved in migrating the Repository from Development, testing and Production after testing
• Involved in Creating tasks, work lets, workflows to load various dimensions that include Products, Product Categories, Coverage Type, Coverage Level, Risk Level Dimensions.
• Scheduled, Run and Monitored sessions using workflow manager and workflow monitor to update data on claims, drug, physician and customer data.
• Involved in dealing with performance issues at various levels such as target, sessions, mappings and sources.
• Developed and Optimized Mappings, Mapplets and Sessions from source to target database using Informatica Power Center, and Tuned Mappings for improving performance.
• Tested all mappings developed in Power Center repository and checked data transformation.

Environment: /Tools: Informatica Power Center 9.1/ 8.6, UNIX, Oracle 10g, MS Access, Excel, Oracle E-Business Sute, SQL * Loader, Erwin 4.0,UNIX, Linux.

Confidential, IA

Informatica Developer

Responsibilities:

• Involved in creation of Logical Data Model for ETL mapping and the process flow diagrams.
• Worked with SQL developer to write the SQL code for data manipulation.
• Worked on Informatica versioned repository with check in and checkout objects feature.
• Used Debugger extensively to validate the mappings and gain troubleshooting information about data and error conditions.
• Provided guidance to less experienced personnel. Conducted quality assurance activities such as per reviews.
• Participate in the business analysis process and the development of ETL requirements specifications.
• Worked with production support systems that required immediate support
• Develop, execute and maintain appropriate ETL development best practices and procedures.
• Assisted in the development of test plans for assigned projects.
• Monitor and tune ETL processes for performance improvements, identify, research, and resolve data warehouse load issues.
• Involved in unit testing of the mapping and SQL code.
• Developed mappings to load data in slowly changing dimensions.
• Involved in performance tuning of source &target, mappings, sessions and workflows.
• Worked with connected, unconnected lookups and reusable transformations and Mapplets.
• Involved in designing the star schema and populating the fact table and associated dimension tables.

Environment: Oracle 10g, SQL, PL/SQL, Informatica Power Center 8.5, Sybase, Windows XP, Visio 2000, Business Objects, Crystal Reports, UNIX.