Summary
Overview
Work History
Education
Skills
Affiliations
Timeline
Generic

SHARAN KRISHNA SANJEEVAKUMAR

Milwaukee,WI

Summary

3.5+ years of experience in business analysis, business intelligence, and data analysis. I possess a track record of driving actionable insights by meticulously gathering and analyzing data to measure and enhance KPIs. My adeptness in data analysis and problem-solving has consistently driven operational efficiency and strategic decision-making. Proficient in requirements gathering, data analysis, and visualization. I have strong expertise in SQL and data visualization tools. Skilled in cross-functional collaboration. I effectively communicate and engage with teams and stakeholders, delivering data-driven solutions that address challenges and foster informed decisions.

Overview

4
4
years of professional experience

Work History

BUSINESS INTELLIGENCE ANALYST

TROY SOFTWARE INC.
06.2020 - 06.2021
  • Defined e-commerce goals, KPIs, and areas for improvement in collaboration with cross-functional teams.
  • Translated information requirements into effective data solutions, ensuring alignment with business and technical needs.
  • Aligned data initiatives with the broader strategic vision by defining KPIs and business goals in collaboration with cross-functional teams.
  • Leveraged Microsoft SQL Server for seamless data extraction and analysis from diverse sources.
    Designed and executed complex data integration workflows using ETL principles and SSIS.
  • Utilized SSAS to design complex multidimensional data models, enabling advanced OLAP cube development for in-depth business intelligence and informed decision-making.
  • Developed advanced multidimensional data models, specializing in data modeling and pattern recognition.
  • Conducted in-depth data analysis, translated insights into actionable recommendations, and created dynamic visualizations using Power BI.
  • Tools: Microsoft SQL Server, SSIS, SSAS, SSRS, Microsoft Power Query, Google Analytics, Microsoft Power BI (DAX), Microsoft Word, Microsoft PowerPoint.

BUSINESS INTELLIGENCE ANALYST INTERN

KPK FASERV PVT LTD
01.2020 - 04.2020
  • Led an Agile SCRUM project to automate MIS reporting, enhancing forecasting and budgeting accuracy through close collaboration with the development team.
  • Collaborated with leadership teams to identify pain points, establish KPIs, and monitor progress toward meeting service SLAs.
  • Conducted workshops with cross-functional teams to gather business requirements, resulting in the successful delivery of 2 major MVPs within agreed timelines and budget.
  • Efficiently managed complex queries in Microsoft SQL Server, optimizing data extraction and demonstrating expertise in database schemas, tables, relationships, and constraints to ensure data integrity and streamline operations.
  • Generated 8 Qlik Sense reports and dashboards from 5 large datasets, reducing manual reporting by 20 weekly hours and communicated data-driven insights to the product team and non-technical employees.
  • Tools: Microsoft SQL Server, Microsoft Excel, Microsoft Teams, Qlik Sense, JIRA.

JUNIOR BUSINESS ANALYST

TROY SOFTWARE INC.
03.2018 - 12.2019
  • Implemented Agile methodologies and Scrum practices for efficient project development.
  • Conducted comprehensive research, refined business requirements, and communicated effectively with cross-functional teams, ensuring smooth data migration assessments.
  • Constructed and managed work breakdown structures (WBS) using JIRA, reducing project delivery time through seamless collaboration.
  • Developed detailed Business Requirement Documents (BRD), Functional Specification Documents (FSD) and Software Requirement Specifications (SRS) that outlined project scope, features, and functionality.
  • Expertly utilized Microsoft Power BI (DAX) to transform raw data into actionable insights, contributing to increased conversion rates. Collaborated on database integration with Microsoft SQL Server teams, improving data accuracy and retrieval speed
  • Tools: Microsoft Visio, Microsoft Word, JIRA, Microsoft Excel, Microsoft Teams, LucidChart.

BUSINESS ANALYST

TROY SOFTWARE INC.
08.2017 - 02.2018
  • Applied wireframing techniques in Microsoft Visio to enhance user interfaces.
  • Facilitated Joint Application Design (JAD) sessions, extracting insights for customer-centric online shopping experiences.
  • Created detailed reports using Power BI and Microsoft Excel, enabling stakeholders to make informed decisions for improved customer interactions and bridged the gap between technical and non-technical stakeholders.
  • Tools: Microsoft Visio, JIRA, Microsoft Office Suite (Excel, PowerPoint, Word).

Education

Master of Science - Computer Science

University of Wisconsin - Milwaukee
Milwaukee, WI
05.2023

Bachelor of Engineering - Computer Science And Engineering

Sri Ramakrishna Engineering College
Coimbatore, India
08.2020

Skills

  • Technical Skills: Agile Methodologies (SCRUM), Stakeholder Management, Requirements Gathering, Requirements Elicitation (Brainstorming, JAD, Prototyping), BRD, FSD, SRS, Wireframing, Process Documentation, Process Mapping, Data Modeling, Data Reporting, Data Visualization, Business Analysis, Data Analysis, Big Data Analytics, Data Science, Prompt Engineering, Machine Learning (ML), Data Architecture, ETL, Microsoft Power Query, Database Management, SQL Development, Data Warehousing, Project Management, IT Support
  • Programming languages: Python (NumPy, Pandas, TensorFlow, Keras, PyTorch, Matplotlib), MySQL, DAX, R
  • Tools: Microsoft Power BI, Tableau, Qlik Sense, Microsoft SQL Server, SSIS, SSAS, SSRS, Microsoft Visio, LucidChart, Microsoft Excel (Advanced – PivotTable, VBA, advanced formulas and functions, Macro, Charts), Microsoft Office Suite (Word, PowerPoint, Outlook, Teams), Apache Hadoop, Informatica, JIRA, OpenRefine, Git, Workday

Affiliations

  • Organizer at Desi Cultural Student Association, UWM, WI.
  • Head Organizer at English Literary Society, Computer Science Club, SREC, India.

Timeline

BUSINESS INTELLIGENCE ANALYST

TROY SOFTWARE INC.
06.2020 - 06.2021

BUSINESS INTELLIGENCE ANALYST INTERN

KPK FASERV PVT LTD
01.2020 - 04.2020

JUNIOR BUSINESS ANALYST

TROY SOFTWARE INC.
03.2018 - 12.2019

BUSINESS ANALYST

TROY SOFTWARE INC.
08.2017 - 02.2018

Master of Science - Computer Science

University of Wisconsin - Milwaukee

Bachelor of Engineering - Computer Science And Engineering

Sri Ramakrishna Engineering College

Similar Profiles

CREATE PROFILE
SHARAN KRISHNA SANJEEVAKUMAR