Project Sales

SONAL RANE Mobile: +1-818-***-**** ~ E-Mail: ***********@*****.***

Experience Summary:

• Working in IT industry for past 6 yrs, associated with clients in various domains like Media & Entertainment, Manufacturing.

• Worked as Datawarehouse designer in various modules in Supply Chain and HR management.

• Current Role: ETL Designer for HR application.

• Working in Data Warehousing for past 6 years on to various Business Intelligence Tools like Business Objects and Informatica.

• Worked on different products of Informatica Powercenter like Informatica 7.1, Informatica 8.1, and Informatica 8.6.

• Also worked extensively on different products of BO 6.5 like Designer, Supervisor and Business Objects and BOXI R2 products like DeskI, Webi, Universe Designer, Central Configuration Management, Central Management Console, Import Wizard, and Report Conversion.

• Informatica 7.X Designer Certified.

• Well Experienced in “Administration & deployment of BO XI R2” & “Migration to BO XI R3” organised by Business Objects.

• I have proven myself in delivering high quality IT solutions and services on schedule and under budget.

• Excellent interpersonal skills in communications, client relations, and negotiation.

Projects Summary:

The details of the various assignments that I have handled are listed here, in chronological order.

Project # 8 HRDM – HR Datamart

Customer Electronic Arts

Period Dec 2010 till date

Description • This Project is to convert Sql scripts to run using Informatica 8.6 environment and tuning them to gain performance for process

Roles and Responsibilities ETL Architect

• Discuss with Business to understand the concurrency of the data.

• Design the Informatica workflow depending upon the concurrency.

• Prepare Functional and Technical Design documents

• Tune the sql using different tuning techniques of the oracle

• Unit Testing/System Testing.

• Co-ordination with Client Business for Requirement Gathering & UAT

• Shell scripting for invoking sql scripts using Informatica

Solution Environment Oracle 10 g

Tools Informatica 8.6,Unix,Oracle 10 g

Project # 7 NA Sales Reporting

Customer Electronic Arts

Period Jan 2010 to Nov 2010

Description • This project is for generating Analytical Sales Reports for North America Region of Elctronic Arts.

• This project involves Informatica ETL process to load Sales, Inventory & Forecast data to Sales Reporting Datawarehouse. Sell In data (Sales of EA to Retailers); EA Inventory data will be fetched from Oracle Apps ERP 11i.

• Forecasting data & Sales data reported by Retailers will be fetched from DEMANTRA 7.0.2 (Demand Plannig tool).Business rules are applied on data & stored in datawarehouse for 3 fiscal years.

• Based on this data, Materialzed views are created which are used to generate analytical canned reports which will show Sales data, Forecasting Data, Inventory Data which will help business to analyse Sales trends & forcasting trends .

Roles and Responsibilities ETL Architect and Onsite Coordinator

• Discuss with Business to understand the requirement and indentify the sources of data.

• Design data model for data flow of various data feeds like Sell In, Sell Thru, and Forecast data.

• Prepare Functional and Technical Design documents for Interfaces

• Prepare ETL document for the interfaces.

• Design and Development of fact/dimension entities, summary tables, Materialized views in Oracle.

• Development of ETL routines using Informatica using various transformations.

• Unit Testing/System Testing.

• Co-ordination with Client Business for Requirement Gathering & UAT

• Performance tuning of ETL Code & SQLs.

• Shell scripting for sending error files in attachment to Business Users.

Solution Environment Oracle 10 g

Tools Informatica 8.6,Unix,Oracle 10 g

Project # 6 MediaMorph Digital Reporting

Customer Warner Bros

Period Aug 2009 to Jan 2010

Description It is a project which involves Informatica ETL process to load Licencee digital data from MediaMorph Interfaces to Marvin Datawarehouse. Licencee like Apple, Sony, and Xbox sends the digital data through MediaMorph interfaces to Marvin who will be loaded into Marvin datawarehouse through Extraction, Transformation and load process using Informatica.

Roles and Responsibilities Onsite Coordinator and Informatica Designer

• Prepare Functional and Technical Design documents for Interfaces.

• Prepare ETL document for the interfaces.

• Design and Development of fact/dimension entities in Teradata.

• Development of ETL routines using Informatica.

• Unit Testing/System Testing.

• Co-ordination with Client Business & Systems team for QA.

• Performance tuning of ETL Code & SQLs.

• Writing shell scripts for merging ftp files to load the data.

Solution Environment Teradata

Tools Informatica 8.1,Unix,Teradata

Project # 5 Business Objects Administrator

Customer Warner Bros

Period Oct 2008 to Aug 2009

Description It is a project which involves administrative activities of BOXIR2. It includes content management, security management & server management of BOXIR2 enterprise. Content management consists management of reports & data. Security mangament consists of setting up the access security for groups & users. Server management consists of the managing the BOXIR2 services & cluster environement.

Roles and Responsibilities Onsite Business Objects Administartor

• Creation of Groups, Users, Folders, Objects, Events in CMC

• Security set-up based on the user profile

• Seeting up the application rights for users & groups

• Setting up of windws clusters for load balancing

• Development of Business Object Universe

• Worked with BO Tech Support to resolve production issues

• Setting up Window AD and Enterprise Authentication mode.

• Setting up “Single Sign On” on Business Objects enterprise

• Build Business Objects servers for latest BOXIR2 Patch Installation

• Maintenance of activities related to Universe, Reports and user Profiles.

• Report Busting using Publishing wizard to meet the requirements.

• Migrating data from one environement to other environment

• Infoview customisation for Business Requirement of Warner Brothers

Solution Environment Windows 2003

Oracle 10i

Tools BOXIR2,Business Objects 6.5, Webi 6.5,Tomcat,JSP

Project # 4 TOBI(Thetrical Online Business Intelligence)

Customer Warner Bros

Period Feb 2007 to Oct 2008

Description It is a project which involves cration of Business Object reports based on various functional areas used by territorial users.It also involves Universe Changes for various new functionalities.

Some customisations are also being done using jsp pages.

It also involves the testing of ETL routins using BO reconciliation report

TOBI is the application which involves Non US theatrical business of Warner Bros

Roles and Responsibilities Onsite Module Lead

• Territorial Deployment activities

• Tesing for ETL routins using BO reconciliation reports

• Development for the new enhancements like AR Pack, JV,End of run date etc from BO side

• Changes of Business Object Universe for additional functionalities

• Unit Testing/System Testing.

• Co-ordination with Client Business & Systems team for requirement gathering.

Offshore Module lead

• Testing for territorial deployment

• Tesing for ETL routins using BO reconciliation reports

• Resolution for BO Production issues

Jsp customisation changes

• Addition of new features in reports like Cascading Prompts, Merging of Dimensions in Webi, creation of Profiles etc.

Solution Environment Windows NT

Oracle 9i

Tools BOXIR2,Business Objects 6.5, Webi 6.5,Jsp, Informatica 7.1.3

Project # 3 EPE TBSCT DW

Customer GE Energy

Period May 2006 to Jan 2007

Description It is a project which involves cration of datawarehouse for the EPE TBSCT application run at France & Business Object Universe for the same which is to be used for ad hoc reporting by fuctional users.

EPE TBSCT application is the application involves manufacturing process of GE Energy

Roles and Responsibilities Offshore Project Lead - Informatica / BO Technical Lead

• Prepare functional and technical design documents for interfaces.

• Design and development of fact/dimension entities.

• Development of ETL routines.

• Development of Business Object Universe

• Unit Testing/System Testing.

• Co-ordination with Client Business & Systems team for QA.

• Performance tuning of ETL SQLs.

• Post Production Support

Solution Environment Windows NT

Oracle 9i

Tools Plsql developer,Informatica 7.1.3,Business Objects 6.5, Erwin

Project # 2 PREP-CPS DW & historical datamart

Customer GE Energy, Atlanta

Period Aug-2005 to Apr-2006

Description GE Energy Global Parts has Oracle 11.5.9 implement as their ERP system. The Parts team also has a Parts data warehouse that pulls ERP information and functions as the primary source of data for all Parts reporting metrics.

Energy Parts is working on a Process Re-Engineering Project (PREP) that is scheduled to go-live in Feb 2006. This project will make significant changes to several business processes that exist today and will also require the creation of a new Operating Unit in Parts ERP and to implement a Historical sourcing datamart for Parts.

Roles and Responsibilities Informatica – Business Objects Developer

Analysis of source system ETL Maps.

• Development of ETL routines historical datamart.

• Report development using BO.

• Design of BO Universe to facilitate ad-hoc querying.

• Unit Testing/System Testing.

• Co-ordination with Client Business & Systems team for QA.

• Performance tuning of ETL SQLs.

• Post Production Support

I have been given customer appreciation certificate fot this project for the work done during Production migration of this project

Solution Environment Windows NT

Oracle 9i

Tools Business Objects 6.5, Informatica 7.1.3, Erwin

Project # 1 Datawarehousing COE

Customer Internal

Period Jul-2005 to Aug-2005

Description Datawarehousing COE is undertaking the projects which are to be shown to the client as a Demo

Roles and Responsibilittie Team Member

• Understanding of existing products

• Understanding of tools which are used for the product development

Solution Environment Windows NT,Oracle 8i

Tools Infomatica,Business Objects,Data Stage

Technology:

Below is a list of important hardware, software products, tools and methods that I have worked with.

Hardware:

IBM pSeries 630

Software Products:

RDBMS: Oracle 8i/9i/10i, Teradata.

Languages: C,C++,Core Java , SQL, UNIX Shell scripts

Web Server:Tomcat

Operating Systems: Windows, UNIX

Tools:

BI/Data Warehousing Tools: BOXI - R2,Informatica 8.1, Informatica 7, Business Objects 6.5

Data Modelling Tools: ERWin 4.1

Certifications:

Certification Date Certified

Informatica Certification first level (Exam conducted by Informatica company) Nov,2006

Green Belt Quality certification & project Oct,2006

Qualifications:

Degree and Date Institute Major and Specialization

Bachelor of Technology Usha Mittal Institute Of Technology for Woment Computer Science & Technology

HSC D.G Ruparel College Science

SSC Balmohan Vidyamandir General

Career Profile:

Dates Organization

Since Feb -2006 TATA Consultancy Services ltd.

Apr 2005 – Feb 2006 Tata Infotech Ltd

Passport details:

Name as on passport Relationship Passport Number Date of Issue Expiry Date Place of Issue

Sonal Suresh Rane Self F3695589 20-MAY-2005 19-MAY-2015 Mumbai

• Having Valid US L1 B visa till Oct 2011

• Having Valid UK Work permit & Visa till Aug 2009

Personal Details:

Date of Birth 24-Jul-1982

Nationality Indian

Contact this candidate