Summary
Overview
Work History
Education
Skills
Technical Skillset
Summary Of Experience
Software
Certification
Timeline
Generic
SUKALP SHIVAM

SUKALP SHIVAM

Senior Analyst
Bengaluru,KA

Summary

Thorough Senior Analyst with over a 5+ year background in Analytics. Excellent planning, organizational and communication skills. Self-reliant to perform analysis and make recommendations. Talented in data modeling and client management.

Overview

6
6
years of professional experience
22
22
years of post-secondary education
3
3
Certifications

Work History

Senior Analyst

Factspan Analytics
05.2019 - Current
  • Worked for leading cybersecurity firm in analytics team
  • Designed and deployed Tableau dashboards, including the Conversion rate dashboard, ensuring timely updates and accessibility for stakeholders
  • Utilized Python's analytical libraries including Numpy and Pandas to automate diverse manual tasks, resulting in a remarkable reduction of processing time by over 50%
  • Automated multiple reports end-to-end, reducing dependency on team members and streamlining processes
  • Developed a Conversion rate dashboard to monitor and analyze conversion metrics across various channels and regions.
  • Leveraged Azure database and advanced SQL queries (e.g., temp tables, window functions) for data retrieval and analysis
  • Pre-Post analysis carried out for millions of data entries and performed data analysis using Excel
  • Implemented a Jira dashboard for efficient task tracking across various projects
  • Provided analytical support to businesses by interpreting datasets, analyzing results using statistical techniques, and generating key business reports
  • Engineered an automated QC tool in Excel, significantly reducing manual processing time from 45 minutes to 2 minutes
  • Developed an automated framework for spend reports across different channels and regions, enhancing data accuracy and reporting efficiency
  • Conducted root cause analysis, bug detection, and reporting to engineering teams, facilitating timely issue resolution and delivery planning through impact analysis
  • Optimized project management, resulting in timely deliverables and improved client satisfaction rates
  • Played a pivotal role in the successful completion of high-stakes projects by providing crucial analytical support and insights
  • Updated and developed scripts and queries to extract and analyze data from multiple sources
  • Implemented Python automation to streamline daily Affiliate reports, reducing dependencies and significantly decreasing overall processing time
  • Identified patterns and trends in large data sets and provided actionable insights.

Data Analyst

Pacecom Technologies Pvt Ltd
02.2018 - 11.2018
  • Worked on live videos to collect data and understand the pattern
  • Analyzing the overtaking speed of different types of vehicles using Excel
  • Generating KPI reports for the client, where using pivot tables to understand the different scenarios for different types of roads
  • Analyzing the impact of weather and road type with the driving speed using the ANOVA test done in Excel
  • Analyzing the relative speed of different vehicles and understanding the optimum host velocity to avoid accidents
  • Managed large-scale databases to ensure timely access to critical information for key stakeholders.
  • Understanding the different emergency scenarios where the driver less car can use the given inputs to save lives and drive safely.
  • Maintained up-to-date knowledge of industry trends and advancements in data analytics, enhancing the adaptability of solutions provided.

Education

B.Tech - Electronics And Communications Engineering

CUTM
Khorda, Odisha
04.2012 - 04.2016

Post Graduation Diploma in Data Science - Data Science

Greta Lakes Institute of Management
Bengaluru, India
04.2001 - 05.2019

Skills

Analytics program experience

undefined

Technical Skillset

Analytics, Business Analysis, Reporting, Automation, Tableau, Power BI, Databricks, Advanced Excel, Gitlab, VBA, Alteryx, Pentaho, SQL, Python, Jira, Confluence, SharePoint

Summary Of Experience

An accomplished analyst with over 5 years of expertise in dissecting market trends, conducting in-depth market analysis, and deriving actionable insights from data to propel innovative business solutions. Possesses an excellent understanding of business operations and proficiently utilizes analytics tools for effective data analyses. Demonstrates the ability to solve complex problems and excels in fast-paced and challenging roles.

Software

SQL Server

Tableau

Python

Altryex

Power BI

Certification

Tableau Desktop Specialist

Timeline

Python PCEP

02-2024

Alteryx Designer Core Certification

08-2023

Tableau Desktop Specialist

01-2023

Senior Analyst

Factspan Analytics
05.2019 - Current

Data Analyst

Pacecom Technologies Pvt Ltd
02.2018 - 11.2018

B.Tech - Electronics And Communications Engineering

CUTM
04.2012 - 04.2016

Post Graduation Diploma in Data Science - Data Science

Greta Lakes Institute of Management
04.2001 - 05.2019
SUKALP SHIVAMSenior Analyst