SUMMARY

• 7+ years of IT experience with expertise in complete Software Development Life Cycle (SDLC) which includes business requirements gathering, system analysis, design, development and implementation of data warehouse.
• Expertise in building Enterprise Data Warehouses (EDW), Operational Data Stores (ODS), Data Marts and Decision Support Systems (DSS).
• Extensively used Informatica Client tools - Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Sound knowledge in using Informatica PowerCenter 9.1/8.6.1/8.1.1 (Source Analyzer, Mapplet Designer, Transformation Designer, Star & Snowflake Schemas using Informatica tool on Oracle, Flat files and SQL Server).
• Good proficiency in using databases like Oracle 11g/10g/9i/8i.
• Worked with Dimensional Data warehouses in Star and Snowflake schemas and Slowly Changing Dimensions.
• Proficient in extracting and transforming data from various sources (Oracle tables, Flat files, XML) into the Data-warehouse using ETL tools.
• Extensively worked on transformations such as Source Qualifier, Expression, Aggregator, Filter, Router, Joiner, Lookup, Sorter, Normalizer, Sequence Generator, Stored Procedure and Update Strategy transformations.
• Wide knowledge in Extraction, Transformation and Loading of data from multiple sources to the data warehouse.
• Experienced in creation of mappings, mapplets, workflows, worklets, tasks and also scheduling of workflows.
• Extensively involved in Performance issues of both Informatica and Databases.
• Experience in design of logical and physical data modelling and also have expertise in using SQL Loader to load data from external files to Oracle database.
• Strong experience in RDBMS concepts, PL/SQL programming units like Procedures, Functions and Packages in UNIX and Windows environments.
• Basic knowledge on Informatica Data Quality and Informatica Master Data Management (MDM) software products.
• Excellent in verbal and communication skills, good in understanding business procedures and have ability to work as an individual or in a team.

TECHNICAL SKILLS

Data Warehousing tools: Informatica 9.1/8.6.1/8.1.1 (Powercenter - Designer, Workflow manager, Workflow monitor, Server manager)

Data Modelling: Logical data modelling, Physical data modelling, Relational modelling, Dimensional modelling (Star and Snowflake schemas, Facts and Dimensions), Entities, Attributes, Cardinality, E-R diagrams

Databases: Oracle 11g/10g/9i, Teradata, MS SQL Server 2008

Database tools: PL/SQL developer, SQL Plus, SQL* Loader

Programming: SQL,PL/SQL, HTML, UNIX, XML,C++

Reporting: Cognos 8.2/8.4, BOXI

Other tools: HP Quality Center 10.0, Autosys (Scheduling tool)

Operating Systems: MS Windows NT/2000/2003/XP/Vista/7, UNIX, MS-DOS and Linux

PROFESSIONAL EXPERIENCE

Confidential, Arlington Heights, IL

Senior Informatica Developer/Tech Lead

Responsibilities:

• Extensively used Informatica PowerCenter 9.1 to extract data from various sources and load in to staging database.
• Extensively used transformations such as Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Joiner, Transaction Control and Stored Procedure.
• Extensively used ETL to load data from multiple sources to staging area (Oracle 10g) using Informatica PowerCenter 9.1.
• Worked with pre and post sessions, and extracted data from transaction system into staging area along with knowledge of identifying fact and dimension tables.
• Tuned sources, targets, mappings and sessions to improve the performance of data load.
• Experience in data migration of Informatica mappings, sessions, and workflows to Data Integrator.
• Involved in the development of Informatica mappings and mapplets and also tuned them for Optimum performance, dependencies and batch design.
• Created several Informatica mappings to populate the data into dimension and fact tables.
• Worked cooperatively with the team members to identify and resolve various issues relating to Informatica and other database related issues.
• Designed mapping templates to specify high level approach.
• Budget Estimations of the minor projects.
• Team alignment for the smooth execution of all the Informatica/Oracle based projects in NSN - CFO cluster.
• Arranging training sessions to the team for functional & technical understanding on the project.
• Documentation of the newly created workflows.
• Status reporting for all the projects headed by me.

Environment: Informatica PowerCenter 9.1, Oracle 10g/9i, PL/SQL, Windows, UNIX, LEI, SQL Loader.

Confidential, Barrington, IL

Senior Informatica Developer/Project Leader

Responsibilities:

• Worked closely with client in understanding the Business requirements, data analysis and delivering it to the client’s expectation.
• Used Informatica PowerCenter 8.6.1 and all its features extensively in migrating data from OLTP to Enterprise Data warehouse.
• Extracted data from different sources like Oracle and flat files and loaded into DWH.
• Updated complex mappings in PowerCenter Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Developed mappings/Reusable Objects/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica PowerCenter 8.6.1
• Used Informatica PowerCenter 8.6.1for extraction, loading and transformation (ETL) of data in the data warehouse.
• Involved in creation of Folders, Users, Repositories and Deployment Groups using Repository Manager.
• Developed PL/SQL and UNIX Shell Scripts for scheduling the sessions in Informatica.
• Migrated mappings, sessions, and workflows from development to testing and then to Production environments.
• Involved in Performance tuning for sources, targets, mappings and sessions.
• Performed unit testing on the Informatica code by running it in the Debugger and writing simple test scripts in the database thereby tuning it by identifying and eliminating the bottlenecks for optimum performance.
• Worked extensively with different caches such as Index cache, Data cache and Lookup cache (Static, Dynamic, Persistence and Shared).
• Created deployment groups, migrated the code into different environments. Worked closely with reporting team to generate various reports.
• Prototyped Dimension model and ETL process by matching the business requirements and core technical requirements from the Reporting team.
• Implemented ETL and Dimension prototype with complex mappings and mapplets for faster and effective means of reporting.
• Worked on dimensional models like Star schema and Snowflake schema.
• Used Informatica PowerCenter 9.1 with all its features in migrating data from OLTP to Enterprise Data Warehouse.
• Extracted data from different sources like Oracle and flat files.
• Worked extensively on Source Analyzer, Transformation Developer, Mapplet Designer and Mapping Designer.
• Implemented performance tuning logic on sources, targets, mappings and sessions to provide maximum efficiency and performance.
• Worked extensively with different cache memory in Informatica such as Index cache, Data cache and Lookup cache (Static, Dynamic, Persistence and Shared).
• Worked extensively with different cache memory in Informatica such as Index cache, Data cache and Lookup cache (Static, Dynamic, Persistence and Shared).
• Successfully implemented changes in making all the ETL jobs to harmonize within the allotted DWH time frame.
• Ownership of ETL code with UAT testing and production deployment.
• Handled entire responsibility of deploying code to Test and Production environments without any issues.
• Tested performance for ETL mappings with various possible scenarios.
• Drafted the complete systems testing plan, created all possible business scenarios with efficient data results.
• Supervised sanity test in multiple environments for various stages of the system and streamlined defect management process using HP quality center.
• Demonstrated witness testing to the Client team after every iteration of the testing phase.
• Suggested changes in the ETL development process which improved overall productivity and ability to hit the target plans with less overhead.

Environment: Informatica PowerCenter 8.6.1 (Power Center Repository Manager, Designer, Workflow Manager and Workflow Monitor), Oracle 11g, SQL, PL/SQL, UNIX, Teradata.

Confidential, FL

Senior Informatica Developer/Project Leader

Responsibilities:

• Gathered business requirements and performed analysis, design, development and deployment of various ETL components.
• Prepared High level and Low level design specifications of business requirements.
• Formulated Source to Target mapping documents for better ease of ETL implementations.
• Resolved various technical issues in production databases and implemented code fixes in quick pace.
• Appreciated by the client for efficiently rectifying critical real-time customer issues.
• Extensively used Informatica PowerCenter for extraction, transformation and loading of data from relational and non-relational sources.
• Sound knowledge in using various transformations such as Source Qualifier, Expression, Lookup, Aggregator, Joiner, Sequence Generator, Update Strategy while migrating data from various heterogeneous sources like Oracle and Flat files.
• Developed Informatica mappings, re-usable transformations, re-usable mappings for loading the data into the data warehouse.
• Handled Slowly Changing Dimensions of Type 2 to populate current and historical data into the Dimension and Fact tables in the data warehouse.
• Designed UNIX scripts and automated it to run the workflows at different intervals - daily, weekly and monthly.
• Developed mapping parameters, mapping variable and session parameters using Informatica PowerCenter.
• Composed complex SQL scripts to avoid Joiner, Union and Lookup transformations to enhance the performance of loading huge volumes of data.
• Performed Unit testing, Integration testing and System testing in a Data Warehouse.
• Created deployment groups, migrated the code into different environments - Development, Testing or Production.
• Developed mappings for Fact and Dimension tables using the various transformations to extract data from different sources like Oracle, Flat and XML files.
• Tuned sources, targets, mappings and sessions to improve the performance of data load.
• Extensively tuned Informatica mappings, sessions by following best practices to avoid unnecessary caching of data by the lookups.
• Contributed in designing the logical, physical data models and Star schema for designing the Data Marts.
• Experienced in data migration of Informatica mappings, sessions and workflows to Data Integrator.
• Developed the repository manager, users, user groups and their access profiles.
• Implemented new Autosys set up for scheduling of the ETL jobs.

Environment: Informatica PowerCenter 8.6.1, Oracle 10g, UNIX, Autosys

Confidential, Bradenton, FL

Senior Informatica Developer/Project Lead

Responsibilities:

• Designed and developed ETL strategy for new mappings.
• Analyzed and checked feasibility of new requirements.
• Reviewed Business Requirement Documents (BRD) for accuracy and completeness of business requirements.
• Tuned highly complex ETL sessions to reduce the overall refresh time by more than 30%.
• Developed PL/SQL and UNIX scripts for scheduling sessions in Informatica.
• Migrated mappings, sessions and workflows across different environments - Development to testing and then to Production.
• Created test data and configured testing of the Informatica code using the Debugger option to identify issues related to any particular set of data.
• Created Informatica mappings to populate the data into dimensions and fact tables.
• Developed Connected and Unconnected Lookup transformations to lookup the data from source and target tables.
• Worked along with the DBA to resolve performance and tuning issues.
• Involved in creation of Folders, Users, Repositories and Deployment Groups using Repository manager.
• Utilized the Explain Plan, Hints, Analyze commands, Statistics and Indexes for better performance of SQL queries.
• Documented the best practices to be followed in resolving data load and memory related issues in Informatica.
• Monitored ETL jobs running in Production environment and fixed bugs and documented the same to avoid similar future occurrences.
• Developed and documented mappings/transformations, audit procedures and Informatica sessions and workflows developed.
• Coordinated with my team members to identify and resolve problems based on Informatica and other database related issues.
• Created test scripts, performed System Integration testing, Regression testing and reviewed test results.
• Used SQL Loader to load huge flat files into Oracle database.

Environment: Informatica PowerCenter 8.6, BOXI 11.5, PL/SQL developer, Oracle 10g/9i, UNIX,Oracle, SQL Loader,Autosys.

Confidential, Bradenton, FL

Informatica Developer/Team Member

Responsibilities:

• Designed and developed ETL strategy for new mappings.
• Analyzed and checked feasibility of new requirements.
• Reviewed Business Requirement Documents (BRD) for accuracy and completeness of business requirements.
• Developed PL/SQL and UNIX scripts for scheduling sessions in Informatica.
• Migrated mappings, sessions and workflows across different environments - Development to testing.
• Created test data and configured testing of the Informatica code using the Debugger option to identify issues related to any particular set of data.
• Created Informatica mappings to populate the data into dimensions and fact tables.
• Developed Connected and Unconnected Lookup transformations to lookup the data from source and target tables.
• Provided reliable, timely support of integration, performance and user acceptance testing (UAT) processes.
• Worked along with the DBA to resolve performance and tuning issues.
• Utilized the Explain Plan, Hints, Analyze commands, Statistics and Indexes for better performance of SQL queries.
• Documented the best practices to be followed in resolving data load and memory related issues in Informatica.
• Monitored ETL jobs running in Production environment and fixed bugs and documented the same to avoid similar future occurrences.
• Developed and documented mappings/transformations, audit procedures and Informatica sessions and workflows developed.
• Coordinated with my team members to identify and resolve problems based on Informatica and other database related issues.
• Created test scripts, performed System Integration testing, Regression testing and reviewed test results.

Environment: Informatica PowerCenter 8.6, BOXI 11.5, PL/SQL developer, Oracle 10g/9i, UNIX,Oracle, Autosys.