Harsha L
Summary
Microsoft Certified Power BI Developer with extensive experience in data processing, visualization, and optimization. Proficient in developing and automating comprehensive Power BI reports, migrating legacy systems, and optimizing data models for improved accuracy and performance. Skilled in SQL, DAX, and Python, with a strong background in conducting API testing, troubleshooting SSIS packages, and providing on-call support. Recognized for creating effective visualizations, enforcing documentation standards, and collaborating with business analysts and ETL developers to ensure seamless data integration and performance optimization.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Data and BI Engineer
E2 Consulting Engineers Inc.
08.2024 - Current
- Led the end-to-end delivery of data analytics projects, collaborating with cross-functional teams to solve complex business challenges, align data strategies with organizational goals, and deliver measurable outcomes.
- Designed and developed Power BI dashboards for supply chain optimization, financial forecasting, and resource planning, empowering leadership to make confident, data-driven decisions, saving over 15 hours per week in manual analysis.
- Created advanced DAX calculations to address complex analytical needs, delivering insightful visualizations that support strategic initiatives.
- Automated manual workflows with Power Automate, streamlining processes, saving significant time, and boosting team productivity by 30%.
- Built enterprise-grade Dataflows integrating sources such as SAP HANA and Amazon Athena, ensuring seamless data connectivity and robust pipelines.
- Optimized Power BI report performance by refining queries and enhancing data models, reducing refresh times by 60% and significantly improving efficiency.
- Designed the Construction GIS Dashboard using ArcGIS to visualize underground distribution projects, integrating geospatial data and project status tracking, resulting in faster issue resolution and improved contractor oversight.
- Developed the All Dates Grid Dashboard, centralizing project management data with custom filters and heatmaps to highlight discrepancies, driving transparency and accountability.
- Developed a Column Selector Dashboard to consolidate KPIs from multiple data sources, enabling users to dynamically select relevant columns via a checkbox interface, reducing clutter and enhancing usability.
- Created impactful reports to track the removal of overhead lines and poles, enabling efficient monitoring of transitions from overhead to underground services.
- Developed environmental compliance dashboards to monitor reviews, releases, and milestones, ensuring regulatory adherence and advancing project goals.
- Designed a comprehensive Supply Chain Dashboard to track material availability, utilization, and inventory levels, optimizing resource allocation and preventing delays.
- Built Safety Dashboards to monitor safety observations, incidents, and vendor performance, identifying high-risk areas and driving targeted training programs.
- Automated the data validation process in Power BI, introducing real-time alerts to detect and address discrepancies proactively.
- Streamlined reporting workflows by enhancing drill-through and cross-filtering functionalities, making reports more intuitive and actionable for decision-makers.
- Played a pivotal role in developing a Request for Proposal (RFP) by leveraging project expertise to align with requirements and showcase capabilities.
- Modernized data systems by replacing legacy pipelines with cleaner, more accurate data sources, improving data quality and enabling advanced filtering options.
- Established version control for Power BI reports using ALM Toolkit and SharePoint, ensuring seamless updates, enhanced collaboration, and reliable version management.
- Delivered custom Power BI visuals using Deneb, addressing unique business needs and enhancing decision-making capabilities.
Business Intelligence Developer
Citizens Property Insurance Corporation
08.2022 - 08.2024
- Develop and optimize data processing and visualization solutions, enhancing system efficiency and user experience.
- Transform raw data into meaningful KPIs for directors, enabling strategic decision-making.
- Routinely update and optimize legacy SQL code to align with current business requirements, enhancing functionality and performance.
- Utilized DAX Studio and Performance Analyzer to identify and resolve performance bottlenecks in Power BI reports.
- Conduct thorough reviews of reporting systems to address issues such as missing historical data, unnecessary fields, or missing records.
- Created Rally agile reports to track user stories, defects, sprints, backlogs, and departmental user story distribution.
- Designed and implemented Kudos and Serve Award Reports, enabling HR to recognize employees for quarterly awards and potential pay scale increases.
- Developed Power BI metadata reports, analyzing report usage, identifying performance bottlenecks, and assessing concurrency.
- Implemented incremental refresh techniques for large dataset models, significantly improving refresh performance and reducing refresh times by nearly 70%.
- Leveraged Databricks to import MyService ticket data via API, convert them into parquet files, and utilize Synapse to create external tables.
- Developed comprehensive reports for the ServiceNow ticket system to analyze ticket resolution efficiency and suggest mitigation strategies.
- Collaborated with systems developers to create and test Orbeon forms, ensuring data accuracy and seamless production deployment.
- Conducted API testing using SOAP API for Orbeon forms, ensuring functionality and accuracy.
- Employed Python to develop fuzzy logic for address matching, enhancing the accuracy of customer activity analysis.
- Utilized Python libraries such as Pandas and NumPy to clean and preprocess large datasets, ensuring data quality and consistency.
- Conducted calculations on large datasets using group-by operations and aggregations in Pandas to derive performance metrics and insights.
- Performed exploratory data analysis (EDA) using Python to identify trends, correlations, and outliers, providing actionable insights.
- Assisted in retiring outdated data mart tables, using source tables to recreate approximately 30 reports.
- Created dashboards for the infrastructure team to monitor active on-prem physical servers, VMs, CSX, and Azure cloud usage.
- Developed audit reports with historical tables to limit the computational load on SQL servers.
- Developed a server patching report for the Network Administration team, detailing patch status, occupancy, and failures. This report helped identify months with the highest failure rates and accountability, facilitating more efficient patch management and compliance tracking.
- Developed and enforced a documentation standard within Power BI for every report, significantly reducing onboarding time for new reporters by clearly outlining the report's functionalities and data processes, saving them approximately 8-16 hours per report.
- Assisted with creating and maintaining stored procedures and views to resolve reporting issues, ensuring data accuracy.
- Proficient in advanced SQL techniques including complex joins, subqueries, window functions, and CTEs to efficiently query and manipulate large datasets.
- Skilled in performance tuning and optimization of SQL queries using indexing, execution plans, and query refactoring to ensure optimal performance.
- Experienced in utilizing advanced data manipulation techniques such as dynamic SQL for flexible query capabilities, and automation of data transformation processes to support scalable data workflows.
- Automated around 30 reports using Power Automate, enhancing delivery efficiency by 50% and saving approximately 20 hours per week.
- Developed and enforced documentation standards within Power BI, significantly reducing onboarding time for new reporters.
- Led a Power BI seminar for business leaders to improve data literacy and empower self-service analytics.
- Proficient in using DAX (Data Analysis Expressions) to create custom calculations and measures to derive insights from large datasets.
- Skilled in developing sophisticated data models using Power BI's data modeling capabilities, including the implementation of star schema designs to enhance data retrieval efficiency and analytic capabilities.
- Utilized Power BI's M Query for data extraction and transformation processes, optimizing data import and manipulation tasks to prepare detailed reports.
- Experienced in setting up and managing data gateways, scheduled refreshes, and incremental data loads to ensure timely and accurate data availability.
- Implemented security practices within Power BI environments, configuring row-level security (RLS) to ensure data safety and compliance.
- Troubleshot data issues by analyzing SSIS packages and collaborating with ETL developers.
- Provided on-call support for troubleshooting and resolving failed packages, ensuring minimal downtime and maintaining data flow integrity.
Jr Business Intelligence Developer
SIRI NEXTGEN IT SOLUTIONS INC
06.2021 - 08.2022
- Led the migration and enhancement of the company's reporting system from Cognos to Power BI, boosting data analysis capabilities.
- Took responsibility for approximately 30 Cognos reports, creating a comprehensive Power BI data model and developing multiple versions of Paginated reports using DAX and SQL code.
- Continuously developed and optimized a range of data processing and visualization solutions, applying advanced data modeling techniques.
- Spearheaded efforts to revitalize legacy reporting systems, employing strategic data management practices.
- Troubleshot data issues by analyzing SSIS packages and collaborating with ETL developers.
Part Time Report Developer
University of North Florida
11.2020 - 04.2021
- Migrated and transformed Excel reports to Tableau, enhancing data visualization and interactive dashboard capabilities.
- Developed Career Fair, Enrollment and Retention, and Resource Utilization dashboards, delivering actionable insights.
- Compiled "Student Wishlist" reports from survey data, identifying areas for improvement.
- Prepared and delivered PowerPoint presentations to university leaders, summarizing data-driven insights.
Education
Bachelor of Science - Computer And Info Science, Information Technology
University of North Florida
Jacksonville, FL08.2022
Skills
- Python (PySpark, Pandas, NumPy)
- Microsoft SQL Server
- Databricks
- Azure Synapse
- Power BI
- Paginated Reports
- SSRS
- SSIS
- Tableau
- Azure
- DAX
- M Query
- Agile Methodology (Rally Software)
- ServiceNow
- COGNOS IBM
- Measure Killer
- Power BI ALM Tool Kit
Websites
Certification
- Microsoft Certified: Power BI Data Analyst Associate, 12/01/22
- Tableau Desktop Specialist, 08/01/22
Timeline
Data and BI Engineer
E2 Consulting Engineers Inc.
08.2024 - Current
Business Intelligence Developer
Citizens Property Insurance Corporation
08.2022 - 08.2024
Jr Business Intelligence Developer
SIRI NEXTGEN IT SOLUTIONS INC
06.2021 - 08.2022
Part Time Report Developer
University of North Florida
11.2020 - 04.2021
- Microsoft Certified: Power BI Data Analyst Associate, 12/01/22
- Tableau Desktop Specialist, 08/01/22
Bachelor of Science - Computer And Info Science, Information Technology
University of North Florida
Similar Profiles
Nicole GuestNicole Guest
PROGRAM MANAGER at E2 Consulting Engineers, Inc.PROGRAM MANAGER at E2 Consulting Engineers, Inc.
Luis RuizLuis Ruiz
Project Coordinator/Specialist at E2 Consulting Engineers Inc.Project Coordinator/Specialist at E2 Consulting Engineers Inc.
Ian RichardsonIan Richardson
Project Engineer at E2 EngineersProject Engineer at E2 Engineers