Data Analyst Power Bi

Aniket Anil Raut

****************@*****.*** https://www.linkedin.com/in/aniket-raut18/ https://github.com/aniketraut18 A results-oriented Technical Data Analyst with 3 years of experience enhancing operational efficiency and driving strategic decisions. Skilled in statistical analysis, hypothesis-led analysis, data storytelling, and data-driven decision-making. Experienced in synthesizing complex data into impactful insights for stakeholders. Proficient in Python, R, SQL, and tools such as Power BI, Alteryx, Azure Analytics (Databricks), SSIS, SSRS, SSMS with a passion for solving real-world problems through data analysis and visualization. EXPERIENCE

Management Analyst, Express Mart, US (Part-time (Student Employee)) Aug 2022 – May 2024

• Optimized inventory tracking, reducing stock discrepancies by 20% and improving order accuracy by 15%.

• Supervised 15 associates to analyze sales data and adjust shelf layouts, increasing product visibility by 25% and quarterly revenue by 10%.

• Developed a customer traffic model, improving service metrics by 18% and reducing wait times by 25%. Data Analyst, Tech Mahindra, IND (Technologies: KNIME Tool, Oracle DB (12c, 11g), Power BI) Aug 2019 – July 2022

• Led ETL workflows and data integration, improving model accuracy by 8% through data validation and governance.

• Streamlined data pipelines and enhanced SSIS ETL processes, ensuring accurate data flow and improving reporting efficiency.

• Optimized machine learning model performance by 5%, enhancing predictive analytics and operational efficiency.

• Executed advanced SQL queries in Oracle DB, utilizing business intelligence tools like Power BI and SSRS, leading to a 20% improvement in customer engagement strategies.

• Conducted regression analysis and hypothesis testing on 500,000+ records, uncovering trends that guided strategic business decisions.

• Created data models and delivered weekly Power BI reports, driving a 30% surge in customer engagement by providing actionable insights that influenced strategic decisions and operational performance.

• Directed the development of tailored AIOps solutions for over 20+ clients, leading to a transformative shift towards AI-driven IT operations and high project quality standards.

• Documented 5+ data pipelines architecture and procedures, improving clarity and reducing onboarding time by 15%. Data Services Trainee, RK Projects, IND (Technologies: Excel, CRM, Oracle DB) June 2018 – Dec 2018

• Enhanced SQL query efficiency for student data, speeding up the process by 30% and improving data analysis for customer trends.

• Analyzed educational data with Python, identifying key insights reported in Excel, resulting in a 10% improvement in engagement strategies.

• Automated routine data validation, decreasing data preparation time by 30%, allowing focus on in-depth analysis & strategic insights. ACADEMIC EXPERIENCE

• AWS-Sage Maker: Mobile Price Prediction ML Model Mar 2024 – Apr 2024

- Technologies: AWS, Python, Pandas, NumPy, Matplotlib, Seaborn.

- Implemented an end-to-end machine learning pipeline on AWS Sage Maker, improving model accuracy by 10%.

- Deployed the trained model as a scalable endpoint, enabling real-time predictions and reducing inference latency by 20%.

• IBM Watson Market Analysis: Transforming Data into Strategic Insights Jan 2024 – Feb 2024

- Technologies: Python, Scikit-learn, Pandas, NumPy, Matplotlib, Seaborn.

- Conducted in-depth financial data analysis, identifying KPIs and trends, improving operational efficiency by 20%.

- Engineered a predictive analytics model using ML algorithms, enhancing investment strategy decisions, improving forecast accuracy by 5%.

• Dine-Smart Analytics: Streamlining Food Delivery for Enhanced Customer Satisfaction Dec 2023 – Jan 2024

- Technologies: Python, Pandas, NumPy, Matplotlib, Seaborn, Scikit-learn, SQL.

- Analyzed delivery timelines using statistical analysis, reducing delays by 15%, boosting customer satisfaction.

- Overhauled 'Food Hub' platform using data visualization, decoding ordering patterns, increasing weekend orders by 20% through promotions.

EDUCATION

Master of Science in Computer Science – George Mason University, Fairfax, VA, USA August 2022 – May 2024 GPA 3.5/4.0 Bachelor’s in Computer Engineering – Savitribai Phule Pune University, Pune, MH, IND June 2015 – May 2019 GPA 3.4/4.0 TECHNICAL SKILLS

• Programming Languages: C, C++, Java, Python, R, SAS

• Tools: Power BI (DAX, Power Query), Tableau, CRM, Microsoft Excel, Jupyter Notebook, Apache Spark, Hadoop, Databricks, KNIME, SSIS, SSRS, SSMS, Alteryx, Jira, Google Analytics, Siebel-CRM, Oracle (12c, 11g), MySQL, MongoDB, Snowflake, AWS, Azure, Microsoft Power Apps

• Technical Competencies: Data Science, Data Analytics, Machine Learning, Data Engineering, Statistical Analysis, A/B Testing, ETL, Data Transformation, Data Modeling, Data Mining, Data Warehousing, Business Intelligence, Data Reporting, Agile Project Management. CERTIFICATIONS

• Amazon Web Services Cloud Practitioner (f7fd1495c31841b5b5ba52c3042b7c66)

Contact this candidate