Summary:

• Dynamic, result oriented Technical design developer with 14 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,DataMarts and IODS 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 11 years of strong data processing experience in designing and implementing Data Warehouse and Data Mart applications, mainly Transformation processes using ETL tool INFORMATICA POWER CENTER 1.6/1.7/5.1/6.2/7.1.4/8.x/9.0.1,B2B Data Transformation 9.0.1,Test Data Management 9.0.1,Data Quality 9.0.1,POWER EXCHANGE 8.5(CDC),ORACLE 10g/ 9i/ 8.x, Sybase, SQL Server 6.5/7.0, MS Access, DB2 UDB, SQL, PL/SQL, SQL*Plus, SQL*Loader, SQL Navigator, UNIX Shell Scripting, Crystal ReportsandDeveloper 2000.
• Expertise in implementing Oracle BI Apps in all phases like implementing Out of order Box(Vanilla mappings) prebuilt mappings, Designing ETL and metadata management using DAC
• Extensively work in ETL process consisting of data transformation, data sourcing, mapping, conversion and loading.
• Proficient in understanding business processes / requirements and translating them into technical requirements.
• Good Experience in software development of application software in areas of Finance, Insurance, Education, Federal
• Government, Health and Manufacturing Environments

Informatica Certified Professional
PUBLIC TRUST CLEARANCE (BI LEVEL6)

Operating Systems :WINDOWS NT 4.0, UNIX, LINUX v 2.4.36, 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/2000andDOS
Database :ORACLE 10g/9i/ 8i/8.0/7.3, DB2 UDB, DB2 EEE, Teradata 12.0, SQL  SERVER 7.0/6.5, WATSON, MS Access 7.0, INFORMIX, Sybase
Languages :SQL, SQL PLUS, PL/SQL, COBOL, JCL, XML, JavaScript, HTML 4.0, DHTML, SHELL Scripting 
Data Warehousing Tools (ETL): INFORMATICA POWERCENTER 1.7/5.x/6.x/7.x/8.6.1/9.0.1,B2B Data Transformation 9.0.1,Data Quality 9.0.1,Test Data Management 9.0.1,POWERMART 4.7/5.1.2/6.2,Power Exchange 8.5, Power Channel, Power Connect for Salesforce.com and Power Connect for SAP R/3
Business Intelligence Tools :BUSINESS OBJECTS XI/5i, WEB INTELLIGENCE 2.6, CRYSTAL REPORTS 6.5
Data Modeling Tools :Platinum Erwin 3.5, CA ERwin 4.0 and SELECTSE 
GUI : FORMS 4.5/5.0, REPORTS 2.5/3.0, VISUAL BASIC 5.0/6.0 Developer 2000 
Tools :BTEQ, SQL Assitant,SQL NAVIGATOR, SQL*Loader, SQL-Programmer, WINSQL,  TOAD and Microsoft Query
Methodologies : STAR SCHEMA, SNOWFLAKE
Exposed To : Trillium, BO DATAINTEGRATOR 11.7.2, First Logic

Lead ETL Solution Engineer/Informatica Admin November 2010 To Tilldate

Confidential, New Carrolton MD

Solution Engineer/Developer 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
• Involved to drive the solution approach to data schema development, business rules, data design and migration processes for theteam. Also provided standards, guidelines, processes and expertise to consistently address recurring data issues including data convergence, data standards and data synchronization.
• Identifying ETL specification based on Business Requirements/Mapping Document. Formulating and documenting ETL process design. Participated and lead research and development efforts (proof\'s of concept, prototypes), as subject matter experts, with new technologies.
• 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.
• Ensure technology solutions in Production are monitored and assessed for performance and sustainability through
• periodic health checks (such as capacity planning, incident and problem reviews)
• Responsible for the planning, designing and developing an Informatica ETL solution using Informatica objects such as Mappings, Mapplets.
• Worked with business owners, analysts, solution engineers, development teams and infrastructure services to communicate application and data architectures.
• Provided expert advice, counsel and technical expertise to the project team to help assure that Informatica solutions are designed and developed in the optimal manner and in accordance with industry and Informatica best practices
• 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
• Developed ETL mappings, mapplets and transformations using Informatica Power Center 9.0.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
• Involved in automating the Informatica process by using Unix Shell Script.
• Managing timely written and verbal communication on project progress, load status, issue tracking, and concerns for managementattention and/or escalation. Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Created effective test data, developed and performed thorough Unit test cases to ensure successful execution of the data loading processes.

Administrator Responsibilities:

• 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.
• Migration of Informatica Power Center mappings, Workflows, Sessions and Shared Objects.
• 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
• Identifies, researches, and resolves ETL root cause of production issues or system problems.
• Code/folder migration from one environment to another as part of release management
• Maintain Relational Database connections with the assistance of DBAs.

Environment

Informatica PowerCenter 9.01,B2B Data Transformation 9.0.1,Data Quality 9.0.1,Test Data Management 9.0.1,Toad 9.7,Data Profiling,SQL, Unix Shell Scripts, F-Secure SSH 5.3 and Sun Solaris 9.0

Project: Confidential 
Responsibilities:

• Worked with functional and technical project leads, marketing, sales, finance, and other business groups to identify, analyze and document business requirements.
• Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents.
• Involved in customizing out of the box reports to support the business requirements.
• Managing timely written and verbal communication on project progress, load status, issue tracking, and concerns for managementattention and/or escalation.
• Provided expert advice, counsel and technical expertise to the project team to help assure that Informatica solutions are designed and developed in the optimal manner and in accordance with industry and Informatica best practices.
• Involved in configuring sources, targets, tasks and execution plans using DAC.
• Implemented ETL standards and Best Practices while naming Mappings, Transformations, links, Sessions, Workflow names, file names etc.
• Involved in Informaticacode migrations and monitoring according to Informatica standards
• Developed ETL mappings, mapplets and transformations using Informatica Power Center 8.6.1
• Prepared Unit Test plan and efficient unit test documentation was created along with Unit test cases for the developed code.
• Involved in automating the Informatica process by using Unix Shell Script.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.

Environment

Informatica PowerCenter 8.6.1,Oracle Business Intelligence suite 10.1.3.4, Oracle BI Apps 7.9.6/7.9.5,DAC, Toad 9.7,Data Validation Option, Metadata Manager 8.6.1,Data Profiling, Data Validation Option Tool, Data Analyser,SQL, Unix Shell Scripts, F-Secure SSH 5.3 and Sun Solaris 9.0

Sr Informatica (ETL) Developer/Informatica Administrator April 2009 To August 2010 

Confidential, Baltimore

Developer Responsibilities:

• Participated in the entire requirements engineering process right from requirements elicitation phase to the phase involving documenting of the requirements.
• Identifying ETL specification based on Business Requirements/Mapping Document. Formulating and documenting ETL process design.
• Reviewed data models using Erwin tool to find out data model dependencies.
• Implemented ETL standards and Best Practices while naming Mappings, Transformations, links, Sessions, Workflow names, file names etc.
• Involved in Informaticacode migrations and monitoring according to Informatica standards
• Developed ETL mappings, mapplets and transformations using Informatica Power Center 8.6.1
• Created mappings using Informatica Designer to build business rules to load data and tuned them to enhance the performance
• Converted PL/SQL procedures into Informatica mappings using various transformations.
• Extensively used ETL to load data from Flat Files, Oracle and Teradata to Teradata
• Worked extensively on different types of transformations like source qualifier Transformation, expression, Aggregator, Router, filter, update strategy, lookup, sorter, joiner and sequence generator.
• Extensively wrote user-defined SQL coding for overriding for Auto generated SQL query in Source Qualifier 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
• Migrated mappings and sessions and work flows from dev/test to production environment.
• Expertise in writing BTEQ scripts in Teradata and running them by using shell scripts in Solaris environment.
• Involved in automating the Informatica process by using Unix Shell Script.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Created effective test data, developed and performed thorough Unit test cases to ensure successful execution of the data loading processes.

Administrator Responsibilities:

• Apply Informatica PowerCenter software installation/ upgrades and hot-fixes
• Informatica Server maintenance including troubleshooting server issues and performance monitoring and tuning.
• Software installation / configuration, object migration and performance tuning / optimization.
• Migration of Informatica Power Center mappings, Workflows, Sessions and Shared Objects.
• Setup appropriate ETL administration best practices and procedures.
• Identifies, researches, and resolves ETL root cause of production issues or system problems.
• Code/folder migration from one environment to another as part of release management
• Work with the System Admin staff on physical optimizations.
• Maintain Relational Database connections with the assistance of DBAs.

Environment

Informatica PowerCenter 8.6.1, Teradata 12.0,Oracle 10g, Data Validation Option, Toad 9.6.1,Metadata Manager 8.6.1,Data Profiling, Data Validation Option Tool, Data Analyser,SQL,PL/SQL, Unix Shell Scripts, SQL Navigator 4.5, BTEQ, SQL Assistant, F-Secure SSH 5.3 and Sun Solaris 9.0

Sr Informatica (ETL) Developer Nov 2008 to April 2009 

Confidential, Washington DC

Responsibilities:

• Involved in design and development of interfaces, transactional logic, design and code reviews.
• Identifying ETL specification based on Business Requirements/Mapping Document. Formulating and documenting ETL process design.
• Implemented ETL standards and Best Practices while naming Mappings, Transformations, links, Sessions, Workflow names, file names etc.
• Developed ETL mappings, mapplets and transformations using Informatica Power Center 8.1.5
• Created mappings using Informatica Designer to build business rules to load data and tuned them to enhance the performance
• Converted PL/SQL procedures into Informatica mappings using various transformations.
• Extensively used ETL to load data from Oracle to ORACLE
• Worked extensively on different types of transformations like source qualifier Transformation, expression, Aggregator, Router, filter, update strategy, lookup, sorter, joiner and sequence generator.
• Extensively wrote user-defined SQL coding for overriding for Auto generated SQL query in Source Qualifier 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
• Migrated mappings and sessions and work flows from dev/test to production environment.
• Involved in automating the Informatica process by using Unix Shell Script.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Involved in Unit Testing and System Testing.Created, updated and maintained ETL technical documentation.

Environment

Informatica-Power Center 8.1.5,Oracle 10g,SQL, STAR Schema, Toad 9.5, Unix Shell Scripts, TortoiseSVN and Sun Solaris

Sr Informatica (ETL) Developer Feb 2008 to Nov 2008 

Confidential, Reston VA

Responsibilities:

• Involved in the requirement definition and analysis in support of IODS Design 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 8.5.1.
• Involved in adding registration group for the Source System tables using PowerExchange CDC 8.5
• Created mappings using Informatica Designer to build business rules to load data and tuned them to enhance the performance
• Extensively used ETL to load data from Flat Files and Oracle to ORACLE,SQL SERVER
• 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
• Migrated mappings and sessions and work flows from dev/test to production environment.
• Troubleshoot connectivity problems. Looked up and read session, event and error logs for troubleshooting
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Involved in Unit Testing and System Testing.Created, updated and maintained ETL technical documentation.

Environment

Informatica-Power Center 8.5.1,Power Exchange 8.5,Oracle 10g, SQL Server 2005, Flat Files ,SQL, STAR Schema, Toad 9.5, Unix Shell Scripts, LINUX v 2.4.36,SecureCRT 4.1.0,Rational Clear Case 7.0.1 and Windows NT

Confidential 
Responsibilities:

• Involved in design and development of interfaces, and transactional logic, design and code reviews.
• Involved as Technical leadership role providing technical direction to technical team members working withInformatica, Providing mentoring and knowledge transfer.
• Track record of successful delivery of conversion data at the individual and team levels, schedule management, resources and issue management.
• Developed ETL mappings, transformations using Informatica Power Center 8.1.5
• Created mappings using Informatica Designer to build business rules to load data and tuned them to enhance the performance
• Extensively used ETL to load data from Flat Files and Oracle to ORACLE,Flat Files
• Worked extensively on different types of transformations like source qualifier Transformation, expression, Aggregator, Router, filter, update strategy, lookup, sorter, joiner and sequence generator.
• Modified several of the existing mappings and created several new mappings based on the user requirement.
• 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.
• 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
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Involved in Unit Testing and System Testing.Created, updated and maintained ETL technical documentation.

Environment

Informatica-Power Center 8.1.5, Oracle 10g, NCR TERADATA 12.0,Flat Files ,SQL, STAR Schema, Toad 8.5, Unix Shell Scripts, PL/SQL,Sun Solaries 9.0 and Windows NT

Lead Informatica (ETL) Developer Jan 2007 To Oct 2007 

Confidential

Responsibilities:

• Involved in understanding requirements, analyze new and current systems to quickly identify required sources and targets
• Involved in the requirement definition and analysis in support of Data Warehouse and Datmart efforts.
• Developed ETL mappings, transformations using Informatica Power Center 7.1.4/8.1
• Created mappings using Informatica Designer to build business rules to load data and tuned them to enhance the performance
• Extensively used ETL to load data from Flat Files, Oracle and DB2to ORACLE
• Developed data Mappings between source systems and warehouse components using Mapping Designer.
• Created, launched & scheduled Workflows/sessions. Involved in the Performance Tuning of Mappings and Sessions
• 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 Datamarts.
• Webi Reports were created and deployed through Info View
• Involved in fixing invalid Mappings, Testing of Informatica Sessions, Batches and the Target Data.
• Troubleshoot connectivity problems. Looked up and read session, event and error logs for troubleshooting
• Written documentation to describe program development, logic, coding, testing, changes and corrections.

Environment

Informatica-Power Center 7.1.4/8.1,Oracle 10g, Db2 UDB 7.1 ,SQL, STAR Schema, Toad 7.3, CUTE FTP,Unix Shell Scripts, Business Objects XI, AIX 5.2 and Windows NT

Lead Informatica (ETL) Developer March 2006 To Jan 2007 

Confidential, Fredericksburg, VA

Responsibilities:

• Involved in understanding requirements, analyze new and current systems to quickly identify required sources and targets
• Involved in preparing detailed ETL Design Documents.
• Involved in the requirement definition and analysis in support of Data Warehouse and Datmart efforts.
• Developed ETL mappings, transformations using Informatica Power Center 7.1.2
• Created mappings using Informatica Designer to build business rules to load data and tuned them to enhance the performance
• Extensively used ETL to load data from Flat Files, Oracle and SQL SERVERto ORACLE,SQL SERVER
• 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 Datamarts.
• Troubleshoot connectivity problems. Looked up and read session, event and error logs for troubleshooting
• Written documentation to describe program development, logic, coding, testing, changes and corrections.

Environment

Informatica-Power Center 7.1.2,Oracle 10g, SQL SERVER 2000 ,SQL, STAR Schema, Toad 7.3, Unix Shell Scripts,Business Object 6.1, First Logic 4.2,HP-UX 11i and Windows NT

Confidential 
Responsibilities:

• Involved in the requirement definition and analysis in support of Data Warehouse and ODS efforts.
• Developed ETL mappings, transformations using Informatica Power Center 7.1.2
• 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 Mainframes, Oracle, ,XML,MQ Series,SAP and Flat Files to Oracle, Flat Files ,Teradata and XML
• Developed data Mappings between source systems and warehouse components using Mapping Designer
• Worked with PWS tool and Test Directory to get SIR’s to analyze and fix the code
• Used Utilities Fast Load and BTEQ

Environment

Informatica-Power Center 7.1.2,TERADATAV2R4, Oracle 9i, XML, Power Connect for MQ Series,Power Connect for SAPR/3 ,SQL, STAR Schema, PWS(Project Workflow System), Toad 7.3, Unix Shell Scripts, HP-UX 11i, Sun Solaris 5.4, WINSQL, Documentum v 7.0 and Smart FTP v 1.5

Responsibilities:

• Involved in the requirement definition and analysis in support of Conversion efforts.
• Developed ETL mappings, transformations using Informatica Power Center 7.1.1
• 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 mainframes, Oracle to DB2UDB and Oracle.
• Worked with PWS tool and Test Directory to get SIR’s to analyze and fix the code
• Troubleshooted connectivity problems. Looked up and read session, event and error logs for troubleshooting
• Written documentation to describe program development, logic, coding, testing, changes and corrections.

Environment

Informatica-Power Center 7.1.1,DB2 UDB 8.1, Power Exchange 5.2,Oracle 10G, SQL, STAR Schema, PWS(Project Workflow System) Toad 7.3, Unix Shell Scripts, HP-UX 11i, Sun Solaris 5.4, WINSQL,Humming Bird 9.0 ,CITRIX 7.0 ,Visual SourceSafe 6.0 and Windows NT

Education: Bachelor of Engineering