SUMMARY:

• Almost 17 years of experience in developing and managing software applications. This includes 16 years of experience in SAP Enterprise and Native HANA 1.0, SAP HANA Architecture, SLT, HANA Modeling, Fiori Apps, S/4HANA, CDS Views, HANA Live Views, SAP Vora, HANA Security using Analytic Privileges and Reporting, Universe with SAP HANA, SAP Lumira, SAP BW 7.5 edition for SAP HANA, BW on HANA Architecture, SAP BI/BW, ABAP, BI Dashboards and modeling, Business explorer, SAP BusinessObjects BI Platform 4.0 and BOE 3.1, SAP BusinessObjects Data Services 4.0, Crystal reports, Dashboard Design, Web Intelligence, Universe Design.
• Have experience with the SLO tools, SAP LT for Replication and SAP LT for Data Migration, TDMS.
• Have experience with the Data Migration and Archiving strategies.
• Have experience on Data Provisioning (Data Migration) in HANA using SDI/SDQ, SLT and BODS
• Have experience on setting up the SLT system for the table Replication from SAP and non - SAP source systems.
• Have experience in setting up the SDI/SDQ in HANA, setting up the Data Provisioning Agent and Adapters used for the replication in SDI, setting up the Data Provisioning Monitor for the SDI, use of Transforms for Cleansing/Enriching the data using SDQ.
• Have attended the training from SAP for SAP Vora. Have clear understanding on how Vora can help in integrating Big Data Hadoop with HANA for Analytics, have thorough understanding about the architecture on the HANA and the Hadoop cluster involving SAP Vora/Spark Controller.
• Have experience of Dimensional Modeling and ER Modeling in the Enterprise Data Warehouse.
• Have experience on Data Warehouse Design for OLAP.
• Have experience of over 3 years in HANA that includes Data Provisioning using SLT, OPD and Data Services, configuration and implementation of all 3 types of Fiori Apps, HANA Modeling using graphical user interface and SQL scripting, HANA Live Views and its extensions, Security for HANA Live Views and the Analytic Privileges, BW on HANA, Composite Providers, Transient Providers, Architecture of BW on HANA, combination of BW models and HANA views, Reporting in SAP HANA 1.0, SAP Lumira.
• Extensive Experience with SAP BI/BW Extractors, ABAP, BW Modeling and BEx Reporting, Dashboards using Web templates in SAP BW. Experience with all SAP BW/BI components and ETL processes like creating Info Cubes, Multi Providers, Remote Cubes, Transactional Cubes, Process Chains, Transformations in BI 2004s, Open Hub.
• Strong experience on SAP BOE 3.1, SAP Business Objects BI platform 4.0, SAP BusinessObjects Data Services 4.0. Worked with the Information Design tool, Universe designer, Web Intelligence, Crystal reports and Dashboard Design (Xcelsius in BOE 3.1), BI launch pad (Infoview in BOE 3.1), QaaWS, Central Management Console.
• Worked extensively with BEx Query Designer, BEx Analyzer for developing reports, analysis, and Web reporting.
• Knowledge of Tableau Reporting with HANA
• Have experience with the authorization within SAP BW
• Excellent communication and presentation skills and Customer Oriented attitude.
• Having experience of leading a team, strong team orientation, hardworking and enthusiastic.
• Have experience of managing the project and the team.
• Experience in creating the RFPs for the new projects.
• Experience in giving the Presentations to the end users and also within the organization.
• Have the SAP HANA certification of SAP Certified Application Associate - SAP HANA 1.0
• Have the SAP Fiori Certification
• Have the certification of Project Management Professional (PMP) from Project Management Institute (PMI).

SKILL:

OPERATING SYSTEMS: Concepts of Operating Systems, Windows 2003,XP and Windows 7

SAP: SAP HANA 1.0,SLT, SDI/SDQ, SAP BW 7.5 edition for SAP HANASAP BW3.1, SAP BI 7.0,SAP 4.6C,4,7 and ECC 6.0 and SAP BusinessObjects 3.0, 3.1, BusinessObjects BI Platform 4.0

LANG/ TECH: SQLScript in SAP HANA, Fiori, Modeling, BW 3.1, BI 7.0, SAP LumiraDashboard Design (Xcelcius in BOE 3.1) using Query, QaaWS, Live Intelligence reports, BusinessObjects Explorer, Business Explorer tool (Query Designer, Web Application Designer), Visual Composer, HR

ABAP, non: HR ABAP, C++, Java, JSP, JavaScript, VB Script, ASP,HTML

DATABASES: Oracle, MSSQL

SERVERS: Tomcat 6.0

TOOLS: Junit, Mercury, SAP Lumira

PROFESSIONAL EXPERIENCE:

Confidential

Architect/Lead

Responsibilities:

• Design the complete Corporate Data Warehouse on standalone SAP HANA system to support the Reporting needs. Transaction system used as the data source for this are SAP S/4 HANA and NetSuite.
• Developed and maintained BW reports on HANA, used CDS views as transient providers on S4 HANA system and developed reports using the Bex Queries on top of that.
• Worked with the Virtual Infoproviders by using Calculation Views as Data source and developed the report using the Bex Query and then assigning the report to the Fiori Tiles
• Worked with the CDS views as Virtual Infoprovider to load the data from S/4 HANA system to BPC through BW as staging layer.
• Data Provisioning is done by SLT for Real Time Replication and SAP Data Services (BODS). Provided the Reporting solutions for Sales/Marketing, Planning, Forecast and Master Data. Reporting is done using the BusinessObjects Web Intelligence. Built Tableau Dashboards for Sales/Marketing using HANA views as the backend.
• Developed the complex HANA Calculation Views and Stored Procedures to support the reporting and Dashboard requirements.
• All the S/4 data is replicated into HANA using SLT to make the reporting Real time. Plan, Forecast, Point of Sale, Inventory data are moved to HANA using SAP Data Services. Also few very complex Stored Procedures are scheduled in HANA to refresh the Inventory stock data on a daily basis to reflect it on the Tableau Dashboard.
• Set up the Security based on the Regions across the globe.

Confidential

Data Migration Architect/Lead

Responsibilities:

• Data Migration strategies for the company code carve-out using SLO tools.
• Data Migration and Archiving for SAP ECC.Data Migration and Archiving for the SAP BW. Data Integrity in BW after Archiving.Identify the transformation strategies for the company carve-out using SAP LT. Setup the SAP LT for the Deletion of company codes. Run the Archiving for SAP objects pertaining to FI, CO, MM, SD, QM, PM, PS modules. Prepare the test cases for the unit test. Run the company-carve out scenarios and test all the exception cases where company codes are not deleted using SAP LT.

Confidential

HANA Architect

Responsibilities:

• As part of this POC with SAP America customer wanted us to push the SAP Data to Hadoop using SLT.
• Provided the Architecture to achieve this.
• As part of this Architecture, first we pushed the SAP data to SLT using ODP(Operational Data Provisioning) and ODQ and then from SLT the same data from ODP was used as source for the Data Services and it was subsequently pulled into Data Services. From there on HIVE Adapter was used to push the data from Data Services to Hadoop.
• Configure the SLT for the identified table.
• Replicate the identified tables into ODP of SLT.

Confidential

Lead HANA Architect/Modeler

Responsibilities:

• As part of this project the customer wanted to move on to SAP S/4HANA Road Map, so we migrated the SAP Business Suite from Oracle DB to HANA DB. Product version was SAP ERP EHP7.
• Scope of this project was to configure and implement all 3 types of Fiori Apps i.e. Transactional Apps, Fact Sheets and the Analytical Apps. This is done to build the foundation to use the SAP Fiori Apps for S/4HANA, on premise Enterprise edition of HANA.
• Prepare the system landscape with a dedicated Gateway system as the Front end, SAP Web Dispatcher as Reverse Proxy and the SAP ECC on HANA as the backend system. Configure the SSO between Gateway and the Backend (ECC on HANA) Application server for the Transactional Apps and the Fact Sheets. Configure the SSO between the Gateway and the HANA XS for the Analytical Apps.Configure the infrastructure for the Fiori Launchpad. This includes the activation of the required SICF and OData Services on the Gateway.
• Configure the Embedded search for the Fact Sheets on the backend system. Configure the Web Dispatcher to work as the Reverse Proxy. Configure the HANA XS for the Analytical Apps.Configure the Tiles and Groups on the Launchpad Designer. Implementation of Analytical and Transactional Apps.Worked with HANA Live Views for the Analytical Apps. Extended the HANA Live view. Worked with SQL Script for the Calculation views.Setup the HANA Security and the Authorizations.Extension of Fiori Apps.Integration of custom Apps using LPD CUST with the Launchpad of other Apps.Worked with the Roles and Permissions for the Fiori Apps.

Confidential

Lead HANA Architect/Modeler

Responsibilities:

• Scope of this project was to make the SAP data available in MSSQL database as the business uses the QlikView for the reporting and they wanted to continue with the same tool but with the Real time data from SAP for the reporting purpose. Identified the Background and Dialog work processes in the dedicated SLT system and in the source system of SAP ECC on HANA.Identified the tables to be setup with the SLT and categorized them based on the data volume. This task was done to prepare the tables for the Initial Load.
• Configure the SLT for the identified tables. Granted the required privileges on the MSSQL database schema. Configure the SLT using Advanced Replication Settings for the exceptional large volume tables that were already identified. Start the Replication for the identified tables. Fixed the issues encountered during the replication and also with the load statistics. Setup the e-mail notification for the SLT.Performed the validation in MSSQL for the loaded table.

Confidential

Lead HANA Modeler

Responsibilities:

• Designed the HANA Database for the TSO Analytics/Reporting. Worked with the Basis is setting up the SLT for the ECC Treasury tables in HANA. Worked with the Data Services team in setting up one table getting replicated in HANA from BODS. Market Data, Payments, Investment Trades, Bonds, Fund Data are transferred to SAP Treasury (ECC) via the Web Method and then subsequently these get replicated in HANA using SLT. EOD trade Position file gets transferred to HANA using the BODS. Worked on the Dimensional Modeling to build the Graphical Calculation views.
• As part of this project, 17 Reports are developed. To accomplish this, Application logic is built in the Calculation views and the Procedures in HANA using the HANA Studio. These Calculation views and Procedures are developed using the SQLScript and the Graphical views. These Information Models are consumed in BW on HANA by creating the BEx Queries for on top of these Calculation views using the Virtual Info Provider in BW on HANA. Authorization is set up in BW on HANA. These BEx Queries are called by the AO (Analysis Office). Business users use the Reports via AO.
• Setup the Autosys to schedule a job to transpose one of the SAP tables in HANA using the Procedure. Performed the validation in HANA. As a part of this validation did the testing and comparison between source tables in HANA and HANA views. Handled the currency translation as most of the transactions happen globally.
• Maintained the Design Documents with the ER diagrams and Technical Specs for each Calculation views.

Confidential

BW Architect/Lead Developer

Responsibilities:

• Developed the Virtual Info Providers in BW to pull the real time data from the purchasing (MM module) tables in SAP. Developed the Data Sources in ECC to accomplish this. Developed the BEx queries to pull the data from this info provider.
• Developed APDs (Analysis Process Designer) to save the data in excel.
• Finally this data is incorporated on the contract form using the VB code on the excel. VB work is done by another team member.

Confidential

Lead HANA Architect/Modeler

Responsibilities:

• Designed the HANA Database for the portal Dashboard. Worked with the SAP Data Services team in setting up the database in HANA. From the individual business process within Remedy, identified the tables using the ER Model for the replication in HANA. Data Services is used for the table replication from Remedy database into SAP HANA. Source for these Remedy tables is MySQL database. Another source for this is SAP ECC. SAP ECC data is used for SAP HR and FI data. Used the Dimensional Modeling to create the Analytical and Attribute views.
• Worked on HANA Modeling to have the views for MicroStrategy for the Dashboard reports. As part of this development created the Attribute views, Analytic views and Calculation views. Created the SQL script based Calculation views. Brought some of the complex logic from MicroStrategy into HANA by creating some of the complex calculated columns in HANA views. Designed the security for the HANA views. Implemented the row level security in HANA by setting up the Analytic Privileges for the views. Performed the validation in HANA. As a part of this validation did the testing and comparison between source tables in HANA and HANA views. Also used the Webi reports in BO to compare the results from HANA views.

Confidential

Lead Developer

Responsibilities:

• As part of this project emulated the new GL functionalities into the classic GL. To achieve this developed a new custom extractor for the Balance Sheet account. Created the functionalities of the YTD cumulative balance in DSO.Worked on currency conversion. Developed APDs (Analysis Process Designer) to push the data into excel spreadsheet for the BusinessObjects dashboard. These spreadsheets are the source files for the Webi for Dashboard.
• Worked on the General Profit center allocation. For this created DSOs for Profit center allocation, Profit center allocator and Profit center allocation basis. Worked on the complex logic to allocate the accounts to correct profit centers. GL COPA line item DSO is the Base DSO for the Profit center allocation data.Developed validation reports using Query designer.

Confidential

Lead Developer

Responsibilities:

• Worked on the POC (Proof of Concept) of using HANA as OLTP and OLAP. As a part of this built column stored custom tables in HANA using the SQLScript language. Used the SQLScript functions to Delta Merge the tables with the new data. Performed the Data Modeling in HANA to build the Attribute views for the master data, Analytical views for the transaction data and the Calculation views for the more complex transaction data with the measures from more than one tables. Developed the Analytical Privilege to restrict the access of Attributes inside the Analytical View. Built the reports on top of these views in HANA. For this performed the reporting using the BusinessObjects Explorer of SAP BusinessObjects BI Platform 4.0. Also developed the reports using the Web Intelligence and Dashboard Design clients of SAP BusinessObjects 4.0. To develop the reports using Web Intelligence and the Dashboard Design, built a Universe Design on the top of Calculation views in HANA. This Universe Design is developed to build the Business layer using the Information Design Tool of SAP BusinessObjects.

Confidential, Los Angeles, CA

BI/BW Architect and Lead Developer

Responsibilities:

• Worked on LO cockpit. Involved in Data Modeling and Data Staging. This project required the extraction of the data from SAP R3, built up Design in BW with the Data Targets and providing the validated reports to the user and setting up the procedures for ETL process using the Process Chain in BW.Involved in creating the generic data sources. Involved in creation of Info Areas, Info Objects, Info Cubes, and DSO’s and created required Transformations and DTP to load data into Data targets.Involved in creating the generic data sources. Maintained routines for required objects. Activated and installed relevant Business Content Info Objects. Maintained the Process chains for Master data and transaction data loads.
• Involved in preparation and review of Unit Test Plans & Documentation.

Confidential

Tech lead

Responsibilities:

• As part of this project, HR dashboards have been developed using SAP HR,BI7.0, BOE 3.1, BusinessObjects for BI platform 4.0 and tools like Dashboard Design, Xcelsius, Universe, Query, Live Office, QaaWS(Query as a web services),Crystal reports, Web Intelligence reports, Business explorer
• Dashboard is developed inside the infoview and BI launch pad of BusinessObjects platform. Dashboard has Headcount report, Attrition rate report, Position overview, compensation overview, Action Reason report, Benefit reports, Overtime comptime reports, Payroll posting by fund center report.

Confidential

Tech lead

Responsibilities:

• Inventory turnover rate, Gross Profit percentage, Product Revenue, Operational Cost, Gross Margin Summary by customer and Total Net Sales

Confidential, Los Angeles, CA

BI/BW Architect and Lead Developer

Responsibilities:

• Confidential has been serving as educator to more than three million students. Affordable, accessible and practical, the Confidential offers opportunity to all . The client has SAP HR 4.7 version with concurrent employment feature enabled. Helped in setting up the BW reports on the Enterprise portal. With this the reports are displayed under Tab structure with the Tabs for each area in SAP. Setup the BI statistics reports. Developed reports covering FI/CO, MM, SD, HR,PM, GM modules in SAP. Developed new FI and GL reports. Developed new BW reports for Payroll, Time, Benefits, Personnel Administration, and Organization Management in HR. Developed new reports that integrate FI and MM like PO reports. Developed FI reports that include Open Commitment, Budget availability (Budget vs. Actuals vs. commitments), Transaction actual, Vendor expense, Asset etc. Developed new reports for MM. Few of these are like GL summary and detail reports for PO, Outstanding GR reports, PO balance reports and integration of these MM reports with FI.Developed new Dashboards using the BW query and the Web template for the Benefit Open enrollment for Confidential . These include the benefit data for the employees and the open enrollment status for the district. Setup the open hub in to distribute the data to an excel spreadsheet.
• Setup the Broadcasting feature of the BI 7.0 for FI reports for the managers to see these reports for their respective departments. These reports are scheduled to send the pdf form of these reports through email to the managers and also have the capability to save them on the KM portal.Helped in testing the data load in the BW cubes after migration. Created the test cases in Mercury QC (quality center).

Confidential, Los Angeles, CA

Project lead and BI Architect

Responsibilities:

• This application Confidential (Institutional Effectiveness System) facilitates the Program Review and Planning processes for all campuses within the Confidential . This is used for the accreditation purpose of the various colleges of Confidential . It covers Planning including Goals /Objectives and Budget Prioritization, SLOs (Student Learning Outcomes) and Validation. All these functionalities have to be integrated with the existing Confidential system which is already developed as part of Phase I, which covers Program Review part. The application includes connections between modules of the application and accreditation standards.
• The application is developed using Web Dynpro for ABAP and BI. All the screens are designed using Web Dynpro for ABAP and the BI reports are integrated in this application. The whole application is divided into 3 parts. For the first 2 parts the screens are designed for the administrators (College campus administrator and the Super Administrator) whereas the third part is designed for the users who will be participating in the Planning and Budgeting process of the Accreditation. The application has the validation process as well. For each step of program review work flow has been setup through which email is being sent to respective persons.
• Developed BI reports using WAD and Query designer that is called inside the application. . Managed the project.

Confidential, Los Angeles, CA

Team Lead and BW/BI Architect

Responsibilities:

• Performed functional migration of BW3.1 to SAP Netweaver2004s.Created Data Transfer Process (DTP) to transfer data within BI from one persistent object to another object. Performed migration of emulated data source.Generated Transformations from Transfer rules and update rules in the process of Migration of data flow from 3.1 to 7.0. Implemented Start and End routines within Transformations. Enhanced InfoCubes with remodeling concept to make changes, without having to reload data. Generated Queries using new BEx Query Designer. Designed new applications using new Templates in BEx WAD.Migrated Web templates from BW 3.1 to BI 7.0. Worked extensively with new BEx Analyzer. Setup the Broadcasting using BEx Information Broadcasting to distribute the reports to different sections of the departments/users.
• Conducted training sessions at the campuses for the end users

Confidential, Los Angeles, CA

Technical Consultant

Responsibilities:

• Confidential has been serving as educator to more than three million students. Affordable, accessible and practical, the Confidential offers opportunity to all . The client has SAP HR 4.7 version with concurrent employment. Involved in the HR Reporting project for Confidential .Gathered the requirements from the user. Prepared the technical specifications. Report with List of Employees on Health Benefit Employee Subgroup (ESG) with FTE changes (increase or reduction). This report was made to help Health Insurance to readily identify when changes are made to employee personnel assignments/FTEs at the campus level as it often affects eligibility for health benefits (whether District-paid or POP). Developed a monthly report needed to identify Confidential enrollees who lose eligibility due to change in IT 9001( Confidential specific) and/or ESG (employee Subgroup).

Confidential, Stamford

Onsite Lead Technical Consultant

Responsibilities:

• Involved in the enhancements and the maintenance project for Confidential . Client has WM, FI, SD, MM, PP, HR modules of SAP.Coordinate with the user and the offshore team in India for all the technical issues. Worked on an enhancement to add the remittance advice payment details to the ACH payment files. Developed LSMW for sales order update. Worked on an enhancement to add the signature on the Confidential Checks using SAP Script form and Print program.
• Worked on an enhancement to change the communication method of sending the Payment advice files to the bank.
• For this a program was developed to trigger the Unix script, which is used to send the files to web method server, from where a MW job sends those files to the bank.
• Fixed a bug in already existing interface in which Mainframe sends biiling data to SAP via middleware.
• These data get posted in SAP.
• Worked on an enhancement for the Bar Code Part label using Bar-One software. For this worked on SAP Script form and the print program.
• Worked on an enhancement to add the address field on the checks which Confidential sends to the bank.