Summary
Overview
Work History
Education
Skills
Websites
Certificationsandawards
Software
Certification
Timeline
SHREY TANDON

SHREY TANDON

Mcdonald,PA

Summary

Motivated Team Lead possessing excellent leadership and planning abilities. Focused on delivering high-quality products on tight schedules. Monitors, trains, and encourages employees to improve skills and meet demanding targets. History of successfully developing and managing strong teams through proactive training and issue management. Versatile Business Operations Specialist with background in optimizing operational processes and implementing effective business solutions. Skilled in project management, strategic planning, and process improvement, consistently delivering results that drive efficiency and reduce costs. Strong analytical abilities and problem-solving skills contribute to successful project outcomes and positive impacts on overall business performance.

Overview

13
13
years of professional experience

Work History

Senior Enterprise Analytics Analyst

Stantec Consulting Ltd.
12.2024 - Current
  • Led diverse team across multiple regions in workflow supervision.
  • Expanded SaaS model to new internal clients.
  • Identified top performers in service for inter-regional collaboration.
  • Directed extensive monitoring of service usage.
  • Coordinated, delegating and executed testing for software releases utilizing Jira and QTest.
  • Optimized processes by delegating tasks as per priority and workload.
  • Supervised the review process to maintain quality standards across all instructional material provided to clients.
  • Collaborated proactively with cross-functional delivery teams for the creation of new subject areas.
  • Collaborated with cross-functional teams on projects related to analytics initiatives.
  • Prioritized and organized tasks to efficiently accomplish service goals.
  • Evaluated needs of departments and delegated tasks to optimize overall production.
  • Identified areas for improvement, narrowing focus for decision-makers in making necessary changes.
  • Analyzed large datasets with statistical methods and software programs.
  • Worked with cross-functional teams to achieve goals.

Agile Team Lead

Stantec Consulting Ltd.
08.2023 - Current
  • Directed Agile team, oversaw Kanban board and JSM board to streamline workflow.
  • Facilitated daily stand-ups, retrospectives, and workshops to boost team collaboration.
  • Guided team members to enhance skills and ensure project success.
  • Led automation implementation for Jira Service Management, significantly decreasing manual tasks.
  • Directed efforts to improve cross-departmental collaboration in Jira workflows, enhancing project delivery efficiency by 25%.
  • Directed and facilitated discussions for innovative problem-solving in Agile Team Lead communities.
  • Led Agile Team Lead meetings, fostering continuous improvement.
  • Implemented enhancements in Kanban workflows, achieving faster task completion and smoother operational flow.

Enterprise Analytics Analyst

Stantec Consulting Ltd.
10.2021 - 12.2024
  • Proven history of collaborating with delivery teams for improved efficiencies and outcomes for internal clients globally
  • Single point of contact for NA/UK region for our internal client base
  • Transitioned ANZ clients to new team members successfully to scale service
  • Built the internal client service base from 2-3 users to over 170 users growing at almost 4-6 users per week currently for our service
  • Built an external-facing SharePoint site for users of the service and hands-on labs to educate users
  • Testing the Jira Service Management tracking system and its linkage in the new SharePoint
  • Trained pilot users on DV & presented use cases for visuals in DV
  • Excellent working relationships with internal clients built on referrals
  • Proactive in engaging with clients, discovering performance inefficiencies and addressing them with delivery teams
  • Proof of Concept built in the analytics tool for delivery teams and assessing the priority of use cases in the backlog
  • Helped to propel self-service using the 'Train the Trainer' model
  • Worked with Oracle and internal technical team for access, bug fixes and service improvements
  • Awarded Green Ribbon Level certificate by Oracle for idea generation & knowledge sharing
  • Collaborated the roll out of the enterprise analytics service in Oracle Data Visualizer (DV)
  • Onboarded new team members to the Enterprise Analytics Service processes and tools
  • Tested security and access for the Jira service management and SharePoint
  • Created DV projects/ workbooks /datasets and data flows for usage tracking for dashboards
  • Great presentation skills and have engaged internal clients on a small and large scale in groups from 5-70
  • Excellent interpersonal skills and have had detailed one-on-one sessions since the pilot phases of the service
  • Pivotal in creating DV workbooks for Projects, Finance and Marketing groups globally
  • Active member of Employee Resource Groups

Data Analyst

Alberta School Employee Benefit Plan (ASEBP)
Edmonton, Canada
05.2019 - 10.2021
  • Revamped trustee reporting package creating Power BI dashboards at the annual, semi-annual, and monthly level, which were very well-received
  • Received accolades for the Client Experience reporting for the Zone and pool level Client Experience reports
  • Had the opportunity to present the Client Experience dashboard as part of our BIS team efforts, which was very well-appreciated
  • Pioneering work for row-level security at dashboard level for the Orbit KPI dashboard applauded
  • Received several kudos from internal clients for collaboration and innovation
  • Provide guidance and share expertise with all levels of the organization
  • Supervise process and production of periodic daily/ monthly/ quarterly performance and management reports and analyses
  • Created several Power BI dashboards for clients, particularly for Spending Accounts, Orbit ticket status, Plan Administration, Short-Term Disability and Extended Disability
  • Designed and optimized SQL queries to optimize report execution
  • Provided training and direct support to clients

Business Intelligence Analyst

Alberta Investment Management Company (AIMCO)
Edmonton, Canada
09.2016 - 04.2019
  • Propelled SaaS for Power BI through training and ongoing support
  • Responsible for producing and enhancing functional requirements documentation based on client requirement
  • Created Power BI dashboards for clients, particularly for the Fixed Income, Treasury, Compliance, CFO, Money Market, and Equities group
  • Created high-profile dashboard for internal audit to catch double-dipping
  • Develop reporting, integrity checks, presentations, and processes to effectively report critical business functions
  • Project Rooster: To automate integrity checks daily using Python
  • Creating automation SQL pro's for Rooster project
  • Creating time locks to manage deadlocks with other processes
  • Single point of contact for data integrity
  • Run daily integrity checks using SQL queries & stored procedures
  • Created the Reporting Dashboard in Power BI for the team
  • Implemented several data mart optimization initiatives
  • Tuned SQL queries to optimize database performance
  • Phased out redundant reports in consultation with clients

Manager, Market and Customer Insights

Sobeys Point West
Edmonton, Canada
03.2015 - 03.2016
  • Company Overview: pre-merger with Safeway
  • Present Flyer Scorecards analytics weekly and promotion analysis for senior directors and executives
  • Managing the Flyer forecasting process for the front and the back page of weekly flyer and wrap
  • Used SAS Enterprise Guide to find the 13-week average sales and household sales for each ad on front/back of flyer
  • Customer segmentation analysis for RFV for each ad spot on front/back page of flyer
  • Predicting the Customer segmentation for each ad spot on front/back page of flyer
  • Pioneered concept of analyzing impact of customer demographics on merchandising and promotion
  • Created Stored Processes and Programs in SAS Enterprise Guide
  • Developed SAS Macros for various analyses
  • Change Management: Managed the harmonization process for Market and Customer Insights department as Sobeys and Safeway merge into the West Business Unit
  • Provided retail specialists with customer segmentations by store to apply appropriate merchandising and promotions for stores in Western Canada
  • Onboarding for processes & documentation followed by team at Sobeys with Safeway
  • Provided on-the-job training for analysts in Sobeys for SAS Enterprise Guide
  • Pre-merger with Safeway

Project Intern

Utility Client
Tulsa, USA
01.2012 - 09.2012
  • Predictive Model designed to predict which locations would be most profitable for new kiosks
  • Extensively used SAS Enterprise Miner, SAS Enterprise Guide and JMP for the project
  • Well-received by the clients for business objectives and planning

Consultant

Capgemini Consulting India Pvt. Ltd.
Mumbai, India
10.2005 - 04.2007
  • Conducted pre-sales activities to bid to clients/customers to promote Capgemini's products with continuous support for clients in Europe
  • Developed the main premises to pitch for prospective clients and provided ongoing analytical support to explore client background
  • Trained new consultants entering the team about market research techniques, data gathering, and analysis and insight generation
  • Company and industry analysis for clients on financial, market & brand parameters and competitor activity
  • Tracked company and industry analysis for clients on financial, market and brand parameters
  • Generated sector-wise monthly newsletters for the financial, manufacturing, automotive and retail sectors in Europe
  • Published online monthly and weekly industry-wise newsletters for clients in Europe
  • Maintained and updated database of leads of prospective customers
  • Underwent training at Munich, Germany for a month to imbibe consulting practices, pre-sales activity engagement activities and real-time consulting and marketing practices for clients/customers

Junior Marketing Manager

JSW Steel Ltd.
Mumbai, India
05.2004 - 04.2005
  • Performed key account management in the domestic region
  • Coordinated with marketing heads in each region and the VP, Marketing to track the level of satisfaction with the customers
  • Communicated quality issues from customers to Marketing Managers & technical team
  • Tracked the satisfaction of the key accounts with our products
  • Worked at finding new prospects
  • Trained new junior marketing managers at the other locations
  • Actively involved to prepare the Annual Business Plan for 2005-06
  • Prepared presentations on World Steel Sector for VP, Marketing
  • Prepared daily domestic price reports for steel, raw materials (coke and limestone), billets & scrap
  • Public communication with customers
  • Coordinated a Steel Museum at manufacturing plant for steel coils
  • Coordinated with Indian Market Research Bureau and domestic marketing heads to survey major customers to determine their satisfaction levels with Jindal and our competitors
  • Prepared Monthly Information System reports tracking key account activity for top management

Education

GRADUATE CERTIFICATE - BUSINESS DATA MINING

Oklahoma State University, OK, USA
12.2011
  • Hands-on courses to develop in-depth skills in data mining.
  • Learned data mining techniques using SAS and JMP.
  • Mentor students at OSU as an alumni
  • GPA: 4.0

MASTER OF ARTS - ECONOMICS

University Of Pune, Pune, India
01.2005
GPA: First Division

POST GRADUATE DIPLOMA - MANAGEMENT (MARKETING & OPERATIONS)

Symbiosis Institute of Management Studies, Pune, India
04.2004
  • Full tuition scholarship for standing first in SIMS entrance examination.
  • GPA: Distinction

Skills

  • Strategic Planning
  • Task delegation
  • Performance monitoring
  • Trend tracking
  • Work assignment delegation
  • Stakeholder management
  • Process improvement
  • Product management
  • Diversity and inclusion
  • Change management
  • Employee training
  • Conflict resolution
  • Coaching and mentoring
  • Influencing skills
  • Relationship building
  • Key performance indicators
  • Workflow management
  • Client communication
  • Attention to detail
  • Financial acumen

Certificationsandawards

  • Disciplined Agile Scrum Master (DASM), PMI, 08/01/23
  • Microsoft Certified Solution Associate - MCSA- BI & Reporting, 02/01/20
  • Certified BI Professional Certification - CBIP, 10/01/18
  • Investment Foundation Certificate by CFA Institute, 11/01/17
  • SAS Certified Predictive Modeler using SAS Enterprise Miner 6.1, 01/01/11
  • SAS Certified Programmer using BASE SAS 9., 01/01/11

Software

SAS

SQL

Python

SSRS

GitHub

Jira

Confluence

Agile Team Lead

SSMS

Oracle Data Visualizer

OBIEE

Oracle Analytics

Certification

  • Certified ScrumMaster (CSM) - Scrum Alliance.

Timeline

Senior Enterprise Analytics Analyst - Stantec Consulting Ltd.
12.2024 - Current
Agile Team Lead - Stantec Consulting Ltd.
08.2023 - Current
Enterprise Analytics Analyst - Stantec Consulting Ltd.
10.2021 - 12.2024
Data Analyst - Alberta School Employee Benefit Plan (ASEBP)
05.2019 - 10.2021
Business Intelligence Analyst - Alberta Investment Management Company (AIMCO)
09.2016 - 04.2019
Manager, Market and Customer Insights - Sobeys Point West
03.2015 - 03.2016
Project Intern - Utility Client
01.2012 - 09.2012
Consultant - Capgemini Consulting India Pvt. Ltd.
10.2005 - 04.2007
Junior Marketing Manager - JSW Steel Ltd.
05.2004 - 04.2005
Oklahoma State University - GRADUATE CERTIFICATE, BUSINESS DATA MINING
University Of Pune - MASTER OF ARTS, ECONOMICS
Symbiosis Institute of Management Studies - POST GRADUATE DIPLOMA, MANAGEMENT (MARKETING & OPERATIONS)

Similar Profiles

CREATE PROFILE
SHREY TANDON