Quality Assurance Technical Support
Resume:
Darwin Meredith
Wilmington, DE 19808
******.********@*****.***
302-***-**** (Home)
302-***-**** (Cell)
PROFILE: Currently offering skills as a Quality Assurance and SQL Analyst with an extensive background in program development, testing, implementation, troubleshooting, and analysis of business systems.
Proven experience with a wide variety of enterprise environments, including; medical insurance, distribution, finance and credit card systems
Strong internal customer interface record to address program, troubleshooting and end-user training needs
Worked with users to create technical documents to create new code for software programs for developers
TECHNOLOGY:
Languages: VB.NET, RPGIII, RPGIV, RPGILE, RPG400, CL, JAVA, C#, UNIX, COBOL/400
Hardware: AS400, IBM PC’s, SQL Server
Software: Lotus Notes, MS Office (Word, Access, Excel), SQL, Query/400, PDM, SEU, DFU, DDS, DBU, SDA, RLU, ISDB, DB2, DBG, Abstract/Probe (Aplus), TurnOver, Windows 2000, XP, RDA, HTML, Websphere, Infinium, Stratton Warren, Visio, Quality Center (9.2 & 10.0), CA Clarity PPM, QTP, PowerMHS, Planmate, SQL Developer, Hummingbird & UltraEdit, Claredi, CIS
PROFESSIONAL EXPERIENCE:
2004 - 2014 Consulting QA Analyst/Application Developer for CAI, CSS and RHT
CLIENT PROJECTS:
2013 – 2014 Depuy Synthes – (Companies of Johnson& Johnson)
Developer / Analyst West Chester, PA
Responsible for technical support in JDE World.
Tested, debugged and maintain complex RPG/JDE programs.
Wrote and used SQL queries to analyze current defects in the system.
Created reports using SQL for various departments.
Created technical requirements from user and created new or updated existing programs
2009 – 2013 Independence Blue Cross of Philadelphia
QA Analyst Newark, Delaware
Responsible for providing testing and analytical support to CAI clients
Wrote SQL queries using SQL Developer on the Independence Blue Cross network.
Created technical requirements, evaluate them, work with developers to create or update a program.
Responsible to develop, maintain, and upgrade testing activities (Test Conditions, Test Scenarios, Test Scripts and Test Cycles) in Quality Center for Independence Blue Cross client.
Worked with Quality Center (9.2 & 10.0) and CA Clarity PPM.(Project Portfolio Management software package)
Performed Manual Testing using Quality Center (QC)
Wrote SQL queries to test or verify various conditions on Independence Blue Cross programs.
Performed Manual Testing using User Acceptance Testing (UAT). Interacted with users and modifying the test cases accordingly to test the new features developed in the application as per the user requirements as part of (UAT).
Used DB2 for data manipulation on the mainframe of Independence Blue Cross.
Tested HTML, C#, .NET And JAVA programs
Created UNIX shell scripts and updated the scripts as per the requirement.
Supported all the UNIX requests for various applications.
Documented and tracked defects timely and accurately in Quality Center
Used PowerMHS and Planmate to modify and test medical claims
Implemented industry Quality Assurance methods
Developed test strategies for assigned projects
Defined and executed test plans (testing modifications, analyzing and verifying results) accurately and in a timely manner.
Read and understood Business requirements, User Cases, Scope Documents and Technical Specifications.
Followed up, resolve and escalated open issues in a timely and appropriate manner
Produced output that meets the expected standards for Quality, thoroughness, timeliness and neatness.
Worked with HIPAA EDI Transactions including 834, 837, 835, 276, 277, 270 and 271. Tested (Professional & Institutional) Claims and performed basic testing, functional, and regression testing and tested generation of 834’s and 835’s for 837 transactions. Also tested 270, 271 and 276, 277 transactions.
Used Excel extensively and used macros and formulas.
Used QTP for automated testing
Ran SQL Queries to identify healthcare subscriber information.
Used Hummingbird to FTP files and used UltraEdit to compare files
Worked and tested with all Microsoft Windows operating systems and Microsoft Internet Explorer
Worked on HIPAA medical claim processing projects
-3-
2006 – 2009 WL Gore - Maryland
System Support Analyst/Developer Newark, Delaware
Took over the support roles from the current WL Gore IT staff. Responsible for assuming the technical support roles for the AR, AP, MRP, Sales and Purchasing in JDE World.
Created many complex SQL queries that would update or delete records in production environment.
Managed through daily support questions from hundreds of business users.
Used SQL queries to investigate problems or to test various conditions with certain records involving many files.
Monitored the EDI mailbox for errors and make the necessary corrections. Analyzed and corrected many EDI errors in purchase orders and invoices.
Responsible for the environmental refreshes at WL Gore. Modified and executed CL and RPG programs to copy records from the production environment to different test environments in a monthly basis.
Supported all the UNIX requests for various applications.
Used client access to upload records to the AS/400. Would be verify records and check for duplicates. Used SQL to insert or update records in physical files.
Created reports using SQL for different users and departments.
Tested, debugged and maintain complex RPG/JDE programs.
2004 – 2005 Delaware Park
AS/400 Programmer/SQL Analyst. Newark, Delaware
Worked on assignments as a contractor at Delaware Park in Wilmington. Wrote, tested, debugged and maintain complex RPGILE and CL programs.
Worked with Infinium on the AS/400.
Created SQL queries to investigate data in the Infinium databases.
Created new custom VB.Net programs that used Infinium programs and files.
Created in Infinium human resources programs using VB.Net. Also maintained existing Infinium programs.
Developed UNIX scripts for inbound and outbound of the data on servers.
Provided user support and trouble shooting for all Infinium systems.
Worked with Stratton Warren and sent records creating client access programs to send to a LAN server.
Created custom inventory programs and reports from Stratton Warren for the restaurants at Delaware Park.
Provided technical expertise in the installation of Infinium HR/Payroll Updates.
Used Excel extensively and wrote macros and used formulas
Used complex SQL queries to maintain records from Infinium databases.
-4-
2002 – 2004 Quaker City Motor Parts Middletown, Delaware
Senior Programmer / Analyst
Developed, designed and implemented business application for sales, finance and human resources. Analyzed systems requirements for computer application, wrote solution programs, documented development methods; tested, corrected and revised programs. Wrote, tested, debugged and maintained complex RPGILE programs. Performed daily AS/400 operations, which included scheduling jobs, backups, answering messages, etc.
Converted existing 5250 interfaces to Web interfaces using IBM WebSphere Development Studio Client, HTML, JavaScript, and Jpegs.
Designed, analyzed, and tested applications for RADS/Real D time Automated Development Series project to create RPGILE programs for primary use by warehouse staff in scanning barcodes with fewer errors and increased production. Created RPG IV, RPGILE and CL programs and modified existing RPG and RPGILE programs to complete project.
Wrote RPGILE programs that used embedded SQL in them.
Utilized SQL to create advanced queries and to test various conditions to distinguish data.
1995 – 2002 Applied Card Systems Wilmington, Delaware
Senior Programmer / Analyst
Designed, analyzed, programmed, and tested applications for credit card processing, which included developing and maintaining systems to enhance payment history, cardholder maintenance, credit line range maintenance, and transmission processing reconciliation programs on the AS/400. TurnOver was used to compile and move programs and keeping track of the source and objects of the programs
.
Designed JAVA programs that utilized vital statistic from an AS/400 database to retrieve telephone numbers from various web site sources. Created batch JAVA programs and JAVA programs that utilized HTML and JAVA servlets.
Created reports using SQL for different users and departments.
Created CL programs that scheduled and executed the copying and processing of records between two AS/400s, used menus that would interact with RPG, Cobol or
other CL programs and return to the source menu, and utility programs that manipulated dates.
Developed RPG IV and RPGILE programs that sent emails to individuals if a process
Did reporting with SAS and computed and analyzed financial data with SAS
Created queries using Query/400 that produced reports and gathered records.
Utilized SQL to create advanced queries and to test various conditions to distinguish data.
-5-
EDUCATION:
CAI - VERICENTER UNIVERSITY Newark, Delaware
Certificate of Achievement for QA Analyst
A graduate of CAI Vericenter University, a comprehensive quality assurance and testing course that provides intensive training in test planning, test design, test implementation, test execution, and defect tracking.
THE CHUBB INSTITUTE Springfield, Pennsylvania
Diploma in Computer Programming
DELAWARE TECHNICAL & COMMUNITY COLLEGE Wilmington, Delaware
Took various computer courses at Del Tech
UNIVERSITY OF NEW MEXICO Las Vegas, New Mexico
Bachelor of Arts Degree in Anthropology
Master of Arts Degree in History
Contact this candidate