SUMMARY:

Highly successful, quality - driven IT Analyst with expertise in data analysis and management, process design and implementation, and a myriad of software. In excess of 20 years of experience in analytical through supervisory roles in various Data and QA areas. Recipient of numerous awards, promotions, and bonuses for outstanding Analytic, QA and Business Intelligence (BI) contributions. Combines strong analytical abilities with excellent communication skills. Drives use of available leading-edge technology to support material enhancements for internal and external customer satisfaction, and management of products and/or service quality toward optimal ROI. Provides flexibility to suit company needs across Development, Marketing, Finance, Quality Assurance, Operations, and Data Services. Provides quality (QA) services to, and is an integral part of the Development team.

COMPUTER PROFICIENCIES:

Microsoft: Windows XP/Vista/7-10 & Server 2012 administration, Office 2013.

Query & Report tools: Transact-SQL for SQL Server, Oracle PS/SQL, DB2 SQL, and Quality Center (QC) to track all requirements and defects through final product implementation.

Other: Expertise with PC hardware and networking, as well as with many non-Microsoftsoftware packages such as Linux OSs and applications along with basic Unix command language.

EXPERIENCE:

Confidential, Horsham, PA

Senior Engineer QA & EHR-Orders team lead

Responsibilities:

• Serve as the SME for the Order Module team to help assure that they deliver a high-quality, “best in breed” product from one version release to the next.
• Provide project (QA) estimates, Test Case and results documentation, requirement review and feedback to BAs, metric and analytic reporting, and more as the QA “EHR-Orders” team lead. EHR-Orders is comprised of Laboratory, Radiology, and Immunization ordering from initial diagnosis through test results, drug administration, and patient history Registry reconciliation.
• Recent projects completed include: Vaccine Group (CDC-based) Recommendation integration, Immunization “Dose Validity”, ICD-9 to ICD-10 conversions, ICD & CPT Update Utilities, Bi-Directional Registry, PAQ-DM Linking to orders, Confidential Lab Delegate permissions, and VIS-barcode.
• Test and monitor clinical data compendium import (OLTP) processes prior to customer delivery, and contribute toward process enhancement as well as resolve data-driven errors and identify workarounds to programmatic defects.
• Utilize QC testing software on a daily basis to track and assure new Business Requirement definition, comprehensive test planning, and defect identification/logging through resolution.
• Provide all necessary QA analytic services independently supporting a very diverse team of Developers, as well as provide data metrics and analytic research as a back-up to the customer service group.
• Utilize Cruise-control source-code tracking software to maintain up-to-date multiple QA environment files, receive and check new SQL and/or Stored procedures.

Confidential, Philadelphia, PA

Senior Analyst

Responsibilities:

• Analyzed data for accuracy, appropriateness, clean-up & enhancement strategies, and implemented data QA activities for a cable/telecommunications/entertainment company.
• Designed, scripted, and ran PL/SQL (for Oracle) for data corrections and related metric gathering and reporting, as well as for customer data issue/ticket research and resolution. Created and implemented repeatable diagnostic and QA checks supporting all related data changes.
• Created Access 2010 database to track and report on all service, billing, and product code data supporting major remapping of vendor billing codes. Provided thorough reporting on data analysis and exceptions and provided metrics in executive summaries with formal recommendations.

Confidential, Blue Bell, PA

Director of Database Services

Responsibilities:

• Responsible for all data management activities, including system hardware and software determination through implementation of a superior, live 24/7 “Genesis” database system for over 3 years.
• Responsible for identifying enhancement opportunities, defining system process advancements, and project plans, as well as leading projects through post implementation activities and ongoing database validations. Played a pivotal role in strategic and operational improvements, such as investigating and reporting on recommendations for potential additional revenue-generating data sources.
• Determined database structure, data classifications, and quality documentation standards for implementation, and provided basic internal DBA-level services while managing data management analysts and developers to assure compliance to internal and external requirements while optimizing data output.
• Hired, trained, and supervised Data Team staff members toward achievement of departmental / divisional objectives. Conducted performance reviews, provided mentoring, and determined rewards and/or improvement plans for staff.
• Managed all database quality assurance (QA) efforts and QA initiatives for all software, data metric gathering, and statistical reporting, while serving as sole contact for management reporting requests.
• Responsible for delivering quality databases and daily transaction updates to customers, including support specialist duties as back-up to Customer and Account Management and Operations teams.
• Coordinated data sets with internal sales and marketing to promote company data product and service offerings, including competitive and customer data analyses and enhancements.

Data Analyst

Confidential

Responsibilities:

• Analyzed data for clean-up and enhancement strategies, as well as performed all software QA activities.
• Designed, scripted, and ran SQL for metric gathering and reporting and presentations, as well as provided thorough analysis reporting, including Executive Summaries and formal recommendations.
• Created standards for the documentation of subject area test planning and results in a waterfall environment, significantly shortening development time.

Confidential, Berwyn, PA

Sr. Analyst - Quality Assurance

Responsibilities:

• Tested new Windows software technology, and tested legacy system software for a financial services company.
• Reviewed Business requirements, analyzed software, created test scripts, provided complete documentation identified issues, and completed thorough testing for various projects involving areas such as:
• State-specific insurance data processing of Commutation Fee calculations.
• Client-specific insurance data processing for Preferred Settlement Valuations.

Confidential, West Point, PA

Sr. Systems Analyst - Quality Assurance

Responsibilities:

• Scripted and executed comprehensive test plans for pharmaceutical pricing and contract management software, from Business Requirements and Specifications in accordance with Software Life Cycle processes over multiple product releases for a leading pharmaceutical company.
• Performed integration and system testing, and logged defects and enhancements from business logic through GUI issues.
• Followed up through regression testing, documentation, and closing of outstanding issues.
• Conducted extensive testing of OLTP and DSS functionality using Oracle SQL and Business Objects.
• Created documentation standards for subject area test planning and results: Shortened development.
• Implemented custom MS-Access defect tracking database reports via links to Rational 7.5 ClearQuest.
• Improved “expected results” processing by comparative testing of rebate and discount calculations.

Confidential, Blue Bell, PA

Business Analyst - Quality Assurance

Responsibilities:

• Served as Certification Lead for Centura-based Vista 1.5.1 and 2.0 human resource management software, competitive software to PeopleSoft.
• Analyzed software, created test scripts, and reviewed all documentation for refinement.
• Led new Quality Assurance (QA) projects for ADP integration and Compensation modules.
• Created procedures for database table relationship and data integrity analysis as part of QA system testing
• Established higher-quality, more in-depth testing processes in an agile environment.

Confidential, Warminster, PA

Manager - Quality Assurance

Responsibilities:

• Implemented certification procedures for comprehensive quality assurance of SPAN-FMtm facilities management software.
• Identified program goals involving business logic, data integrity, and security measures, as well as implemented standards for visual appearance, and provided additional industry-specific knowledge for program development and inclusion in documentation.
• Reviewed and updated user guide and installation materials for comprehensive refinement.
• Created, implemented, and maintained an MS-Access relational database for tracking, reporting, and coordinating program “bugs” (software defects), customer requests, and enhancements in an agile environment.
• Monitored program development progress with computerized, statistical methods and reviewed results and improvements with programming staff and senior executives for domestic and international /overseas concerns.
• Coordinated program developments with project management team, providing up-to-date status on any customer-requested program enhancements and assisting with client communication.