SQL Developer Resume Profile Jersey City - Hire IT People

QUALIFICATION AND SKILLS

Advanced MS Excel knowledge and experience.
Solid experience using SQL to perform queries with databases.
Proficient in regression analysis and time series model manipulation using SAS.
Experienced in C programming in ODE, PDE, SDE approximation and Monte Carlo simulation.
Broad programming experiences using C, MATLAB and VBA.

EXPERIENCE

confidential

Used Excel to extract item information from more than 30 vendors' files, standardized data in order to meet GSA-Schedule and SQL database rule.
Imported data into SQL-Server database.
Created and did deep test Null test and Distinct test for all vendor files. Found and filled null information Found and removed duplicate information.
Applied PNC Rules on every item.
Rebuilt company's SQL-Server database. Created PNC Main File, which includes millions of items from more than 30 vendors Created Item File, which includes all detail item information Created Item Price File, which helps company doing price analysis and making purchase decisions.

confidential

Created Excel spreadsheet for data from public resource Queried data into an analyzable spreadsheet
Used SAS to import, clean and analyze dataset.
Used SAS proc means/univariate to analyze data, and proc glm to build the model.
Used proc report to generate final report.

confidential

Performed industry-wide research and analyze specific stocks to identify key support and resistance levels, as well as changes in moving averages and trend reversal movement to provide recommendation and market forecast to the company's traders.
Devised trading plans and implemented trading strategies using different technical studies, such as Fibonacci Analysis, Moving Averages, VWAP and Pivot Point to search for potential profitable trade and determine the best entry and exit prices.
Reviewed and summarized daily activities that influenced the S P 500 Index, the Dow Jones Index, and the NASDAQ Composite after the market closes to project the following day's movements and search for potential trades.
Continuously maintained profitable for 7 months, achieved a monthly return of 58 with the initial investment fund in March 2014.

confidential

Assisted traders in trading in the foreign exchange, commodity and money markets.
Participated in raising funds from banks, managing daily cash balances.
Obtained first-hand experience of crucial business discussion, decision and negotiation.

confidential

Participated in the early stage of business credit project investigation and report writing. Analyzed and reported on data from thorough survey on gross settlement of banks in Chengdu.
Participated in evaluating customer credit, improving risk control strategy, and optimizing the procedure.
Obtained experience of credit project selection, key points of investigation before credit granting, and risk control strategies.

confidential

Completed acceptance test of V2.52 edition of core business system which including the case writing, test execution and test report writing.
Developed and tested new mathematical models and optimized existing models used by PICC's web application to provide highly personalized financial advice.

SELECTED PROJECT EXPERIENCE

Complied C code to price options by Quasi Monte Carlo simulation with Halton sequence 2013
Simulated stock price paths by Box-Muller and Beasley-Springer-Moro method with Halton Sequence.
Computed option prices and analyzed accuracy of estimates by Anderson Darling test.

Compiled C code to price put options and simulate Greeks under Black-Scholes model

Tested implementation of Crank-Nicolson approximation by variation of error.
Computed put option values and Greeks used in portfolio hedging.
Computed sensitivities of option values to interest rate changes and analyzed the results of Greeks.

Financial Analysis of Energy Industry Investment Analysis

Described and discussed recent historical performance of Energy industry.
Assessed the likely industry performance over the next couple of years.
Provided well-supported investment opinions of the coal companies ACI, ANR, BTU, CNX through Fundamental and Technical Analysis.

Established time series model for daily physicochemical data

Transformed the data to fit ARIMA model, multi-regression model and regression-time series model.
Computed 20 forecasts for each model and compared the reliability checked normality of residuals.

Regression Analysis on Housing Values in Suburbs of Boston using SAS

Fitted regression model of housing value considering a dozen of environmental factors.
Redid regression based on training/testing dataset to reveal how data selection would affect the results.
Estimated the forecast error through back testing.

The Design Ideas and Background Analysis of Several Insurance Products

Design and implement a typical movie ticketing system

Provided the functionalities of online information query, ticketing, and refunding.
Provided various roles of management such as distributed ticketing system and financial management.
Implemented C functions within Microsoft SQL database.

Student Leadership and Activities

Volunteer, Thousands of Children for Expo 2010 by Singapore CapitaLand

Volunteer, Post-earthquake Reconstruction, Chengdu, China

Minister, Students' Life Department of School of Mathematical Sciences

Minister, Culture and Sports Department of School of Mathematical Sciences