SUMMARY

• Over 12+ years of techno - functional experience in Business Intelligence - Analytics, Strategy and Solution Delivery in Financial, Pharmaceutical, Manufacturing & Retail industry.
• Six complete E2E Life Cycle Implementations, Due Diligence and Production Support projects. Experience with ASAP methodology of SAP SDLC beginning from project initiation and requirements specification through development, QA, UAT and Go-Live.
• Global SAP BW project implementation experience in geographies including USA, UK, Belgium and India.
• Well experienced in Data warehousing concepts, Designing effective client specific BW systems, Data Modeling, Performance Tuning, Data Extraction and ABAP Transformation routines for both application specific as well as generic from R/3(ECC), APO, and Non-SAP systems like JDE.
• Successfully performed SAP BW on HANA migration project which involved re-designing existing BW data models to HANA optimized data models.
• Performed and led Due Diligence projects in SAP BW for Oil & Gas client in Belgium.
• Published White Paper on SDN for integrating SAP BW with Microsoft SSIS/SSAS.
• Managed BI projects, led BI teams in onsite offshore model, mentor and trained staff in technology and business.
• Ability to work in various organizational setups - independently and in collaborative teams. Capable of conducting business requirement workshops with key stakeholders
• Capable of presenting to groups across the organization. Strong interpersonal skills to facilitate clear communications (oral and written) of results and ideas within the organization. Strong in story boarding using various tools namely, interactive Dashboards, PowerPoint.

TECHNICAL SKILLS

• SD, MM, FI-GL, AR, AP, HR
• Bex Query Designer(3.x/7.x)
• Analysis for Office (AO 2.x)
• BOBJ Lumira 2.0 SP2 (New)
• Design Studio 1.2 SP1
• Web Application Designer
• SAP HANA Studio 2.0
• Tableau
• SAP BODS 4.2
• SAP APO/DP
• Business Process mapping in Provision
• QlikView Design / Developer 11.0
• HP PPM / MQC
• HANA Views - Calc + Analytical
• Composite Providers, aDSO
• ABAP Start/End Routines
• Process Chains
• Generic Extractors
• Analysis Process Designer (APD)
• DBCONN ECT/UDCONN ECT
• Hierarchy creation/maintenance
• BI Autorisations
• BI Transports / SOLMAN
• Applying SAP Notes
• Raising OSS Message

PROFESSIONAL EXPERIENCE

Confidential, NYC

Sr. SAP BW Project Analyst

Responsibilities:

• Responsible for migrating and re-designing SAP BW 7.x data models to the new SAP BW on HANA landscape.
• Developed advanced DSO's (aDSO), Composite Providers, Hana views including Script views, Graphical views etc. to replace the conventional BI data model objects.
• Responsible for partnering with Accounting and SCM business partners to provide quick and effective reporting solutions using BW on HANA technology.
• Performed data extraction from various ECC and non ECC data sources and provide On-Call production support.
• Successfully implemented the FSCM BI content with custom user enhancements on the new BW (7.4) on HANA landscape.
• Successfully integrated Google AdMarc (3 rd party) media data feeds into SAP BW for performing analytical reporting on Media data.
• Responsible for supporting all the enhancements and future developments in the Trade Management Solution (TMS), a SCM tool, at Bloomberg.
• Performed all aspects of testing required to deploy the BW models successfully in Production.
• Developed BEx reports/workbooks and dashboards using Analysis for Office (AO 2.1) and other reporting tools such as Design Studio v1.3 SP1.
• Responsible for migrating existing Design Studio dashboards to the new Lumira Designer based platform.
• Responsible for creating and testing security roles/authorizations and ensuring they are assigned to power/end users.
• Performed prototype to understand how Hadoop/Big Data technology could be integrated with SAP BI.
• Prototyped and evaluate how BO Data Services (BODS 4.2) could be utilized for non-sap related data sets for extraction directly into SAP HANA.

Confidential, NYC

SAP BW Global Support Team Lead

Responsibilities:

• Lead the Global BW SAP support (America's, APAC, EMEA) initiatives including defining the data load monitoring procedures and protocols, redefining the support SLA and ensuring overall BW system performance are in-line with benchmark standards.
• Lead team of Sr. BW Developers (NYC and HKG) to manage and provide operational support to the IPG BW Application Support Portfolio.
• Interact with cross functional process teams in identifying and documenting necessary KPI and Interface requirements.
• Architected and lead the overall design and provide technical recommendations to the BW development team in establishing data models, usage of front-end reporting tools, ETL tools and technical infrastructure.
• Responsible for BW Accelerator maintenance by implementing (build/drop and monitor) InfoCube indexes, monitoring the memory usage and performing required escalations and follow up with SAP on BWA performance.
• Designed, configured, implemented and supported SAP's Business Warehouse solutions, which included the complex extraction, transformation and loading operational setups, create and maintain ODS's and Infocube, establish and monitor process chains.
• Lead all system upgrade initiatives including SAP BW 7.3 upgrades (H/W and S/W upgrades), GUI 730 upgrades and DR tests by interacting with cross functional teams (DES/BizTalk/Hyperion/PeopleSoft) and identified the impacted process streams which included - defining the test scope for BW (7.3) application.
• Performed Triaging of Remedy incidents and track all incidents are assigned and meet the completion due dates.
• Proposed and Implemented Early Watch Alert recommendations by SAP for improving the data load performance to ensure Global BW reporting is
• Responsible for the successful operation of the BW data load processes by implementing Early Watch Alert recommendations from SAP and ensuring the overall performance of the system is optimal.
• Performed capacity planning and performance management for the Global BW system. Responsible for managing the production data loads and production support schedule.
• Created and Published Weekly and Monthly BW Metrics for senior management on the overall BW Application performance.

Confidential, NYC

Sr. SAP BW Reporting Analyst

Responsibilities:

• Lead team of developers and external consultants and collaborated with partner consulting firm in implementation and deployment of multiple BI solutions to confidential.
• Involved in rolling out new reporting and analytical capabilities to FRX Marketing groups on BOBJ/SAP platform from various data sources including IMS-RDM, Data View and confidential etc.
• Conceptualized and developed the BI reporting framework in QlikView using BW Info Providers as data source.
• Developed the weekly and monthly EDW staging and reporting data models (DSOs, Info Providers, ABAP routines, Custom Hierarchies etc.) in BW. Developed and realized SAP BEx reports for various market segments.
• Helped increase the reliability of BOBJ reports by extensive data validation activity with the backend data model and gain user confidence by efficient management of user change requests.
• Developed BOBJ universes and reports for Monthly & Weekly Rx data (NRx, TRx, EUTRx) and performed sales data analysis in BOBJ and QlikView.
• Took lead in automating and scheduling BOBJ reports in order to provide the Market Research team with critical executive reports by meeting the SLA.
• Developed prototype solution to demonstrate the capabilities of QlikView for Forest Digital Marketing Team. Also performed Extraction of Speaker Program data into BI and applying relevant business transformation rules and exporting data to SAS.
• Created Business Process models using ProVision.

Confidential

Sr. SAP BW Analyst

Responsibilities:

• Involved with region specific rollouts for EMEA, ASPAC, LATAM and Americas region.
• Responsible for BI Strategy and requirement gathering/gap analysis in line with the defined global business rollout template.
• Integrated JD Edwards (JDE) ERP (Master and Transaction data) with SAP BW using DB-Connect for performing financial analytics on Accounts Receivable data for DSO reporting.
• Implemented Business Content for FI-AR Extractors (Transaction, Line Items, and Payment History & Credit Management modules) which was a SOX compliant source system for SAP BW/BI.
• Contributed to the region-specific project management plan preparation and updates.
• Performed quality assurance & quality control by implementing the quality management plan using the appropriate tools and techniques in order to ensure the deliverables as per the required quality standards.
• Prepared and documented the Functional and Technical design documents along with the quality compliance documents including System test protocol( STP ), System test scripts ( STS ), System test report( STR ), UAT Protocol ( UATP ) and UAT Report ( UATR ), Development Checklist, Error Handling and Business Operating Procedure documents ( BOP ). Performed system testing and captured the test results in MQC (HP-Mercury Quality Center)
• Created BEx reports/dashboards on FI-AR extractors for developing various category reports including DSO, Aging, Credit Exposure and Payment History.
• Worked on creating the Rollback DSO Model for MRC's, Legal Entities (LE) and AR Company by creating custom extractors, DSO's, wDSO's, Info Cubes, Multi-Providers, APD's and Process Chains.

Confidential

Global SAP BW Lead for North America Project Rollout

Responsibilities:

• Responsible for managing and implementing the Global Template (V2) rollout in SAP BI for the confidential region which includes Miami, Canada, Mexico and Puerto Rico.
• Prepared the BI Project Plan for the Americas in consideration with the Europe rollout plan by coordinating with team in Geneva.
• RICEFWs development in the area of Sales & Distribution (SD), PP and APO (DP).
• Architected and developed the Proof of Concept on the integration between SAP BI with SQL Server Integration Services (MS BI - SSIS/SSAS) through Open Hub technology using MS Connector 1.0 in order to support the regional BI reporting environment post go-live.
• Performed Proof of Concept (PoC) for migrating and deploying SAP BI Cube structures to SQL Server Analysis Services (SSAS) layer in Microsoft BI tool.
• Responsible for implementing the 'Global Refresh Strategy (GRS)' by creation of Write Optimized DSO's at the staging layer in order to support frequent data refresh from ECC to SAP BI for various geographies.
• Managed a team size of 3 BI members.

Confidential

SAP BW Developer / Team Lead

Responsibilities:

• Onsite lead developer for implementing Projects and Change Requests in SAP BW.
• Installed and activated the Standard Business Content for OM, PA and EIC modules
• Design and Implemented Analysis and Structural Authorization (0PA DS03, 0PA DS02) for meeting the security requirements of the project.
• Managed a team size of 6 BI members in an Onsite -Offshore project delivery model.
• Performed Data Source enhancements /debugging to meet the various reporting requirements for the above listed HR modules using ABAP.
• Created Generic Data Sources for master (text) and transaction data along with writing user exits in CMOD in ECC 6.0. Performed transports of Workbench and Customization objects.
• Translated the business requirements into functional Specifications for various HCM modules and understanding the HR info types, extractors and master data requirements for the project.
• Prepared the cutover strategy and Integration test scripts for the rollout of BI reporting for multiple sites in a phased approach.
• Coordinated and guided the offshore team for regular project updates and reviews of key deliverables in line with the project timelines.
• Implemented SAP SD, MM, PP, IO, COPA extractors and data models in SAP BW.
• Created Init. and Delta loads from R/3 systems including the scheduling and monitoring of data loads. Also involved in creation of Generic data sources with views on the R/3 side and the writing ABAP transfer routines and update routines.
• Architected and Prototyped the data archiving solution in CO-PA by preforming ADK Archiving
• Involved in designing BEx Reports by using Formulas, Selections, Structures, Calculated Key Figure, Restricted Key Figure, Exception, Conditions, Filter and using variables with different processing types, Query Jump Target using Report - Report Interface (RRI).