SUMMARY

• 8 years of professional IT experience in System analysis, design, development, Data Warehouse/Data Mart design, development and implementation of client server applications
• Five years of extensive experience on Informatica Power Center with strong business understanding and knowledge of Financial, Marketing, Consumer and inventory management projects.
• Hands on experience in all aspects of Software Development Life Cycle (SDLC)
• Proficient in transforming data from various sources (flat files, XML, Oracle) to Data warehouse using ETL tools.
• Worked on UNIX and windows platform for ETL testing and different tasks of ETL.
• Involved in designing Database schemas using Erwin.
• Extensively involved in ETL Data warehousing using Informatica Power Center 7.x/8.x, Repository Manager, Server Manager, Workflow Manager, Mapping Designer, Transformation Designer, Mapplet Designer, and Reusable Transformations.
• Extensively worked on transformations such as Source Qualifier, Joiner, Filter, Router, Expression, Lookup, Aggregator, Sorter, Normalizer, Update Strategy, Sequence Generator and Stored Procedure transformations.
• Extensive experience in supporting production jobs, data enhancements and code fixes.
• Worked with Dimensional Data warehouses in Star and Snowflake Schemas
• Expertise in using SQL*LOADER to load Data from external files to Oracle Database.
• Extensive experience in writing PL/SQL programming units like Triggers, Procedures, Functions and packages in Unix and windows environment.
• Strong experience in RDBMS (Oracle and MS Access).
• Experience in Optimizing the Performance of SQL scripts and Oracle database/application tuning.
• Developed Batch Jobs using UNIX Shell scripts (csh, bash, ksh) to automate the process of loading, pushing and pulling data from different servers.
• Excellent verbal and communication skills, has clear understanding of business procedures and ability to work as an individual or as a part of team.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x/8.x/7.x.

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

Data Modeling: Toad, Erwin, MS Visio.

OS: MS DOS, Windows XP/NT/2000, UNIX 5.0.5, Red Hat Linux 8.x

Languages: SQL, PL/SQL, C#, .NET Framework.

Scripting: VBScript, SHELL Scripting.

Querying Tools: SQL plus, TOAD, SQL Navigator, Query Analyzer

Web: HTML, DHTML, XML.

Applications: MS Office 2007/2010

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr.Informatica Developer

Responsibilities:

• Worked withinformaticapower center, DB2, oracle 10g, Teradata, Flat files and other sources to integrate data and also worked in Data warehouse Development life cycle to generate reports.
• Worked with different mappings like getting data from Oracle tables and flat files, getting data from dimension and fact tables in 2 separate data marts and loading to oracle target tables. Also used pre - loaded stored procedures.
• UsedInformaticafeatures to implement Type I, II changes in slowly changing dimension tables and also developed complex mappings to facilitate daily, weekly and monthly loading of data.
• According to transformation logic, we used various transformations like sorter, aggregator, lookup, Expression, filters, Update Strategy, Joiner, Router etc in Mappings.
• Created Metadata manager Service, Reporting Service and Reference Table Manager Service in powercentre Admin Console to effectively use Metadata Manager.
• Configured the Reusable command task for sending the triggers, invoking different scripts and Reusable Email tasks for sending failure mail along with session details and appending logs with it and success mails. Also used Event wait, Event Raise, Scheduler options in the workflows.
• Worked with other teams for bug fixing, documenting QA DOCS (checking list, design document, performance test doc, business Approval doc, and code review doc) and getting approved.
• Developed SQL, PL/SQL, Stored Procedures, and triggers for Implementing Complex Business Rules, Transformations and Loading.
• Tuned various sql queries, mappings, targets and sources to improve the performance.
• Used session and workflow logs for debugging the session. Knowledge in using cognos for report generation.
• Used debugger wizard to remove bottlenecks Confidential source level, transformation level, and target level for the optimum usage of sources, transformations and target loads.
• Configured the workflows for running concurrently, used various types of migration techniques for moving code to Test environment from Development environment.
• Performance tuning on sources, targets mappings and SQL (Optimization) tuning.
• Worked with the QA team to resolve and fix the defects found.

Environment: InformaticaPower Center 9.1, Oracle 11g/10g, SQL Server 2008, Teradata, PL/SQL, DB2, Cognos, Windows XP, UNIX.

Confidential, Bedminster, NJ

ETL Developer

Responsibilities:

• Develop and implement the business logic and the ETL mechanism to populate the dimensional structure. Program ETL tool with business rules to be applied to data from source input to target data repository, automating data extraction/load programs to run on regular schedule.
• Assist in development of EDW architecture including the design, development and implementation of the physical data model
• Extensively worked on building and loading mappings into subject area.
• Scheduled ETL jobs on a daily, weekly, monthly basis using Autosys.
• Develop database objects, stored procedures and packages, views, tables, and triggers as needed
• Develop and assist in implementing system and unit test programs ensuring correct application of transformation logic from source to target.
• Develop and implement automated test scripts to ensure that source system data is accurately represented in the final reporting objects of the Data Warehouse.
• Work with other application developers and computer operations to support test, QA and production reporting environments including daily administration, batch processing, configuration management, environment migration, and tool automation.
• Document all phases of work including gathering requirements, joint relationship diagrams, database diagrams and other program technical specifications using current specified design standards for new or revised solution.

Environment: Informatica PowerCenter 8.6.1, Oracle 11g, Erwin, PL/SQL Developer, SQL, UNIX, TOAD.

Confidential, WA

ETL Informatica Developer

Responsibilities:

• Worked with Business Analyst in requirements gathering, business analysis and project coordination.
• Analyzed the source data coming from different sources like, DB2, Flat files
• Worked with business users and developers to develop the model and documentation for the new projects like marketing and ODS building.
• Responsible for developing complex Informatica mappings using different types of transformations like UNION transformation, Connected and Unconnected LOOKUP transformations, Router, Filter, Aggregator, Expression, SQL, Stored procedure and Update strategy transformations.
• Responsible for creating Workflows and sessions using Informatica workflow manager and monitor the workflow run and statistic properties on Informatica Workflow Monitor.
• Responsible for Defining Mapping parameters and variables and Session parameters according to the requirements and usage of workflow variables for triggering emails.
• Responsible for tuning the Informatica mappings to increase the performance
• Implemented complex ETL logic using SQL overrides in the source Qualifier.
• Performed Unit tests development work and validates results with Business Analyst.
• Developed Unix Scripts for updating the control table parameters based on the environments.
• Used DB2 loader to load data from flat files to DB2 target database and created exception tables to populate the rejected records.
• Created various data marts for analyzing different business units.
• Responsible for providing written status reports to management regarding project status, task, and issues/risks
• Worked on loading MQT’s for web sphere integration to monitor the business daily.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process.
• Worked with Cognos Developer in generating reports for EDW & Data marts.

Environment: Informatica PowerCenter 9.0.1/8.6.1, DB2 (ISAS), Flat files, TOAD, IBM data studio, PL/SQL, SQL, UNIX, Windows XP.

Confidential, VA

ETL Informatica Developer/ Data Analyst

Responsibilities:

• Responsible for working with the Business analysts for gathering functional requirements and analysis.
• Responsible for taking Strategic decisions for Complex Process including analyzing 20 years old financial legacy data.
• Responsible for working with DBA and Data Modellers for project coordination.
• Responsible for Detail design of each interface.
• Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators.
• Responsible for Unit and Regression testing of the Informatica Mappings created according to the business requirements.
• Using of SQL tools like TOAD to run SQL queries to validate the data.
• Responsible for creating Workflows and sessions using Informatica workflow manager and monitor the workflow run and statistic properties on Informatica Workflow Monitor.
• Responsible for Defining Mapping parameters and variables and Session parameters according to the requirements and performance related issues.
• Responsible for using Autosys and workflow Manager Tools to schedule Informatica jobs
• Responsible for tuning the Informatica mappings to increase the performance.
• Responsible to co-ordinate with SIT, UAT, Performance test teams to fix the Informatica Code defects and various performance related issues.

Environment: Informatica PowerCenter 8.6.1/8.1.1, Oracle 10g/11g, DB2, Flat files, XML, TOAD 9.0, PL/SQL, SQL, UNIX, Windows XP.

Confidential

ETL Developer

Responsibilities:

• Involved in the requirement definition and analysis in support of Data Warehousing efforts.
• Interpreted logical and physical data models for Business users to determine data definitions and establish referential integrity of the system.
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translates business rules and functionality requirements into ETL procedures.
• Involved in the implementation of this application, which involved the Extraction, Transformation, and Loading of IMS Xponent data into an Oracle database.
• Extensively worked on Drug Distribution Data (DDD), which is used to track sales activity for every major distribution channel, including hospitals, clinics, mail service, major retail food stores and chains, mass merchandisers and independent pharmacies.
• Confidential ETL stage, worked in multiple source data extraction and data transition from existing production system to test environment.
• Developed and tested all the backend programs, Informatica mappings and update processes.
• Created and Monitored Batches and Sessions using Informatica Power Center Server.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes.
• Responsible for loading from various sources like Oracle, SQL Server and flat files and loaded it into Teradata target.
• Developed Interfaces using UNIX Shell Script to automate the bulk load & update Processes.
• Implemented complex ETL logic using SQL overrides in the source Qualifier.
• Designed and developed Business Intelligence application using Business Objects.
• Used Designer Module to create Universes, Classes, Objects and Supervisor module to create Repository, Users, and User Groups.
• Developed different types of reports like Trending, Drill Down, Cross Tab, Charts, Master/Detail and Slice and Dice using Business Objects.

Environment: Informatica Power Center 8.1.1/ 7.2, Oracle 9i (9.2.0.1), COBOL, SQL, PL/SQL, Erwin, TOAD, UNIX.

Confidential, Galveston, TX

Informatica Developer/ Consultant

Responsibilities:

• Performed Requirements Analysis, Process Design, Data Design, Development, Testing and Implementation of Data warehouse load processes and Data transformation processes.
• Extensively worked on Informatica Power Center - Designer, Workflow Manager and Workflow Monitor.
• Created Technical Specification documents using MSVisio and maintained Technical specification documents throughout development lifecycle.
• Extensively used ETL processes to load data from various source systems such as Oracle, Sybase, Flat Files and XML into the target Oracle database by applying business logic on transformation mapping for inserting and updating records when loaded.
• Extensively used the Designer to import source and target definitions into the repository and to build mappings.
• Extensively used Informatica Workflow Manager and Workflow Monitor to develop, manage and monitor workflows and sessions
• Extensively used Expression, Filter, Joiner, Lookup, Router, Aggregator, Sorter and Update Strategy transformations. Used debugger to test the mapping and fixed the bugs.
• Simplified the data flow by using a Router transformation to check multiple conditions Confidential the same time.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes.
• Created Sessions, Workflows and scheduled and monitored the workflows and Tasks using Workflow Manager and Workflow Monitor.
• Performed Unit test document work and validated results with Business Analyst.

Environment: Informatica Power Center 7.1, MS Visio, Oracle 9i, MS SQL Server, Sybase, SQL, PL/SQL, TSQL, Flat Files, XML, UNIX and Erwin.

Confidential

Oracle Developer

Responsibilities:

• Understanding the customer’s requirements, analysis, design, development and implementation of system gather and define business requirements, improve business processes.
• Designed and developed PL/SQL functions, stored procedures, cursors, triggers and packages.
• Involved in designing the ER diagrams to create a normalized database
• Created tables, views and stored Procedures
• Developed front-end screens using HTML and JavaScript to provide user-friendly interface
• Developed client side validation programs using Java Script to check the input
• Provided End User Training and Support

Environment: Oracle 9i, SQL*Plus, HTML/DHTML, PL/SQL, TOAD, Windows XP