SUMMARY

• Above 7 years of experience in IT in analysis, design, development of software applications, expertise in Data warehousing solutions using Informatica Power Center, Power Mart and generating OLAP reports using Business Objects.
• 8 years of experience in ETL mechanisms using Informatica PowerMart & PowerCenter 9.1/8.x/7.x/6x
• 8 years of experience in RDBMS database systems using ORACLE 9i/10g/11g, SQL Server, DB2 in client/server environment.
• Extensive Experience on Oracle database, analyzing business needs of clients, developing effective and efficient solutions and ensuring client deliverables with in committed timelines.
• Expertise in maintaining data quality, data organization, metadata and data profiling.
• Experience in Data Analysis, User Requirement Gathering, User Requirement Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis.
• Extensive experience with development, testing, debugging, implementation, documentation and production support.
• Excellent knowledge and experience in data warehouse development life cycle, dimensional modeling, repository management, implementation of STAR, Snowflake schemas and slowly changing dimensions.
• Experience in performance tuning of sources, transformations, targets, mappings, worklets, workflows, sessions and batches.
• Proficient in using Informatica workflow manager, workflow monitor, server manager, PMCMD (Informatica command line utility) to create, schedule and control workflows, tasks, and sessions.
• Experience in using the Informatica command line utility pmcmd to schedule and control sessions and batches.
• Having strong hands on experience in extraction of the data from various source systems ranging from Mainframeslike DB2, Flat Files, VSAM files, etc. to RDBMS like Oracle, SQL Server etc.
• Proficient in using Informatica Server Manager to create and schedule sessions and batches.
• Experience in PL/SQL Programming (Stored Procedures, Functions and Triggers).
• Experience in UNIX shell scripting, automation of ETL processes using Cron tab.
• Expertise in using Erwin, Designer 2000, Toad, SQL *Loader and PVCS.
• Well experienced in designing and developing master/detail, cross tab, drilldown, chart, adhoc and complex reports using BI tools like Business Intelligence.
• Excellent communication, client interaction and problem solving skills.
• Expert in Dimensional Data Modeling, using Data Modeling, Star - Join Snowflake Schema Modeling, FACT & Dimensions Tables, Logical & Physical Data Modeling usingERWINand Oracle Designer.
• Proficient in generating reports usingBusiness Objects XI R2 functionalities such as Queries, Master/Detail and Formula, Slice and Dice, Drilling, Cross Tab and Charts.
• Solid Expertise inOracle Stored Procedures, Triggers, Index, Table Partitions and experienced in Loading data likeFlatFiles, XML Files, Oracle, DB2, SQL Serverinto Data Warehouse/Data Marts using Informatica.
• Expertise in RDBMS, database Normalization and Denormalizationconcepts and principles.
• Strong experience in Creating Database Objects such asTables, Views, Functions, Stored Procedures, Indexes, Triggers, Cursors in Oracle.
• Created tables and views based on the layout sent by Clients.
• Created mapping documents andwork flows and data dictionaries.
• Good knowledge of Data Warehouse concepts and principles - Star Schema, Snowflake, SCD, Surrogate Keys, Normalization/ De-normalization.
• Very well conversant withOracle 9i/10g/11gandSQL Server 2005/2008, Analytical Functions, Database Design, Query Optimization and Performance tuning.
• Experience with IMPORT/EXPORT, Data-Pump, Sql-Loaderand built-in packages in Oracle.
• Worked extensively in Development of large Projects with complete END to END participation in all areas ofSoftware Development Life Cycle and maintain documentation.
• Quick adaptability to new technologies and zeal to improve technical skills.
• Good analytical, programming, problem solving and troubleshooting skills.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 9.1/8.6/8.5/8.1/7.1 (Workflow Manager, Workflow Monitor, Repository manager and Informatica Server).

Databases: Oracle 8.x/9i/10g/11g, DB2, MS SQL Server 2000, Sybase, Oracle Express.

Database Utilities: SQL Plus, Oracle DBA Studio, SQL Loader, ODBC, Toad, Erwin, PVCS, Designer 2000 and Discoverer 2000 and MSVisio.

Languages and Packages: SQL, PL/SQL, Shell Scripting (Csh, Ksh, Bourne), Cobol

Operating Systems: Unix (Sun-Solaris, HP-UX, AIX), Windows 95/98/NT/2000/XP

Testing Tools: Mercury Test Director

Hardware: IBM 3090, IBM ES-9000, Z OS/1.8 IBM Compatibles

Scheduling Tools: Control-M, Autosys

PROFESSIONAL EXPERIENCE

Confidential, Folsom, CA

Sr. Informatica Developer

Responsibilities:

• Performed data analysis and gathered columns metadata of source systems for understanding requirement feasibility analysis.
• Involved in completesoftware development life cycle (SDLC)including requirements gathering, analysis, design, development, testing, implementationanddeployment.
• Developed technical design documents (HLD and LLD)based on the functional requirements.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica PowerCenter.
• Creating and maintainingsource-target mapping documentsforETL developmentteam.
• Providing requirement specifications and guide theETL teamfor development of theETL jobsthrough InformaticaETL tool.
• Develop Mappings and Workflows to generate staging files.
• Developed various transformations like Source Qualifier, Sorter transformation, Joiner transformation, Update Strategy, Lookup transformation, Expressions and Sequence Generator for loading the data into target table.
• Created multiple Mapplets, Workflows, Tasks, database connections using Workflow Manager.
• Created sessions and batches to move data at specific intervals & on demand using Server Manager.
• Responsibilities include creating the sessions and scheduling the sessions.
• Recovering the failed Sessions and Batches.
• Extracted the data from Oracle, DB2, CSV and Flat files.
• Implemented performance tuning techniques by identifying and resolving the bottlenecks in source, target, transformations, mappings and sessions to improve performance.
• Worked on optimizing and tuning theOracleviews andSQL’sto improve the performance of batch and response time of data for users.
• Provided support during thesystem test, Product IntegrationTesting andUAT.
• Provided quick productionfixesand proactively involved in fixing production support issues.
• Development oftest casesandtesting.
• Coordinate with Configuration management team in code deployments.

Environment: Informatica Power Center 9.1, Unix, Oracle 11g, SQL Server 2005, COBOL, JCL, Flat Files, TOAD, Autosys, SQL Assistant 12.0, Business Objects, Korn Shells, MS Visio, Remedy, Data Mover.

Confidential, Louisville, KY

Sr. ETL/ Informatica Developer

Responsibilities:

• Developed ETL programs using Informatica to implement the business requirements.
• Communicated with business customers to discuss the issues and requirements.
• Imported various Application Sources, created Targets and Transformations using Informatica Power Center 9.1 Designer (Source analyzer, Warehouse developer, Transformation developer, Mapplet designer, and Mapping designer).
• 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.
• Production Support has been done to resolve the ongoing issues and troubleshoot the problems.
• Performance tuning was done at the functional level and map level. Used relational SQL wherever possible to minimize the data transfer over the network.
• 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.
• 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 at 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.
• Designed and developed Informatica Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables. Used transformations like Joiner, Expression, Connected and Unconnected lookups, Filter, Aggregator, Rank, Update, Router and Sequence generator.
• Developed and scheduled Workflows using task developer, worklet designer and workflow designer in Workflow manager and monitored the results in Workflow monitor.
• Did performance tuning at source, transformation, target, and workflow levels.
• Used PMCMD, and UNIX shell scripts for workflow automation.
• Involved in creating and management of global and local repositories and assigning permissions using Repository Manager. Also migrated repositories between development, testing and production systems.
• Wrote PL/SQL stored procedures using Toad.
• Used Informatica Power Analyzer and Informatica Analytics for developing Dashboards, Alerts, Reports, Indicators and adhoc Query Reporting.
• Used PVCS for version control and Cron for Job scheduling.
• Applied Velocity methodology throughout the development life cycle of application.

Environment: Informatica Power Center 9.1, I, ORACLE 9i, Oracle Apps 11.0/10.7, DB2 UDB, HP-UX, Windows NT/2000, TOAD 6.3.11, PVCS 6.7.10, Erwin.

Confidential, St. Luis, MO

Informatica Developer

Responsibilities:

• Involved in design, development and maintenance of database for Data warehouse project.
• Involved in Business Users Meetings to understand their requirements.
• Designed, Developed and Supported Extraction, Transformation and Load Process (ETL) for data migration with Informatica 7.X.
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Created complex mappings which involved Slowly Changing Dimensions, implementation of Business Logic and capturing the deleted records in the source systems.
• Worked extensively with the connected lookup Transformations using dynamic cache.
• Worked with complex mappings having an average of 15 transformations.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once
• Monitored Workflows and Sessions using Workflow Monitor.
• Performed Unit testing, Integration testing and System testing of Informatica mappings
• Coded PL/SQL scripts.
• Coded Unix Scripts to capture data from different relational systems to flat files to use them as source file for ETL process
• As a Data Warehousing team member, Involved in designing, developing and documenting of the ETL (Extract, Transformation and Load) strategy to populate the banking data from various source systems feeds using Informatica, PL/SQL and Unix Shell scripts.
• Involved in Data Extraction, Staging, Transformation and Loading and worked with Oracle Application Integration
• Creating Informatica mappings for populating the data into dimension tables and fact tables from ODS tables.
• Worked on Informatica Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformations.
• Created Informatica Mappings with PL/SQL procedures/functions to build business rules to load data using transformations like Source Qualifier, Aggregator, Expression, Joiner, Connected and Unconnected lookups, Filters and Sequence, External Procedure, Router and update strategy.
• Created sessions and batches. Used parameter files to pass variable values.
• Generated Reports using Business Objects.
• Created Dimension objects keeping in view of the end-user requirement. Created User Prompts, Conditions and Filters to improve the report generation.
• Used Hierarchies for providing drill down options for the end-user.
• Created Master Detail and Cross Tab Reports.

Environment: Informatica Power Center 9.x, Oracle 11g, UNIX TOAD 7.1, SQL, PL/SQL, SQL Server 2000, Oracle 9i, DB2, IBM AIX, Windows 2000/NT.

Confidential

Informatica Developer

Responsibilities:

• Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
• Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.
• Involved in extracting the data from the Flat Files and Relational databases into staging area.
• Mappings, Sessions, Workflows from Development to Test and then to UAT environment.
• Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a star schema.
• Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
• Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Center Designer.
• Imported various heterogeneous files using Informatica Power Center 8.6 Source Analyzer.
• Developed several reusable transformations and mapplets that were used in other mappings.
• Prepared Technical Design documents and Test cases.
• Involved in Unit Testing and Resolution of various Bottlenecks came across.
• Implemented various Performance Tuning techniques.

Environment: Informatica 8.6, Erwin 7.1, Oracle 11g, PL/SQL developer, SQL*PLUS, SQL, SQL*Loader, Toad, ER-Studio, UNIX, CVS, HTML, XML.