Ravindra Porwal

Experience Summary:

V Total 7.6 years of professional experience in IT industry, in the

field of Data Warehousing/Business Intelligence using industry

leading BI tools and technologies such as Oracle Data Integrator

(ODI), Informatica, Oracle Warehouse Builder (OWB),IBM Data Stage,SAP

BODS/BODI, OBIEE, Oracle (SQL & PL/SQL) and IBM Information Analyzer.

Have worked in multiple projects with various US and UK based clients

V Highly Motivated Business Intelligence professional with

specialization in building Data Marts and Data Warehousing with

Expertise in variety of ETL tools.

V Architect the ETL designs and provide best methodologies for Source

system extraction, naming standards, design of staging area,

Incremental loads, data quality, integration strategy,

monitoring,alerting,lineage,cleansing,testing,metadata

management,deployment,audit,archiving and documentation

V Experienced in Information Gathering, Requirement Analysis, Data

Profiling, ETL architect, ETL Design, Development, Testing,re-

engineering,deployments & on time Delivery.

V Engaged in various ETL processes from start to end and provide the

CRAVE C(Consistent)

R(Reusable)

A(Affective)

V(Versatile)

E(Efficient) solution for all ETL processes E.g.

Deployement,Packaging,ETL error tracking etc.

V Extensively worked on Design, Development and Administration of

various ETL processes based on customer requirement like Error

handling and error recovery, ETL Job control, Effective loading of

data into Dimensions and Fact tables, incremental logic, capturing

ETL audit statistics,restartabililty

V Expert in automation of various processes and stabilizes the complex

processes

V Mentoring and educating the team members and provide them training

and motivation in various areas

V Expertise with all ODI tools - Topology, Security Manager, Designer

and Operator

V Worked on both waterfall model as well as agile methodology projects.

V Specialized in all ETL tools available in market and cloud based ETL

(Snap Logic) and Open source ETL tools like Penteho.

V Working experience in OBIEE and worked as a link between ETL and

Reporting team for BI projects and developed the RPDs and reports in

OBIEE.

V Familiar with usage of tools like CQ,JIRA and SalesForce.com for

defect tracking

V Rich experience in Extraction of data from various data sources to

the staging area and performing various transformations on the data

and finally loading it to the target data warehouse

V Prepare estimation for given RFPs and provide the questionnaires and

responses to BD team.

V Excellent technical, logical, code debugging and problem solving

capabilities and easy grasping of new things.

V Worked with team and as well as individually motivated.

V Highly adaptable in quickly changing technical environments with very

strong organizational and analytical skills.

V Exposure to Various Domains like Sales(Retail),CRM and Inventory

Competencies

ETL Tools: ODI,Informatica,IBM DataStage,SAP BODI/BODS,OWB

Reporting Tools: OBIEE 11g

Verticals Manufacturing,Retail,Oil and Gas, Media,CRM

Databases: Oracle 11g, MS SQL Server 2005

Software Tools: TOAD, SQL Loader, SQL Developer

Development SalesForce.com,IBM Clear Quest, Jira

Tools:

Reporting Tools: OBIEE 11g

Environment: Linux, Windows Server 2008,Windows7/XP

Assignments:

1. Title: Cisco- NetAcad

June-14 -Till Date (3 month)

Client: Cisco,San Jose,USA

Technical Environment: Informatica,Oracle 11g, UNIX with Putty,

Liferay,Canvas,Toad with Oracle,SalesForce.com.

Brief Profile: Cisco Networking Academy delivers a comprehensive, 21st

century learning experience to help students develop the foundational

skills needed to design, build, and manage networks, along with career

skills such as problem solving, collaboration, and critical thinking. The

rapid growth of networks has created a global shortage of people who are

qualified to implement and maintain networking solutions. Every year,

hundreds of thousands of Networking Academy students worldwide gain the

skills needed to build, design, and maintain computer networks; improving

their career prospects while filling the global demand for networking

professionals. With 10,000 academies in 165 countries, Networking Academy

helps individuals prepare for industry-recognized certifications and entry-

level information and communication technology (ICT) careers in virtually

every type of industry.

BI system built on the all the data collected from all over the world by

Network academy.

Role: Computer System Analyst and Onsite coordinator

Responsibilities:

V Provides technical consulting and guidance to development teams for

the design and development of highly complex or critical ETL

architecture.

V Worked closely with the Project Manager and Data Architect. Assisted

Data Architect in design by doing source data analysis, rectifying the

requirement documents, creating source to target mappings.

V Created Informatica sessions and workflows and arrange all sessions by

using perl script

V Proposing architecting of new ETL using database table and perl

script.

V Implemented logic to archive the source files with date stamp affixed

after the successful load.

V Advise and implement 'Best Practices' for ETL in complex system

including processes for code migrations and configuration controls.

V Informatica Generic packaging creation to avoid the multiple

workflows.

V Written documentation to describe program development, logic, coding,

testing, changes and corrections, optimized the mappings by changing

the logic Included error-handling and exception handling by logging in

the error tables and sending an alert message via e-mail to the

concerned distributions list.

V Coordinates with offshore team and development schedules, maintenance

activities and staff across all BI project teams.

V Identifies opportunities for new development initiatives; makes

recommendations on the increasing scalability and robustness of ETL

platforms and solutions.

V Involved in performance tuning of sources, targets, sessions, and

workflows. Also involved in tuning of SQL queries.

V Identify, recommend and implement ETL process

V Manage build phase and quality assure code to ensure fulfilling

requirements and adhering to ETL development

V Identify bugs when developers are not able to do so.

V Allocate and re-direct resources

V Manage coordination between onsite/offshore teams

V Designing, developing and supporting jobs for to extract and load into

the database from different sources.

2. Title: DSR - ACTIVISION BLIZZARD

Apr-13 -May-14

Client: ACTIVISION BLIZZARD, USA

Technical Environment: Oracle Data Integrator (ODI), Oracle 11g, UNIX with

Putty, Toad with Oracle,SalesForce.com.

Brief Profile: Oracle Demand Signal Repository (DSR) leverages external

demand data to lower out-of-stocks at the store shelf and improve execution

of promotions and new product introductions. The result is a more demand-

driven enterprise with increased revenue and reduced costs due to better

demand planning, more accurate retail execution, and a more streamlined IT

environment. Activision Blizzard, Inc (worldwide pure-play online and

console game publisher.) uses Demand Signal Repository (DSR) to get all

external demand data of all retail stores, integrate and manage it and

provide the potential to capture the analytics on top of it. The Project

includes following activities:

V Load the different regions retail data into the DSR

V Design and Develop the various ETL processes based on customer

requirement like Error handling, Effective loading of data into

Dimensions and Fact tables, incremental logic, capturing ETL audit

statistics,restartabililty etc.

V Everyday tracking the retail data by creating and analyzing the OBIEE

reports

V To track and monitor every day loads on production and performance

issues

Role: Team Lead and Senior ETL developer

Responsibilities:

V Provides technical consulting and guidance to development teams for

the design and development of highly complex or critical ETL

architecture.

V Understanding the Requirement Specifications, preparing the Functional

and technical design documents.

V Advise and implement 'Best Practices' for ETL in complex and multi-

developer system including processes for code migrations and

configuration controls.

V Extensively researched on ODI packages and ODI 11g load plans and

creating the product based generic ODI components and ensuring that

all components are reusable and flexible enough to fit into every ETL

situations.

V Written documentation to describe program development, logic, coding,

testing, changes and corrections, optimized the mappings by changing

the logic Included error-handling and exception handling by logging in

the error tables and sending an alert message via e-mail to the

concerned distributions list.

V Coordinates development schedules, maintenance activities and staff

across all BI project teams.

V Interacted with OBIEE team during design and development of facts and

dimensions to accommodate all the reporting requirements.

V Identifies opportunities for new development initiatives; makes

recommendations on the increasing scalability and robustness of ETL

platforms and solutions.

V Involved in performance tuning of sources, targets, interfaces, and

packages. Also involved in tuning of SQL queries.

V Identify, recommend and implement ETL process

V Manage build phase and quality assure code to ensure fulfilling

requirements and adhering to ETL development

V Ensure that all related projects cooperate and coordinate with the

ETL DSR program team and BI team

V Manage coordination between onsite/offshore teams

V Designing, developing and supporting jobs for to extract and load into

the database from different sources.

3. Title: CRM - ACTIVISION BLIZZARD

Feb-12 -Mar-13

Client: ACTIVISION BLIZZARD, USA

Technical Environment: ODI,SAP Business Objects Data Services XI 3.2, Snap

Logic, Oracle 11g, UNIX with Putty, Toad with Oracle.

Brief Profile: Activision Blizzard, Inc headquartered in Santa Monica,

California,. And it is a worldwide pure-play online and console game

publisher with leading market positions across all categories of the

rapidly growing interactive entertainment software industry. Project

includes following activities:

V Day to day analysis by users on worldwide pure-play online and console

gaming data to improve the business.

V Extracting online data like games which are BlackOPs, Modern warfare

3(MW3),Call OF Duty from different applications,databases and

transform and load it into the database.

V Everyday tracking the statistics, behavior, events, trends of gamers

for these games to enable marketing campaigns.

V Design and Develop the various ETL processes based on customer

requirement like Error handling, Effective loading of data into

Dimensions and Fact tables, incremental logic, capturing ETL audit

statistics,restartabililty etc.

V To track and monitor every day loads on production and performance

issues.

Role: Team Lead and Senior ETL developer

Responsibilities:

V Manage the team such critical project and provide response in time

V Designing, developing and supporting jobs for to extract and load into

the database from different sources.

V Automation of data load using ODI and SAP BODS.

V Extensively researched on ODI packages and ODI 11g load plans and

creating the product based generic ODI components and ensuring that

all components are reusable and flexible enough to fit into every ETL

situations.

V Supporting and monitoring daily loads and performance issues

effectively.

V Making business users to know about the statistics, behavior, events,

and trends of gamers for these games to enable marketing campaigns and

measure the effectiveness.

V Tracking everyday huge gaming data effectively.

V Overcoming a lot of performance issues while supporting and delivery

in time.

V CRM application provides business users to know about the statistics,

behavior, events, and trends of gamers for these games to enable

marketing campaigns and measure the effectiveness.

V Ability to view data at a high level.

V Monitor ETL

V Modify ETL routines

V Make minor changes to ETL mappings

V Developing enhancements when ever required.

3. Title: Oneview

Dec-10 -Jan-12

Client: Proprietary Product of Rolta India Limited

Technical Environment: Oracle Data Integrator 10g/11g (ODI), SAP Business

Objects Data Services XI 3.2, SAP, Aspentech, Honeywell PHD,Oracle 11g,

Toad with Oracle.

Brief Profile: Rolta One View is a web-based business intelligence

application that empowers personnel to make on-time decisions at

all levels of the organization. Rolta OneView provides a platform to

improve performance and overall operational effectiveness by aligning the

work-process efforts of personnel with the goals of the business and

provides a center for collaborative decision making leading to lower risk.

Rolta OneView establishes a cross-functional paradigm shift, uniting users

around one view of their business.

OneView Data Warehouse Common Object Model provides an informational

backbone for all facets of OneView. This single point of access provides a

cross-functional view of multi-sourced information based on ISA and other

industry standards and best practices.

Role: Senior ETL developer and architect

Responsibilities:

V Development of ETL Interfaces, packages, procedures using Oracle Data

Integrator.

V Extensively researched on ODI packages and ODI 11g load plans and

creating the product based generic ODI components and ensuring that

all components are reusable and flexible enough to fit into every ETL

situations.

V Development of SAP BODS jobflows,work flows, data flows.

V Creating the ETL loading strategy for SAP BODS jobs and make those

jobs enable to run and control by database table and ensuring its

serial and parallel execution.

V Extraction of data from various data sources to the staging area and

performing various transformations on the data and finally loading it

to the target data warehouse

Involved in the Unit testing for the jobs.

V Extensively involved in the requirement gathering for various KPIs and

implement the data structure of tables according to the business needs

and populate the data according

V Researching on the Open source ETL tool to implement for current

product.

V Working on to create seamless and smooth installation procedure of the

ODI components like master and work repository, agent, physical and

logical schemas, scenarios etc. to any platform like windows or Linux.

V Developing the real time ETL for the real time reporting and for the

sources like Aspentech,SAP,PHD,MS Access,excel,flat files,maximo etc.

4. Title: HDS-RTS (May 2009 -Dec-10)

Client: HDSupply, USA

Technical Environment: IBM DataStage, Oracle PL/SQL, Toad

Brief Profile: HDSupply, the world's largest home improvement retailer,has the various types of business units such as Plumbing, Electrical,

Repair & Remodel, whitecap construction etc. and also for these business

units there are different subject areas like customer, invoice header,

invoice line, branch location etc. To provide ETL mappings to different

business units along with different subject areas, Informatica is using. So

data stage jobs use to extract data from source of various business units

and load it into destination. These jobs run on the daily, weekly, monthly

or yearly according to the schedule.

Role: Lead ETL Developer

Responsibilities:

V Involved in the requirements definition and analysis and creation of

high level and detailed design and mapping documents

V Worked with high volumes of datasets from various sources like Oracle,

text files, and relational tables

V Created the Repository, maintained source definitions, transformation

rules, and target definitions using Informatica Repository Manager

V Extensively used the following transformations, among others: stored

procedure (for index drop/rebuild), router (for creating multiple data

pipelines), lookup (connected & unconnected), update strategy (to

define insert/update/delete/reject), aggregator, and sequence

generator (for generating surrogate keys)

V Invoked stored procedures to perform database operations as a part of

post-session and pre-session commands

V Responsible for tuning ETL mappings and sessions via source

qualifier/lookup overrides to optimize load and query performance

V Analyze jobs and implement jobs according to the business needs.

5. Title: HDS - Sales Data Mart (Dec 2007 - Apr 2009)

Client: HDSupply, USA

Technical Environment: IBM DataStage, Oracle 10g, Information Analyzer,

Toad

Brief Profile: HDSupply, the world's largest home improvement retailer,has

the various types of business units such as Plumbing, Electrical, Repair &

Remodel, whitecap construction etc. and also for these business units there

are different subject areas like customer, invoice header, invoice line,

branch location etc.

Building a data mart for HDSupply to generate reports to analyze and

monitor their sales metrics.

Role: Lead ETL Developer and Lead data analyst

Responsibilities:

V As a data analyst analyze the data according to business and correct

the data coming from different source systems and provide the issue

logs to extract developers to correct data

V Development of ETL server jobs using DataStage Extraction of data from

various data sources to the staging area and performing various

transformations on the data and finally loading it to the target data

warehouse Involved in the Unit testing for the jobs.

V Involved in the ETL design and its documentation

V Interpreted logical and physical data models for business users

to determine common data definitions and establish referential

integrity of the system.

V Used Informatica Designer to create mappings using different

transformations to move data to a DWH

V Loaded the flat files data using Informatica to the staging

area.

Career Profile

Dates Organization Designation

Feb 2012 to Till date ZenSar Technologies Senior Software Engg

Dec 2010 to Jan 2012 Rolta india Limited Senior Software Lead

July 2007 to Dec 2010 L & T InfoTech Senior Software Engg.

Personal Details

Date of Birth 14-Dec-1985

Nationality Indian

Marital Status Married

Visa Status H1B Till Mar-2016

Personal Accomplishments

Degree/Certification/Publication Year of Passing

Academic B.E. with Ujjain Engineering College, June-2007

Qualification Ujjain

R.G.P.V. University, Bhopal

Certification 75%

s, Scores

Publications Presented the paper on annual BI360

/ Papers conference on the Data warehousing

technologies.

Participated in TECH FAIR 2013 in

ZenSar Technology and presented my

solution and appreciated by the chief

and audience

Languages English,Hindi

Known

Client / Team Got the Annual Excellence Award 2013

Feedback UBHARATA SITARA (RISING STAR) in

ZenSar Technologies for extra

ordinary work done for entire year.

Got the Quarterly EKLAVYA award in

ZenSar Technologies for outstanding

innovative work and committed to

goals and successfully follow.

Got Spot award in ZenSar for

implementing intelligent and

effective solutions and highly

appreciated by client

Got the Spot award in L&T InfoTech,

Mumbai for delivering efficiently and

achieve target before deadlines to

give maximum customer satisfaction.

Highly appreciated by the clients on

different occasions to provide them

new innovative ideas of development

to reduce the efforts.

Contact this candidate