We provide IT Staff Augmentation Services!

Business System Analyst / Quality Assurance Liaison / Database Analyst Resume

5.00/5 (Submit Your Rating)

PROFESSIONAL SUMMARY:

  • 35 years experience IT Mainframe and Client/Server environments, which includes 9 years as Independent/Salaried contractor and employee to Financial Institutions, Defense Agencies, Healthcare (Provider), and local government and Business owner, 3 years in Transportation, 1 year of Retail, and 1 year of Manufacturing and 13 years in Telecommunications.
  • Extensive IT background in program, systems and business analysis, Software Quality and Controls, SDLC and Testing methodologies, Project Management, Database Management and Administration.
  • Experiences include process and program analysis, technical and end - user support resulting in efficient and expeditious resolutions.
  • Proficient in the use of management software (Microsoft Suite - Access, Excel, FrontPage, Outlook, NetMeeting/NetConferencing, PowerPoint, Project, Schedule +).
  • 28 years DB2 database design, development, administration and support under high volume transaction processing using ANSI SQL, SPUFI, QMF
  • 7 years ORACLE database (8i/9i/11) programming using PL/SQL
  • 14 years IMS/DB (Batch, On-Line, Administration duties)
  • 22 years of System and User Requirements gathering (Business analysis and Assessments) and JAD facilitation and participation
  • 20 years IT project (MS Project, Word, and VISIO) and technical management
  • 17 years Implementation planning
  • 17 years test plan creation and QA (Quality Center)
  • 17 years Batch Scheduling software (CA-7, ESP)
  • 14 years Process Improvement
  • 7 years EDI (Electronic Data Interchange - AS2 messaging format)
  • 35 years application development, system analysis and coding
  • 10 years file Encryption (PGP, WinZip, PGPZip)
  • 35 years IT mainframe and PC and client/server environments
  • 15 years UNIX (file transfer, scripting, data manipulation)
  • 10 years Data Mapping and GAP Analysis
  • 5 years (HP) Quality Test Professional
  • Highly proficient in written (status reporting to upper level management) and oral (presentations) communications.

PROFESSIONAL EXPERIENCE:

Confidential

Business System Analyst / Quality Assurance Liaison / Database Analyst

Responsibilities:

  • As a Business Database/Business Systems Analyst, I am providing AGILE/SCRUM development, systems analysis, systems process improvement and technical support to the Confidential ’s Administration in the processing of Web based EDI transactions against DB2, Oracle and SQL Server databases.
  • I am responsible as a BSA/DBA for developing and maintaining applications in JAVA, Python, Ruby, PL/SQL and IReport as well as troubleshooting production issues with EDI transactions (batch Mainframe, LINUX Server and Internet based).
  • I am also responsible for writing PL/SQL and MS/SQL Server scripts and complex queries.
  • I have also been tasked to lead the ICD-10 upgrade initiative as a Lead Systems Business Analyst/Quality Assurance liaison. Coding is done in PL/SQL and JAVA using MS-SQL Server and Oracle databases with Talend as the ETL using Web Based (JAVA) applications as front-end.
  • Additionally I troubleshoot, provide production support for EDI (Health care) transactions including 270, 271, 276, 277, 835, 837, 999 transaction sets, develop and maintain JAVA Oracle applications and SFTP to VA’s Mainframe (region specific), provide daily Production support monitoring and troubleshooting (daily claims batch load process), develop and maintain Python Oracle applications, develop and maintain DOS and Unix scripts, develop and maintain iReport Reports, write custom queries as per customer interview request in SQL, develop and maintain PL/SQL packages.

Confidential, Denver CO

Systems Analyst/Business Analyst/Quality Analyst (Team Lead)

Responsibilities:

  • Employed to perform Business / Infrastructure / Integration Analysis and Quality Assurance for Confidential ’s Product machine and Front End JAVA/Eclipse software (EDI 270, 271, 276, 277, 837 (I/P), 999 transaction sets) as configured for business clients in healthcare (State Exchanges for the Affordable Care Act).
  • Additional duties include assistance with and construction of user Acceptance testing plans, QA test plans, Server integration and sizing assistance, Rules generation on Product Machine, Use case construction and review, Test case (manual and Automated System and User) construction, review and execution.
  • Daily duties include, but are not limited to:
  • Lead and participate in BA/QA daily standup (SCRUM) calls; 2 - 3 week sprint delivery cycles; Interacting closely with business customers project Management and technical peers in the system analysis process and develop technical requirements for Use cases; Developing and documenting testing standards, best practices and ensures they are communicated and applied accordingly; Defining and documenting test plans for new and existing applications with large-sized, diverse scope and increased complexity;
  • Manually create and input test data and uses tools, programs or extracted production data to execute test cases; Participating at requirements (Use Case) reviews, design reviews, system analysis (SOAP/UI, XML, WebServices, Front-end software) and facilitating the testing review process.
  • May on occasion lead the requirements or design effort as they relate to testing; Evaluating risks associated with test plans and makes recommendations for alternative testing approaches; Reviewing test plans, test cases and test scripts of other team members; Providing coaching and feedback to junior level Quality Assurance Analysts;
  • Modifying test plans in accordance with changing requirements (Change Requirements); Determining if manual and/or automated test tools should be used to execute test cases and uses automated test tools to execute the testing process. Creates automated test scripts and shares with others.
  • Will make recommendations and/or implements additional automated test tool opportunities within area;
  • Supporting improvements in overall quality results through the use of statistical measurements and available tools;
  • Executing test quality assurance responsibilities and associated functions for projects (requirements, risk assessment, staff time estimating, test approach, reviews, overall organization and coordination of testing activities, analyst support, usability, etc.);
  • Defect Management (JIRA) script creation.

Confidential, Tampa, Fl

Systems Analyst/Business Analyst

Responsibilities:

  • Contracted to perform business requirement gathering for ICD-10 conversions, while identifying and translating business processes into high level requirements.
  • Constructed BPM (business process models) to assist in the streamlining of clients’ re-engineering effort.

Confidential, Colorado Springs, CO

Sr. Systems Analyst/Business Analyst

Responsibilities:

  • Lead Team member for the Business Analysis/design, Gap Analysis and recommendation of process improvement to infrastructure and the business for Healthcare industry for major payers and subscribers as the industry migrates from EDI (Electronic Data Interchange) version 4010 to version 5010 (transactions HL7, 270, 271, 276, 277, 278A, R, N in real-time (cURL), 837 (Institutional, Professional and Dental) claims) and Batch (HTTPS, UI) in a SaaS environment.
  • Developed Business Requirements Document (BRD) and Functional specification documents (Agile User Stories using Rally software) for the preliminary initiative for Confidential and Confidential ’s server infrastructure.
  • This includes the integration of Websphere with TXM (Transaction Manager) for HL7.
  • Agile sprint cycles would run typically 2 weeks; however there were instances where the cycle would be three weeks.

System/Application Environment: USE Case development, Mercury Quality Center, PlanView, Sharepoint, Clear Quest, TCP/IP, File Encryption (PGP), UNIX Shell/PERL/cURL scripting, SFTP, Connect Direct, JAVA, XML, BEA WebServices, APIs (C++, JAVA), Agile and SCRUM Methodologies.

Confidential, Colorado Springs, CO

Appl. Dev. Sr. Systems Analyst/Programmer

Responsibilities:

  • Technical Team leader for the Business Analysis/design, development and recommendation of process improvement to infrastructure, business process and creation of multiple LPAR environments (development of Technical Specifications from user requirements) in regards to the industry and executive leveled directives as they pertain to the Fraud Systems Development of High Toll application.
  • The High Toll system is a tool used by the Confidential to augment visibility to subscription fraud and bad debt.
  • The system reduces the financial exposure that can occur between real-time fraud detection and credit/collection processing.
  • High Toll System accumulates network usage over a 30-day period to identify trends and escalation of calling patterns.
  • Various algorithms that predict fraud and potential non-payment situations are applied to the data to identify high risk.

System/Application Environment: COBOL II, Oracle Gateway, DB2 (SPUFI/QMF), TSO/ISPF, JCL, CICS (TS 2.2), USE Case development, Mercury Quality Center, PlanView, Sharepoint, Clear Quest, FileAid (VSAM, DB2), InSync for DB2 & VSAM, TraceMaster for CICS, MQ Series, ESP batch scheduler, Expediter, Release Management (ClearCase SCM, Endevor) Change Management (ChangeMan, InfoMan, Rational ClearQuest), TCP/IP, File Encryption, UNIX Shell/PERL scripting, SFTP, Connect:Direct, JAVA, XML, BEA WebServices, dotNet framework, APIs (C++, JAVA).

Confidential, Columbia, South Carolina

Appl. Dev. Sr. Systems Analyst (Business Systems Analyst)

Responsibilities:

  • Senior Technical Team member for the development of analysis documents from requirements, detailed design from analysis document and recommendation of process improvement via context diagrams, data flows, and entity relationships in regards to the industry and executive leveled directives as they pertain to the Financial system for Electronic payment and eligibility system under Membership enrollments (834) and payments.
  • Confidential is written in APS COBOL and uses a DB2 relational database that collects and processes EDI financial transactions for all lines of business via secured event driven transaction processing (triggered by NPI (837 e-claim filing) segment CLM and optional/conditional segments NM1).
  • The Confidential system maintains all accounting activity and eligibility of members for Confidential commercial business.
  • Payments are applied to accounts receivable and balances are adjusted. Reports and general ledger entries are created for all activity.
  • Confidential is the Membership Enrollment/Eligibility Financial Information Processing System that displays all bills, payments and financial transactions (XML parsing) with real time or near time processing. This system offers many advantages that include the ability to: view electronic payments online (835 outbound e-remittance advice) and apply money view invoices (PO’s) by transaction codes and descriptions (XML translation from EDI) view cash suspense items and apply payments from the same screen stop bank drafts from processing (ACH/820) process refunds more efficiently utilizing GUI screens (EFT)

System/Application Environment: APS Cobol (Micro Focus Mainframe Express ver. 3.0.75), ASDD-Citrix, COBOL II, DB2 (SPUFI/QMF), DL/1, IMS DB, TSO/ISPF, JCL, USE Case development, APS CICS (TS 2.2), XML, EDI (4010, 5010), EDIINT AS2, COMPAREX, SAS, FOCUS, Zeke/Zebb, Smart Test, Max VSAM, MQ Series, ChangeMan, Rational ClearQuest, PlanView, Rational ClearCase, Mercury Quality Center, TCP/IP, Visual Basic, Adobe DreamWeaver, MS Access, UNIX Shell/PERL scripting, APIs.

Confidential, Englewood, CO

Sr. Programmer/Analyst(Sr. Q/A specialist)

Responsibilities:

  • Senior Technical Team member responsible for the analysis and recommendation of process improvement to source code in regards to the industry and executive leveled directives as they pertain to the Mutual Fund Trading.

System/Application Environment: COBOL II, DB2 (SPUFI/QMF), CA-DataCom (DB), DL/1, IMS DB, TSO/ISPF, JCL, CICS (TS 2.2), COMPAREX, SAS, FOCUS, DataSlicer (Softbase), CA-7, ESP batch scheduler, Expediter, ChangeMan, PlanView, Rational ClearQuest, Rational ClearCase, Mercury Quality Center, Sharepoint, TCP/IP, Visual Basic, MS Access, UNIX Shell/PERL scripting, APIs.

We'd love your feedback!