Business Intelligence Data Modeling

SUMMARY:

Leading implementation strategy for multiple business intelligence implementations.

Hands on technical installation, configuration and deployment of large business intelligence platforms.

Strong data modeling skills including entity relational and multi-dimensional modeling.

Strong presentation and idea selling skills.

Comprehensive knowledge reporting, data analysis, data transformation (ETL), data modeling and data governance.

Strong technical and functional understanding of big data and analytics.

Strong leadership and management skills leading implementation teams of diverse consultants.

Hands on experience in healthcare, insurance, retail, banking, financial services, manufacturing, higher education, governmental agencies and startups.

EDUCATION/CERTIFICATION:

CARNEGIE MELLON UNIVERSITY Pittsburgh, PA August 2002

Master of Information Systems and Management

UNIVERSITY OF GHANA Legon, Accra May 1998

B. S. Biochemistry

Certifications, Awards & Activities

Certified Professional Cognos BI Author

Certified Professional Cognos BI Metadata Modeler/Developer

Certified Professional - Cognos Sales Mastery

TECHNICAL SKILLS:

Enterprise tools: Cognos Analytics 11, Google BigQuery, Data Studio, Oracle, MS SQL Server (SSIS, SSRS and SSAS), SAS, Informatica, MS Excel, MS Project, SPSS, Tableau, Salesforce, Looker, Mode and Power BI

Modeling: UML, ERD, OLAP, MOLAP, HOLAP, ROLAP.

Modeling tools: Erwin, Visio, Cognos (Framework Manager, Metrics Designer, Powerplay Transformer)

Internet Technologies: HTML, ASP, WML, JSP, Cold Fusion, XML and TCP/IP

Programming: JAVA, SQL, PL/SQL, MDX, Easel and Visual Basic

Operating Systems: Windows, MAC OS and Unix

ERP: JD Edwards, SAP

PROFESSIONAL EXPERIENCE:

Management Systems Advisory Group Inc. Jul 2006 - Present

Principal Consultant, BI and Analytics

Manage a team of sales and marketing professionals as well as Business Intelligence (BI) consultants and developers on projects.

Build and maintain complex visualizations such as dashboards and storyboards to be consumed on a variety of devices including mobiles and desktops.

Build and manage OLAP cubes using different tools such Cognos Transformer, Cognos cube designer and TM1.

Perform data modeling and metadata modeling using tools like Erwin, MS Visio and Cognos Framework Manager.

Querying data in BigQuery for report building and dashboards using Data Studio.

Building reports and dashboards for clients such as UBER, VISA, IBM, Disney, BBDO, Nike, Key Bank, GAP, Red Bull and CIGNA. Using tools like Cognos, Power BI, Data Studio, Mode, Looker and Tableau.

Manage and maintain BI environments in an administrative capacity. Performing upgrades, deployments, sanity checks, new installations.

Adept at creating RFPs, statement of work (SOW), consulting engagement proposals, project implementation plans, data access strategy plans, BI product map plans and end-client presentations in-person or online.

Comfortable working as a business analyst with all business stakeholders including Executives, Sales and Marketing teams, Finance teams, Supply Chain teams, HR teams, IT teams, Product teams and contractors.

Work with teams on data transformation for reporting and analytics purposes through ETL and ELT processes with tools such as Informatica, Ab Initio, Cognos Data Manager, Python and MS SSIS.

Participate in BI budget committee meetings to provide guidance on user base configuration assessments for BI systems with efforts geared towards minimizing software licensing costs.

Review reporting environments and make recommendations for best practices addressing issues like reporting model complexity, query efficiency, effective coupling between reporting packages and reports as well as acceptable runtime for reports.

Lead and manage the implementation of large-scale BI projects for Fortune 100 companies example VISA as well as the Public Sector (State and Federal). Phases include Sizing, Design, Installation, Configuration, Deployment, Development, Testing, Management and Maintenance of BI Systems.

Matria Healthcare Inc. (Alere) Marietta, GA Oct 2004 – Feb 2006

Sr. BI Analyst, Healthcare Informatics

New Acquisition Integration efforts: Led the integration and standardization of Business Intelligence on a single platform for all new companies acquired by Matria Healthcare Inc.

Led the investigation and recommendation to my team on general Business Intelligence software acquisitions, upgrades and maintaining vendor support relationships.

Created complex multi-page reports; analyze underlying data source schemas; created metadata models for BI reporting in Cognos.

Performed quality assurance procedures on BI reports to ensure that they have the right information and meet customer expectations.

Provided guidance to database developers in the development of disease management data marts.

Deployed complex multi-scorecard application using IBM Cognos Metrics Management software.

Integrative Logic Inc. Decatur, GA Jan 2003 – Sep 2004

Manager, Database Solutions

Created and managed database solutions for our agency’s clients.

Performed ETL for marketing data collected in promotions or sent to us by our marketing clients.

Performed analysis on data to determine the best process for extracting and reporting on the data.

Performed quality assurance procedures on client data to ensure that the data is clean and actionable.

Provided guidance to database developers in the development of marketing data marts.

Led the implementation of data management project from scratch.

Contact this candidate