Software Data

RENEE MICHELE KEY

*** ******* ***** ********@*******.***

Madison, AL 35757 301-***-****

PROFESSIONAL EXPERIENCE

Administrative Assistant: Missile Defense Agency, May 2018 – Present; Oakwood University, Oct 2017 – May 2018 & Jan 2011 – Sept 2011; Cherry Bekaert, Feb 2017 – April 2017

Provided 3-letter support to BCT and BCE via: ETasker acceptance, delegation and signature approval of various directives both internal and external to Battle Command; DTS travel support for travel authorization and voucher reimbursement; DAI SuperTimekeeper support; Outlook and EScheduler conference/meeting support;

University office support for President and VP of Faculty Development, Communication Department Chair, and English Department Chair: travel arrangements; set up meetings and synchronize calendars; take minutes; requisition adjunct salaries, general supervision of contractor work, ordering office supplies.

Managed (3) student workers in various support roles: assigned data gathering and report writing; assigned spreadsheet updates for course and room schedules, and campus errands (mail pickup, faculty errands).

Software utilized: D2L software class registration maintenance and test scores input; Infomaker for SQL report writing on breakdown of student population in various concentrations; transcript reports.

Interfaced with Zoomerang survey software to create online survey for student body activities tracking.

Created purchase orders; approved invoices for payment through Jenzabar accounting software.

Logistics coordinator for international director and staff for student exchange program presentations.

Conference center coordinator for Student Services for Moran Hall: blackout dates, participate in walk-throughs, distribute and retrieve sound equipment.

QA Test Analyst, Tennessee Department of Treasury, Nashville, TN, February 2016 August 2016

Reviewed business requirements to ensure that documentation is complete, comprehensive and testable.

Participated in system requirements meetings to collaborate the business needs into testing scenarios.

Created test plans, test cases and test scripts for monthly builds for the TCRS/Tennessee Consolidated Retirement System (DPAS/Deloitte Pension Accounting System) application development and maintenance initiatives.

Completed assigned testing in development, system, UAT, functional, and regression test environments.

Monitored, recorded and reported on testing tasks to validate expected results for the Qualified Domestic Relations Order/QDRO software extension builds – for counseling services and member services managers.

Compiled reports for internal clients regarding tests progression -- and create and perform defect analysis -- to indicate the current state of TCRS stability in the QA environment and in the production environment.

Assigned testing tasks to other project team members by providing test scripts and scenarios.

Ensured testing is complete, accurate and measured according to the needs of the business users, the work of the developers, and the requirements of the project team lead. Assisted in regression testing.

Senior Financial Analyst, Parallon/HCA, Cool Springs, TN, September 2014 June 2015

Designed, developed and implemented revenue cycle financial reports for use by executive management.

Used Teradata SQL, Excel pivot tables and vlookups to develop analysis to solve complex operational, financial and/or accounting problems.

Assisted the Director of Reporting with developing and maintaining reporting tools necessary to support Parallon operations, including the development of tools to effectively measure financial and operational performance.

Developed and produce month-end and ad-hoc reports for internal and external Parallon executive management.

Created procedures to promote efficiency and repeatability of reporting and analytical tasks, regarding documentation and automation as appropriate.

Communicated regularly with Shared Service Center and other field executives to ensure smooth data collection and reporting processes.

Completed QA testing for Mercy Health EMR/ArcPlan reports.

Renee Key

Page 2

Senior QA Test Analyst - MicroStrategy, Parallon/HCA, Cool Springs, TN, Sept 2011 August 2014

Met with MicroStrategy developers, business analysts, end users, project managers, Teradata and MicroStrategy administrators, and business owners for requirements review, design specification and technical documentation.

Followed System Project life cycle (SDLC): developed test plans, test cases, traceability matrix, and metrics to ensure all testing requirements were met and documented – in a manual functional test environment.

Completed agile methodology testing for system testing, integration testing, UAT testing, and regression testing.

Coordinated, prioritized, updated and monitored defects in Quality Center/ALM from initiation to resolution.

Attended daily scrums to report on defect updates/progress and defended defect positions.

Validated back-end ETL and database data against GL/Host (mainframe), Patient Accounting (DMR/MOR reports), EMR/ArcPlan reports, QMIRS/VISTA reports.

Created and executed Teradata SQL queries, and Essbase queries (Excel Add-in) to validate U/I test results.

Tested QA metrics and KPIs for MicroStrategy dashboards on the web and in the iPad environment.

Completed QA analysis for the following MicroStrategy dashboards for functionality, data inconsistencies, metric source verification, formatting and presentation, and integration testing: Recycle Cycle Management web & iPad (4) dashboards with monthly, quarterly, and year-to-date iterations (Accounts Receivable, Cash, Payment Compliance and Summary); Net Revenue (Net Revenue, Other Revenue, Uncompensated Care, SMA, Financial Class, Volume); Service Level Agreement (facility & summary); Physicians Services Charge Entry dashboard; Daily Management Report (Cash) Inpatient/Outpatient web & iPad dashboards; HSC Scheduling/Forecasting dashboards; Recovery Audit Review (RAC) dashboard; Patient Accounting Open Connect dashboard.

Managed an additional QA resource during Net Revenue dashboards development.

Continued regression testing as dashboards were enhanced; as configurations changed; as software was updated.

Systems Analyst, ERC, Inc. (NASA Ares I Project), Huntsville, AL, May 2009 – June 2010 (RIF-ed)

Created and maintained Cradle data (systems engineering software) for requirements, DVOs, data definition files, and technical owners (TEPOCs). Provide query solutions for user data needs, audit imports, and verify User Acceptance Testing for Cradle upgrades.

Developed and established hierarchy links between data definition files (TEPOCs, requirements, verification, comments, doc sections), for applicable documents.

Created and maintained the Cradle Support Team’s (CST) public Integrated Collaborative Environment (ICE) Wiki website pages.

Completed training courses and post documentation on the IEC (Integrated Engineering Capability) environment, through the Windchill ProjectLink.

Administrative: Published the weekly TEPOC report, and the CST task worksheet; create traceability reports. Promoted data into DDMS for review (data management system).

INFORMATION ACCESS SOLUTIONS department, Carefirst Blue Cross/Blue Shield, Washington, D.C., September 1998 – May 2009

Senior Programmer Analyst – June 2001 to May 2009

MicroStrategy (MS) Administrator for 77 users (10 desktop and 67 web-based): Completed project migrations thru standard lifecycle development (MS IIS); security administration using roles and ACLs; server performance tuning; troubleshooting on Oracle and Sybase platforms; technical writing and maintaining documentation describing changes and modification to all systems (Oracle, Sybase, FACETS, MicroStrategy).

Tracked space allocation and processed timing of each database/report extraction. Attended Change Control to defend any changes to table structure or row insertions. Maintained system backups.

Created and maintained extraction scripts (SQL, PL/SQL) for daily, weekly and monthly data loads for financial data marts. Analyzed data, and researched fixes when download failed.

Developed and connected hierarchy of attributes in a Star schema for Earned Income datamart.

Trained users on MicroStrategy desktop and web environments; wrote/revised procedures.

Created financial reports (Accounts Aging Report, Underwriting reports, Sales and Earnings reports, Enrollment reports), and created user ad-hoc financial reports through MS Desktop, MS Web, and MS Free-form SQL.

Created User Acceptance Test environment for financial data marts (Earned Income, and General Ledger).

Renee Key

Page 3

Logged and monitored test strategies into Mercury Quality Center (Test Director) – verified FACETS test data against datamarts (SQL scripts executed against Oracle and Sybase servers).

Assisted in stress tests, at completion of each data mart build, prior to PROD release.

Provided analytical and testing support for FACETS v.431 production (source system) upgrade.

Senior Business Analyst – January 2000 to June 2001

Provided analytical and testing support for the Broker Administration project.

Wrote Microsoft ACCESS queries for controllers department (in FACETS RUBI reporting system).

Completed month-end analysis of billing/receipts system (FACETS) and earned income datamart (target).

Processed ongoing monthly reconcilements of earned income datamart suspense account.

Assisted in UAT testing for any Trizetto financial enhancements to FACETS (OLTP) production system.

Wrote or revised procedures as part of training/documentation.

PC Systems Support Specialist – September 1998 to January 2000

Designed MSAccess database to facilitate reconciliation of corporate Accounts Receivable system.

Maintained MSAccess Foreign Currency Exchange database.

Converted MSAccess databases from 16-bit to 32-bit platforms; performed testing and troubleshooting.

Debugged and ran Easytrieve Plus programs to extract data to the desktop level from mainframe files.

Participated in implementation of Oracle General Ledger (V. 10.7). Completed advanced training in Oracle General Ledger and Oracle ADI software.

Developed reports; prepared report catalog and system downloads; wrote technical procedures.

Provided desktop maintenance: software installation, integration of new programs and hardware.

Created a procedure to reconcile off-line general ledger accounts against mainframe master control files.

EDUCATION

George Washington University, Washington, D.C. -- Bachelor of Business Administration

Finance/major; Economics/minor

ADDITIONAL TRAINING AND SOFTWARE:

Test software utilized: Issue Tracker, HP Quality Center software, TFS software.

Teradata SQL and Access queries (for EDW); Essbase and EMR/ArcPlan reports.

Retrieve back-end data from reporting tools: Document Direct, Vista, GL Host, and SMA.

Attended the following training sessions while a test analyst: Agile Awareness course; Agile Lean presentation on Project Work Request (PWR) process; 2-day Fundamentals of Software Testing class; Completed the QACoe Internal Certification; Daily Batch Reporting and Master File Maintenance; Patient Accounting Files class; E-tran class; reviewed Quality Center ‘Flash Facts’ videos. Also attended the 1-week IT Healthcare Connection program (hospital setting).

SQL Querying 2-day (refresher) class - July 2013.

MicroStrategy: Certified Project Designer, March 2012; Transaction Services for Dashboard and Mobile App Developers course – June 2013; Document Essentials certification; and Dynamic Dashboards certification – April 2013; Project Design certification - April 2012; Advanced Reporting certification – May 2011.

Web Administrator - UAH course completed November 2009.

NASA training classes: Cradle Verification & Validation Design and Realization classes (August 2009).

Database Design; and Structured Language SQL classes at US Department of Agriculture Spring 2002.

Oracle Programming at Career Training Institute, June 1998: Introduction to Oracle 7/8 and SQL*PLUS; Introduction to PL/SQL; Oracle Developer 2000 (Forms V.4.5; Reports V. 2.5; Graphics V.2.5).

CLEARANCE:

SECRET

Contact this candidate