Design Data
Resume:
Title:Technical Team Lead
*****.***@*********.***
Document
Source below
NAME: F Lin
ADDRESS:
CITY: Roseville
STATE/PROVINCE: MN
ZIP/POSTAL CODE: 55113
COUNTRY: USA
EMAIL: *****.***@*********.***
PHONE: 612-***-****
CANDIDATE ID: N/A
CITIZENSHIP: US
Citizen
EDUCATION: Not Entered
EXPERIENCE: Not Entered
WILL RELOCATE: Not Entered
RELOCATION INFO: Not Entered
JOB WANTED: Not Entered
HOMEPAGE:
COMMENTS:
HOTSKILLS:
ESUME
F Megan Lin
1963 Eldridge Ave W
Roseville, MN 55113
*****.***@*********.***
SUMMARY
Extensive experience and knowledge in Information System with
emphasis
in the Data warehousing and database administration.Strong skills in
data
warehouse design, ETL development and replication process optimization
as well as database design, development and administration.
WORK EXPERIENCE
Technical Team Lead
November 1998
- CurrentReliaStar Financial Corp
.
Minneapolis, Minnesota
Technical lead of the Data Warehouse team.My main responsibilities
are to create project plan, define the mapping specifications, design
ETL
modules, develop ETL mapping, tune ETL processes and ensure the
process meeting the services level.Other responsibilities include
creating
ETL development guideline, mentoring other divisions to design ETL
process, providing leadership to determine enhancements to release
projects and managing the data warehouse team.
Design, develop and optimize data warehouse replication processes
for
ReliaStar Consolidate Data Store.The processes replicate data from
various legacy systems located nationwide to the data warehouse in
Minneapolis.
Define ETL mapping specifications with mainframe developers,
identify
data issues with business analysts, use Informatica Power Marts tool
to
develop ETL processes and coordinate project migration procedures.
Support and enhance replication processes which are coded by Perl,
Unix
scripts and Sybase stored procedures.Design procedures to manage the
records rejected by ETL processes.
Database Administrator/Database Developer
August 1997
- November 1998
Office of Secretary of state, State of Minnesota
St. Paul, Minnesota
Design, develop and maintain several SQL Servers for the Secretary
of
State.My main responsibilities are database design, database
management and database administration for Fiscal, UCC, Image
Systems, Notary and Business Services.Other responsibilities include
providing guidelines for application developers and acting as a
liaison
between outside consultants and upper management.
Database design includes logical and physical database design,
physical
database modeling and data migration for all SQL Servers.
Database administration activities include: SQL Servers
installation,
upgrade and configuration on Window NT platform, database performance
tuning, database usage monitoring, database consistency analysis,
database security, and backup procedure.
Database management involves system troubleshooting, maintaining
database integrity, rectifying damaged databases and database
optimization.
Assist upper management in defining business objectives in
client/server
environment.Plan and implement the business processes in client/server
application.
Assist database users in defining data structure for database
programming, with complete documentation.Provide technical supports
to
group member in database programming and database implementations.
Assist application developers with data mapping and data flow
process
design from MAPPER to SQL Server.Provide application teams with
database management expertise and guidelines.
Fiscal Application Design achievement award by the Secretary of
State,
Joan Growe, in 1997.
UCC Application Design achievement award by the Secretary of State,
Joan Growe, in 1998.
Achievement Award for Outstanding Work by the Minnesota Association
of Professional Employee (MAPE) in 1998.
System Programmer
June 1993
- August 1997VTC, Inc
.
Bloomington, Minnesota
Designed database in Oracle RDBMS and created SQL programs to
analyze real-time industrial parameters to control overall
manufacturing
process of semiconductor production.
Created statistical analysis software in PC platform using Microsoft
ACCESS, Visual Basic and Excel for generating graphical reports.This
software provides engineers with information to perform product yield
enhancement, quality control and diagnostics.
Developed Pascal programs in VAX/VMS to transfer test data from
semiconductor testing equipment to computer system, and convert test
data from binary to ASCII format.Designed database in FOCUS to store
and analyze test data.
Provided technical support and in-house training to computer users
on
developed and commercial software.
Application Programmer
University of Minnesota
December 1992
- June 1993
Designed and maintained computer programs in support of financial
audit
process for University auditors in Electronic Data Process (EDP) unit
in
Department of Audits.
Provided training and technical supports to staff members on
computer
hardware and software such as Microsoft Windows, Lotus and PC
hardware.
COMPUTER EXPERIENCE:
Database Systems:
MS SQL Server, Oracle/RDBMS, Oracle/DBMS, MS ACCESS, FOCUS
Database software:
Informatica Power Mart, Brio
Operating Systems:
UNIX, Window NT, Window 95, VAX/VMS,DOS, Macintosh
Computer Software:
Visual BASIC, Excel, Lotus, Microsoft Word, SAS, SPSS
Computer Languages:
SQL, Visual Basic, Pascal, Fortran, C
EDUCATION:
Bachelor of Art
in Computer Science, December 1993, University of
Minnesota,
Twin Cities
d
Contact this candidate