Sql Server Microsoft Office

************@*****.*** Cell 416-***-****

SUMMARY

Over 8 years of experience in software design, development, documentation, Implementation and testing of web based and client/server applications.

Extensive knowledge in .NET Framework 1.1/2.0/3.5/4.0/4.5, ASP.NET(C#/VB), C#.NET, VB.NET

Proficiency in HTML5, CSS3, Javascript, VBScript, AJAX, Web Services, Crystal Report, Fusion Charts

Experienced working with Oracle 8/8i/10g/11g, SQL Server 2000/2005/2008/2012, Access databases

Expertise in complete System Development Life Cycle (SDLC) and familiar with 3-tier Architecture Applications

Highly worked with Visual Studio 2008/2010/2012, Microsoft Visio, TOAD, IIS 6/7/8/10

Expertise in DotNetNuke CMS 7.0 and 8.0.

Hands on experience in debugging and fixing the bugs and also good at after hour support

PROFESSIONAL EXPERIENCE

Chartwell Retirement Residences, Mississauga, Canada February, 2016 – Present

Web Developer

Proposed development were in line with LOB Architecture roadmaps, standards and strategies

Responsible for design and developed business logic, data access layer based on database architecture.

Worked closely with solution architect to discuss strategies, development and implementation plan for LOB requirements.

Developed & implemented .NET integration with legacy system

Deploy application on UAT also worked with LOB's in UAT and Production phase for running test cases and get UAT & Production sign off

Interaction with Stakeholders/LOB's for requirements gathering

Working with Online presence team and reporting to Online presence Director

Worked with solution architect to create complex Stor-proc of Sql server database.

Refactor existing code with new frameworks

Translating mockups & Use Cases and wireframes into functional code

Contribute to development and troubleshooting of existing and new applications

Mentored new team members for product architecture, product functionality and coding standards

Tech Environment: ASP.NET(C#), .NET Framework 4.0/4.5, Microsoft Visual Studio 2012 / 2015, Team Foundation Server 2012, Microsoft SQL Server 2012, HTML, CSS, JavaScript, AJAX, XML, JSON, Web Services, Windows server 2012, Windows 10, IE 11, Microsoft Edge, Fiddler, Beyond Compare, FileZilla, VPN (Junos Pulse / GlobalProtect), Bootstrap, Wordpress CMS, MS SQL

Enghouse Networks, Markham, Canada October, 2010 – February, 2016

Programmer Analyst

Create design document based on requirements\specification documents

Designed, developed telecom software called "Pulse INP (Intelligent Network Platform) Manager" as a team leader that allows a carrier to manage their entire telecom network from a web interface. Through the Pulse INP Manager, carriers can upload supplier, rate and other routing information directly to switching devices, regardless of the switch’s location. This enables completely centralized routing implementations providing unlimited data and easily managing the complex rate and LERG table process.

Design, develop, test and deploy Telecom WEB/Database applications like Least Cost Intelligent and Wholesale Routing, Enhanced Toll-Free message routing and Peering network utilization application developed using ASP.NET (C#) and Oracle 10g/11g database.

Worked on Telecom distributed database system consists of OLTP and Warehouse databases which required 10 milliseconds response time and handled 450 million records table. The Distributed system consists of average 4 database servers.

Install platforms and provide 1st level support to customers regarding issues with the pulseINP product set.

Create new or modify existing user documentation(e.g. job preparation instructions, run dependencies, recovery procedures)

Tech Environment: ASP.NET(C#), Entity Framework, .NET Framework 2.0/3.5/4.0, Microsoft Visual Studio 2008/2010, JavaScript, AJAX, CSS, Web Services, Oracle 8/10g/11g, Microsoft Visio 2000, Windows server 2008 R2, Linux

TD Bank Financial Group, Mississauga, Canada May 2009 – September 2009

IT Analyst – Internship

Developed Web based JIRA Reports using SQL database which are useful to track the activity of employees of IBM. JIRA Reports cover Service Level Agreement reports, Enhancements hour status report, Overview project Accomplishment, Resource Assignment, Problem Management Record Metrics, Utilization of server by days and Major & Minor Enhancement report.

Developed Financial Dashboard Reports for Information Delivery and Capability Solution department. Financial Dashboard Reports cover FTE Allocation & Utilization report, Work Load Balance, Recovery Quarterly Breakdown and Quality Sigma Report.

All reports covers statistical data and graphical solution.

Upgrade WebPages to wiki WebPages for Hardware Service, IT Asset management, Problem & Change management team, Operational best practices, Incident management etc.

Tech Environment: ASP.NET(VB), .NET Framework 2.0/3.5, Team Foundation Server 2008, SQL Server 2005, SSRS, Microsoft Visio 2000, JIRA

Parikh Impex Pvt. Limited, Gujarat, India January 2007 – December 2007

Senior Software Developer

Developed Store & Purchase module of ERP system using VB.NET 2005 and SQL Server 2000

Evaluated and applied requirements and specifications received from store and purchase department and designed an efficient data workflow process.

Was solely responsible for the database design and also designing the Windows forms for the modules like quotation, purchase order, goods received note, inspection, return goods or generate purchase invoice etc.

Designed and developed stored procedures, views and triggers to validate data and ensure system integrity for various tests based on different specifications.

Generated reports for consumption register, stock summary, pending purchase order, gate inward outward register, rejection summary, material requisition register, invoice register, Buyer’s purchase order etc.

Maintained existing attendance RFID system, generate reports.

Modern Denim Limited, Gujarat, India January 2006 – December 2006

Project Trainee

Developed Human Resources Management System using C#.NET and SQL Server 2000.

Analyzed requirements of HR department to re-design the database.

Designed and developed Windows forms for employee management, attendance and leave management, performance appraisal etc.

Developed single click payroll calculation.

Generated reports for salary statements, employee salary slips, government reports, attendance reports, leave reports etc.

ACADEMIC PROJECTS

Centennial College, Semester-8 January 2010 – April 2010

College Academic Research Center Project-MVC Framework (C#), ASP.NET3.5, SQL SERVER 2008

Developed Ethics form in ARC project by which user can add, update, edit and delete ethic information of a particular submitted project.

Developed different documents such as SRS, Test Plan, Use Cases and User manual plan.

Centennial College, Semester-7 September 2009 – December 2009

Hospital Management System - ASP.NET2.0, SQL SERVER 2005

I developed the modules such as Admin, doctor and Staff.

Admin can add, update and delete doctor, patient and login information of staffs.

Doctors can track information of visited patient and determine whether patient is in or out patient.

Staff can track patient's personal and visited information.

EDUCATION

Centennial College, Ontario, Canada January 2008 – April 2010

Software Systems Design Applied Degree

GLS ICT College, Gujarat University, India September 2003 – July 2006

Master in Computer Application

Sahjanand Arts & Commerce College, Gujarat University, India September 2000 – April 2003

Bachelor in Commerce

SOFTWARE SKILLS

Languages, Tools & Technologies

.NET 1.1 / 2.0 / 3.5 / 4.0 / 4.5, C#.NET, VB.NET, ASP.NET (C# / VB), ADO.NET, Visual Basic 6.0, Core JAVA, JSP, ASP, HTML/CSS, DHTML, XML, JavaScript, VBScript, AJAX, AngularJS, Web Services, SOAP

Database Development Tools

Microsoft Access 2007, MS SQL Server 2000/2005/2008 (Stored procedures, Functions & Triggers), Oracle 8 / 8i / 10g, PL SQL

Software Tools

Microsoft Visual Studio 2008/2010/2012, Eclipse 3.0, Microsoft Visio 2000, Microsoft Office 2007, MS FrontPage 4.0, DNN/WordPress CMS

Mobile Programming

Android, Blackberry

Other Tools

Microsoft Office (Word, Excel, PowerPoint, Project, Visio), Crystal Report, Fusion Charts, SQL Server reporting services (SSRS)

OTHER SKILLS

Implementing software development life cycle policies and procedures

Ability to manage and support multiple projects concurrently, meet deadlines and work under pressure

Excellent problem-solving skills with a creative mind and willing to look beyond general limiting constraints

Capable of rapidly learning new technologies and processes, and successfully applying them to projects and interpersonal communication skills

Highly adaptable in quickly changing technical environments with very strong organizational and analytical skills

Hard worker with excellent leadership and teamwork skills

REFERENCES AVAILABLE UPON REQUEST

Contact this candidate