PROFESSIONAL SUMMARY:

• More than 14 years of IT industry experience encompassing a wide range of skill set and roles
• Worked in Germany for few years in Dusseldorf and Essen. Worked also in Belgium and France.
• Extensive knowledge in Tableau, SAP BI, SAP HANA, Business Objects, Mongo DB, Composite DV, a part of Data lake for Big data, Alteryx, Hadoop.
• Worked extensively in SAP BW, BPC,HANA and Tableau modelling.
• Worked on defining design and implementation of SAP BPC 11.0 planning models for forecasting. A full cycle implementation of Finance forecasting cycle for various models was done.
• Extensive experience with analysis, design, development, and implementation of integration and BI solutions
• Proficient in analyzing and translating business requirements to technical requirements and defining architecture
• 13 + Years of experience in SAP BI tools.
• SAP Certified BI Solution Consultant, BPC, HANA 2.0 and S4 HANA. Total 4 certifications from SAP.
• Worked in multiple software implementations from concept to completion, played several key roles like BI Solution Architect, Project Lead and developed expertise in the areas of solution architecture, business analysis, business process design and improvement, SAP BI thought leadership, BI Center of Excellence setup and BI education, among others.
• As a part of SAP BI Center of Excellence, developed expertise in the areas of bridging the gaps between IT and the business, integrating process re - engineering and continuous improvement into BW projects, creating and maintaining architectural standards, centralizing and formalizing the housing and reuse of code, promoting standard methodologies, tools and education.
• Good communication skills, interpersonal skills, self-motivated, quick learner, Excellent team player overseeing fast-paced, time-critical project environments. Recognized as a creative and effective trouble-shooter and problem solver at all times
• Experience in working with the teams across the globe.
• Worked in various Proposals for new client bids, various Conferences and client presentation were given and we did win few of the client engagements.

TECHNICAL EXPERTISE:

• Enterprise Package processes(SAP Business Intelligence Implementation Methodology)
• Tableau
• SAP BPC 11 and 10 - Embedded Netweaver
• Mongo DB extraction and architecture
• ETL & Data Quality(ETL & Data Quality - ALL)
• Manufacturing(Manufacturing - ALL)
• Reporting, Analytics & Visualization(SAP Business Objects)
• SAP Functional(SAP CRM)
• SAP Functional(SAP FICO)
• SAP HANA and BW on HANA
• SAP Technology(SAP HANA)
• SAP Technology(SAP NetWeaver - EP)
• SAP Technology(SAP Solution Manager)

SKILLS:

Domains: Finance, COPA, SD, CRM Sales, CRM Services, Inventory, MM and refurbished Life cycle.

Data Warehouse: SAP BPC, SAP Business Intelligence/ Warehouse, SAP HANA, Oracle, Tera data, Mongo DB, Hive, BO

Data Visualization: Tableau, Analysis Office, Business Objects, SAP BeX, Xcelscius

Data Virtualization: Composite DV ( Confidential Information Services), Smart Data Access

Implementations: 2 Full Cycle Implementations(BW) and 1 Implementation (SAP BPC 11)

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, California

Technology Lead

Responsibilities:

• Playing the role of lead and Onsite coordinator.
• Full scale implementation for BPC models for forecasting on Embedded BW4HANA in progress.
• Build Forecasting models on Embedded BPC 11 NetWeaver.
• Green field implementation of 5 models based on BW4HANA and BPC.
• Custom and Corporate hierarchies built on data extracted from non-SAP systems.
• POC for various types of hierarchies which can be used by various models and hence scalable features.
• Since embedded use of FOX formulas to create planning functions and sequences.
• Data extraction from CDS views from S/4 HANA Central Finance.
• HANA Analytical models build from Revenue and Bookings reporting. Attribute views, analytical and majorly Calculation views were created to create virtual data marts.
• Full scale implementation for BPC models for planning on Embedded BW4HANA in progress.
• Analysis is going on to use have few BPC models to be taken from BPC to Out of box Predictive models in HANA and then feed them back to BPC.
• Bw4Hana implementation in progress for the underlying data marts from various Non-SAP sources.
• Co- ordination with Business for requirements and specifications.
• Co-ordinate with Tableau COE/Power BI to get the details of newer versions, test few features and use it for the performance issues faced in our project.
• Native HANA MODELLING - Designing Views (Attribute View, Analytic View, Calculation View), Stacked Calculation Views, Views that needs multiple table functions, counters, Restricted and Calculated measures, input parameters, filters, transparent filters. Debugging Views. HANA Modeling using SQL Script
• BODS extractors creation and maintenance for both SAP and Non-SAP data sources. SLT and ODP frame work used for data extraction .
• POC’s on the new technological roadmap to find the right fit of technologies.
• Open ODS views with SDA were used for reporting and reconcilation
• Worked on few analytical reports from SAP S4 HANA.As a part of this worked on CDS views and the implementation part of it .
• Implemented transformations with BADI, ABAP routines with field level and expert routines as well.

Confidential, San Jose, California

Technology Lead

Responsibilities:

• Implementation of the Tableau dashboards with proper data blend.
• Played the role of lead and Onsite coordinator.
• Development of Tableau charts for specific KPI’s.
• Experience with Tableau for Data Acquisition and data visualizations using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Implementation custom design planning by understanding user requirements.
• POC for using BPC 10 for planning needs and find out the fit -gap analysis.
• Understand the previous planning based on Standard BPC 10.0 and conversion of the same to embedded BPC 11.
• Change from Account based to Key figure based model to bring in more flexibility along with keeping the business understanding intact.
• Look in for options to derive key planning metrics like Intelligent pricing, Reservations based on BPC or data science.
• Started on POC for building embedded BPC planning in S4 HANA Simple finance embedded instead of using data uploads to a different system like BW.
• Restricted data for particular users using Row level security and User filters including customizations based on specifications.
• Developed Tableau workbooks from multiple data sources using Data Blending and Cross DB joins.
• Generated Tableau Dashboard with quick/context/global filters, parameters, calculated fields, interactive views, trends and drill downs along with user level security
• Currently working to use Data Prep tool of Tableau for a building a business layer.
• Data retrieval, transformation from HANA and Hadoop Data lakes.
• HANA Analytical models build from Revenue and Bookings reporting. Attribute views, analytical and majorly Calculation views were created to create virtual data marts.
• Process to convert Analytical and attribute views to calculation views were being analyzed/
• SLT used to retrieve Supply chain data for reporting on near real time.
• Blend data for different systems from to develop data patterns and charts.
• Co- ordination with Business for requirements and specifications.
• Analyze the data, patterns and statistics to come up with new KPI’s to help business. We used predictive Analysis tool Alteryx for this aspect and some part of HANA Analytics.
• Few patterns like Intelligent pricing, Inventory Build and stock were designed using predictive algorithms by the means of tools and raw data analysis.
• Heterogeneous data sources were used to get the proper threading and analysis.
• Data virtualization on Composite DV for from heterogeneous source systems.
• Work on data warehousing design for the increasing complexity of KPI’s and develop data mining options.
• Co-ordinate with Tableau COE to get the details of newer versions, test few features and use it for the performance issues faced in our project.
• Native HANA MODELLING - Designing Views (Attribute View, Analytic View, Calculation View), Stacked Calculation Views, Views that needs multiple table functions, counters, Restricted and Calculated measures, input parameters, filters, transparent filters. Debugging Views. HANA Modeling using SQL Script
• Reports based on SAP BW were translated to Tableau and some were based directly from Calculation views from HANA along with Data models where required.
• Work on Mongo in the migration phase to design and convert all Oracle structures and data to Mongo.
• POC’s on the new technological roadmap to find the right fit of technologies.
• Worked on few analytical reports from SAP S4 HANA.
• HANA SECURITY & TRANSPORT- Creating Analytic Privileges, Setup data level authorization and privileges at SAP HANA Database, Creating User, Roles & assigning the respective Privileges

Environment: Tableau 9.3,10.2, Tera Data, Oracle 11G,SAP HANA, Hadoop, SAP BW, Alteryx, Business Objects,CIS,S4 HANA Analytics

Confidential

Technology Lead

Responsibilities:

• Implementation of the HANA for Supply chain.
• Design and build Calculation views in HANA.
• Replace the existing oracle objects with HANA objects with modifications to suit HANA implementation methodologies.
• Design models in LSA++ architecture to enhance performance of analytical engine of HANA.
• Analyze where we need to use BW models and merge data from Tera data without any data persistency.
• Use the features such as Mixed scenarios, virtual data marts to report the required amount of data.
• Segregate the design to understand the types of objects which needs to be created like attribute views, Analytical views etc.… upon analyzing the data.
• Calculation views to be consumed in Tableau for dashboards and co-ordination with Tableau team to get the right mix of complexity.
• Created Calculation views by Hana Native Queries as well as Graphic Modelling tool.
• BO Webi reports developed for consumption of data.
• Develop back-end design, construction and unit testing of the Advanced DSO, Info Cubes, Composite Providers, Multi-Providers, and Info Packages.
• Experience with proper data architecture, PSA maintenance, Info Packages, Data Transfer Process (DTP), Delta functionality, Flexible Master data staging, and debugging loads using the Data load Monitor.
• Working with SAP BO tools set like SAP Universe designer, Web Intelligence, Analysis For Business Explorer, Xcelsius (Dashboard) and SAP BI tools like Query Designer, BEx Analyzer, BEx Web analyser and Application designer.
• SAP Native Hana Data Modeler Developer to utilize HANA Data Modeling for custom Revenue Accounting solution
• Extensive and thorough IT know-how regarding web technologies and solutions
• HANA SECURITY & TRANSPORT- Creating Analytic Privileges, Setup data level authorization and privileges at SAP HANA Database, Creating User, Roles & assigning the respective Privileges.
• Good Experience in Creating Repository, adding Users and Groups, Assigning Password, security, Assigning privileges to Documents and Universes. Designed, implemented and migrated complex Universes and Business objects Reports, Created classes, subclasses, objects, Cardinalities, Contexts, joins, external Strategies, prompts. Extensively used Tableau for specifications such as Master Detail, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.

Environment : SAP HANA SPS 9, Oracle 11g, SAP BW for HANA, Business Objects, Tableau

Confidential

Technology Lead

Responsibilities :

• Business co-ordination for the use of the newly created Global implementation.
• To identify the key areas where specific changes could enhance business usability.
• Resolve all the escalations with proper business discussion and design the technical changes accordingly.
• Identify the glitches in technical solution to find out a permanent solutions to the changing process.
• Develop BO reports and Data warehousing layer according to the enhancements.
• Onsite co- ordination and follow-up with Offshore team for technical design and development.
• Work on WeBi, Xcelsius and Analysis office reports for changes and enhancements.
• Experience in creating virtual characteristics, key figures using both user exits and BADI’s and user exit variables
• Change or create new models in SAP BW

Environment : SAP BW 7.3 and 7.0, SAP BO

Confidential

Technology Lead

Responsibilities :

• Team Lead for the entire support project related to BW.
• Handle and co-ordinate the overall support activities for the recently developed models
• All the tickets for the modules such as Finance, CRM, Sales and Inventory.
• Activities included analysis and root causing the solution
• Identify long term and short term solutions for problems identified.
• Prepare the required transition plans for Project and Support teams.
• Perform the month end activities for co - ordination between Finance and BW reporting perspective.
• Interact and understand the functional activities in source systems like CRM Services, Sales, Finance to provide root cause and finding the appropriate fix.
• Month end activities and verification with teams who would be putting in financial figures and performing monthly closing.
• Extracted data from SAP R/3 using LO Cockpit, Generic and Business Content Extractors.
• SAP BI ABAP - Created Update rules, Transfer rules, Transformations, Start Routine, End Routine, user exit and function module code for generic data source.

Environment : SAP BW 7.3 and 7.0, SAP BO

Confidential

Technology Analyst

Responsibilities :

• Stream lead for CRM Services module implementation in BIBO.
• Green field implementation of BI part of CRM services.
• Full cycle implementation from scratch with only the table names in hand.
• Analyzing the table data and vigorous discussion with functional CRM folks to prepare the blue print and design the whole application in BI for CRM services.
• Handled a team to work on the planning and technical objects and reports.
• The reports were in WebI, Analysis office and Xcelcius dashboards.
• Data sources were analyzed, new custom data sources were designed and flows for our project specific implementation was done.
• HR related objects and data sources were also engaged to get the services related information.
• Worked extensively on standard and custom defined LIS, LO extractors. Installed relevant SAP business content. Used LO structures for extracting sales order, delivery information. Logistics Cockpit configuration and customization

Environment : SAP BW 7.3 and 7.0, SAP BO

Confidential

Technology Analyst

Responsibilities :

• Played role of an Onsite coordinator and Team member.
• Working on Bex Analyzer, WAD, Report Designer and BW 7.0.
• Main task involved working on Change requests for specific modules.
• Involve with business to understand their requirements and work on the respective Change requests.
• Part of the work also related to checking the support incidents and analyzing the root cause to solve the issue.
• Worked extensively on standard and custom defined LIS, LO extractors. Installed relevant SAP business content. Used LO structures for extracting sales order, delivery information. Logistics Cockpit configuration and customization
• Point of contact for all Upgrade tasks and new module integration also including new company codes in the system etc.
• Worked in Germany as the Onsite coordinator to involve in Business discussions and getting the requirements done in system.
• Worked extensively with BEx Query Designer, BEx Analyzer and Web Application designer for creating custom and enhanced reports.
• Solid experience in Front-end BW queries, workbooks and templates, RRI, Calculated and restricted key figures, Variables, Information Broadcasting and publishing reports in the Portal.

Environment : SAP BW 7.3 and 7.0, SAP BO