SUMMARY

• 7+ years experience in the Information Technology industry and over 5 years of experience as Informatica Developer.
• Extensive knowledge of SDLC (Software Development Life - Cycle).
• Extensive Data Warehousing experience using Informatica Power Center 8.6 Designer (Source Analyzer, PowerCenter Designer, Mapping designer, Mapplet Designer, Transformation Developer), Repository Manager, Workflow Manager, Workflow Monitor, Admin console & Metadata Manager.
• Extensive experience on Informatica Power CenterTransformationssuch asSource Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, SorterandSequence Generator.
• In-depth knowledge of PL/SQL with the experience in construction of Triggers, Functions, user defined data type, Records, Arrays and Exception Handling using TOAD, SQL*PLUS and PL/SQL.
• Excellent knowledge and experience in creating source to target mappings using various cleansing rules.
• Proficient in the integration of various data sources with multiple relational databases like Oracle10g/11g, MS SQL Server, DB2 files and Flat Files into the staging area of ODS, Data Warehouse or Data Mart.
• Willing to learn and adapt to new challenges.
• Proficient in analyzing the Business Requirements, System Requirement Specifications (SRS) and Functional Requirement specification (FRS) has earned the confidence of the clients in the past.
• Have worked as team in a tight deadline driven scenarios.
• Excellent analytical & problem-solving skill. Good verbal, written, and presentation skill.
• Excellent team worker. Self-motivated and quick learner. Adaptable to a fast growing and changing environment.

TECHNICAL SKILLS

Data Warehousing/ETL: Informatica Power Center 8.6.1 & Power Mart 8.6.1 using Designer (Source Analyzer, PowerCenter designer, Mapping designer, Mapplet Designer, Transformation Developer), Repository Manager, Workflow Manager & Workflow Monitor, SQL*PLUS, SQL*Loader

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2005/2000,MS Access 7.0/97/2000, Sybase 12.x/11.x,Teradata

Reporting Tools: Developer 2000 (Forms 4.5/5.0, Reports 2.5/3.0), MS Access Reports

Programming: SQL, PL/SQL, SQL*Plus 8.1.5, C,C++,Unix Shell Scripting, Java

Environment: HP-UX 10.20/9.0, IBM AIX 4.2/4.3, MS DOS 6.22, Win 3.x/95/98, Win NT, Win 2000, Win XP.

PROFESSIONAL EXPERIENCE

Confidential, NYC,New York

ETL Developer

Responsibilities:

• Played a lead role in the design,development and testing of the ISO BureauCodes database that involved the following:
• Development of stored procedures for integrating the Datawarehouse and Datamart data for Bureau Reports.
• Used Informatica Powercentre 8.6 for development of the ETL process for automating the task on daily and monthly basis.
• Development of various interfaces and running them in the production environment on monthly and quarterly basis.
• Unit testing of the stored procs before migration to the Test and Production environment.
• Detailed Analysis of the error reports to ensure data quality of the same before data migration.
• Coordination with the business team in requirements gathering, business analysis and designing of the data warehouse.
• Worked with various active transformations in Informatica PowerCenter like Filter Transformation, Aggregator Transformation, Joiner Transformation, Rank Transformation, Router Transformation, Sorter Transformation, Source Qualifier, and Update Strategy Transformation.
• Performance tuning of sources, targets, mappings and SQL queries in the transformations.

Environment: Informatica Power Center 8.6.1, Windows XP, SQL,, SQL Server200 8, Cognos

Confidential, Arlington, VA

Informatica Developer

Responsibilities:

• Worked with Business analysts and the DBA for requirements gathering, business analysis and designing of the data warehouse.
• Developed complex mappings for GMSTG & GMMRT schemas.
• Worked with Informatica Workflow Managerfor creating and running workflows and tasks.
• Widely used Informatica client tools -- Source Analyzer, PowerCenter Designer, Mapping designer, Transformation Developer and Informatica Workflow Manager. Used look up, router, filter, joiner, stored procedure, source qualifier, aggregator and update strategy transformations extensively.
• Used Informatica Designer to extract data from Oracle and non-Oracle data sources, transform and load data into the target database in the process of developing the data warehouse.
• Created Complex mappings using Unconnected, Lookup, and Aggregate and Router transformations for populating target table in efficient manner.
• Generated Reusable Transformations, Mapplets and used them extensively in many mappings.
• Used Informatica Workflow Monitor extensively to monitor the workflows.
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.
• Optimized SQL queries for better performance.
• Created events and tasks in the work flows using workflow manager.
• Worked on Data cleansing, data conversion & process implementation.
• Developed Informatica mappings and also tuned them for better performance with PL/SQL Procedures/Functions to build business rules to load data.

Environment: Informatica Power Center 8.6.1, Windows XP, SQL, PL/SQL, SQL Developer, UNIX

Confidential, San Francisco, CA

Informatica Developer

Responsibilities:

• Gathered and documented the user requirements and report specifications on regular basis to maintain the integrity of the development.
• Involved in design and development of Business Requirements in liaison to business users and Technical teams by gathering requirement specification documents and identifying data sources and targets.
• Worked closely with data modellers on Erwin tool for dimensional modelling (Star schema).
• Extracted data from various heterogeneous sources like Oracle, SQL Server, Sybase, MS Access and Flat files.
• Extensively used Various Data Cleansing and Data Conversion Functions in various Transformations.
• Developed mappings using various transformations such as Expression,Joiner,Filter,Router,Lookup and Update Strategy.
• Extensively worked with Joiner functions like normal join, full outer join, master outer join and detail outer join in the Joiner transformation.
• Worked with Session logs and Work flow logs for Error handling and troubleshooting in Dev environment.
• Used SQL tools like TOAD to run SQL queries and validate the data.
• Involved in development of Mappings to update the Records on both daily basis and Monthly basis. Used Lookup Transformation to access data from tables, which are not the source for mapping and also used Unconnected Lookup to improve performance.
• Extensively worked on error handling and problem fixing in Informatica.
• Used PMCMD command to start, stop and ping server from UNIX and created UNIX Shell scripts to automate the activities.
• Unit testing and System Testing of Informatica mappings and Workflows.

Environment: Informatica Power Center 8.6.1, Windows XP, SQL, PL/SQL, SQL Developer

Confidential, Detroit, MI

Informatica Developer

Responsibilities:

• Extensively worked with Informatica — Manager, Designer and Director to load data from flat files and Oracle to target databases.
• Used Informatica Designer to extract data from Oracle and non-Oracle data sources, cleanse, transform and load data into the target database in the process of developing the data warehouse
• Used Informatica Designer and Manager for importing metadata into repository, creating new workflows categories, exporting and importing the jobs between the production and the development servers.
• Created mapplets to use in multiple workflows.
• Writing & maintaining Java core modules alongside Oracle development tools and implementation of the modules into production.
• Leading team in CCVOX development and deployment at client sites.
• Analyzed user requirements, participated in business requirement walkthroughs/change request meetings to understand the scope.
• Wrote queries validating population of data in the Oracle backend tables using SQL and PL/SQL.
• Used TOAD to manipulate the databases in all environments.
• Developed user interactive screens using Developer2000.
• Review test plans and identify tests, which should not be automated due to insufficient return-on-investment, moved to separate test plans, and execute manually.

Environment: Informatica Power Center 8.6.1, Windows XP, SQL, PL/SQL, TOAD

Confidential

ETL / Informatica Developer

Responsibilities:

• Designed mappings using Source Qualifier, Filter, Joiner, Aggregator, Union, Router, Rank, Lookup, Stored Procedure, Normaliser, and Expression.
• Developed the Extraction, Transformation and Load process (ETL) from SQL SERVER data sources to data warehouse using Informatica Power center.
• Developed and implemented the coding of Informatica Mapping for the different stages of ETL.
• Developed and configured various Tasks, Sessions and Workflows. Monitored Repository services, Integration Services.
• Fixed the invalid mappings and troubleshoot the technical problems of the database.
• Extensively worked on error handling and problem fixing in Informatica.
• Worked with Autosys for Scheduling and Monitoring of jobs.
• Created SQL queries to test the mappings.
• Debug the sessions by utilizing the logs of the sessions.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.
• Created Mapplet and used them in different Mappings.
• Worked with Informatica Workflow Managerfor creating and running workflows and tasks.
• Used shell scripts for automating the execution of maps.
• Designed and developed Oracle PL/SQL scripts for Data Import/Export.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Environment: Informatica Power Center 8.6, Workflow Manager, Workflow Monitor,PL/SQL, SQL Developer, UNIX

Confidential

Software Engineer

Responsibilities:

• Performance tuning of queries in PL/SQL and debugging and testing the same before integrating it into the database for the JACE controller.
• Participated in database development (Created PL/SQL stored procedures, functions, packages and sequences).
• Used Informatica Designer to extract data from Oracle and non-Oracle data sources, transform and load data into the target database in the process of developing the data warehouse.
• Declaring, raising and handling user defined exceptions in handling unexpected situations during compilation and execution in the JACE software.
• Working knowledge of declaring public and private constructs in stored procedures, functions and packages.
• Worked extensively along with the Business Analysts to help them analyse the data and create various scenarios for testing purposes.
• Created Complex mappings using Unconnected, Lookup, and Aggregate and Router transformations for populating target table in efficient manner.
• Involved in Unit, System, and Integration testing of the JACE software.
• Wrote and executed SQL scripts to identify Test Data in the UAT environment.
• Active participation in design reviews, creating techno-functional specifications to meet business requirements.

Environment: Informatica Power Center 8.6.1, Windows XP, SQL, PL/SQL, SQL Developer

Confidential

Software Engineer

Responsibilities:

• Designed, compiled and customized the firm’s in-house database using the XA21 architecture. Analyzed and designed new modules per customer requirements.
• Involved as a team member in Factory Acceptance Tests, Site Acceptance Tests and End user training programs.
• Wrote stored procedures and triggers for storing Alarms and Events into the SYBASE RDBMS in PL/SQL.
• Created a Daily testing update message and reported Testing status, Explained delays, Escalated Issues in daily and periodic meetings to the Project Managers.
• System tested UNIX scripts by creating input test data files, executing the jobs & validating the output data files.
• Performed database testing using SQL queries by using Left, Right Joins & conditional Queries.
• Wrote queries using SQL to retrieve data from the database for various customer requirements.
• Generated Hourly, Daily & Monthly shift reports using Triggers and Procedures for various feeders, transformers, lines etc. Generated reports of Energy consumed by the TEC Consumers, helping them to prepare monthly Energy balance reports using APT Workbench for report generation.
• Involved in testing, debugging and trouble-shooting code related to database.
• Involved as a team member in Software installation & integration of all different third party software.

Environment: IBM AIX 4.2, Sybase, APT Workbench