SUMMARY

• Around 8 years of overall IT exposure with system design, development, testing support and production support experience in Health Insurance, Commercial Insurance and Retail Domains.
• Prime expertise in Data Warehousing which involves ETL, Teradata, Reporting and Data modeling.
• Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using Informatica Power Center 9.6.1.
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, and Sequence Generator.
• Excellent capabilities in integration mappings including dynamic cache lookup, shared, and persistence mappings for Type I, Type II, Type III slowly changing dimensions.
• Good knowledge in OLAP and OLTP process.
• Good exposure in working with SFTP using the SSH encryption and knowledgeable about B2B Data transformation.
• Proficiency in using Informatica Power Center tool to design data conversions from wide variety of sources.
• Strong in Data warehousing concepts, dimensional Star Schema and Snowflakes Schema methodologies.
• Has good exposure of Data Migration/Integration
• Extensively worked with large Databases in Production environments.
• Proficient in using Informatica workflow manager, Workflow monitor to create, schedule and control workflows, tasks, and sessions.
• Involved in Performance tuning of the Informatica and Oracle.
• Extensive work in ETL process consisting of Data Transformation, Data Sourcing, Mapping, Conversion and Loading.
• Designed and developed data validation, load processes (ETL) using Oracle Data Warehouse Builder.
• Performed Unit testing and Performance testing.
• Extensively worked with SQL Loader for bulk loading into the oracle database.
• Proficient in understanding business processes / requirements and translating them into technical requirements.
• Highly adopt at creation, execution, testing and debugging of Informatica Mappings, Mapplets, Sessions, Tasks, Worklets and Workflows in UNIX and Windows Environment.
• Good Knowledge in Data Modeling.
• Experience in creating UNIX shell scripts to access data and move data from Production to Development and developed UNIX scripts and scheduled ETL Loads.
• Extensive experience with Business - to-consumer (B2C) sales of tangible goods/online services and Business-to-business (B2B) scenarios, such as e-procurement.
• Knowledge and experience in implementation ofHIPAA andNCPDPstandards.
• Extensive experience in analyzing and requirements gathering and writing system functional specifications
• Application of Software Development Life Cycle (SDLC), with thorough understanding of various phases such as Requirements, Analysis/Design, Development, Testing and Implementation.

TECHNICAL SKILLS

Data Warehousing ETL: Informatica PowerCenter 9.0.1/8.6.1/8.1.1

Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, Fact, Dimensions), MS Visio

Databases: Oracle 10g/9i, SQL Server, MYSQL, Oracle,DB2,Sybase

Programming: SQL, PL/SQL, AS400,COBOL,C, C++, Unix

Testing Tools: HP Quality Center 9.0/9.2, Rational Suite (Rational Robot 6.0, Rational Test Manager, and Rational Clear Quest)

Automation Tools: MS Visio, Rational Rose, Rational Clear Case, SharePoint

Other Tools: Oracle SQL Developer, TOAD, Adobe Dreamweaver, MS Office, Autosys

Operating Systems: UNIX, Windows (XP, NT/95/98/2000,7).

PROFESSIONAL EXPERIENCE

Confidential, Framingham, MA

Sr. Informatica Developer

Responsibilities:

• Gather requirements by conducting meetings and brainstorming sessions with end users and SME and document them.
• Requirements solicitation for all Warehouse Management Systems projects.
• Analyze technical and functional requirements of all assigned logistics projects.
• Work within a structured SDLC process of managing software maintenance and development.
• Implement WMS solutions for new customers.
• Collaborate with Business analysts and the DBA for requirements gathering, business analysis and designing of the data marts to prepare to code ETL Mappings for new requirement changes.
• Analyzing underlying business information contained with disparate source systems.
• Create/Modify complex Informatica mappings as per design documents.
• Implemented Performance tuning techniques for ETL processes such as finding bottlenecks in sources, targets, mappings, and sessions and have done Troubleshooting and Error Handling.
• Worked on complex transformations like Lookup, Normalizer, Aggregator, Expression, Update Strategy, Filter, Router, Joiner, Sorter and Union transformations.
• Played a key role in working with SFTP transfers using the SSH keys.
• Extensively used Informatica debugger to figure out the problems in mappings. Also involved in troubleshooting existing ETL bugs.
• Implemented Incremental loading of mappings using Mapping Variables and Parameter Files.
• Create and execute test plans, test files and scripts for data warehouse testing.
• Unit/Integration Testing- creation and execution of test cases that correspond to the needs of the business requirements and validate test results with business representatives.
• Create and maintain real-time batch jobs using Autosys batch application.
• Working with management regarding issues, change control and communication of resolution to completion among associated team members, including identifying discrepancies between systems.
• Analysis of project/work tasks, provide estimates of scope, work efforts and dependencies.

Environment: Informatica Power Center 9.1.0, Oracle 11g, MS SQL Server, Oracle SQL Developer, TOAD, Autosys Software, HP Quality Center, Robo FTP, TOAD, Flat file and XML Sources, ERwin, UML.

Confidential - Detroit, MI

Sr. Informatica Developer

Responsibilities:

• Interacted with Business system analysts to review and analyze the ETL requirements and develop the data migration plan according to the company’s methodology.
• Designed and developed complex mappings and Mapplets using various transformations using Informatica version 8.6
• Identifying the source and validate the source data, developing particular logic and transformation as per the requirement and creating mappings and loading the data into different targets.
• Implemented Star schema, Slowly changing dimensions Type 2 with delta incremental loads.
• Performed change data capture (CDC) process using SCD-I and SCD-II implementations.
• Worked in the Performance tuning of the programs, ETL Procedures and processes.
• Performance tuning of SQL statements.
• Analyze complex tickets as and when they arise, resolved them and passed them to UAT under critical time frames.
• Used Autosys scheduler for scheduling and running the jobs as per the business.
• Reviewing the ongoing development projects with technical design specifications, test plans, quality assurance, deployment procedures and change control processes to manage the IT development life cycle for assigned IT tasks ensuring quality, timely and accurate delivery.
• Worked with Oracle SQL Developer to analyze the data and perform various DML functions.
• Employed staging areas in ETL process to improve the performance and data quality.
• Worked extensively on pipeline partitioning to improve session performance. Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Tested applications and resolved complex problems throughout software development life cycle (SDLC), including preparing detailed program specifications.
• Responsible for maintaining and updating technical documentation for software and systems.

Environment: Informatica Power Center 8.6.1 (Repository Manager, Power Center Designer, Workflow Manager, Workflow Monitor), Oracle 10g, Windows Server 2003, ERWIN 4.x,Microstrategy.

Confidential

Informatica Developer

Responsibilities:

• Actively involved in gathering requirements and acquiring application knowledge from Business Managers and Application Owners.
• Involved in the development of the Conceptual, Logical and Physical data model of the Star Schema using ERWIN.
• Extracted data from various Source Systems such as Oracle, Sql Server, Flat Files, and DB2 as per the requirements.
• Designed and developed several complex mappings using various transformations like Source Qualifier, Expression, Lookup, Aggregator, Router, Rank, Filter and Sequence Generator transformations.
• Created Workflows and used various tasks like Email, Event-wait and Event-raise, Timer.
• Used Workflow Monitor to monitor the jobs, review error logs that were generated for each session, and rectified them.
• Worked on performance tuning of the ETL processes. Optimized/tuned mappings for better performance and efficiency.
• Extensively involved in coding of the Business Rules through PL/SQL using the Functions, Cursors and Stored Procedures.
• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.

Environment: Informatica 6.2, Oracle 9i, OLTP, PL/SQL, SQL Server, DB2, MS Excel, UNIX Shell Scripting, TOAD 7.1.