Data Analyst Business Intelligence

Mamidi Mallika

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

PROFESSIONAL SUMMARY:

Results-driven Data Analyst / Business Analyst with over 4 years of experience in data analytics, business intelligence, and process improvement. Skilled in collecting, analyzing, and interpreting complex data sets to drive strategic decision- making. Proficient in Power BI, Tableau, Excel, SQL, Python, and data visualization. Strong background in business process optimization, stakeholder collaboration, and reporting solutions to enhance operational efficiency. Adept at requirement gathering, troubleshooting data discrepancies, and implementing automation for process improvements. TECHNICAL SKILLS:

Data Analysis & Visualization: Power BI, Tableau, Excel, SQL, Python (Pandas, NumPy, Matplotlib)

Database Management: SQL (MySQL, PostgreSQL), ETL, Data Warehousing

Business Intelligence & Reporting: KPI Dashboards, Data Storytelling, Data-Driven Insights

Process Improvement & Automation: Business Process Mapping, Workflow Automation, RPA

Project Management & Tools: JIRA, Agile, Scrum, Microsoft Office Suite, Confluence

Stakeholder Communication & Documentation: BRD, FRD, UAT, Data Governance PROFESSIONAL EXPERIENCE:

Tec fuji LLC Data Analyst May 2024 – Present

Created dynamic Power BI dashboards and Excel reports to give critical business insights, cutting reporting time by 30%.

Collaborated with cross-functional teams to examine data trends, which resulted in a 15% boost in operational efficiency via data-driven process enhancements.

Led troubleshooting initiatives for data quality concerns, including fixing discrepancies and creating automatic SQL validation checks.

Gap analysis and demand collection for new reporting features were carried out, with the goal of aligning business needs with technical implementation.

Automated data extraction operations with Python and Power Query, saving 20+ hours of manual reporting time every week.

Partnered with stakeholders to translate business objectives into measurable KPIs, ensuring alignment with organizational goals.

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

Designed and maintained Tableau dashboards and Excel reports to track key business metrics and performance indicators.

Analyzed large datasets to uncover insights and recommend business strategies, leading to a 12% revenue increase.

Developed SQL queries to extract and manipulate data from multiple sources, ensuring accuracy and consistency.

Conducted A/B testing to measure the impact of marketing campaigns and operational changes.

Assisted senior leadership with forecasting and predictive modeling, resulting in improved decision-making capabilities.

Worked with IT and business teams to guarantee the smooth integration of data analytics technologies into business procedures.

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

Developed and optimized SQL queries to streamline data retrieval processes, reducing query execution time by 40%.

Provided real-time troubleshooting for software and database-related issues, ensuring minimal downtime and disruptions.

Followed Agile methodologies (Scrum) to manage software development projects, improving team collaboration and project delivery timelines.

Education:

Master of Science in Computer Science from University of Central Missouri, Warrensburg, MO (GPA:3.6) - Dec 2024

Project:

Predictive Sales Model for Retail Inventory Optimization

Developed a machine learning model using Python (Pandas, NumPy) and linear regression, improving sales forecast accuracy by 15%. Implemented the Time series forecasting for sales prediction.

Contact this candidate