SUMMARY

• SAP AG Certified in SAP BI 7.3/BO 4.0 and SAP HANA with more than 10 plus years of experience.
• Expertise in all phases of SDLC like Realization, Analysis, Functional and Technical specification, Development, Integration and UAT, End - User trainings and Post Go-Live support.
• Worked in Agile Methologody.
• Experience in Leading and managing teams. Handled multiple roles like Senior BI consultant, Onsite Coordinator, BW Tech Lead and BW Developer.
• Holding more than 5 years of experience in Webi Reporting and Administration.
• Good Experience in Webi reporting on Non-SAP sources and on SAP HANA (Ms Access, Oracle, etc).
• Expertise in ETL and Data Modeling (Data Extraction, Generic Extraction, Data Loading), Scheduling, Monitoring, Reporting Web publishing.
• Extensively worked on Info-objects, Info Sources, Info Cubes, DSOs, Multi Provider, Info Set, Transformations and Process Chains.
• Extensively worked in BW Security on end user authorizations for reporting.
• Good Experience in Experience in Solomon Manager - Charm.
• Strong ABAP programming skills including Data Source Enhancements, Routines (Start, Field, End and Expert Routines), Customer Exit Variables, Info Package and DTP Routines.
• Exclusively worked on BW/HANA testing, Unit Testing, Regression testing and DR testing.
• Experience on Native HANA and SAP BW Powdered by HANA
• Experience on SAP Native HANA Data Provisioning (SLT, DXC, BODS and SDA), Data Replication, Modeling and Reporting.
• HANA modeler experience includes creating Composite Providers, Advanced Data Store Objects, HANA Views (Analytic, Attribute and Calculation). Extracted data from ECC and created reports using reports SAP Landscape Transformation Replication Server (SLT). Created reports on external Databases using Smart Data Access (SDA). Business Objects Data Services (BODS) is used as an ETL from extracting data from external systems.
• Involved in Transporting HANA Views from Dev to Production using Delivery Units.
• Have hands on experience in HANA modeling in creating Attribute, Analytic and Calculation Views.
• Extensively Involved in the SAP BW 7.3 to 7.5 upgrade with HANA as database - Pre and Post Upgrade activities and Fixes.
• Extensive knowledge in Integrated Planning, resolved the end user incidents in IP.
• Involved in three full - life cycle BW implementations, upgrade from 3.X to 7.5, Enhancements and Post Production Support in the areas of SAP SD, MM, PP, PM, PS, FI and SAP CRM.
• Expertise in BW Performance Tuning of Queries by maintaining Aggregates, Compression, partition and indexing of Info Cubes.
• Extensively worked on Tableau Dashboards on top of HANA, BW Systems.
• Good Knowledge on Enterprise HANA, Live HANA and Native Hana
• Worked on LUMIRA as frond end reporting tool.

PROFESSIONAL EXPERIENCE

Confidential

SAP BW/HANA Lead

Responsibilities:

• I was responsible as a DevOps lead consultant in an onshore-offshore 24/7 support model to work across full sap life cycle implementations and production support like requirements gathering, design, development and post go live support and enhancements.
• Involved in end-to-end project implementations, with global/regional rollout of SAP, Upgrades and Production Support.
• Created Info objects, DSO’s, SPO’s and Cubes & Composite Providers, Bex queries as per the data model. Defined several transformations as per the need.
• Performed clean-up activities for the pre-emigration of BW on HANA implementation. Optimized BW cubes for HANA purpose
• Good Experience on BW on Hana model.
• Involved in creating the nested graphical calculation views on the DSO’s which is exposed in HANA.
• Good experience in Microstragy reporting based on Hana views.
• Good experience on Open hubs which is tightly integrated with Informatica..
• Extensively worked on Webi reporting.
• Collaborating with process partner organizations to gain an in-depth understanding of their business information requirements and then designing, documenting, developin and testing complex HANA data models that assimilate data from multiple sources system (SAP and non-SAP) to effectively and efficiently solve business requirements.
• Responsible to deliver the projects on time without a single escalation from the client.

Confidential

Sr SAP BW/HANA/BO/ Developer/Lead

Responsibilities:

• Extensively worked on FI reporting, created the FL flow from scratch.
• Managed, Configured and Performed Transports between multiple BW environments. Defined practices for BW transport management. Created multiple process chains for Delta & Full Data sources. Troubleshooting data and technical issues related to SAP BW.
• Interaction with business users and gathered the requirement and built the Bi reporting accordingly.
• Extensively worked on the custom/standard Info-objects, Info Sources, Info Cubes, DSOs, Multi Provider, Info Set, Transformations and Process Chains.
• Led efforts on handling of UAT and coordinating with offshore team for quick closure of bugs reported
• Worked on SAP MM, SD and all other modules.
• Created customer data sources and worked on SAP defined data sources and built the BW flow according to the requirement.
• Worked on SAP BW on HANA and worked on mixed modelling scenarios.
• Worked on HANA studio, created of the all Information Views.
• Worked in Solomon Manager, used CHARM as the transport mechanism to transports the objects throughout the landscape.

Confidential

Sr SAP BW/HANA/BO/ Developer/Lead

Responsibilities:

• Designed and implemented SAP HANA data modeling using Attribute View, Analytic View, and Calculation View.
• Involved in Test final output based on requirements and business needs.
• Extensively worked on Info-objects, Info Sources, Info Cubes, DSOs, Multi Provider, Composite Providers, Transient Providers and Transformations and Process Chains.
• Created BEx Reports providing insight of Business Intelligence to aid the analysts in decision-making using Formulas, Selections, Structures, Calculated Key Figure, Restricted Key Figure and Customer Exit.
• Developed BOBJ Webi reports on BW queries and HANA views used the IDT.
• Worked on SAP Native HANA and BW on HANA used the Data Provisioning (SLT, DXC and BODS and SDA), Data Replication, Modeling and Reporting.
• Worked on HPQC tool for BW testing, created test scripts, test plans.
• Worked Extensively on Webi reporting using BICS connection to connect the Bex Queries.
• Exclusively worked on BW/HANA testing, Unit Testing, Regression testing and DR testing
• Worked on DSO look-ups at start routine and end routine using Classes and Methods.
• Creation/Change of Process Chains for the entire Daily / Weekly/Hourly Loads..
• Provided hyper care- Post Implementation Production Support includes Monitoring the Process Chains Daily, Weekly and Monthly. Troubleshooting and Correcting the Data Load Errors.
• Involved in Data Source Enhancement using the BADI-Enhancement Spot.
• Involved in all support pack activities every quarterly.
• Created the connection between IDT and HANA views
• Proficient in importing HANA models into IDT
• Created Interactive design studio dashboards on HANA views
• Created Info objects, DSO’s, and Cubes & Multi providers as per the data model. Defined several transformations as per the need. Performed clean-up activities for the pre-emigration of BW on HANA implementation. Optimized BW cubes for HANA purpose .
• Created generic data source for custom requirement and enhanced data sources as required.
• Managed, Configured and Performed Transports between multiple BW environments. Defined practices for BW transport management. Created multiple process chains for Delta & Full Data sources. Troubleshooting data and technical issues related to SAP BW.
• Created Complex Bex reports using Composite Providers.
• Create Open ODS view and Advanced DSO’s in HANA Studio.
• Reconciled Inventory and purchasing data from BW to R/3 for existing Production reports

Confidential

Sr SAP BW/HANA/BO//Lead

Responsibilities:

• Facilitate requirements gathering and reconciliation of data definitions with business and IT experts.
• Playing a Lead role for onshore and offshore.
• Designed and implemented SAP HANA data modeling using Attribute View, Analytic View, and Calculation View.
• Involved in SAP HANA Security including User Management, Roles, and Privileges.
• Evaluate the information gathered from multiple sources, reconcile conflicts, and decompose high level information into details, abstract up from low-level information to a more general.
• Understanding, distinguish presented user requests form underlying true needs and distinguish solution ideas from requirements.
• Involved with basis team in the upgrade process from BW 7.3 to BW 7.4 version HANA as a database.
• Prepare requirements documents to be used as the basis for project development.
• Leading Onshore and Offshore teams.
• Involved in BO and Tableau server maintenance and installation, configuration.
• Experience in publishing reports, dashboards and data sources to Tableau Server.
• Test final output based on requirements and business needs.
• Using Design Studio created the dynamic dashboards.
• Coordinate with global IT and Business teams to deliver the requirements
• Created the Open Hubs for PS Flow, HRMS, Time Entry and COPA Data Flows to transfer the data to Third Party PDW System.
• Extensively worked on Info-objects, Info Sources, Info Cubes, DSOs, Multi Provider, Info Set, Transformations and Process Chains.
• Extensively worked on Data Source Enhancements.
• Data provisioning using SAP Landscape Transformation and SAP Dataservices, DXC, Flat File Uploader, SAP HANA Architecture Participated in year-end Rollover to gather requirements from business, do impact analysis and Implement changes.
• Used DSO look-ups at start routine and end routine.
• Worked on SAP Native HANA Data Provisioning (SLT, DXC and BODS), Data Replication, Modeling and Reporting.
• Expertise in SAP Native HANA data modeling using Attribute View, Analytical view and Calculation view where non BW sources where used.
• Experience on Open ODS View, Composite providers and Transient providers
• Created BEx Reports providing insight of Business Intelligence to aid the analysts in decision-making using Formulas, Selections, Structures, Calculated Key Figure, Restricted Key Figure and Customer Exit.
• Created multiple Visualization reports/dashboards using Dual Axes charts, Histograms, Filled map, Bubble chart, Bar chart, Line chart, Tree map, Box and Whisker Plot, Stacked Bar etc. using tableau.
• Involved in writing the td and fd documents, and developing and deploying technical components of Tableau BI Solution.
• Created daily, weekly, monthly and quarterly reports for the management team and Regional Managers
• Create parameterized reports (these reports show information from highest level by company and can be drill-down to single product using hyperlinks), cross-tab, conditional, and Top N, Summary and Sub reports in Web Intelligence.
• Effectively used data blending, filters, actions and Hierarchies feature in Tableau
• Experience with Single Sign on with Tableau.
• Worked on data blending for data extracts and ability to work with multiple data sources.
• Built the tableau dashboards and bubble charts as the source as SAP BW (bex query) and SAP HANA views.
• Developed story boards and dashboards on HANA Information models using SAP Lumira.