SUMMARY:

• Over 13 years of experience in BW/BI implementations, SAP BPC, SAP HANA, BPC optimized for S/4 Hana, SAP ABAP,BI Integrated Planning, SAP Business Objects (BO), which includes 9 full Life Cycle Implementations and Production support following ASAP methodologies in various domains like Oil and Gas, Manufacturing, Chemicals, Banking, Real Estate, Transportation, Media & Consulting Services. Extensively worked in the areas of Sales and Distribution (SD), Finance (FI) and controlling (CO), HR, PP, Materials Management (MM), Inventory Management (IM), Joint Venture Accounting(JVA), PRA, PS, AM, CML, CMS and have in - depth business process knowledge.
• Extensive experience with Requirement Gathering (from process design owners, Business Groups (Power Users and End users), Business Blueprint (Identifying Reports, Gap Analysis, Enhancements), Realization (Design & Development of BI objects) and Post Production Support.
• Strong process knowledge across Expense accounting, Payout accounting, Cash call accounting, Accruals, Allocations, Joint interest accounting, Corporate accounting etc.
• Good experience as On-Site coordinator, to synchronize project tasks with offshore team members.
• Expertise in OLTP extractions from SAP R/3 using LO Cockpit, COPA, Generic Extractions and non-SAP extraction.
• Expert in analysis, design and delivery of complex business requirements to support BI analytics for both batch and real-time data requirements.
• Lead architect and SAP HANA SME for several BW on HANA migrations, HANA Agile datamart implementations, and post migration optimization projects.
• Had experience in deploying business analytical solutions in the areas of Order-To-Cash, Forecast to deploy, Procure to pay etc.
• Experienced in estimating effort, resource and costs for HANA agile data mart, predictive analysis and BW on HANA business requirements.
• Expert in architecting and deploying global EDW solutions by following SAP best practices including LSA and LSA++ architecture, utilizing the standard business content, and SAP recommended landscape and platform standards.
• Experienced with EPM 10.1, BW 7.4 on Hana upgrade.
• Expert in SAP BW on HANA and migrating standard SAP Models to In-memory optimized models and Performance tuning.
• Experienced in BPC 7.0, BPC 7.5, EPM 10.0 & EPM 10.1. Had experience in CAPEX planning, OPEX planning, G&A budgeting & Complex Consolidation project experience involving 23 company codes and several organizational restructurings during support.
• Excellent communication and interpersonal skills; committed to deliver quality work on time and within budget, trusted advisor on technology and business solutions, and a strong believer of customer satisfaction and relationship building.
• Experience in SAP IQ-Near Line storage 15.4 & 16.0 solutions.
• Created BW Objects such as Info Objects, Info Cubes, DSO, Data sources, Transfer rules, DTP’s, Start routines & End routines, Process chains, Open Hub, APD etc.
• Expert in extracting data from SAP ECC and non-SAP source systems like SQL Database, Oracle Database, and flat files in to BW.
• Developed complex custom delta DataSources using Function Modules.
• Developed CO-PA Datasources for both Account based and Cost based.
• Extended standard business content extractors using BW and LIS user exits. Deep expertise using the LO Customizing Cockpit to modify and administer Logistics extractors. Also very experienced with FI/CO and CO-PA extractors including their dependencies and R/3 system parameters.
• Proficient in data staging design and implementation including ABAP development.
• Expert in Integrated Planning based on real-time InfoCube, DSO, Local Provider, Aggregation Level, Planning Functions, Planning Sequence, Data slices, Filter, Variable, Input ready query, Lock management etc.
• Designed and implemented BEx Reporting and BI Web Reporting.
• Expert in Bex Queries, Bex variables, user exits, Analysis for Office.
• Experienced in designing and developing HANA views using graphical and SQL scripts, data provisioning using ETL and SLT, implementing HANA security, and user management.
• Expert in BW/BPC Integrations including BADI, User Exits.
• Expert in Logic Script, Fox formula.
• Proficient in Technical Documentation & User Orientation manuals/Trainings.
• Expert in SAP BW 7.4.
• Expert in Data Extraction and Data Flow within SAP BW 7.4 NW 2004S.
• Expert in New Data source Concept of BW 7.4
• Expert in Transformation in BW 7.4(ETL)
• Expert DTP (Data Transfer Process) from 3.X TO BW 7.4
• Expert in Business Content UPGRADING DATAFLOWS
• Expert in Administration of Info Cubes.
• Expert in DSO (DATA STORE OBJECTS), InfoCubes, Composite Providers and Multi Providers.
• Expert in BPC 7.0, 7.5, 10.0 & 10.1.
• Expert in Planning & Consolidation.
• Experience in Budgeting.
• Expert in BPC back-end (BW modeling, data manager packages, package links, BADI etc.).
• Expert in BPC administration (Models, Dimensions, Business rules, BPF, Script logic etc.).
• Expert in EPM add-in & Analysis or Office.
• Expert in reporting & input templates.
• Expert in consolidation process like Ownership, Controls, Currency conversion, Equity pickup etc.
• Expert in designing security (Users, Teams, Task Profiles, Data access profiles).
• Experience in utilizing the standard Analytic Apps for Management Accounting.
• Experience in joining custom data flows with standard data flow(ERP/SFIN M01).
• Experience in utilizing standard planning workbooks, creating custom workbooks.
• Experience in planning and consolidation authorizations.
• Experience with Real Time Consolidation(RTC).
• Experience in Creating an attribute view
• Experience in Creating an analytic view
• Experience in Creating a calculation view
• Experience in Creating Attribute Views with Hierarchies
• Experience in Calculated columns in an Analytic view
• Experience in Calculated columns in an Attribute view
• Experience in Using Variables with Analytic views
• Experience in Using Decision Tables with update values
• Experience in Using Decision Tables with return values
• Experience in Creating Tables: Row Store vs Column Store
• Expert in Creating Analysis Views using Analysis edition for OLAP (HANA OLAP connection).

TECHNICAL SKILLS:

ERP: SAP ECC 6.0, R/3 4.6C/ 4.6B/ 4.5B

SAP BW: SAP BI/BW 3.5.7.0 7.3 , 7.4 (HANA), BPC 7.0, 7.5,10.0, 10.1

SAP HANA: HANA Studio

Planning: SAP EPM 10.1(BPC 10.1), BPC 10, BPC 7.5, BPC 7.0, IP, BPS

Languages: ABAP/4, C.

Reporting Tools: BEx Reporting, Web Reporting, Report Designer, EP and SAP Business Objects, BO XI 4.x

Operating Systems: Windows 95/98/2000/XP and Windows/NT

Database: MS-Access and ORACLE 8i/9i/10g, HANA, SQL.

PROFESSIONAL EXPERIENCE:

Confidential, Oklahoma City, OK

SAP BPC optimized for S/4 Hana Solution Architect

Responsibilities:

• Designed and delivered Calculation views and Analysis reports(AO) reports based on standard SAP transaction codes (CJI3N, KSB1N etc.) for accounting team saving their time for reconciliation.
• Delivered financial planning package to plan CAPEX and compare at Region, Formation & Field Office. Main functionality of this package is to plan the CAPEX budget for next year at field office level for Land cost, Drilling cost, Completion cost etc. and compare it with actuals from well level rolled up to field office based on well attribute and project type. This is designed based on /ERP/SFIN V01 for Actuals, /ERP/SFIN R01, /ERP/SFIN V20 for Plan data & Custom table to hold field cost estimates. This is delivered by enhancing the standard data flow of /ERP/SFIN M01.
• Worked on the real time consolidation POC.

Confidential, Ashland City, TN

SAP BPC/BW Solution Architect

Responsibilities:

• Designed and delivered Operational analytic tools in BW based SAP Transportation Management module data.
• Designed and delivered Sales Analysis reporting tool(COT) based on SAP Sales Orders, Delivery, Billing, Shipment, Legacy sales data.
• Assessed Confidential BPC system and fixed long standing issues related to transports, Consolidation performance, Equity pickup issues, fine tuned the reports to improve reporting performance etc.
• Fixed data load issues for Consolidation model from SAP and legacy systems.

Confidential, Tulsa, OK

SAP BPC Architect

Responsibilities:

• BPC Solution architect cum developer (only technical resource on the project) to design and deliver Full Cost Pool & Roll forward schedule planning, G&A budgeting, CAPEX planning by activity. Also, supporting existing BW/BPC landscape (Designed & delivered by me during implementation project ).
• Roll Forward Schedules: Conducted workshops with user base to showcase BPC planning functionality like Business rules, Business Process flow, Script Logic etc. and provide direction and recommendations for integrations.
• Conducted workshops with Asset Accounting & Corporate Accounting teams to understand the Roll Forward schedules they are doing manually for years.
• Enhanced Asset accounting standard extractors to meet the requirements related to rotatory dry hole.
• Joined Asset accounting data with FI data in BW data flow to support detailed drill-through reports in BW.
• Created Planning model in BPC, loaded all the master data to BPC dimensions from BW infoobjects and automated the loads through BW process chains.
• Loaded actuals from SAP BW to BPC and delivered input templates to enter planning data.
• Used transformation files, conversion files to transform the data in required format while loading data from BW to BPC. Developed ABAP logic(BADI) to apply complex data transformation while loading the data.
• Used Business rules & script logic to meet the business functionality.
• Delivered 6 EPM reports for Roll Forward schedules. Delivered Business process flow to automate this process.
• G&A Budgeting: Conducted workshops with all the department VPs to showcase BPC Budgeting functionality and understand the requirements.
• Designed & delivered BW data flow including datasources, DSOs, Cubes, Transformations, DTPs to pull actuals from SAP and transform data in the BPC format for actuals.
• Delivered input template to enter Budget for each department at cost center level.
• Delivered 2 EPM reports with drill-through functionality with the support of 5 Bex queries.
• CAPEX planning at Activity level: Conducted workshops with Production Department (Drilling & Completion) & Corporate accounting teams to understand the requirements for CAPEX activity based planning.
• Used existing BW LOS data flows (Delivered during the implementation project) to provide actuals to BPC CAPEX planning.
• Delivered input template to enter Plan, also delivered BW data flow to consume planning data from flat file.
• Delivered 2 EPM reports with drill-through functionality with the support of 2 Bex queries.
• Delivered Business Process flows to automate these processes & defined and delivered security profiles (Teams, task profiles, data access profiles etc.).
• Responsible for developing a detailed run book for the BW and BPC activities and integrate it with the basis and security activities.
• Conducted user training workshops to train power users on creating ad-hoc BPC reports, daily tasks like monitoring etc.

Confidential, Oklahoma City, OK

SAP BW/HANA Lead Architect

Responsibilities:

• BW/Hana Solution architect to design and deliver Chesapeake Operational Reporting tools (Analysis for Office reports, Dash boards, Webi reports, Spot Fire reports) serving 1200 users across Reserves, Land, Finance, Production departments.
• Conducted workshops with stake holders to understand the issues with legacy Lease operating statements to understand their use cases. Also, conducted workshops with user base from each department to showcase BW Reporting tools like Analysis for Office, Webi, Design studio dash boards.
• Provided technical solution guidance to produce a robust and agile EDW reporting solution.
• Ensured the optimal configuration of the BW and HANA systems for best results in terms of performance and stability.
• Delivered best practices and recommendations on design, data modeling and ABAP coding for optimal data load and report performance, memory consumption, flexibility, and stability to the SAP partner’s onsite and offshore team.
• Empowered the client and SAP partner with the functional and technical knowledge on SAP HANA and BW on HANA.
• Provided expert advice during the blue printing, realization, and testing phases and project approach.
• Ensured a successful go-live with on-time deliverables and stable HANA system.
• Act as liaison between the customer and SAP to address the issues and provide timely resolution.
• Created blue prints by understanding the existing Chesapeake reporting tools like GRAT and the information from the business users and functional consultants during workshops.
• Designed and delivered BW/Hana data flow joining data from FI, CO, JVA, AP, Legacy systems (Enertia & Corporate well master).
• Designed/Developed the BW data models (LSA++) suitable to HANA Database.
• Involved in creation of Calculated attributes, measures, Restricted measures, Calculated columns, filters, hierarchies, variables, input parameters to satisfy reporting requirements using SAP HANA STUDIO.
• Conducted regular meetings with SAP to review the status of critical issues and very high priority OSS messages related to Composite Provider, Open ODS view, JVA standard extractor issues.
• Delivered various Analysis for Office reports like Lease Operating Statement Net Accounting Month, Lease Operating Month Net by Service month, Gross Lease Operating statement by Service Month, Lifting Cost report, LOE Analysis, G&A Analysis, Vendor Spend Analysis, CAPEX Analysis, CAPEX look back, Income Statement etc.
• Worked closely with SpotFire developer to deliver COR tool consisting of all the legacy features (GRAT tool) like Analysis by map, division, department etc. and without any issues they had with GRAT tool like performance, security etc.
• Guided design studio team in delivering desktop & mobile dashboards.
• Reviewed and resolved both Front end and Back end performance issues.
• Responsible for developing a detailed run book for the BW and Hana activities for internal team.
• Conducted user training workshops to train power users on creating ad-hoc AO reports, WEBI reports etc.

Confidential, Tulsa, OK

SAP BW/BPC Architect

Responsibilities:

• Completely responsible for the end to end BW implementation from gathering requirements to reporting including Analysis for Office, Business Objects Web Intelligence Reports & data provisioning to other existing IT & Business tools.
• Conducted workshops with user base to showcase BW Reporting tools like Analysis for Office, Bex Analyzer etc. and gathering requirements.
• Delivered best practices and recommendations on design, data modeling and ABAP coding for optimal data load and report performance, memory consumption, flexibility, and stability.
• Empowered the client with the functional and technical knowledge on SAP JVA, PRA & BW.
• Provided expert advice during the blue printing, realization, and testing phases and project approach.
• Ensured a successful go-live with on-time deliverables and stable BW system.
• Act as liaison between the customer and SAP to address the issues and provide timely resolution.
• Recreated all the legacy reports in BW environment like Balance sheet, Income statement, well level information, Lease Operating statements, Lifting Cost report, Vendor spend Analysis etc.
• Developed all these reports with seamless drill down to invoice image in SAP.
• Used Open Hub data marts to provide delta transaction data from BW to existing DW tables to support AFEMS, LOE tools.
• BPC Consolidation: After SAP & BW projects went live started working on BPC consolidation project.
• Conducted workshops with user base to showcase BPC functionality and gathering requirements.
• Delivered BPC consolidation of 23 Company codes involving Currency Conversion.
• Responsible for developing a detailed run book for the BW and BPC activities for Consolidation and integrate it with the basis and security activities.
• Conducted user training workshops to train power users on creating ad-hoc BPC reports, daily tasks like running consolidation etc.
• Supported both BW & BPC environments post Go-Live and during many Chapter 11 organization restructurings.

Continental, Oklahoma City, OK

SAP BW/BPC Architect

Responsibilities:

• Responsible for entire BW & BPC systems support (Only resource on the project).
• Interaction with the Management and Business Decision-makers to identify new business requirements.
• Document reporting needs of the Business Service and Support Organization and disseminate those requirements into a data warehouse strategy resulting in both operational and analytical reporting.
• Developed and delivered CAPEX look back report.
• Delivered Accrual Analysis tool.
• Created MultiProviders to split Query process on various data targets, and InfoSets on ODS to integrate data logically for optimal query performance.
• Developed the Interactive and Formatted Dashboard Reporting.
• Designed custom queries by implementing Variables, Exceptions, Conditions, and Restricted & Calculated Key Figures on BEx.
• Developed KPI dashboard using Query Designer
• Creating customized Queries/Reports on various data targets and testing with legacy data. Developed Flexible queries using Filters, Free characteristics, Variables and Navigational Attributes in BEX Query Designer to facilitate Data analysis in a Drill down or Summarized way to give detailed levels of information.
• Created Reusable components like Calculated Key figures, Restricted key figures and Variables.
• Worked with Exceptions and Conditions In the Query Designer.
• Created Process Chains for the info packages scheduled on daily and Weekly basis and dealt with PC Failures.
• Involved in Unit testing, Integration testing and UAT
• Evaluated BW Statistics on InfoCubes and Aggregates to perform optimization for reporting.
• Redesigned entire BPC CAPEX planning Model and Evdre reports in BPC 7.0 to fix performance issues.
• Automated BPC dimension data from BW application server using SAP How-To-Guide.
• Involved in BPC 7.0 to BPC 7.5 upgrade including testing, fixing data load issues by redesigning entire data load process using new data manager packages on infoobjects.
• Involved in BPC 7.5 to BPC 10 (EPM 10) upgrade including testing, fixing all the upgrade issues. Redesigned all the Evdre reports in EPM tool as our existing reports are complex and not able migrate them with the help of SAP migration tool.
• Instrumental in Continental Resources moving in the Hana direction by show casing performance improvements to the management with the help of POC.
• Migration from BW to BW-HANA.
• Rapid database migration of BW on RDBMS to BW on HANA
• BW on HANA fresh installation and moving only the required, data models & content, in the process optimize and cleanup the BW system
• HANA as real time, high value agile/custom data mart and later migrating BW to BW on HANA
• New projects, initiatives on new BW on HANA installations.
• Performs activities required after the initial system copy of a SAP NetWeaver BW system reliable.
• Done with post migration activities.

Continental, Oklahoma City, OK

SAP BW/BPC Architect (IBM Consultant)

Responsibilities:

• Conducted User Requirements, gathering Workshops and interacted with the Management and Business Users to identify Business Requirements.
• Completely responsible for designing the end to end Reporting system for Continental Resources.
• Designed and Created estimation model for BI implementation based on the scope of the requirements and prepared Technical Specification documents.
• Conducted workshops with user base to showcase BW Reporting tools like Bex Analyzer, Bex Web etc. and gathering requirements.
• Delivered best practices and recommendations on design, data modeling and ABAP coding for optimal data load and report performance, memory consumption, flexibility, and stability.
• Empowered the client with the functional and technical knowledge on SAP JVA, PRA & BW.
• Provided expert advice during the blue printing, realization, and testing phases and project approach.
• Ensured a successful go-live with on-time deliverables and stable BW system.
• Act as liaison between the customer and SAP to address the issues and provide timely resolution.
• Recreated all the legacy reports in BW environment like Balance sheet, Income statement, well level information, Lease Operating statements, Lifting Cost report, Vendor spend Analysis etc.
• Developed all these reports with seamless drill down to invoice image in SAP.
• Creating customized Queries/Reports on various data targets and testing with legacy data. Developed Flexible queries using Filters, Free characteristics, Variables and Navigational Attributes in BEX Query Designer to facilitate Data analysis in a Drill down or Summarized way to give detailed levels of information.
• Created Reusable components like Calculated Key figures, Restricted key figures and Variables.
• Worked with Exceptions and Conditions in the Query Designer.
• Involved in Unit testing, Integration testing and UAT

Confidential

SAP BW Senior Consultant

Responsibilities:

• Extensively worked in generating reports on CML & CMS modules.
• Developed many custom extractors to pull data from these modules and delivered complex BW data flow based on these modules to meet business requirement.
• Created Multiprovider to facilitate the need for reporting requirements.
• Loaded the data from ECC to BW and used initialization with delta update and full update methods.
• Extensively worked on Open Hub.
• Created APDs and open hub to load the BI data into Flat file for legacy systems.
• Activated the business content for FI AR & GL.
• Worked on BEx Query Designer, BEx analyzer, portal reporting. Developed flexible queries using filters, navigational attributes in BEX analyzer to facilitate data analysis in a summarized way to give detailed level of information.
• Created Financial Statement Item report as per the business requirement.
• Delivered Integrated planning model for Head Count planning using real time infocube, Aggregation level, Planning function, Planning sequence etc.
• Involved in Unit testing, Integration testing and UAT.
• Developed end user training document as per the design document and conducted end user training sessions.

Confidential

Senior SAP BW Consultant

Responsibilities:

• Responsible for BW reporting on Demand Planning, SNP & PP-DS modules during APO implementation
• Gathered the requirements from functional and business users to understand the requirements.
• Interaction with the management and business Decision-makers to identify business requirements. Document reporting needs of the Business Service and Support Organization and disseminate those requirements into a data warehouse strategy resulting in both operational and analytical reporting.
• Undergone Complete Life Cycle Implementations of SAP BI/BW, which includes data modeling, Design Support, Data management, Global & Cross-functional metadata definition.
• Enhanced standard extractors based on Business user’s requirement and configured BW objects including generic data sources to extract data from R/3 systems.
• Extensively worked on start routine, expert routine and end routines.
• Reviewed BW Reporting requirements relating to DP & SNP area and implementing those requirements by creating R3 data sources and building BW ODS and Infocubes.
• Created process chains to schedule the InfoPackages and data transfer processes.
• 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.
• Involved in Performance Tuning of the system.
• Involved in Unit testing, Integration testing and UAT.
• Used both initializations with delta update and Full update methods depending on the business requirement.
• Managed and monitored several data loads, captured the errors and corrected the bugs and applied several OSS notes for the errors encountered while loading the data.

Confidential

Senior SAP BW Consultant

Responsibilities:

• Responsible for upgrading BW 3.5 to BI 7.0.
• Redesigned FI data flow to use standard content as much available and improve performance.
• Created MultiProvider to split Query process on InfoCubes to integrate data logically for optimal query performance.
• Transporting Requests of various Objects of the BI system from Development to quality and Production environment.
• Created Process Chains for the info packages scheduled on daily and Weekly basis and dealt with PC Failures.
• Involved in Unit testing, Integration testing and UAT.
• Evaluated BW Statistics on InfoCubes and Aggregates to perform optimization for reporting.
• Designed and delivered integrated planning model for Financial Planning for Confidential . This is a co-operative society of Farmers in Netherlands for Animal feed. Expenses are planned and shared with all the farmers and tracked periodically against actuals. This package is delivered with a planning query to enter plan data by each region head and actual data is pulled from SAP with the standard FI-GL data flow.

Confidential

Senior SAP BW Consultant

Responsibilities:

• Responsible for gathering requirements from the Business Users, Re-designing and Production issues.
• Responsible for creating the Queries based on the user requirements.
• Worked on BI 7.0 testing, Consistency Checks, Impact Analysis and kick off all the master data and transactional data process chains and compared the reports with production system.
• Responsible for Design of data models, comparing the model with delivered contents and implementing the business logic with delivered contents along with modifications.
• Created Transport requests and transported the developed Info providers and queries to the test box and subsequently to the production box
• Developed flexible queries using filters, navigational attributes, variables, calculated key figures, restricted key figures in BEx analyzer to facilitate data analysis in a drill down or summarized way to give detailed level of information
• Analyzed report performance for statistics and implemented proposals for aggregate creations and indexing. Tuned Queries using Aggregates and MultiProvider
• Performed statistical setup for purchase, Sales, Billing and Shipment and extracted the data to BI.
• Customized Lo Cockpit data source to include custom defined fields and populated those fields using customer exits before the setup.
• Used “Queued Delta” method to extract the delta records of MM and SD application.
• Extensively worked in generating reports on Finance Invoices and MM Invoices. Worked on Finance Data Extractors 0FI AR 04 and 0FI AP 04 and loaded data into data targets.
• Optimize data extraction and data load in PS module.
• Responsible in Design and Development of Custom build cubes and multi provider.
• Designed and developed process chains (RSPC) for master data loads and transaction data loads with the help of Info Packages and these Process chains are scheduled for periodic loads.
• Involved in production support to check the loads regularly.
• Involved in solving performance-related issues.
• Daily monitor the data loads and resolve the issues on priority base.
• Created and maintained aggregates, rollup of data using process chains, after the successful extraction of transaction data.
• Expertise in creation of BEx Queries, Workbooks, structures, variables, calculated key figures, restricted key figures and RRI reporting.
• Extensively worked on Creating Dashboards & Web Reports Using Web items Like Tables, charts, Drop down Box, Radio button Check Group, Label, Filter and Text Elements.
• Generated Queries, Reports, and Work books with custom Layouts using logos, Charts Overdue analysis, Customers Overview, Vendor overview etc..,
• Transport of objects from Development to Testing and Production systems using CTS and Error correction during import.