Emmanuel Audu

*** ***** **** • Manchester, NH • 603-***-**** • adwpfj@r.postjobfree.com

EDUCATION

Southern New Hampshire University Manchester, NH

Master of Science, Information Technology, Concentration in Business Analytics December 2020

GPA: 3.87

Southern New Hampshire University Manchester, NH

Bachelor of Science, Business Administration May 2019

Minor: Operations and Supply Chain Management

GPA: 3.37

Technologies: Microsoft Office including Excel, Word, Access, PowerPoint, Microsoft SQL Server Management Studio (MSMS), Minitab, Power BI, R, Python, Tableau, Data Visualization, Advocate, Trello, and Project Libre

Certifications: Professional Scrum Master I (PSM I)

SUMMARY

4 years’ experience in the IT/Analytics sector

Including extensive technical background in DB applications, Data Analysis, Data modeling and warehousing and Systems Administration.

Have good experience in Developing Power BI dashboards including creating Data Model, Custom visuals, Filters, different kind of Charts, formatting the data and publishing multiple reports as per user views/ Client requirements using Power BI

Experienced in Data Analysis and ETL techniques for loading enormous amounts of data.

Identified issues when reports are created from several and complex data sources.

Performed DATA MODELING, DATA MIGRATION with the data management team, consolidate and harmonized data. Hands-on data modeling experience using Dimensional Data Modeling, Star Schema, Snowflake, Fact and Dimension Table, Physical and Logical Data Modeling using ERWIN.

Strong ability to write SQL queries using Microsoft SQL Server Management Studio (MSMS)

Experience in data scrubbing and cleansing.

Expert on Microsoft Power BI reports dashboards and publishing to the end-users for executive-level Business Decision.

Possess a strong ability to adapt and learn new technologies and new business lines rapidly.

Good knowledge of portfolio analysis, management, and customer segmentation.

Self-motivated individual with strong communication skills, great attention to details and the ability to work under pressure.

Exceptional organizational and time management skills and the ability to work independently.

Excellent team player with demonstrated experience of working diplomatically and collaboratively with all levels of staff to ensure successful implementation of assignments.

Operationalized business intelligence solutions and conducted advanced analytics to identify opportunities and strengths to meet business goals.

Presented and communicated the findings in an understandable and actionable way tailored to the audience and customer's needs.

Established long-term and value-added relationships with assigned business partners to educate and develop the analytic capability of business customers and the organization.

Created and maintained data visualizations that educated, informed, and engaged business partners on key metrics and performance measures.

Collaborated with enterprise data warehouse, data governance, and business teams on data quality issues, as well as architecture or structure of data repositories.

PROFESSIONAL EXPERIENCE

Associate Business Intelligence Analyst

Southern New Hampshire University Manchester, NH

September 2020 - Present

Gathered and documented business requirements for analytical reports. Participated in requirement meetings and data mapping sessions to understand business needs.

Used advanced SQL concepts like OLAP, Group By and aggregate functions.

Used complex SQL queries in advance to fetch data for visualization.

Wrote queries to fetch data from different tables by using JOINs, Sub-queries, CTE’s, Temp Tables, Correlated sub-queries and derived tables on Teradata platform.

Work with ETL Process which includes SSAS, SSIS, and POWER BI. Worked with Business Intelligent tools like Power BI and SQL server.

Worked on both live and import mode to bring data to Power BI for creating reports. Used Power BI gateway to schedule daily job to refresh data and establish RLS (Row Level Security).

Created complex SQL scripts to extract data from Oracle, SQL Server, Data Lake, and Hive to make data available for enterprise reporting.

Design and write elastic queries to access data across database and migrate an existing Oracle Database to Azure Database using Azure Data Factory.

Created user-friendly and dynamic dashboards and reports with KPIs, heat maps, scatterplots, bar charts, slicers, Drilldown, and drill through features.

Created DAX Queries to generate calculated columns and measures in Power BI.

Expertise in data preparation with experience in blending multiple data connections and creating multiple joins across the same and various data sources.

Used and created various visualizations in reports like scatter plot, box plot, Sankey chart, bar graphs, Gantt charts, trend lines, waterfall charts, statistical models, heat maps, and geo-maps end-users to utilize the full functionality of the dashboard.

Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.

Supported the design, build, and maintenance of automated reporting, dashboards, and analysis to enable our team to self-service most of their regular BI data needs, allowing you to focus on answering hard, strategic, and ambiguous problems that will move the needle in terms of customer adoption.

Delivered timely, accurate and professional technical assistance to internal colleagues. Can dive deep into how their needs can be met with existing (and new) metrics and insights to grow adoption.

Developed queries and visualizations for ad-hoc requests and projects, as well as ongoing reporting.

Created DAX Queries to generate computed columns in Power BI.

Generated computed tables in Power BI by using DAX.

Involved in creating and optimizing stored procedures and queries.

Published Power BI Reports in the required originations (Workspace).

Trained 20+ business users on extracting data from Power BI into excel for creating ad-hoc reports.

Built 20+ reports with Power Bi for stakeholders and trained the stakeholders on the use of the report.

Identified and recommended process improvements that boosted the identification of students that have a low performance by 15% over a quarter.

ADDITIONAL EXPERIENCE

Public Safety (Data entry) and Student Affairs (Community Standards) SNHU Manchester, NH

Graduate Assistant August 2019 – February 2020

Use of Microsoft Excel, and Advocate software to generate data for decision making.

Extracted data from Power BI to identify total students enrolled in the term, and what dorm they live in.

Used excel to impute data for students who got parking tickets and lost and found data.

Contact this candidate