Nishant S. - Finance Data and Performance Automation

Go to Website

Faridabad, India

Experience

Dec 2023 - Present

2 years 1 month

Finance Data and Performance Automation

Nagarro

Designing HANA Cloud models in SAP BAS for the new implementation of S4 Hana and including the old Oracle ERP data.
Developing Synonyms, Calculation views, Table Functions, Procedures, and cross-container HANA Cloud designs.
CI/CD deployment with GitHub. Automation with Airflow and Glue jobs.
Leading AR, Expense, WIP reporting on parallel ledgers.

May 2022 - Nov 2023

1 year 7 months

Global Data Automation

LTIMindtree

Designing financial models to XSA Containers and designing container-based models in HANA XSA over the source system S4.
Developing Synonyms, Calculation views, Table Functions, Procedures, and cross-container HANA XSA designs.
Leading FI AR reporting with snapshot data and designing master data models to showcase the complete order to cash process.
Migrating Native Hana models into HQL and PySpark functions for quote to cash processes.
CI/CD deployment with knowledge of Confluence, Azure DevOps, and Jira.

Aug 2019 - Apr 2022

2 years 9 months

Rebate Automation

Infosys

End-to-end implementation of Vistex reporting, where data models are created in Native HANA and consumed by different reporting tools.
Accommodating the design of the HANA models with iterative release in Vistex.
Following layer architecture in HANA developments that syncs with the data architect’s data model design.
Complete analysis of Vistex to understand the process flow and tables.
Performing code and design reviews and accommodating changes as per review comments.
Documenting all process flows and change tracker with each production release for audit process.
Designing and developing BODS jobs to push or pull data to different systems and using SLT to load data in the HANA environment.
Designing different scalar functions and procedures to fulfill reporting data requirements.
Performing migration activities involving quality tests and performance tests on different environments and approvals for releasing SOLMAN and Charm.

Jan 2019 - Jul 2019

7 months

Finance Reporting

Infosys

Developed composite providers on BW on HANA and consumed them to create WebI reports for business owners.
Managed development migration activities along with data quality tests and UAT.

Oct 2018 - Dec 2018

3 months

Noida, India

SOLMAN Reporting (ITSM and Charm)

Noida Power Company Limited

Identification and installation of different reporting objects in SOLMAN.
Customized developments according to the requirement and gained functional aspects of the SOLMAN system.

Aug 2018 - Sep 2018

2 months

Noida, India

SAP Lumira Discovery and Designer Implementation

Noida Power Company Limited

Leading the upgrade process of SAP BO 4.2, installing Lumira 2.1 in BO landscape.
Replicating old Xcelsius dashboards with Lumira Discovery Dashboards.
Gaining exposure to S4/HANA and BW4HANA modeling.

Aug 2017 - Jul 2018

1 year

Noida, India

SAP ISU EDM Implementation & Predictive Modeling

Noida Power Company Limited

Developed complete reporting aspect SAP ISU EDM in SAP BW with different customized and standard objects in SAP BW and SAP ECC.
Covered almost every customization aspect in SAP BW objects to meet requirements.
Set up and owned the complete reporting and analytics platform based on SAP BW and R programming for energy data management of the whole company for different customer groups.
Modeled business processes to optimize theft case analysis through statistical modeling in R.
Provided business reports and insights to senior management, business operations, and finance teams.
Designed and implemented a statistical model to identify theft cases in different consumer clusters.

Jan 2017 - Jul 2017

7 months

Noida, India

SAP CRM Reporting

Noida Power Company Limited

Covered the complete reporting aspect of a department at different hierarchies of the company.
Gathered functional requirements, implemented and installed standard objects between cross-application.
Created reporting hierarchy in SAP BO for CRM.
Handled different requirements at different levels in SAP BW and source systems with standard and customized objects.

Oct 2016 - Dec 2016

3 months

Noida, India

SAP FI Reporting

Noida Power Company Limited

Designed Excel, Tableau, and SAP BO dashboards to analyze and report management and internal KPIs and crucial business reporting.
Identified different requirements and replicated them in BW for efficient reporting.
Covered GL reporting of all transactions at different projects and capital expenditures and delivered to higher management for crucial decision-making.
Covered master data activation and standard and customized objects in cost center reporting.

Jul 2016 - Sep 2016

3 months

Noida, India

SAP CO Reporting

Noida Power Company Limited

Developed different reporting aspects in the CO module of SAP ECC in SAP BW using standard objects and later tweaked to fulfill requirements.
Covered actual planning and commitments of work breakdown structures with different line items.
Covered reporting aspects across different hierarchies of the department.

Jan 2016 - Jun 2016

6 months

Noida, India

Internship

Noida Power Company Limited

Tested and built different Xcelsius dashboards in SAP BO 4.1.
Built WebI Reports.
Built OLAP and relational universes according to requirements.
Installed LO extractors for inventory management.
Developed complex queries for inventory management.

Summary

9+ years of experience in analysis, design, and development of various SAP HANA XSA, HANA Cloud, SAP BW/BO, and SAP BODS.
Worked on projects in Waterfall and Agile methodology.
Rich experience in standard and custom developments to fulfill business requirements.
Proficient in SQL and used in different environments and tools.
Created data models in all projects and worked closely with data architects.
Proficient data visualization using open-source technologies and licensed ones.
Experience in working with multiple vendors and geographically distributed teams.
Hands-on knowledge of predictive and statistical modeling in R, understanding different SAP Modules and Add-ons like FI, CO, MM, ISU, Vistex, and ISU-EDM.