Project Manager Sql Server

Bill (Hui) Rong

Email: ********@*******.***

**** ********* **. ***** ***, Berkeley, CA, 94704

(C) 857-***-****

* **********

Independent Consulting, Berkeley, CA

Feb 2010 - Present

Used SSIS and Perl for medical claim data processing

Used Haskell (Parsec) to parse claim format spec files

Acadian Asset Management, Boston, MA

Developer/Consultant (May 2008 - Dec 2009)

Business Services Group of the $50 billion quantitative global equity

investment firm

Developed and maintained a wide range of reports that cover performance

(long/short portfolios, country/sector analysis, standard and custom

benchmarks), operations (currency hedges, portfolio turnovers, account

accruals/cash flows/incomes) and marketing.

Streamlined reporting process by creating an XML based tool (using C#) that

enables customized conversion from Excel file to PowerPoint.

Provided support to groups of Client Service, Research, Reporting, and

Operations; collected user requirement to automate data/reporting processes

and build customized applications.

Tools used - SQL,VB/VBA, C#, XML, Perl, SSIS(ETL), SSRS and Crystal Report

OmniClaim, Inc. Winchester, MA

1 System Architect, IT Manager (Jan 2005 - Apr 2008)

Designed a claim filter process that maximize the potential revenue of

negotiation business by using a predictive model on attributes of claims

Developed a rule-based database system that identifies abnormalities in

medical claims; the system processes claims of the United Health Group, one

of the biggest healthcare insurers

Developed programs to analyze structured policy data of major health

insurers

Created business and operational metrics that monitor the company's

competitiveness

Developed multiple applications such as a contract identification

algorithm, aclaim processing system and an XML based internet fax system

Tools used - C++/C#, SQL Server, Perl, VBA(MS-Access, Excel), Java, XML

Availant, Inc. Cambridge, MA

2 Sr. C++ Developer / Project Leader (Feb 2001-Sept 2001)

Designed and developed Availant Manager, a web-based system that highly

improves servers' reliability and availability using C++(STL), XML, Perl,

HTML and Java Script

Designed various test-automating programs that streamlined QA tasks

Atex Media Solutions, Bedford, MA

2 Sr. C++ Developer (Mar 1998-Feb 2001)

Designed and programmed key features for a $15 million, content management

system used by large newspapers globally such as The Wall Street Journal

(C++/STL, XML, table design, triggers and stored procedures in Oracle

PL/SQL, Unix, Windows, IBM VIX)

Re-designed advertisement layout system for The Boston Globe

Defined functional specifications for output sub-system of The Financial

Times system

Leopard Electronics, Beijing, China

1 Project Manager (Jun 1996-Mar 1998)

Designed bankcard software to solve incompatibilities among different

bankcards in China's market; the software was adopted by two of the biggest

banks in China

Led the development of an enterprise information system for the retail

industry that covered that covered sales, inventory, finance, accounting

and analysis

2 Jie Hong Game Software, Beijing China

3 Developer (Feb 1994 - May 1996)

Developed action games (complex algorithms and data structures, intensive

C/C++ programming)

2 EDUCATION

Boston College, Chestnut Hill, MA

MBA and MS in Finance (Sept 2002-Dec 2004)

Took PhD courses in Econometrics and Time Series Analysis

Programmed analytical models -

Binomial tree stock/bond option pricing

A simulation module that analyzes Value-at-Risk and interest rates risk

exposures of a hypothetical bank's asset/liabilities portfolios

Beijing Polytechnic University, Beijing, China

BS in Computer Science (Sept 1990-Jul 1994)

1 CFA level II candidate

Skills:

Object-oriented design; multi-threading programming; algorithm design

Strong skills with multiple languages C/C++/C#, Perl, SQL, HTML,

JavaScript, XML

Familiarity with ASP.NET web development

SQL Server Integration Services (SSIS) SQL Server Reporting Services (SSRS)

Windows, UNIX, shell scripting, EXCEL VBA, and MS-Access

Statistics and data analysis with R, SAS, MATLAB

Used ANTLR and Java to create a SQL code analyzer

Excellent communication and presentation skills

Contact this candidate