Summary
Overview
Work History
Education
Skills
Accomplishments
Languages
Certification
Timeline
Generic
Deepak Gundaram

Deepak Gundaram

Associate Manager - Implementation
Hyderabad

Summary

Service-oriented Associate Manager with commitment to excellence and more than 8 years of experience. Proven history of efficiency and reliability. contributed Contributed as an Associate Manager at Randstad Offshore Services in Data Analytics & Implementation Services leading a technical team of 10-15 analysts and developers by creating and optimizing data-driven solutions for business performance. Developed and assisted in implementing comprehensive analytic strategies that increased profitability by 25% ROI, by building efficient ETL/ELT process using SQL & Python & automating reports, visualizing data using tools such as Tableau, Looker Studio, Power BI, SQL and Excel. Job primary objective was to ensure in maintaining consistent 100% accuracy and zero deviations in data quality management. Delivered real-time insights to 100+ stakeholders across different domains and functions.

With an overall 10+ years of Experience & 8 years of Professional Experience in data & people analytics with strong expertise in automation & scrum implementation. With a strong background in project management, using Scrum and Kanban methodology and Jira tools. Hands-on Experience in data API integration, cleansing, and manipulation using Power Query, python libraries, VBA code, SQL queries.

Overview

13
13
years of professional experience
7
7
Certifications

Work History

Associate Manager - Implementation

Randstad Offshore Services
01.2021 - 07.2023
  • Developed & Implemented comprehensive analytic strategies aligned with business goals increasing
    profitability by 25% ROI using ETL data modelling & BI Tools like Power BI, Tableau & Looker Studio
  • Trained & Managing a team of analysts & developers in developing 150+ reports, optimizing & maintaining 300+ reports every year in identifying key metrics & performance indicators to monitor business performance
  • Achieving consistent 100% accuracy & zero deviations in Data Quality Management & Report Automation
  • Building ETL Piplelines for batch processing, creating visually appealing, constructive & functional dashboards to perform MOM, YOY analysis, project sales performance, analyze entity & product developments
  • Developing relationships between Fact & Dimensional Tables using Snowflake & Star schema
  • Creating Custom Dashboards, Paginated Reports using Power BI0 and building comprehensive dashboards using Looker Studio for 100+ stakeholders with real-time data insights to identify gaps & key pain areas
  • Partnering with cross-functional teams to understand & develop domain-specific reports & visualization to cater 100+ personalized data solutions, improving forecasting & predictive models
  • Automate Reports using G-Script, VBA macros & automate data migration using Automation Anywhere (RPA)
  • Data extraction, manipulation, append & Data cleansing using Python Libraries, SQL query & Joins, DAX
  • Developing Integrated Solution & tracking the development cycle, analyzing team performance using JIRA & Scrum methodology in Payroll Implementation Project

Senior Data Analyst

Vaco Binary Semantics LLP
10.2019 - 12.2020
  • Working closely with the Business Head to analyze & project data estimates, Building Reports using Power BI, Looker Studio, SQL queries, Google Sheets & Excel, automating them using vba in Mac Environment
  • Visualizing the data using Excel, Power BI, Google Sheets & Looker Studio
  • Creating connections between SQL, Data Studio with Excel, and Google Sheets for data visualization
  • Working with Truly, Intercom Data Base for Data extraction & mining to eliminate data anomalies
  • Creating API connections to feed from Salesforce using Zapier connector & python libraries for data migration
  • Creating Templates using Markdown, HTML & CSS for Built Clients
  • Preparing All Delivery Metrics to understand gaps & entity performance for Director & senior leadership

Senior MIS Executive

PrimEra Medical Technologies
09.2018 - 03.2019
  • Building KPI Dashboards & Reports extracted from SharePoint & SQL Server, In-House CMG Tool (Intranet) using VBA or Power Query, cleansing data & merging tables from different sources using Power Query
  • Create visually compelling Patient History, Hospital Management, etc. dashboards using Power BI
  • Designed End to End complex vba solutions for Logistics & various depts by merging raw source files & create single workable file from different sources viz. different file formats
  • Optimizing SQL queries & vba run time to extract & combine data using joins & develop high volume reports churning millions of rows by power tuning the data & connect to Power BI for live data feed
  • Create BI Dashboards to analyze hospital in & out patient data, Case Denial, Approval, Bill claim & appeal, etc.
  • Prepare BRD, SRD docs using Lucid Charts & Manage workflow using Jira & Scrum acting as Product Owner

Senior Data Analyst

Shell Infotech
03.2018 - 07.2018
  • Identify innovative solutions in Tax & Consulting projects , Migrating users from Exchange to Office 365
  • Working with business research tools such as Factiva, OneSource, FATCA Management, and Intelligize tools etc. for financial analysis, benchmarking, market & company assessment
  • Create MIS reports like Pricing Tools, Global Delivery Reports, and Tax Services Billing Structure, KPI dashboards to analyze On Time Tax Filings & No. of FTE & External WF, etc using excel, PowerBI/Tableau
  • Building a Pricing Strategy & serving as a consultant to internal clients for developing data models using SQL
  • Working with Power Query & Power Pivot to create connections with external databases, automate dashboards, create dynamic pivot charts using Power Query & Power BI to display QTD, MTD, YTD reviews

Freelancer

Unipoint IT Solutions Pvt Ltd
04.2015 - 03.2018
  • Update, track, and maintain data in SharePoint & ParXnet, grant user access & permissions, approve workflow
  • Develop MIS reports for complete HR Cycle viz. attrition, headcount, hierarchy, salary benchmark, employee satisfaction survey, std & dynamic billing rate, etc. using Excel, Tableau, SQL
  • Developing Flow Charts, User Reported Bug Documents, SOPs, Audit & Compliance Docs, Test Case
  • Develop Pharma & clinical mgmt dashboards using Tableau to perform YOY, QOQ, YTD, MTD, QTD analysis
  • Proficient in vba technologies viz. convert excel formulas to macro code, create loops, highlighting color, data split using vba, create user forms, events, connecting to SQL server using vba, etc.
  • Visualizing dashboards to identify -ve trends, create PPTs, present data insights for QTD, MTD, YTD

Process Developer

Genpact
03.2014 - 04.2015
  • Design & develop a BI solution for Thomson Reuters Sales, daily PO & Web cycles/errors count KPIs
  • Create client specific vba forms, create interactive dashboards using Quick filters, Parameters & Measures
  • Building dashboards using to analyze forecasts, and trends with reference lines using Tableau, and PowerBI, Publishing Workbooks by creating user filters so that only appropriate teams can view it
  • Develop Excel reports to automatically import data from diff sources i.e. SAP SRM, TR One Source
  • Create logical-based complex solutions in excel using if & array functions, data validation, conditional formatting, pivot tables/charts using Slicer & Sparkline & visualize data using Tableau, Power Pivots, etc
  • Migrate data from SQL server into Access using connections, etc. & standardize the data import

RTP Specialist

DuPont
01.2011 - 11.2012
  • Develop BI solutions to analyze spend data, production volume for diff materials across regions,
    analyze POs vs invoices generated, team performance KPIs using Excel & Tableau
  • Schedule Daily, Weekly, Monthly reports, create Access User Forms, develop ad-hoc reports using VBA
  • Identify data anomalies, and propose corrections, Perform research on pricing trends & material availability
  • Create MIS reports to analyze Spend Data for Profit %, Cost Incur, material movement & availability
  • Working with Primary & Secondary data using Factiva, D&B, etc to analyze business performance

Education

MBA - Marketing And Human Resource Management

Swami Vivekananda PG College
Hyderabad, India
04.2001 -

Bachelor of Science - Biology

AV College of Arts, Science & Commerce
Hyderabad, India
04.2001 -

Skills

Power BI, Tableau, Looker Studio, VBA, SQL, Python Libraries, Jira - Agile Scrum, Lucid Charts, ETL - Data Modelling, Power Query, Data Management, Market Research, Microsoft Office Suite, Negotiation Skills, Team Management, Project Management, Stakeholder Management, Strategic Planning

Accomplishments

  • Presidents Club Award - Randstad, Mar 2023 For leading best team & being a top performing individual for 3 consecutive years within Randstad
  • Silver Award - Thomson Reuters, Oct 2014 For key contribution in best performing team for driving excellence in Genpact client driven Thomson Reurters P2P Pilot Process
  • Best Team Award - DuPont, Jan 2013 In recognition for key contribution to team success

Languages

English
Advanced (C1)

Certification

Microsoft Office Specialist Expert- Office Excel 2010 Expert - Certiport - A

Timeline

Associate Manager - Implementation

Randstad Offshore Services
01.2021 - 07.2023

Senior Data Analyst

Vaco Binary Semantics LLP
10.2019 - 12.2020

Senior MIS Executive

PrimEra Medical Technologies
09.2018 - 03.2019

Senior Data Analyst

Shell Infotech
03.2018 - 07.2018

Freelancer

Unipoint IT Solutions Pvt Ltd
04.2015 - 03.2018

Process Developer

Genpact
03.2014 - 04.2015

RTP Specialist

DuPont
01.2011 - 11.2012

MBA - Marketing And Human Resource Management

Swami Vivekananda PG College
04.2001 -

Bachelor of Science - Biology

AV College of Arts, Science & Commerce
04.2001 -

Similar Profiles

CREATE PROFILE
Deepak GundaramAssociate Manager - Implementation