Professional Profile

Professional Summary

Versatile and highly qualified Systems Administrator/Manager with 13+ years of experience using SQL Server’s Suite of products (SSRS, SSIS(SSDT), SSMS), managing daily operations of infrastructure, technical teams, and large database environments for healthcare operations and clinical departments. Strong ability to troubleshoot complex system issues and identify solutions to streamline processes. Familiar with many database systems, servers, monitoring tools, and other emerging technologies.

Core Competencies

Exceptional problem solving, multi-tasking, communication, organizational, and time management skills.
Full life-cycle experience in scoping, designing, developing, deploying, and supporting enterprise-scale business database systems and maintenance procedures for SQL Server.
Conduct Web Services test using Soap UI and integration with SQL Server and Oracle Database systems
In-depth knowledge of many web applications, database platforms, and hardware systems.
Unique competency in translating business issues into technical solutions including technical leadership and coordination in ensuring complex system requirements are met.
Outstanding leadership abilities; able to coordinate and direct all phases of project-based initiatives using agile methodologies and creating technical user stories, defining features in an effort to ensure that technical initiatives meet user defined requirements efficiently and timely .
Experience in interpreting and developing solutions around regulatory compliance reporting using SQL Server Reporting Services, Crystal Reports and Microsoft Excel.
Involved in implementation and Migration of various clinical and claim processing systems, Altruista Health Guiding Care, Health Rules Care Manager, Health Rules Payor, InterQual Review Manager, McKesson Care Manager and Sai Global Compliance360.
Developed automated reconciliation program for data quality control using Microsoft Access as the front end developed by using VBA and the back-end data repository using SQL Server Integration Services and SQL Server Management Studios to manage ETL schedules.

Career Overview

Technical Business Analyst

Collaborate with business stakeholders and development teams to elicit and document clear technical business requirements in the migration from legacy systems to Health Rules Payor
Develop, Test and Guide technical teams in the facilitation of REST API calls as the main tool to migrate data from legacy systems and integrate Health Rules Payor with other systems.
Prepare and lead technical training sessions with technical vendors and direct business stakeholders to use Soap UI as the platform to test Web Service Call APIs to send and receive data to and from Health Rules Payor system
Collaborate with the Business Team to interpret inter-dependencies with system technical requirements that directly impact configured business rule requirements
Define technical business project scope and documentation by defining and analyzing requirements written and discussed to develop technical solutions
Follows the Agile methodology and interprets technical test cases as user technical stories from business engagement in deep dive and discovery sessions with clients.
Champion efforts to establish technical standards in application roadmaps to ensure consistency within the companies systems architecture portfolio.
Prepare and lead technical training sessions to support new and emerging technical design changes outlined in technical user stories.
Design and execute unit, system and integration test plans for new developments/releases/reports.
Knowledge transfer with other workforce and team members to improve overall team education to support ongoing system growth and adapt to changes in business strategies.

Health Economics & Informatics Systems Manager

Responsible for evaluating requests for system modifications, defining user requirements, estimating impact on current operations, and recommending plan of action for development and installation of enterprise application upgrades and/or migration for SQL Server suite of products (SSIS, SSRS, SSMS).
Develop and manage SQL scripts, test data, business requirements, and server resources to optimize system performance.
Designed, documented and maintained clinical data warehouse/data store hybrid using SSIS and SQL Server Agent to automate refresh process to capture clinical operational data and claims data from Health Rules Care Manager for FIDA members and Altruista Health Guiding Care (non FIDA members) and claims data from Health Rules Payor.

Application Architect

Provided oversight and guidance on all tasks and projects relating to architecting application solutions while developing and implementing all changes or additions to the organization’s application portfolio using SQL Server Management Studios, SQL Server Integration Services and VBA.
Developed and managed the technical ETL’s between the organizations internal Clinical Case Management system, (Altruista Health Care Manager and Health Rules Care Manager) and Health Rules Payor system and/or externally hosted systems with SSIS.
Collaborated with internal clients to identify needs and evaluate alternative business solutions and strategies.
Communicated complex system requirements to business units for sign off and delivery of solution specifications to technical teams.

Senior Systems Administrator

Successfully developed a reporting infrastructure for the Clinical Operations Department with Crystal Reports and JeffNet.
Created a software solution permitting users to capture Gaps in Care for Quality control and improved star ratings for the Quality Management Department by developing a solution using MS Access VBA with a back-end interface to a SQL Server using SQL Server Integration Services and automated on a schedule using SQL Server Agent.
Conducted technical research and development to enable continuing innovation within the Clinical Operations Department’s infrastructure.
Investigated and analyzed feasibility of system requirements and developed system specifications.
Supervised staff including hiring, training, evaluating and disciplining. Guided and provided work direction for technical staff, contract staff and/or student employees.
Identified methods/solutions and provided project leadership and management to provide a high level of service to business units.
Conducted the migration from SQL Server 2005 to SQL Server 2008 R2 to meet the vendor software system requirements.

Systems Administrator

Successfully launched the Clinical Case Management System C.C.M.S. with minimal resources on target.
Executed and planned configuration, maintenance and system support for all UM/QM database activity.
Develop, maintain and revise database requirements for effective UM/QM reporting and oversight requirements by maintaining SQL Stored Procedures, SQL Server Data Transformation Services and Crystal Reports UI development.
Provided technical support, ongoing maintenance and enhancement of all applicable software programs for the Medical Management/Quality Management Department.
Assisted with data and technical support for all required reporting and system activities for UM and/or QM Departments.
Conducted the migration from SQL Server 2k to SQL Server 2005 to meet the vendor software system requirements.