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 reporting and data extracting process with the help of BI tools, thereby helping the firm in the reduction of manpower(5:1) and quick predictions.- Experience with unstructured data, star-schema SQL Azure database, Python, Java, MySql, SAS, R, AWS to interpret statistical results. - Working on Alteryx/Informatica tools to extract, transform and load the data. Scheduled them on server for automatic run. - Designed, implemented and published 50+ dashboards using Power BI/Tableau with all securities in place. - Excellent problem solving and analytical skills and a strong sense of structure and logic. - Working as an Anaplan Consultant for financial budgeting and reporting process, pipeline model and workforce planning. - Mentored junior data scientists within my team with complete independent ownership of the projects and the initiatives in the team for project management.

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 requirements for our stakeholders- Finance, Operations and Staffing and helping them to identify the loopholes to bridge the gaps.- Assigned duties to team members with proper sprint planning with help of JIRA tool, helping them in architecting the right model.- Created many workflows in Alteryx as an ETL tool to extarct from source system, applied business logics, shared them in Gallery in Alteryx Server for easy sharing and scheduling.- Designing, creating and implementing BI solutions with Power BI, Tableau etc.- Worked on complex Data Modelling challenges by creating relationships, dimesnion and fact concept.- Created interactive and highly informative BI reports using DAX features and reletable charts,bookmark,cards,table and apply all types of RLS(Row Level Security).- Sharing/Scheduling of Power BI reports and managing workspaces in Power BI service from Power BI Desktop.- Worked on streamlining differenct phases of project through PowerBI ALM toolkit to follow agile methodology.- Have worked on DAX Studio and Tabular Editor 3 for performance related issues and DAX logics.- Worked with various M Power Query transformations in Power Query Editor.- Extensively used different Categories of DAX functions like Time Intelligence Function, Filter Functions, Date Functions, Logical Functions, Text Functions, Number and Statistical Functions for Creating New Information.- Used Trend lines, Reference lines and Statistical techniques to describe data.- Created various views in Power BI like Donut charts, Tree Maps, Heat Maps, Scatter plots.

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 EPM versions to ensure compliances with best practices and change management policies.• Well versed with the Headcount loads for actuals projection monthly and forecasting the data.• Load of actuals data to Employee, Primary and Revenue applications.• Extensive experience on developing calculations scripts to perform the data copies and data deletions in different cubes of the Essbase.• Knowledge on creating forms, rule files, calc scripts and data load rules.• Well versed on HFM metadata properties, Essbase and Planning properties and FDMEE mapping.• Hands on experience in creating data load rules, import formats and jython scripts for importing the data from source to target in FDMEE.• Experience in Manual testing and Data validation in SmartView spreadsheets.• Involved in Preparation of Application playbook and self help documents for the users.• Interaction with the client for requirement gathering, understanding the problems and providing solution to improve client productivity.• Raising SR’s with oracle and working on bugs during technical issues.

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.• Working with offshore, client, onsite teams as part of the project.• Opening of new period in HFM, setting up EA task flows after sign off.• Preparation of monthly metrics and sharing it to client.• Setting up new locations, changing properties in FDMEE and validations.• Analyzing and applying the patches suggested by Oracle.• Working on RCA on P1/P2 issues and PBI management.• Involved in Preparation of Application playbook and self help documents for the users.• Interaction with the client for requirement gathering, understanding the problems and providing solution to improve client productivity.

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.• Generating various SAP BO reports and OBIEEE dashboard reports.• Debugging the issue during the production cycle and quick fix for proper processing of the system during reporting cycles. • Developing technical documents and provided KT to new team member.• Provided application maintenance and enhancement support. • Working on RCA’s for P1/P2 issues and PBI management.

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