Engineer Sql Server
Resume:
Muhammad Ahsan
House No. ***-C Satellite town,
Bahawalpur Pakistan.
Ph: +92-321-*******
Email: *********@*****.***
OBJECTIVE:
I want a place where I can apply my experience and skills i.e. (system
analysis, Database designing, Application Designing/development and
software quality assurance) with maximum motivation and hard work to
increase the achievement rate of that organization.
SUMMARY:
Approximately 8 years plus experience of extensive involvement in the
area of information technology,
System analysis to application development, maintenance and
troubleshooting of various businesses oriented systems. I have in
depth knowledge of
. .Net Technologies as major software development tools for
Desktop Applications and Web Application
. Core strengths include ASP.NET, Web Services, Windows Services,
Complex Work Flow Applications, WCF, WPF (basic), MTS, VB.NET,
C#.NET, Managed C++, MY SQL 5.0, and Crystal Reports Component
Based Programming.
. Oracle 10g, SQL Server 2005/2008,Ms Access as database Tools
. Strong concepts of structured & object oriented programming
. UML methodologies for Object Oriented Analysis & Design.
. Highly confident, motivated, and competent individual with
excellent analytical skills.
. Strong background in application programming as well as in web
development
. Strong concepts in RDBMS, Object Oriented Analysis, Design and
Development.
. Ability to quickly master new software development tools and
apply its full range of capabilities.
. Open to training in new areas with full enthusiasm.
. Ability to Work in a complex, deadline-oriented environment
EXPERIENCE:
Zarai Taraqiati bank limited (Formally known Agriculture Development
Bank of Pakistan)
Designation: Assistant vice president- Software Engineer (Full time
Employee).
Duration: 12-Aug-2006 to Date.
Responsibilities: Independent Analysis, Software Architecture and
Design, Implementation and Unit testing
. Analyzing user requirements for new and existing software
systems.
. Creation of System Requirement Specification (SRS) & Functional
specification (FS) for the software systems to be developed.
. Creating logical and physical database, Writing the Standards
database level stored procedures, functions, Packages, Views,
Triggers and Database constraints.
. Designing Front end interface for Web and Desktop based
application.
. Mapping Front-end Entity classes to Backend Database tables.
Component based programming using 2 Tier 3 tier and N Tier
Architecture.
. Unit testing of each Frond-end procedures and back-end
Procedures to match the expected outputs.
. Following the Coding/Architectural standards
. Deployment of Applications
. Maintenance of the application incorporates the new Business
requirement in the software
. GAP analysis for new requirements
. Coordinating with Quality Assurance Team to incorporate their
suggestion in Developed applications
Company Description: http://www.ztbl.com.pk/
Zarai Taraqaiti Bank Limited (ZTBL) erstwhile Agricultural Development
Bank of Pakistan (ADBP) is the premier financial institution geared
towards the development of agriculture sector through provision of
financial services and technical know how. The restructuring of
former ADBP (Agricultural Development Bank of Pakistan) is being
carried out with the aim to uplift the agriculture and rural sector by
raising farm productivity, streamlining the institutional credit and
increasing income generating capacity of the farming community.
XAVOR Corporation. (Microsoft Managed Business Partner /Gold partner,
Google Managed Partner)
Designation: Software Engineer.
Duration: 25-jul-2005 to 27-july-2006.
Responsibilities: Analysis, Design, Implementation and Testing
. Creating reusable component and libraries for software
. Creation of System Requirement Specification (SRS) & Functional
specification (FS) for the software systems to be developed.
. Creating logical and physical database, Writing the Standards
database level stored procedures, functions, Packages, Views,
Triggers and Database constraints.
. Designing Front end interface for Web and Desktop based
application.
. Mapping Front-end Entity classes to Backend Database tables.
Component based programming using 2 Tier 3 tier and N Tier
Architecture.
. Unit testing of each Frond-end procedures and back-end
Procedures to match the expected outputs.
. Deployment of Applications
. Maintenance of the application incorporates the new Business
requirement in the software.
. Deployment of software as per defined procedure by Broadcom.
Company Description: http://www.xavor.com/
XAVOR is a Lahore, Pakistan-based Management & Technology Consulting
firm with clients and offices in both Pakistan and United States. They
use a proprietary workshop-driven consultative approach to help their
clients with
Techno Beavers Limited. (Company Deals in Business Intelligence
related Software services and Accountancy)
Designation: Software Developer (Microsoft.Net).
Duration: 20-sept-2004 to 10-June-2005
Responsibilities: Design, Implementation and Testing
. Creating logical and physical database, Writing the Standards
database level stored procedures, functions, Packages, Views,
Triggers and Database constraints.
. Designing Front end interface for Web and Desktop based
application.
. Mapping Front-end Entity classes to Backend Database tables.
Component based programming using 2 Tier 3 tier and N Tier
Architecture.
. Unit testing of each Frond-end procedures and back-end
Procedures to match the expected outputs.
. Deployment of Applications
. Maintenance of the application incorporates the new Business
requirement in the software
Data Matrix (Pvt) Limited. (Firm has been closed)
Designation: Junior Software Developer.
Duration: 1st-Mar-2004 to 7-Sept-2004
Responsibilities: Implementation and Unit Testing
. I have converted legacy system of HR and Payroll of WWF Company
to .NET technology.
. My responsibilities were creating physical database, writing the
Standards database level stored procedures, functions, Packages,
Views, Triggers and Database constraints.
. Designing Front end interface for Web and Desktop based
application.
. Programming application code
. Unit testing and Deployment.
EDUCATION:
M.Sc Computer Science (Specialization in .Net technologies): (2001-
2003) CGPA (3.26/4.00)
University of the Punjab, Lahore.
A public sector Government University recognized by HEC (Higher
Education Commission of Pakistan
B.Sc (Bachelors of Science): (2001) (572/800):
Islamia University Bahawalpur (A public Sector Government
University)
Math A, Math B, Physics.
F.Sc (Pre Engineering) (1998):
Board of Intermediate & Secondary Education Bahawalpur
Metric (Science Group) (1995) (607/850)
Board of Intermediate & Secondary Education Bahawalpur
CERTIFICATIONS
MCP (70-316) Developing Windows Application
Using C#
MCP (70-315) Developing Web Application Using
C#
MCTS (70-529) Developing Distributed Application
Using VB.NET/C#
TECHNICAL SKILS
Languages: C#.Net, VB.Net,ADO.Net, Managed C++, COM, COM+, UML,
Transact SQL, Pl/SQL,XML,XSLT, XAML
Development VS.Net 2003/2005/2008/2010, Seagate Crystal Reports,
Tools: MS.SQL reporting service, Microsoft Visual Source safe
,MS Access Forms
Web ASP.Net 1.1,2.0,3.0, IIS (6.0/7.0), AJAX, Asp.Net Web
Technologies: parts, Web Services 1.0/2.0, Remoting,WCF/WPF, Silver
light 3.0/4.0
Scripting: J Query,HTML, DHTML, Java Scripting, XML Http, XAML
Data Bases: SQL Server (2000/2005/2008), Oracle 10g, MS Access, My
SQL 5.0
Case Tools: MS Visio (UML), Rational Rose, Rational XDE, ER Studio,
Enterprise Architect
Operating Windows 98/XP/2000, DOS
Systems:
PROJECTS:
Internal Audit Management System
Client: In House (Agriculture Development Bank of Pakistan).
Tools: C#, Oracle 10g, MS Excel, Crystal Reports, MS Reporting
Service, MS Application Blocks
Duration: 6 months
Team Size: 2
Role: Analyst Programmer
Responsibilities: Analysis, Design, Implementation, Unit testing.
Description:
Internal Audit Management System (IAMS) provides the entire
feature set to handle audit related activities. It can be called as
ERP of Audit. Used by ZTBL Internal Audit Division at head office as
well as field offices. This system is also used by audit users for
better recording of audit observations and their compliance from Audi
tee to track records.
Field Audit Department (FAD) of Audit Division currently performs
audit tasks at branches. Their task starts with identification of
need of audit to be performed at any branch. For this purpose audit
plan is drafted by audit zone and for finalization sent to FAD. This
audit plan contains all information regarding engaging of auditors,
number of loan cases to be audited per day, total number of days to
perform this audit etc. Internal auditors are geographically posted
at Audit Zones and reporting to their SVP/In-charge of Audit Zone
concerned. However Chief of Audit Division has been authorized by the
Audit Committee to assign them to the internal audit engagement
flexibly depending upon the requirement. Auditors perform different
daily tasks on branches regarding audit of loan cases and find
observations. These observations are given to branch manager for
rectification and then sent to zonal chief in case of any observation
remain unresolved after 3 days. At the end, audit report is to be
generated that will be sent to higher authorities as MIS report.
Compliance arrangement and issuing of Draft Statements of Allegation
(DSAs) are solely on the basis of this prepared audit report.
Corporate Audit Department (CAD) is responsible to conduct the annual
management audit of head office departments, audit zones and HO units
in the field in light of applicable rules, regulations, policies and
procedures with a view to assess that all the functionaries are
performing their duties efficiently, judiciously and periodical
verification of dead stock articles and depreciation charge thereon.
Management audit of the departments is planned keeping in view the
priorities posing financial, operation, technological and regulatory
risks to the ZTBL.
Laboratory Information Management System
Client: Islamabad Labs.
Tools: C#, MS SQL server 2008 MS Excel, Crystal Reports, MS Reporting
Service, MS Application Blocks
Duration: 3 months
Team Size: 1
Role: Analyst Programmer / Software Architect
Responsibilities: Analysis, Architect and Design, Implementation, Unit
testing.
Description:
Laboratory Information Systems are part of an integrated informatics
solution. The LIS is used in inpatient and outpatient settings and in
many cases is designed to support both. It is a
complete management system that handles all business functions
from patient
Management, results generating, to physician decision making.
Following are the main heads Hematology Immunology Pathology
Bacteriology Chemistry Endocrinology Serology Virology
Features includes
. Dynamic Menus and UI generation base on Roles and Rights of
User stored in backend.
. Tests/Profile Management
. Test Parameterization engine rules and reference Ranges
Management based on Textbox (values) selection Box i.e. (+ive,-
ive) or text box and selection box to enter both cut off and
Textbox value i.e. Hepatitis C,B
Make sure the accuracy
. Panel's management
. Employees management through Finger print and Web Cam
Integration
. Patient management through Finger print and Web Cam Integration
for Registration
. Order Processing and cash management
. Phlebotomy and Accession through Barcodes
. Result Entry
. Verification using Maker and Author to verify finally before
submission.
. Configurable Workflow through UI.
. Statistical Reporting and Barcodes
. Alerts
. Integration with Inventory Management for Kits using in Tests.
. Reports Include (Daily cash summary, Panel Billing report,
Patient Billing report, Expense, Income, Inventory Items, sales
and Purchase, Due Balances and Many other.
Security Document Management System
Client: In House (Agriculture Development Bank of Pakistan).
Tools: C#, Oracle 10g, MS Excel, Crystal Reports
Duration: 6 months
Team Size: 2
Role: Developer
Responsibilities: Analysis, Design, Implementation, Unit testing.
Description:
Security Documents are most important part of Loan Case
Documents and plays important role in protecting Banks interest a
document repository and management system coupled with robust Meta data
to describe the key contents of documents. It facilitates branches in
managing electronic copies of Security Documents and In-kind Delivery
Proofs of various types of Loan Cases It comprises of all those
processes, which includes storing and processing of scanned images of
Security Documents, digital copy of photographs of borrower etc related
to a sanctioned loan case.
Key features of SDMS shall be,
. Repository management to digitize both sensitive documents and
pictures of In-Kind delivery of agriculture products
. Store Key contents of Security document
. Facility of connecting/integration with Web/Digital Camera and
scanner with SDMS software
. Security Documents Check list
. Authorized access to manage and store Information and documents
. Provide facility of generating parameterized reports.
Key features of SDMS shall be,
. Data backup and restoration
. Consolidation of data at Head Office
. Complete audit trail of each activity
Internal Credit Risk Management System (for Existing Loan cases)
Client: In House (Agriculture Development Bank of Pakistan).
Tools: C#, ASP.Net 2.0, Oracle 10g, MS Excel, Crystal Reports
Duration: 6 months
Team Size: 2
Role: Developer
Responsibilities: Analysis, Design, Implementation, Unit testing.
Description:
Obligor Risk Rating (ORR) is a tool, which provides a uniform
framework and common language for assessing and monitoring of credit
risk. It allows ZTBL management to evaluate and track risks related to
credit portfolio. As a general practice risk rating operates
simultaneously with credit approval process. The risk rating should be
recorded in appropriate place in Credit Information Report (CIR).
The ORR model has 9 rating grades ranging from ORR-1 to ORR-9 for non-
defaulted borrowers and 3 rating grades ranging from ORR-10 to ORR-12 for
defaulted borrowers. The model is based on 10 factors where each factor
has its own weight. These factors are divided into 4 categories where each
category is assigned different weight. It is to mention that Same ORR
model is applicable for both existing and new borrower
these factors of ORR are as follows
Net Income, Age, Experience, Soil Type, Land Ownership, Repayment
Behavior, Market Reputation, eCIB Report, Product Default History,
Market Availability.
Identity Management System & CIR
Client: In House (Agriculture Development Bank of Pakistan).
Tools: ASP.Net 2.0 (C#), Oracle 10g, Web Parts, MS Excel
Duration: 2 months
Team Size: 2
Role: Developer
Responsibilities: Analysis, Design, Implementation, Unit testing.
Description:
IDMS is developed for verification of CNIC's through NADRA
(using VeriSys of NADRA) is a workflow application. It covers
verification of old CNIC available in COBOL system as well new data.
Historical data from FOCS (COBOL) (non verified customers in old
system) was loaded into IDMS and then sent to NADRA in form of batches
for verification. Applicant's credentials will then be verified either
by IT-OPs or concerned Zones/Departments.
Features
IDMS is primarily responsible for customers/applicants basic
credentials verification/maintenance using NADRA. IDMS initially will
provide the following major functionality/interfaces:
. New Customer/Applicant entry for verification
. Interface to Import Batch Data from FOCS into IDMS
. Interface to define Batches and Export batches for NADRA
Verification
. Interface to import NADRA generated file into IDMS
. Functionality to define Master Data for CIR definition
. Functionality to enter CIR at Zones/Branches
. Functionality to export completed CIR to FOCS for further
processing
. Statistical Screen Queries
. Parameterized Searches
. Reports
. Two level verification make and Verify at one each level.
. Authentication and Authorization Head Office /Zone /Branch
level so that each user can access his own Head Office /Zone
/ Branch information only and can make and Authorize his own
information.
Data from DMS will be transferred to IDMS during EOD processes and
after verification status will be pushed back to DMS. A file interface
will be provided to update data in FOCS
Data Transfer Service
Client: ZTBL (IT-Operation Dept).
Tools: C#.Net (Customized FTP Client), ASP.NET 2.0, Oracle 10g,
Crystal Report, Web Service 2.0
Duration: 1 month
Team Size: 1
Role: Developer
Responsibilities: Analysis, Design, Implementation, Unit testing.
Description:
Data Transfer Service is currently using to upload and Download
Files to/from Server to/form to Branches of the bank. It is
easily accessible from the internet using Http protocol. It has
build on SOA Model. This application has three major parts
1) DTS Administration
2) DTS Server End
3) DTS Client End
Features:
Resume able Uploading and downloading.
Based on Service Oriented Architecture to communicate to the
Application Server & DB server.
User Authentication and Authorization using Soap Headers in
ASP.NET C# Web services.
Multithreaded Application
File Uploading/Downloading Status Completed, Incomplete, In
Queue
Broken Link Management
Auto Dial to Internet
Fast Communication using TCP/IP Protocol
Audit Trail & different kind of reports regarding Upload and
download
Web interface to Administration End to download the file
uploaded from Client.
Trust Accounts & Detail of Investment Management System
Client: ZTBL (Accounts Dept).
Tools: ASP.Net (2.0), Oracle 10g, Crystal Report, MS Excel
Duration: 1 month
Team Size: 1
Role: Developer
Responsibilities: Analysis, Design, Implementation, Unit testing.
Description:
The purpose of Trust Accounts and Detail of Investment is to
invest amount in a business in order to earn profit. For this purpose,
a fixed amount is deducted from the salary of each employee every
month against a fund/scheme (Trust Account). When a handsome amount is
collected in the fund/scheme, profit rates are collected from
different business organizations/banks. The amount is then invested in
the business organization/bank offering the best profit rate.
The employees of ZTBL are given benefit against the profit earned from
the business and the actual amount is invested in the business again
and this process cycle continues.
Different kind of Salary generation & CPF/GPF module reports is
designed by me for Accounts Dept.
Appraisal Management System
Client: ZTBL (HR Dept).
Tools: ASP.Net (2.0), Oracle 10g, Crystal Report, MS Excel
Duration: 1 month
Team Size: 1
Role: Developer
Responsibilities: Analysis, Design, Implementation, Unit testing..
Description:
This system captures the employee's yearly
Appraisal/Performance information which will be tightly
integrated with HR system. It provides the efficient reporting
system like different statistical reports of employees and their
performance related report yearly basis. Currently all
information would be managed at head office as per user
requirement but this system will be accessed as an Extranet in
future to wash out all the manual process.
Online Vendor Short Listing System
Client: ZTBL (IT-User Support Dept).
Tools: ASP.Net (2.0), MS Access/My SQL, Crystal Report,
Duration: 5 days
Team Size: 1
Role: Developer
Responsibilities: Analysis, Design, Implementation, Unit testing.
Description:
ZTBL Information Systems Division has introduced an online
IT vendor Prequalification form. The information submitted online
substantially reduces the time it takes to process the
prequalification applications. System is capable to calculate the
points obtained by each vendor to qualify.
Data Ingression and Management System
Client: In House (Agriculture Development Bank of Pakistan).
Tools: C#.Net, Oracle 10i
Duration: 5 months
Team Size: 1
Role: Senior Developer
Responsibilities: Analysis, Design, Implementation, Unit testing.
Model of this application which will be deployed in all zones of ADBP.
Description:
DIMS application is the core banking application for Credit accounting
and management information system. It is also capable of generating
comprehensive and meaningful reports this application has three main
processes.
-CIR (Credit Investigation Report)
-DACT (Daily Activity)
-Vouchers (Transaction form)
1. Assembly Process Change Notification for CISCO (2.0) (XAVOR Corp)
Client: Broadcom Corp/Cisco.
Tools: ASP.Net, SQL Server 2000, MS Excel
Duration: 5 months
Team Size: 3
Role: Developer / Engineer
Responsibilities: Worked on the Business logic layer and data access
layer of this application .And also Participated on designing Data Model,stored procedure and Views of application.
Description:
. It is an enhancement to current system for processing APCN for
Cisco
. Additional capability in the system to manage Cisco's PCN
functionality.
. Traceability of information related to Customers put on Hard Holds
. Provide more effective and efficient workflow.
. Three actors are mainly involved in this process, namely
- BU QA Engineer
- Sales Representative
- Packaging Engineer
. BU QA Engineer's are entry driver for Cisco Process
. Final outcome of the process is Cisco Letter and the Horizon Report
2. Supplier Portal Framework & Supplier Quality Monitoring System (Xavor
Corp)
Client: Broadcom Corp.
Tools: ASP.Net, SQL Server 2000, SQL Server Reporting services, Web
Farm environment
Duration: 5 months
Team Size: 4
Role: Developer / Engineer
Responsibilities: Worked on the Business logic layer and data access
layer of this application .And also Participated on designing Data
Model,stored procedure and Views of application.
Description:
Bro application consist of two parts Portal Framework and SQMS. Portal
is the interface of all application of broadcom and SQMS is the
application which actually solves the business problem.
Broadcom wanted to provide the supplier with an extranet website where
they can directly post the required data and provide some additional
metadata information which will help to categorize and sort the
information and facilitate in searching the information.
The SQMS module is the part of the overall QADC.NET application suite
with an interface for both the suppliers and the internal QA and other
Broadcom engineering teams. This is the first application in the QADC
suite, which is being exposed externally to the Suppliers and relies
heavily on their input to the system.
Co sox Complaint System (Holds Microsoft ISV)(Techno Beavers Ltd)
Tools: (C#, ASP.NET, SQL Server)
Duration: 5 months
Team Size: 3
Role: Developer / Engineer
Responsibilities:
Worked on the Business logic layer and data access layer of this
application .And also Participated on designing Data Model, stored
procedure and Views of application.
A system specifically designed to meet Sarbanes Oxley Act and Basel II
operational risk management requirements. A COSOCK is based on COSO
internal controls framework and allows an organization to document,
track and manage financial and operational risks relating to all key
processes.
It is an intranet application that monitors the organization progress
and flaws by implementing Oxley Sabine Law of business; it is an
Intelligent and highly secures system. It provides very attractive and
easy environment to operate
3. TBL Accounts Automation System (Techno Beavers Ltd)
Client: Techno Beavers (Pvt) Ltd
Tools: ASP.Net, SQL Server 2000,
Duration: 4 months
Team Size: 5
Role:
Developer / Engineer
Responsibilities:
Designed GUI, Worked on the Business logic layer and data access
layer of this application. And also wrote stored procedure for this
application.
Description:
A secure and intelligent system that automates the process of job
handling, the system is divided 4 well-defined phases and each phase
is integrated to other to accomplish the job. It includes scanning,
managing, printing and execution. Responsibilities of each staff
member is well defined and monitored, it is capable of tracking daily
work progress report, it keeps the teams and managers aware about jobs
progress via an alert system, at the end of every job completion /
failure the correspondents are informed about the status, it generates
variety of reports.
4. Time Tracker Application (Techno Beavers limited)
Client: Hardy & Co (U.K)
Tools: ASP.Net, SQL Server 2000, Ms Access 2000
Duration: 4 months
Team Size: 2
Role:
Developer / Engineer
Responsibilities:
Designed GUI, Validation and Coding of different Forms. Used
three tier architecture to develop the application using C#. Net.
Stored procedures were used in SQL Server to handle different business
rules.
The basic purpose of the System is to keep track of the time spent by
staff in providing accounting and related services to clients and
generating monthly invoices for these clients. It is also capable of
generating management reports. The System implements a role-based
security system with well-identified rights and privileges. The System
is primarily divided into three sections i.e. Owner Section, Admin
Section and User Section.
The features used in this application of AS.NET are
Forms Authentication
Users Controls
Globalization
Resource files
Payroll Management System (Data Matrix (pvt) Ltd)
Client: WWF (Lahore)
Tools: VB.Net, SQL Server 2000, Seagate Crystal Report 8.5 (Desktop
Application)
Team Size: 5
Role: Junior Developer / Engineer
Responsibilities:
I wrote the code to convert this application from VB 6.0 to
.NET. Manage changes in the application in stored procedures triggers
and views Seagate crystal reports were used for reporting.
Bidirectional Dictionary
English to Urdu and Urdu to English Bi directional Dictionary
(Desktop Application using C#. Net & SQL server)
Tools: C#.Net, SQL Server 2000 (Desktop Application)
Team Size: two
1) This product is developed as Bi-Directional dictionary in which
search can be made in both direction from English to Urdu and as well as
from Urdu to English. This can also search synonyms and part of speech of
each word. This dictionary work as plug-Inn in Microsoft Word. And this
product is in the form of component that can be used by other
developer who wants to use in his product.
2) Another component of this application take input an Urdu word and
Romanize it in to its equivalent English form.
INTERESTS
Application Development & Database Management using SQL
Server & Oracle
Object Oriented Analysis & Design
Study and Implementation of Advanced Object Oriented Programming
REFERENCE
Muhammad Tayyab Ghauri
Digital sys
Washington DC,
USA
Subject: Application for the Post of Consultant / Senior Programmer Analyst
Dear Sir/Madam,
This is to express my interest in the Sr Analyst Programmer/Consultant
position. I believe that my strong technical experience and education
will make me a very competitive candidate for this position. I am
applying to you because I believe u do offer a stimulating environment
where I can make significant contributions, my profile is:
Qualified, experienced and result oriented System software Engineer.
8+ years of expertise in developing software applications, especially,
online business concerning web-applications Desktop Applications
Windows/Web Services and Server Components, Remoting/Web services /
WCF using Microsoft technologies.
Ability to meet the provided deadlines and achieving specified targets
within stipulated time period
Flexible and initiative driven professional with excellent analytical,
problem solving, inter personal, decision making and communication
skills. Provide exceptional contributions to customer service for all
customers
For more detail version of profile, please find enclosed resume.
Concerning the remuneration, I am quiet flexible on terms & willing to
discuss in person. Therefore, I look forward to a formal meeting with
you & it would be my pleasure to attain the same with you at your
convenient time.
Looking forward to a positive response from your end.
Sincerely,
Muhammad Ahsan.
Sr System Developer (IT -SDD).
ZTBL Head Office.
Contact this candidate