Sales Sql Server

Lucy Wang

*** ******** ***., *********, ** *****

Tel: 413-***-****, 413-***-****

E-mail: *******@*****.***

SUMMARY: More than 10 years of experience developing web-based applications using ASP.NET/ASP, C#, VB.net, SQL, HTML, CSS, JavaScript, VBScript, AJAX, Linq, Web Services, TFS on MS SQL Server database with Jira Agile management tool. Strong in business requirement analysis and functional specification design and documentation. Strong in front-end development and back-end database design, implementation. Able to work in a multi-task environment with excellent time pressure and prioritization management skills.

EDUCATION:

MS in Computer Science, State University of New York at New Paltz, 8/99

MA in Economics, Northeast University of Finance & Economics, China, 7/88

BA in Economics, Liaoning Institute of Finance & Economics, China, 9/85

SKILLS: Web Skills: ASP.NET/ASP, C#, VB.NET, SQL, HTML/DHTML, XML, CSS, JavaScript,

VBScript, AJAX, Linq, Web Services, Visual Studio, TFS, Infragistics,

Visual InterDev, ADO.NET/ADO, ODBC, SMTP, IIS.

Databases: MS SQL Server, MS Access, Oracle

Reports: Crystal Reports, SSRS Reports, MS Access Reports

Platforms: Windows 2000/XP/7

EXPERIENCE:

06/2015--Present Web Application Developer, Percy’s Corp. MA

Designing, developing web applications using ASP.net, Vb.net, Bootstrap, HTML, CSS, JavaScript, AJAX, Web Services, MS Sql on MS SQL Server Database.

09/2011-04/2015 Software Developer, MSD MA

Designed, developed healthcare based web applications using ASP.net/ASP, C#, HTML, CSS,

JavaScript, AJAX, Linq, Web Services, MS Sql on MS SQL Server Database with Jira Agile

management tool.

Heavily worked with end-users to gather user requirements. Based on own experience, strong thinking and judgment skills, analyzed and translated complex business requirements into simple, elegant solutions.

Designed databases, created tables, views, stored procedures, triggers to define and manage data relationship.

Developed source codes. Researched new methods and technologies as project needed. Recommended best program methodologies to increase software performance and operation efficiency.

Created Stored Procedure to import data from customer source files into sql database.

Analyzed query execution plans, optimized database codes.

Wrote test plan, tested, debugged and fixed code errors.

Enhanced /fixed existing applications, upgraded websites with improvements from users to maintain customer interest.

Trouble shooting end users machines when problems pop up.

Wrote program documentation. Trained end users.

Main projects included:

CSV Drop Ship program, POD (proof of delivery), Parlevel calculation report, Customized equipment delivery ticket, OIS Medicare program, Customer login project.

02/2011--06/2011 (Contract) Web Application Developer, Technology Insight Corp. MA

Designing, developing Recovery Audit System internal web applications using ASP.net, Vb.net, HTML, CSS, JavaScript, AJAX, Linq, MS SQL and MS SQL Server Database.

03/2010--12/2010 (Contract) Web Application Developer, Foley Services, Inc. CT

Participated in designing, developing Solution.NET and Client Portal web applications using ASP.net, C#, HTML, CSS, JavaScript, AJAX, Linq, Web Services, MS SQL and MS SQL Server Database.

Duties and Accomplishments highlights:

Designed, developed cross-browser user interface, with JaveScript and CSS combined created dynamic CSS menu.

Developed cross-browser search function, using Web Services to query CS file in the Client Portal Library to retrieve data from different systems.

Developed quick sales application, using Linq, Generics list, Dataset, Entities Data Model to query/filter/add/update the objects.

Developed Assign Sale application, which is used to search/list/assign/reassign sales leads. Using Datasets created based on Sql queries, Stored Procedures, Functions to access data in the database.

Developed sales person absence web page, which dynamically updates sales agents working status to avoid inefficient sales leads assignment.

Developed sales dashboard application, with four KPI (key performance indicator) - sales, offers, phone calls and working hours to evaluate salesperson performance, using graph to visually identify strong and weak performance of particular sales area.

Created sales activity application, which is used to search/list/add/update salesperson activities.

Created Email Report application, users can create Crystal Report on the fly and send pdf format as Email attachment. Created SSRS Report Models for end users.

Wrote documentation.

03/2001-06/2009 Web Developer / Programmer Analyst, Hardigg Industries, Inc. MA

Led and participated in company websites’ entire development life cycle- analyzed,

designed, developed, tested, debugged and supported company websites for internal and

external use using ASP.NET/ASP, C#, HTML, CSS, JavaScript, AJAX, MS SQL and MS

SQL Server.

Finished main projects:

Designed, developed internal HR website.

Designed, developed survey project, which produced quicker connection between the company and the employees.

Designed, developed online job application.

Designed, developed computer inventory management system for tracking all company electric inventory assets.

Designed, developed purchasing requisition system, which involved purchasing, accounting, shipping, receiving and inventory departments.

Other projects including QA Calibration system, Sales reports (Crystal Report), SO complaint management system, Engineering Design Log book etc.

03/2000-03/2001 Web Developer, Harte-Hanks Interactive Inc., NY

Designed, developed and modified websites using ASP, HTML/DHTML, CSS, JavaScript, VBScript, MS SQL and SQL Server.

My duties included:

Interfaced with technical lead and project management to understand project requirements.

Worked independently to complete coding tasks related to the project.

Independently determined best program methodology to complete client projects.

Interfaced with QA personnel to identify and amend coding defects.

Wrote and maintained program documentation.

Developed and maintained an understanding of departmental process and ensure work was completed within this definition.

Communicated process problems and inefficiencies to supervisor.

Contact this candidate