SUMMARY

• 5 years as a SAP Consultant within various modules working on POC's, and real time reporting giving businesses a competitive advantage. This experience included full life cycle Implementation and production bug fixes in various domains such as retail, healthcare, and manufacturing.
• Extensively worked in the areas of Sales and Distribution (SD), Finance (FI) and Controlling (CO), HR, PP, Materials Management (MM), Inventory Management (IM) and have in - depth business process knowledge.
• Adherence to IT/SAP project methodologies, and change control processes.
• Familiarity and comfort in working with a variety of support models with onsite & offshore resources
• Willingness to work off business hours and weekends as required for production support when issues arise
• Proven experience completing assigned tasks on multiple projects with tight deadlines successfully
• Strong analytical and problem-solving skills able to identify flexible and forward-thinking IT solutions
• Excellent written and oral communications - ability to communicate to all levels of an organization
• Strong understanding of IT project management SDLC processes and methodologies, such as Waterfall, Agile Scrum and associated best practices
• Expert level exposure to In-Memory Computing, Structure of SAP HANA studio, Configure Perspectives & Create Package, Enterprise HANA and BW on HANA.
• Solid understanding of SAP HANA Architecture, different deployment and integration options.
• Strong experience in Native HANA Modeling, Performance Tuning.
• Strong experience in SQL, stored procedures.
• Exposure to CDS Views.
• Knowledge in different ETL tools like SLT, BODS, SDA and SDI.
• Knowledge in different Reporting tools like Tableau, Web Intelligence and Lumira etc.
• Proven experience in HANA system architecture design, Implementation, Integration & Testing and post production support.
• Proven track record of interaction with client executives.
• Proven track record of collaborating with offshore team and leading them in reaching the Sprint goals.
• Used ServiceNow and Jira for tracking.

TECHNICAL SKILLS

ERP Packages: SAP ECC 6, SAP ECC 5, SAP ECC 4.7

Expertise: Programming, problem solving, Design patterns, Research and development, Mentoring/Training, Testing

SAP Technical: BI BW,BOBJ,BODS, HANA, ABAP, SAP BW/ 4 HANA: SAP HANA Design Studio, SQL Script, CE Functions, PL/SQL

Reporting tools: Micro Strategy, Tableau, Webi

Methodologies: SDLC, Agile, Waterfall

SAP Modules: SD,MM,IM,PP,PS,HR,FICO(GL,AR,AP,AA,CCA,PCA,COPA),sales to order / order to cash

Database: HANA 1.x, Oracle 11g/10g/9i/8i/8.0, MS SQL Server 2000/7.0, MS Access,DB2,Teradata,Oracle,Hadoop

Networking tools: Service now, Jira, Share point, Devops, RICEF,BMC Remedy

MS Office: MS Outlook, MS PowerPoint, and MS Excel

PROFESSIONAL EXPERIENCE

Confidential

SAP BI/HANA Consultant

Environment: SAP HANA 2.3, SAP XS engine, Informatics, SAP data services(BOBJ and BODS), BMC Remedy, JDE- Oracle, HADOOP,DB2,Teradata, ODATA services, OKTA, SharePoint, Lumira 2.3, Power BI

Responsibilities:

• Leading enhancements and supporting activities through out SDLC. Sole responsible on enhancement deliverable.
• Participating in business sessions to analyze requirements, issues, document and prepare technical design and specs accordingly.
• Worked on both Load performance tuning and Report performance tuning by creating DB Statistics, Aggregation, OLAP Cache, Compression, Indexes and Partitioning
• Used WEBI to connect with the SAP HANA Database, in designing new Reports for bringing summarized view of large volumes of data.
• Working on SAP HANA modelling (creating information models, packages and calculation views)
• Creating procedures and script based calculation views using HANA programming languages like SQL Script, CE functions or native SQL
• Replicating data from S4HANA / Non SAP sources to SAP HANA using SAP BODS and flat files. Upstream and downstream using OData services
• Build Custom data models to fill in the requirements. Transported HANA content from development, testing environment to Production environment using delivery units.
• Provide fixes to eliminate the root cause of failures for both support and development model projects
• Analyze requirements, evaluate alternate designs and propose solutions in a SAP BO and HANA reporting environment.
• Facilitate and coordinate discussions and to manage expectations of multiple stakeholders.
• Work in an onsite-offshore model involving daily interactions with offshore teams to ensure on-time quality deliverables

Confidential

SAP HANA Modeler

Environment: SAP HANA 2.3, SPS 03, SAP XS engine, Informatics, SAP data services, BODS, SLT, Service now, JDE- Oracle, Netezza, SharePoint, S4HANA, JIRA.

Responsibilities:

• Redesigned HANA Attributes Vies, and HANA Analytical Views for Sales Stats Extractor Loads and called them using the Open ODS (Using Database Tables/ Views) in SAP HANA Studio.
• Worked on both Load performance tuning and Report performance tuning by creating DB Statistics, Aggregation, OLAP Cache, Compression, Indexes and Partitioning
• Used WEBI to connect with the SAP HANA Database, in designing new Reports for bringing summarized view of large volumes of data.
• Working on SAP HANA modelling (creating information models, packages and calculation views)
• Creating procedures and script based calculation views using HANA programming languages like SQL Script, CE functions or native SQL
• Replicating data from S4HANA / Non SAP sources to SAP HANA using SAP Landscape Transformation (SLT) & SAP BODS
• Build Custom data models to enable Finance/OTC reporting.
• Working on Time Dimensions, performance tuning and troubleshooting HAA views
• Transported HANA content from development, testing environment to Production environment using delivery units. HANA XS and O Data Services.
• Prepare Design document and test cases for HANA models
• Participating in business sessions to analyze requirements, issues, document and prepare technical design and specs accordingly.
• Designing and building Calculated Attributes, Calculated Measures, Restricted Measures, Variables, Input Parameters and Decision Tables.
• Working with an Offshore development team on a regular basis and have the ability to articulate the requirements and solutions to them. Review the work delivered by offshore team.

Confidential

SAP BWHANA Analyst

Environment: SAP HANA 1.0, SPS10, SPS12, BW 7.4, 7.5, SAP BOBJ 4.2 SP2/SP3/SP5, SAP XS engine, Informatics, Service now, DCS, XA - data providers, SharePoint.

Responsibilities:

• SAP BW/4 HANA Modelling for ADSO and Open ODS, Extraction and loading of data from Sales Stats
• Designing SAP HANA Tables, HANA models (Attribute Views, Analytical Views and Calculations Views) using transactional and Dimensional Data.
• Extensive understanding of FI-CA, CO, IS-U Billing, IS-U Customer Service and IS-U Device Management.
• Involved in requirement gathering for development, Data modelling and designing reports as per the requirement. Also Involved in Installing BI Technical Content.
• Installed Business Content for standard Info objects, Info-Sets, Info-Cubes, and Multi-Providers etc.
• Worked extensively on Open hub, Informatics tools to download data to the Third-Party Tools from BW
• Performed analysis, design, development and implementation of standard/customized Info-Cubes and ODS Object.
• Understanding existing project flow, existing ABAP developments, changing data for further enhancements.
• Establishing connectivity between the SAP BW Info-Cubes/BEX Queries with Tableau 9 and designing Tableau queries for the end users.
• Redesigned HANA Attributes Vies, and HANA Analytical Views for Sales Stats Extractor Loads and called them using the Open ODS (Using Database Tables/ Views) in SAP HANA Studio for SAP BW/4 HANA.
• Worked on both Load performance tuning and Report performance tuning by creating DB Statistics, Aggregation, OLAP Cache, Compression, Indexes and Partitioning
• Used WEBI to connect with the SAP HANA Database, in designing new Reports for bringing summarized view of large volumes of data.
• Writing start, end and pseudo routines in ABAP when needed.
• Worked on Complex information models and implemented using SQL Script.

Confidential, Topeka, KS

SAP HANA Modeler

Environment: SAP HANA 1.0, SPS10, SPS12, BW 7.4, 7.5, SAP Data Services SAP BI 7.1/7.3, SAP BOBJ 4.2 SP2/SP3/SP5, ECC 6.0, BOBJ Explorer 4.1 SP3/SP5, Dashboards Design Studio, Oracle 10g, DB2, MS SQL Server 2008.

Responsibilities:

• Designing SAP HANA Tables, HANA models (Attribute Views, Analytical Views and Calculations Views) for Sales and Inventory scenarios.
• Worked on Complex information models and implemented using SQL Script.
• Developed complex HANA Information models and achieved MPP (Massive Parallel Processing) by using different column views in SQL script Calculation views.
• Preparation of data, designing and implementing HANA analytical models, data provisioning into HANA tables, and designing and creating reports on HANA data.
• Created Attribute views, Analytic views, and calculation views as a part of SAP HANA Modelling using HANA Studio. Implemented the business models using SAP Tables
• Worked on providing security restrictions on models using Analytic Privileges and assigning authorization roles to different types of users.
• Configured SLT, created new SLT schema, replicated the data from SAP ECC and non-SAP data, modified the SLT transformation filtered, and added new fields with logic before data loading; Data provisioned data from multiple Modules like FICO, MM and SD.
• Involved in creating Generic Extractors using Table and view.
• Involved in designing the Graphical Star Schema View by following the necessary standards to deploy optimized Info Cube Data Model both at the Database level and Reporting Level.
• Promotion of HANA code to production using export/import of information models and delivery units. Involved in transports using Delivery Units; Transported Universe from one System to another system.
• Creation of local and secure connections and Universe in IDT; Created universe using IDT and report development in WebI.
• Experience in working with modules of Business Objects XI Enterprise suite like Information Design Tool, CMC, WebI, Business Explorer(BEx) and various reporting tools like Celsius, Analysis for Office, Lumira.