Power Bi Business Intelligence

Name: Pranusha Apuri

Email: *************@*****.***

Phone: 980-***-****

Senior PowerBI Developer

PROFESSIONAL SUMMARY

8+ years of IT experience specializing in Business Intelligence (BI) development using Microsoft technologies.

Proficient in Microsoft Power BI, Power Apps, Power Automate, D365, SQL Server, SSRS, SSAS, SSIS, and more.

Full lifecycle experience, from analysis to maintenance, in Software Development Life Cycle (SDLC).

Expertise in Power BI components, including Power BI Desktop, Service, Mobile, Gateways, and Report Builder.

Skilled in data modeling, using Composite and Mixed Models across diverse data sources.

Strong understanding of Power BI building blocks, such as Visualizations, Datasets, Reports, Dashboards, and Tiles.

Experience integrating Power Apps and Power Automate into Power BI, including embedding Power Apps within reports.

Proficient in various database systems (ORACLE, DB2, Teradata, MySQL) and database programming.

Extensive knowledge of Data Analysis Expressions (DAX) for creating measures, tables, and columns.

Competent in Power Query, Power Pivot, Power Views, and developing Ad Hoc, SSRS, and Power BI reports.

Skilled in ETL processes for data extraction, transformation, and loading into Data Warehouses.

Strong T-SQL skills, including stored procedures, triggers, views, complex queries, indexes, and packages.

Proficient in RDBMS concepts, including normalization, clustering, constraints, querying, joins, keys, and indexes.

Experienced with Azure Cloud Services, SQL Database, Data Factory, and DevOps.

Agile methodology and version control using TFS, JIRA, and GIT.

Exceptional client service, communication, and problem-solving skills.

Proven ability to provide tier 3 production support and handle customer escalations. Strong independent and team working skills, adaptable, and dedicated to continuous learning.

TECHINCAL SKILLS

Languages

Python, SQL, shell script, Java

Bigdata Technologies

HDFS, Hive, Spark, Kafka, Sqoop.

Java Technologies

Core Java, JSP, JDBC

Cloud Technologies

Data Lake, Data factory, Azure Databricks, Azure SQL database, Azure SQL Datawarehouse, Data Flows. Azure Synapse

NoSQL Databases

HBase, MongoDB3.2, & Cassandra

IDE’s & Tools

Eclipse, IntelliJ Idea, putty, Visual Studio Code, Jenkins

Databases

My SQL, Oracle, Teradata, Microsoft SQL,PL/SQL

Operating Systems

Unix, windows, Linux

Business Intelligence Tools

Tableau, Power BI

ETL Tools

Hive, SQL, Azure SQL, Databricks,Spark,Athena, Spark sql, Infomatica, Talend, SSIS, Data Stage

Ingestion Tool

NiFi

Scheduler tools

Control-M, Airflow, Oozie

Message Broker Tool

ActiveMQ, Apache Kafka

Power BI Tools

Power BI Desktop, Power BI Service, Power Bi Report Builder, Power BI

Gateway, Power Query, Power Pivot, Power Views, DAX

Databases Tools

SSMS, SSRS, SSAS, SSIS, Visual Studio, SSRS Report Builder, Business

Intelligence Development Studio (BIDS), SSDT, Access

EDUCATION

University of North Carolina at Charlotte Aug 2021 – Dec 2022

Master’s in Computer Scirnce GPA – 4.00

JB Institute of Engineering and Technology, India Aug 2009 – May 2013

Bachelor’s in Electrical and Electronics Engineering GPA - 3.86

WORK EXPERIENCE

PowerBI Developer Jan 2024 – present

Archkey Solutions

St.Louis, Missouri

Collaborate with the Director of Data & Analytics to understand the scope and requirements of migrating existing BI dashboards from Spectrum ERPSystem to eCMS ERP System.

Assess the current data models, visualizations, and business logic in Spectrum-based dashboards.

Modify and adapt Power BI reports and dashboards to seamlessly integrate with the data structure and business processes of the eCMS ERP System.

Ensure data accuracy and consistency during the migration process.

Work closely with stakeholders to gather requirements for new BI dashboards utilizing data from the eCMS system.

Design and develop Power BI reports and dashboards tailored to meet the specific needs of the construction space, leveraging insights from the eCMS ERP System.

Implement best practices for data visualization, ensuring that the dashboards provide actionable insights for informed decision-making.

Conduct testing and validation to ensure the accuracy and reliability of newly developed dashboards.

Utilize Power BI desktop and related tools for the design and development of interactive and user-friendly dashboards.

Implement effective data modeling techniques to create a robust foundation for BI solutions.

Collaborate with the UX/UI design team to ensure a visually appealing and intuitive user interface.

Incorporate user feedback and make iterative improvements to enhance the overall user experience.

Translate business requirements into data models that align with the capabilities and structures of the chosen ERP systems.

Demonstrate a proactive and self-starting approach to problem-solving.

Identify potential challenges or roadblocks early in the project lifecycle and propose effective solutions.

Maintain comprehensive documentation of data models, transformations, and dashboard specifications.

Maintain clear and effective communication with stakeholders, including the Director of Data & Analytics and end-users.

PowerBI Developer Feb 2022 – Dec 2023

BJ’s

Dallas, Texas

Gathered business requirements and translated them into technical specifications.

Designed, built, and deployed interactive Power BI solutions, including reports, dashboards, and visualizations.

Configured data gateways for accessing and updating data from multiple sources.

Utilized Power BI Mobile apps for on-the-go access to reports and dashboards.

Created paginated reports using Power BI Report Builder and Power BI Service.

Implemented data modeling using DirectQuery and import models from various sources.

Utilized Power Query, Power Pivot, and Power View for data transformation and reporting.

Developed Power BI datasets and dataflows from diverse data sources.

Created various visualizations, including tables, charts, and more.

Integrated Power Apps and Power Automate within Power BI.

Implemented data integration, processing, and presentation in Power BI.

Created Ad Hoc, SSRS, and Power BI reports. Utilized Key Performance Indicators (KPIs) for data insights.

Managed data access with row-level security. Proficient in Azure Data Studio, SQL Server Management Studio, Azure DevOps, and Azure Pipelines.

Demonstrated effective collaboration and communication with cross-functional teams.

Designed and implemented ADF pipelines to perform data processing, cleaning, and modeling, ensuring data accuracy and integrity.

Proficient in leveraging Azure Synapse to enhance Power BI capabilities for data analysis and reporting.

Designed and implemented Azure Databricks solutions to preprocess, analyze, and transform data for Power BI dashboards and reports.

Collaborated in Agile (Scrum/Kanban/SAFe) development environments, contributing to iterative project cycles.

Utilized Data Warehouse experience to design and implement scalable data solutions and also data modelling.

Worked with Business Intelligence tools such as Business Objects and BIRT to create insightful reports and analytics.

Developed and maintained complex PL/SQL scripts for data extraction, transformation, and loading processes.

Designed and optimized relational databases to enhance system performance and data integrity.

Conducted performance tuning and troubleshooting of PL/SQL queries to improve overall database efficiency.

Collaborated with cross-functional teams to analyze business requirements and translate them into efficient database solutions.

Proficient in OBIEE and Power BI, with hands-on experience in Oracle BI Administration Tool, OBIEE Answers, Power BI Desktop, and Power BI Service.

Demonstrated expertise in data modeling, transforming complex OBIEE data models into efficient and optimized Power BI data models using DAX and M languages.

SKILLS:

Microsoft Power BI, Power Apps, Power Automate, MS SQL Server, SSMS, SSRS, DAX, Report Builder, Azure Active Directory, Azure Data Storage, Azure Data Factory, Azure Data Lake, Excel, SharePoint, Visual Studio, Microsoft Outlook, Teams, Project, Planner, Python, Snowflake, Azure Synapse, Azure Databricks, Azure SQL database

PowerBI Developer Nov 2019 – Aug 2021

Polsinelli

Kansas City, Missouri

Proficient SQL developer with a strong track record of crafting complex SQL queries to extract, transform, and analyze data.

Collaborated with cross-functional teams to understand business requirements and translate them into optimized SQL solutions.

Demonstrated expertise in designing efficient database structures and enhancing query performance through indexing and tuning.

Developed and maintained SQL queries and stored procedures to support business-critical reporting and data analysis.

Applied advanced SQL techniques to solve intricate data retrieval and processing challenges, delivering valuable insights to stakeholders.

Collaborated with business users to gather requirements and create reports using SQL Server Reporting Services (SSRS).

Developed interactive Power BI reports and dashboards, applying data blending and complex calculated measures with DAX.

Ensured data security through Row-Level Security (RLS) and optimized performance by using T-SQL.

Managed ETL processes with SSIS, designed multidimensional models in SSAS, and scheduled report subscriptions in SSRS.

Collaborated with cross-functional teams to integrate Azure Databricks with Power BI and enable advanced data processing.

Collaborated with cross-functional teams to gather business requirements and integrate Azure Synapse with Power BI.

Utilized ADF to extract, transform, and load data from diverse sources into target destinations, optimizing ETL processes.

Configured, designed, developed, and tested Power BI dashboards, providing actionable insights to stakeholders.

Utilized Oracle, Oracle Utilities, and ETL tools to extract, transform, and load data into the BI system.

Developed and maintained PL/SQL scripts for efficient database querying and manipulation.

Applied structured system development methodologies to ensure the successful delivery of BI solutions.

Integrated diverse data sources with Power BI, including Snowflake, Azure, and SQL Server.

Efficiently handle and process large datasets into required formats.

SKILLS:

Microsoft Power BI, SQL Server, MS SQL Server Management Studio, SSRS, T-SQL, Visual Studio, GIT, SSIS, Azure Data Factory, Azure databricks, Azure SQL, Azure Synpase Analytics

PowerBI Developer Nov 2016 – Jan 2018

Deloitte

Hyderabd, Telangana

Gathered business requirements and converted existing SSRS reports into Power BI reports.

Collaborated with Power BI developers, performed peer reviews, and published reports to the workspace.

Continuously monitored and maintained report refreshes to ensure data accuracy.

Developed more than 12 reports with various visualizations.

Proficient in SQL Server Data Tools (SSDT), including SSIS, SSAS, and SSRS.

Expert in ETL processes, deploying SSIS packages, and writing complex T-SQL queries.

Experienced in RDBMS, SQL objects, and version control using GitHub, TFS, JIRA, and GIT.

Created interactive Power BI reports with slicers, charts, and navigation buttons.

Designed drill-down, drill-through, and synchronized slicer reports.

Managed roles and sharing in Power BI Service for client collaboration.

Wrote DAX expressions for data analysis in Power BI.

Experience working in OBIEE reports.

SKILLS:

Microsoft Power BI, SSMS, SSRS, SSIS, SSAS, SQL Server, T-SQL, ETL, Visual Studio, Report Builders, Outlook, MS Access, SQL Profiler, TFS, Agile Methodology.

SQL Developer/Reports/PowerBI Developer March 2014 – Nov 2016

IBM

Hyderabd, Telangana

Designed and developed relational databases in SQL with data integrity rules.

Created complex Stored Procedures, Triggers, Functions, Indexes, and SQL joins.

Developed ETL processes using SSIS for data extraction and transformation.

Generated reports and designed complex visualizations using SSRS, including drill-down reports and charts.

Created Power BI reports with data visualizations such as cross tabs, maps, scatter plots, and charts.

Designed custom reports for Power BI and SSRS.

Utilized SQL and PL/SQL knowledge to optimize queries and procedures for improved performance.

Collaborated with business analysts and QA teams to gather requirements and ensure testing progress.

Worked as a database administrator and in database design.

Created SSIS packages and implemented row-level security for data access.

Integrated Power Apps with Power BI reports.

Used Informatica for ETL workflows, data validation, and quality checks.

Collaborated with stakeholders to understand and map business processes.

Proficient in PL/SQL for Oracle databases.

Developed complex stored procedures, functions, triggers, and optimized SQL queries.

Implemented data validation, integrity checks, and constraints.

Created and maintained PL/SQL packages and libraries for code reusability.

SKILLS: MySQL Server, SSRS, SSIS, Power BI, SSAS, VB

Certification: Microsoft Certified Azure Data Engineer Associate

Contact this candidate