BI Project Manager

Desh Deepak Bali MBA, PMP

(971-**-******* •• **********@*******.*** •• Linkedin

BUSINESS INTELLIGENCE & DATA WAREHOUSE MANAGER

Obtain a long-term career managing a technology team, collaborating with internal/ vendor/ customer contacts, and architecting innovative and highly effective Business Intelligence & data warehousing solutions.

PROFILE

BI/ DW manager with over 15 years of proven management in Automotive, Retail, Hospitality, Media, Marinas, Non-banking financial service and Manufacturing domains.

Proficient in working with executives to translate the vision into actionable strategies resulting in multiple enterprise data management solutions including data warehouses, data quality, business intelligence and data integration.

Geared for Enterprise mobility solutions comprising of self service BI which are device independent and cloud aware.

Proven track record of building relationships, developing strategies, building road-maps, as well as, implementing data solutions through multiple concurrent methodologies.

Defining software, hardware and network requirements, analyzing IT requirements for EDW, BI solutions and enterprise wise business application integration.

MANAGEMENT & TECHNICAL SKILLS

Disciplines & Training

Project Management, Human Resources Management, Application Development (Oracle, C, Powerbuilder, SQL Anywhere), Data Warehousing, ETL, Software Development Life-Cycle (SDLC), Agile & Scrum, Data Mining using SAS, Basic Statistics using SAS, Base & Advanced SAS

Programming Languages

SAS, SQL, Unix Shell Scripting, JavaScript (JS), VBScript, SQL, SOAP, XML, XSLT, Basic, Visual Basic (VB), VBA, Perl, Python, HTML, Cascading Style Sheets (CSS), Stored Procedures, Triggers, DTS, SSIS

Applications & Tools

Qlikview/Qlik sense, SAS, SAS VA, Informatica, IBM Cognos Business Intelligence 6, Miscorsoft Sharepoint Portal, Microsoft Visual Studio, Microsoft Visual Interdev, Microsoft Visual Basic, Microsoft Visual Source Safe (VSS), Microsoft Project, Microsoft SQL Server (SP, DTS & SSIS), Microsoft Office, Microsoft PowerPoint, Microsoft Word, Microsoft Excel, Microsoft Access, Microsoft Outlook, Oracle, TOAD (The Oracle Application Developer), MySQL, Apache Web Server, Microsoft Internet Information Server (IIS), Adobe Acrobat, Sybase, Sybase IQ, Teradata, Hadoop

Operating Systems

Microsoft Windows (95/98/NT/CE/ME/XP/2000/2003/Vista/7/Mobile), UNIX (Sun Solaris, Linux and HP Unix)

Core Competencies

Data warehouse & Business Intelligence

Business/ Requirement Analysis

Product/ Project Management

Mentoring & Coaching

IT Roadmap strategic engagements

Cross Functional Team Coordination

Team Leadership

Process Improvement

GM(Software Delivery), Amtek Auto - New Delhi 2014-15

Amtek is a $5 billion group spread across US, Europe, Japan, China and India, comprising of various diverse verticals namely Aerospace & Automotive components, Mining(Coal & Iron), Power generation, Hospitality and Packaging.

Responsibilities

Partnered with leadership to set IT strategy & direction appropriate for rapid growth environment; initiated Data warehousing & self service BI plans per vertical in effective and efficient manner.

Aligned Business Intelligence G&O’s to enterprise objectives and strategies, identified key/focal areas which would be covered by BI namely MRM, CAPEX and Quality

Identified appropriate performance metrics(ROMI, ROI, Revenue/EBITDA) for Executive Dashboards in SAS VA from MRM data. Appropriate filter for Region, Business unit & Customer to ascertain revenue vs operating costs

Presented Consolidation plan for multi-silo data environments into an enterprise data warehouse for optimum hardware and resource usage.

Operated effective IT governance framework that includes appropriate function leads.

Coordinated overall technology investment and operating budget and routinely seek opportunities to optimize IT total cost of services.

Established strategic service provider partnerships and vendor management disciplines.

Accomplishments

Formulated business intelligence strategy for Barista chain of restaurants from Hyperion to Microsoft BI suite to save cost and formulated road-map for move to Qlikview for next generation BI solutions with integration of loyalty and social data across 250 outlets in india

Planned enhancements to SAS VA based Executive Dashboards to reflect forecasted data for EBITDA, Revenue and impacted metrics

Presented multiple proposals and conducted POC’s for group wide CAPEX data mart and BI Dashboard using SAP PS & Fiori/BO, the dashboard tracked key KPI’s like ROI, Revenue, Budgeted vs planned and forecasting the next quarter financial implication.

Establishment of measurement metrics on routine support and project performance.

Senior Project Manager, SAS Research & Development - Pune 2010 - 14

Effectively manage BI & Analytics based products/solutions with revenue of $15M in Customer Intelligence, Digital marketing, Customer Analytics for Retail, Forecasting and Inventory optimization.

Primary liaison between the Cloud implementation team and Product Development & Management; managing relationships and communication.

Manage a diverse cross-functional team of 100+ resources that include business analysts, data analysts, developers, production support engineers, architects, UX designers, quality assurance analysts, data base administrators, and Release engineering & configuration specialists.

Successfully managed multiple overlapping software releases for the development and deployment of an Enterprise Business Intelligence (BI) & Analytics solution.

Report and review project progress on a regular basis with executive management and key stakeholders. Determine and monitor project resource levels; hiring and training resources as needed.

Proactively monitor project risks and develop contingency plans.

Participate RFP’s and assist with proposal efforts.

Senior Software Manager - Testing, SAS Research & Development - Pune 2007 - 10

Managed sas-access group of development testers, BI/data visualization automation & accessibility team working on various SAS BI & Analytics products/solutions.

Technical Manager & Mentor for :

oSAS-Access Products

Unix & Windows : Informix, Sybase, Sybase IQ, MySQL, HP Neoview, Pcfiles(office stack) & Oledb

MVS : ADABAS, Datacom, IMS, IDMS

oThreaded Kernel Table server products (API testing) :

Unix & Windows : Oracle, Teradata, DB2, Sybase

Owning responsibility for quality & schedule

Created Test strategy/Plans as per SRS/MRD

Track project milestones and deliverables.

Proficient in SAS v9.1/9.1.3/9.2/9.3 and strong experience in Base SAS, SAS/Stat, SAS/Graph, SAS/Macro, SAS/ODS, SAS/Access, and SAS/SQL under Windows environment.

Solid understanding of data cleansing, data management and data processing techniques like merging, concatenating, interleaving, appending of SAS datasets and data validation using Proc Compare and Proc Freq.

Good understanding of SAS functions like Character functions, Date functions and familiar with Formats and Informats.

Thorough experience in extracting data from various disparate data sources like (xls, csv, txt) files, Oracle, SQL Server, MS-Access, etc. Ability to analyze & process data using various SAS procedures such as utility procedures, report procedures, statistical procedures.

Well versed with platform for SAS Business Analytics typically client tier consisting of SAS VA or SAS Enterprise guide, SAS Add-in for Microsoft Office, SAS Information Map Studio, SAS OLAP Cube Studio and middle tier consisting of SAS Information Delivery Portal, SAS Web Report Studio, SAS Stored Process Web Application, SAS Content server and SAS BI dashboards.

PREVIOUS EXPERIENCE

1994 - 2007

Servitium IT Solution, Delhi Data warehouse/Database Architect

Hewitt Technologies, Gurgaon Data warehouse/BI Project Lead

Honda Siel Cars Ltd, Noida BI Consultant

RR Financials, Delhi Data warehouse/BI Consultant

Tulip Software, Delhi Manager Support & Development

EDUCATION

Master of Business Administration - International Business from Sikkim Manipal University, India

Diploma in Computer Application from Amity University

Bachelor of Arts - Mathematics from Moti Lal Nehru College, Delhi University

References available on request

Projects Worked on @ Amtek

1. Executive Dashboard Amtek comprise of many verticals and MRM data was used as input to compare sales vs manufacturing data along with revenue, quality and Ebitida/EBT

Existed Dashboards were tweaked to reflect SAS VA forecast guidance to know the variation from budgeted/plan.

SAP integration was still not complete, the excel sheets were used to import data from various vertical/regions.

Created BPM application to track Quality issues across plants and integrated with SAS VA

Worked on a cloud based POC from Qlikview in line with planned move to cloud, this facilitated providing greater flexibility to executives and the supporting team to create on demand reports as per the need.

2. CAPEX planning workbench Amtek comprise of many verticals and Capex projects are tracked for ROI, Fund requirement and budget vs actual metrics.

Creation of multiple reports categorised by Vertical, company and regions wise.

The reports reflect revenue actual vs budget, Turnover, Ebitda related metrics data across the category.

Did multiple POC’s with Finario, Qlik, SAS VA and SAP PS/Business Objects, SAP PS was chosen on the basis of cost and ongoing SAP implementation across plants

3. Barista Essbase transition

Barista chain of restaurants were acquired by Amtek auto, was involved in M&A team to transition BI reports from Essbase to Microsoft BI suite as stock gap arrangement. Created a EDW & BI roadmap for transition to self service Bi using Qlik view/sense integration with SAP adapter for Qlik.

Transition 14 reports, spread over 3 broad categories Company, Owned stores, New stores, Commissary. The reports reflect revenue actual vs budget, Turnover, Ebitda related metrics data across the category

Several POC’s were conducted to ascertain the right fit on the basis of Capex and Opex cost for each.

Projects worked on @ SAS R & D

Customer Analytics for Retail using SAS VA, SAS, Lazr in memory Analytics server, Java Mid tier, SAS Di studio, Base sas ETL and Oracle & Hadoop cluster

Supply Chain Management using SAS VA, SAS BI(Flex), Java Mid tier, SAS Di studio, Base sas ETL and PostgresSql

Inventory Optimization Workbench using SAS VA, SAS BI(Flex), Java Mid tier, SAS Di studio, Base sas ETL and PostgresSql

Forecast Analyst Workbench using SAS VA, SAS BI(Flex), Java Mid tier, SAS Di studio, Base sas ETL and PostgresSql

Marketing Resource Management(multiple versions released) A hosted and on premise CRM solution using Microsoft BI, .net studio, SSIS scripts for ETL and Sqlserver/Oracle warehouse

Contact Center Planning & Optimization( 2 versions released) using SAS VA, SAS BI(Flex), Java Mid tier, SAS Di studio, Base sas ETL and Oracle warehouse

SAP Adapters using SAS DI studio and Sap surveyor

oFinancial Management

oInformation Technology Resource Management

oService Parts Optimization

Projects worked on @ Hewitt

1. Your Benefits Resource (YBR 5.0) Your Benefits Resource (YBR 5.0) is one of the Largest Web Interface used by the Hewitt Clients to enroll into services like Defined Benefits, Defined Contributions and Health Management.

Analysis of existing OLTP Systems. Extensively involved in creation of Informatica mappings for extracting the source data and transformed the data into target tables according to business logic.

Implemented performance tuning by optimizing the mappings and sessions to increase the session performance as well as Unit testing and Functional testing.

Created reports in Cognos Report Net and HTML

2. Capgemini Defined Benefits and Recruitment Warehouse Capgemini HR of North American region was outsourced to Hewitt, the data warehouse was in Oracle which used to pull data from peoplesoft and ODS. Business Object and Excel reports were used to publish dashboard reflecting employee turnover and attrition. We had to publish 4 reports daily and at the end of month payroll and befit data was combined with turnover numbers to generate executive dashboard and set of 11 report reflect region/BU wise reports.

Led the intial transition from capgemini to Hewitt and later transition to offshore location at Gurgaon.

Managed a team of 20 including business analyst, ETL & BI developers/testers to deliver the reports as per schedule.

Led technical migration of select reports from oracle/excel to informatica/cognos

Created Detailed Low Level Design Documents.

Designed & Developed Informatica code, creating sessions and workflows for Data Loads.

Review Informatica mappings to verify Coding Standards. Designed solutions to improve performance by tuning the mappings in Informatica and SQL tuning using Indexes.

Contact this candidate