System Design
Resume:
LIN YU
***.**.**@*****.***
Hands-on senior level data professional with client-facing business skills.
EXPERTISE
Data Modeling Database Design & System Analysis and
Development Design
Data Analysis Business Analytics Performance
Architecture Optimization
Software Project Strategic Planning Research & Development
Development
COMPUTER & SYSTEM SKILLS
Programming Languages PHP 5, Perl 5 (DBI/DBD), Apache/2.2.0, C, C++,
HTML, Visual Basic, Shell, SQL, PL/SQL, SybPerl,
Transact-SQL, Open Client DB, TCL.
Databases & Tools MySQL 5, Oracle 9g, Sybase, Berkeley DB
(Sleepy Cat), Access, Ingres, ERWin 7, SOA, TOAD
9, ETL.
Platforms and Operating Systems Linux/Fedora, Unix, Solaris, HP-UX,
SunOS, FreeBSD, Windows XP.
SELECTED ACCOMPLISHMENTS
SR. DATA MODELER & DATABASE DESIGNER, SYSTEM ARCHITECT, ANALYST
Stinger Technology, Ltd.
2004 - Present
Stinger Technology provides IT consulting services in infrastructure,
software design and development, e-commerce and information technology
project management, business processes, financial applications, and
information systems.
. Responsible for overall IT strategy, infrastructure planning and
implementation, and team building. Overseeing design, development,
testing and delivery throughout project life cycle.
. Responsible for data analysis, data modeling, database design,
development and performance tuning.
. Led and developed the data model, database design and its
implementation, and the conceptual framework of web-based OLTP systems,
including the specifications of the business, architectural and high-
level requirements and designs, OLAP design and DW (data warehouse)
analysis and reports, ETL design.
. Led the overall design of an e-commerce system on LAMP platform.
. Designed and implemented a rule-based double-entry financial accounting
journal component for an in-house e-commerce system that allocates
funds to all relevant parties and accounts based on business rules.
Also designed and developed a data warehouse for it, with an analytical
reporting module.
. Designed and implemented an analysis and reporting component for
financial systems.
. Member of a team that did the conceptualization, data modeling, and
design of a Labour Scheduling system, and of a POS (Point of Sales)
system.
. Member of a team that did the design and development of a healthcare
organization web system.
. Member of a team that did the conceptualization, data modeling and
system architecture design of a shopping card sub-system.
. Technical Tools: Linux, Perl 5, PHP 5, ERWin 7, MySQL 5, Oracle, SQL,
HTML/HTTPD, Shell, SOA.
DIRECTOR OF DEVELOPMENT, ARCHITECT
EBPM, Inc.
2002 - 2004
EBPMI provides enterprise business process management solutions that
enables enterprises to quickly and easily adapt and respond to the ever-
changing business environment to meet their business challenges and to
succeed. The EBPMI solution is based on EBP, a software system that was
developed in house.
. Developed the business process management system data model, process
flow, and the system conceptual framework, including the specifications
of the architecture and high-level requirements.
. Responsible for the overall EBP system architectural design. Led the
development, and achieved the targets on time. Designed and developed
the server backend database.
. Designed and developed a web-based return merchandise registry system,
including its two-tier database system (for better real-time
performance), prototype, designed and executed performance test and
tuning.
. Technical Tools: Solaris (Unix), Perl/CGI, DBI/DBD, C/C++, SQL, Oracle
9g, PL/SQL, LDAP, HTML, ERWin 4, Visual Basic, SOA, TOAD, Shell.
SENIOR MEMBER OF TECHNICAL STAFF
Trendium, Inc.
2000 - 2002
Trendium provides an OSS intelligent network assessment, assurance and
provision software system solution for telecommunication service providers.
. Member of a team that was responsible for R&D on a network assessment,
assurance and provision software system. Major responsibilities
included leading the repository component database architecture (as the
database architect) and functional design and development, the
Information Model. Innovating new techniques for problem solutions.
. Responsible for data modeling & database design, and data warehouse.
Implemented a VLDB (Very Large Data Base), solving many technical
problems along the way. Instrumental in improving the data repository
performance, initially by 600%, and then by another 350% over the
already improved performance.
. Made many technical contributions to the architectural and functional
design and processes, and implementation of various components using
analytical and problem solving skills. A solution provider.
. In charge of company's patent evaluation, writing and filing process,
personally written and filed five patent applications, of which two
have been granted. Performed research on network OSS systems.
. Technical Tools: Solaris (Unix), C Oracle 9g, SQL, PL/SQL, ERWin
4, SOA, TOAD, Shell.
MEMBER OF TECHNICAL STAFF (MTS)
Bell Labs, Lucent Technologies
1999 - 2000
The research and development wing of former AT&T and later Lucent
Technologies, which was a $14B telecommunication company with facilities
around the globe. It was formerly known as AT&T Bell Labs, Murray Hill, NJ.
After 2006 merger with Alcatel, the total annual revenue for Alcatel-Lucent
was $24.5B.
. A key member of a team that was responsible for research and
development on network usage information collection and usage-based
network billing. The team also consisted of developers from the
business unit whose focus is on product placement and marketing.
. Designed and implemented a prototype for the Net Mediator which is a
key component of the network usage information collection and usage-
based network billing system. Net Mediator analyses and aggregates raw
data into a concentrated and refined form that is more palatable for
network billing, services and various types of data analysis.
. Designed and analyzed many time-consuming performance tests in order to
study the characteristics of the underlying software system, which
allowed for fine tuning of software system parameters and modification
of its underlying data structures, algorithms, and database designs to
achieve more efficient real time performance.
. Analyzed network traffic data en-mass, to find usage and traffic
patterns to be abstracted into the data model and to be utilized in
network billing structures.
. Published a paper on task scheduling in Algorithmica, a highly regarded
international technical journal.
. Technical Tools: Solaris (Unix), C Oracle 8, SQL, PL/SQL, ERWin,
Shell.
SENIOR SPECIALIST
Fleet Technology Solutions
1996 - 1999
The technological division of Fleet Financial Group, which develops,
operates and maintains all of the computing systems for all functions and
organizations of the $45B organization (It became Fleet Boston Financial
after merging with Bank of Boston, and in 2004 Fleet Boston was acquired by
Bank of America).
. Analyzed and implemented the process flow and the design of some of the
interactive call center systems and their underlying operations,
including database modeling and design and development.
. Led a four-month Y2K project for the telephone banking systems owned by
the project team. Planned the methodology, created execution plan and
coordinated its implementation to eliminate potential Y2K bugs from the
banking system. Delivered two weeks ahead of schedule.
. Responsible for a major revision of the Small Business Credit
Application system, which required first extensive debugging of the
entire existing problem-prone system, then revision according to new
business requirements and financial process, created technical system
and process requirement document, then designed and developed the new
version. (Between the time of production deployment and my departure,
never received any problem ticket from business division and bank call
centers.)
. Technical Tools: Windows NT, Visual Basic 6.0, SQL, Solaris, C
Oracle 7, PL/SQL, TCL, ERWin.
DATABASE ARCHITECT & LEAD ANALYST
Logic Technology, Inc.
1992 - 1996
A privately owned consulting firm which specializes in software system
development and computer operations. Contractual project work with
companies such as GE, Coca-Cola, Kodak, government (State of New York) and
various financial institutions.
. Lead database modeler and architect for a large-scale CAD engineering
design and analysis system for steam turbines, done for GE Power
Generation Division (Schenectady, NY).
. Designed and implemented large-scale CAD relational databases and a
process of automated creation of database wrap library to provide OORDB
access methods.
. Designed and implemented various modules/programs for the CAD system.
Designed and implemented a database administrative and security system
including its GUI. Developed various database diagnosis and maintenance
tools.
. Designed and implemented systems for various other related projects,
such as data migration procedures and implementations, steam turbine
component designs, among others.
. Technical Tools: HP-UX, C, Sybase, SQL, Transact-SQL, Shell.
SENIOR PROGRAMMER / ANALYST
New York State Department of Health
1992
. Designed and developed a large-scale relational database for Medicare
Reimbursement System for all health care facilities in the New York
State.
. Designed and developed some major components for a Medicare
Reimbursement System for all health care facilities in the New York
State.
. Technical Tools: SunOS, C, Sybase, SQL, Transact-SQL.
ASSISTANT PROFESSOR
University of Albany - State University of New York
1991 - 1992
. Taught senior level and graduate level Database courses and Operating
System courses.
. Supervised graduate students' Master Degree projects and thesis works.
SUMMARY
Accomplished IT professional of broad research, modeling, design, analysis
and R&D project experience. Excellent analytical skills and solution
provision. Self-starter. Team and project leader. Attention to details.
Expertise in business application customer requirement analysis, business
analytics architecture, data analysis, data architect, data modeling,
database design, implementation and optimization, software system design
and implementation, system optimization, system architecture. Good
understanding of Software Life Cycle and OOD. Concept development,
prototype building. Fertile creative thinking & work, patent writing and
filing experiences. Unique mathematics and computer science background.
Excellent verbal and written communication skill. ... an "idea man" ...
Ph.D.
EDUCATION
University of Albany - State University of New York Ph.D. -
Computer Science
University of New Paltz - State University of New York B.A. -
Computer Science
OTHER ACCOMPLISHMENTS
. Inventions:
o Inventor of three (3) U.S. Patents
- USPTO Numbers: 6,795,821;
6,892,199; and 7,693,845.
o Inventor of two (2) pending U.S. patent applications.
. Publications: Extensively published in leading computer science
technical journals including SIAM Journal on Computing, IEEE
Transactions, ACM Transactions, Algorithmica, Acta Informatica, Lecture
Notes in Computer Science, ACM SIGMOD PODS (Principles of Database
Systems), among others.
. Honours: Presidential Distinguished Doctoral Dissertation Award
(sole award in College of Science & Math that year), College's Honors
Degree, National Honors Society, Magna Cum Laude, Outstanding Senior,
Gerson-Robison Award, Dean's List of Distinguished Students (eight
semesters).
PERSONAL INFORMATION
. Member of Sigma Xi (a scientific research community association).
. Member of Association for Computing Machinery (ACM), SIGMOD (Special
Interest Group on Management of Data).
. U.S. citizen.
Contact this candidate