Shams Ahmad
Email :
shamsahmad@rediffmail.com
Mob : 9026041517, 9336879070
_______________________________________________________
PROFESSIONAL OBJECTIVE
Myself having Seven years of experience in the areas of Web and Software Development, Analysis, Coding,Testing, Installation and Maintenance, using varied softwares specially Oracle9i ,
Oracle Forms and regular Office management tools, on different Operating systems platform. My ambition is to excel in the above field and to make a heavy contribution to the ever improving software industry.
EMPLOYMENT HISTORY
• Presently Employed with Ad’Launchers Advertising Agency since Oct. 2008 as a System Analyst cum
programmer.
• Worked with B.B.C. Paints and Solvents Co. LTD. Riyadh, Kingdom of Saudi Arabia (K.S.A) since January 28th 2006 as a Software
programmer.
• Worked with Beeah Consultancy Group, Riyadh, Kingdom of Saudi Arabia (K.S.A) since May 2001 , as a Software Developer.. Earlier posted at Jeddah and Taif, Ministry of Municipal and Rural Affairs (K.S.A) as a Software Consultant on a different project .
• Earlier Worked with Brains APL, Pvt Ltd, Lucknow, India for two years as a
programmer/System Analyst since May 1999 till April 2001.
JOB SPECIFICATION
• Developing projects in
Oracle 8i with D2K and Visual Basic .
• Linking
Oracle Spatial Database with other Geographic Information System Softwares as Front End tools in a Client Server Architecture.
• Developing In-house as well as External projects.
• Maintenance and Upgradation of Client sites.
PROFESSIONAL EXPERIENCE
PROJECTS UNDERTAKEN IN SAUDI ARABIA :
1. Project Details :
Client B.B.C. paints and Solvents Co. Ltd
Project Name Sales,Purchase,Stock and Production Management System
Project Description The project dealt with the enhancement of current system of Managing Sales,Purchase and work flow of the production system
Project Duration Feb 2006 to Jan 2008
Responsibilities Design and Development As a System Analyst cum
programmer
I am managing an independent module in the role of System Analyst and
programmer. Identifying and documenting the user requirements.This includes initial investigation, questionnaires, creating Data Flow Diagrams, Entity Relationship diagrams, flow charts and Normalizing the tables. Also developing Database, Forms and Reports for the End Users and applying numerous Front End as well as Back End Triggers,Procedures and Functions on them for performing various Validation checks and Queries against the stored Database.
Environment This Project Developed in
Oracle 8i , Forms6i on Windows platform.
2. Project Details:
Client Jeddah Municipality, Jeddah, K.S.A
Project Name Web Based GIS System
Project Description This project was developed for local government for managing and regulating various aspects of Privately owned parcels of land, like property registration,recording legal documents for public access and review. Landuse zoning & issuance of construction permit. The idea was to put up all the relevant Maps on the web so that users can perform related quries ,look-ups and map viewing based on easy access to large data stored on Spatial database.
Project Duration Feb 2004 to Oct. 2005
Responsibilities Design and Development As a Senior
programmer
Creating PostgreSql(PostGIS) database to store Spatial data(both Gepgraphic and Demographic) associated with different parcels of land areas on Map, that can be queried and viewed from MapLab & MapServer(Front End Web based GIS tools) through Internet .
Environment PostgreSQL, PostGIS, Linux, MapServer, Apache Webserver and PHP(scripting Lang).
3. Project Details:
Client Taif Municipality, Taif, K.S.A
Project Name Goods Information system
Project Description This Project formed the part of Material Requirement Planning System. This module integrated the activities of the stores, purchase and goods inward department of the Organization.
Project Duration March 2003 to Jan 2004
Responsibilities Design and Development As a Senior
programmer
I managed the whole project in the role of System Analyst and
programmer. Identifying and documenting the user requirements.This included initial investigation, questionnaires, creating Data Flow Diagrams, Entity Relationship diagrams, flow charts and Normalizing the tables. Also developing Database, Forms and Reports for the Ministry and applying numerous Front End as well as Back End Triggers,Procedures and Functions on them for performing various Validation checks and Queries against the stored Database.
Environment This Project was Developed in
Oracle 8i , Developer/ 2000 on Windows platform.
4. Project Details :
Client Al Beeah Planners, Architects & Engineers, Kingdom of Saudi Arabia
Project Name GIS Data upload in
Oracle 8i
Project Description Conversion of GIS Spatial Data into
Oracle Database.
Project Duration August 2002 to February 2003
Responsibilities
programmer
Design and Architecture
This application was of very critical importance to the company. The Geographic and demographic data had to be uploaded on
Oracle 9i from the MapInfo 6.0 (Architectural design tool) to build web enabled database to be viewed on the intranet and internet. The task was accomplished using EasyLoader as the middleware,
Oracle 9i as backend and MapInfo as the front end tools.
Environment
Oracle 9i as Backend , EasyLoader, MapInfo 6.0 on Windows platform.
5. Project Details :
Client
Project Name Management System and Data maintenance of Trees, Ministry Of Agriculture , Riyadh, K.S.A.
Project Description This program was all about database management of trees and details. The trees were grouped under various heads according to their smell, leaves, size and so many other characteristics (around 20-25): There was also some Contractors information as to who were the contractors who were given the orders to plant these trees and what were the costs. Financial parts were also involved.
Project Duration December 2001 to July 2002
Responsibilities
programmer
Creation of Database, Forms and generation of Reports
Environment
Oracle 9i/8i with D2k on Windows 98
PROJECTS UNDERTAKEN IN INDIA :
6. Project Details :
Client State Bank Of Patiala, Lucknow, India.
Project Name Automation of Bank Account.
Project Description This project dealt with the various processes and routine transactions that take place against the centralized Bank Accounts Database .
Project Duration November 2000 to April 2001
Responsibilities
programmer/ System Analyst
Database Design , Architecture and Programming
In the capacity of system analyst I performed the initial investigation to identify the problems in the existing system, analyzing and designing the candidate system and in the capacity of
programmer , automated the whole manual process through Creation of Tables, Forms ,generation of Reports to felicitate the transactions taking place in the Bank and developing the user friendly Menu system.
Test Plans and Executions
Prepared Test and Plans to Implement the system .
Environment
Oracle 8i with D2k on Windows platform.
7. Project Details :
Client Central Command ,Army Head Quarter, Lucknow, India
Project Name Enemy Information System
Project Description This project dealt with Database Management of Enemy Information System to keep track of Enemy activities which included Addition, Manipulation and Display of enemy information thru the execution of various complex queries.
Project Duration May 2000 to October 2000
Responsibilities System Analyst/
programmer
Design and Programming
The process involved were creation of database tables, generation of forms and reports and providing different access levels on them to the users. This system being highly confidential from integrity and security point of view, the consistency and security of data had to be monitored cautiously to prevent any data loss or unauthorized access to data thru the implementation of various checks and validation on Database ,Forms and Reports. Also making arrangements for Backup and Recovery process.
Test Plans and Executions
Prepared Test and Plans to Implement the system .
Environment
Oracle 8i with D2k on Windows platform.
8. Project Details :
Client Ad’Launchers Advertising Agency, Lucknow, India
Project Duration Since Feb 2009 Onwards
Project Name Computerised Payroll information System
Responsibilities System Analyst cum
programmer
Design and Programming
This project would provide fast and easy access of information related to payroll (Attd., I.tax, Deduction at P.F etc) so as to link up all administrative operations and to reduce the information gap.
Environment
Oracle 8i with Forms 6i on Windows platform.
TOTAL NO. OF YEARS OF WORK EXPERIENCE :
In India : 2
Abroad : 5
In Main Skill Area (Application Programming) : 7
PROFICIENCY IN COMPUTERS
• RDBMS :
Oracle 8.0 with Forms 6i,VB 6.0,PostgreSQL
• Operating Systems : Windows 2000/98,UNIX, Linux(Red Hat),MS-DOS
• Software Packages : Foxpro 2.5,Dbase IV,MS-Word, Access, Lotus
• Computer Languages : C, C++,COBOL,FORTRAN 77,BASIC.
• Internet Technology : HTML,DHTML,Core & Advance Java , Apache Web Server
• Computer Hardware : PC Upgradation and Maintenance
• Web based GIS : Maplab, Mapserver,Mapinfo
QUALIFICATIONS
EDUCATIONAL
• Graduation with B.Sc. (Computer Science) Lucknow University in 1995.
• Intermediate U.P.Board in 1991.
• High School I.C.S.E. Board in 1989.
PROFESSIONAL
• M.B.A. in Information Technology and Management.
From : ALL INDIA MANAGEMENT ASSOCIATION-CME, NEW DELHI.
(Approved by A.I.C.T.E.). Course Duration : 2 Years(Jan ‘96 to Jan ‘98).
• Post Graduate Diploma in Computer Applications (P.G.D.C.A).
(Sponsored by U.G.C. Accredited by D.O.E.A.C.C.), Lucknow.
Course Duration : 1 Year.
• Certificate course in
Oracle 8.0 with DEVELOPER/2000.
From:SOFTWARE TECHNOLOGY GROUP INTERNATIONAL LIMITED (S.T.G.),
Lucknow, India, Course Duration : 6 Months.
• Certificate Course In Core and Advance Java from SSI, Lucknow, India.
• Advance Diploma in Computer Hardware, Maintenance and Networking .
From : INSTITUTE OF COMPUTER LANGUAGES AND TECHNOLOGY(ICL),Lucknow, India
PERSONAL PROFILE
FATHER’S NAME : Musharraf Husain
DATE OF BIRTH : 31st of May 1973
ADDRESS : 9/281,Munshipulia, Indira Nagar,Lucknow,U.P.
PERSONAL STRENGTH:
Willingness to Learn, Hard Working, Flexible, Honest and Sincere, Professional Attitude.
DECLARATION:
I hereby declare that the above written particulars are true to the best of my knowledge and belief.
Signature:
Shams Ahmad