Sql Server Customer Service

Callie Ju

Net Developer - Paychex Inc

*********@*****.*** - 703-***-****

• Over 6+ years of experience in design, development, testing and deployment of secure, multi-tier web and

client/server applications.

• Experience in Web Application using .NET Framework 4.0/3.5/ 2.0, C#.NET, ASP.NET, Web Services

(WSDL, SOAP), ADO.NET, Oracle, and MS SQL Server.

• Designed Presentation Tier (web pages) using the concepts such as Master Pages, Themes, HTML, XML,

CSS, Java Script, JQuery and also Worked With ASP.NET Custom Controls.

• Experience working with .NET features like Events & Delegates, Generics & Collections, Exception Handling,

Serialization, LINQ.

• Expert level experience in SQL Server 2008/2005/2000 database design, development of Schemas, Tables,

Views, Indexes, Stored Procedures, User Defined Functions and Triggers, Transaction Management, T-SQL/

PL-SQL, Code optimization and performance.

• Used Language-Integrated Query (LINQ) query to retrieve data from different data sources (LINQ to XML,

and LINQ to SQL).

• Experience in using ASP.NET AJAX framework for quickly creating efficient and interactive Web applications

that work across all popular browsers.

• Worked extensively with ADO.NET objects such as Data Adapter, Dataset, and Data Reader to interact with

databases like Oracle, SQL Server 2008/2005/2000.

• Strong Experience in working with Windows Communication Foundation (WCF) in .Net Framework 4.0/3.5

and Language Integrated Query (LINQ) in .Net Framework 4.0/3.5.

• Experience in creating Business Intelligence reports using Crystal Reports and SQL Server Reporting

Services (SSRS) accessed from Web applications.

• Experienced in different process: Agile Methodologies and Waterfall methodologies and Test-driven

development (TDD).

• Experience in updating, accessing and version controlling the source code using Rational Team

Concert(RTC), Visual Source Safe (VSS), Subversion (SVN).

• Experience in deploying, configuring and maintaining the web sites and services on IIS

• Extensive working experience in unit testing framework - Integration Testing, MS Unit Tests.

• Excellent Written, Analytical Skills, Verbal Communication skills with a customer service oriented attitude.

• Excellent work ethics, self-motivated and quick learner.

WORK EXPERIENCE

Net Developer

Paychex Inc - Rochester, NY - February 2014 to Present

Project: HRS Development

Description: Paychex Inc. is made up of several different departments, from Sales to Operations to Information

Technology (IT). Information Technology is in charge of maintaining the systems used to sell and administer

these products. HRS Development works on 401(k), Flexible Spending Accounts (FSA), COBRA, Workers

Compensation, Health & Benefits, and the Paychex Agency, to name a few. HRS used HRIS.NET as

GUI application. Development of the HRIS.net application pages is done writing C# code using ASP.NET

framework.

Responsibilities:

• Involved in the complete HRS Development Life Cycle, upon which requests for code changes are made,

developed, and implemented. Projects, support changes, and BAU(Business As Usual) work requests are

included in the process.

• Worked on Agile Methodology for analyzing, modeling and documentation, including Turnover and Unit Test

documentations.

• Created Business Logic Layer, WCF Server Layer, User Interface Layer, Web Layer, and Unit Test classes

using C# .Net for web pages.

• Developed Windows Communication Foundation (WCF) services using ASP.net and C#, used them to

generate SvcUtil.Config files based on the web services and consumed in web application.

• Designed website in ASP.NET 4.0 with a consistent site-wide page layout Using Master Pages and their

associated content pages.

• Created Server side validations with ASP.Net.

• Designed different components using C# .Net language and used Exception handling, Error providers to

handle exceptions.

• Used AJAX controls to retrieve the data from the server without interfering the display and behavior of existing

page.

• Used LINQ to Entities to collaborate the domain and integration objects with the view objects.

• Created PL/SQL codes, including packages, stored procedures, functions, and triggers for applications.

• Used Toad to access Oracle Databases, as primary IDE and debugger for PL/SQL.

• Implemented Unit Testing, Integration Testing and System Testing using NUNIT.

• Responsible for maintaining versions of source code using Rational Team Concert (RTC).

• Analyzed, modified, and developed Pro*C codes in Linux Environment.

• Converted Applications from PowerBuilder to .Net Pages; created documentation, excel files for preparation

of conversions.

Environment: C#, ASP.NET, Oracle, Rational Team Concert, WCF, JavaScript, JQuery, XML, Microsoft Visual

Studio, LINQ, ASP.NET AJAX, Linux, PowerBuilder.

Dot Net Developer

E-LOAN Inc - Pleasanton, CA - October 2012 to January 2014

Project: E-LOAN

Description: E-Loan is North America's highest ranking online financial services company specializing in Home

Purchase, Home Refinance, Auto Loans, Auto Refinance, Home Equity and Personal Loans. This project

generates reports about the loans passed daily/weekly/monthly. It also filters the clients whose installment

date has been passed but the client has not paid the installment. This project provides Role level security to

its users.

Responsibilities:

• Involved in the complete Software Development Life Cycle (SDLC) including Analysis, Design,

Implementation, Testing and Maintenance.

• Worked on Agile Methodology to practice-based methodology for modeling and documentation of software-

based systems.

• Developed the independent Windows Communication Foundation (WCF) services and defined Service

Contracts for specific functionality.

• Created and deployed XML Web Services (WCF) using ASP.net and C#, used them to generate the proxy

class files based on the web services and consumed in web application.

• Worked with ASP.NET Web Forms, Web Services, and Caching features, configuring optimizations and

securing the web application.

• Designed website in ASP.NET 4.0 with a consistent site-wide page layout Using Master Pages and their

associated content pages.

• Effectively handled ASP.NET 4.0 client side state management features such as view state, control state,

hidden fields, cookies and query strings, as well as the server side state management features session state

and application state.

• Created Client side validations with JavaScript and Server side validations with ASP.Net.

• Designed different components using C#.Net language and used Exception handling, Error providers to

handle exceptions.

• Created User Controls, Data Access Layer, Business Logic Layer Classes using C#.Net for web pages.

• Used AJAX controls to retrieve the data from the server without interfering the display and behavior of existing

page.

• Intensive use of Cascading Style Sheets (CSS) and XHTML to design look and feel of the web pages.

• Used LINQ to Entities, LINQ to Dataset to collaborate the domain and integration objects with the view

objects.

• Created new tables, wrote stored procedures for applications and some user defined functions. Created SQL

scripts for tuning and scheduling.

• Development of enterprise reports by pulling data from various sources and presenting in SQL Server

Reporting Services (SSRS).

• Implemented Unit Testing, Integration Testing and System Testing using NUNIT.

• Responsible for maintaining versions of source code using Team Foundation Server (TFS).

Environment: C#, ASP.NET, SQL Server, TFS, MS Test Library, ADO.NET, Web services, WCF, JavaScript,

JQuery, XML, Microsoft Visual Studio, LINQ, ASP.NET AJAX and SSRS.

Dot Net Developer

SunTrust Bank - Atlanta, GA - August 2011 to September 2012

Project: Channel link Platform

Description: Channel link Platform is one of the SunTrust Bank's critical and highly visible applications. This

is banks endeavour to transform the teammate experience and client experience. This is a customization of

ARGO Banking solution. It is a web based application which interacts with legacy system via web services.

Channel link Platform will be used by is used by all branches, STOLI and several back office departments. The

graphical front end provides a single point of entry for the major SunTrust application systems. STI Platform

also provides links to nine Intranet URLs for functions related to ASI Research, Consumer Loan GUI and

"What if" analysis, fees and disclosures, Image Link, Merchant Express, Sales Desktop, and SunTrust Online

(STOLI) Sales Tracking and Help.

Responsibilities:

• Implemented the project according to the Software Development Life Cycle (SDLC) and programming by

using fast paced agile methodology, involving task completion, user stories, and iterations.

• Implemented abstract, sealed classes, interfaces and classes to construct the business and data tier using

C# and Entity Framework.

• Developed the architecture with Model View Controller design pattern. Overridden default controller behaviors

and implemented custom action methods.

• Designed and developed rich and enhanced web pages using MVC 3.0, C#, Entity Framework, JSON, HTML

5, CSS 3 and JQuery.

• Implemented HTML Helper MVC WebGrid with JQuery for boosting the pagination performance, and loaded

the graphical data with JSON. Also supporting custom searching along with sorting the data with partial views.

• Created WCF Service to retrieve and send information from client side without Post Back and consuming

existing Web Services using SOAP, HTTP and WSDL.

• Extensively used Asynchronous JavaScript Calls to do data processing.

• Used SSRS for developing reports for analyzing the inflow and outflow of different documents, tickets.

• Written SQL Scripts, for creating database tables with foreign key relations in SQL Server 2008/2012 using

T-SQL.

• Designed and developed several SQL Server Stored Procedures, User defined Functions, Triggers and

Views for all the DML functionality of the application.

• Participated in various Client meetings with the team and the Project manager to discuss improvements/

amendments in the development of the application.

Environment: .NET 4.0, C#, WCF, JQuery, ASP.Net MVC 3.0, Linq, Razor View SQL Server, XML, CSS,

HTML, Java Script, Microsoft Visual Studio, IIS and TFS.

Dot net Developer

Beijing Sports Agency - 北京市 - October 2009 to January 2011

Description: This project is about to build a internal ECM system as well as construct a public web portal, which

provide user a online reservation service of large amount of public sports center like gym, football field, tennis

court who join the partnership with Beijing Sports Agency.

Responsibilities:

• Collect the business requirements and translate them to technique implementation. Prepare the initial

technique specification documentations.

• Implement the unit test code of the new features.

• Implement the online reservation request logic, using 3-tier Architecture.

• Responsible for the Web application designing, So Implemented CSS, Jquery and HTML design for the

application.

• Manage the project source code using TFS, control the source file versions.

• Worked Closely with the client to gather requirements and scheduling weekly meetings with clients.

• Involved in preparing product release documentation for all the activities undertaken at regular intervals for

the project management review and update.

• Took over server maintenance, planed and implement back-up routines. Inspected site usage and quota,

analysis web healthy report.

• Participate in Public Test. Collect and maintain the user feedback, writing the test report.

• undertaken at regular intervals for the project management review and update

• Involved in fixing bugs based on the clients requirements and worked on the enhancement of the web pages.

Environment: C#, ADO.NET, ASP.NET 3.5, AJAX, JQuery, HTML, CSS, Microsoft Windows Server, IIS, Web

Services, SQL Server

Dot Net Developer

Shanghai Telecom Corporation - 上海市 - November 2007 to September 2009

Project: Encounters

Description: Shanghai Telecom Corporation improves healthcare access and quality for a hospital by

developing innovative managed health services for the public sector. The application Encounters eliminates the

internal paperwork in the company and makes several employee related functions available online. Some of the

features include searchable staff directory, online Human Resource management, online project management

and online Tech support along with other staff related functions.

Responsibilities:

• Involved with Analysis and designing of the application.

• Writing Stored procedures, triggers, views and function for enhancements and development.

• Designed user interface screens and implementing / coding application logic under Microsoft .NET framework

using visual basic to use .NET features that powered with CLR.

• Use ASP.NET 2.0 Login Control to display user registration forms, login forms, change password forms and

password reminder forms.

• Worked in ASP.NET Web Forms, ASP.NET state Management, ASP.NET caching features, configuring

ASP.NET optimizations, securing ASP.NET web application and used ADO.Net to connect to SQL Server.

• Generating PDF and Word Documents from Crystal Reports writing methods in visual basic.net

• Used Web forms, ADO.Net in ASP.Net for security checking purposes.

• Documentation of developed Components and module.

• Testing and packing of the developed module.

• Responsible for Database support of the application.

Environment: Windows 2000 server, Visual Studio.NET, ASP. Net, visual basic.net, SQL Server 2005,

ADO.Net, XML

Non-PROFESSIONAL EXPERIENCE:

Android Application Development, US:

Description: The application is between psychology and computer science department in a college. It is used to

detect mood and dysregulation alcohol intake. Three parts involved: body sensors, server, and android phone.

Body sensors get data from human body, and send to the server through Bluetooth. Server deals with data

and sends the data to mobile side through WiFi. Webpage used to show processed human readable data and

charts for analyzing. Mobile side survey is used to get mood data from volunteers.

Responsibilities:

• Involved with Analysis and designing of the application.

• Used HTML5, CSS3, JavaScript to create webpages for displaying data and charts.

• Involved with mobile side design, using Android programming.

• Used agile methodology, delivered work every two weeks.

City Government News Website, China:

Description: The website is used to post news everyday. Users can read, search related news and watch city

advertising video.

Responsibilities:

• Involved with Analysis and designing of the website.

• Used HTML5, CSS3, JavaScript, Angular JS to create webpages for displaying data.

• Used CMS to post news.

ADDITIONAL INFORMATION

TECHNICAL SKILL SET:

Programming Languages C#.NET 4.0/3.5/2.0, T-SQL, PL/SQL, C

.Net Technologies and IDE ASP.Net, C#, ADO.Net, Linq, Entity Framework, ASP.Net MVC, Web Services,

WCF, ASP.Net AJAX, Microsoft Visual Studio 2012/2010/2008

Web Technologies HTML5, CSS, JQuery, JavaScript, JQuery UI, JQuery Validations, AJAX, JSON, XML

Databases SQL Server 2008/2005, Oracle 11g/ 10g/ 9i

Reporting & Source Control tools Sql Server Reporting Services (SSRS), Crystal Reports

Methodologies Waterfall, Scrum, Agile

Other Tools IIS 6.0/7.0, RTC, VSS, TFS, SVN, ODP.NET

Contact this candidate