We provide IT Staff Augmentation Services!

Sap Bi/hana Consultant Resume

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.

Hire Now