OBJECTIVE:

Seeking a long - term opportunity at a solid company needing a Test Manager, QA Lead, PM, or Report Analyst to solve the company’s short term needs and create structure and stability long term. Karen is highly adaptable to a variety of system environments and able to apply her analytical skills to each unique situation, resulting in stakeholder and customer satisfaction. Karen is a manager and coworker that can empathize with the situations team members’ face. She focuses on listening; removing barriers and helping the team find solutions.

PROFESSIONAL SUMMARY:

• 20+ years’ experience in project management, business analysis, quality control, test leadership, and technical roles.
• She has in depth knowledge of SDLC methodology and general knowledge of Agile Scrum.
• She is skilled at test planning, organizing test teams, performing unit testing, system testing, functional testing, user acceptance testing, requirements gathering, data mapping, reporting, help documentation, business process flow diagrams, training and support.
• Uses PMI standards to effectively plan and monitor projects, using MS Project and other project tracking software.
• She has proven success in business intelligence and data-warehousing initiatives, with expertise in analyzing and reporting on large volumes of data, data quality and test management for a variety of system and business processes.
• She believes quality and process improvement to be a continuous mindset, a framework that guides our daily actions.

BUSINESS REPORT ENVIRONMENTS TECHNICAL HIGHLIGHTS:

• Marketing Database Client Support Data Quality ETL Tester Lead Using SQL
• General Ledger, Payroll Reports Cognos Report Studio Prompted Reports
• Health Benefit Enrollment TM1, Transformer, Data Models
• Workforce, 401K, Investment Reports QA Data Warehouse Star SchemaEnterprise PMO Pharmaceutical Manufacturer SQL Coding / Data Quality, Test Strategy & Execution
• Insurance Claims Scorecard Reports SharePoint, HP Quality Center, HP Quick Test Pro
• Issue Tracking & Issue Management Reports Business Process Analysis Visio /Excel/MS Access

SKILL:

• Using PMI and all aspects of Project management, Project Planning, Project Tracking, Task Lists, WBS, Monitor/Control Risk & Change, Meeting Facilitation, Team Organization, Stakeholder Communication Plan.
• Highly adaptable to various systems, platforms, languages, environment, business models
• SDLC, Requirements Gathering, Iterative Design, Agile Methodology
• ETL Test Plans, Integration Test, Performance Test, Data Conversion Testing, System Functional Test, UAT
• Test Strategy, Test Plan Creation, Test Execution, Issue Tracking, Defect Management, Mentor junior testers
• SQL Coding, Report & Cube Development & Testing, Cognos TM1 Perspectives, Cognos BI Cognos Connection, Report Studio, Event Studio, Framework Manager, Transformer, (Prompted Reports & Cubes). Data Quality Analysis, Star Schema, Testing Prompted Interactive Web Reports, HP Quality Center (HPQC) HP Quick Test Pro, MS Project, Visio, SharePoint, Word, Excel, PowerPoint, Access, technical writing
• Process Analysis/Data Flow Diagraming/ Business Process Diagraming, Current/Future State Analysis

EMPLOYMENT SUMMARY:

Confidential

QUALITY ANALYST TEST ENGINEER

Responsibilities:

• Confidential Corporate Operations. System and UAT Test management for TM1 Cubes for system conversion from People Soft to Workday for Confidential .
• Create test methods to check accuracy of financial Cognos Perspectives TM1 cubes.
• Compare the converted data and newly mapped data. Verify the accuracy of all years of historical data for the dimensions and measures in the Cognos TM1 Cubes.
• Together with business and technical leads, plan the testing effort, create test plans, test methods, user stories, test matrix, and execute test using TM1, MS Access & Excel. Log issues, regression test, document-testing artifacts in SharePoint. System went live January 2015.

Confidential

ENTERPRISE PMO PROJECT COORDINATOR

Responsibilities:

• The project involved over 1500 tasks, with multiple project managers and high amount of coordination between technical and business functional areas.
• Worked closely with lead Project Managers, Relationship Managers, and Functional Leads to create and maintain project schedules and other ad-hoc requests.
• Produced daily & weekly project status reports, meeting minutes to summarize key points from detailed discussions, action items, issue-tracking reports, organized go-live task list, on-call schedule for Hyper care.
• Daily use of Excel, Word, PowerPoint, SharePoint and MS Project for project tracking and artifacts. IT Restructure prompted contractor layoff.

Confidential

PM UAT TEST MANAGER

Responsibilities:

• Test Manager for a large-scale conversion from legacy General Ledger system to new accounting HUB (Microgen custom software.).
• Oversee all testing activities for User Acceptance Test (UAT), Data conversion, Disaster Recovery, and Performance Testing Under direction of head PM. Document process flow, task lists, time line, open items.
• Follow up / team task management from initiation through code delivery, defect resolution, and user acceptance.
• Meet daily with team leads to monitor progress, discuss open items, identify risks, and escalate issues and defects.
• Create and monitor task list, timelines, schedules MS Project.
• Document and monitor open items and project risks.
• Monitor resources, test plan creation status, test schedule, batch schedule, defect tracking and resolution in HP Quality Center.
• Create testing statistics reports for leadership team.
• Facilitate a coordinated effort, working together with vendor, business stakeholders, testers, developers, and QA teams. Hold daily cross-functional team meetings address specific topics with business, tech leads and vendor development team.
• Monitored task list in MS Project, creates time lines, schedules, open items list, communication plan, monitors and reports progress to executive management.
• Performed PM and BA work to fill resource gap, elicit business/technical requirements for Confidential Rate transmission process, document batch process, and keep cross-functional FX sub-team on task according to timeline.

Confidential

PROJECT MANAGER

Responsibilities:

• Manage technical process for on boarding web/email domains for newly acquired businesses.
• For domain acquisition, document and improve workflow/hand-offs between multiple divisions, departments, functional areas, and external vendors. Improve requirements gathering with a standard format improving efficiency and accuracy.
• Manage Enterprise PMO. Perform project reviews of high dollar IT Projects for resource, schedule and budget.
• Improve process by creating project-tracking templates for Project Managers to document status at a glance meeting CIO’s requirement.
• Train off shore team in PMO responsibilities and procedures.
• Create monthly IT metrics reports for global CIO using MS Excel & MS Word & SharePoint.
• Reports include Operational Metrics and Project Metrics with summary, detail & graphs.
• Publish monthly metrics to web portal.
• Train and delegate metrics report creation to offshore team, monitor and control process, working together to make improvements based on lessons learned.
• Trouble shoot operational issues for Confidential ., for the Concur expense management software.
• Document current state, interview stakeholders from multiple functional areas of IT and Business, and create new staffing model, quality control procedures, assure accountability for ongoing system support.

Confidential

SENIOR QUALITY ANALYST

Responsibilities:

• Create Cognos quality test methods and procedures as Sr. Quality Analyst for the Cognos development team. Document QA methods and train on shore and off shore staff. Perform testing (Cognos Report Studio Reports) for claims summary with drill through to detail, frequency and severity, triangle, claim scorecards, claim dashboard, code benchmark, managed care, workers compensation, book of business reports.
• Manage test team and perform all aspects of report and system quality for new reports and Cognos upgrades. Manage issue list; coordinate w/developers for resolution. Code complex SQL scripts to verify the accuracy of prompted, variable driven Cognos Report Studio reports. The Report Studio reports were interactive with ability to produce thousands of combinations of results, based on user input. Use multiple validation techniques to quality check report result matched manual result in Excel.
• Assure accuracy of data, security, user functionality, and adherence to requirements. Test all Cognos features: prompts, drill through to source system, user security, navigation, integration, scheduling. Assure all features work at optimum performance levels for end users who access reports via the web.
• Suggest system enhancements or eliminate unnecessary steps for more efficient system development procedures. Promote standardized formats and methods to provide consistent and predictable level of quality. Able to gain agreement from business community for changes that made technical development easier, but would alter user’s steps. Show proof of cost benefit of such changes in order to gain acceptance.
• Respond to website feedback and end user’s question. Collect responses to compile as reference guide, and published as FAQ and help documentation on web. Cognos Reports developed by our team were highlighted in company newsletters, sales and marketing materials bringing greater value to over 2,000 Gallagher clients.

Confidential

BUSINESS SYSTEMS ANALYST/COGNOS DEVELOPER

Responsibilities:

• Improved Cognos Payroll Reports for Finance Department using Cognos Impromptu, Excel, MS Access and SQL.
• Discover and document business and system requirements for desired report consolidation effort. Present summary of business requirements to gain approval from business management.
• Create/ Code process improvements. Consolidated data extracts, streamlined report creation using Cognos, SQL, MS Excel, and MS Access. Train remote teams using PowerPoint and Webinars. Cut labor hours by 75% reducing operating costs.

Confidential

BUSINESS INTELLIGENCE REPORT DEVELOPER AND ETL TESTER

Responsibilities:

• Code SQL to Perform ETL testing for large-scale startup of the Confidential Plan Sponsor Web Site newly developed data warehouse and data mart star schema design. Continuously develop expertise through daily use of SQL and Cognos Development Tools and troubleshoot system issues.
• Develop Cognos data models, cubes and reports such as Work Force Analysis, Health Management, and 401K, Pension, and Investment data. Perform report design, prototype, and coding using full suite of Cognos Software, SQL, Impromptu, Transformer, Power Play Enterprise Server, Upfront, and Access Manager.
• Setup Cognos Cubes and Web Reports for US Federal Reserve, JCPenney, Starbucks, Compaq, Allstate, JP Morgan etc. Each client had custom view based on user security. Roll out to 200 clients.
• Interface w/ internal business sponsors to gather requirements for executive reports using employee benefits data. Performed requirements gathering, data mapping, cube design, report development. Troubleshoot issues with Cognos tool interfacing with vendor. Develop work around or alternate solutions for rapid issue resolution. Develop Daily Annual Enrollment and Health Plan Migration Cognos Cubes & Reports for 250 clients. Replace manual Excel reports with automated web reports, resulting in significant cost savings.
• Enable customized analysis for benefit plan administrators and executives at their fingertips with Cognos Web Reports, eliminating programmer intervention. Use an iterative development approach to prioritize and deliver highest impact reports and cubes, rollout in phases based on stakeholder needs. Produce cross-client analysis reports on 401K trends published in US News and World Reports magazine.
• Redesign & stream line client Cognos Report on boarding workflow processes from manual GUI steps to a setup script by coding MDL language.

Confidential

SYSTEMS ANALYST PENSION ADMINISTRATOR

Responsibilities:

• Original role at Confidential assigned to legacy system. Manage software maintenance, customizations, and upgrades for group of clients Pension System. Perform client custom system testing and customize instruction for each client. Write client procedures for clients to apply upgrades on site, as well as travel to client site to perform upgrades. Project Manage setup and work flow to create the issue and project-tracking database. Managed consultant team resources for issue tracking/resolution and team assignments for system upgrades.