SUMMARY

• Over 8+ years of experience in Information Technology wif a strong back ground in Analyzing, Designing, Developing, Testing, and Implementing of Data Warehouse development in various domains such as Financial, Sales, Insurance, Telecom and Wireless.
• Over 7+years of experience in dealing wif SQL and PL/SQL.
• Over 6+ years of Data Warehousing experience using Informatica Power center 9.x/8.x/7.x/6.x, Informatica Power Mart 7.x/6.x, Power Connect, Power Exchange, Power Analyzer.
• Expertise in Database development skills using Oracle 11g/10g/9i/8i, SQL, PL/SQL stored procedures, Functions, Packages, Triggers, Cursors, Programming and TOAD.
• Experienced in Installation, Configuration, and Administration of Informatica Power Center/Power Mart Client/Server.
• Experienced in complete life cycle Implementation of data warehouse.
• Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and De normalization Concepts.
• Expertise in building Enterprise Data Warehouses (EDW), Operational Data Store (ODS), Data Marts, and Decision Support Systems (DSS) using Data modeling tool ERWIN and Dimensional modeling techniques (Kimball and Inmon), Star and Snowflake schema addressing Slowly Changing Dimensions (SCDs).
• Extensively worked on various Data warehouse projects using Informatica Client Tools - Source Analyzer, Transformation Developer, Workflow Manager, Workflow Monitor, Server Manager, Mapping Designer, Mapplet Designer and Warehouse Designer.
• Expert knowledge in Trouble shooting and performance tuning at various levels such as source, mappings, target and sessions.
• Experience in Administration activities like Creating and Managing Repositories, Users, User Groups, Folders, Working wif administrator functions of Repository Manager.
• Experience in teh concepts of building Fact Tables, Dimensional Tables, handling Slowly Changing Dimensions and Surrogate Keys.
• Expertise in designing and Developing complex Mappings using Informatica Power Center Transformations - Lookup, Filter, Expression, Router, Joiner, Update Strategy, Aggregator, Stored Procedure, Sorter, Sequence Generator and Slowly Changing Dimensions.
• Working experience in using Informatica Workflow Manager to create Sessions, Batches and schedule workflows and Worklets, Developing complex Mapplets, Worklets, Re-usable Tasks, Re-usable Mappings, Define Workflows &Tasks, Monitoring Sessions, Export & Import Mappings & Workflows, Backup & Recovery.
• Expertise in doing Unit Testing, Integration Testing, System Testing and Data Validation for Developed Informatica Mappings.
• Data loading using UNIX Shell scripts, SQL*Loader.
• Experience in dealing wif various databases like Oracle 11x/10g/9i/8x/7x, SQL Server 2005/2003/2000 , Teradata, DB2, MSSQL, Excel sheets, Flat Files, Sybase and XML files.
• Well Experienced in doing Error Handling and Troubleshooting using various log files.
• Good exposure to development, testing, debugging, implementation, documentation and production support.
• Expertise in developing reporting applications using Cognos 8.x/6.x Components like Framework Manager, Report Studio, Query Studio, Analysis Studio, and Data Manager.
• Expertise in developing web service applications using .NET and related technologies.
• Experience in handling initial and incremental loads in target database using mapping variables.
• Developed TEMPeffective working relationships wif client team to understand support requirements, develop tactical and strategic plans to implement technology solutions, and TEMPeffectively manage client expectation.
• Excellent written, communication skills and possessed analytic problem skills in evaluating business and technical processes and issues, develops and implements system enhancements to facilitate overall operations.

TECHNICAL SKILLS

Data Warehousing: Informatica Power Center 9.5/8.6/8.1/7.1/6.2/5.1 , Informatica Power Mart 7.x/6.x, Informatica Power Exchange 8.x/7.x, Repository Admin console, Repository Manager, Designer, Workflow Manager, and Workflow Monitor, Informatica Power Designer.

Data Modeling: Ralph-Kimball Methodology, Bill-Inmon Methodology, Star schema, Snowflake schema, Dimensional data modeling, Snowflake modelingFact Tables, Dimension Tables.

Databases/Files: Oracle 11g/10g/9i/8i, SQL Server 2008/2005, Teradata V2R6, DB2,Sales Force.com,Sybase,Web services,XML and Flat files.

Oracle Utilities: Oracle SQL Developer, SQL * Plus.

Operating Systems: Windows 7/vista/NT/2000/XP, MS-Dos, UNIX/ Linux.

Reporting Tools: Informatica Power Analyzer, Cognos 8.x/6.x, Business Objects XI R3 and OBIEE.

Modeling Tools: Erwin 4.1/4.0, TOAD 9.x/8.x/7.x, SQL Loader 11g/10g, ER-Studio.

Scheduling Tools: Tidal, Autosys, Control-M and Maestro.

Office Tools: MS PowerPoint, MS Word, MS Excel.

Programming: SQL, PL/SQL, T-SQL, C, C++, C# (.NET), HTML, ASP.NET.

Scripting: UNIX Shell Scripting, Java-Scripting, Korn Shell Scripting, Perl Scripting.

PROFESSIONAL EXPERIENCE

Confidential, Allen, Tx

Sr.Informatica Developer

Responsibilities:

• Involved in teh source data landing process, wrote scripts to load various source files like txt, csv, delimited and oracle dump files.
• Responsibilities included source system analysis, data transformation, and loading, validation for data marts and data warehouse.
• Worked closely wif Business Analysts in requirements gathering (BRD) and source system analysis and translated teh business requirements into technical specifications to build teh Enterprise data warehouse.
• Analyze and Estimation durations for milestone after understanding requirements from Business Analyst.
• Designed and Developed Oracle PL/SQL Procedures and UNIX Shell Scripts for Data Import/Export and Data Conversions.
• Interacted wif both Technical, functional and business audiences across different phases of teh project life cycle.
• Developed Informatica mappings, sessions and workflows as per teh business rules and loading requirements using mapping parameters and variables.
• Used debugger to analyze teh data flow between source and target to fix teh data issues.
• Developed PL/SQL procedures, functions to facilitate specific requirement.
• Implemented audit and reconcile process to ensure Data warehouse is matching wif teh source systems in all reporting perspectives.Worked on generating teh Interface files based on teh business requirements.
• Upgrade from Informatica 9.1 to Informatica 9.5
• Extensively used various Data Cleansing and Data Conversion functions like LTRIM, RTRIM, ISNULL, ISDATE, TO DATE, Decode, Substr, Instr, and IIF functions in Expression Transformation
• Responsible for best practices like naming conventions, Performance tuning, and Error Handling
• Responsible for Performance Tuning at teh Source level, Target level, Mapping Level and Session Level
• Extensively worked wif various lookup caches like Static Cache, Dynamic Cache and Persistent Cache
• Used Power Exchange to extract data from teh IBM DB2 systems.
• Created teh release requests for QA Builds to include all teh release requirements and involved in teh implementation of QA, UAT and Production releases.
• Developed a UNIX Shell scripts for various data files validations and workflow executions.
• Provided data loading, monitoring, system support and worked on data issues raised by end users.
• Performance tuned Informatica mappings using Pushdown Optimization, Variables and Dynamic Cache.
• Prepared Mapping Specification Document, which gives teh data flow and transformation logic for populating each column in teh data warehouse table.
• Prepared teh Standard Operating Procedure (Knowledge Transfer) document, which provides necessary information, required for teh Maintenance and Operation of teh application.
• Stayed on call for support for any workflow failures or any Technical Issues.
• Coordinated wif other application teams to run LHS and RHS for a successful conversion.
• Worked wif Informatica and other consultants to develop IDQ plans to identify possible data issues.
• Applied business rules using Informatica Data Quality (IDQ) tool to cleanse data.
• Integrated Informatica Data Quality wif Informatica Power Center.
• Installed IDQ on a informatica power center server machine.
• Finding teh Informatica mappings bottlenecks and optimizing teh mappings to get teh best performance and tuning teh SQL queries as well.
• Implemented partitioning and bulk loads for loading large volume of data.
• Involved in loading teh data from Sources to RST (Raw Staging Tables) using Transformation and Cleansing Logic using Informatica.
• Used Informatica debugging techniques to debug teh mappings and used session log files and bad files to trace errors occurred while loading.
• Based on teh requirements, used various transformations like Source Qualifier, Normalizer, Expression, Filter, Router, Update strategy, Sorter, Lookup, Aggregator, Joiner, Stored procedure transformations in teh mapping.
• Developed mapplets and worklets for reusability.
• Implemented daily error tracking and correction process using Informatica and Tidal.
• Involved in performance tuning of mappings, transformations and (workflow) sessions to optimize session performance.

Environment: Informatica Power Center 9.5(Repository Manager, Designer, Workflow Manager, and Workflow Monitor, Source Analyzer, Informatica Power Designer, Warehouse Designer, DB2 UDB 9.5, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer), Oracle 11g/10g, PL/SQL, Toad, Perl, Unix Shell Scripting, Linux,XML and Flat Files.

Confidential, Houston, Tx

Sr.Informatica Developer

Responsibilities:

• Responsible for Requirement Gathering Analysis and End user Meetings
• Responsible for converting Functional Requirements into Technical Specifications
• Extracted data from various heterogeneous sources like Oracle, SQL Server, Sybase, MS Access, and Flat Files.
• Worked on Power Center Tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager
• Worked on Designer Tools like Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, and Mapping Designer
• Extensively used Source Qualifier Transformation, and used most of its features like filter, sorter, and SQL Override.
• Extensively used various active and passive transformations like Filter Transformation, Router Transformation, Expression Transformation, Source Qualifier Transformation, Joiner Transformation, and Look up Transformation, Update Strategy Transformation, Sequence Generator Transformation, Rank Transformation, and Aggregator Transformation
• Upgrade from Informatica 9.1 to Informatica 9.5
• Extensively used various Data Cleansing and Data Conversion functions like LTRIM, RTRIM, ISNULL, ISDATE, TO DATE, Decode, Substr, Instr, and IIF functions in Expression Transformation
• Responsible for best practices like naming conventions, Performance tuning, and Error Handling
• Responsible for Performance Tuning at teh Source level, Target level, Mapping Level and Session Level
• Used Power Exchange to extract data from teh ERP systems.
• Solid Expertise in using both Connected and Un connected Lookup transformations
• Extensively worked wif various lookup caches like Static Cache, Dynamic Cache and Persistent Cache
• Extensively worked wif joiner functions like normal join, full outer join, master outer join, and detail outer join in teh joiner transformation
• Responsible for analyzing, designing and developing ETL strategies and processes, writing ETL specifications for developer, ETL and Informatica development, administration and mentoring.
• Work closely wif various levels of individuals to coordinate and prioritize multiple projects. Estimate, schedule and track ETL projects throughout SDLC
• Teradata views has been developed against teh Departmental database and claims engine database to get teh required data.
• Developed application views in Teradata and using expression and router implemented teh Change Data Capture (CDC) process
• Coordinating wif user to gather teh new requirements and working wif existing issues.
• Involved in business analysis and technical design sessions wif business and technical staff to develop requirements document, and ETL specifications
• Experience wif high volume datasets from various sources like Oracle, Text Files, and Netezza Relational Tables and xml targets
• Used Update Strategy DD INSERT, DD DELETE, DD UPDATE, AND DD REJECT to insert, delete, update and reject teh items based on teh requirement
• Worked wif Index Cache and Data Cache in cache using transformation like Rank, Lookup, Joiner, and Aggregator Transformations
• Developed Re usable Transformations, and Re Usable Mapplets
• Worked wif Shortcuts across Shared and Non Shared Folders
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files
• Worked wif Informatica and other consultants to develop IDQ plans to identify possible data issues.
• Applied business rules using Informatica Data Quality (IDQ) tool to cleanse data.
• Integrated Informatica Data Quality wif Informatica Power Center.
• Installed IDQ on a informatica power center server machine.
• Responsible for determining teh bottlenecks and fixing teh bottlenecks wif performance tuning
• Worked wif Session Logs, and Workflow Logs for Error handling and Troubleshooting in DEV environment
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy
• Responsible for Unit Testing and Integration testing of mappings and workflows
• Responsible for month-end data consistency checks and fixes using shell scripts and stored procedures. Also responsible for tuning stored procedures
• Unit and Integration Testing of Informatica source and Target Data.
• Created and Documented ETL Test Plans, Test Cases, Test Scripts, Expected Results, Assumptions and Validations.
• Created documents for data flow and ETL process using Informatica mappings to support teh project once it implemented in production.

Environment: Informatica Power Center 9.5(Repository Manager, Designer, Workflow Manager, and Workflow Monitor, Informatica Power Designer, Source Analyzer, Warehouse Designer, DB2 UDB 9.5, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer), Informatica Power Exchange, Data Explorer, Data Quality, PL/SQL, Oracle 10g, SQL Server 2008 R2, Sybase, Cobol, Teradata V2R12/V2R6, Flat Files, UNIX Shell Scripting, CA Autosys 11.3

Confidential, Richmond, VA

Sr.Informatica Developer

Responsibilities:

• Extensively worked wif teh data modelers to implement logical and physical data modeling to create an enterprise level data warehousing.
• Extensively worked on creating Facts and Dimensions tables
• Designed and Developed Oracle PL/SQL Procedures and UNIX Shell Scripts for Data Import/Export and Data Conversions.
• Created and Modified T-SQL stored procedures for data retrieval from MS SQL SERVER database.
• Worked wif pre and post sessions, and extracted data from Transaction System into Staging Area.
• Extensively used Informatica Power Center 9.1 to extract data from various sources and load in to staging database.
• Extensively worked wif Informatica Tools - Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager, Workflow Manager, Workflow Monitor, Repository server and Informatica server to load data from flat files, legacy data.
• Extensively used transformations such as Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Joiner, Transaction Control and Stored Procedure.
• Designed teh mappings between sources (external files and databases) to operational staging targets.
• Involved in data cleansing, mapping transformations and loading activities.
• Developed Informatica mappings and Mapplets and also tuned them for Optimum performance, Dependencies and Batch Design.
• Implemented Slowly Changing Dimension methodology for Historical data.
• Wrote BTEQ Scripts for extracting data.
• Establish Loading process using MLOAD, FLOAD, and BTEQ.
• Exporting Data using BTEQ and Fast Export.
• Generated reports using Teradata BTEQ.
• Fine-tuning of PL/SQL Stored Procedures.
• Designing mapping templates to specify high level approach.
• Created Data Breakpoints and Error Breakpoints for debugging teh mappings using Debugger Wizard.
• Provided production support for Business Users and documented problems and solutions for running teh work flow.
• Extensively worked on unit testing and implemented on transformations, mappings.
• Involved in production support and stabilizations.
• Worked on Migration of Data warehouse in between different versions.
• Coordinated between Development, QA and production migration teams.
• Extensively involved in documentation of teh project.
• Reports were generated using Business Objects for analysis.

Environment: Informatica Power Center 9.1, Teradata V2R5/V2R6, Oracle 11g, PL/SQL, Hyperion, SQL SERVER 2005, UNIX Shell scripting, Business Objects XI R3, ESP Schedule, TOAD, SQL Assistant, Win 7.

Confidential, Branchville, NJ

Sr.Informatica Developer

Responsibilities:

• Involved in Data modeling design, Designing specifications and Documentation of Data Warehouse using ETL (Extraction, Transformation and Load) tool Informatica Power Center 9.1.
• Analyzing existing database schemas and designing star schema models to support teh users reporting needs and requirements.
• Upgraded informatica power center 8.6.1 to informatica power center 9.1.
• Extensively used Informatica Power Center 9.1 to create and manipulate source definitions, target definitions, mappings, mapplets, transformations, re-usable transformations, etc.
• Involved in design and development of complex ETL mappings and stored procedures in an optimized manner.
• Designed and developed daily audit and daily/weekly reconcile process ensuring teh data quality of teh Data warehouse.
• Finding teh Informatica mappings bottlenecks and optimizing teh mappings to get teh best performance and tuning teh SQL queries as well.
• Implemented partitioning and bulk loads for loading large volume of data.
• Involved in loading teh data from Sources to RST (Raw Staging Tables) using Transformation and Cleansing Logic using Informatica.
• Used Informatica debugging techniques to debug teh mappings and used session log files and bad files to trace errors occurred while loading.
• Based on teh requirements, used various transformations like Source Qualifier, Normalizer, Expression, Filter, Router, Update strategy, Sorter, Lookup, Aggregator, Joiner, Stored procedure transformations in teh mapping.
• Developed mapplets and worklets for reusability.
• Implemented daily error tracking and correction process using Informatica and Tidal.
• Involved in performance tuning of mappings, transformations and (workflow) sessions to optimize session performance.
• Developed Informatica SCD type-I, Type-II mappings. Extensively used almost all of teh transformations of Informatica including complex lookups, Stored Procedures, Update Strategy, mapplets and others.
• Developed workflow tasks like reusable Email, Event wait, Timer, Command, Decision.
• Created Stored Procedures, Packages in PL/SQL wif Oracle in order to create, update several tables like Order processing Information table and Audit Log tables.
• Used PMCMD command to start, stop and ping server from UNIX and created UNIX SHELL PERL scripts to automate teh process.
• Extensively used cognos 8.4 frame work studio to create reports relative to corporate business planning.
• Extensive hands on Schema design, XML import/export, Scheduling, System management using Informatica.
• Creating Test cases and detailed documentation for Unit Test, System, Integration Test and UAT to check teh data quality.

Environment: Informatica Power center 8.6.1/9.1(Source Analyzer, warehouse designer, Mapping Designer, Mapplet, Transformations, Repository Manager, Work Flow Manager, Workflow Monitor), oracle 11g, Sales Force.com,Web Services, TOAD 10.6 for oracle, PL/SQL, ER-studio, Tidal, DB2,IBM iseries interface, XML, Flat Files, Windows 7, Linux, Cognos 8.4.

Confidential, Milpitas, CA

ETL Developer

Responsibilities:

• Involved in teh requirement analysis, database design and modeling Techniques.
• Preparation of strategy for Data Conversion as per teh business rules.
• Collection of data source information from all teh legacy systems and existing data stores.
• Configured and Installed Informatica power center 8.6 on Oracle database in Windows 2008 Environment.
• Created repositories and folders as per teh client requirement.
• Developed complex mappings using multiple sources and targets in different databases, flat files.
• Created different transformations using Informatica power center 8.6 for loading teh data into targets using various transformations like Source Qualifier, Java Transformation, SQL transformation, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, and Sequence Generator.
• New attributes/columns were introduced in teh dimension tables by slowly changing dimensions.
• Used Workflow Manager to create Worklets and workflows and Workflow Monitor to monitor teh workflows.
• Used Workflow Manager to create connections, sessions, tasks, workflows and created Event Wait, Event Raise, Timer and Control Events in a single master workflow according to teh business requirements.
• Applied performance tuning on targets, sources, mappings and sessions to improve system performance.
• Writing Oracle Stored Procedures, SQL scripts and calling them by using Perl shell and Korn shell scripts at pre and post session.
• Developed PL/SQL, T-SQL stored procedures for pre and post session commands and used indicator files to run tasks in workflows.
• Tuning Informatica Mappings and Sessions for optimum performance.
• Used shortcuts to reuse objects wifout creating multiple objects in teh repository and inherit changes made to teh source automatically.
• Well Experienced in doing Error Handling and Troubleshooting using various log files.
• Created Breakpoints for debugging teh mappings using Debugger.
• Extensive use of Persistent cache to reduce session processing time.
• Created partitions for concurrent loading and processing of data.
• Implemented XML and UML web services using C #.NET and ASP.NET.
• Deployment of Informatica jobs into testing, Validation and production environments.
• Preparing deployment documents, user guides, coding standards, and other technical documents.
• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Involved in teh creation of new users and controlling and administering teh access privileges to Informatica Power Analyzer.
• Reports were generated using power analyzer for analysis.

Environment: Informatica Power center 8.6.1, SAP R/3, oracle 11g, SQL server 05, Toad for oracle 8.1, ER-studio, Maestro, DB2, Sybase, XML, Flat Files, Windows 7, Linux, Power Analyzer.

Confidential, IL

Data Warehouse Developer

Responsibilities:

• Actively involved in gathering requirements and acquiring application knowledge from Business Managers & Application Owners.
• Prepared teh High-level Design document to provide an overview of teh technical design specification system required for Application Enhancements.
• Involved in designing teh process flow for extracting teh data across various systems interacting.
• Developed ETL routines using Informatica Power Center and created mappings involving transformations like Lookup, Aggregator, Ranking, Expressions, Mapplets, connected and unconnected stored procedures, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers.
• Implemented dimension model (logical and physical data modeling) in teh existing architecture using Erwin.
• Designed data model structure and E-R modeling wif all teh related entities and relationship wif each entity based on teh rules provided by teh business manager using Erwin.
• Used workflow manager for session management, database connection management and scheduled teh jobs to run in teh batch process.
• Developed Slowly Changing Dimensions for Type 2 SCD.
• Troubleshoot teh issues by checking sessions and workflow logs.
• Involved in analyzing teh bugs, performance of PL/SQL Queries and provided solutions to improve teh same.
• Written and used UNIX shell scripts extensively for scheduling and pre/post session management
• Involved in teh performance tuning process by identifying and optimizing source, target, mapping and session bottlenecks.
• Involved in Unit testing, System testing to check whether teh data loads into target are accurate, which was extracted from different source systems according to teh user requirements.
• Prepared teh Standard Operating Procedure (Knowledge Transfer) document, which provides necessary information, required for teh Maintenance and Operation of teh application.
• Provided data loading, monitoring, system support and general trouble shooting necessary for all teh workflows involved in teh application during its production support phase.
• Actively participated in data base testing like checking teh constraints, correctness of teh data, stored procedures, field size validation, etc.

Environment: Informatica Power Center 8.6.1, Oracle 11g, PL/SQL, SQL Server 2005, T-SQL, SQL*Loader, Erwin 4.0, SQL Loader 11g, Win 2008, Perl & Korn scripts, SAP R3, Flat files, SAS Data, Toad, Solaris 10, Autosys, ODBC, Power Analyzer.

Confidential

Programmer Analyst

Responsibilities:

• Interacted wif Business Analysts, Source to Target Mapping and E-R Diagramming.
• Developed teh ETL process from teh source system into teh Oracle Dimension and Fact tables using POWERCENTER 1.7. Developed stored procedures, functions and database triggers in teh backend.
• Automated teh report generation process from Oracle using Essbase 5.0 through VBA coding in EXCEL.
• TEMPEffected Modifications to teh reports on user-request and comprehensively tested teh reports.
• Participated in Data Modeling in Designer 2000, Source System Analysis and STAR Schema design.
• Created very complex SQL and used dynamic views and correlated queries of teh highest quality.
• Developed stored procedures, functions and database triggers in teh backend.
• Tuned teh SQL using optimizer hints and EXPLAIN PLAN.

Environment: Informatica Power Center 5.1, Informatica Power Connect, Cognos, Oracle 7.3, MS SQL Server 2000, HTML, XML, SQL Plus, PL/SQL, SQL, and Windows 2000.

Confidential

ORACLE DEVELOPER

Responsibilities:

• Creating dimensions and facts in physical data model.
• Attending several business sessions wif teh business users.
• Creating Views and altered some of teh dimensional tables to satisfy business users reporting needs.
• Writing teh SQL procedures to improve warehouse loading.
• Designing teh Database Schema using Designer /2000.
• Designing mapping for sales organization.
• Defining Entities, Attributes, UIDs, and relationships.
• Database Schema Designing, Writing SQL procedures for teh application.

Environment: Oracle 7.3 (SQL, SQL*Loader), SQL, PL/SQL, SQL Server 6.5, and Developer/2000.