SUMMARY:

• Dynamic, result oriented Technical design developer with 12 years of software life - cycle experience Data Warehouse, Business Intelligence and Client Server applications.
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL).
• Team player, Excellent Interpersonal Skills and self-starter, capable of working independently and motivate a team of professional.
• Over 9 years of strong data processing experience in implementing Data Warehousing and Data Mart applications, mainly Transformation processes using ETL tool INFORMATICA POWER CENTER 1.6/1.7/5.1/6.2/7.1.3/8.1.1/9.1.0/9.5.1 , POWERMART 4.6/4.7/5.1/6.2 , Business Objects 5.0/ 5.1/5i, Web Intelligence 2.5/2.6, ORACLE 11.x/10.x/9.x/, SQL Server 6.5/7.0, MS Access, DB2 UDB, Teradata 12,SQL, PL/SQL, SQL*Plus, UNIX Shell Scripting,
• Extensively work in ETL process consisting of data transformation, data sourcing, mapping, conversion and loading.
• Extensive experience in implementation of Data Cleanup procedures, transformations, Scripts, Stored Procedures and execution of test plans for loading the data successfully into the targets.
• Proficient in understanding business processes / requirements and translating them into technical requirements.
• A Team Player with excellent communication, analytical, verbal and writing skills.
• Good Experience in software development of application software in areas of Insurance, Finance and Pharmaceutical Environments.

TECHNICAL SKILLS:

Operating Systems: WINDOWS NT 4.0, UNIX, MVS/ESA, OS/390, HP-UX, SUN SOLARIS 2.6/2.7/2.8(Sun-Ultra, Sun-Spark, Sun Classic)IBM AIX 4.2/4.3, Windows 95/98/2000 and DOS

Database: ORACLE 11g/10g/9i/ 8i/8.0/7.3, DB2 UDB and SQL SERVER 8.0/7.0/6.5

Languages: SQL, SQL PLUS, PL/SQL, XML, HTML 4.0, DHTML, Shell Scripting

Data Warehousing Tools (ETL): Informatica PowerCenter 4.7/5.1.2/6.2/7.1.3/8.1.1/9.1.0/9.5.1 , Powermart 5.1.2/6.2, Power Exchange 9.1, Data Quality 9.1, TDM 9.5.1, Power Exchange 9.1.0(Sales Force)

Business Intelligence Tools: Business Objects 5.0/5i, Web Intelligence 2.6, Crystal Reports 6.5

Data Modeling Tools: Platinum ERwin 3.5

GUI: FORMS 4.5/5.0, REPORTS 2.5/3.0, VISUAL BASIC 5.0/6.0, Developer 2000

Exposed to: Microstrategy 8.0, TERADATA

Tools: TOAD, DB2 Command Center Microsoft Query and WINSQL

Methodologies: STAR SCHEMA, SNOWFLAKE

Professional Work Experience

Sr. Informatica Developer

Confidential, Washington, DC

Responsibilities:

• Involved in Design and develop the architecture for all tool integration strategy; source system data ETL strategy, data staging, movement and aggregation, information and analytics delivery and data quality strategy
• Involved to drive the solution approach to data schema development, business rules, data design and migration processes for the team. Also provided standards, guidelines, processes and expertise to consistently address recurring data issues including data convergence, data standards and data synchronization.
• Ensure technology solutions in Production are monitored and assessed for performance and sustainability through
• Responsible for the planning, designing and developing an Informatica ETL solution using Informatica objects such as Mappings, Mapplets.
• Produce detail design document, low level design document and involved in code/document review. Participated in the maintenance and enhancement of the application and perform bug fixing
• Designed and developed ETL mappings to load, transform data from source to Target using Informatica Power Center 9.5.1
• Worked extensively on different types of transformations like source qualifier Transformation, expression, Aggregator, Router, filter, update strategy, lookup, sorter, joiner and sequence generator.
• Tested all the business application rules with test & live data and automated, monitored the sessions using Work Flow Manager and Workflow Monitor
• Created, launched & scheduled Workflows/sessions. Involved in the Performance Tuning of Mappings and Sessions
• Managing timely written and verbal communication on project progress, load status, issue tracking, and concerns for management attention and/or escalation. Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Provided knowledge transfer to the end users and created extensive documentation on the design, development implementation, daily loads and process flow of the mappings
• Created effective test data, developed and performed thorough Unit test cases to ensure successful execution of the data loading processes.

Environment: Informatica PowerCenter 9.5.1, SQL Server 2014, Unix Shell Scripts, Rational Team Concert Eclipse, Control-M 7.0 and Sun Solaris 9.0

Sr. Informatica Developer

Confidential, Washington, DC

Responsibilities:

• Participated in the entire requirements engineering process right from requirements elicitation phase to the phase involving documenting of the requirements.
• Involved in Design and develop the architecture for all tool integration strategy; source system data ETL strategy, data staging, movement and aggregation, information and analytics delivery and data quality strategy
• Involved to drive the solution approach to data schema development, business rules, data design and migration processes for the team. Also provided standards, guidelines, processes and expertise to consistently address recurring data issues including data convergence, data standards and data synchronization.
• Ensure technology solutions in Production are monitored and assessed for performance and sustainability through
• Responsible for the planning, designing and developing an Informatica ETL solution using Informatica objects such as Mappings, Mapplets.
• Produce detail design document, low level design document and involved in code/document review. Participated in the maintenance and enhancement of the application and perform bug fixing
• Designed and developed ETL mappings to load, transform data from source to Target using Informatica Power Center 9.5.1
• Worked extensively on different types of transformations like source qualifier Transformation, expression, Aggregator, Router, filter, update strategy, lookup, sorter, joiner and sequence generator.
• Tested all the business application rules with test & live data and automated, monitored the sessions using Work Flow Manager and Workflow Monitor
• Created, launched & scheduled Workflows/sessions. Involved in the Performance Tuning of Mappings and Sessions
• Responsible for designing and implementing consistent strategic data privacy / data masking solution using ILM Test Data Management
• Managing timely written and verbal communication on project progress, load status, issue tracking, and concerns for management attention and/or escalation. Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Provided knowledge transfer to the end users and created extensive documentation on the design, development implementation, daily loads and process flow of the mappings
• Created effective test data, developed and performed thorough Unit test cases to ensure successful execution of the data loading processes.

Environment: Informatica PowerCenter 9.5.1, Test Data Management 9.5.1( ILM Data Subset, Data Masking), PL/SQL, SQL, Unix Shell Scripts, F-Secure SSH 5.3, Control-M 7.0 and Sun Solaris 9.0

Lead Informatica Developer/Admin

Confidential, Washington, DC

Responsibilities:

• Participated in the entire requirements engineering process right from requirements elicitation phase to the phase involving documenting of the requirements.
• Involved in Design and develop the architecture for all data warehousing components e.g. tool integration strategy; source system data ETL strategy, data staging, movement and aggregation, information and analytics delivery and data quality strategy.
• Reviews new and existing systems design projects and procurement plans for compliance with standards and architectural plans. Ensures that solutions across platforms adhere to the enterprise architectural road map and support both short-term tactical plans as well as long-term strategic goals.
• Implemented ETL standards and best practices while naming Mappings, Transformations, links, Sessions, Workflow names, file names etc.
• Developed ETL mappings, transformations using Informatica Power Center 9.5.1
• Extensively used ETL to load data from Oracle, Flat Files, SalesForce to Oracle, Flat Files, SalesForce.
• Used Informatica Debugger to validate and test the business logic implemented in the mappings and fix the bugs. Developed reusable Mapplets and Transformations.
• Created complex Informatica mappings to load the data Warehouse and monitored them. The mappings involved extensive use of transformations like source qualifier, expression, Router, aggregator, update strategy, lookup, sequence generator, joiner and Union.
• Configured Informatica mappings, to handle the updates to preserve the existing records using Update Strategy Transformation.
• Tested all the business application rules with test & live data and automated, monitored the sessions using Work Flow Manager and Workflow Monitor
• Created, launched & scheduled Workflows/sessions. Involved in the Performance Tuning of Mappings and Sessions
• Managing timely written and verbal communication on project progress, load status, issue tracking, and concerns for management attention and/or escalation. Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Used BTEQ and SQL Assistant (Query man) front-end tools to issue SQL commands matching the business requirements to Teradata RDBMS
• Created effective test data, developed and performed thorough Unit test cases to ensure successful execution of the data loading processes.
• Software installation/configuration, object migration and performance tuning/optimization, perform upgrades and apply hot fixes, Backup/Recovery of Informatica software, repository and configurations, server maintenance including troubleshooting server issues and performance monitoring and tuning.
• Setup appropriate ETL administration best practices and procedures. Provided technical support for the Informatica environment, worked with infrastructure teams to ensure an effective operating environment including throughput, repository sizing, capacity planning, monitoring and maintenance
• Code/folder migration from one environment to another as part of release management

Environment: Informatica -Power Center 9.5.1, Oracle 11g, Teradata (v2R5, 12), SQL, Toad 9.0, Unix Shell Scripts, Control-M, B2B Data Transformation 9.1.0, Data Quality 9.1.0, Power Exchange 9.1.0(Sales Force), Toad 9.7, Data Profiling, SQL, Unix Shell Scripts, F-Secure SSH 5.3 and

Sr. Data Warehouse Developer

Confidential, Washington, DC

Responsibilities:

• Involved in the requirement definition and analysis in support of Data Warehousing efforts.
• Involved in design and development of interfaces, and transactional logic, design and code reviews.
• Implemented ETL standards and best practices while naming Mappings, Transformations, links, Sessions, Workflow names, file names etc.
• Developed ETL mappings, transformations using Informatica Power Center 7.1.3
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Extensively used ETL to load data from Sybase, Flat Files and Oracle to Oracle
• Extensively wrote user-defined SQL coding for overriding for Auto generated SQL query in Source Qualifier Transformation.
• Used Informatica Debugger to validate and test the business logic implemented in the mappings and fix the bugs.
• Developed reusable Mapplets and Transformations.
• Created complex Informatica mappings to load the data Warehouse and monitored them. The mappings involved extensive use of transformations like source qualifier, expression, Router, aggregator, update strategy, lookup, sequence generator, joiner and Union.
• Configured the mappings to handle the updates to preserve the existing records using Update Strategy Transformation.
• Created, launched & scheduled sessions. Involved in the Performance Tuning of Informatica mappings and sessions
• Setting up Workflow, Tasks, Worklets and sessions to schedule the loads at required frequency using Power Center WorkFlow manager.
• Involved in Unit Testing and System Testing.
• Created, updated and maintained ETL technical documentation.

Environment: Informatica- Power Center 7.1.3, Sybase, Oracle 9i, SQL, STAR Schema, Toad 7.0, AIX 4.3, Unix Shell Scripts, Smart FTP v 1.5 and Sun Solaris 11i

Data Warehouse Developer

Confidential, Indianapolis, IN

Responsibilities:

• Involved in the requirement definition and analysis in support of Data Warehousing efforts.
• Worked on complete Software Development Life Cycle (SDLC) from Extraction, Transformation and Loading of data using Informatica.
• Developed ETL mappings, transformations using Informatica Power Center 7.1.3.
• Developed data Mappings between source systems and warehouse components using Mapping Designer
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Used Debugger to test the mappings and fix the bugs.
• Extensively used ETL to load data from Flat Files and Oracle to DB2 UDB and Flat Files
• Created reusable Mapplets using Mapplet Designer and reusable Transformations.
• Involved in the Performance Tuning of Informatica mappings and sessions.
• Setting up Workflow, Tasks and sessions to schedule the loads at required frequency using Power Center WorkFlow manager.
• Involved in the Unit testing for the validation of data.
• Involved in generating reports using Business Objects.
• BO Universes and Reports to validate the data movement between the various stages from Source to Staging and Data Warehouse.

Environment: Informatica-Power Center 7.1.3, Oracle 10g, DB2 UDB 7.0, Business Object 6.1, SQL, STAR Schema, Toad, Sun Solaris 2.8, HP-UX 11i and Windows NT

Data Warehouse Developer

Confidential, Bloomington, IL

Responsibilities:

• Consolidate data from various departments into the data warehouse by identify the common data and solve the discrepancy on data values and created various data marts.
• Developed ETL mappings, transformations using Informatica Power Center 7.1.1
• Extensively used ETL to load data from Flat Files and Oracle to DB2 UDB and Flat Files
• Developed reusable Mapplets and Transformations.
• Developed data Mappings between source systems and warehouse components using Mapping Designer
• Worked extensively on different types of transformations like source qualifier, expression, filter, aggregator, rank, update strategy, lookup, sequence generator, joiner.
• Created, launched & scheduled sessions. Involved in the Performance Tuning of Informatica mappings and sessions
• Setting up Workflow, Tasks, Worklets and sessions to schedule the loads at required frequency using Power Center WorkFlow manager.
• Providing the data for the other teams for their development and testing
• Designed and developed transformation rules (business rules) to generate consolidated data using Informatica ETL (Power center) tool.
• Used Informatica repository manager to backup and migrate metadata in development and Test systems.
• Involved in Unit Testing and System Testing. Extensively interacted with user and Involved in requirement gathering, prototyping and prepared various documents like Interface Requirement Document, Customer Requirement document, Integration test plan, Unit test plan, Release notes etc.

Environment: Informatica-Power Center 7.1.1, DB2 UDB 7.2, Oracle 9i, SQL, STAR Schema, Toad, AIX 4.3, HP-UX 11i and Windows 2000

ETL-Informatica Developer

Confidential, Itasca, IL

Responsibilities:

• Developed Extracts using shell scripts from WMS, RMS and HRS database for the Data warehouse.
• Developed Complex mapping to build Enterprise Data Warehouse and Data Marts.
• Developed ETL mappings, transformations using Informatica Power Center 6.2
• As a ETL developer handled the full building of the Warehouse Management System, RMS and HRS module of the Datawarehouse based on third party Brightpoint system
• Extensively used ETL to load data from Flat Files, DB2 UDB to DB2UDB and Oracle
• Developed data Mappings between source systems and warehouse components using Mapping Designer
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Worked extensively on different types of transformations like source qualifier, router, normaliser, expression, filter, aggregator, rank, update strategy, lookup, stored procedure, sequence generator and joiner.
• Created, launched & scheduled Sessions/Workflows. Involved in the Performance Tuning of Informatica.
• Created session in Informatica to load data from flat files obtained from Convergys
• Troubleshoot the connectivity problems. Looked up and read session, event and error logs for troubleshooting.

Environment: Informatica-Power Center 6.2, DB2 UDB 7.2, Oracle 8i, SQL, STAR Schema, WINSQL, SQL Navigator, Unix Shell Scripts, AIX 4.3, SUN Solaris 2.8, CuteFTP, Windows 2000 and WINDOWS XP

Informatica Developer

Confidential, Bloomington, IL

Responsibilities:

• Analyzed the systems, met with end users and business units in order to define the requirements.
• Power Connect for mainframes is used as an interface between Mainframes and Informatica
• Developed ETL mappings, transformations using Informatica Power Center 5.1.2/6.0
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Server Manager/Workflow Manager.
• Extensively used ETL to load data from COBOL Flat Files and Oracle to DB2, COBOL Flat Files
• Developed and implemented Error Handling Strategies.
• Created, launched & scheduled sessions. Involved in the Performance Tuning of Database and Informatica.
• Setting up Workflow, Tasks, Worklets and sessions to schedule the loads at required frequency using Power Center WorkFlow manager.
• Involved in Unit Testing and System Testing.

Environment: Informatica-Power Center 5.1.2/6.0, Power Connect for Mainframes ( STRIVIA DETAIL3.1), DB2 UDB 7.0, Oracle 8i, SQL, STAR Schema, UNIX Shell Scripts, AIX 4.3, Microsoft Query and Windows 2000

Confidential

Responsibilities:

• Responsible for system study, finding user requirements, system design.
• Responsible for development, testing, implementing the system.
• Wrote triggers, procedures to develop different types of reports.
• Reports are generated using Oracle PL/SQL and Report Writer 2.5

Environment: Oracle 8.0 using Developer/2000(Forms 4.5, Reports 2.5), PL/SQL, SQL*Plus, Windows NT