SUMMARY

• 10 Years of total IT experience in Programming and maintenance of Software with designing of Data Warehousing Projects using ETL Tools Informatica and Ab Initio.
• Experienced in all phases of the project life cycle including Requirement Analysis, Design, Coding and testing.
• Working as an Onsite Coordinator and leading multiple teams at a time in different projects.
• Worked on Teradata, SQL Server, Oracle 9i/8i (PL/SQL) to write procedure for computation and of data and loaded into data warehouse/flat files.
• Expertise in data analysis in different databases.
• Expertise in using Informatica workflow manager, Workflow monitor.
• Worked in Performance Tuning of Informatica Mappings and Sessions.
• Designed complex Mappings and expertise in Performance tuning.
• Well experienced in writing the Unix scripts
• Domain Expertise in Banking, Health Insurance, and Telecommunication.
• Excellent communication and interpersonal skills and has ability to handle multiple tasks.
• Initiative to handle responsibilities independently as well as a proactive member of a team.
• Well experienced in handling the huge team from Offshore

TECHNICAL SKILLS

Data Warehousing Tools: Informatica, Ab Initio, Data stage

Databases: Oracle, Teradata, SQL Server, DB2

Web Technologies: HTML, DHTML

Reporting tools: SSIS, INFOGIX

Data Modeling Tools: Erwin 4.1, MS VisioOperating Systems AIX, HP - UX, Linux, Windows NT/2000/XP, MS-DOS

Utilities: Toad 7.x, SQL*Loader

PROFESSIONAL EXPERIENCE

Confidential

Sr. Technical Consultant

Responsibilities:

• Involved in Requirements gathering, Business Analysis and User meetings, discussing the issues to be resolved and translating user inputs into ETL Design Documents.
• Used to involve data profiling to identify the source issues and give the solutions to fix the data in ETL level.
• Created multiple mapping documents to move the data from source to target based on the business requirements.
• Created multiple UNIX scripts to validate the files/ and automate the process for the BTEQs.
• Prepared Technical Design Documents & Approach review documents based on the Functional/Business requirements and receiving Signoff from the Business Users on the Mapping Documents.
• Extensively worked on Informatica Power Center - Designer, Workflow Manager and Workflow Monitor.
• Used Teradata utilities such as BTEQ, Fast Load, Multi Load, and Fast Export.
• Involved in tuning the queries in BTEQs and in Informatica mappings.
• Followed the coding standards in all the scripts/ BTEQs.
• Created multiple UNIX scripts to execute the Teradata utilities like BTEQ, fast export and loaders.
• Extracted data from multiple sources like Main Frame files, Oracle and DB2 sources and loaded them in to Edward warehouse.
• Extracted the data from EDLR1 as well as EDWARD (EDLR2), transformed it as per the business requirements and loaded to the Flat Files/Temp Tables.
• Extensively interacted with DIS, DBA, LO, PRC, ITT and Release, and Business teams to move code to different phases such as DEV to SIT, UAT, IR (Implementation Readiness) and Production and following up on the Approvals at each stage.
• Involved in creating complex procedures and schedule them using WLM and Informatica
• Involved in the production support to monitor the jobs to make sure they are running correctly in given time. If there are any failures need to co-ordinate with multiple teams to fix that issue.
• Performed extensive testing on the mappings and wrote queries check if the data was loading from one instance to another.
• Extensively worked with WLM to schedule the jobs to run the Informatica workflows
• Documented each stage of the project in SDLC Workbook, by conducting meetings and gaining Approvals.
• Generate the reports using the INFOGIX and publish it to users.
• If any issues with the reports interact with the respective teams to resolve the issues.
• Leading a multiple development teams for different projects at a time.
• Handling the multiple projects at a time.

Environment: Informatica Power Center, Ab Initio, Oracle, Teradata, UNIX, WLM, Ipswich WS FTP Professional 2007, Windows SharePoint 3.0,, Service Center Enterprise v6.2, IBM TIVOLI, Windows XP Professional, SQL Assistant, INFOGIX

Confidential, Thousand Oaks, CA

Sr. ETL Consultant

Responsibilities:

• Used Informatica Power Center to generate the xml files from flat files.
• Worked with X12 0 related XML files.
• Worked with XML Sources / Targets which will interact with SAP systems.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Rank, Joiner, and Stored procedure transformations.
• Created data conversion mappings (nearly 250 mappings) to make the data available all internal applications like CCS, GPS, IMS, and RDS.
• In the Conversion process extract the data from flat files, Excel sheets and Teradata data base and loaded it in to different data bases for different applications.
• Created the tables, views, stored procedures and packages in 9i and 10g data base.
• Interaction with the users/analysts to understand the business of the application, gather requirements and put into technical design.
• Interaction with the DBA s to understand the tables, schemas
• Developed extensive reusability using mapplets, reusable transformations and worklets.
• Involved in the requirements gathering and analysis for implementing the Data Warehouse
• Worked closely with data population developers, multiple business units and a data solutions engineer to identify key information.
• Interpreted logical and physical data models for Business users to determine common data definitions and establish referential integrity of the system.
• Used Informatica as an ETL tool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translating business rules and functionality requirements into ETL procedures.
• Developed and tested all the backend programs, Informatica mappings and update processes Populated the Staging tables with various Sources like Flat files (Fixed Width and Delimited), Relational Tables in Tera data, Oracle.
• Created mappings using various Transformations such as Source qualifier, Aggregator, Expression, lookup, Router, Filter, Rank, Look up, Sequence Generator, and Update Strategy.
• Involved in performance tuning of SQL Queries, Sources, Targets and Informatica Sessions for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Created and used Debugger Sessions to debug sessions and created breakpoints for better analysis of mappings.
• Extensively used Workflow Manager for maintaining Sessions by performing tasks such as monitoring, editing, scheduling, copying, aborting, and deleting.
• Used Informatica Repository Manager to maintain the Metadata, Security, and Reporting.
• Involved in writing project documentation

Environment: Informatica Power Center 8.0/7.1.4, Data Stage, Tera data R5, Oracle10g, SQL Loader, PL/SQL, MS SQL Server 2005, T, MS Access, XML files, DB2, UNIX, Shell Scripting, Auto Sys, Windows NT/2000, TOAD 7.0, SAP connector, Mainframes, Erwin 4.0

Confidential, Wilmington, DE

ETL Consultant

Responsibilities:

• As a Data Warehousing/ETL/Informatica consultant, involved in designing the data mart and entire data warehousing life cycle designing.
• Used Informatica Power Center for extraction, loading and transformation (ETL) of data in the data warehouse.
• Created the repository manager, users, user groups their access profiles.
• Responsible for definition, development and testing of processes/programs necessary to extract data from client's operational databases, Transform and cleanse data, and Load it into data marts.
• Used the Informatica Designer, Source Analyzer, Warehouse Designer and Mapping Designer.
• Developed and documented data Mappings/Transformations, Audit procedures and Informatica sessions.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Rank, Joiner, and Stored procedure transformations.
• Involved in creation of reports using Business Objects.
• Exported the universes to the Repository to making resources available to the users. Created reports for various Portfolios using the Universes as the main Data Providers.
• Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Created and Developed Stored Procedures, Packages and Triggers for Oracle 8i Databases using PL/SQL

Environment: Informatica (PowerCenter7.1.2), Teradata, Oracle 9i/10g, SQL Server 2005, HP UX, SIPERION, Auto Sys.