Experienced IT Project Manager

Distinguished leader of IT and a Certified Project Manager with extensive experience developing and promoting Business Intelligence and Data Analytics through strategy, design and architecture. Solution oriented technology manager with a proven track record of gaining the competitive advantage through strategic vision and leadership in direct support of global business objectives. A recognized leader and motivator of individuals to maximize levels of productivity.

Professional Experience

PepsiCo, White Plains, NY

Sr. Manager – Reporting and Data Analytics 2015 to 2018

Business Relationship Manager for Business Intelligence and Data Analytics for Finance, Supply Chain, Marketing and Food Service functions of North America Beverages division.

Worked closely with business partners to understand the business process and gaps to recommend IS solutions, resulting in multiple BI projects impacting internal P&L and business operations.

Functioned as primary IT point of contact for business to brainstorm and recommend Data & Analytics solutions to improve business performance and productivity.

Developed novel solutions to the demands of the division’s supply chain and revenue management cycle.

Led strategic planning to improvise data extract and reporting from very complex DB2 data warehouse by multiple BI tools including Business Objects, MicroStrategy, Tableau, OBIEE, and internal Enterprise Reporting Tool. This resulted in minimal data discrepancy amongst all reporting.

Managed various aspects of DB2 data warehouse to Teradata data warehouse migration. Responsibility included successful migration of all BI reporting apps including OBIEE and SAP Business Object.

Managed multiple complex Data and Analytics projects. Results include better tracking of Plant Production Line performance, Simplified Sales Planning and Forecast for key national accounts, and implementation of strategic finance initiative to show true reflection of concentrate sale and its impact on internal P&L.

Mentored and coached team members with leadership and personal growth tools to achieve their professional goals.

Managed internal and external suppliers of hardware and software.

Managed vendor relationship including staff augmentation for both on-shore and off-shore resources.

Pepsi Beverages Company, Somers, NY

Manager – Business Intelligence 2012 to 2015

Project Manager and People Manager responsible for leading the Business Intelligence program to advance capability and optimization for the Finance Control organization by supporting and managing multiple BI initiatives.

Led International project for the Global Audit team for automating audit management done by KPMG to track and monitor all audit requests and status globally.

Implemented strategic initiatives to establish PMO and Quality Center to enable better control and standards on process and deliverables.

Led the development and configuration of SharePoint 2013, in-premise environment of 180+ sites, for Finance Control.

Led multiple strategic projects including Supplier Request Form enhancement for collection of W9 documents up front and mandate EFT setup for new suppliers, resulted in eliminating the need to track vendors for W9 and mailing the checks to vendors.

Managed multiple projects using various BI tools including Business Objects, SQL Server, Visual Studio, SharePoint, QuickBase, Monarch and MS Office applications, resulting in returning 5000+ productivity hours to the Control organization.

Hands-on development using SQL Server, Business Objects, Visual Studio, SharePoint, and other IS solution tools.

Apria Healthcare, Lake Forest, CA

IT Project Manager 2011 to 2011

Provided leadership for development of revenue sensitive insurance compliance project using budget control, production timetable, status reporting, client project team coordination, and quality assurance.

Led revenue sensitive insurance compliance project for business catering to sleep disorder patients.

Managed project in a global, matrixed environment with internal (IT and Business) and external (3rd Party Service Provider, on- and off- shore) teams.

Praxair Healthcare Services, Danbury, CT (Acquired by Apria Healthcare)

IT Project Manager / Business Intelligence Specialist 2007 to 2011

Provided leadership for development and support of various data marts that directly impacted daily operational, billing, and sales activities of the business using all aspects of software development.

Provided system concept development, requirements gathering, design, development, testing, and implementation with adherence to high Praxair Integrity standards.

Delivered in-house CRM tool under budget and per plan to the sales force, resulting in better monitoring structure and increased sales lead. Recognized by VP of Sales and Marketing for outstanding work.

Implemented consolidated reporting methodology, saving the company $15,000 per year in licensing costs.

Implemented operations reviews, metrics, dashboards and design/architecture improvements that increased data availability from 70% to 99.5%.

Delivered consolidated data mart of 10 million+ rows, feeding from multiple data sources residing in different applications, resulting in reduced time and effort by business for operational activity and reporting.

Hands on involvement in ETL and BI development using Visual Studio 2005, SQL Server 2005 and Cognos 8 BI reporting modules.

Praxair Inc, Danbury, CT

Cognos BI Administrator / Developer 2006 to 2007

Mediacom Communications, Middletown, NY

Cognos BI Administrator/ Developer 2004 to 2006

STME Ltd., Bahrain

Cognos BI Administrator/ Developer 1999 to 2002

First Computers, Bangalore, India

Training Executive – Computer Integrated Management 1996 to 1999

Education

London College of Advanced Studies, London, England

Master of Science in Computer Science

Delhi University, New Delhi, India

Bachelor of Arts in Economics

Technical Expertise

Database Oracle, SQL Server, Teradata, Sybase, MS Access

Software MS Project, MS Visio, Visual Studio 2005, SQL Server 2005, SharePoint, SAP Business Objects, Cognos 8 BI, OBIEE, Tableau, Monarch, MS Office 2010, MS Publisher, QuickBase, Enterprise Applications.

Certification

Project Management Professional Certification by PMI

Certified Trainer on Leadership and Personal Growth with John Maxwell Team

Advanced Diploma in Systems Management by NIIT

Lean Six Sigma Leaders Training

Predictive Analytics Fundamental – PepsiCo University

Cognos 8 BI Administration and Development

Contact this candidate