SUMMARY:

• 7+ years of IT experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using BI - Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.
• 6+ years of Data Warehousing experience in designing and implementing Data Warehouse applications using Informatica Power Center 9.x, 8.x and 7.x.
• Strong in Data Warehousing concepts, dimensional star schema and snow flake schema methodologies.
• Involved in different phases of Data Warehouse Life Cycle including business reporting requirements gathering, source system analysis, logical/physical data modeling, ETL design/development, project deployment and production support.
• Proficient in understanding business process/requirements and translating them into technical requirements.
• Data processing experience in designing and implementing Data Mart applications; mainly transformation processes using Informatica.
• Experience in monitoring the environments and suggesting improvements for stability and performance tuning.
• Advanced SQL skills, including use of derived tables, unions and multi-table inner/outer joins.
• Extensive work in ETL process consisting of data transformation, data sourcing, mapping, conversion and loading.
• Worked extensively to build complex mappings using Informatica Designer Transformations such as Source Qualifiers, Lookups, Aggregators, Expressions, Routers, Filters, Joiners and Stored Procedure.
• Experience in implementing complex business rules by creating re-usable transformations and robust mappings/mapplets.
• Experience in implementing type 1, type 2 slowly Changing Dimensions in Data Warehousing using various transformations in Informatica.
• Experience in setting up and configuring Enterprise Informatica Implementation with Power Center. Implementation of patches and upgrades.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels such as target, source, mapping and session.
• Experience in performing SQL query optimization using Hints, Indexes and Explain plan.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.0.1/8.6/8.1/8.0/7.2 , Power Connect/Power Exchange.

OLAP Tools: Cognos 8.1, Business Objects 6.5/XI.

Databases: Oracle 10g/9i, SQL Server 2008/2005/2000 , MS Access, Sybase, SQL, PL/SQL, UDB DB2, Teradata V2R5

Data Modeling Tools: ERWIN, Microsoft Visio.

Scripting: UNIX Shell Scripting, HTML, DHTML, XML

Defect Tracking Tools: Rational Clear Quest, Mercury Quality Center.

Other Tools: Rational Clear Case, Tivoli, Control-M, TOAD, Rapid SQL

Operating Systems: Windows XP/NT/2000, IBM AIX UNIX, Linux, 7.3/8.0, IBM-PC Compatibles

PROFESSIONAL EXPERIENCE:

Confidential, Vista, CA

Informatica Developer

Responsibilities:

• Analyze the current data movement (ETL) process and procedures. Identify and assess external data sources as well as internal and external data interfaces.
• Extracted data from various source systems that include Oracle, Sybase, Flat files, XML files and Web Services.
• Worked on Informatica Designer tools - Source Analyzer, Target Analyzer, Mapping Designer, Mapplet Designer and other client tools such as Workflow Manager and Workflow Monitor to create and monitor the batches.
• Developed complex mappings in Informatica using different transformations such as Source Qualifier, Lookup, Expression, Aggregator, Joiner, Router, Sequence Generator and Update Strategy and Web Service Consumer Transformations.
• Developed reusable transformation objects such as mapplets to avoid duplication of metadata, reducing the development time.
• Performance tuning has been done to increase the throughput for both mapping and session level and SQL Query Optimization as well.
• Used SQL Loader to load the data from flat files to the relational tables.
• Performed Informatica code migrations, test, debug, document to maintain programs and deployed.
• Extensively worked on testing the system from beginning to end to ensure the quality of the adjustments made to oblige the source system up-gradation.
• Worked on bug fixes in Informatica mappings to produce the correct output.
• Performed unit testing, SIT (System Integration Test) and UAT (User Acceptance Test) to check the data quality.
• Automation and scheduling of UNIX shell scripts and Informatica sessions and batches using Scheduling tool Control M.
• Post production support, enhancements and performance tuning.
• Efficient documentation was done for all phases like Analysis, design, development, testing and maintenance.

Environment: Informatica Power center 9.0.1/8.6,OBIEE,DAC, Oracle 10g, Sybase, Flat Files, SQL Loader, UNIX AIX, and Microsoft Visio.

Confidential, Bentonville, AR

Sr. Informatica Developer

Responsibilities:

• Used Informatica PowerCenter 8.1.1 for migrating data from various OLTP databases and other applications to the Radar Store Data Mart.
• Worked with different sources like Relational, Mainframe (COBOL), XML and flat files (CSV).
• Created complex Informatica mappings with extensive use of Aggregator, Union, and HTTP Post, Filter, Router, Normalizer, Joiner and Sequence generator transformations.
• Created and used parameter files to perform different load processes using the same logic.
• Extensively used PL/SQL for creation of stored procedures and worked with XML Targets, XSD’s and DTD’s.
• Was involved in the modification of the XSD’s so as to write the data to the appropriate XML files.
• Performed performance tuning of targets, sources, mappings and session and performed pipeline partitioning.
• Utilized the new utility Informatica Data Quality (IDQ) and Informatica Data Explorer (IDE) that came up with Informatica Ver.8.
• Defined Target Load Order Plan and Constraint based loading for loading data appropriately into multiple Target Tables.
• Expertise in using different tasks (Session, Assignment, Command, Decision, Email, Event-Raise, Event-Wait and Control).
• Involved in modifying already existing UNIX scripts and used them to automate the scheduling process.

Environment: Informatica power center 8.1.1, Power Exchange, Oracle 9i, XML, UNIX, PL/SQL, Windows 2000/XP.

Confidential, Chicago, IL

Application Developer

Responsibilities:

• Analyzed business documents and created software engineering requirement specification.
• Helped business analyst in design, development and implementation of the Enterprise Data Warehouse and Data Marts.
• Interacted with the business users, analysts for requirements, developed conceptual and logical data models using ERWIN tool.
• Extracted data from the various source systems that include Oracle, SQL Server, DB2 and flat files.
• Created and walked the team through mapping specification document.
• Developed several mappings using transformations like Source Qualifier, Expression, Aggregator, Joiner, Lookup, Sequence Generator and Update Strategy, etc in Informatica to populate the data to the target systems.
• Developed user defined functions, reusable transformations and mapplets and made use of them in several mappings to streamline the mappings.
• Implemented Incremental Aggregation to capture only the new records from the source, which increased the performance.
• Improved the mapping performance by overriding the default SQL queries.
• Developed mappings using type 2 slowly changing dimensions to keep track of historical data.
• Created sessions and batches in the workflow manager tool and monitored the status using the workflow monitor tool.
• Extensively used various performance tuning techniques to improve the session performance.
• Implemented Pushdown Optimization to reduce the burden on the Integration service and thereby increase the performance.
• Running parallel sessions by using concurrent batches reduced the time for loading the data.
• Partitioning the session improved the session performance by creating multiple connections to the source and target systems.
• Tracked the defects and wrote test cases.
• Used debugger to test the data flow and fixed the mappings.
• Performed code reviews with peers and created unit test plan document.
• Created test cases for Unit test, System Integration test and UAT to check the data quality.
• Successfully upgraded Informatica 8.0 to 8.6 and responsible for validating the objects in the new version of Informatica.

Environment: Informatica power center 8.6/8.0, Power Exchange, ERWIN 7.2, Oracle 10g/9i, Flat Files, SQL Server 2008, DB2, Teradata V2R5, UNIX AIX, SQL, PL/SQL, Rational ClearQuest, Rational ClearCase, Business Objects XI

Confidential, Los Angeles, CA

Informatica Developer

Responsibilities:

• 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.
• Analyzed application requirements and provided recommended design and studied the current system to understand the existing data structures.
• Participated actively in user meetings and collected requirements from users.
• Used Informatica Power Center 8.1 for extraction, transformation and loading (ETL) of data in the Data Warehouse and used velocity methodology.
• Designed, developed and documented several mappings to extract the data from Flat files and Relational sources.
• Performed ETL into ORACLE Data Warehouse using Informatica Mappings including transformations Aggregator, Joiner, Lookup (Connected & Un-connected), Filter, Update Strategy, Stored Procedure, Router, Expression, Sql and Sorter.
• Involved in design and development of ad-hoc data load or business critical code enhancement.
• Worked on stored procedures, functions and views.
• Developed data mappings between source systems and warehouse components.
• Created workflows and tested mappings and workflows in development, test and production environment.
• Developed re-usable transformations, mappings and mapplets confirming to the business rules. Used Debugger to test the mappings and fix the bugs.
• Actively involved in performance improvements of mapping and sessions and fine tuned all transformations.
• Performed Informatica code migration from development/ QA/ production and fixed and solved mapping and workflow problems.
• Developed and maintained optimized SQL queries in the Data Warehouse.

Environment: Informatica 8.1.1, Unix Scripting, Toad, Oracle 11g, Sql, Pl/sql, Business Objects 6.5, Data Analyzer

Confidential, Troy, MI

Program Analyst

Responsibilities:

• Created stored procedures, functions, Packages, Data base triggers, Reports 6i and Cursors based on business requirements.
• Worked under Agile Scrum methodology
• Involved in performance tuning using Explain Plan, Tk- proof utilities.
• Involved in analyzing Schema’s, Tables and Indexes as part of OPTIMIZATION
• Involved in creating Specification Documents, Mapping documents, Data Flow Diagrams, ER Diagrams, Dependency documents.
• Maintained and created UNIX shell scripts.

Environment: Oracle 8i, SQL, PL/SQL, SQL* Plus, UNIX shell script, .NET.