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.

PROFILE HIGHLIGHTS:

• 12 yrs. of total IT Experience.
• 12 years of SAP Confidential 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 experience.
• 3 yrs of SAP BPC experience .
• 1 year of DSiM experience
• 4 yrs. of SAP BOBJ experience.
• 5 yrs of Confidential -ABAP experience
• 8 end-to-end implementations, 2 upgrades, 1 rollout and 2 sustainment/development assignments.
• SAP BO WebI 4.0 Certified
• SME for 2 Major BWonHANA Migration projects
• Implemented in SAP ISU- Confidential Implemented ISU- Confidential for Billing, Invoicing, Device management and FICA functionality for Major Utility client. Implemented ISU- Confidential Integration for Sales Statistics Data Flow which included:
• Working with ECC side configs to enable Confidential 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 Confidential .
• Implemented SAP BPC- Confidential for both Planning and Consolidation. Planning - Confidential Backend model Budgeting - Confidential Backend model Forecasting - Confidential 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 Confidential Upgrade from 3.x to 7.0
• Experience on Confidential Upgrade from 7.0 to 7.3 including BWA upgrade and Unicode conversion and analysis authorization migration.
• Worked on HR- Confidential Integration
• Designed technical design document for the HR- Confidential Integration design
• Created ETL process PA, Payroll and Time management
• Worked on issues resolution and performance optimization for HR- Confidential flows
• Worked on COPA model prototype with SAP HANA
• Rich experience in Designing, Modeling, Reporting and extraction work in Confidential .
• 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- Confidential integration .
• Demo and Training experience in Celonis on HANA
• Knowledge of SAP OPI (Operational Process Intelligence)
• Experience in Confidential -APO modeling, design and reporting.
• Experience in PBF 8.1 Implementation and Support.
• Experience in Vistex- Confidential 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 Confidential .
• Implemented CO-PA model and extraction (Costing based).
• Implemented Project Systems (PS).
• Implemented SD, Purchasing and Inventory applications in SAP Confidential .
• Implemented POS DM in Confidential .
• 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 Confidential 7.0.
• Implemented Confidential Admin cockpit for the Confidential 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.

PROFESSIONAL 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.

SAP HANA Lead

Confidential

Responsibilities:

• Leading the Confidential on HANA migration project and also the Native HANA - Confidential 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 Confidential backend flow including custom extractors. Bex report creation on top of Confidential model. Rendering Bex report for BOBJ front end reporting and dash boarding.
• Creation of Confidential models and flows for BPC.
• Managing and implementing BPC data manager packages, working with BPC functional team to implement new dimensions, properties and models.
• Working as a lead from Confidential 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 Confidential 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 Lead

Responsibilities:

• 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- Confidential 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 Lead

Responsibilities:

• 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 Confidential 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
• 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 .

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.
• 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.