SUMMARY

• Over 7 years of extensive experience in IT Industry, with special emphasis on design & development of Data Warehousing, Data Modeling, Relational Database Systems and testing web applications.
• Experience in Data Warehousing development, extract and loading data using ETL tools such as Informatica.
• Experienced in Informatica Repository Manager, Mapping Designer, Mapplet Designer, Transformation Developer, Warehouse Designer, Workflow Manager and Workflow Monitor.
• Extensive experience in developing Informatica Mappings, Workflows, and maintaining Informatica Repository, developing UNIX scripts, creating CRON jobs for supporting Informatica processes.
• Experienced in Installation, Configuration, and Administration of Informatica Power Center Client, Server.
• Involved in creating, registering repository, managing repository privileges and taking backup of repository.
• Proficient in conventional ER, OLTP, OLAP, Dimensional Data Modeling Concepts, Star and Snowflake schema design, Logical Data Modeling and data warehousing methodologies, concepts and aspects.
• Experience in datawarehouse design and data modeling tools like ERWIN and Microsoft visio.
• Worked in different stages of Software Development Life Cycle (SDLC) such as analysis, development, user acceptance test, administration, and production support on different platforms like UNIX, Linux and WindowsNT/2000/XP.
• Working knowledge in Java, JDBC, JSP, HTML, JavaScript, XML and other web technologies in client side.
• Experienced in writing of complex queries, Stored Procedures, Functions, cursors, triggers, and packages using PL/SQL.
• Expertise in Create/Build/Run/Schedule Batch Job streams, Sessions, Workflows using the Workflow Manager, pipeline partitioning, configuring email.
• Experience in Partitioning, Performance Tuning of SQL, and ETL process.
• Strong Experience in various Data sources like Oracle, DB2, Teradata, MS SQL Server, MS Access
• Experience in generating reports using Cognos.
• Hands - on Experience in design and development of Business Intelligence reports using Business Objects.
• At Ease in high stress environments requiring superior ability to effectively handle multiple levels of responsibility.
• Exceptional communication, leadership skills, collaboration & team building skills with proficiency at grasping new technical concepts quickly and utilize the same in a productive manner.

TECHNICAL SKILLS

ETL Tools: Informatica 9.01/8x/7x, Datastage

Reporting Tools: Business Objects XIR2/XI3.1, Cognos

Data Modeling Tools: ERWIN 4.x/3.5, Microsoft visio, Rational rose

Databases: Oracle 11g/10g/9i/8i/8.0, DB2, Teradata 12.x, MS-SQL Server 2010/2008/ 2005/2000, MS-Access

Languages: J2EE, Servlets, SQL, PL/SQL, C,C++, .NET,HTML, DHTML, XML, Java Script, VBScript, PHP, Shell script

Methodologies: Data Modeling Logical / Physical, Star/ Snowflake Schema, FACT & Dimension Tables, ETL, OLAP, OLTP, Software Development Life Cycle (SDLC) and Testing Life Cycle.

Operating Systems: Windows NT/2000/2003/XP, UNIX, LINUX

Tools: TOAD, SQL Developer, Teradata Assistant, SQL Advantage

PROFESSIONAL EXPERIENCE

Confidential, MD

Senior Informatica Developer

Responsibilities:

• Creating Source definitions from the Operational sources and Target definitions.
• Worked Extensively on Repository Manager, Designer and Workflow Manager and Workflow Monitor.
• Developed Transformation logic and designed various complex Mappings in the Designer.
• Designed reusable transformations and mapplets in the designer using transformation developer and mapplet designer tools.
• Created Stored Procedures for data transformation purpose.
• Exported and Imported mappings and sessions across Repositories with XML files.
• Troubleshoot error prone mappings and improved the mapping performance using SQL overrides.
• Involved in creating the backup of the Repository.
• Design and Development of ETL routines, using Informatica Power Center within the Informatica Mappings, usage of Lookups, Aggregator, 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 and ran Pre-existing and debug sessions in the Debugger to monitor and test the sessions prior to their normal run in the Workflow Manager.
• Used Workflow Monitor to monitor tasks, workflows and also to monitor performance.
• Created and Scheduled Workflows based on demand, run on time, run only once using Informatica Workflow Manager.
• Used Type2 mapping to update slowly changing dimension table to keep full history.
• Executed the sessions with pre-session and post-session Shell Scripts.
• Developed Shell scripts for event automation and scheduling.
• Efficient Documentation was done for all Mappings and Workflows.
• Fine-tuned Informatica jobs by optimizing all transformations.
• Extensively used SQL and PL/SQL scripts.
• Used Parameter files to pass mapping and session parameters to the session.

Environment: Informatica PowerCenter 9.01, Oracle 11g, SQL Server 2010, Flat Files, XML, UNIX and Windows XP.

Confidential, VA

Senior Informatica Developer

Responsibilities:

• Involved in dimensional modeling of the data warehouse to design the business process.
• Involved in designing logical and physical database model using ERWIN.
• Analyzed and created Fact and Dimension tables.
• Developed procedures to populate the customer data warehouse with transaction data, cycle and monthly summary data, and 36 months of historical data.
• 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, Rank and Router transformations.
• Developed Mapplets using corresponding Source, Targets and Transformations.
• Created Sessions and Batches through the Informatica Server Manager.
• Designed and documented the validation rules, error handling and test strategy of the mapping.
• Developed UNIX shell scripts to run the pmcmd functionality to start and stop sessions and batches.
• Involved in unit testing of the mapping/sessions and batches.

Environment: Informatica PowerCenter 8.6, ERWIN, Oracle 10g, SQL Server 2008, Windows XP.

Confidential, TX

Informatica Developer

Responsibilities:

• As a Developer, involved in the complete cycle of Project Plan, Design, Development and Testing.
• Designed and developed Star & Snowflake Schema, Created Fact and Dimension Tables.
• Worked with different Operational Data Sources such as Oracle, SQL sever, DB2, Flat flies, XML files.
• Used Transformations like Expressions, Aggregators, Routers, Joiners, Rank, Sorter, Stored Procedure, Lookups, Normalizer, Sequence Generator and Update Strategy in mappings to manipulate data related to Customers.
• Worked on Performance Tuning and Partitioning. Identified Performance bottleneck for Sources, Targets, Mappings, Sessions and optimized mappings and sessions.
• Designed and developed Mappings, Mapplets and Sessions.
• Prepared documentation to describe program development, logic, coding, testing, changes and corrections.
• Involved in writing SQL Stored procedures, Triggers for updates.
• Performed Unit Testing and validated the data.
• Automated ETL jobs using Informatica batches and Pre-Session and Post- Session UNIX scripts.
• Used Workflow Manager for creating and maintaining the Sessions and Workflow Monitor to monitor, edit, schedule, copy, abort and delete the session.
• Successfully moved the Sessions and Batches from the Development environment to Production environment
• Involved in generating reports using Business Objects.

Environment: Informatica Power Center 7.1.1, Oracle 10g, MS SQL server 2005, DB2, Flat Files, XML files, UNIX Shell Scripting, Business Objects, SQL* Plus.

Confidential, CA

ETL Developer

Responsibilities:

• Imported and Created Source Definitions using Source Analyzer.
• Imported and Created Target Definitions using Warehouse Designer.
• Developed and Implemented ETL processes using Informatica client tools - Designer, Workflow Manger and Workflow Monitor.
• Created Mappings using Mapping Designer to load the data from various sources using different transformations like Aggregator, Expression, Filter, Joiner, Lookup, Router, Sequence Generator, Source Qualifier, Normalizer, Stored Procedure and Update Strategy.
• Created Mapping Parameters and Variables.
• Involved in writing Stored Procedures.
• Involved in Unit testing and Integration testing.
• Modified several of the existing mappings and created several new mappings based on the user requirement.
• Involved in Optimizing the Performance by eliminating Target, Source, Mapping, and Session bottlenecks.
• Involved in ensuring the stable operation of ETL processes in the production environment to agreed service levels.
• Used Cognos for generating reports.

Environment: Informatica PowerCenter 7x, Windows XP, Oracle, PL/SQL, SQL, UNIX, UNIX Shell Scripting, Cognos, SQL Server, SQL *Plus, DB2.

Confidential, CA

ETL Developer

Responsibilities:

• Involved in gathering and analysis of business requirements, and Data Quality Analysis to determine cleansing requirements.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Extensively used ETL to load data from multiple sources to Staging area (Oracle 9i) using Informatica PowerCenter.
• Worked with pre and post sessions, and extracted data from Transaction System into Staging Area.
• Involved in identifying Facts and Dimensions tables.
• Worked extensively on Source Qualifier, Expression, Router, Aggregator, Update Strategy, Lookup, Stored Procedure, Sequence Generator and Joiner transformations using Informatica and created mappings, sessions, workflows and worklets.
• Configured the sessions using workflow manager to have multiple partitions on Source data and to improve performance.
• Tuning Informatica Mappings and Sessions for optimum performance.
• Designed and developed SQL scripts for creating and dropping tables, indexes, constraints, partitions.
• Created reusable transformations and Mapplets and used them in complex mappings.
• Creating tasks, sessions and workflows for the ETL processes. Wrote Unix Shell Scripts for automating the ETL procedures and calling these scripts through cron jobs.

Environment: Informatica PowerCenter, Oracle 9i, PL/SQL, ERWIN, SQL*Plus, SQL*Loader, Shell Script, UNIX.

Confidential

QA Tester

Responsibilities:

• Responsible in gathering and analysis of requirements.
• Responsible for preparing the project plan.
• Responsible for understanding the project requirements and conducting the feasibility study.
• Worked on developing various macros using MS Excel to serve the purpose of the project.
• Worked on developing the test cases for functional and regression testing.
• Worked on developing the automation test scripts for functional and regression testing.
• Involved in executing the automation test scripts and analyzing the test reports.
• Responsible to properly analyze the test reports and log the bugs.
• Analyzed the production logs on daily, weekly basis to ensure the application is behaving as per the application standards.

Environment: Windows XP, Cognos, Quick Test Professional, HP Quality Center, MS Office