SUMMARY:

• Amish Sinha is a certified SAP Hana and BO Consultant with 11 years of experience on SAP Business Intelligence and Analytics.
• He has extensive experience working with service delivery, implementation of SAP BIBO/HANA projects / program initiatives and ensuring delivery of projects within time to clients and has overall completed four Full life cycle implementations, 2 upgrades and 3 production support roles. He has Hands - on experience with data architecture, data mining, large-scale data modeling, and business requirements gathering/analysis and reporting. He has worked on SAP HANA Data provisioning using SAP Landscape Transformation (SLT), BODS and has used information models like Attribute, Analytical and Calculation Views.
• His SAP BO experience includes working with Front end tools Lumira, Business Objects Design Studio/(Xcelsius) Dashboards, Web Intelligence, Information design tool(IDT) and integration with SAP HANA, Business Intelligence and relational database. He has integrated BO with Business Intelligence, HANA and relational database. Also, experience on S/4HANA Embedded Analytics Architecture (Analytical CDS Queries, Analytical Fiori Apps, and Integration with Business Objects Reporting Tools etc.) Has extensive experience in Data Analysis and SQL programming to analyze and debug complex SQL queries. He has experienced with SAP CRM, FICO, SD module implementation.
• Amish has good communication skills, has worked with cross platform teams and has assisted/mentor team members. He is completing his project at Coca- Cola in North Carolina, USA and has worked on Confidential in New Jersey, Sony Pictures and Amerisource projects, PA USA.

TECHNICAL SKILLS:

SAP Business Objects BI Suite: Business Objects 4.2/4.1/3.x/XIR2, SAP Business Objects Explorer, SAP Business Objects Information Design Tool(IDT), SAP Crystal Reports for Enterprise, SAP Crystal Reports 2011 / 2013, SAP Business Objects Design Studio, SAP Lumira, CMC, Web Intelligence (WEBI), Web Intelligence Rich Client (WRC), OLAP Analysis, Translation Manager, A-Office.

SAP HANA: Data Provisioning using SLT and ETL SAP Data Services 4.x (BODS), Native Data Modeling HANA attribute, analytic, and calculation views and reporting, S/4 HANA system, ABAP CDS views, SAP HANA LIVE, S/4HANA Embedded Analytics Architecture -Analytical CDS Queries, Analytical Fiori Apps, Integration with Business Objects Reporting Tools.

S/4 HANA CDS Report Designer: Experienced with various reporting tools such as BusinessObjects, Lumira, Fiori, and Analysis for Microsoft Excel, BEx Analyzer/Designer, Design Studio, etc. available in SAP. ABAP CDS View data can be consumed from one of the tools above to generate reports. There are 3 types of ABAP CDS views available in SAP and they are basic views, composite views and consumption views. ABAP CDS views are similar to Hana Views (attribute views, analytic views and calculation views) but they are database independent and lie on the Application layer. On the other hand, Hana views are specific to Hana database and lie on the database layer.

SAP BW/BI: BEx Query, Strong understanding of BW 7.0, 7.3 and 7.4 on HANA

Databases: SAP HANA, SAP ECC, SQL Server 2008, MSSQL, Oracle 11i, Teradata, MS Access; DB2

Languages: SQL, JavaScript, HTML, DHTML, XML.

SAP Module: SAP FI-CO, SD, CRM, MM

Industries: pharmaceuticals, finance, health care, insurance, telecommunications, energy, media and entertainment and manufacturing.

PROFESSIONAL EXPERIENCE:

Confidential, NC

SAP HANA Consultant - Reporting and Analytics

• Presented best table and model design practices to improve HANA performance, star/snowflake model design practices that maximize join pruning.
• Utilized HANA Plan visualizer to analyze, redesign and optimize existing HANA calculation models and SQLScript (PL/SQL) for maximum efficiency and performance.
• Built and automated distribution of delivery efficiency reports using SAP BusinessObjects WebI.
• Design and develop HANA attribute, analytic, and calculation views so that end results can be consumed via a Business Objects report, dashboard, and an all-inclusive Business Objects self-service universe.
• Implement create database schemas, compose views, develop scripts, and establish data feeds (some from SLT).
• Identify and develop procedures for attributes, measures, and Hierarchies.
• Create packages, manage attribute mapping, and create constant columns and analytics privileges.

Confidential, NJ

Sr. SAP Consultant - Analytics, BO, HANA

• Experience on Native Data Modeling HANA attribute, analytic, and calculation views (graphical and script).
• Proficiently manage and accountable for the complete life cycle of development/support projects including analysis of the client requirements, translating new ideas into client solutions, requirements development, delivery, support, analysis and documentation.
• Provide technical leadership and functional insight while estimating and evaluating the effort/schedules and manage the team and its grievances while training them on the project architectures.
• Design and develop HANA attribute, analytic, and calculation views so that end results can be consumed via a Business Objects report, dashboard, and an all-inclusive Business Objects self-service universe.
• Implement create database schemas, compose views, develop scripts, and establish data feeds (some from SLT).
• Identify and develop procedures for attributes, measures, and Hierarchies.
• Create packages, manage attribute mapping, and create constant columns and analytics privileges.
• Translate report functional specifications into Business Objects, and report technical specifications as well as HANA technical specifications.
• Gather requirements and document functional specifications with regards to Business Objects reports.
• Experienced on various reporting tools such as BusinessObjects, Lumira, Fiori, and Analysis for Microsoft Excel, BEx Analyzer/Designer, Design Studio, etc. available in SAP. ABAP CDS View data can be consumed from one of the tools above to generate reports.There are 3 types of ABAP CDS views available in SAP and they are basic views, composite views and consumption views.ABAP CDS views are similar to Hana Views (attribute views, analytic views and calculation views) but they are database independent and lie on the Application layer. On the other hand, Hana views are specific to Hana database and lie on the database layer.
• Participate in requirement validation sessions and translate the functional requirements for technical team.
• Experience connectivity between Business Objects and HANA
• Help with information design tool creation of data foundation, universe for HANA reporting
• Retire legacy BW data warehouse systems to native HANA.
• Work with connector configuration towards HANA DB (both enterprise and BW), using HANA business layer, utilizing universe and BICS connections and composite model using BW cubes.
• Handle report scheduling, security, separating power users vs. end users, managing folders and reports, enabling/restricting specific BO application capabilities based on user groups.
• Experience on Analysis for Office (A-Office)
• Real-time operational reporting and analytics using SAP HANA live.
• Experience on SAP’s strategic solution for real-time operational reporting is SAP HANA Live.
• Gain Valuable Insights on Your Business right after installing the SAP HANA Live for SAP Business Suite by using the rich content delivered by the Virtual Data Models delivered with it.
• Make use of the ease of use of as well SAP HANA Studio, SAP Business Objects BI standard reporting interfaces and the capabilities of html5 front ends.
• Hands on experience into SAP Rapid Deployment Solutions to accelerate the implementation of your SAP HANA Live Implementation.
• Real time operational reporting using SAP HANA Live
• Create technical specification documents for indicated Business Objects artifacts.
• Support end user’s questions as it relates to the released universes, reports, connectivity, and end users reports.
• Interact with business analysts and end clients whenever required.
• Troubleshoot any report design, testing and performance issues.

Confidential

SAP Principal Consultant BOBI, HANA

• Managed SAP BW backend with BO as frontend reporting tool.
• Played vital role in BOXI 3.1/4.x landscape planning, designing and implementation.
• Designed and developed HANA attribute, analytic, and calculation views.
• Made use of the ease of use of as well SAP HANA Studio, SAP Business Objects BI standard reporting interfaces and the capabilities of HTML5 frontend
• Was extensively involved in design, route cause analysis, issue tracker, and ticket management.
• Mentored for project manager on project deliverables & weekly status, monthly status project updates, and tasks status.
• Created complex reports stating revenue generation per year using cascading and user objects like measure objects by using @aggregate awareness function to create the summarized reports.
• Involved in developing new universes as per the user requirements by identifying the required tables from data mart and by defining the universe connections.
• Used derived tables to create the universe for best performance and use context and alias tables to solve the loops in universe.
• Updated client on the progress/issues and necessary details.
• Assigned reports to team members and kept track on the progress of the reports.
• Created BEx query, aggregate awareness, LOV, custom hierarchies, time hierarchies and used @Functions with objects in universe design.
• Resolved chasm and fan traps and resolved loops using aliases, contexts, and shortcut joins.
• Developed universes and reports.
• Developed critical reports like drill down and master/detail for analysis of parts benefits and headcount.
• Created different reports containing charts showing revenue and operating income by different divisions, sales and revenue.
• Created complicated reports including sub-reports, graphical reports, formula base and well-formatted reports according user requirements.
• Actively executed process exceptions according to user’s requirement.
• Maintained project-related documents.
• Involved in creating web intelligence reports and rich client reports with various sources like universe, OLAP, and RDBMS.
• Involved in end-to-end risk management project life cycle, from gathering requirement, understanding requirements, making function specification and drafting technical design to deploying reports live.
• Created access matrix in CMC, development of Universes, and Webi reports.
• Had good experience on production support, ticket handling, and interacting users and resolving issues.
• Participated project E2E documentation such as functional specification (requirement specification), technical design (ETL data mapping, universe table/field mapping, scheduled jobs), end user presentation and workshops.
• Was involved in every phase of this project, integration test case submission and getting sign of from users, creation of CRs and getting code promotion approval Dev to UAT, UAT to PROD.
• Played vital role in code migration process and content migration methodology.

Confidential

SAP Consultant, Business intelligence

• Played vital role in BOXI 3.1/4.x landscape planning, designing and implementation.
• Was extensively involved in design, route cause analysis, issue tracker, and ticket management.
• Mentored for project manager on project deliverables and weekly and monthly status project updates and tasks status.
• Created complex reports stating revenue generation per year using cascading and user objects like measure objects by using @aggregate awareness function to create the summarized reports.
• Involved in developing new universes as per the user requirements by identifying the required tables from data mart and by defining the universe connections.
• Created BEx query, aggregate awareness, LOV, custom hierarchies, time hierarchies and used @Functions with objects in universe design.
• Used derived tables to create the universe for best performance and use context and alias tables to solve the loops in universe.
• Updated client on the progress/issues and necessary details.
• Assigned reports to team members and kept track of progress of the reports.
• Created aggregate awareness, LOV, custom hierarchies, time hierarchies and used @Functions with objects in universe design.
• Resolved chasm and fan traps and resolved loops using aliases, contexts, shortcut joins.
• Develop universes and reports.
• Developed critical reports like drill down, master/detail for analysis of parts benefits and headcount.
• Created different reports containing charts showing revenue and operating income by different divisions, sales and revenue.
• Created complicated reports including sub-reports, graphical reports, formula base and well-formatted reports according user requirements
• Actively executed process exceptions according to user’s requirement.
• Maintained project related documents.
• Helped created Web intelligence reports, rich client reports with various sources universe, OLAP, and RDBMS.

Confidential

Sr. Software Developer

• Requirement Analysis and gathering from client.
• Created complicated reports including sub-reports, graphical reports, formula base and well-formatted reports according user requirements
• Involved in creating web intelligence reports and rich client reports with various sources like universe, OLAP, and RDBMS.
• Prepare Technical Design Document.
• Developing application using Lotus Notes Scripting and Lotus document management tool.
• Involved in Perform Unit testing for the application developed.

Confidential

Software Developer

• Requirement Analysis and gathering from client.
• Involved in creating web intelligence reports and rich client reports with various sources like universe, OLAP, and RDBMS.
• Prepare Technical Design Document.
• Developing application using Lotus Notes Scripting and Lotus document management tool.
• Perform Unit testing for the application developed.