PANKAJ SHARMA

+91-9650591170, +91-9999953577
pankaj7sharma@gmail.com

EXECUTIVE SUMMARY
 Program Manager, Delivery Leader, Business Intelligence and Data ware House Solution Architect with Fifteen (15) years
of experience in Data Architecture/DW/Big data/Hadoop, Data Strategies, Data Management, Data Migration,
Operational Data Store, EDW, and Automations

 Expert in Strategies development, Project Management, People Management, SLA Management, Process Re-
engineering, Project Estimation & Feasibility, Defining Annual Operating Plans, Requirement gathering & analysis, Effort
Estimation, Client/Partner/Vendor Management

 Defining architecture for large distributed systems, technical consulting, project management and technology
implementation on Cloud – AWS and Azure systems, Big Data, Hadoop, Enterprise Information Management, Data
Management, Product Management and Application integration

 Managed and implemented projects for Data Engineering, Data Integration, Data Migration, Visualization, OLAP
DWH/ODS, Data Modeling using technologies like MSBI, IBM BI Stacks, Tableau, Oracle, SQL Server, Talend,
Snowflake, MySQL, DB2, Power BI, Python, MSBI, VBA/VBE/VBO on Premise and Cloud Platform

 Experience with implementing legacy and modern Data Warehouse / Data Lake on cloud. Good experience with Hadoop
distributions like AWS, Cloudera, Hadoop architecture and technology stack (Hive, HBase, Map Reduce, Sqoop, HDFS,
Oozie, and zoo keeper, Kafka, Spark, Kinesis, Hue, Phoenix, HBase, Apache Impala, Sentry and Lambda), Apache
Spark, Athena

 Managed larger enterprise level programs like Center of Excellence (CoE) for Business Intelligence and Analytics by
restructuring existing processes and centralizing teams. Span of control - 7 to 165 direct/indirect reportees

 Extensive experience to manage, work and engage with global teams. Have developed team in India and offshore and
directly worked with teams located at various geographical locations such as – East Hastings (UK), King of Pursea (US),
Raleigh (US), Paris (France), Rheinbach (Germany) and Helios (Singapore)

QUALIFICATION & TRAININGS

 MSC-Information Technology (Punjab Technical University, 2006)
 B.Com (Himanchal University, 2004)
 CAPM®, PRINCE2® Practitioner
 MCSD, MCP (SQL Server)
 AWS trained (July 2019)
Advanced Architecting on AWS
Big Data on AWS

SKILLS AND COMPETENCIES

Big Data Ecosystem: Cloudera, HDFS, YARN, MapReduce, Hive, Pig, Impala, Sqoop, Flume, Spark, Kafka,
Storm, Drill, Zookeeper and Oozie
ETL Tools: snapLogic, Talend, SQL Server Integration Services, IBM DataStage,
DWH Tools: MSBI, Amazon Redshift, Snowflake, IBM Cognos, SSAS
BI Visualization Tools: Power BI, Tableau, SQL Server Reporting Services
Databases: Oracle, SQL Server, DB2
Database Tools: SQL Server Management Studio, Query Analyzer, SQL Profiler, Toad
Data Modeling Tools: Erwin R6/R9, ER Studio and Oracle Designer
Development Methodologies: Agile/Scrum, Waterfall
Languages: PL/SQL, TSQL, MDX, Python, XPath, VB, VBA, ASP, PHP, ColdFusion
Version Control Tools: GIT, SVN, Jira, TFS

PROFESSIONAL EXPERIENCE

EVALUESERVE.COM December 2013 – Present

Designation: GM - Business Intelligence and Data Analytics
Role: Delivery Leader - DE/DM projects
Profile:
 Data Engineering delivery head, working for Beyond Data GmBH (German based Evalueserve entity) unit and catering
EU, US and South Asia regions
 Senior BI/DWH solution architect, provide technical and process leadership for projects, defining and documenting
information integrations between systems and aligning project goals with reference architecture

1 of 2
  Program manager for both legacy BI technologies (MSBI, Tableau, Power BI, SQL Integration services) and Modern
DWH / DataLakes on-premise and AWS/Azure clouds
 Lead end-to-end Hadoop implementation at large enterprise environment integrating with multiple legacy applications in
heterogeneous technologies (Microsoft BI, IBM BI stack, Oracle, SQL Server et al)
 Developed big data environment in a team of employees with different disciplines, managing and building team of
Cloudera/Hadoop/BI/EDW/ETL/Amazon Redshift/Snowflake specialist in Indian and offshore offices
 Heading operations for global customers/Clients/Partners for Application Development, Analytics, Biostatics, Cloud
administration and user management, Quality Assurance, Technical Support, Data Quality Management
 Enable team/s to create Proof of Concepts from scratch illustrating data engineering techniques can meet specific
business requirements reducing cost and time to market/clients/sponsors

BHARTI INFRATEL LIMITED April 2012 –December 2013

Designation: Manager - Technology
Role: PM - Business Intelligence/DWH
Profile:
 Delivery and Operations leader for Business Intelligence projects initiated by Bharti group’s companies ‘Infratel’ and
‘Airtel’. Managed IBM account comprising 35 BI/EDW software engineers and supervised Bharti’s IT team having 17 MI
and DB engineers
 Developed large enterprise Business Intelligence product “Ready Reckoner” under Center of Excellence program, which
involved centralization of de-centralized databases/applications/ERP and optimization of resources
 Initiated and established analytics under CoE Program for Bharti’s tower company. Continual saving of INR 45 million
per annum by re-engineering the existing enterprise reporting system
 Identified scope of automation within business processes and developing solutions/programs to minimize TAT, enhance
quality, reduce manual efforts and maintain compliance
 Managing appraisals, promotions, R&R, assigning targets to the team members and maintaining SLAs, provided CxOs
and executive committee with scorecards and dashboards for company performance

INC RESEARCH CLINICAL DATA SERVICES Sep 2009 -April 2012

Designation: Manager - Data Services
Role: Head - Delivery & Operations (Data Management)
Profile:
 Reporting into Sr. VP Data Services, Battle, UK office. Managed a direct team of 17 people (SAS, DB Analyst and BAs).
Handled Enterprise Reporting and its Operations for the EU and US region
 Participate in global cross-functional, cross-departmental & client meetings and recommend business, technical and
managerial solutions to optimize communication and minimize duplication of tasks for BI and reporting projects
 Develop project schedules. Negotiate with project team members to identify key milestones, project activities,
dependencies and risks, and develop associated timelines to create and manage project plan
 Pre sales support - Assisting the Sales team in formulating proposals (RFPs/RFIs) and supporting them to bring in Data
Services / Data Management projects. Mining existing accounts by extending the scope of current projects
 SPOC for enterprise BI/DWH projects (MSBI, IBM Cognos, Data Stage) with UK and US teams; successfully managed
internal & external client expectations

SEQUENTIAL TECHNOLOGY INTERNATIONAL July 2006 - Aug 2009

Designation: Manager
Role: Head – Automations
Profile:
 Head for Reporting & Information Systems function, managed direct and indirect 25 (Data Analyst/TL/AM) team members
 Centralization of department level and client data; implemented data centralization programs using SQL Server
 Responsible for optimization of running business operations by identifying scope of automation to reduce FTE, overheads
and support staff
 Managing client expectation in terms of dashboard/report deliveries, new/Ad-Hoc MIS generation
 Interacting with telecom clients to understand business process needs and provided them the solutions for COA,
workflow, reports formats and data analysis

HEWITT ASSOCIATES July 2004 - July 2006

Designation: Team Developer
Role: Programmer - Automations
Profile:
 Created documentation, work instructions and SOPs for various business operations
 Carried automations for business processes using VBA/VBE/SQL Server and created technical documentation for same
 Created frontend and done automations for HRMIS
 Developed web based tool for PMS management for department
 Helped client/s by pulling various data/reports from Oracle and SQL databases

2 of 2