PROFESSIONAL SUMMARY:

• 10+ years of experience in developing and maintaining Software applications, of which 6 years of strong experience in designing and implementing Data Mart / Data Warehouse applications using ETL tools INFORMATICA PowerCenter Client 5.1/6.2/7.1.3/8. x/9.x (Designer/WorkFlow Mgr / Repository Mgr.) and PowerMart to transfer the data from legacy systems to common/ different targets and Oracle PL/SQL and Data Modelling using ERWin (3.5/4.1)
• Extensively worked on Informatica PowerCenter Designer Transformations such as Source Qualifier, LookUp, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Sequence generator, Stored Procedure, Sorter Transformation, Lookup Caches(Static/Dynamic), Aggregator, Union, XML Sources/Targets, Rank, etc.
• Parallelization of sessions at the WorkFlow level by creating session level partitions
• Created/Worked extensively with various WorkFlow tasks like Command, Decision, Control, Event Wait & Event Raise, Timer
• Extensively used CDC methods for source data extraction
• Extensively worked on database applications using Oracle, SQL* Plus, PL/SQL, SQL*Loader.
• Strong in Relational Databases (RDBMS), Data Modeling and Design and building of Data Warehouses, Data marts using Star Schema and Snow Flake Schema for faster and effective Querying.
• Extensive experience in developing the front end using Oracle Forms/Reports, Power Builder, ASP and developing the back end applications using Oracle/ MS Access/MS SQL Server.
• Experience in writing Oracle Stored Procedures (PL/SQL) and Triggers.
• Worked on developing reports using Oracle Reports/Power Builder.
• Experience in developing logical and physical models and implementing them in Oracle.
• Excellent skills in retrieving/manipulating data by writing simple/ complex SQL Queries and optimizing SQL and PL/SQL.
• Excellent in problem solving, logical and analytical abilities.
• Excellent Communication and interpersonal skills.

TECHNICAL EXPERTISE:

Data Warehouse Tools: Informatica Power Center 9.1/8.5/7.1.2/6.2/5.1 , Power Mart, Business Objects 5.1.4., Oracle Warehouse Builder(9.x), Cognos impromptu, Cognos Power Play, Impromptu, Oracle Discoverer(10.x),, Oracle Reports

Programming Languages: C, SQL, Java, Power Builder, Oracle Forms (4.5, 6.0), Oracle Reports (2.5,3.0,6.0), SmallTalk

Operating Systems: Win NT, Win 2000/98/95/XP, UNIX, AIX, UX

RDBMS: Oracle 10g/9.x / 8.x / 7.x, SQL Server 7.0, MS Access, Sybase server

Database Tools: Sql*Plus, Sql Loader, Export, Import, ERWin 3.5/4.1,SQL Navigator, Toad, PL/SQL, Visual Explain for DB2

Configuration Tools: PVCS Manager, PVCS Tracker, Microsoft Visual SourceSafe(VSS), Control - M Job Utility, Rational Clear Case, Rational Clear Quest, Microsoft Excel, Informatica Version Control, Unicenter AutoSys Job Scheduler

Others: HTML, JavaScript, VB Script, Active Server Pages Oracle Forms (4.5, 6.0), Oracle Reports (2.5,3.0,6.0), Power Builder (4/5/6), Microsoft Office 2003 Visio, PVCS Version Mgr., Microsoft Visual SourceSafe, PVCS Tracker, Secure FX & Secure CRT, Control-M job utility, Citrix Server MetaFrame, CA AutoSys Job Automation/Scheduling Tool

PROFESSIONAL EXPERIENCE:

Confidential, Culver City, CA

Environment: Datastage, Teradata

Onshore-Offshore Co-Ordinator, Systems Architect

Responsibilities:

• Work on the system level reconciliation framework architecture
• Review the same with peers and the various stake holders
• Work with the offshore to communicate the same.

Confidential, Los Angeles, CA

Environment: Informatica PowerCenter 9.5, Oracle 11x, SQL Server,XML,Files.

Informatica/ETL Developer

Responsibilities:

• Development of informatica mappings/workflows
• Unit testing of the same
• Scheduling the workflows

Confidential, Los Angeles, CA

Environment: Informatica PowerCenter 9.5, Oracle 11x, Oracle SQL

Informatica/ETL Developer

Responsibilities:

• Development of informatica mappings/workflows
• Unit testing of the same
• Scheduling the workflows

Confidential, Irvine, CA

Environment: Informatica PowerCenter 9.1, Oracle 10g, perForce, HP UX (HP UNIX), AutoSys Job Scheduler, Unix Shell Scripting, Agile methodology environment, Scrum

ETL Analyst

Responsibilities:

• Preparation of ETL design docs
• Troubleshoot various stress points in the performance of data flow processes.
• Impact Analysis of new requests
• Determine job scheduling
• Determine Slowly Changing Dimensions load strategy(SCD)
• Creating end2end workflows(Informatica mappings/workflows/Autosys jobs/any SQLs/Unix scripts

Confidential, Charlotte, North Carolina

Environment: Informatica PowerCenter 8.6/9.1, Oracle 10g, Clear Quest, Clear Case, HP UX (HP UNIX), AutoSys Job Scheduler,Unix Shell Scripting

Db/ETL Analyst

Responsibilities:

• Preparation of ETL design docs
• Provide estimates for phases of development work
• Troubleshoot various stress points in the performance of data flow processes.
• Impact Analysis of new requests
• Determine job scheduling
• Determine Slowly Changing Dimensions load strategy(SCD)
• Dealing with DWH & Data Marts

Confidential, Charlotte, North Carolina

Environment: Informatica PowerCenter 8.6, Oracle 9i/10g, Netezza DB, TeradataClearQuest, ClearCase, HP UX (HP UNIX), AutoSys Job SchedulerUnix shell scripting

ETL Lead/ On Site-Off Site development team Coordinator/ETL Developer

Responsibilities:

• Preparation of ETL design docs
• Provide estimates for phases of development work
• Co-ordinate the development work on the onshore-offshore model.
• Troubleshoot various stress points in the performance of data flow processes.
• Interact with the BAs/DAs to get the requirements right
• Impact Analysis of new requests
• Determine job scheduling
• Determine Slowly Changing Dimensions load strategy(SCD)
• Dealing with DWH & Datamarts(SnowFlake schemas)

Confidential, Pittsburgh, PA

Environment: Informatica PowerCenter 8.1, Oracle 9i/10g, PL/SQLPVCS Mgr, HP UX (HP UNIX), Control-M Job Creation & SchedulerUnix shell scripting

ETL/DB Developer /Consultant

Responsibilities:

• As part of the Application(s) development team, was responsible for the ETL development work using Informatica, Oracle PL/SQL, Unix, CTRL-M job creation/scheduling.
• In addition, did some enhancement work to the existing work.
• Using CDC(change data capture) extensively to extract/load data into the target db system.
• Also involved in new development to serve the business needs of the downstream clients.
• Involved in the migration of applications from the existing infrastructure(current server) to the new proposed infrastructure(new environment).
• Creating Unix shell programs to wrap the Oracle SQL scripts & FTPing data files & Validating data files
• Creating Autosys CTRL-M in order to automate/schedule the Informatica and Oracle/Unix work.
• Analyzing the existing Business Requirements and Technical Documentation.
• Creating Technical Design Specifications Documentation
• Interacting with Data Analysts/Business Analysts for the T2T (Table-To-Table) mapping of the business/application flow.
• Time estimations for analysis, preparation of technical design specifications documentation, unit test plan scripts, development.
• Creating Unit Test Plan Scripts as part of the development/testing
• Analyzing the mappings and optimizing them
• Tuning the mappings
• Troubleshooting the mappings and sessions
• Developing mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Joiner, Aggregator, Stored Procedure, Update Strategy, Rank, Normalizer, Router, Lookup, Sequence Generator, Filter, Sorter, Source Qualifier, Union, Mapplets, Expression, Lookup Caches (Static and Dynamic) etc.
• Writing Oracle PL/SQL Stored Programs (Procedures & Functions) to do data transformations and integrate them with Informatica programs and the existing application
• Daily/Monthly Data maintenance activities of the applications..

Confidential, Los Angeles

Environment: Informatica PowerCenter 7.1/8.5, Oracle 9i/10g, PL/SQLPVCS Mgr, HP UX (HP UNIX), Unicenter AutoSys Job SchedulerSybase Db Server, SmallTalk, PowerBuilder v10

ETL Developer /Consultant

Responsibilities:

• Development of Informatica loaders
• Development of Pl/SQL loaders
• Unix scripts for file validations / FTP
• Performance tuning of Informatica
• Performance tuning of PL/SQL
• Preparation of TSDs for the loaders
• Job Scheduling

Confidential, Hartford, CT

Environment: Informatica PowerCenter 7.1, Oracle 9i/10g, PL/SQL, Windows XPPVCS Mgr, HP UX (HP UNIX), Unicenter AutoSys Job Scheduler

ETL Developer /Consultant

Responsibilities:

• Development of Informatica loaders
• Development of Pl/SQL loaders
• Unix scripts for file validations / FTP
• CTRL-M jobs
• Performance tuning of Informatica
• Performance tuning of PL/SQL
• Preparation of TSDs for the loaders
• Job Scheduling

Confidential, Troy, MI

Environment: Informatica PowerCenter 7.1.3, Oracle 9i, DB2, Toad 7.6, Visual Explain for DB2, Microsoft Excel, Rational Clear Case, Rational Clear Quest, Informatica Version Control, UNIX(AIX), Microsoft Windows 2000, Shell Scripting, SSH/SCP

Consultant / ETL Lead

Responsibilities:

• Development of Informatica loaders
• Development of Pl/SQL loaders
• Unix scripts for file validations / FTP
• Performance tuning of Informatica
• Performance tuning of PL/SQL
• Preparation of TSDs for the loaders
• Job Scheduling

Confidential, Troy, MI

Environment: Informatica PowerCenter 6.1/ 7.1.2, Oracle 9i, Toad 7.6, IBM Mainframe, Secure FX, Secure CRT, IBM Host on Demand, Microsoft Excel, PVCS Tracker, PVCS Version ManagerControl - M job utility, Microsoft Windows NT.

Senior ETL Developer /Consultant

Responsibilities:

• Development of Informatica loaders
• Development of Pl/SQL loaders
• Unix scripts for file validations / FTP
• Performance tuning of Informatica
• Performance tuning of PL/SQL
• Preparation of TSDs for the loaders
• Job Scheduling

Confidential, Houston, TX

Environment: Informatica PowerCenter 6.2, Oracle 9i, PL/SQL, Windows XP, Citrix Server, PVCS Mgr, UnixMicrosoft VisioDescription: Hartford Life is a leading provider of insurance and risk management services in the US. Hartford is using a wide variety of system applications in both Mainframe and Client Server environments to serve their Group Benefits Life Insurance.

Senior ETL Developer /Consultant

Responsibilities:

• Development of Informatica loaders
• Development of Pl/SQL loaders
• Unix scripts for file validations / FTP
• Performance tuning of Informatica
• Performance tuning of PL/SQL
• Preparation of TSDs for the loaders
• Job Scheduling

Confidential, San Jose, California

Environment: Informatica PowerCenter 6.2, Oracle 9i, Oracle PL/SQL, Windows NT, Unix(F-Secure SSH Client & F-Secure SSH File Transfer 5.3), Microsoft VSS 6.0

Consultant / Analyst

Responsibilities:

• Development of Informatica loaders
• Development of Pl/SQL loaders
• Unix scripts for file validations / FTP
• Performance tuning of Informatica
• Performance tuning of PL/SQL
• Preparation of TSDs for the loaders
• Job Scheduling

Confidential, Chicago

Environment: Informatica PowerCenter 6.2, Oracle 8i, PL/SQL, Windows NT, Citrix Server, UNIX

Senior Developer

Responsibilities:

• Creating new mappings and updating old mappings according to changes in Business logic.
• Creating and monitoring sessions and batches
• Analyzing the mappings and optimizing them
• Scheduling Jobs and preparing technical documentation
• Tuning the mappings
• Troubleshooting the mappings and sessions
• Created Workflows, Worklets for running sessions.
• Developed mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Joiner, Aggregator, Stored Procedure, Update Strategy, Rank, Normalizer, Router, Lookup, Sequence Generator, Filter, Sorter, Source Qualifier, Mapplets, LookUp Caches (Static and Dynamic), XML Source Qualifier, etc.
• Writing Oracle PL/SQL Stored Programs (Procedures & Functions) to do data transformations and integrate them with Informatica programs and the existing application
• Tuning SQL and Oracle stored programs
• Troubleshooting the stress points of the application (both within Informatica & PL/SQL)

Confidential, Maryland

Environment: Informatica PowerCenter (5.1), PL/SQL, Oracle 8i, Windows NT, Unix, Citrix Client Services

Developer / Analyst

Responsibilities:

• Creating new mappings and updating old mappings according to changes in Business logic.
• Creating and monitoring sessions and batches
• Analyzing the mappings and optimizing them
• Scheduling Jobs and preparing technical documentation
• Tuning the mappings
• Troubleshooting the mappings and sessions
• Developed mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Joiner, Aggregator, Stored Procedure, Update Strategy, Normalizer, Router, Lookup, Sequence Generator, Filter, Source Qualifier, Mapplets, LookUp Caches (Static and Dynamic), XML Source Qualifier, etc.
• Writing Oracle PL/SQL Stored Programs (Procedures & Functions) to do data transformations and integrate them with Informatica programs and the existing application
• Tuning SQL and Oracle stored programs