CapgeminiStrategy Operations Consultant
Oct. 2017 - Dec. 2018Toronto, Ontario, CanadaAs a Strategy Operations Consultant, I managed multiple clients across Canada and North America by eliciting their business requirements and translating them into technical ones. I collaborated with the Delivery Excellence Business Unit's leadership and played a key role as the Functional Lead in defining dashboard requirements and providing best practices for ETL and publishing data to reports and dashboards. My expertise in creating Business Intelligence reporting solutions involved selecting the right toolset available across the BI suite to publish reports and dashboards to different accounts and also provide data-driven insights and decisions. I developed Excel, Power BI, Tableau, and Rstudio reports, scorecards, and dashboards. I also used Capgemini's proprietary data visualization tool, e-Virtual Visual Management, to create standard KPIs and SLA modules for different accounts across the North American region based on incident data. I analyzed financial data and provided insights to the Delivery Excellence VP regularly and on an ad-hoc basis. I am proficient in using AWS services such as IMA, EC2, S3, and Glue, and GCP services like Big Query, cloud composer, and compute engine. To create financial dashboard stories and custom KPIs using client ticketing data, I utilized R studio and necessary packages. I also created customer surveys and financial dashboard stories using R Studio and the required packages. Throughout my career, I worked with various R packages such as DBI, ODBC, sqldf, readxl, xlsx, dplyr, tidyr, lubridate, ggplot2, plotly, amRcharts, DT, flex-dashboard, Shiny, and leaflet. To showcase my data visualization and dashboarding skills, I have created sample R Dashboards, which can be found at https://vimath2020.s3.amazonaws.com/Sample_DB.html and https://vimath2020.s3.amazonaws.com/CFO_Sample_DB.html.