CAREER OBJECTIVE:

To contribute to the world of Information Technology in a way that fosters innovation, personal growth and puts forward new challenges to extend the skills and learning opportunity.

SUMMARY:

• 12 yrs. of total IT Experience.
• 12 years of SAP BW experience.
• 1 yr of Big Data - Hadoop-HANA integration experience.
• 5 yrs. of SAP HANA experience. HANA as main EDW with S4 as source. HANA as a DATA HUB - Modeling, Extraction & Reporting. HANA as a Side-Car - Modeling, Extraction & Reporting. Worked on both SP9 and SP10 versions. Worked on complex - SQL Scripting.
• 1 yr of SAP ISU-BW experience.
• 3 yrs of SAP BPC-BW experience .
• 1 year of DSiM experience
• 4 yrs. of SAP BOBJ experience.
• 5 yrs of BW-ABAP experience
• 8 end-to-end implementations, 2 upgrades, 1 rollout and 2 sustainment/development assignments.
• SME for 2 Major BWonHANA Migration projects
• Implemented in SAP ISU-BW Implemented ISU-BW for Billing, Invoicing, Device management and FICA functionality for Major Utility client. Implemented ISU-BW Integration for Sales Statistics Data Flow which included:
• Working with ECC side configs to enable BW extraction.
• Working with functional team to work with reconciliation keys
• Working with table - DBESTA BWPROT to check the closed and open reconciliation keys.
• Implementing mass activity to enable delta transfer to BW.
• Implemented SAP BPC-BW for both Planning and Consolidation. Planning - BW Backend model Budgeting - BW Backend model Forecasting - BW Backend model. Worked on developments and support for BPC front end w.r.t Data manager logic enhancements, ad-hoc data manager loads and issue resolution.
• Experience on BW Upgrade from 3.x to 7.0
• Experience on BW Upgrade from 7.0 to 7.3 including BWA upgrade and Unicode conversion and analysis authorization migration.
• Worked on HR-BW Integration
• PA (Personnel Administration)
• Payroll
• Time Management
• Designed technical design document for the HR-BW Integration design
• Created ETL process PA, Payroll and Time management
• Worked on issues resolution and performance optimization for HR-BW flows
• Worked on COPA model prototype with SAP HANA
• Rich experience in Designing, Modeling, Reporting and extraction work in BW.
• Extensive ABAP experience which includes Routines, User Exits, Function Modules
• Implemented HANA end to end project with WebI reporting - CEI
• Implemented DSiM 2.0 (Demand Signal Mgmt) for Swedish Hygiene Company
• Implemented DSiM 2.0 (Demand Signal Mgmt) custom development through HANA procedures for US largest Sausage manufacturer.
• Implemented HANA POC Design.
• Implemented CEI on HANA project.
• Experience in SCM-BW integration .
• Demo and Training experience in Celonis on HANA
• Knowledge of SAP OPI (Operational Process Intelligence)
• Experience in BW-APO modeling, design and reporting.
• Experience in PBF 8.1 Implementation and Support.
• Experience in Vistex-BW Integration.
• Experience in generic datasources and enhancements.
• Experience in advanced reporting using WAD, BEx web and other tools.
• Experience in BWA implementation, upgrade and troubleshooting.
• Implemented FI G/L (New GL), AP & AR applications in BW.
• Implemented CO-PA model and extraction (Costing based).
• Implemented Project Systems (PS).
• Implemented SD, Purchasing and Inventory applications in SAP BW .
• Implemented POS DM in BW.
• Implemented APDs and OHDs for the data export.
• Implemented archiving using NLS DAP (Near Line Storage - Data archiving)
• Implemented PM (Plant Maintenance) data model and reports.
• Implemented analysis authorizations in SAP BW 7.0.
• Implemented BW Admin cockpit for the BW usage reports.
• Experience in Request Administration Archiving.
• Defect Management, Incident Management and Client handling.
• Experience in User acceptance & Integration testing.
• Mentoring new team members.
• Recognized for a niche in client interaction skills.
• Experience in SOMAN, HP Service Centre, Mercury Quality Centre & Lotus Notes.

EXPERIENCE:

Confidential

SAP HANA Solution Architect & Specialist

Responsibilities:

• Analyzing the data and table structure in the source before provisioning into SAP HANA.
• Building ER diagram and table relationships with start-schema modeling and snow-flake schema modeling, along with history preserving and table comparison operators.
• Working with SDI (Smart Data Integration) using the DP agent and adapters to both pull data from legacy databases and to push data onto cloud based solutions (Netsuite-Monexa).
• Setting up the persistency model with versioning and change control via repository artifacting using HDBDD and HDB* models.
• Setting up the A-LCM(Lifecycle Manager) to design and implement the transport routes and promote the DU (delivery units) across the HANA landscape.
• Building and implementing HANA models with Flowgraphs, Calculation views and Catalog objects (Views, Sequences etc.).
• Performance optimization using the PlanViz tool.
• Building the SAP Lumira and Design Studio dashboards to showcase the data modeled in SAP HANA.

Confidential

SAP HANA Big Data Solution Architect

Responsibilities:

• Analyzing the data lakes and big data formats to be loaded into Hadoop.
• Integrating HANA and Hadoop using SAP Spark Controller, which leverages Apache Spark framework and SDA (Smart Data Access).
• Loading Data into Apache Hadoop (CDP) and building Hive tables.
• Federating data integration into SAP HANA using virtualization framework via SDA (Smart Data Access).
• Setting up the persistency model with versioning and change control via repository artifacting using HDBDD and HDB* models.
• Building and implementing HANA models with Flowgraphs, Calculation views and Catalog objects (Views, Sequences etc.).
• Performance optimization using the PlanViz tool.
• Building the SAP Lumira and Design Studio dashboards to showcase the data modeled in SAP HANA.

Confidential

SAP HANA Lead

Responsibilities:

• Leading the BW on HANA migration project and also the Native HANA – BW HANA mixed scenario using Smart Data Access (SDA).
• The migration work involved end-to-end planning starting with Blueprinting to Go-live and post-go live support.
• This involves executing the pre, post and actual migration tasks. Post migration, the responsibility also entailed optimization w.r.t SAP HANA, table redistribution and cube optimization.
• On the native side, it involved building HANA model with virtual tables using SDA (Smart Data Access) and using the OpenODS view generated Calculation views, combining data.
• Once the HANA modeling is completed, we also need to use Design Studio on tablet mode for the field engineers and reporting end-users.
• Creation of BW backend flow including custom extractors. Bex report creation on top of BW model. Rendering Bex report for BOBJ front end reporting and dash boarding.
• Managing and implementing BPC data manager packages, working with BPC functional team to implement new dimensions, properties and models.
• Working as a lead from BW team for the BPC 7.5 to 10.1 NW upgrade.
• This involves workshops for design sessions.
• Delineating the upgrade and migration plan. Implementing the pre and post migration activities.
• Troubleshooting the issues during the upgrade and migration.
• Modifying the custom Logic Script and BW components to comply with 10.1 framework.
• Working with BPC functional team to implement Consolidation Solution.
• Working with Portal team to implement SSO. Go Live and post Go-live support.

Confidential

Onsite BW Lead

Responsibilities:

• BW Presentations for upgrade process, expected issues and resolutions.
• Upgrade and Authorization migration design documentation.
• End-to-End execution of the upgrade process.
• Analyzing current model and landscape and preparing process documentation to handle all scenarios.
• Pre-upgrade checks and activities.
• Cutover plan preparation and successful execution with minimal issues.
• Pre and post upgrade Portal-BW integration issues and resolutions.
• BEx Broadcasting configuration and automation through process chain.
• Authorization migration from 3.x to Analysis authorizations.
• Optimization of the existing design with performance improvement measure and implementing Industry best practices.
• Replicating the same upgrade modus-operandi for DR (Disaster recovery site)

Confidential

Onsite BW Lead

Responsibilities:

• Client discussions to delineate the BW blueprint.
• Preparation of Tech Spec.
• Analyzing the current model and the SAP Portfolio in EHS for Web reporting.
• Complete Custom development blueprint.
• Implementing multiple custom extractors, based on function modules, both transactional and master data.
• Testing the custom extractors and presenting to client.
• Pre-go live support.
• PoC for PBF 8.1 PEP (Personnel Expenditure Planning) Module:
• Installation of PBF 8.1 BW ABAP Add-on.
• Supported installation of PBF-JAVA Add-on.
• Activation of BI content for fiscal period and flexible pay period PEP.
• Creation and execution of PEP process chains.
• Integration of HR data into PBF PEP.
• Supported the creation and maintenance of master data for Budget Form templates: FM Area, Fiscal Year Variant, Fund Center, Funded Program
• Grant, Functional Area, Fund.
• Responsible for end to end delivery including blueprinting, realization and final delivery.
• Also entails mentoring team members and training client core teams to understand and efficiently use the BI system.
• Completed 2 end-to-end HANA-BO Implementation with complex SQL scripting.
• HANA as a DATA-HUB: Implemented a completely new Solution from ground up for the SAP Marketing Team.
• Requirement involved designing HANA acted a DATA-HUB wherein all the Campaign data needs to be consolidated in the HANA DATA-HUB and processed via procedures and Scripted Calculation views. Finally the data had to be consumed by the BOBJ reporting toolset (Design Studio, WebI, Lumira).

HANA-BO Lead

Confidential

Responsibilities:

• Discussion with Database Architect and understanding the data model for Nurture.
• This model had complex hierarchical relationship between Nurture hierarchy and the relationship between Nurture and Campaign Hierarchy.
• Building the HANA Model which included creation of Attribute Views, Analytic and Calculation views.
• These calculation views were developed using complex SQL scripting to accommodate the requirement.
• Extraction of data from OLTP system (CRM) via SLT to store Campaign related data.
• Built BO-WebI and Lumira reports for Business to visualize and analyze the KPIs.
• Worked on BO-HANA Integration through Universe Design.
• Worked on Analytic Privileges to setup authorizations for reporting users.
• Implemented Dashboarding Solution – VnV – from ground up for the SAP Marketing Team.

HANA-BO Lead

Confidential

Responsibilities:

• Blueprint discussion and Signoff. Translating the Blueprint to Technical Design Document.
• Evaluating various BO-Tools for the best-fit. Evaluated Design Studio, Lumira, Analysis for Office – Excel and WebI.
• Building the HANA Model which included creation of Attribute Views, Analytic and Calculation views.
• Built BO-WebI reports for Business to visualize and analyze the KPIs.
• Worked on Analytic Privileges to setup authorizations for reporting users.
• Worked on 2 Projects which involved end-to-end DSiM config, BO-DS config and implementing custom function through custom HANA Script Procedures.
• Understanding the data and Blueprint and translating it into DSiM components. This involved adjusting excel and csv files to tailor them to suit the DSiM format.
• Converting weekly data format to dates for Enrichment. This involved orchestrating complex lookup logic in the BO-DS job.
• End-to-End configuration setup for DSiM system which included IMG and DSM setup for all the components: Data Upload, Harmonization, Quality Validation and Enrichment.
• End-to-End configuration and setup of BO-DS (Data Services) Project and Job for loading data into DSiM. This setup involved both Master and Transaction Data.
• Supervising the data upload process to make sure all the roadblocks/errors are addressed and the upload is successful.
• Testing of the DSiM data upload, web-dynpro and UI5 reports.
• Presentations and Status Upload to customers.
• Developing custom functions as HANA procedure to accomplish a custom KPI – Most Common Price per Unit.
• Here we had the challenge to convert a C++ code to a HANA SQL script procedure which can handle millions of data. Implemented HANA SQL Script procedure successfully with optimized code.