IT, Business Intelligence, Cognos, Data warehouse, BI Architect

E-mail:

*******@*******.***

Phone: 858-***-****

Sanjeev Dhirar

Summary of Offer total of more than 25 years of IT experience with

qualifications last 10+ yrs in building BI /Data warehouse solutions and

Finance Planning/ budgeting solutions. Prior to that was

involved in implementing ERP / EAI solutions at various

client locations in US.

More than 7 yrs experience in managing BI & ETL team and

responsible for design and development of BI / DW projects

and led a team of BI analysts, data architects, data

modelers, BI & ETL developers to deliver BI solutions to

business users. Customer service focussed & engaged with

business continously to ensure they have access to

information to efficiently meet their objectives.

Superior communication, interpersonal, and presentation

skills; Excellent project management, team building skills

and expert in building consensus and project engagement

across all levels of management and stakeholders.

Computer Skills Operating System

UNIX, Linux, MS-DOS, Windows XP, Window NT, Windows 2003&

2008 Server 64bit

Languages

C++, Java, PL/ SQL, HTML, XML

Database

Microsoft Access, Dbase, Foxpro

RDBMS/4 GL/ Multidimensional Database

Oracle 10g/ 11g, MS SQL Server/ OLAP Cubes, SQL Plus,

PL/SQL

ERP

Baan 5.0c(& earlier versions), Peoplesoft, Oracle Apps

11.5.10, Oracle Apps R12

EAI Application

IBM Websphere (previously Crossworlds)

BI Reporting & Analytics/ Planning tools

Cognos Series 7, Cognos Reportnet, Cognos 8, Cognos 10,

Cognos Planning & Contributor, Cognos TM1, OBIEE, Hyperion

Essbase, Hyperion Planning, SSAS, Crystal, Tableau

Data Warehouse/ ETL

Oracle warehouse builder, Informatica, SSIS, Oracle PL

/SQL, Transact SQL

Modeling

Erwin, Visual Studio, Framework Manager, Transformer

Other

MS Office products, MS Sharepoint, MS Project, MS Access,

MS Visio, Citrix etc

Work Status

US Citizen

Professional (Sept 2007 until Present)

experience Resmed Corp, San Diego, CA

(BI Manager)

Manage the BI & DW team and responsible for design,

development and delivery of BI / DW projects - well versed

in activities including business requirements analysis,

data profiling, data modeling, Solution architecting, ETL

design & development, OLAP/ Cube development, reports &

dashboard design, bursting, active reports and their

delivery automation etc. Engage with business continously

to ensure they have access to information to meet their

objectives.

Architected, Designed, Implemented and Managed setup of

Data warehouses using Oracle PL/ SQL, Informatica, OWB and

BI Systems including Cognos, Tableau & OBIEE at Resmed.

Manage BI departmental budgets and control actual spending

within budget limits

Lead BI Steering committee with key business leaders/

partners to help present, approve and prioritize BI

projects

Introduce data governance process and involve/ mentor power

users from business serving as data owners

Recently migrated from Cognos 8 to Cognos 10 and

implemented latest features like Active reports, Active

burst reports,Mobile reporting on iPad etc.

Helped build BI & ETL team at Resmed and great coach/

mentor to the team

Achieved great productivity from BI / DW teams keeping

small team size while expanding BI presence in the company

from 20 users to 400+ users

Built BI roadmap for expanding BI usage and promote

self-service data access capabilities along with building

automated report delivery solutions

Rollout online Cognos access to entire sales team across

the Americas for self-service reporting & analytics and to

help meet their sales targets - project included

integration Cognos within CRM tool (SFDC)

Setup and managed offshore BI and ETL teams to reduce costs

to maintain and implement BI projects

Expanded BI usage by keeping tight control on software

costs

Implemented various BI applications including Cognos,

Tableau, Manhattan SCI / SSIS/ SSAS and OBIEE /OBIA

solutions

In-process of re-designing global DW using Informatica as

well as consolidating Cognos into single global environment

Lead and managed various business critical projects like

ROS - Resmed Online Store rollout providing business with

data to perform reporting & analytics on sales promotions

and help expand customer base & increase sales, TASP (True

ASP analysis for accurate pricing & margin analysis) etc

(June 2006 until Sept 2007)

Fairfield Residential, San Diego, CA

(Sr. BI Specialist)

Cognos 8 Framework Manager Modeling, Report Studio

authoring - Includes modeling (DMR, relational, OLAP) with

all various sources, data warehouse/ datamart. Debugging

and analysis, publish databases from Cognos Planning, CDS

links, Powerplay integrations, Cognos Planning and Cognos

Finance integrations

Powerplay Transformer Cube design/development/analysis

Assist BI Users, business analysts and SME's for their

requirements gathering using fact qualifier matrix.

Conceptual, logical and physical model design, gap

analysis for model design (based on Cognos SIM and TDWI

Methodologies)

Mentor and guide business analysts, junior BI resources

with Cognos products, issues and business analysis

BI Processes & workflow design, prepare BI Governance

process & methodologies

Hardware and server layouts/ architecture design,

performance tuning, best practice methods for Cognos setup

Planning, maintaining, configuration and loading user

classes required for Cognos Contributor Applications (Batch

process elist user class update)

Software installations on Cognos environments (test and

prod), setup, Cognos configurations on BI servers,

monitoring, performance improvement steps etc

Design security for BI, Cognos Planning, Contributor

environments - Package, Folder security planning for Cognos

connection designed and implemented for test and production

environments, Cognos Planning and Contributor security

designed, coordinated with user groups for implemention

Integration of Cognos Planning with BI, Publish databases,

maintain /monitor/validate jobs/ reports

(August 2003 Till June 2006)

ACCENTURE Inc., San Diego, CA

(BI Specialist)

Design, Development and Implementing Cognos - using

framework manager modeller, Cognos Transformer, report

authoring, Powerplay cube design and BI reporting

Involved in design of Cubes, star schema modelling and

building cubes using Cognos Powerplay and Transformer.

Provided BI/ Data warehouse development and support using

Oracle warehouse builder ETL tool, SQL Navigator and Cognos

reporting - work performed includes coordination with

business on DW requirements, design and develop star

schemas, cubes/dimensions and link/extaction process from

ERP, support DW /ETL jobs using process flows and maps,

support ad-hoc reporting for business etc.

Designed and developed various maps, views, process flows

for job scheduling etc for ETL /BI - Data Warehouse to load

staging tables and create final data marts

Provided techno-functional development and production

support in BI/ Data Warehouse environments including

business and systems analysis, root cause analysis, testing

etc.

Performed BPR activities, Gap analysis for ERP and BI

products like Cognos, ETL etc and developed/supported ERP

products - Baan 5.0c, Peoplesoft

Closely interacted with technical team and co-ordinated

technical development and support from both onshore and

offshore resources.

(June 2000 Till Aug 2003)

DANA CORPORATION, CT

(ERP Lead Analyst)

(Engine Mgmt. Division)

Analyzed user requirements, designed functional/ technical

specifications, provided techno-functional support in areas

of Finance, Manufacturing, Distribution and Supply Chain.

Studied and converted user requests to functional

specifications.

Lead several IT projects like adding new site to Baan,

development of Baan-Aspect (e-Source) interface, Archiving,

Baan-Lawson interface, Baan 4c2 to c4 upgrade etc

Data migration and conversion performed.

Designed and developed various new ERP modules

Mentor other ERP analysts

Training given to ERP user group for better understanding

and functioning of interfaces.

(January 1998 - June 2000)

INTELLIGROUP Inc., New Jersey

(Principal Consultant)

Assignments:

(July 1998 - June 2000)

Client: Dana Corporation, Chicago, IL

Worked as Project Technical lead, overseeing a team of 10

developers, Project management from start of the project

till go-live (full-life cyle) implementation and lead the

ERP technical team.

Analyzed, Designed and developed technical specifications.

Systems Analysis, Customized and Developed numerous

interfaces between Baan and Lawson like inventory

adjustment updates, finance GL upload, Sales order

interface, inventory reconciliation interface, Supply chain

interface, Parts demand interface etc.

Developed various new process and update sessions,

interfaces and reports (100 plus) in the areas of

Manufacturing, Distribution and Finance.

Implemented EDI 830 for Supply chain Sales schedule import.

(Jan 1998 - July 1998)

Client: Philips Semiconductors, Sunnyvale, CA

Performed Systems analysis, technical specifications

definition (Using Connectware barcode driver setup).

Systems analysis and developed Interfaces with the legacy

systems like export screening interface, interface with SOS

software

Manufacturing and Distribution modules customization like

Prod. Order entry, generate outbound and release outbound,

new modules for packaging information storage and its

interface with shipment process etc

(June 1997 - Jan 1998)

SE TECHNOLOGIES Inc., Irvine, CA

(Senior Analyst)

Assignments:

(Dec 1997 - Jan 1998)

Client: Overland Data, Inc., San Diego, CA

Sales order lines and Sales history sessions modifications

Modifications to manually override the ABC field in item

master

(June 1997 - Dec 1997)

Client: Summit Electric, Inc.,New Mexico

Detailed Systems Analysis, Scoping, and writing functional

and technical specifications, Customizations &

enhancements.

Finance application session changes done like check

printing formats, general ledger reports etc.

(April 1991 - June 1997)

GODREJ AND BOYCE Infotech Ltd, India

(Asst. Manager)

Configuration and Development of Baan ERP undertaken for

India's largest manufacturer of office automation

equipment's in a Make-to-Order and Engineer-to-Order

environment

Perform Gap analysis, mapped activities/ processes for

office equipment division.

Developed functional & technical specifications for

required customizations/enhancements.

Certifications

IBM Cognos certified

Resmedallion Winner - Awarded Best Employee at Resmed in

2009 by CEO

APICS CPIM Certified

BAAN ERP Certified

Trainings /

Courses Cognos Series 7 Version 3 PowerPlay Exploration and Report

Building

Cognos Reportnet1.1 - Authoring and Modelling fasttrack

Cognos PowerPlay OLAP Modeling for Series 7 Version 3 &

Cognos 8 BI

Cognos BI Advanced Report Authoring - Part II

Cognos BI Framework Manager Modeling -Advanced (Part II)

Cognos BI Metrics Studio Modeling

Cognos Planning (Analyst, Contributor)

Cognos Planning Technical Administration

Dimension Modeling in Depth - Kimball University

OBIEE/ Informatica/ DAC training - Oracle University

Oracle Warehouse Builder 10g (Data Warehouse ETL and

reporting)

Microsoft SSIS/ SSAS training

Data Modeling Techniques/ Courses by TDWI

Big Data (Hadoop/ Map Reduce) training courses by TDWI

ERWIN Data modeling

ERP Basic certification (covering all modules)

Baan ERP Enterprise Logistics (Manufacturing &

Distribution) certification.

Dana University certificate for supervisory training in 1)

Problem Solving and Decision Making, 2) Product Cost

Analysis and 3) Finance Planning for Business Success.

IBM Websphere Interchange Server EAI tool certified

(Previously Crossworlds)

Peoplesoft and Peopletools I/II training certification

Tableau training

Completed Situational Leadership & Productive conversation

training

Education

Bachelor of Engineering - Production Engineering (4 Year

degree equivalent to BS - Industrial Engg.) - Graduated in

1989

PG Diploma in Computer Programming in Unix, C and Oracle

(1991)

Contact this candidate