Daniel Ni

*** - *** ******** **, ***********, Ontario M1T3M7

416-***-**** acqx4t@r.postjobfree.com

OBJECTIVE

Seeking a position as a Sr. SQL Server/ASP.NET Developer

Skills & Experience

10+ years with Database development including proficiency with development of tables(data modeling), stored procedures, user defined functions and optimisation of queries, Database tuning and Optimization, SQL Server(7/2000/2005/2008, 10+ years), Sybase/DB2(1 year)

Experience working with BI/ETL, Sybase/DB2(1 years), Cognos(1 year)

7+ years in ASP.NET development using C#, Web service(SOAP,WCF, Restful)

Extensive with HTML, XML, CSS, JavaScript, jQuery and Json

6+ years development experience using VB and Windowsform

Practical development experience with mobile environment, Java Me(6 months), Android 2.2/2.3(3 months), Blackberry IDE(5.0)(3 months)

Expert skills in design and working with n-tier architectures(UI, Business logic layer and Data Access layer), OOP method

End to end experience across the entire software development lifecycle(SDLC), analysis, design, coding, testing, release

Advanced analytical skills for complex problem solving, good team player and fast learner

Professional Experience

Sr .NET Developer May 11, 2015 – Present

SharpSchool/Intrafinity

Sharpschool is a school solution and service provider, full product line include K-12 Web solution, SafeMail, eLocker, Parent Portals, Gradebook, Instructional Management System, MentorMatch, it also provide related Web hosting/Integration, cloud storage platform services. As a Sr developer, my responsibilities include:

Work close with project manager, Business analyst, QA, customer support team, provide solutions to new features and ongoing projects using .NET platform, ensure a smooth implementation to existing integration/production environment.

Products maintenance and business issues resolve.

Codes analyze and performance optimization.

Software Developer June 2013 – June 2014

TD Auto Finance, Toronto, Canada

TDAF is an internal .Net web application which creates PDF letters from DOCX template using client information come from internal/external data sources: batch file, web services and database (MS SQL Server 2008).

Responsibilities & Roles:

Design and develop TDAF web application for TD internal employees. Develop on .NET platform with SQL Server, C# and use MVC, WCF, Restful technologies.

Data modeling include tables, indexes, store procedures, and provide backup/restore strategy, Database server install, configuration, tuning, optimisation and daily support in development environment.

Develop DOCX to PDF web service use Word Automation Services under SharePoint 2013, Open XML API, Active Directory, iTextsharp

Generate security daily report (Diamond report), XML file base on Active Directory and user auth/roles update from each application.

Technical lead on ETL system to integrate and transmit data into and out of TDAF systems. Design and document database architecture using MSSQL Server 2008 and related DBMS tools of SSRS and SSIS.

Mentor junior developers

Sr Software Developer Jan 2007 – Feb 2013

Cellflare Mobile Application Company, Toronto, Canada

Major duties include (Database and back end: 80%, front end: 20%):

-Created tables, store procedures and index, query optimization

-Created and configured resume full-text search functionality using SQL Server’s full-text search engine

-Database backup/restore plan designed and configured based application,

-Database server daily support and maintain.

-Using OOP method constructed components and modules

-Using ASP.Net, C#, WFC, Restful, Open XML, iTextsharp, HTML, JavaScript, jQuery, Json, AJAX and CSS wrote front-end web pages

-Unit testing and bug fixing

-Maintained and optimization Web application including back-end and front-end

-Provided and maintained Web Services to support the front-end and Phone apps

Projects:

Crimestoppersmobile website for iPhone version (222tips.com/mobile)

This is iPhone browser version that allows user to submit tips from their iPhone directly

Technologies: Windows Server 2008, VS 2010, ASP.Net3.5/4 JavaScript, jQuery, Json, HTML5, CSS, C#, MS SQL Server 2008, TFS

Crimestoppersmobile website (www.crimestoppersmobile.com)

You can submit tips from 8 cities (Toronto, Edmonton, Medicine Hat, New York State, Denver, Bay Area, Cook County, Charlotte and Bermuda) through your phone, I worked on font end and provided web services to support phone applications submit tips (text/picture/video), maintained Crimstoppers app for android (android1.6/2.2/2.3)

Development Environment:

Windows Server 2008, VS 2010, ASP.Net42.0 JavaScript, jQuery, Json, HTML, CSS, C#, MS SQL Server 2008, TFS,Google Map API,ffmpeg

Pharmacy Refill projects under cellflare website (www.cellflare.com)

Provide prescription refill service, I worked on store management module and refill request delivery module (back end and front end), include:

Store user register, store uploading, refill request delivery (fax/email) and response

Provide Web-Services (Json/XML) to support the front end and phone applications.

Delivery Cloud Message to mobile device, I coded adapter API on Android and Blackberry platform

Development Environment:

Windows Server 2003, VS 2005/2010, ASP.Net 2.0 JavaScript, jQuery, Json, HTML, CSS, C#, MS SQL Server 2000/2005, TFS, Google Map API

Cellflare website

Provide mobile device GPS location service, I worked on User management module and Mobile device app (Nokia N95/Java me, Blackberry 9000/9700)

Jobbeam website (www.jobbeam.com)

Provide job and candidate searching service looks link workopolis. I worked on Job seeker module, most important functionality include:

Job seeker register, Event/Newsletter sending

Resume posting (MS Word, PDF, Video), searching (job title, key word, category, industry, location)

Job alert creating/updating /sending, Job apply

Development Environment:

Windows Server 2003, VS 2003, ASP.Net 1.1 JavaScript, HTML, CSS, C#, MS SQL Server 2000/2005, MS SourceSafe

Third party resource:

Google Map API: searching candidate/job by location

ffmpeg: uploaded video converting

Other Custom Web Projects

Based on content management’s web applications for internal user and phone applications, I worked on back-end and front end, created and maintained Web-Services and provide JSON and XML API to support the front end/phone applications and multimedia file (video, image, PDF)/cloud message delivery: Insol, Pharmsave, Refillbuddy, Kevinmartin, Campmuskokawoods, Trishmagwood, DavidAdjey-cookbook, Bata shoe museum, Power lessons, Cresentschool, StockPicker, and Campmanitout

Software Developer (co-op) Feb 2006 - June 2006

Platform Computing Inc, Toronto, Canada

Added new functions into log file view tool using C#, Designed, developed, tested Cleanup tool 1.0/1.1/1.2 for Symphony 2.1/Symphony 2.2 using VBScript, WMI

Business Analyst Feb 2003 – Apr 2004

Business Intelligence Dept. Si-Tech Software Co. Ltd., Sichuan, China

Business Intelligence Dept. Si-Tech Software Co. Ltd., Sichuan, China

This company is a one of biggest integrated business operation support system(BOSS) providers in Telecommunication industry. As a Business Analyst in reporting team,

My client was Sichuan branch of China Mobile (As Rogers), I worked for The Data center department.

My main work was collected and provided required data for management and business decisions from a large size data source, these data distributed on 12 Sybase database servers (several million mobile customers account information/per server, 6 months on-line data, such as customers statements, outcome/income voice calling records), my daily task included:

Designed, developed and deployed BI/OLAP system using data warehousing technology, built and designed cubes using SQL Script, Unix K Shell, Sybase, Cognos, C

Devised, wrote and debugged programs from multi-database (SQL Server, Sybase, DB2)

Analyzed, reviewed and rewrote programs to increase operating efficiency or adapt to new requirements.

Troubleshot, Identified and fixed bugs in existing application systems on C/UNIX (Sun Solaris)

Projects (Team leader):

Integrated Business Reporting System for Sichuan branch

Design API with billing system, Business operation system and outsource apps

Get data and technology support from billing team, environment management team(Database and Server), client and third-party suppliers.

Develops the Project Plan and manages the team’s performance of tasks. make sure the progress on schedule with acceptable quality

Business Operation reports upgrading

Designed and Developed new sub-system using SQL, K shell and Cognos tools, include:

Finance reports: income/profit/cost report with regions/branches

CRM platform and Client supporting workstation

Software Programmer Jan 2002 – Aug 2002

Top Group, Shenzhen, China

As a team leader worked for HaWei technology co. Ltd (AS Cisco System)

Project: TCP/IP protocol stack under embedded real time operating system term RTOS

Made Project plan, distributed tasks, organized weekly Technology meeting, code review scheduled control

Planned, wrote and implemented system test project

Developed Stock layer codes using C, TCL/TK, VxWorks, pclint

Designed, constructed and modified test environment under Windows NT/9x and C

Software Programmer Jan 2000 – Dec 2001

Person Pharmacy co. ltd. Chengdu, Sichuan China

I work in the Computer Network Department as a Computer Programmer, being involved in the development of Hospital Information System 2000 FOR 98/NT using VB 6.0, SQL SERVER 7.0/2000/ ORACLE 8

Software Programmer Jan 1999 – Dec 1999

Chengdu Dao Yuan Software Co. Ltd., Chengdu, Sichuan China

I worked as a computer programmer in the hospital products department of the development center. I participated in the development of the HOSPITAL INFORMATION SYSTEM 2.6 FOR 98/NT using VB 6.0 MS Access/SQL SERVER 6.5/7.0, Project98, SourceSafe 6.0

Software Programmer Sep 1997 – Dec 1998

Golden Abacus Financial Software Co. Ltd., Chengdu, Sichuan China

Developed the Decision Support (BI) system

Responsible for detailed design of modules and code writing, using VB 5.0/6.0, MS Access/ SQL Server 6.5/Oracle 7.3, Project 98 and SourceSafe 5.0

Provided system trouble diagnosing and fixes as well as customer service

Education

Bachelor, Computer and Application (Computer Science) 1997 - 2000

Chengdu University of Electronic Science and Technology of China, China

Diploma, Computer and Application (Computer Science) 1990 - 1993

Sichuan University, China

REFERENCES AVAILABLE UPON REQUEST

Contact this candidate