Data Analyst

Adheesh Ghotikar

+1-716-***-**** *********.********@*****.*** github.com/adheesh1408 linkedin.com/in/adheeshg Experience

S & S Tecnomark, Data Analyst Hyderabad, India Apr. ‘24 – Jun. ‘24

• Conducted competitor pricing analysis for reverse e-auctions using historical tender data, helping secure a 1.5 Crore INR government contract through optimized bid placement strategy.

• Estimated raw material requirements for 5,000 units/month and built dashboards to track Cost per Unit, improving inventory plan- ning accuracy and reducing excess stock by 20%.

• Queried and transformed 10,000+ procurement and production records using Python and SQL, identified cost leakages, and auto- mated attendance tracking with Excel VBA, reducing manual entry time by 70%. ADP, Associate Data Analyst (Member Technical) Hyderabad, India Jul. ‘22 – Apr. ‘24

• Transformed and cleansed large datasets using advanced SQL (joins, CTEs, functions); streamlined structured data publishing via MuleSoft APIs, accelerating downstream deliveryby 30%.

• Collaborated cross-functionally with global stakeholders and VPs to gather requirements and deliver data solutions aligned with business objectives; mentored new analysts to strengthen team capability.

• Developed an automated vendor testing system using Java and Selenium, saving 3+ hours of manual effort daily and significantly reducing errors.

• Investigated regional failures in scheduled calling tests using Splunk dashboards; diagnosed and resolved issues in PHP code to restore functionality with minimal disruption.

Education

New York MS, Management Information Systems 3.93/4.0, University at Buffalo (The State University of New York) Jul. ‘24 -Jun. ‘25 India Bachelor of Engineering, Computer Science First Class with Distinction, Osmania University Aug. ’18-Jun. ’22 Projects

Bike-Sharing Data Analysis Python, Tableau Feb ’25

• Analyzed and cleaned 1.9M+ bike-sharing records using Python, Pandas, and data transformation techniques to ensure high data quality.

• Created an interactive Tableau dashboard with interactive slicers, filters, and moving averages that revealed a 50% surge in peak usage during optimal weather, enabling actionable trend and seasonality insights for operational decisions. Hospitality Domain Data Analysis PowerBI Jan ’25

• Wrangled and transformed raw data end-to-end using Power Query, reducing weekly processing time by 2 hours and ensuring near- perfect data accuracy for reporting and analysis.

• Developed key performance metrics (DSRN, RevPAR, Realization%) using DAX, which enhanced revenue forecasting and operational planning, leading to a 15% increase in actionable insights. Stock Portfolio Management System PostgreSQL, Python, Tableau Aug ’24

• PioneeredadatainfrastructureusingPostgreSQL,highlightedbyanexhaustiveERD,whichsupportedthecreationofthreeinteractive Tableau dashboards for real-time data visualization.

• Expedited data input processes by engineering Python scripts that extracted data from external APIs, minimizing manual errors and accelerating processing by 30%.

• Created advanced SQL queries and Tableau dashboards to track KPIs like price-to-book ratio and average closing price,accelerating data-driven investment strategy adjustments by 15%. Retail Insights Data Warehouse OracleSQL, Tableau, Python Sept ’24

• Designed and deployed a cloud-based data warehouse in Oracle Autonomous DW with 10+ optimized tables; built ETL pipelines in Apache Hop to integrate 1,000+ transactional records using dimension lookups and early-arriving fact handling.

• Engineered a 4,000+ row date dimension with hierarchical attributes and surrogate keys to enable efficient time-series analysis and support star schema architecture.

• Developed interactive Tableau dashboards to track sales trends, highlight top-performing customers, and visualize YoY changes across product categories.

Skills

Data Analysis ETL, KPI Reporting, EDA, Data Integration, Data Wrangling, Data Visualization. Tools PowerBI,Tableau, Excel, IBM Cognos, Splunk, Jira, Confluence. Databases MySQL, PostgreSQL, MongoDB, Oracle Cloud, Snowflake. Languages/Libraries Python, NumPy, Pandas, Selenium, PHP, Java, C/C++. Certificates

Jan. ’25 Microsoft Certified: Power BI Data Analyst Associate, Microsoft Learn Jun. ’24 IBM Data Analyst Professional Certificate, Coursera Jun. ’24 Data Analyst Capstone Project, Coursera

Apr. ’24 SQL - MySQL for Data Analytics and Business Intelligence, Udemy

Contact this candidate