SUMMARY:

• 17 years IT experience and over 12 years in business analytics with certifions in HANA, BW and Financial Markets in Finance, Sales, Royalty, supply chain domains using HANA, HANA Live, Business objects, Tableau and Design Studio .
• Architected data models for Supply chain, Finance, Sales metrics using HANA and BO.
• Developed Royalty Report, P&L report, planning reports on HANA models on Design studio.
• Created dashboards for multiple source data including OTC, PM, MM, FI for perfect orders, product mix and various other KPIs on HANA and Design Studio .
• Created VCPA product on HANA, BW, BO for Retail, Hi - tech and FMCG KPIs using complete dash board solution for operational and strategical reports .
• Responsible for data model design, high level architecture and solutioning.
• Created Attribute views, analytical views, scripted calculation views, graphical calculation views, decision tables, procedures, hierarchies, HANA Administration including managing schemas, data model objects, security, roles, users, import/export and CTS ++ content.
• Provided Scope Analysis, effort estimation for native HANA projects.
• Performed Gap Analysis, requirement gathering for DSS projects and effort estimation for various BW/HANA/BO Projects.
• HANA Modeling of Attribute Views, Analytic Views, Calculation Views, Procedures, Decision Tables, Package & Schemas and Analytic Privileges.
• Extensively worked in HANA Data provisioning activities to provision the data from SAP & Non-SAP source systems using BODS ETL Based & SLT replication, SDA (Smart Data Access) for remotely accessing Oracle database and DXC for Business content extractors.
• Extensively worked on SQL performance tuning for optimized query execution times.
• Worked on HANA XS Project by creating native HANA Developments, Using JavaScript for client- side validations and server scripts for implementing Business logic.
• Implemented BW projects including Business Blueprinting, Design, Development, Unit Testing, Integration Testing, Training Documentation and end user training.
• Provided solutions for blended Scenarios reporting for BW on HANA Implementation projects.
• Experience in ABAP customizations for SAP BW Standard datasource enhancements, Function module based Generic Datasource developments for complex data extractions.
• Published Blogs in SDN for SAP BI/BO Integration.

TECHNICAL SKILLS:

SAP HANA, SAP BW, SAP BO, SAP SD, MM, FI and COPA

PROFESSIONAL EXPERIENCE:

Confidential

HANA/BW/BO Architect

• Created HANA BPC Corp Units Models to forecast demand using various dimensions by various planning processes.
• Worked with Gaming, Major Pharma, Bio-Technology and Automation clients on business requirements from top level management for different product matrix and creating data flows and reports for Customer Participation reports, Employee Compliance Reports and
• SQL optimization using plan-viz, join optimizers, input parameters, filters for faster query execution times.
• Employee compliance and Customer participation report execution times improved significantly using SQL optimization.
• Architected complex Customer Participation Report by integrating Participation, billing, AR, COPA data to display customer payments, customer reported amount and company reported amount by brand with identification of differences in both HANA models with WebI reports.
• Modeled HANA attribute views for customer, organization, product, analytical views for sales, participation data and calculation views for COPA, AR, using joins and star joins for master data and multiple fact tables.
• Unit Count Reports based on number units available by region, brand, theme and period based on customer hierarchy.
• Employee compliance HANA Models and reports with exceptional time entries and drill down reports for detailed analysis. Reports. These are complex models exclusively used using procedures and HANA calculation views and validate for time entries to identify time lines.
• Created HANA Live models and activated HANA content for Finance, Billing data and master data Private views, Reuse views and Query views.
• Delivered Accounts receivables and COPA model in SAP HANA for AR Details report, GDW report, Variance report and Average Selling price with costs and revenues per material using HANA Live Content.
• Worked on Accounts Receivables HANA model. Created model from finanace new GL tables and joined billing data and currencies. Base data was joined with master data.
• Created virtual data stores on HANA models from various non-sap systems.
• Created Aging buckets logic for different due dates calculation.
• Worked on GL report for period Cost and variance reporting.
• Resolved Index issues and partitioning issues.
• Changed SQL System parameter settings to optimize performance.
• Select statements with optimized values for dates and other statements are used.
• Identification of source tables in ECC, CRM, SCM and other legacy systems to map the relationships for various tables. Created catalogs, Schemas, tables and views in HANA system.
• Maintained security administration for providing SYS BI, SYS BIC and SYS REPO authorization.

Confidential

HANA Architect

Responsibilities:

• User Requirement analysis and Implemented Royalty Subscription analytics report which saves huge money to the company by avoiding duplicate/incorrect royalty payments.
• Modeling and development of objects for Royalty Analytics using Native HANA Attribute views, Analytical Views and Calculation views.
• Created statistics and enabling SQL trace to identify execution times and identify issues related to joins and cardinalities.
• Maintained SQL privileges and debugging SQL scripts to ensure models are optimized.
• Passing parameters and filtering data by using Parameters in SQL scripts to limit data.
• Moved calculations to HANA DB engine and created SQL Script and CE Functions for checking the Royalty orders.
• Performance optimized SQL scripts execution times reduced drastically.
• Resolved Index issues and partitioning issues.
• Created sql scripts and procedures for complex logic including encryption and decryption and unifying data.
• Extracted data from Hadoop Hive to BODS and subsequently to HANA system.
• Experienced on Data Extraction Transfer Loading (ETL) using SAP BOBJ Data Services.
• Provided Scope Analysis, effort estimation for native HANA projects.
• Created Snapshot table and get the transformed data from various tables for encrypted, decrypted data, sales and finance data using procedures.
• Handled Transport activities across DEV, QA & PROD Environments using Perforce to track changes and to perform change management activities.
• Involved in Data services replication and creation of jobs for the Enterprise reporting.
• Reviewed Technical Design specifications and created required documentation.

Confidential

Solution Architect

Responsibilities:

• Created HANA/BO Dashboards with Design Studio using Variables and Input Parameters with different charts and containers for pixel perfect formatting and used standard templates for visualization.
• Created Functional Specification, Technical Design specifications and corrected existing flaws in the system. Identified gaps in the system and re-engineered the process and design to stabilize the HANA System.
• Created HANA Models for Sales overview reports using data from VBAK, VBAP, BSAK, BSAD, KNA1, MARA, TCUR* and various tables and checked the dependency while creating complex Calculation views using graphical models.
• Experienced on Data Extraction Transfer Loading (ETL) using BOBJ Data Services.
• Provided Scope Analysis, effort estimation for native HANA projects.
• Optimized the Design of the data flows in BW, HANA for the requirements.
• Data provisioning to replicate data from ECC and non- SAP systems to HANA system through BODS, DXC and SLT.
• Created SQL Script and CE Functions for the Native HANA Transformation.
• Implemented Procure to Pay backend & frontend implementation in HANA/BW/BO area.
• User Requirement analysis and development for COPA and FIGL reports and created LSA ++ dataflow. Analyzed the requirements and identified the gaps.
• Handled Transport activities across DEV, QA & PROD Environments.
• Involved in the requirement gathering for Data warehouse Environment for FI and CO applications.
• Created Delivery Analysis Planning Models using BPC planning flow and reduced user effort of performing lots of manual processes and created reports for customer based actual and forecast value comparison in comparing and retrieving information for Revenue, Cost and P&L values.
• Developed BO WebI reports for complex requirements using BW 7.3 Infoproviders including Transient Infoprovider, Virtual Master Data InfoObjects, Composite Providers and Multiproviders.

Confidential

SAP BW-HANA Architect

Responsibilities:

• Created SCOR & RDS KPI Solutions for Value chain Accelerators using HANA models with the Design studio for dash boards.
• Deployment of reports and dashboards for sales and Purchasing areas.
• Data provisioning to replicate data from ECC and non- SAP systems to HANA system through BODS, DXC and SLT.
• Involved in HANA Modeling Activities for specific report requirement to achieve the real time reporting for high volume data.
• Developed HANA objects Attribute Views, Analytic Views and Calculation Views to implement the real time data reporting directly from ECC through HANA system.
• Scheduled Batch jobs in BODS.
• Involved in importing of BW Models into HANA for specific report requirements.
• Created SAP BO WEBI, Crystal reports and Desgin studio . Created WebI reports on Gross to Net Sales reports, Direct-Indirect Sales report and Contract Sales Report.
• Extracted data from Vistex Data Sources and created reports on bill back/chargebacks. Involved in Transportation repackaging activities to transport the objects in cross environments and Lifecycle Manager Transport activities for BOBJ objects.
• Rapid-deployment solution implementation including functional testing.
• Created HANA models with SCOR and Supply chain operational dashboards.
• SME discussions to demonstrate pre-sales capabilities, providing proof points of knowledge and its execution.
• Developed BW Objects InfoObjects, DSO, InfoCube, Multiprovider, Transformation, DTP, OHD, APD, Datasource and Infopackages.
• Created BW Transformation logic implementation through ABAP routines. Solution design for the SAP BW Implementation flows.
• Enhanced BW objects and worked on BW releases and involved in Performance & Tuning activities. Identified performance improvement areas for Flexibility, Maintenance of the BI.

Confidential

SAP Solution Architect

Responsibilities:

• Created Delivery Analysis Planning Models using SEM planning flow and reduced user effort of performing lots of manual processes and created reports for customer based actual and forecast value comparison in comparing and retrieving information for Revenue, Cost and P&L values.
• Involved in SEM activities including SEM Full batch, Commit & Close Superrec. Created SEM Delivery Analysis report with planning functionality in SEM which reduces manual effort for planning and copying data from Revenue and P&L cubes. Creating Planning Model which includes planning folder, planning layout, Multi planning area, planning level, planning package and planning functions including standard and SEM- FOX formulae. Created CPF Extractor flow to reduce extraction time for cost extractors for planning functions. Performed Transport activities and other maintenance activities. Worked with Security team on roles and authorization objects to provide relevant access for SEM delivery.
• Retrieved missing records from ECC to BI for different areas like Sales, purchase, Plant maintenance and other areas. Involved in KT sharing sessions and performed admin activities including transport activities, collected transport objects and BEx objects.
• Involved in coordinating with functional team and created business blue print and data flow diagrams, business team in development of the BPC functional specs.
• Designed functional specification and technical specifications as per the business requirement.
• Involved in creation of Unit test script templates and executed of those scripts and ensured there are no gaps between functional and technical aspects.
• During the testing phases took up more responsibilities in all the activities related to defects resolution and coordinating with the BPC development team and focusing on solution and working towards the closure of the defects.
• Involved in automation of data load activities in the backend using process chains.
• Involved in SAP BO reporting to generate Actual Vs Plan data comparison reporting.

Confidential

SAP BW-BOBJ Consultant/Architect

Responsibilities:

• Involved in development of SAP Solution for Supply chain & functional requirements for Value chain performance accelerator solution.Created KPIs for Monitoring Cockpit, Analysis paths and analysis rooms using Xcelsius dashboards for a complete solution for supply chain.
• Involved in managing team to take care of the daily deliverables of BW & BOBJ Implementation.
• Responsible for coordinating with End users to gather the requirements and close the gaps.
• Identified the BW BEx reports & Infoproviders to build SAP BO reports.
• Extensively coordinated with the Security teams to design & implement Analysis Authorization for various Reports. Client Liaison & Documentation, Internal and External presentations.
• Design & Development of Workbooks and publishing them as per Business Roles
• Responsible for smooth transition of project from Implementation to Production support team.
• Involved in End user training for BW BEx & BO Queries.

Confidential

SAP BI Consultant

Responsibilities:

• Involved in requirements gathering workshops.
• Experience in writing Function Specifications. Involved in identifying gaps & installed the necessary Standard BI content as per the requirement.
• Created complete flow of overhead reports in Controlling area for Unit cost, CIR reports and Reinstatement Reports using generic extractors ZBW IS *and standard extractors 0CO OM OPA 6 and 2LIS 18 I3OPER used WAD for formatted Web reports .
• Involved in configuring and creation of DataSources to extract data from various Flat Files and SAP R/3 system. Extracted data from ECC to extract LO-MM data to the BW components. Extracted data from SAP R/3 LO, MM modules into BW and created necessary objects in BW for data staging, transfer, transformation and analysis. Material movements reports using data sources 2LIS 03 BF and 2LIS 03 UM for Goods movements by storage location.
• Extensively worked in Datasource enhancements to extract the data from various tables.

Confidential

Senior SAP BI Developer

Responsibilities:

• Involved in requirements analysis & functional spec review. Involved in Technical specs derivation for backend(Modeling) & frontend (BEx Queries)
• Exclusively involved in BEx Reports like Analysis Reports and Operational Reports.
• Coordinated with the business users to fix the gaps in the developments. Involved in BI Content installation. Extensively worked on Unit Testing to writing test Scenarios.
• Extensively involved in creation of BEx reports using RKF, CKF, Selection, and Formula variables.

Confidential

SAP BI Consultant

Responsibilities:

• Extensively in Transformation routines (Start/Field level/End routines) using SAP ABAP programming to in corporate business logics.
• Generated reports using BEx with exceptions, conditional formatting RKF, CKF Currency translation keys and RRI (Query Jump Targets) as per the requirements of the query.
• Involved in Business Objects WEBI, Crystal, and Dashboard reporting on BW BEx Queries.
• Experience in the Modeling of different components in BW like InfoObject, DSO, Infocubes, Multiproviders, Transformations & DTP, Datasource, and Infopackage.
• Developed flexible queries using filters, Navigational attributes in BEx Query Designer to facilitate data analysis in a drilldown Way to give detailed level of information.
• Worked out logical and physical data models in BW, definition of key figures and characteristics, InfoCubes, multiplanning areas in BPS and IP and created Aggregations, Filters and Manual planning, Uploaded data into Transactional cubes for Plan, Budget and commitments and Implemented BW ADMIN Cockpit Portal successfully.
• Scheduled & Monitored data loads into BW from R/3 for Delta initialization and Delta load.

Confidential

SAP BW Consultant

Responsibilities:

• Involved in business preparation, estimation of effort, requirement gatherings and user discussions and workshops. Generated BW Reports using queries and workbooks for Exception reports, Condition reports to pinpoint the bottlenecks of the organization.
• Mapped existing reports to the BW generic reports. Created authorizations and roles to users.
• Implemented Planning functions for BPS and Retraction of data to source system.
• Used FoX (Formula Extensions) for BPS Planning functions. ABAP Function modules and routines debugging programs. Worked on Performance tuning and evaluated statistical performance and suggested recommendations to basis support for optimization.
• Enhanced Business Content as per the user requirements.
• Worked on PCA, CCA and GL Accounts. Involved in the month beginning data loads to extract CO-PA and FI-SL data and Job Monitoring, Process Chains and Enhancements.

Confidential

Consultant

Responsibilities:

Participated as a team member in Blue print stage for discussion with Business Analyst and end user in Data Modeling, Business content, granularity and performance tuning. Involved in Go -Live Support.Created Generic Data Extractors and DataSources for Transaction & Master Data for FI reports. Worked on Business Objects (BO) Reporting and Crystal reports and created complex Reports. Facilitated workshops/ interviews and discussions with users for requirement gathering as well provided user training.

Confidential

Consultant

Responsibilities:

Administration activities for SAP system loads and Production Support includes the Job Monitoring and resolving issues. Prepared KPI, KCI reports and dash boards. Worked with transition team to better understand the business process. Worked with the users to understand and implement the solutions and map the requirements.

Confidential

Software Engineer

Responsibilities:

Worked on Job desire web portal including creating Admin page and provided access for different users and administrator’s different access. Involved in Database design and normalization of Oracle tables and designed Database tables and coding of Admin Module.