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
• Worked on PMCMD, knowledge of PMREP & Workflow tasks like Command, Email,.
• Hands on experience in creating Design specifications, Test plans, Test Scripts, managing Testing Specifications
• In depth knowledge of UNIX and Shell scripting
• Knowledge on OBIA 7X 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, OSB & Pricing Area
• 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

P rogramming 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

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 incorporate 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 DeveloperPutty,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

Confidential

Project Lead and Responsible Analyst

Responsibilities:

• Lead, designed and developed multi-phased Price simplification project which improves productivity and data accuracy by streamlining the complete pricing workflow in a single web-based environment.
• Responsible for architecture and design, providing technical direction to come up with a standard design for multi-phased Price simplification applications.
• Instrumental for improvising smart quote system with innovative solution of memo quote using six sigma DMAIC process to provide bird eye view of master customer’s quote to their tied customers.
• Drove team towards value-addition to the business with corporate initiatives and processes, which focus on eliminating defects, improving systems, reducing cycle time and manual efforts.
• Responsible Analyst - Lead team to provide on-going support mission critical pricing business applications with SLA driven metrics.
• Drove team towards value-addition to the business with corporate initiatives and processes, which focus on eliminating defects (DMAIC), improving systems (DMAIC), reducing cycle time and manual efforts (LEAN).
• Improvised smart quote system with innovative solution of memo quote using six sigma DMAIC process to provide bird eye view of master customer’s quote to their tied customers which brings in $300M of business savings by order to remittance defect reduction.

Environment: Front End: VB 6/VB.net, COBOL, Oracle/UNIX, VSS, RCS, Farpoint Spread/Tabpro/ InputPro, Minitab