SAP HANA Consultant
Resume:
RAJESH RAO
SAP CERTIFIED HANA CONSULTANT
**** ****** *****, *** ***, Baltimore, Maryland, 21209
Visa Status: U S Citizen
315-***-**** ac3134@r.postjobfree.com
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