SUMMARY

• Over eight years of total IT experience, and six years as an ETL Developer.
• Technical proficiency in data warehousing teamed with business requirements analysis, application design, data modeling and data quality, data profiling, development, testing and documentation.
• Worked in the implementation of warehouses and database business systems for Insurance, Pharmaceutical, Financial and Telecom industries.
• Hands on experience in all aspects of the Software Development Life Cycle (SDLC).
• Six years of strong data warehousing experience using Informatica PowerCenter 9.1/8.6/8.5.1/8.1.0/7.1/7.0/6.2/6.1/5.1 (Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation developer), Informatica PowerMart 6.2/6.1/5.1.2/5.1.1/ , Power Connect, PowerPlug, Power Exchange, PowerAnalyzer, Datamarts, ETL,OLAP,OLTP, Operational Data Sources, Tidal, Autosys.
• Developed batch jobs using UNIX Shell scripts (csh, bash, ksh) to automate the process of loading, pushing and pulling data from and to different servers.
• More than five years of dimensional data modeling experience using Star Schema/ Snowflake modeling, FACT and Dimensions tables, physical and logical data modeling using ERWIN 4.5/4.0/3.x and Oracle Designer.
• Sales data warehouse experience.
• Java transformation experience.
• Strong SQL querying, SQL tuning experience.
• Worked with dimensional data warehouses in Star and Snowflake Schemas, created slowly changing dimension target mappings, Type1/2/3 dimension mappings.
• Extensively involved in designing database schemas using Erwin.
• Three years of experience in handling business and system requirements for Policy Admin Systems.
• Solid exposure to Business Intelligence experience using Business Objects XI/6.5/5.x (Business Objects 6.5/5.1, BO Designer, BO Reporter, Supervisor, Auditor, ZABO, BCA, BO SDK, WebI 6.1/6.2, InforView) Crystal reports Enterprise 10/8.5, OLAP, and Data Reports.
• Six years of experience using Oracle 10g/9i/8x/7.x, DB 2 8.0/7.0/6.0 , MS SQL Server 2008/2005/2000/7.0/6.5 (Query Analyzer, Enterprise Manager & DTS), TeraData, Database Systems, MS Access 7.0/97/2000, SQL, PL/SQL, DB2 Visualizer, Transact SQL, UNIX, Shell Scripting, HTML 4, SQL*Plus, TOAD.
• Excellent verbal and written communication skills with a clear understanding of business procedures and ability to work individually or as a part of a team.

TECHNICAL SKILLS

Data Warehousing/ ETL: Informatica PowerCenter 9.1/8.6/8.1/7.1.2/7.1.1/7.0/6.2/5.1 , Informatica PowerMart 6.2/5.1, (Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Repository manager), Metadata, Datamart, OLAP, OLTP, Power Connect, Power Exchange, B2B Exchange, Ascential Data Stage 7.0, ERWIN 4.x/3.x, MS Visio

Reporting Tools: Business Objects XI R2/XI/6.x/5.x, Cognos Impromptu/ Power Play 6.x/7.x, Micro strategy, Hyperion Brio, Designer 6i/2000 and MS Analysis Server

Data Mining Tools: Clementine 6.5, DB2 Intelligent Miner 6.1, Data Scope 3.0

Databases & Tools: Oracle 10g/9i/8i/8.x, DB2 UDB 8.5, SQL*Server, Teradata, Teradata Utilities, OEM Grid control, RMAN, Export/Import, AWR, Statspack, Explain Plan, TKPROF, SQL*Plus, SQL*Loader, Net8, TOAD

Scheduling Tools: Appworx 6.0, Informatica Workflow Manager, Autosys, Maestro/Tivoli, Apache, Tomcat, IIS, Connect Direct NDM, Control - M,ESP

Programming Languages: Unix Shell Scripting, SQL, PL/SQL, Perl, Visual Basic

Web Tools: HTML, ASP, JavaScript, .NET, HP Quality Center

Environment: UNIX, Win XP/NT 4.0/7

PROFESSIONAL EXPERIENCE

Informatica Developer, System Analyst

Confidential, West Des Moines, IA

Responsibilities:

• Interacted with Business to implement New Product functionality.
• Involved in design and implementation of TBS Product.
• Interacted with Business Analyst to understand requirements and translated them into the appropriate technical solution.
• Created Data Mappings and Design Documents according to Business Requirements.
• Created ETL Design Documents for team better understanding.
• Created Tables, Views and Materialized Views as per the design.
• Loaded Data into EDW using BTEQ, Fast Load and Multi Load.
• Used data integration with ETL tool, Informatica Power Center/Power Mart.
• Designing and developing complex Informatica mappings including Type-II slowly changing dimensions.
• Extensively used ETL to load data from wide range of sources such as flat files and legacy systems.
• All the jobs are integrated using complex Mappings including Mapplets and Workflows using Informatica power center designer and workflow manager. Ver. 8.6 and Ver.9.1.
• Created Various UNIX Scripts to load and transfer the data into tables and flat files.
• Performance tuning has been done to increase the through put for both mapping and session level.
• Use debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Created effective Test data and development thorough Unit test cases to ensure successful execution of the data and used pager for notifying the alerts after successful completion.
• Worked extensively on HP Quality Center.
• Worked Extensively on TeraData to load or pull data using Utilities.
• Created Apples to schedule the jobs for our nightly run using ESP.
• Used Cognos Impromptu and Power Play to create reports from the data mart.
• Provide off-hours on-call support on as needed basis.

Environment: Informatica 9.1/8.6, Unix, Windows NT, Oracle 10g database Oracle 11g database, SQL Server 2000, PL\SQL, ESP, UNIX Shell scripting, Toad, HP Quality Center, Visio.

Informatica Developer, System Analyst

Confidential, West Des Moines, IA

Responsibilities:

• Interacted with Business and Solution Architects for building Policy Admin System.
• Involved in design and implementation of Policy Admin System.
• Interacted with Business Analyst to understand requirements and translated them into the appropriate technical solution.
• Created Data Mappings and Design Documents according to Business Requirements.
• Created ETL Design Documents for team better understanding.
• Created Tables, Views and Materialized Views as per the design.
• Loaded Data into EDW using BTEQ, Fast Load and Multi Load.
• Involved in Informatica (8.6 to 9.1) and Oracle (10 to 11g) Upgrades.
• Created Critical Finance Extracts for our Product Reporting Team using Informatica Power Center.
• Used data integration with ETL tool, Informatica Power Center/Power Mart.
• Designing and developing complex Informatica mappings including Type-II slowly changing dimensions.
• Extensively used ETL to load data from wide range of sources such as flat files and legacy systems.
• Performed Java transformations.
• Converted all PL/ SQL into Informatica Extracts which our most products used.
• All the jobs are integrated using complex Mappings including Mapplets and Workflows using Informatica power center designer and workflow manager. Ver. 8.6 and Ver.9.1.
• Created Various UNIX Scripts to load and transfer the data into tables and flat files.
• Performance tuning has been done to increase the through put for both mapping and session level.
• Use debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Created effective Test data and development thorough Unit test cases to ensure successful execution of the data and used pager for notifying the alerts after successful completion.
• Worked extensively on HP Quality Center.
• Worked Extensively on TeraData to load or pull data using Utilities.
• Created Apples to schedule the jobs for our nightly run using ESP.
• Used Cognos Impromptu and Power Play to create reports from the data mart.
• Provide off-hours on-call support on as needed basis.

Environment: Informatica 9.1/8.6, Unix, Windows NT, Oracle 10g database Oracle 11g database, SQL Server 2000, PL\SQL, ESP, UNIX Shell scripting, Toad, HP Quality Center, Visio.

Informatica Developer

Confidential, Plano, TX

Responsibilities:

• Involved in design, development and implementation of RDM (Report Data Mart).
• Involved in interacting with the business community to understand their requirements.
• Involved in dimensional modeling, data quality, data profiling and data integration used to cleanse the data; ERWIN was used to design the business process, dimensions and measured facts.
• Extensively worked with Informatica PowerCenter client tools like Source Analyzer, Warehouse Designer, Transformation Developer and Mapping Designer, and Power Exchange.
• Extensively worked on unstructured data such as flat files to load data into Datamarts.
• Translated the business process into Informatica Mappings for building Datamart.
• Imported COBOL files from the respective database DB2 by using Normalizer transformation and created new mappings using Designer module of Informatica Power Center.
• Extensively work on the performance tuning of Informatica PowerCenter Mappings as well as the tuning of the sessions.
• Involved in Production Support related activities including resolving end user queries, investigation and resolving data related issues.
• Performed Java transformations.
• Worked on SQL Tools like TOAD to run the SQL Queries to validate the data.
• Wrote PL/SQL procedures for calculating the quantity of supply, stock in hand which are derived during the business requirement study.
• Created Perl scripting to automate the execution the workflows and Unix shell. Used Tidal job scheduler to schedule the workflows.
• Involved in performance tuning of SQL Queries, mappings and the workflows.
• Used the debugger in Informatica to test the mapping and fix the mappings.
• Optimized the mappings using various optimization techniques, repository configurations and also debugged some existing mappings using the Debugger to test and fix the bugs.
• Performed unit testing and system testing for troubleshooting the mappings and workflows.
• Did migration from test folder to UAT (User Acceptance Test) and Production.
• Involved in designing and developing the universe to support the reporting requirements by creating the Business Objects data model selecting/join tables, subdividing into contexts and creating the objects which are grouped into classes and tested them for efficient report generation and correct mappings of the objects.
• Involved in writing project documentation using Microsoft VISIO for different diagrams and server configuration management and used web services XML.

Environment: Informatica PowerCenter 8.5.1/8.6, Informatica PowerConnect for DB2, Business Objects XI/6.0, Erwin 4.5,IBM DB2, SQL, PL/SQL, MS SQL Server 2005/2000,Database Systems, Flat Files, UNIX Shell Scripting, Tidal, SQL*Loader, TOAD,HTML 4,MS Visio

ETL Informatica Developer/Data Modeler

Confidential, Saint Louis, MO

Responsibilities:

• Responsible for the Data Analysis of the Source systems constituted of Mainframe files, MS SQL Server database and Flat-files (CSV or Tab-Delimited files).
• Created multiple PowerCenter Mappings (20+) and PowerCenter Workflows to accomplish data transformation and load process.
• Used PowerExchange to facilitate the data fetch from DB2 UDB to EDW.
• Used various complex PowerCenter Transformations like Lookup, Joiner, Expression, Router, Update Strategy, Source Qualifier, Aggregator, SQL, Filter, Sequence Generator, XML Generator, Normalizer and Java to accomplish the mapping design.
• Created a detailed data flow diagram using MS Visio, representing the hierarchy of various DB tables being loaded by respective PowerCenter Workflow objects, and the complex inter-dependencies of the load process.
• Migrated Mappings, Sessions and Common Objects from DEV to IT and PROD environments.
• Re-designed multiple existing PowerCenter mappings to implement change requests (CR) representing the updated business logic.
• Created User Defined Functions (UDFs) and reusable Mapplets and Transformations to simplify maintenance process and improve the productivity.
• Developed various shell scripts for different purposes. For example, starting workflow, reset sequence generators, purge database tables.
• Performed Unit Testing and Integration Testing of Mappings and Workflows.
• Made substantial contributions in simplifying the development and maintenance of ETL by creating re-usable Mapplets and transformation objects.
• Validated and fine-tuned the ETL logic coded into existing PowerCenter Mappings, leading to improved performance.
• Validated the Informatica mappings against the pre-defined ETL design standards observed at Confidential Corporation.
• Experienced in scheduling using Tidal scheduler, which runs every day by maintaining the data validations.
• Extensively worked towards development of a custom application for use by Business Analysts. Contributed as an ETL analyst and Data Modeler.
• Designed data model for the custom application for use by Business Analysts, using Erwin 4.5.
• Wrote multiple DB Sequences and Triggers in Oracle towards the custom application.
• Created PowerCenter mappings using Web Services Source and Target objects in PowerCenter 8.5, with extensive use of SQL, XML Generator and XML Parser and Java transformations.
• Created Business Process Modeling (BPM) diagrams using standard Business Process Modeling Notations (BPMN) in Informatica Orchestration Client.
• Modeled a BPM diagram to represent a new data request from source system, and orchestrated the process of data fetching from source to staging database.
• Designed Human and Application process workflows using Orchestration Server and Client components.
• Maintained technical documentation.

Environment: Informatica PowerCenter 8.5/8.1/8.0, PowerAnalyzer, DB2, Tidal, Erwin 4.0, Oracle 9i/8i, UNIX Shell Scripting, SQL, PL/SQL, SQL * Loader, TOAD for Oracle and DB2, MS SQL Server 2000, Sun Solaris 2.6 UNIX, Windows XP/NT/2000, Ultra Edit, MS Visio

Developer, Support Analyst

Confidential, Warrenville, IL

Responsibilities:

• Participated in complete SDLC - requirements gathering, feasibility analysis, physical and logical data modeling, mapping design, unit and integration testing, production support and related documentation. Classified requests as either New Data or Changed Data requests.
• Analyzed data from flat files and multiple legacy source systems like NextGen Deal Entry, NextGen RefData, MOFT, US Exposure, and SAP to understand data dependency for EDW.
• Designed multiple Informatica Mappings (50+) and data quality verification programs using Informatica and PL/SQL to extract, transform and load source data based out of Oracle, Sybase, MS SQL Server, SAP (Inventory Data), MS Access and Text files into SCR, GMR and IPM Datamarts.
• Debugged multiple PowerCenter Mappings to analyze if Data Quality and Standardization requirements were being met.
• Created and documented Test Plans.
• Performed Unit and Integration testing for PowerCenter Mappings and Workflows, and documented the findings.
• Designed Reusable Transformations, Mapplets, Tasks and Worklets during Mapping and Workflow design process. Used most of the PowerCenter Transformations like Source Qualifier, Joiner, Router, Update Strategy, Lookup, Rank, Expression, Aggregator, Filter and Sequence Generator for loading the data into Oracle database.
• Configured the mappings to handle the updates to preserve the existing records using Router and Update Strategy Transformation, per business logic.
• Performed Mapping, Workflow, SQL and Database tuning to improve system performance.
• Created and maintained Mapping Design and Testing documentation.
• Provided production support by monitoring the processes running daily. Also assumed the role of an L1/L2/L3 support analyst for multiple Informatica and Kalido DIW based ETL systems, Documentum Webtop Client, Desktop Client and Administrator (DA) and Business Objects (BO thick client/WEBI, Supervisor, Broadcast Agent).
• Conducted technical and application training / knowledge transfer (KT) sessions for offshore team members (Infosys). This enabled them to take up L1/L2 support tasks.
• Facilitated change request (CR) implementation tasks by the way of gathering requirements, documenting them (Data Design Specification document), performing requirements review with offshore team members, performing code review, integration and systems testing, UAT, OAT, and production implementations. I would lead the effort of change implementation for 2 members at offshore location, and was accountable for their work.
• Participated in End-User training, and New Release or Change Implementation Meetings.
• Investigated, debugged and fixed problems with end-user BO report generation, Documentum Jobs, Documentum Workflows and Objects.
• Created custom Business Objects reports using thick client/WEBI, published and maintained them at Broadcast Agent (BCA). Automated the report generation process at specified schedule, for specific reports.
• Performed unit and integration testing in User Acceptance Test (UAT), Operational Acceptance Test (OAT), Production Support Environment (PSE) and Production environments.

Environment: Informatica Power Center 7.1, Business Objects 5.1.7/6.0/6.1/ WEBI, Oracle 9i, Sybase 11.x, MS SQL Server 2000, PL/SQL, MS Access, Documentum 5.3.x, Webtop Client, Desktop Client, Documentum Administrator (DA) Erwin 3.5, UNIX shell scripts

ETL Developer

Confidential

Responsibilities:

• Extensively involved in understanding the client’s database and identifying the significant fields to extract.
• Analyzed the sources, targets, transforming the data, mapping the data and loading the data into targets using Informatica PowerCenter.
• Involved in extraction of data from the different flat files and data from Oracle OLTP Systems.
• Developed transformations, mappings, sessions and workflows.
• Worked extensively on different types of transformations like normalizer, expression, union, filter, aggregator, update strategy, lookup, stored procedure, sequence generator and joiner.
• Scheduled the jobs to ensure the freshness of the data.
• Supervised, tested / validated all mappings for different applications.
• Documented all the mappings in Informatica.

Environment: Informatica PowerCenter 6.1, Oracle 8i, Windows 2000.