Data Management

N aresh Jain

*************@*******.*** H ome Phone: 360-***-****

I mmig ration Status: US Citizen

Having 20 years experience in IT industry with more than 14 years working on different large

to complex data warehousing and business intelligence programs

Managing data warehousing and business intelligence engagements, assisting project leads in

various cross functional areas primarily in the business intelligence, analytics and data

warehousing verticals. Involved in setting up teams at new clients and delivery processes to

g row DW-BI footprint while building relationships with various stakeholders

Periodically inculcate thought leadership through facilitating ideas, assisting team in

governance, data management, enterprise BI solutions, business Intelligence roadmaps, tool

evaluation and analytics

Program managed retail distribution clients for the enterprise BI analytics and MDM by

exercising iterative development and conventional project management approaches. Mentored

a rchitects and developers to successfully deliver and build technical competency to deliver

value to the clients

Recently completed $3.8m account for the data integration, business intelligence and analytics

t racks for a retail client

Working with pre-sales teams across different industry verticals within Infosys for the

RFI/RFP responses and client presentations

Education: M .S from BITS Pilani, India

Certifications:

Certified Data Management Professional (CDMP/CBIP)-TDWI certified)

PMP (formal certification underway)

Infosys process methodologies and leadership

Microstrategy Certified, COGNOS trained, Business Objects certified, Informatica certified,

DataStage certified, TOGAF 9 Pre-Certified

Technical:

Proficient in wide range of BI tools and technologies like Informatica, Brio, Query, Business

Objects, Cognos, DataStage Enterprise Edition/DB2, Microstrategy, Microsoft OLAP Services,

SQL, EXCEL and other Data Warehousing related tools. Skilled in SQL Server 2000 and

O racle 8i/9i in administration level and data warehousing capabilities, BigData – Hadoop,

Tableau and QlikView

E xpé riences :

I nfosys Technologies Expérience: Dec’2003 - Continue

Oct’2011- Continue

Cisco - Analytics for Services

M anaging various analytics projects in the services areas with the re-designing in-memory

analytics solution for the covered & active products globally, using Teradata as a platform and

I nformatica as an ETL tool. Fixed bid end to end projects included complete SDLC (business

requirements gathering, ETL development, and QA and QlikView analysis queries). Multiple

p rojects have been further extended onto the Hadoop environment for the deep down data

analytics. Also involved with DB-Appliances, Tableau, ETL tools evaluation while working with

t he technology domain architects and managers.

Sep’2009 – Sep’2011

Ni ke - SAP implementation – I n tegration T rack & Cognos Analytics Reporting

T rack

For the SAP ERP solution, managed data integration track for the applications to applications

and data warehousing business areas. Managed multiple projects in various business

f unctional areas using BO data services, Informatica, Cognos analytics reporting and data

a rchitecture. Defined data integration architecture and selection of integration points based

on the case based scenarios with respect to what technologies to use and when. Played a key

techno-functional management role.

Feb’2008 – August 2009(Banking)

S unT rust - M a rger & Acquisition P roject

Program managed M &A (Merger and Acquisition) project for the design and development of a

f ramework/utility for the merger and acquisition of the banks. This project has touch points

w ith at least 27 people in the various phases of SDLC process. Reviewed technical work and

managed external resources for the business banking to interface with the M &A architecture

for the on line banking, check payments and small businesses and delivery of the financial

analytics.

Feb’ 2006 – Jan’2008(HealthCare)

Apria -Healthcare P roject ( Master Data Management – M D M )

Involved from the Pre-Sales to the inception of the project. Technically laid out MDM strategy

to bring payer, institution, providers and the claim business data. The phase 1 was more MDM

related business analytics oriented designed using Microstrategy as a BI tool.

• Managed multiple projects with a team of 21 resources

• Participated/architected master data management for all line of business

• Conducted JAD sessions with the business and the IT team

• Direct working with VP (IT) and VP of enterprise architecture group

• Worked with the stakeholder in carving out a multiyear roadmap

M isc (P re-sales & Org building) – I nfosys

• Working with different verticals sales groups within the organization on the LARGE

RFI/RFP responses

• Providing effort estimation, Proposing high level solution approaches

• Client presentations and RFP response calls with clients

• Planning and setting up teams once the RFP is materialized, Mentoring of juniors and

a rchitects

• Participation organization new resource hiring process

Oracle Corp. Expé rience: Feb’1999 – Oct’2003 – GE Power, H P

Senior Consultant

Led technical stream projects for the various Oracle clients in the area of Data Warehousing

and Business In telligence. Set up best practices for the data quality management, metadata

management, design and integration. As part of the Architecture Group at EMC, designed and

i mplemented a conventional enterprise data warehouse data model for all the three hops

(staging, ODS and DW). Conducted impact analysis of legacy data warehouse (1 year)

• Laid out enhancement strategy for the Enterprise Data Warehouse

• Design and developed new data marts for the customer centric business group

Lead consultant at HP group of projects, worked in different capacity (analyst, Data architect,

E TL developer, data modeler). Designed and implemented Forecasting Datamart

• Developed and recommended strategies and specifications for the BI solutions based on the

analysis on business goals, objectives, needs, and existing data systems infrastructure. Had

authority on ETL strategies/technologies for the forecasting model

• Requirements & gaps analysis from cross-functional teams; Strategy approach for

forecasting Datamart implementation; ETL design & development; Modeled product

h ierarchy management for the business forecasting group; Data integration for the

accurate product costing; Analyzed silo data warehouses for a possible consolidation

Implementation of Business Intelligence Purchasing module

Analysis of business requirements for the module extension; Architected ETL solution from

O racle Applications 11i; Designed purging strategy for the historical data; Led technical team

t hroughout for the implementation of the project. Designed and architected data integration

for the Oracle Warehouse Builder

I mation Corp. (3M Corp. Spun Off) Oct’1996 – Jan’1999

Team Lead/ Data Analyst / ETL Designer/ Data Modeler / Oracle DBA

Worldwide implementation of Oracle applications and Data Warehousing projects

• Requirement gathering and analysis; Legacy application data analysis; Analysis and

design of staging database; Analysis and design of Operational Data Store (ODS); Design of

Star and Snow f lake schemas; Laid ETL design strategy; Worked on data conversion loads

f rom legacy to warehouse; Designed and developed Oracle discoverer reports; Worked as

O racle DBA

I ndia Experience

CR IS & P riceWater House, I ndia Jan’1988 < Oct’1996

System Analyst - Center for Railway Information System, New Delhi

Designed and implementation of financial costing and accounting system for the in-house

accounts department

Designed and Implementation of Claim Processing Information System for Indian Railways at

4 d ifferent locations (Northern Railways, Western Railways, Southern Railways, North East

Railways) with Novell Networking and the model hook up to Railway Board in New Delhi. With

P riceWater House conducted the study on Thomson Press order management application.

Contact this candidate