Self-motivated & Hardworking ETL/Data Architect with over 12 years of experience in fast-paced, delivery focused fortune 500 environments.

• 12 years of experience in Information technology on handling multiple engagements in various capacities as Data Warehouse architect, ETL Architect, Designer and Developer.
• Experience in Insurance, Utility, Banking, Mortgage, Finance and Manufacturing Domain
• Worked on various MULTI-SITE projects teams spread across US, Europe, Australia & India handling complex onsite-offshore engagements involving large data volumes.
• Strong experience on Project Management, Systems Integration, Data warehouse architecture, Database Design, ETL Design, Report Design, ETL Optimization, Data Profiling, Data quality process design, Best practice implementation, ETL Development, Production support and team co-ordination.
• Data modeling experience using Erwin tool involving Dimensional and Fact tables in Operational Data Store and Enterprise Datawarehouse.
• Strong ETL experience using Datastage 8.1, Datastage Balanced Optimizer, Informatica Power Center 7.x & 8.6.
• Strong experience in Oracle, Teradata and SQL.
• Have experience of working on Business Objects 6.5 Universe, Web intelligence reports and SAS Tool.
• Knowledge of IBM CDC Tool
• Coordination with users during UAT.
• In-depth experience on process modeling, analytical, problem solving and understanding of DW processes & best practices and onsite-offshore communication.
• Experienced in Project estimation, Planning & Project proposal.
• Certified in Informatica/Oracle.

Operating System: Windows 2000, Windows XP/NT, Unix

Programming Languages: Unix Shell Scripting

Confidential, 12/2010 till date, ETL Architect cum Lead

Confidential, 04/2004 till 12/2010, ETL/Data Architect/Project Leader

Confidential, 05/2002 to 04/2004, Sr Software Engineer

Confidential, 06/2000 to 05/2002, Executive-Systems

Confidential, 05/1999 to 06/2000, Software Engineer

PROFESSIONAL EXPERIENCE:

Confidential, Dec 2010 till date

Project Title: Smartconnect Datawarehouse
Duration Dec 2010 till date
Location: La Palma, CA
Client: Confidential
Title: ETL Architect cum Lead
Technologies: Used Data stage 8.1, Balanced Optimizer, IBM CDC Tool, Teradata 13.10, Unix, Business Objects, SAS, Tivoli

PROJECT DESCRIPTION:

SCE is in the process of replacing today's electric meters with the new "smart" meters and communications system that will improve customer service, offer customers new rate options and help customer save energy and money.

The Edison SmartConnectTM Data Warehouse is Teradata database implemented using Teradata's uLDMTM (Utility Logical Model). Customer, Billing, Meter Reading & Interval Data is extracted from various source systems using IBM CDC Tool creating extract file on Real Time basis on Unix box. These extracts are then loaded into DW using IBM Datastage and finally exposed in Business Object Report and Website using Teradata semantic layer and web services. The system also provide Budget Assistance which provides customer with Projected Monthly Billing based on the current usage.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

• Gathering the Project Requirement
• Worked on System Requirement Design
• Worked on ETL Specification and Logical & Physical Design documents
• Providing best possible solution and getting it approved from Architectural Board
• Providing alternate solutions or approach to improve the existing process
• Providing Architectural Design to the development team
• Coordination with the Datastage ETL & Reporting Development team with Design/Development approach to create a Datamart
• Data Integration from source systems into DW
• Working with DBA's to get the Database design approved and implemented
• Define and Improve tasks to ensure Data Quality
• Find performance bottle necks and provide industry standard solution
• Standardize the process to the enterprise level
• Closely interact with Vendors, business users and internal teams to make sure every process goes smoothly
• Timely communication to the Project participants and management team about the progress
• Improve the existing process towards more automated, reduce failure risks, improve data quality and increased resource utilization

Confidential, April 2004 till Dec 2010

Project Title: Information Management-Bacardi
Duration May 2010 till Dec 2010
Location: Newark, DE
Client: Confidential
Title: ETL/Data Architect
Technologies: Used Informatica 8.6.1, Data stage 8.1,DB2, Unix, SAS 5.1, Maestro

PROJECT DESCRIPTION:

Bank of America CARD Information (Bacardi) is central repository for card specific data. It is a data warehouse in DB2 built on UNIX systems. Consumer credit card also resides in this warehouse. This warehouse is mainly used for Marketing, reporting and for statistical analysis of data. Process involves UNIX, Informatica, Data stage and DB2. Data was extracted from various source systems including mainframe and loaded into DWH using Informatica. All new processes are getting loaded through Data stage. A framework was built which will capture the run time statistics, load quality check and Data quality of the data. Some of the reports were generated though SAS tool.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

• Gathering the Project Requirement
• Analyze changes and design database changes
• Providing best possible solution and getting it approved from Architectural Board
• Providing alternate solutions or approach to improve the existing process
• Providing Architectural Design to the development team
• Coordination with the Datastage ETL & Reporting Development team with Design/Development approach to create a Datamart
• Data Integration from source systems into Operational Data Store-ODS
• Working with DBA's to get the Database design approved and implemented
• Define and Improve tasks to ensure Data Quality
• Find performance bottle necks and provide industry standard solution
• Standardize the process to the enterprise level
• Closely interact with Vendors, business users and internal teams to make sure every process goes smoothly
• Timely communication to the Project participants and management team about the progress
• Improve the existing process towards more automated, reduce failure risks, improve data quality and increased resource utilization
• Worked on design of Dimensional Database with star fact tables.
• Worked with development team for creation of Test Scripts needed during Unit Testing/UAT.

Project Title: Information Management-Informatica 8.6.1 Upgrade
Duration Apr '2010 to May'2010
Location: Newark, DE
Client: Confidential
Title: Project Lead
Technologies: Used Informatica 8.6.1, Unix

PROJECT DESCRIPTION:

Informatica was upgraded to 8.6.1 version from its previous version of 8.1.1. This was done as the DB2 was also upgraded from 9.1 version to 9.7.1 version.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

• Define roadmap for Informatica Upgrade
• Coordinate with Informatica Admin, Unix Admin, DBA's and Upgrade team to finalize the roadmap and get it approved
• Weekly status reporting with the progress of the upgrade to management
• Identify any issues and provide support to the Upgrade team
• Coordination with the Informatica support team for smooth upgrade.

Project Title: Datahub Project
Duration Sept' 2009 to March'2010
Location: Mclean, Virginia
Client: Confidential
Title: Data/ETL Architect
Technologies: Used Informatica 8.6.1, Business Objects, DB2 and Oracle

PROJECT DESCRIPTION:

Sourcing to servicing project is a Datwarehousing project where data needs to be pulled from Loan system-Legacy system in Mainframe into a SBO (Oracle) target system. The data was in real time format in the form of JMS messages as well as file systems. Data was then reported using Business Objects.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

• Coordinating with client
• Requirements gathering, analysis and design
• Documentation of requirement and design
• Database Design
• ETL Design
• Data Integration from source systems into Operational Data Store-ODS to create a Datamart
• Coordination with Development Teams
• Worked with development team for creation of Test Scripts needed during Unit Testing/UAT.
• Suggesting best practices.

Project Title: Sourcing to Servicing
Duration Apr '2010 to May'2010
Location: Mclean, Virginia
Client: Confidential
Title: Data/ETL Architect
Technologies: Used Informatica 8.6.1 with Web service,
JMS messaging, Orchestration, Oracle, Unix

PROJECT DESCRIPTION:

As part of this project we worked on a POC on Informatica 8.6.1 to explore the features of web service consumer transformation, JMS messaging and Orchestration features. Informatica components were exposed as web services so that other application can used the features of the component.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

• Business users interaction
• Database Modeling using Erwin Tool involving Dimensional /Fact schemas.
• ETL Design
• Data Integration from source systems into Operational Data Store-ODS to create a Datamart
• Scope management and SOW submission
• Documenting the findings from POC
• Finalizing the best solution approach after approval from Technical Board.
• Status reporting to Stakeholders & PMO
• Schedule tracking
• Suggesting best practices.

Project Title: Enabling Technology DWH
Duration Feb 2009 to July 2009
Location: Stamford, CT, US
Client: Confidential
Title: Data Architect
Technologies: Used Informatica 8.1.1, Oracle, Erwin Tool

PROJECT DESCRIPTION:

Enabling Technology is a DWH project where in data is integrated from multiple source systems from Treasury applications into an integrated ODS layer. The data from this layer is then loaded into an EDW Star schema model, on top of which reporting is built. Informatica was used as ETL tool where all the business logics were applied. Business Objects - the reporting tool will generate the consolidated report.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

• Requirements gathering, analysis and design.
• Coordination with Business Users and Analyst to understand the requirement
• Database Design
• Data Integration from source systems into Operational Data Store-ODS and EDW
• Creation of ETL Specs-Mapping of data from Source to Target with logic to pull data needed to create a Datamart
• Coordination and providing solution approach to Development team
• Coordination with Reporting team and help them resolve any issues
• Suggesting best practices.
• Data modeling using Erwin tool involving Dimensional/Star fact schemas.
• Coordination with the Business Objects reporting team to help them design the Report layouts.

Project Title: Market smart
Duration Nov'2008 to Feb'2009
Location: Danbury, CT, US
Client: Confidential
Title: Data Architect
Technologies: Used Informatica 8.1.1, Teradata, Business Objects, Erwin

PROJECT DESCRIPTION:

Market Smart Data mart is a long term strategic vision for marketing team for getting all information related to sales and marketing initiatives for Enterprise Sales and Capital Solutions.It's a Data warehouse for Capital Solutions to support Sales and Marketing initiatives. It has CRM as well as Volume data for different P & L's like EFS Direct, Indirect, Canada, Fleet, HFS etc. Informatica is used as the ETL tool and Teradata is the backend.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

• Requirements gathering, analysis and design
• Coordination with Business Users and Analyst to understand the requirement
• Database Design
• Creation of ETL Specs-Mapping of data from Source to Target with logic to pull data to create a datamart
• Data Integration from source systems into Operational Data Store-ODS
• Coordination and providing solution approach to Development team
• Informatica Consultation
• Data modeling using Erwin tool with Dimensional Modeling.
• Coordination with reporting team to design the layout of the reports and design of the Universe.

Project Title: Siebel 8.0 upgrade
Project Title: '2008 to Nov'2008
Location: Danbury, CT, US
Client: Confidential
Title: Onsite Coordinator/Tech Lead
Technologies: Used Informatica, Business Objects 6.x, Unix Scripting, Oracle

PROJECT DESCRIPTION:

GE Capital Midmarket Finance has embarked on some strategic initiatives in the area of Enterprise Data Warehousing for its 3 business units (GE Cap CEF, VFS & EEF). The scope of the project includes different redesign/ build in the area of Data Warehousing. The data was pulled from Siebel System consisting of Sales and Marketing data. The data warehouse was enhanced and redesigned due to an upgrade in the Siebel source system to version 8.0.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

• Leading the Project
• SOW Submission
• Coordinating with client
• Requirements gathering, analysis and design.
• Project Tracking, resource alLocation:.
• Status Reporting to Client: & Management
• Testing and implementation.
• Coordinating with offshore and Client: team.
• Ensure the quality of the deliverables to the client

Project Title: BI Monthly Releases
Duration Oct'2007 to May'2008
Location: Danbury, CT, US
Client: Confidential
Title: Onsite Coordinator/Tech Lead
Technologies: Used Informatica, Business Objects 6.x, Unix Scripting, Oracle

PROJECT DESCRIPTION:

GE Capital Mid Market Finance has embarked on some strategic initiatives in the area of Enterprise Data Warehousing for its 3 business units (GE Cap CEF, VFS & EEF). The scope of the project includes different build / re-engineering / maintenance projects in the area of Data Warehousing. The project requires extensive use of data quality tools during transformations and specialized tools for data mining/statistical analysis purposes. The objective of this project is to ensure that data extractions and transformations from legacy systems and other external sources are facilitated, data cleansing and staging is carried out and summarization of data completed seamlessly. Data is also to be migrated from the existing Legacy systems into the Warehouse based applications. The mains cope of project was to work on enhancement projects.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

• Leading the Project
• Coordinating with client
• Requirements gathering, analysis and design.
• Project Tracking, resource alLocation:.
• Status Reporting to Client: & Management
• Coordinating with offshore and Client: team.
• Ensure the quality of the deliverables to the client
• Worked on Business Objects Reporting tool for designing report layouts.

Project Title: BI BR Maintenance & Support
Duration Jun'2005 to Oct'2007
Location: Mumbai, India
Client: Confidential
Title: Project Lead
Technologies: Used Informatica 7.3.1/8.1.1, Business Objects, SQL Server, Oracle, Unix Scripting, ASP, Approx. scheduling tool

PROJECT DESCRIPTION:

The scope of the project was Maintenance & Enhancements of Data warehouse for CEF, VFS & HFS Applications and web applications. The Project was a MCA with more than 80 applications with 24*7 support. The scope of this project involved data extraction from various source systems on daily, weekly and monthly-calendar, fiscal basis including yearend processing.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

• Coordinating with client
• Ensuring smooth data loads
• Resolving issues identified based on priority of ticket
• Assigning tickets to team members
• Ensuring faster resolution of tickets within the specified SLA
• Status tracking and reporting to Client: on weekly basis
• Ensure the quality of the deliverables to the client
• Identifying any optimization/enhancement opportunity and get it implemented.
• Working with Development teams for Project Transitions, change control processes.
• Suggesting Development teams for best possible approach

Project Title: GEMS-SWAP (SUPPLIER WARRANTY PROGRAM)
Duration Apr'2004 - June 2005
Location: Mumbai, India
Client: Confidential
Title: ETL Lead
Technologies: Used Informatica 7.3, Oracle 8.x, Business Objects 6.5

PROJECT DESCRIPTION:

GE-Milwaukee, USA is a $10 billion global leader in medical imaging, point-of-care systems, Healthcare services and information technology. Its offerings include networking and productivity tools, clinical information systems; patient monitoring systems etc.., the data is extracted from Service delivery systems and Parts delivery systems which consist of origin data of America, Europe and Japan. GEMS-SWAP developed for checking Part warranty, System Warranty and identifying the Parts which are defect and check whether they are belonging to Part Warranty or System Warranty and load the data in to SWAP warehouse. The data from the warehouse is used for reporting the status of all the parts through Business Objects.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

• Worked on Detail ETL Mapping design
• Worked on ETL Logical & Physical Application design documents
• Coordination with the Data Architects & Reporting team
• Lead the ETL team to develop ETL Mapping & Unix scripts to load the data from source to DW

Smartech Global SolutionS Ltd - May 2002 to April 2004

Project Title: Kolsite DWH
Duration Mar'2003 - Apr'2004
Location: Mumbai, India
Client: Confidential
Title: Project Lead
Technologies: Used VB, Oracle

PROJECT DESCRIPTION:

The company manufactures machines. This is an ERP like package consisting of modules like Purchase, MRP, Engineering, Sales, Budget, Scheduling, Bill of Material, Production Planning, Accounts, Inventory, Engineering, Exports, Machine Shops and Assets.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

• Leading the team
• Requirement analysis and database design.
• Preparing design document and Tractability matrix
• Status reporting to Client: and Management
• Ensuring smooth deliverable of the project.

Project Title: Cello Exports
Project Title: 2002 to Mar'2003
Location: Mumbai, India
Client: Confidential
Title: Module Lead
Technologies: Used VB, Oracle, Crystal Reports.

PROJECT DESCRIPTION:

The scope of the project was to build a export package consisting of various export documents like Pre shipment, Post shipment, DEPB, DEPC, ARE documents. Did synchronization using merge type on SQL Server 2000 to transfer data between Mumbai & other Location: & vice versa over Telephonelines.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

• Responsible for the module.
• User Interaction
• Design of VB Components and development of crystal reports
• Development of PL SQL Components
• Testing and Implementation.
• Creation of documentation.

Confidential, June 2000 till May-2002

Project Title: Tech Pacific Australia/India/NZL
Duration June 2000 to May 2002
Location: Mumbai, India
Client: Confidential
Title: Sr Developer
Technologies: Used Cold Fusion 4.5, Oracle, SQL Server, Universe

PROJECT DESCRIPTION:

This Web Site was developed for Australian Branch .The Company was in IT products distribution with more than 80 warehouses throughout the country. It is a B2C website which allows a valid customer to order products online. Was involved in development of 'Bag a Bargain Module, PO In transit /receive modules. Was involved in the development of the web pages using the Cold Fusion Development Tool. In all the above web sites, Program written in to upload the data entered in ERP module to Oracle seen on web site. Similarly, data entered through on web site is downloaded to the ERP. This ERP was developed using UNIVERSE language.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

• Involved in requirements gathering
• Involved in Analysis & design.
• Involved in Coding
• Developing several important functionalities

Confidential, May 1999 till June-2000

Project Title: Cawasji Behramji & co
Project Title: 1999 to June 2000
Location: Mumbai, India
Client: Confidential
Title: Team Member
Technologies: Used VB, Oracle, Crystal Reports, Visual Help Pro

PROJECT DESCRIPTION:

• This was a customized software package for Ship Chandlers Company. This Project consists of following modules.
• * Purchase * Sales * Exports * Inventory * Accounts * Payroll

ROLES AND RESPONSIBILITIES IN THE PROJECT:

• Coding and Development
• Testing
• Implementation
• Documentation and creation of Help File

Bachelors of Electronics Engineering

Informatica 7.3.1-Oct 2005
MCSD(Microsoft Certified Solution Developer-Feb 2000
OEAP(Oracle Alliance Partner Certification)-Oct 2001