Oracle Developer Data C# Development .Net Experience

Harwood Wang

Phone: 571-***-****

*******.****@*****.***

PROFESSIONAL PROFILE

• 7+ years of professional experience in software development of commercial

applications. Comprehensive knowledge of and solid experience in full Software

Development Life Cycle (SDLC) Methodologies.

• Able to work independently and with other developers on. Strong troubleshooting,

decision making and problem solving skills.

• Good knowledge of Object Oriented Analysis & Design Methodologies (OOAD).

Thorough understanding of Design Patterns with implementation details.

• Proven background translating cell formulas in Excel into VBA code and using

Excel/VBA/C# to design, analyze, and deploy programs for finance industry

• Proven background translating cell formulas in Excel into VBA code and

using Excel-based VBA to design, analyze, and deploy programs for

finance industry.

• Proven experience of Excel real-time programming of plotting and data

analysis.

• Good knowledge of .NET technologies: C#, VB.Net, Windows Forms.

• Expert level MS Excel skills and experience and familiarity of all MS Office

products, including Access, Word, PowerPoint, etc.

• Expert in creating Excel Add-Ins by using C# program for Monte Carlo

simulations, Call-Put Option Calculation, and Interest Rate calculations.

• Experience with Bloomberg API programming for Real-Time data server

and source development.

• Expert in creating Excel/C# Interface for Excel Automation in stand-alone

C# program.

• Proficient in Oracle, Extensive working experience with relational databases

(RDBS) such as Oracle, OLEDB, ODBC.

• Good working experience of large-scale data processing experience by using

Excel/VBA.

• Good working knowledge of MS Visual Studio 2005 and 2008.

• Excellent background of building statistical and mathematical models, including

PDE models, FEM models.

• Strong background in native C++: Template, STL and Boost libraries.

• Passed CFA (Chartered Financial Analyst) exam Level I.

• Professional financial background, including derivatives, options, swap, and

interest rates.

• Good Oral and written technical communication skills, including the ability to

document code, and produce technical documentation when required.

• Excellent analytical, inter-personal, communication and written skills.

PROFESSIONAL EXPERIENCES

NATIXIS CAPITAL MARKET, New York, NY Jan. 2009 - Present

Excel/VBA/C# Developer

Team Size: 10 ~ 15

Description: Natixis Capital Markets is an affiliate of Natixis, a key player in the banking

sector of France and Europe. Natixis Capital Markets provides innovative, made-to-

measure financing, investment and risk management solutions through understanding the

complexities of risk and harness change in these ever-evolving global markets. I take full

responsibility for the development and support of the risk framework in Excel/VBA and

work directly alongside Quants and traders to design develop and implement new systems

in Excel/VBA/C#.

Responsibilities:

• Assume primary development and support responsibilities for the existing

risk framework about Excel/VBA and C# Add-Ins developments

• Integrate Excel, VBA, formulas, and data sources into a profitable trading

tool

• Design/implement risk reporting tools by Excel/VBA and C# Add-Ins for

limit monitoring, back testing, capital calculation and other risk measures

• Support the trading desks and day-to-day trading activities about data

models and Excel/VBA and C# Add-Ins programming.

• Work closely with Strategist, trading desk and controllers to follow up on

any questions/issues raised in the trade review process.

• Assist client to apply the tools for Global usage by using Excel/VBA and

C# multithreaded programming.

• Work with users for software support, testing and maintenance issues

about data models, Excel/VBA applications and C# Add-Ins.

• Address ad-hoc quantitative, analytical and technical risk requirements

and write Excel/VBA codes, C# and C++ program.

• Working directly with the quant team, assume responsibility for the

implementation and system integration of new models.

• Develop C# GUI interfaces using Open Database Connectivity (OLEDB) to

connect to Oracle and Access Relational Database Management Systems

(RDBMS) under Windows OS.

• Improve current modules with more standardization, robustness and

efficiency.

• Write functional specifications, technical design/implementation and user

guide papers

• Continuously improve implementation in coordination with lead

Environment: Visual C#/C++, MS Excel/VBA, .NET Framework, Boost library,

UNIX, Oracle 10g, ODBC Classes, Oracle Data Provider.

AT&T Shannon Lab, Florham Park, NJ January. 2008 – Dec. 2008

Application Developer

Team Size: 30 ~ 40

Description: AT&T Inc. is the largest communications holding company in the

United States and worldwide, by revenue. Operating globally under the AT&T

brand, AT&T is recognized as the leading worldwide provider of IP-based

communications services to businesses and the leading U.S. provider of

wireless, high speed Internet access, local and long distance voice, and directory

publishing and advertising services.

Responsibilities:

• Designing Statistical Model for radio wireless network optimization;

• Developing Capital and Operation models by using statistical and

mathematical knowledge.

Developed Capital and Operation models (C#, Oracle database, and

•

Excel/VBA) and pricing model for Indian market data;

Developed Information Management System by using C#, .NET

•

Framework, Excel/VBA and Oracle database;

Designed GUI Interface (C#, VBA), developing special UI components

•

Designing optimization models about global radio wireless network in C#,

•

Oracle database.

Responsible for all project lifecycle phases, from specifications and coding

•

through deployment, testing, debugging, documentation, and

maintenance.

Create VBA and C# programs to automatically update Excel workbooks,

•

encompassing class and program modules and external data queries.

Develop GUI interfaces using Open Database Connectivity (ODBC) to

•

connect to Oracle and Access Relational Database Management Systems

(RDBMS).

Extensively use Excel functions in development, focusing on read/write

•

integration to databases.

Created DB objects like tables, synonyms, sequences, views etc under

•

Solaris system

Implemented Join conditions, group by functions, correlated sub queries,

•

nested queries.

Coded database triggers, packages, functions, and stored procedures

•

using PL/SQL and maintained the scripts for various data feeds.

Supported DBA team for the data migration from oracle 9i to 10g.

•

Environment: Solaris, C#, Visual Basic, MS Excel/VBA, Oracle 10g, PL/SQL,

ODBC Classes, Oracle Data Provider.

Ameritas Life Insurance Corp, Lincoln, NE August. 2005 – January,

2008

Senior Statistical Developer/Analyst, Fixed Income IT

Project: Order Management System

Ameritas traces its heritage back to 1887 and its founding in Lincoln, Nebraska. In 1988,

Bankers Life changed its name to Ameritas Life Insurance Corp. to reflect the company's

broad product line and national scope. Main businesses in Ameritas include life insurance

and annuities, group dental and eye care insurance, retirement plans, investments. This

project was targeted to make access to Ameritas Life Insurance Corp even easier

for clients by allowing spot and forward orders to be submitted electronically 24

hours per day. The system can handle a range of orders from simple to complex.

Clients can not only monitor, amend and cancel orders in real-time but also set

up exclusion period in advance.

Team Size: 10-15

Responsibilities:

• Involved in all aspects of the development life-cycle, including

enhancements to existing components as the design and development of

new components.

• Developed Windows based applications using C# and Oracle 9i.

• Developed multi-threaded services to capture and stream real-time deal-

able prices.

• Using Excel internal functions such as CONCATENATE, PROPER, TRIM,

LEFT, and RIGHT to manipulate all kinds of data.

• Using VLOOKUP and HLOOKUP commands to build advanced tables.

• Developing Excel templates and writing VBA codes to automatically using

the templates to do data analysis.

• Writing VBA codes to connect Excel files with Oracle database and SQL

database.

• Writing VBA codes to integrate SQL queries in an Oracle environment to

Excel operations.

• Utilization of Excel including pivot tables, graphing and mechanization.

• Utilization of MS Excel/Access with VBA code, including data import/export,

query building, information extraction, and mechanization.

• Integrating the development of C# and VBA.

• Developing Windows scripting and automation processes to run EXCEL

files automatically.

• Create VBA programs to automatically update Excel workbooks,

encompassing class and program modules and external data queries.

• Used ADO.NET technology (SqlConnection, SqlCommand, SqlParameter,

SqlDataReader, SqlDataAdapter) to connect to databases

• Assisted Fixed Income department analyze and develop interest rate

derivatives models, and involved in options, mortgage models and interest

rate derivatives models under Windows OS.

• Assisted Fixed Income department develop application programs, including

mortgage calculations and interest rates derivatives programs with Visual

C#/C++ language.

Environment : C++/C#, Windows Forms, Excel/VBA, Visual Studio.Net

2003, Oracle 9i, ODBC Classes, Oracle Data Provider for .NET

Travelers, Overland Park, KS January. 2004 – July, 2005

Senior Statistical Developer

Project: Employee Payroll Management System

Description: Travelers offers a wide variety of property and casualty insurance and

surety products and services to businesses, organizations and individuals in the United

States and in selected international markets. The application was in effort to automate

the process of job scheduling, bill submitting, and wage calculation. To achieve

the objective, the application was implemented with 3 modules, the Master

Module, Billing Module, and Wages Module. In Billing Module, user will enter

Work Order along with job schedules, and generates the bill and check-list to

submit. Wages Module is used to calculate monthly salary of Employees.

Team Size: 15-20

Responsibility:

• Involved in Requirement gathering, Analysis and preparation of design

documents

• Involved in prototype development and finalization of user requirements

• Developed multi-threaded web services to perform data access and data

conversion.

• Designed and created tables for data storage and stored procedures for

data access in Oracle 9i.

• Implemented data access layer (DAL) with ADO.NET objects such as Data

Reader, Data Adapter and Data Set to retrieve and manipulate data.

• Designed friendly Graphic User Interfaces (GUIs) by Wiring up Windows

forms, Dialogs, Menus, DateTimePicker, Panel, GroupBox, ListBox,

CheckBox, and TrackBar.

• Assisted actuarial department to develop options and derivatives models

and write source codes by using ISO C++ under UNIX system and wrote

bash shell codes.

• Ensure data integrity with Excel/VBA by validating information obtained

from product administration systems using a variety of available resources.

• Work/communicate with various departments including IT and Legal

department for various variable funds/products and data issues.

• Support cross-functional projects related to generation of product

prospectus information or other required disclosures by using Excel/Access

and VBA codes.

• Review reports for accuracy and completeness;

• Using Excel internal functions such as CONCATENATE, PROPER, TRIM,

LEFT, RIGHT to tailor report format and content to the target audience.

• Perform analysis of data and high level summaries by running Excel VBA

code developed.

• Developed or recommend automated solutions for manual processes.

• Developed and analyzing tables, queries and reports in Microsoft

Excel/Access 2003

• Valuated and updated Code in Microsoft Excel/Access 2003 Application.

• Evaluated and modified tables, queries, and reports per agency

requirements by optimize Excel templates and VBA codes.

• Evaluated database normalization for optimized functionality by using

Excel/VBA and ODBC.

Environments: Microsoft Visual Studio .NET 2003, C++, SQL Server, Oracle,

ADO .NET, Excel/VBA, Windows XP, Windows Server 2003, UNIX.

COMPUTER SKILLS

C#/C++, .NET, Java, VB, PL/SQL, VB Script, Perl

Languages:

Oracle, SQL Server, MS Access, ADO.Net, ODBC

Database:

Win 95/98/NT/2000/XP, UNIX, Solaris, Linux, DOS

Operating Systems:

GVIM, VI, Visual Studio, .Net Framework, UML

Tools:

Object Oriented Analysis, Design Patterns, Software

Concepts:

Development Life Cycle, Database design, Multi-Threading

E D U C AT I O N

Masters Degree in Actuarial Science

University of Nebraska @ Lincoln, NE

Contact this candidate