Shipra Gupta Email & Phone Number

Gurugram, HR, IN

Gurugram, Haryana, India

- Established and led the Center of Excellence for the firm from the scratch and growing it to a team of 10 members now. - Senior stakeholder management from the requirement gathering phase, developing proof of concepts, data architecture/modelling steps on defining business problems, designing and articulating analytical insights. - Automating the entire.

Gurugram, Haryana, India

- Leading a Team of 10 members for Global Reporting(Centre Of Excellence) within the firm and also working as an Anaplan/Hyperion Consultant.- Working on creating a star-schema Datamart/Datalake for bringing the data at one place for single source of truth.Tools used-Azure DB and Alteryx.- Serve as a point of contact for gathering and defining business.

Gurugram, Haryana, India

• Worked on Creating Financial statement reports such as Income tax, Balance sheet, Owners Equity, Intercompany Matching report etc on SAP BPC via EPM addin along with data validation from S4Hana.
• Worked on creating various Dashboards for finance team via Power BI tool such as Global Practice Dashboard, Staffing report, Partner/Principal Performance Metrics etc.
• Created RLS for employees at practice, region, unit levels etc.
• Developed and implemented set of dashboards/reports/visualizations (Scorecard, KPIs, Charts, Tables, Matrix, Chiclets etc.)
• Translate business objectives into technical requirements.
• Worked on requirement gathering, developing, testing, and presenting various reports/dashboards to higher management.

Gurgaon, India

• Work with accounting and FP&A team with month end close, running the P&L reports, monthly forecast and Annual Plan in Hyperion Planning and Essbase.
• Serve as the primary point of contact for Hyperion Planning and Essbase.
• Setup and maintaining user/group accesses with Shared Services.
• Involved in end to end upgrade from Hyperion 11.1.2.1 to 11.1.2.4 and change of source from legacy GFS to SAP systems.
• Expertise as a Technical consultant in EPM system performance tuning and troubleshooting.
• Extensive experience and proficient in server/application maintenance activities like weekly maintenance of the application, user maintenance activities, security accesses and applying latest patches on WebLogic and.

Bangalore

• The purpose of this project is to report the financial data of the Client. (Worked on Behalf of Tata Consultancy Services Ltd)
• Performing month end activities like service restart, log archival, data audit tables, archiving and maintaining FDMEE tables.
• Handling service requests, incidents and regular smoke test.
• Monitoring daily data loads and metadata loads and fixing errors if any.
• Running adhoc jobs and journals based on business request.
• Providing evidences for SOX Controls Monthly and Quarterly.

Bangalore, India

• The purpose of this project is extract, transform and load data to HFM application. (Worked on behalf of Tata Consultancy Services Ltd)
• Hands on exp on source Analyzer, Mapping Designer, Repository Manager, Workflow monitor and workflow manager.
• Mapping business objectives to existing system and gaps.
• Imported flat files, transformed and loaded into target application.
• Optimizing the mappings by tuning the logic to reduce run time.
• Involved in end to end production monitoring and hence personally interacted with clients to provide business solutions.

Bachelor Of Technology (B.Tech.), Electronics And Communications Engineering

Activities and Societies: Convener at Robotics Club of GBPEC.Literary Head for College FestGraduated with Honors(Branch Topper) Received.

Icse/Isc Board, Science