Vinay Mamidi

ad40s8@r.postjobfree.com 913-***-**** Overland Park, KS

SUMMARY

Data analyst with over 5 years of experience specializing in leveraging data-driven insights to optimize business processes and drive strategic decision-making. Proficient in a wide range of tools and technologies including Power BI, SQL, Excel, Azure, and ETL methodologies. Experienced in developing and maintaining complex Power BI dashboards and reports to deliver actionable insights to stakeholders. Skilled in SQL querying and data manipulation to extract meaningful insights from large datasets. Demonstrated expertise in using Excel for advanced data analysis and visualization. Proven ability to design and implement end-to-end data solutions using Azure services such as Azure Data Factory and Azure SQL Database. Adept at leading ETL processes to ensure data integrity and streamline data pipelines. Collaborative team player with a strong track record of delivering high-quality analytical solutions to meet business objectives.

SKILLS

• Data Modeling

• Gateway Administrator

• Fact and Dimension Tables

• Azure Data Factory

• Star and Snowflake Schema

• SQL

• Microsoft Azure

• DAX (Data Analysis Expressions)

• Power BI Administrator

• Data Visualization

WORK EXPERIENCE

Walmart Remote

Power BI Developer Jan 2023 - Present

•Collaborated with cross-functional teams to gather business requirements, translate them into technical specifications, and deliver analytical solutions that address key business challenges.

•Developed and maintained SQL queries and stored procedures to extract, transform, and load (ETL) data from multiple sources into a centralized data warehouse.

•Utilized advanced Excel functions and formulas like VLOOKUPs, XLOOKUPs, pivot tables, and macros to analyze and visualize the data, facilitating decision making processes for stakeholders.

•Developed and maintained complex Power BI dashboards and reports, providing actionable insights to stakeholders, resulting in a 20% increase in data-driven decision-making efficiency.

•Used DAX functions to create complex calculations and measures in Power BI, such as year-over-year growth, moving averages, and cumulative totals, enhancing analytical capabilities and enabling deeper insights into business performance trends.

•Implemented Azure services such as Azure Data Factory and Azure SQL Database to design end-to-end data solutions, ensuring scalability, reliability, and security of data pipelines.

•Implemented version control using Git for Power BI projects, enabling collaborative development, code review, and tracking of changes across multiple team members, resulting in a 30% reduction in development errors and conflicts.

Capgemini Hyd, India

Power BI Engineer Aug 2018 - Oct 2021

•Collaborated with IT teams to migrate on-premises databases to Azure SQL Database, optimizing data storage and improving scalability

•Extracted and transformed data from various sources using SQL and Azure Data Factory to create a centralized data warehouse, enabling comprehensive reporting and analysis.

•Experienced in designing and implementing dimensional data models to optimize data storage and retrieval for analytical purposes.

•Utilized advanced Excel functions and pivot tables to analyze large datasets, resulting in a 15% reduction in data processing time

•Created interactive dashboards in Power BI to visualize sales performance metrics and identify trends, enabling stakeholders to make data-driven decisions in real-time.

•Implemented row-level security using DAX expressions in Power BI, ensuring data confidentiality and compliance with regulatory requirements by restricting access to sensitive information based on user roles and permissions.

•Integrated Git into the data analysis workflow, enabling efficient tracking of changes to data scripts, queries, and visualizations, thereby reducing the risk of errors and inconsistencies in analytical outputs.

QA Analyst Oct 2016 – Aug 2018

•Collaborated closely with cross-functional teams including developers, business analysts, and project managers to ensure the quality of software products

•Strong understanding of SDLC and STLC methodologies

•Created comprehensive test plans, test cases, and test scripts based on software requirements and specifications

•Experienced in manual testing techniques including functional, regression, integration, and user acceptance testing

•Skilled in identifying, documenting, and tracking software defects using bug tracking tools such as Jira, Bugzilla, or HP ALM

•Capable of creating and maintaining test data sets to support testing activities and ensure data integrity

•Proficient in analyzing test results and preparing detailed test reports summarizing findings and recommending improvements

EDUCATION

University of Central Missouri, Master of Science, Computer Science Warrensburg, Missouri, United States

Bachelor’s degree in computer science or a related field (an advanced degree is like an extra bonus level).

5+ years of experience with cloud platforms, especially Azure.

Solid understanding of Power BI Premium features and capabilities, including Power BI Administration, data modeling, capacity management, and AI-driven insights.

Proven experience in report design and build, coupled with a mastery of development methodologies.

Demonstrated ability to architect and design complex solutions that'll leave everyone in awe.

Excellent communication and interpersonal skills – you know how to make tech talk sound like music.

Be innovative, data-driven, and customer-focused.

Contact this candidate