We provide IT Staff Augmentation Services!

Sybase Consultant Resume Profile

Washington, DC

EXPERIENCE SUMMARY

  • Over eighteen years of experience in information technology with major strength in:
  • SQL Transact-SQL , SYBASE , UNIX and Perl scripting.
  • Experience in all stages of system development, testing and production support.
  • Strong problem solving and analytical skills to coordinate and resolve problems efficiently.
  • Extensive user support and training.
  • Good Interpersonal and communication skills.

TECHNICAL SKILLS

  • Development Tools: UnixKorn Shell awk, sed , PERL script,
  • Rapid SQL, DBArtisan, SQL Programmer, Erwin, CVS, ClearCase, SVN.
  • Fair knowledge in: JAVA, JDBC connect to MySQL database and execute queries and process result set, Connect MySQL database from Perl and execute queries and process result set, JavaScript, HTML, XML.
  • Database Expert level : Sybase versions: 12-15x.
  • Database Fair level : Microsoft SQL Server 7.0-2000, Oracle 10g, MySQL.
  • Operating Systems Expert level : Unix Solaris, AIX, HP-UX, Windows all types.

OBJECTIVE

To work in a position where my skills in SQL, database, and UNIX can be utilized.

WORK EXPERIENCE

Confidential

Sybase Consultant

  • Company was running old Sybase 11.9.2 version and had page allocation error with 'Severity 16' which needed to be fixed ASAP.
  • I was hired only in a few hours notice to run to their office in Washington DC
  • to fix the issue.
  • Dropping and recreating the corrupt table and BCP was used to fix the problem.
  • Assignment completed successfully in a few days with huge appreciation from the company.

Confidential

Sr. Database Developer

  • DTCC is global leader in the financial services industry which processes 100 million transactions amounting trillions of US dollars everyday. Worked in a new project called Post Production Phase 1 . Project involves better risk calculations for the parties involved in trades.
  • Sybase 15.7 with Unix Solaris and Windows8 was used.
  • Task involved:
  • Creating data model, implementing data model to create tables and indexes in a new database, writing numerous stored procedures for front end Java screens.
  • Wrote Unix shell scripts with sed and awk to run in Autosys to import data from post production database to this new database. Changes to the stored proc codes were made quickly as the logic changed for business requirement.
  • Prepared the database for testing.

Confidential

Sr. Database Developer

  • Worked for Wellpoint in a new project called WCRE Women Contraceptive Religious Exemption from inception to completion.
  • Sybase 15.7 with Unix Solaris and Windows8 was used.
  • Sybase format file was used for new input fields added and the row size was 3000 bytes.
  • Altered General Ledger input tables, revised reporting procedures and altered various proxy tables. Added many new tables with stored procedures. Tuned all the procedures for performance which involved more than 25 million rows.
  • Wrote many shell scripts using awk and sed.
  • ClearCase was used for version control.

Confidential

Sr. Database Developer

  • Confidential Securities has selected Broadridge Global Processing Solution, which includes the Impact, BPS, and Gloss applications, as system of record for fixed income and equity trade processing and reporting functionality from trade capture through settlement. The Broadridge solution will replace the existing SunGard Phase3 system currently used by Wells Fargo Securities today.
  • Working with compliance team to rewrite all the stored procedures for reports due change in Trading system as mentioned above.
  • After rewriting all the procedures fine tuned them for performance:
  • Database: Sybase ASE 15.0.3

Hire Now