Post Job Free
Sign in

Project Sql Server

Location:
Calgary, AB, Canada
Posted:
March 10, 2014

Contact this candidate

Resume:

AMANPREET SIDHU

416-***-****

*********.****@*****.***

*** ********* **** **, *******

Summary

. 7+ years of experience in Application development with C# / ASP.Net /

Silverlight.

. Played role in Requirement Gathering, Analysis, Designing, Coding

Testing and Documentation.

. 2+ years of working in Agile Environment.

. Good Communication skills, Analytical, Team player, Problem-solving

capabilities.

Technical Skill Set

Programming C#.NET, Silverlight, ASP.NET, Window Forms, ADO.NET,

LINQ, WCF Service, ASP, HTML, JavaScript

.NET Frameworks 4.5, 4.0, 3.5, 2.0, 1.1

Database Server 2008/2005, SQLite3, Oracle

Tools Visual studio 2012/2010/2008/2005/2003, TFS, Visual source

safe

Testing Experience in writing Unit test

Third Party Telerik controls, ComponentOne, GoDiagram (Diagram

tools components from Northwood's Software), Reshaper

Design Patterns Knowledge of design patterns

Experience

Vital Insights Inc August 2013 - Feburary 2014

As Sr. Software Developer

Blueprint Software Systems March 2011 - August 2013

As Intermediate Developer

Ionnor Solutions December 2008 - January 2011

As Software Developer

A1 Technology May 2006 - December 2008

As Software Developer

Education

. Masters in Computer Science

Certification/Exams

. MCAD - Microsoft Certified Applications Developer (2007)

Achievements

. Received an award for best performance in team at A1 Technology.

Projects

Vital Insights Inc. - Sr. Software Developer (August 2013 - February 2014)

Project: Foresight, a customer experience management tool for auto

industry.

Foresight is a fast, powerful and intuitive, web based, customer experience

management tool, which provides fully customizable, data driven, real time

information to auto dealers. Dealers can connect with customers using

dynamic and customizable surveys, and get real time information to act

instantly on customer feedback. Scheduled Reports provide analytical data

to point out the strengths and weakness.

Technologies: Asp.net, C#, MVC, SQL server 2008

Role:

. Working through all the layers; UI, Business and Database.

. Writing new sql queries or modifying the existing one to incorporate

new features into the product.

. Adding new features or Business rules to the product as requested by

client.

. Follow Agile methodology, participate in daily scrum meetings,

estimation and planning sessions.

Blueprint Software Systems - Intermediate Developer(March 2011 - August

2013)

Project: Blueprint Requirement definition and Management software

Blueprint provides a broad range of rich, visual requirements editors for

collecting the requirements for project. Provide different formats for

business processes, UI mock ups, domain diagrams, storyboards, and more. It

has tools to manage version control, baselines, traceability, reusability,

or security. The product lets you validate, simulate, track the progress,

and do the reviews and approvals. Have features like Email notifications,

social discussions, role-based access, and share requirements even across

multiple projects. Blueprint has integration with ALM, TFS and Microsoft

Excel.

Technologies: C#, Silverlight 5, Telerik controls, Component One RichText

Box, MVVM, Async programming, Design patterns like Singleton and Factory,

WCF RIA services

Role:

. Implementing new features or enhancing the existing ones in the

product, working through all the layers from User Interface, Business

logic and Database.

. Write unit test and Integration test for the new and existing features.

. Work closely with Business Analyst, Project Managers and QA team.

. Fixing the bugs/issue reported by Customers, sales team and internal QA

team.

. Follow Agile methodology, participate in daily scrum meetings,

estimation and planning sessions.

IONNOR Solutions - Software Developer (December 208 -January 2011)

Project: Pulsen Combine Silverlight Controls (For Pulsen Applications,

Sweden)

. Recurrence Control - It is s control for generating the occurrences of

an Event by selecting the schedule parameters. Its functionality is

similar to the Outlook's Recurrence control.

. HTML Editor - It uses a Rich textbox control to display the HTML code,

with highlighting the syntax (as the HTML syntax is highlighted in

VS). Enables the user to modify the HTML code and preview the same.

Technologies: C#, Silverlight

Role: Design, code, test, documentation

Project: Khepri (For Pulsen Applications, Sweden)

Khepri is an Enterprise level application for Organizational Role

Management.

Technologies: ASP.NET, C#.NET, LINQ, SQL Server 2008, Oracle

Role:

. Restructure the code to separate it into Business logic, Data Access

and Common functions.

. Modification of Data Access layer in order to provide support for SQL

Server 2008. Previously Khepri supported only Oracle database.

. Convert the entire Oracle in line queries to the Oracle Stored

Procedures.

. Develop equivalent Stored Procedure for SQL Server 2008. Provide

alternatives for Oracle Sequences, Connect To Prior clause,

SYS_CONNECT_BY_PATH clause etc.

. Develop Nuint Test case project for testing purpose.

. Testing, Bug resolution by root cause analysis.

Project: Optimization Module (For Pulsen Applications, Sweden)

This module produces a Time based schedule for Employee to Visit the

customers on a particular day for cost reduction and performance

enhancement. There are different parameters which governs the logic of

scheduling. The schedule can be based on the Priority of Visits, the

distance travelled by Employees, the Time of the Visits or the Relationship

between the Employee and the customer. The optimization engine gives the

ideal schedule for the set of parameters.

Technologies: Window Forms, C#.NET, WCF Web Service

Role:

. Developed a WCF Service, which is responsible for scheduling the

Visits for the Employees.

. Developed the algorithmic logic for scheduling the Visits based on the

parameters provided.

. Developed a GUI component which displays the time slots for the

Employees and the Visit timings.

Project: VisAlfa Dokplan (For Pulsen Applications, Sweden)

It is tool for illustrating processes and activity flows. Enable the user

to make process maps that are more clear and easy to grasp. It is a best

tool for Analysis and documentation of business processes.

Technologies: Window Forms, C#.NET, GoDiagrams

Role:

. Developed a Rule Engine. It shows a warning message in status bar of

application when ever a rule specified in an ".ini" file is violated.

The rule engine is event driven.

. Partial Import/Export of .vis file project.

. Developed a Rich Text editor for writing notes. Included support for

selecting Font type, size, bullets, bold, italic, underline, text

alignment, Color Picker options.

. Exporting the sidenotes to the HTML with text formatting by applying

css tags.

. Exporting the .vis file to XML format.

. Incorporated a new BPNM methodology in VisAlfa.

. Added functionality to Save and Load the templates.

. Other minor/major modifications in existing modules and resolving the

bugs.

A1 Technology - Software Developer (May 2006 - December 2008)

Project: www.ibuyer.com

Technologies: ASP.Net, C#.Net, JavaScript, SQL Server 2005, AJAX

Project Description: This is a site for selling and buying of old vehicles.

One can register on the site to add his vehicles to the inventory. The

users can also add their requirements for which they get alerts through

emails. Users can search, save, and set alerts for the vehicles.

Project: Online Business Expense System (For Siebert Brandford Shank & Co.

LLC, USA)

Technologies: ASP.Net, C#.Net, JavaScript, SQL Server 2005

Project Description: This system will allow your business expenses to be

processed more efficiently, as it provides many benefits like :-Automatic

compliance and/or business approval of certain expenses, if they are within

the firm guidelines; Elimination of paper copies of expenses to be mailed

to management for approval, as approvals are now done on line (although

hard copy still needs to accompany receipts sent to the controller); and,

Expedited check processing on approved expenses since expenses will no

longer need to be re-input by the accounting department.

Project: www.Livehire.com (For LiveHire, New Jersey, USA)

Technologies: ASP.Net, C#.Net, JavaScript, SQL Server 2005

Project Description: This is a Job interviewing site for Candidates,

Employers and University/ Colleges. Employers identify a candidate he or

she would like to interview and an invitation is sent via a mail.

Candidates log in and can accept the invitation to interview. On scheduled

date and time employer and candidate log in for real time interview.

Project: www.propertiesmls.com (For PropertyVertical, Chandigarh)

Technologies: ASP.Net, C#.Net, JavaScript, SQL Server 2005

Project Description: Propertiesmls.com is site of PropertyVertical for the

dealers. They can register on this site and organize their data about the

properties, maintain the contact list, send latest news about real estate.

They can view the properties submitted to the site.

. Recreated the website in ASP.NET from ASP.

. Modify the Existing functionality and added new features.

. Resolve the bugs reported by QA, Property Vertical members and Users.

Project: www.propertyvertical.com (For PropertyVertical, Chandigarh)

Technologies: ASP, VB Script, JavaScript, SQL Server 2005

Project Description: Property Vertical is a Chandigarh based Real Estate

dealers. Propertyvertical.com provides facility for advertising the

property by dealers or owners. User can search property according to their

requirements. It provide location wise search using the maps of respective

locations. It lists the upcoming developments or projects.

. Resolve bugs reported by QA, Property Vertical members and Users.

. Modify the existing functionality and add new features such as daily

news, featured projects etc.

Project: In-house library of java script functions (For A1Technology,

Chandigarh)

Technologies: JavaScript

Project Description:

. Created In-house library of functions to provide ready to use

functions for the projects. It includes validation functions for -

strings, alphanumeric, numeric; email, phone numbers in specific

format, dates in different formats, zip codes etc.



Contact this candidate