SUMMARY:

• 11+ SAP professional years of experience in the development and implementation of the business applications with extensive experience in SAP Confidential 3.5/BI 7.0/7.3/7.4/7.5 , SAP BOBI 4.0/4.1, SAP HANA 1.0 and HANA 2.3 as a techno functional consultant.
• Worked on SAP Confidential on HANA, SAP BW, Integrated Planning (IP), Enterprise Portal and ABAP/4 Programming on various Support and Implementation projects playing different roles such as Team Lead, Team Member and Offshore as well as Onsite Consultant.
• Requirement gathering and lead the team (Offshore and onsite model).
• Worked on Finance Month end close activity
• Worked on Transient Provider/Virtual Provider Based on a SAP HANA Model, Operational Data Provisioning (ODP), Open ODS Views, Data services for SAP and non - SAP systems
• Worked in HANA modeling in modeler and developer perspective in HANA Studio.
• Created repositories and developed views, procedures and tables in project explorer in HANA Studio.
• Worked on import/export Delivery Units.
• Importing of flat files into HANA Studio. Exporting and importing of tables.
• Developed attribute and analytic views on top of hana tables.
• Created odata service on analytical views which is then used by upstream system like web applications.
• Created schemas, tables and Procedures to load the data from source systems to staging tables and then from staging to core tables.
• Developed calculation views related to Automated Validation reporting in SQL script and Graphical views.
• Used variables, filters, input parameters in views.
• Used Analytical privileges.
• Exporting and importing of objects and Delivery unit migration. Loading CSV files in tables.
• Performed Performance tuning in SAP HANA to process and load millions of data.
• Developed Confidential models on top of calculation and analytical views to feed the data to BW
• Hands-on experience on SAP BO reporting tools primarily Xcelsius Dashboard Designer, webi reports, Analysis for office and Crystal Reports.
• Worked on Confidential Reporting on SAP Industry Specific Solutions for Utilities, manufacturing company.
• Involved in implementing decision making dashboard in visual composer for one on utility client
• Involved in setting up of SAP Enterprise Portal, BEX Broadcaster and Pre-Calculation Servers.
• Very good analytical ability and a knack for reaching to the crux of difficult problems.
• Created dashboard and reports using web templates, Visual composer and Crystal reports.
• Extensive experience in content administration, system administration, Collaboration, KM of enterprise portal.
• Created iview, workset, roles etc,Configured jive Forum,
• Have Knowledge about Integrated Planning
• Worked on SAP BI security(User and Role management)

PROFESSIONAL EXPERIENCE:

Confidential, CA

Onsite Lead - Reporting and Analytics

Responsibilities:

• Working as team lead from on Site for utility client for production support.
• Daily effort tracking
• Co-ordinate and manage offshore team, review their deliverables and ensure all deliverables are delivered on time and with good quality
• Gathered business requirements and deliverables along with functional analysis together with SAP ECC.
• Interactions with Application Team owners to understand their data requirements
• Conducting Business fit analysis on data requirements before finalizing the data modeling.
• Suggest and Perform enhancements to improve batch performance.
• Automated some weekly activities which are value adds to client
• Managing enhancement.
• Handling all support activity for SAP Confidential on HANA system.
• Responsible for all types of SLA’s
• Creation of Generic Custom datasources and Enhancements of Standard datasources to satisfy reporting requirements where standard content does not satisfy Business reporting needs
• Development projects of Business object reports, Crystal Reports
• Created graphical calculation view in SAP HANA for sales tax report.
• Upgraded the SAP Confidential system from 7.3 to 7.5 versions with support of Basis team. Worked on Performing Pre and Post upgraded steps.
• Upgraded the SAP Confidential system from 7.3 to 7.5 versions with support of Basis team. Worked on Performing Pre and Post upgraded steps.
• Worked on In-Memory Optimized Infocube and Data Store Object.
• Worked on Transient Provider/Virtual Provider Based on a SAP HANA Model, Operational Data Provisioning (ODP), Open ODS Views, Eclipse Composite providers and ADSOs.
• Created Reconciliation of BI reports with the ECC data in analysis office.
• Worked on authorizations and other related issues

Confidential

Offshore/Onsite Lead - Reporting and Analytics

Responsibilities:

• Interactions with Onsite counterparts to understand business requirements.
• Manage six member offshore team, review their deliverables and ensure all deliverables are delivered on time and with good quality
• Created webi report,
• Build HANA data Models to support Reporting Requirements
• Created o data services to view HANA data.
• Involved for actuate to crystal report conversion project.
• Provide accurate Status Reporting to all stakeholders
• Work-load balancing among the offshore Team members and providing them with right direction and motivation
• Involved in the activity of migrating the 3.x Datasources to 7.0 along with the standard transformation/routines.
• Worked in Data Modeling - Creating Infoobjects, Datasource, InfoPackage, DTP, Transformations, DSO and Infocubes etc.
• Involved in the activity of Process Chain creation for Master and Transaction data.
• Worked extensively on reporting. Modified the reports based on user requirement.
• Created queries using Variables, Conditions, Exceptions, Formulas, Calculated key figures.
• Worked on information broadcasting by publishing the queries.

Confidential

Onsite Lead - Reporting and Analytics

Responsibilities:

• Interactions with Business users and Client’s Confidential consultants to understand Client’s reporting requirements.
• Conducting Business fit analysis on reporting requirements before finalizing the data modeling.
• Designing and Data Modeling to achieve Business reporting requirements.
• Created Dashboard for Inventory and Procurement in SAP Visual composer for Client SUZLON Energy Limited
• Creation of APDs
• Stock in days, nonmoving Stock, Adjustment analysis, Rejection Analysis, Scrap Analysis, and Inventory turns etc reports present in Dashboard
• Created Dashboard for OMS(Operation Maintenance Services) in SAP Visual composer for Client SUZLON Energy Limited
• Creation of Generic Custom data sources and Enhancements of Standard data sources to satisfy reporting requirements where standard content does not satisfy Business reporting needs
• Created Classification data source for Functional location
• Authorization and user management
• Provide Post Go-Live Hyper Care support.

Confidential

Offshore Lead

Responsibilities:

• Co-ordinate and manage offshore team, review their deliverables and ensure all deliverables are delivered on time and with good quality
• Involved in production report work
• Handling Call stand by calls
• Fix batch Job failures
• Suggest and Perform enhancements to improve batch performance.
• Provide accurate Offshore Status Reporting to all stakeholders

Confidential

SAP Confidential Consultant offshore

Responsibilities:

• Conducting Business fit analysis on reporting requirements before finalizing the data modeling.
• Activation of Business Content for SD/MM Info cubes, info sources, Transfer Rule/Update rule transformations.
• Activation of LO-Cockpit Data Sources for SD/MM like 2LIS 13 VDITM, 2LIS 03 BF, 2LIS 03 UM.
• Enhancement of Extract Structure as per Reporting Requirements, and additional field’s addition through customer Exit.
• Job Control Scheduling for Delta Initialization and Set up Table Filling and Deletion for past data Extraction.
• Creating Process Chains and Scheduling, Monitoring data Loads.
• Query Designing and Report Designing as per reports formats Supplied for e.g. Stock Overview, ageing Reports, Sales Analysis, and Billing Data.
• Data validation as per Excel formats and Created crystals
• Supporting Functional Unit Testing and Integration testing of delivered Reports

Confidential

SAP Confidential Consultant

Responsibilities:

• Gathered business requirements and deliverables along with functional analysis together with SAP R/3.
• Modeling of ODS, Cubes and APDs for providing valid data for the trend reports.
• Creation of 30 queries, query views and workbooks.
• Creation of consolidated Web Templates with multiple queries views and graphs.
• Using BEx broadcaster, distributed the customized reports by region and exported to the Enterprise portal
• Analysis of long running loads and reports and implementing steps for performance Improvement.
• Provide Post Go-Live Hyper Care support

Industry: Oil & GAS (SAP BI Implementation in Jamnagar Export Refinery Project (JERP))

SAP Confidential Consultant

Confidential

Responsibilities:

• Discussion of reporting requirements in application areas of SD/MM data Preparation.
• Activation of LO-Cockpit Data Sources for MM.
• Enhancement of Extract Structure as per Reporting Requirements, and additional field’s addition through customer Exit.
• Query Designing and Report Designing as per reports formats Supplied.
• Data validation with R/3 data.
• Designing and Definition of Real time Cube for storing plan data, Aggregation Level, Filters, Characteristic Relationship.
• Creating Input Enabled queries/Workbooks/Web templates to enter manual plan data.
• Creating BEx Workbook for output layout, same will be published in to enterprise portal
• Creation of reports using Crystals reports, WAD and VC for Management Dashboard.
• User query resolution.

SAP Confidential Consultant

Confidential

Responsibilities:

• Created Landing Page for Portal
• Configured collaboration services
• Created virtual rooms.
• Installed Jive forum and customized like Confidential
• Created federated portal network.