Data Manager
Resume:
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