Project Data

SUMMARY

Accomplished Programmer Analyst / Database specialist / Business Analyst/

Enlightened Leader

SKILLS

SSRS SSIS

SVN Team Foundation Server

Microsoft SQL Server Oracle

C# ASP .NET

ETL Data integration

SDLC Agile Methodologies

JQuery Git

Mongo DB MySQL

PROFESSIONAL EXPERIENCE

Pairs Golf 02/2014 - 07/2014

Team Lead / Senior Developer

PHP Project

Redesign pairsgolf.com from the scratch to meet the business requirements

and use the proper CSS files.

www.pairsgolf.com

Technologies used: PHP, MYSQL, CSS

Aura Advanced Technologies 09/2013 - 01/2014

Team Lead / Senior Software developer

.NET / SharePoint 2010

Automated Data Upload and Modification

This Project was for an environmental company. The main purpose of this

project was to collect raw data from field. Store it in database and based

of that data generate the reports. So it was broken down in 2 following

phases.

. Automate data upload from field data using C# to extract data from

excel spreadsheets and saving it in MSSQL

. Presentation and modification of data. (SharePoint custom web parts.)

Technologies used: C#, SQL 2012, SharePoint 2010, Team Foundation Server

Project Requirements

User requirements and Project plan was completed for the following

projects.

. CIWIC program for Cardiology Department. This program was a conversion

from Delphi to SharePoint and .Net.

. HR System for one of the environmental companies to build in

SharePoint and .Net.

Technologies used: MS Project

AGAT Laboratories 05/2012 - 09/2013

Team Lead / Senior Developer/ Systems Analyst

.NET Projects

ASP.NET, C# Projects

Hydro Carbon reporting system.

o This project was designed to replace the old MS Access system and

it will also connect to the LIMS database.

o It will collect data from lab instruments for different kind of

gases perform the calculations and present the result in PDF

format that can be either printed or send via email.

o It also have the ability to pull the work orders from main

database so the analysis can be done according to Client's

requirements.

. Mobile app to Scan sample point data.

o This application was designed to replace manual entry of the

location where sample data originally collected. It will scan the

bar code that will help correctly identify the sample location

point.

. Automated data upload interface.

This project was written to collect data directly from the lab

machines.

o Approximately 80 machines will analyse different samples and

generate the text files. In the past users were manually entering

the data and there were lot of issues with the data accuracy by

doing this project 'human factor' was eliminated and data was 100%

correct that increase reliability.

. Re-coding of Laboratory information management system.

o This was involved in re-writing of existing LIMS system from power

builder to C# 3.5 .

. Quoting module.

o Before this module all the Quotes that were sent to Clients were

made by entering the data manually in excel spread sheets. By

completion of this project all the data was imported from LIMS

database.

Technologies used: C#, Oracle 9 /11 G, ASP.Net, Team Foundation Server,

Scrum Methodology

SharePoint Projects .

. Scheduler

o Ability to schedule appointments to collect samples from sample

points using C# and ASP.NET with SharePoint.

. Weboasis

o This project was done for oil lab. The purpose of this project was

to collect data from lab machines, run the calculations and then

present it in a different way and generate statistics using C# and

ASP.NET along with SharePoint.

. Data Migration

o Extract invoicing information out of Microsoft exchange and saving

the invoices into Oracle DB. As MS Exchange 2003 has a limitation

of 500 folders and 20GB of mailbox size and we were getting very

close to it .

Technologies used: C#, SQL 2008, SharePoint, ASP.NET

C# and Excel Project

. The purpose of this project was to take excel spreadsheet that has 15

departments combined together and using C# to create 15 different tabs

in excel to separate all the departments individually. Before this

project it was done manually and took 1.5 weeks, after the completion

of this project it took only 3 minutes .

Data modeling(Oracle 11G)

This project had following 2 phases..

. To get rid of all the redundancy of data and improve the performance

as the program is running. It was achieved by removing 68 million

records which were redundant in table, it will save 10GB on disk space

and increase program performance from 15 to 40%

. Re-modeling the whole database.

SSIS and SSRS

. Created SSIS package for "spendmap" and "weboasis" so the data can be

used to generate reports using SSRS.

. Created SSRS reports using Oracle backend to meet the business needs.

Technologies used: C#, SQL 2008, Oracle 9 /11 G, SharePoint, MS Access.

ETL Project

. Data migration from MS Access database to Oracle 11G .

Technologies used: SQLLoader, MS Access, Oracle 11G.

Unity Builders Group 01/2007 - 05/2012

Programmer Analyst

Web sites ASP.NET, C#, JQuery

Developed and maintained the following websites.

. http://www,unitybuilders.com

. http://www.unityinvestments.com

. http://www.todayshomes.ca/

. http://www.greenborohomes.ca/

. http://www.greenborohomes.com/

Technologies used: C#, SQL 2005, HTML, JQuery, JavaScript. IIS, SVN

ASP.NET, C# Projects

Web Portal

. Built a reports portal using ASP.NET, C#, Crystal Reports XIR2, Web

Services, AJAX, and T-SQL

. Ran against load balanced replications of the production database,

reducing the load on the production databases.

. The report permissions were based on Active Directory users and

groups.

. Report parameters page was dynamically generated to prompt for various

parameter types based on the report's requirements (e.g., calendar

dropdowns for dates, cascading dropdowns, etc.).

. Greatly simplified the creation and maintenance of new and existing

reports.

. Consolidated four different reporting systems into a single,

consistent, and user friendly reporting system.

. Performance of reports was dramatically improved.

Technologies used: C#, Crystal Reports, SQL 2005, AJAX, Jquery, SVN

Home Gallery

. Developed an application for Windows Mobile 2003 that used a hand held

bar code scanner running the Windows Mobile 2003 platform. The

project entailed scanning the client's selections of various options

for their new home, such as carpet, appliances, paint, etc. The

program sent the selected products to a server, and interfaced with a

sales program.

. Developed and implemented invoicing system. This system helped create

invoices for RED DOT (A sub company of UBG) to create, print and email

invoices to the company. Also it was capable of generating different

reports using Crystal Reports.

Technologies used: C#, Crystal Reports, SQL 2005

Intranet

Created internal intranet that provided the following

. Booking for vacation/Sick days

. Document management system.

. Wikipedia

. UBG website stats.

. Process for software called Newstar.

Technologies used: C#, Crystal Reports, SQL 2005, Jquery

SQL Reporting Services (SSRS) and SQL Integration Services(SSIS)

. Converted 108 reports from Crystal Reports to SQL Server Reporting

Services.

. Imported 832 tables from Progress database into SQL so the most

recent reports can be generated.

Technologies used: SQL 2008 R2

Inlets (Subdivision of Calgary Academy) 02/2003 -

12/2006

Senior Web/Application Developer

ASP.NET, C# Project

IPP (An Individualized Program Plan) Project

. Lead developer on a two person team which designed, developed and

implemented a new Client / Server .NET version of IPP. Project saw

performance increases of three hundred percent over the previous

version.

. Designed and developed all necessary supporting database structure for

the Proliferate application and related websites.

. Data Pool for common data has the ability to share common goals

between the teachers. Also have the capability to measure qualitative

data into quantitative data using simple assignments.

. Based on above mentioned data it can generate progress report that can

be shared with the parent and management.

. This project also has following components.

o a summary of student strengths and needs

o annual individualized outcomes (goals)

o specific individualized outcomes (objectives)

o recommended services for the student

o special materials or equipment

o transition planning

o roles and responsibilities assigned to specific individuals

. At the end of year it will generate reports that will send to

CBE(Calgary Board of Education)

. Developed a web based "web site creation tool" which allows users the

ability to:

o created new web pages, update content on existing web pages

o upload images and files to be used on the website

o created a whole new site.

. Programmed for Internet Explorer 5.0, 5.5 and Firefox.

. Tools and technologies used: C#, JavaScript, ASP.Net, HTML, XML,

Microsoft SQL Server, SQL Stored Procedures, SQL Table Design &

Maintenance, T-SQL, IIS, Visual Studio and Dreamweaver.

PHP Project

. Developed a PHP/Flash project that lets users enter comments after

watching video. Users can add, edit, and delete their comments.

DTS Project

. Imported data from a Visual FoxPro 6.0 database to Microsoft SQL

Server database to update student information on a quarterly basis.

Calgary Board of Education used a program called Travlec to collect

student information.

SSRS

. Used SQL reporting for all the reporting needs in the .NET project.

It included approximately 30 reports ranging from detailed to summary

reports. Mainly used stored procedures in the creation of the report.

Java Project

Student Record System

Centralized System to keep all the student related data.

. Used Unified Modeling Language (UML) for specifying, visualizing,

constructing, and documenting this project.

. Performed implementation, maintenance and administration of the school

of management database Used Microsoft SQL Server 7.0

. Accomplished maintenance and optimization of performance for software

managing the student information system.

. Provided technical support to the employees.

. Prepared, executed and supervised the data import and export routines.

. Designed, developed and implemented the teacher's portal which was

used to create, assign and mark student tasks. It was also used as a

means of communication and collaboration between teachers, students

and parents.

. Solved technical and design issues that arose during the development.

o Upgraded the solution to the new product releases and add new

functionalities (e.g. an on-line

o assignment and grading tool for the teachers).

. Created User Guides and other system documentations.

. Developed and implemented the web parts which provided the main

functionalities of the solution including assigning tasks to students,

grading student assignments and enrolling teachers in professional

development courses.

. Implemented an information system for managing various aspects of

registration, course delivery, meetings between professors and

students, and student records.

. Used JUnit for unit testing.

Technologies used: Java Servlets, IIS, Tomcat

Quest Computers 04/1998 -

06/2001

Programmer

N.P Spinning Mills 04/1995 - 07/1997

Systems Analyst

Capital Spinning Mills 01/1995 - 04/1995

Programmer

Aroma Travel 01/1994 - 12/1994

Programmer

EDUCATION

. Masters in Computer Science. Karachi Pakistan

. Object Oriented Software Technology (I Year) Linux, Java, C++, Visual

Basic, XML, C#, .Net, Jscript, VBScript, Object Oriented Analysis and

Design, HTML, Visual Basic, PL/SQL, MSSQL2000, ASP, JSP, Oracle 8

from University Of Calgary Canada

. Implementing & Maintaining Microsoft SQL Server 2008 Analysis . Course

#6234

. Diploma, Computer Science, Petroman Computer Institute Karachi

Pakistan .

. Diploma in Oracle, Oratech, USA, Karachi, Pakistan Computer Institute

. Maintaining a Microsoft SQL Server 2005 Database. Course #2780.

Contact this candidate