SUMMARY:

• 8+ years of IT experience in Business Intelligence and Data Warehousing applications.
• 7+ years of experience in ETL of data from various sources into Data Warehouses and Data Marts using Informatica Power Center 9.5.1/9.1/9.0.1/8. x/7.x/6.x.
• 2+ years of experience using Business Objects XIR2/6.x/5.x
• Excellent Working Knowledge in Dimensional modeling using multi - dimensional models (Star, Snow Flake schema).
• Experience working with Informatica Power Exchange, Informatica ILM, Informatica DVO, Informatica IDQ, Informatica Analyst, Informatica Metadata Manager, TDM.
• Database experience of Oracle 11g/10g/9i/8i/7.x, Teradata V12/V13, SQL Server, IBM DB2.
• Thorough knowledge in Teradata architecture, extensively worked on BTEQ, MLOAD, FLOAD, SQL Assistant to design and develop dataflow paths for loading transforming and maintaining data warehouse.
• Strong Knowledge in all phases of Software Development Life Cycle (SDLC) on various platforms like UNIX, Windows.
• Experience as Informatica Administrator in 8.x and 9.x and Informatica Production support.
• Expertise in design and development of mappings to handle all types of slowly changing dimensions SCD type 1, type2 and type3.
• Experience in transforming data from various types of sources like flat files, Oracle, Teradata, SQL server and XML documents.
• Extensive experience in Performance tuning of sources, targets, mappings, sessions and SQL queries.
• Extensive Expertise with error handling and Batch processing.
• Experience with Push down optimization, Partitioning for better performance.
• Strong knowledge of Software Development Life Cycle (SDLC) with industry standard methodologies like Waterfall, Agile, and Scrum methodology including Requirement analysis, Design, Development, Testing, Support and Implementation. Provided End User and Support.
• Extensive experience with TOAD, SQL Developer and SQL Navigator, Teradata SQL Assistant, SQL Server Management to test, modify and analyze data, create indexes, and compare data from different schemas.
• Extensive experience in Shell scripting.
• Good experience in creating procedures, functions, triggers and cursors using PL/SQL.
• Expertise in performing Unit Testing, Integration Testing and Regression Testing.
• Mentors and assists developers, business analysts.
• Extensive work experience on Onsite offshore model.
• Excellent communication and interpersonal skills, very good team player and self-starter with ability to work independently and as part of a team, strong effort, time management, good analytical reasoning and high adaptability to new technologies and tools.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.5.1/9.1/9.0.1/8. x/7.x/6.x, Informatica Power Exchange 9.x/8.x/7.x,TDM,ILM,IDQ,DVO,Analyst,metadata manager.

OLAP Tools: Business Objects XIR2,6.x,5.x (Supervisor, Designer, Full Client, Web intelligence), Crystal Reports 7.0/8.0/9.0/10/ XI/XIR2

Languages: SQL, PL/SQL, Unix Scripting, C++, Java, XML, Toad.

Operating Systems: Windows, UNIX, Linux

Databases: Oracle 11g/10g/9i/8i/7.x, SQL*PlusTeradata (BTEQ, Fast load, multi load, TPump, SQL Assistant, Fast Export)SQLServer, IBM DB2.

Data Modeling: Erwin, Star-Schema Modeling, Snowflakes Modeling, FACT & DIMENSION Tables, MS Visio

PROFESSIONAL EXPERIENCE:

Confidential, St. Louis, MO

Data Analyst / Informatica Developer

Responsibilities:

• Assisted Business Analyst with drafting the requirements, implementing design and development of various components of ETL for various applications.
• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user and support for production environment.
• Designed, developed and improved complex ETL structures to extract transform and load data from multiple data sources into data warehouse and other databases based on business requirements using Informatica.
• Installed/configured Informatica Metadata Manager.
• Created Informatica Metadata manager reports.
• Customized Metadata Manager Reports for where used analysis, created reports in multiple formats.
• Created metadata manager data lineage
• Design, build, or enhance Informatica mappings, according to Thrivent standards, in support of requirements provided by the project.
• Responsible for testing, modifying, debugging, documenting and implementation of Informatica mappings.
• Used Informatica Power Exchange for loading/retrieving data from mainframe system.
• Performance tuning of the mappings as well as the tuning of SQL queries for better performance.
• Extensively used Teradata utilities like Fast load, Multiload to load data into target database.
• Did bulk loading of Teradata table using TPump utility.
• Created jobs for Informatica data replication fast clone to get data from oracle and load it into Teradata.
• Involved in Unit and Integration testing (UTC), System testing and User Acceptance Testing (UAT).
• Generated different transformations for loading the data into target like Source Qualifier, Joiner, Update Strategy, Connected Lookup, Unconnected Lookup, Rank, Expression, Router, Filter, Aggregator, XML generator, XML parser and Sequence Generator transformations.
• Built reusable transformations and mapplets to use in multiple mappings.
• Hands on experience using mapping variables, mapping parameters, workflow variables and session parameters.
• Implemented SCD-Type 1/Type 2/Type 3 mappings.
• Handling multiple projects on timely manner.
• Worked on TDM (Test Data Management) project performing masking part.
• Good Knowledge onapplying rules and policies using ILM (Information Life Cycle Management) workbench for Data Masking Transformationand loading into targets.
• Demonstrated experience in effective use and deployment of Informatica's Application ILM products. These include Data Masking and Data Validation Option (DVO)
• Experience loading data to and from Salesforce.
• Attending project kickoff meetings, status meetings and weekly team meetings regularly.
• Working on Onsite offshore model.
• Coordinating with QA team at project testing phase and work on any issues found.
• Involve in all production implementation activities including registering the release and creating CRQ’s.
• Work with scheduling team in scheduling the jobs in proper order and mentioning the frequency of job run.
• Provide Warranty period support for the projects which went live i.e. monitor and maintain the jobs scheduled.
• Involved in production support on call duties on rotation basis for the monitoring of daily and monthly jobs.

Environment: Informatica Power Center 9.5.1/9.1.0, Metadata Manager, Oracle 11g, Teradata 14, Db2 mainframe, Zena scheduling tool, Unix, putty, Windows, Toad, SQL Developer, Informatica Analyst.

Confidential, Houston - TX

ETL, Informatica Consultant

Responsibilities:

• Gathering requirements and creating design documents and mapping documents.
• Design the ETL processes using Informatica tool to load data from sources.
• Design, build, or enhance Informatica mappings, according to ESI DWH standards, in support of requirements provided by the project.
• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user and support for production environment.
• Work closely with end users to identify data sources.
• Development of the Informatica Mappings, reusable components, Sessions, Workflows etc as per the design documents/communication.
• Performance tuning of the mappings as well as the tuning of SQL queries for better performance.
• Extensively utilized MLOAD, FASTLOAD in Informatica to load data to Teradata.
• Experience in creating Teradata SET and MULTISET tables, creating views, Indexes, collecting stats on the tables for improving query performances.
• Involved in Unit and Integration testing (UTC), System testing and User Acceptance Testing (UAT).
• Generated different transformations for loading the data into target like Source Qualifier, Joiner, Update Strategy, Connected Lookup, Unconnected Lookup, Rank, Expression, Router, Filter, Aggregator and Sequence Generator transformations.
• Built reusable transformations and mapplets to use in multiple mappings.
• Hands on experience using mapping variables, mapping parameters, workflow variables and session parameters.
• Implemented SCD-Type 1/Type 2/Type 3 and Fact Tables.
• Experience in CDC techniques in oracle to extract the incremental changes from source systems.
• Good experience in creating procedures, functions, triggers and cursors using PL/SQL.
• Attending project kickoff meetings, status meetings and weekly team meetings regularly.
• Worked on Onsite offshore model.
• Coordinating with QA team at project testing phase and work on any issues found.
• Involve in all production implementation activities including registering the release and creating CRQ’s.
• Running production day deployment and implementation activities.
• Work with scheduling team in scheduling the jobs in proper order and mentioning the frequency of job run.
• Monitoring all the sessions that are scheduled, running completed and failed. Debugging the workflows that failed.
• Provide Warranty period support for the projects which went live i.e. monitor and maintain the jobs scheduled.
• Handled production support for the monitoring of daily and monthly jobs.

Environment: Informatica Power Center 9.5.1/9.0.1/8.6.1, Teradata 13, Oracle 11g, SQL, PL/SQL, Control-M, Cron, Tivoli, Windows and Oracle SQL Developer.

Confidential, Stevens Point - WI

Informatica Developer

Responsibilities:

• Involved in gathering requirements and created design documents and mapping documents.
• Involved in design and development complex ETL mappings.
• Fine-tuned existing Informatica maps for performance optimization
• Used Transformations like Lookup (Connected and Unconnected), Update Strategy, Aggregator, Expression, Filter, Sequence Generator, Stored Procedure Transformations etc. to develop the Mappings.
• Extensively used Slowly Changing Dimension type II to keep history of records.
• Used SQL overrides in Source Qualifier, Lookup Transformation and Target
• Extensively worked on the performance tuning of the mappings as well as the tuning of SQL queries for better performance.
• Used Debugger to test mappings and fix the bugs.
• Used Borland starteam and peregrine SM7 for raising tickets for Informatica issues, migrations, rights and privileges.
• Responsible for monitoring all the sessions that are scheduled, running completed and failed. Involved in debugging the Mappings that failed.
• Informatica component level/folder level migrations of Mappings, Sources, Targets, Maplets, Sessions, worklets and work flows using Informatica power center.
• Perform Informatica Administration tasks like administering Informatica Repository, including creating and managing users,groups, creating and managing folders and Ensured appropriate privileges are assigned to the different users
• Extensively worked on Code Migrations from Development, UAT, and Production
• Ensured that all production and security standards and practices are adhered to and Reporting of all deviations from plan.
• Running production day deployment and implementation activities.
• Worked as Production support member.
• Monitored the scheduled jobs or run the workflows and scripts which need to run daily.
• Taking care of workflows and tasks that are not running or if they are not started at the scheduled times or, some problems occurred at the data loading or any server is down.
• If any issues or job fails, immediately checked the logs and contacted support team if needed.
• Worked on resolving issues if Informatica jobs fail at 24x7 basis.
• Create UNIX shell scripts, rename files and move the files from one directory to another and also to archive the files.
• Scheduled Informatica workflows via a shell script using scheduling tool Control-M.

Environment: Informatica Power Center 9.1.0/8.6.1, Business ObjectsXIR2, Oracle 11g/10g, SQL, PL/SQL, Autosys, Windows XP and TOAD.

Confidential, Buffalo, NY

Informatica and Business Objects Developer

Responsibilities:

• Involved in the design phase of the project.
• I have designed the format for the user input files as well as the format for the Error-Files that will be mailed to the user after the session is executed
• Designed the ETL mappings using Informatica tool to load data from excel files to ORACLE database. An error file is also created which will be mailed to the client side DBA.
• Imported Source/Target Tables from the respective databases and created reusable transformations (Joiner, Routers, Lookups, Rank, Filter, Expression, Update, Aggregator) and created new mappings using Designer module of Informatica
• Written PL/SQL Procedures for Procedure Transformations
• Worked on the Performance tuning of the programs, ETL Procedures and processes.
• Made use of the latest Informatica feature of FLAT FILE LOOKUPS.
• Involved in the Test case preparation Developed Universe (semantic Layer) Using Data Loaded in the Datamart Using Business objects.
• Interacted with the business users to understand their requirements and documented the scope and specifications of module.
• Created queries to extract data from Oracle database for multidimensional analysis using Slice & Dice and Drill up/down functionality.
• Developed around 10 Reports to Depict the Caterer Performance using B.O tool.

Environment: Informatica Power Center 8.1.1 SP2, Flat Files, Oracle 9i, SQL, PL/SQL, UNIX, Erwin 4.5, Business Objects 6.5/XIR2, Windows XP.