Dedicated computer professional over 6 years of extensive experience in IT industry with an excellent skill set as a Business System Analyst/Programmer, in the field of multi-tier client/server computing, Internet/Intranet development, database programming, Administration and design. Well conversant with all phases of software development life cycle from analysis, design and development to installation, maintenance, support and technical documentation.
Excellent communication and interpersonal skills, and proven analytical and problem solving approach.
During different phases of work experience, worked on the following Languages, Platforms, RDBMS, toolsets and Applications, able to select and adopt them appropriately at all stages of system development life cycle.
|
Thomson
Financial, Wall Street NYC. |
March
2000-Present |
|
TOYS
“R” US International, Paramus, NJ |
Dec 98 – March
2000 |
|
American
Standard Inc., Piscataway, NJ |
June 98 – Dec 98 |
|
Digital
Processing Systems Inc., NYC |
Jan 98 – June
98 |
|
National
Bank |
May 96 – Jan
98 |
|
Optimum
Technology |
Sep 95 – April
96 |
Bachelor of Engineering in Computer Systems (1991-1995)
Thomson Financial Wall Street NYC.
Working as a “Consultant” since March 2000 – Present
idEXEC, infoUSA Co.
· Responsible for the WEB application database maintenance, administration, planning, design and support. Perform backup and restore. Designed and developed nightly refresh procedures and scheduled jobs. Written and Automated several jobs, applications, procedures, imports and exports packages in the database and in the OS. Perfroms database transformations into different MS formats, write DTS packages.
·
Involved in the decoupling and migration tasks of idEXEC system from Thomson
systems to the infoUSA systems
· Designed,
developed, tested and implemented
new tasks e.g; Asynchronous Queries, Job forcing, Parent/subsidiaries in
www.idexeconline.com.
· Designed and
developed CSV file download feature with customize enhancements features,
written COM component in Vbasic for the creation of CSV file in
www.idexeconline.com.
·
Setup stand
by internet servers with database replication and load balancing.
·
Incooprated
a Trial user account facility in www.idexec.com. This enables us to submit
request for a two days trial account to access www.idexeconline.com .
·
EXECAlerts:
Designed and developed ExecAlert Web Application for the clients. This application sends weekly changes in any executive profile in the database via Email.
·
DATAAlerts:
This WEB application
sends monthly changes in any company profile within the database, create text
files and distributes to the client via email.
·
Media
Request Manager:
This application stores the requests submitted by the clients through web site which cannot be processed online and then process it asynchronously and creates a CD for distribution.
·
Responsible
for the maintenance, adding upcoming new enhancements, help desk, support and
batch jobs for the following website.
Development Environment: ASP, Ms Visual InterDev v6.0, MS-SQL Server 2000/v7.0/6.5, Vbasic v6.0, IIS v4.0, ADO, JAVA Script, CSS, MMC, Pc Anywhere v9.0/v8.0, Windows 2000/NT4 servers and workstations.
Toys "R" Us
International, Paramus, NJ
Worked as a “Consultant” since Dec 98 – March 2000
Web Development
·
Designed
& developed browser based front ends using ASP, HTML & VB Script.
· Designed
& developed forms & sever side scripting using ASP, connects to DB2/400
databases using ADO v2.1, implemented paging through recordsets.
· Designed
& developed external cascaded style sheets(CSS) according to the user
requirements and manipulated in the HTML.
· Worked on
JAVA/400 project, designed multi threaded 3-Tier JAVA Servlet. performed
different database manipulations for logistic application system and return
resultsets to the clients.
·
Designed and
developed servlets for the AS/400
clients/users to invoke batch and
interactive commands & program calls on AS/400.Used JAVA web server for
handling servlets at server side
·
Designed
HTML pages as per user requirements for submission to the servlets, Jscript is
used for event triggering and form validations.
Development
Environment:
JAVA/400, ASP, HTML, VBScript, Jscript, ODBC, JDBC, ADO, CSS, OS/400
V4R2, DB2/400, AS400 Development toolset for JAVA, Visual InterDev v6.0, JAVA Web
server
Vendor Charge Back (VCB) System:
·
Worked in
the design, development and testing of VCB system. The purpose of this system is
to charge canadian vendors for their late, early and short shipments as defined
in the trade agreement.. the system serves as an interface between purchase
order and the a/c payables system. Responsibilities include to design databases,
write programs and create reports
for the reversal module of the charge back system. This module reverse
the charge back transactions and undo various changes done by the various batch
or interactive processes executed on weekly basis. Creates process and on demand
reports. Control exceptions through extensive error handling and commitment
control.
Development Environment: COBOL/400,JAVA/400, JSDK2 v2.1, JAVA Web Server v2.1, HTML, OS/400 v4R2, DB2/400, AS400 Development toolset for JAVA, Win/95.
CBA
(Cost Based Accounting System):
Worked on the design and development of the
project CBA as a senior programmer.
The purpose of this project is to facilitate the merchandising and the finance
groups to use the Weighted Average Cost (WAC) methodology in evaluating
merchandise cost. this will allow consistent reporting to analyze information
and drive business decisions. Developed COBOL programs to capture different
transactions e.g; receipts, sales, mark down allowances, cost adjustments,
return goods, damaged or vendor and financial adjustment, calculate WAC, create
files, queries and reports which includes inventories, merchandising,
profitability, transaction specific and margin
analysis.
·
provide,
support, maintenance and help desk services to all the regional offices located
on different countries.
Development
Environment: OS/400
V4R3M0, COBOL/400, CL/400, DB2/400, SQL/400, Client Access for AS/400, Win/95.
AMERICAN STANDARD INC. Piscataway,
NJ.
Worked as a “Consultant” June 98 – Dec
98
COPS:
analysed,
designed, developed, implemented, tested Intranet enabling of COPS (Customer
Order Processing System). Responsibilities includes
·
involved in
the completely relational databases design in DB2/400 with the enforcement of
referential integrity.
·
Browser
based front ends using java components and
ASP.
·
Designed and
developed forms for order entry, browsing, changes and updating in ASP in
replication of the pre-designed screen. Used Jscript for the form validation at
client side.
·
Designed and
developed HTML pages for order inquiry and browsing with the enhancement of
recordset traversing and highlighted
exceptions.
Development
Environment: OS/400 V3R7M0, DB2/400, WIN NT v4.0, ASP, ADO, JAVA
v1.1.1, JSCRIPT, VBSCRIPT, IIS v2.0
DIGITAL
PROCESSING SYSTEMS, INC. NY
Jan
98 - June 98
Web
Development
Coordinated with the in house and overseas clients, presented technical and business specification and directed the development of following web sites using HTML, JavaSript, VBScript, Cgi, Front Page 98.
http://www.pakistan-embassy.com
http://www.cadsoftsolutions.com
Personal
Management and HR System
Developed,
implemented and tested browser based Personal M&HR which keeps the records
of all the employees in the company, recruiting, hiring & consultant status.
Responsiblities include
·
involved in
the database design.
·
Designed
& developed forms for data entry, browsing, inquiry, changes and deletion
using ASP and VBScript
Development
Environment:
Visual InterDec v5.0, Win NT/95, SQL Server v6.0, ASP, VBScript, ODBC.
Y2K
Changes
For a retail
chain, involved in the implementation of Year 2000 changes. The objective of
this project was to make the applications running on the system Year 2000
compliant. Involved in the inventory phase, impact analysis, programming and
data conversion. Sliding window technique was being used for making the
application Year 2000 compliant. Responsibilities include analysis, review,
making the application Year 2000 ready, unit testing and regression testing.
Development
Environment:
AS/400(OS/400 V3R7), COBOL/400, CL/400, SDA, RLU, Query/400.
NATIONAL
BANK OF PAKISTAN, HEAD OFFICE
Worked as
member of Online (Real time) and modern banking team in one of the leading state
owned bank in the capacity of ANALYST PROGRAMMER and extensively exposed to:
Visual
BASIC, COBOL/400, RPG/400, CL/400, SDA, RLU, QUERY/400, SQL/400, DDS, DFU,
JAVA/400, JAVA Script, VB Script, CGI Scripting and
HTML.
ATM
Card Holder Management System
Worked as
team programmer and responsible for the development of ATM card holder system in
Visual BASIC that keeps the record of all the ATM card holder country wide,
generate various types of reports by submitting queries using ODBC System
calls(Client Access AS/400 ODBC Drivers). Major databases
reside on
AS/400. Completely relational model. New programs were developed on AS/400. Join
logical files have been created over the physical
files.
Development
Environment:
Visual BASIC v4.0, Windows 95, Client Access for AS/400, COBOL/400,
SDA, RLU, DB2/400.
ATM(Auto
Teller Machine) Control Software
As a
Programmer/Analyst designed, developed, tested, implemented and debugged a
system comprised of several interface programs between ATM and the AS/400 in
collaboration with the IBM to manage different transactions initiated through
ATM(i.e. Balance inquiry, Cash withdrawals, Fund Transfer, Request for check
books and complete statement of account). Update all related Online data files
and hence provide a real time transactions. The design was very extensive and
handles various exceptions. Also developed a front end for transaction browsing,
inquiry and generating reports.
Development
Environment:
Win 95, Visual Basic v4.0, AS/400(OS/400 V3R7), DB2/400, COBOL/400 ,
RPG/400.
ATM
Report Management System
Designed and
developed a standard and on demand reporting system for the overall ATM
transactions for all the online/ATM branches, Head office and Regional Computer
Centers. All the ATM and non-ATM branches takes out these reports at the
start/end of each business day to reconcile the ATM transactions. This is a very
extensive reporting system, checks various exception conditions and for each
exception, separate report is generated.
Development
Environment:
AS/400(OS/400 V3R7), DB2/400, RPG/400, SDA,
RLU.
Conversion
from S/36 to AS/400
Completed
the conversion of various banking applications from S/36 mode to the native mode
of AS/400.
Development
Environment:
AS/400(OS/400 V3R7), DB2/400, COBOL/400, SDA,
RLU.
Provident
Fund System
As a trainee
programmer. Involved in the development of provident fund system and its
statement for the employees at branches and head
office.
Development
Environment:
AS/400(OS/400 V3R7), COBOL/400, SDA .
Internet/Intranet
Developmet:
Involved in
the Web development and exposed to the following areas:
·
Analysis,
design and implementation of front end browser based database JAVA Applets and
Server application to perform database manipulation over AS/400 databases using
pure IBM DB2 JDBC Drivers.
·
Developed
three tier multi threaded server application in JAVA, performs database access
to AS/400 with enhanced security and logging features, offer multiple clients to
connect with and provide different services. Client Applets connects with the
server application over a socket. the purpose of this client/server appliction
is to provide balance of inquiry
and the statement of account to the banks’s customers on the
net.
·
Provide
training and conduct classes of JAVA/400 & VB for the various staff members
and executive of the bank.
·
As a proof
of concepts pilot projects:.explored the scope of JDBC-ODBC bridge.
·
CGI
scripting in IIS/2.0.
·
Designed
& Developed ActiveX documents.
·
Designed web
site using HTML, JAVA Script, VB Script.
·
Designed and
hosted a web site http://www.nbp.com.pk
Development
Environment:
Windows NT/95, Visual BASIC v5.0, IIS v2.0, JDK 1.1.4, AS/400
Development toolset for JAVA.
Sales
Order System
Developed
& maintained a 'Sales Order System' in Visual BASIC, database was relational
and designed in Ms Access with the enforcement of refernetial Integrity.
application provides order entry, its maintanance, changes, cancellation &
updation during the overall order processing. keeps track of the inventories and
products, its availability and pricing information. allocate it for each order
under process and update status of each inventory and orders affected by its
allocation. create invoices for the processed orders generates standard and
on-demand reports. standard reports are printed at the end of each businees day.
The System assists in managing order data so as to provide customers with a
correctly priced product delivered in a timely and efficient
manner.
Development
Environment:
Visual Basic 3.0/4.0, Windows 3.1/95, Ms
Access.
MC8051
Based Control Systems Development Kit
Designed and
developed a kit for MC8051 based
control systems. Responsible for the development of front end using Visual Basic
for source entry, compiling, data uploading and downloading, signal analysis and
processing, checking status of 8051 and its ports, dump EEPROM via serial port.
Communication control of VB was used to perform serial
communication.
Development
Environment:
Visual Basic 3.0/4.0, Windows 3.1/95, Assembly
8051.
|
·
AS/400
Concepts and facilities workshop |
IBM, May
96 |
|
·
ORACLE 7
Developers/2000 |
ORA-TECH
Systems, Nov 96 - Dec 96 |
|
·
CL
Programming |
IBM,
Oct 97 |
|
·
AS/400
DB2 Coding and implementations |
IBM,
Oct 97 |
Available
upon request.