Summary
Overview
Work History
Education
Skills
Accomplishments
Technical
Professional Snapshot
Personal Information
Languages
Training
Disclaimer
Certification
Timeline
Generic
Amandeep Singh

Amandeep Singh

Ghaziabad

Summary

Results-driven professional with over 10 years of comprehensive experience in SAP Analytics for Cloud, SAP BI/BW on HANA, and EPC Thermal Power Plant environments. Proven track record of successfully leading and contributing to diverse projects, encompassing the development of 60+ SAC objects, strategic planning, and the implementation of complex calculations. Demonstrates a deep understanding of SAP Analytics Cloud architecture, data modeling, integration, and report development. Possesses extensive expertise in SAP HANA data modeling, SAP BI report design techniques, and proficiency in monitoring and troubleshooting complex data processes. A seasoned resource with a keen focus on automation, reducing manual entries, and enhancing reconciliation processes across various data sources.

Overview

8
8
years of professional experience
1
1
Certification

Work History

Assistant Manager

EY GDS Noida
Noida
11.2024 - Current
  • Migration for Project for the Product build
  • Worked on the design of the model and Dimensions
  • Created Dimensions, Measures and Models
  • Built FS and TS for the development
  • Built the Sprint Plan for the development of the objects
  • Experience in creating Stories and Analytical Apps
  • Experience in creating Tables, Input controls, story filters, Composite, calculated measures, restricted measures, and comments etc
  • Experience in creating Data actions, Multi-actions, and Calendar Tasks
  • Transporting object from development to quality system and to UAT system
  • Created Test scripts and involved in testing the objects
  • Created Excel-Add-in’s templates for inputting data
  • Maintained FX rates and Developed Currency Conversion App and Stories
  • Responsible for efficiently delivering the project and supervising the implementation team
  • Extensive experience in data modelling and preparing datasets, merging, appending, custom hierarchies, custom calculations, groupings, formatting values, data wrangling, dimensions, and measures
  • Well versed in visualizations and their usage charts, tables, maps, filters, dropdown menus, hiding functions, interactive objects, pictures
  • Knowledge in predictive capabilities, Smart Assist, Smart Predict.

Consultant

Deloitte USI Gurgaon
Gurgaon
02.2022 - 11.2023
  • Created Dimensions, Measures and Models
  • Experience in creating Stories and Analytical Apps
  • Experience in creating Tables, Input controls, story filters, calculated measures, restricted measures, and comments
  • Experience in creating Data actions, Multi-actions, and Calendar Tasks
  • Transporting object from development to quality system and to UAT system
  • Created Test scripts and involved in testing the objects
  • Created Excel-Add-in’s templates for inputting data
  • Maintained FX rates and Developed Currency Conversion App and Stories
  • Supported during SIT, Cutover, UAT Cycles & Go Live in resolving defects
  • Responsible for efficiently delivering the project and supervising the implementation team
  • Extensive experience in data modelling and preparing datasets, merging, appending, custom hierarchies, custom calculations, groupings, formatting values, data wrangling, dimensions, and measures
  • Well versed in visualizations and their usage charts, tables, maps, filters, dropdown menus, hiding functions, interactive objects, pictures
  • Knowledge in predictive capabilities, Smart Assist, Smart Predict
  • Used Power automate to create data source for flat file
  • Using Power query automated some reports.

Assistant Manager

Genpact Ltd. Noida
Noida
02.2021 - 02.2022
  • Successfully created Dashboard story in SAC using Canvas, Responsive pages, and Digital boardroom
  • Successfully display story in Mobile SAC app using Responsive pages
  • Tested and resolved data issues in SAC Dashboard stories
  • Implemented stories using different features of SAC
  • Implemented complex calculations in SAC stories
  • Responsible for efficiently delivering the project and supervising the implementation team
  • Extensive experience in data modelling and preparing datasets, merging, appending, custom hierarchies, custom calculations, groupings, formatting values, data wrangling, dimensions, and measures
  • Well versed in visualizations and their usage charts, tables, maps, filters, dropdown menus, hiding functions, interactive objects, pictures
  • Knowledge in predictive capabilities, Smart Assist, Smart Predict
  • Used Power automate to create data source for flat file
  • Using Power query automated some reports.

Software Engineer

HCL Technologies Noida
Noida
07.2016 - 02.2021
  • Monitored Daily Chains, Weekly Chains
  • Finding the route cause for the failed chains and giving resolution
  • Loading Master data, Transaction data into the SAP BW on daily and weekly basis
  • Experience with SAP HANA data modelling using Attribute View, Analytical View, Calculation view, Stored Procedures, Table Functions, Decision tables & Analytical Privileges
  • Editing the error records in the ERROR stack and uploading these records by using error DTP
  • Changes in query based on client requirement
  • Scheduled the reports in BI Launch pad and modified the report broadcasting time and modified the emails for respective customers
  • Escalating prioritized tickets regarding extraction, performance issues and load failures
  • Uploading weekly monitoring status to portal and Attending Weekly status meeting with client
  • Created all Process chains for the Transaction Data and the Master Data Daily Loads
  • Worked on ODP Extractors
  • Maintained ODQ for the delta management
  • Monitoring the Process Chains of Daily loads and supporting the loading issues.

Education

B.Tech - Electrical& Electronics

Pranveer Singh Institute of Technology
Kanpur
05-2012

12th - Science Education

Jalpa Devi IC
Kanpur
05-2006

10th - Science Education

Mercy Memorial School
Kanpur
05-2004

Skills

  • SAP analytics Cloud Planning
  • SAC Reporting
  • Strategic Planning
  • Financial Planning
  • SAC Security Design
  • Hana Modelling
  • BW Support

Accomplishments

  • Won several Inter and Intra School Quiz competition.
  • Represented State, district& college team in cricket tournaments.
  • Synchronization of Unit -1 & Unit-2 with Grid.
  • Won second prize for school in Interschool competition.

Technical

  • EDWH SAP BI/BW 7.0,7.3, 7.4, 7.5
  • ERP ECC, SAP R/3
  • REPORTING TOOLS SAC-P, SAC- Excel Add-in, Power BI, SAP Lumira BEX Query Designer, BEX Analyzer

Professional Snapshot

Around 7.5 years of experience in SAP Analytics for Cloud & SAP BI/BW on HANA with hands-on exposure, and 3.3 years of experience in EPC Thermal Power Plant. Built 60+ SAC Objects (Models, Stories, Data Actions, Integration jobs) across all planning processes resulting in increased automation, reduced manual entries, and improved reconciliation across different data sources. Worked on Security development of SAC-P roles and users as well. Experience in building essential financial reports like P&L Statements, Parallel Trade Input Forms, Price Volume Variance Mix reports, and SG&A & other operating expense reports. I am experienced in strategic planning, including Bottom-Up and Top-Down approaches. Good knowledge in SAP Analytics Cloud for BI and planning. Successfully implemented complex calculations in SAC stories and applications. Strong understanding of SAP Analytics Cloud architecture, data modelling, data integration, and report development. Extensive experience with SAP HANA data modelling using Attribute View, Analytical View, Calculation view, Stored Procedures, Table Functions, Decision tables, and Analytical Privileges. Proficient in SAP BI report design techniques, implementation, and support of complex reports (Query Designer, Bex Analyzer), and knowledge of analytical tools like Explorer, OLAP, Dashboards, and Analysis Office. Experienced in monitoring data loads of Daily & Weekly Process Chains and troubleshooting failed process chains.

Personal Information

  • Father's Name: Mr Sawant Singh
  • Date of Birth: 03/21/88
  • Gender: Male
  • Nationality: Indian

Languages

English, Hindi

Training

  • Jindal institute of power technology Project- Power Plant Familiarisation and DCS (MAX DNA) Operation.
  • ETAP Training at GVK Power ltd

Disclaimer

I hereby declare that above information is true to the best of my knowledge. Yours Sincerely, (AMANDEEPSINGH)

Certification

  • SAP Certified Application Associate - SAP Analytics Cloud: Planning - https://www.credly.com/badges/0fec2509-4b04-4a2a-86fa-1b2aba2bc714/linked_in_profile
  • SAP Certified Application Associate - SAP Analytics Cloud Story Design- https://www.credly.com/badges/d281a5e1-2928-44cb-b00c-4988835df604/linked_in?t=s3xxk5

Timeline

Assistant Manager

EY GDS Noida
11.2024 - Current

Consultant

Deloitte USI Gurgaon
02.2022 - 11.2023

Assistant Manager

Genpact Ltd. Noida
02.2021 - 02.2022

Software Engineer

HCL Technologies Noida
07.2016 - 02.2021

B.Tech - Electrical& Electronics

Pranveer Singh Institute of Technology

12th - Science Education

Jalpa Devi IC

10th - Science Education

Mercy Memorial School
Amandeep Singh