Post Job Free

Resume

Sign in

System Sql

Location:
Dayton, OH, 45431
Posted:
March 09, 2010

Contact this candidate

Resume:

Najeeb Goher Ali Khan

**** **** ****** ******,

Dayton, Ohio 45431

C 937-***-****

H 937-***-****

abm6u4@r.postjobfree.com

Education

University of SINDH

MS, Mathematics

Status US Citizen

Hardware/Software

Hardware: VAX-ALPHA, VAX-4000, VAX-2000, Mainframe IBM-370,

IBM 4331, IBM 7026-6MI, IBM Compatible PC's, Client/Server

Operating Systems: OPEN-VMS, VAX-VMS, UNIX (SCO_SRV), AIX,

Windows NT, Windows 2003, Windows

(Professional)/XP/98/95/3.1, DOS/VSE, MS-DOS, PC-DOS

Databases: Oracle, Ingress, Corevision, MS Access, FoxPro,

Clipper, Dbase III Plus

Languages: VAX-COBOL, VAX-C, PRO* COBOL, SQL, PL/SQL

Applications: Pharmacy Benefits management System (HDS),

Cellular Phone Billing System, Order Processing System,

Electricity Billing System, Accounts and Finance information

system, Line Losses system and New Application Procedure

System

Tools: DCL, DEC-FORMS, CMS, RMS, CDD, TPU, EDT, DEBUGGER,

FMS, Datatrieve(DTR), KORN-SHELL, C-SHELL, PERL, JCL,

APPLIX, STARTEAM, ORACLE FORMS, ORACLE REPORTS, ORACLE

LOADER, TOAD, PL/SQL DEVELOPER, SUPPORT MAGIC, ECLIPSE, TEL-

NET, VI, TEXT-PAD, FTP, Dev-2000,

Experience

May 2008 to Feb 2009 Aurora Systems Group, Inc Saint Louis (Client

Express Scripts, St Louis MO)

Worked as senior programmer in (Pharmacy

Benefits Management (PBM) Company), the company works for

health insurers and employers including DOD which hire ESRX

to manage prescription drug benefit plans for their members

and employees. Worked on VAX COBOL and VAX-C based Home

Delivery System (HDS), main duties were analysis, development

and modification of COBOL programs, creation of test case and

testing. Worked on OPEN-VMS, VAX-COBOL, VAX-C, CDD, DEC-

FORMs, RMS, CMS, MMS, DCL (.COM files procedures),

RTL_Routine, along with FTP, TPU, DEBUGGER and Datatrieve

along with Micro Soft office 2007 Prof (OUTLOOK, WORD, EXCEL,

and ACCESS)

Sep 2007 to Apr 2008 CareSoft Inc, NJ (Client Delaware Valley

Financials, Philadelphia PA)

Worked for as senior programmer in

financial company which provides administration for

Variable annuities to number of

Insurance Companies like Allianz, Genworth, AIG ...

. Worked on Premium Processing System which is based on

OPEN-VMS, DEC-RMS, VAX

COBOL, PRO*COBOL, SQL, PL/SQL (ORACLE9i)

. Developed/modified COBOL programs to create ISAM files,

reports and data entry screens.

. Worked on SQL (DDL, DML), developed / modified queries to

insert / update and extract the

table's data, used sql* plus prepared reports.

. Created / modified tables, index, sequence and views for

testing.

. Worked on PL/SQL, developed / modified packages,

procedures, functions triggers and cursors.

. Used PL/SQL DEVELOPER debugger, beautifier, report, and

performance optimizer

. Worked on Accent R database and DCL (.COM files

procedures) in DEC-VAX /VMS

environment.

Main duties were development, break fixing, testing, code

walk through and documentation. Worked on VAX-APLHA OPEN-

VMS, VAX-COBOL, PRO*COBOL, DEC-FORMs, ORACLE9i database, SQL,

PL/SQL, PL/SQL DEVELOPER, RMS, DCL, LOTUS NOTES, and VSS.

Nov 2002 to Sep 2007 Atlanta Group of Systems (Client VeriSign, Sawana

GA)

Worked as a senior developer ion a COBOL / Oracle based

Cellular Phone Billing application in client/server

environment. Responsibilities included analysis, technical

spec design, development, testing, data review, code walk

troughs and creation of test cases.

. Worked on development & modifications of COBOL based work

order and POS programs.

. Worked on sequential, indexed sequential and Relative data

files.

. Worked on Unix Shell Scripting (Korn-Shell), developed /

modified shell scripts for lock boxes payment system and

automation of back ground jobs and other procedures to make

files available for process.

. Provided Production Support 24 X 7 to resolve day-by-day

issues including bug fixing.

. Also worked as a team member on a migration project of cell

phone billing from COBOL to ORACLE, worked on development /

modification of SQL quires to insert, update, delete the

records from tables.

. Worked on SQL* Plus to prepare the reports,

. Worked on PL/SQL, developed / modified packages, procedures,

functions, triggers and cursors.

. Created tables and views for testing,

. Wrote flat file extract programs and control file (ctl)

scripts to load the data into tables through ORACLE loader.

. Worked on UNIX (SCO_SRV), AIX, COBOL, ORACLE9i, SQL, PL/SQL,

APPLIX, STARTEAM, TEL-NET, VI, K-SHELL, C-SHELL, PERL, TEXT-

PAD, TOAD, SMART FTP and Microsoft Office (OUTLOOK, WORD,

EXCEL, ACCESS).

Jan 2000 to Nov 2002 International Software Technologies (Client Reymolds &

Reynolds, Dayton OH)

. Worked as programmer ion the Order Processing System (OPS) /

Customer Master. Provided support and resolved day-to-day

user problems. Worked with the users, gathered requirements,

performed analysis, developed / modified INGRESS database

procedures and VAX-COBOL programs, developed / modified SQL

queries for reporting and manipulation of data in

tables(DDL, DML),

created tables for testing. Also made changes in data entry

screens, menus and reports programs. Worked on DEC/VAX, VAX-

ALPHA, Windows NT, OPEN-VMS, RMS, CMS, DCL, ABF, QBF, COBOL,

DEC-FORMs, FTP, TPU, DEBUGGER, RTL routines, Microsoft

Office (OUTLOOK, WORD, EXCEL, and ACCESS) and Support Magic.

Aug 1990 to Sep 1999 Water And Power Development Authority Hyderabad

. Participated in design and development of program modules

and test plans for batch and online functions of major

electrical application.

. Designed and developed a major accounting application to

properly handle billing, collections and receivable in large

water and power organization. The application was

implemented in five different electrical distribution

companies.

. Worked on ORACLE -7 database and developer-2000, developed

data entry forms and reports. Worked on SQL, PL/SQL, ORACLE

Forms, ORACLE Reports, wrote SQL queries, packages,

procedures, functions, cursors and database/ forms triggers.

Optimized queries. Used SQL*Loader to load data from flat

files to tables. Converted an accounting system from VAX-

COBOL and VAX-C to ORACLE 7. Transferred the data from a

legacy COBOL application and wrote completely new packages &

procedure, using PL/SQL, ORACLE Forms and ORACLE Reports.

Worked on database applying standard normalization methods

and designed indexes to optimize query efficiency. Developed

procedures to govern database modifications to ensure data

integrity.

. Modified the billing system written in VAX-COBOL, and

provided 24/7 production support to different sites.

Interfaced with users and management at five electrical

companies to successfully insure that the requirements of

each site were met. Used CMS to maintain the programs

history. Wrote command procedures in DCL (.COM) to automate

the system. Used VAX-ALPHA, Windows NT, OPEN-VMS, RMS, DCL,

TPU, CMS, FMS, DATATREIVE, DEC-FORMS and DEBUGGER.

Jul 1988 to Aug 1990 Water And Power Development Authority Multan

. Worked, maintained and implemented a VAX-COBOL based

electrical billing system. Reviewed and approved technical

system change documents, including software specifications

and requests for application & database modification.

Developed programs to perform data collection, editing, and

processing on DEC/VAX machines, used VAX-VMS, DCL, TPU, FMS,

RTL routines, DEBUGGER. Also worked on several Y2K projects

and provided 24x7 on-call system and production support.

Sep 1986 to Jul 1988 Water And Power Development Authority Gujranwala

. Responsible for analysis, development & implementation of

the Electrical Line Losses System and electricity billing

system worked on VAX-COBOL, worked on DCL, TPU, RMS, and

FMS.

. Provided day to day support to COBOL based data entry system

which transferred data from PC to VAX.

. Performed systems analysis, detail design, development,

enhancements, modifications, and unit and system testing for

an electricity billing system used IBM COBOL II worked on

IBM-MF 4331 JCL, DOS/VSE.



Contact this candidate