SUMMARY:

More than 20 years programming and application development experience. Broad experience in design and analysis of application systems. Involved in all phases of system design and development: program specifications, comprehensive tests, technical documentation, and maintenance. Offshore/onshore production team management experience

TECHNICAL SKILLS:

Proficient in: Oracle SQL, SQL*PLUS, PL/SQL, DCL, COBOL, PL/I, FORTRAN, PRO*C, C

Familiar with: Java, SCO Unix/Linux shell scripts

Database: ORACLE 11g and corresponding developer tools, Oracle Forms 10g, Oracle Reports 10g, Oracle SQL*Loader, Oracle Export/Import utility, TOAD, Oracle SQL Developer, Oracle PL/SQL Developer, FTP, PVCS, Clear Case, Clear Quest, Microsoft SQL Server2008, Microsoft Access, SharePoint, Autosys job system

Familiar with: BI Publisher

Platforms: Microsoft Windows 2000/NT/XP/Vista/7/8, Dec Open Alpha, SCO UNIX/LINUX

PROFESSIONAL EXPERIENCE:

Confidential

Technical Consultant

Responsibilities:

• Designed, coded, tested and implemented programs, stored procedures and data base triggers for COTT, OMAC,TPL, InfoITA, AWD Systems by using Oracle PL/SQL, Microsoft SQL Server 2000/2003/2008
• Created SMTD and SOP documents for each maintaining system
• Maintained and supported different parts of the client system (COTT, OMAC etc. Systems) and provided support for over 100 end - users
• Developed and Implemented On-Line and Batch programs for State Street bank by using Oracle SQL, SQL*Plus, PL/SQL
• Submitted corresponding batch processes by using Oracle DBMS JOB package, shell scripts, and AutoSys Job Scheduler
• Designed User Interface as well as Ad-Hoc and On-Line Reports (Tabular, Master Detail, Form, Form Letter, Matrix reports) by using Oracle SQL*PLUS, Oracle Reports 10g
• Resolved extensive Debugging and Troubleshooting problems of the systems
• Fully responsible for maintenance and production support
• Designed and created flow diagrams and narrative of procedures
• Fully responsible for performance analysis and tuning of applications

Confidential

Sr. Programmer Analyst

Responsibilities:

• Fully responsible for maintenance and production support
• Designed, coded, tested and implemented programs, stored procedures and data base triggers for a shipping company
• Loaded Mainframe’s data to ORACLE database by using Oracle SQL* Loader, Oracle Export/Import utility, FTP, and developed Ad-Hoc reports
• Designed and created flow diagrams and narrative of procedures
• Fully responsible for design and coding of Billing, Import, Documentation, Wharfage, Brokerage, AMS applications
• Developed Import, Documentation, Billing, Wharfage, Brokerage, AMS, and Archive projects:
• Developed background processes for corresponding projects by using Oracle SQL, SQL*PLUS, PL/SQL (Created Oracle PL/SQL Packages that include Oracle PL/SQL Procedures and Oracle PL/SQL Functions)
• Submitted corresponding batch processes by using Oracle DBMS JOB package or shell scripts
• Developed reports (Tabular, Master Detail, Form, Form Letter, Matrix reports) for corresponding projects by using Oracle 6i, Oracle 9i, Oracle 10g Reports
• Developed front ends for corresponding projects by using Oracle 6i, Oracle 9i, Oracle 10g Forms
• Performed Y2K modification on 50% of all existing applications in the system
• Fully responsible for design and coding of more than ten background processes that include numerous data base packages
• Fully responsible for performance analysis and tuning of applications
• Designed, developed, coded, and maintained security for all applications
• Provided support for over 100 end-users

Confidential

Programmer/Analyst

Responsibilities:

• Designed, coded, tested and implemented programs, stored procedures and data base triggers for Automated Directory System by using Oracle PL/SQL
• Maintained and supported different parts of the client system (Contract Processing, Sales Administration) and provided support for over 30 end-users
• Developed and Implemented On-Line and Batch programs for telephone company by using Oracle SQL*Forms 3.0, Oracle SQL*ReportWriter 1.3 (Tabular, Master Detail, Form, Form Letter, Matrix reports), Oracle reports 2.5, Oracle SQL, SQL*Plus, PL/SQL, SQL*Menu, DCL
• Submitted corresponding batch processes by using Oracle DBMS JOB package
• Designed User Interface as well as Ad-Hoc and On-Line Reports (Tabular, Master Detail, Form, Form Letter, Matrix reports) by using Oracle SQL*PLUS, Oracle SQL*ReportWriter 1.3, Oracle Reports 2.5
• Resolved extensive Debugging and Troubleshooting problems of the System

Confidential

Programmer/Analyst

Responsibilities:

• Designed, coded, tested and implemented programs for Marketing systems for variety of clients (brokerage companies, retail companies, credit card companies, etc.) by using Oracle Forms 3.0 and Oracle SQL*ReportWriter 1.3
• Created tables for Client List, Sales List, Product List, etc. by using Oracle SQL
• Generated reports for marketing analysis, mail merge, etc (Tabular, Master Detail, Form, Form Letter, Matrix reports) by using SQL*ReportWriter 1.3
• Designed On-Line User Interface and tested different parts of the system as well as the integrated application by using Oracle PL/SQL