Summary
Overview
Work History
Education
Skills
Timeline
Generic

Sandeep Yenni

Memphis

Summary

Seasoned Senior Data Analyst with over 6 years of experience in harnessing the power of data analytics to extract actionable insights. Eager to apply my extensive experience and analytical capabilities to drive data-driven decision-making and add value to an innovative organization.

Overview

8
8
years of professional experience

Work History

Master Data Analyst

Lex Nimble Solutions| Client: AbbVie
10.2022 - Current
  • Collaborate with cross-functional teams, including procurement, production, and supply chain, to gather and analyze data requirements for material master creation and maintenance.
  • Track and monitor materials using SAP S4 Hana to run process reports, execute STO Tracker SharePoint updates and support open projects and provide weekly progress/status updates.
  • Developed dashboards using Power BI, providing insights that allowed management to focus on materials, raising revenue 15%.
  • Responsible for developing ETL pipelines to meet business use cases by using data flows, Azure Data Factory (ADF), Data lake and Snowflake.
  • Utilized R Markdown's flexibility to automate repetitive data analysis tasks,increasing efficiency and productivity in data processing and reporting.
  • Conducted root cause analysis for data discrepancies and implemented corrective actions to prevent future issues.

Senior Solutions Analyst

FedEx Services
04.2022 - 10.2022

Senior Solutions Analyst:

  • Utilize SQL queries and database management techniques to effectively track and analyze shipment data, ensuring accurate and timely information for customer support operational decision-making.
  • Proactively engaged with business unit executives to explore and recommend technology solutions to address current and future business needs, resulting in a 15% increase in operational efficiency.
  • Deep working knowledge of SQL and it tools while sourcing data from multiple sources cleaning, analyzing the data with large amounts of transportation data.
  • Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
  • Created and maintained detailed process flow diagrams, business process models, and requirement traceability matrices to enhance project documentation and communication.

Sales Analyst

FedEx Services
02.2020 - 03.2022
  • Perform ad hoc analysis for management supporting $653,286,520 business in FedEx to drive key business decisions.
  • Designed, developed, and maintained interactive data storytelling Power BI reports, YoY trends and dashboards that provided actionable insights to pitch in more business growth.
  • Played a key role in budgeting processes and conducted thorough cost and savings analyses, optimizing financial strategies.
  • Developed competitive pricing programs by validating customer pricing and ensuring alignment with market trends.
  • Created and optimized data models, implemented complex DAX calculations, and developed custom measures to enable effective data analysis and reporting.
  • Engaged in comprehensive data analysis to identify trends, opportunities, and areas for improvement in sales strategies and customer engagement.
  • Acted as a bridge between technical intricacies and clear communication with non-technical stakeholders by a deep understanding of different customer pricing programs and agreements.
  • Transformed raw data from multiple sources using SQL for clean, structured datasets that were ready for analysis.

Data Analyst Intern

FedEx Services
06.2019 - 08.2019
  • Designed and developed dashboards for FedEx executive management using Power BI to track hours spent on each task by employees.
  • Utilized Power BI to connect with Teradata and extract customer sales transactional information to develop dashboards.
  • Implemented features such as bookmarks, buttons, slicers on each page to easily navigate between pages in dashboards.
  • Implemented Row Level Security on Managers Dashboard to restrict access so that to see only those employees under manager who logs in.
  • Collaborated closely with business stakeholders to gather and understand reporting requirements, ensuring alignment with business objectives.

Application Development Analyst

Accenture Solutions Private Limited
10.2015 - 12.2017
  • Applied advanced sampling & data analytic techniques to help with strategic initiatives, roadmaps & process models.
  • Created presentations in concise & well-researched manner on newproduct feature ideas & opportunities by collaborating with product owners.
  • Leveraged Azure Data Explorer to analyze large volumes of real-time data, providing actionable insights to improve operational efficiency and decision-making.
  • Created and maintained documentation for data pipelines, data dictionaries, and process workflows to facilitate knowledge sharing and transparency.
  • Worked on data modeling and schema design in Snowflake, ensuring data consistency, accuracy, and optimal query performance.
  • Organized activities while handling short-term issues and managed multiple tasks concurrently with multiple deadline.

Education

Master of Science - Management Information Systems

The University of Memphis
Memphis, TN

Bachelor of Technology - Information Technology

GITAM University
Andhra Pradesh, India

Skills

  • ETL: Azure Data Factory, SSIS and Apache Spark
  • Databases: MySQL, Teradata, SQL Server, MongoDB
  • Analytics: Power BI, Dax Studio, Tableau, Excel
  • Data Warehousing: Snowflake, Microsoft Azure, SAP s4 Hana
  • Programming Languages : Python (NumPy , Pandas), R (markdown, ggplots2 and dplyr)
  • Methodology: Waterfall, Agile

Timeline

Master Data Analyst

Lex Nimble Solutions| Client: AbbVie
10.2022 - Current

Senior Solutions Analyst

FedEx Services
04.2022 - 10.2022

Sales Analyst

FedEx Services
02.2020 - 03.2022

Data Analyst Intern

FedEx Services
06.2019 - 08.2019

Application Development Analyst

Accenture Solutions Private Limited
10.2015 - 12.2017

Master of Science - Management Information Systems

The University of Memphis

Bachelor of Technology - Information Technology

GITAM University
Sandeep Yenni