Project Manager Business Analyst
Resume:
AN-LUNG (STEVE) LIN
**** ** ***** ******, *******, WA 98011
Phone: 253-***-****
Email: ***************@*****.***
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