Power Bi Developer

Senior Power BI Developer

Name: Chetan

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

Professional Summary:

Senior Power BI Developer with over 12 years of extensive experience in Business Intelligence, data analysis, and

visualization. Adept at designing and implementing end-to-end BI solutions that empower decision-makers across

diverse sectors including financial services, healthcare, aviation, and IT. Skilled in SQL, DAX, Power Query, and

cloud-based data platforms, with a focus on performance tuning, secure data modeling, and automation. Recognized

for creating impactful dashboards, modernizing reporting systems, and mentoring teams to adopt BI best practices.

Key Responsibilities:

Developed interactive Power BI dashboards and reports for data-driven decision-making.

Managed large and complex datasets, ensuring accurate and efficient data processing.

Designed end-to-end BI solutions, from data collection to visualization.

Implemented strategies for significant improvement in data processing and reporting speed.

Conducted ETL operations using SSIS, integrating data from varied sources into centralized systems.

Established robust security protocols, including row-level security in Power BI.

Utilized DAX and MDX for creating complex calculated measures and enhancing data analytics.

Demonstrated advanced skills in SQL querying, stored procedure optimization, and database management.

Provided Power BI training and support to enhance organization-wide usage and understanding.

Integrated Linux systems into the ETL workflow for seamless execution of data processing tasks.

Documented intricate business requirements and translated them into technical specifications.

Collaborated with various teams to ensure alignment of BI solutions with business goals.

Developed dynamic operational and analytical reports as per evolving business needs.

Created efficient data models using Power BI and SQL Server for enhanced data visualization.

Extracted data from various sources, including SQL Server, Oracle, and SQL Azure, into Power BI.

Published and maintained Power BI reports and dashboards for enterprise accessibility.

Developed the Canvas application in Power Apps to automate the manual data entry application.

Automated data refresh processes in Power BI, ensuring up-to-date reporting.

Implemented report integration among Power BI, Tableau, SSRS and Python reports

Integrated PL/SQL components seamlessly into the ETL solutions, ensuring efficient data processing and manipulation.

Implemented query optimization techniques for faster data retrieval and report generation.

Built Python Modules to deliver specific formats of data

Developed interactive features like slicers and drill-down in reports for better user engagement.

Provided ongoing maintenance and troubleshooting for BI tools and reports.

Actively sought and implemented improvements in BI processes and tools.

Engaged with stakeholders for requirement gathering and delivering tailored BI solutions.

Utilized Power Query for effective data cleansing, ensuring data integrity and accuracy.

Automated various BI processes, enhancing operational efficiency.

Managed reporting databases, ensuring optimized performance for BI applications.

Advocated for and implemented best practices in BI development and reporting.

Maintain and develop system integrations among enterprise front and back-end applications (ERP, CRM, EDI, Demand Planning, Manufacturing Control Systems)

Stayed abreast of emerging technologies and trends in BI, continually enriching skillset and solutions.

Developed data capture and navigation desktop and mobile apps in Microsoft Power apps that connect to distribution Centre solutions design analytics in Power BI.

Utilized Microsoft Fabric components including One Lake, Lakehouse, and Dataflows Gen2 to unify data engineering and reporting pipelines for scalable analytics.

Technical Skills:

BI Tools

Power BI, Microsoft Fabric, Python, SSRS, Crystal Reports, Power Apps, Pivot, Power View

Programming Languages

DAX, MDX, SQL, T-SQL, Python

ETL Tools

SSIS, Power Query, Informatica, Azure Data Factory

Databases

SQL Server, Oracle, Azure SQL DB, MySQL, PostgreSQL, Big Query

Data Modelling

Star and Snowflake schemas

Reporting

Ad-Hoc Reporting, Drill-down, Drill-through Reports, Parameterized Reports, Linked Reports, Chart Reports, Sub Reports

Performance Optimization

Performance Tuning, Query Optimization

Security

Row-Level Security (RLS), Azure Active Directory (AAD),

Security Model Implementation.

Other Skills

Data Warehousing, Data Cleansing, Automated Data Refresh, Dashboard Development, Report Scheduling, Data Import/Export, Data Transformation

Professional Experience:

Client: UBS, New York, NY September 2024 – Present

Role: Senior Power BI Developer

Responsibilities:

Spearheaded the design, development, and deployment of interactive Power BI dashboards and analytical reports.

Architected scalable BI solutions encompassing Microsoft Fabric components like Lakehouse and One Lake for enterprise-wide reporting.

Integrated Dataflows Gen2 for ingesting, transforming, and unifying data across reporting layers.

Automated enterprise-wide report deployment and data refresh cycles using Power BI REST APIs integrated with CI/CD pipelines.

Partnered with senior business stakeholders to elicit KPIs and performance metrics, delivering executive-level scorecards and dashboards tailored for high-impact decision-making.

Engineered robust ETL pipelines to extract, transform, and load data from heterogeneous sources, including cloud platforms (Azure, AWS), relational databases, and RESTful APIs.

Optimized database architecture by creating high-performance schemas, views, and indexes, ensuring referential integrity and boosting query efficiency.

Led successful migration of legacy BI platforms (SSRS, Tableau) to Power BI, modernizing analytics workflows and aligning with cloud-first strategies.

Authored and fine-tuned advanced SQL queries, enabling faster reporting turnaround and deeper analytical capabilities across large datasets.

Championed Power BI governance best practices, overseeing workspace configurations, access controls, row-level security (RLS), and audit readiness.

Conducted performance tuning of BI solutions, resolving bottlenecks and reducing report load time by over 50% in mission-critical dashboards.

Collaborated with data engineering and architecture teams to enhance the organization’s centralized data warehouse using dimensional modeling and star schema design.

Participated in client demos and pre-sales initiatives, showcasing BI capabilities to business units and contributing to successful onboarding of new projects.

Technical Environment: Power BI, SSRS, Excel, Tableau, Power Query, DAX, SQL, Python, Azure Data Factory, Informatica, SQL Server, Oracle, MySQL, PostgreSQL, Microsoft Azure, AWS, PowerShell, Azure DevOps, GitHub, Jenkins, Power BI REST API, Web Services, OData, JSON, Microsoft Fabric, Row-Level Security (RLS), Azure Active Directory (AAD), Microsoft Teams, SharePoint, JIRA, Confluence, Git, TFS, KPI Scorecards, Interactive Dashboards, Data Storytelling, Infographics.

Client: Southwest Airlines, Dallas, TX March 2023 – August 2024

Role: Senior Power BI Developer

Responsibilities:

Collaborated cross-functionally with business analysts, data engineers, and product owners to gather, analyze, and translate complex requirements into scalable BI solutions.

Integrated Microsoft Fabric to modernize data lake storage and streamline data movement using Lakehouse and Pipelines.

Implemented Delta Lake format in One Lake for performance-tuned analytics and governed reporting.

Led the development of ad-hoc and scheduled operational dashboards, delivering real-time insights to support revenue management, customer analytics, and fleet operations.

Designed and implemented robust ETL frameworks that consolidated data from Oracle, SQL Server, and flat files into a centralized reporting repository.

Developed complex DAX calculations and computed tables within Power BI to enhance analytical depth and visual interactivity.

Integrated PL/SQL components into ETL pipelines and executed optimized stored procedures to streamline data transformations and increase processing efficiency.

Created Python scripts using PyMongo for dynamic data ingestion from NoSQL databases like MongoDB, supporting advanced reporting use cases.

Automated secure data transfers and processing workflows using Linux shell scripting, including encryption, decryption, and SFTP automation.

Architected and maintained data integrations with Azure Blob Storage, enabling seamless import/export of structured files (CSV) into reporting ecosystems.

Developed and deployed interactive dashboards using Power BI, Power Pivot, Power View, and Power Map, enabling data storytelling across mobile and web platforms.

Published and managed reports in the Power BI Service, configuring Enterprise and Personal Gateways for real-time refresh and improved performance.

Engineered end-to-end ETL solutions using SSIS and Informatica Power Exchange, facilitating data integration across cloud, on-premises, and legacy systems.

Administered the TIBCO Spotfire platform, including data modeling, information link development, and platform support to ensure reporting continuity.

Leveraged REST APIs and Python for loading structured/unstructured data into Google Big Query, utilizing GCP components such as DataProc, GCS, and Cloud Functions.

Collaborated with data architects and DBAs to design Star and Snowflake schemas, enhancing data normalization and query performance in warehouse solutions.

Conducted performance tuning of SQL and PL/SQL routines, improving query efficiency and system responsiveness for business-critical dashboards.

Engaged in freelance and personal development projects to gain hands-on experience with Informatica IDMC, multidimensional cubes, and OLAP modeling.

Mentored junior BI developers on Power BI, Informatica, and best practices in modern data stack design and visualization techniques.

Contributed to continuous improvement initiatives and knowledge-sharing sessions, enhancing BI maturity and adoption across the enterprise.

Technical Environment: Power BI, Power Pivot, Power View, Power Map, SQL Server, Azure SQL DB, Oracle, ETL (SSIS, Informatica Power Exchange), DAX, Microsoft Fabric, Azure Blob Storage, Power BI Gateway (Enterprise & Personal), TIBCO Spotfire, SFTP, Python, REST APIs, MongoDB, GCP (Big Query, DataProc, Cloud Functions, GCS), PL/SQL, Data Modelling (Star & Snowflake), Shell Scripting (Linux).

Client: CVS Health, Providence, RI June 2022 – Feb 2023

Role: Power BI Developer

Responsibilities:

Designed and developed data visualization solutions in adherence to business requirements, ensuring seamless alignment with project plans.

Implemented best practices for Oracle database administration and optimization.

Utilized business requirement documents to create interactive dashboards, providing a user-friendly data representation.

Managed extensive datasets, performing aggregation, organization, and preparation for in-depth business analysis.

Implemented row-level security for visuals, enhancing data protection measures.

Developed complex calculated measures using Data Analysis Expression (DAX), contributing to advanced analytics capabilities.

Conducted performance tuning and optimization of PL/SQL code for enhanced query performance.

Developed and optimized PL/SQL scripts, stored procedures, and functions for data processing and manipulation.

Implemented table partitioning and indexing techniques, resulting in a remarkable 90% improvement in performance.

Expert in developing web-reporting applications using WEB focus Scheduling the reports using Report Caster, deploying the reports on web pages using HTML hyperlinks, creating web based too

Implemented error handling and transaction management within PL/SQL code.

Deployed and scheduled reports using SSRS, facilitating regular and timely reporting cycles.

Created and optimized stored procedures, significantly reducing report rendering time from 15 minutes to 30 seconds.

Administered Linux servers, ensuring their stability, security, and optimal performance.

Improved existing WEB Focus reports as per the new Requirements and converted few WEB Focus reports to either DataStream reports or DOMO reports.

Designed and developed Power BI dashboards and reports, ensuring a visually appealing and insightful representation of data.

Published dashboards and reports on the Power BI service, promoting accessibility across the organization.

Created SSIS Packages with various transformations, including Derived Columns, Pivot Transformation, and Condition Split.

Check daily jobs and verify databases in order to ensure the correct flow of data from different systems like IFS (Industrial and Financial Systems) which is a Oracle Financial ERP system for Confidential, WMS (Warehouse Management system), Pivotal system which holds retail and distributor data.

Extracted and cleansed data from diverse sources, such as Excel Spreadsheets, Text files, MS Access, and CSV files.

Utilized MDX to interact seamlessly with back-end OLAP Services, enhancing data connectivity.

Employed Power Query in Power BI for effective data cleansing and massaging.

Executed routine maintenance tasks and applied security patches to Linux-based systems.

Extracted data from various sources, including SQL Server, Oracle, and SQL Azure, into Power BI.

Created complex Crystal Reports, including Ad Hoc Reports, Frequency Reports, and Summary Reports.

Implemented parameters, sub-reports, crosstabs, and charts in Crystal Reports, enhancing reporting flexibility.

Provided ongoing maintenance, bug fixes, and development for existing and new Power BI reports.

Contributed to continuous enhancements and actively participated in resolving production problems.

Implemented Performance Tuning and Query Optimization, addressing blocking and transactional deadlocks.

Building a Scala and spark based configurable framework to connect common Data sources like MYSQL, Oracle, Postgres, SQL Server, Salesforce, Big query and load it in big query.

Coordinated with team and Developed framework to generate Daily adhoc reports and Extracts from enterprise data from Big Query.

Proficient in data visualization tools such as Tableau and Power BI, which have OLAP capabilities.

Experience with SQL and other data manipulation languages that are foundational for OLAP technology.

Extensive experience with data analysis, SQL, and data manipulation languages that provide a strong foundation for learning Informatica.

Developed and optimized ETL pipelines with Informatica Power Exchange, enabling seamless data extraction, transformation, and loading from various sources.

Created detailed documentation of ETL processes, mappings, and workflows to facilitate knowledge transfer and maintain high standards of project delivery.

Extensive experience in data modelling using both Star and Snowflake schema designs for data warehousing and business intelligence solutions.

Designed ETL processes to load data into Star and Snowflake schemas, ensuring data consistency and integrity.

Technical Environment: Power BI, SSRS, SSIS, Crystal Reports, Oracle, SQL Server, IFS (ERP), WMS, Pivotal, DAX, Power Query, MDX, Excel, Access, CSV, WEB FOCUS, DOMO, Scala, Spark, Big Query, Linux, Informatica Power Exchange, Data Warehousing, Star/Snowflake Schema, Performance Tuning, Query Optimization

Client: Freddie Mac – TX July 2020 – May 2022

Role: Power BI Developer

Responsibilities:

Collaborated intensively with business users, ensuring a thorough understanding of nuanced business requirements and accommodating changes seamlessly.

Designed and developed dashboards tailored to showcase intricate customer-related information, aligning with the unique demands of the financial services sector.

Integrated Linux tools into the data processing pipeline for efficient file handling.

Responded to specific business requests by developing visualizations using Power BI, ensuring a user-friendly and insightful representation of data.

Engineered end-to-end Power BI solutions, creating reports, visualizations, and dashboards that precisely met business requirements, subsequently publishing them for widespread enterprise access.

Leveraged the DAX programming language for measure creation, employing DAX formulas to execute accurate and meaningful calculations.

Managed table relationships in Power BI using a star schema, optimizing data connectivity and relationships for efficient reporting.

Implemented a variety of slicers in Power BI to enhance report interactivity and user experience.

Worked on diverse report types, including Yearly, Quarterly, Monthly, and Daily reports, tailoring each to the specific analytical needs of stakeholders.

Designed and deployed reports with advanced features such as Drill Down, Drill Through, drop-down menus, and parameterized and Linked reports.

Employed various transformations available in Power BI Query Editor to streamline data processing and enhance report accuracy.

Utilized Power Query in Power BI for dynamic Pivot and Un-pivot operations in the data model, ensuring robust data cleansing and massaging.

Applied a range of DAX functions for fact calculations, ensuring efficient and meaningful data visualization in Power BI.

Scheduled and managed data refresh for dashboards and reports, ensuring timely access to updated information.

Contributed to continuous improvement and optimization of the Power BI environment at Freddie Mac, addressing evolving business needs.

Collaborated with cross-functional teams to enhance data-driven decision-making capabilities and promote Power BI best practices.

Conducted training sessions to empower end-users with effective use of Power BI features and functionalities.

Participated in the creation and optimization of SQL objects, supporting evolving reporting requirements.

Ensured compliance with security standards for Linux-based data processing.

Implemented performance tuning strategies to enhance report rendering and overall system efficiency.

Collaborated in the identification and resolution of system bottlenecks, ensuring smooth Power BI service operations.

Engaged in ongoing knowledge transfer sessions to share insights and expertise within the project team.

Technical Environment: Power BI, DAX (Data Analysis Expression), Power Query, SQL Server, Power BI Query Editor, Data Modelling (Star Schema), Financial Services Data, Report Optimization Techniques, SQL Objects

Client: Zenser Technologies, India Sept 2015 – Nov 2018

Role: Power BI Developer

Responsibilities:

Actively participated in the meticulous gathering of Business Requirements and System Specifications, ensuring a comprehensive understanding of project needs.

Collaborated closely with business users, conducting thorough discussions to comprehend complex business processes and project requirements.

Translated gathered insights into detailed ETL Design Specifications, providing a robust foundation for subsequent development phases.

Designed and developed a variety of SQL Server Database objects, including Tables, Views, Indexes, Stored Procedures, User Defined Functions, and Triggers, aligning with specific business requirements.

Created and optimized Clustered and Non-Clustered Indexes, strategically enhancing SQL Server performance and data retrieval efficiency.

Developed SSIS Packages, incorporating OLE DB connections from heterogeneous sources (Excel, Flat Files, XML, ADO.NET) and employing diverse transformations (Slowly Changing Dimension, Data Conversion, Derived Column, Lookup, Conditional Split, Merge, and Union All).

Implemented comprehensive debugging, logging, error handling, and event handling mechanisms for SSIS packages, ensuring robust package execution and error resolution.

Designed SSIS packages featuring tasks and transformations such as SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, and Derived Columns.

Utilized SSRS and Power BI to generate detailed reports related to Claims, Policyholders, and Policy coverage, ensuring the delivery of actionable insights.

Developed a diverse range of business reports, including Chart reports, Sub reports, Drill-down reports, Drill-through reports, and Parameterized reports, deploying and scheduling them in Report Manager for routine reporting cycles.

Produced and maintained business reports and dashboards using both Power BI Server and Power BI Desktop, ensuring accessibility and relevance.

Created new reports in Power BI and executed the migration of legacy SSRS reports to Power BI, leveraging various visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, and Tree map.

Developed and optimized PL/SQL scripts, stored procedures, and functions for data processing and manipulation.

Utilized advanced Data Analysis Expressions (DAX) functions to create new Calculated Columns and Calculated Fields in Tabular model projects, enhancing data analysis capabilities.

Automated Power Query data refresh using a Windows PowerShell script, seamlessly integrating with the Windows Task Scheduler in Power BI Desktop.

Automated Data Refresh by creating a detailed and scheduled refresh plan in Power BI Server reports, ensuring up-to-date information for end-users.

Established a robust Security Model (Row-level security) in Power BI, restricting access based on specific geographic regions.

Collaborated with cross-functional teams to enhance data-driven decision-making capabilities and promote Power BI best practices within the organization.

Conducted engaging training sessions to empower end-users with effective use of Power BI features and functionalities.

Contributed to the creation and optimization of SQL objects, ensuring scalability and efficiency in supporting evolving reporting requirements.

Implemented performance tuning strategies to enhance report rendering speed and overall system efficiency.

Created various SSIS packages for data movements and transformations. Worked on Python code to load data from Google buckets to big query tables, used data flow for ELT (Extract Load Transform) in Big Query.

Technical Environment: Power BI, SQL Server, SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services), Data Analysis Expressions (DAX), Windows PowerShell, Power Query, SQL Server Data Tools, Windows Task Scheduler, Security Model (Row-level security)

Client: IVY Comptech – India June 2013 – Aug 2015

Role: SQL Developer

Responsibilities:

Played a pivotal role in the complete Software Development Life Cycle (SDLC) process, meticulously analysing business requirements and understanding the functional workflow of information.

Designed and developed SSIS Packages for the import of data from Oracle databases in the form of flat files, transforming, and loading data into SQL Server databases.

Implemented robust error handling through the utilization of Common Table Expressions (CTEs).

Created Clustered/Non-clustered indexes, views, and stored procedures for optimized data access and retrieval.

Demonstrated proficient use of Joins and sub-queries in SQL queries for retrieving data from multiple tables.

Transformed data into SQL Server databases by developing views, staging tables, and loading data into tables using Stored Procedures.

Participated in the development and debugging of complex T-SQL procedures and functions.

Upgraded SSIS packages for an entire application from 2005 to 2008 using Project wizard and successfully deployed packages.

Managed the complete migration of SQL Server 2008 R2 to SQL Server 2012, ensuring a seamless transition.

Utilized the Automated Processing Environment (APE) Application for automating daily SQL jobs and executing packages automatically.

Engaged in the Waterfall model of SDLC, actively gathering business requirements from Business Analysts.

Recorded results of validation and bugs related to the project in Gemini, acting as the tracking system.

Provided organizational reporting and timely reports using SSRS (SQL Server Reporting Services).

Leveraged SSRS for the development of reports for Business users from different sources like tables, stored procedures, and various report types.

Developed different types of reports, including Parameterized reports, Drill-down reports, Ad-hoc reports, Snapshot reports, and Sub reports.

Deployed SSRS reports into Report Manager, actively managing report subscriptions, delivery, generation, and rendering.

Maintained and supported Microsoft Team Foundation Server (TFS) for secure code, SSIS Packages, and Reports, utilizing it as a repository for code comparison.

Built a Reporting database, serving as a mirror database to the existing OLTP database, specifically used for reporting purposes.

Technical Environment: SQL Server, SSIS (SQL Server Integration Services), Common Table Expressions (CTEs),

T-SQL, APE (Automated Processing Environment), Waterfall SDLC Model, SSRS (SQL Server Reporting Services), Microsoft Team Foundation Server (TFS)

Education:

Bachelor of Technology in Mechanical Engineering Aug 2009 – May 2013

Vidya Jyothi institute of Technology [GPA-3.10] Hyderabad, India

Master of Science in Business Analytics Jan 2019 – May 2020

Lewis University [GPA-3.80] Romeoville, Illinois

Contact this candidate