Leen W Mwangi

Fort Worth, Texas Tel: 817-***-**** ad3d5q@r.postjobfree.com

Professional Summary

Microsoft Business Intelligence Developer with over 2 years of work experience in developing Business Intelligence solutions in an Agile environment.

Strong experience in using the Microsoft BI Stack (SQL, SSIS, SSRS, DOMO, Sage Intacct and Power BI) working with various versions of SQL server.

Education / Certifications

Colaberry School--- Data Analytics and Visualization, Plano TX

Bachelor in finance, minor in Accounting---University of Texas in Arlington, TX

Certification--- SAP

Green Belt Certified-Learning Six Sigma

PROFESSIONAL EXPERIENCE

IMS Experts Services (Dallas TX) April 2023 – November 2023

Data Analyst

Responsibilities:

Develop and build the Reports, Dashboards, and scorecards using Power BI and deployed them into Power BI Service.

Work with executives and other business leaders to identify opportunities for improvement.

Create reports for internal teams and/or external clients via defining, designing, and implementing Power BI Reports and dashboards for end-users.

Collaborate with team members to collect and analyze data.

Use graphs, infographics, and other methods to visualize data.

Establish KPIs to measure the effectiveness of business decisions.

Install and configure Power BI Gateways to keep the dashboards and reports refreshed automatically.

Structure large data sets to find usable information.

Work with a team of analysts and other associates to process information

Create presentations and reports based on recommendations and findings.

Created a scheduled flow via Power Automate to export and email Power BI reports utilizing row-level security to various stakeholders as well as team members.

Colaberry Inc (Healthcare Client) (Dallas TX) January 2021 – April 2023

Power BI Developer

Responsibilities:

Gather project requirements from business, stakeholders, and end users to develop and deliver scheduled and Ad hoc reports accurately and on time.

Creating and Uploading Ad hoc reports and scheduled reports to Health Insurance Company remote servers according to their requirements.

Maintaining and troubleshooting Case Tracker ETL processes that securely transfer Eligibility data from employers, payment data and Claims data ass per 834, 835, 837 HIPAA regulated files.

Documenting the logical structures like joins and filters for new SQL scripts used in producing reports for various business reports to ensure uniformity and presenting the same to UAT and client for approval.

Extract data into SSRS from various sources such as Excel, SQL, CSV, and XML

Utilized Power Query in Power BI to Pivot, Un-pivot, Append, Merge, or group the data model for data cleansing and efficient data massaging.

Utilize SSIS packages to perform ETL data messaging operations: data cleaning, validation, and error handling.

Create and implement several DAX functions for various fact calculations for efficient data visualization in Power BI.

Design intuitive visuals utilizing sub-reports, gauges, charts, maps and tables, and matrices.

Design, develop and publish Power BI reports and dashboards according to business requirements and deployed them into Power BI Service.

Optimize Power BI report performance and schedule reports to refresh automatically.

Utilize Power BI gateway to keep dashboards and reports up to date with on-premises data sources.

Seagate Holdings LLC (Transport Client) (Grapevine TX) Feb 2017 – Dec 2020 Staff Accountant

Responsibilities:

Full cycle accounting which includes AP, AR, Payroll processing and Collections

Maintain accounting ledgers by verifying and posting account transactions.

Customer balance reconciliation between three systems and Research and resolve payment discrepancies.

Monitored complete accuracy and timeliness of payroll to employees leading to job satisfaction and retention and handles payroll issues.

Performed secretarial and administrative work including data entry, filing, mail distribution and division budget oversight.

Helping my Supervisor with Monthly bank reconciliation

XPO Logistics North Richland Hills, TX Sep 2014 –Jan 2017

Account Receivable Specialist

Responsibilities:

oReports all recurring rejected claims to management for evaluation of impact on the Accounts Receivables

oFollow up with various internal departments to ensure that all shipments are invoiced accurately within the proper accounting period.

oReview A/R billing cycle for accurate shipping of products, billing to Oracle Financials, through customer acceptance of EDI transmitted invoices, and compliance to payment terms.

oTrack, research, analyze and resolve outstanding payment issues utilizing ERP Software (Oracle NetSuite, Get paid, Mainframe)

oUtilize Excel modeling (V-lookups, Pivot tables) for formatting, querying, and calculating data to determine accuracy of accounts.

oResearches and responds to customers, payers, and or representative inquiry by telephone and/or mail within 2 business days of requests.

oResearch and resolve credit balances by refund and adjustment reports and process claim and/or remittance advice/EOB for third party carriers.

oAudit payments received to identify discrepancies and determine if deductions are pre-approved; create and collect unapproved deductions.

oApply cash to invoices as indicated on customer remittance advice.

oMonitors recurring rejected claims to management for evaluation of impact on the timely filing of claims.

oComplete ad hoc projects as needed.

Contact this candidate