Post Job Free

Resume

Sign in

Data Project

Location:
Las Vegas, NV
Posted:
February 15, 2020

Contact this candidate

Resume:

Classie M. Holden, MBA Las Vegas, NV adbsqf@r.postjobfree.com 510-***-****

PROFESSIONAL SUMMARY

15+ years of Information Technology services in:

SDLC, BRD/FRD, management, project management, business and data analysis/analytics, white box/black box/grey box testing, web-based testing, mobile testing, resource management and planning, process improvement, requirements gathering, use cases, user stories, process flows, project plans creation, test strategies, test plans, test estimates requirements and test case creation and execution expertise, UAT, ETL, data modeling, data cleansing, data/database integrity. Experienced in system and security setup, data warehousing, disaster and business continuity. Risk mitigation/assessment, PCI, P2P Data Encryption & Tokenization, EMV and HIPPA experience. Experience working with Agile/Scrum, Kanban and Waterfall Methodologies. Skilled at being a conduit between business stakeholders and technical project teams.

SKILLS

Microsoft Office, Microsoft Project, Visio, SharePoint, Access, Toad, JIRA, Confluence, Quality Center/ HP ALM, UML, LoadRunner, QTP, TFS, JAVA, ServiceNow, Rational ClearQuest, Rational ClearCase, Double Take (data cleansing tool), EditPlus, UltraEdit, Putty, PMS, CMS, LMS, InfoGenesis (POS), EVERI (Kiosk), Oracle SQL, MYSQL, TeraData SQL, Selenium, gForge (project tracking), eCash (electronic secure cash system for transferring credit card information), JCL, MVS, TSO,Enterprise Pharmacy System (EPS), UNIX, AS400/iSeries, ACRES, BRAVO, ACSC, IGT, SAS, Business Objects, Business Object Data Integrator (BODI XI), Kronos, Cognos, Ardent Data Stage, PeopleSoft Financials 8x, PeopleSoft HRM, Soloman Financials, SQL Server 2008, WINSQL, Sybase, DB2, FOCUS, GitHub, Crystal Report, SSRS, MicroStrategy, HTML, XML, SOAP UI.

INDUSTRY EXPERIENCE

Casino eCommerce & Marketing Financial/Banking

Hospitality Health Care Education

Customer Service/Call Center Government

EDUCATION/TRAINING

University of Phoenix: MS - Computer Information Systems

PROFESSIONAL EXPERIENCE

Test Engineer -Gaming Laboratories International (GLI) 07/2018 – Present

●Provide functional testing and analysis for hardware and software of gaming devices

●Set-up and configure gaming products for testing

●Ensure gaming devices meet compliance with state, federal and tribal gaming regulatory standards

●Detect and log defects via Jira

●Identifies and use pre-defined test scripts, utilizing the correct rules per jurisdiction and regulations prior to certification submission

●Perform system and gaming audit reconciliation

Business Analyst -CTG (Client: HMS) – Las Vegas, NV 11/2017 – 05/2018

Part of the technical BA design team utilizing SQL Server 2014 responsible for:

●Development of Business Process design flows utilizing VISIO

●Utilize ETL to conduct health plans data analysis, auditing and report generation

●Development of Test Cases utilizing complex SQL queries utilizing Teradata

●Conduct Data validation and verification

●Respond to and Process healthcare data rebuttals, denials and acceptance analysis

Data Analyst – Magnolia Health Plan (Contract) 07/2015 – 09/2017

Part of a newly developed team responsible for the analysis of health management programs including:

●Design reports for use in validating financials, pharmacy, claims, clinical, provider and member network data for Medicaid and Medicare (CHIP, TANF and SSI) to assist management in making good business decisions

●Perform data cleansing and data reconciliation analysis and trend analysis in various functional areas of healthcare to find and document any deviation in data

●Create, validated and distributed various financial and statistical reports using Excel, Pivot Tables, Access, MicroStrategy and Teradata SQL

●Served as Compliance Ambassador to the Finance Department, helping to improve knowledge of data privacy, policies and procedures

●Handle client related issues and work with both business managers and supervisors in facilitating deliverables

●Responsible for developing and tracking data trends, forecasting and metrics summaries and reports of various levels using Teradata SQL

●Participate in researching and recommending cost-savings Health Benefit Initiatives to management. Assisted with creating Dashboards, Graphics, Summary reports utilizing Pivot Tables, VLOOKUP and HLOOKUP

●Evaluate business data to identify their difference and/ or locate similarities to find ways in which they can be integrated for better results

●Gather and interpret business requirements, monitor and analyze data trends to identify and resolve issues for

better report turn-around time and accuracy; increasing this process by 70%.

Quality Assurance Manager – Agilysys, Inc. (Las Vegas, NV) 08/2013 – 06/2015

●Manage and provide guidance to QA Analysts of one of the largest Lodging Management Systems (LMS) in the Las Vegas area

●Develop and streamline QA documentation process / standard operating procedures, defect management process, test plans / strategies, metrics and PCI testing process

●Create and produce testing strategy for various projects following the SDLC process

●Responsible for the development of QA quarterly turnover release plans and presentation to Management Team

●Develop working relationship with remote and on-site Developers, Business Analysts and Project

●Responsible for estimating testing requirement for QA test efforts

●Responsible for preparing reports for presentation at monthly Leadership Review Meetings

●Assist with the QA testing efforts in time of crisis to meet critical deadlines

●Plan and conduct performance employee reviews and performance improvement plans

●Develop and introduce the first department on-boarding QA process and resource planning process (hardware, software, staffing) which was later used by the entire company.

Sr. Business Systems Analyst – IT Strategies (Contract) (Las Vegas, NV) 10/2012 – 6/2013

Project: Windows 7 & Microsoft Office 2010 Upgrade

●Create project metrics, perform project analysis for software migration project for over 150 departments

●Gathered, analyzed and documented business requirements, conduct and plan User Acceptance Testing and training (UAT)

●Assist in implementing tests processes, policies, and protocols

●Project liaison between Information Technology (IT) and businesses during the migration project. Coordinated and lead project kick-off meetings

●Documented business requirements, determine and recommend solutions for application functionality and reporting needs. Developed Functional and Technical Design documentation.

Quality Assurance Analyst – Experis, LLC (Contract) (Las Vegas, NV) 04/2011 – 08/2012

Project: Casino Upgrades / New Features

●Prepare test plans, test scripts and test scenarios in Agile / Waterfall environment for various projects utilizing black box and white box testing for .net, web-based and iSeries applications

●Prepare and maintain issues / defects and escalation processes

●Create and execute SQL queries to validate test data for various enhancements and new projects

●Develop and create test cases and obtain sign off on QA Test Plans

●Responsible for the completion of QA Lab set-up and testing (slot machines, embosser) improving testing efforts by 100%.

●Develop the QA project release plan, improving QA Production release by 90%

●Identify and confirm software bugs detection and drive escalation and resolution efforts using FTS

●Provide End User Training. Communicated status of all task priorities including time remaining and expected delivery.

Sr. Business Analyst – Haynes & Co. (Contract) (Pasadena, CA) 12/2010 – 04/2011

Project: SBMO Migration

As a member of the newly developed Store Based Mail Order Team (SBMO), responsible for preparing and maintaining issue logs, gathering requirements, project analysis and resource planning (local and offshore).

●Provide technical support and training to end users as well as coordinating project upgrades and User Acceptance Testing

● Act as liaison between business and technical team

●Evaluate company systems, hardware/software and current processes

●Compile objectives for improving and streamlining company procedures

●Track company systems progress and provide management report on progress

●Research and recommend procedures to improve existing systems and hardware/software

●Prepare Functional Business Requirement and Technical Specification Document

●Conduct interviews with project business owners/stakeholders to gather project requirements and scope

●Assist management with project timelines and completion schedules, and project close-out documentation.

Fitech, LLC 02/2010 – 11/2010

Business Analyst / Project Manager / QA (Las Vegas, NV)

Performed dual roles for a Payday Loan spinoff company by conducting Business Requirements and Analysis for projects for current and new projects.

●Manage Projects and Project Upgrades using Agile Methodology and Kanban acting as liaison between the business and developers

●Perform process improvement by reviewing current process and recommend process improvements

●Coordinate with management on daily and weekly reports creation for distribution

●Assist VP with project milestones, resource planning and budget projections using MS Project and Excel

●Assist in the planning and implementation to supportive business solutions

●Analyze and translate data for presentation to other team members

●Present key information to IT teams for improvements

●Estimate and establish costs of upgrades and improvements

●Address issues of existing systems

●Compile, write, and distribute system process specifications

●Participate in Requirements Review Walkthrough and project sign off, prepare Business, Technical, and Functional Requirements documentation as well as provided test cases execution, defect management, UAT readiness utilizing Oracle PeopleSoft Financials, SOAP UI and Selenium for various applications/projects. Helped to improve to the department process by 60%.

Las Vegas Sands Corporation 06/2008– 2/2010

QA Analyst Lead (Las Vegas, NV)

●Develop, prepared and reviewed test plans, test strategies, test cases, and test summaries for various projects and applications for various Casino applications and projects via AS400 (iSeries); slot machine testing and set-up

●Conduct Risk analysis, managed and tracked defects

●Develop formal QA templates for producing test plans and test scripts. Improving defect tracking and QA documentation 70%

●Develop and execute iSeries SQL queries for validating test data

●Utilize Cognos for testing and developing various reports.

Software Quality Engineer – Link Technologies (MGM Contract) (Las Vegas, NV) 11/2007-6/2008

●Develop, create, execute and review test plans, test strategies, test scope and test summaries for various projects and applications at MGM Mirage

●Develop and execute iSeries SQL queries for validating test data. Create and execute test cases

●Conduct risk assessment on projects for Regulatory Compliance (GCB, PCI and PII)

● Serve as QA Lead for Infrastructure Vertical, managing offshore QA Testers for web-based applications including Hotel, Golf, Poker and Restaurant Reservations; and Players Club promotions

●Perform Regression, Functional, Performance and Integration testing.

Delta Dental of California 04/2005-11/2007

Software Test Engineer II/QA San Francisco, CA

●Conduct software testing of client and web-based applications utilizing Oracle, Unix and BODI XI

●Manage and review test cases for remote and offshore testing teams

●Develop, prepare, execute and review test plans, test strategies, test cases, and test summaries for various projects

●Develop installation scripts for UAT and production deployment/release

●Conduct quality walk-throughs to obtain testing sign-off

●Audit the quality of project turn-over reports from developers

●Develop and execute SQL queries/scripts to verify and validate data between source and target

●Extract, Transfer, and Load (ETL) data in various into database tables ensuring successful data loading

●Analyze and document issues / defects discovered during testing.

Ernst Mechanical, Co. (HVAC) 02/2002-10/2009

Project Manager/Consultant Oakland, CA

●Responsible for employees scheduling, coordinating and managing contracts, permits, submittals, change orders, operation manuals, request for information, ordering of materials, blueprints and take-offs assistance, health and safety documents for plumbing projects

●Maintain and Create positive relationship with contractors, suppliers/vendors, owners, and architects about contract-related matters and orders. Prepare weekly time sheets.

CompuTrain / RTTC 05/1994 – 02/2002

Trainer/Consultant Oakland, CA

●Develop and enhance course materials for Word, Excel, Access, PowerPoint for participants in the Welfare to Work program

●Interview and work with perspective business partners to determine program requirements

●Establish relationships with companies, community organizations and professional organizations for job placement

●Prepare for and attend career fairs and community events.

University of California 09/2001-04/2005

Programmer Analyst II/HR Assistant Oakland, CA

●Manage UC Corporate contracts and grants reporting system and departmental Access and Mainframe databases utilizing Focus, JCL, DB2 and MVS

●Maintain, enhance and modify Research Administration Web page utilizing Dreamweaver

●Manage office information systems, including files, regulatory and library materials, managed temporary and permanent administrative staff

●Distribute information to campuses and investigators for electronic proposal submission of contracts

●Research, generate and troubleshoot sponsor code problems and changes. Coordinated and lead inter-departmental process improvement meetings

●Interview and document clients’ requirements and changes. Performed background checks for applicants using PeopleSoft

●Conduct interviews/screening (phone, in person), administer pre-employment testing, prepare and attend career fairs.

ValueStar Marketing, Oakland CA 05/1998 – 09/2001

Call Center Agent/Database Analyst/Software Developer

●Handle inbound and/or outbound calls, chats and emails. Conduct telemarketing or sales/up sales, customer service, third-party verification, or technical support for inbound and/or outbound calls

●Identify and document business processes and recommended improvement. Created the business process review schedule by functional area (Finance, Sales, Marketing, IT, Ratings). Analyzed and documented system requirements for enhancement, implementation, training and processes including data gathering and user requirements. Create data flow diagrams utilizing VISIO. Researched and reconciled weekly reports

●Manage and execute direct mail marketing campaigns, segmentation, and data processing services

●In collaboration with the Sales and Marketing departments, define and implement procedures for process improvements

●Manage and provide on-board training to contract and full-time staff

●Project Lead for Goldmine and ACT Customer Relationship Management database

●Analyze and produce branding trend reports to assist sales and marketing departments in making key business decisions

●Develop Financial, Sales and Ratings Reports utilizing PL/SQL and Crystal Report for test and development databases

●Define process requirements for report changes, upgrades and new system proposals

●Review, propose, design, and implement department changes recommending overall improvement to operations

●Analyze, develop, test, and tune various queries, procedures and database triggers to synchronize active service providers' information between the Goldmine (CRM) and Production databases

●Develop queries, triggers, stored procedures, and tables using SQL/Scripts, PL/SQL, and Oracle Forms 6i for the Call Center, Sales, Finance and Marketing departments

●Performed data loading, developed and executed SQL using SQL*Loader to import and export data (ETL)

●Develop queries, procedures, and temporary tables to load new data received on CD-ROM into a data warehouse

●Produce marketing reports from company-wide databases by extracting information through various databases

●Generate direct marketing lists (email blasts, direct mail, telephone responses and fax) for management.

Consultant – Harris Consulting (Las Vegas, NV) 07/2013

Provides business analysis and technical support for hardware and software installation to various clients to include:

●Accounts set-up, changes and deletion utilizing Active Directory

●Conduct compliance analysis and recommendations as needed

●Provide training and consulting services as needed



Contact this candidate