Data Warehouse Architect / Informatica Lead

IT professional with extensive experience in Data Warehousing, Data architecture, design and programming. Experienced with multiple computing environments and a variety of project types and sizes (small to large, multi-year efforts), from business requirements to post implementation support and reviews, the complete system design life cycle (SDLC). Also extensive experience of review techniques as well as a broad knowledge of requirements definition, design, testing, and implementation in the IT Development area.

OBJECTIVE:

Seeking a position to work as a Data Warehouse Architect / Informatica Lead Developer for a reputable organization and to be able to exercise my skills and further enhance my career leading to greater accomplishments in the implementation of high quality software using good project management, quality processes and tools.

TECHNICAL EXPERIENCE:

Extensive experience in Architecting and Developing Data Warehousings projects.

My Job Responsibilities have included:

• ETL architecture, Data Warehouse Design, Dimensional Model, Project Planning and Execution of data warehousing projects

• Handle Data Warehouse Project End to End

• Database and table design and implementation for data warehouse and related ETL processes.

• Extensively worked on the ETL mappings, analysis and documentation of OLAP Cube requirements. Solid understanding of OLAP concepts and challenges, especially with large data sets.

• Informatica PowerCenter experience including Version 9.0.1

• Experience in Performance tuning in large volume data.

• Extensively worked experience in MS Analysis Services, MDX and Optimization and performance tuning of SQL Server

• Ensure the implementation of the quality standard and processes in project deliverables.

• Expertise in data warehousing, ETL architecture.

• Expertise in tuning the performance of mappings and sessions in Informatica and determining the performance bottlenecks.

• Experience in creating pre-session and post-session scripts to ensure timely, accurate processing and ensuring balancing of job runs.

• Expert in troubleshooting/debugging and improving performance at different stages like database, workflows, mapping.

• Thorough Knowledge of different OLAP’s like MOLAP, ROLAP, HOLAP.

• Intense Knowledge in designing Fact & Dimension Tables, Physical & Logical data models using ERWIN and Erwin methodologies like Forward & Reverse Engineering.

• Involved in writing Unit test cases for complex scenarios.

• Knowledge in design and development of Business Intelligence reports using BI tools Business Objects, Cognos and Microstrategy.

• Experience in Installation and configuration of Informatica server with sql server, oracle and able to handle the Informatica administrator tasks like Creating repository and backup, Configuring DSN, creating Connection Strings, copying & moving mappings, workflows and creating folders etc.

• Experience includes thorough domain knowledge of Manufacture, HRMS, Financial system and Banking.

• Enthusiastic and goal-oriented team player possessing excellent communication, interpersonal skills and leadership capabilities with high level of adaptability.

• Design, Coding and Configuration Management

• Knowledge of MDM

Work Experience

• Working as Senior System Analyst in Ramco System Limited, India from Nov’02 - Aug’11

• Worked as Assistant Consultant in Pentasoft Technologies Limited, India from Feb’99 - Aug’02

TECHNICAL ENVIRONMENT

Hardware/OS : Windows 9x/NT/2000/2003, MS DOS, UNIX

Database : SQL Server 2005/2008 , HP Neoview , Oracle 8.0/10g

ETL : Informatica PowerCenter 8.6.1/9.0, SQL Server Integration Service (SSIS)

OLAP : SQL Server Analysis Services (SSAS), Business Object,

Pentaho Mondrian, Crystal Analysis

Report : Crystal Report, SSRS

Data Modeling : Erwin, Visio 2000 S Designer

Languages : SQL, MDX, Visual Basic 6.0, PL/SQL

Others : MS Visual SourceSafe, Subversion

KEY PROJECTS:

HP/Ramco Systems (Mar 2009 – August 2011)

Data Warehousing Architect/Informatica Lead Developer and Architect

Description: Ramco Banking Analytics product provides all basic and primary analysis requirements at large for variety of banks in India and abroad, though some of the terminology related to product types needs revision for banks abroad. This solution would provide in Bank of India to build advance analytics covering Customer wise Performance Analysis, Loan Analysis, Deposit Analysis and generation of all the reports required within the bank. The data warehouse solution provides business intelligence using KPIs, score cards, cube reports and MIS reports

Responsibilities :

• Requirement Analysis, Architecting and design of data warehouse ETL processes.

• Design and Maintain Informatica Power mappings for extraction, transformation and load (ETL) between Oracle, HP Neoview and SQL Server databases

• Responsible for the Designing Dimensional Data Modeling using Erwin

• Tuning Informatica Mappings and Sessions for optimum performance.

• Validating PowerCenter Mapping.

• Eliminating Bottleneck ETL process and Implemented a partitioning strategy

• Responsible for completing the technical development within the target time.

• Onsite Implementation.

Environment: HP Neoview, UNIX, SQL 2008, Informatica PowerCenter 9.0.1, Mondrian OLAP, Erwin, Ramco Analytical Report and DecisionWorks.

Banking Analytics , Ramco Systems (Aug 2008 – Feb 2009)

Data Warehousing Architect/Informatica Lead Developer and Architect

Description: Banking analytics solution aimed at addressing Business Intelligence (BI) needs of banks. The solution which will have a pre-built data warehouse will provide loan analytics to banks looking for loan performance management for their loans portfolio. The analytical support provided by the solution will help bank executives take crucial decisions such as interest rate adjustments, region-wise loan deployments, overall business strategy and compliance. This solution intends to provide a collaborative platform for integrating and analyzing all core banking data with a view to helping senior executives take better decisions. The pre-built data warehouse feature will help banks to save costs on expensive in-house development and deployment of data warehouse solutions.

Responsibilities :

• Estimation plan for completing task

• Gathering requirements from Banking Consultant and designing Data Modeling

• Source data analysis, table design using ErWin, improved cube designs for ease of loading.

• Created and maintained Informatica PowerCenter mappings and Workflow session as needed.

• Designing MOLAP Cube in MS Analysis Services

• Design and create database tables needed for application.

• Performance tuning in PowerCenter Mapping , HP Neoview and MS Sql Server Database

• Tuning Informatica Mappings and Sessions for optimum performance.

• Technical mentoring of the ETL team

• Used Informatica Workflow Manager to create, schedule, execute and monitor sessions, worklets and workflows.

• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, Workflows and database tuning.

• Worked with Session Logs and Workflow Logs for Error handling and Troubleshooting in all environment.

Environment: HP Neoview, UNIX, SQL 2008, Oracle 10g, Informatica PowerCenter 8.6.1, Mondrian OLAP, Erwin, Ramco Analytical Report and DecisionWorks.

ES Analytics, Ramco Systems (Nov 2007 – Jul 2008)

Data Warehousing Architect/Informatica Lead Developer and Architect

Description: Enterprise Solution Analytics is a readymade package of generic BI Analytical solution which includes KPIs, Scorecards, Analytical reports and MIS reports in the areas of - Stores, Purchase, Sales, HR, Finance and Production by using Neoview.

Responsibilities: Requirements analysis, Estimation, Design, Execution and Quality Assurance.

Environment: SQL 2008, Informatica PowerCenter 8.6.1, MS Analysis Services, Erwin, Ramco Analytical Report and DecisionWorks.

NBO – Data Migration, Dubai (Jul 2007 – Oct 2007)

Data Warehousing Architect/Informatica Lead Developer and Architect

Description: Nation Bank of OMAN is one of Omen’s leading Banking which currently serves over 5 million customers- end users on behalf of their esteemed clients. The objective of the data migration activity is to migrate the payroll data from the current Ramco 3x to the Ramco 4x Payroll system and validate the same. Identify the data sources that must be transported into the new system and also it involves getting acquainted with the actual data that needs to be migrated. Loading the destination tables with the cleansed source data using Informatica tool

Responsibilities: Requirements analysis, Project planning, Data mapping, Coding, Execution and Quality Assurance.

• Developed mappings to extract data from Flat files, Excel and load into SQL Server using the PowerCenter.

• Developed common routine mappings. Made use of mapping variables, mapping parameters and variable functions.

• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Union, Expressions and Aggregator transformations.

• Used mapplets for use in mappings thereby saving valuable design time and effort

• Used Informatica Workflow Manager to create, schedule, execute and monitor sessions, worklets and workflows.

• Worked with Session Logs and Workflow Logs for Error handling and Troubleshooting in all environment.

• Responsible for Unit testing and Integration testing of mappings and workflows.

• Troubleshooting database, workflows, mappings, source, and target to find out the bottlenecks and improved the performance.

Environment : SQL Server 2008 and Informatica PowerCenter 8.6.1

DLF (Mar 2007 – Jun 2007)

Informatica Lead Developer

Description: DLF is India's largest real estate company in terms of revenues, earnings, market capitalization and developable area. In order to garner competitive edge, DLF needs a system that will provide the means for quicker, more accurate and more informed decision making capability. Project involves creation of performance metrics on dashboard for aggregated performance along with analytical reports giving the consolidated view of the operations with flexibility to view transactional details

Responsibilities : Requirements analysis, Estimation, Project planning and execution, Design, Quality Assurance and Implementation.

Environment: SQL 2005, RBI, Analysis Services, Erwin, Ramco Analytical Report and DecisionWorks.

Madras Cement Limited (Oct 2006 – Feb 2007)

Informatica Lead Developer

Description: Implementation of Corporate Performance Management solution with Scorecards, key Performance Indicators (KPI’s) and analytical reports with long-term view of implementing Balance Scorecard. . The solution enables process management, sales and operation planning, cashflow planning, drilling from high-level to detailed information, capturing trends, performing statistical analysis, and extracting intelligence

Responsibilities : Requirements analysis, Estimation, Project planning and execution, Design.

• Interacted with business community and gathered requirements based on changing needs. Incorporated identified factors into Informatica mappings to build the DataMart.

• Developed a standard ETL framework to enable the reusability of similar logic across the board. Involved in System Documentation of Dataflow and methodology.

• Assisted in designing Logical/Physical Data Models, forward/reverse engineering using Erwin.

• Developed common routine mappings. Made use of mapping variables, mapping parameters and variable functions.

Environment: SQL 2005, RBI, Analysis Services, Erwin, Ramco Analytical Report, DecisionWorks, OWC, Quality Assurance and Implementation..

Safe Air, New Zealand (May 2006 - Sep 2006)

Informatica Lead

Description: Safe Air Limited (SAL), headquartered at Blenheim, New Zealand is aviation MRO (maintenance, repair and overhaul). SAL needed a business performance system, which would help the company to

• Monitor and optimize process efficiencies and effectiveness.

• Identify business trends and hidden patterns.

• Have a unique and consistent view of the information.

The solution implemented encompasses various function areas of the business like the Human resources, Business development, Business performance, Operations and Finance. A Unique, consistent and comprehensive view over the organization business available to users on their dashboards

Responsibilities: Requirements Analysis, Design, Execution, Quality Assurance and Support

Environment: SQL 2005, RBI, Analysis Services, Erwin, Ramco Analytical Report, DecisionWorks and OWC.

HR Analytics, Ramco Systems (Feb 2006- Apr 2006)

Team Lead

Description: It is part of an internal implementation of DecisionWorks in the company in the HR domain encompassing the major processes of the HR division. A pilot implementation was initiated in the HR division as part of the enterprise wide initiative. The data warehouse solution implemented and provides business intelligence using KPIs, score cards, cube reports and MIS reports.

Responsibilities: Requirements Analysis, Design, Execution, Quality Assurance and Support

Environment : SQL 2005, Analysis Services, RBI, DecisionWorks, Excel Pivot and OWC

Sesa (July 2005- Jan 2006)

Informatica lead

Description: Implementation of Corporate performance management application with scorecards, Key performance metrics (KPI's) and analytical reports with a long-term view of implementing Balance Scorecard. The solution enables process management, sales and operation planning, cashflow planning, drilling from high-level to detailed information, capturing trends, performing statistical analysis, and extracting intelligence

Responsibilities: ETL Design, Executin, Quality Assurance and Onsite implementation

Environment: SQL 2000, DTS,Analysis Services, DecisionWorks, Excel and OWC

eThekwini Municipality, South Africa (Jan 2005 – Jun 2005)

Technical Consultant

Description: EThekwini, the municipality of Durban, one of the largest in South Africa, prepares its capital and operating budget and plans its sources of income well in advance to meet the expenditure. One of the main sources of its operating budget is income from property tax. The new budgeting system consolidates property information and other details from various systems. Is supports multiple scenarios planning by varying the controlling parameters and compare the budgets to arrive at the optimal budget. Apart from the KPI developed to track the payments and discrepancies, the system provides rates analysis report, budget vs. actual and reconciliation reports. The reports which took months of manual processing are available instantly.

Responsibilities: Design, Execution, Quality Assurance and onsite implementation

Environment : SQL 2000, Analysis Services, RBI, DTS, DecisionWorks , Excel and OWC

CIBA, Switzerland (Sep 2004 – Dec 2004)

Data Warehouse Design Lead

Description: CIBA specialty chemicals Switzerland has operations in more than 60 locations in 23 countries employing about 20,000 people. Ciba’s HR Information Systems comprise of a very large number of diverse and often non-integrated system clusters, with no single reliable source for HR data. A global HR warehouse integrating data from 40 different systems and providing unified and standardized HR information was developed. The solution span encompasses KPI, score cards, cube reports and mis reports with complex data security based on user's span of control facilitating exception handling going to the level of employees.

Responsibilities: ETL Design, Execution, Quality Assurance and support

Environment : SQL 2000, Analysis Services, DTS, RBI , DecisionWorks, Excel and OWC

PHI, USA (June 2003 – Dec 2003)

Informatica Developer

Description: Petroleum Helicopters Inc. (PHI), head quartered at Lafayette, Louisiana, is one of the world’s leading helicopter services companies. Corporate Performance Management was implemented for the Safety, Maintenance, Materials, People, Operations, Marketing and Finance functional areas. A Comprehensive data warehouse talking to 5 different systems was developed to support over 100 Key performance indicators and 30 OALP reports. A state of the art materials requirement planning was implemented for optimal planning of material requirements for periodic maintenance.

Responsibilities:,ETL Design, Execution, Quality Assurance and support

Environment : SQL 2000, Analysis Services, DTS, RBI, DecisionWorks, Excel and OWC

Agency, SWRDA UK (Feb 2003 – May 2003, Jan 2004 – Aug 2004)

Informatica Developer

Description: South West Regional Development Agency is responsible for economic development of nine counties in UK in the south west region. It interacts with more than 7000 government and corporate bodies and manages more than 1500 development programs. Siebel based contact and project management system have been implemented. Agency needed to gain insightful information to monitor their activities and to identify if they are effectively and efficiently working towards their objectives. The warehouse solution implemented encompasses development of Siebel connectors, data warehouse comprehensively covering the major entities in the Siebel system.

Responsibilities: ETL, Execution, Quality Assurance and support

Environment: Siebel, SQL 2000, Analysis Services, RBI, DecisionWorks, Excel and OWC

IPRings - India (Nov 2002 – Jan 2003)

Team size 20

Role Team Member

IPRings Ltd is a leading piston rings manufacturer. IPRings has a structured performance management being implemented in their operations. Currently manual computation is being done for key performance indicators. Ramco Business Decisions is being implemented to a automate data collection, balanced score card, computation of key performance indicators by integrating with Ramco ERP system.

Responsibilities: ETL, Quality Assurance and support

Environment: SQL 2000, Analysis Services, DTS, RBI, DecisionWorks, Excel and OWC

Pentasoft Technologies Limited, India February 1999 – August 2002

Designation : Assistant Consultant

Primary Responsibilities : Development of client based application based on Visual Basic 6.0, MS SQL Server 7.0 and Crystal Report 7.0 .

Education

• Master’s Degree in Computer Applications, University of Madras (1995-98)

• Bachelor’s Degree in Commerce, University of Madras (1991-1994)

Training

• Ramco – All SDLC processes laid down by Ramco Systems (CMMI L5 Company)

• Microsoft – Data warehousing using Analysis Services.

References

References available on request.

Contact this candidate