Pankaj Dhole

About Pankaj Dhole

Management Consultant - Enterprise PerformanceBusiness Analytics SME (DWH, BI, EPM)TOGAF 9.1 Foundation Enterprise Architect22 years of professional experience.17 years experience on integrated financial planning and analytics covering strategic/business plan, sales/revenue planning, demand forecasting, workforce planning, capital expenditure planning, operational expenditure planning, project financial planning, tax planning, treasury planning, financial consolidations, funds transfer pricing and pricing strategies using profitability and cost management.22 years of global experience in development, support, maintenance, upgrade, migration, health assessment, solution design of Data warehouse, Business Intelligence and Enterprise Performance Management systems.Skills: Business Management, Management Consulting, DWH/BI/EPM solutions on pre-packaged and Customized Products, Solution Architecture, IT Delivery\\Portfolio\\Project management.Domains: Banking, Finance, Insurance, Retail, Manufacturing, Telecom, Aviation, Oil & Gas, Hospitality, Real Estate and eCommerce related systems. Transactional source systems: ERP Oracle Apps - Finance, HR, Supply Chain, Procurement & Spend modules, Peoplesoft HRMS, CRM (Siebel, Salesforce, Microsoft), OLTP Systems (Pega, Taleo, CareerLink, custom applications), Oracle Financial Services Analytical Applications (OFSAA Fund Transfer Pricing and Profitability Management) and Agile Product Lifecycle Management.Business Intelligence, Data Warehousing and EPM Tools: OBIEE, OBIA (Finance, Supply Chain, Human Resources, Sales, Service, Marketing, Product Life Cycle), Business Objects, Hyperion Interactive Reporting, Hyperion FinancialReporting, Crystal Reports, Tableau, Qlikview EPM Tools: Oracle Hyperion Planning, HFM, HPCM, EDMCS, EPBCS, PCMCS, FCCS, ARCS, TRCS, Narrative Reporting Master Data Management & Governance : Oracle DRM, EDQ, EDMCS ETL/ELT Tools: Informatica, Oracle Data Integrator, PL/SQL Databases : Oracle, SQL Server, DB2, MS Access and Hyperion Essbase Big Data : Microsoft Azure ML, Hadoop Cloud : Microsoft Power BI, Oracle BI Cloud Services (BICS)Advanced Analytics : R, SQL, Excel Scripts: SQL, PL/SQL, C, Java Script, VB Script, HTML, CSS, PHP, Python

Experience

1. Founder - Director

   Prayaam Software Services Private Limited

   Jul 2018 — Present

   Strategy and General Management- Research and development in Business Analytics, Enterprise Performance Management, Enterprise Resource Planning, Supply Chain, Human Resources, Customer Relationships Management, Artificial Intelligence and animation solutions and frameworksKey Assignments- Integrated enterprise performance management solution for a corporate client in Middle East covering consolidation, budgeting, reconciliation, profitability, tax and narrative reporting- Route profitability for an Aviation client and Integrated financial planing and consolidation for a Manufacturing client in south East Asia- Integrated financial planing for a telecom client in Middle East- Financial consolidation close and planning for a Middle East and Africa client- Data cleansing, transformation and reporting for a client in UK- Managing Microsoft CRM, Power Platform, Power Apps and Power BI projects for multiple clients in India and North America- SaaS Products development and support for clients in India- Graphic design services for clients in India and North America

Education

• Visvesvaraya National Institute of Technology

  BE, Electronics

  1999 — 2003

• Symbiosis Centre for Distance Learning

  PGDBA, Finance

  2005 — 2007

Skills

• Data Integration
• Microsoft Sql Server
• Software Development Life Cycle (Sdlc)
• Hyperion Epm
• Testing
• Master Data Management
• Informatica
• Data Migration
• Business Objects
• Pre-Sales
• Obiee
• Analytics
• Vendor Management
• Epm
• Business Intelligence
• Crystal Reports
• Etl
• Sdlc
• Hyperion Interactive Reporting
• Solution Architecture
• Business Intelligence Tools
• Pl/Sql
• Data Modeling
• Oracle Applications
• Oracle E-Business Suite
• Extract, Transform, Load (Etl)
• Business Analysis
• Oracle
• Requirements Analysis
• Hyperion Planning
• Integration
• Data Warehousing
• Software Project Management
• Sap Businessobjects
• Crm
• Hyperion Financial Reporting Studio
• Essbase
• Dashboard