SUMMARY:

• Confidential is a global SAP Native HANA/BW on HANA Solution Architect with 12 years of experience in IT projects.
• Works with multiple clients across industries to help their HANA Journey. Consulting visits to set up architecture/Guidelines/Governance/Troubleshooting/Performanceissues/memoryissues/Archival strategy/Data Tiering strategy/Data Provisioning Strategy, estimate the proposal, timeline, Budgeting, oral presentations with stake holders for projects.
• Communicates effectively with senior management, Conflict Management, IT, Business and all other functions to act as a strong advocate and steward for the business/IT/Business IT.
• Aligning Information Technology plans with strategic business objectives, including revenue growth and profitability through effective collaboration with key stakeholders.
• Responsible developing Digital Analytics vision, Strategies, Value Engineering, Roadmaps, Directions, Planning and mobilization project and hands - on with technical, functional, Business and cross industry implementation experience.
• Recommend solutions to leadership, project teams, and other stakeholders adapting style to both technical and non-technical audiences.
• Collaborate with other architects to ensure continuity of solutions.
• Hands-on, develop and contribute to application roadmaps/implementation approach & project plans.
• Determine how to leverage technology to create solutions that satisfy the business requirements.
• Recent focus on Data Tiering with respect to SAP HANA/SAP IQ, NLS Archival Strategy and Data Hub Scenarios with Big Data Capability.
• Managing a team 50+ across countries building capabilities, delivering various solutions to multiple clients.
• Part of COE team, to do PoCs, PoVs, train people on various new technologies, come up with innovative strategy to create learning mechanisms for associates, creating knowledge article, certification materials.

TECHNICAL SKILLS:

SAP Skills (Subject Matter Expert) : SAP HANA(Native HANA), SAP BW on HANA, SAP BW, NLS on SAP IQ, Data Tiering, SAP Business Objects Design Studio, SAP Analytics on Cloud, SAP BO Lumira, SAP BO Webi, SAP Data Services, SAP Power Designer, Financial Domain Expertise for Analytics, Manufacturing Doman Expertise for Analytics, SAP HANA & BW interface with Spotfire, Business Objects, Tableau, Qliksense, Oracle etc.

PROFESSIONAL EXPERIENCE:

Confidential

SAP HANA Solution Architect

Technologies: SAP Native HANA, SAP BW on HANA, BOBJ 4.2, Tableau, Spotfire, QlikView

Responsibilities:

• Collaborate with users to understand new analytics requirements and design new solutions on Hana
• Set the architecture based on the Business requirement, HANA capabilities, HANA connectivity with reporting tools, HANA interface capability with external database, HANA connectivity with remote sources, Road map of SAP for HANA etc.
• Set up the strategy for appropriate use of the reporting tools, ETL tools across HANA.
• Setting up the development guidelines, governance, where to what scenarios, best practices etc.
• Design the data model based on the Business requirement.
• Integrate the data from various sources like SAP ECC, BPC, Oracle, TIBCO CIM for Masterdata, terradata etc;.
• Envision the Business requirement and its intended KPI to solve problems and accordingly develop HANA views, Data provisioning in HANA, SQL Scrip Procedures, Work-arounds on reporting tool limitations with HANA.
• HANA Views Consumption to plug and play Reporting environment comprising of A4O, WEBi, Design Studio, Lumira, Spotfire, Tableau etc.
• Use of hybrid scenarios of mixing BW on HANA models with Native HANA Models for maximum gain of benefits.
• Optimizing the existing BW models to make it ready for BW4HANA Migration.
• Various Performance Tuning measures, trouble shoot high memory consuming issues and resolving them. Weigh in Physicalization vs run time query calculation scenarios.
• Data Tiering, Archival Strategy Setup, HANA Extension nodes VS Dynamic Tiering discussions, Data Temperature Analysis.
• Managing a team of 25+ across US, APAC, Europe locations and ensuring the deliverables of the project are on time & flawless. Skill development across
• Perform one of the biggest transformations for the Finance team to get rid of the 15 year old system by doing the following:
• Create a Data Lake/Data HUB for Finance by integrating the finance data multiple source systems like SAP, non-SAP, Master Data from TIBCO CIM, Planning from SAP BPC, FDM data etc.
• Creating a tightly integrated Finance Month end close processing, reducing the month end closing time & effort in HANA by more than 50% from the existing legacy system.
• Create metric reports like P&L, PGM reporting, Plan vs Actual variance, Legal Cost vs the Consolidated cost variance, Pricing variance, adjustment variance, FX variance, Purchase Price Variance, IQV/Discards inventory, Intercompany Profit Elimination, Production Variance, Manufacturing order variance etc.
• Handled some of the biggest tables in SAP ECC for finance like BSEG, BKPF, COEP etc.

Confidential

SAP HANA Architect

Technologies: SAP Native HANA, BOBJ Reporting, DB Migration, NLS on SAP IQ, Spotfire Reporting

Responsibilities:

• Discuss with the business to understand requirement on questionable inventory.
• Making HANA as system of record for user input on questionable inventory alterations.
• Setting up governance, audit regulations for reporting on month end reporting, security, Data availability SLA etc.
• Development of HANA views, BW ADSOs, Composite Providers & working with security team to set up security architecture.
• Envision the Business requirement and its intended KPI to solve problems and accordingly develop HANA views, Data provisioning in HANA, SQL Scrip Procedures, Work-arounds on reporting tool limitations with HANA.
• HANA Views Consumption to plug and play Reporting environment comprising of A4O, WEBi, Design Studio, Lumira, Spotfire, Tableau etc.
• Various Performance Tuning measures, trouble shoot high memory consuming issues and resolving them. Weigh in Physicalization vs run time query calculation scenarios.
• Various Performance Tuning measures, trouble shoot high memory consuming issues and resolving them. Weigh in Physicalization vs run time query calculation scenarios.
• Managed a team of 10+ members on a BW on HANA Migration & Optimization involved with BW on HANA Migration like converting Multiprovider to Composite provider, Cubes to DSOs, etc

Confidential

SAP BW on HANA Architect

Technologies: SAP BW/HANA, BOBJ Reporting, DB Migration, NLS on SAP IQ, Spotfire Reporting

Responsibilities:

• Understand the system overall based on size, Reporting usage Frequency, Data usage frequency etc.
• Set up archival strategy for the system based on Data Temperature
• Work with Business to confirm the archival strategy based on data and report usage.
• Reduce the Data foot print in the System and make it ready for BW on HANA migration by archiving the data on NLS on SAP IQ, System table archival into File system.
• Migrate the BW on HANA system doing the pre migration & post migration activities, preparation of cookbook, Performance base lining.
• Adhering to new LSA++ strategy, reduction to cubes, conversion to composite providers etc.
• Managed a team of 10+ members on Archival Analysis, Strategy, Set up, implementation & handover.

Confidential

SAP BW Solution Architect

Technologies: SAP BW/HANA, BOBJ Reporting, Spotfire Reporting

Responsibilities:

• Responsible for delivering various projects like Optimized Product availability, Lead time analytics, Delivery Performance metric for manufacturing division
• Data integration into BW from APO, SAP ECC, Oracle, TIBCO CIM master data etc.
• Integration of BW with different reporting tools like Cognos, Spotfire, Business objects etc.
• Development of BW objects like Infoobjects, Cubes, DSOs, Multi providers, BEx queries, open Hubs, APDs etc.
• Responsible for delivering projects like Month end close and consolidation for Finance
• Data integration into BW from APO, SAP ECC, Oracle, TIBCO CIM master data etc.
• Integration of BW with different reporting tools like Cognos, Spotfire, Business objects etc.
• Development of BW objects like Infoobjects, Cubes, DSOs, Multi providers, BEx queries, open Hubs, APDs etc.
• Worked on end to end requirement gathering, development to UAT support to GO live on Design Studio dashboards and WEBi.
• Was responsible for building and integrating security between BW & Business Objects inheriting the roles from SAP BW system to Business Objects and also setting up folder level security, activity level setting
• Setting up governance for BW accelerator.
• Managed a team of 20+ members on Delivering Delivery performance like Perfect Order Reporting, Optimized Product Availability Dashboard including Days of Coverage of Inventory, Forecast Accuracy, Product Lead Time Analysis etc.

Confidential

SAP BW/BI/HANA Solution Architect

Technologies: SAP BW, SAP Business Objects

Responsibilities:

• Responsible for delivering various projects
• Interact with the users and help them in preparing Functional Specifications and identify the reporting requirements.
• Design blue print for BW data modeling and create Technical Specifications based on the Functional Specs.
• Data integration into BW from APO, SAP ECC, SAP CRM, Vistex etc.
• Integration of BW with different reporting tools like Cognos, Business objects, SAP BEX, SAP WAD etc.
• Development of BW objects like Infoobjects, Cubes, DSOs, Multi providers, BEx queries, open Hubs, APDs etc.
• Performance redesigns like Physical partitioning region wise etc.
• Integration of BW with different reporting tools Business objects etc.
• Setting up governance for BW accelerator.

Confidential

SAP BW Support Consultant

Technologies: SAP BW

Responsibilities:

• Responsible for resolving all support issues like Data load Monitoring, Fix bugs in Business logic, Abap logic, transformation logic, Additional enhancements like reporting & transformation enhancement etc.

Confidential

Responsibilities:

• Involved in Data modeling for the Inventory and Sales reports in SAP BW.
• Data extraction from SAP R/3 into SAP BW system through LO-Cockpit and Generic Extraction techniques.
• Worked on Data Sources 2LIS 03 BX, 2LIS 03 BF, 2LIS 03 UM, 2LIS 02 HDR, 2LIS 02 ITM.
• Performed detailed analysis to improve the performance of Cubes using BW Statistics and Aggregates.
• Developed Reports and Workbooks based on the custom Info Cubes and ODS objects.
• Solved tickets for the end users by giving post production support.