Data Analyst Power Bi

MALLIKA M

DATA ANALYST

- Location: United States Phone: 816-***-**** Email: **************@*****.***

SUMMARY

Data Analyst with over 4 years of experience in data modeling, analysis, and visualization across diverse industries including retail and healthcare. Proven ability to deliver actionable insights through SQL, Python, and R, significantly improving business performance and operational efficiency. Skilled in creating Tableau, and Power BI dashboards, achieving a 40% reduction in manual reporting time, and enhancing data accessibility for cross-functional teams. Expertise in automating reporting processes, streamlining ETL workflows, and implementing data-driven strategies that cut operational costs by 20%. Committed to leveraging advanced statistical methods and machine learning techniques to optimize data management and support data-driven decision-making.

WORK EXPERIENCE

Techfuji LLC Data Analyst May 2024 – Present

Delivered over 30 interactive Power BI dashboards, resulting in a 40% reduction in manual reporting time and improved data accessibility across cross-functional teams.

Collected data using SQL, performed data cleaning, and generated reports, graphics, and statistical analysis, which helped monitor performance for nearly 90% of the projects.

Applied advanced statistical methods to interpret data, generate reports, and create presentations that convey findings to stakeholders.

Performed data cleansing and manipulation using advanced Excel functions like VLOOKUPs and pivot tables in various data-related tasks.

Engineered PL/SQL statements and stored procedures for extracting and writing data.

Designed and implemented data models to optimize data storage, retrieval, and analysis processes.

Conducted A/B testing and statistical analysis to optimize production processes, contributing to a 5% increase in efficiency.

Tata Consultancy Services (Client: Mars Incorporated) Data Analyst Nov 2020 – Nov 2022

Automated data reporting processes and optimized dashboards for a retail domain client, reducing load times by 50% and enhancing operational efficiency, enabling faster data-driven decision-making.

Executed data-driven strategies that reduced operational costs by 20%, enhancing overall business performance.

Experience in analyzing KPI data to assess performance against targets and identify trends or areas for improvement.

Streamlined the extraction, transformation, and loading of data in more than 15 ETL processes using Microsoft SSIS, resulting in a 30% improvement in the accuracy of sales reports.

Created and maintained comprehensive Tableau dashboards using various visualizations, including heatmaps, bar charts, and line graphs, to track retail performance metrics such as sales trends, inventory levels, and customer demographics, facilitating informed decision-making.

Leveraged Python libraries like Pandas and NumPy for data cleansing and validation and built predictive models using machine learning algorithms to optimize retail sales and inventory management.

Institute and uphold data governance policies to define data ownership, usage, and security protocols throughout the organization.

IBASEIT(Client: Novartis) Software Engineer Feb 2019– Oct 2020

Established and maintained robust CI/CD pipelines, leading to a 30% reduction in deployment times and increasing the reliability of automated builds while minimizing human error throughout DevOps processes.

Successfully executed more than 5 cloud migrations, achieving 40% faster application response times and improved system scalability.

Generated Power BI dashboards and reports, increasing visibility into key performance metrics and defect triage status for informed decision-making.

Collaborated with cross-functional teams (development, QA, operations, Solution Architecture) to streamline workflows, resolve issues, and drive continuous improvement initiatives.

TECHNICAL SKILLS

Programming Languages: R, Python, SQL, Java

Cloud Technologies: AWS, Azure

Packages: NumPy, Pandas, Matplotlib, SciPy, Scikit-learn, Seaborn, ggplot2, Dplyr

Analytics and Visualization Tools: Tableau, Power BI, MS Excel (pivot tables, VLOOKUP, complex formulas), SAS.

Database: MS SQL, NoSQL, PL/SQL, Big Query.

Others: Hadoop, Hive, Data warehousing Process, database administration, Data cleaning, Data Wrangling, Data Governance, Data Mining, A/B Testing,

EDUCATION

Master of Science in Computer Science Dec 2024 University of Central Missouri, Missouri, United States

Projects

Data Analysis and Sales Forecasting for Retail Business

Analyzed 4 years of SKU sales data using machine learning techniques, achieving an R-squared value of 0.85 in sales forecasting.

Developed visualizations (line charts, scatter plots, bar charts) to communicate trends and insights, improving forecasting accuracy by 15%

Contact this candidate