Amy R Brooks
Nolensville,TN
Summary
Dynamic Senior Business Systems Analyst with extensive expertise in healthcare and general businesses environments specializing in related data analysis, software administration and project management. Proven track record in optimizing ETL processes and enhancing database performance leading to improved operational efficiency. Skilled in SQL development and adept at fostering collaboration across teams to drive successful project outcomes. Committed to delivering high-quality solutions in fast-paced settings.
Overview
17
17
years of professional experience
Work History
Senior Business Systems Analyst
Centene Management Company, LLC
St. Louis, MO
09.2021 - 10.2024
- Stepped into the role of Senior Business Systems Analyst at Collaborative Health Systems, a subsidiary of Centene.
- Add details...CMS, Compliance, Vendor Related Project, Home Grown Provider/Beneficiary System, MA, ACO, MSSP, Data downloads and loads, data integrity...
Senior Applications Software Engineer
Centene Management Company LLC
St. Louis, MO
06.2020 - 08.2021
- Facilitated the transition of responsibilities to another IT division within Centene Technologies after the merger with WellCare Health Plans.
- Lead migration project to transfer PeopleSoft-related ETF processes in the current system being retired, Diplomat, to the new system, Control-M. The migration involved coordination with the EFT Team, Business Owners, Vendors & PeopleSoft Admins to document, test and promote new file transfer jobs upon successful completion of end-to-end testing.
- Served as Business Analyst for RPA/IPA team during the intake process involving collaboration with business owners gathering requirements & creating documentation to determine processes suitable for automation.
- Collaborated on project approvals, assisted in development initiation including mapping of manual processes in Visio, and ensured thorough testing by business users prior to production deployment.
- Worked as an Alteryx developer to enhance existing workflows and create new workflows approved for automation through the intake process.
Systems Engineer (1st Year as IT Contractor)
WellCare Health Plans, Inc.
Brentwood, TN
02.2015 - 05.2020
- Provided user support, data analysis and process development for transition of a Medicare and Medicaid affiliated health plan company serving markets in Tennessee and other southeastern states.
- Designed and optimized ETL work flows leveraging MS SSIS 2005-2012 for data in production and legacy systems based in MS SQL Server and Oracle.
- Managed creation and enhancements of MS SQL and Oracle stored procedures, packages and views related to various legacy system databases, including an Xcelys data warehouse.
- Designed complex T-SQL and SQL queries for comprehensive data analysis in multiple environments as required for business and compliance reporting needs.
- Ensured continuous operation of MS SSRS reports in both current and legacy systems.
- Adhered to WellCare corporate documentation and procedure guidelines for the product development lifecycle using MS TFS 2012.
- Led IT initiative for Tennessee and Arkansas state-mandated data collection projects, All Payers All Claims Databases (APCD/APAC), including development of code to retrieve legacy data, documentation of all aspects of the projects and completion of quality assurance for all data submitted to each state.
Manager of Data Exchange
naviHealth, Inc.
Brentwood, TN
01.2014 - 09.2014
- Hired and managed a new Data Exchange Team of SQL and ETL Developers to complete the build out of a new data exchange environment and maintain existing integration processes for all data exchanged between clients and our various internal database environments.
- Provided support to current and prospective external clients and our internal Data Analytics Team by improving data accuracy and completeness, ensuring secure transfer and providing a better understanding of all clinical and claim data elements.
- Designed, developed and maintained MS SQL Server 2012 stored procedures, MS SSIS 2012/2008 packages and MS SQL Server Agent jobs to exchange data between secure FTP sites including cleansing and loading of incoming data into the appropriate internal database environment(s) and secure export of data to external clients.
- Lead all facets of data integration for new client implementations, most recently completing the implementation of the company's largest client.
SQL Server Developer (Interim Data Architect)
CareSpot Express Healthcare
Brentwood, TN
12.2012 - 01.2014
- Team Lead and Interim Data Architect over all Business Intelligence processes, projects, databases and personnel.
- Designed, developed, implemented and maintained an MS SQL Server 2012 Data Warehouse including patient visit, claims and marketing data from the current EPM/EHR system, NextGen; both legacy systems, Systoc and SolAR spanning a total of ten databases; and the customer satisfaction survey data collected by Listen 360.
- Built complex queries to perform data analysis and create reports for Revenue Cycle, Marketing, Accounting, NextGen Applications, various outside business partners and all levels of management including quarterly investor reports.
- Created ETL processes using MS SSIS 2012 for the integration of source data into the data warehouse and managed all imports and exports needed for outside vendors and partners.
- Provided backup SQL Server Database Administration support to the Director of Technical Services including performance tuning, peer review of coding changes prior to implementation and general troubleshooting of MS SQL Server 2012 database issues.
- Presented team objectives and regular status reports including project milestones and accomplishments to the company's executive leadership team at monthly IS Steering Committee meetings and to the IS management team at weekly IS Management Team meetings.
- Along with the team, completed implementation of a new reporting solution, SAP Business Objects, using the new data warehouse to provide more efficient and accurate reporting.
Manager of Information Services
Renal Advantage, Inc. / A Fresenius Company
Franklin, TN
05.2011 - 12.2012
- Lead a team of Applications Analysts in the daily support and maintenance of all clinical, billing, purchasing and accounting systems for a dialysis healthcare organization.
- Managed vendor relations for the various systems to coordinate support, maintenance, customizations and upgrades.
- Collaborated with other members of management and staff to regularly review business processes and determine where new internally developed reports and applications could be created to enhance or streamline these processes.
- Managed projects to implement CMS changes as they related to our clinical and billing systems, including testing and implementation of new software or changes to current software functionality through the organization of meetings, fulfillment of deadlines, creation of training documentation, and regular status communication throughout the project life cycle.
- Coordinated with the Development Team and Network/System Administrators to backup, maintain and restore as needed the various application and reporting environments in MS SQL Server 2005/2008 and Oracle 10g databases including performance optimization, security and extensive data analysis.
IS Systems Analyst (Development - 1 Yr / Applications - 1 Yr)
Renal Advantage, Inc.
Franklin, TN
04.2009 - 05.2011
- Maintained positive relations with users, management and other departments to ensure data reporting and system needs were understood and met.
- Developed and maintained clinical, billing, purchasing and accounting reports including patient outcomes dashboards using MS SSRS 2005/2008 and published these reports to the company's internal Portal.
- Performed database and application upgrades for Oracle-based billing system, QMS, including QA testing.
- Provided analytical ad hoc database reporting across systems for all levels of management and staff.
- Provided daily applications support for all clinical, billing, purchasing and accounting systems.
- Completed regular internal auditing of user accounts and application data.
- Provided mentoring and training to other team members.
- Responsible for research and implementation of new software based on the company's current and future needs.
IS Administrative Assistant / Part-Time Help Desk Support Agent
Renal Advantage, Inc.
Brentwood, TN
03.2008 - 04.2009
- Tracked spending and balanced the monthly IS Department financials to create end of month reports for the Chief Information Officer to be utilized for ongoing and annual departmental budgeting.
- Supported the IS Help Desk as needed by providing systems and hardware support to a nationwide network of employees.
- Provided administrative assistance to the CIO and all other Information Services Department leaders including but not limited to event planning, travel, correspondence and organization.
- Coordinated with the team of IS Directors to create monthly and quarterly status reports for use by the CIO in executive leadership team meetings.
Education
Developing High-Performance SQL Server Databases -
Learning Tree International
New York, NY07.2012
Oracle PL/SQL Programming -
Learning Tree International
New York, NY09.2010
Microsoft Course 2793A - Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services
New Horizons
Nashville, TN05.2009
Microsoft Course 2778 - Writing Queries Using MS SQL 08 Transact-SQL
New Horizons
Nashville, TN04.2009
Skills
- Knowledge of CMS (Medicare/Medicaid) Compliance Processes and Reporting Requirements
- Knowledge of Databases: MS SQL Server, MS Office Access, and Oracle
- Data Analysis: SQL Queries and MS Office Excel
- Database Administration: SQL Server and Oracle
- Database Development: Queries, Stored Procedures, Views, and Functions
- Database Maintenance: Analysis, Profiling, and Performance Tuning
- Database Programming Languages: T-SQL and PL/SQL
- Data Warehousing: Design, Develop, Deploy and Manage
- Reporting: Design, Develop, Deploy and Manage - MS SSRS
- Project Management and Process Development
- Project/Process Prerequisites: Requirements Gathering and Mapping
- Project/Process Documentation: Business, Functional, and Technical Specifications
- Software Development Life Cycle (SDLC)
- Managed File Transfer (MFT) Processes: Design, Develop, Deploy and Manage - Control-M
- ETL Processes: Design, Develop, Deploy and Manage - Alteryx and SSIS
- Health Claims Revenue Management Systems Admin: Xcelys, NextGen EPM, QMS, and Artiva
- Health Information Management Systems Admin: NextGen EHR and HII-AMI TIME
- Accounting, Procurement, and Inventory System Admin: MS Dynamics SL
References
Available upon request
Coursework
- Microsoft Course 2778 Writing Queries Using MS SQL 08 Transact-SQL, 04/01/09, New Horizons, Nashville, TN
- Microsoft Course 2793A Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services, 05/01/09, New Horizons, Nashville, TN
- Oracle PL/SQL Programming, 09/24/10, Learning Tree International, New York, NY
- Developing High-Performance SQL Server Databases, 07/13/12, Learning Tree International, New York, NY
Timeline
Senior Business Systems Analyst
Centene Management Company, LLC
09.2021 - 10.2024
Senior Applications Software Engineer
Centene Management Company LLC
06.2020 - 08.2021
Systems Engineer (1st Year as IT Contractor)
WellCare Health Plans, Inc.
02.2015 - 05.2020
Manager of Data Exchange
naviHealth, Inc.
01.2014 - 09.2014
SQL Server Developer (Interim Data Architect)
CareSpot Express Healthcare
12.2012 - 01.2014
Manager of Information Services
Renal Advantage, Inc. / A Fresenius Company
05.2011 - 12.2012
IS Systems Analyst (Development - 1 Yr / Applications - 1 Yr)
Renal Advantage, Inc.
04.2009 - 05.2011
IS Administrative Assistant / Part-Time Help Desk Support Agent
Renal Advantage, Inc.
03.2008 - 04.2009
Developing High-Performance SQL Server Databases -
Learning Tree International
Oracle PL/SQL Programming -
Learning Tree International
Microsoft Course 2793A - Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services
New Horizons
Microsoft Course 2778 - Writing Queries Using MS SQL 08 Transact-SQL
New Horizons
Similar Profiles
Rona WilsonRona Wilson
Care Management Support Coordinator II at Centene Management Company LlcCare Management Support Coordinator II at Centene Management Company Llc
Melissa JohnsonMelissa Johnson
NICU/Pediatric Concurrent Review Nurse at Centene Management Company LLCNICU/Pediatric Concurrent Review Nurse at Centene Management Company LLC
Geri AlbrightGeri Albright
Concurrent Review Nurse, Utilization Management at Centene Management Services LLCConcurrent Review Nurse, Utilization Management at Centene Management Services LLC
Tyagaraja MandayamTyagaraja Mandayam
Tutor at Personal TutoringTutor at Personal Tutoring
KRISTA COLLEEN ECHOLSKRISTA COLLEEN ECHOLS
Risk & Continual Improvement Program Manager, Senior Cytogenetic Technologist at LABCORPRisk & Continual Improvement Program Manager, Senior Cytogenetic Technologist at LABCORP