Sam Adeiga

Senior Data & Business Intelligence Architect
Westminster, US.

About

Highly accomplished Senior Data and Business Intelligence Architect with over a decade of experience driving data-driven decision-making and optimizing business processes. Proven expertise in end-to-end data lifecycle management, including data extraction, ETL methodologies, data modeling, and developing advanced analytics and self-service dashboards. Adept at translating complex datasets into actionable insights, improving data accuracy by up to 30%, and reducing operational expenditure by 10%. Skilled in leading cross-functional teams, stakeholder engagement, and implementing Agile/Scrum frameworks to deliver impactful solutions across diverse industries including IT, finance, and healthcare.

Work

Northrop Grumman
|

Senior Data Analyst

Summary

Developed advanced data analytics, ad-hoc reports, and executive dashboards, utilizing agile methodologies to deliver user stories and strategic task execution.

Highlights

Supported rapid turnaround for ad-hoc analysis, developing use cases, researching, and resolving issues to accelerate executive decision-making.

Ensured data accuracy and integrity by validating reports against databases using complex SQL queries.

Designed and deployed Tableau and Power BI dashboards, providing critical insights that guided executive management in optimizing fiscal year cost implementations.

Led User Acceptance Testing (UAT) for SQL queries and BI dashboards, ensuring high quality and alignment with business requirements.

Contributed to UX design for dashboard templates, enhancing client understanding and adoption of data visualization solutions.

Collaborated cross-functionally with IT and business teams to gather and analyze data, facilitating successful project implementations.

Operated within Agile/Scrum frameworks, utilizing Program Increment (PI) planning to efficiently manage project timelines and deliver client requests.

Automated data extraction processes, resulting in a 10% reduction in operational expenditure.

Applied algorithmic and statistical approaches to extract actionable information from large datasets.

Designed and implemented robust ETL pipelines, including Snowflake integration, for efficient data warehousing.

Peraton
|

Senior BI Architect / Data Analyst

Summary

Developed ad-hoc reports for the Treasury Department, leveraging big data to inform policy decisions and executive insights.

Highlights

Expedited ad-hoc analysis, developing use cases and resolving issues to significantly reduce user wait times.

Conducted comprehensive analysis and compiled migration roadmaps for critical components, ensuring seamless transition processes.

Designed and implemented ETL processes, improving data accuracy by 20% by integrating diverse data sources into the data warehouse.

Facilitated stakeholder meetings to refine reporting requirements, ensuring precise alignment with client objectives and project delivery.

Utilized Visio for data modeling, ensuring optimal data integration and visualization within Power BI.

Fulton Financial Group
|

Data Analyst / BI Architect

Summary

Supported migration from a legacy system, accelerating banking data reports and delivering instant representational views for executives.

Highlights

Coordinated with users and developers to refine data models, leading to the modification and optimization of over 150 executive-level Power BI/Qlik reports.

Established an SSRS environment for internal users, enhancing self-service reporting capabilities.

Implemented best practices in team management, improving efficiency and accelerating processing times for urgent, multi-million-dollar project reports.

Developed and maintained robust data processes, reducing data errors and inconsistencies by 30% and ensuring high data accuracy and integrity.

Cultivated and managed strong relationships with diverse international stakeholders, fostering effective collaboration and project success.

Executed complex data transformations (mergers, aggregations, sorts, multicasting, conditional splits, derived columns) to prepare data for analysis.

Optimized data integration processes, significantly enhancing system performance.

Created 10 custom Power BI/Qlik reports, demonstrating tool flexibility and supporting company-wide knowledge growth through training initiatives.

Implemented Scrum methodologies to develop a collaborative environment, enabling effective workflow monitoring and team performance tracking.

Designed and built advanced SSRS 2016 reports, incorporating tabular, matrix, bar, line, and spark charts with multi-tiered drilldowns, and advanced formatting for enhanced data visualization.

AARP
|

Data Analyst / BI Analyst

Summary

Developed advanced ad-hoc reports to drive effective decision-making and optimize resource utilization.

Highlights

Presented key data insights and project statuses to diverse business teams, facilitating informed decision-making.

Leveraged SAS, Tableau/Qlik, and SQL for comprehensive data collection, analysis, and reporting, delivering timely solutions to client requests.

Conducted monthly incentive performance analysis, leading to strategic adjustments in marketing offers.

Provided rapid ad-hoc analysis support, developing use cases, researching, and resolving critical data issues.

Identified and documented components for system migration, ensuring smooth transition readiness.

Automated daily reporting processes by optimizing SQL and SAS scripts, enhancing efficiency.

Collaborated on the foundational analysis for Snowflake integration, evaluating its potential as a core data tool.

Defined precise data requirements and report layouts, developing comprehensive testing plans and scripts to validate solutions.

Managed the installation of Tableau and QlikView/Sense, ensuring data accuracy and implementing robust server access security measures.

Applied statistical analysis to optimize stock levels, reducing inventory turnover by 19%.

Developed partitioned and join indexes, and collected statistics to significantly enhance database performance.

Citibank
|

Data Analyst / Data Architect

Summary

Developed dynamic reports from cloud environments to provide accurate figures influencing daily investment, risk management, and company policy.

Highlights

Developed dynamic, cloud-based reports for executives, providing accurate insights that influenced daily investment, risk management, and company policy.

HSBC
|

Data Analyst / SQL Developer

Summary

Collaborated on database creation and management, developing structures and visualizations for global units to support executive decision-making.

Highlights

Collaborated on a team to design, manage, and realign database structures, creating global visualizations that supported executive decision-making.

Christiana Healthcare Hospital
|

Data Analyst / Tableau Developer

Summary

Contributed to project development, modification, and deployment via reports, focusing on data modeling, visualization, and database structure.

Highlights

Contributed to a team overseeing the full project lifecycle, including development, modification, and deployment of impactful hospital reports, with a focus on data modeling, visualization, and database structure.

Education

Coventry University

Master of Science Degree

Investment Management

Covenant University

Bachelor of Science Degree

Business Accounting and Taxation

Certificates

Disruptive Strategy

Issued By

Harvard Business School Online

Scrum Master Certified

Issued By

International Scrum Institute

Skills

Data Analysis & Business Intelligence

Data Analysis, Business Intelligence, Ad-hoc Reporting, Executive Dashboards, Data Visualization, Statistical Analysis, Performance Analysis, Data-driven Decision Making.

Database & Data Warehousing

Data Warehousing, ETL, Data Modeling, Data Integration, Database Management, Performance Tuning, Partitioned Indexes, Join Indexes, Stored Procedures, Views, Triggers.

Programming & Querying Languages

SQL, DAX, Python, R, SAS 9.x, SnowSQL, Scripting.

BI & Reporting Tools

Power BI (10.0), Tableau, QLIK, MicroStrategy, SSRS (2016), SSAS, SSIS, Business Objects (xi3.1), Power Query.

Data Modeling & ETL Tools

MS Visio, Alteryx, Erwin, ER Assistance, Databricks, Sparks.

Cloud Platforms

Azure, AWS, Snowflake.

RDBMS & Databases

Oracle 10g, SQL Server (2008/2012/2014), MySQL, Teradata, SAP HANA, Salesforce.

Project Management & Methodologies

Agile, Scrum, Requirements Gathering, Workflow Preparation, Process Re-engineering, UAT Testing, Stakeholder Management, Cross-functional Collaboration, User Acceptance Testing.

Soft Skills

Communication, Problem Solving, Initiative, Judgment, Business Acumen, Team Leadership, UX Design, Data Storytelling, Critical Thinking.

Operating Systems

Windows (8, 10, XP, Vista, 7), Unix.