Yohan Wode
Stamford
Summary
- Detail-oriented Power BI Developer with 4+ years of experience in Data Analytics, Business Intelligence, and Data Warehousing, leveraging SQL Server, MSBI Stack (SSIS, SSRS, SSAS), and Power BI.
- Proven ability to build dynamic dashboards and reports in Power BI and SSRS, enhancing data visualization for business insights.
- Strong T-SQL development skills, specializing in writing optimized stored procedures, views, functions, and triggers for scalable database performance.
- Experienced in Power BI Desktop, Power BI Service, and Power BI Mobile, developing interactive reporting solutions accessible across devices.
- Capable of gathering and analyzing business requirements, ensuring robust data models and insightful reporting structures.
- Proficiency in Power BI Reports, Crystal Reports, SSRS, and MDX-based reporting solutions, integrating multidimensional data for better analytics.
- Expert at creating scheduled and on-demand reports using SQL Server Reporting Services, streamlining organizational reporting needs.
- In-depth knowledge of data warehousing strategies, including star schema modeling, fact and dimension table relationships, and OLAP solutions.
- Expert in relational database modeling, ensuring optimal data structuring for analytical efficiency.
- Strong understanding of ETL development, using SSIS and Power Query to integrate diverse data sources for business intelligence.
- Hands-on experience configuring Power BI Gateway, Power Pivot, and Power View for streamlined data processing and reporting.
- Proficient in data transformation techniques, including DAX expressions, calculated measures, filtering, and data cleansing.
- Skilled in data integration from multiple sources, optimizing datasets for high-performance Power BI reports.
- Well-versed in Power Platform tools, using Power Automate for workflow automation and notification triggers.
- Strong troubleshooting skills in Power BI workspace and report failures, ensuring seamless production support.
- Excellent communication and teamwork skills, working closely with business stakeholders and development teams to refine data insights.
Overview
7
7
years of professional experience
1
1
Certification
Work History
Data Analytics/Power BI Developer
Synchrony Financial
04.2024 - Current
- Designed and implemented data models in Power BI, applying DAX calculations and aggregations for performance optimization
- Developed and maintained SQL queries and stored procedures, ensuring efficient data retrieval and transformation
- Created interactive dashboards in Power BI, integrating various visualization techniques such as line charts, bar charts, and maps
- Utilized Power Query and ETL techniques to clean, transform, and merge data from different sources
- Published Power BI reports and dashboards to the Power BI Service, configuring automated refresh schedules
- Configured data source connections, optimizing performance in import and Direct Query modes
- Developed and deployed customized SSRS reports, integrating them with Power BI for enhanced analytics
- Provided end-user training and documentation to enhance adoption of Power BI reports across departments
- Worked with stakeholders to define KPIs, report requirements, and business logic for accurate data representation
- Integrated Power Automate with Power BI to automate reporting processes and alert mechanisms
Data Analytics/SQL/SSIS/SSRS/Power BI Developer
FNB
03.2021 - 03.2024
- Designed and developed Power BI dashboards and reports, focusing on user-friendly interactive visualizations and real-time data analysis
- Created SQL-based ETL pipelines using SSIS, improving data consistency and reporting efficiency
- Developed DAX expressions to perform complex calculations and aggregate data for various reporting needs
- Built data models in Power BI, applying fact and dimension tables for structured data organization
- Configured Power BI Service and on-premises data gateways, enabling seamless data access and refresh
- Integrated multiple data sources including SQL Server, Azure SQL DB, and Excel, ensuring a unified reporting experience
- Implemented Power Query transformations to enhance data accuracy, consistency, and usability
- Optimized Power BI performance by reducing data refresh times and minimizing report processing overhead
- Developed custom reports in SSRS and Power BI, ensuring flexibility and scalability in data visualization
- Collaborated with teams to understand business requirements and deliver customized, insightful reporting solutions
SQL / Power BI Developer
Home Depot
02.2018 - 02.2021
- Designed and managed end-to-end ETL pipelines, automating data extraction, transformation, and integration for structured reporting
- Built and optimized Power BI dashboards, using DAX calculations, measures, and filters to improve business insights and KPIs tracking
- Configured Power BI Gateway and Dataflows, enabling real-time reporting from cloud and on-premise databases
- Created SQL stored procedures and functions, ensuring optimized query performance for Power BI and SSRS reports
- Developed Power Query transformations, including data cleansing, merging, pivoting, and unpivoting for structured data models
- Scheduled and automated Power BI report refresh cycles, reducing manual data update efforts
- Designed relational and dimensional data models using fact and dimension tables, optimizing report generation efficiency
- Implemented row-level security (RLS) and workspace permissions, ensuring controlled data access for different user roles
- Assisted in migrating SQL Server databases from older versions to SQL Server 2019, improving scalability and reliability
- Provided support and troubleshooting for SQL Server, Power BI reports, and SSIS workflows, ensuring smooth system performance
Education
Bachelor’s -
computer science
Skills
- SQL Server
- T-SQL
- Oracle Database
- Azure SQL DB
- Cosmos DB
- SSRS
- SSAS
- SSIS
- MariaDB
- Power BI
- Qlik Sense
- Tableau
- Data Modeling
- DAX
- Power Query
- Data Blending
- Business Intelligence
- Python
- PowerShell
- JavaScript
- R
- M Language for Power Query
- REST API Development
- Microsoft 365
- Excel
- Macros
- Power Pivot
- Access
- OneDrive
- Outlook
- SharePoint
- Git
- Power Automate
- JIRA
- Azure Data Lake
- Snowflake
Technical Skills
SQL Server, T-SQL, Oracle Database, Azure SQL DB, Cosmos DB, SSRS, SSAS, SSIS, MariaDB, Power BI, Qlik Sense, Tableau, Data Modeling, DAX, Power Query, Data Blending, Business Intelligence, Python, PowerShell, JavaScript, R, M Language for Power Query, REST API Development, Microsoft 365, Excel (Macros, Power Pivot, Power Query), Access, OneDrive, Outlook, SharePoint, Git, Power Automate, JIRA, Azure Data Lake, Snowflake
Certification
Microsoft Power Platform Developer
Timeline
Data Analytics/Power BI Developer
Synchrony Financial
04.2024 - Current
Data Analytics/SQL/SSIS/SSRS/Power BI Developer
FNB
03.2021 - 03.2024
SQL / Power BI Developer
Home Depot
02.2018 - 02.2021
Bachelor’s -
computer science
Similar Profiles
RAJSHREE SAINIRAJSHREE SAINI
Manager, Portfolio Credit at Synchrony FinancialManager, Portfolio Credit at Synchrony Financial
Naheed Sultana NazneenNaheed Sultana Nazneen
Senior Quality Analyst-Fraud & Collection Process at Synchrony FinancialSenior Quality Analyst-Fraud & Collection Process at Synchrony Financial
Katakam Akanksha ReddyKatakam Akanksha Reddy
Senior Representative-Universal Fraud at Synchrony FinancialSenior Representative-Universal Fraud at Synchrony Financial
Rajat GuptaRajat Gupta
Manager, Analytics - Customer Insights at Synchrony FinancialManager, Analytics - Customer Insights at Synchrony Financial
Megan DancyMegan Dancy
Pastry Chef Intern at The Grand Hotel Golf Resort & Spa, Autograph CollectionPastry Chef Intern at The Grand Hotel Golf Resort & Spa, Autograph Collection