SUMMARY:

• Over 5 years of experience in SAP HANA and BW on HANA in various areas of Development and Enhancements.
• Experience in native HANA development, modelling best practices for large data volumes, SQL scripting, stored procedures, CE Functions.
• Leverage technical expertise to develop HANA models using Attribute Views, Analytic Views, and Calculation Views.
• Strong understanding of Data Modeling in data wa r ehouse envi r onment such as star schema and snow flake schema
• Worked on Filters, analytic privileges, currency conversion mechanisms, Variables and Input Parameters on calculation views and stored procedures.
• Experience with conversion of deprecated models in SPS11
• Worked on Hierarchies and on creating calculated and restricted columns.
• Experience with usage of Various Data provisioning techniques like Importing of Data from Flat Files, BODS, SLT and SDA for populating data to the HANA system
• Strong knowledge in ETL - Extraction/ T ransformation/Loading, Data Analysis, Data mining, Data migration, Data p r eparation, Graphical P r esentation, Statistical Analysis, Reporting, V alidation and Documentation.
• Worked on MDX and AO reporting mechanism on HANA Modelling Views.
• Usage on time attribute Views and creation and updating the decision tables, currency conversion, Variables and Input Parameters.
• Consuming data modelling objects from BW to HANA platform.
• Created Data Modelling Objects like Composite Providers, Advanced DSO ’ s, Open ODS view, Virtual Providers, Transient provider.
• Experience in Data Modelling activities like creation and maintenance of info Cubes, ODS/DSO, info Objects, Multi Providers, Info sets, Info Package, Transformation and DTP.
• Experienced in developing Data Mapping, Performance T uning and Identifying Bottlenecks of sou r ces, mappings and targets.
• Involved in all phases of the Software Development Life Cycle (SDLC) and experience with W aterfall Model and Agile project development Methodologies.
• Experience in writing T echnical design documents, T raining material, User manuals and Unit test plans.

TECHNICAL SKILLS:

LANGUAGES: Java, C, SQL, UNIX Shell Scripting SAP TOOL: SAP NetWeaver 2004s,, SAP BI 7.0, SAP BI 7.3, SAP BO 4.0, ECC6.0, HANA 1.0

REPORTING: BEx Query Designer, BEx Query Analyzer, WEBI, Universe Designer, Xcelsius 2008, Hyperion reporting

PL: A TFORMS: W indows, Unix, Linux, Mac OS

Data: AT ABASE: Oracle 12c/1 1g/10g, Postgres 9.5/9.4/9.3, My SQL, MS SQL Server

IDE: T OOLS: SQL Develope r, T OAD, Eclipse, PG ADMIN III

VERSION: CONTROL: Subversion (SVN)

SOFT: W ARE T OOLS: MS O f fice Suite( W ord, Excel, Project), V isio, Rational Rose

WEB: TECHNOLOGIES: HTML, CSS, XML, JSP

QUALITY CONTROL: ITSM, HP Quality Cente r, JIRA

PROFESSIONAL EXPERIENCE:

Confidential

SAP BW on HANA Consultant

• Analyze existing client processes and create optimized or enhanced solutions using HANA.
• Implement analytical and planning tools, focused on ETL and data modelling.
• Virtual data modeling, HANA Studio, Hana Live / Core Data Service.
• Worked extensively on various information models like Attribute views, Analytical views and Calculation views in HANA Studio
• Developing SAP HANA information models such as Procedure and Hana Views (Attribute, Analytics and Calculation views) with graphical and SQL Scripting, SDA (Smart Data Access).
• Excellent knowledge on: HANA Optimized InfoCubes, HANA Optimized DSO's, Transient, Composite, Hybrid Providers, Publishing HANA Model in SAP BW, Import SAP NetWeaver BW Model to HANA .
• Providing technical expertise on SAP architecture and making recommendations to improve performance.
• Basic Architecture and knowledge of how BW on HANA works & insights into sizing, HA, DR for BW on HANA systems.
• Created Universes on top of HANA calculation views and developed the Webi reports and dashboards using IDT Information design tool .
• Implementing SAP BW on HANA specific modelling like using LSA++, Composite Providers and exposing BW objects in HANA Views, Operational Data Provisioning, ADSO etc
• Manage SAP BW tables in HANA Scale up and Scale out systems
• Experience in Importing BW models Info Cube, DSO in HANA as Analytical view.
• Designed developed cross tab reports, reports with sub reports linked unlinked and charts using Crystal Reports.
• Managed, monitored several data loadings, Error Debugging and rectification, solving issues, problems faced during Data uploads. Involved in Increasing the Load performance of the BW system while loading into ODS objects and Info cubes.
• Understanding the business scope, gathering and documenting requirements, determining possible solutions, designing, configuring and testing solutions, and assisting report developers and users with learning and issues
• Conducted Training sections for all BI Business Users and created end-user training documentation.
• Developed scripts to automate the business flo w .
• Build projects using W aterfall and Agile project development methodologies.

Confidential

SAP BI Consultant

• Expertise in Data Modeling: Creating necessary BI InfoObjects, Data Store Objects, InfoCubes, InfoSets, MultiProviders, InfoPackages, Data Transfer Process and Transformations as per client requirements.
• SAP BI 7.0 & 7.3 Data Extraction: Experienced in Data Extraction from SAP R/3 using LO- Cockpit extraction structures and other extraction structure.
• Good experience of BW backend dataload and front end query performance tuning.
• Good experience of working with ECC6.0 components like Data Source Enhancement. Created and activated Generic Data Sources.
• Expertise in creating Queries in Query Designer using Variables, Restricted Keyfigures, Calculated Keyfigures, Filters, Exceptions.
• Excellent knowledge in both functional and technical domain of SAP BW and good query development in the areas of SAP modules SD, FICO, PP, QM, MM.
• Customized and improved query navigation by implementing Conditions, Jump queries using RRI, Free Characteristics.
• Implemented various Performance Tuning activities to increase the performance of Queries by Creating Aggregates, Partitioning and Compression of infocubes.
• Involved in Sales order Header and Item Level data extraction
• Used different tables to extract data, tables such as VBAK (Sales order header data), VBAP (Sales order item Data), VBUK (Sales document Header status), and VBUP (Sales document item status).
• Experience in SAP BO tools such as Analysis for office, Web intelligence and Design studio
• Involved in solving tickets regarding Extractions, Performance Issues and also Load Failures.
• Understanding of the techniques to optimize performance of views.
• Functional background in SAP and understanding of SAP ECC business process integration
• Ability to create SAP HANA information models such as Procedure and Hana Views (Attribute, Analytics and Calculation views) with graphical and SQL Scripting.
• Support local and international key accounts through whole lifecycle of projects by delivering onsite and/or remotely, e.g., business analysis, development, risk assessments, platform integration and validation, technical and functional business process improvement, and empowerment
• Responsible for Identifying Business Requirements from Business Requirements from end- users.

Confidential

SAP BW Consultant

• Maintaining Reconciliation to verify the data in SAP R/3 and SAP BW are same or not after the data loads.
• Involved in performing Production Support activities like Ticket Analysis report, Resource Utilization Report, Time sheet maintenance of the support team.
• Supported the client by providing long-term solutions to the tickets by doing Root cause Analysis.
• Maintain list of all the activities for all the tickets until it is closed down.
• Involved in Validated data consistency in reporting with Data Target against PSA after loading them to data targets.
• Actively and regularly involved in Load Monitoring of Daily, weekly, and Monthly, Data Loads using Process Chains.
• 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 infopackage.
• Created Aggregates for Info Cubes to improve query performance.
• Created Reports using Calculated Key figures, restricted key figures, Formulae, Conditions and Variables and Developed Drilldown Reports Using RRI.
• Involved in solving tickets regarding Extractions, Performance Issues and also Load Failures.
• Building and handling large data warehouses with BW.
• Excellent knowledge in both functional and technical domain of SAP BW and good query development in the areas of SAP modules SD, FICO, PP, QM, MM.
• Ensures stabilization of the solution and continuous improvements
• Project and user support and responsible for ticket escalation in cases of data mismatch.