Web Analyst

JOAN DU

**** *** ******* ****, *******, TN *****

Phone: 901-***-****

Email: goily9@r.postjobfree.com

PROFILE

A result-oriented Programmer Analyst with eight years extensive experience in

developing, analyzing, and implementing complex large-scale information systems

and on-line applications. Proficiency in database design, develop and analysis

in fast-paced environments. Exceptional knowledge and expertise in web-based

application development. Well-developed organizational skills, problem-solving,

multi-task, and competence under pressure in highly complicated situations.

TECHNICAL SKILLS

LANGUAGES/SOFTWARES:

ASP/ASP.NET, ADO/ADO.NET, IIS, MTS, JavaScript, Crystal Report, HTML, CSS,

FrontPage, PhotoShop, VB/VB.NET, VBScript, C, C++, Java, Visual Studio,

Visual, InterDev, COBOL, VISIO, MS Project, MS Excel, VLookup, Pivot Table

DATABASES:

SQL Server 2005, SSIS, SSRS, SSAS, Data Warehouse, Data Mining, T-SQL Script,

SQL Server 2000, DTS, OLAP, OLTP, Oracle, MS Access, VBA Scripting

OPERATING SYSTEMS:

Windows 95/98/NT/2000/XP/Vista, Unix

PROFESSIONAL EXPERIENCE

ROBERT HALF TECHNOLOGY (2010–Present)

Consultant

Crystal Report Writer

* Intensively Worked on data from financial system.

* Extracted data to MS Access, manupulated, designed and created crystal

reports for Health Insurance Program, Long Term Disability Program,

Retirement Program, Investment Loan Program and Growth Income Fund Report etc.

SSRS Report Writer

* Worked on financial and accounting data from CMS (Content Management

System) and Softrax (Revenue Cycle Managemetn Solutions System).

* Extracted data to SQL Server, designed Accounting Receivable Aging Report,

Invoice Statement, Monthly Revenue Report etc. for top management using SQL

Server Reporting Services.

* Extensive excel experiences with formulas, functions, sort, filter, vlookup

and pivot tables.

ACXIOM CORP.

Memphis TN (2007–2009)

DECISION SUPPORT ANALYST (DATABASE PROGRAMMER ANALYST)

* Provided professional consulting and information services to banks,

insurance and financial clients. Conducted projects including weekly

on-boarding, direct marketing campaign, campaign tracking, history

promotion, and ad hoc researches.

* Experienced overall schema designing and modification to multi-client

database systems to assure high productivity and efficiency.

* Designed and developed databases, tables, SQL queries, stored procedures

and views for new clients; proficiency in advanced T-SQL scripts, batches,

SSIS integration services and SSRS reporting services to automate complex

process.

* Extracted data from data sources including OLE DB source (Access, Oracle,

DB2 and SQL Server), excel and flat text files. Designed stored procedures

and T-SQL scripts to transform extracted data to fit operational needs, and

loaded into database in SQL Server.

* Designed codes and implemented a variety of marketing campaigns using

effective segmentation and fulfillment models to approach target customers

and grow clients' business.

* Designed and generated various campaign tracking result summary reports,

exported to PDF, Excel or Text files using SSRS reporting services to analyze

customer responses to marketing programs with focus on sales, incremental

sales, and profitability.

* Well-developed organizational skills, identifies work plans, considers

priorities, forecasts problems, and envisions solutions. Provides competence

under pressure in highly complicated situations. Follows up efficiently.

ARCHER MALMO INC.

Memphis TN (2005–2007)

DATABASE PROGRAMMER ANALYST

* Provided information services to multi-client via direct marketing

campaigns, conducted professional database design, development, analysis,

problem-resolution, and process development.

* Experienced and skilled in large-scale database design, stored procedures,

views, transactions, locks, index, advanced SQL queries, linked server,

DTS package design, and jobs scheduling.

* Extracted, transformed and loaded data into SQL Server from various data

sources, including Access, DBase II, Oracle, Excel, and Text files.

* Processed lists for client promotional mailings using DTS packages and

manually created databases and tables; exported lists to .dbf files and

transferred to client’s ftp sites.

* Conducted data analysis for back-end reporting, including detailed summaries

of sales, overall revenue, Return on Investment (ROI), and sales conversion.

THYSSENKRUPP ELEVATOR MANUFACTURING

Memphis TN (2003–2005)

PROGRAMMER ANALYST

* Solely responsible for design and development of integrated client-server

web-based Global Projects Reporting System and e-Procurement Management System.

Online Reporting System greatly reduced operating cost and improved efficiency.

E-Procurement Management System gained visibility and control over corporate

purchasing and expenses. They had been highly appraised by President of Thyssen

Northern American and widely used within organization and its affiliated

companies.

* Gained in-depth understanding of application development full life cycle,

including prototype design, specification, coding, testing, implementation,

documentation, user instruction, training, and technical support.

* Provided all programming and analysis support for top management and internal

departments on their decision making process using variety of programming

languages, tools, and technologies.

* Extracted data from Mainframe and other format of data files from MS Access,

Text, and Excel, manipulated and analyzed data in SQL Server and exported to

various formats using Data Transformation Services.

* Developed automatic sales quotation system in Excel using VBA scripting,

macro, and Excel functions.

COMPREHENSIVE MARKETING INC.

Memphis TN (2001–2003)

APPLICATION DEVELOPER

* Designed and developed various online applications for multi-client to

implement full functional and user-friendly E-Business solutions used by their

business channel partners.

* Generated back-end databases used in applications; employed normalization to

purify data.

* Developed proficiency in Crystal Report design, web application development

life cycle and object-oriented programming technique.

SIEMENS (CHINA) LTD.

Beijing China (1992–1998)

PROJECT MANAGER

* Directed project planning, promotion, customer liaising, contract bidding,

negotiation, implementation, and customer support.

* Gained specialty telecom industry knowledge, especially switching network,

wireless mobile network, GSM, and CDMA systems.

* Managed customer relation, product promotion, advertising and exhibition,

trades shows, and large turnkey projects bidding in the fields of switching,

transmission, mobile network, cable, and microwave projects.

EDUCATION

Master of Science, Management Information System

University of Memphis, Memphis, TN

Contact this candidate