Patrick Kpodji

Patrick Tetteh Kpodji 21 Summerhill Place., Wixams - Bedford • - •- SUMMARY With over half a decade of dedicated experience in business intelligence and data analytics, I am a results-driven professional committed to delivering impactful outcomes. At my current position, I have effectively collaborated with various departments for over a year, consistently demonstrating reliability, motivation, and a passion for technological advancement and analytical development. Renowned for my problem-solving abilities and motivational spirit, I excel in stakeholder engagement through exceptional communication skills. My expertise spans SSIS, SSMS, SQL Server, Data Warehousing, Azure Cloud Services, Python Programming, Power BI, Microsoft Fabric, Power Apps, and Power Automate. I am adept at simplifying decision-making processes, ensuring outcomes that are both impactful and enjoyable for stakeholders. Continuously enhancing my skills through a personal home lab, I am dedicated to staying at the forefront of industry trends, driving both personal and professional growth.SKILLS -SQL Server Integration Services (SSIS) - Designing and implementing ETL processes to streamline data flow and ensure data integrity. - SQL Server Management Studio (SSMS) - Managing and administrating SQL Server databases, ensuring optimal performance and reliability. - SQL Server - Database design, development, and optimization to support complex data-driven applications. - Data Warehousing - Building and maintaining data warehouses for robust data storage, retrieval, and analysis. - Azure Cloud Services - Leveraging Azure cloud solutions for scalable, secure, and efficient data management and analytics. - Python Programming - Using Python for data analysis, automation, and developing custom solutions to meet specific business needs. - Power BI - Creating interactive and insightful data visualizations and reports to support decision-making. - Microsoft Fabric - Utilizing Microsoft Fabric for enhanced data integration, connectivity, and collaboration. - Power Apps - Developing custom business applications to streamline processes and improve productivity. - Power Automate - Automating workflows and business processes to increase efficiency and reduce manual tasks. - Stakeholder Engagement - Exceptional communication skills and a keen ability to engage with stakeholders. - Problem-Solving - Recognized for strong problem-solving abilities and motivational spirit. - Continuous Learning - Dedicated to staying ahead of industry trends through continuous skill enhancement and personal development. WORK EXPERIENCE Business Intelligence Developer, Castles and Coasts Housing AssociationMay 2023 - Present Location: Carlisle/Newcastle Company Description: Castles and Coasts Housing Association Ltd is dedicated to providing affordable and quality housing solutions to individuals and families. Focused on improving communities and enhancing the lives of residents, the organization manages and develops a range of housing properties, including apartments and houses. Castles and Coasts strives to create safe, welcoming, and sustainable environments, making them a valuable organization in the field of housing and community development. Duties and Responsibilities: - Advanced Power BI Report Building - Developed interactive and impactful reports using Power BI, ensuring insightful data visualization. - DAX for Reporting - Expertly wrote DAX queries for robust and efficient reporting from Power BI models. - Stored Procedures Development - Created dynamic T-SQL stored procedures to optimize data processing and reporting workflows. - Database Development - Developed views, triggers, temp tables, and more to support comprehensive reporting needs. - Data Modelling - Skilled in data modelling within Power BI and SQL, with extensive knowledge in M query and DAX development. - End-to-End Solution Delivery - Managed full lifecycle projects from scoping, design, development, testing, to deployment, ensuring successful solution delivery. - New Data Product Development - Developed dashboards, paginated reports, data extracts, predictive services, and more for various departments. - Advanced Data Analysis - Conducted in-depth data analysis using SQL, constructing complex data models for relational sources. - Data Visualization - Created effective and impactful data visualizations across reports and dashboards. - Senior-Level Communication - Effectively communicated and engaged with senior-level stakeholders to drive project success. - ETL and Data Warehousing - Strong background in ETL processes and data warehousing, ensuring data integrity and accessibility. - BI Delivery Focus - Specialized in BI delivery with an emphasis on the front-end/presentation layer for user-friendly interfaces. - Power BI Tenant Management - Configured and managed Power BI tenants, including license and capacity management. - Results-Oriented - Maintained a results-oriented mindset with keen attention to detail and a passion for data-driven insights. - Technical Communication - Confidently explained technical features to non-technical users, bridging the gap between technology and business. - Operational Analytics Support - Supported and maintained effective operational analytics systems for the organization. - Stakeholder Collaboration - Collaborated with business stakeholders to gather, document, and prioritize requirements, ensuring alignment with business goals. - Mentorship and Advocacy - Led the Power BI Community of Practice, mentoring colleagues and advocating for best design practices. - Empowering Data Use - Empowered businesses to make more effective use of data through coaching and guidance. - Problem Solving - Proactively solved problems in collaboration with business stakeholders, driving continuous improvement. - Advanced T-SQL Querying - Developed advanced T-SQL queries to support complex data analysis and reporting needs. - DAX Expertise - Proficient in building DAX expressions for sophisticated data analysis within Power BI. - Data Modelling Tools - Utilized various data modelling tools and techniques to create robust and scalable data models. - Data Visualization Practices - Mastered good data visualization practices to ensure clarity and effectiveness in reporting. - Agile Team Collaboration - Worked comfortably within Agile teams, contributing to dynamic and iterative project development. - Documentation and Requirements Interpretation - Developed structured approaches to documentation and accurately interpreted business requirements. - Application Testing - Conducted thorough testing of applications, both manually and through automation technologies. - Positive Attitude - Embraced challenges with a "can-do" attitude, thriving in team-based work environments. - Communication Skills - Exhibited excellent verbal, written, interpersonal, and customer-facing skills. - Power BI Data Model Maintenance - Collaborated with project teams to maintain and improve Power BI data models. - Coaching and Guidance - Coached colleagues on data analysis, interpretation, and decision-making, ensuring adherence to data standards and quality. - Data Handling Proficiency - Proficient in handling data in all formats, ensuring accuracy and reliability. - Complex Data Projects - Engaged in complex data projects involving data gathering, cleaning, modelling, stakeholder correspondence, visualization design, testing, implementation, documentation, workshops, and going live. - Liaison with BI Team - Acted as a liaison with the internal head of BI developers, ensuring alignment and collaboration across the team. Business Intelligence Developer - Horizon Frame, United Kingdom Jan, 2019 - May,2023 Company Description: Horizon Frame is a data solutions consultancy agency specializing in providing bespoke data analytics and business intelligence services to small and medium-sized enterprises (SMEs). With a focus on harnessing the power of data to drive business growth and efficiency, Horizon Frame delivers tailored solutions that cater to the unique needs and challenges of SMEs. The agency's expertise spans across various industries, offering services that include data integration, advanced analytics, reporting, and strategic consulting. By empowering businesses with actionable insights, Horizon Frame helps clients make informed decisions, streamline operations, and achieve their strategic goals. Duties and Responsibilities: - Advanced Power BI Report Building - Developed interactive and impactful reports using Power BI, ensuring insightful data visualization. - DAX for Reporting - Expertly wrote DAX queries for robust and efficient reporting from Power BI models. - Stored Procedures Development - Created dynamic T-SQL stored procedures to optimize data processing and reporting workflows. - Database Development - Developed views, triggers, temp tables, and more to support comprehensive reporting needs. - Data Modelling - Skilled in data modelling within Power BI and SQL, with extensive knowledge in M query and DAX development. - End-to-End Solution Delivery - Managed full lifecycle projects from scoping, design, development, testing, to deployment, ensuring successful solution delivery. - New Data Product Development - Developed dashboards, paginated reports, data extracts, predictive services, and more for various departments. - Advanced Data Analysis - Conducted in-depth data analysis using SQL, constructing complex data models for relational sources. - Data Visualization - Created effective and impactful data visualizations across reports and dashboards. - Senior-Level Communication - Effectively communicated and engaged with senior-level stakeholders to drive project success. - ETL and Data Warehousing - Strong background in ETL processes and data warehousing, ensuring data integrity and accessibility. - BI Delivery Focus - Specialized in BI delivery with an emphasis on the front-end/presentation layer for user-friendly interfaces. - Power BI Tenant Management - Configured and managed Power BI tenants, including license and capacity management. - Results-Oriented - Maintained a results-oriented mindset with keen attention to detail and a passion for data-driven insights. - Technical Communication - Confidently explained technical features to non-technical users, bridging the gap between technology and business. - Operational Analytics Support - Supported and maintained effective operational analytics systems for the organization. - Stakeholder Collaboration - Collaborated with business stakeholders to gather, document, and prioritize requirements, ensuring alignment with business goals. - Mentorship and Advocacy - Led the Power BI Community of Practice, mentoring colleagues and advocating for best design practices. - Empowering Data Use - Empowered businesses to make more effective use of data through coaching and guidance. - Problem Solving - Proactively solved problems in collaboration with business stakeholders, driving continuous improvement. - Advanced T-SQL Querying - Developed advanced T-SQL queries to support complex data analysis and reporting needs. - DAX Expertise - Proficient in building DAX expressions for sophisticated data analysis within Power BI. - Data Modelling Tools - Utilized various data modelling tools and techniques to create robust and scalable data models. - Data Visualization Practices - Mastered good data visualization practices to ensure clarity and effectiveness in reporting. - Agile Team Collaboration - Worked comfortably within Agile teams, contributing to dynamic and iterative project development. - Documentation and Requirements Interpretation - Developed structured approaches to documentation and accurately interpreted business requirements. - Application Testing - Conducted thorough testing of applications, both manually and through automation technologies. - Positive Attitude - Embraced challenges with a "can-do" attitude, thriving in team-based work environments. - Communication Skills - Exhibited excellent verbal, written, interpersonal, and customer-facing skills. - Power BI Data Model Maintenance - Collaborated with project teams to maintain and improve Power BI data models. - Coaching and Guidance - Coached colleagues on data analysis, interpretation, and decision-making, ensuring adherence to data standards and quality. - Data Handling Proficiency - Proficient in handling data in all formats, ensuring accuracy and reliability. - Complex Data Projects - Engaged in complex data projects involving data gathering, cleaning, modelling, stakeholder correspondence, visualization design, testing, implementation, documentation, workshops, and going live. - Liaison with BI Team - Acted as a liaison with the internal head of BI developers, ensuring alignment and collaboration across the team. Data Consultant - PatMacTech UK Ltd, Bedford – UK Feb 2022 - Jan 2024 Company Description: PatMacTech UK Ltd is a leading technology solutions provider dedicated to delivering innovative and comprehensive IT services. Specializing in managed IT services, software development, cybersecurity, digital transformation, and infrastructure solutions, PatMacTech UK Ltd caters to businesses of all sizes. As a general consultant, I worked closely with clients to understand their unique challenges and requirements, offering expert guidance and tailored solutions to optimize their technology infrastructure and drive business growth. My role involved advising on best practices, implementing cutting-edge technologies, and ensuring seamless integration and performance across various platforms. PatMacTech UK Ltd's commitment to excellence and client satisfaction makes it a trusted partner for businesses seeking to leverage technology for competitive advantage. Duties and Responsibilities: - Advanced Power BI Report Building - Developed interactive and impactful reports using Power BI, ensuring insightful data visualization. - DAX for Reporting - Expertly wrote DAX queries for robust and efficient reporting from Power BI models. - Stored Procedures Development - Created dynamic T-SQL stored procedures to optimize data processing and reporting workflows. - Database Development - Developed views, triggers, temp tables, and more to support comprehensive reporting needs. - Data Modelling - Skilled in data modelling within Power BI and SQL, with extensive knowledge in M query and DAX development. - End-to-End Solution Delivery - Managed full lifecycle projects from scoping, design, development, testing, to deployment, ensuring successful solution delivery. - New Data Product Development - Developed dashboards, paginated reports, data extracts, predictive services, and more for various departments. - Advanced Data Analysis - Conducted in-depth data analysis using SQL, constructing complex data models for relational sources. - Data Visualization - Created effective and impactful data visualizations across reports and dashboards. - Senior-Level Communication - Effectively communicated and engaged with senior-level stakeholders to drive project success. - ETL and Data Warehousing - Strong background in ETL processes and data warehousing, ensuring data integrity and accessibility. - BI Delivery Focus - Specialized in BI delivery with an emphasis on the front-end/presentation layer for user-friendly interfaces. - Power BI Tenant Management - Configured and managed Power BI tenants, including license and capacity management. - Results-Oriented - Maintained a results-oriented mindset with keen attention to detail and a passion for data-driven insights. - Technical Communication - Confidently explained technical features to non-technical users, bridging the gap between technology and business. - Operational Analytics Support - Supported and maintained effective operational analytics systems for the organization. - Stakeholder Collaboration - Collaborated with business stakeholders to gather, document, and prioritize requirements, ensuring alignment with business goals. - Mentorship and Advocacy - Led the Power BI Community of Practice, mentoring colleagues and advocating for best design practices. - Empowering Data Use - Empowered businesses to make more effective use of data through coaching and guidance. - Problem Solving - Proactively solved problems in collaboration with business stakeholders, driving continuous improvement. - Advanced T-SQL Querying - Developed advanced T-SQL queries to support complex data analysis and reporting needs. - DAX Expertise - Proficient in building DAX expressions for sophisticated data analysis within Power BI. - Data Modelling Tools - Utilized various data modelling tools and techniques to create robust and scalable data models. - Data Visualization Practices - Mastered good data visualization practices to ensure clarity and effectiveness in reporting. - Agile Team Collaboration - Worked comfortably within Agile teams, contributing to dynamic and iterative project development. - Documentation and Requirements Interpretation - Developed structured approaches to documentation and accurately interpreted business requirements. - Application Testing - Conducted thorough testing of applications, both manually and through automation technologies. - Positive Attitude - Embraced challenges with a "can-do" attitude, thriving in team-based work environments. - Communication Skills - Exhibited excellent verbal, written, interpersonal, and customer-facing skills. - Power BI Data Model Maintenance - Collaborated with project teams to maintain and improve Power BI data models. - Coaching and Guidance - Coached colleagues on data analysis, interpretation, and decision-making, ensuring adherence to data standards and quality. - Data Handling Proficiency - Proficient in handling data in all formats, ensuring accuracy and reliability. - Complex Data Projects - Engaged in complex data projects involving data gathering, cleaning, modelling, stakeholder correspondence, visualization design, testing, implementation, documentation, workshops, and going live. - Liaison with BI Team - Acted as a liaison with the internal head of BI developers, ensuring alignment and collaboration across the team. EDUCATION Business Intelligence Developer Training Vogue IT Academy SSIS SSMS/T-SQL Advance Excel Power Bi Desktop Power Bi Service BSc. (Hons) Banking and Finance Presbyterian University – Ghana Jan 2018 - Aug 2019 Sep 2005 – Oct 2009 Banking and Finance Accounting Pure Mathematics Philosophy WAEC Certificate Sep 2000 - Oct 2003 Pope John Senior Secondary School Pure Mathematics Economics Geography Social Studies ADDITIONAL INFORMATION Technical Skills: WordPress Web Development, Musical Instrument Languages: English, Twi, Ga, French(Beginner) Certifications: Cyber Security Awareness Training, Fraud Prevention, Diversity and inclusion, GDPR UK, Health and Safety, Mental Health Awareness, Modern Slavery, Safeguarding Adults level 2, Safeguarding Children level 2, First Aider, Basic Life Support, Care certificate, Fire training, WordPress web design, Advance PMVA (Instructor Level) Projects: Personal Projects: - Procurement Spend Report Dashboard (1 week) - Scope: ETL, Modelling, Visualization, and Presentation - Tasks: Testing, Implementation, Documentation, and Delivering Workshops - Income and Financial Report Dashboard (2 weeks) - Scope: ETL, Modelling, Visualization, and Presentation - Tasks: Testing, Implementation, Documentation, and Delivering Workshops - Reports Dashboards Landing Page (3 days) - Scope: ETL, Modelling, Visualization, and Presentation - Tasks: Testing, Implementation, Documentation, and Delivering Workshops - Documentation Guide and Templates (1 day) - Scope: ETL, Visualization, and Presentation - Tasks: Testing, Implementation, Documentation, and Delivering Workshops - Void Report (8 weeks) - Scope: Extraction, Transformation, and Loading, Modelling, Visualization, and Presentation - Tasks: Testing, Implementation, Documentation, and Delivering Workshops - Complaints Dashboard (3 weeks) - Scope: Extraction, Transformation, and Loading, Modelling, Visualization, and Presentation - Tasks: Testing, Implementation, Documentation, and Delivering Workshops - Compliance Dashboard (8 weeks) - Scope: Extraction, Transformation, and Loading, Modelling, Visualization, and Presentation - Tasks: Testing, Implementation, Documentation, and Delivering Workshops - Customer Relationship Management Dashboard (2 weeks) - Scope: Extraction, Transformation, and Loading, Modelling, Visualization, and Presentation - Tasks: Testing, Implementation, Documentation, and Delivering Workshops - Damp and Mould Dashboards (4 weeks) - Scope: Extraction, Transformation, and Loading, Modelling, Visualization, and Presentation - Tasks: Testing, Implementation, Documentation, and Delivering Workshops - Silent Residents Report (2 weeks) - Scope: Extraction, Transformation, and Loading, Modelling, Visualization, and Presentation - Tasks: Testing, Implementation, Documentation, and Delivering Workshops - Finance Report Dashboard (12 weeks) - Scope: Extraction, Transformation, and Loading, Modelling, Visualization, and Presentation - Tasks: Testing, Implementation, Documentation, and Delivering Workshops Team Projects: - NHS Report (8 weeks) - Scope: Visualization and Presentation - Tasks: Testing, Implementation, Documentation, and Delivering Workshops - Team Size: 16 members - Restaurant Sales Analysis (4 weeks) - Scope: Data Modelling, Testing, Implementation - Tasks: Liaising and Conducting Meetings with Stakeholders - Team Size: 16 members Professional Affiliations - Pragmatic Works Training - Specialized training programs focusing on business intelligence, data management, and analytics. - Simplilearn - Comprehensive online learning platform offering courses in data science, analytics, and various IT fields. - RADACAD - Provider of advanced analytics and Power BI training and consulting services. - Enterprise DNA - Empowering Power BI users through extensive resources and training to transform their business intelligence capabilities. - Tutorials Point - Extensive online library of tutorials and courses covering a wide range of technical and professional subjects. - Microsoft Power BI Service - Access to Power BI reports and dashboards for real-time data analysis and visualization. - Microsoft Docs - Official documentation and resources for Power BI and other Microsoft technologies. - Udemy - Online learning platform offering a vast array of courses on business intelligence, data analytics, and programming. - Pluralsight - Technology-focused online learning platform providing courses in IT, software development, and data analysis. - Udacity - Provider of rigorous, industry-relevant programs in data science, AI, and other technical fields. - Coursera - Global online learning platform offering courses from top universities and companies in data science, business, and more. - Brilliant - Interactive learning platform focusing on problem-solving and critical thinking skills in science and mathematics. - ITProTV - On-demand IT training videos and resources for IT professionals. - Power BI Meetup Group - Community group for Power BI users to share knowledge, attend events, and collaborate on projects. - YouTube Channels - Guy in a Cube: Power BI tutorials and tips. - SQLBI: Advanced Power BI and DAX insights. - DAX Guide - Comprehensive reference guide for DAX (Data Analysis Expressions) in Power BI. - DataCamp - Interactive learning platform for data science and analytics skills. - Recommended YouTube Video - Power BI Tutorial: "Power BI Full Course - Learn Power BI in 4 Hours | Power BI Tutorial | Edureka" (YouTube link). References: Available upon request.