Post Job Free

Resume

Sign in

Business Analyst Customer Service Sql Server .Net Developer

Location:
Clinton Corners, NY, 12514
Posted:
September 12, 2013

Contact this candidate

Resume:

Jason Tian

201-***-****,

ab7guq@r.postjobfree.com,

*** ****** **., *** *, Hoboken, NJ 07030

SUMMARY:

. 5 months of experience in Financial Analyst

. 1+ years of experience in Master Programs Projects of Hedge Fund

Analyzing, Portfolio Management Analyzing, Financial Risk Management

. 1+ year of experience in Bachelor Programs Projects of Fixed Income

Analyzing, Foreign Exchange, Stocks Trading and Futures Trading

. 5 months of experience in Business Analyst

. Experience in Design Pattern C++

. 2+ years of experience in Software Development & Maintenance of

Client/Server and Web based applications using C#, debugging with

Microsoft .NET framework 3.0/3.5/4.0 with C#

. Experience in web technologies to develop data centric applications

using ASP.NET, C#

. Experience in SQL Server 2005 & 2008, SQL, TSQL, stored procedures,

Functions, Triggers, Backup and Restore

. Experience in building a rich web experiences using JavaScript and

Silverlight

. Experience in HTML, HTML 5, XML, IIS 6.0/7.0

. Good knowledge in Web Service and WCF development

. Good knowledge in Microsoft Dynamics CRM 4.0 and Microsoft Dynamics

CRM 2011

. Leadership experience in President of Student Association in College

. Quick Adaptability and good problem solving skills

. Efficient at identifying organization needs and customer expectations

SKILLS:

. Quantitative & Analytical skills: Stochastic Calculus & Statistics

. Finance: Portfolio Theory, Financial Risk Management, Fixed Income &

Equities, Financial Accounting

. Language: English (Fluent); Chinese & Mandarin (Native)

. Candidate for CFA Level I

. Technical skills:

Enterprise Technologies BizTalk, Microsoft Dynamics CRM 4.0/2011

Languages C, C#, JavaScript, T-SQL

.NET Technologies .NET Framework 3.0/3.5/4.0, C#.net, ASP.net,

ADO.net, WCF, WF, Visual Studio 2008/2010

Web Technologies XML, XSLT, HTML, CSS, JavaScript, AJAX, IIS

6.0/7.0

Databases LINQ, MS SQL Server 2008-R2

Reporting Tools SQL Server Reporting Services (SSRS)\

Office Tools Microsoft Office/Project/Visio

OS Windows 2003/2008R2, Windows 7

EXPERIENCE:

Marlabs, NJ

04/2013-Present

.Net Developer /Web Programmer

Responsibilities:

. Experiences in the full range of the Software Development Life Cycle

(SDLC), which includes application design, coding, testing,

application deployment.

. Developed Architecture in UML using Use Cases, Sequence Diagrams, and

Class Diagrams.

. Implemented the Agile Scrum methodology and Test First methodology

(TFD) for developing the application.

. Designed and developed UI and core components of LUAU - windows

application written in Framework 3.5 WPF technology.

. Developed Win forms and Win forms application to invoke the Web

services and sending out marketing promotions mails to braches.

. Applied Enterprise Library Exception Handling Application Block

functions, such as the ability to log exception information, to hide

sensitive information by replacing the original exception with another

exception, to maintain contextual information for an exception by

wrapping the original exception inside of another exception.

. Used this Enterprise Library Data Access Application Block in a

variety of situations, such as reading data for display, passing data

through application layers, and submitting changed data back to the

database system.

. Developed and delivered dynamic reporting solutions using SQL Server

2008 Reporting Services (SSRS).

. Applied MSI Installer as an engine for the installation, maintenance,

and removal of software on modern Microsoft Windows systems.

. Displayed new data and reports in this system after retrieving data

from SQL Server 2008.

. Developed Stored Procedures, Cursors and Views using PL/SQL & T-SQL

for both these systems.

Environment:

C#, WCF, Web services, WPF (XAML), SQL Server 2008, Microsoft Enterprise

Application Library 4.0

North Van Lines, NJ

11/2012-03/2013

.Net Developer/ Web Programmer

Responsibilities:

. Involved into migration of .NET 1.1 modules into .NET 3.5 Framework.

. Responsible for producing, documenting, and mentoring other team

members on a custom development framework and practices for

development projects using C# and ASP.NET, including the development

of common libraries and web controls, development standards,

requirements and design documentation standards.

. Implemented Architecture in UML using Use Cases, Sequence Diagrams,

and Class Diagrams.

. Implemented the Agile Scrum methodology and Test First methodology

(TFD) for developing applications.

. Developed and designed a LINQ to SQL and Web Service driven Web Form

application that served as a more user-friendly and powerful user

interface for an existing application.

. Involved in setting up the Active Directory for implementing

authentication based on it.

. Used WCF to bind industry-specific applications to the web site which

allowed AJAX access to the applications data.

. Used Team Foundation Server (TFS) for source control, data collection,

reporting, project tracking, and collaborative software development

projects.

. Used MSI Installer as an engine for the installation, maintenance, and

removal of software on modern Microsoft Windows systems.

Environment:

C#, ASP.NET, WCF, SQL Server 2005, TFS (Team Foundation Server)

CavalierIT Inc., Jersey City, NJ

06/2012-10/2012

Business Analyst / Information Systems Analyst

Responsibilities:

. Assisted Business Group Leader in developing strategic product,

services and programs to support the goals of our business group

(financial, customer service, operational efficiency, market share,

production, quality, etc.)

. Cooperated with our business partners/clients to identify and maximize

opportunities to use information and technology to improve product,

service and program business processes

. Inspected, analyzed, and created detailed documentation of business

systems and clients needs, including workflow, program functions, and

developing or modifying computer programs

. Discussed with clients to determine business, functional and technical

requirements for specified applications and requirements

. Coordinated all the approved development of business and functional

specifications for applications. Communicated with IT project staff to

ensure business requirements are adequately reflected in technical

planning documents by using cases and other technical documents

. Created reporting tools for the business group

. Analyzed the activities of business group and compares analyses with

the service standards. Presented findings and worked with the Business

Group Leader and other personnel to identify and implement strategies,

which will be set as strategic goals.

. Wrote routine reports

Alexion Pharmaceuticals Inc, CT

01/2012-05/2012

.Net Developer/Business Analyst/CRM Consultant

The project required creating a customized sales force automation

application using MS .Net Framework and CRM 2011 based on the business

requirements. A sales landing page was generated as a virtual office for

the sales force linking into the many custom screens, and workflows that

were created in ASP .Net and CRM. This implementation is expected to help

in supporting a sales cycle and bring high level of efficiency and

productivity.

Responsibilities:

. Analyzed requirements for the planning module of the project

. Created a project plan for the customer, including both estimates for

the tasks that will be completed and the timeline in which they will

be completed

. Customized the sales module according to the business plan

. Created Entity Attributes, Filtered Views, Lookup fields and

customized forms/views for all System & Custom Entities

. Created documentation to define workflow and requirements and

implemented custom workflows into business process to enhance and

automate sales process

. Designed and integrated ASP.NET front-end using Web Services and

implemented client side validations for Web-server controls. Used .NET

validation controls for client side validations

. Communicated with internet and intranet web applications in CRM

environment by using iFrames functionality

. Used JavaScript functions to do client side validations according to

the requirement

. Developed reports using CRM reporting interface and SSRS (SQL 2008 R2

engine), and deployed it on the CRM that were used in the application

depending on roles

. Made SSRS reports for sales and financial data using joins and Pivot

Tables

. Created several drill down and drill through data analysis features in

the reports.

Designed several custom dashboards and other visualizations

integrating reports/charts with dashboards.

. Created .NET plug-ins to hide the system default views and registered

them with the CRM server.

. Customized Sitemap for entity navigation and customized ISV file for

custom menus.

Environment:

Windows 2008 R2 Server, IIS 7.0, C#, SQL Server 208 R2, MSCRM2011,

JavaScript, DHTML, XML, WCF Web Services, SSRS

ASPS Linen, NJ

09/2011-12/2011

Software Engineer (Part-time):

Responsibilities:

. Developed Web Forms using ASP.NET and HTML in Web Application and used

codes are behind C# Programming

. Involved in developing Business Logic and Data Access Components

. Experienced in creating Tables, Indexes, Stored Procedures and User

Defined Functions in SQL Server

. Made Unit Test Cases in implementation and tested in various phases of

applications, like unit testing and integration testing

. Experienced in creating Delta Script to execute the script on

Production Database

. Experiences in setting up the data bases for Development and QA

Environment

. Used File Transfer Protocol for moving files to production server

after QA Completes

. Applied CVS version control to Tagging Code after moving code to

production server

. Implemented all the user input validations by using the validation

controls

. Documented all the procedures and user defined functions that were

formed in SQL Server.

. Implemented Inheritance on various Classes in the application

. Involved in preparation of Unit Test Cases and performed Unit Testing

. Client Validations by using Java Script and Cascading Style Sheets

Environment:

ASP.NET, C#, ADO.NET, JavaScript, HTML, IIS, SQL Server 2008, Windows XP,

Visual Studio 2008

Taiyuan Iron & Steel (Group) Co., Ltd, China

06/2011-08/2011

Developer/Business Analyst

Responsibilities:

. Performed Requirement analysis, Design, Development, Testing and

Maintenance.

. Developed reusable Web User Controls(.ascx) in ASP.NET

. Developed JavaScript function for ASP.NET web form pages.

. Responsible for Data Access Layer implementation in C#.NET.

. Worked in creating/modifying tables/stored

procedures/packages/functions and triggers in Oracle 8i/9i.

. Prepared Technical & Unit Testing documents for the screens developed

. Prepared quality documents like traceability matrix and update SRS

when changes are made in the UAT phase of the project.

. Performed business process monitoring.

Environment:

Asp.Net, C#, SQL Server 2005, Web Services, Windows Services, IIS

ViewTrade Financial Network Inc., Jersey City, NJ

01/2011-05/2011

Financial Analyst (Part-time)

Responsibilities:

1) Hedge Fund Analyzing:

. Analyzed financial information relating to specific companies, for

example, profit and loss and cash flow statements

. Regularly communicated with the management of the companies and their

investor relations team, usually over the telephone but sometimes at

their premises, for example, company office meetings

. Keeping up-to-date with market developments, new investment products

and all other areas that can affect the markets, for example,

movements in the economies of relevant countries

. Considered how the economic implications of factors, such as natural

disasters, weather, might affect the performance of companies and

funds

. Monitored the financial news using specialist media sources

. Drafted research reports and investment ideas to be sent to clients

. Ensured that they meet the numerous compliance regulations

. Maintained regular communication with clients by telephone, email and

face-to-face, including updating fund managers/hedge funds on

investment ideas and summaries of research

. Made presentations and recommendations as to which funds should be

included in fund managers' portfolios

. Maintained hedge fund data on a database

. Skillfully managed relationship with our hedge fund clients

. Performed due diligence on hedge funds for credit risk, recommended

credit limits, prepared analytical reviews and prepared ISDA

agreements

2) Financial Risk Analyzing:

. Managed checked financial data resources wisely

. Considered proposed business decisions

. Protected the organization's assets and public image

. Performed research to assess the severity of risk

. Performed statistical analysis to evaluate risk and using statistical

software such as SPSS and SAS

. Provided recommendations to reduce or control risk

. Read and checked legal documents

. Presented ideas by reports and presentations, outlined findings and

made recommendations for improvements

. Cooperated with traders to calculate the risk associated with specific

transactions

. Connecting with underwriters and insurers

. Forecasted and monitored market trends

. Bought insurance if need

. Analyzed a bank's market position and calculated the relevant figures

in complex models to find value at risk (VAR) measurements

. Executed quantitative & statistic analysis

. Applied financial packages and software such as portfolio management

software

. Pay attention to government legislation, which may affect a company,

and advised on compliance

. Provided contingency plans to deal with emergencies

3) Stocks Trading Analyzing:

. Made investment strategies by fundamental & technical analysis,

trading models & real time data

. Read daily data of companies in a year from ViewTrade' system by Co.'s

software

. Searched and chose valuable bid/ask price data to test my strategies

. Tested the effectiveness of the strategies &calculated the results

using selected data

. Implemented the strategies in the real markets and assessed the

results

PROJECTS:

. Application for butterfly spread:

10/2010-12/2010

. Constructed a model by selling 100 options with strike price K1,

selling another 100 options with strike price K2 and buying 200

options with strike price K3 which was between K1 and K2

. Calculated and analyzed the Volatility of the returns

. Adjusted the strategy over time based on the "Vol" and calculated

the returns by VBA

. Calibrated a GARCH(1,1) process for SX5E:

09/2011-10/2011

. Built a Stochastic Volatility Model for SX5E

. Matched mean, initial volatility and long term volatility to the

empirical mean and short and long term standard deviations by the

Method of Moments

. Fitted the Kurtosis and Autocorrelation of squared returns

. Forecast the future variations and performances by the fitted

parameter

. Found a least-cost portfolio for bonds:

11/2011-12/2011

. Selected the bonds from database

. Used the MATLAB optimization toolbox to construct model in MATLAB

. Found a least-cost portfolio of the bonds and calculated the cost

of the portfolio

. Application for Monte Carlo Program-Design:

04/2011-05/2011

. Used repeated sampling to determine properties of some phenomenon

by Monte Carlo Simulation

. Applied Design Pattern, e.g. Strategy & Bridge in C++, to comply

the simulation process

. Repeated 1,000,000 times simulation to calculate the mean as the

benchmark of the process

. Future Arbitrage trading & FX Swap trading:

09/2007-09/2008

. Chose two related products; analyzed the spread of the spot prices

and future prices of them; forecast the right trading point and

traded them ; made a profit of $5,000

. Found a FX swap trading opportunity; made a strategy-trading;

obtained E60,000

LEADERSHIP:

. President of Student Association in College

09/2006-09/2007

. Funded and collected money for campus events by advertising some

companies

. Arranged and organized some campus student events, such as sports

meeting

EDUCATION:

. Stevens Institute of Technology, GPA: 3.8/4.0

08/2010-05/2012

Master of Science in Financial Engineering, Hoboken, NJ, USA

Graduate Certificate of Financial Engineering, Hoboken, NJ, USA

. Shanxi University of Finance & Economics, GPA: 3.6/4.0

09/2005-07/2009 Bachelor of Business Administration in Financial

Engineering, China



Contact this candidate