Data Analyst Power Bi

Malisety S

Mobile: 980-***-**** Email: ***********@*****.***

SUMMARY

Data Analyst with 3.5 years of experience driving strategic decision-making through actionable insights. Skilled in data analysis, database design, and business analysis, with experience in transforming large datasets into measurable results. Proficient in SQL, Python, R, Excel, and data visualization tools like Power BI, Tableau, and Google Data Studio. Demonstrates strong abilities in predictive modeling, statistical analysis, and building ETL pipelines across diverse environments. Experienced in working collaboratively with cross-functional departments to support operational efficiency, governance, and enterprise reporting goals. Brings excellent problem-solving, communication, and presentation skills, with a deep understanding of data governance, and exposure to cloud platforms like AWS, GCP, and Azure. Additionally, founded and led Simy Media, delivering client-focused SEO and social media growth strategies demonstrating entrepreneurial initiative, stakeholder communication, and data-driven marketing performance tracking.

TECHNICAL SKILLS

● Programming & Analysis: Python, R, SQL, Pandas, NumPy, Excel, Regex, Statistical Analysis, Predictive Modeling, Scenario Simulation

● Data Visualization: Power BI, Tableau, Google Data Studio, Matplotlib, Seaborn, Excel Charts

● Database Management & ETL: MySQL, BigQuery, AWS Glue, Athena, ETL Pipelines, Data Warehousing, Data Cleansing, Data Transformation

● Cloud Platforms: AWS (Lambda, S3, EC2, Step Functions, CloudWatch), Google Cloud Platform (BigQuery, Cloud Storage, Cloud Functions), Azure (Basics)

● Tools & Platforms: JIRA, SEMrush, Git/GitHub, SharePoint, Jupyter Notebook, Google Sheets, Anaconda

● Other Skills: Data Governance, Business Analysis, CRM Management, A/B Testing, SEO & SMMA Analytics, KPI Tracking PROFESSIONAL EXPERIENCE

VOSYN Inc, USA Feb 2025 – Present

Data Engineer/ Analyst

● Orchestrated the development of 5+ Power BI dashboards to monitor vendor onboarding, pipeline health, and SLA metrics using SQL and Python (Pandas).

● Reduced manual QA effort by over 45% by automating backend validation scripts that ensured vendor data accuracy.

● Delivered integration insights via weekly reports accessed by 6+ cross-functional teams, improving anomaly detection rates by 35%.

● Enhanced vendor accountability through interactive Tableau dashboards that highlighted SLA breaches, contributing to a 25% improvement.

● Improved ETL efficiency by 40% by refactoring pipelines using Python and R for optimized performance.

● Facilitated governance by collaborating with 10+ engineers and PMs to document 30+ metadata attributes for traceability.

● Executed automated data validation workflows using AWS Lambda and S3, increasing scalability and fault tolerance.

● Streamlined incident response by 40% via CloudWatch-based alerts and auto-triggered remediation using AWS Step Functions.

United Airlines, USA Sep 2023 – Aug 2024

Data Analyst

● Established robust SQL checks on finance and operations datasets, boosting vendor integration accuracy by 35%. Oversaw 4 interactive Power BI dashboards monitoring 25+ vendor and SLA KPIs, supporting weekly executive reviews.

● Minimized reporting errors by 40% by transforming and cleaning 1.2M+ vendor records with Python (Pandas, NumPy).

● Introduced a dynamic Excel-based reconciliation tool, decreasing delivery mismatches by 30%.

● Strengthened data delivery performance by 20% through collaboration with 5+ vendor managers and 10+ stakeholders.

● Diagnosed and resolved 15+ critical data quality gaps, accelerating onboarding timelines by 25%.

● Enabled vendor renegotiations by conducting root cause analysis on delivery delays affecting 3 major suppliers.

● Boosted report load times by 50% by migrating dashboards and SQL pipelines to Google Cloud (BigQuery).

● Automated vendor file ingestion using Cloud Functions and GCS, improving large-scale transformation reliability. April 3rd Foods, India Aug 2022 – Aug 2023

Data Analyst

● Engineered SQL pipelines to manage 500K+ weekly records from sales and vendor platforms, cutting delays by 35%.

● Elevated forecast precision by 30% via Excel-based demand models aligned with vendor supply cycles.

● Designed and published Power BI dashboards to track fulfillment rates, delivery issues, and vendor scores.

● Boosted order accuracy by 30% through SQL-driven root cause analysis of 100+ vendor delivery mismatches.

● Enhanced data hygiene by standardizing 500+ vendor profiles across business units and regions.

● Saved 10+ analyst hours monthly by automating Excel reports and Python scripts for recurring metrics.

● Assessed vendor performance through custom-built scoring models across reliability, speed, and quality. Built scalable ETL pipelines using AWS Glue and Athena for streamlined processing of vendor fulfillment feeds.

● Published secure Power BI reports on EC2, enabling centralized access for stakeholders. Digi Bros Pvt.Ltd, India Sep 2021 – Aug 2022

Data/Business Analyst

● Spearheaded the cleaning and transformation of vendor and lead datasets using Python (Pandas) and SQL, enhancing CRM accuracy by 40%.

● Delivered interactive Tableau dashboards for 5+ clients, tracking ROI, click-through rates, and conversion metrics across campaigns.

● Designed automated Excel dashboards for internal marketing teams, cutting manual reporting time by 50%.

● Merged marketing metadata with vendor timelines using SQL views, boosting campaign performance analysis and budget allocation.

● Partnered with stakeholders to present insights that informed data-driven strategies, improving vendor efficiency by 25%.

● Implemented data governance practices by standardizing lead source classifications across platforms. Simy Media, India June 2020 – Present

Freelancing/ Project Based

● Founded and scaled a digital strategy agency, advising SMBs on SEO, SMMA, and data analytics to grow traffic and engagement.

● Leveraged SEMrush to analyze web traffic, keyword ranking, and competitor strategy, helping clients improve reach by 30%.

● Drove 25–30% uplift in client conversion rates through A/B testing, audience trend analysis, and ROI-based campaign optimization.

PROJECTS

Vendor Integration Monitoring Dashboard

● Built an interactive Power BI dashboard with SQL and Excel to track vendor onboarding, SLA compliance, and data quality, improving visibility by 60%.

● Automated error classification and reporting using Python, generating weekly health reports for business teams.

● Delivered an executive-ready Tableau version to support strategic, data-driven decisions.

● Ensured clean vendor metadata and accurate reporting through strong data governance practices. Regulatory Compliance Testing Dashboard

● Designed a JIRA-integrated QA dashboard using SQL and Excel to monitor 200+ test cases and defect trends for compliance data flows.

● Developed validation logic to verify reports against source systems, reducing rework by 30%. Financial Risk Forecasting Model

● Built a risk forecasting tool with Python, SQL, and Excel to simulate portfolio risk and predict outcomes under different market conditions.

● Used regression modeling and scenario analysis to improve forecasting accuracy by 25%.

● Created interactive Excel dashboards and backtested model logic with real KPIs.

● Collaborated with finance teams and applied ETL and compliance logic to ensure data accuracy and governance. EDUCATION

University of North Carolina at Charlotte (UNCC), Master of Science in Computer Science with concentration in Data Science

Contact this candidate