Arpit Gupta Email & Phone Number

Canada

Canada

Ottawa, Ontario, Canada

• Officer, Order to Cash Analytics for Transactional Finance Team at Canada Post Corporation (CPC).• Gather requirements, design the functional layouts and specifications, draft user requirement documents.• Develop Power BI data Models, Data Preparation with Data Flows and designing Power BI reports• Great experience in consuming data from different sources and designing the Power BI Data Models.• Proven experience in writing DAX expressions and Power Queries using M Language.• Excellent knowledge of Data transformation in Power BI to ensure the highest optimization.• Working on multiple data queries and creating the relationship using Data Model and by joining the data queries.• Excellent experience working with Power Automate. Saving the email attachments to a specific shared location, processing files for Power BI reports, sending the email alerts, creating the backups, deleting the old files, exporting the data, and sending files as an attachment to name a few.• Design the KPIs for various teams, managers, and directors, and present the analysis in the GM’s meeting on a monthly basis. Elicit feedback from each director on monthly KPIs.• Replicated old Tableau reports to Power BI, and ensure the data integrity, report refresh frequency, subscriptions, and other related functionalities.• Experience in presenting new dashboards to a larger audience (200+ people) and explain features, benefits, and new capabilities which can save a lot of time.• Automated a lot of manual work using Power BI and Power Automate, which saves more than 10 hours of weekly work done by different managers in the organization; from receiving the raw data files in email to saving the files, apply transformation, cleaning the data, creating the required visuals and tables, refreshing the reports, subscribing the users to receiving the clear exported data in their email on a daily or weekly basis.

Hyderabad, Telangana, India

• Data Analyst for Global Financial Planning and Analysis (FP&A) Team.• Design and delivery of fact-based reports and dashboards by using Power BI, Tableau, Alteryx, SAP Web Intelligence, Cognos, advanced excel, etc.• Gather requirements, design the functional layouts and specifications, draft user requirement documents.• Extract raw data from the FDW using SQL queries and format the data accordingly by using Alteryx data preparation/cleansing tools and then publish clean data to Tableau / Power BI / SAP Webi to create interactive visuals.• Design interactive Tableau / Power BI data visualizations using cross tabs, maps, bars, line charts, pie charts, graphs, scatter plots, tornado charts, Cards, Slicers, etc.• Writing Complex DAX functions and M queries into Power BI as per the business requirements.• Writing LOD (Level of Details) expressions and table calculations in Tableau.• Design the complex workflows by leveraging the basic and advanced Alteryx Tools like Macros, RegEx, Interface, Spatial, Data Investigation, Developer, R, Python, In-Database, Predictive, Time Series, Connectors, etc.• Fix the report and data source errors, find the right solutions, resolve the business challenges, and client issues/concerns whenever arises. • Provide recommendations and advice to assist the development team as a thoughtful partner.• Collaborate and communicate strategic priorities and act as a liaison with internal and external partners.• Analyze the risks involved in the reporting projects and provided valuable inputs during the governance calls.• Help the organization to achieve the targets consistently by visualizing the financial data and KPIs.• Evolution of Reporting Suites and Navigation Methods by leveraging the advanced BI tool features.• Awarded 6 times for the contributions towards the company’s growth and other achievements.

Greater Chennai Area

• TM1 Lead.• Responsible to deliver all TM1 designs on time.• Create interactive Reports and Dashboards using TM1 Perspectives and advanced Excel features.• Write complex TurboIntegrator (TI) Process using SQL Queries and Business Rules using Skipcheck and Feeders.• Publish the reports on the TM1 Web server and share the visuals to analyze the financial progress.• Provide strategic directions to the management through critical thinking.• Provide excellent L2 support and address key business issues in the production environment as they arise.• Automate the tasks and processes by scheduling Chores on the server.• Contributed to the Cognizant EPM Team during 04/2016-03/2017 which resulted in FY Profit Margin growth of 15.71%.

Master Of Technology - Mtech, Automotive Electronics

University Projects: • Data Processing: Automatic Object Counting in Real-Time • Data Processing: Traffic Sign Clustering and automate.

Bachelor Of Engineering - Be, Eectronics & Cmmunication Engineering

University Projects: • Electronic Circuit: Automatic Staircase light switch ON and OFF in Real-Time