Arpit Gupta Email and Phone Number
Arpit Gupta work email
- Valid
Arpit Gupta personal email
• Over 9 years of rich experience in Business Intelligence (BI) reporting tools such as Microsoft Power BI, Tableau, Alteryx, SAP BusinessObjects BI.• Proven expertise in Planning, Budgeting, and Forecasting tools like IBM Cognos Analytics, Cognos TM1 Perspectives, TM1 Web, Planning Analytics (PAX / PAW), Google Analytics.• Certified Professional Scrum Master (PSM1).• End to end management of a reporting intake process from project requirements gathering to production support that includes layout designing, development, and testing through business partnering with various global leaders and stakeholders.• Rich experience in Project Management and implementing the Scrum Framework into the organization.• Enhance user experience, process simplifications, reporting capabilities, automation, and decision making.• Develop analytical and user-friendly production reports using various BI Tools and advanced Excel.• Provide ad hoc and insightful analyses to the management and stakeholders. • Publish the interactive reports on the server and share insights with a large audience to analyze the financial progress.• Communicate the detailed information to the clients based out in the US, Canada, Singapore, and EMEA region.• Collaboration with Business Teams for identifying gaps and translate the functional requirements into simpler terms.• Experience in Data Mining, Data Modelling, Data Cleansing, Data Exploration, and Data Integration.• Experience in extracting large structured and unstructured datasets from multiple data sources like Oracle, Teradata, Cloud, SQL developer, SQL Server, etc.• Experience in Data Warehouse concepts and ETL Tools such as Microsoft SISS, Informatica, Alteryx, SAP, etc.• Part of Audit Programs and R&D Projects to optimize server performance and memory usage.• Gather critical information to analyze the organization’s historical data and assist with future planning, budgeting, and forecasting.• Investigating the complex problems and provide modern solutions through critical thinking.• Manage User Securities in production environments through Identity Access Management (IAM).• Support and track projects by using online tools such as ALM, JIRA, etc.• Regular interaction with multiple users and customers to elicit feedback on the progress and foster collaboration using good verbal and written communication and interpersonal skills in an impactful way.• Influence business to make better decisions faster and provide strategic directions to the management.
Canada Post / Postes Canada
View- Website:
- canadapost.ca
- Employees:
- 23556
-
Manager, Customer Care AnalyticsCanada Post / Postes CanadaCanada
-
Manager, Product AnalyticsCanada Post / Postes Canada Jun 2024 - Present
-
Officer, Order To Cash AnalyticsCanada Post / Postes Canada Jan 2021 - Jun 2024Ottawa, 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.
-
Data AnalystJohnson & Johnson Nov 2017 - Dec 2020Hyderabad, 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. -
Tm1 LeadCognizant Sep 2015 - Nov 2017Greater 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%.
Arpit Gupta Skills
Arpit Gupta Education Details
-
Automotive Electronics -
Eectronics & Cmmunication Engineering
Frequently Asked Questions about Arpit Gupta
What company does Arpit Gupta work for?
Arpit Gupta works for Canada Post / Postes Canada
What is Arpit Gupta's role at the current company?
Arpit Gupta's current role is Manager, Customer Care Analytics.
What is Arpit Gupta's email address?
Arpit Gupta's email address is ar****@****post.ca
What schools did Arpit Gupta attend?
Arpit Gupta attended Vellore Institute Of Technology, Rajiv Gandhi Prodyogiki Vishwavidyalaya.
What skills is Arpit Gupta known for?
Arpit Gupta has skills like Leadership, R, Data Warehousing, Requirements Analysis, Tm1 Architect, Agile Project Management, Microsoft Powerpoint, Cognos, Matlab, Data Analysis, Load, Jira.
Who are Arpit Gupta's colleagues?
Arpit Gupta's colleagues are Joan W, Chelsey Buote, Christine Brault, Branka Arand, Franco Zacchigna, Shayne Taylor, Fleurette Farmer.
Not the Arpit Gupta you were looking for?
-
-
-
Arpit Gupta
Student At Seneca College Ex-Tcs , Ex-Infosys - Devops Senior Associate ConsultantScarborough, On -
Arpit Gupta
Full-Stack Developer | Proficient In C#, .Net, And Azure | Python Enthusiast | Specializing In Ai/Ml Solutions For Intelligent InnovationKitchener, On
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial