Post Job Free

Resume

Sign in

Software Engineer Sql Server

Location:
Canada
Posted:
August 17, 2016

Contact this candidate

Resume:

FAISAL SIDDIQUI

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

PROFILE

A motivated and result-oriented IT professional with 10+ years of experience in analysis, design and development of client/server, web-based and n-tier applications. Functional domain experience in Financial, Insurance, Logistics, Sales, Pharmaceutical. Health and HR. Expert in developing Web applications, Windows application, Windows services and Web/WCF services in .Net using C++, C#, VB. Net, ASP. Net, ADO.NET and SQL Server. Responsive UI Development using open source technologies .Possesses strong analytical and problem solving skills and effective in working independently and collaboratively in teams.

TECHNICAL

.

Languages:

C++, C#, and VB.Net

Technologies:

.Net Framework, ASP, ASP.Net (using C# and VB.Net), Win Forms, VB6 AJAX, ADO.Net, Web Parts, COM/COM+, Web Services, XML/XSLT, Windows Services, WCF Services, WPF, MSMQ, IBM MQ, MVC, SOAP, Entity Framework, JavaScript, JQuery plugins, AngularJS, Bootstrap, CSS, HTML.

Framework/Tools:

.Net 2.0, 3.5, 4.0 & 4.5, Visual Studio 2003, 2005, 2008, 2010 and 2012

Designing Tools:

Erwin and Microsoft Visio

Reporting & Integration Tools:

SSIS, SSRS 2005, 2008 R2 and Crystal Report

Database:

MS SQL Server 2000, 2005, 2008 R2 & 2012, MySQL, Oracle 11 g

Other Tools:

Ms TFS (2010, 2012) and Visual SVN (for Version Controlling), IIS, ANTS Performance Profiler and MS. FxCop for Code review, Infragistics and Telerik (third party UI Controls.)

PROFESSIONAL EXPERIENCE

COLLEGE OF FAMILY PHYSICIAN OF CANADA Mississauga, ON

IT Consultant/Lead Developer Feb 2015 – till date

Representing more than 35,000 members across the country, the college of family physicians of Canada (CFPC) is the professional organization responsible for establishing standards for the training, certification and lifelong education of family physicians and for advocating on behalf of the specialty of family medicine, family physicians and their patients. The CFPC accredits postgraduate family medicine training in Canada’s 17 medical schools.

MainPro+ Portal/Integration Solution

MainPro+ is a robust program that will cater to continuing professional development of CFPC members. It will aim to provide participation guidelines, enable convenient tracking and monitoring and ensure high quality programming through a rigorous peer review process. Overall, the system will be very intuitive and have avenue for new reporting categories and wider range of credits and is replacing the earlier version of Mainpro.

Self-Learning - Subscriber Portal Solution

The Self Learning Subscriber Website is used to publish the online version of the Self Learning journal in English and French in both PDF and interactive formats while the Question Creation Tool is a collaborative space for those involved in the journal’s production to create, edit and organize Self Learning questions and issues. The Self Learning project is to re-design and develop the Self Learning Subscriber website and the Self Learning Question Creation Tool and their integration with the current Admin Tool. Together, this will offer a new and improved user experience allowing our subscribers to access online issues of the Self Learning Program, purchase or renew subscriptions, purchase back issues, and claim credits for participating in the Self Learning program.

Responsibilities:

Translate application storyboards & use cases into functional applications

Design, build & maintain efficient, reusable & reliable code

Ensure the best possible performance, quality & responsiveness of applications

Identify bottlenecks & bugs, and devise solutions

Completes applications development by coordinating requirements, schedules, and activities; contributing to team meetings; troubleshooting development and production problems across multiple environments and operating platforms

Assisting PM in all SDLC phases and using scrum methodology and TFS to handle project management

Education/knowledge and experience:

Host & Configure TFS 2013 for code repository. Did customization for PMs and BAs so they can utilize it for their scrum/agile methodologies.

Design and Developed Windows services (ETL based) to integrate with vendor applications, using JSON object to communicate with their system.

Implement front-end SPA's (single-page applications) that utilize RESTful services (Web API using C#) via AJAX. Extensively leveraged JavaScript open-source libraries and frameworks (AngularJS, jQuery).

Writing extensive and advanced LINQ queries and leveraging Entity Framework to overcome SQL store procedures complexity.

Developed critical monthly SSRS reports for Membership department so they can forecast future revenue.

Tuning DB design and schema for efficiency and better performance.

Use of time: 30% designing, 70% Programming

Technical Environment: VS 2010/2012, C#/VB.Net, MVC/Web API, Entity Framework, LINQ to XML, LINQ to SQL, AJAX, JavaScript, JQuery Plugins, AngularJS, Bootstrap, Windows Form, Windows Service,SQL Server, SSRS

BRINKS CANADA LIMITED Mississauga, ON

Sr. Application Developer Jun 2012 – Jan 2015

Brinks Incorporated is a leading provider of armoured car transportation, ATM servicing, currency and coin processing and other value-added services to banks, retailers and other commercial and governmental agencies around the world.

Brink’s Customer Portal

Complete redesign of the Brink’s old ticketing system into a fully responsive website that provides consistent user experience on all environments (PC/Laptops/tablets). This portal helps technical support staff and Brink’s customer to track and log support incidents and service requests. It automatically generates new call tickets and updates existing call tickets via Microsoft CRM dynamic services.

This portal also helps finance team to generate LOCKBOX files for Oracle PeopleSoft. End users can import billing invoices from external sources like Excel, text files etc. and then select invoices for LOCKBOX files.

KRONOS Customs Reporting and Integration

Kronos Workforce Central is a complete set of human resource and workforce management applications including Kronos HRMS, payroll, time and attendance, absence management, scheduling and more. Thousands of companies and millions of users in more than sixty countries use Kronos software every day to effectively manage their most important resource - their employees. In fact, the system is in place at more than half of Fortune 1000 organizations.

NCR Data Integration with legacy Software

NCR Corporation is the global leader in consumer transaction technologies including ATM business.

Brinks Canada has outsourced most of the First Line Maintenance (FLM) services of ATMs to NCR.

This project was launched at the end of 2011 and phased approach was chosen. Phase 1 was used in one way communication to NCR system via electronic means. Phase 2 was responsible for full 2-way process of creating; updating and closing calls in the NCR ticket system as call are process in Brink’s end.

Responsibilities:

Ensured accuracy & integrity of data & application through analysis, coding writing clear documentation and problem resolution

Analyzed & translated function specification & change requests into technical specifications

Coordinated and worked closely with the business/SMEs to identify the problems and ensure business requirements are met.

Maintained legacy software integration and provide requested reports (Billing/daily/Weekly/Monthly branch level reports) and queries from the data.

Ensured code development is consistent with company development standard and aligned with industry guidelines and best practices.

Provided post-production application support as required. Responsibilities include problem identification, troubleshooting, data analysis and emergency bug fixes.

Education/knowledge and experience:

Developed application architecture for above work. Evaluated and recommended changes to current legacy architecture.

Identified usability and developed functional and smooth, easy to operate and eye catching web applications.

Designed and implemented Single Page Application (SPA) using HTML, JQuery Plugins, AngularJS, Bootstrap, Web services/WCF.

Used SSRS 2008 for custom reporting and use web service as a data source

Used SQL jobs for nightly data transfer and email notifications.

Data integration through WCF & Windows Service

Agile/Scrum environment

Use of time: 30% designing, 70% Programming

Technical Environment: VS 2005,2008 and 2010, ASP.Net using C#/VB.Net, MVC, Entity Framework, AJAX, JavaScript, JQuery Plugins, AngularJS, Bootstrap, WCF, Web Services (SOAP),Windows Form,SQL Server, SSIS, SSRS

AMERISOURCEBERGEN CANADA (ABCC, Fortune - 50 Companies) Burlington, ON

Sr. Developer/Team Lead Jan 2011 – Jun 2012

AmerisourceBergen Canada (ABCC) is a leading supplier in pharmaceutical distribution and service solutions. Servicing both healthcare providers and manufacturers in the pharmaceutical supply channel, AmerisourceBergen Canada provides distribution and service solutions designed to reduce costs and improve patient outcomes.

ABCC Portal Solution

Its internet-based order management system that allows pharmacies(Pharmacist and Front Store Managers) to place and manage their orders, returns online and access accounts information(like Invoice/Credit Notes, Statements). It also provides instant access to extensive product information and product availability, as well as purchase statistics. Report Portal is a real time, web-based reporting portal. It is a user-friendly tool designed to monitor project progress through confidential accounts. As an ABCC Canada client, you can securely and easily access up-to-date information in your account as often as you need. Any of the standard or custom reports we currently deliver can be made available through ABCC Report Portal.

Responsibilities:

Developed programming applications that support the goals of the organization according to agreed standards and guideline

Performed unit tests on the applications prior to handover to Systems Analysts / Business Analysts to ensure that the applications team is satisfied with the quality of deliver

Provided inputs to technical specification

Mentored junior staff in developing their skills to ensure further career development and succession planning

Education/knowledge and experience:

Used N-Tier Architecture for presentation layer, the Business and Data Access layers.

Development of unit test plan

Supporting and mentoring junior staff in development work

Develop new functionality on our existing software product

Using MVC Pattern

Daily Scrum meeting

Use of time: 40% designing, 60% Programming

Technical Environment: VS 2005 and 2008, ASP.Net using C#/VB.Net, Windows Form, SQL Server, AJAX, ASP.Net Web Parts, JavaScript, JQuery, XML/XSLT, Web Services, WCF, WPF, Crystal Report, SSRS, ADO.Net Entity Framework and Ms. Enterprise Library

OTHER POSITIONS HELD:

ECUSTOMS-MSR Toronto, ON Software Engineer Oct 2007 – Dec 2010

EDS – Winsoft Corporation Ottawa, ON Software Engineer Jan 2006 – Sep 2007

TEILHARD TECHNOLOGIES St. Catharines, ON Application Programmer Jul 2005 – Dec 2005

PICIC (Investment Bank) Software Engineer Aug 2003 – Jun 2005

ERNST & YOUNG INTERNATIONAL Analyst Programmer Feb 2002 – July2003

INTERNATIONAL SYSTEM TECHNOLOGY Programmer Dec 2000– Jan 2002

EDUCATION

Master in Computer Science Karachi University

Bachelor of Science (Honors) Karachi University



Contact this candidate