PROFESSIONAL SUMMARY:

• Overall 10+ years of technical expertise mainly focused in end - to-end design, development and implementation of SAP HANA, SLT and BW solutions. I have led various teams to develop best-in-class technology applications and successfully implemented appropriate solutions for clients across multiple industries.
• Extensive knowledge of end to end application development using SAP HANA. Design and development of reliable, flexible, scalable and responsive BI solutions, which are aligned with the global delivery strategy.
• Closely working with various levels of management, BI stakeholders, Business Relationship managers, Business Analysts and Key users to identify and document reporting requirements.
• Business knowledge in Supply chain, General Ledger, Account Receivables and Accounts payable.
• Assisting the Global BI Delivery Lead in the development of the report design and development procedures.
• Excellent experience in building Analytics Data Warehousing platform using SAP HANA Platform and SAP BW on HANA with SAP Data Services and SLT.
• Worked in BW 7.5 on HANA migration and HANA models using ADSO, composite provider, Calculation View, Analytical view, Attribute view, CDS view, Hana Stored procedure, XSJS, XS OData Services.
• Worked with BI Architect, SAP Technical Architect, BI team and other functional teams on solution designs, business warehouse strategy and end-to-end testing.
• Played key role in implementing complete life cycle of the HANA Project for the Client which includes right from analysis, design specification, development, performance tuning, documentation, maintenance, trouble-shooting.
• Worked extensively in SAP Native HANA side car scenario for the following domains ( OTC - Account Receivable, Contracts and Sales Orders & Billing; PTD - Material Master, Deliveries & Demand Planning; PTP - Vendor Master, Accounts Payable & Purchase Order; RTR - General Ledger, Cost Center Accounting & Profitability ).
• Worked extensively in Non SAP Source systems to extract data from OTO - CPQ & Oracle Leasing (OLFM). Involved in complete phase of testing (Unit testing, User acceptance testing, Data validation testing) between ECC, other third party systems and HANA. Involved in Disaster Recovery test during Go-Live phase and worked in HANA Live.
• Have good knowledge in SLT for as setting up the source and target configurations, monitoring the data load and analyzing issues in SLT.
• Extensively worked in support model which includes pre-go live, Post-go live, managing large offshore & onsite team, providing best solutions to client, tracking tickets, change request, service request and enhancements.
• Extensively worked on Cognos 10.2 BI (Report Studio, Query Studio, Framework Manager, Cognos Connection).
• Experience in developing complex reports (List, Cross Tab, Chart, Singleton Repeater, Active Reports) using drill-through, prompts, master-detail, burst options, dynamic filtering.
• Extensively worked on Tableau 7.1 and created visualizations dashboards using Tableau Desktop and Server using multiple data sources.
• Worked as BW team lead & project lead and responsibilities include managing BW team, product deliverables, conducting meetings, finding out solution for complex issues, reviewing the project scope, communicating management and team members about project accomplishments and deadlines and reviewing status reports.
• Extensive knowledge in design and development of Info cubes, Multiprovider, DSO/ODS, Infoset, datasource, Info Objects, transformation, Open Hub, extractor configuration and data loading, information broadcasting and Process chain.
• Excellent expertise in BW data archival process to clean up the unused confidential data.
• Worked in extracting data from R/3 using BW content extractors, Custom Generated extractors and Generic Extractors. Experience in performance tuning using Aggregates, Rollup, Compression and Partitioning.
• Expertise in report generation-worked on BEX-Query Designer and Analyzer in building Queries using Conditions, Exceptions, Calculated key figure, restricted key figures, Filters and Variables.
• Conducted BW & HANA training for onsite/offshore resources.

TECHNICAL SKILLS:

Data warehousing: SAP BW 7.5, 7.3,7.1,3.5, SAP HANA Studio

ERP: SAP R/3 ECC 6.0, 4.7

ETL Tools: SAP Landscape Transformation (SLT), SAP BO Data Services (BODS) 

Reporting Tools: SAP Bex Reporting, BOC, Cognos 10.2, Tableau 7.1, SAP PA, MS BI

SAP Functional Area: SAP FICO, SD, MM, HR, SCM

Programming: SQL, PL/SQL, Oracle, ABAP

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Tools: SAP HANA, BW, SLT, ECC, Tableau

Sr. SAP HANA, BW & Tableau Architect

Responsibilities:

• Worked in end to end implementation of Inventory Projection (Supply Chain) dashboards using HANA models having BW as a source.
• Worked extensively in BW on HANA model performance tuning and created optimized HANA artifacts. Created complex Tableau dashboard for supply chain models.
• Involved in end to end implementation of Quality Management includes replicating data source in ECC, developing BW models like info object, DSO, Cube, HANA models and Tableau Dashboard.
• Involved in SAP Predictive analytics 3.0 development having HANA as a source.
• Involved in creating analytical privileges and have a good understanding of various components of SAP HANA.
• Creating Information Models (Calculation Views, Analytical views, Attribute views) as per the business requirements with functional areas of FI and Supply Chain.
• Excellent knowledge on Advanced DSO, Open ODS view, Transient provider, HANA live, HANA database artifact, HANA XS, Procedure, Hana Optimized DSO’s, Composite, Hybrid Providers, and Import SAP Net Weaver BW Model to HANA.
• Expertise in OLTP extractions from SAP ECC using LO Cockpit, Generic Extractions, Enhancement of Datasource using User Exits as per the business requirements. 
• Extensively worked on Start Routines, End Routines and Expert Routines at different levels of Transformations to implement business logic. 
• Hands-on in configuring the SLT and extracted data from SAP and Non SAP systems.
• Very good in writing Procedures, CDS view, stored procedure, XSJS, XS odata services, functions using the SQL Script and used them in Calculation view.

Confidential, California

Tools: SAP BW, ECC, Bex

Sr. SAP HANA & BW Lead

Responsibilities:

• Involved in information gather phase
• Created Users, Roles, Privileges, Packages, Schemas as part of HANA Security and Development.
• Designed and implemented SAP HANA data modeling using Attribute View, Analytic View, and Calculation View.
• Developed complex SQL scripts in Calculation views.
• Executed Data Extraction Transfer Loading (ETL) using SAP Data Services 4.0 to import csv files into SAP HANA tables.
• Reporting, Accessing Analytical and Calculation views from EXCEL.
• Leading the architecture, development, and data content of the SAP BW environment.
• Managing the BW development team members and accountable for all technical deliverable, support and change request streams for BW.
• Design, configure, and implement SAP's Business Warehouse solutions and Monitoring & review BW technical designs.
• Responsible for managing and implementing BI system upgrades. Responsible for system performance including the use of BIA and future use of HANA.
• Hand on experience in FICO - AP, AR, 0EC PCA 3 data sources and extracted the data in to BW.
• Monitoring Data load activities and recovered failures in Dev, Quality system as a part of unit testing and preparing the process documents for each and every enhancement.
• Involving in solving high-prioritized tickets regarding extractions, performance issues and data load failures.
• Worked on process chains to automate the Deleting indexes in Info cubes, Process of info packages, creating indexes, ODS activation, further updating, PSA request deletion and Attribute change run so on. Using open hub to export data from BI to External systems.
• Monitoring the daily loads to various data targets in the system and the process chains on the basis of daily, weekly& monthly.
• Manual loading and rolling up the data into data targets and maintaining the logs for each manual load.
• Creating aggregates to improve the query response and Performance tuning of queries using aggregates, indexing of Info cubes.

Confidential, Connecticut

Tools: SAP HANA Studio, SAP BW, SAP SLT, SAP BODS, Cognos, Tableau

Sr. SAP HANA & BW Lead

Responsibilities:

• Involved in information gathering phase and reviewed Functional and Technical Specifications & validated the HANA models across domains.
• Created Attribute view, Analytical view, calculation view, variables, Input parameters.
• Involved in complete phase of testing (Unit testing, User acceptance testing, Data validation testing).
• Involved in performance testing of the HANA models as well as Disaster recovery testing.
• During the SIT4 testing, interacted with customers to understand the business processes and help them to complete the HANA model script testing.
• Responsible to answer for all customer doubts related to BW and HANA feasibility analysis.
• Responsible for GL, AR, AP and GR/IR domain reconciliation issue.
• Responsible for managing on-shore/ off-shore team for issues and status updates.
•  Created technical design documents based on the existing BW system and transferred technical knowledge specific to HANA data model.
• Responsible for comparing BW models with created HANA views and finding the gaps between two systems.
• Created lots of Account Receivable reports such as AR Summary, AR Details, AR Aging and GL reports.
• Involved in HR BW data archival process to clean up the unused confidential data. Created the ADK DAP process in BW and archived (150 GB) data into Unix server using ‘SARA’ transaction.
• Created SLT configuration, replicated SAP ECC tables to HANA and monitoring the job loads.
• Worked in SAP BODS (Project, Job, Data Flows, Work Flows, Data Store, Query Transform, Date Generation, Table Comparison etc...) and extracted data from third part systems like SFDC, OLFM, CPQ.
• Interacting with the Business Users, Suppliers teams for understanding the process flow and new business requirements or enhancement activities.
• On daily basis, updating the Borland scripts and Remedy status for all testing and development activities.

Confidential

Tools: SAP BW, ECC, Bex

Sr. SAP BW Developer

Responsibilities:

• Designing the data solution to satisfy defined business requirements.
• Identifying the data in the source environment and Mapping the data to the BW environment.
• Identifying data quality gaps and developing a plan to close data quality gaps.
• Testing of all developed programs and ensuring integration testing of data from various sources.
• Worked on Extraction of data from SAP source systems using LO Cockpit Extraction, Generic Extractions and including installation of Business Content. Involved in migration of Inventory, Purchasing data model from BW3.5 to BI7.0.
• Work experience on performance tuning using Aggregates, Rollup, Compression, and Partitioning.
• Worked in open hub to load the data to third party tool and infospoke. Designing Info Objects, PSA, Data Sources, MultiProviders, Infosets, ODS/DSO, Info Cubes, Info Packages, Transformations, DTP (for both ODS and Info cube) and Extracting master data and transactional data from flat files and SAP R/3 & ECC.
• Designing the Bex report on BEX-Query Designer and Analyzer in building Queries as per the business requirement. Created custom queries to compare and show sales according to region and cost center for the company products.
• Created reports to evaluate open items by due date for accounts receivable through BEx analyzer. Developed reports using query designer, BEx analyzer.

Confidential

Tools: SAP BW, BEx, ECC

SAP BW Solution Architect

Responsibilities:

• Responsible for development, support, maintenance and implementation of a complex project module. Worked on problems of complex scope, through extensive usage of standard concepts & principles.
• Worked as a fully contributing team member, under broad guidance with independent planning & execution responsibilities.
• Applied own judgments to independently determine course of action, which is then executed independently post review.
• Responsible for coaching, guiding and mentoring junior members in the team to help them scale up faster. Monitoring data loads of Daily, Weekly, Monthly Process Chains and Involved in monitoring Production systems.
• Worked on high, medium and low priority tickets and Actively Involved in Rectification of Load Failure errors like Master Data Loads, Transaction Loads.
• Monitoring of info packages and analyzing the reasons for frequent failures of Infopackages.
• Schedule data loads into BW from R/3 involving full, initial, delta loads and creating the Aggregates against the Cubes to improve the query response time.
• Modifying the reports as per the user requirements and enhanced Data Source as per the business requirement.
• Involved in Performance tuning of InfoCubes, Reporting and data loading. Updated status of tickets and process chains in weekly meeting. Used Information Broad Casting and set the BEx reports on pre calculation. Distributed the Workbooks and Web Reports to the users using Broadcasting.
• Actively involved in training end users and preparing end user material. Solved many Data reconciliation tickets and maintained work history for all the tickets until it has closed down.

Confidential

Tools: SAP BW, BEx, ECC

SAP BW Developer

Responsibilities:

• Analyzed data requirements and translated these requirements into dimensional data models for FI/CO using star-schema and extended star-schema data modeling techniques.
• Responsible for data modeling of the Sales and Distribution Module, and Master data (Customer and Material Master), for the SAP Business Information Warehouse (BW).
• Gathered data by consulting with the functional specs and decided to implement custom made InfoCubes to cater their requirements.
• Worked extensively with Administrative Work Bench (AWB).
• Extensively worked on Creating Info Objects, Info Cubes, Data Store Objects, info packages, Multi providers.
• Created Transformations and DTP’s on different Data Sources and DSO’s. Designed and developed process chains (RSPC) for master data loads and transaction data loads with the help of DTP and these Process chains are scheduled for periodic loads.
• Extracted data in various Data Targets depending on the user requirements like DSO, Infocube.
• Activating the business content, replicating data source, and mapping, creating Info cubes, DSO, update rules, and Transfer rules.
• Worked on remodeling such as adding the new filed in existing cube.
• Installed standard Business content as per the requirement.
• Data extraction from SAP R/3 system and Flat file. Created Generic data extraction using Views and Tables. Enhanced Data Source as per the business requirement.
• Worked on process chains to automate loadings in background.
• Involved in Creation of reports using BEX-Analyzer, used free characteristics, Restricted key figures, Calculated key figures, Variables, Exceptions, Text Variables and filters.