SUMMARY

• 7 years of combined IT experience and technical proficiency in Data Warehousing space with hands on expertise in comprehensive business analysis/data modeling, database architecture design, data integration ETL processes and report building that governs complex schema builds for corporate reporting following SDLC
• Experience in Informatica Power Center to implement data marts which involve creating, debugging and executing mappings, sessions, tasks, and workflows and testing SQL queries.
• Experience in Informatica administration to implement and work on infrastructure support, maintaining standards, communicating to business, Monitoring.
• Proficient in performance tuning of Informatica Mappings, Transformations, and Sessions; experienced optimizing query performance.
• Used complex Informatica transformation like Normalizer, Transaction control, Update Strategy.
• Worked on different transformations like Router, Filter, Expression, Union, Joiner, Lookup
• Experience in Loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD and Informatica.
• Expert in using Informatica Power Center with Oracle database.
• Experience in working and writing the scripts in PL/SQL
• Experience in integration of various data sources like Oracle, DB2, SQL Server, Flat Files, XML, and Mainframe into Warehouse.
• Has knowledge on concepts like IDQ, B2B Data exchange, and MDM. Has good experience in performing data quality.
• Well versed in Data modeling concepts incorporating dimensional modeling (star and snowflake schema), logical and physical data modeling.
• Identified and fixed bottlenecks, and tuned complex Informatica mappings for better performance.
• Experience in building a very large data warehouse with many complex transformations, with many sources and targets.
• Excellent knowledge on using MS office tools and utilities.
• Excellent written and oral communication, interpersonal skills and presentation skills.

TECHNICAL SKILLS

ETL: Informatica Power Center 9.1,8.6.1,8.1(Repository Manager, Designer, Server manager, Work Flow Monitor, Work Flow Manager),ETL Informatica Administrator.

Databases: Oracle 11g/10g/9i,MS SQL Server 2000/2005/2008 R2,TOAD 8/7.5/6.2, PL/SQL Developer 6.0, SQL Loader, SQL Server Management Studio,Metadata,DB2,Teradata

Programming: Unix Shell Scripting, SQL, PL/SQL

Environment: Microsoft 8/7/XP/NT/2000/98/95, Mac OS

Others: MS Office (MS Access, MS Excel, MS Outlook, MS Power point, MS Work), UNIX/LINUX,IDQ, B2B, MQ Series, ILM, MDM, B2B Data Exchange.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

ETL Developer

Responsibilities:

• Worked as a ETL Developer in extracting data from different sources into DB2 database.
• Performed various cleanups on the existing data to meet the reporting requirements and correct the existing data anomalies
• Worked on various data fix and adhoc data tickets that involves the data issues incorrect data, missing data arises day to day on the existing data to meet their requirement.
• Used transformations like Lookup, Union, Normalizer, Update strategy, Expression, Filter, Aggregator, Joiner, Router, Rank and Sequence generator etc.
• Involved in the migration of data fromuser system to DB2 system through ETL process performing both Initial and incremental loads.
• Created Dynamic Parameter file that is used for the incremental loading of data into the staging tables.
• Performed testing of the mappings and of the data loaded into the target table.
• Used Shell scripting to run the workflows and handle the file system, FTP and ETL controls.
• Involved in the on call production support to resolve the production issues during the implementations.
• Participated in various meetings and discussions about various efficient and effective ways of migrating the data.

Environment: Informatica Power Center 9.1, DB2, UNIX Shell Scripting, Windows7, DBVisualizer

Confidential, Charlotte, NC

ETL Informatica Developer.

Responsibilities:

• Worked as ETL developer on various projects in extracting the Data from different sources into Siebel RMW.
• Used to change passwords, communicate with the business and team support, change in networks are my responsibilities as administrator.
• Improved the data quality by eliminating the redundant data by using Informatica data quality (IDQ).
• Multiload, BTEQ, created & modified databases, performed capacity planning, allocated space, granted rights for all objects within databases, etc
• Maintained multiple SDLC Informatica environments, user creation, group creations across various teams and worked server admin.
• Applied the required patches during Informatica tool upgrade process.
• Prepared and executed the test plan for ETL mappings and data load from transaction to OLAP system.
• Developed type2 & type3 slowly changing dimension mapping in various project requirements.
• Used transformations like Lookup, Union, Normalizer, Update strategy, Expression, Filter, Aggregator, Joiner, Router, Rank and Sequence generator etc, extensively used the debugger and analyzed log files, loader logs to test the data.
• Developed override SQL statements in Source Qualifier and Lookups to suit extraction of desired data from desired region.
• Identified the bottleneck and fine - tuned Source, Targets, Mappings, Transformations and sessions for better performance
• Developed the jobs using Parallel Stages like Join, Merge, Lookup, Filter, Aggregator, Sort, Row Generator, and Column Generator.

Environment: Informatica Power Center 8.6, Informatica Data Quality, Teradata, Oracle 11g, PL/SQL,UNIX shell scripts, TOAD, windows XP.

Confidential, Atlanta, GA

ETL Developer

Responsibilities:

• Developed Mappings and workflows in Informatica to handle complex ETL logic.
• On the other hand had some experience as an Informatica Administrator where my role is to maintain the standards and responsible to manage the development.
• Develop, schedule and monitor B2B ETL processes, ensuring that integration projects are feasible and meet business requirements.
• Used various transformations like Expression, Lookup, Joiner, Filter, Normalizer etc. to perform the process of Extract, Load and Transform effectively in the Mapping Designer.
• Involved in the migration of data fromDB2to Oracle system through ETL process performing both Initial and incremental loads.
• Performed data cleanups as and when necessary to maintain the data quality and integrity in the target tables.
• Worked on solving QC tickets, that involve any data issues like missing data or incorrect data etc. this data is very crucial in the functioning of the applications that use this information to be able to display on the Hotel UI screens.
• For User Interface(UI),used Amazon EC2 web service to make look and feel better anad its very easy to access.
• Involved in the movement of data from the Oracle system to the final warehouse in Teradata, using Informatica and the Multiload loader connections.
• Maintained the Referential Integrity while loading the data into the tables having Parent-Child relationships, that involves complex logic.
• Participated in various meetings and discussions about various efficient and effective ways of migrating the data and meeting the deadlines that are very crucial for the successful completion of the project.
• Performed extensive Unit and Integration testing of the mappings and of the data loaded into the target tables

Environment: Informatica Power Center 8.1,B2B Data Exchange. UNIX, PL/SQL, SQL, Windows XP, Oracle 10g, DB2,Teradata

Confidential, Monterey Park, CA

Informatica Developer

Responsibilities:

• Responsible for requirements gathering, analyzed the functional specs provided by the data architect and created technical specs documents for all the enhancements.
• Worked as the administrator where my role is to communicate between business and various teams involving in support and development.
• Replicated operational tables into staging tables, Transform and load data into enterprise data warehouse tables using Informatica from their legacy systems and load the data into targets by ETL process through scheduling the workflows.
• Involved in design and development complex ETL mappings and stored procedures in an optimized manner.
• Worked with different source systems- Oracle, XML files, flat files.
• Fine-tuned existing Informatica maps for performance optimization.
• Debugged mappings by creating logic that assigns a severity level to each error, and sending the error rows to error table so that they can be corrected and re-loaded into a target system.
• Involved in the Unit testing and System testing.
• Worked on bug fixes on existing Informatica Mappings to produce correct output.
• Developed Informatica SCD type-I, Type-II mappings and tuned them for better performance.
• Design and development of UNIX Shell Scripts to handle pre and post session processes.
• Used reusable transformation objects such as mapplets to avoid duplication of metadata, reducing the development time.
• Created automated scripts to perform data cleansing and data loading.
• Handled some of the data issues in the jobs, during the release of the project to send the correct data to the business users.

Environment: Informatica Power Center 8.1, Oracle 10g, Toad, UNIX Shell Scripting, Flat Files.

Confidential, Chicago, IL

ETL Informatica Developer

Responsibilities:

• Analyzed the data coming from different sources and their relationships.
• Interacted with business community and gathered requirements based on changing needs.
• Analyzed the architecture for Data Warehouse - star schema/snowflake model.
• Developed mapplets and re-usable transformations to prevent redundancy of transformation usage and maintainability.
• Create ETL migration strategy document, Integrate Data stage Metadata to Informatica Metadata and created ETL mappings, sessions, workflows in Informatica.
• Designed Mapping Templates and Developed Mappings using Source Qualifier, Expression, Filter, Look up, Update Strategy, Sorter, Joiner, Normalizer and Router transformations.
• Monitor; troubleshoot batches and sessions for weekly and monthly extracts from various data sources across all platforms to the target database.
• Prepared estimates and tracked each and every task and strictly adhered to the estimated deadlines.
• Responsible for unit testing of mappings developed.
• Provided production support by running the jobs and fixing the bugs.

Environment: Informatica Power Center 7.1, Oracle10g/9i, PL/SQL, UNIX, Win XP, Flat file, Unix Shell Scripting, DB2, TOAD, Microsoft Office, Visio

Confidential

Oracle Developer

Responsibilities:

• Experience in assisting the Application Developers in creatingconceptual database designsthat meet the business and technical objectives.
• Used conceptual models and extended conceptual models with business rules to develop logical data models.
• Designed Oracle Logical Objects including Triggers, Stored Procedures, and Sequencesthat helped in automating various operations in the database.
• Developed complex reports likeMatrix Reports, Tabular Reportsfor the systems using running totals, sub totals, grand totals and daily balance by using lexical parameters.
• DevelopedFront-end formsdepending upon the logic such as Master-detail form and complex forms for the application.
• DevelopedSQL*Loader scriptsto load flat files into source staging database and plan the loads to run concurrently without any manual intervention.
• Fine Tuned SQLfor the maximum efficiency in various schemas across databases usingOracle Hints, Explain plans and Trace sessionsfor Cost based and Rule based Optimization.
• Performedmanual testingon the application and Involved in defects fixing team.
• Created new and modified database procedures, functions, triggersand other database objects by using TOAD tool.

Environment: Oracle 6i, Developer 2000, TOAD, SQL, PL/SQL, SQL Plus, Windows 2000.