LEAD BUSINESS INTELLIGENCE DEVEPLOER
ABC FITNESS
Managed a team of 7 report developers, including delegating tasks to specific developer, taking into consideration their personality, area of expertise, and years of experience.
Assembled and led a team of Power BI developers to create reports and guide them on nay technical challenges.
Design, construct, create, and maintain efficient and reliable data pipelines to move data across systems. This involves extracting data from various sources, transforming it into a usable format, and loading it into storage.
Design and implement scalable, distributed, and high-performance data storage systems. Choose appropriate storage technologies and data models based on the specific requirements of the organization.
Integrate different data sources to ensure consistency and accuracy in data reporting and analysis. This might involve working with structured and unstructured data from various databases, APIs, and file systems.
Clean, transform, and preprocess data to prepare it for analysis. Apply data transformation techniques such as normalization, aggregation, and feature engineering to ensure data quality and relevance.
Implement data quality checks and validation processes to identify and rectify data inconsistencies, errors, and missing values. Ensure data accuracy and reliability for analytical purposes.
Experience administrating or connecting data sources like Azure Data Lake, Azure SQL, Azure Databricks, Azure Synapse, Snowflake, etc. for data ingestion in an analytics platform.
Follow and implement industry best practices for a better time to market using the latest CI/CD technologies and automate day-to-day tasks.
Develop enterprise-grade distributed products that can perform, scale, and integrate into a broad enterprise ecosystem.
July 2023 - Present
SENIOR BUSINESS INTELLIGENCE DEVELOPER
ABC FITNESS
Design, construct, create, and maintain efficient and reliable data pipelines to move data across systems. This involves extracting data from various sources, transforming it into a usable format, and loading it into storage.
Integrate different data sources to ensure consistency and accuracy in data reporting and analysis. This might involve working with structured and unstructured data from various databases, APIs, and file systems.
Clean, transform, and preprocess data to prepare it for analysis. Apply data transformation techniques such as normalization, aggregation, and feature engineering to ensure data quality and relevance.
Connect different data sources like Databricks, Snowflake, Azure Data Lake, SQL Server Analytics Services, ODBC-based data sources, etc. for data ingestion in the Power BI platform.
Set up and troubleshoot Power BI Gateway and Virtual Network Data Gateway for data source connectivity.
Develop enterprise-grade distributed products that can perform, scale, and integrate into a broad enterprise ecosystem.
Collaborated with business users, collect requests, and updated the set of existing BI reports accommodating business needs.
Implemented 3 fully functional data schemes and 10+ data flow optimization processes for reporting performance and enhancements.
Analyses current ETL process, define and design new systems.
Redefine and make technical/strategic changes to enhance existing Business Intelligence systems.
SQL querying for best results, use of filters and graphs for better understanding of data.
Work with users and team members at all levels for performance improvement and suggestions.
November 2022 - July 2023
POWER BI REPORT DEVELOPER
ABC FITNESS
Power BI development and administration.
Understand business requirements in BI context and design data models to transform raw data into meaningful insights. into meaningful insights.
Create dashboards and interactive visual reports using Power BI. Identify key performance indicators (KPIs) with clear objectives and consistently monitor -those.
Chart creation and data documentation explaining algorithms, parameters, models, and relations.hose.
Design, develop, test, and deploy Power BI scripts and perform detailed analytics.ons.
Perform DAX queries and functions in Power BI.
Analyses current ETL process, define and design new systems.
Redefine and make technical/strategic changes to enhance existing Business Intelligence systems.
SQL querying for best results, use of filters and graphs for better understanding of data.tems SQL querying for best results, use of filters and graphs for better understanding of data.
Work with users and team members at all levels for performance improvement and suggestions.
November 2021 - November 2022
POWER BI REPORT DEVELOPER BUSINESS ANALYST
FITNESS BI
Power BI development and administration.
Understand business requirements in BI context and design data models to transform raw data into meaningful insights.
Create dashboards and interactive visual reports using Power BI.
Identify key performance indicators (KPIs) with clear objectives and consistently monitor those.
Chart creation and data documentation explaining algorithms, parameters, models, and relations.
Design, develop, test, and deploy Power BI scripts and perform detailed analytics.
Perform DAX queries and functions in Power BI.
Analyses current ETL process, define and design new systems.
Redefine and make technical/strategic changes to enhance existing Business Intelligence systems SQL querying for best results, use of filters and graphs for better understanding of data
Work with users and team members at all levels for performance improvement and suggestions
November 2020 - November 2021
SENIOR SOFTWARE ENGINEERING ANALYST
ACCENTURE
Power BI development and administration.
Building Analysis Services reporting models.
Developing visual reports, dashboards and KPI scorecards using Power BI desktop.
Connecting to data sources, importing data, and transforming data for Business Intelligence.
Excellent in analytical thinking for translating data into informative visuals and reports.
Able to implement row-level security on data and have an understanding of application security layer models in Power BI.
Proficient in making DAX queries in Power BI desktop.
Expertise in using advanced-level calculations on the data set.
Adept in developing, publishing, and scheduling Power BI reports as per business requirements.
Able to properly understand the business requirements and develop data models accordingly by taking care of the resources.
Creating Modules as per requirement. Develop GUI interfaces using Open Database.
Connectivity (ODBC) to connect to Access and SQL Relational Database Management Systems (RDBMS).
Building a web-based application in this role and now responsible for maintaining/managing the same. This application is a website https://cmtdex.accenture.com (accessible only to DEX leads) and contains dashboards related to governance of delivery in CMT
August 2015 - November 2020