Power Bi Business Intelligence

Swetha Kommaraju

Austin, TX (***) -***-**** *******************@*****.***

LinkedIn: LinkedIn Profile Portfolio: Portfolio

Professional Summary

• Business Intelligence and Data Analytics professional with over 3 years of experience in developing impactful data solutions. Proficient in Power BI, SQL, and Azure Data Engineering tools. Skilled at creating efficient ETL workflows, developing predictive analytics models, and delivering actionable insights. Microsoft Certified Power BI Data Analyst with a strong focus on optimizing business performance through data-driven decisions.

Technical Skills:

• Programming Languages/Tools: Python, C, Java

• Operating Systems: Linux, Windows

• Business Intelligence Tools: Microsoft Power BI, Microsoft Fabric, Microsoft apps, SSRS, SSIS, SSAS, Tableau, Google Looker, Advanced Excel.

• Frontend Development: HTML, CSS, JavaScript, Angular.

• Databases: MySQL, MSSQL Server, SQL Server, Hive.

• Data Warehousing: Snowflake.

• Cloud Platforms: Azure data factory.

Professional Experience:

Data Engineer Associate

Aug 2019 – Nov 2022

Client: Leading American multinational retail corporation

• Designed and developed SSRS and Power BI reports, including parameterized, matrix, and tabular formats.

• Created and optimized SSIS packages and SSAS cubes for seamless data integration and analytics.

• Built predictive analytics models in Power BI, improving sales forecast accuracy by 15% and enhancing inventory alignment.

• Created and optimized complex SQL queries to extract, transform, and load data across multiple databases, ensuring high performance and data accuracy.

• Designed relational database schemas and implemented stored procedures, triggers, and views to support business intelligence solutions.

• Automated data workflows using SQL Server Integration Services (SSIS) for seamless ETL processes across various data sources.

• Performed performance tuning on SQL queries and optimized database operations to improve system efficiency.

• Supported and resolved report development tickets, ensuring timely and accurate delivery of data insights.

Environment: Power BI, SSRS, SSIS, SSAS, SQL Server, Snowflake Project: Finance Transformation

Client: A leading American multinational retail corporation operating hypermarket, discount department stores, and grocery stores globally.

• Built and managed clusters in Azure Data Bricks using Jupyter Notebooks for PySpark development.

• Developed and automated data workflows with PySpark scripts and Automic workflows, integrating with Hive databases.

• Designed and supported Hadoop solutions, including installation, configuration, and documentation.

• Analyzed large datasets using Hadoop ecosystem tools such as Hive and HDFS.

• Processed and analyzed data in Teradata and ThoughtSpot to meet business requirements.

• Collaborated with cross-functional teams to ensure efficient data processing and timely service delivery.

• Monitored and managed scheduled finance jobs (Hive, Teradata, ThoughtSpot) using Automic.

• Coordinated with business teams to resolve data delays and ensure consistent delivery. Environment: HDFS, Hive, PySpark, Automic, Teradata, ThoughtSpot. Education:

Master of Science, Computer Science (Jan 2023 – Dec 2024) Wichita State University (WSU), Kansas, United States. Bachelor of Technology, Information Technology (Aug 2015 – May 2019) Jawaharlal Nehru Technological University, Kakinada, India. Certifications:

Microsoft Certified: Power BI Data Analyst Associate Alteryx Designer Core Certified.

Projects:

Power BI Projects

Delicious Pizza Dashboard: Developed a Power BI dashboard to visualize sales performance, customer feedback, and inventory management for a pizza chain. FICO Utilization Report: Created a Power BI report to analyze FICO scores across customer segments.

Banking Insights Report: Built a comprehensive Power BI dashboard to monitor key banking metrics, including loan approvals, customer demographics, and account balances.

Contact this candidate