| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Vibhuti E-Mail: EMAIL AVAILABLE
Phone: PHONE NUMBER AVAILABLE
Power BI Developer | GC Holder
PROFESSIONAL SUMMARY
TECHNICAL SKILLS
Over 7+ years of experience in Power BI, proficient with Power BI Desktop, Development & Automation: Python, T-SQL,
Power BI Service, and Power BI Report Server. Utilizes Power Query and PL/SQL, VBA (Visual Basic for Applications)
DAX to create high-quality, interactive data visualizations and reports. Cloud Services: Azure, AWS
Knowledgeable in Amazon Redshift and Amazon S3 for scalable cloud- Data Integration & Analytics: Azure Data Lake,
based data storage, processing, and analytics solutions. Azure Synapse Analytics (SQL Data Warehouse),
Experienced in automating workflows with Python, T-SQL, PL/SQL, and Amazon Redshift, Amazon S3 Hadoop, Spark,
VBA, enhancing data processing efficiency and reducing manual effort. Azure Data Factory, Informatica, SSIS
Strong background in managing and querying databases, including SQL Business Intelligence & Reporting: Power BI
Server, MySQL, PostgreSQL, Oracle, and Snowflake, to ensure accurate (Desktop, Service, Report Server), Power Query,
and efficient data handling. DAX, Custom Visuals, Python Integration, Power
Proficient in using SSRS (SQL Server Reporting Services) and SSAS (SQL Automate, Power Apps
Server Analysis Services) to create detailed, actionable reports and Database Management & Reporting: SQL
perform multidimensional data analysis. Server, MySQL, PostgreSQL, SSRS, SSAS, Oracle,
Adept at developing custom visuals and integrating Python scripts within Snowflake
Power BI to enhance analytical capabilities and meet complex reporting Version Control & CI/CD: Git, Jenkins, Azure
requirements. DevOps
Extensive experience with Azure Data Lake, Azure Synapse Analytics, and Methodologies & Tools: Agile (Scrum, Kanban),
Azure Data Factory for efficient data integration, transformation, and JIRA, Confluence
management.
Skilled in leveraging Hadoop and Spark for large-scale data processing
and analysis, ensuring efficient handling of extensive datasets. EDUCATION
Expertise in version control and CI/CD practices using Git, Jenkins, and
Azure DevOps to support robust software development and deployment Bachelors in Information Technology
processes. Gujarat Technological University, India.
Well-versed in Agile methodologies (Scrum and Kanban) with strong skills in
using JIRA and Confluence for effective project management,
collaboration, and task tracking.
Excellent problem-solving abilities, strong attention to detail, practical
communication skills, and a collaborative mindset. Proven capability to
work under pressure, adapt to changing requirements, and deliver high-
quality results.
WORK EXPERIENCE
Power BI Developer September 2023 - Present
Provident Bank, Jersey City, NJ
Developed and maintained automated report solutions, achieving a 30% reduction in report generation time using Power BI Report
Server and report automation tools.
Leveraged DAX to enhance reporting capabilities, resulting in a 40% improvement in advanced calculations and data modeling
accuracy.
Utilized Python scripts for data manipulation and automation, streamlining data processing workflows and reducing manual effort
by 50%.
Created and maintained SQL Server Reporting Services (SSRS) reports, increasing the depth and detail of data reporting and
visualization by 35%.
Integrated data from Azure Data Lake and Azure Synapse Analytics into Power BI, providing a 25% enhancement in
comprehensive data analysis.
Managed ETL processes using Azure Data Factory, optimizing data integration from Hadoop and Spark by 45%, which improved
data flow efficiency.
Created and implemented interactive reports and dashboards using Power BI Desktop and Power BI Service, leading to a 30%
boost in user engagement and improved accessibility.
Applied performance tuning techniques in Power BI and SQL Server, achieving a 50% improvement in data retrieval speed and
report performance.
Developed self-service BI solutions using Power BI and Power Query, increasing user autonomy in creating reports and analyses by
60%.
Engaged with stakeholders to gather requirements and deliver BI solutions, resulting in a 20% improvement in alignment with
business needs and user satisfaction.
Implemented data security measures and governance policies, achieving 100% compliance with data protection standards and
safeguarding sensitive information.
Utilized Power Automate and Power Apps to create automated workflows and applications, enhancing operational efficiency by
40%.
Employed CI/CD pipelines and Jenkins for continuous integration and deployment of BI solutions, reducing deployment times by
35%.
Created and deployed OLAP cubes and dimensional models using SSAS, supporting complex analytical queries and improving
data analysis capabilities by 30%.
Applied Agile and Scrum methodologies to manage project workflows, resulting in a 25% increase in delivery speed and
adaptability to changes.
Utilized data integration techniques to consolidate information from diverse sources into unified BI solutions, achieving a 50%
reduction in data silos and improving overall data coherence.
Environment: Power BI, DAX, Python, SSRS, Azure, Hadoop, Spark, Power BI Desktop, Power BI Service, Power Query, Power Automate,
Power Apps, Jenkins, SSAS, Agile, Scrum.
Power BI Developer May 2022 - August 2023
VNA Health Care, Aurora, IL
Employed DAX for advanced calculations and data modeling, resulting in a 35% increase in report and dashboard effectiveness
through enhanced data insights.
Designed and developed scalable Power BI solutions using Power BI Desktop and Power Pivot, delivering insightful data
visualizations and KPI dashboards that improved business intelligence by 40%.
Conducted data cleaning and transformation processes, ensuring 98% data quality for accurate analysis and reporting.
Managed ETL processes with Informatica, integrating data from Amazon Redshift and MySQL into the data warehouse, which
improved data integration efficiency by 50%.
Utilized Python scripts for data manipulation and automation, streamlining data processing workflows and reducing manual effort
by 45%.
Developed and maintained CI/CD pipelines using Jenkins, automating the deployment of BI solutions and reducing deployment
times by 30%.
Crafted complex queries and analyzed data, extracting valuable insights that supported decision-making and improved strategic
planning by 25%.
Provided end-user training on Power BI features and best practices, ensuring a 50% increase in effective utilization of BI tools
among users.
Managed data governance and security, implementing role-based access controls and encryption protocols, achieving 100%
compliance with data protection standards.
Applied Agile and Kanban methodologies for project management, enhancing development efficiency by 30% and improving team
collaboration.
Integrated data from Amazon S3 into Power BI reports, enhancing comprehensive data analysis and visualization capabilities by
40%.
Collaborated using Confluence to document processes and share knowledge, leading to a 20% increase in team productivity and
information accessibility.
Designed and implemented star schema data models and dimensional modeling, optimizing data organization and improving
performance by 35%.
Ensured data accuracy and consistency by applying best data modeling and governance practices, achieving a 98% accuracy
rate in reporting.
Environment: DAX, Power BI Desktop, Power Pivot, Informatica, Amazon Redshift, MySQL, Python, Jenkins, Amazon S3, Agile, Kanban,
Confluence.
MSBI (Microsoft Business Intelligence) Developer November 2020 - April 2022
Systango Technologies, India
Designed and optimized dimensional modeling and star schema for effective data warehousing using Snowflake and PostgreSQL.
Developed and managed ETL workflows with SSIS and Azure Data Factory (ADF) to streamline data integration and
transformation.
Created interactive dashboards and detailed reports with Power BI and SSRS to drive business insights.
Implemented and maintained SSAS for multidimensional and tabular data analysis, ensuring high performance in SQL Server.
Utilized T-SQL for advanced querying and data manipulation, focusing on performance tuning and accuracy.
Conducted data normalization and migration to enhance data quality and consistency across systems.
Integrated Azure services, including Azure Blob Storage, Azure Data Lake Storage, and Azure Key Vault for secure and scalable
data management.
Managed CI/CD pipelines and automated deployment processes using Azure DevOps, with project tracking facilitated by Azure
DevOps boards.
Applied Agile methodologies to manage project workflows, ensuring efficient delivery and collaboration.
Performed data analysis and troubleshooting to resolve issues and optimize system performance.
Developed technical documentation to standardize data integration processes and provide clear guidance for BI solutions.
Leveraged Azure Active Directory (Azure AD) for secure user authentication and access control.
Environment: Power BI, SSRS, SSAS, SQL Server, T-SQL, Snowflake, PostgreSQL, SSIS, Azure Azure DevOps, Agile, Azure AD.
SQL BI Developer June 2018 - October 2020
Eminence Technology, India
Utilized Talend for ETL processes to ensure accurate and efficient data integration.
Created interactive dashboards and reports in Tableau, utilizing star and snowflake schema designs.
Conducted data analytics, cleansing, and transformation using PL/SQL.
Applied indexing strategies and OLAP operations to enhance query performance and data retrieval efficiency.
Developed and optimized complex SQL queries, stored procedures, functions, and triggers in Oracle databases.
Designed and implemented data warehouse environments, focusing on performance tuning and optimization.
Employed Agile and Kanban methodologies to manage projects and improve workflow efficiency.
Collaborated with teams on documentation and knowledge sharing using Confluence.
Utilized Excel and Power Pivot for advanced data analysis and reporting, including VBA macros for automation.
Used Git for version control, ensuring proper tracking and management of code changes.
Performed data mining to uncover patterns and insights, supporting business intelligence initiatives.
Developed technical documentation to standardize processes and ensure clarity in data integration and BI tasks.
Environment: Talend, Tableau, PL/SQL, Oracle, SQL, Git, Confluence, Excel, Power Pivot, VBA, Agile, Kanban.
Business Intelligence (BI) Developer July 2017 - May 2018
CMARIX, India
Designed and developed interactive dashboards and reports using Tableau to deliver actionable business insights.
Conducted data analysis to extract key metrics and support strategic decision-making processes.
Created and maintained data models and warehouses to ensure accurate and timely data retrieval.
Collaborated with business users to gather requirements and translate them into technical specifications for BI solutions.
Developed ETL processes to integrate data from multiple sources and maintain data quality.
Implemented data visualization best practices to effectively present complex data.
Optimized SQL queries and database performance to enhance data retrieval and reporting efficiency.
Monitored and troubleshot BI systems to resolve issues related to data integrity and performance.
Created automated reports and alerts to provide timely updates on key performance indicators (KPIs).
Environment: Tableau, ETL, SQL, Data Visualization, Performance Optimization, Data Integrity.
|
