SUMMARY

• 8 + years of IT experience in Data warehousing projects, primarily as specialist in performing Analysis, Design, Development, Testing, Implementation, Migration, Deployment, Enhancement and Maintenance ofInformatica, Oracle, DB2/UDB, Sybase and SQL Server environments.
• Extensive knowledge on the SDLC development life cycle. Involved in different phases starting from Requirement Gathering to Production Deployments and warranty Support.
• Expertise in OLTP/OLAP system study, Analysis and developing Database Schemas like star schema and snowflake schema used in relational, dimensional and multidimensional modeling.
• Good Understanding of Ralph Kimball and Bill Inmon methodologies/approach
• Involved in Full Life Cycle Development (Waterfall & Agile) of building a Data Warehouse on Windows and Unix Platforms for Financial, and Health Insurance Industries.
• Extensive experience with Informatica Power Center 9.x,8.x and 7.x hosted on UNIX, Linux and Windows platforms.
• Extensively worked on Data migration, Data cleansing and Data Staging of operational sources using ETL processes and providing data mining features for data warehouses.
• Experience in implementing update strategies, incremental loads and Change Data Capture (CDC)
• Hands on experience in defining Technical Requirements for ETL processes and developing Complex Mappings to load data into enterprise data warehouse and data marts.
• Experienced in handling SCDs (Slowly Changing Dimensions) using Informatica.
• Good understanding of relational database management systems like Oracle, DB2, and SQL Server and extensively worked on Data Integration using Informatica for the Extraction transformation and loading of data from various database source systems.
• Expertise in trouble - shooting production issues by root cause analysis to identify the problem, impact analysis to determine the dependencies and providing the resolution.
• Extensive knowledge of various Performance Tuning Techniques on Sources, Targets, Mappings and Workflows using Partitions/Parallelization and eliminating Cache Intensive Transformations.
• Very strong understanding in data warehousing concepts star and snow flake methodologies, slowly changing dimensions.
• Developing Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules.
• Committed individual with excellent interpersonal, analytical and communication skills
• Ability to work simultaneously on multiple projects, work independently as well as a team member.

TECHNICAL SKILLS

Operating systems: Windows NT/XP,Windows Server 2003,UNIX

ETL Tools: Informatica Power Center 9.1/8.x/7.x.,Power Exchange

Databases: Oracle 11g/10g/9i, SQL Server 2005/2008,DB2,Mainframe

Languages: SQL, PL/SQL, UNIX Shell Scripting, XML.

DB Tools: Toad,SQLTools.

Reporting Tools: Business Objects

Other Tools: Autosys

PROFESSIONAL EXPERIENCE

Confidential - Carlsbad, CA

Sr. Informatica Developer

Responsibilities:

• Developed ETL programs using Informatica to implement the business requirements.
• Communicated with business customers to discuss the issues and requirements.
• Created shell scripts to fine tune the ETL flow of the Informatica workflows.
• Used Informatica file watch events to pole the FTP sites for the external mainframe files.
• Performance tuning was done Confidential the functional level and map level. Used relational SQL wherever possible to minimize the data transfer over the network.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.
• Effectively worked in Informatica version based environment and used deployment groups to migrate the objects.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Effectively worked on Onsite and Offshore work model.
• Pre and post session assignment variables were used to pass the variable values from one session to other.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used Informatica scheduler to schedule jobs.
• Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.
• Performed unit testing Confidential various levels of the ETL and actively involved in team code reviews.
• Identified problems in existing production data and developed one time scripts to correct them.
• Fixed the invalid mappings and troubleshoot the technical problems of the database.

Environment: Informatica Power Center 9.1/8.6.1,Informatica Power Exchange, Oracle 10 g, Crystal Reports 4.0,Autosys, Windows 2003/2008,Flat files, SAP Files

Confidential - Los Angeles, CA

Sr. Informatica Developer

Responsibilities:

• Complete SDLC including analysis, design, development, testing, implementation and maintenance of application software in Enterprise Data Warehouse.
• Extracted data from BCBSNE EDW environment using Informatica ETL tool with predefined transformation rules. Responsible for all ongoing Data Model Design decisions and database implementation Strategies.
• Involved in Data modeling and design of data warehouse in star schema methodology with confirmed and granular dimensions and fact tables.
• Interacted with the end user to gather requirements, plan, build, test, deploy, document and apply change control process.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Implemented Agile Methodology for handling the ever-changing Business Requirements
• Attended Informatica code review meetings and suggested the required changes according to the set naming standards.
• Data is coming from various sources like Oracle, SQL Server, Mainframe etc. which will be loaded in to EDW based on different frequencies as per the requirement
• Used Error Handling Mapplet to capture error data into PMERR tables for handling nulls, analysis and error remediation Process.
• Developed standard and re-usable mappings and mapplets using various transformations like Expression, Lookups, Joiner, Filter, Source Qualifier, Sorter, Update strategy and Sequence generator
• Identified bugs in existing mappings by analyzing the pipeline data flow, evaluating transformations and fixing the bugs so that they conform to the business needs and redesign the existing mappings for improving the performance.
• Optimized the performance of queries with modifications in Confidential -SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.
• Involved in change management, error management, creation of remedy tickets and work order request to implement changes in the existing process.
• Designing and documenting ETL Process flow, job execution sequence, parameter file requirements, and Job scheduling and alerting mechanisms using command line utilities.
• Trouble-shooting production issues by root cause analysis to identify the problem, impact analysis to determine the dependencies and providing the resolution.
• Used PMCMD command to automate the PowerCenter sessions and workflows through Windows

Environment: Informatica Power Center 9.1/8.6.1,Informatica Power Exchange, SQL Server 2005/2008, Quality Center, Crystal Reports 4.0, Mainframe, Tidal, Windows 2003/2008,XML,XML Parser, Flat files, Cobol Files, SSRS

Confidential - Atlanta, GA

Sr Informatica Developer

Responsibilities:

• Complete SDLC including analysis, design, development, testing, implementation and maintenance of application software in Enterprise Data Warehouse.
• Extracted data from BCBSNE EDW environment using Informatica ETL tool with predefined transformation rules. Responsible for all ongoing Data Model Design decisions and database implementation Strategies.
• Involved in Data modeling and design of data warehouse in star schema methodology with confirmed and granular dimensions and fact tables.
• Interacted with the end user to gather requirements, plan, build, test, deploy, document and apply change control process.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Implemented Agile Methodology for handling the ever-changing Business Requirements
• Attended Informatica code review meetings and suggested the required changes according to the set naming standards.
• Data is coming from various sources like Oracle, SQL Server, Mainframe etc. which will be loaded in to EDW based on different frequencies as per the requirement
• Used Error Handling Mapplet to capture error data into PMERR tables for handling nulls, analysis and error remediation Process.
• Developed standard and re-usable mappings and mapplets using various transformations like Expression, Lookups, Joiner, Filter, Source Qualifier, Sorter, Update strategy and Sequence generator
• Identified bugs in existing mappings by analyzing the pipeline data flow, evaluating transformations and fixing the bugs so that they conform to the business needs and redesign the existing mappings for improving the performance.
• Optimized the performance of queries with modifications in Confidential -SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.
• Involved in change management, error management, creation of remedy tickets and work order request to implement changes in the existing process.
• Designing and documenting ETL Process flow, job execution sequence, parameter file requirements, and Job scheduling and alerting mechanisms using command line utilities.
• Trouble-shooting production issues by root cause analysis to identify the problem, impact analysis to determine the dependencies and providing the resolution.
• Used PMCMD command to automate the PowerCenter sessions and workflows through Windows

Environment: Informatica Power Center 9.1/8.6.1,Informatica Power Exchange, SQL Server 2005/2008, Quality Center, Crystal Reports 4.0, Mainframe, Tidal, Windows 2003/2008,XML,XML Parser, Flat files, Cobol Files, SSRS

Confidential, Atlanta, GA

Sr Informatica Developer

Responsibilities:

• Analyze ETL requirement documents.
• Involved in development phase meetings for Business Analysis and reviewed requirement documents.
• Involved in Data model reviews and validated the tables, columns and data types to meet the requirements.
• Involved in Integration Requirements Document (Technical Requirements) reviews and validated the document against the functional requirements document
• Created time and resource estimates for development, testing and implementation activities.
• Performed source system data profiling.
• Used Error handling strategy for trapping errors in a mapping and sending errors to an error table.
• Implemented change detection process to send only incremental data for all the subject areas.
• Involved in dealing with performance issues Confidential various levels such as target, sessions, mappings and sources
• Optimizing/Tuning mappings/sessions, indexing and partitioning for better performance and efficiency.
• Implemented the session partition strategy to improve the workflow performance.
• Designed the parallel and sequential session workflows and scheduled the workflows and Sessions using the Workflow Manager.
• Created mapping documents and design documents
• Acted as a key contributor for in the team to ensure delivery.
• Developing Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules
• Performance tuning of Informatica mappings.
• Defined the testing strategy and supported UAT and Regression testing.
• Interacting with the business for queries, clarifications during UAT.
• Production Implementation of the system.
• Involved in Preparation of Unit Test Plans and testing with the same
• Involved in creation of Reports using OBIEE 10g for various Subject Areas
• Post-Production Activities.
• Performance Tuning, SQL Query Optimization, Partitioning, Parallelism was implemented to improve the through put.
• Extensively used UNIX shell scripts to create the parameter files dynamically.
• Used PMCMD command to automate the PowerCenter sessions and workflows through UNIX
• Supporting production systems for day to day maintenance and incident resolution.
• Developed, implemented and enforced ETL best practices standards.
• Worked closely with OBIEE developer and developed different Dashboards, Subject-Areas, Pages and Reports.

Environment: Informatica Power Center 8.6.1, Oracle 10g, Toad, DB2,AIX64, UNIX, Erwin, Quality Center, MS Visio, Tivoli, OBIEE 10g,Mainframe

Confidential

Sr. Informatica Developer

Responsibilities:

• Tuned queries, stored procedures to enhance the performance of applications.
• Created load scripts using Fast Load and Mload utilities and procedures in SQL Assistant.
• Implemented Aggregate, Filter, Join, Expression, Lookup and Update Strategy transformations. Used debugger to test the mapping and fixed the bugs.
• Developed mappings using Mapping Designer to standardize data as per business requirements.
• Worked extensively on fine tuning SQL overrides for enhancing performance.
• Involve in performance tuning to optimize existing SQL Scripts.
• Developed PL/SQL scripts and stored procedures for database updates and to create the necessary indexes in the target tables.
• Involved in developing stored procedures, triggers for the application.
• Worked extensively with Mapping Designer to join Oracle and tables using Joiner transformation.
• Worked on developing workflows and sessions and monitoring them to ensure data (target file) is properly loaded into the warehouse.
• Used debugger extensively to identify the bottlenecks in the mappings
• Responsible for scheduling reports, error checking, production support, maintenance and testing of ETL procedures using Informatica session logs.
• Ad-hoc reports were used for Business Objects User modules for various Portfolios using the Universes as the main Data Providers
• Extensively involved in making data flowing through mappings consistent and organized.
• Prepared the ETL documentation for data conversions

Environment: InformaticaPowerCenter 7.1.2, Oracle 9i, SQLServer,, PL/SQL, UNIX, Windows NT, Autosys

Confidential

Informatica Developer

Responsibilities:

• Worked with business teams to gather the functional requirements and translated them into ETL technical documents .
• Identified bugs in existing mappings by analyzing the pipeline data flow, evaluating transformations and fixing the bugs so that they conform to the business needs and redesign the existing mappings for improving the performance.
• Used transformations lookup, Normalizer, aggregator, router, filter, expression, input, output, sequence generator and external procedure.
• Build and maintain SQL scripts, indexes and complex queries for data analysis and extraction using Confidential -SQL.
• Optimized the performance of queries with modifications in Confidential -SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.
• Created Mapplets, and reusable transformations to implement the business logic in the pipeline .
• Collected performance data for sessions and performance tuned by adjusting Informatica session parameters.
• Created pre-session and post-session shell scripts and mail-notifications.
• Implemented aggregation logic using expression transformation with in the pipeline to implement the business logic.
• Designed the parallel and sequential session workflows and scheduled the workflows and Sessions using the Workflow Manager.
• Implemented the session partition strategy to improve the workflow performance.
• Implemented Command Task, Control Task, decision task, event raise and event wait tasks within the workflows to stream line the session scheduling.
• Optimizing/Tuning mappings/sessions, indexing and partitioning for better performance and efficiency.
• Developed, implemented and enforced ETL best practices standards using velocity methodology.

Environment: Informatica Power Center 8.6.1/8.1.1 Oracle10g, SQLServer 2005, PL/SQL, SQL Developer

Confidential

Informatica Developer

Responsibilities:

• Creating Folders and manages user and user group access to objects based on LDAP settings.
• Coordinating with Business Teams / Functional Subject Matter Experts (SME) to gather Requirements and transforming them into technical specifications for the ETL
• Designs through which Implement ETL solutions using Informatica Power Center (v 8.1.1/8.6.1/ (9.0 - Started recently)
• Experienced in facilitating deployment of the ETL jobs into the Production environment along with primary production support which involved handling
• Change Requests and Defect Resolution and testing them thoroughly till the Business user’s certification (UAT).
• Worked extensively to propose some changes to the existing ETL architecture to facilitate the balancing of premiums with the Business financials.
• Worked with multiple Databases like Oracle (8i / 9i) and DB2 (v8.1 / v9.5). Designed automated solutions for ETL using Dynamic SQLs.
• Automate the production jobs using UNIX Shell scripting and worked to implement automated ETL solutions which include scheduling of jobs with Informatica PMCMD Commands to remove manual dependencies.
• Optimizing/Tuning mappings/sessions, indexing and partitioning for better performance and efficiency to reduce the data latency to be less than 36 Hours and to make sure that the Business IT SLA’s are met with every incremental loads.
• Proposed new solutions to enhance the existing Error handling mechanisms in architecture.
• Experienced in Data profiling using both Tools based (Informatica Data profiling) and customized techniques and worked on different types of sources - Relational, Flat files etc.
• Regularly provided metrics (effort estimation and tracking on ETL tasks) and Status reports for the senior management.
• Currently handling a team of 5 people and working on all the change requests from business sponsors from gathering the requirements, provide estimates till implementation and UAT.
• Worked with Business Groups to identify, analyze, and document Business Requirements.
• Created Business Facts, Dimensions and defined Logical relation between them Confidential the Business model and mapping layer.
• Created Dashboards & Answers.

Environment: Informatica Power Center 8.6.1/8.1.1 Oracle10g, SQL Server 2005, PL/SQL, SQL Developer

Confidential

Informatica Developer

Responsibilities:

• Developed Mappings & Workflows as per business logic, quality and coding standards prescribed for the module.
• Anticipated and addressed critical issues in a timely and effective manner.
• Used Informatica tool to handle complex Mappings and extensively used the various transformations like Source Qualifier, Aggregator, Lookup, Filter, Expression, Sequence Generator, Normalizer, Union and Sorter etc.
• Built Mapplet, work lets and re-usable transformations.
• Prepared Unit Test Plan (UTP) documents for all the test cases for the developed mappings.
• Performing reviews on peer developed code in later phases.
• Mentoring and assisting team as SME in later phases.
• Interacting with Client Team on weekly calls on progress and deliveries.
• Worked on SQL Assistant for complex queries in build and test.
• Performed Informatica and Database level performance tuning.
• Worked as only and Primary ASKMIG (Ask Migration Team email group) member from offshore which involved migration of Informatica objects across environments (DEV, TEST and UAT). PROD is handled by On-Shore.

Environment: Oracle 7.3, Windows NT, PL/SQL, SQL* Loader, Informatica