We provide IT Staff Augmentation Services!

Lead Business Systems Analyst Resume

5.00/5 (Submit Your Rating)

Mechanicsburg, PA

SUMMARY

  • Information Technology professional with over twenty five years of experience in Banking, Mortgage Banking, Pharmaceuticals, Publishing, Commercial Insurance and the Healthcare Industries.
  • Over twenty years of experience in Project Management; Business Systems Analysis; and Quality Assurance testing, both manually and automated; with areas of expertise in analysis, design, methods/cost control, planning, communications, organization, problem solving, consulting, and coordination of multi - tasks.

TECHNICAL SKILLS

Languages/Tools: Excel, Word, Power Point, Outlook, MS Project, Bar-coding, Visio, Release Management Software, Mercury Quality Center Test Director(now H-P Quality Center), Java, Visual Basic, .NET applications, Websphere, IBM Rational Requisite Pro and ClearQuest, Deloitte’s Comment Tracker and eRoom, Donegal’s Request Tracking and SDLC software using Microsoft access for tracking projects, Allenbrook Phoenix software for testing insurance policies, Allenbrook WriteBiz software customized for Donegal agents to prepare web based quotes, UltraEdit, SpecBuilder, Silk and Load Runner.

Databases: PEGA,SQL, DB2, Access, Oracle, UNIX

Applications: Web based, A/S 400, Mainframe, and Client Server Platforms

Telecommunications: TCP/IP, Token Ring, POP, ISDN SPIDS, LAN, WAN, IIS servers, Frame Relay, MPLS lines

PROFESSIONAL EXPERIENCE

Confidential, Mechanicsburg, PA

Lead Business Systems Analyst

Responsibilities:

  • Team member of the United Concordia Dental Division Information Technology team.
  • Interpreted and created Business Requirements and Functional Specifications for the Dental Systems.
  • As a skilled analyst, partnered with the project business owner(s) and all stakeholders to create, test, and implement the most efficient solution using the PEGA DB schematic.
  • Reviewed all identified updates that were requested to be changed by the Business owner(s) and ensured that the changes were cost effective in the overall scheme of the technology for the entire dental division.
  • All solutions that were created for the PEGA DB were reviewed with the team to ensure the most advantageous solution that would be most cost effective.
  • Lead work sessions for modifications and updates to the Requirements and Design sessions by providing guidance in the best solutions.
  • As part of the SDLC process, prepared and presented formal Power Point presentations, as needed, for the Business Owner(s) and senior management.
  • Maintained excellent working relationships with all Business Owner(s), stakeholders, senior managers, information technology(IT) staff, and peers for the dental division. This included the understanding of the dental business and how it related to other IT systems.
  • Managed all project with meeting the objectives, implementing quality software updates, and ensuring the performance of the software changes did not affect the performance of the overall systems.
  • Work with the developers to ensure the best solutions are developed from the requirements.
  • Interpret and create test scenarios and test scripts to be executed for all modifications and updates.
  • Provide mentoring to the staff for Quality Assurance and Business Systems Analysis.
  • Create Excel spreadsheets for analysis of data and the interpretation of the data for the Dental Systems.
  • Muti-Tasker as priorities change for the task focus to daily/weekly etc.
  • Create SQL queries to run against the Mainframe for data analysis.
  • All documentation for all projects was stored in Sharepoint as a central repository for the department. Ensured that the documentation was clear, complete, and concise as the final solution throughout the SDLC.
  • Provide testing expertise for the updates to the systems throughout the SDLC process. This included the test, pre-production and production environments.
  • Troubleshoot Production issues with the Development team as needed.
  • Provide weekly status reports for the IT management to communicate effectively with senior management..

Confidential, Portland, ME

Technical Analyst/Business Systems Analyst

Responsibilities:

  • Team member for the Infrastructure Currency Program for upgrading of bank wide servers in the United States and Canada. The current year - 2013 has approximately eleven (11) Business Units that will upgrade their servers to the Bank Standards.
  • Reviewed the process used for the TD Bank Check Free system that is proprietary by the vendor, Fiserv. Also reviewed the Check Inventory (IV) application from Fidelity Systems.
  • Reviewed the process used for the Credit Card Systems. These systems are proprietary by the vendor, TSYS. Reviewed the Customer Information File (CIF), Customer Information System (RM), Installment Credit (IR) and the Customer Statement (SC) applications from Fidelity Systems.
  • Reviewed servers that were slated for decommissioning and followed up on those servers to ensure they were decommissioned. Follow up with the respective Lines of Business for further analysis of the servers that were slated for decommissioning. Several of these have been found to be still active and had not been decommissioned.
  • Coordinated the testing effort needed by the eleven Lines of Business for the upgrading of the servers from the current servers to the future servers. Created and maintained an Excel spreadsheet with all necessary testing data including Test plans, scripts, schedules, servers, types of data, etc.
  • Prepared Weekly Status Reports for management.
  • Attended daily status meetings for check points of the Infrastructure Currency project.
  • Prepared numerous documents for the Infrastructure Currency project.
  • Ensured that the documentation required was clear, complete, and concise as final solutions throughout the SDLC.

Confidential, Radnor, PA

Systems Analyst

Responsibilities:

  • Member of the MGTI implementation team to convert data from in house to an off site location.
  • Reviewed the Benefit Plan systems for the testing approach needed to convert the data from Production .
  • Verified existing test scripts to be used for testing of data before and after the conversion.
  • Created test plans and test scripts as needed for the conversion of data for all environments including DEV, TEST, QA, STAGING, DR (Disaster Recovery), and PRODUCTION.
  • Coordinate all testing requirements for all environments.
  • Set up weekly meetings to review Quality Assurance plans for the UAT testing approach.
  • Set up daily meetings to review defects/bugs from testing.
  • Participate in the Requirements and Design sessions by providing guidance with a focus on Quality Assurance needs.
  • Review software packages for a repository for all Quality Assurance testing, scripts, execution, and defect tracking.
  • Muti-Tasker as priorities change for the task focus to daily/weekly etc.
  • Troubleshoot issues with the Development team as needed.

Confidential, Portland, ME

Senior Business Systems Analyst/Quality Assurance Analyst

Responsibilities:

  • Support the Merchants Services for Private Label Credit Cards. This includes maintaining their PROD, Test, Disaster Recovery and Development servers for Microsoft Patching, Expansion of Space, assist with new clients, Intermediate and Root Certificates, maintain vendor communications and ensuring their business is up on a 24/7 basis.
  • Tested existing software whenever updates were installed to ensure there were no issues for the clients.
  • Reviewed and tested the Installment Credit (IR) application from Fidelity Systems to ensure the process for Private Label Credit Cards was fully functioning.
  • Created and executed test scripts for the Consumer Credit Department software upgrade. This included the updates for the Advanced Loan System (ALS) from Fidelity Systems. Reported defects to the test team at the daily meetings. Completed and closed defects when development made changes to the software.
  • Coordinate all projects needed for the Merchant Services and ensure their needs are being met at all times.
  • Was part of a project team to install intrusion hardware in front of the PROD and Test Servers. This was a bank wide project that has been installed successfully.
  • Coordinated and led a project team to decommission approximately 20 servers. This included archiving, copying and ingesting the data into Filenet.
  • Led a project team to install an MPLS line from Chase PaymenTech to TD Bank in Canada for private label transactions. This also included POTS and ISDN SPIDS lines and the dial up back up connectivity.
  • Was part of a project team to install an MPLS line in TD Bank North and connected to TSYS, a vendor in Atlanta, GA.
  • Was part of a project team to implement a new pilot project for an ATM Personalization Project.
  • Reviewed and tested file transmissions received and sent to TSYS to consolidate lines. Interpreted data on Excel spreadsheets and updated findings for the team working on TSYS lines.
  • Reviewed a Credit Card department's access to a DXR server. Became familiar with the process to administer the server. Presented an updated process to the users for the copying of data received monthly on CD’s from the TSYS vendor.
  • Worked with the Credit Card team to set up a weekly/monthly status report in EXCEL to be sent to management for updates to the teams projects.
  • Attended and participated at the weekly status meetings for the Credit Card team and the Technology Solutions team.
  • Investigated, tested and implemented several web applications for the Credit Card department users. The web applications are being used for analytical data reviews of the credit card accounts.
  • Coordinated and led a project team of approximately 20 members, to complete a disaster recovery test for the Retail Card Services Group. The System DR Test was completed and approved by the Security Group. Communications were sent to all team members, RunBooks were completed, testing documentation was completed, and numerous other required documents.
  • Coordinated the monthly Microsoft Patching for the Retail Card Services Group for their Production, Disaster Recovery, Bat/Test and Development servers. Completed testing of the updates for the patching that was completed and installed monthly; specifically to the Production environment.
  • Coordinated updates and new code development for the Retail Card Services Group. Updates and new code was for new clients and existing ones. This included creating the Change Control and presenting them to the Change Control Review Board.
  • Coordinated and led monthly meetings for Retail Card Services Group for all of their current and any future initiatives.
  • All documentation for all projects was stored in Sharepoint as a central repository for the department.
  • Maintained tables with server information for expiration of SSL Certificates and Thwarte Certificates. Worked with Operations to renew the certificates and to get them installed.
  • Set up a monthly schedule to move daily audit files from the servers to archived sites for the Retail Card Services Group.
  • Created a weekly process to copy a Sanitized production copy of data to be moved to the Lower Environments for the Retail Card Services Group to use as a test bed for existing and new clients.

Confidential, Plymouth Meeting, PA

Systems Analyst for Great West Integration

Responsibilities:

  • Interpreted Business Requirements and Functional Specifications for the Great West project. Applications that were tested were for imaging functions, marketing and client repositories. Back up applications were tested in response to Disaster Recovery.
  • Created test scripts for the Great West project for Fairfax, MailRx, Magellan/Aspect Dialing and Operation Readiness applications.
  • Performed UAT (user acceptance testing) testing on FairFax, MailRx, Magellan/Aspect Dialing and Operation Readiness applications.
  • Coordinated and attended daily defect/fault meetings with internal and external clients to review such defects for disposition.
  • Executed test scripts within numerous environments including PROD, Test, and UAT.
  • Maintained all testing documents in a shared repository for easy access by the QA Team.
  • Used 2.0 .NET technology for the Web based product.
  • Worked with Mercury Quality Center (now H-P Quality Center) to set up requirements, test plans, designs and scripts for execution.
  • Interpreted Business Requirements and Functional Specifications for the PCI projects.
  • Coordinated UAT testing teams for the implementation of the FairFax application and FairFax Reporting projects.

Confidential, Cherry Hill, NJ

UAT Tester

Responsibilities:

  • Interpreted Functional Business Requirements and Functional Design Notes to create the UAT Test Plan for the Secure Site Redesign - Phase I (SSRI) project.
  • Created test plans and test scripts for execution in Mercury Quality Center (now H-P Quality Center) for the SSRI project.
  • Created a Traceability Matrix for the SSRI project to trace gaps within the process.
  • Attended team meetings for the SSRI project
  • Interpreted Functional Business Requirements and Functional Design Notes to create the UAT Test Plan and Test Scripts for the Loyalty 4 project.. This project was for the retail programs using shopping carts, multiple vendors, calendars, and various payment types.
  • Created test plans and test scripts for execution in Mercury Quality Center(now H-P Quality Center) for the Loyalty 4 project.
  • Attended team meetings for the Loyalty 4 project
  • Attended walk through's for the Functional Business Requirements for the Dynamic Card redesign project
  • Attended UAT team meetings

Confidential, Plymouth Meeting, PA

Systems Analyst

Responsibilities:

  • Interpreted Business Requirements and Functional Specifications for the project for Releases 1.0, 1.0 update, 1.1, and 2.0.
  • Created test scripts for the iPS project for Income Positioning Service Desktop Client (Fat Client), User Management/Hub Navigation, Management Usage Reports, Client Reports, and Sales Reporting.
  • Performed UAT (user acceptance testing) testing on the Tool Usage Reports and the Desktop Client for field representatives.
  • Created estimates for time requirements for the iPS testing cycles.
  • Coordinated and attended daily defect/fault meetings with internal and external clients to review such defects for disposition.
  • Executed test scripts for the Fat Client on various platforms, including WIN XP and WIN 2000. Also, tested the Fat Client using various browsers including AOL, Firefox, MSN, Netscape, and Comcast.
  • Executed test scripts within numerous environments including PROD, Pre-Prod, QA, Integration, AA Test Site, and AA Downloads.
  • Executed test scripts for all of the components of the iPS product as needed by the Fat Client tests, User Management/HubNavigation, Management Usage Reports, Client Reports and Sales Reporting.
  • Maintained all testing documents in a SharePoint repository for easy access by the QA Team.
  • Created simple SQL queries for the validation of data in XML files.
  • Used .NET technology for the Web based product.

Confidential, PA

Systems Analyst

Responsibilities:

  • Interpreted Business Requirements into Functional Design Requirements and Traceability Matrices for projects as assigned.
  • Created a Testing Approach document that included all information needed by the testers and developers for testing of projects.
  • Interpreted test requirements for the Quality Assurance needs of the projects based on Detail Design and Functional Specifications
  • Led project meetings to review the Functional Design documents.
  • Issued Meeting Minutes and follow up information for action items.
  • Created Excel spreadsheets for test scenarios and test cases.
  • Created simple SQL queries for the validation of data being converted from flat files to XML files into theupstream data base.
  • Interfaced with Business Analysts, Systems Analysts, Developers, and Management for review of any and all processes for implementation of the projects.
  • Attended training classes for the eSB department to understand the systems and processes associated with the ongoing daily, weekly, monthly and yearly processes.
  • Tested web based applications that used Java .

Confidential, Harrisburg, PA

Sr. Quality Assurance Analyst

Responsibilities:

  • Validated by testing, that all Commercial Line Insurance (including all types of Property and Casualty) are correct and are documented properly in the WriteBiz system.
  • Validated by testing, that all Commercial Line Insurance is correct and documented properly in the Allenbrook system.
  • Interfaced with System Development Manager, Client Manager, Research & Development, Underwriting, and Subject Matter Experts
  • Tested the Rating algorithms for State and Lines of Business either manually or by automation.
  • Tested web based software that used .Net applications.
  • Created and tested scenarios for UAT of the products for Commercial Line Insurance.
  • Assisted in the development of Training materials.
  • Gained working knowledge of Commercial Insurance processing for Business Owners, Contractors, Commercial Auto, Workmen’s Compensation, Umbrella and the Commercial Package Policies in all states that Donegal writes business policies.
  • Was knowledgeable with the workflow and interface processes for the Commercial Lines Insurance.
  • Assisted with the coordination of system upgrades as they related to testing with all departments.
  • Reviewed all ISO materials/filings that are received from Research & Development for Quality Assurance.
  • Assisted in the design of System Screens and Structure & Flow of Screens
  • Reviewed/Evaluated Forms and wrote up specifications accordingly for Quality Assurance
  • Estimated the timeframe and impact on the system and processing for Quality Assurance.

Confidential, Plymouth Meeting, PA

Sr. Quality Assurance Analyst

Responsibilities:

  • Validated that all testing processes are properly and adequately documented.
  • Interfaced with Client Manager, Project Manager, Development, and Subject Matter Experts.
  • Interpreted test requirements for the Quality Assurance needs of the project based on Detail Design Specifications.
  • Performed UAT testing for the Order Entry and Billing Applications with the Accounts Payable staff.
  • Developed QM Strategy Documents, Test Plans, and Test Scripts for manual and automated testing of the software applications. Examined and evaluated purpose and content of business requirements.
  • Reviewed, analyzed, and evaluated business systems for quality control of Finance Business Applications (including Sales Customer Relationship Management Applications, Order Entry & Billing Applications, Sales Compensation Applications and E Com General Ledger Processing).
  • Formulated test plans to test web based sites that used .Net protocol to parallel overall business strategies.
  • Wrote detailed description/results of test, program functions, and steps required to modify computer applications.
  • Worked with Sales Customer Relationship Management Applications, Order Entry & Billing Applications, Sales Compensation Applications and E Com General Ledger Processing.
  • Created application test plans and MS Project plans.
  • Understood the needs and was comfortable working closely with business users and programmers in researching and solving problems.
  • Relied on past experience and judgment to plan and accomplish goals.

Confidential, Harrisburg

Auditor/Quality Assurance Tester

Responsibilities:

  • Assisted with oversight of component and integration testing that the primary vendor was performing.
  • Performed UAT with the Commonwealth testers.
  • Assisted the Commonwealth testers with all facets of test writing for test plans and test scripts.
  • Validated that testing techniques were adequate and support best practices.
  • Verified that all testing processes were properly and adequately documented.
  • Ensured that evaluation and test criteria were adequately defined.
  • Ensured that SDLC standards were defined, appropriate, and in place for each specific activity.
  • Reviewed and evaluated testing tool configuration, implementations, and associated reports and work product.
  • Evaluated and documented IV&V relevant observations from Solution Provider and Client meetings.
  • Ensured that business requirements set was clear, complete, and wholly expressed in documentation as final solution throughout the SDLC
  • Reviewed, commented, and prepared evaluation reports for all Solution Provider deliverables, utilities and supporting documentation.
  • Reported process inefficiencies and updates via a weekly status written report.

We'd love your feedback!