Post Job Free

Resume

Sign in

Sql Server .Net

Location:
British Columbia, Canada
Posted:
May 11, 2015

Contact this candidate

Resume:

Fahad Javed

***** ******** **** **

Home Phone : 587-***-****

Calgary, AB. T3A5B9

Email : acpmpe@r.postjobfree.com

Significant Expertise

. Software development for both server and client platforms including

Web based systems and services, Client/Server multi-tier applications,

GUI, and databases.

. Expertise in data modeling, data mapping and warehousing tools.

. Consultation with customers on data processing, system integration,

specifications, customization and presentation.

. Sound analytical approach to problem solving and paying attention to

details.

. Good understanding of Design Patterns and Separation of Concerns

(Inversion of Control (IoC), Service Locator, Dependency Injection).

. Proficient in keeping abreast of new technologies, methods and

techniques to understand how they might be applied to the client's

environment.

. Highly motivated, positive, and having ability to work with minimal

supervision.

. Excellent inter-personal and communication skills.

Technical and Other Skills

Web/Client/Server Side-Technologies Experience

ASP.NET(1.1, 2.0, 4.0) 5+ years

ADO.NET 6+ years

MS-IIS (5.0, 6.0, 7.0) 10+ years

J2EE (EJB, Servlets, JSP, Java Beans, JDBC) 1+ years

Tomcat, Apache 1 year

SOAP 2+ years

ASP 1+ years

PHP 1 year

Perl Scripting (CGI, DBI) 1 year

SQL 10+ years

PL/SQL 1+ years

Infragistics 3+ years

Ajax 2 year

JavaScript 10+ years

Telerik Kendo UI 1+ year

Require JS 1+ year

Angular JS 1+ year

Bootstrap CSS 1+ year

jQuery 2+ years

LINQ 2+ year

WCF/WF/Entity Framework 5/ASP.NET MVC 2.0 & 4.0 1+ year

Programming Languages Experience

VB.NET(1.1, 2.0) 2+ years

C#.NET(1.1, 2.0, 4.0, 4.5) 6+ years

Microsoft Visual Source Safe 5+ years

HTML5/DHTML/CSS/DOM 5+ years

COM/COM+(Design, Implementation) 1+ years

XML/XSL/XSD 4+ years

Visual Basic 6 3+ years

Java 4+ years

C/C++ 1 year

Pascal 5 months

COBOL 5 months

Databases Experience

UDM DB2 1 year

Domino 1 year

Visual Foxpro 4 months

MS SQL Server(6.0,6.5,7.0,2000, 2005, 2008) 8+ years

MS-Access 3+ years

MySQL 1+ years

Oracle 7/8i/9i 1+ years

ODBC 5+ years

Business Intelligence Reporting/ETL Tools Experience

SAP Business Object Data Services 3.0 2+ year

SAP Business Object Universe 3.0 1+ Year

SQL Server Reporting Services (SSRS) 5 years

SQL Server Integration Services (SSIS) 2 years

Designing/Development/Testing Tools Experience

WebSphere Studio 1 year

Microsoft Visual Studio/InterDev 6.0 3 years

Domino Designer 1 year

Oracle Developer Suite (Form, Report, and Graph) 1 year

Microsoft Visual Studio.NET (2003, 2005, 2008, 6+ years

2010, 2013)

Rational XDE Tester 1 year

Microsoft Team Foundation Server (2005, 2010, 2013) 5 year

Rational Rose 1 year

Hardware & Operating Systems Experience

Microsoft Windows NT/95/98/2000/2003 6 years

LINUX (RedHat, Fedora Core, and Mandrake) 1 year

UNIX (AIX) 1 year

Productivity Software Experience

Microsoft Visio 2010 1+ years

Microsoft Office (2003, 2010) 8+ years

Microsoft SharePoint 2010 3+ year

Analysis/Design Methodologies Experience

UML 2 years

Object Oriented Application Development (OOAD) 5+ years

Agile Software Development 4+ years

Single Page Application (SPA) 1+ year

Work Experience

April 2014 - Present City of Edmonton, Edmonton, AB

Senior .Net/SharePoint Developer

. Created custom Publishing Page Approval workflow for SharePoint 2010

using Visual Studio 2010.

. Used SharePoint Designer 2010 to create out of the box Page Approval

workflow.

. Used client side JavaScript Frameworks Angular JS, Telerik Kendo UI,

Require JS, and JQuery to develop custom client side controls for

Business Licensing Portal. Style Sheet branding was applied using

Bootstrap CSS Framework.

. Created Document upload APIs using SharePoint 2010 Client Object Model to

upload, download, delete and view document's history from SharePoint

2010.

. Developed external facing Knowledge Base Article web site based on SPA

methodology using SharePoint 2010 Client Object Model, Telerik Kendo UI,

Bootstrap, JQuery, Angular JS, HTML5, CSS, ASP.NET MVC and Web API.

. Designed Knowledge Based Article a collaboration site for City of

Edmonton internal staff in SharePoint 2010.

. Created and customized Site Layouts, Site Collections, Lists, Document

libraries and Web Parts using SharePoint Designer 2010 and JavaScript

Client Object Model.

. Created Web Parts using Visual Studio 2010 ASP.NET, AJAX and C#.net.

. Customized third party Newsgator community web parts to allow user to

generate new community sites.

. Wrote WCF service to allow external application eService to Upload,

Download and Delete documents from SharePoint 2010 document library using

SharePoint 2010 Server Object Model.

. Responsible for bug fixing and deployment of Pet Licensing Portal using

ASP.Net 4.0, C#.Net, AJAX, JQuery, JavaScript and SQL Server 2008.

March 2009 - March 2014 Healthcare Benefit Trust (HBT),

Vancouver, BC

Systems Analyst/Lead Developer

. Conducted analysis of the scope of improvement in the existing system and

provided optimum solutions.

. Documented and interpreted user requirements into design specification.

. Responsible for maintaining and updating technical documentation for

software and systems.

. Identified risks/impacts, level of efforts and proposed risk mitigation

strategies.

. Prepared and reviewed test cases to verify the functionality and

performance of the application based on requirements.

. Worked extensively through Agile development methodology by dividing the

application into iterations.

. Conducted UAT with stakeholders and business users for the validation and

got system approvals by conducting UAT sessions.

. Dexterously led the analysis, design, development, testing and deployment

of Data Warehouse for various analytical reports using SAP Business

Object Universe and Web Intelligence tools.

. Documented data warehouse architecture, data dictionaries and coding

standards. Performed code reviews.

. Created ETL architecture and lead the development of ETL processes in SAP

Business Object Data Services to load and integrate data from various

sources into the Data Warehouse.

. Wrote XML file parser using C#.NET and LINQ to load employee's Benefits

and Coverage related data received from PBC (Pacific Blue Cross) into the

Data Warehouse.

. Analyzed content as well as quality of SQL Server databases and

recommended data management procedures.

. Lead the redesign, development and deployment of HBT web site using

SharePoint 2010.

. Designed and developed Collaboration sites for Health Authorities and HBT

Board in SharePoint 2010.

. Created and customized Site Layouts, Site Collections, Lists, Document

libraries, Web Parts and Master Pages using SharePoint Designer 2010.

. Used jQuery, JavaScript and CSS to customize Web Parts and Lists.

. Utilized central administration site to manage security groups and user

roles.

. Worked on PowerShell for backup, restore and deployment of SharePoint

sites on production server.

. Configured SharePoint Crawler and setup search scope for HBT and HA

Sites.

. Installed and configured Microsoft SharePoint 2010 on Windows 2008 and

SQL Server 2008.

. Documented Use Cases for custom user security administration features for

newly developed HBT site in SharePoint 2010.

. Setup MS Team Foundation Server 2010 environment for development team,

Source code repository and other SDLC related processes.

. Integrated SharePoint 2010 and SSRS with MS Team Foundation 2010.

. Trained, mentor or coach end users in all functional areas of MS Team

Foundation 2010.

. Responsible for administering various websites using IIS 6 & 7.

. Created ETL job using SSIS packages to load employee's Claim data

provided by the PBC (Pacific Blue Cross) into the EPICOR (HBT's financial

system).

. Developed Benefits ID Portal in ASP.NET, C#.NET, Infragistics and SQL

Server 2005 to replace employee's SIN with custom generated ID's.

. Created SSIS packages and wrote SQL Scripts to parse data feeds provided

in HIPPA (Health Insurance Portability & Accountability Act) and EDI

(Electronic Data Interchange) standards.

. Significantly involved in the deployment of Group Web a client facing web

application for Group+ an IBM iSeries based health insurance system.

. Fixed bugs and customized Group Web based on the business requirements

using ASP.NET, VB.NET, ASP, CSS and JavaScript.

Feb 2008 - March 2009 Contac Services, Vancouver, BC

Intermediate .Net Web Developer

. Played major role in the development of eContac travel literature

ordering system using ASP.NET, C#.NET, AJAX, and SQL Server 2005

. Analyzed and created Ad-Hoc Reports, Summary Reports, Sub Reports, and

Drill-down Reports using SQL Server Reporting Services 2005.

. Designed and developed windows services for uploading data feeds using

C#.net.

. Enhanced and bug fixed existing Warehouse Management System using

ASP.NET.

. Wrote web-services for newly deployed iLink Warehouse Management System

to receive data from existing Order Management System using ASP.NET,

C#.NET, XML, and SQL Server 2005.

May 2006 - Feb 2008 Upside Software Inc., Edmonton, AB

Intermediate .Net Web Application Developer

. Enhanced Upside Contract Management software for release of newer version

using ASP.Net, Ajax, C#.Net and SQL Server 2000.

. Fixed bugs and maintained older versions of Upside Contract Management

software.

. Used MS Team Foundation Server 2005 for source code repository.

. Wrote manual as well as NUNIT automated test cases.

. Gathered and documented business and functional requirements.

. Optimized and created new reports using SQL Server Reporting Services

2000.

May 2005 - May 2006 TSI Auto Solutions Inc., Saint John, NB

Junior .Net Developer

. Wrote FTP and Https web services in .NET 2.0.

. Developed Upload process in ASP.NET and C#.NET which allows auto dealers

to upload their financial statements to the eComposite system.

. Wrote Text to XML file converter application using VB.Net and SQL Server

2000 as a backend database.

. Developed financial reports for auto companies using ASP.Net.

. Provided support for ShopTrack a work schedule application, written in

Visual Basic 6.0 and MS-Access as a backend database.

. Maintained versions of source code in Visual Source Safe.

May 2004 - Aug 2004 IBM Toronto Lab, Toronto, ON

DB2 UDB Testing Tools Developer

. Developed DB2 CLI (Call Level Interface), CLP and JDBC drivers testing

tools in C, C++, C#, and Java.

. Built testing tool to parse and format XML data according to user

specifications.

. Set up and tested regression environment to run regression buckets and

fix bugs.

Sept 2003 - Dec 2003 IBM Toronto Lab, Toronto, ON

Graphical User Interface Tester

. Tested translated DB2 UDB GUI for bugs.

. Wrote automated test cases and performed various QA product testing and

hot-fixes.

. Responsible for administrating and maintaining Lotus Notes databases.

Sept 2002 - April 2003 Relais International, Ottawa, ON

Programmer

. Implemented web applications in J2EE, JSP, Servlet and Java Beans.

. Wrote application in Java to make Web application to work with MS-SQL

Server, Oracle and MS-Access.

. Designed and created robust distributed client server intra/internet web

applications using Jscript, VBScript, and ASP with MS SQL server

database.

Sept 2001 - April 2002 NB Power Generating Station, Point Lepreau, NB

Programmer Analyst

. Developed Client/Server applications in Visual Basic.

. Performed Administrative tasks in MS-SQL Server and set up new IIS Web

Server on Windows NT.

. Analyzed, designed and implemented other in house projects.

. Upgrade, bug fixes, and Troubleshoot day-to-day problems with web

applications.

Jan 2001 - April 2001 UNBSJ, Saint John, NB

Student Help Desk Consultant

. Assisted faculty, staff, and students with the use of computing and audio

visual equipment.

. Operated front counter for the help desk (Answer phones, e-mails and walk

up request).

. Assist in the tracking and recording of inventory (software, manuals, and

printing).

Key Projects

Street Vending Permit Application - City of Edmonton

- Wrote custom control upload controls using Angular JS, Kendo UI upload

process, JQuery, JavaScript, MVC, Entity Framework, LINQ.

Document Upload Process - City of Edmonton

- Wrote document upload process using SharePoint 2010 Client object

model and Server object model.

External facing eShare Knowledge Base Article Site - City of Edmonton

Developed client facing eShare Knowledge Base Article Site which would

allow customers to get help on any business they want to conduct with City

of Edmonton. It was developed using Angular JS, Kendo UI upload process,

JQuery. JavaScript, MVC, Entity Framework, LINQ, SharePoint 2010 Client

Object Model.

eShare Knowledge Base Article Site - City of Edmonton

Developed Knowledge Base Article Site for internal staff using SharePoint

2010.

Data Warehouse - Healthcare Benefit Trust

- Lead the design and development of HBT Data Warehouse which helped users

to generate various analytical reports for employees on Long Term

Disability (LTD). ETL process was created in SAP Business Object Data

Services and SQL Server 2008 was used as a backend database. SAP Business

Object Universe and Web Intelligence tools were used to generate reports.

Web Site - Healthcare Benefit Trust

- Lead the development of HBT new website from scratch. I played leading

role in analysis, design, development and deployment of new site. It was

developed in SharePoint 2010, jQuery and SQL Server 2008.

Benefits ID Portal - Healthcare Benefit Trust

- Developed portal for Health Authorities (HA) to replace SIN of employees

working for both HA and HBT with custom created IDs. Technologies used in

the development of this site were ASP.NET 2.0, Infragistics, Ajax, and SQL

Server 2005.

eContac Site - Contac Services

- Contributed in the development of an online travel literature ordering

system. This site allows travel agencies to order brochures and promotional

items. Site was developed in ASP.NET 2.0, C#.NET and SQL Server 2005.

Automated Data Feed Process - TSI Auto Solutions Inc.

- Wrote automated web and win services which extract data from various

external sources via FTP and HTTPS and upload to the system.

Text to XML Converter - TSI Auto Solutions Inc.

- Developed Text to Xml converter which helps to convert financial

statement in text format to XML format and then upload to the system.

System was implemented using Vb.Net, ASP.Net, SQL Server 2005 and Excel.

Relais Access System - Relais International

- Responsible for developing and upgrading a web based Relais Access

application. System was implemented using

J2EE, JSP, Servlets, Java Beans, EJB, and JDBC for database connectivity,

Oracle 8i, MS-SQL Server 2000, MS- Access for Windows and Linux platforms.

The web servers used were Tomcat, Apache, and MS-IIS.

Helpdesk Request System - NB Power Generating Station

- Designed and developed a request system that keeps track of all the

requests made by NB Power employees. System

developed using ASP for front end interface, with MS-Access and MS-SQL

Server backend databases.

Educational Qualifications

Sept 2007 - Jan 2008 Certified as MCPD

- Designing and developing web-based application using MS

.NET Framework (Exam 70 - 547)

- .Net Framework 2.0 - Application Development Foundation

(Exam 70 - 536)

Jan 2006 - Feb 2006 Certified as DBA Associate

- Introduction to SQL (1Z0 - 007)

Sept 1999 - May 2005 Bachelor of Computer Science - UNB, Fredericton, NB

- Graduated with major in Software Systems and six co-op

work terms of relevant work

experience in the IT industry.

Aug 1998 - Jan 1999 Diploma in Oracle - Orasoft, Karachi, Pakistan

- Administration Track which include Database

Administration, Backup & Recovery, Tuning,

PL/SQL, SQL*PLUS.

References

References are available upon request.



Contact this candidate