Business Intelligence IT Professional

PROFILE

Sandip brings over 18 years of extensive experience in the areas of Business Intelligence, data warehousing and master data management. Technically sophisticated and business savvy management professional with a pioneering career reflecting strong leadership qualifications coupled with “hands-on” expertise. Maintain focus on achieving bottom line results while formulating and implementing advanced technology and business solutions to meet a diversity of needs.
Core Areas of Expertise:

• Program and Project Planning and Management
• Enterprise Business Intelligence Governance
• Master Data Management/ Data Integration
• Data Warehouse Assessments
• Data Modeling, Data Quality and Profiling,
• Enterprise Data Architecture,
• Enterprise Data Warehousing
• Mentoring Programs
• Off-shore development

PROFESSIONAL EXPERIENCE

Independent Consultancy Dec. ’07 – Present
Confidential May ’11 – Present

Project Manager
Implementing a custom BI analytics for United Health Group in term of financial (claims) and non financial reporting (clinic success).
Environment: Oracle, SAS

Confidential Feb ’11 – April ‘11

Client Manager

Responsible for implementing a BI analytics for investment portfolio
Environment: Oracle, OBIEE

Confidential Nov ’10 – Present

Sr. PM 
Implementing Business Intelligence solution for VMWARE.
Technology track: Oracle 10g, OBIEE, Informatica

Confidential Jun ’10 – Present
Sr. PM
Implementing Enterprise BI solution using Oracle BI Apps

Confidential Jan ’10 – Mar ‘10
Program Manager, Global Data Center Program
Responsibilities:

Co-coordinating Data center virtualization with both IT and business.
It is a driving factor in the global data center strategy which will 
increase business agility, global availability, collaboration, and growth capabilities,
as well as capacity and resiliency.
Different tracks (Teradata, Oracle, Informatica, SAS, OBIEE, BO etc.) from the IT side and Different apps (Quote-to-cash), CRM, Click stream etc.) need to move to a Global Data Centre to a shared Virtualization framework (not Cloud computing or SAAS).

Confidential May ‘09 – Oct ‘09
Datawarehouse Manager
Responsible for managing a redesign effort of an existing Enterprise data Warehouse to incorporate the following features…

• Instead of applying data transformation logic at all layers, the new data warehouse should have all logics applied only at transformation layer
• Decouple the Operational and BI application to add more flexibility to business process without compromising BI requirements
• Improve performance by about 30% to meet the SLA
• Appropriate definition of system of records

Confidential March 2008 – March 2009
Sr. Manager, Professional Services (BI)
As a Senior Principal Solutions Architect, Managing Architect, and Project Manager, 
Sandip was involved primarily with Delivery to a lesser extent, with Business Development 
at high profile and visible clients. 
Sandip focused on thought leadership in establishing business intelligence competency 
centers in an automobile industry. 
Responsibilities include (but not limited to)

• Defining BI Drivers… What is propelling to adopt BI culture
• BI constraint…. The pain points that need to be addressed
• BI Strategy…
• What is to be built
• How it is to be built
• Driving a forward-looking view of the business
• Ensuring alignment to corporate strategy
• Enabling more effective decision making at all levels of the company

Key Achievement:
Estimated and budgeted projects accurately with the Senior Leadership Team and Project Stakeholders, repeatedly bringing projects in on time and on budget

Confidential Oct 2006 – Nov. 2007
Sr. Manager

Sandip was hands-on facilitating the discovery of and alignment of business drivers and processes, leading to prioritization of IT initiatives in terms of technical capabilities – this in turn, is driving innovation in the road mapping techniques that detail the improvements, projects, timelines, and budget required. This details analytic methods that frame business performance improvements in terms of integrating informatics with business processes and knowledge sharing. 
Responsibilities include (but not limited to)…

• Business Case Assessment
• Analyzing performance improvement opportunities by looking at data pain points.
• Focusing on process instead of technology to realize value
• Leading with the business community
• Understanding Enterprise Data Flow.
• Enterprise Infrastructure Evaluation
• BI tools evaluation

Key Achievement:

• Managed and designed large data migration and integration effort, due to Mergers and Acquisition

Confidential April, 2004 – August, 2006
Sr. Manager, Enterprise Data Warehouse

Sandip has developed a program strike zone that documented the key business success criteria targets and thresholds and has accelerated the development and implementation of an Enterprise Data Warehouse from eight departmental data marts. Implemented all Mortgage Service Package (MSP) extracts into one enterprise data warehouse positioned to feed all downstream data mart applications of the Loan Servicing Business Unit thus helping the organization to manage the loans in a much better way. Sandip managed project resources (including but not limited to number of people & skill sets, hardware configuration disaster recovery), progress, completion timeframes, and budget. There were 9 project teams consisting of 125 people.

Key Achievements.

• Established offshore infrastructure development team(hiring people, setting up infrastructure, assigning job responsibilities etc.) and coordinated offshore activities which includes both development and loading of data every night and QA
• Saved the company over quarter million dollars every year by receiving the source files (from 3rd party) only once instead of receiving the same 180 files a number of times for each data mart.

Confidential 2002 – 2004 

Senior Manager/Program Manager
Engagements include:

Confidential Aug 2003 – Feb 2004
Business Intelligence Technology Manager.
Responsibilities:

• Insured viability of the integrated program plan from the business perspective in designing master plan for a data warehouse project to meet requirements of the California State Health Department
• Based on the data volume and retention of the data, defined the system architecture.
• Defined the data architecture and metadata
• Insured the program stays within the boundaries of the Program Strike Zone
• Coordinated with vendors for hardware and software procurement as per specifications defined

Confidential Feb 2002 - July 2003
Sr. Project Manager
Responsibilities:
.

• Lead multiple project teams through the application development life cycle. Insured that all project team deliverables are developed in synchronization so the whole project is delivered as required.
• Implemented best practices for Enterprise Data Management project utilizing PMI methodology.
• Acted as a catalyst to ensure that all four project teams of the EDM project work in alignment
• Instrumental in creating and institutionalizing data warehouse methodology standards to create a repeatable and refined process

Key Achievement:

• Improved productivity(approx: 10%) by developing a master plan, including best practices methodology, to coordinate project efforts among 4 independent teams standardizing norms, procedures, and usage of tools.
• Brought lagging projects back on track with appropriate resources for successful completion. Analyze current organization structures and provided recommendations for change – focusing on alignment with new data and metadata management requirements. Ensured information and extract, transform and load architectures were sound, extensible, and scalable

Confidential 1998 – 2002
Provider of system integration services for clients with a heavy concentration in automotive manufacturing industry 
Manager, Professional Services
Responsibilities:

• Managed all areas of business intelligence/data warehouse projects including project planning, scheduling, analysis, design, development, test and implementation.
• Responsible for building a strong business intelligence team.
• Developed business intelligence methodologies and process guidelines which improved process; utilized this new methodology to complete and improve quality of three Businesses Intelligence projects namely Sales and Marketing data mart, financial data mart

Key Achievement:

• Improved skills, productivity of junior staff members by introducing knowledge sharing forums, etc.

EDUCATION

M.B.A 
Masters of Technology, Industrial Engineering & Management 
Bachelor of Electrical Engineering 
Project Management Certification