Aug 2015 – Oct 2017 · 2 yrs 2 mos · Pune, Maharashtra, India

• Business Intelligence and Management Analytics

Jan 2008 – Jan 2009 · 1 yr

• is one of the world's leading theatrical exhibition companies with interests in 359 theatres with 5,138 screens.
• Scope includes creating a data warehouse using SQL Server as backend, DataStage 8 as an ETL Tool.
• Visited AMC client (US) for requirements gathering process
• Project involves development and implementation of a data warehouse for ticket sales and Food and Beverages Sales.
• Managed a team of 11 resources.
• Involved in designing ETL processes and jobs design.
• Prepared technical specifications and use cases
• Data is being extracted from SQL Server system, XML files and flat files
• Involved in Unit and System Testing
• EDW-INVENTORY DATAMART

Feb 2007 – Dec 2007 · 10 mos

• Micron's Mobile DRAM product line, featuring Endur-IC technology, is designed specifically to address the complex demands of wireless, handheld products. Micron's Mobile DRAM product line, featuring Endur-IC technology, is designed specifically to address the complex demands of wireless, handheld products. Micron's traditions of superior quality, innovation, and technological excellence are an integral part of our high-density NAND Flash devices.
• Scope includes creating a data mart using Oracle as backend, DataStage as an ETL Tool and Cognos as a reporting tool.
• Project involved development and implementation of a data mart for INVENTORY.
• Managed a team of 6 resources.
• Used DataStage as an ETL tool.
• Prepared technical specifications and use cases and developed DataStage jobs
• Designed job templates in XML format.
• Data is being extracted from SAP system, Oracle database and flat files
• Developed jobs and sequences
• Involved in Unit and System Testing
• DataStage, Oracle, Unix, Sybase

Dec 2005 – Jun 2006 · 6 mos

• is dedicated to turning imaginative ideas into leading products and services that helps solve some of the world's toughest problems. The services range from jet engines to power generation, financial services to plastics and medical to news and information.
• The project supports the organization in providing the ability to access operational data for management reporting (Black Belt Certified Managers) and allowing knowledge workers to investigate the history of the customer.
• Project involves development and implementation of a data warehouse for SALES.
• Developed Informatica Mappings from the technical specification provided by the client.
• Data is being extracted from Oracle database and flat files
• Used Informatica as an ETL tool.
• Developed mappings and workflows
• Involved in Unit and System Testing
• Involved in scheduling the workflows
• Informatica 7.1.3, Oracle 9i, Windows 2003, AIX UNIX.

Jan 2005 – Aug 2010 · 5 yrs 7 mos

• Worked as team lead as well as datastage developer

Jan 2005 – Dec 2005 · 11 mos

• PerkinElmer Fluid Sciences manufactures parts for the military and defense related markets.
• The project involved development and implementation of a data warehouse for PerkinElmer that encompasses the following functional areas:
• Sales and Marketing
• The project supports the organization in providing the ability to access operational data for management reporting and allowing knowledge workers to investigate the history of the customer.
• Project involves development and implementation of a data warehouse for SALES & MARKETING.
• Created tech specifications using the functional specifications
• Involved in preparation of low-level design document.
• Data is being extracted from SQL SERVER, Oracle and flat files
• Used Informatica as an ETL tool
• Developed the mappings and workflows
• Carrying out steps in grinder process such as extraction, transforming and loading.
• Involved in testing the application such as Unit testing.
• Involved in scheduling the workflows.
• Informatica, Oracle 9i, Windows 2003, AIX UNIX.

Jan 2005 – Jun 2005 · 5 mos

• Worked as datastage developer

Jun 2004 – Dec 2004 · 6 mos

• Worked as an ETL developer
• Project involves development and implementation of a data warehouse for mortgaged loans, specific to the states of US
• Data is being extracted from 5 separate sources Oracle, Mainframes, Sybase and Unix.
• The sources could be marketing or telemarketing systems (Sybase and Oracle) used to solicit the existing customers for new offers, or calling up new customers referred by the existing ones
• Mainframe source contains the loan origination information
• Used DataStage as an ETL tool
• The project supports the organization in providing the ability to access operational data for management reporting and allowing knowledge workers to investigate the history of the customer, as to whether sanctioning of the new loan or not
• Business Objects was used as a reporting tool
• DataStage, Business Objects, Oracle, Unix, Mainframes, Sybase

Jan 2004 – Jun 2004 · 5 mos

• Built the Data Mart for solicitations done by HSBC bank, and the responses from the customers, both existing and new
• The project involved analysis and enhancement of a Data Mart for home loans, specific to the states of US. Data is being extracted from 2 sources (Oracle/ Unix and Sybase/Unix) and has to be put onto Oracle database.
• The sources could be marketing/ telemarketing systems (Sybase and Oracle) used to solicit the existing customers for new offers, or calling up new customers referred by the existing ones
• Mainframe source contains the loan origination information
• Other mainframe source system contains the serviced loans
• Used Datastage as an ETL tool
• Project supports the organization in providing the ability to access operational data for management reporting and allowing knowledge workers to investigate the history of the customer, as to whether sanctioning of the new loan or not
• DataStage, Oracle, UNIX, Sybase

Jan 2003 – Dec 2003 · 11 mos