Post Job Free

Resume

Sign in

Customer Service Sql Server

Location:
Oakville, ON, Canada
Salary:
85000/yr
Posted:
January 01, 2016

Contact this candidate

Resume:

TECHNICAL SKILLS

Proficient in developing applications in ASP.NET web portal forms using ADO.NET, EPF, AJAX WCF, WPF, MVC, MVC2,MVC4,MVC5(learning) and Dynamic Data Templates.

Extensive knowledge in WINFORMS / custom user controls and developer express (DEVEXPRESS).

Experience in website development including HTML5, XML, PHP, CSS, JAVASCRIPT JQUERY

JSP, JavaScript, SQL (Oracle)

Practical experience in C# .NET 3.0/3.5/4.0/4.5 programming with LINQ and many .NET add-ons within Visual Studio 2010 & 2012

Working knowledge of Microsoft SharePoint 2007 & 2010.

Possess excellent skills with SQL Server Management Studio 2008: SQL, Views, Tables, T-SQL, Stored Procedures, and Aggregate Functions.

Well verse in C/C++ Programming, understand how to use and interpret this language.

Able to install, configure and maintain hardware, software & peripherals with effective troubleshooting & problem solving skills

Familiar with LAN and telecommunications concepts.

Experience in many applications support.

PROFESIONAL EXPERIENCE

System Analyst July 2015 – Present

CRM Dynamics, Mississauga, ON

Configure, Deploy, customize and maintain CRM application (Microsoft Dynamics CRM).

Knowledge of programming procedures and programming languages including C#, JavaScript and fundamental knowledge in SVN tortoise.

Knowledge of IIS and web technologies

Develop and test programs and programming modifications; Wrote testing plans for others to test their work.

Delegate CRM plugins and data loaders to the development team. Ensured code consistency and managed the project time line.

Plan and perform data migration into the new systems.

Create reports, forms and other deliverables for projects and tickets.

Write and maintain programming and project documentation based on provided specifications.

Provide end-user and system administrator training in on-site and remote formats.

Understands and uses programming and documentation best practices.

Continuously improve knowledge through reading and self-study.

Install applications and configure environments for use in development, testing and production.

Mapping requirements; participating in the finalization of product specifications and selection of appropriate technologies.

Configure the application to meet a client’s requirements using the Microsoft Dynamics CRM Customization Tool, Workflow Tool, or SDK.

Design and integrate business processes and data flows between CRM applications and other applications, such as back office/ ERP applications.

Lead technical discussions with clients.

Analyze front office processes (sales, marketing and customer service) to identify opportunities for improvement.

Perform gap analysis between a client’s requirements and the functionality within Microsoft Dynamics CRM.

Configure the application to meet a client’s requirements using the Microsoft Dynamics CRM Customization Tool, Workflow Tool, or SDK.

Software Developer April 2014 – June 2015

Vital insights, Mississauga, ON

Develop, maintain and build on existing ASP.NET MVC 4 platforms.

Experience with .NET 4.0, 3.5, 3.0 and 2.0, C# and VB.NET, ASP.NET, MVC2,MVC4 AJAX,[XAML], LINQ.

Fundamental knowledge in team foundation server (TFS).

Good Knowledge of Performance Tuning for SQL Server Queries and Stored Procedures.

Debug, test and ensure code is properly tested by deployment to development databases and QA databases.

Establishing proper communication among the different delivery locations.

Mapping requirements; participating in the finalization of product specifications and selection of appropriate technologies

Technologies: .NET 4.0/3.5/3.0/2.0/1.1, C#, VB.NET, ASP.NET, AJAX, LINQ.

Software Developer / IT Specialist June 2011 – April 2014

Crosslink Technology, Mississauga, ON

Involved in complete Life Cycle including Analysis, Design, Development and Testing.

Programming in ARAGO (DOS) Language, C# WINFORMS, Visual Basic, JavaScript, SQL, T-SQL.

Developed modules of the application in ASP.NET Web forms, Silverlight and involved in writing C# Projects.

Used Web services to communicate with the business layer objects.

Created and worked with dependency, attached and complex properties and plugged them into different development scenarios.

Coding the presentation layer using WINFORMS.

Creating custom site pages, lists, views and master pages and adding ASP.NET Controls, using WPF, AJAX.

Developed WCF services to enable effective communication between SOA.

Accessing SQL Server 2008 from a WINFORMS application.

Implementing LINQ queries on different data sources in Web applications and WINFORMS applications.

Worked with Ajax enabled WCF services using C# and ASP.Net.

Implemented WINFORMS / user controls in creating custom controls

Proficient in HTML, CSS, Jscript, Net Beans and C# ASP.NET web development

LINQ to SQL C# / OLEDB Connection strings.

Used MYSQL and worked with OLE DB database along with .DBF conversions for SQL.

Set up new SBS 2012 server to run / migrate ServerNT 2003 emails and Sharepoint.

Maintained windows server 2000/2003./2008/2012, set up scheduled tasks to run on the computer every night along with scheduled backups transported to an outside company.

Managed and maintained all I.T purchases along with consulting past purchased orders

Technologies: ASP.Net, C#, .Net 3.0/3.5/4.0, WPF, WCF, Silverlight, AJAX, Visual Basic, JavaScript, SQL, T-SQL, MYSQL, SQL Server 2008, Developer express, HTML, CSS, JavaScript,

Computer Programmer August 2010 – February 2011

JPL Vehicle Management Services. Etobicoke, ON

Developed and modified Companies website at www.jplvms.com.

Proficient in HTML, CSS, Jscript, Net Beans, WINFORMS and C# ASP.NET web development.

Created, modified, managed, troubleshoot, quality assurance tested many console and windows forms programs.

Achieved an Intermediate Microsoft SharePoint certificate in programming with C#. NET. This included scripting in administration pages and new site pages.

Learned how to create workflows, manage user groups, user permissions, advanced Site content and manage administrator pages.

Supported fellow colleagues with creating various database queries and exporting them to their individual excel sheet. Created my own functions and procedures in our database.

Excellent skills in MS SQL server 2005.

Proficient in creating tables and setting specific primary and foreign keys to their proper value in other tables. Know how to create, update, insert and delete tables.

Help other departments troubleshoot vehicle errors on programming side. (Amount errors/ billing errors).

CERTIFICATIONS:

Microsoft SharePoint Certificate.

10267A:Introduction to Web Development with Microsoft Visual Studio 2010.

Help Desk/ Hardware/AV Technician (part - time) September 2009 – October 2011

Town of Oakville, Oakville, ON

Provide effective customer service to staff, council members, fire stations, etc.

Set up, operate and maintain A/V (audio and visual) equipment in council chambers. Record and edit many mayoral and council meetings for Cogeco broadcast, using FinalCut and Adobe Flash Encoder with Mac OSX

Develop documentation for various applications for IT staff

Manage servers, switches/routers

Train new staff in procedures

Keep current with technology to ensure technical skills are at required levels

Completed final work term at the Town and currently am a part time IT staff memb

IT Support Fall 2008

Halton District School Board, Burlington, ON

Worked as an I.T representative for the region of Halton

Trouble-shoot and replaced all PC and Mac computers for Halton public schools

Trouble-shoot network drops and activated new ports

IT Support Centre Technician Winter 2008

Sheridan College, Oakville, ON

Assisted students, faculty, and staff with laptop issues and assisted teachers with any podium related issues, such as VCRs, DVD players, projectors, desktop computers and any software issues

Troubleshoot and resolved technical support issues including printer problems using Secure Shell Host, and data projector problems

Assigned laptops to students and faculty, signed out instructional equipment to faculty

Image, QA and cleaned laptops and desktop computers

Provided technical support for hardware, software, and peripherals, laptops, desktop supported classroom and lab technologies

Provided procedural information to staff, faculty, and students; reset password and profiles for students

Trained new co-op students in tasks and procedures

Built, setup and configured desktop computers in classrooms, and installed software

Built and repaired network cables

PROJECTS

WINFORMS - Datasheets Production & CRM : An employee login application with connection to our SQL server that enables the user to have access to a custom developed CRM which includes, Sales check based on function selection (Date frame, customer, product to customer, current open orders, total sales) this sales check application exports customized reports, charts and graphs for the user. This feature also has the ability to view customers / add notes / insert documents stored on our server and view / delete & modify. CRM shows customer prices (all history of prices saved if they have changed) along with an extensive exporting method for custom customer quotation. Ability to enter in Sample requests with a whole customized SQL database. (Orders, Shipments, Follow-ups). This all has a customized reports and charts as well.

WINFORMS datasheets :A datasheets application where Lab & Chemists may enter in new Datasheet formulas and have them generate plenty of complex calculations at the press of a button. I used Aggregate functions and stored procedures to produce these results. All datasheets are stored on the server with the ability to customize and modify them through C# winforms.

WINFORMS management system: production Team shows the current batches based on orders, Creates CofC’s C of A’s if the user requires them. This software will tell you what is due within the data and what is late with customized reports & charts.

ASP.NET - OEM web portal: I have had the opportunity to work on a variety of different OEM manufacturer’s employee and regional login websites. These OEM include infinity, BMW, KIA, Jaguar, Landrover, Mini and VW. These website show the customer experience relationships. With a labyrinth of KPI’s and dataflow charts shown from Regions to dealerships and to individual employee performances.

ASP.NET web portal: application that allows the customer to login and view their orders using a wide variety of filters.

EDUCATION

Computer Engineering Co-op Technology Diploma Fall 2006 – Fall 2009

Sheridan College, Brampton, ON

oCourses included: Problem Solving/Programming Logic, Object-Oriented Programming 1 – JAVA, Internet site development, C, Assembly language, Advanced Programming, Advanced Networking. Application support. Electronic Fabrication, Applied Electricity, Advanced Electricity, Mathematics.

Leader ship development series (LDS) CERTIFICATE 2014 – Present

Sheridan College.

oCourses included: Creative thinking, leading responsibility, leading teams, managing change, performance management, communication, professional business communication, human relations, finance and employment law for leadership

Ontario Secondary School Diploma 2006

Holy Trinity Catholic School, Oakville, ON

ACTIVITIES / INTERESTS

Soccer, golf, snowboarding, hockey, movies

Computers, computer programming, help family and friends with computer issues



Contact this candidate