Information Technology Professional

Summary:

An independent, committed and accurate Information Technology Professional with experience as a Business, Systems and Quality Assurance Analyst. Possess diverse experience in the insurance, retail and financial industries. Recognized as a successful team leader with the ability to consistently deliver results within the project‘s timelines. Highly valued organizational, communication, time management, problem solving and decision making skills.

Core competencies include:

Cross Functional Coordination

Customer Focused

Detail Oriented

Technical Depth and Breadth

Strong Analytical Skills

Team Player

Self-Motivated

Resourceful

Deadline Sensitive

Technical Skills:

MS Office Suite, MS Project, Visio, MS Access, Outlook, DB2, Test Plans, Data Flow Diagram, App Design Specs, Functional Specs, Business Specs, Test Strategy, Warehouse Testing, Software Testing, SAS, Oracle SQL*Plus, PL/SQL, TOAD, Oracle Developer 2000, Star Schema, Relational DB, Eztrieve, Hypereion(BRIO), QMF /Spufi, TSO/JCL/Fileaid, Mainframe, Sales Force(financial), Sales Logix, Data Loader, Docupace, Smart Works, Salesforce(medical), CA Agile Central(Rally), HP ALM Explorer 12.2x(Application Lifecyc le Management), Microsoft SQL Server 2012, Work Bench

Professional Experience:

TEK Systems / Client: United Health Group, Hartford, CT 1/2016-1/2017

Team Lead / Quality Assurance – Sales Force - Complex Care Management

Provided QA team leadership to support the testing of the new and improved version of the Salesforce Application UI which will eliminate current inadequacies, production problems and be an integral part the Pathway Project, which is being designed to migrate Complex Care Management (CCM) LOB’s – INSP / IESNP / DSNP – off the Care One to Complex Population Management System.

Used the Agile Software Development Process which divided the work that could be completed into two week sprints (there were over 30 sprints)

Managed the QA team of 4 testers to make sure that their test cases and test plans captured the Business Analyst’s Requirements. Defects were documented/resolved with explanations and screen shots if applicable, daily meetings to discuss any issues that needed to be resolved, etc.

There were daily scrum calls that monitored the progress of each story and dealt with any issues, defects or needs of the participants(developers, testers, BA’s, SA’s and Architects)

participated in the hands on testing of the Salesforce UI

Our team created negative test scenarios for the UAT testing and a Regression test bed

Team Lead for two QA testers that were responsible for creating test cases / test scripts for the New – CP Community Reports (Texas) for the enhanced Inbound and NextGen Migration. I created End to End Test Plan for these reports.

Also was involved in testing “Pathway Member Ingestion and Identity Management Software” and “Campaign Data Load Solution Integration”

Held meetings with the QA team to transfer the knowledge that I acquired while working on the “Pathway Member Ingestion and Identity Management” process. This process is complex and the data exported from this process is critical to the rest of the system and needs to be 100% correct.

This testing involved the process of creating/ transporting data using client input files which were processed through the system to various data bases and associated tables.

Validation of the data included correctness of the data, edit rules being followed, error conditions working correctly and Etl processes functioning properly

Used Microsoft SQL Server 2012, Work Bench, Excel Spreadsheets and Sales Force UI, to validate that the data was correctly transferred from client input files and processed through the system to the various data stores and then loaded into SalesForce.

Constance Kish, page 2

Apex / Client: Voya, Windsor, CT 3/2015-10/2015

Business Analyst / Quality Assurance – Broker Dealer Business Support

Supported the Hybrid Registered Investment Advisor Project (medium size) and the Docupace ePACS project (large size) as a BA and QA tester. The area that I was responsible for was Docupace (workflow processing system), a third party vendor which hosted and supported imaging applications for the ING CORE broker dealer. The automated imaging and workflow capabilities allow for electronic routing, storage, and document retrieval which increases efficiency and production, reduces lost paperwork and drives down cost for representatives and the home office.

Part of the Business Technology Support Team, focusing on the Docupace Hybrid RIA and ePACS projects

Participated in project and application business Requirements reviews, test strategy reviews, and status/defect meetings within current release

Evaluated business requirements and translated into test plan

Many meetings were held with the Docupace IT team to resolve many outstanding questions/issues, due to the lack of documentation For the Hybrid RIA project prepared and executed test scripts for the segregation of Voya Financial Advisors Firm’s reps and accounts from the independent reps, within the Docupace workflow and imaging system

For the ePACS project prepared and executed test scripts for the Brokerage ePACS workflows and coordinated the preparation and execution of the Direct Way ePACS workflows test scripts

Documented test results, reported and resolved defects via bug tracking tool Smartsheet used by Docupace and worked with Docupace to resolve these issues.

The testing consisted of WEB based Docupace and Smart Works applications in the Acceptance and UAT test environments

Documentation for Docupace was non-existent. I created/maintained a sharepoint site to store informational and procedural documents, that we had been creating and encouraged the team to contribute

APEX / Client: ING / Voya, Windsor, CT 5/2014-9/2014

Quality Assurance – WEB & Customer Relations Management Services

Provided Quality Assurance Consulting for the Conversion of the SalesLogix data and relationships to the SalesForce Application Project for the Retirement Institutional Markets. The Small and Mid-Market Corporate teams now utilize a Client Relationship Tool (Saleslogix), no longer supported by the Vendor. The servers that the CRM tool resides on are being decommissioned and the tool is being moved to a new data center. This environment will provide an integrated, holistic view across the different relationships pertinent to the institutional Markets users.

Participated in sessions to map the records and relationships needed by the Corporate, TEM (Tax Exempt Market) and LCM (Large Corporate Market) Business from Sales Logix to Sales Force for Retirement Institutional Markets

Followed the Agile Software Development Process

Prepared and executed Account, Plan, Activity, Opportunity test scripts for Acceptance and PFIX Testing

Collaborated with business analysts and developers to resolve test issues

Documented test results, reported and resolved defects via bug tracking tool in Quality Center

Cigna Healthcare, Bloomfield, CT 6/2004-1/2014

Systems Analysis Specialist/Quality Assurance – Data Warehouse

Supported the HealthCare Economics (HCE) Data Mart, Transitional Data Store Warehouse (TDS), Finance Data Mart and the Consumer Centric Data Repository (CIGNA Corporate Warehouse applications). Familiar with the subject areas within the Warehouses and Marts. As QA test lead for these applications, coordinated activities related to business workflow testing for all enterprise projects for the major yearly releases. These projects assisted Cigna Healthcare in achieving its goals of improved customer service, better management of medical costs, standardized processes and reduced administrative costs.

Performed the duty of test lead for theTesting Competency Center and subject matter expert supporting these warehouses and data marts.

Participated in project and application design spec reviews, test strategy reviews, functional spec reviews, status meetings and data flow working sessions for applications within current release and provided sign offs.

Facilitated training sessions to bring four individuals up to speed in the testing of the warehouses and marts.

Participated in evaluating the business workflow test scenarios, based on application design spec reviews for the input feeds, application design spec reviews, project design reviews and application test strategies.

Coordinated applications testing efforts working with the Project manager and Project test lead.

Led and coordinated the documentation of test plans, test scripts and results using Quality Center/Test Director.

Assigned and monitored test activities to ensure test results were based on project requirements.

Participated in sessions to identify scenarios that were candidates for automation and future regression tests.

Evaluated business requirements and translated into test strategies and plans.

Coordinated test planning and execution work with offshore vendor resources.

Coordinated preparation of evidence review documents for business review.

Also responsible for creating test scenarios, test scripts, test plans and test strategies.

Very familiar with Quality Center - test scripts, defects

Ability to evaluate data using Oracle SQL Developer, TOAD, TSO/JCL/Fileaid, QMF /Spufi, Hypereion (BRIO), Eztrieve, and EXCEL to query and validate varying data and file formats.

Possess strong SQL skills to create adhoc reports joining as many as 12 tables and comparing source fields to target fields on Oracle and DB2 databases.

Constance Kish, page 3

Albano Systems / Client: Mass Mutual, Hartford, CT 2003-2004

Business Analyst – Disability (Consultant)

Provided Business Analysis Consulting for 04 Product Initiative including addition of new products/riders to the Disability Ins portfolio, co-coordinated the Web logic Upgrade testing effort for system, QA and Pre Production.

Created enhancements to business specifications document for the Sales Workstation Integration and added Max Elect, Radius 04 products and catastrophic rider to Sales Tracking Tool.

Documented the system dependencies, high risk factors, critical testing areas, and unique testing situations.

Analyzed product specifications against the Sales Tracking Tool to drive appropriate modifications.

Created test plans, coordinated testing efforts, performed systems QA, pre prod testing to test the web based Case Viewer and Online Enrollment Tool, Sybase Guarantee Issue Process System and Benefit / Premium Calculation Reports.

Documented issues found in testing and work with developers to resolve these issues.

Ames Inc, Rocky Hill, CT 2001-2002

Systems Analyst/Programmer – Financial Applications (Fulltime Employee)

Provided technical leadership to the tax department to design and produce critical tax reports to avoid government penalties.

Created and executed project plans.

Facilitated business requirements gathering and translated into system functional specifications and design specifications.

Created / coded program specifications and created / executed test plans.

Created custom queries and reports for users and performance-tuned existing reports.

The critical Tax reports were created on time to avoid government penalties.

Systems Group / Client: Cigna, Bloomfield, CT 2000-2001

Business Analyst - Provider Access Line (Consultant)

Provided business analysis for provider access line 1B and 1D Transformation Projects.

Developed, prepared, and executed test cases, plans and scripts for systems, end to end, acceptance and regression testing.

Worked closely with business analysts from interfacing systems to create meaningful test data to adequately meet the testing requirements of all the systems involved.

Collaborated with business analysts and developers to resolve test issues.

Documented, reported and resolved defects via bug tracking tool in test director. Performed production checkout.

IMART Consulting Inc. / Client: Ames Inc., Rocky Hill 1999-2000

Systems Analyst/Senior Programmer – Financial Applications (Consultant)

Provided System Analysis and Program Consulting, which was used during the conversion of the GEAC Fixed Assets and Lawson Fixed Assets Systems to the Oracle Financials Database. Created custom accounts receivable, accounts payable and general ledger reporting for the Financial Department.

Created and executed project plans.

Facilitated business requirements gathering and translated into system functional specifications and design specifications. Created / coded program specifications and created / executed test plans

Created data mapping documents for the GEAC and the Lawson Fixed Assets Systems which were used to map the fields to the new Oracle Financial Data Base.

Created custom queries and reports for users and performance-tuned existing reports

Howard Systems / Client: MassMutual, Springfield, MA 1997-1999

Business Systems Analyst/Quality Assurance – Individual Life (Consultant)

Provided Quality Assurance Consulting for the Year 2000 Project Team for Individual Life performing test support, data aging and Future date test environment support.

Provided test support for each system during its testing process from test strategy, test plans, test cases, test environments, test data, test cycles, execution of tests, resolution of problems, verification of data, to the sign-offs for each phase of testing.

Coordinated integration testing of the systems that should be tested together including the correct software version and the correct cycles of data.

Documented the procedures that were being used for the future date test environment setup.

Aetna US Healthcare, Middletown, CT 1996-1997

Specialist/Developer – Healthcare

Developed the process to extract the member data from the Aetna Administrative System (AAS) and then to load the extracted data to the USQA Data Warehouse.

Data mapping from existing data model to new data model

Initiated meetings with all involved participants and kept everyone informed.

Created and executed project plan. Wrote the programs to extract and load data.

Gathered requirements, wrote program specifications and created / executed test plans.

Created custom queries and reports for users. Ability to use QMF, SPUFI, UNIX

Connie Kish, page 4

Aetna Life & Casualty, Windsor, CT 1990-1996

Specialist, Senior Programmer Analyst

Several roles and responsibilities associated with a multitude of projects in the Property/Casualty business and Aetna Health Plans.

Operational areas include Loss Responsive Rating–National Accounts, Premium Billing-National Accounts, Claim Administration, Electronic Publishing, Alpha Interface, Risk Management, and Aetna Health Plans.

Senior Programmer/Analyst:

Application development/ maintenance for new and old systems.

Accurately interpret customers’ problems and offer the best resolution in a timely manner.

Trouble shooting complex problems. Assist and direct junior members of the team.

Data Modeling Sessions: National Commercial Accounts Information System

As a team member, modeled NCAIS’ claims, sites, and plans using the E. F. Codd modeling approach.

Tester:

Planned and implemented many test projects.

Developed and executed test plans in the User, Acceptance, Regression, and/or Production environments.

Change/Resolution Management

Verified all results with the business partners and obtained the sign-off for production implementation.

Team Leader:

Responsible for both development projects and the resolution of production and maintenance referrals.

Used Phase/4 System Development Methodology to Develop the Actual Paid Loss Retro Billing Stage I & II projects. These systems interfaced with the Electronic Publishing System.

Communicated with National Accounts Department about the impact of IDMS Version updates on their Systems & changes needed.

Assumed responsibilities of the Retrospective Rating System (Stage I) during the testing phases of the project due to reduction of staff. Resolved outstanding issues, obtained sign-off from customers, and implemented into production.

Recommended a major cost saving measure before implementation

Key player in the Retro Calc Override enhancement. VB front-end, upload to MVS for batch processing, download extracted data to server each morning for PC inquiries.

Developed the stage II Retrospective Rating Update process using AMP methodology.

Team Leader of 3 programmers for maintenance support of 10 systems. The team handled 80 referrals in the first year.

Education:

AS Computer Science: Hartford State Technical College, Hartford, CT

Computer Studies: Western New England College, Springfield, MA

Contact this candidate