AN-LUNG (STEVE) LIN

**** ** ***** ******, *******, WA 98011

Phone: 253-***-****

Email: ad4f9i@r.postjobfree.com

SUMMARY:

Applications Development Manager - Project Manager - Business Analyst -

Systems Architect - Data Modeler - SQL Database Engineer - Developer

Accomplished highly-effective IT professional with several decades of experience and a proven track record of seamlessly integrating into new organizations and projects, quickly identifying key objectives, and mastering complex technologies.

Renowned for exceptional problem-solving skills, offering a wealth of creative and innovative solutions to challenges. Proficient in tailoring communications to resonate with diverse audiences, from team members to high-level executives, ensuring that the message aligns with their specific needs and priorities. A keen listener who excels at understanding the true goals of business users and management, translating these insights into highly successful IT projects that consistently exceed expectations.

Demonstrated expertise in project rescue and turnaround. Recognized for tackling high-profile projects and turning them into publicly lauded examples of exceptional management and innovative thinking.

Adept at galvanizing diverse cross-functional teams towards achieving common goals and optimal solutions. Equipped with extensive IT experience to lead staff effectively, ensuring projects are delivered on time and to the satisfaction of business stakeholders. Accomplished in directing teams of diverse staff in planning, executing, and overseeing numerous IT and business area endeavors spanning various technologies. Credited with achieving multi-million-dollar savings through innovative cost avoidance strategies and process improvements.

“Known for accomplishing what others thought was impossible.”

KEY COMPETENCIES:

- Systems Integration, Architecture, Design, Development, Business Intelligence, Data Analytics

- SDLC Methodologies (Agile, Waterfall, Hybrid) (Formal and Stage Gate Methodologies)

- Data Modeling (Enterprise, Conceptual, Logical, Physical)

- Efficient Database/Data Warehouse/Data Mart Design (Normalized, Star and Snowflake schemas)

- Technical Problem Solving- Business Process Analysis & Re-engineering (As-is and To-Be Models)

- Cross-functional Team Leadership & Motivation

- Process Improvement and Automation

- Project Planning and Management

- Stakeholder Communication & Collaboration

- Requirements Elicitation, Documentation and Maintenance

- Requirements Workshops / JAD sessions, Use Cases, BPMN, Requirements Matrices

- Testing Plans, Execution and Reporting

KEY TECHNICAL SKILLS: (Decades of experience in almost all listed)

- Database Systems: MS-SQL Server, Oracle, mySQL, MongoDB/noSQL, Sybase, Informix, xBase(dBase, R:Base),

Access, Paradox, DB2, ADABAS, DMS-2200.

- Business Intelligence: SQL, SAS, Corda/DOMO, PowerBI/Odata.

- Programming: SQL (T-SQL, PL/SQL), C#, C++, C, Visual Basic(VB, VBScript, VBA), Java, PowerShell, JavaScript,

BASH, AWK, Zebra Programming Language (ZPL), SAS, DYL, COBOL, Natural, Pascal, Fortran, PL/1,

RPG, MASM.

- Web Technologies: Web Services, ASP.NET/CORE, HTML/DHTML, XML/XSLT, CSS, JQuery, Bootstrap, PHP.

- Barcoding Systems: Multiple symbologies (QR, Data Matrix, PDF417, Code128, Code39, etc.),

creation, printing, scanning, printer control and configuration.

- Project Methodologies: Lean, Agile, SCRUM, SDLC, ALM, Information Engineering (IE).

PROFESSIONAL EXPERIENCE:

Applications Development Manager Public Health Laboratories Shoreline, WA 2014 – 2023

Responsible for leading a team of developers, business analysts, subject matter experts, and testers in the development, integration, and management of all of the IT systems at the Public Health Laboratories. This includes legacy system support and redesign, new Laboratory Information Management System (LIMS) enhancements, and the design and development of new (barcode scan-able, voice-enabled, and touch-enabled) applications, and workflow automation, in the support of clinical and environmental laboratory testing and epidemiology.

KEY ACCOMPLISHMENTS:

- Successfully enhanced laboratory information systems to handle critical public health outbreaks (COVID, Zika, eBola).

- Implemented automated result reporting system with encrypted email, resulting in a 1900% increase in delivery speed.

- Developed barcoded specimen scanning, resulting in a 1500% performance increase in laboratory throughput.

- Streamlined laboratory test development processes, resulting in a 97% performance increase.

- Developed specimen storage temperature monitoring system, ensuring specimen integrity via temperature compliance.

- Proven track record of implementing automated solutions, significantly reducing processing times between 60 and 80%.

- Gathered and documented business requirements, working closely with stakeholders, business SMEs and IT.

- Translated business requirements into technical specifications, and technical jargon into relatable business terms.

- Oversaw project teams, assigning responsibilities, and driving progress to meet project milestones.

- Successfully managed vendor relationships, enforced expectations, ensuring the timely delivery of contracted services.

- Automated many ETL/EL(T) pipelines, enhancing systems integration, affording better business information flow.

- Conducted feasibility studies, cost-benefit analyses, risk assessments, impact analysis, and gap analyses.

- Implemented best practices in systems architecture and design, ensuring scalability and performance.

Data Warehouse Specialist Department of Social and Health Services Olympia, WA 2009-2014

Worked closely with the Office of Refugee and Immigrant Assistance business to determine their needs regarding managing and the documentation, tracking, and reporting on Unaccompanied Minors assistance. Responsible for database, data warehouse, data mine, data mart, dashboard, web application design, development, and support for Economic Services Administration, Operations Support Division, E-MAPS Office using SAS, MS-SQL Server, Corda/DOMO, Java, and C#.Net.

KEY ACCOMPLISHMENTS:

- Analyzed their information flows and design a data warehouse, data mine, and multiple data marts, to address all

of their management and federal reporting needs.

- Developed a database and front-end application to ETL reports from diverse sources, processing and combining many

information management needs into one comprehensive system. That system is still being used today, without any

need for modification or enhancement since developed.

Information Technology Office Chief Department of Social and Health Services Olympia, WA 1997-2000

Responsible for all tasks performed by 35 diverse IT professionals. Responsible for the management and delivery of IT services to over 3,000 users and the public. This included multiple public assistance, food stamps, financial reporting, and health insurance benefit programs.

KEY ACCOMPLISHMENTS:

- Successfully created a new IT office with over 250 employees, that was spread over two cities and three different

locations. This included combining three networks into one new building, all over two weekends, with no downtime.

- Instituted Help Desk Issue Tracking, combined priority meetings, and time-tracking procedures.

- Created an in-house training center for IT staff professional development and customer system training.

- Created and led an inter-agency Federal and State Financial Reporting system project to standardize reporting.

- Developed and implemented a major imaging project processing 2.4 million imaged documents a month using OCR and

bar code recognition, in less than six months, saving the agency from a $300 million dollar Federal audit penalty.

- Streamlined complicated reporting system for a 47,900% (not a typo!) increase in speed of completion.

- Converted Legacy systems to Client/Server platform.

- Led Y2K conversion efforts and had successful rollovers for all in-house systems

Additional employment history available on request.

Employment History:

Previous Employers

Services Provided

Period

Washington State Dept. of Health Public Health Laboratories

Manage Public Health Laboratories’ information systems

2014 – 2023

Washington State Dept. of Health and Social Services

Business Intelligence Systems Architect

2009 – 2014

Washington State Dept. of Employment Security

IT Data Warehouse Developer

2005 – 2005

Washington State Dept. of Health and Social Services

Chief Information Technology Officer

1997 – 2000

Washington State Dept. of Employment Security

IT Manager/Senior Systems Analyst

1988 – 1997

Washington State Dept. of Health and Social Services

Senior Systems Analyst

1986 – 1988

CSC Computer Services Company, Incorporated

Assistant Business Manager

1984 – 1986

University of Cincinnati

Language Tutor

1983 – 1984

Mandarin House

Assistant Manager

1978 – 1983

Manus Services Corporation Direct Marketing Division

Developer

1979 – 1980

Garcia Incorporated

Developer

1977 – 1978

Cincinnati Public Schools

Developer/Programming Instructor

1976 – 1978

University of Cincinnati

Keypuncher

1975 – 1975

In addition to the above employment, I also have run my own consulting firm, named Cognizant Design, since 1990.

Clients

Services Provided

Period

Washington State Dept. of Health and Social Services

Business Intelligence Systems

2003 – 2008

Wolf Haven International, Inc.

Web site support

2007 – 2008

SafeCo Insurance Company, Inc1

Enterprise Systems Inventory Discovery

2006 – 2006

Washington State Dept. of Health and Social Services2

Legacy-to-Web Application Development (EJAS)

2003 – 2003

Washington Counties Risk Pool3

Internet-based Claim Database System

2000 – 2001

Illuminet (purchased by Verisign in 2001)

Database Conversion and Upsizing

1998 – 1998

Weyerhaeuser, Inc.4

Shipping System Y2K Conversion

1997 – 1998

Association of Washington School Principals3

Database Performance Enhancement

1997 – 1997

Olympia, Computer Central, Inc.

Training Database Development

1997 – 1997

Head Start Program ESD#113

Web Database Development

1997 – 1997

Idaho Department of Labor

Disaster Unemployment Assistance System

1997 – 1997

International Products Company, Incorporated

Network Expansion and Configuration

1997 – 1997

International Products Company, Incorporated

Network Installation and Business Analysis

1994 – 1994

Safeplace Women Shelters

Client Statistical System Analysis/Development

1992 – 1994

Center for Individual and Family Counseling

Network Installation and Client Billing System

1991 – 1992

Center for Individual and Family Counseling

Organizational Assessment and Alternative Study

1991 – 1991

Safeplace Women Shelters

Comprehensive Organization Assessment

1990 – 1991

John S. Murphy and Associates, Incorporated

Realty Image Database Telecom System Development

1990 – 1990

International Products Company, Incorporated

Accounting/Inventory Systems Setup

1990 – 1990

1-Subcontracted as W2 through Excel, Bellevue, WA

2-Subcontracted as W2 through Aetea, Tukwila, WA

3-Subcontracted as 1099 through Olympia Computer Central, Olympia WA

4-Subcontracted as 1099 through Professional Consulting Services, Seattle, WA

Partial Skill Summary Matrix (Recruiter Style)

This matrix is a partial listing of the skills I have acquired and used throughout my many decade career in the following positions:

Information Technology Manager, Project Manager, Senior Systems and Business Analyst, Data Administrator/Modeler, Database Architect, Business Intelligence, SQL Server, and Full-stack Developer.

Skill Type

Yrs. Exp.

Last Used

Proficiency

1-5

Management Skills

Business Management Skills

39

2023

4

Accounting and Budgeting Skills

39

2023

4

Communication Skills

48

2023

4

Staff Management Skills

32

2023

4

Project Management Skills (Waterfall, Agile/SCRUM, DevOps)

39/14/2

2023

5

Data Administration and Modeling Skills

Data Administration, Data Modeling, Database Administration

39

2023

5

Business Systems Analyst Skills

Information Engineering (Business Area Analysis, Business Systems Design, Detailed System Design, Construction, Implementation/Integration, Post Implementation Review), Requirement Studies, Alternative Studies, Feasibility Studies, Risk Analysis and Mitigation, Impact Analysis, Cost Benefit Analysis, Joint Application Development, Rapid Application Development, Business Process Reengineering, Reverse Engineering

39

2023

5

Modeling Skills

Conceptual, Logical, and Physical -Process Modeling, -Function Modeling, and -Data Modeling

39

2023

5

Methodology Skills

Jackson, Martin, Chen, Constantine, DeMarco, Ganes & Sarson, Warnier-Orr, Booch, Raumbaugh, Yourdan, Rational Unified Process, (IE,SASD,OOAD/OMT/UML/RUP)

39

2023

5

Databases

MS-SQL Server, Sybase

28

2023

5

Oracle

19

2023

3

DB2/CSP

4

2008

3

ADABAS, DMS-2200

10

2003

4

Xbase(dBase,R:Base,Clipper)

19

2000

5

MS-Access

36

2023

5

CASE Tools

ER/Win

4

2000

5

System Architect

3

1997

4

IEW/ADW

3

1991

5

Programming Language Skills

BASIC, Visual Basic, VB.NET

48/26/17

2009

5

Structured Query Language (SQL)

39

2023

5

Active Server Pages (ASP), ASP.NET

26/21

2023

5

VBScript/JavaScript/HTML

26

2023

5

C/C++/C#.NET/Java

20/15/19/5

2023

4

Powershell, BASH

6

2023

4

COBOL, JCL/ECL, REXX, DYL-280, ADAMINT/ADAPREP

16

2000

5

NATURAL

8

2003

5

Level (LVL): Scale used is 1 to 5, with 5 being the highest.

5 = Expert level knowledge; can train and mentor others

4 = Excellent working knowledge; can function independently

3 = Good working knowledge and experience; can function well within a Team

2 = Some work experience; beginner/intermediate; may require direction / assistance

1 = Education Only; beginner; would require direction and assistance

Contact this candidate