Support Data

LORILYNN KING

Loveland, CO *****

************@*******.*** 303-***-**** www.linkedin.com/in/lorilynnking DATA ANALYST, METICULOUS AND TENACIOUS

Analysis, Application Development, Systems Integration, Post-Install Support Expert in verbal and written communication, proactive, extreme detail-oriented problem solver with demonstrated success in breaking issues down into logical steps to be prioritized, addressed and solved. Technically savvy and a quick study in emerging technology along with industry and business skills that translate business requirements into system solutions. Remote telecommuting experience. Comprehensive experience in technical and test support, development team member, team lead, and product architect Recognized for schedule integrity and process improvement. Effective communicator collaborating with clients and global support teams with compassion and sensitivity to different cultures, styles, and values. Excellent mathematical and statistical analysis skills. TECHNICAL SKILLS

Oracle database administration; Application development & support: SQL, DB Visualizer, ETL (InfoSphere DataStage 9.1 & 11.3), HTML, CSS, Java, MVS/TSO: z/OS, ISPF and ISPF/PDF, QMF, JCL, RACF, Tivoli Workload Scheduler (TWS), PL/I, REXX, DB2, CLIST, IBM Utilities, VSAM, Problem and Change Management, Technical Writing & Course Development, Mathematics, Statistics, Microsoft Office (Word, Excel macros/VLOOKUP/pivot tables, PowerPoint, Outlook) PROFESSIONAL EXPERIENCE

ETL Development Team Lead (2013 to 2016) IBM Business Analytics Services, Boulder, CO Led global team of approximately 35 developers from worldwide locations. Developed, tested and supported ETL analytics applications.

Supported and worked with customer data of approximately 70 clients from a variety of industries, including finance, government, insurance, and travel. Managed confidential and restricted accounts which often required security clearances and drug screening.

Utilized DataStage 9.1 and 11.3, importing and processing client data for incident, problem, change, asset, availability and other domains.

Created SQL queries used against DB2 relational databases, manipulating and transforming data in preparation for graphical presentation via Cognos.

Scheduled DataStage jobs based on performance of SQL queries and availability of updated source data, ensuring timely and accurate completion of metric data generation processes.

Coordinated with additional development teams (project management, architecture, database, presentation development, and steady state support), managing workload, client transition sizing and scheduling, life cycle development, and personnel.

Addressed production performance issues by coordinating with subject matter experts from ETL and other teams. Solutions included use of DB2 stored procedures, monitoring job performance, scheduling and minimizing contention, and DB2 indexing.

Enforced internal problem and change management using Maximo application, properly managing routing and documenting investigation, cause and solution.

Performed root cause analysis (RCA), addressing/preventing recurrence of production issues. Documented timeline of events and contributing factors, breakdown in processes and procedures, recommended process modifications via formal RCA web sessions and follow-up documentation. Lorilynn King ************@*******.*** Page 2

QA/Tech Support Team Lead (2009 to 2013) IBM Competency Metrics, Boulder, CO Performed multiple roles in development of analytics for IBM labor and productivity metrics for over 30 countries worldwide.

Collaborated with project executives to coordinate, prioritize, and document requirements for multiple releases of Competency Metrics Tool (CMT) offering on IBM mainframe utilizing MVS, DB2, batch JCL.

Developed, implemented and maintained complex batch scheduling suites using IBM Tivoli Workload Scheduler (TWS); provided education and documentation for other team members.

Led international team of testers, verifying new function and ensuring data accuracy. Created test suites for new function, integration, and regression testing and established system integration test environment that validated need for repeatable build process.

Executed problem and change management for development and production environments, resulting in timely resolution of issues and prioritization of requests for new function for future releases and ensured proper coordination and communication of change among entire project team.

Facilitated education and training for new development team members and country/geography metric coordinators, including documentation/examples of common issues and resolutions, addressing user issues in timely manner.

Analyzed mathematical and statistical trends to identify best practices for labor and productivity to aid global executive teams in reducing regional and country workforce costs.

Developed standardized queries (DB Visualizer and QMF) used by support team members in mathematical and statistical analysis of data, investigation of production data and performance issues, streamlining problem determination and resolution. Tech Support Team Lead (2003 to 2009) IBM Measurements & Reporting, Boulder, CO Gained broad knowledge of metric reporting process, from data collection to extract to presentation of analytics data.

Investigated production issues with client metrics and documented common causes. Implemented and facilitated problem management sessions, ensuring timely progress on issue resolution.

Established repeatable change process and scheduled biweekly build sessions, communicating and enforcing proper coordination of changes between all branches of development organization.

Developed, implemented and maintained batch report sequencing and scheduling using Tivoli Workload Scheduler (TWS), achieving reliable sequencing and on-time completion of reports. EDUCATION

Bachelor of Science, Electrical Engineering (BSEE) College of Engineering, COLORADO STATE UNIVERSITY, Fort Collins, CO Oracle Database Administration Certification

College of Computer Information & Sciences, REGIS JESUIT UNIVERSITY, Denver, CO Web Development Certification

Techtonic Group, Boulder, CO

PROFESSIONAL DEVELOPMENT

Oracle Database Administration

SQL

PL/SQL

MySQL

Cognos V10 Queries

HTML

CSS

Java

MS Excel Macro Programming

IBM Rational ClearQuest

Fortran

RACF

ASSOCIATIONS

Board Member, Longmont Chorale, Longmont Colorado

Contact this candidate