Business Intelligence Data

ANDRIA HALL

Greater Houston Area, Texas *****

Phone: 346-***-**** ******.*****.****@*****.***

Business Intelligence Solutions Developer /Microsoft BI Expert

Summary of Qualifications

Over ten years of professional experience in information technology services and supporting roles for various companies, having the ability to develop strong working relationship with all relevant parties and with a strong ability to be pro-active and to take initiative and self-start tasks projects.

Over five years in business intelligence development using Microsoft technology: SQL Server 2012, Analysis Services (SSAS), Integration Services (SSIS), Reporting Services (SSRS).

Strong working knowledge of Cognos and with the Microsoft Power Platform: Power BI.

Strong working knowledge of Tableau 9.x and versions of Tableau Desktop Professional and Tableau Server. Proficiency in Microsoft Office: Word, Excel(Pivot Tables, PivotChart, VLOOKUP), PowerPoint, Access, and SharePoint.

Advance level mathematical proficiency, with a strong ability to understand, interpret and develop spreadsheet data. Strong project management skills, with the ability to solve problems and consistently meet demanding deadlines.

Maintaining leading-edge technical skills and up-to-date BI industry knowledge by taking time off from professional experience to prepare for Data Engineering and Cloud Computing certifications in Amazon Web Services.

HARD SKILLS: Data Analysis; Data Mining; Data Modeling; Data Visualization; Systems Network; Programming languages (T-SQL, MDX, DAX, R); Cube design and development; Dashboard creation and deployment; Machine Learning.

SOFT SKILLS: Integrity; Dependability; Effective communication; Open-mindedness; Time management; Teamwork; Creativity; Problem-solving; Critical thinking; Adaptability; Willingness to learn; Project management; Entrepreneurship; Flexibility; Innovative; Result-oriented; Decision-making; Empathy. Analytical; Perform duties with moderate to low supervision.

Career Highlights

Played key role in securing a JMD$2.7M Bid for a civil engineering firm in Jamaica, by building solid partnership with consultants, suppliers, and contractors.

Collaborated with a team of doctoral educators at a teacher training university in Jamaica to upgrade their diploma programs to pre and post graduate degree programs. Generating an exponential increase in new students’ enrollment.

Professional Experience

CEDAR GATE TECHNOLOGIES/GLOBAL HEALTHCARE ALLIANCE (GHA) Apr. 2015 – Jul. 2020

Global Healthcare Alliance, a leading provider of end-to-end prospective bundled payment solutions serving healthcare providers, was purchased by Cedar Gate Technologies (provider of a value-based care performance analytic platform ISAAC) in 2018.

Business Intelligence Solutions Developer, Cedar Gate Technologies (Oct. 2018 – Jul. 2020)

Retained following merger of Cedar Gate Technologies and GHA. Continuing to build robust, turnkey BI Solutions, to ensure accurate, reliable, and actionable business decisions.

Supporting and maintaining existing BI systems. Implementing changes to existing BI systems.

Continuing to work with clients to build accurate and reliable analytic reports using the Power BI self-serve and Tableau applications.

Assisting in administering Business Objects environments having over three hundred reports and over one hundred weekly scheduled reports used by over thirty different business units.

Working on problem records and investigating root causes; working on incidents, user service request raised by customers; documenting results while resolving BI infrastructure issues.

Publishing reports in test and production environments and making sure they are in the same line of structure, before user validation.

Creating SSIS packages to load data from flat files, CSV files, and SQL Server 2008 R2 to SQL Server 2012 by using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot transformation, and Slowly Changing Dimension.

Scheduling the jobs for executing the stored SSIS packages, which were developed to update the database daily, using SQL server agent.

Scheduling monthly reports and exporting in PDF and/or Excel format as desired by users.

Involving in creating alerts for successful or unsuccessful completion of scheduled jobs.

Business Intelligence Solutions Developer, Global Healthcare Alliance (Apr. 2015 – Oct. 2018)

Recruited by Global Healthcare Alliance to design and implement a Microsoft Business Intelligence (BI) solution, platform, to run con-currently with its existing database systems and later to design and develop data marts to facilitate analytic reports in BI. To build new reports in Tableau and Power BI while improving existing reports that were developed using SQL Server Reporting Services (SSRS).

Working with senior management team, operation-level managers, accounting managers to develop a data infrastructure to provide access to information and expanding reporting capabilities.

Generating new reports and modifying existing reports (Dashboards, Drill through reports, Paginated reports) using the SQL Server Data Tools functionality in Visual Studio 2017.

Performing assessments on existing SSRS reports for accuracy, best fit and integration with the BI platform, using Multidimensional Data Expression (MDX) scripting language.

Assisting in development, roll-out, and maintenance of dashboards, both executive and management reporting, across all departments and across all internal and external divisions.

Serves as a point of contact for questions related to BI reports and as the first line of support for BI technical issues, training, and user inquiries.

Publishing client reports in test and production environments and making sure the reports are in the same line of structure, before user validation.

Developing financial data extraction and reporting, reducing reporting lag to operational decision makers from as much as twenty-one days to real-time, and decreasing the workload for staff accountants.

Interfacing with the user community to make sure their needs are met and maintaining a tight relationship with the production management and accounting team.

Education & Credentials

Bachelor of Science (BSc) in Computing with Management Studies – Utech (2009)

Certificate – Data Science – Johns Hopkins University (2016)

Designing Business Intelligence Solutions – Microsoft Certified Professional (2013)

Contact this candidate