SUMMARY:

• Over 8 years of IT experience in development and Implementation of various projects using Database system, Data Warehousing tools, Network applications and Web applications.
• Over 8 Years of extensive experience in ETL process using Informatica - PowerCenter 5.1/6.2/7.1/8.1/8.5/9.5.1 Hotfix 4, PowerMart 5.1/6.2 and PL/SQL.
• Certified Oracle DBA (2003).
• Strong working experience on DSS (Decision Support Systems) applications, directly responsible for the Extraction, Transformation and Load (ETL) of data from Legacy Systems using Informatica.
• Expertise in Data Warehousing, Data Modeling using Star Schema and Snow-Flake Schema, Physical and Logical Data Modeling.
• Worked extensively with complex mappings using Expressions, Routers, Lookups, ERP source qualifiers, Aggregators, XML to develop and load data in to different Target types.
• Expertise in writing Server Side Programming with PL/SQL (Stored Procedures, Stored Functions, Cursors, Database Triggers and Packages)
• Experience with Oracle, DB2, VSAM and SAP R/3 7.1 and Other Utilities/tool: TOAD, UNIX Shell Scripting, Export/Import, SQL*Loader and KOALA
• Self-motivated and enjoy working in a technically challenging environment.
• Possess excellent Communication and interpersonal skills.

TECHNICAL SKILLS:

Languages: C, C++, SQL

Data Base: Oracle 7x/8i/9i/11.x, SQL Server 2000, Teradata, DB2, SAP and MS-Access

ETL Tools: Informatica Power Center 5.1/6.2/7.1/8.5/8.6, 9.5.1 Hotfix 4, Datastage and KOALA

Scripting Languages: UNIX Shell Script, Linux, PL/SQL, Perl

Data Modeling Tool Erwin 3.5.2/4.0, D3btool:

Business Intelligence: Business Objects, Cognos-Power Play, Impromptu, BRIO

Oracle Tools & Utilities: SQL *Loader, SQL Navigator, Export and Import, TOAD

Operating Systems: Windows 95/98/2000/NT/XP, UNIX, Sun Solaris 9

Version Control Tools: Clear Case, AutoSys tool

ERP Applications: SAP R/3 7.1

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

INFORMATICA Developer

• Involved in requirements gathering and design discussions with business owners for new enhancements in NAC customer report.
• Involved in the standup discussions and clarification of requirements from the business owners for the development of this project.
• Developed various mappings for loading staging, fact and dim tables to consolidate the data from various tables for individual metrics in to fact and aggregate table using Informatica Power Center 9.5.1 HotFix 4.
• Applied Business rules to Fact tables and Dimension Tables, Control status tables that were needed as part of historical and incremental data loading requirements.
• • Created Workflows and Sessions, various Tasks using Informatica Workflow manager and monitored real-time loads and historical loads using Workflow Monitor.
• Created Informatica mappings with PL/SQL stored procedures/functions to in corporate critical business functionality to load data.
• Extensively worked in the performance tuning of mappings, sessions, Target and Source such as evenly based partitions.
• Used the Debugger to run Debug sessions setting Breakpoints across instances to verify the accuracy of data to find data effects during DEV and QA testing.
• Involved in QA testing for various phases of the NAC such as FILE to STAGING, STAGIN to DWH and DWH to MICROSTATEGY. Creating test plans and test cases and scripts for the regression testing.
• Involved in the code deployment and coordinating with LOB for post deployment data validation and fixing production issues, and developing mapping document and implementation plan for the migration.
• Involved in the scheduling the jobs in Tidal for the new NAC mappings and monitoring the incremental loads in the tidal.
• Loading data from IBMA system into Teradata production and development warehouse using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD and Informatica.
• Creating and modifying MULTI LOADS for Informatica using UNIX and Loading data into IDW.
• Refreshed the data by using fastexport and fastload utilities.

Environment: Informatica - Power Center 9.5.1 Hot fix 4, Oracle 11.6, SQL, PL/SQL, Linux 2.6.18 and Windows XP/7 and Cisco Enterprise scheduler Tidal 6.1, Microstrategy and Teradata 14.x.

Confidential, Plano, TX

ETL Developer

• Involved in requirements gathering and design discussions with business owners for new enhancements in AML2.
• Involved in the scrum discussions and Agile methodology of development of the process of this project.
• Developed various mappings to consolidate the data from various tables for individual metrics in to one fact and aggregate table using Informatica Power Center 9.1.6 Hot Fix 11.
• Applied enhancements to Fact tables and Dimension Tables, Control status tables that were needed as part of data loading requirements.
• Created Workflows and Sessions, various Tasks using Informatica Workflow manager and monitored real-time loads using Workflow Monitor.
• Created Informatica mappings with PL/SQL stored procedures/functions to in corporate critical business functionality to load data.
• Created UNIX shell script to validate the input file and output files based on the counts and to generate Log files and parameter files and check the status of dependent loads based on a status table and implanting the business logic using the Scripts.
• Extensively worked in the performance tuning of mappings, sessions, Target and Source
• Created Mapplets for reusable business rules to get the Month key based on the servicer code.
• Used the Debugger to run Debug sessions setting Breakpoints across instances to verify the accuracy of data to find data effects during production issues.
• Developed UNIX Shell scripts for data extraction, running the pre/post processes and PL/SQL procedures for performing different database tasks.
• Involved in development, coordinating with QA team and preparing the test plans and scripts for the regression testing, code deployment and Coordinating with LOB for post deployment data validation and fixing production issues, and developing mapping documents, generating CIT test scripts for QA.
• Involved in the Operations Support for various Informatica jobs scheduled and timely resolving production issues.
• Involved in the migration of the AutoSys version from 4.5 to R11.3.5 and creating AutoSys scripts to schedule jobs for workflows.
• Involved in the Upgrade of Power Center 9.6.1. from Power Center 9.5.1. Testing and setting configurations.

Environment: Informatica - Power Center 9.5.1 Hot fix 4, Power Center 9.6.1, Oracle 11.6, SQL, PL/SQL, Linux 2.6.18 and Windows XP/7 and AutoSys 4.5 and R11.3.5, Tectia 6.3

Confidential, Dallas, TX

ETL Developer

• Involved with requirements gathering and design discussions with business owners
• Designed and developed a robust data model that supports future enhancements with less effort/changes.
• Developed various mappings to consolidate the data from various tables for individual metrics in to one fact and aggregate table using Informatica Power Center 8.1.6 HotFix 11.
• Applied enhancements to Time Dimension table that were needed as part of data loading requirements.
• Incorporated complex logic using Oracle inner & sub queries to extract the data for last 10 weeks, months, quarters and last year same day, prior MTD, etc.
• Created Workflows and Sessions using Informatica Workflow manager and monitored real-time loads using Workflow Monitor.
• Created Informatica mappings with PL/SQL stored procedures/functions to in corporate critical business functionality to load data.
• Created UNIX shell script to generate parameter files and check the statuses of dependent loads based on a status table.
• Extensively worked in the performance tuning of mappings, sessions, Target and Source
• Created Mapplets for reusable business rules.
• Used the Debugger to run Debug sessions setting Breakpoints across instances to verify the accuracy of data.
• Developed UNIX Shell scripts for data extraction, running the pre/post processes and PL/SQL procedures for performing different database tasks.

Environment: Informatica - Power Center 9.5.1 Hotfix 3, Oracle 10g, Ms Visio, SQL, PL/SQL, UNIX Shell scripting and Windows XP/7.

Confidential, Dallas, TX

Oracle Developer

• Extensively involved in gathering business requirements and translating them into technical requirements and further design and development.
• Involved in performance tuning of various processes to enhance retrieval speed and increase in performance.
• Mapping and session level tuning of Informatica PowerCenter objects to reduce processing time while loading the data from operational systems to datawarehouse.
• Developing PL/SQL stored procedures, functions, triggers, views and record tables to implement the business logic.
• Involved in development of Informatica PowerCenter mappings, sessions, mapplets, worklets and workflows to perform ETL processing for Distribution System Datamart loading.
• Developed various shell scripts for file transfer using sFTP, file validation, manipulation and cleansing, parameter generation.
• Performed Unit testing, Integration Testing, and User Acceptance testing to identify the data inaccuracies.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Prepared effective documentation for future references.
• Delivered and sign-off of deliverables pertaining to the Distribution System Datamart in a timely manner.
• Prepared design documents, ETL Specifications and migration documents.
• 24X7 Production support on a weekly shift basis
• Involved with maintenance and supporting user requirements of Informatica PowerCenter administration(e.g.,. creation of users, folders and setting permissions, applying HotFixes, etc.)
• Supported various adhoc reporting requests from business executives
• Involved in Tracking and timely resolution of issues raised by various business groups in a timely manner.

Environment: Informatica 8.6.1 Hot Fix 11, Oracle 10g, PL/SQL, UNIX, Shell Scripting, Solaris 5.10, Windows NT4.0.

Confidential, Fort Worth, TX

Data warehouse Consultant

• Extensively involved in gathering business requirements and translating them into technical requirements.
• Responsible loading the data into SAP using BAPI'S and IDOC’S.
• Involved in performance tuning at source, target, mapping and session level.
• Performed Unit testing, Integration Testing, and User Acceptance testing to identify the inaccuracies.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Extracted data from various sources such as Flat Files from Mainframe system, VSAM, DB2 and SAP tables for Inbound and outbound mappings.
• Prepared effective documentation for future references.
• Documentation of the daily updations in the mappings.
• Created and monitored workflows/sessions using Informatica Server Manager/Workflow Monitor to load data into target SAP.
• Delivered and sign-off of deliverables pertaining to the Operations Data warehouse.
• Prepared design documents, ETL Specifications and migration documents.

Environment: Informatica Power Center 8.5, DB2, VSAM, SAP R/3 7.1, SQL Server 2000/7.0, PL/SQL, UNIX, WindowsNT4.0, Hyperian ESSBASE 7.

Confidential, Miami, FL

Data warehouse Consultant

• Worked with the Business analysts for requirements gathering, business analysis, testing, and project coordination.
• Worked on Dimensional modeling to design and develop STAR Schema data model, used Erwin 4.1.4, identifying booking and transaction fact and dimension tables for different subject areas.
• Developed mappings for extracting raw data in flat files from Mainframe OLTP system to Revenue management System.
• Developed number of Complex mappings, mapplets and reusable transformations for the RMS to facilitate booking and transaction fact table’s data.
• Developing PL/SQL stored procedures and functions to implement the business logic in the process of enhancements to RMS and loading historical data.
• Involved in the DBA tasks such as creation of Schema, User, Table space, Views and Index to increase the performance of the query.
• Extensively worked in the performance tuning of the SQL queries, PL/SQL programs, ETL procedures and session processes.
• Involved in developing UNIX Shell script and scheduling jobs using OpCon job scheduler.
• Worked on various transformations such as Aggregator, Normalizer, Upgrade strategy, XML, Java, Router, Sorter, Source Qualifier, Filter, Expression, Look-up, Sequence Generator, Joiner etc. in the process of developing mappings to load fact tables.
• Loaded various Key Performance measures (KPI) FACT tables and multiple dimension tables for RMS using Informatica PowerCenter 8.1.1.
• Involved in creation of enhancements mappings to the RMS for the reporting system.
• Involved in development of various mappings that required writing the output in XML files and transmitting them to external billing system using FTP.
• Identified and tracked the slowly changing dimensions, heterogeneous Sources and determined the hierarchies in dimensions.

Environment: Informatica - Power Center 8.1.1, Oracle 9.2.0.5-2.0.7/10 g, Erwin 4.1.4, SQL, PL/SQL, SQL Server 2000,Windows NT/2000, Sun Solaris 9.

Confidential, Dallas, TX

Informatica Developer

• Business Analysis and Requirements Gathering.
• Developed various mappings for extracting raw data from GSM architecture network elements and sales data into the Regional database and aggregate the summary data in centralized location Network Data Warehouse.
• Involved in the design of the star schema for the revenue management system data warehouse.
• Involved in the DBA tasks such as creation of Schema, User, Tablepsace and setup standards for objects using the database building block tool.
• Developed and designed Datamart in Star Schema using the Erwin 4.0.
• Loading the Cingular demo database with network KPI’S calculated using the Performance measurement tool KOALA and Creating the PL/SQL Stored procedures/functions to in corporate critical business functionality to calculate aggregate data.
• Made extensive use of UNIX Shell scripting, Setup of UNIX cron jobs, maintaining user profiles etc.
• Involved in developing Export and import scripts to load report database for the demo server which is used at Confidential workshop for Corporate companies.
• Used SQL tools like TOAD to run SQL queries and validate the data in warehouse.
• Creating the Software installation builds and versioning using Clearcase tool for the CD release.
• Provided technical assistance by responding to inquiries regarding errors, problems, or questions with programs/interfaces.

Environment: Informatica - Power Center 7.1, Oracle 9i, Erwin 4.0, SQL, PL/SQL, Windows NT/2000, D3B tool, KOALA, ClearCase, Oracle EXPORT and IMPORT utility, UNIX CRONTAB and PERL.

Confidential, Dallas, TX

Informatica Developer

• Developed various mappings for extracting the data from different source systems using Informatica Power Center 6.2 - Server, Workflow Manager, Repository Manager and Designer.
• Converted the existing batches as Worklets and Workflows and scheduled them as per the requirement.
• Developed mappings between multiple sources such as text file, oracle and multiple targets.
• Involved in Data Modeling for FTTP component designed using Snowflake-Schema in Erwin.
• Created Workflows and Sessions using Informatica Workflow manager and monitored real-time loads using Workflow Monitor.
• Analyzed and Created FTTP Fact tables for the metrics and Dimension Table for storing the historical data.
• Created Informatica mappings with PL/SQL stored procedures/functions to in corporate critical business functionality to load data.
• Created UNIX shell script to transport flat files from different ordering systems to the ETL server
• Extensively worked in the performance tuning of mappings, sessions, Target and Source
• Developed Informatica mappings for TYPE 2 Slowly Changing Dimensions.
• Created Mapplets for reusable business rules.
• Used Pipeline partitioning and External Loader to improve Session performance
• Used the Debugger to run Debug sessions setting Breakpoints across instances to verify the accuracy of data.
• Developed UNIX Shell scripts for data extraction, running the pre/post processes and PL/SQL procedures for performing different database tasks.

Environment: Informatica - Power Center 6.2, Oracle 9i, Erwin 4.0, SQL, PL/SQL, UNIX and Windows NT/2000 and Teradata.