SUMMARY

• SAP BW/BI/HANA Analytics Solution Architect /SME with experience working in Big 5 & SAP for over 15+ years’ experience and 14+ in SAP consulting.
• Progressive and diverse experience across various industry domains like Oil and Gas, Pharmaceutical, Financials (Banking, Investments and transactional banking), Telecommunication, Consumer products, Food Manufacturing, Agriculture Machinery, Audio - electronics manufacturer
• 8 Full Life Cycle implementations and 14+ Projects comprising of Rollout, Upgrade and post implementation/Support of SAP BW from version 3.0 to 7.4 with various source systems such as SAP ERP,SAP CRM, SAP Banking, Payment engine and various third party systems.
• LSA++ architecture with BW on HANA database and use of Composite Provider, open ODS view, Smart Data Access.
• Hands on experience with enterprise/Native HANA using data provisioning/acquisition, Modelling, Administration, Optimisation, performance and security.
• Sound knowledge of business processes which includes FI-CO, Travel management (FI-TV), CO-PA, Transactional banking, Payment Engine, PCA, MM, PM, SD, SCM (APO Demand planning and Supply network planning), Payroll and PCP modules.
• Expertise in LSA (Layered scalable Architecture), BW Architecture, Data-modelling, Extraction, Reporting, activating BW business content, process chains.
• Deep expertise in BW/BI performance optimisation for data load, front end (reporting) and backend. ( SAP COE)
• BW/HANA data integration using SLT, BODS, ODP.
• Problem-solving mindset focusing on providing sustainable and flexible solutions to teh customers
• Experience in implementing OSS, Methodology such as Agile, Design thinking Cutover plans, test plans and task lists during project planning
• NLS implementation for warm and cold data archiving - Sybase IQ for Info cube in BW.
• Experienced analytics consultant in BOBJ 4.1, Design Studio, Dashboard 4.0, Webi, and Analysis for Office 1.4 and A-OLAP.
• Trust Advisor for new technologies and potential proof-of-concept projects (SAP HANA RDS, SAP Mobility, Predictive Analysis, Text Analysis, Geo-Localization, Big Data, etc.)
• Overview of A-TPM implementation and usage of planning functions and sequences.
• Good knowledge of financial statements, Trial Balance, DTR’s, Journal Entries.

TECHNICAL SKILLS

SAP BI& other: SAP BW 7.4, BW7.3, HANA, ECC 6.0 Modules MM, FI-CO, PM and SCM.BW 7.0, 3.5, 3.1, CRM, Payment Engine, Banking Service, SAP R/3 4.6c/4.7/, Design Studio, A-OLAP, Analysis for office, Webi.

SAP Technical Skills: ABAP/4, Customer Exits, Enhancements, Reporting, SAP Script, Smart Forms, Dialog Programming, BDC, Logical Databases, ABAP Query,RFC, BAPI, business add-ins

Database: Oracle 7.2/8.1,My SQL, MS ACCESS

Packages: QlickView, Network Engineer (Telcordia), MapInfo, Arc View, Power Designer 1.0

PROFESSIONAL EXPERIENCE

Confidential, Chicago

SAP BI /HANA Architect

Environment: SAP BI 7.4, SAP HANA, SAP ECC 6.0, SAP CRM, Bobj A-OLAP

Responsibilities:

• Manage BI Project functional requirements with BPE’s and coordination with service provider for solutions using BW7.4 on HANA, BOBJ.
• Provided leadership to resolve complex performance issues, worked on various performance Optimizations and defects resolution.
• Implementation of A-OLAP reporting using Bex queries-BICS connection.
• Participated in planning and execution regression and production cutover activities
• Creation of data model in HANA (Analytical views, calculated views) in enterprise HANA for reconciliation reports between ECC and CRM.
• Performance and optimisation review of HANA models
• SAP HANA data provisioning using SAP LT Replication service, Legacy data from BODS
• Analysis and review of logging table for Planning DSO based on SAP standard BADI’s.
• Unit testing, Integration testing, system testing, and volume testing.
• Reports creation on Events tactics, Detail transaction register, Trade spending, funding and revenue as part of visualisation project using Composite provider.
• Conducted workshops and trainings to user community for rollout of A-OLAP reporting tool and new SAPUI5 application created for corporate planning.
• Coordinate with SAP support for resolving Design studio/OLAP tool issues.
• Creation of Functional documents for Contract numbers, aging report, Payment details.
• Prototype for reporting using SAP HANA live for FI.

Confidential

SAP BI Architect

Environment: SAP BI 7.3, SAP ECC 6.0, SAP Banking Services 4.0, SAP CRM, SAP Payment Engine, SAP HANA

Responsibilities:

• Design and development of BI relevant Objects for transactional banking (Loans) which includes reporting model for Disbursements, Account master data, instalments, commissions, GL Payments, Contingency, Write-off.
• Manage BW team onsite + offshore and provide technical solutions based on Functional documents for Confidential business processes.
• Development of BI relevant Objects for CRM and Payment engine which includes reporting model for Payment orders and items, request agents, interest calculations, Opportunities, quotations, business partner etc.
• Setup Analysis authorisations for by activating 0TCA* objects in BW backend and reporting layer.( Used company code, Org level etc. restrictions)
• Implementation of analysis authorisation customer exit at variable level for restricting data. (During Query execution).
• Performance tuning activities pertaining to SAP BI system and SAP banking specific extractors in tandem with SAP AGS team.
• Strategy on BW landscape simplification, roll-out of BW modelling across Confidential geographies (Countries), Speed of queries.
• Open hub creation for delivering data to 3rd party system
• Reconciliation reports for integration between Banking (Loans) - CRM and Payment engine. ( Using Business object Webi and other components)
• Review and assess existing developments and recommendations based on best practices and new functionalities in BW7.3
• Installation of SAP BI technical content(Statistics-Admin cockpit)
• Optimization of teh mission-critical process chains (root cause analysis, performance diagnosis) in order to provide an action plan with technical recommendations (delta vs full, parallelization, load balancing, application settings, statistics, conversion with DTP, indexes, ABAP coding in transfer, update and transformation rules, redesign of process chains, OSS notes)

Confidential

SAP BI Lead Consultant

Environment: SAP BI 7.0, SAP ECC 6.0, SAP APO.

Responsibilities:

• Evaluated design, architecture and recommended improvements in all components of SAP BW landscape which includes various maintenance activities pertaining to SAP BW.
• Assigning tasks to BW team for development/changes as part of Remodelling and Performance initiative.
• Actively involved in QC/QA process as part of SAP BW deliverables.
• Analysing teh scope and feasibility of functional requirements with periodic key user's interaction workshops/Meetings to transform functional requirements into technical specifications and creation of Design & solution documents.
• Design and development of BI Objects for Plant maintenance(PM) and APO( SNP) and SNP/ECC extractors
• Workbook based solution for Movement reports, Deployment performance reports.
• Developed reports leveraging Key Performance Indicators (KPIs) and metrics based on best practices and business requirements
• Created teh integration test plan and ensured teh successful execution of PIT’s
• Transition of BW objects from development team to Production support team.
• Setting up Analysis authorisation for reporting based on InfoProviders.

Confidential

SAP BI Lead Consultant

Environment: SAP BI 7.0, SAP BOBJ (Webi, Crystal Reports)

Responsibilities:

• Providing Dashboard reporting from Business Objects using BW as data warehouse as source.
• Provide custom built SAP Bex reports for reporting from Webi and Crystal reports.
• Build dashboards as POC using new features of BI
• Remodeling of BW model for performance improvements on reporting.

Confidential

SAP BI Lead Consultant

Environment: SAP BI 7.0, SAP ECC 6.0

Responsibilities:

• Coordinating with different teams (Internal and external) for Upgrade of SAP BI7.0 to BI7.3 and defining Scope based on SAP BW security/Authorisations
• BI 7.0 to BI 7.3 migration of user authorisations / Roles etc mapping and integration testing.
• Installing / Maintaining BW technical content for statistics to enable BI statistics reports using delivered content.
• Operational activities for production support and ramp-up team for resolution of critical process chain failures. Hand-holding of team members for fast resolution to maintain SLA’s.
• Setting up Analysis authorization for reporting based on info provider
• Evaluated design, architecture and recommended improvements in all components of SAP BW landscape which includes various maintenance activities pertaining to SAP BW.

Confidential, NY

SAP BI Lead consultant

Environment: SAP BI 7.0, SAP ECC 6.0, SEM-BCS

Responsibilities:

• Dashboard visualization business requirement and fitgap analysis workshops including data conversion project for migration to SAP.
• Mapping of current live BI reporting solution for different groups with new reporting requirements categorising by corporate. Local and non-BI reporting.
• Exhibit and Schedules reporting from BI system based on corporate SI structure and mapping with FSV (Financial statement hierarchy) in ECC.
• Prototype for usage of Business intelligence Accelerator in current reporting solution.
• Initiative for setup of “BI Admin Cockpit” as part of performance initiative.
• Creating custom User authorisation logic for Company code hierarchy as part of global sell-off of entities by restricting valid and auto company code data available at each user/group level.
• Creation of global filters, structure in queries as part of corporate reporting initiative.
• Setup of broadcasting for daily and weekly reports to different groups as part of automation.

Confidential, NY

Sr. SAP BI/Lead Consultant

Environment: SAP BI 7.0, SAP ECC 6.0, QlickView

Responsibilities:

• Analysing teh scope and feasibility of functional requirements provided by Confidential user groups, transforming functional requirements into technical specifications and creation of User requirement specifications.
• Designed & documented high level BI data modelling & reporting Solution based on URS and technical specifications using Visio and other tools after signoff of requirements.
• Created data model to integrate SAP BI with offline Reporting Tool “QlickView” based on Rx data on Brand’s and Doctor’s.
• Integration of current BI application data with new Data staging engine in SAP BI for extracting data from Confidential legacy system files.
• BI reporting solution to be developed in BEX using queries, workbooks and Portal Queries.
• Designing flexible, scalable solution for any future requirements pertaining to existing application data model.
• Setup of process chain for delivery of data to external reporting system “QlickView”.
• Analysis of current BI application objects for performance enhancements.

Confidential, IL

Sr. SAP BI Consultant

Environment: SAP BI 7.0, SAP ECC 6.0(OTC, ATR)

Responsibilities:

• Performance tuning of BI-APO, OTC and ATR Relevant info providers.
• GAP analysis & Data model changes to generate Backorder& Cancel report using Sales order Schedule line and Delivery data.
• Analysis & Activation of business content for Purchasing info providers.
• Analysis & Activation of business content for Account receivable info provider and creation of vendor analysis reports
• Analysis & Activation of business content for Allocation info providers 0OPA*.
• Monitoring production system and resolving daily data load issue.

Confidential, NJ

Senior SAP BI-APO Consultant

Environment: SAP BI 7.0, SAP ECC 6.0, SCM 5.10(APO)

Responsibilities:

• GAP analysis for Travel Management-Travel expenses and State compliance reports for designing BI Architecture pertaining to travel management.
• Design of Data Model integrating SAP BW Travel management, Credit card buffer and state compliance reporting between SAP and Non-SAP systems.
• Creation of functional design document, Technical design document on travel expenses and state compliance reporting based on ECC and BI.
• Development customized and standard Datasources, Communication/Transfer structures, InfoObjects, Infopackages, InfoCubes, DSO Objects, Aggregates, Transfer/Update rules (including ABAP), InfoAreas and application components / hierarchies
• Activation of Business content for Travel expenses - Totals and Receipts objects (Data source - 0FI TV 01 and info cube - 0FITV C01) as part of GAP analysis.
• Design/Creation/review of custom extractors, Info providers for Travel expenses (Receipts details, audit information, GL by expense type, submission frequency etc), credit card buffer data, Integration of Travel expense reporting with State compliance reporting (Master data from CRM system).
• Design of reconciliation strategy between ECC and BW.
• Enhancement/Upgrade of personal cost planning & Payroll modules for infocubes-0PACP C01, 0PACP C02, 0PY PPC01, 0PY PP2 and all teh relevant objects (ODS).
• BW performance review for designing improvement roadmap for Demand Planning, FI (GL, CCA, WBS) as part of Template rollout in all BI modules.
• Enhancement of APO Supply Network Planning and Demand Planning data source.
• Remodelling Supply network planning DSO to write optimised in APO system using 9MALO.
• Regression test of Supply Network Planning, Demand planning as part of APO (SCM) upgrade project for SAP BI extraction/reporting.

Confidential, NY

Sr. SAP BW Consultant

Environment: BW 7.0, SAP ECC 6.0 (ABAP) in FI, CO-PA

Responsibilities:

• Performance Tuning: Design of aggregates for optimizing query performance,Optimize outbound, physical partitioning of InfoCubes, optimized process Chains for parallel processing, custom parameter settings, InfoCube Compression, index maintenance, statistics management, RSRV, master data Maintenance etc.
• Designed & remodeled using Remote cube reporting concept for Federal reporting (Regulatory reporting) with function module based extractor and user exits.
• Resolving loading, reporting issues, developments, enhancements based on SLA’s and coordination/mentoring offshore development and support centers(India, Manila)
• Maintenance of teh FI, CO-PA data warehouse: delta management and correction of teh functional and technical anomalies.
• Created process chains for automation (bseg/Copa) up to golden cube so as to reduce delays while running parallel loadings, easy maintenance of data targets, master data maintenance.
• Created queries using BEX which includes Variables, Filters, conditions, and Restricted & Calculated Key figure, Jump targets.
• Created info spokes using open hub service for delivering data to external systems BW system and BCS. These extract files act as feeds for various existing legacy systems which halps in reporting. (CRES/IDB/IUC/GID legacy systems).
• Enhancement of CO-PA ( Confidential Operating concern) extractor to accommodate change in reporting standards for IFRS GAP.
• Worked on USGAAP, BASTA, IFRS reporting solution.
• Setup and coordination with MAESTRO for scheduling jobs and various housekeeping tasks.
• Writing of a upgrade scenario from release 3.5 to 7.0, Transformation of background jobs(all locations) to Process chains which includes creating custom processes for process chain/steps monitoring/logs which
• Impact assessment for technical upgrade which includes creating business case for implementing BI accelerator.
• Cut over plan and road map for upgrade, issue list and test plans
• Maintenance of aggregates during upgrade for all changes as per support packages.
• BEx queries/workbooks functionality test w.r.t. Customer exits/Exception reporting, jump targets, VBA usage.

Confidential

Technical Consultant

Environment: BW3.1, SAP R/3 4.6c in MM, FI-CO, PM.

Responsibilities:

• Involved in GAP analysis for teh Shell EP Blueprint for implementation of SAP R/3 and BW for supply chain management.
• Creating technical Specifications for data mapping, conversion Plan, OLTP Extract processes, and legacy extract procedures.
• Analyzing teh exiting BW objects for teh requirements of teh affiliate and issue new change request for customization and creation for teh same.
• Analyzed teh existing model for optimizing existing queries, data load Processes.