Erika Bricker, Pmp® Email & Phone Number

Austin, Tx, Us

Columbia, Maryland, United States

Lead data integration initiatives from multiple EHR systems, significantly enhancing the accuracy and efficiency of clinical quality measure reporting.Drive client success through targeted training sessions and comprehensive data analyses, informing strategic decisions in software implementations.

Remote

Supported clients through Saas Implementations.Managed regulatory submissions for assigned clients, ensuring compliance and accuracy while using MS SQL/Databricks to troubleshoot measure results and maintain data integrity and reliability.Improved client outcomes by validating and resolving discrepancies in data analysis and eCQM measure results, ensuring high-quality deliverables.

Austin, Texas Metropolitan Area

Engineered and optimized ETL processes for healthcare data across multiple platforms (Meditech, Epic, Cerner, eClinicalWorks, Allscripts Pro) using SQL, Azure Data Lake, Databricks, Spark SQL, and Python, improving data flow and accessibility.Proactively identified and resolved critical issues in data extraction processes and pipelines, significantly enhancing data quality and reliability for downstream analytics and reporting.

Remote

Contributed to the development of SQL databases for healthcare software, enhancing eCQM reporting capabilities and supporting critical decision-making processes.Led the adoption of Agile methodologies, significantly increasing team agility and productivity as ScrumMaster.Reduced build-time by 50% through the implementation of new processes and integration of the Redgate Toolbelt suite, markedly improving deployment efficiency.

Remote

Involved in all aspects of the product development life-cycle of web-based business intelligence/decision support software for the healthcare industry.SQL development, data warehousing, ETL, and database management using Microsoft SQL Server, Visual Studio and Team Foundation Server. Certified ScrumMaster®.

Collaborated with healthcare clients to develop custom reporting solutions using T-SQL and SQL Server Reporting Services.Performed basic SQL server database administration tasks as necessary to support products and services.Supported custom software solutions for healthcare regulatory reporting from the Meditech EHR.

Developed and implemented custom clinical and financial reporting solutions, enhancing operational efficiency and client satisfaction using T-SQL and SSRS.

T-SQL development in Microsoft SQL Server.Created custom clinical and financial reporting solutions using SQL Server Reporting Services (SSRS).Troubleshooting data and software issues, collaborating with clients to find solutions.

Operated a freelance web development business, specializing in web design, graphic design, and internet marketing services, with a focus on empowering women-owned businesses through enhanced digital presence.Delivered full-spectrum web hosting and maintenance services on both Linux and Windows platforms, ensuring optimal performance and client satisfaction.

Directed the implementation of the Meditech Data Repository, a Microsoft SQL Server database, improving data accessibility and management.Managed SQL 2005 servers, overseeing security, installations, and upgrades to ensure system integrity and performance.Supported Meditech Financial modules, performing consistent system maintenance to enhance functionality.Developed and deployed clinical and financial reports using T-SQL, SSRS, and SSIS, thereby boosting reporting accuracy and utility.

Filed, distributed and release records in accordance with hospital policies and HIPAA regulations.Trained on health information systems such as SoftMed, Unity, Meditech and document imaging software.

Prepared revenue-related metrics including analysis of network usage and billing events for carrier network access, telephone subscribers, special circuits, IP and video services and detection of phantom traffic and fraud.Analyzed and interpreted reported data, identifying trends and anomalies using Excel, Access and Crystal Reports.

Developed, tested, and reported on the internal controls of the company for Sarbanes Oxley requirements.Prepared the Gross Receipts Tax, Sales and Use, Excise, and Tire Tax payments and returns.Processed elimination journal entries monthly and reconciled assigned accounts.

Supervised a group of Billing analysts responsible for auditing billing cycles, resolving customer billing complaints, and reporting cycle statistics. Participated nationally in special projects such as the development of new audits for Sarbanes Oxley compliance and the integration of new systems.

Responsible for ad hoc reporting of billing data to support CEO/CFO, Finance, Marketing, Regulatory and Sales using BrioQuery, as well as developing reports and templates using Access and Excel.Responsible for auditing and committing billing cycles, including trending and reporting of financial statistics.

B.S., Business Administration, Minor In Accounting

Activities and Societies: Phi Beta Lambda, President, Pre-Law Association

Mba, Business Administration