Analytical SME Resume

SUMMARY

Solution driven, innovative, cross - functional IT Professional with expertise in architecture and development of end to end BI Solutions. Extensive experience in enterprise data warehousing and working with large datasets to provide for business analytics and reporting purposes. Efficient and effective issue resolution within tight deadlines. Proficient in working with Agile principles.
Logical and physical data models for datawarehouse and data marts
BUS matrix, data mappings
Solution design, data flow diagrams and development
Multidimentional and Tabular data models
Experienced in reporting using PowerBI and DAX
Integration testing and implementation
Data security models
Data solutions migrations
Schedule and automate data loads and processing
Efficient problem solving
Performance monitoring and enhancements
Provide ongoing support for existing systems and solutions
Proficiency in working with both OLTP and OLAP data models
Agile methodologies - Scrum, Kanban

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Analytical SME

Responsibilities:

Confidential

BI Solutions Specialist

Responsibilities:

Create intelligent analytics and regulatory reporting solutions for Credit Risk department at Confidential thereby eliminating manual data collection and manipulation efforts.
Centralize data storage for efficient data management.

Confidential

BI Solutions Specialist

Responsibilities:

CIO Dashboard: Business and data analysis. Develop Capital Budgeting charts and graphs for visualizing Capital Budget and Spend.
MTN BIR Reporting: BI Solution to provide dashboard displaying daily overview of MTN Subscriber base and analytic reporting capabilities.

Confidential

BI Solutions Specialist

Responsibilities:

Anti-Money Laundering (AML) ETL solution
Dashboard and scorecards for HR to measure employee performance
Consolidate and create data feeds for Customer behaviour monitoring.
Cash Threshold Reporting - Develop automated solution for regulatory reporting to FIC within tight deadlines thereby preventing an impending fine of a few million.
Solutions migration for SQL 2000 and datastage to SQL 2008R2