SUMMARY

• More than 12+ years of experience in various technologies focusing on Data warehousing, business intelligence, database programming, Informatica ETL, Oracle, .NET, Classic VB, Crystal reports & Business objects.
• 7+ years of providing technical leadership on Data Warehousing and Business Intelligence projects involving Analysis, Design, Data Modeling, Development, Integration, Implementation, Maintenance, Testing, and Production Support of Applications.
• Expert in depth knowledge of Informatica 8x, 9xs. Installation, configuration, design & development of Informatica 9x components.
• Loaded and maintained Data Warehouses and Data Marts using Informatica ETL
• Senior Technical Lead for Data warehousing projects for OSB & Pricing Business Function in Confidential Appliances,
• Expertise in Analysis, Design and Development of Informatica ETL and DWH packages.
• Excellent skills on debugging, troubleshooting, bug fixing & performance tuning of production Informatica ETL packages. Involved in 24x7 Technical support of Production Informatica environment.
• Ability to understand long - term project development issues at all levels, from interpersonal relationships to the details of coding scripts.
• Expert in fulfillment of data warehouse project tasks such as Planning, Requirement gathering, Identifying sources, allocation of resources and execution of projects including planning of implementation activities.
• Strong skills in database programming including SQL, PL/SQL, Stored Procedures, Functions,. using Oracle 10g, 11 & SQL Server 2005/2008.
• Strong knowledge & understanding of Dimensional Modeling like Star Schema and Snow Flake Schema
• Extensively used basic transformations like Aggregator, Filters, Joiners, and Lookups etc.
• Used advanced transformations like HTTP transformation, SQL transformation, UNION transformation, JAVA transformation
• Hands on experience in creating Design specifications, Test plans, Test Scripts, managing Testing Specifications
• In depth knowledge of UNIX and Shell scripting
• Knowledge on ODI and OBIA 11X in Order management and Procurement and Spend Modules
• 4+ years of experience Application Development in ASP.Net, VB.Net, SQL Server, Visual Basic 6.0.
• Experience in working directly with US clients. Preparation of technical and functional Specifications.
• Lead and worked with teams ranging from 5 to 15 people.
• Strong background in Operational and Decision Support systems.
• Experience in Financial, Banking industries, Retails domain
• Global Responsible Analyst (RA) for 6 Applications in OSB & Pricing Business IT solutions.

TECHNICAL SKILLS

Data warehouse/ Reporting Tool: Informatica 7.1/8.6/9.5,ODI,Crystal Report 8, Crystal Reports with Business Objects, Business Objects XI, OBIEE, Erwin InstallationConfiguration of BOXI, Installation, configuration of Informatica 9x

Databases: MS SQL Server 2005/2008, Oracle 9g,10g,11.x, SQL, PL/SQL

GUI: VB.NET, VB5/6

Programming Languages: C/C++, ASP.NET, .NET(VB.NET), COBOL

Scripting Languages: VBScript

Middleware / Server: IIS, MTS, COM / DCOM

Operating System: Windows 95/98/2000, UNIX, Linux

Others: RDBMS Concepts, Software Engineering Concepts

PROFESSIONAL EXPERIENCE

Confidential, New York

Senior Informatica developer

Responsibilities:

• Wrote the technical specification documents by understanding the business requirements and functional specification documents.
• Coordinated with business team and off shore team members to fill gaps.
• Performed design analysis, preparation of High level Design, Detailed level Design and Mapping documents.
• Designed ETL jobs for extracting, cleansing, transforming, integrating, and loading data into different Data Marts using Informatica Tools which includes error processing, restartability logic.
• Identified/documented data sources and transformation rules required to populate and maintain Data Warehouse content.
• Involved in data warehouse project tasks such as Planning, Requirement gathering, Identifying sources, planning, execution of the projects which includes planning of implementation activities.
• Extensively used Informatica Client tools - Source Analyzer, Transformation developer, Mapping designer, and Mapplets designers to develop mappings
• Extracted data from various source systems like relational data bases, Flat files and load data into the data warehouse.
• Implemented Performance tuning and optimization techniques to improve the performance of the mappings
• Performed Data Extractions, Data Transformations, Data Loading.
• Performed data validation of the fact and dimension tables on targets and supported varied Test cases and execution.
• Translated the business processes into Informatica mappings.

Environment: Informatica 9.x, Oracle 11g, TOAD, Putty, Filezilla

Confidential

Senior Technical Lead

Responsibilities:

• Wrote the technical specification documents by understanding the business requirements and functional specification documents.
• Coordinated with Confidential Appliance park business team and off shore team members to fill gaps.
• Performed design analysis, preparation of High level Design, Detailed level Design and Mapping documents.
• Designed ETL jobs for extracting, cleansing, transforming, integrating, and loading data into different Data Marts using Informatica Tools which includes error processing, reprocessing logic, count match logic, restartability logic.
• Documented the purpose of mapping so personnel could understand the process and in corporate changes as necessary.
• Identified/documented data sources and transformation rules required to populate and maintain Data Warehouse content.
• Involved in data warehouse project tasks such as Planning, Requirement gathering, Identifying sources, planning, allocation of resources, execution of the projects which includes planning of implementation activities.
• Extensively used Informatica Client tools - Source Analyzer, Transformation developer, Mapping designer, and Mapplets designers to develop mappings
• Extracted data from various source systems like relational data bases, Flat files and load data into the data warehouse.
• Implemented Performance tuning and optimization techniques to improve the performance of the mappings
• Implemented the SCD type2 to keep track of historical data.
• Performed Data Extractions, Data Transformations, Data Loading.
• Worked extensively on different type’s transformations like Source Qualifier, Lookup, Expression, Filter, Router, Sequence Generator, Update Strategy etc.
• Performed data validation of the fact and dimension tables on targets and supported varied Test cases and execution.
• Translated the business processes into Informatica mappings for building the data mart.
• Created Work Flows with Command Tasks, Worklets, Decision, Event Wait and Monitored sessions by using workflow monitor.
• Used Shell Script to Send Email to the user groups.

Environment: Informatica 9.x, Oracle 10g, JAVA (GUI), Oracle SQL Developer, Putty, WINSCP

Confidential

Senior Technical Lead

Responsibilities:

• Involved in business analysis and technical design meetings with off shore business and technical staff to develop requirements document, and ETL specifications.
• Analyzing requirements and coordinating the various activities between the users in various off shore team and the team members
• Performed design analysis, preparation of High level Design, Detailed level Design and Mapping documents.
• Developed Universe using Designer module in Business Objects
• Extensively used Informatica Client tools - Source Analyzer, Transformation developer, Mapping designer, and Mapplets designers to develop mappings
• Designed complex mappings using transformations like Lookup, SQL transformation, Aggregate transformation, Update Strategy etc.
• Used designer debugger to test the data flow and fix the mappings, Prepared test cases
• Performed Data validation on source systems.
• Implemented performance tuning and optimization techniques to improve the performance of the mappings
• Designed workflows, tasks and monitored sessions.
• Performed the Integrity check and finally exported universe to the repository
• Distributing the Documents to the various user group and types of users through the Repository.
• Development of Complex Reports using multiple data providers.
• Organized data in reports by using filers, sorting and highlighted data with alerts

Environment: Informatica 9.x, Oracle 10g, Crystal Reports with Business Objects, Oracle SQL Developer, Putty, WINSCP

Confidential

Senior Informatica Developer

Responsibilities:

• Extensively used Informatica Client tools - Source Analyzer, Transformation developer, Mapping designer, and Mapplets designers to develop mappings
• Performed data extractions, data transformation, data loading and data analysis
• Designed complex mappings using transformations like Lookup, SQL transformation, Aggregate transformation, Update Strategy etc.
• Implemented Change Data Capture (CDC) techniques like Slowly Changing Dimensions, Slowly Growing Targets and Simple pass through
• Optimizing the mapping to load the data in slowly changing dimensions
• Used designer debugger to test the data flow and fix the mappings
• Performed Data validation on source systems.
• Implemented performance tuning and optimization techniques to improve the performance of the mappings
• Designed workflows, tasks and monitored sessions.
• Prepared test cases and performed UTP.

Environment: Informatica 8.6, Oracle 10g, Oracle SQL Developer, Putty, WINSCP

Confidential

Informatica Developer

Responsibilities:

• Performed data migration and data synchronization from source systems
• Creation of mappings for staging and target tables
• Used Transformations as per requirements for transforming data like Source Qualifier, Aggregator, Expression, Lookup, Router, Normalizer, Sequence Generator etc.
• Checked the output according to the specifications and preparation of UTC
• Created reusable transformations, mapplets and worklets
• Enhancement of existing functionalities and customizing according to the needs of Busniess
• Migrated Informatica 7.1 to 8.6 & supported the Production box

Environment: Informatica 8.6, Oracle 10g, Oracle SQL Developer, Putty, WINSCP

Confidential

Informatica Developer

Responsibilities:

• Performed data migration and data synchronization from source systems
• Creation of mappings for staging and target tables
• Used Transformations as per requirements for transforming data like Source Qualifier, Aggregator, Expression, Lookup, Router, Normalizer, Sequence Generator etc.
• Checked the output according to the specifications and preparation of UTC
• Created reusable transformations, mapplets and worklets

Environment: Business Objects XI, Oracle 10g and data warehousing

Confidential

Informatica Developer

Responsibilities:

• Designed the Users and Groups as per the requirement
• Created, modified, deployed and maintained Business Objects Universes
• Developed and created classes with Dimension, Detail & Measure Objects and specified the hierarchies for the Location Dimension.
• Created reports as per the requirements
• Distributing the Documents to the various user group and types of users through the Repository.
• Responsible for the maintenance of Development and Production Repositories

Environment: Business Objects XI, Oracle 10g and data warehousing