SUMMARY

• Over 8 years of IT experience as specialist in performing Business Analysis, Data warehouse Design, Development, Testing, Deployment, and Maintenance for various applications.
• Extensive experience in ETL design, development and maintenance using SQL, PL/SQL, Informatica Power Center 9.x/8.x/7.x on UNIX platforms.
• Expertise in Data Warehousing, Data Migration, Data Integration using Business Intelligence (BI) tools such as Informatica Power Center, Power Exchange CDC, B2B Data Transformation, Informatica Data Quality,
• Worked wif various source/target systems such as Relational Sources, Flat files, XML, Mainframe COBOL and VSAM files, CSV files, SAP and Web Services.
• Extensive knowledge of various Performance Tuning Techniques on SQL, Informatica Mappings, Sessions, and Data Base Tuning.
• Expertise on integration mappings including dynamic cache lookup, shared, and persistent cache for mappings of SCD Type 1, 2 &3.
• Strong skills in Data Analysis, Requirement Analysis and Data Mapping for ETL processes
• Expertise in defining and documenting ETL Design &Process Flow, Job Execution Sequence, Job Scheduling and Alerting Mechanisms using command line utilities.
• Extensive experience in implementing Error Handling, Auditing and Reconciliation and Balancing Mechanisms in ETL process.
• Knowledge of E - R modeling, and Dimensional modeling (Star/SnowflakeSchema).
• Strong Expertise in Database Design, development of SQL Scripts, Stored Procedures, Functions, Packages, Triggers using Oracle PL/SQL, T-SQL, Teradata SQL, DB2 SQL PL, etc.
• Experience in writing ETL supporting UNIX Shell Scripting
• Committed individual wif 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, Linux& UNIX.

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

Data Modeling: Erwin, E-R Studio, UML.

Databases: Oracle 11g, SQL Server 2005/2008, Teradata, DB2, Sybase, Netezza

Languages: SQL, PL/SQL, T-SQL, UNIX Shell Scripting

Other Tools: HP Quality Center, Tivoli, Tidal, Autosys, IC Env, Control-M.

PROFESSIONAL EXPERIENCE

Confidential, Durham, NC

Informatica /PL/SQL Developer

Responsibilities:

• Documented User Requirements, translated business requirements into technical requirements.
• Designed High level data flow diagrams which depicts the overall process
• Developed complex PL/SQL functions 8 major calculations
• Responsible for some of the key data model design decisions and database implementation strategies.
• Writing customized SQL as part of ETL source systems on Oracle DB
• Designed Cursors using complex recursive queries to make historical calculations
• Tuned performance of PL/SQL function, saved 50% execution time.
• Designed and developed complex mappings by using Lookup, Expression, Update, Sequence generator, Aggregator, Router, Stored Procedure, etc., transformations to implement complex logics while coding a mapping.
• Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from Oracle, SQL server, DB2 and Flat files and loaded into Oracle.
• Trouble shooting of PL/SQL and UNIX shell scripts, Tuned SQL statements; Partitioning/Indexing.
• Identified slow running ETL jobs and reduced the run time drastically by applying performance tuning techniques.
• Used Variables and Parameters in the mappings to pass the values between mappings and sessions as part of some complex requirements
• Performance tuned existing ETL processes in Informatica

Environment: Informatica Power Center 9.5, Oracle 11g, SQL Developer, Unix

Confidential, Northbrook, IL

Informatica Developer

Responsibilities:

• Coordinating wif the client to gather ETL technical and functional requirements
• Document the requirements in the Confidential standard procedures
• The Documentation includes preparation of high level design document, ETL source to target mapping for each and every column along wif the business logic.
• Design the required Informatica mappings and assign to team members for development
• Developed some of the complex mappings out of the planned mappings
• Defined standards required for entire development process, especially for Informatica mappings.
• Design and define the required target DB objects, this involves more analysis on existing data warehouse and the downstream applications.
• Tune the mapping implemented by team members to improving performance in load times.
• Design the final workflows and sessions to meet the integration requirements
• Developed UNIX shell scripts to automate ETL workflows execution.
• Prepare unit test cases to cover the all the business, technical and functional scenarios.
• Involved in peer review process of mappings developed by other team members.

Environment: Informatica Power Center 9.6, Oracle 11g, TOAD, Tivoli, UNIX &Windows 7.

Informatica Developer

• Documented User Requirements, translated business requirements into technical requirements.
• Developed complex mappings for slowly Changing Dimensions Type II using Informatica designer.
• Involved in data modeling and designed the entities in snowflake Schema model,
• Responsible for some of the key data model design decisions and database implementation strategies.
• Writing customized SQL as part of ETL source systems on Oracle, DB2
• Designed and developed complex mappings by using Lookup, Expression, Update, Sequence generator, Aggregator, Router, Stored Procedure, etc., transformations to implement complex logics while coding a mapping.
• Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from Oracle, SQL server,DB2 and Flat files and loaded into Oracle.
• Used Metadata Manager to manage the Metadata associated wif the ETL processes.
• Troubleshooted PL/SQL and UNIX shell scripts, Tuned SQL statements; Partitioning/Indexing.
• Used error handling mapplets to capture error data into PMERR tables for handling nulls, implemented error remediation process.
• Identified slow running ETL jobs and reduced the run time drastically by applying performance tuning techniques.
• Used Variables and Parameters in the mappings to pass the values between mappings and sessions as part of some complex requirements
• Performance tuned existing ETL processes in Informatica

Confidential, Madison, WI

Informatica Developer

Responsibilities:

• Functional & technical requirement analysis.
• Preparing Integrated requirement document.
• Preparing Integrated design document.
• Evaluating construction done from offshore.
• Design & technical issue resolving.
• Involving wif ETL team to improve the performance of existing Informatica jobs.
• Preparing unix shell scripts
• Constructing mappings.
• Designing test procedure.

Environment: Informatica Power Center 9.5, Power Exchange CDC, Oracle 11g, PL/SQL, SAP, TOAD, Oracle ERwin, Quality Center, Shell Scripts, Informatica scheduler

Confidential, McLean, VA

Informatica ETL Developer

Responsibilities:

• Interacted wif Business Analysts to understand business and functional requirements.
• Involved in dimensional modeling (Star Schema) of the Data warehouse and used Erwin 3.5 to design the data model.
• Participated in the Design Meetings, and prepared technical and mapping documentation.
• Extensively involved in migration process of data from different source systems such as flat files, relational, and XML sources to ODS, Data marts and Data warehouse.
• Used Type 1 and Type 2 SCD mappings using Informatica changed data capture (CDC).
• Used shortcuts to reuse objects wifout creating multiple objects in the repository and inherit changes made to the source automatically.
• Involved in performance reviews of Informatica Mappings, Tasks, Sessions, SQL and Scripts to optimize Data-Load performance.
• Read from SAP source using Power Exchange and also loaded data into SAP targets.
• Worked on IDQ tool to identify data duplication, and understand the quality of data. Used IDE tool for profiling the data prior to Data migration.
• Worked wif testers and participated in Unit, Integration, system, and performance testing of ETL applications.
• Used Informatica web services - consumer and provider.

Environment: Informatica Power Center 8.6.1, Metadata Manager, Informatica Power Exchange(CDC), IDQ, Oracle 11g, SAP R3, Windows NT/2003, UNIX, Autosys.

Confidential, Des Moines, IA

Informatica Developer

Responsibilities:

• Analyzed the functional specs provided by the data architect and createdTechnical System DesignDocuments and Source to Target mappingdocuments.
• Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database, created Automated scripts, defined storage parameters for the objects in the Database.
• Involved in designing Staging and Data mart environments and built DDL scripts to reverse engineer the logical/physical data model usingErwin.
• DesignedAudit tablefor ETL anddeveloped Error Handling Processes for Bureau Submission.
• Created various UNIX Shell Scripts for scheduling and automated execution of workflows.
• Managed Change Control Implementation and coordinating daily, monthly releases and reruns.
• Responsible for Code Migration, Code Review, Test Plans, Test Scenarios, Test Cases as part ofUnit/Integrations testing, UAT testing.

Environment: Informatica Power Center 8.1/8.6, Oracle PL/SQL,TOAD, SQL SERVER 2005/2008, XML, UNIX, Windows XP.

Confidential, Tulsa, OK

Informatica Developer

Responsibilities:

• Involved in Dimensional Modeling (Star Schema) of the Data Warehouse and used Erwin 3.5 to design the physical model
• Migrated data from different source systems such as Flat Files, Relational, and XML sources to ODS, Data Marts,
• Used Type 1 and Type 2 SCD mappings to update Slowly Changing Dimension tables using Power Exchange Change Data Capture (CDC).
• Using Informatica Power Exchange for Siebel to extract and integrate customer relationship management (CRM) data stored in Siebel.
• Used Shell Scripts to schedule PMCMD to interact wif Informatica Server from command mode.
• Designed and developed UNIX scripts for creating, dropping tables which are used for scheduling the jobs.
• Worked wif testers and participated in Unit, Integration, Regression and Performance testing of ETL applications.

Environment: Informatica Power Center 8.6.1, Informatica Power Exchange (CDC), Oracle 11g, PL/SQL, TOAD, Autosys, DB2.

Confidential

Informatica ETL Developer

Responsibilities:

• Involved and Designed the System Development Life Cycle, me.e. such as conducting the preliminary
• Investigation and technical specs.
• Involved in creation of tables, writing stored procedures, Triggers, PL/SQL Libraries.
• Created facts and dimensions according to the business requirements.
• Performed Normalization and Logical Database Design Unit Testing of the modules.
• Developed user-friendly forms for easy data entry.
• Created UNIX shell scripts to invoke the SQL scripts datwere run daily.

Environment: Oracle Database 8i, SQL, PL/SQL, Sun Solaris V5.8, Windows 2000, Toad, Test Director.