R E S U M E

Nasha Aijun Huang

***** ********* ****, ******, ** 46033

317-***-**** (h), 317-***-****(o), abl512@r.postjobfree.com

Highlights: Sr. System Analyst/Associate Information Consultant with over

25 years' hands-on experiences in Data Analysis, Business Analysis, Data

Process/Work Flow Oriented Application (Win/Web) System Design,

Development, Testing, Data/System Integration, Deployment, Reporting

System Development, Data Integration Tool Administration/Training, plus

System Support.

Summery of Qualifications

. Work with business /customer to collect business requirements, create

validation document, propose system architecture design for project

. Provide legacy system/data analysis, inspect business reality, collect

business information to support project proposal

. Design, develop and maintenance of globalized data driven information

integration/management system using combined technology

. Create integrated data view, data reporting system, web services as

interface of data warehouse to support management decision making and

project teams

. Design, develop window/web applications to enable capability on data

retrieving, analysis, mapping, validation and publish to support

business process

. Design, develop front-end interface ( win/web) to extend the function

of reference database

. Administrate data analysis/process tool, monitoring system running

status, provide training/coach to power users

Technical Skills

Platform and Tools

. Platform: Window 2000, XP, Vista; Unix, VAX/VMS, Linux

. Software: MS Visual Studio Team Development 2008, MS Office, MS SQL

Server Visual Studio 2008 (SSIS/SSRS/SSAS/SSMS), ASP. Net, ADO.Net,

VB. Net

. Database: Oracle, Oracle Advanced Queue, Oracle Client (TOAD,

sql*plus, SQL*Loader),Oracle DBA (DDL, DML), Access, SQL Server 2008,

PL/SQL, SQL, Microsoft Team Foundation Server

. Application Development: .Net, ASP, XML, C#, Java, JSP, C, C++, HTML,

AJAX, VB.Net, PERL, CGI, SAS, Fortran, SQL Server -

SSIS/SSRS/SSAS/SSMS, Informatica, Sunopsis, Mercator, Excel, TOAD,

SQL*Loader, Power Designer, WSAD, J2EE, eclips, NetBeans, Rational

Rose, Documentum, MS Sharepoint, Spotfire, Dreamweaver, ColdFusion

. Others: MS Project Management

Professional Experience

Associate Information Consultant

Eli Lilly and Company - LRL R&D IT (1/2/2008 to present)

. Designed, developed InVivo data access/process systems to load

company internal and external generated in-Life study data from

different DM systems into data warehouse

. Provided business/data analysis for legacy system, created data

mapping document, data process specification document, formalized

data rules which are applied by ETL ( Extract, Transform, Load)

process to gain high quality of the data

. Utilized Oracle Messaging Management capability to allow data in XML

schema to be processed timely and correctly

. Created window based tool to monitor system running status using

email web service to send notice to resources, linked to web

application to view integrated data report

. Created web based data reports with input parameters to allow study

owner to query, retrieve, view all related data with other

supporting information

. Created data warehouse web services to support other data consumer

and applications

Sr. System Analyst

Eli Lilly and Company - Discovery IT (1/31/2000 to 1/2/2008)

. Designed, developed application to provide data integration service

with data analysis, conversion, aggregation, merging, joining, and

normalization capability to support research data management

. Created data quality control (QC) templates based on business rule

and data integrity relationship. Templates are used by authorized

users to generate data processing files in consistent format

. Designed, developed web application to provide on-line service to

customer for item searching, ordering and status checking capability

plus data reporting system to support management investigation

. Worked on data modeling on legacy RDM system to enhance the data

integration capability and implementing the enhancement based on new

business requirements

. Designed, developed window application to provide one-step service

to allow commercial information ( data in big volume) to be

accessed/read/merged/validated/loaded into the data warehouse

. Designed, developed web based application to provide QC capability

on molecule structure data. Web application is accessed by scientists

cross domain

. Served as product management board member to bridge project team and

vendor product committee; accelerated fully transparent

communications in between; found any issue/bug/change request that

project teams have on product; help find solution or report to vendor

. Implemented enhancement of legacy system to allow batch data loading

and graphic/image file publishing on InVitro study data

. Designed, developed, published multiple data web services to

applications based on system requirements which provided instant data

service to applications in consistent and secured manner

. Led a project team to developed/delivered best practices on certain

pattern/procedures which are published on IT Architecture web site to

provide support to developers

Programmer /System Analyst Specialist

IU Medical Group, Indianapolis - Information System (1/19/1998

-1/29/2000)

. Designed, developed window system with the capability to analyze,

transfer, convert, and migrate data from legacy RDM system to new

RDM system. The system process can be monitored during the running

time via window interface

. Designed, developed application to collect requested information

on patients using C++. System is user friendly with Active

Controls. Data entered by user is moved to target database

. Worked as technical support to maintain system

. Provided data/ informational analysis on requested data format,

type, layout and usage, Analysis report is submitted to the

system administrator to support system enhancement implementation

. Designed and developed data IO utility using MS Access database

plus micros. Utility is used to enhance data process performance

. Provided assistant to DBA to monitor data processes/database

behavior, manage user, take users' request and resolve any issue

user reported

Data Processing Programmer /Analyst Specialist (III)

Department of Natural Resource, State of Maryland (12/24/1996

-1/17/1998)

. Designed, developed system to provide data access, reading,

convert, migration service on Mainframe (VMS/VAX operating System)

to move data from old VMX/VAX system to window- RDM system using

SAS, VB 4.0, and MS Access.

. Designed, developed client /server application to allow data

entry and process to be taken place in an automated way using

C++, MS Access, SQL Server ; System is with the capability to

process image files to GIS Database

. Designed, developed window application - graphic user interface.

System is used to retrieve and edit graphics from GIS Database,

also able to publish/ share enterprise meta data vai Web page using

OLE Data Cartridge, MS Access, Actview, CoreDraw 7.0, ASP

Programming Moduler/Ph.D. Candidate Student

Biological Engineering Dept. University of Wales, U.K (10/1991

-03/1996)

. Designed, developed computerized predictable working model l data

collection, conversion, and analysis. Program (C, FORTRAN) predictable

working models to simulate specially assigned ocean physical dynamic

movement. The model is used to support research on tidal and

estuarine water quality control in Bay area

Model Developer/Ocean Wave Forecaster

State Administration of Ocean and Atmosphere, China (10/1985 -11/1990)

. Participated design and development on Ocean Wave Forecasting model

. The Model is with the full parameter driven system to be able to take

input from both atmosphere and background environments, then provide

calculation, simulation, and forecast to developing waves

. The model is developed using Assembly and Fortran and run in VAX/VMS

environment on 8060-Large-Digital Computer Mainframe.

EDUCATION

10/1992-11/1995

Ph. D. Student Candidate In Computer Modeling, Department of Biological

Sciences, University of Wales Swansea, U.K.

Thesis: Computer Modeling on Tidal and Estuarine Water Quality.

10/1991-10/1992

M. Phil*, (M. Sc. Route to Ph. D) in Computer Modeling on Coastal

Environmental, Department of Biological Sciences, University of Wales

Swansea, U.K.

Thesis: Computer Modeling on Water Movement and Water Quality in Rivermouth

Area.

02/1978-02/1982

B.Sc. in Marine Sciences, Department of Environmental Sciences, Qingdao

University of Oceanography, Qingdao, China.

Note: * Being transferred to do Ph.D. Directly granted by the Academic

authority of University of Wales after finishing one year's M.Phill.

courses.

IMMIGRATION STATUS: U. S. Citizen

REFEREES : Available upon request

Contact this candidate