Marie C.'s Location
Greater Houston, United States
About Marie C.
• Strong functional and technical background in ERP/CRM/BI/ECM: systems implementation/support, data mining/modeling/visualization, regression analysis/inferential statistics/statistical process control, requirements gathering, gap analysis, data mapping/conversion, upgrades/enhancements, coding, workflow, process automation, testing strategy, issues tracking/resolution, full project life cycle, project management.• Applications implementation, upgrades and production support hands-on experience of ERP PeopleSoft, SAP, and McKesson STAR application suites, HCC, Brio Intelligence/Data Warehousing, MS Access customized applications.• Full project life cycle experience in PeopleSoft and SAP ERP implementations. Soft project life cycle experience includes systems upgrades/enhancements, customized tools development, various special projects.• Continued project management training (project life cycle, managing constraints, WBS and network diagramming, crash analysis,Gantt charting, PERT/critical path analysis). Experience includes Agile and Scrum methodologies. • Process improvements training and experience includes Statistical Process Control charting and analysis, Common Cause/Special Cause variation analysis, flowcharting, Pareto charting/analysis, Fishbone cause-and-effect charting/analysis, Six Sigma methodologies, and other tools used in process improvement methodologies.• Data Analysis, Process Improvements and Automation experience with building customized Access Data Tools, building Excel Macros/Visual Basic Tools, Dashboarding, building custom Hyperion Brio Applications, building custom SharePoint Application and Workflow Toolsets.• Fundamental accountant/analyst experience. Financial accounting and reporting, Fund/government accounting, Auditing/Compliance, Forecasting, Aging Analysis, Trend Analysis, Account Reconciliation.• Data Mining and Analysis, KPI/metrics Dashboarding, broad adhoc reporting, SPC (statistical process control) reporting, Regression Analysis, Inferential Statistics.
Marie C.'s Current Company Details
Business Intelligence, Application Lead, Systems Analysis and Decision Support mariecolemana.com/onlineportfolio
Marie C. Work Experience Details
-
Business Information Consultant – Program Integrity Aligned Incentives, Diversified Business GroupAnthem, Inc. Feb 2018 - Jul 2019Houston, Texas Area•Source the meta and transactional data to support datamart teradata consumption in the datawarehouse architecture (raw data layer, common data layer, analytic data layer) for the PIAI initiative•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 project methodology) -
Application Lead - Campus Solutions ServicesUniversity Of Houston Oct 2012 - Feb 2018Houston, Texas Area•Manage ERP modules implementations, development, maintenance, upgrades, and enhancements.•Create and manage testing strategies and 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. -
Functional Systems Analyst Iv - Enrollment Management Production SupportUniversity Of Houston Jul 2008 - Oct 2012Houston, Texas Area•Performed system process analysis, design and simulation to meet institutional and State of Texas regulations. •Performed analysis and re-design of business processes. •Communicated and resolved issues with functional staff.•Coordinated programming requirements with technical staff. •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.** Performed strategic ad-hoc analysis using advanced functional/technical skillsets in support of other modules key projects such as a Security risk analyses, including development of algorithms, macros and use of VBA.**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 CS 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.
-
Sr. Financial Analyst - Gim, At And EcMd Anderson Cancer Center Aug 2007 - Jul 2008Houston, Texas Area•Analyzed and reconciled company centers account activities.•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 procurements, vendor payments, and receipts aging.•Prepared monthly, quarterly and yearly trend and forecasting analyses and graphs of account balances, PRS 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.•Managed accounting of grants and contracts. •Led process improvements projects. -
Special Projects AccountantSt. Joseph Medical Center Mar 2007 - Aug 2007Houston, Texas Area•Performed month-end close processing of payroll salaries, benefits, pto and payroll taxes liability/expense, miscellaneous revenue, suspense account, and miscellaneous accruals journal entries in the general ledger; related expense and balance sheet liability account reconciliations and MTD and YTD favorable/unfavorable variance reporting; and productivity reporting. •Trained support staff on account reconciliations.•Resolved subsystem modules to general ledger system errors for month-end close.•Developed Monthly Operating Review reporting packages for executives/directors meetings providing dashboards, graphs and details on key financial and operating performance indicators.•Managed system configurations and mappings.•Wrote complex adhoc KB-SQL queries and prepared data analysis for adhoc projects including ROI, utilization, and “bright ideas” cost/benefits analysis.•Assisted Controller and Assistant Controller in annual budget preparation, surveys, and annual tax package preparation.**Advised need of and initiated project to automate closing of GL fiscal periods to prevent errors occurring between submodule to general ledger system feeds and improper posting of financial activity to wrong fiscal periods. -
Decision Support Analyst - Clinical Revenue And Reimbursement/Financial ServicesMd Anderson Cancer Center Jan 2005 - Mar 2007Houston, Texas Area•Performed advanced analysis to support strategic operations and financial oversight of patient care.•Developed application tools for 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 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 the data dictionary for the HCC application.•Wrote SQL scripts for data transformations and handling, wrote SQL query selects for data analysis. **Designed and developed Hyperion Brio-based Uncompensated Charity Care application for monitoring and analyzing the indigent population. The custom toolset automated the staging of 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, 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 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 and developed a Projects database (in MS Access, VBA) that provided a central repository for tracking/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 diverse query requests. Also made changes to the algorithms to improve the integrity of the staged data.
-
Sr. Accountant - Gastroenterology, Hepat,& Nutr/GimnMd Anderson Cancer Center Jan 2003 - Jan 2005Houston, Texas Area•Analyzed and reconciled company centers account activities.•Prepared financial and variance reports.•Tracked and reported capital, controlled assets and minor equipment.•Assisted Department Administrator in budget analysis and forecasting.**Designed and created the financial and assets inventory databases, spreadsheets and reporting toolset. **Designed and created Access-SmartStream ODBC linked database repository and reporting tool.
-
Project Accountant / AnalystSubsea 7, Halliburton Jan 2002 - Dec 2003Houston, Texas Area• Managed two sets of books working directly with GoM F/A Manager and Project Managers. • Project tracking and costing. Financial accounting and reporting of ROV/Survey projects (yielding yearly total firm and anticipated revenues of $10+ million). • Profit/loss analysis and reporting, budgeting, forecasting. Cost analysis. • Billing, collections and receivables, journal entries and month-end close of job ledgers -
Sr. Accountant/Erp Systems Functional Super UserNextira One, Llc / Williams Communications Solutions Jan 1997 - Jan 2002Houston, Texas Area•Performed as functional ERP Systems Super-User.•Developed AP current and future state assessments and GAP analysis. •Implemented PeopleSoft Payables and Expenses for business units. •Maintained the PS Payables, Expenses Reimbursement and Purchasing PeopleSoft modules. •Led module system upgrades and provided applications support. •Led module requirements gathering, system design and configuration, PeopleCode modifications, data conversion, customizations, creation of Crystal Reports, interface development, process scheduling, and resolution of production issues.•Conducted training sessions and presentations. •Prepared IRR analysis for proposed Capital Expenditures on Bluebird Document Imaging system. •Conducted auditing, compliance, and trend analysis of Procurement Card activity, and conformity spending•Provided supervision of accountants and clerical personnel.•Provided advanced functional and technical support including creating customized PeopleTools Queries and Crystal Reports, creating advanced MS Access database ODBC links and connection strings, knowledge of SQR, Application Designer, Workflow Administrator, Security Administrator, EDI Manager, Utilities, Process Scheduler, Application Engine, and PeopleCode.**Developed custom ODBC MS Access database that automated the retrieval and distribution of period costs for month-end reporting. **Designed MS Excel toolset with advanced formulas, macros, alerts, and reports that aided departmental staff in tracking their vendor group of aging payables. -
AccountantMwr, Morale Administrative Support Branch Jan 1996 - Jan 1997Okinawa, Japan• Fund accounting for the MWR Marine Corp military branch of government accounting. • Analysis and reconciliation of Fixed Assets/Capital Projects Fund (capitalization, depreciation, status changes, and impairment) and Work In Progress subsidiary ledgers. • Prepared and posted AJEs for month-end accrued items. • Prepared interim financial reports and restatement of budget for billeting segment. -
Tutor, College Of BusinessPrairie View A&M University Jan 1995 - Jan 1996Prairie View, Tx• Tutored all Accounting classes, Business Statistics and Production Operations Management.
Marie C. Education Details
-
Data Analytics -
Accounting
Frequently Asked Questions about Marie C.
What is Marie C.'s role at the current company?
Marie C.'s current role is Business Intelligence, Application Lead, Systems Analysis and Decision Support mariecolemana.com/onlineportfolio.
What schools did Marie C. attend?
Marie C. attended Western Governors University, Prairie View A&m University.
Not the Marie C. you were looking for?
Free Chrome Extension
Find emails, phones & company data instantly
Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial