About
Teamwork-oriented and highly motivated Data Analyst with a strong background in Microsoft Power BI for designing, developing, deploying, and visualizing comprehensive business reports. My expertise extends beyond data visualization to include the development of SSIS packages for efficient Extract, Transform, and Load (ETL) processes, ensuring data integrity and accessibility. I am also proficient in managing and optimizing data within Microsoft SQL Server, working across both OLTP (Online Transaction Processing) and OLAP (Online Analytical Processing) environments, with a focus on delivering robust data warehousing solutions.
Looking for Full-Time, Part-Time, TemporaryHours Available / Wk - 40 hrs
Employment History
-
Power BI/ SQL Developer
Colaberry Inc
October 2021 - Present
* Extract data from various sources, including SQL Server databases, CSV files, and Excel spreadsheets.
* Transform and clean this data using Power Query, and load it into Power BI Desktop.
* Develop and customize dashboards, charts, graphs, tabular reports, and matrix reports to meet customer requirements using Power BI and SSRS.
* Create dynamic drill-down and drill-up reports for in-depth data analysis.
* Design and implement KPIs utilizing advanced DAX functions, and publish reports to Power BI Service.
* Apply row-level security to ensure controlled data access.
* Utilize agile methodologies to manage complex projects, breaking them into manageable sprints.
* Work with star schema and snowflake schema designs in data warehousing.
* Employ T-SQL to develop stored procedures, tables, and user-defined functions, and use joins to optimize data loading processes in Power BI.