Profile

• 13 plus years of experience in the IT Industry.
• Over 8+ years extensive experience in developing Web based Applications / e-Applications in Object Oriented Architectural Environment, Post-Relational Databases Environment, and Multi instance Production Databases.
• Six years of experience in managing and administering multi-environment, mission critical, system with working experience of Decision Support System (DSS) and Comprehensive Knowledge ofOnline Transaction processing System (OLTP), Relational database management system.
• Experience with Mumps, InterSystems Cache Object Script, InterSystems Cache server pages, InterSystems Zen, InterSystems Web Services, InterSystems Cache Direct, Cache Explorer, Cache Configuration Manager, Cache Terminal, Cache Studio, Cache SQL Manager and Cache Database.
• Intensively queried information from SQL Server 6.5/7.0/2000 and Oracle databases on the Windows NT 4.0 and 2000 platforms,
• One year Exclusive experience in ASP .Net.
• Experienced in database modeling, database design and development, monitoring of Cache (Cache database performance, Cache database tuning) Oracle (Oracle database backup & Recovery, Oracle Network configuration, Oracle data management tools and packages)
• MS SQL SERVER (Tables, Views, Stored procedures and Triggers)
• Experience with Rational Unified Process (RUP)
• Experience with Agile/Scrum
• An Oracle 8 Certified DBA (OCP).

EDUCATION

• M.S. in Computer Science
• Post Graduate Diploma in Database Management System

ADDITIONAL QUALIFICATIONS

• Online course in Cache server pages (CSP) and Cache Object Script.
• On Site one week InterSystems Zen training
• One week Unit testing course with InterSystems
• Three (3) months Course in Java, HTML, DHTML, ASP.
• Two (2) Years Diploma in Computer Software Technology from ITC
• Four (4) Months Course in Network Application from ITC
• One (1) Month Course in Oracle Financial (GL, A/C Payable)
• SIX (6) Months Course on SCO Unix, Red hat Linux 6.2
• Two (2) Months Course in Oracle Forms/Report/Designer 6i
• Oracle Certified Professional DBA Version 7.3 & 8.0
• Two (2) weeks courses in Clear Quest, Clear Case, and Rational Requisite Pro
• One week Agile/Scrum training
• One week Jazz/RAT training
• One day JSpell HTML/Evolution training

TECHNICAL SKILLS

• Web developing tools: InterSystems Cache, InterSystems Zen, Web Link, Dream Weaver, Sun Micro System's Forte for Java, Borland's J builder, MS Front Page, ASP and STL, Visio, JSpell HTML, JSpell Evalution.
• Languages: Mumps, .Net, Java, Visual C VBScript, JavaScript, HTML & DHTML, XML, SQL, Fox Pro, Visual Basic.
• Database Software: Cache 3.x/4.x/5.x,2008/2010.2 Oracle 8i/8.x/7.x, MS SQL Server 6.5/7.0/2000.
• Tools: Rational Requisite Pro, Rational Clear Case, Rational Purify, Rational Clear Quest, Rational Quantify, Rational Test Manager, UML, Rational Rose, Rational Unified Process, Jazz/RAT, ERWIN3.x, Crystal Reports
• Operating Systems: Windows N.T 3.51/4.0/9X/2000/XP, Red Hat Linux 6.2/7.0, SCO UNIX, and SUN UNIX.

PROFESSIONAL EXPERIENCE

Confidential
Tallahassee, FL.USA
Project: Health Management system (HMS).
Programmer Analyst/Cache Web Application Developer
January \'05 - Present

The Bureau of Application Development & Support (ADS) of the Confidential is working in collaboration with the Office of Planning, Evaluation and Data Analysis (HPE) to develop the Health ManagementSystem (HMS), a new distributed web-based application that will begin phasing out the existing Health Clinic Management System (HCMS) in July 2006. The HMS will include functionality available in the current HCMS system and additional functionality identified through the County Health Department (CHD) Business Process Analysis (BPA) process.

HMS is a state-of-the-art web application that utilizes an object-oriented design for the development and implementation in InterSystems Cacheä.

PRIMARY JOB RESPONSIBILITIES

• Write the server-side and client-side, Zen methods/code
• Develop reports by using Cache web studio
• Develop Cache Routines, Methods and Classes in Cache Studio
• Develop Cache Zen pages, Custom Composites, Zen Application and Components
• Develop various Cache utilities
• Perform Test driven Unit testing for Business logic layer by using Cache %UnitTest Package
• Reviewed Unit testing for User Interface Layer by using Cache %WebStress
• Perform System Enhancement tasks
• Maintain Defect Resolution in the HMS System through Tester applications
• Coding/Programming in Cache cubes
• Develop source control hooks with Clear Case Explorer
• Create functions and object in JavaScript language
• Create custom tags in Cache
• Design interactive web pages in HTML
• Develop sub routines and SQL Queries in Cache SQL Manager
• Manager Employees profile and accounts
• Test Method and Queries in Cache Terminal
• Maintain Classes and Properties through Cache Explorer and Cache Control Panels
• Attend and participate in Use Case and Enterprise operation Meetings
• Practice Agile methodology and scrum framework
• Create Cache web services to export and import lab result from LabCorp
• Experience working with HL7 Protocol
• Manage Clear Quest Tickets for Enhancement and Correction.
• Communicate and work closely with Health Management System (HMS) business analysts and testers, as well as Health Planning and evolution HPE staff for review and corrections to work products.

Environment:InterSystems Cache, InterSystems Zen, Cache SQL Manager, Cache web studio, VBScript, JavaScript, SQL, HTML, Rational Requisite Pro, Jazz/RAT and Windows NT 4/XP.

Confidential
Tallahassee, FL.USA
Project: Online MY ElectricMD health system.
Programmer Analyst/Cache Application Developer
June '02 - November '04

MyElectronicMD is a revolutionary self-screening health system that facilitate user to discover the condition that might be causing your symptoms and also prepare you for your doctor visit. This application was developed using the Cache Objects & Cache Server Pages. Cache Routines were developed to enhanced the health system\'s productivity in order to import and export data from different components. Cache Server Pages were used to develop client interface for Bereavement Program that is a partial part of MyElectronic MD.

PRIMARY JOB RESPONSIBILITIES

• Analyzed software requirements and business requirements documents developed in Rational Requisite Pro, to get a better understanding of the system from both technical and business perspectives
• Developed Cache Classes in Cache Studio for Client Registration, Client Medical History, Client Medications and Symptoms.
• Created Transactional Bitmap indexes for better performance on queries.
• Designed and developed the Web User Interface using Cache Server Pages, JavaScript, VBScrtipt and HTML
• Created Cache routines to Export/Import data in related system.
• Developed Cache methods and functions for Server side processing of business logic.
• Used Custom Tags in Cache Server pages.
• Managed Logical Locking for height concurrency.
• VA Fileman database were used as reference for data structures.
• Designed components using object-oriented designmethodology
• Used SQL queries in consonance with database execute methods to access data from different Cache Classes (tables)
• Managed Relational Database access with Cache Relational Gateways.
• Developed Multidimensional Data Model, Rich Multidimensional Data Structure.
• Handled Transactional Processing with large number of Users.
• Monitored unattended Backup while the database was being updated.
• Increased performance and scalability with Enterprise Cache Protocol.
• Derived e-Application with the power of post relation Cache.
• Integrated Cache with other Object Oriented Technologies.

Environment: Inter Systems Cache, ASP.NET, VB.NET, VBScript, VA Fileman, JavaScript, SQL, HTML, Rational Requisite Pro and Windows NT 4.

Confidential
Tallahassee, FL
Project: Finance and Human Resource Tracking
Programmer Analyst/Senior Web Application Developer/DBA
November '01 - March '02

GIS provided consulting services to Confidential to develop a web based salary review tool. The application was developed using VB/ASP, Developer 2000 as a front-end with MS SQL SERVER 7.0 on Sun Solaris 2.7 as a Back-end. This allowed for managers to login with varying access levels. This application provided managers the ability to review their employees, track funds for their group add new employees, delete employees, move employees between managers and so on. Administrators from the compensation team have the ability to assign funding for the year, create new managers and assign employees to that manager, delete managers and assign employees to a different manager or reassign employee's level.

PRIMARY JOB RESPONSIBILITIES

• Database design, sizing and creation, tuning and reorganizations
• Developed several stored procedures and triggers, which incorporated all business logic of the application.
• MS SQL SERVER Installations and Upgrades on Sun Solaris & Windows NT
• Created HTML and DHTML pages
• Define Java Script stored Procedures and Functions
• Security implementation via roles/privileges.
• Removed certain commands from users using Product User Profiles
• Created database triggers and stored procedures for web based projects.
• Monitored active processes, rollback segments usage, segment growth etc.
• Generated reports regarding backup status (exports, hot and cold backups), alert log monitoring and database space checks.
• During production phase took part in software support group. Particularly I:
• Tuned up the MS SQL Server database to achieve the best performance.
• Played role of the Database Administrator (DBA)
• Crystal Reports was used as a reporting tool

Environment: MS SQL SERVER 7.0, Developer 2000,HTML, SQL, Java Script VB/ASP, IIS, Crystal Report, Sun Solaris 2.7, and Windows NT

Confidential
Karachi, Pakistan
Project: Designed an Enterprise Resource Planner (ERP)
Project Manager/ Programmer Analyst
June '00 to September '01

Confidential provided consulting services to English Biscuit Manufacturer (EBM) to develop an Enterprise Resource Planner (ERP). The application was developed using Oracle8i onRedHat Linux 6.2 as a Back-end and Developer 2000 on Windows NT Server 5 as a front-end. This application facilitate all departments of EBM including Sales & Marketing, Human Resource, Commercial & Store, Finance, Production, Engineering, Budgeting, Treasuring and Administration to perform paper-less on-line functions including on-line approvals and authorizations according to company's Basic Accounting and Financial Rules. This application allowed for each Head of department to fill their respective forms and Generate possible required reports online. Through this application Finance Department assign monthly budget to all individual departments and all individual department also estimate their future budgets according to their previous expenditure on-line. Login levels are categorized according to its responsibility and functionality by assigning different roles and privileges to different group of users. Deletion, updating and authorization are restricted to different layers of employer according to their responsibility performed in their respective departments.

PRIMARY JOB RESPONSIBILITIES

• Analyze the current Manual system and legacy data
• Design proposed comprehensive system
• Developed Business Flow Diagrams and Flow Charts
• Developed Entity Relation Diagrams (ERDs)
• Developed Data flow Diagrams (DFDs)
• Developed Hierarchical Flow Diagrams (HFDs)
• Database design, sizing and creation, tuning and reorganizations.
• Oracle Installations (Oracle 8.1.6) on Linux & Windows NT.
• Developed Oracle Connectivity by using Net8 features.
• Re-Scheduled the reports for the best output and powerful decision-making.
• Developed the Project Documentation.
• Performed project testing & implementation & Follow up.

Environment: Oracle 8i, Oracle Enterprise Manager ,HTML, Java Script, SQLVB script, Forms 5.0, Reports 3.0, PL/SQL, Red hat Linux 6.2, and Windows NT

Confidential
Karachi, Pakistan
Programmer Analyst/ORACLE Database Administration
February '99 - June '00

Wasa Pharma is the local company established in Pakistan for last 15 years.

Wasa-Pharma captured 60% of its target market of Medicine in Pakistan. It has two Production plants located in different regions.

As the sole Database Administrator, was responsible for database administration for the whole plants. Primary responsibilities included upgrading, maintaining, assisting developers, and tuning theOracle 8.0.4 database.

PRIMARY JOB RESPONSIBILITIES

• Ensuring availability of database
• Creating stored procedures
• Managing physical storage structures
• Managing storage space
• Enrolling new users
• Security implementation via roles/privileges
• Oracle Installations (Oracle 8.0.4)
• Monitored active processes, rollback segments usage, segment growth etc.
• Managing Database users
• Ensuring System Security
• Performing complete & incremental backups
• Recovering database in case of failure

Environment: Oracle 8.0.4, Forms 5, PL/SQL, SQL*Loader, and Windows NT 4

Confidential
Karachi, Pakistan
Project: Complete Financial System including Payroll System, Account Payable, Account Receivable, Ledgers, and Managing Assets
Programmer Analyst
May '97 to January '99

Printel Circuits is the Electronic Circuits Manufacturer; these Circuits are used in different Electronic Home Appliances. Printel Circuits is sole proprietorship based in Pakistan.

As a Programmer Analyst, I was responsible to analyze the different phases of the Client Services System (CSS), make a retrieval of information on demand, providing user-friendly interface to other staff of the company, also developed the System Reference Documents (SRD) and User Help Documents (UHD), this system will be compatible for other standard database platforms such as FoxPro, PL/SQL, SQL Server and MS Access. Mainly whole work was being utilized toward the front-end tool Developer 2000 and Oracle 7.3 RDBMS as back-end engine on windows NT network operating system and. As a Programmer Analyst successfully developed Financial System of the company in GUI environment which consists of Payroll System, Account Payable, Account Receivable, Ledgers, Managing Assets etc. using Oracle 7.3 RDBMS and Developer 2000 as front-end tools.

PRIMARY JOB RESPONSIBILITIES

• To develop System Reference Documents (SRDs) & User Reference Documents(URDs)
• Analysis of various programming phases
• Designing the appropriate model
• Managing logical flow of information
• Developing Financial System including Payroll application, GL, Account Receivable
• Responsible for planning, implementation and project completion time of database management programs.

Environment: Oracle 7.3, Developer 2000, Visual Basic, SQL, PL/SQL, FoxPro and Windows NT 4

Confidential
Karachi, Pakistan
Programmer
May'95 to May' 97

Printel Circuits is the Electronic Circuits Manufacturer used in different Electronic Home Appliances. Printel Circuits is sole proprietorship based in Pakistan.

As a Programmer, I was engaged in the writing of computer programs with logic development and dataflow and participated in coding the computer programming logic and debugging the resulting programs and also connected with user support and trouble shooting activities.

PRIMARY JOB RESPONSIBILITIES

• Developing applications
• Code writing & debugging programs
• Testing & troubleshooting
• Training & support for users
• Installation
• Documenting programs

Environment: Oracle 7.3, Developer 2000, Visual Basic, PL/SQL, FoxPro and Windows NT 4

Confidential
Karachi, Pakistan
Computer Programmer
January' 94 to April' 95

Fero Industries is located in Karachi, Pakistan and having a factory in Karachi industrial area in which all activities were performed regarding Marble and Stones including Cutting of Marble, Polishing and Finishing of different type of Stones and also providing raw material to specific American Companies. Fero Industries are having mines in Sindh Pakistan Mining Area and working from last 12 years.

As a Programmer, I was responsible for making user-friendly Programs in ORACLE for company's different requirements and also Participated in database development, Managing spread sheets and data volume, taking care of in use dedicated software by making some minor modification as per user requirement.

PRIMARY JOB RESPONSIBILITIES

• Developing programs
• Participating in database development
• Managing spreadsheets and data volume
• Performing minor modification in dedicated software

Environment: Oracle 7.3, Developer 2000, Visual Basic, PL/SQL, FoxPro and Windows NT 4.

CERTIFICATIONS

Secured Cache 5.1 and OCP 8 DBA certification in the following areas:

• Cache Object Script (InterSystems Cache Developer Certification)
• Introductions to Oracle SQL and PL/ SQL
• Oracle7.3 Database Administration
• Oracle7.3 Backup and Recovery Workshop
• Oracle7.3 Performance Tuning Workshop
• Oracle 8 Network Administration