SUMMARY:

• Over 7 years of experience in Information Technology Industry with wide range of exposure to various Business Solutions.
• 5 years of working experience with Informatica PowerCenter 6.X/7.x/8.X,9X. Advanced knowledge and excellent concepts in development and design of ETL methodology for supporting data transformations and processing ETL solutions.
• Strong technical exposure with good degree of competence in business domains likes. Financial, Telecommunications, Healthcare, Pharmaceutical.
• Advanced knowledge in ETL, Data warehousing with OLAP technology, ETL Tools.
• Experienced in integration of various data sources like SQL Server, Oracle, DB2 and MS Access into staging area.
• Well versed with schemas design for Dimension Models like Star Schemas and Snowflake Schemas.
• Designed and developed complex mappings, from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more.
• Expertise in programming using PL/SQL, C, Perl and Shell Scripts. Strengths include creation of scripts for collection of statistics, reorganization of tables and indexes, and creation of indexes for enhancing performance for data access.
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Extraction, Transformation and Loading (ETL) and SQL Server and ORACLE.
• Thorough knowledge of the Data Mart Development Life Cycle. Performed all dimensions of development including Extraction, Transformation, and Loading (ETL) data from various sources into Data Warehouses and Data Marts using PowerCenter (Repository Manager, Designer, Server Manager, Workflow Manager, and Workflow Monitor).
• Experience in troubleshooting by tuning mappings, identify and resolve performance bottlenecks in various levels like source, target, mappings, and session.
• Extensive database experience using Oracle 11g,10g/9i/8i/7.x, DB2, MS SQL Server 2008,2005, MySQL, MS - Access, SQL, PL/SQL, SQL*Plus, SQL*Loader.
• Extensive experience of Application Study, Systems Analysis, Design, Development, Testing, Implementation, Maintenance, on the Client Server & Web based Environment.
• Knowledge in PL/SQL, Stored Procedures, Packages, Database Triggers.
• Excellent communication and interpersonal skills. Demonstrated ability to quickly grasp new concepts, both technical and business related and utilize them as needed.

TECHNICAL SKILLS:

Data Warehousing: Informatica Power Center 6.X/7.X/8.X/9.X (Source Analyzer, DWH Designer, Mapping Designer, Mapplets, Transformations, Workflow Monitor, Workflow Manager), Designer, ETL.

Data Modeling: Star-Schema Modeling, Snowflakes Modeling, FACT and dimension tables.

Databases & GUI: Oracle 10g,9i/8.x/7.x, Microsoft SQL Server 7.0/2000/2005, MYSQL, DB2, MS-Access, Visual Basic 6.0

Operating Systems: Windows 98, MS Windows NT/2000/2003, NT 4.0, XP, Red Hat Linux, SCO UNIX.

Languages: C, C++, Java, Shell Scripting, PL/ SQL, T-SQL, SQL * Plus, Visual Basic 6.0.

Web Skills: Active Server Pages (ASP 3.0), VB Script, Java Script, Macromedia Flash 5.0, DHTML and HTML 4.0.

Tools & Utilities: SQL* Plus, Erwin 4, SQL Navigator, Toad, SQL tools, MS SQL Server DTS, FileZilla, WinSCP, Putty.

Other Skills: Distributed Databases and Software Engineering concepts.

PROFESSIONAL EXPERIENCE:

Confidential, Tampa, FL

ETL (Informatica) Developer

Responsibilities:

• Interacted actively with Business Analysts and Data Modelers on Mapping documents and Design process for various Sources and Targets.
• Extracted data from Relational Databases (Oracle) AND loaded it into CLMEXT (Oracle).
• Designed and developed source to stage mappings/sessions/workflows.
• Designed and developed stage to ODS mappings/sessions/workflows.
• Designed and developed ODS to data mart mappings/sessions/workflows.
• Extensively worked with heterogeneous sources from various channels like Oracle,, SQL Server and Flat Files.
• Extensively worked on Informatica tools like source analyzer, warehouse designer, mapping designer, workflow manager, and workflow monitor and repository manager.
• Created mappings using various Transformations such as Source qualifier, Aggregator, Expression, Router, Filter, Look up, Joiner, Sequence Generator, and Update
• Debugged all expression and data validation problems in the mappings with debugger.
• Extensively worked on performance tuning of ETL mappings and sessions.
• Used TOAD to run SQL queries and to validate the data.
• Documented all mappings, crested effective test cases by performing unit testing and Integration testing to ensure the successful execution of data loading process.
• Analyzed session log files if the session failed and resolved the errors.
• Provided technical assistance by responding to inquiries regarding errors or questions with programs/interface.
• Tested the data and data integrity among various sources and targets.
• Associated with production support team in various performances related issues.

Environment: Informatica Power Center 8.6, Oracle 10g,Toad 10, SQL/PLSQL, Microsoft SQL Server 2005, MS Access, TOAD, SQL Plus, PL/SQL, UNIX Shell Scripting.

Confidential, ST Petersburg, FL

ETL (Informatica) Developer

Responsibilities:

• Worked with heterogeneous sources including relational sources and flat files.
• Work with Data Modeler and Data Architect to understand the Architecture of Data warehouse and the mapping Documents.
• Design mappings based upon the complex business logic provided by data modeler, which includes Dimensions and Fact Tables.
• Designed complex mapping logic to implement SCD1 and SCD2 dimensions.
• Interacting with the Front end users to present the proof of concept and to gather the deliverables of the team.
• Doing research work to resolve production issues and data discard during workflow runs.
• Extract the data from relational source Oracle, flat files and perform mappings based on company requirements and load into Oracle tables.
• Used lookup transformation (Static as well as Dynamic), aggregator transformations, Update Strategy, Filter and Router Transformations.
• Extensively used Informatica functions LTRIM, RTRIM, IIF, DECODE, ISNULL, TO DATE, DATE COMPARE in Transformations.
• Also used Used-defined Function, which declared once globally and used in various mappings.
• Working extensively on Informatica Designer, workflow manager to create, sessions, workflows and monitor the results and validate them according to the requirement.
• Extensively involved in monitoring the jobs in order to detect and fix unknown bugs and track performance.
• Used Informatica Workflow to create, schedule, monitor and send the messages in case of process failures.
• Involved in Performance Tuning of sources, targets, mappings, sessions and data loads by increasing data cache size, sequence buffer length and target based commit interval.
• Tested the target data against the source system tables by writing the SQL queries and documented the results in the excel sheet.
• Create Mapping that Generate Parameter file and load log.
• Migrate mappings and workflows from development to QA, QA to UAT and from UAT to production.
• Unit tested Informatica Objects to check the errors and made appropriate changes in the objects to generate the required results.
• Prepared ETL low level and high level design documents.
• Documenting the ETL mapping strategies and transformations involved in the extraction, transformation and loading process
• Interact with various business users of VCMG in order to understand concept and Business Logic.

Environment: Informatica Power Center 8.6, Oracle 10g, Linux, SharePoint, Windows XP, TOAD.

Confidential, Irving, TX

ETL (Informatica) Developer

Responsibilities:

• Analysis, involved in acquiring Requirements from Business Requirement Document (BRD), function/technical specification, development, deploying and testing by Business Analysts, UAT, TQA and Developers.
• Converted the business requirements into technical specifications for ETL process by populating the fact and dimension tables of data warehouse.
• Created and executed SQL scripts in oracle to test the data flow from OLTP systems to data warehouse.
• Designed & assisted Informatica ETL developer to create new Aggregate.
• Created Informatica mappings for initial load and daily updates.
• Developed several mappings (Source Qualifier, Lookup, Filter, Joiner, Aggregate, Sequence Generator, Expression, Lookup, Router, Normalizer, and Update Strategy) to load data from multiple sources to data warehouse.
• Created sessions, workflows and database connections using Informatica Workflow Manager.
• Worked with pre and post session SQL commands to drop and recreate the indexes on data warehouse using source qualifier transformation of Informatica Power center.
• Involved in troubleshooting the load failure cases, including database problems.
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
• Created proactive agents iBots and interactive Dashboards to alert the Marketing team about business changes.
• Managed day-to-day Rpd, Siebel Delivers, Scheduler & iBots.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Handled Full load and refresh load via staging tables in the ETL Layer.
• Involved in Design and Data Modeling using Star schema.
• Setup & Configure Data Warehouse Administration Console (DAC).
• Configured environments for full ETL and incremental data loads from OLTP onto OLAP data sources using DAC and Informatica routines.
• Configured Informatica connections source DB connection and target DB connection in DAC.
• Configured new customized mappings and work flows in DAC for new customized subject area.
• Configured DAC to run nightly data loads on daily basis.

Environment: Informatica 8.1, Siebel 7.7 Analytics, DAC (Data warehouse Administration Console), Oracle 10g, UNIX, Windows XP, TOAD.

Confidential, Pleasanton, CA

ETL (Informatica) Developer

Responsibilities:

• Created mappings based upon the complex logic provided by front end team, which extracts the data from Clarity (Teradata) tables and load them into data mart.
• Designed complex mapping logic to implement Type2 and late arriving dimensions.
• Prepared ETL low level and high level design documents for Revenue Cycle project.
• Interacting with the Front end users to present the proof of concept and to gather the deliverables of the team.
• Did research work to resolve production issues and data discard during workflow runs.
• Extract the data from relational source (Teradata) and perform mappings based on company requirements and load into Oracle tables. Used lookup transformation, aggregator transformations, Update Strategy, Union, Joiner, Filter and Router Transformations.
• Extensively used Informatica functions LTRIM, RTRIM, IIF, DECODE, ISNULL, TO DATE, DATE COMPARE in Transformations.
• Working extensively on Informatica Designer, workflow manager to create, sessions, workflows and monitor the results and validate them according to the requirement.
• Tested the target data against the source system tables by writing the SQL queries and documented the results in the excel sheet.
• Migrate the mappings and workflows from development to QA, QA to UAT and from UAT to production.
• Worked on Shell scripts to update the parameters for Jobs scheduled using Tivoli. Modified shell scripts to dynamically change the parameter variables used in mappings, start the ETL process, check for the success of the session and notify the status through email.
• Unit tested informatica Objects to check the errors and made appropriate changes in the objects to generate the required results.
• Worked with tools like TOAD, SQl Assistant, Rochade and Tivoli.
• Interactions with various business users / Source contacts, DBA’s and system administrators for production issues.
• Created reports based on complex business user requirements using Business Objects XI/R2.
• Documenting the mapping strategies and transformations involved in the extraction, transformation and loading process

Environment: Informatica Power Center 8.1, Tivoli, Sun Solaris-Unix, Oracle 10g, Teradata V2R5, Win 2000, TOAD, Sql Assistant 7.2

Confidential, Santa Cruz, CA

ETL (Informatica) Developer

Responsibilities:

• Interacted with the business users to present the proof of concept and to gather the deliverables of the team.
• Collected user requirements to generate reports in Business Objects.
• Did research work to resolve production issues and data discard during workflow runs.
• Extracted data from relational source (Oracle), perform mappings based on company requirements and load into Oracle tables. Used unconnected lookup transformation, aggregator transformations, Update Strategy, Filter and Router Transformations.
• Extensively used Informatica functions LTRIM, RTRIM, IIF, DECODE, ISNULL, TO DATE, DATE COMPARE in Transformations.
• Worked extensively on Informatica repository manager, Designer, workflow manager to create, sessions, workflows and monitor the results and validate them according to the requirement.
• Tested the target data against the source system tables by writing the SQL queries and documented the results in the excel sheet.
• Migrated maps and workflows from development to testing, testing to QA and from QA to production.
• Worked on Shell scripts to schedule batches on Cron Jobs. Modified shell scripts to dynamically change the parameter variables used in mappings, start the ETL process, check for the success of the session and notify the status through email
• Used Debugger to check the errors in the mapping and made appropriate changes in the mappings to generate the required results.
• Worked with tools like TOAD and SQL tools to write queries and generate the results.
• Interactions with various business users / Source contacts, DBA’s and system administrators for production issues.
• Interact with Business Objects developers to find out the data issues while generating the reports from the data marts build by ETL process.
• Documenting the mapping strategies and transformations involved in the extraction, transformation and loading process
• Working with ETL lead to prepare the documentation for the whole Extraction Transformation and Loading process for EPM (Enterprise Performance Management)

Environment: Informatica Power Center 7.1, Sun Solaris-Unix, Oracle 9i, Win 2000, TOAD, Business Objects 6.5

Confidential, NY.

ETL (Informatica) Developer

Responsibilities:

• Interacted with Technical team and Business users to perform analysis of business.
• Created Source to Target and Data Migration documents.
• Involved in creating the Physical & Logical design using MS Visio.
• Involved in the creation of users, groups, and security access control, etc using Repository Manager.
• Designed Sources to Targets mappings from primarily Excel/Flat files/Xml to Oracle using Informatica PowerCenter.
• Cleansed data using First Logic like Parsing unfielded lines of data and recognizing the discrete elements contained within diverse structures.
• Various kinds of transformations were used to implement simple and complex business logic. Transformations used are: Lookups, Router, Stored Procedure, Expressions, Source qualifier, Aggregators, Filters, Sequence Generator, Joiner, Update Strategy, etc.
• Implemented Business Logic using PL/SQL Stored Procedures, Functions, Cursors, and other Packages.
• Created and Configured Worklets and Sessions to transport the data to target warehouse Oracle tables using Workflow Manager.
• Created various tasks like Event wait, Event Raise, E-mail and command etc.
• Automized Worklets and Session schedule using PMCMD and UNIX Shell scripts.
• Wrote pre-session shell scripts to check session model (enable/ disable) before running/scheduling batches.
• Interacted with metadata to trouble shoot session related issues as well as global performance issues.
• Involved in the migration of DB2 to Oracle Databases.
• Troubleshoot problems by checking Sessions and Error Logs. Also used Debugger for complex problem troubleshooting.
• Generated Unit Test Plans and related documents. Conducted Unit Testing as per UTS.
• Involved in generating the reports using Business Objects.
• Responsible for on-call support during the month-end OLAP reporting of financials

Environment: Informatica PowerCenter 6.2.2, Business Objects 5.1, Oracle8i, Unix shell(Korn) scripting 5, Perl, XML,Windows NT, Sun Solaris, HP UX, SQL*LOADER, MS Visio.

Confidential, Alpharetta, GA

ETL (Informatica) Developer

Responsibilities:

• Performed data analysis of the source data coming from point of sales systems (POS) and legacy systems.
• Developed mappings using Informatica 6.1 designer to extract data from the source databases and flat files into oracle staging area.
• Developed transformation logic to cleanse the source data of inconsistencies during the source to stage loading.
• Implemented the business rules and logic by using Expression, Look up, Sequence Generator, Aggregator, Joiner, Router and Update Strategy transformations.
• Created session tasks, worklets and workflows to execute the mappings.
• Involved in the migration of the project from development to production.
• Involved in monitoring the workflows and in optimizing the load times.
• Extensively used Informatica debugger to validate mappings and to gain troubleshooting information about data and error conditions.
• Performed Performance tuning to ensure optimal session performance.
• Documenting the entire process. The documents included the mapping document, unit testing document and system testing document among others.

Environment: Informatica PowerCenter 6.1, Oracle 8i, PL/SQL, MS Access, UNIX, Windows XP, Flat files.

Confidential

Database Programmer

Responsibilities:

• As an Oracle implementation team member, worked on writing custom forms and custom tuning the reports using hints
• Worked as a technical support for a team that involved technical & quality reviews of program codes and PL/SQL blocks for optimization and maintaining standards & guidelines
• Developed Database Triggers in order to enforce complicated business logic and integrity constraints, and to enhance data security at database level
• Developed Custom forms to view edit the data in custom interface tables and event handling tables using template forms
• Completed database architecture including developing stored procedures and functions in order to create shortcuts to frequently repeated tasks
• Promoted the new code to production through unit and system testing.

Environment: Windows NT Client/Server, Oracle 8i, Developer 2000 (Rel. 2), Forms 4.5, Reports2.5, SQL*Plus, SQL, PL/SQL

Confidential

Database Programmer

Responsibilities:

• Involved from the design to the testing stage and implementation with coding of modules like Pharmacy & Sales module.
• Designing various Reports for the above said module.

Environment: Visual Basic 6.0, Oracle 8i, PS/SQL & Windows NT