Sql Server .Net
Resume:
Fahad Javed
Home Phone : 587-***-****
Calgary, AB. T3A5B9
Email : **********@*******.***
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