We provide IT Staff Augmentation Services!

Technical Consultant Resume

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:

  • Technical leader on all applications involved in
  • 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
  • Support of multiple tasks related to super user and end user
  • 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:

  • Team leader on all the projects involved in since 2001
  • 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

Hire Now