Data Analyst Power Bi

Data Analyst

Madhusudhan Raju Varnakavi

Denton, TX 940-***-**** *****************@*****.***

Career Summary

Data Analyst at Soft techers LLC, NOV 2024 –present

Results-oriented Data Analyst at Soft techers LLC with strong expertise in gathering and consolidating data from multiple sources—including databases, spreadsheets, and system logs while ensuring data accuracy and consistency through effective cleaning and validation. Skilled in applying statistical and analytical methods to uncover trends, patterns, and actionable insights that support project strategy and business decision-making. Experienced in creating detailed reports, dashboards, and visualizations to clearly communicate findings to stakeholders, facilitating real-time tracking of project progress and performance. Proven ability to collaborate effectively with cross-functional teams such as developers, project managers, and QA professionals to ensure data-driven decisions align with overall project objectives and drive successful outcomes.

Education

Master of Science, Advanced Data Analytics

University of North Texas — GPA: 3.36 — May 2024

Relevant coursework: Data Analysis and Visualization with Excel, Advanced Excel: Power Query and Power Pivot, SQL, Statistics for Data Science and Business Analysis, Data Cleaning and Preprocessing, Tableau or Power BI for Data Visualization, Project Management for Data Analysts.

Bachelor of Engineering, Computer science Engineering

Andhra university — GPA: 3.5 — Mar 2018

Relevant coursework: Algorithms, Data Structures, OOP in Java, Networks, Database, Programming Languages (Python, Java, C++)

Technical Skills

Programming & Scripting Languages:

Python (Pandas, NumPy, Matplotlib, Seaborn, Scikit-learn)

R (for statistical analysis and visualization)

SQL (data querying, database management)

Data Visualization Tools:

Tableau

Power BI

Google Data Studio

Statistical Analysis

Hypothesis testing and regression analysis

Familiarity with ML frameworks like Scikit-learn, TensorFlow (basic)

Databases & Data Management:

Relational databases (MySQL, PostgreSQL, Oracle)

Data warehousing concepts

ETL processes (Extract, Transform, Load)

Tools & Software:

Microsoft Excel (advanced functions, pivot tables)

Jupyter Notebooks

Git/GitHub (version control)

Other Skills:

Strong understanding of algorithms and data structures (from computer science background)

Knowledge of software development lifecycle (SDLC)

Familiarity with Agile methodologies and collaboration tools (JIRA, Confluence)

Professional Experience

Data Analyst

Soft techers LLC, Charlotte, NC— NOV 2024–Present

Data Collection & Integration:

Gather and aggregate data from multiple internal and external sources such as databases, spreadsheets, APIs, and system logs.

Data Cleaning & Validation:

Ensure data accuracy, consistency, and completeness by performing data cleaning, handling missing values, and resolving discrepancies.

Data Analysis & Interpretation:

Apply statistical methods and analytical techniques to identify trends, patterns, and correlations within datasets to support business and project goals.

Reporting & Visualization:

Develop and maintain dashboards, reports, and visualizations using tools like Tableau, Power BI, or Excel to communicate insights to stakeholders clearly and effectively.

Collaboration & Communication:

Work closely with cross-functional teams—including developers, project managers, QA teams, and business units—to align data findings with project objectives and support data-driven decision-making.

Performance Tracking:

Monitor key performance indicators (KPIs) and project metrics to evaluate progress and identify areas for improvement.

Data Documentation:

Maintain thorough documentation of data sources, methodologies, and analysis processes to ensure transparency and reproducibility.

Ad hoc Analysis:

Conduct exploratory data analysis and provide quick insights in response to specific business questions or urgent needs.

Support Automation & Optimization:

Identify opportunities to automate data collection and reporting processes to improve efficiency and reduce manual effort.

Stay Updated:

Keep up to date with the latest data analysis tools, techniques, and industry trends to continuously enhance skills and contribute innovative ideas.

Decathlon sports India, Hyderabad, India — Jan2019– Apr 2021

Data Analyst (Inventory & Forecasting) – Decathlon Sports India

Inventory Data Management:

Collect, clean, and maintain accurate inventory data from multiple retail outlets, warehouses, and supply chain systems.

Demand Forecasting:

Apply statistical models and machine learning techniques to predict product demand, helping optimize stock levels and minimize overstock or stockouts.

Trend Analysis:

Analyze sales patterns, seasonal trends, and customer buying behaviors to provide actionable insights for inventory planning.

Performance Monitoring:

Track key inventory metrics such as turnover rates, shrinkage, and fulfillment efficiency to ensure optimal inventory health.

Collaboration with Supply Chain & Merchandising Teams:

Work closely with procurement, supply chain, and merchandising teams to align inventory plans with business goals and promotional activities.

Reporting & Visualization:

Develop and maintain dashboards and reports that provide real-time visibility into inventory status and forecast accuracy for stakeholders.

Risk Assessment:

Identify potential risks related to inventory shortages or excess and recommend mitigation strategies.

Continuous Improvement:

Suggest process improvements and automation opportunities in inventory tracking and forecasting workflows.

Support Strategic Planning:

Provide data-driven insights to assist leadership in making informed decisions about product launches, discontinuations, and pricing strategies.

Market & Competitor Analysis:

Monitor external market trends and competitor activities to adjust forecasting models and inventory strategies accordingly.

Contact this candidate