Data Analyst Intelligence

Balkiss Bochere

Atlanta, GA 678-***-**** **********@*****.***

PROFILE

A result oriented, motivated, analytical and business intelligence professional with diversified business data analysis, logistics, ad hoc reporting, database development, and data modeling. I have worked on data-driven projects, utilizing my vast knowledge of business operations to monitor, measure and appraise logistics and operational performance. I have a secrete security clearance and leadership background.

AREA OF EXPERTISE

Project Management

Ad Hoc Reports

Power BI (DAX)

Jira

T-SQL

SSIS

SSMS

Agile methodology

MS Excel (Advanced)

Statistics

Data Modeling

EXPERIENCE

WellStar Marietta, Ga 09/2021 – Present

Business Intelligence Analyst/supply Mngt

Partner with the project and corporate stakeholders in preparation of weekly and monthly financial packages, dashboards, and reporting of key performance metrics.

Develop business intelligence solutions (Dashboards and Reports) using Excel and Power BI that provided comparative analysis actionable insights used by executives to make data-driven strategic decisions.

Utilize advanced Pivot Tables in Excel to calculate, summarize data for comparison analysis, and check Trends and Patterns.

Review, and analyze the effectiveness and efficiency of existing dashboards and reports to identify opportunities for process improvements.

Manage end-to-end complex data migration, conversion, and data modeling (using SSIS, SQL) and create a visualization using Power BI to develop high-quality dashboards.

Collaborate with specific department managers and project managers to create Business Requirement Documents (BRD) for various projects which improve efficiency and accuracy in data extraction, report creation, functionality, and delivery.

Create multiple SQL queries that extract and transform data. Created multiple SQL queries for retrieving and manipulating data for reporting purposes. The written SQL queries include constructs like Joins, Views, Sub-queries, set operators, and case statements.

Write complex T-SQL queries for data validation and create reconciliation reports to resolve data discrepancies in contractor payment data.

US ARMY Dobbins Airforce Base GA 04/2016– 08/2021

Business Analyst/Supply Management

Led efforts to identify key performance indicators and metrics that helped report and analyze bills of equipment logistical data.

Gathered, and analyzed data or requirements in support of business cases, proposed projects on each step within the supply chain, and recommended changes to reduce costs.

Worked closely with Supply Chain and Retail teams to design, develop, document, test, and validate solutions that meet the unit’s requirements.

Maintained expertise in both U.S. Army and U.S. Air Force supply and logistics operations. Managed and maintained reporting requirements using an automated supply tracking system.

Developed and implemented supply programs, methods, and procedures that ensure brigade objectives are accomplished. Coordinated supply and equipment operations from initial receipt to delivery to unit level.

CARAVITA HOMECARE Roswell, Ga 06/2014– 03/2016

Data Analyst

Created interactive enterprise-wide dashboards with a focus on client intake and discharge rates that enabled the managers and executives to make strategic and data-driven decisions.

Built Power BI reports that provide a comparative analysis of treatment plans; These reports were used to improve our members’ responsiveness to treatment plans and to evaluate the most effective plan.

Performed multiple research activities to troubleshoot/fix data inconsistences; wrote multiple SQL queries to apply data fixes.

Built and maintained client transportation activity report using Power BI; this report provided insights into transportation metrics like trip counts, mileage, and rates aggregated by date, client, and other categories. Implemented standard data modeling methodologies, cleansed, and transformed data using Power Query created calculated columns, designed, and implemented measures using DAX, and built visually appealing visualization in Power BI.

Performed medium to complex data transformations and cleansing in excel using formulas like VLOOKUP, INDEX/MATCH, IFS, MID, Data Validation, Conditional Formatting, and array formulas.

Created various metrics such as process metrics, risk metrics, and performance metrics. Identified metrics to be upgraded to KPIs and KRIs.

EDUCATION

Supply Chain Management Quarter Master School Fort Lee, VA

Business & Enterprise Development Jomo Kenyatta University. Kenya

Contact this candidate