SAP HANA Consultant

RAJESH RAO

SAP CERTIFIED HANA CONSULTANT

**** ****** *****, *** ***, Baltimore, Maryland, 21209

Visa Status: U S Citizen

315-***-**** *******@***.***

OBJECTIVE

Seeking a position as SAP HANA consultant, leveraging my SAP Data Provisioning, SAP HANA information modeling and data visualization skill sets to integrate data, create information views and produce striking visuals.

PROFILE

SAP HANA Business Intelligence Consultant with excellent experience in requirements gathering, process analysis, fit-gap analysis, blueprinting, assisting/advising in the solution design, configuration, testing, documentation, training and implementation of BW solution in sync with the Industries Best Practices and Standards. Also coordinated team activities, participated in daily/weekly status meetings and reports. Maintained excellent liaison with 3rd party vendors/consultants including off-shore resources in the support of quality and timely project deliverables. Well-versed in creating BW queries, HANA information views and reports, dashboards and visuals based on utilizing various BI data visualization solutions.

Experienced with data provisioning utilizing SAP Landscape Transformation (SLT) and SAP Data Services (SAP DS)

Experienced with ETL of data from diverse sources such as flat files, Excel, SQL Server, etc., using SQL Server Integration Services (SSIS) packages and its constituent functionalities such as tasks and transforms

Experienced in analyzing data models and creating various SAP HANA Information Views

Experienced in the design and development of reports, dashboards and visuals utilizing SAP Lumira, SAP BEx Analyzer, Power BI, Tableau, and SQL Server Reporting Services (SSRS)

Modification of Excel and Web reports based in SAP Business Information Warehouse utilizing Visual Basic, HTML, JavaScript, etc.

Experienced in creating various T-SQL functionalities in SQL Server Management Studio (SSMS)

Collaborated with accounting and finance professionals in the production, modification and maintenance of business reports

SAP Global Academy trained in HANA, BW and APO

Very good consulting experience with a Big 5 consulting firm for two years

Prior full life cycle implementation experience in SAP BI-BW

Excellent communication and interpersonal skills

Excellent technical writing and presentation media skills

Skills Summary

SAP HANA Modeling Lumira, Tableau, Power BI SAP BW Queries/Reports

SQL, SQLScript, C++, VB HTML5, CSS, JavaScript SSMS, SSIS, SSRS

SAP DS, SLT Excel, Access Adobe CC Suite

PROFESSIONAL EXPERIENCE

2017: MyCove Corporation, Jersey City, NJ

Business Intelligence Consultant (Contractor)

Reporting Implementation Project:

MyCove Corporation, Jersey City, NJ (Real Estate Sector) 01/2017 to 03/2017

Researched various Data Visualization tools such as Tableau, QlikSense, Pentaho, etc. and made recommendations as to best tool per business requirements

Implemented various Power BI reports and dashboards such as Consumer Expenditure by County, Median Household Income by County, Median Rent by County, Home Owner vs. Renter by County as per business requirements

2016: TEKSystems, Syracuse, NY

Systems Analyst (Contractor)

ETL Implementation Project:

AXA Equitable, Syracuse, NY (Finance) 02/2016 to 05/2016

Implemented ETL via SSIS packages utilizing various transformation components such as Conditional Splits, Multicasts, Data Conversions, Derived Columns, etc., to effect modification, addition, update, and migration of data from CSV files and complex Excel files to staging tables in SQL Server.

Implemented error checking via various SSIS logging functionalities

Modified various existing T-SQL stored procedures per client requirements

2015: Edureka

MSBI Stack:

Trained in MSBI stack involving

-Using SSRS, designed and deployed various types of reports such as drill down, cascading, parameterized, linked, etc., along with concomitant charts

-Hands-on experience in creating queries, stored procedures, views, triggers, and other T-SQL functionalities using SSMS

-Extraction and migration of data from flat files, Excel files and SQL Server database sources and subsequently migrating data into staging environment in SSMS using SSIS packages

-Per ETL mapping document requirements, employed various SSIS transformation components such as Lookups, Unions, Conditional Splits, Multicasts, Data Conversions, Derived Columns, Slowly Changing Dimensions (SCD), etc., to effect modification, addition, update, and migration of data from staging area to resident database in SSMS data warehouse

-Implemented Merge based and Lookup based transformational equivalents of SCDs, in place of SCDs to improve performance

2014 to 2015: Surya Academy (SAP SE Affiliated)

SAP HANA Trainee

Trained in various SAP HANA solutions

-Hands-on experience with Data Provisioning tools including SLT and SAP Data Services

-Hands-on experience involving the creation and use of Attribute, Analytic and Calculation views

-Modification and manipulation of data models utilizing input parameters, variables, constraint filters, restricted columns, calculated columns and decision tables

2014: SAP America, Global Academy, Newtown Square, PA

SAP HANA Trainee

Trained in SAP Academy courses, HA100, HA300, and HA360

-Detailed coursework involving the creation of attribute, analytic, and calculation views within a CO-PA context

-Detailed coursework involving using Full, Fuzzy and Freestyle Searches

-Hands-on experience involving the consumption of reports utilizing SAP Lumira

-SQL and SQLScript programming

2013 to 2014: Cary, NC

Primary care provider for ill family member

2011 to 2013: 3D Animation Studio Startup, Columbia, MD

Collaborated with several CGI professionals in India to set up 3D Animation Studio in India and worked on animation projects.

2003 to 2006: Deloitte Consulting, Glen Mills, PA

SAP BW Consultant

SAP Projects:

Fender Guitar, Scottsdale, AZ, 11/2005 to 02/2006

Designed and developed SAP BEx queries for reports using BW Query Designer

AIG, Wilmington, DE, 11/2004 to 10/2005

Designed and developed BEx queries

Developed various BEx elements and components such as calculated key figures, restricted key figures, structures, variables, exceptions and conditions

Managed outsourcing activities in India as remote consultant

Coca-Cola Enterprises, Atlanta, GA, 02/2004 to 09/2004

Responsible for design and development of SAP BW reports for the web and Excel

Handled Visual Basic based design and development of web related SAP BW reports

Created and maintained Business Process Procedures (BPPs), Business Process Master List (BPML), Scorecard and End User training documentation

Collaborated in integration testing

Responsible for the maintenance of Issues Log and ensuring resolution of entries

Organized team activities and outing related to work-balance life

Trained Junior Systems Analysts

Designed and created reports using SAP BEx Analyzer

Modification of BEx Analyzer reports using VBA

Greenlee Textron, Rockford, IL, 11/2003 to 02/2004

Performed unit testing of various business processes

Successfully tested changes made to system configuration

Performed integration testing in quality and production systems

Assisted the end users in User Acceptance Testing by designing test cases to cover all the functional scenarios of the SAP BW system in real-world usage.

Successfully tested the system performance of various business scenarios & final validations

1999 to 2002: Lockheed Martin, Syracuse, NY

Associate Software Engineer

Object oriented design and development of graphical elements using Visual C++ for U.S. Navy Sonar Simulation Systems

Object oriented analysis, design and development of graphical elements using Visual C++ for Australian Air Force Radar Systems

Software development of GUI interface for Acoustic Doppler Profiler System

EDUCATION

Master of Divinity, 2011, Trinity International University, Deerfield, IL

Master of Science, Computer Science, Syracuse University, Syracuse, NY

Bachelor of Science, Medicinal Chemistry, SUNY at Buffalo, Buffalo, NY

CERTIFICATION

SAP HANA Certified Application Associate - Edition 2016 - SPS12

COMMUNITY INVOLVEMENT

Maranatha College – Taught ESL in Vijayawada, India, 2010

Pui Tak Center - Taught ESL in Chicago’s Chinatown, 2008

HOBBIES

Graphic Design & Animation

Contact this candidate