Data Analyst Power Bi

Samitha singireddy

+1-763-***-**** *******************@*****.***

PROFESSIONAL SUMMARY

Data Analyst with 3+ years of experience transforming complex datasets into actionable insights. Proficient in SQL, Excel, Google Sheets, and dashboard design, with a strong track record of streamlining reporting workflows. Recognized for collaborating across teams to support strategic initiatives and drive business performance through targeted data analysis.

EDUCATION

Concordia University, St. Paul – Minnesota

Master of Science, Information Technology Management Dec 2024

WORK EXPERIENCE

Pinnacle Arc LLC Apr 2025 - Present

Data Analyst Las Vegas, Nevada

•Collected and cleaned large datasets from diverse sources, ensuring data quality for actionable merchant insights.

•Performed statistical and trend analyses to identify key performance indicators for internal stakeholders.

•Developed automated Power BI dashboards that reduced reporting turnaround time by 35% and enhanced recurring reporting workflows.

•Collaborated with business units to define KPIs and create self-serve reporting tools, translating complex data into strategic recommendations.

•Implemented Python scripts to automate routine data preparation tasks, saving over 10 hours weekly.

•Integrated Excel, SQL Server, and Power BI into a streamlined reporting pipeline to support operational decision-making.

•Executed ad-hoc SQL queries and deep-dive analyses for marketing, sales, and finance teams to drive strategic insights.

•Conducted exploratory data analysis and hypothesis testing to validate business assumptions and support operational metrics.

•Enforced data governance standards through regular audits and meticulous quality checks.

•Coordinated with portfolio and finance teams to monitor resource allocation and support budgeting processes.

•Annotated and pre-processed structured datasets to support algorithm training and testing workflows using Python (Pandas, NumPy).

•Organized and managed high-volume image and tabular data sets, ensuring data integrity and consistency across annotation stages.

•Analyzed performance data from marketing and sales campaigns to identify key trends and actionable insights across multiple channels.

•Developed Power BI dashboards to track campaign KPIs, engagement metrics, and ROI, enabling real-time decision-making for marketing teams.

CloudData Technology Sep 2023 - Mar 2025

Data Analyst Intern Wilmington, Delaware

•Cleaned and formatted legacy production data for ERP integration using advanced SQL and Excel techniques.

•Conducted data audits to identify and rectify anomalies across five departments for improved data accuracy.

•Developed comprehensive documentation and SOPs to bolster data governance efforts.

•Created Excel-based reports summarizing ERP implementation progress for executive stakeholders.

•Collaborated with developers and QA teams to validate data flows and mappings post-migration.

•Engineered robust ETL pipelines leveraging SQL and Python to extract data from APIs, transform with business rules, and load into Power BI for dynamic dashboarding.

•Automated daily ETL workflows using Power Query in Excel, SQL Server, and scheduled Python scripts, reducing manual processing by 50%.

•Devised custom data transformation logic to normalize and map legacy ERP data for production use across five departments.

•Supported agile processes through backlog grooming and sprint planning with product managers.

•Built Python scripts to automate cleaning, labeling, and transformation of complex datasets used in model development and reporting.

•Manipulated and analyzed metadata using Pandas, generating summary reports to support product and clinical teams.

•Partnered with cross-functional teams (marketing, sales, finance) to scope analytics requests and deliver compelling data stories that influenced media planning.

•Built PowerPoint reports translating technical metrics into clear, visual insights for business and leadership audiences.

Harman India Mar 2022 - Aug 2023

Data Analyst Bangalore

•Created 10+ Power BI dashboards, improving visibility into project KPIs and delivery metrics.

•Wrote complex SQL queries to extract and transform data from large relational databases.

•Automated recurring Excel reports using macros and Power Query, reducing manual work by 25%.

•Partnered with senior analysts to translate business requirements into actionable datasets.

•Conducted time-series and cohort analyses to assess product adoption and customer retention.

•Supported monthly business reviews by compiling dashboards and insights across multiple regions.

•Developed predictive models to estimate future customer churn using historical data trends.

•Designed and executed A/B tests to evaluate marketing campaign effectiveness, revealing a 12% increase in engagement for Variant B.

•Performed hypothesis testing using Python and Excel (t-tests, p-values) to validate business assumptions and recommend changes.

•Provided detailed documentation and training for internal teams on reporting tools.

•Assisted with data migration and validation during system upgrades.

•Mentored junior analysts and interns on SQL best practices and data visualization.

Sales Insights Dashboard – Excel & Power BI

•Consolidated 6 months of retail sales data from disparate Excel files. Cleaned and pre-processed data using Excel formulas and Power Query. Designed a Power BI dashboard to track total revenue, units sold, profit margins, and regional sales trends. Utilized DAX to calculate custom KPIs (e.g., YoY growth, average sales per region, sales rep performance) and added interactive filters for detailed exploration. Created trendlines and heatmaps to highlight seasonal spikes and underperforming regions.

•Successfully simulated a real-world reporting system, enhancing understanding of business KPIs and advanced visualization techniques.

Customer Order Analysis – SQL

•Imported structured order data (orders, products, customers) into a relational database using PostgreSQL. Wrote complex SQL queries (INNER JOINS, GROUP BY, HAVING, window functions) to analyze customer behavior, identifying top-selling products, customer lifetime value, repeat buyer frequency, and average order value. Segmented customers into first-time vs. repeat buyers using CASE statements. Exported query results to Excel for summary tables and presentations.

•Identified that 30% of total revenue originated from just 15% of customers, providing actionable insights for targeted loyalty programs and upselling campaigns.

HR Attendance Analysis – Excel & Power BI

•Collected employee attendance logs in Excel and structured data into a consistent format using formulas (IF, VLOOKUP, TEXT, DATEVALUE). Identified patterns such as frequent absentees, late logins, and department-level punctuality rates. Built a Power BI dashboard with charts showing daily attendance trends, absenteeism heatmaps, and top 5 departments by punctuality. Used calculated columns and measures to flag high-risk employees based on attendance thresholds and included a month-wise breakdown for HR forecasting.

•Developed a simulated real-life HR reporting system, significantly strengthening data cleaning, pattern recognition, and dashboarding proficiencies.

SKILLS

•Data Analysis: Excel (advanced formulas, pivot tables, Power Query), SQL (MySQL, PostgreSQL), Python (Pandas, NumPy)

•Data Visualization: Power BI (DAX, KPIs), Tableau (dashboards, calculated fields), Excel Charts, Looker Studio

•Programming: Python (data manipulation, Matplotlib/Seaborn, Pandas, NumPy), SQL (complex queries, joins, CTEs, window functions)

•Data Cleaning & Preparation: Excel (IF, VLOOKUP, TEXT, XLOOKUP, INDEX/MATCH), Power Query, SQL, Python (missing values, merging)

•Dashboarding & Reporting: Power BI (interactive dashboards, slicers, drilldowns), Tableau, Excel dashboards, Looker Studio

•Statistical & Business Analysis: Descriptive statistics, Trend analysis, KPI tracking, A/B testing basics, Time-series analysis.

•Database Management: MySQL, PostgreSQL (schema design basics, indexing, normalization)

•Tools&Technologies: Jupyter Notebook, VS Code, Git/GitHub, Google Sheets, PowerPoint, SharePoint, Confluence, Planview (basic familiarity, fast learner).

•Soft Skills: Strong communication, Stakeholder engagement, Data storytelling, Problem-solving, Teamwork

•Project Collaboration: Agile-style environments, Cross-functional team experience, Requirement gathering, Sprint planning, Budget tracking, Resource allocation coordination, Vendor communication.

CERTIFICATIONS

•Bank of America Sales and Trading Analyst Job Simulation Forage: April 2025

Successfully completed a job simulation focused on analysing market trends and delivering client-centric solutions within the sales and trading division.

Performed in-depth data analysis using Excel and Bloomberg to identify key financial trends, assess market dynamics, and align insights with client objectives.

Researched and proposed strategic recommendations for optimizing trade execution processes and enhancing workflow efficiency through automation and process analysis.

Developed a client proposal detailing tailored investment strategies, leveraging data-driven insights to address client goals including portfolio diversification, sustainability, and moderate growth.

PROJECT WORK

Contact this candidate