Summary
Overview
Work History
Education
Skills
Timeline
Generic

Arva Joshi

Senior Data Analyst
Dallas,Texas

Summary

Skilled Data Analyst with over 5 years of extensive experience in discovering, analyzing, and scoping data requirements to create conceptual and logical data models. Expertise in gathering and analyzing data across diverse business processes, including forecasting, inventory management, logistics, manufacturing, and production capacity, to develop effective production optimization models. Adept at utilizing geographics, POS, pricing, promotions, and e-commerce data to build detailed channel models. Experienced in writing SQL queries, creating reports, working with SAP Data and visualizations with Tableau and Power BI. Proficient in leveraging Microsoft Azure Cloud tools and services for data storage, processing, and analysis, ensuring seamless integration and scalability. Committed to empowering business decision-making through the adoption of data science, business intelligence, and data-driven strategies.

Overview

9
9
years of professional experience

Work History

Sr. Data Analyst

LTIMindtree LTD
07.2020 - Current
  • Conducted independent data analysis and wrote SQL queries as per the business requirements to transfer raw data objects and queries from Microsoft Access and Microsoft Excel to SQL Server and Azure Data Explorer for data manipulation.
  • Harmonized disparate data sources into unified data warehouse, simplifying access and analysis for all departments.
  • Used advanced chart visualizations in Tableau such as dual axis, box plots, bullet graphs, treemaps, bubble charts, and waterfall charts to solve complex problems and create interactive dashboards and visualization.
  • Conducted extensive data profiling to identify trends, anomalies, and exceptions in structured and unstructured datasets, translating business requirements into conceptual and logical data models and supporting business solutions using SQL tools.
  • Worked on report automation to streamline report generation processes using SQL Server Reporting Services (SSRS), Tableau and Power BI based on specific reporting requirements. Worked on implementing data integration modules for Extract/Transform/Load (ETL) function.
  • Expertise in working on Platform as a Service(PaaS) and Software as a Service(SaaS).
  • Worked in Agile methodology by utilizing Azure DevOps Boards as well as ticketing tools like JIRA and ServiceNow.
  • Worked on SAP data with internal Microsoft tools like Jarvis, Applens, Production Dashboards, Event Tracing for Windows (ETW) logs to troubleshoot live end client issues for different PaaS Azure Cloud Services such as Azure Storage, Azure Logic Apps, Azure Service Bus, Azure Event Hub, Azure Event Grid.
  • Leveraged data from POS aggregators to conduct detailed sales performance analysis, helping clients optimize product placement, pricing strategies, and promotional efforts across multiple retail channels.
  • Collaborated with cross-functional teams as well as offshore teams and leadership for discussing analytical trends and participated in decision making in the best interest of the organization.
  • Collaborated with IT to bolster data security measures, significantly mitigating risk of data breaches.

Technology Lead

Infosys LTD
02.2020 - 07.2020
  • Led scrum calls with data analysts and IT team to assist team members with technical difficulties for data related concerns.
  • Worked closely with technology infrastructure teams, development & testing teams in supporting integrated/independent releases, software/hardware upgrades, server upgrades, designed and implemented Extract, Transform, Load (ETL) pipelines.
  • Migrated data to/from staging table in SQL from multiple data sources including Microsoft Access, Microsoft Excel, CSV flat files and other SQL servers.
  • Troubleshot live docker outages and ensure database saved in docker is intact.
  • Provided resolutions using advanced query programming skills for various application issues and conducted root cause analysis.
  • Conducted quality assurance checks to ensure data accuracy and reliability.
  • Used Python packages (Pandas, Numpy, SciPy) for feature engineering and machine learning models.

Data Analyst

Marlabs INC
04.2019 - 02.2020
  • As a part of Interactive Voice Response(IVR) & Computer Telephony Integration (CTI) applications team, provided insights for daily incoming calls and application performance and developed dashboards to proactively identify and improve the customer experience for Verizon.com.
  • Collaborated with business partners and application monitoring teams to deploy and maintain database clusters in production and lower environment for Cassandra, MySQL.
  • Used SQL queries for Verizon Customer data for data manipulation in order to deploy active data clusters in production during weekly and monthly Verizon Release and deactivate and repair inactive clusters using SQL queries.
  • Used to maintain Microservices for IVR applications on Amazon AWS by performing day to day BAU activities for AWS MySQL.
  • Collaborated with the team to automate Tableau reports.
  • Utilized Python scripts to extract data from multiple sources and store them to MySQL for reporting needs.
  • Worked on live alert system for production outage by collecting data for unidentified and unknown activities performed on the AWS clusters.

Software Engineering Intern

Indian Space Research Organisation
01.2016 - 05.2016
  • Worked closely in a team called "Data Repository for Antenna Systems Group"at Space Application Centre which worked on maintaining and developing database structures for live Satellite Antenna Software.
  • Learned basics on requirement gathering by shadowing data scientists.
  • Participated in weekly meetings to shadow senior data scientists in discussion of Satellite Antenna improvement strategies and solutions.
  • Worked in ASP.NET, C# and SQL Server Studio to implement internal ISRO intranet to streamline internal employee communications and maintain database for ISRO employee details.

Education

Bachelor of Technology - Information Technology

Ganpat University
Gujarat, India
05.2001 -

Master of Science - Computer Science

New York Institute of Technology
New York

Skills

Methodologies: SDLC, Agile, Waterfall

Database: MS SQL Server, MySQL, MS Access

Visualization Tools: Tableau, PowerBI, MS Excel

Cloud Platform: Microsoft Azure, AWS, GCP

Python Packages: NumPy, Pandas, Matplotlib, SciPy

Automation Tools: Jenkins

Ticketing Tools: JIRA, ServiceNow, Azure DevOps

Programming Languages: SQL, Python, R, HTML, CSS, JavaScript

Operating Systems: Windows, Linux

Other Tools & Technologies: ETL Pipelines, SQL Server Integration Service(SSIS), SQL Server Reporting Service(SSRS), SAP Data Services, Data Quality, Data Mining, Database Management, Data Manipulation, Data Acquisition and Extraction, Data Cleaning

Timeline

Sr. Data Analyst

LTIMindtree LTD
07.2020 - Current

Technology Lead

Infosys LTD
02.2020 - 07.2020

Data Analyst

Marlabs INC
04.2019 - 02.2020

Software Engineering Intern

Indian Space Research Organisation
01.2016 - 05.2016

Bachelor of Technology - Information Technology

Ganpat University
05.2001 -

Master of Science - Computer Science

New York Institute of Technology

Similar Profiles

CREATE PROFILE
Arva JoshiSenior Data Analyst