About
With a robust foundation in Power BI and a comprehensive grasp of data analytics, I specialize in developing intricate business intelligence solutions that drive decision-making and operational efficiency. My expertise extends to SQL Server, SSIS, SSRS, and DAX language, enabling me to design dynamic, impactful BI reports and dashboards that highlight key performance indicators and business insights.
Dedicated to continuous improvement and innovation, I thrive in environments that challenge my skills in ETL processes and data visualization, leveraging agile methodologies and SDLC best practices to deliver exceptional outcomes. My proactive approach in collaborative settings, coupled with a keen ability to adapt to new technologies, ensures that I provide valuable contributions to any data-driven project. Engage me to enhance your organization’s data strategies and uncover actionable insights that foster growth and success.
Looking for Full-TimeHours Available / Wk - 40 hrs
Portfolio
_dDlV6.gif&h=190&w=185 "Predictive Employee Attrition")
Predictive Employee Attrition
This project utilizes data science to accurately predict employee attrition by analyzing historical ... ... More
Employment History
-
Power BI Developer
Colaberry Inc
June 2017 - Present
• Spearheaded the design, development, and deployment of Power BI dashboards, aligning with firm's data management principles and best practices, enhancing executive-level decision-making.
• Advanced the firm’s data analytics capabilities by creating analytical dashboards that highlight critical KPIs, such as Income, YOY percent change, and PTI ratio, enabling stakeholders to forecast and pinpoint improvement opportunities.
• Proficient in dimensional and relational data modeling, adept at employing star schema and snowflake patterns as well as managing fact and dimension tables to structure vast datasets effectively.
• Honed expertise in T-SQL, developing and optimizing Tables, Stored Procedures, Views, Indexes, Triggers, and User-defined Functions for robust database management on SQL Server platforms.
• Improved query performance and stored procedure efficiency using execution plans and data profiling, leading to faster data retrieval and report generation.
• Utilized Power BI Gateways to maintain report freshness, and implemented Role Level Security for nuanced data access control across the enterprise.
• Collaborated across departments to ensure a comprehensive inventory of data and reporting assets, assisting in the establishment of governance for reporting, data transfer, and storage standards.
• Streamlined data extraction, transformation, and loading processes from various sources, including SQL Server databases and flat files, ensuring clean and reliable datasets for reporting.
• Leveraged DAX to craft calculated columns, measures, and complex formulas, thereby enhancing report interactivity and analytical depth for users.