ELEAZER OWUSU-POKU
Richardson,TX
Summary
Data Analyst/Business Analyst with over 6+ years of experience in Database Development and Advanced Data Visualization, I bring a strong background in database design, development, and optimization, paired with expertise in creating insightful data visualizations. My skills include crafting complex SQL queries, ensuring robust data security and integrity, and developing dynamic Power BI dashboards. Dedicated to delivering high-quality solutions, I excel in troubleshooting, collaboration, and leveraging data to drive business success.. My extensive T-SQL expertise includes database object creation, optimization, and performance enhancement techniques.
Overview
7
7
years of professional experience
1
1
Certification
Work History
SQL Developer
Elan Partners
Plano, TX
01.2022 - 11.2024
- Orchestrated comprehensive insights delivery by integrating SQL Server and Azure databases, crafting dynamic dashboards in Power BI to illustrate intricate data patterns and trends, empowering stakeholders with actionable information for strategic decision-making
- Developed complex SQL queries, stored procedures, triggers, and views to meet client requirements and enhance system performance
- Researched and analyzed data integrity issues involving large volumes of data stored across various systems, leveraging Microsoft SQL to identify discrepancies, optimize data queries to ensure seamless data integration and accuracy
- Developed and managed ETL (Extract, Transform, Load) processes to integrate data from various sources into centralized systems
- Created and maintained comprehensive documentation for database architecture, processes, and procedures for internal and client use
Report Developer
Ericsson Ghana
05.2018 - 11.2022
- Performed data transformation and cleaning tasks to prepare data for reporting and analysis.
- Extracted, analyzed, and interpreted complex data from multiple sources to provide actionable insights for various departments.
- Developed and managed data models within Power BI, including creating relationships between tables, and defining measures and calculated columns using DAX.
- Designed, developed, and maintained interactive reports and dashboards using Power BI.
- Integrated Python scripts within Power BI to enhance data modeling and automate report generation processes.
Education
Advanced Diploma - Software Engineering
Intercommunication Programming and Co (IPMC)
Bachelor of Science - Information System
Kwame Nkrumah University of Science And, Technology
Skills
- SQL
- Python
- Excel
- Data Warehouse
- Microsoft Azure
- Microsoft Power BI
Certification
- Microsoft Certified SQL Data Analyst
- Microsoft Certified Power BI Data Analyst
References
References available upon request.
Timeline
SQL Developer
Elan Partners
01.2022 - 11.2024
Report Developer
Ericsson Ghana
05.2018 - 11.2022
- Microsoft Certified SQL Data Analyst
- Microsoft Certified Power BI Data Analyst
Advanced Diploma - Software Engineering
Intercommunication Programming and Co (IPMC)
Bachelor of Science - Information System
Kwame Nkrumah University of Science And, Technology
Similar Profiles
Nicholas HoskavichNicholas Hoskavich
Senior Account Executive at Assured Partners - The Elan GroupSenior Account Executive at Assured Partners - The Elan Group
Craig WickeCraig Wicke
Senior Account Manager at Assured Partners- Elan GroupSenior Account Manager at Assured Partners- Elan Group
Ching-Ho LinChing-Ho Lin
Section Manager at ELAN MicroelectronicsSection Manager at ELAN Microelectronics