Marie Coleman

Hello! I'm Marie

I will confess I'm a bit of a data/systems/applications geek...I have over 15 years of systems and business experience. Well rounded, having obtained exposure in both the private and public sectors and different work cultures, I have built my career in a variety of roles and industries (Higher Education, Health Care, Oil and Gas, Telecommunications, Government/Military) while delivering a consistently high level of quality performance.

I have an immense appreciation for challenges and enjoy finding innovative ways to meet them. My professional experience as well as functional and technical savvy are transferrable in any environment.

I am always open for new opportunities to invest in, to grow, and to mentor.

Professional Profile:

• Strong functional and technical background in ERP/CRM/BI/ECM, systems implementation, data mining/modeling/visualization/analysis, requirements gathering, gap analysis, data mapping and conversion, upgrades, enhancements, coding, workflow and process automation, application development and testing strategy, issues tracking and resolution, project management.

INFORMATION TECHNOLOGY & SERVICES

Available for:

Business Intelligence
Decision Support
Systems Implementation & Support
Project Management
Applications and Web Design

Email: marie_coleman_a@hotmail.com

LinkedIn Profile: www.linkedin.com/in/marieacoleman

Website: www.mariecolemana.com/onlineportfolio

EXPERIENCE

Experience

Professional Profile

Introduction

2018-2019

Business Information Consultant

ANTHEM, INC.

Source the meta and transactional data to support datamart consumption in the datawarehouse architecture (raw data ingestion layer, common data layer, analytic data layer) for the PIAI (Program Integrity Aligned Incentives) initiative for the Diversified Business Group. Lead functional area data sourcing, mapping and visualizations. Facilitate tangential system request modifications where data modeling has a downstream dependency.

As a core team member, successfully delivered the 2019 datamart MVP phase I go-live.
Created a SharePoint custom workflow repository for downstream client reporting as a stop-gap to enable meeting MVP (minimal viable product, per Agile).

2012-2018

Application Lead

UNIVERSITY OF HOUSTON

Manage the development, implementation, maintenance, upgrades, and enhancements of information technology ERP application modules. Create and manage testing strategies of system modifications, enhancements, and projects; formulate acceptance criteria. Liaise between business owners and technical staff. Collaborate with stakeholders and impacted users regarding ERP capabilities, enhancements and disruptions. Facilitate defining and usage of security permissions and roles. Prepare training materials; plan, organize, and conduct multi-campus and cross-functional training. Deliver informative presentations and collaborate as a subject matter expert on system functionality. Manage projects and lead deliverables. Facilitate analysis and research of Business Intelligence ERP tool for acquisition.

Application lead on the UHD campus Banner/PeopleSoft implementation project for the custom CB module and IR module.
Application lead on the 9.2 upgrade project of the institution’s custom CB module, IR module and PeopleTools Query.
Project manager on UHD campus Building and Facilities Banner/PeopleSoft conversion.
Application lead on HR/CS database split project of the institution’s custom CB module, IR module and PeopleTools Query.
Project manager on Query Security Architecture reengineer project.
Consultant on Assessments Committee. Consulted with Student Affairs and Enrollment Services departments on assessment review and preparation projects. Collaborated on, designed and developed the committee’s SharePoint website.
HEUG/SCHRUG member and workshop presenter for Basic Query and Advanced Query.
Created a track on Metrics Reporting in collaboration with the Undergraduate Scholars department for their Academic Advisor II certification program.

2008-2012

Functional Analyst IV

UNIVERSITY OF HOUSTON

Responsible for the complex system process analysis, design and simulation in relation to the integration of the university's business systems and State of Texas regulations, the communication and resolution of issues with functional staff, and the coordination of programming requirements with technical staff. Performed analysis and re-design of business processes. Led the deployment of and developed SharePoint site containing custom dashboards and multi-level complex workflows. Led Query methodology and knowledge transfer. Used advanced technical skills to provide ad hoc analysis for other modules within Campus Solutions.

Functional lead on the 9.0 upgrade project of the institution’s custom CB module, IR module and PeopleTools Query.
Led the department’s SharePoint 2007 to 2010 upgrade, involving restructuring and redesign of the site’s components.
Designed, developed and deployed an automated toolset (repository lists, custom pages, custom form/views, and complex custom workflows) for submitting, maintaining, and tracking enhancement request business cases in SharePoint. A key initiative of the project was meeting the university’s goal of leveraging technology to conduct business more efficiently. The work required advanced use of SharePoint Designer custom workflow constructs and web-parts design; as well as advanced InfoPath form design, rules, views, widgets and form validation edits.

2005-2008

Decision Support Analyst;

Sr. Financial Analyst

MD ANDERSON CANCER CENTER

Performed advanced analysis to support strategic operations and financial oversight of patient care. Developed, implemented and supported application tools for use in monitoring and evaluating strategic decisions based on operations and product line performance; including data mining, data modeling, data visualizations, and trend/predictive analysis. Analyzed reconciliations and resolved discrepancies between the patient accounting system and the various decision support systems. Performed requirements gathering, design specifications, and GAP analysis. Developed project plans scope, resourcing and WBS, testing strategy, and implementation strategy of new modules, upgrades and system modifications. Maintained data dictionary for the HCC application. Oversaw batch jobs scheduling, interfaces development, and system maintenance. Wrote SQL scripts for data transformations and handling, and wrote SQL query selects for data analysis.

Performed analysis and reconciliation of company centers account activities and audited reconciliations of other staff. Maintained controlling records and Access/Excel spreadsheet databases to ensure accuracy of data entered in accounting systems. Monitored and audited procurement activities. Prepared monthly, quarterly and yearly trend and forecasting analyses and graphical visualizations of account balances, gross patient revenue, department costs, available funds summary, operating margin, grants and contracts, and variance reports. Prepared department budget and forecasting submissions in Hyperion Planning, Hyperion Forecasting and Hyperion Analyzer. Led process improvements projects.

Designed, developed and implemented Hyperion Brio-based Uncompensated Charity Care focused application for monitoring and analyzing the indigent population. The custom toolset automated the staging of approximately 150 statistical process control and bar charts and 140 tabular summary and exception reports each month utilizing key operational metrics (patient counts, charges, length of stay and gross patient revenue). The project allowed the institution to experience economies of scale and cost savings by producing a higher volume of reports while eliminating FTE efforts previously used each month in the manual production process. Experience included utilizing Oracle SQL, Visual Basic, JavaScript and Brio proprietary coding languages as well as advanced statistical calculations.
Designed, developed and implemented departmental custom Projects database (in MS Access, VBA) that provided a client-specific central repository for capturing, tracking, and reporting on project requests undertaken by the department and performance measures on the project.
Automated the department's "Encounters by Admit" process (Access-HCC ODBC link staged data) to meet the needs of many departmental query requests. Also made changes to the algorithms to improve the integrity of the staged data.