I have 16+ years of experience in SAP BW/BOBJ implementation/Support along with other SAP/Non-SAP software applications, encompassing a broad range of technologies and areas. Having fair understanding / hands-on of HANA (SP6), HANA studio and BW on HANA. Proven ability to leverage and incorporate best practices and innovation to architect BI and Corporate Information Factory solutions as strategic enterprise shared services to optimize decision making processes. Proven and dedicated strategic leader as Technical Manager / Solutions Architect for multiple solution and tool implementations in Utilities and Consumer Products industries. - BW/BOBJ Architect o Solution designing, Standard templates, BW and BWA Sizing, Performance tuning, Technical spec preparation, Design review using BOBJ 3.x and BI 4.1, Migration from BOBJ 3.x to BI 4.1 - BW Functional o FI/CO, FI-SL, SD, MMs, ISU, EAM, FICA, SGE (Smart Grid), DM, QM - SDLC o Planning, Designing, Realization, Testing, Executing and Support - HANA / In Memory DB Concepts o HANA Understanding, HANA Studio, Calculation, Analytic, Attribute view usage and optimal design - Maintenance (AMS) o Incident Management, Problem Management, Crisis Management, Change Management, SLA tracking, SAP Support pack testing strategy etc. - Implementation o 2 full life cycle, major / minor enhancements - Business Solution Designing o Setting BRM/Business expectation, Providing optimal design as per client tool, landscape and system capacity - Planning o Budget planning, Business alignment with IT, Projects / Enhancements Prioritization, - Programming o ABAP routine review, BODS SQL review, BODS jobs and schedule review - Reviewing o Design review, data model review, performance review and other documentation review - Performance Tuning, testing etc. o BW and BWA performance measures, BW and BWA Sizing, planning for testing strategy which includes test data from production to quality and development landscape

IT Manager (BW and DBA) @ Project Management. From November 2014 to Present (1 year 2 months) Senior Project Manager @ Project management From June 2014 to November 2014 (6 months) Portfolio Manager SAP BW and ERP & CA @ EDSI – Consumer Energy (ISU) BW Portfolio Manager SAP BW AMS Transition Management SAM BW Production Stabilization •Knowledge Transition Management for ISU •Production environment stabilization, Managing BW and BWA data archival plan for good system health •Managing BW support as well as minor / major enhancements (SOW Preparation) •Leading team of 18 resources •Incidents / Problem / Change tickets management, Management of change requests •Managing business expectation and helping them out for the new requirement •HANA Assesment for the customer need and POC •BOBJ 3.x to BI 4.1 upgrade •SLA tracking / Management / Client Escalation management •Resourcing •Project Plan Preparation •BW Data archiving plan •Transport release process management and sync between production vs. Project landscape •New data model design / architecture / estimation review •Knowledge of ISU data model (Sales Statistics, Open Item, BFD, CATS, EAM) •ISU (IS Utility) reporting and month end/year end support strategy preparation From September 2011 to June 2014 (2 years 10 months) SAP BW Lead @ Jones Retail Corporation SAP BW Lead SAP BW Project Lead Production Support Enhancement • BI lead for the Query / Workbook development including 24x7 production support • Extensively used the cell editor in BEx query designer for complex report requirement • Requirement gathering from business users in Sales and Purchasing Functional / Technical specification preparation • Defined work packages and technical specifications for design, development, testing and roll-out • Hands on development of data model for the various functional requirements by implementing queries and cubes using standard business content (e.g., BW Statistics) • Worked with functional consultant for mapping the source data (SAP / Non-SAP (AS/400)) to target Data Sources in BI • Defined the initial sizing requirements based on source data volume estimates • Setting up Precalculation Server for information broadcasting • Defining Global BEx template as per business requirement • Worked with the users for defining the reporting needs and helped design/develop flexible queries and pre-calculated reports using BEX reporting features like variables, exception and conditions in Sales and Purchasing areas. • Created SAP BI reports which include o Plan/Actual revenue comparison, o Order and sales value by sales representatives and Vendor delivery efficiency. • Analyzed report performance for statistics and implemented proposals for aggregate creations and indexing. • Using ABAP for SAP Exit variable in Transformation Start and End routine • Using Replacement path queries • Trained users in reporting functions and ad-hoc queries. • Active involvement during requirements gathering, blueprinting, solution recommendation and fulfillment of resources. • Project resourcing, job description, interviews, etc. • Lead team of up to 8 individuals to provide the following deliverables o Scope Document o Project Plan o Management of change requests o Organization chart From 2005 to 2011 (6 years) Senior Software Engineer @ From 2000 to 2004 (4 years) Senior Software Engineer @ From 2000 to 2004 (4 years) Software Engineer @ • Analysis, Designing, Development and Testing of Financial Reports developed in Crystal Report 5.0 • Administration and Tuning of reports developed using Crystal Report • My role was to prepare SRS and Design Document and development of financial reports and to develop its Interface using Visual Basic 6.0. This includes writing COM Components in VB6.0 and adding functionality to Crystal Report to overcome the bottleneck of Crystal Report • A seven-member team was involved in the development of the Project. • Tools and Technology used: Oracle 7.3 Enterprise server, Visual Basic 6.0, Seagate Crystal Report 5, Windows NT 4.0 Server, SQL Server From May 1998 to June 1999 (1 year 2 months) New Delhi Area, IndiaSoftware Engineer @ Financial Accounting and Inventory Production Planning and Management Payroll Management and MIS HR/Payroll • Development and Implementation for following Three Modules: o Personnel Information System o Risk Premia Scheme o Security Module • Development of various forms and reports developed using Developer 2000 and Oracle • Data Migration using SQL * Loader and COBOL Flat Files • Writing database backup scripts • Writing Shell scripts in UNIX for Batches • Analysis, Designing, Development and Implementation for Engineering Module Entry Forms and Reports • Writing Database Stored Procedures and Packages. • Data Migration using SQL * Loader and COBOL Flat Files • Writing database backup scripts • Writing Shell scripts in UNIX for Report generation • Tools and Technology used: • Oracle 7.3 Enterprise server, Developer / 2000 Rel. 2.0, Pro * COBOL, Sun OS From 1998 to 1999 (1 year) New Delhi Area, India

MCA, Computers @ V.B.S Purvanchal University From 1995 to 1998 Computer Applications, Computer and Information Sciences and Support Services @ Masters in Computers Application From 1994 to 1997 Pankaj Gupta is skilled in: SAP BI/BW, SAP BO, Oracle, Crystal Enterprise Reports, Redwood, HPSM, HPQC, BODS, BIA, Project Planning, Project Management, Crisis Management, SLA Management, Team Management, Onsite-Offshore co-ordination