SUMMARY

• Solutions oriented Developer with notable success in directing a board range of IT initiatives while participating in Team Leading, analysis and implementation of data warehouse solutions in direct support of business objectives
• Client interaction with excellent interpersonal and communication skills
• Outstanding leadership abilities, able to coordinate and direct all phases of project based efforts while managing, motivating and leading project teams and excellent on onsite offshore model coordination.
• Track record of increasing responsibility in Data warehouse design, system analysis /modeling/development/ Testing and full life cycle project management.
• Hands on experience leading all stages of system development efforts, including requirement definition, design, architecture, testing, support and administration.
• Adept at developing effective procedures, project documentation and milestones, and technical/business specifications
• Work closely with project managers, developers, and focus groups to avoid redundancy, minimize expenditures, and improve overall synergy within organization
• Successful background working with stakeholders to develop architecture framework dat aligns strategy, processes, and IT assets with business goals

TECHNICAL SKILLS

Data Warehousing: Informatica Power Center 9.1.0/8.6.1/8.1.1/7.1.4/7.1.3/6.x/5.0 (Source Analyzer, Data warehousing designer, Mapping Designer, Mapplet, Transformations) Power Exchange 8.1/5.2.2

Business Intelligence: Business Objects XI R2, 6.5/5.0/5.1/4.x (Designer, Supervisor, Reporter & WEBI), Micro strategy 7.1/6.x

Data Modeling: Dimensional Data Modeling, Star Join Schema Modeling, Snow Flake Modeling, FACT and dimensions Tables, Physical and Logical Data Modeling, Erwin 4.2/3.5/3.x

Databases: Oracle 11g/10g/9i/8i, SQL, PL/SQL, SQL*Plus, SQL*Loader, Siebel, IBM DB2 UDB 8.1/7.0, SQLServer 2008/2005/2000/7.0/6.5, Teradata V2R5/V2R4/V2R3 MS Access 7.0/2000, Sybase 12.5.3,Netezza 3.2.1

Programming: SQL, Transact SQL, PL/SQL, Perl scripts, Korn Shell scripting, Unix Shell Scripting, C, Java, VBScript, Visual Basic 6.0/5.0/4.0, HTML 4.0, DHTML

SUMMARY

Confidential - Rockville, MD

Senior Data warehouse Developer

Responsibilities:

• Worked as part of teh architect team to develop complete star schema, Snow Flake for teh Phase I of teh Data Warehouse.Perform impact analysis, identifying gaps and code changes to meet new and changing business requirements.
• used Agile/Scrum LEAN development methodologies
• Implemented AGILE Scrum project framework as Phase II.
• Worked with Business Analyst’s and product managers to identify business rules for data migration, parsing design specifications to ETL coding following mapping standards.
• Populated data into staging tables, dimensions and fact tables using type-2 and type-3 strategy from flat files, XML sources, Cobol Copybooks and Relational Sources and applied business logic on transformation mapping for inserting and updating records.
• Developed PL/SQL Procedures, Functions, Packages and SQL scripts.
• Worked with most of teh transformations including lookup, Stored Procedure, SQL transformations and also used Informatica Debugger for identifying transformational errors.
• Involved in performance tuning of teh Mappings, SQL statements, Query optimization, and Explain Plan utilities for Optimum Performance
• Developed data base objects like Materialized views, Sequences, Triggers, Cursors and Stored Procedures for accomplishing teh Complex logical situations and Memory Management
• Applied appropriate field level validations like date validations, Default values for cleansing teh data.
• Worked on session level tasks, control task, email task, assignment, decision and workflow variables for session level processing.
• Registered source tables for change data capture using Power Exchange navigator client tool and validated teh data by database row test.
• Restarting teh power exchange utilities, stopping and starting teh power exchange logger and listener services.
• Monitoring teh space on servers and stopping and restarting teh Informatica integration services whenever needed.
• Labeled Informatica objects and migrated teh objects using Repository Manager to different environments.
• Worked with Informatica tech support group regarding unknown problem.
• Involved in Code reviews and also halped teh production support team in solving complex technical issues.
• Worked on Informatica Data profiling (Profile Manager) for analyzing source data and generating profiling reports.
• Worked on Informatica Data Analyzer for identifying session with errors and to generate error reports.
• Conducted SQL testing for database sources for Insert and Update timestamps, Counts, Data definitions and Error logic for Facts and Reference tables.
• Created test plans, test strategies, setup teh test environment, co-ordinate with teh business analysts and business users to create test data to perform end to end testing.
• Track defects in teh Mercury Quality Center and update status in a timely manner during teh entire phase of teh testing life cycle.
• Used Informatica Scheduler and Unix CRON tab to schedule and run workflows using PMCMD

Environment: Informatica Power Center 9.1/8.6.1, Power Exchange 9.1/8.6.1, Data Profiler 9.1, Data Analyzer 9.1, Windows XP/2003, Sun Solaris, UNIX KSH, Oracle 11g,Sqlserver 2008,Oracle SQL Developer, VSAM files, Flat Files, IBM Mainframe, COBOL files, SQL, PL/SQL. Visio, Clear case, TOAD

Confidential, MD

Senior Informatica Developer

Responsibilities:

• Responsible for requirements gathering from Clients, analyzed teh functional specs provided by teh data architect and created technical specs documents for all teh enhancements.
• Worked with high-volume data, Tuning and troubleshooting of mappings and Created documentation to support for teh Application.
• Migrated raw Oracle and Sqlserver data to Netezza using Fast Loader
• Performed Development at teh crucial piece of work on Oracle PL/SQL Packages, SQL scripts to facilitate teh functionality for teh module.
• Used monitoring tools in UNIX and teh database as part of teh tuning process.
• Converted Oracle and Sqlserver standard SQL’s to ANSI standard for Netezza
• Worked with Connected and Unconnected Stored Procedure for pre & post load sessions
• Created mappings and reusable mapplets from multiple sources including Trizetto Facets (4.5.1 and 4.3) Flat Files, VSAM files and Oracle tables.
• Perform impact analysis, identifying gaps and code changes to meet new and changing business requirements.
• Redesigned and Updated worklets dependencies to accommodate Business needs
• Involved in developing an ETL Change Data Capture data acquisition methods using redo log files for inserts, updates and deletes of data from transaction database to load into Data Warehouse.
• Involved in ODS implementation to ensure dat their is a centralized data store wherein all historical information will be available for analytical processing.
• Tuned performance of Informatica sessions for large data files by increasing block size, data cache size and sequence buffer length.
• Developed PL/SQL Procedures, Functions and Packages and used SQL
• By using Autosys, created teh job, which runs a UNIX script. Teh script in turn runs teh "pmcmd" command to run a workflow.
• Conducted SQL testing for database sources for Insert and Update timestamps, Counts, Data definitions and Error logic for Facts and Reference tables
• Ran various JCL for scheduled workflows, which are kicked from Informatica, which were scheduled and on-demand.

Environment: Informatica 8.6.1, Power Exchange 8.6, SQL server 2008, SQL, PL/SQL, Windows XP/2003, UNIX KSH, Oracle 10g, Oracle SQL Developer,Netezza- Win SQL

Confidential Owings Mills, MD

Senior Informatica Developer

Responsibilities:

• Worked as lead Developer, and led a team of two developers, Responsible for requirements gathering, status reporting, creating various metrics, project deliverables.
• Worked as part of teh architect team to develop complete star schema, Snow Flake for teh Phase I of teh Data Warehouse
• Responsible for requirements gathering from Clients, analyzed teh functional specs provided by teh data architect and created technical specs documents for all teh enhancements.
• Created standard and best practices for Talend ETL components and jobs.
• Assist others in maximizing teh use of Informatica in ETL Preparation of technical specifications for teh development of Informatica Extraction, Transformation and Loading (ETL) mappings to load data into various tables in Data Marts and defining teh ETL standards.
• Worked with high-volume data, Tuning and troubleshooting of mappings and Created documentation to support for teh Application
• Perform impact analysis, identifying gaps and code changes to meet new and changing business requirements.
• Involved in developing an ETL architecture based on Change Data Capture data acquisition methods using redo log files for inserts, updates and deletes of data from transaction database to load into Data Warehouse.
• Involved in CareFirst ODS implementation to ensure dat their is a centralized data store wherein all historical information will be available for analytical processing.
• Created data profiles using Informatica Data profiler to analyze and report on teh data quality to business and take decisions based on teh same.
• Extracted CDC data from Facets using Informatica Power Exchange 8.1 and transformed them to be loaded in ODS tables.
• Performed Development at teh crucial piece of work on Oracle PL/SQL Packages, SQL scripts to facilitate teh functionality for teh module.
• Created Informatica mappings to extract data from Trizetto Facets 4.51 and 4.3 claims databases. Analyzed teh Trizetto Facets 4.51 data model and assist teh Data architecture team to build teh Claims Canonical data model in teh ODS.
• Used monitoring tools in UNIX and teh database as part of teh tuning process(top, sar, dbArtisan, sp monitor, sp sysmon)
• Worked with Connected and Unconnected Stored Procedure for pre & post load sessions
• Created mappings and reusable mapplets from multiple sources including Trizetto Facets (4.5.1 and 4.3) Flat Files, VSAM files and Oracle tables.
• Tuned performance of Informatica sessions for large data files by increasing block size, data cache size and sequence buffer length.
• Developed PL/SQL Procedures, Functions and Packages and used SQL
• Used EXPLAIN PLAN, TKPROF to tune SQL queries. Created Test scripts, prepared Unit Test Report to document teh testing performed.
• By using Autosys, created teh job which runs a UNIX script. Teh script in turn runs teh "pmcmd" command to run a workflow.
• Assist teh testing team to understand teh Facets Claim adjudication process in order to ensure dat they prepare valid test scenarios
• Conducted SQL testing for database sources for Insert and Update timestamps, Counts, Data definitions and Error logic for Facts and Reference tables
• Created test plans, test strategies; setup teh test environment, co-ordinate with teh business analysts and business users to create test data to perform extensive testing.
• Perform QA and Code review for my code and other developers code co-ordination with client side IT Team and business users
• Track defects in teh Mercury Quality Center tool and update status in a timely manner during teh entire phase of teh testing life cycle.
• Ran various JCLs for scheduled workflows which are kicked from Informatica which were scheduled and on-demand.

Environment: Informatica Power Center 8.6.1/8.1.1, Power Exchange 8.1, Windows XP/2003, UNIX KSH, Oracle 10g,Sqlserver 2008, Oracle SQL Developer, Trizetto FACETS 4.51/4.31, DB2 UDB 8.1, VSAM files, Flat Files, IBM Mainframe, COBOL files, JCL, SQL server 2005, SQL, PL/SQL.

Confidential - Auburn Hills MI

Senior Informatica Developer

Responsibilities:

• Analyze teh source systems data and teh current reports at teh client side to gather teh requirements for teh Data Warehouse Data Model.
• Worked as Team lead, and led a team of two developers, Responsible for requirements gathering, status reporting, creating various metrics, project deliverables
• Was responsible for teh timely and quality delivery of teh ETL code and all related documents for Confidential .
• Collected Business Analysis and Requirements by working with teh business end users.
• Designed ETL Detailed Design document, which is a guideline to ETL Coding.
• Passed higher-level model/design into Informatica ETL code.
• Involved in designing an error handling strategy for data validation, error reporting.
• Experience in loading high-volume data, Tuning and troubleshooting of mappings and Created documentation to support for teh Application
• Populated data into staging tables from flat files, XML sources, Cobol Copybooks and Relational Sources and applied business logic on transformation mapping for inserting and updating records.
• Worked with DTD’s (document type definition), which are teh source definitions for teh XML.
• Involved in optimizing very large data loads.
• Created shell scripts/Perl scripts for better handling of incoming source files like moving file from one directory to another directory, extracted information from file names such as date for continuously incoming source.
• Using Informatica Designer designed Mappings dat populated teh Data into teh Target Star Schema on Oracle 10G Instance.
• Conducted SQL testing for DB sources for Insert and Update timestamps, Counts, Data definitions, Control, and Error logic for Facts and Reference tables.
• Involved in performance tuning of teh Mappings, SQL statements, Query optimization, and Explain Plan utilities for Optimum Performance and used Informatica Debugger.
• Used data base objects like Materialized views, Sequences, Triggers, Cursors, Parallel Partitioning and Stored Procedures for accomplishing teh Complex logical situations and Memory Management.
• Involved in migrating teh Mappings, Sessions, Workflows from Test environment to Production environment.
• Applied appropriate field level validations like date validations, Applying Default values for cleansing teh data.
• Used Perl Script to integrate with Informatica and utilized Perl database modules for very rigorous error checking and logging of data loads.
• Made enhancements to Perl scripts to call Informatica jobs and handle French characters.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Prepared Unit Test Plans. and Performed Negative testing, positive testing and field to field data validations.
• Log, track and solve teh issues after moving teh code to QA and Production.
• Helped teh production support team in solving complex technical issues.
• Implemented teh Slowly Changing Dimension strategy for teh Warehouse.

Environment: Informatica Power Center 8.1.1, Sun Solaris 2.7, Oracle 10g,Erwin 4.2,Toad, PL/SQL, UNIX Shell Script /Perl scripts, Business objects XI R2, Visio, Clear case, Windows XP, HP-UNIX.

Confidential, Columbus OH

Senior Datawarehouse developer

Responsibilities:

• Was responsible for teh design, development, and support of extraction, transformation and loading following all teh standards and best practices.
• Performed data analysis on teh source data.
• Atomic and Mart load was done on tables created in DB2 UDB 8.1
• Identified business rules for data migration, parsing high-level design specs to simple ETL coding and mapping standards.
• Worked on complete SDLC from Extraction, Transformation and Loading of data using Informatica.
• Designed new database tables to meet business information needs. Designed ETL Detailed Design document, which is a guideline to ETL Coding.
• Loaded teh data from Ms SQL Server 2005 and Sybase 12.5.3 to DB2 UDB 8.1 staging area using Informatica Power Center 8.1.1
• Worked on Informatica Power Center 8.1.1 tool - source analyzer, warehouse designer, mapping designer, workflow manager, mapplets, and Reusable Transformations.
• Used Informatica Designer to design mappings dat populated teh Data into teh target star schema on IMB DB2 db 8.1 instances.
• Understood teh business needs and implemented teh same into a functional database design.
• Optimized query performance, session performance and reliability.
• Extensively used router, lookup, aggregator, and expression and update strategy transformations.
• Set Standards for naming conventions and best practices for Informatica Mapping Development.
• Tuned teh Mappings for optimum performance, dependencies and batch design.
• Created teh batch design and scheduled teh batches to run under teh Window time.
• Designed teh slowly changing dimension strategy for teh Warehouse.
• Used Autosys as teh scheduling tool for scheduling jobs.
• Used shell scripts/ Perl scripts for post session operations
• Used session level tasks, control task, email task, assignment, decision and workflow variables for session level processing.
• Prepared and documented teh Unit/Integration Test cases
• Involved in UAT, Defect management, system testing phases of teh project.
• Assisted Support team in completing design and code review.
• Helped teh production support team in solving complex technical issues

Environment: Informatica Power Center 8.1.1, Sun Solaris 2.7, Ms SQL Server 2005, Sybase 12.5.3 IBM DB2 UDB 8.1, Perl scripts Administrator, Agent, Architect, Informatica Power Exchange 5.2.2 Change Data Capture (CDC), Intelligence Server, AQT, Transact SQL, PL/SQL, Erwin 4.2, Trillium, Autosys, Windows XP, HP-UNIX.

Confidential, Columbus, OH

Informatica Developer

Responsibilities:

• Created mappings using teh transformations such as teh Source qualifier, Aggregator, Expression, Lookup, Router, Filter, Rank, Sequence Generator, update Strategy.
• Developed and managed automated batch job schedules using Maestro.
• Developed Unix Shell Scripts to download files from teh mainframe, file checking, directory cleanup, file backups and execute jobs for batch processing.
• Extensively worked on Oracle Stored Procedures and also Teradata SQL.
• Involved in creating scripts for loading data from flat files to database tables, FTP process and Net change process.
• Performed tuning and optimization of mappings and sessions.
• Responsible for teh Code Review of teh team and also for teh migration of teh code.
• Followed & Implemented Nationwide Standards for BI & DW at various levels of teh SDLC.
• Major responsibilities included writing Test plans, creating Test scripts, team co-ordination and technical writing / Documentation during Manual Testing.
• Involved in loading high-volume data, Tuning and troubleshooting of mappings and Created documentation to support for teh Application
• Used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformations, Informatica Repository Manager and Informatica Server Manager.
• Teh objective is to extract data stored in different databases such as Oracle, SQL Server and to load finally into a single data warehouse repository, which is in Netezza 3.2.1 and Teradata.
• Developed and implemented various enhancements to teh application in teh form of production and new production rollouts.

Environment: Informatica 7.1.4, Oracle 10g, Netezza 3.2.1, Teradata V2R5, UNIX/PERL/SHELL scripting, Autosys, Configuration management (Harvest), WinSql, TOAD.

Confidential

ETL Developer

Responsibilities:

• Developed an understanding and converted teh financial hierarchy for Fact and Dimensions fields for ETL team to create teh mapping.
• Worked on PowerCenter client tools including Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Involved in designing teh procedures for getting teh data from all systems to Data Warehousing system.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Created mappings with different kinds of transformations like Source Qualifier, Aggregators, Lookups, Filters, Sequence Generator, Stored Procedure, and Update Strategy Transformations.
• Created and used Reusable Transformations to improve maintainability of teh mappings.
• Created various Reusable tasks in teh Task Developer and Non-Resuable tasks (Session).
• Created and used different tasks such as Decision and Email tasks.
• Monitored teh sessions dat were running, scheduled, completed and failed.
• Performance tuned teh Informatica Repository and Mappings for optimum performance.
• Used Informatica Server Manager to create, schedule, monitor sessions and send pre and post session emails to communicate success or failure of session execution.
• Involved in teh design and building of teh Universes, Classes, and Objects for teh client requirements.
• Created various standard reports and queries based on teh existing classes and objects.
• Resolved loops in Universe by creating Aliases and Contexts.
• Involved in teh troubleshooting of teh universe schema with loops and cardinality problems.

Environment: Informatica PowerCenter 6.2 (Source Analyzer, Data warehousing Designer, Mapping Designer, Mapplet, Transformations), Oracle8i, FlatFiles, ERwin, SQL, PL/SQL, HP-UX, Windows 2000/NT, Business Objects 5.0.

Confidential

Data warehouse Developer

Responsibilities:

• Designed and built Data Marts for Power, Gas and Turbines and underwriting divisions.
• Created temporary repository for already migrated database for system analysis.
• Using Informatica Designer designed and developed Source Entities for, MS SQL Server 2000 and Target Warehouse Entity for Oracle.
• Developed Mapplets using corresponding Source, Targets and Transformations.
• Test all applications and transport teh data to target Warehouse Oracle tables on teh server, Schedule and Run Extraction and Load process and monitor sessions by using Informatica Server Manager.
• Created Sessions and batch management and Performance Tuning and initial testing followed by teh volume testing, resolve technical issues with software consultants and vendors.
• Used shell scripts for post session operations
• Evaluate BI tools like Cognos, Brio and Micro strategy for Reporting Needs.
• Written SQL Stored procedures and Shell Scripts to access data from MS SQL Server 2000.
• Setting of Error Logic for streamlining and automating teh data loads for cleansing and trapping incorrect data on staging servers and tan loading it to teh data warehouse.
• Customer interaction and User Training for on going Maintenance.
• Analysis of Source, existing OLTP system and Identification of required dimensions and facts from teh Database.
• Identify business rules for data migration and Perform data administration through data models and metadata.
• Design new database tables to meet business information needs. Design of a Mapping Specification and creating multidimensional models.
• Star Schemas are designed using ERWIN 3.5

Environment: Informatica 6.2/7.1.1,Business Objects 5.0, web intelligence 2.x, Micro strategy, Oracle 8i, MS SQL Server 2000, PL/SQL, SQL*Plus, SQL*Loader, Erwin 3.5, Windows NT 4.0, AIX

Confidential

Data warehouse developer

Responsibilities:

• Analyzed teh source data coming from Flat files and worked with business users.
• Used UTL File Packages to Load data from Flat files to Oracle Tables
• Extensively worked with Normalizer Transformation and other common transformations
• Created reusable Mailing alerts, events, Tasks, Sessions, reusable worklets and workflows in Workflow manager and used parameters and variables at mapping and session levels to tune teh performance
• Identified data source systems integration issues and proposing feasible integration solutions.
• Partnered with Business Users and DW Designers to understand teh processes of Development Methodology, and tan implement teh ideas in Development accordingly.
• Created Oracle PL/SQL queries and Stored Procedures, Packages, Triggers (for data security), Cursors and backup-recovery for teh various tables.
• Customized data by adding calculations, summaries and functions.
• Involved in PL/SQL Debugging and support

Environment: Informatica Power center 5.0, Oracle 8i, MS Access 2000, Toad, Cognos, Ultra Edit, UNIX AIX 5.1