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 PowerCenter 9.5.1/9.1/9.0.1/8. x/7.x/6.x.
• Excellent Working Knowledge in Dimensional modeling using multi - dimensional models (Star, Snow Flake schema).
• 2+ years of experience using Business Objects XIR2/6.x/5.x
• Database experience of Oracle 11g/10g/9i/8i/7.x, Teradata V12/V13, SQL Server, PL/SQL, IBM DB2 8.0/7.0.
• 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. Worked with Oracle Stored Procedures and experienced in loading data into Data Warehouse/Data Marts using Informatica, SQL. Extensive Expertise with error handling and Batch processing.
• 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 Training 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.
• Experienced in Shell scripting and PL/SQL procedures.
• Expertise in performing Unit Testing, Integration Testing and Regression Testing.
• Mentors and assists lower level senior developers, business analysts and developers.
• Worked in 24/7 production support of ETL and BI applications for large insurance data warehouses for monitoring, troubleshooting, resolving issues, generating SLA reports. Also worked on administrative tasks of Business Objects XI R2 and Informatica.
• 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 8.x/7.x

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*Plus, Teradata V12/V13, SQL Server, IBM DB2.

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

PROFESSIONAL EXPERIENCE

Confidential, Orlando - FL

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 training and support for production environment.
• Work closely with end users to identify data sources.
• Development of the Informatica Mappings, lookups, 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.
• Performed unit testing at various levels of the ETL and actively involved in team code reviews.
• 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.
• Attending project kickoff meetings, status meetings and weekly team meetings regularly.
• 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.
• Monitoring all the sessions that are scheduled, running completed and failed. Debugging the workflows that failed.
• Work with scheduling team in scheduling the jobs in proper order and mentioning the frequency of job run.
• Running production day deployment and implementation activities.
• Provide Warranty period support for the projects which went live i.e. monitor and maintain the jobs scheduled.

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

Confidential, Plano - TX

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, Control-M, Windows XP and TOAD.

Confidential

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 preparationDeveloped 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 7.1.3, Flat Files, Oracle 9i, SQL, PL/SQL,Unix, Erwin 4.5, Business Objects 6.5/XIR2, Windows XP.

Confidential, Florida

Informatica Developer

Responsibilities:

• Involved in understanding the existing system.
• Parsing high-level design specifications into simple ETL coding and mapping standards Designed Mapping document, which is a guideline to ETL Coding.
• Used Informatica Power Center 7.1.3 to carry out the extraction, transformation and Loading (ETL) of data.
• Used Designer, Workflow Manager and Workflow Monitor.
• Responsible for Peer Testing the codes of other Informatica Developers.
• Responsible for Unit Testing of codes developed by Informatica Developers in other Projects.
• Worked with Oracle SQL Developer at the source end to query the database to provide sample reports to the Business Users.
• Developed several Mappings, Mapplets, Transformations, Sessions and Workflows.
• Exported mappings to create backups of existing mappings in XML format.
• Used SQL overrides in Source Qualifier, Lookup Transformation and Target.
• Used Transformations like Lookup (Connected and Unconnected), Update Strategy, Aggregator, Expression, Filter, Sequence Generator and Stored Procedure Transformations to develop the Mappings.
• Extensively used Slowly Changing Dimension type II to keep history of records.
• Extensively worked on the performance tuning of the mappings as well as the tuning of the sessions. Tuning of SQL queries for better performance.

Environment: Informatica Power Center 7.1.3, Windows XP Platform, Oracle SQL Developer,SQL, PL/SQL, Flat file, Oracle 9i, Microsoft Visio.

Confidential

Informatica Developer

Responsibilities:

• Implemented logical and physical data modeling with STAR schema techniques in Data Mart.
• Worked on Informatica - Source Analyzer, Data warehousing designer, Mapping Designer & Mapplet and Transformations.
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translates business rules and functionality requirements into ETL procedures using Informatica Power Center.
• Responsible for the definition, development and testing of the processes/programs necessary to extract data from the client's operational databases, Transform and cleanse the data, and Load it into the data marts.
• Responsible for the analyzing and comparing complex data from multiple sources (Oracle, flat files).
• Written PL/SQL Procedures and Functions for Procedure Transformations
• Worked on the Performance tuning of the programs, ETL Procedures and processes.
• Worked in debugging using Session Log messages, Server Messages.

Environment: Informatica Power Center 6.1, Business Objects 5.1, AIX UNIX 4.1, Windows2000, MS SQL Server 2000,Oracle 7i, DB2 7.0, Toad, ERWIN 4.1a, UNIX Shell Scripting.