About Me
A Microsoft-certified Data Analyst with 3+ years of experience specializing in comprehensive customer data analysis and data warehousing. Proven expertise in database management, data visualization, and advanced data mod…
A Microsoft-certified Data Analyst with 3+ years of experience specializing in comprehensive customer data analysis and data warehousing. Proven expertise in database management, data visualization, and advanced data modeling techniques, underpinned by a strong foundation in ETL processes, data architecture, and migration
Experience
Data Analyst
•
Developed and implemented interactive Power BI dashboards to track and analyze billing data, resulting in a 30% reduction in time spent on manual reporting processes
•
Spearheaded the implementation and management of Master Data Management (MDM) solutions, focusing on customer data integration, quality, and governance to support enterprise data consistency and reliability
•
Contributed to the design and implementation of a scalable MS SQL Server data warehouse, centralizing data from 5+ disparate sources and significantly enhancing the team's reporting capabilities.
•
Created complex SQL queries and stored procedures in Microsoft SQL Server to extract and transform billing data, improving data accuracy, and reducing processing time by 20%
•
Responsible for rate calculations, ensuring accurate and timely billing calculations for various utility services
•
Utilized Azure Databricks for data cleansing and preprocessing, automating the integration of disparate data sources into a coherent dataset for analysis, which enhanced data reliability and reduced data preparation time.
Data Analyst
Developed and implemented interactive Power BI dashboards to track and analyze billing data, resulting in a 30% reduction in time spent on manual reporting processes
Spearheaded the implementation and management of Master Data Management (MDM) solutions, focusing on customer data integration, quality, and governance to support enterprise data consistency and reliability
Contributed to the design and implementation of a scalable MS SQL Server data warehouse, centralizing data from 5+ disparate sources and significantly enhancing the team's reporting capabilities
Created complex SQL queries and stored procedures in Microsoft SQL Server to extract and transform billing data, improving data accuracy, and reducing processing time by 20%
Responsible for rate calculations, ensuring accurate and timely billing calculations for various utility services
Utilized Azure Databricks for data cleansing and preprocessing, automating the integration of disparate data sources into a coherent dataset for analysis, which enhanced data reliability and reduced data preparation time
Data Analyst
Worked with cross-functional teams to gather business requirements and develop reporting solutions using Power BI, which led to increase in user satisfaction
Implemented real-time data visualization and dashboards using Power BI for financial data analysis, resulting in a 50% reduction in financial report creation time and an increase in data accuracy
Leveraged advanced features of Power BI such as DAX and R scripts to assemble customized financial reports
Utilized MS Excel and MS SQL Server to extract and manipulate data for Power BI reporting and analysis, leading to an increase in data quality
Played a key role in the migration of legacy data systems to a modern data warehouse, resulting in a more streamlined and efficient data management process
Developed and maintained ETL processes for data ingestion, transformation, and loading into the data warehouse