SUMMARY:

• Over 7+ years of professional IT experience in Analysis, Design, Development, Testing and Implementation of various Database and Data warehouse Software Applications
• Hands on experience in Full Life Cycle Development of Data warehouse design Process.
• Experience in all aspects of project development life cycle in Data Warehousing.
• Experience working in Agile Methodology.
• Experience in integration of various data sources wif Multiple Relational Databases like Oracle, SQL Server, MS Access, DB2 and flat files using Informatica.
• Developed Complex mappings from varied transformation logic like Unconnected /Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more.
• Extensively worked wif Stored Procedures, Triggers, Cursors, Indexes, Functions and Packages.
• Expertise in PL/SQL development and SQL Query tuning for better performance.
• Expertise in development of stored procedures and functions to develop business rules.
• Extensive experience wif Data Extraction, Transformation, and Loading (ETL) from disparate Data sources like Multiple Relational Databases. Worked on integrating data from flat files, CSV files, and XML files into a common reporting and analytical Data Model.
• Proficient in warehouse designs based on Ralph Kimball and William Inmon methodologies.
• Performance Tuning at various levels such as Source, Target, Mapping, Session, and System.
• Implemented complex business rules in Informatica by creating re - usable transformations, robust mappings/mapplets.
• Worked on UNIX-shell Scripting for Pre-Session, Post-Sessions tasks and also automated teh scripts using a scheduling tool.
• Experience in using Workflows, Worklets and Mapplets.
• Used constraint based loading to load teh targets
• Experienced wif coordinating cross-functional teams, project management and presenting technical ideas to diverse groups.
• Excellent Technical and communication skills.
• Experience in coordinating wif onsite and offshore teams.
• Extensive Business Knowledge in Healthcare, Retail, Finance, CRM and HR Services.
• Strong in Analyzing Business spec and Developed Test Plans, Test Scripts and Test Cases and Execute them.
• Significant exposure to automation test tools like QC and QTP.

TECHNICAL SKILLS:

Data Modeling: Dimensional Data Modeling, Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical / Logical Data Modeling, Erwin 7.3

Databases: Oracle 11g/10g/9i, SQL Server, Flat Files, DB2, EXPLAIN PLAN, Stored Procedure, Triggers, Materialized Views.

ETL: Informatica Power Center 9.1/8.6/7.1. PowerExchange, Data Profiling, Data Cleansing, OLAP, OLTP, Autosys

Programming: SQL, PL/SQL, Transact SQL, Shell, Java, XML

Environment: Unix-AIX 5.2/4.3,Solaris 10, Win XP, VMware

OS Tools: Putty, WinSCP

Collaboration Software: Microsoft SharepointApplication Lifecycle Management

Version Control Software: WinCvs

PROFESSIONAL EXPERIENCE:

Confidential, Ann Arbor, MI

ETL Engineer

Responsibilities:

• Work wif Product Management team to identify teh user stories based on teh client requirement.
• Attend scrum meetings/Daily stand up call to discuss and update teh rally wif teh assigned user story status.
• Worked wif fixed width and delimited flat files as major part of teh data is coming from teh flat files
• Performed data manipulations using various Informatica transformations like Expression, Router, Lookup, Aggregator, Filter, Update Strategy, Sequence generator, Stored Procedure, etc.
• Updated SQL overrides in source qualifier according to teh business requirements.
• Created and monitored Batches using UC4 Automation scheduler tool and scheduling them to run at specified time wif required frequency.
• Use internal application - operators console to setup and process teh batch.
• Create Source Definitions, Shortcuts and Labels to properly migrate from Dev to TST to AT/ PROD.
• Published monthly data quality reports in flat files and also using Cognos Report Studio.
• Extensively worked on Performance Bottlenecks to improve teh performance of teh sessions and workflows.
• Prepared and published SAD documentation of teh project.

Environment: Informatica Power Center 8.6, Oracle 10g, Flat files, Oracle SQL Developer, UC4, Visio, PL/SQL, SQL, UNIX, Unix Sell Scripting, Cognos 10, Windows XP

Confidential, Fort Worth, TX

ETL Informatica Developer

Responsibilities:

• Work wif Business User and Analyst to identify teh source systems based on teh business requirement.
• Co-ordinate wif Data Architects / DBAs to create appropriate table structure in Dimensional Model.
• Develop Informatica Mappings to extract data from various sources such as MS Access, MS Excel, Oracle Database and Flat files tan apply transformation rules and load into Oracle tables.
• Create Source Definitions, Shortcuts and Labels to properly migrate from Dev to UAT to PROD.
• Used key transformations such as Lookup, Joiner, Source Qualifier, Update Strategy, and Aggregator to effectively provide teh correct data and improve overall performance.
• Worked wif DBAs to improve table performance.

Environment: Informatica Power Center 9.1, Oracle 11g, Oracle SQL Developer, MS Excel, Flat Files, MS ACCESS, PRIMAVERA, M-II, SUCCESS, PACES, Windows XP

Confidential, Dallas, TX

Informatica Developer

Responsibilities:

• Performed data manipulations using various Informatica transformations like Joiner, Rank, Router, Expression, Lookup, Aggregator, Filter, Update strategy and Sequence generator etc.
• Extensively used Dynamic Lookup transformation and Update Strategy transformation to update slowly changing dimensions.
• Extensively utilized teh Debugger utility to test teh mappings.
• Extensively worked on Performance Bottlenecks to improve teh performance of teh sessions and workflows.
• Used workflow manager for creating, validating, testing and running teh Sequential and Concurrent batches and sessions and scheduling them to run at specified time wif required frequency.
• Created and used different tasks like Decision, Event Wait, Event Raise, Timer and E-mail etc.
• Used Unix Scripting and Scheduled PMCMD to interact wif Informatica Server from command mode.
• Created database Triggers, Stored Procedures, Exceptions and used Cursors to perform calculations when retrieving data from teh database.
• Defined Mapping parameters and variables and Session parameters according to teh requirements and performance related issues.

Environment: Informatica Power Center 8.6, Oracle 10g/11g, Flat files, Oracle SQL Developer, Informatica Scheduler, Mercury, Java, Visio, PL/SQL, SQL, UNIX (AIX), Linux, Unix Sell Scripting, Windows XP

Confidential, Bloomington, IL

ETL Informatica Developer

Responsibilities:

• Worked wif business analysts to identify appropriate sources for data sources for data warehouse and to document business needs for decision support systems.
• Performed data manipulations using various Informatica transformations like Joiner,
• Rank, Router, Expression, Lookup, Aggregator, Filter, Update Strategy, Sequence generator, etc.
• Extensively used Data profiler to analyze teh source data.
• Worked wif teh ETL architect to perform teh load balance test and stress test.
• Worked wif marketing people to understand teh requirements in a closer way.
• Worked wif fixed width and delimited flat files as major part of teh data is coming from teh flat files.
• Worked wif teh data architects to understand teh conceptional, logical and physical models of teh mart.
• Extensively utilized teh Debugger utility to test teh mappings.
• Written SQL overrides in source qualifier according to teh business requirements.
• Extensively involved in Database tuning and Database performance.

Environment: Informatica Power Center 8.1, Oracle10g, TOAD, PL/SQL, SQL*Loader, DB2, MS Access, ERwin, UNIX, Windows XP

Confidential, Cincinnati OH

Informatica Developer

Responsibilities:

• Understand teh business needs and implement teh same into a functional database design using Erwin.
• Data Quality Analysis to determine cleansing requirements.
• Documented data conversion, integration, load and verification specifications.
• Developed complex mappings using corresponding Source, Targets and Transformations, which were optimized for maximum performance.
• Created mappings using various transformations like update strategy, lookup, stored procedure, router, filter, sequence generator, joiner, aggregate, and expression transformation.
• Created reusable transformations and Mapplets in teh designer using transformation developer and Mapplets designer tools.
• Created different parameter files and started sessions using these parameter files using pmcmd command. Session parameters, mapping parameters, and variables are changed at run time.
• Modified teh PL/SQL stored procedures to meet teh changing standards.
• Generated completion messages and status reports using Informatica Server Manager.
• Created and monitored Batches and sessions using Informatica Server Manager.
• Worked in teh performance tuning of teh programs, ETL procedures and processes.
• Developed shell scripts to automate teh update processes.

Environment: Informatica Power Center 7.1, TOAD, Flat Files, Oracle 10g, SQL, PL/SQL, UNIX, Windows XP

Confidential, Denver, CO

Oracle Developer/Production Support

Responsibilities:

• Requirement gathering and analysis.
• Participate in Data Model design
• Create design specifications including source to target mappings for Mainframe/Operational Source to Stage, Stage to ODS and from ODS to Data warehouse tables.
• ETL development in Informatica, Code Migration from different Repositories and Data Conversion.
• Integration of source data from multiple systems and building data warehouse
• Daily monitoring & support of load to teh ECS Data Warehouse

Environment: Informatica Power Center 7.1, Oracle 9.2.0, Toad, AIX UNIX, VISIO, Crystal Reports, DB2, Windows XP

Confidential

Oracle Programmer

Responsibilities:

• Designed and developed data tables to store employee payroll information.
• Interacted wif end users to prepare system requirements.
• Identify teh data and activities that need to be maintained.
• Designed and developed all teh tables, views for teh system in Oracle.
• Created indexes, sequences, constraints.
• Developed Application programs using Oracle PL/SQL Packages, Procedures, Functions and Database Triggers.
• Worked wif analysts, users, and other IT technical professionals to understand requirements.
• Supported technical teams involved wif ORACLE issues and operations.
• Involved in Implementation and production Support of teh system.
• Responsible for unit testing and documenting teh test results.

Environment: Oracle 9i, Visual Basic, SQL, PL/SQL, MS Access, MS Office Tools, Windows 2000.