Business Analyst Customer Service Sql Server .Net Developer
Resume:
Jason Tian
************@*****.***,
*** ****** **., *** *, 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