SUMMARY

• 7 Years of total IT experience
• 6+ Years of Informatica experience
• SDLC: Over 7 years of IT experience with four years of experience in System Analysis, Design, coding and testing of Data Warehousing implementations across Financial, Banking, Insurance and Pharmaceutical
• Informatica: 6+ years of Data Warehousing experience using Informatica Power Center 8.6, PowerMart 6.1, Warehouse Designer, Power Connect for Siebel/DB2, Power Exchange, Power Analyzer, Power Plug, ETL, Siebel 7.0/, Siebel Warehouse 6.3, Siebel EIM, OLAP, OLTP, Autosys, JCL Control M, Sybase. Implemented data warehousing methodologies for Extraction, Transformation and Loading using Informatica Power Center (Repository Manager, Workflow Manager, Workflow Monitor). Extensively Worked on Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designers.
• Experience in designing and developing Mappings, using various transformations like Unconnected and Connected lookups, Source Qualifier, Rank, Sorter, Router, Filter, Expression, Aggregator, Joiner and Update Strategy etc.
• Involved in data replication, data warehousing and data mart, cluster and grid configurations.
• Strong skills in Oracle are PL/SQL, backend programming like Stored Procedures, Functions, Cursors, Triggers and Packages.
• Extensive experience in implementation of Data Cleanup procedures, Transformations, Scripts and execution of Test plans for loading the data successfully into the targets.
• Involved in Troubleshooting database problems, Performance tuning - Session and Mapping tuning, partitioning.
• Worked extensively on forward and reverse engineering processes. Created DDL scripts for implementing Data Modeling changes. Created ERWIN reports in HTML, RTF format depending upon the requirement, published Data model in model mart, created naming convention files, co-coordinated with DBAs to apply the data model changes.
• Postproduction support, enhancements and performance tuning.
• Extensive experience to analyze unstructured data and convert it into datasets.
• Involved in Designing the ERD DIAGARMS.
• Experienced at Creating effective Test data and development thorough Unit test cases to ensure successful execution of the data & used pager for notifying the alerts after successful completion.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Centre 8.x/7.x/6.x, Power Mart 5.1, SQL Server DTS 2000, Oracle Warehouse Builder, Autosys 3.5,JCL, SQL*Plus, SQL*Loader

Reporting tools: OBIEE 10.1.3 (Oracle BI Admin Tool, Presentation Services, Catalog Manager, Job Manager), Business Objects

Modelling Tools: Erwin 4.0

Databases: Oracle 10g/9i/8i/8.0/7.0 MS SQL Server 2000/7.0,SQL Server 2005,2008 IBM DB2/UDB 7.2, MS Access 2000, MySQL, Teradata

Operating Systems: Windows XP/2000/NT/9x, UNIX(Korn), Sun Solaris 2.6/7/8, AIX 5.2, MS-DOS 6.22

Programming: SQL, PL/SQL, UNIX Shell Scripting(C Shell, Korn Shell Bourne Shell), C, C++, Java 2.0, Visual Basic 6.0, COBOL

Web Development: JavaScript, VBScript, HTML 4.0, DHTML, Java, JSP

PROFESSIONAL EXPERIENCE

Confidential

ETL Developer

Responsibilities:

• Involved in analysis, requirements gathering, function/technical specifications, development, deploying and testing.
• Involved in all the phases of project (Client Interaction, Gathering requirements from Business users, Preparation of detail design, Development, Unit Testing and Production support).
• Created Informatica Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, and Connected and Unconnected lookups, Filters, Sequence, Router and Update Strategy.
• Cleansed the source data, extracted and transformed data with business rules, and built reusable transformation logic, known as ‘Mapplets’ using Informatica Designer.
• Modified several of the existing mappings and created several new mappings based on the user requirement.
• Used the Debugger in debugging some critical mappings to check the data flow from instance to instance.
• Created various tasks like sessions, work lets, and workflows in the workflow manager to test the mapping during development.
• Involved in Performance tuning of various mappings and sessions to increase the performance.
• Extensively worked on tuning and thereby improving the load time.
• Involved in the error checking and testing of ETL Procedures using Informatica Session log and workflow logs
• Developed the mapping to pull the information from different tables and used SQLOveride to join the tables instead of Joiner transformation to improve the performance
• Scheduled sessions to update the target data using Workflow Manager of Informatica.
• Developed all the mappings according to the design document and mapping specs provided and performed unit testing.
• Reviewed the ETL mappings and data samples loaded in the test environment for data validation.
• Developed reports using BI Dashboard and Answers, views & charts, created filters to obtain weekly sales for each region & send alerts to upper management.

Environment: Informatica Power Center 8.6 (Informatica Designer, Repository Manager, Workflow Manager, Workflow Monitor) Windows XP, Oracle 10g, Toad.

Confidential, Richmond, VA

ETL Developer

Responsibilities:

• Analyzed business requirements by interacting with the business users and application development teams
• Designed and developed the ETL architecture to build and populate the data marts using Informatica
• Designed and developed Informatica mappings for data loads that included Source Qualifier, Aggregator, Joiner, Lookup, Filter, Router, Update Strategy, Expression and Sequence Generator transformations
• Designed Parameter driven Informatica sessions and workflows for extracting, cleansing, transforming and loading the data from the heterogeneous sources into the data warehouse by using parameter files
• Implemented SCD Type 2 strategy to update the Slowly Changing Dimensions and maintain the OLAP tables storing history in the data mart star schema
• Developed Informatica mappings to cleanse and remove duplicate rows from source data
• Programmed Oracle SQL, T-SQL Stored Procedures, Functions, Triggers and Packages as back-end processes to create and update staging tables, log and audit tables, creating primary keys
• Used workflow manager for session management, database connection management and scheduling of jobs
• Improved performance by identifying the bottlenecks in Source, Target, Mapping and Session levels
• Performed Unit Testing and assisted QA team in Quality Assurance Testing, Load Testing and UAT,Performance estimation testing
• Ensured the execution of UAT test cases and documentation of test results.
• Analyzing business and functional requirement to design SIT and UAT Test Cases
• Possess strong Documentation skill and knowledge sharing among Team, conducted data modeling review sessions (Erwin) for different user groups, participated in requirement sessions to identify requirement feasibility.
• Prepared functional and technical specification documents for the ETL standards and strategy
• Developed views necessary for structured and ad-hoc reporting
• Managed security privileges for each subject area and dashboards according to user requirements.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Handled Full load and refresh load via staging tables in the ETL Layer.
• Involved in Designing ERD using Star schema.
• Involved in Design and Data Modeling using Star schema.
• Used DAC (Data Warehouse Administration Console) Client to manage, configure, customize, and monitor ETL process.

Environment: Informatica Power Center 8.1, Oracle 9i, DB2, Oracle data ware house builder, XML, Flat files, Erwin 3.2, Windows NT 2000, Toad.

Confidential, Dallas, Texas

Informatica Developer

Responsibilities:

• Involved in business analysis and technical design sessions with business and technical staff to develop requirements document, and ETL specifications.
• Involved in all phases of SDLC from requirement gathering, design, development, testing and roll out to the field user and support for production environment.
• Extensively worked with Informatica Power Center client tools like Source Analyzer, Warehouse Designer and Mapping Designer to develop mappings for implementing the transformation logic to implement the business rules and requirements.
• Worked with the DBA to build the fact and dimension tables.
• Extensively developed source to target mappings and scheduling Informatica sessions.
• Worked on various transformations like Lookup, Aggregator, Expression, Router, Filter, Update Strategy, and Stored Procedure.
• Designed and Developed the workflows, validated the dependencies in between the workflows which involved various tasks like even-wait, command, session tasks.
• Monitored production jobs on a daily basis and worked on issues relating to the jobs failure and restarted failed jobs after correcting the errors.
• Developed reusable transformations and Mapplets.
• Involved in writing the scripts using Korn.
• Used pmcmd command to run Informatica Workflows in Scripts.
• Created test cases and test scenarios and documented actual results.
• Involved in USER ACCEPTANCE testing (UAT) of overall Processes.
• Involved in Performance Tuning of the mappings, used Informatica Debugger.
• Compared actual results to expected results and suggested changes to mappings owned by others.
• Used Incremental Loading and done Slowly Changing Dimension type 2 to maintain history data.

Environment: Informatica Power Center 7.1, Oracle 9i, SQL, T-SQL, UNIX, Windows 2000, Erwin 4.0.

Confidential,

Data warehouse Consultant

Responsibilities:

• Analysis of the client requirements.
• Coordinating with project and soft ware Quality Assurance (SQA) team.
• Developing the Oracle Stored Procedures and T-SQL.
• Unit testing & peer reviews.
• Participating in internal, external Audits.

Environment: Oracle 8, visual Basic 6.0, Windows 2000.