SUMMARY

• Approximately 12 plus years of experience in the IT industry in various Analytics, Data warehousing, Data Modeling, Data Quality and various BI Analytical tools, design, development, testing and implementations.
• Expertise in SAP BW, BW on HANA, BW/4HANA in Implementations (6) as well as Production support(3).
• Expertise in SAP HANA 1.0/2.0 Modeling, Data provisioning (SAP Landscape Transformation (SLT) to perform real - time data replication).
• Expertise in SAP Analytics Cloud, SAP BOBJ AO and Design Studio.
• Good Knowledge and working experience with Power BI and Informatica
• Knowledge in SAP Business Objects Data Services.
• Experience in HANA Enterprise Modelling including Attribute Views, Analytical Views, Calculation Views, SQL scripting and Analytical Privileges.
• Extracted data from various SAP modules SAP ECC, FI, Controlling, COPA, SD and SCM (Materials Management and Purchasing), PM, CS, HCM, PS & CRM and from NON-SAP(Oracle/SQL) systems as well.
• Experienced in all aspects of BI projects including, gap analysis, blueprinting, design specifications which include functional specification documents (FSD), business process documents (BPD) and technical specification documents (TSD), development, performance tuning, testing, documentation, maintenance, training, security authorizations and troubleshooting.
• Extensively utilized business intelligence reporting tools such as Business Intelligence Platform 4.x/3.x/R3/R2, Web Intelligence, Design Studio, SAP Lumira, Explorer, Dashboard (Xcelsius), SAP Mobile, Crystal Reports, Data Services (Upgrading from Business Objects XI 3.x to Business Objects 4.x), SAP BW and SAP HANA.
• Expertise in full lifecycle design, development, administration and maintenance of SAP Analytical projects.
• Expertise in SAP BW upgrade from 7.5 to BW/4HANA.
• Experience in Master Data Quality, Master Data Governance, Data Integration, Master Data Processes, Standards and Enterprise Master Data Solution Architecture.
• Managed onsite/offshore BI teams during various SAP BI Implementations globally.
• Expert in business operations, data analysis, advanced analytics and reporting.
• Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.
• Strong on End-to-End BW Configurations and Customizations from Extraction, Staging, Loading, Reporting through BEx Analyzer/SAC, Security and Performance.
• Strong expertise in SAP Functional areas such as FI, CO, SD, SCM, PM, PS.

TECHNICAL SKILLS

Analytical/OLAP Tools: SAP HANA, SAP BW/4HANA, SAP Analytics Cloud, SAP Business Objects, SAP Business Objects Design Studio, Crystal Reports, Explorer, Analysis Office, Tableau, Informatica and Power BI.

Programming: ABAP, SQL, PL/SQL.

Databases: Oracle 7.X/8.0/8i/9i/11, Teradata, SQL Server, DB2, Sybase, SAP HANA and Snowflake.

Data Modeling Tools: SAP HANA Studio, SAP BW/4HANA and SAP BW on HANA

SAP Functional Expertise (from Analytics view): SAP CRM, FICO, COPA, SD, SCM, HCM and PM.

PROFESSIONAL EXPERIENCE

Confidential, Wilmington, DE

SAP Analytics Architect

Responsibilities:

• Involving in multiple projects like Data Lake and OMP Projects simultaneously
• Following the Agile Methodology for Data Lake Project
• Gathered the Reporting requirements of type new and change of existing, working closely with Power/Business Users
• Converting the reporting requirements to Design and develop the flows in SAP BW on HANA and HANA systems
• Involved in design discussion and performed the POCs for delta mechanism from SAP BW to Azure
• Developed the BW flows and HANA models as per the design to cater the data to Azure
• Prepared the documentations like TDs, Joining document and RDs for Business Users and Azure team
• Used technical documents to develop the pipelines in Azure for Master data Flows.
• Supported OMP Projects in developing and supporting BW related objects.
• Also Designed and developed Sale change metrics in BW and HANA and AO reports
• Managing TCS onsite and offshore team members and working collaboratively with Confidential Architect team

Environment: s: SAP BW on HANA, SAP BW/4HANA, SAP BOBJ, HANA and Azure

Confidential, Wilmington, DE

SAP Analytics Architect/Lead

Responsibilities:

• Gathered the requirements for Time Tracking Application
• Converted the Reporting requirements to Design along with Confidential Architects
• Co-ordinated with other teams from planning to execution.
• Developed and End to End Application as per the agreed design.
• Gathered the Reporting requirements of type new and change of existing, working closely with Power/Business Users for Integrated reporting from different businesses.
• Converting the reporting requirements to Design and develop the flows in SAP BW on HANA and HANA systems
• Replicated Data Sources from ODP/ODQ Source system
• Implemented ABAP Routines in BW4HANA environment.
• Created new BW modeling objects - advanced DSOs (ADSO), Open ODS, Composite Providers in new “Data Flows”.
• Business Objects - Configuring front end application for planning in BOBJ Analysis for MS Office.
• Developed AO, SAC reports and dashboards from multiple data sources.
• Created HANA Models and consumed the for Finance data model using S/4 HANA View which is based on ACDOCA cds view and ADSO.
• Extensively worked on Open Hubs/APDs and sent the data to BW/4HANA system to use the data in HANA Models
• Created Dimension Calculation views to get master data, Calculation views (with cube or Star Join) to get fact data and utilized Star schema modeling.
• Creating information objects/Data models (packages, calculation views, Decision tables, Stored Procedures).
• Created HANA models using both physical tables and virtual tables.
• Created Analytic Privileges based on filters required as per the users using the privileges like restriction based in country and region etc. using normal filter and stored procedures upon the data models.
• Created Input parameters, calculated columns, restricted columns (KPIs) according to the business requirement.
• Created Calculated Measures and Restricted Measures in Aggregation to serve different business requirements.
• Involved in the upgrade projects such as BW 7.3 to BW 7.5 on HANA and BW 7.5 to BW/4HANA

Environment: s: SAP BW on HANA, SAP BW/4HANA, SAP BOBJ, HANA and SAP SAC

Confidential, Wilmington, DE

SAP Analytics Architect/Lead

Responsibilities:

• Worked with Specco and Agco Project team to collect the business requirements.
• This is Merger project having separate systems each for SAP BW on HANA and DIH.
• Responsible to collect requirements, design and implementation of the data flows, AO and SAC reporting/Dashboards.
• Used technical documents to design and develop the flows as well as Reporting.
• Various data flows developed using BW on HANA, BW and BW/4HANA
• Various models developed wherever live reporting is required.
• Developed SAC Dashboards and BOBJ AO reports during the project
• Managed TCS onsite and offshore team members

Environment: s: SAP BW on HANA, SAP BW/4HANA, SAP BOBJ, HANA and SAP SAC

Confidential, Wilmington, DE

SAP Analytics Lead

Responsibilities:

• Supported SAP BW and BOBJ for all the Confidential Business.
• Point of contact for any issue related to Reporting.
• Managed Multiple teams during the support within Analytics
• Handled small enhancements within AMS and converted big changes to projects
• Created multiple Knowledge documents for repeated issues
• Created User manuals for multiple modules on how use the reporting tools

Environment: s: SAP BW, Bex, SAP BOBJ and HANA

Confidential

SAP Analytics Architect/Technical Project Manager

Responsibilities:

• Involved in daily discussion with Solution Architect/Business team to understand the functional specs and create technical specs accordingly.
• Involved in Daily scrum Calls with the Scrum master to get the list of objects targeted for the upcoming release and worked with the offshore team to deliver them as planned.
• Created Dimension Calculation views to get master data, Calculation views (with cube or Star Join) to get fact data and utilized Star schema modeling.
• Creating information objects/Data models (packages, calculation views, Decision tables, Stored Procedures).
• Created HANA models using both physical tables and virtual tables.
• Created Analytic Privileges based on filters required as per the users using the privileges like restriction based in country and region etc. using normal filter and stored procedures upon the data models.
• Created Input parameters, calculated columns, restricted columns (KPIs) according to the business requirement.
• Created Calculated Measures and Restricted Measures in Aggregation to serve different business requirements.
• Worked on performance tuning the HANA models using Explain plan and Visualize plan.
• Involved in design and development of Advanced DSOs and Composite providers.
• Created filters, variables, prompts and calculations in the universe for KPIs.
• Data provisioning from SAP ECC system to HANA using SLT replication, to replicate tables from source to HANA.
• Loaded data into table definitions, suspending data loads, resuming data loads using SLT Replication.

Environment: s: SAP BW, SAP ECC, SAP BOBJ, SAP HANA and SLT.

Confidential

SAP BW Architect

Responsibilities:

• Understanding the Reports defined for Sales and FI.
• Identifying the Data Sources requirements and informing to Business IT team to prepare table / views that satisfies the Data Source requirements
• Created the Data Sources using UD connect based on the views and tables for the countries Turkey and Gulf
• Created the Data Sources for Kenya, Kenya Pest, Tanzania, Uganda, Turkey and Gulf
• Created complete data flows all the countries for both the Master and Transaction data
• During the course created the Start, End and Field routines and Functional Modules.
• Created the Currency Translation using custom translation type and done currency translation at Query level
• Created a Program to list inactive Info Cubes, DSOs, Transformations, DTPs and all. Also provided the options to send the inactive objects to email or to file on Server or Local
• Managing the Transports of BW and ECC on SAP HANA

Environment: s: SAP BW, SAP ECC, SAP BOBJ

Confidential

SAP BW Team Lead

Responsibilities:

• Gathering the requirements in terms of KPIs
• Analyzing the KPIs and mapping them to Business content Extractors
• Identifying the gaps and logging them as Gaps for further analysis
• Analyzed the few requirements and converted them to Dashboard
• Prepared both Business and Technical Blueprint
• Designed the Dashboard using SAP BOBJ Xcelsius for Prototype purpose
• Identified the Extractors for in all the specified areas
• Prepared the Configuration guide, Technical Blueprint and Developments standards guide for BW
• Wrote many Start Routines, End Routines, Expert Routines and Global Routines
• Set up the BAdIs in ECC and CRM for populating the data for the Data Source enhancements
• Coordinated with the functional teams to understand and identifying the technical gaps
• Coordinated with Offshore for the developments of BW and Business Objects Developments
• Managed the Transports of BW, CRM SRM and ECC
• Done the Cut-Over activities in QAS and PROD
• Involved in Post implementation Support

Environment: s: SAP BW, SAP ECC, SAP BOBJ, SAP CRM and Crystal Reports

Confidential, Lexington, KY

SAP Business Objects Lead

Responsibilities:

• Understanding the requirements from On-site team and from MOMs shared by them
• Prepared the Technical Spec and Unit test plan for each Report.
• Construction of the Reports using Web I.
• Performing Unit Testing for all Reports.
• Coordinate the team and Communicate with the Onsite.
• Ensure the overall quality of the project by following iQMS processes.
• Prepared the Technical Spec for each Dashboard Components.
• Prepared the Unit test plan document.
• Performing Unit Testing for all Dashboard Components.
• Coordinate the team and Communicate with the Onsite.
• Providing the Support for User Acceptance test for all Dashboard Components.
• Prepared the User Manual document.

Environment: s: Business Objects WebI and Xcelsius.

Confidential

Sr SAP BW Technical Analyst

Responsibilities:

• Activation of BI content for BYD Systems
• Upgrade of BYD Systems at different SP levels
• Handling Customer Incidents on various issues
• Handling Health Checks for all systems
• Implementation of SAP notes whenever required and performing manual actions
• Maintenance of TCO (Total Cost of Ownership) Tracking
• Data Download Activity
• BI Broadcasting
• Process Chain Monitoring
• Daemon Monitoring
• Tracking time for each activity through SPC

Environment: s: SAP Business By Design