PROFILE

• Over 14 years of experience in software design and development
• 8 years of software design and development experience using .NET Technology
• Extensive expertise in developing Client-Server as well as Web based applications
• Expertise in database, web servers and application servers
• Excellent interpersonal and communication skills
• Self motivated and an able team player

TECHNICAL SKILLS

Languages: C#, VB.NET, Visual Basic 6.0, Java, COBOL, C/C++, SAS
Databases: SQL Server 2000/2005, Oracle 9i, MS Access, Dbase III*, FoxPro 2.6
Development Tools: ASP.NET, AJAX, ASP, JavaScript, VBScript, JQuery, HTML/DHTML, XML, Web Services and Visual Interdev Web Servers - MS IIS, DTS, T-SQL, SQL Server Integration Services (SSIS), ETL, LINQ, Entity Framework
Documentation Tools: ER-Win, Visio, Rational Rose, Together Soft, Power Designer
Programming Tech: ADO.NET, COM/DCOM, ActiveX, API
Reporting Tool: SQL Reporting Services (SSRS), Crystal Reports 8/9, Microsoft Access Reporting
Version control: TFS (Team Foundation Server), Visual Source Safe, Clear Case
Operating Systems: Windows NT/2000, Windows XP/9x

PROFESSIONAL EXPERIENCE

C# Systems Analyst / Developer (Consultant)

Project: MIDAS, ABMARS, AMI(Alberta Minerals Information System) 
Environment: C#, VB.NET, ASP.NET, Visual Basic 6.0, AJAX, JavaScript, JQuery, Visual Studio 2005/2010, MS Access 2003, Excel, HTML, IIS, XML, SQL Reporting Services (SSRS), SQL Server Integration Services (SSIS), ETL, SQL Server 2005/2008/2012, IBATIS, LINQ, Entity Framework, Windows XP, TFS(Team Foundation Server), DOE Framework, DOE Common Objects

Working in a large team environment, Alberta Energy Department manages the Minerals, Coal, Sand Oil and Energy resources in Albert-Canada.
My role typically involves doing the following things:

• Analyzing the existing applications written in Power Builder, Visual Basic 6.0 and Ms Access.
• Creating the complete system study document and DFD\'s for future conversion of existing AMBARS and MIDAS applications to .net framework.
• Flowcharting of the existing Procedures for providing an easy fix methodology to other team members.
• Providing full support on MIDAS and ABMARS Assessment/Permit management systems.
• Providing full support for AMI(DOE’s largest system). Day to day tasks include the Integration and unit testing of DI\'s along with the fixing of the DI\'s.
• Adding new features to the AMI system using C#.

Project: Students Biographical and Transcripts Management System 
Environment: VB.NET, ASP.NET, Visual Basic 6.0, AJAX, JavaScript, JQuery, Visual Studio 2005/2010, MS Access 2003, Excel, HTML, IIS, XML, SQL Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server 2005/2008/2012, LINQ, Entity Framework, Windows XP

Working in a large team environment, my role is to fill the gaps and build the Client Server and online web applications that are not available in current system.

• Designed back end using SQL Server 2008/2012.
• Fixed and maintained the existing GHAdmin application that was written in MS Access 2003.
• Implemented N-tire application development architecture for system development
• Designed and developed Student Biographical Management, Mark Book, Teachers Online Attendance, Brevet Fiche, CAS Management, IB University Management, Students Activity Enrollment, Online Students Lunch Menu System and 
  Online Books Sale Systems using VB.net Web Forms, ASP.Net and JavaScript.
• Designed and developed Course manager to handle the student’s course change requests using VB.net Web Forms, ASP.Net and JavaScript.
• Designed and Developed OUAC(Ontario University Application Center) Module to create the OUAC submission files using VB.net Web Forms, ASP.Net and JavaScript.
• Wrote complex SQL Statements, Stored procedures, Data Views and Functions to manipulate data on server side for a better system control and performance. Used extensively T-SQL.
• Used LINQ AND Entity Framework to deal with different kind of data sources.
• Created Data transformation Packages to move data from one database to another database using SSIS(SQL Server Integration Services) and DTS (Data Transformation Services).
• Created reports using SSRS(SQL Reporting services) and Crystal Report.
• Wrote user manuals and trained system users.
• Provided support on all in house existing applications and newly developed applications

Confidential,ON, Canada (August-2006 October-2007)
Computer Programmer/Web Developer (Permanent Full time)

Project: ACOMS (Anatolia Custom Order Management System)
Environment: VB.NET, Visual Basic 6.0, Visual Studio 2005, MS Access 2000, Excel, HTML, SQL Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL, Server 2005/2008 , Microsoft Visio, Windows XP

Business revolves around the Tile Industry. Software automates the manual procedures Like custom order handling, Automatic population of Must Ship/Printed/On Hold Orders on daily basis, Order Entry/Label Printing, Skids management in warehouse, Allocation of skids to different employees, Automatic work status viewing for each arrived trucking company, Employees performance monitoring by means of calculating point for each employee on daily weekly and annually basis, Posting of shipped orders to maintain the system consistency and Invoice tracking management to sole the issues of unpaid invoices. Security supports from module level to form\'s object level, typical formula based report for Custom Order and Aacpac system.

• Designed back ends using Pervasive. SQL 8.0 and SQL Server 2005
• Implemented N-tire application development architecture for system development
• Developed Online Shipment management system for suppliers with secured user logins to create the online shipment notice with Container and items info using VB.net Web Forms.
• Design and Developed Invoice/Transfer checking manager using VB.net Web Forms, ASP.Net and JavaScript..
• Developed UI screens like Custom Order Management, Confirmed Order Info, Latest Order situation, Order’s to ship, Must ship Orders, Reprint orders, prepared by information, Employee’s progress sheet, Login, Module, Security level and set Security using VB.NET Win Forms.
• Created Performa Invoicing System along with auto XML submission to clients SFTP site.
• Used MSFlexGrid along with embedded Picture, Text Box and Combo Box Controls to display data in grid format
• Used Animation Controls to display the processing of data capturing and automatic status updating for each arrived trucking company.
• Wrote complex SQL Statements, Stored procedures, Data Views and Functions to manipulate data on server side for a better system control and performance. Used extensively T-SQL
• Created complex reports based on formula field and sub-reports for Custom order and Aacpac system using Crystal report 9.0
• Created Data transformation Packages to move data from one database to another database using SSIS (SQL Server Integration Services)
• Used SSRS(SQL Server Reporting Services) for web reporting purpose.
• Drawn Activity Diagrams using Microsoft Visio.
• Done everything from System setups creation to installation and writing of user manual to user training
• Provided support on all in house existing and newly developed applications

Confidential,Woodbridge, ON (November 2005 to August 2006)
IT Support Specialist / Programmer (Permanent Full time)

Project: KCOMS (Korson Custom Order Management System)

Company deals with furniture import and distribution throughout the North America.
This project resolves the issues like handling customer fabric inquiries/creating and receiving Fabric Pos’/emailing and faxing pos to different fabric suppliers, china stock management including stock POs and inventory management for available stock items. In addition system is fully equipped with security features.

• Designed back ends using SQL Server 2005
• Developed System Generation, Data Generation, General task management, Pattern management, Custom Ordering, PO Receiving Back ordering, Products, Vendors, and Contacts list and Stock status forms usingVB 6.0
• Designed and developed User, Module, Security Level and User rights Allocation forms to implement user logins in the system
• Created Outbound PO files in Microsoft Word (.doc) and Acrobat (.pdf) format to equip the system with Email and Faxing capabilities using VB.NET Win forms and Microsoft Outlook
• Developed Custom DTS (Data Transformation Services) to transfer data from different excel (.xls) sheets to Targeted SQL Server tables by using the Field mapping criteria in VB.net Win form.
• Wrote the required SQL stored procedures, Triggers, Functions and DTS (Data Transformation Services) using SQL Server 2005.
• Created complex business reports having formula fields/parametric fields and sub-reports using Crystal report 9.0.
• Wrote user manuals and provided training to all system users. Provided support on all in house existing applications and newly developed applications

Application Developer (Part time/Contract)

EDI is an IT solution provider. My duties were to remove logical and physical error from current application and to add new features. Designed and developed new inventory windows, developed new reporting forms so that different EDI clients can print reports for all stores of a selected trading partner instead of printing one by one.
Added new features like boxing the items store wise in pairs of six and enhanced the old bar coding to new UPC bar-coding system.

• Fixed and maintained the existing EDI software.
• Maintained existing EDICommerec application written in Visual Basic 6.0
• Designed and developed EDI Loader, XML Builder, PO Exporter, ASCII File reader using C# Win forms.
• Designed and developed FTP Client application to upload and download EDI data files from different ftp sites using C# Win forms.
• Wrote complex queries to fetch data from Access Database.
• Used MSFlexgrid control to group orders for different store.
• Developed Outbound EDI Files using VB Filing.
• Created reports using Crystal report 8.5.
• Wrote user manuals and provided training to all system users. Provided support on all in house existing and newly developed applications.

1.) position: SENIOR PROGRAMMER/SYSTEM ANALYST (BPS-18) / Team Lead 
PROJECT: MIS ( Management Information System)
Environment: C#, ASP.NET, ADO.NET, XML, XSLT, SQL Server 2000, Case, SQL ANSI, TSQL, 
Java, J#, Oracle, ER-Win, Visio, Rational Rose, Crystal Report 8.0

Punjab Irrigation and Drainage Authority is an institution of Government of Pakistan, My role there was to manage a team of 6 programmers and 10 data entry operators. I was actively involved in all phases of SDLC (Software Development Life Cycle) starting from initial study to coding and software implementation.

Software computerized the manual procedures to save time and increase productivity. Software handles all Employees related matters like Employee details, Visit abroad, Disciplinary proceedings, complaint inquiries, service record,, posting /deputation history, Transfer record, Retirements and publication of vacant posts etc. Software is fully equipped with secured user logins.

• Designed and implemented the GUI
• Designed databases using SQL server 2000
• Designed and Developed Chart of Accounts, Organizational Chart, Accounts Association, Voucher book, Accounts Check Digit System to avoid the possible user mistake and all other forms using C# Win Forms.
• Created automatic Vouchers opening, Closing and Canceling Techniques based on different criteria like weekly, monthly and daily using C# Win forms.
• Developed and integrated Departmental Vehicle\'s management module using C# Win Forms.
• Designed and developed Employee\'s Biographical, Employee\'s payroll system using C# Win Forms.
• Designed and Developed Employee Registration, Allowances, Personal Details, Loan handling, Department/Section information, Leave analysis forms using C# Win Forms.
• Developed Employees Salary slips, Disbursement vouchers, Salaries detail analysis, Leave history, Employee\'s monthly, annually, and seasonally salary analysis reports, Loan reports and all other reports usingCrystal Report 8.0.
• Designed and developed complex reports like Chart for Accounts, Organizational Chart, Ledger, Trial Balance, Balance sheets, Income Statement, Cash Flow Statement, Bank reconciliation statement, Transaction edit list , Budget Utilization and many other types of reports using Crystal Report 8.0.
• Wrote Stored Procedures, Triggers and database Functions using SQL Server 2000.
• Managing batch / interactive process flow. created Reporting System, reflecting daily, monthly and yearly progresses for the different goals set on annual basis
• Implemented Security features from object level to menu level
• Drawn Activity Diagrams using Microsoft Visio
• Wrote User/operational manuals and trained all system users
• Provided support on all in house existing applications and newly developed applications

Lahore Software (PVT) Limited – Pakistan. (Jan 1998 to 28 Feb 2001)

1) position: SENIOR PROGRAMMER/SYSTEM ANALYST 
PROJECT: Inventory Control / Purchase Order Systems. 
Environment: Visual Basic 6.0, ActiveX Data object (ADO), ODBC, MS Windows 98, Microsoft Access 97, 
SQL ANSI, Crystal Report Writer 7.0, ER-Win, Visio

Software controls the store Inventory and Purchase ordering. System Performs tasks like automatic raising of PO\'s for all Items having on-hand quantity lower than pre-defined minimum quantity level, Keeps track of most selling items on daily weekly, monthly and annually basis to fulfill the customer demands, automatically suggests approximate Order quantity for every item on the basis of sale history, Categorize Items in different group and sub-groups for easy price/ sale management, enables store owners to update/change Item prices on the basis of selected Group/Sub-group/supplier/Item. System also supports the feature to backup and recover data. Software is fully integrated with POS (Point of Sale) application.
Checksum sophistication is implemented to stop the unauthorized copying of software.
Users perform tasks according to there assigned security levels, security is implemented from Object to menu level. System can produce more than 20 different Inventory/PO reports.

• Used ER-Win and SQL Server 6.5 for database designing
• Used Visual Basic 6.0 for front end designing
• Designed and developed Group/Sub-group/Item Associations, Vendor history, Item history / On-hand Stock management, Most Selling Products and Pricing/Sale Forms
• Used DAO for database connectivity
• Developed PO Ordering, Receiving, Opening/Closing/Canceling and Back Ordering windows
• Created ActiveX Controls for Security Implementation, and developed configuration windows to embed the security control in different in house software using VB 6.0.
• Wrote complex SQL Queries using Joins and sub-queries
• Created all Inventory/ PO reports using Crystal report 2.0
• Developed Software installation Package and user manuals
• Provided Software support and user training

2) position: SENIOR PROGRAMMER/SYSTEM ANALYST 
PROJECT: Point of Sale Application :
(Siddiq Trade Center,Lahore; Shell Pakistan Ltd. Gujranwala)
Environment: Visual Basic 6.0, ActiveX Data object (ADO), ODBC, MS Windows 98, Microsoft Access 97, 
SQL ANSI, Crystal Report Writer 7.0, ER-Win, Visio

Software manages the products sale activities on different POS (point of sales) terminals, Software enables to upload the sold Products data to inventory control system to adjust the on-hand values for sold items, downloading of Product data from inventory to implement the latest price checking, system includes the barcode reading using barcode readers, barcode/label printing for each Inventory Item. System allows user to print the shift/day report at shift/day end.

• Designed and developed UI and all supported forms using Visual Basic 5.0
• Used VB Files to store the individually sold product\'s data on different Point of sales
• Used MsflexGrid controls to display different data views
• Created complex SQL queries like Join and sub-queries to get criteria based data from SQL Server 6.5
• Wrote stored procedures using SQL Servers
• Created reports using crystal report 2.0
• Provided Software support and user training

3.) position: APPLICATION DEVELOPER 
PROJECT: Point of Sale Application: 
(Metro Mart, Lahore; TES Mart, Lahore – Pakistan)
Environment: Visual Basic 6.0, ActiveX Data object (ADO), ODBC, MS Windows 98, Microsoft Access 97, 
SQL ANSI, Crystal Report Writer 7.0, ER-Win, Visio

System Manages the day to day POS(Point of Sale) activities for all in store product. Speeds up the sale procedures by means of bar code reading, prints Sale receipts after sale confirmation,
Automatically upload /download Product data to and from Inventory Control system. Software allows customer representatives to print the shift/daily selling reports on the basis of different POS terminals.
System Allows Barcode label printing for items on the basis of selected Group/Sub Group/supplier/ Individual selected item.

• Designed and developed Sale, Price change, Currency exchange, Sale history windows using VB 6.0
• used MSFlexGrid control to show the multiple sale items under a single sale activities
• Embedded Image control in MSFlexGrid control to Void different Items in a sale activity
• Implemented additional discount features
• Used VB 5.0 Files to store the current sale activity on each POS terminal
• Wrote user manuals and created setup packages
• Provided Software support and user training