Candidates About

Eric J. Zettlemoyer

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.

Experience

NextGen Healthcare, Horsham, PA                                                                       Dec 2013 – Present
Senior Engineer QA & EHR-Orders team lead and Scrum Master.
Write and execute test plans and scripts using HP Quality Center (QC), SQL-Server, Excel, and Word for an extremely large Electronic Health Record (EHR) product line in a very large, relational database environment over multiple product versions, in a SCRUM-agile environment.

·         Serve as the Scrum Master and 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.

·         Completed projects over the past year that include: Several vaccine group projects (Zoster, MCV-B, HPV, DTaP, Influenza, and Hep A/B), CPT & ICD Update Utilities, Vaccine Group Status (CDC-based) Rule integration, KBM patient workflows (entry through billing), and NIST TCP/IP registry connectivity testing.

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

Sabbatical:  Family International Travel and Home Projects (see LinkedIn for project details)   2011 – 2013

Comcast, Philadelphia, PA  (3-month contract extended to 7 months until work decreased)      2010 - 2011

Senior Analyst – Strategic Planning & Delivery Effectiveness (SPDE) team

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.

LSSiDATA (formerly DataServ), a division of Volt Information Services, Blue Bell, PA               2004 - 2009

   Director of Database Services  October ’05 – June ‘09

   Led data team through data and database enhancements for 180M⁽⁺⁾ record database on Windows 2003-based SQL Server systems in a PolyServe-clustered SAN environment for a diversified information services business.

• 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 – (LSSiDATA) Data Team  July ’04 – October ’05  (Promoted to Director in October ‘05)

   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.

DVFS (Delaware Valley Financial Services), Berwyn, PA                                                         2003 – 2004

Sr. Analyst – Quality Assurance

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.

Merck & Co., Inc., West Point, PA                                                                                     1999 – 2002

Sr. Systems Analyst – Quality Assurance

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 PL/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.

PDS (Personnel Data Systems), Blue Bell, PA                                                                         1998 – 1999

Business Analyst – Quality Assurance

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.

ITS (Innovative Tech Systems, Inc.), Warminster, PA                                                              1994 - 1998

Manager - Quality Assurance

Implemented certification procedures for comprehensive quality assurance of SPAN-FM^tm 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.

Education

MBA (Finance)                                                                          St. Joseph's University, Philadelphia, PA

BS (Architectural Design)                                                                  Drexel University, Philadelphia, PA

Computer Proficiencies

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

Query & Report tools:  Transact-SQL for SQL Server, Oracle PL/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-Microsoft software packages.

Certifications/Awards/Honors

·         Six Sigma Lean Black Belt Certified (LBBP), MSI license 12017376

·         Agile Project Management Fundamentals (APMF), MSI license 14349393

·         Six Sigma Green Belt Certified (SSGBC), MSI license 11146824

·         Certified Kaizen Facilitator (CKF), MSI license 11327568

·         5S Concept Certified (5SC), MSI license 11462568

·         Project Management Qualified (PMQ), MSI license 11521399

·        Project Management Essentials Certified (PMEC), MSI license 11498550

·         NextGen awarded, Nov., '14, bonus’s in recognition of QA contributions within the Order Module and Immunization (vaccine) processing.

·         Promoted to Director at LSSiDATA after 1-1/2 years’ service as Data Analyst; and received performance-based salary increases and management bonuses.

·         Awarded performance bonus after 3-1/2 months at DVFS.

·         Awarded “Merck Award for Excellence” for “GenCord” CM 2.0 Rel (LTC) accomplishments.

·         Recipient of Merck Award for creation of MS-Access reports for software defects.