Susan Gichui

404-***-**** ac61mb@r.postjobfree.com

Professional Summary

* ***** ** ********** ** design, analysis, development and implementation using various BI TOOLS

Experience in Business intelligence, Data Warehousing, Data mining and Data extraction in various domains

Proficient in Tableau Calculations, dashboards, visualizations, Maps, Charts, scorecards and KPIS

Proficient in SQL, Excel VLOOKUP’s and Pivot tables

Experienced in analyzing BI needs, interpreting business user requirements and translating them to reports

Excellent time management and ability to multi task while working in a fast-paced environment

Proficient in developing complicated testing strategies and scenarios, data conditioning, and executing test plans.

Experienced in performing manual testing using HP Application Lifecycle Management (ALM), HP Quality Center, defect reporting using HP Quality Center, HP Application Lifecycle Management, QTP and other testing tools.

Experienced in writing Test Plans, Test Cases, Executing Test scripts, Analysis and Testing life cycle.

8 Years Management experience (Software Project management, Implementation and Customer Support)

10 Years of knowledge in the Healthcare industry

Education

MBA MAY 2017 FLORIDA INSTITUTE OF TECHNOLOGY

Major: MBA Specialized in Information Technology

BACHELOR OF SCIENCE MAY 2008 UNIVERSITY OF ALABAMA BIRMINGHAM

Major: Management information systems

ASSOCIATE OF SCIENCE JUNE 2006 JEFFERSON STATE COMMUNITY COLLEGE

Major: Management information systems

Skills & Abilities

People skills: Leadership/Management, Data mining & Analytics, Project management, Customer service

BI Tools: Tableau Desktop, MS Excel

Databases: SQL Server, MS Access

Languages: SQL, VBA, Java, C++

Applications: MS Word, MS Excel, MS PowerPoint, MS Publisher, Outlook, SharePoint, Project, Visio, Visual Studio

Operating Systems: Windows, Windows 7, Vista, and Mac OS 10.7.3

Other Software Knowledge: HP Quality Center -ALM, QTP, JIRA, Bug Tracker 4.1, REDMINE, EHR and PM systems

Volunteer: Susan G. Komen, Houston Habitat for Humanity, Peachtree Race, Walk to end Alzheimer’s and The Rose

Experience

BUSINESS INTELLIGENCE SPECIALIST(TABLEAU) THE ROSE SEPTEMBER 2015 - CURRENT

Use of Business Intelligence to create meaningful patient data statistics using raw data

Manage, update and maintain local MS Access Databases and Tableau Desktop

Design and generate specific grants reports (Ad hoc), design and generate Executive and leadership team reports/dashboards for better decision making

Design KPI dashboards that improve accuracy, transparency and compliance of procedure reporting and planning for numerous departments.

Design and create SQL Queries, reports using MS Access Databases

Design, develop and maintain dashboards for audits for incorrect data and trends

Analyze trends, drill down data, Forecasts and analyze reports

Responsible for generating grant allocations, tracking and progress status reports of financial and procedures usage

Implemented Tableau desktop in 2015 across the organization for better storytelling and visualizing

Manage and Maintain MS Access databases for collection and reporting on resources across the company on day to day basis.

Interact with various departments; i.e. Mobile, Health Information Management, Development, Patient Navigation and Administration to acquire and maintain knowledge of user objectives, purposes and problems.

Develop interoperability between various databases and other applications. Lead various data collection and analysis activities.

Respond promptly and professionally to bug reports.

Install and train MS Access Databases: Empower Her, Positive Master, In service and outreach at various sites/users.

Provides overall support to the organization with research on program-related issues and operational data management

Create and monitor systems and work assignments for daily/weekly/monthly/quarterly/annual and multi-annual reporting. Confer with IT department about performance tuning of Access databases.

Act as a liaison between various departments such as Mobile, Health Information Management, Development, Patient Navigation and Administration ensuring valid information exchange. Assists various departments with their reporting needs. Support the overall information and data needs related to the execution of the fundraising plan.

Prepare timely monthly statistical reports to determine and illustrate measurements. Work with billing and grants to produce accurate monthly/quarterly/annual and other multi-annual reports. Works with the department managers to effectively use data to inform on department performance, evaluation and strategic planning.

Monitor and guarantee evaluation quality of data by ensuring data validation and integrity between various database systems such as Penrad (EHR), Intergy (PM) and Empower Her (MS Access) and efficacy of beginning parameters. Assists users and supports personnel in identifying system problems and future data needs.

Gather, create and submit reports to MIPS (old PQRS)

Link and maintain software local databases (SQL Server connections) using ODBC Connections in Tableau desktop to blend data from Penrad (EMR) and MS Access databases

Member of the Leadership management team

Experienced with CMS 1500 claims, ICD9 & ICD10 (Mammography Cpt codes)

PRODUCT SUPPORT MANAGER/QA PRACTICEADMIN JANUARY 2015 – MAY 2015

Management – Manage a team of 4 employees, Implementation of support processes, new hire training, scheduling and coaching. Assist the CEO with workflow and escalated issues. Internal liaison for all departments.

Practice Management Software Support – Testing, Software training and support to Billing services clients and acting as an intermediary between operational departments (Q/A, EDI, Product Development, and IT).

Quality Assurance Testing -Tested multiple versions of PM software, taking into consideration different browser platforms (Internet Explorer 9 +)

Involved in System Testing, Performance Testing, Functional Testing, Integration Testing and User Acceptance Testing.

Well acquainted with Bug Life Cycle, bug tracking tools and test cases for new product development

Tested Software bug fixes and new features on Web Based staging environments (copies of production)

Analyzed and reported discrepancies, inconsistencies, and identified Bugs with software

Worked with Project managers on understanding client specification for report requests

Continuously updated documentation for new hires

Billing - Support UB04, CMS 1500 claims, ICD9 & ICD10 (ANSI 837,837i,,835, 4010 and 5010)

Edi Support - Clearinghouses supported Trizetto and Navicure

HL7 Interfaces – Monitor servers and restart jobs that fail (using Mirth Servers)

Documentation – Write, Edit and Revise user manuals (Macros and Knowledgebase Articles).

Edited and updated Kayako SQL Report Queries

PRODUCT SUPPORT MANAGER/QA TESTER NUEMD (NUESOFT TECHNOLOGIES) AUG 2010 - JAN 2015

Management– Managed a team of 8-12 employees. Implementation of support processes, new hire training, scheduling and coaching. Addressed all help desk escalated issues. Internal liaison for all departments.

Generated Department and management reports on a weekly basis for the Director of Product support/Management.

Practice management (PM) EHR, Android and IOS Software Support- Software training and support to offices & clinics inclusive of assisting clients on the functionality of the program; triage and resolution and acting as an intermediary between operational departments (Q/A, EDI, Product Development, and IT).

Quality Assurance Testing - Tested multiple versions of PM/EHR software, taking into consideration different browser platforms/operating systems. (Supported IE 7, Firefox, Chrome and Windows or MAC version 10.7.3 and above)

Involved in System Testing, Regression Testing, Performance Testing, Functional Testing, Integration Testing and User Acceptance Testing. Well acquainted with Bug Life Cycle, bug tracking tools and Created test cases for new product development

Analyzed and reported discrepancies, inconsistencies, and identified Bugs with software enhancements, releases, and modifications to production environments.

Worked with developers on Bug replications, bug fixes, script revision

Worked with Project managers on Release dates and understanding client specification on custom requests

Worked with Marketing on updating and creating software manuals.

Tested Software bug fixes and new features on Web Based staging environments (copies of production)

Generated Ad hoc reports as needed

Java - Installed and troubleshooted java login issues

Billing - Support UB04, CMS 1500 claims, ICD9 & ICD10. (ANSI 837,837i,,835, 4010 and 5010)

Edi Support - Clearinghouses supported Emdeon, RelayHealth, Noridian, Availity and Office Ally

CUSOMER SERVICE (CENSUS PROJECT) RYLA INC APRIL 2010 – AUGUST 2010

Evaluated respondent answers to get more accurate data on census follow-ups.

PROVIDER SUPPORT AGENT IN HEALTH MANAGEMENT BCBS AL AUGUST 2008– MAY 2009

Verified patient health / dental insurance benefits for doctor’s offices.

Assisted doctors with patient precertification approval on complicated procedures.

Researched exclusions and limitations of patient benefits and explained / educated on findings.

Handled claims, updated customer accounts.

Knowledge of CPT codes, ICD-9 codes, GMCD, MRO Screens.

GENERAL MERCHANDISE DEPARTMENT MANAGER WAL-MART MARCH 2004 – JULY 2008

Managed 14 small departments.

Hired, supervised and coached department employees.

Handled customer requests and discrepancies.

Inventory tracking, ordering and adherence to planograms / modulars.

IT INTERN UNITED NATIONS HUMAN SETTLEMENTS PROGRAM (UN-HABITAT) OCT 2002– AUG 2003

IT Internship: assisted in maintenance of UN-Habitat website, development of databases in MS-Access/VB, development of Lotus Notes databases

Software Installation and data entry.

Contact this candidate