Aishwarya Reddy

Business Intelligence Developer/Analyst +1-979-***-**** ad0ydo@r.postjobfree.com

LinkedIn Id- linkedin.com/in/aishwarya-r-975026228/

PROFESSIONAL SUMMARY

Over 4.5 + years of experience in Data Analysis, Design, Implementation, and Administration of Business Intelligence using Power BI, SQL Server, SSIS, SSRS, and SSAS.

Having experience working in different domains such as Telecommunication, Retail, Pharmaceutical, Healthcare, Fashion Goods, Oil and gas, Consumer Packaged Goods (CPG), and Warehouse & logistics.

Experienced Power BI Developer with a proven track record of creating impactful data visualizations and driving data-driven decision-making.

Leveraging expert-level knowledge of Tableau/Power BI, data modeling, and DAX calculations to deliver actionable insights.

Proficient in using DAX, Power Query, MDX, and M for data manipulations.

Skilled in gathering and documenting requirements, managing customer expectations, and resolving issues throughout the development cycle.

Experienced in Data Mining, Data extraction, and data Warehousing.

Proficient in Excel, MS Access, SQL, AWS, and Azure for Data analysis and manipulations

Knowledge in back-end programming SQL data modeling, database design, and database programming using MS SQL server.

Familiar with tools like Tabular Editor, ALM Toolkit, and Dax Studio for model operations.

Experience with Relational and dimensional database modeling.

Skilled in evaluating operational performance metrics and KPIs.

Having a good understanding of data collection, data blending, and data transformation and analysis tools such as Alteryx.

Have strong experience in UI/UX design skills.

AREAS OF EXPERTISE

Power BI/Tableau

DAX

Quality Assurance

AWS

Data Visualization

Documentation

Agile

Data Modeling

MS Power Platform

MS SQL, T-SQL

Azure Data Studio

Jira/Kanban

SSIS, SSRS

Azure Databricks

Confluence

My SQL

Excel

MS Power Apps

MS Access

OBIEE

MS Power Automate

PROFESSIONAL EXPERIENCE

Sr. BI Analyst Oct 2022- Present

DSV, Aurora, IL

Collaborated closely with business analysts to understand data requirements and translate them into effective visualizations.

advanced Data Analysis Expressions (DAX) to create complex calculations and measures for data analysis within Power BI.

Integrated and transformed data from various sources, including Snowflake, to ensure accurate and reliable data visualization.

Optimized Power BI reports/dashboards, and KPI scorecards for enhanced performance and responsiveness.

Develop Power BI reports for HR, Finance, the VP of North America, and stakeholders.

Contributed to cross-functional Agile teams, following iterative and incremental development practices.

Conducted thorough testing and validation of Power BI solutions, troubleshooting, and resolving data-related issues.

Prepared comprehensive documentation for Power BI solutions, including data source connections, data models, and report specifications.

Designed and developed ETL (Extract, Transform, Load) solutions to efficiently extract data from source systems and load it into the Data Warehouse.

Stayed up to date with the latest Power BI features, best practices, and industry trends.

Power BI developer Feb 2021- Oct 2022

Syndigo, Chicago, IL

Profiled legacy database tables using T-SQL queries for data cleansing.

Developed Power BI reports for Consumer-Packaged Goods and Retail clients.

Developed DAX expressions and implemented partitions in Tabular models.

Develop data reconciliation SQL queries to validate data migration.

Published reports in the workspaces and built web-accessible dashboards.

Created interactive and highly informative Power BI reports and KPI scorecards using advanced DAX features.

Created views, functions, and Notebooks in Azure Databricks using SQL.

Managed multiple data models as common data sources.

Utilized JIRA for version control and task management.

Communicated effectively with stakeholders and team members.

Power BI developer Dec 2019-Feb 2021

Express Scripts, NJ

Build Data warehouse ETL packages using SSIS.

Designed and developed SQL Server stored procedures, functions, and views that will be used to feed SSRS reports.

Created DAX measures and calculations aligned with requirements.

Utilized Power BI for reports and data visualizations.

Troubleshoot data issues and performance tuning of SQL queries.

Communicate effectively within the scrum team.

Participated in Scrum methodology contributing to the team.

BI Developer July 2019-Oct 2019

Temenos, Malvern, PA

Developed complex SQL stored procedures, Triggers, Functions, views, and Indexes.

Designed data models and schemas on Azure SQL.

Extracted cleansed data from various sources using SSIS.

Research and identify the cause of reported defects and issues.

Develop Power BI reports according to functional and technical design specifications.

Create /Modify existing Power BI dashboards as per requirements.

MSBI Developer April 2018-April 2019

CSG, Chicago, IL

Collaborated within an agile team using SQL, SSIS, SSRS, and ETL tools.

Utilized DAX functions and effective problem-solving skills.

Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files, etc. to SQL Server using SSIS various features.

Managed defects and enhancements through JIRA and confluence.

Hands-on experience in utilizing DAX functions, including Aggregation, Counting, Logical, information, Text, and date functions in source data.

Communicated priorities effectively within the team.

Demonstrated strong problem-solving and T-SQL coding skills.

EDUCATION

Master’s in Computer Science May 2017

University of Illinois Springfield, IL

Bachelors in Computer Science Engineering May 2015

ST. Martins Engineering College, India

Contact this candidate