PROFESSIONAL SUMMARY:

• Over 13 years ’ experience in SAP which includes S/4 HANA Simple Finance and Embedded Analytics such as SAP HANA,SAP BW, BW - IP, Business Objects (BOBJ ), Confidential following ASAP/Agile methodologies in various industrie s like Retail, healthcare, Chemical, Confidential, banking and Manufacturing. Specializing in Analytics and planning along with extensive work in the areas of Sales and Distribution (SD), and controlling (CO), COPA, GL, SRM, Bank Analyzer, HR, PP, Materials Management (MM), Inventory Management (IM) and Warehouse Management (WM) and have in-depth business process knowledge.
• Overall 13 years of combined IT industry and Management Consulting experience in the area of Business Intelligence, Strategic Enterprise Management, Information Management, and Data Warehouse.
• Successfully led multiple BI teams and implemented several multi-million dollar S/4 HANA Simple Finance/IBPF, Enterprise HANA on premise and Cloud, HANA Live, Integrated Planning, SAP BW,Business Objects (BOBJ), BW on HANA, BWMT, SAP FIORI, TABLEAU, Design Studio, SAP Analytics Cloud(SAC), Lumira, SAP BPC,SAP ABAP for several Fortune 500 companies.
• Successfully implemented several full life-cycle implementations in SAP BI/HANA/IP using ASAP, and Agile methodologies in various industries like Retail, Confidential, Confidential, Chemical, Confidential, Banking and Manufacturing.
• Proactively supported many projects in different phases of life-cycle including business requirement gathering, business blueprint, architect design and solution, data modeling,Cut-over Strategy, UAT testing, post production support, and business user .
• Specialized in reporting and planning along with extensive work in the areas of Sales and Distribution (SD), and controlling (CO), SRM, CRM, HR, PP, Materials Management (MM), Bank Analyzer, Inventory Management (IM) and Warehouse Management (WM) and have in-depth business process knowledge.
• Rich experience in BW ON HANA migration, information and data architecture, system upgrades, requirement analysis, solution design, enhancements, implementation and support.
• Having good Project management experience, project planning, resource planning, resource estimation, project cost and managing the finances of the project, Migration projects, upgrade projects.
• As a Lead demonstrated excellent technical, strategic and interpersonal skills as well as effective communication, leadership, team dynamics and issue resolution capabilities.
• Strong success track helping clients implementing large and complex solutions which best suits their needs.
• Understanding of Hadoop, Hive, Python, SFDC
• Extensive experience in SAP Banking & Financial Services products like FRDP, FSDP, FSDM, FPSL, Bank Analyzer, AFI, SDL, RDL
• Functional understaning of Capital markets
• Flexible in dealing with changing organizational needs and a strong supporter of technical innovation.

TECHNICAL EXPERTISE.

• 12 months experience in S/4 HANA (1511/1605/1610 ) with 2 POC and 1 GO-LIVE Implementations.
• 7 Years experience on Enterprise HANA, BW on HANA, BW/4HANA and Hana Live with 6 full life cycle Implementations
• 12 Years experience in SAP BW,Data Conversion, SAP BODS 4.0, 4.1
• 9 Years experience in SAP Business Objects 3.1, 4.0, 4.1, TABLEAU, Design Studio
• 5 years experience in SAP Banking products
• 2 years experience in SAP FIORI
• 2 Years experience in Integrated planning
• Experience in Data Provisioning using FLAT FILES
• Experience in Data Provisioning using BODS 4.0 (ETL Based Experience in Approach - Building AGILE Data Marts)
• Experience in Building Data Flows in Designer (to Load the Data to SAP HANA).
• Experience in Loading the Data from diff files to SAP HANA using SAP BODS (Text files, spread sheets, XML).
• Experience in Loading the Data from different SAP ERPs (like ECC, S RM)
• Experience in Loading the Data from Non-SAP Source Systems to SAP HANA using SAP BODS.
• Experience in Loading data from CSV, MySQL.
• Experience in Exporting to Binary and CSV
• Experience in Creating a schema in SAP LT
• Experience in Replicating SAP system tables with SLT
• Experience in Real-time replication from ECC to HANA with SLT
• Experience in Building Data Flows in Designer (to Load the Data to SAP HANA).
• Experience in HANA 1.0 & 2.0
• Experience in Web IDE, HDI containers including cross container access
• Experience in working with synonyms, table functions, SDI and flow graphs
• Experience in Creating an attribute view
• Experience in Creating an analytic view
• Experience in Creating a calculation view
• Experience in Creating Attribute Views with Hierarchies
• Experience in Using Create View GUI
• Experience in Calculated columns in an Analytic view
• Experience in Calculated columns in an Attribute view
• Experience in Using Variables with Analytic views
• Experience in Using Decision Tables with update values
• Experience in Using Decision Tables with return values
• Experience in Creating Tables: Row Store vs Column Store
• Experience in HANA Stored procedures
• Experience in HANA XS, CDS, AMDP
• Experienced in using Application Lifecycle Manager(ALM) and CTS+
• Experience in HANA1.0, 2.0, Reporting Layer and Connectivity options
• Experience in SAP Business Objects BI 4. 0, 4.1
• Experience in Designing Complex Universes in IDT based on HANA Tables and HANA Views.
• Experience in WEBi 4.0 on HANA.
• Experience in Crystal Report for Enterprise with HANA
• Experience in Designing the Dashboards using Query Browser on HANA Universes using Dashboard Design 4.0
• Experience in SAP Business Objects BI 4.0 Explorer
• Experience in Designing Information Space based on SAP Experience in HANA Information Model using BO Explorer 4.0
• Experience in Exploring the Data using BO 4.0 explorer based on Information Spaces created on HANA
• Experience in SSO configuration on Cloud
• Experience in Creating Analysis Views using Analysis edition for OLAP (HANA OLAP connection).
• Experience in Information Design Tool(IDT)
• Experience in Universe Designer Tool(UDT)
• Experience in Web intelligence
• Experience in Dashboard Design Tool
• Experience in BI Launch Pad
• Experience in SAP BO 4.0, BW 7.3 Integration
• Experience in SAP BO BI 4.0 SAP HANA INTEGRATION.
• Experience in SAP LUMIRA
• Experience in Multi-dimensional Model in SAP BI 7.4, 7.5
• Experience in Data Extraction and Data Flow within SAP BI 7.3 NW 2004S
• Experience in New Data source Concept of BI 7.3
• Experience in Transformation in BI 7.3(ETL)
• Experience in DTP (Data Transfer Process)
• Experience in UPGRADING DATAFLOWS FROM 3.X TO BI 7.3
• Experience in Business Content
• Experience in Administration of InfoCubes and Aggregates
• Experience in BW HANA objects like Composite Providers, Transient Providers
• Experience in creating simple and complex Aggregation levels
• Experience in creating filters and variables in Plan Modeler
• Experience in data slices
• Experience in planning functions like Copy, Repost, Delete, Revaluation & Distribution by data
• Experience in implementing FOX formulae in planning process
• Experience in creation of input ready queries to accept user input and save the data back to database
• Experience in design and development of planning sequences

PROFESSIONAL HISTORY:

Confidential

Data Modeling/Reporting Lead

Responsibilities:

• Handled teams in multiple geographic locations
• Played the role of Architect of the reporting and reconciliation solution.
• Designed virtual dataflows from Bank Analyzer and S/4
• Involved in development of complex HANA views
• Developed Analysis for Office reports
• Participated in deployment of the solution
• Provided performance analysis and tuning of HANA views and Analysis for Office reports

Confidential

Data Integration/Reporting Lead

Responsibilities:

• Involved in analysis of existing reports and capturing new requirements
• Improvised and made suggestions of better dashboards to the client
• Fixed the bugs in the dashboards
• Automated the dataloads using Process chains
• Modified/Fixed bugs in HANA Calc views
• Designed & built planning applications for Operational planning
• Built custom planning functions using FOX scripting
• Accessed data from FRDP views and modified the HANA views to deliver monthly dashboards
• Delivered new reports using WebI
• Designed & developed Input ready BeX and Analysis for Office queries
• Fixed bugs in Customer Segmentation reports and HANA views
• Used Calc views, performance tuning techniques extensively in providing the dashboards

Confidential

Technical Lead

Responsibilities:

• Used Agile methodology in implementation
• Conducted Scrum meetings on daily basis
• Worked on the largest HANA implementation in the world
• Played a pivotal role in functional design and technical design.
• Involved in analysis of existing reports and capturing the requirements.
• Responsible for development of functional Specifications of Reconciliation process.
• Involved in global delivery model of the project
• Laid down the technical architecture for the technical reconciliations
• Involved in extraction of data from ECC R/3 system using standard and custom datasources
• Extensively used BEx reporting and used BOBJ visualization tools like Analysis for Office and Design Studio
• Built Interactive Dashboards using various components of Design Studio
• Used Native HANA Stored procedures, Calculation views, performance tuning techniques extensively in providing the Tech Recon
• Performance tuning of HANA SQL scripts
• Used different perspectives in HANA Studio like the HANA Development perspective, Modeling perspective, ABAP perspective and BW perspective
• Used filters and parameters in Calculation views
• Has lead the team in testing UI applications built using SAP UI5
• Used Life Cycle Manager and CTS+ to transport objects
• Worked on release management, incident/problem management and ticket handling
• Worked on CDS views and used AMDPs to push down the ABAP code execution to HANA
• Built Composite Providers using BWMT in Modelling the dataflows
• Used SQL procedures extensively in building the Recon solution

Confidential

Technical Lead

Responsibilities:

• Played the role of offshore lead of FI & R2P team.
• Involved in requirement gathering and developing functional specifications.
• Involved in functional and technical design and development of the BI dataflows.
• Involved in extraction of data from R/3 and SRM source systems.
• Designed and developed planning application for cost center planning
• Involved in project planning activities for Change Requests
• Involved in creation of dataflows in BI.
• Used ABAP routines in Transformations and BEx reports and input ready queries.
• Reporting in areas like OTC, Billing, Delivery, Sales Conditions, financial reporting
• Involved in the creation of BO reports.
• Involved in building of Dashboards using Tableau
• Involved in coordination of different teams like ABAP, BODS.
• Involved in the documentation of the project

Confidential

Integration Specialist/ Lead

Responsibilities:

• Involved in migration of database from DB2 to HANA
• Involved in resolution of issues arising in migration.
• Involved in creation of dataflows in BW on HANA.
• Used ABAP routines in Transformations and BEx reports.
• Enabled HANA optimization for the BW dataflows
• Involved in the creation of BO reports.
• Involved in performance tuning of WEBI reports using Query Stripping.
• Involved in the development of POC in BODS
• Involved in the documentation of the project.

Confidential

Development Lead

Responsibilities:

• Involved in design and development of the BI dataflows.
• Involved in extraction of data from R/3 source system.
• Involved in creation of BEx reports to be used in BO frontend.
• Used ABAP in customer exits.
• Involved in creation of BO reports.
• Involved in FERC reporting
• Involved in the documentation of the project

Confidential

Development Lead

Responsibilities:

• Involved in design and development of the BI dataflows required for the Dashboards.
• Involved in extraction of data from Flat File and R/3 source systems.
• Involved in creation of APDs for loading data from BEx reports to Data Targets.
• Used ABAP routines in Transformations and APDs.
• Involved in the documentation of the project

Confidential

BI-ABAP Consultant

Responsibilities:

• Involved in Pre and Post activities of upgradation of SAP BW 3.X to SAP BI 7.0
• Involved in resolution of problems raised during Upgrade.
• Migrated Web templates from 3.5 to 7.0
• Involved in writing test cases and executed the test cases using HP QC.
• Involved in editing the ABAP programs which contained obsolete statements.
• Involved in dataloads before and after Upgrade.
• Involved in the documentation of the project.

Confidential

BI Consultant

Responsibilities:

• Worked with Core team members in studying the client’s business requirements.
• Involved in studying the client’s existing R/3 and BI system.
• Involved in meetings with users for requirement gathering.
• Involved in identifying the enhancements required for the existing system.
• Involved in the preparation of Business Blue Print.
• Involved in the realization of the objects in BI and R/3 systems.
• Worked on enhancements of standard and generic datasources.
• Involved in building the required dataflows in BI system.
• Involved in ABAP coding required in Transformations and Customer Exits.
• Used CKFs, RKFs, variables, filters etc; to design the reports.
• Designed well formatted reports using Web Application Designer.
• Involved in Unit testing and Integration testing of BI objects.
• Involved in the preparation of project documentation.

Confidential

BI Consultant

Responsibilities:

• Studied the technical summaries and data flow diagrams of BW architecture to understand the data flows.
• Written test cases to validate the fields and data of various objects before and after hardware migration in BW3.5.
• Executed the test cases to validate the fields as well as the data in the BW system before and after the Hardware Migration.
• Written test cases to validate the fields and data of various objects before and after Upgradation from BW3.5 to BI7.0.
• Executed the test cases to validate the fields as well as the data in the BW system before and after the Upgradation of BW3.5 to BI7.0.
• Done Regression testing of the test cases which have failed.
• Worked in various areas of QC like Test Plan, Test Lab & Defects.
• Worked on SAP POS (Point of Sale) Workbench to validate data against BW data.
• Thoroughly documented the testing process.
• Done Integration testing of the objects in BI systems across the landscape.
• Involved in Performance testing of the various reports to deliver expected performance.

Confidential

BI Consultant

Responsibilities:

• Worked extensively on Datawarehousing workbench (RSA1).
• Customized InfoObjects, InfoSources and Infocubes.
• Extensively involved in data extraction from SAP R/3.
• Created Infocubes, Datastore Objects by using Transformations, Data transfer process (DTP), Run the Error DTP to load data into Data targets.
• Activated the Standard Business Content.
• Developed Transformations to cleanse and enhance the master and transaction data.
• Used ABAP coding in Transformations and Customer Exits.
• Used Direct access DTP to create data flows to Virtual cubes.
• Generated standard and customized reports using BEx Query Designer.
• Designed well-formatted reports using Report Designer and used WAD to publish the reports on to the browser and in Enterprise Portal.

Confidential

BI Consultant

Responsibilities:

• Involved in Data-modeling, Data Extraction, Generic Extraction, Data Loading, Scheduling, Monitoring and Reporting for MM, SD modules.
• Creating Infocube, Datastore objects (standard DSO, Direct update DSO, Write Optimized DSO) by using Transformations, Data Transfer Process (DTP), run the Error DTP to load data into Data targets.
• Involved in Pre and Post activities of upgradation of SAP BW 3.X to SAP BI 7.0
• Created the datasources.
• Created the data marts like Multiproviders & Infosets.
• Created process chains by using different process types.
• Developed Transformations to cleanse and enhance the master and transaction data.

Confidential

BW Technical Consultant

Responsibilities:

• Involved in Load Monitoring Using RSPCM, RSMO, SM37, and SM50.
• Handled tickets with different priority and never missed the SLA.
• Involved in the modifying the existing reports.
• Involved in performance tuning of Queries.
• Involved in both the Activities monitoring and Production Support.
• Maintained Work History for all the tickets until it is closed.
• Involved in validating data consistency in reporting with Data Target against PSA after loading them to data targets.