Stanley Garrett Email & Phone Number

30 Corporate Drive, Burlington Ma 01803

Schaumburg, Illinois

1. 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 2. 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.3. 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. 4. Collaborate with the Business Team to interpret inter-dependencies with system technical requirements that directly impact configured business rule requirements.5. Design and execute unit, system, and integration test plans for new developments/releases/reports.6. Facilitate root cause analysis on unexpected system outcomes to improve system dependability and improve system stabilization.6. Facilitate and execute data cleansing of the systems Oracle OLTP to ensure data integrity before moving from TEST to PRE-PROD and PROD environments.

Illinois, United States

1. Define technical business project scope and documentation by defining and analyzing requirements written and discussed to develop technical solutions 2. Execute planning using Agile methodology and interprets technical test cases as user technical stories from business engagement in deep dive and discovery sessions with clients.3. Champion efforts to establish technical standards in application roadmaps to ensure consistency within the company's system architecture portfolio. 4. Prepare and lead technical training sessions to support new and emerging technical design changes outlined in technical user stories. 5. Design and execute unit, system, and integration test plans for new developments/releases/reports.6. Knowledge transfer with other workforce and team members to improve overall team education to support ongoing system growth to adapt to changes in business strategies

Brooklyn, New York

6323 7Th Avenue 3Rd Floor, Brooklyn New York 11220

Capture and evaluate system/application modification requests from business owners for practicality and project scope. Estimate overall business impact on current operations and recommend a plan of action for the development and installation of enterprise application upgrades or migration. Hands-on SQL Server Integration Services solution development to achieve bi-directional data imports and extracts. Develop system back end export and import data feeds using Microsoft SQL Server 2008 R2, SQL Server 2012 stored procedures, Microsoft SQL Server Integration Services, and SQL Server Agent jobs to ensure consistent load routines. Document all system developed solutions with versioning of clinical data warehouse/datastore using Microsoft Word to capture upgrade and modification history. Hands-on development of automated daily data transformation routines using SQL Server Integration Services, 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.Hands-on development of Clinical operation’s service authorizations, case management, and clinical criteria reports using SQL Server Reporting Services or Crystal Reports. Develop GUI using JeffNet Reports and Crystal Reports for back end report delivery. Guided and tracked report development progress of staff in report development projects to meet stakeholder requirements.Conduct staff evaluations quarterly for yearly submission.

745 64Th Steet, Brooklyn New York 11220

 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.

745 64Th Street

 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 2k to SQL Server 2005 to meet the vendor software system requirements.

745 64Th Street, Brooklyn New York 11220

 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.

Education record

Business Administration

Business Administration

Business Administration