RESUME OF: LAWRENCE S. LIN

PRESENT POSITION: Manager, Transformation Services (Healthcare consulting)

YEARS OF PERTINENT EXPERIENCE: Seventeen (17)

MS, Health Systems, Georgia Institute of Technology, with focus on Internet, info systems & databases

BS, Industrial and Systems Engineering, Georgia Institute of Technology

• Designed an automated tool that is the key component for entire company's HIPAA assessment consultants. Created it using Visual Basic and Microsoft Excel, which interfaces remotely with Allaire's JRun Java server, loading massive data into MS SQL Server 7.0, to be presented in Windows NT and Internet Information Server (IIS). The tool drastically reduces amount of time the consultants and clients need in order to complete the HIPAA readiness assessment, aggregates critical information from multiple stakeholders in a data-mining approach, covers all of the HIPAA regulation-affected entities (e.g. projects, programs, organization, vendors, partners, identifiers, transactions, codesets, systems, applications, networks, contacts, proprietary data). Completed this tool with minimal assistance and time consumption.
• Served as system administrator for the NIKU HIPAA Assessment system (www.niku.com for more detail), SQL Server 7.0 DBA, NT administrator, inhouse MIS staff for the Atlanta office consultants, and Crystal Reports developer.
• Developed customized HIPAA compliance reports for the largest of all Blue Cross / Blue Shield plans. Used Crystal Report 8.0, tapping into multiple simultaneous MS SQL Server 7.0 ODBC data connections, generating several sub-reports / summaries / grouped lists using intricate VB and CR codes. Single-handedly produced 20+ critical reports in short amount of time with minimal technical assistance. Saved the project from cost overrun and client dissatisfaction, and directly contributed toward the consulting team's ultimate findings and recommendations.
• Created a vendors / competitors / partners database for the company's entire consulting workforce. Lead all designs in ER (entity relationship) diagrams, user identification, technical architecture, implementation alternatives, maintenance plan, multiple beta versions development (by myself), user feedback, and initial data conversion / population. Created this on the quick, pervasive and powerful platform of Access, and shared the resulting HTML interactive pages on the company LAN for broad access from anywhere in the VPN.
• Thoroughly analyzed the market requirements and functional details for an international medical devices company, for its chronic pain internet portal. Designed the technical architecture, identified customer needs, itemized all of the necessary and desirable functions, created a beta site for this site based on ICD-9 diagnostic codes, IASP chronic pain codes, and CPT procedures. Led a team of website programmers to rapidly and systematically create all technical and content details, including site map, features list, testing script, on-site demo environment, code sharing, and accompanying documentation. Achieved the results in several short week's time.
• Helped a national mortgage lending company to analyze Chinese internet user pattern. Recommended an outreach plan to the Chinese internet users, based on search engine listing, advertising on selected sites, and outward comparison to the organization’s international competitors.
• Assisting a well-established mid-western investment bank to re-create its corporate website to fulfill strategic goals re-alignment -- online stock and funds buying/selling, decision intelligence for end users.
• Leading the Technical Team : 3 staffs; focusing on Microsoft technologies.
• Creating new dynamic functions - SQL Server 7.0 database back-end support, Javascript, Java applets, Active Server Pages (ASP) codes development, Windows NT 4.0 server, IIS, Index Server, strong authentication process, entire website's technical design (e.g. content management, web server, application server, clustering design, monitoring tool, log tracking, etc.)
• Working with all other internal teams (Page builders, creative design, content, information architecture, testing/QA, project management, team executives) to integrate technical decisions with other requirements. Acting as technical consultant to internal co-workers. Overall team: about 30 staffs, 3 million dollars revenue project.
• Documenting the new site's technical architecture, detailed functional specifications, technical specifications, project plan, technical briefs, and other key documents.
• Provided technical strategic consultation to Germany's largest conglomerate that serves global consumer and industrial customers.
• Analyzed their current database design, for appropriateness as a back-end, high-volume, and secured data source for their global corporate website.
• Single-handedly presented to all of their divisions and the top Corporate communications officer regarding cost-benefit analysis of different technological architectures.
• Made proposal regarding resource allocation, technological obstacles, growth paths, on-going maintenance, managerial issues and budgetary/licensing issues in web-site re-launch project.
• Worked extremely rapidly in bi-lingual environment to ensure accurate information retention during the translation and analysis processes.
• Assisted a pre-IPO insurance information systems vendors to implement their systems, which is based on Oracle database, Java language, n-tier environment and optical character recognition.
• Represented this vendor to the nation's largest capitated health plan's Pacific Northwest regions. Slated to single-handedly lead technical development for their Mountain states' plans.
• Performed testing procedures for this new Java application for version approval.
• Provided consulting, staff implementation, and other miscellaneous services to a fast-growing pre-IPO company. Drastically reduced time-to-implementation in most cases by at least 60% of time.
• Developed a technical architecture for the new sales information systems, for the national sales process of the nation’s largest capitated health plans.
• Collaborated with the business process specialist to identify the entire sales process: RFI (brokers’ request for information) surveys, RFP (request for proposal), rates generation, proposal formalization, census mapping, and membership installation.
• Jointly developed a three-tier architecture with other technical experts: data layer, business logic layer, and presentation layer.
• Focused on assessment on data quality, data structure, elements definition, and vendor selection (IBM DB2, Oracle, Sybase, and Microsoft SQL Server), for web-enabling capabilities.
• Microsoft SQL Server 6.5 DBA (Database administrator) for a mid-western hospital
• Drafted many procedures, policies and instructions to create a DBA binder for the client to use.
• Performed all backup (dumps), archive, import, security setting, performance measurement and remote access (RAS) tasks.
• Assisted in a Ceridian payroll information system’s implementation, acting as the client’s SQL Server technical resource.
• Intranet/E-Commerce Strategist for a west-coast regional HMO
• Produced three primary deliverables: Intranet Strategy, Content Model, and Technical Architecture.
• Studies the business units strategically to align operations with intranet needs/opportunities: resources (people, skills, budget, IT tools, information), processes, priorities, timeframe, current environment, vision.
• Conducted interviews with company’s executive team, including CIO, CFO, CMO, CEO, VP of Operations, VP of Marketing and Sales, Chief Counsel, and VP of Human Resources.
• Produces comprehensive results in very compressed amount of time (eight weeks). Strategy’s planning horizon is 18 - 24 months.
• Goal is to assist the client to maintain top ranking in customer service, reduce administrative costs, and improve close ratios during sales cycles.

• Project Management Consultant for an University-based Health Plan
• Maintained a Microsoft Project 98 project plan for IT network conversion for 4 major campuses, 19 buildings, 58 network closets. The project was complex and intense: There were 3000 total tasks, 10+ resources, and a 6-month project duration.
• Worked with the project manager to develop a highly standardized structure for the project plan, using common tasks and multiple-plan integration.
• Helped to create a network cabling RFP for the client in 1 week’s time.
• Prepared documentation binders for status report and resources accumulation.

• Internet Consultant for a major national HMO

• Assisted in the Internet Architecture Standards authoring process, focusing on internet management section: clustering, reporting, and fault tolerance.
• Assisted in the Intranet Policies and Procedures authoring process, worked with the intranet webmaster.
• Automation of Intranet project requests into database and email.
• Participated in the Internet Provider Directory project to represent the requirements for internet server (IIS) and database (SQL Server) integration.
• Co-led the entire Internet Formulary project, from exploratory stage to meeting facilitation, documentation, knowledge dissemination, requirement definition (database and web navigation), internal change management process submission, programming oversight, and resource planning.
• "HealthWise" deployment on intranet and internet (a member-education software) - implemented search function using Microsoft Index Server, regularly updated the authentication list of all eligible HMO members, and assisted account managers to sell this benefit to the employer groups.
• Weekly maintenance for client websites:
• Uploaded all current 3.4 million members into a membership authentication table in SQL Server database.
• Updated all of the plan’s providers’ information (3100+).
• Provided a list of all job openings across different regions.
• Updated all brokers’ information in different states.

• Internal Intranet Consultant for Healthcare Consulting Company
• Made process improvement recommendations for the company Intranet site that serves 1000+ employees spread out in 2 continents, hundreds of separate dial-up or LAN locations, and offering intricate security authentication solution based on Microsoft platform (IIS, NT Server 4.0, SQL Server, legacy systems, Office Suites documents).
• Independently conducted interviews with VPs, directors, hands-on staffs and Intranet development staffs. Synthesized the results into critical summaries.
• Project Manager for Computing Services Company
• Coordinated the process of collecting and creating company operating standards.
• Coordinated QC/QA processes for all products - overseeing progress, providing guidance. Drafted Q policy and flowcharts and designed database for problem tracking.
• Led teams of international programmers in many projects.
• Led project for Student Information System (SIS) conversion for 1800 schools in the state of Georgia.
• Developed a proposal tracking database to keep track of assignments, timelines, meetings, and designed accompanying flowcharts to work in conjunction with it.
• Developed a daily report system that pulls first-hand reports (progress, problems plans) from staff members to produce a monitoring mechanism that manages projects directly and closely.

• Owner, consulting firm for internet development and relational database development
• Developed and maintained internet and intranet websites for small businesses.
• Developed Microsoft Access 2.0 and Access 97 databases.
• Provided digital photography services for a medical research client.
• Lead process on ISO-9000 (and ISO-9002) quality certification for client company.
• Assisted in language translation, product localization, import/export and OEM contracts.

• Director, Continuous Improvement (Internal Consulting) for a national HMO
• Led inter-departmental improvement effort among Sales, Underwriting, Configuration, Enrollment/Billing, ITS and Customer Service to reduce ID card time requirement and lost trackability.
• Monitored workload through networked information, leading to business process redesign efforts.
• Tracked enrollment variations.
• Automated monthly renewal process.
• Assisted the Customer Service department in developing monthly control charts for call centers for 20 health plans in 18 states, to handle customer grievances and appeals with Microsoft Access databases.
• Worked with Customer Service department on ID card production/distribution, membership packet procurement process, space layout, and staffing requirement.
• Assisted in data extraction and export process in Amysis information system.
• Assisted Small Business Unit with automating the monthly renewal process and daily quoting process.

• Internet/Intranet Specialist, and MIS Department Analyst
• Designed comprehensive Intranet documentation repository system based on Network Navigator 3.0 and Microsoft Access 97.
• Repaired computer hardware.
• Installed new software (Windows 95, Office 97).
• Formed information system strategy for internet/intranet systems.

• Director of Membership Services for a non-profit medical information society
• Led market trend in early CHINs (community health information networks) and internet-based health information systems.
• Refined and partially maintained an internal database that maintains the 700+ organization who utilized health information networks (HIN), which database was later published as a national directory for open data-sharing purpose.

• Technical Coordinator for a national health information systems vendor.
• Primary technical contact for 3rd party vendors.
• Designed and implemented the Reuter Terminal (multimedia Ethernet workstation).
• Designed multiple internal and external business processes (vendor relations, software revision, warranty and maintenance program).
• Desktop rollout: Coordinated the effort to integrating and deploying desktop PCs, including hardware, software, performance optimization, vendor selection, mass configuration, unique identification, outsourcing, contracting, pricing, marketing, network.
• Assisted the sales department in developing a sales tracking system that relies on current legacy information system without costly and lengthy development (RAD, rapid application development).
• Led the effort to specify the technical requirements for new software that automatically detects the PC’s peripherals’ communication speed and internal CPU processing speed.

SKILLS:

• Technology planning: 3-tier web architecture (data, business logic, presentation), security (encryption, SSL, token, certificate, biometrics), strategy-to-technology alignment, software development process, technical project planning, vendor selection methodology, script platform selection (ASP, Java, CGI), server planning (reliability, disaster recovery, redundancy, scalability, interoperability, environmental factors, usage forecasting), knowledge management
• Software: Microsoft Windows (Windows 2000, 98, NT 4.0 Workstation, NT 4.0 Server, 3.1, 3.11, Workgroups, 95, Chinese), SQL Server 6.5 / 7.0, Internet Information Server (IIS), SourceSafe, InterDev, Office Professional (Access, Excel, Word, Powerpoint, Mail, Publisher, Outlook, Project), Frontpage, Works; Oracle; Sybase; IBM DB2; Informix; Crystal Reports 8; Allaire JRun (Java server), JDK (Java Developer Kit), WebLogic full-text search, Act! for Windows; Netware 3.x client; MiniTab, Statistica, GPSS/H; Photoshop, Correl Draw.
• Hardware: Server room operations, PC performance optimization, upgrade and diagnosis. Network development (Ethernet, client-server, wireless LAN, cable modem, DSL), CD-ROM production, video editing systems, digital photography, graphics scanner, video conferencing, PCI devices, satellite transmission, telecommunications, telemedicine, medical imaging, EDI, OCR.
• Business skills: Strategic planning, project management (using Microsoft Project 2000), financial reporting (accounting principles), resources theory, re-engineering, FOCUS-PDCA, certified ISO-9000 lead auditor (granted by Center for International Standards and Quality, CISQ), meeting facilitation, executive interviewing, brainstorming, active listening, public speaking skill, motivation; industrial & systems engineering tools (sampling, statistics, forecasting, inventory, flowchart analysis, process improvement, simulation, layout design, queueing theory, regressional analysis, etc.), empowerment, diversity utilization, ownership