Power Bi Developer

Akhil Kumar K

+1-910-***-**** **************@*****.*** LinkedIn

BI Developer

SUMMARY

Skilled BI Developer with over 8 years of experience in Power BI, data integration, and dashboard development across finance, healthcare, and education. Proficient in ETL processes, real-time reporting, and advanced visualizations using Power BI, SQL, Snowflake, Azure, and AWS.

Experience in gathering Business requirements, Analysis, Design, Implementation and documentation of various functionalities of Data marts and Business Intelligence.

Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems.

Skilled in performing comprehensive data analysis and designing data-driven solutions tailored to the unique needs of industries such as Finance, Healthcare, and Education.

Proficient in data integration from multiple sources like SQL Server, Oracle, Azure Data Lake, PostgreSQL, and AWS, ensuring seamless data transformation and real-time reporting.

Extensive experience in managing projects through the Software Development Life Cycle (SDLC) using Waterfall and Agile (Scrum) methodologies.

Skilled in overseeing all phases, from requirements gathering and design to deployment and maintenance of BI solutions.

Strong background in crafting insightful dashboards and reports, improving data accessibility for leadership and stakeholders.

Expertise in developing Power BI dashboards, custom visuals (e.g., Sankey charts, heatmaps), and creating DAX measures to track Key Performance Indicator’s (KPIs) for financial, healthcare, and student performance analysis.

Extensive experience in SQL programming, performing complex queries, data extraction, and optimization, improving report accuracy and reducing data load times by 40%.

Working on MSBI Suite (Power Pivot, Power View, Power Query, Power Maps, Power BI Desktop, Power BI Service).

Experienced in using Snowflake for scalable data warehousing, integrating data from multiple sources, and performing advanced analytics to enable real-time reporting and improve data-driven decision-making.

Proficient in developing and optimizing PL/SQL scripts for complex data transformations, querying, and ensuring data integrity in large-scale databases, enhancing reporting and analytical processes.

Establish Best Practices for Enterprise Tableau Environment and application intake and Development processes.

Experience in ETL processes using Azure Data Factory, AWS Glue, and Talend, automating workflows to reduce manual intervention and ensuring efficient data pipelines for real-time data processing.

Expertise in data security and governance with Row-Level Security (RLS) in Power BI, ensuring compliance with GDPR and internal data privacy policies across various industries.

Proficient in using Python for advanced data processing, predictive modeling, and automating ETL tasks to improve performance and reporting accuracy.

Import data from multiple sources like SQL Server DB, Excel, Oracle into Power BI.

Skilled in using Power Query for data transformation, SQL tuning, and performance optimization techniques, supporting efficient and scalable BI solutions.

Hands-on experience in working with Azure Synapse Analytics and Azure Databricks for large-scale data transformation and processing to enable faster decision-making.

Proven ability to collaborate across teams, mentoring BI developers, and improving team productivity by 25% through enhanced Power BI knowledge sharing.

SKILLS:

Business Intelligence Tools

Power BI, Tableau, Power BI Desktop, Power BI Service, Power BI Mobile, Microsoft (SSIS, SSRS, SSAS), Alteryx, Qlik Management Console and SQL Server Management Studio.

Programming languages

SQL and Python

AWS Services

AWS Glue, AWS Lambda, AWS S3, AWS RDS, AWS IAM, AWS Cloud Integration, Snowflake (on AWS).

Azure Services

Azure Data Factory, Azure Data Lake, Azure Synapse Analytics, Azure Databricks, Azure Blob Storage, Azure SQL Database and Azure Active Directory, AWS Sage Maker.

ETL Tools

Azure Data Factory, AWS Glue, Talend and Alteryx.

Data Security and Governance

Row-Level Security (RLS), GDPR Compliance, AWS IAM, Azure Active Directory (Azure AD)

Data Modeling

Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Pivot Tables

Databases

MS SQL Server, Oracle, MongoDB, PostgreSQL, PL/SQL, Teradata, MS Access.

Data Warehousing

Snowflake, Teradata, Redshift and OLAP

EXPERIENCE:

State Street Bank, Boston, MA Jan 2023 - Present

Sr. Power BI Developer

Responsibilities:

Integrated data from multiple sources, including SQL Server, Oracle, and Snowflake, to develop a centralized financial risk dashboard, ensuring real-time updates and seamless data integration across departments.

Performed complex data transformations using Power Query and implemented a star schema, reducing data processing time by 30% and improving report accuracy for financial analysis.

Utilized SQL to write complex queries for extracting, transforming, and merging large datasets from SQL Server, Oracle and Snowflake, ensuring seamless data integration and improving report accuracy.

Leveraged Azure Databricks and Azure Synapse Analytics for advanced data transformations and processing, ensuring scalability and efficiency when managing large financial datasets for decision-making.

Developed Various DAX measures for KPIs, including Value-at-Risk and asset growth, delivering dynamic insights to senior management for better financial decision-making.

Built custom visuals like Sankey charts and heatmaps, improving stakeholder engagement by 15% and enhancing clarity in financial data presentation across departments.

Deployed Azure Data Factory and Snowflake to orchestrate ETL pipelines, enabling real-time data ingestion and seamless integration with Power BI for financial risk analysis.

Optimized Power BI dashboards by improving DAX formula efficiency and reducing report load times by 40%, supporting real-time data availability for over 10 million rows.

Implemented real-time reporting with live data feeds from Bloomberg and Reuters, reducing response time to market changes by 20% and enabling instant asset performance analysis.

Published reports to the Power BI Service and managed Row-Level Security, improving data security and ensuring compliance with governance policies for sensitive financial data.

Integrated Copilot with Power BI to automate and enhance data analysis, enabling more efficient insights generation and improving decision-making processes for financial risk assessments.

Optimized SQL queries for data retrieval and complex joins from SQL Server and Oracle, reducing query execution time by 30%.

Managed Power BI workspaces and implemented data governance policies, achieving 100% compliance with GDPR and internal audits through role-based access control.

Embedded Power BI reports into internal portals, reducing manual reporting efforts by 40% and providing real-time insights to portfolio managers for better decision-making.

Mentored team members, increasing productivity by 25% through enhanced knowledge sharing on Power BI capabilities, including DAX, Power Query, and custom visualizations.

Automated data processing workflows using Python scripts for ETL tasks, enhancing data validation and reducing manual intervention, which improved real-time financial reporting efficiency.

Environment: Power BI, SQL Server, Oracle, Snowflake, Azure Synapse Analytics, Azure Databricks, Azure Data Factory, Power Query, Row Level Security, DAX, KPI’s, Python, Copilot, ETL, Windows 2012 Server, Data Security, Qlik Management Console.

State of New York, NY July 2019 – Dec 2022

Sr. Power BI developer

Responsibilities:

Integrated Medicaid data sources (claims systems, EHR) using AWS Glue for automated ETL processes and Power Query for data transformations, creating a centralized model hosted on Snowflake for predictive analysis and real-time reporting.

Developed DAX measures and SQL queries for patient risk score calculations, improving care coordination and reducing hospital readmissions by 20%, with automated processing through Python scripts.

Built interactive dashboards with custom visualizations and leveraged Python for advanced trend analysis, visualizing healthcare service utilization and predicting demand through AWS cloud integration.

Optimized ETL workflows and SQL queries for real-time data processing of over 1 million patient records, hosted in Snowflake, reducing data load times and improving query performance for Medicaid administrators.

Strong Skills in Data Modelling/Relationships (Star Schema, Snowflake Schema) and loading data from multiple data sources.

Developed and optimized PL/SQL scripts for complex data transformations and extraction processes, ensuring efficient querying and data integrity in patient risk analysis and healthcare reporting.

Extensive experience in developing complex DAX formulas for creating dynamic measures and enhancing data analysis in Power BI.

Deployed machine learning models using AWS SageMaker to predict patient healthcare needs and identify high-risk individuals, improving resource allocation and reducing hospital readmissions by 20%.

Integrated Snowflake for scalable storage and analysis of healthcare data.

Forecasted future healthcare needs using Power BI’s predictive analytics, combined with Python models and SQL data queries on Snowflake, improving resource allocation for medical staff and hospital capacity.

Designed dashboards with ETL pipelines and data-driven alerts for identifying patients overdue for preventive care, leading to a 15% reduction in emergency visits, using AWS Lambda for real-time Notifications.

Worked in developing, publishing, and scheduling Power BI reports as per the business requirements.

Implemented real-time data monitoring for Medicaid fraud detection using SQL, Python, and Row-Level Security (RLS) in Power BI, ensuring data integrity and improving fraud detection efficiency on Snowflake.

Environment: Power BI, EHR, ETL, SQL Server, SQL, PL/SQL, Snowflake, Amazon Web Services, AWS Lambda, DAX, Python, MongoDB, Windows 2008 Server, Windows 2012 Server.

Skillshare, New York, NY Mar 2018 – June 2019

Power BI Developer

Responsibilities:

Developed interactive Power BI dashboards to visualize student engagement metrics and performance trends, providing real-time insights into student learning outcomes.

Automated ETL workflows using Azure Data Factory and Talend, improving data processing efficiency and reducing data refresh times by 40%.

Created DAX measures for tracking key performance indicators (KPIs), including quiz scores and course completion rates, leading to a 15% improvement in student performance.

Integrated Python-based predictive models into Power BI, identifying at-risk students and reducing dropout rates by 10% through early interventions.

Developed custom visualizations in Power BI Desktop using Python scripts, enhancing data visualization capabilities and providing deeper insights into student engagement trends.

Integrated Power BI Desktop with Azure Data Lake for seamless data retrieval, enabling the creation of real-time, interactive dashboards with live data connections, improving overall report accuracy and timeliness.

Optimized Power BI reports by using DAX and SQL, improving query performance and reducing report load times for real-time data analysis.

Managed data transformation processes with Power Query, preparing datasets for analysis and ensuring data accuracy in Power BI.

Ensured secure data access through Row-Level Security (RLS) in Power BI and managed user permissions using AWS Active Directory, maintaining data privacy for sensitive student information.

Streamlined data integration from Azure Blob Storage and Azure SQL Database into Power BI, enabling real-time reporting and improving decision-making for educators and administrators.

Environment: Power BI, SQL Server, SQL, ETL, Row - Level Security, Azure Data Factory, Talend, Oracle 11g, Teradata, Azure Services, Operating Systems, DAX, KPI’s, Python.

Godrej Industries Group, Hyderabad, India Sep 2016 – Feb 2018

Data Analyst

Responsibilities:

Extracted and cleaned sales data from MySQL and PostgreSQL using SQL queries and Alteryx, ensuring accurate and consistent data for analysis.

Analyzed sales trends and product performance using Tableau, creating interactive dashboards to track monthly sales and regional performance.

Performed customer segmentation using Python (Pandas) to identify purchasing patterns, improving targeted marketing campaigns and increasing customer engagement by 10%.

Automated data workflows using Alteryx, reducing manual reporting tasks by 30% and improving the accuracy of real-time sales and inventory data.

Generated reports on marketing campaign performance with Tableau and Excel, providing insights that helped boost promotional sales by 15%.

Used Excel for inventory optimization, calculating turnover rates and forecasting demand to improve stock management and reduce stockouts.

Created interactive Tableau dashboards to present KPIs such as sales growth, customer acquisition, and return rates, helping management make data-driven decisions.

Documented data processes and methodologies using Microsoft Word, ensuring transparency and consistency across teams.

Environment: Operating Systems, MySQL, PostgreSQL, Alteryx, Microsoft Word, Python, Tableau, Excel, KPIs, Data modeling, Microsoft SQL Server.

Education:

Bachelor’s at Jawaharlal Nehru Technology University - Anantapur June 2012 – June 2016

Contact this candidate