https://www.linkedin.com/in/diwakar-mohan-rao-*a**0a3/

Versatile Professional offering experience in Project Management, Data Warehouse Management, Business Intelligence & Solution Delivery across Healthcare, Pharmaceuticals, Manufacturing, CRM, Finance domains, sales, marketing

Handling delivery for a team of 200 members.

Handling COE excellence for BI and DW practice grew the practice

Expertise in leading business application architecture & design efforts; maintaining application architecture for business functional areas across Retail, Telecom & Banking domains

Excels at building & maintaining data warehouses and working with disparate data sources & transforming them into a unified solution; record of liaising & coordinating with respective teams for gathering and analyzing requirements for the enterprise-wide data warehouse

Subject matter expertise in resolving integration & interface issues between systems with focus on optimizing application performance & scalability; implemented enterprise Data Warehouse including a consolidation of multiple tools into one single BI/DW Tool

Distinguished proficiency in driving business intelligence & reporting, performing data analysis for business owners while defining, developing key metrics & business trends; insightful knowledge of spend, metric analysis & business intelligence analytics

Leveraged capabilities of managing & mentoring large teams; front-led a team of 50-150 Developers

MCA from Madras University in 2001

Bachelor’s Degree in Applied Mathematics from Madras University in 1997

May 2019 – July 2019 with Systech India pvt lmt as Senior BI DW Architect

Key Result Areas:

Engaged in Data Analysis for ETL Process to create dimensional model, mapping workflows; managed the administration module of Business Objects Data Integrator

Analyzed the user needs & software requirements to determine feasibility of design within time & cost constraints

Suggested technology-based solutions for enhancing functional efficiency and achieving business excellence

Worked on all phases of data warehouse development life cycle from requirement gathering to testing, implementation & support

Interacted with clients for requirement gathering; evaluated technical and commercial feasibility of solutions

Jan’13 – May’18 with Intelliswift, India as Senior BIDW Architect

Key Result Areas:

Managed operations related to technical architecture while ensuring a high degree of reliability & availability

Accomplished & executed projects with respect to cost, resource deployment, time overruns and quality compliance to ensure satisfactory execution/delivery of the same

Engaged in Data Analysis for ETL Process to create dimensional model, mapping workflows; managed the administration module of Business Objects Data Integrator

Analyzed the user needs & software requirements to determine feasibility of design within time & cost constraints

Suggested technology-based solutions for enhancing functional efficiency and achieving business excellence

Worked on all phases of data warehouse development life cycle from requirement gathering to testing, implementation & support

Interacted with clients for requirement gathering; evaluated technical and commercial feasibility of solutions

Designed and implemented statistical/predictive models with diverse sources of data in order to predict demand, risk and price elasticity

Highlights:

Implemented analytical warehouses including 1 for Smith & Nephew with SAP as the back-end & Business Objects as the front-end for over 6 Country SAP Analytics

Designed & implemented different schemas for reporting & analysis using Data Modeling tools

Developed Dimensional Modeling for data warehousing like Snow Flake & Star Schema

Previous Experience

Mar’12 – Dec’12 with UST Global, Chennai, India as Architect

Oct’09 – Dec’11 with Virtusa, Chennai, India as Associate Architect

Jul’05 – Oct’09 with Intelliswift Inc., Fremont, CA as Senior Business Objects Architect

Jan’04 – Jul’05 with Scientific Information Technology Inc., San Jose, CA as Senior Business Intelligence Lead Consultant

Sept’02 – Dec’03 with Success Software, Chennai as Senior Software Engineer

Nov’01 – Aug’02 with Silikon Technologies Ltd., Chennai as Senior Software Engineer

Jan’01 – Nov’01 with Stepstone Ltd., Chennai as Software Engineer

Jan’97 – Jul’00 with ABSDEK Info Solutions, Chennai, as Software Engineer

Technical Skills

Windows NT/2000, UNIX

Oracle 7/8/9.x, DB2, SQL Server 7/2000, 2005, 2008 Oracle 10, 11g, SQL and PL/SQL, SQL* Loader, Erwin

SAP Business Objects 4.0,Xi, 6x, 5/4.x., Web Intelligence, Broadcast Agent, Business Objects SDK, CMC, Supervisor, Designer, Crystal Reports, Xcelsius

BO Data services, Data Integrator Xi, 6.1.5, SAP BI7, Informatica Power Center 10, 8/Power Mart 10, 8 Cognos 7

SAP BI, FI/CO, SD, MM MS Office, Visual Basic, VBA, MS Access, IIS, ASP, Java Scripting, VB Script, Shell Scripts

Visual Interdev, HTML, Visual Source Safe, Far Point Spread, Dreamweaver 3.0, Photoshop 5.5

BI/Data Warehousing using Business Objects 4.1, SSIS, SSRS, SSAS, Web Intelligence, Business Objects SDK, BO Data Services, SAP BI7, Cognos, Data Stage, Informatica 10, SAP HANA s4, Big Data, Hive, Pig, Java, power bi

Personal Details

Refer to the Annexure for Project Details

Projects Undertaken

At Intelliswift

Title: Biogen

Description: Biogen have to be upgraded from the old version of Oracle to a latest version which

needs mapping from the old version to the latest version.

Responsibilities:

Gathering business requirement, conceptualizing the model, creating high-level design & LDM/PDM; engaged in data mapping and coordinating with Build & Semantic Team

Creating & modifying project plans and resourcing for Data Model Team, Risk Tracking & Quality Maintenance

Engaged in Remap universes from 11i to R12

Represented Biogen in the initial requirement gathering sessions with different line of business of Biogen

Providing strategic solution architecture & reviewing the same with Business & Functional Team

Title: BCBS (Blue Cross Blue Shield)

Description: The scope of the project was to develop latest data warehouse with a star schema from a

old version of the database.

Environment: SAP Business Object 4, HANA s4, BO Data Services, SQL Server 20082012, Informatica,

SSRS, SSAS, SSIS, Windows Server 200

Role: Architect

Responsibilities:

Analyzing ETL and report requirement, preparing technical design document, evaluating the design of the ETL, semantic layer; identifying gaps in the requirement to meet development requirements

Acting as Technical Authority for ETL, EDW, Front-end & Infrastructure and making technical architecture and designing decisions across the entire technology stack.

At UST Global

Description: The purpose of the was to provide architectural roadmap for clients by implementing

redundant & scalable solution.

Period: Mar’12 – Dec’12

At Virtusa

Description: Engaged in a project to provide architectural roadmaps for clients by implementing

redundant & scalable BI/DW solution.

Responsibilities:

Provided POC for new concepts & solutions

Evaluated different products for feasible solution; analyzed the concerned areas and provided DW/BI solutions

Client: Philips Healthcare

Description: The aim of the project was to identify the issues pertaining for conversion of Actuate

reports to Business Objects.

Role: Architect

Environment: SAP Business Object 4, Oracle 11 G, Windows Server 2003, Informatica

Responsibilities:

Managed the Data Migration processes starting from defining approach to design, build, fallout analysis, segmentation strategy, execution & load to new data warehouse

Led the Data Conversion Team to create database design for Data Warehouse and reporting Data Marts

Established the Governance Mechanism in discussion with onsite; identified the stakeholders agree on governance mechanisms (Status Reports, Project Oversight and Steering), process and quality documentation

Client: Standard Charted Bank

Description: The aim of the project was to design the COS (Customer Originating System) System DB

and to provide a Star Schema for reporting and semantic layer for reporting & analysis.

Role: Associate Architect

Environment: SAP Business Object 3.1, Oracle 10 G, Windows 2003 Server, Red Hat Linux 5

Client: Iron Mountain

Description: The objective of the project was to provide scalable solution for its multi-lingual semantic

layer and reports and to translate the reports from English to French and a universe

(semantic) layer to support multiple languages.

Role: Associate Architect

Environment: SAP Business Object XI 3.1, Oracle 10 G, Windows XP/2003 Server

Client: McKesson

Description: The objective of the project was to understand the requirements to provide a scalable

solution for dashboard reporting using Xcelsius with customization for reporting.

Role: Associate Architect

Environment: SAP Business Object XI 3.1, SQL Server 2006, Windows XP/2003 Server

Client: CITI Bank

Description: The objective of the project was to provide a customized design for BS Team to do

reporting and analyze the problem to provide a robust environment for analysis and ad

hoc reporting through Business Objects.

Role: Architect

Environment: SAP Business Object XI r2, Oracle 10 G, Windows XP/2003 Server, Linux 5.8

At Intelliswift Inc.

Client: Smith & Nephew, Andover, MA

Period: Apr’07 – Nov’08

Role: Senior SAP Business Objects Architect Consultant

Description: The aim of the project was to provide cross-functional reporting which was not possible in

BW and to provide a better & a faster scalable solution for reporting & analysis of the

Sales & Finance teams

Environment: SAP Business Objects Studio XI R2, SAP R3, SAP BW, SQL Server 2003

Client: Callaway Golf

Period: Feb’07 – Mar’07

Role: Business Objects Architect Consultant

Environment: SAP Business Objects Studio XI, Data Integrator Xi, Oracle 10 G, SAP R3, SAP BW, SQL

Server 2003

Client: AON Warranty Group

Period: Jan’07 – Feb’07

Role: Business Objects Architect Consultant

Environment: SAP Business Objects XI r2, SQL Server 2000, DB2 V8, Micro Strategy, Excel & Access

Client: Prime Therapeutics

Period: Apr’06 – Dec’06

Role: Business Objects Architect Consultant

Description: The scope of the project was to convert reports from SAS modules into business objects.

Environment: Business Objects XI r2, SQL Server 2000, DB2 V8, Informatica, Excel & Access

Client: Salesforce.com

Period: Jan’06 – Mar’06

Role: Senior Business Objects Lead Consultant

Description: The objective of the project was to convert the back-end of the CRM tool Sales force into

a dimensional model database.

Environment: Business Objects Studio XI r2, Data Integrator XI, Oracle 10G, 8i, Excel, Access

Client: Fannie Mae

Period: Oct’05 – Dec’05

Role: Principle Business Objects Lead Consultant

Description: The objective of the project was to fix the existing ETL framework and create Excel

Macros for analytics & reporting needs.

Environment: Business Objects Studio XI, Data integrator Xi, Oracle 10 G, 8i, SQL Server 2000, Excel,

and Access

Client: Skechers Inc.

Period: Sept’05 – Oct’05

Role: Principle Business Objects Lead Consultant

Description: The project was aimed at teaching the client “How to Use Data Integrator and the Best

Practices”.

Environment: Business Objects Studio XI, Data Integrator Xi, Oracle 10 G, 8i, DB2

Client: Impac Companies

Period: Aug’05 – Sept’05

Role: Business Objects Lead Consultant

Environment: Business Objects Studio XI, Data Integrator Xi, Oracle 10 G, 8i, SQL Server 2000

At Scientific Information Technology Inc.

Client: Silicon Valley Bank

Period: Mar’05 – Jul’05

Description: Migration of old reports to the new version of Business Objects

Environment: Business Objects 6.1, SQL Server 8.0, Oracle 9i, MS Access, VB Macros, Erwin Data

Modeling

Client: Blue Cross Blue Shield

Period: Oct’04 - Mar’05

Role: Business Objects Lead Consultant

Description: The purpose of the project was to data model their existing database to a Star Schema

for better performance & scalability.

Environment: Business Objects 6.5, Business Objects Data Integrator 6.1.5, SQL Server, MS Office,

Erwin Data Modeling

Client: Intel Corporation

Period: Jul’04 – Sept’04

Role: Senior Business Objects Developer

Environment: Business Objects 5.1.7, Business Objects SDK, SQL Server, MS Office & Visual Source Safe

Client: Department of Health Services - Deloitte & Touché

Period: Jan’04 – Jul’04

Role: Senior Business Objects Developer

Environment: Business Objects 6.0, 5.1.7, Web Intelligence, Business Objects SDK, Broadcast Agent,

VBA, Erwin 2.0, Visual Source Safe and SQL Server 2000

At Success Software

Title: Development of a Corporate Site for Chennai Based Company

Period: Sept’02 – Dec’03

Environment: Windows NT, VB 6.0, Far Point Spread, SQL Server, ASP 3.0, Dreamweaver 3.0,

Photoshop 5.5 and MS Access, Crystal Reports

At Silikon Technologies Ltd.

Title: Automation of Super Market

Period: Nov’01 – Aug’02

Environment: Windows NT, VB 5.0 and SQL Server, Crystal Reports

At Stepstone Ltd.

Title: Back-office Maintenance

Period: Jan’01 – Nov’01

At ABSDEK Info Solutions

Title: Material Resource Planning (MRP)

Period: Jan’97 – Jul’00

Environment: Oracle 8, Visual Basic 5.0, Crystal Reports

adbsjq@r.postjobfree.com AMSHAAUMRAO@GMAIL>COM

Diwakar Mohan Rao

Business Intelligence Data Warehousing

https://www.linkedin.com/in/diwakar-mohan-rao-0a970a3/

+91-944*******

Performance driven Professional with nearly 22 years of experience; skilled in adopting a pragmatic approach in improvising on architectural solutions and resolving complex business issues

Targeting strategic assignments in Data Warehousing/Business Intelligence with an esteemed organization

Executive Profile

Education & Credentials

Career Timeline

Key Impact Areas

Data Warehousing COE

Business Intelligence

Business Analysis

Technical Excellence

Delivery Management

Techno-managerial Functions

Functional Consulting

Client/Stakeholder Engagement

Key Skills

Thinker

Tech-savvy

Innovator

Communicator

Collaborator

2013-2018

2012

Virtusa as Associate Architect

Intelliswift Inc. as Senior Business Objects Architect

Scientific Information Technology as Sr. Business Intelligence Lead Consultant

Success Software as Senior Software Engineer

UST Global as Architect

Intelliswift as Senior BIDW Architect

2009-2011

2005-2009

2004-2005

2002-2003

Professional Experience

Date of Birth: 25th July 1977

Languages Known: English, Marathi, Tamil and Hindi

Address: Chennai, India

Contact this candidate