We provide IT Staff Augmentation Services!

Database Consultant Resume

MN

TECHNICAL SKILLS

  • Cobol
  • Db2
  • Oracle
  • REXX
  • SAS(basic) CICS
  • Endeavor
  • Expeditor
  • BAL
  • TSO
  • JCL
  • DFSORT
  • WebSphere MQ changeman
  • Pac2000
  • MQ Series
  • Agile
  • IMS
  • PL/1
  • OFAC
  • Microsoft OfficeConnect:Direct
  • CML
  • XMLSPY

PROFESSIONAL EXPERIENCE

Confidential, MN

Database Consultant

Responsibilities:

  • Writing programs to analyze stock market trends and direction. Utilized these programs to successfully be consistent in day trading the emini - futures
  • Used Windows and Unix machines. Oracle Databases.

Confidential, Chandler, AZ

Software Engineer

Responsibilities:

  • Developed reporting for Mainframe Security applications (Top Secret), using SAS, REXX, COBOL, CICS, DB2, Endeavor, SCLM, CLIST, Perl, MQ Series. Performed day to day maintenance and production support of security applications. Developed new processes to support security administrators.

Confidential, MN

Software Developer

Responsibilities:

  • Writing programs to analyze stock market trends and direction. Utilized these programs to successfully be consistent in day trading the emini - futures
  • Used Windows and Unix machines. Oracle Databases.
  • CICS, DB2, BAL, COBOLII, Assembler, Easytrieve, FTP, NDM, TSO, z/OS, MQ, JCL) environment Facilitated Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members. Mapped out Upstream Business Process model with various Wholesale Banking deliverables and initiate Projects to deliver these systems for a Major Financial Client.

Confidential, MN

DB2 Developer

Responsibilities:

  • Converted Tax Reporting Datacom programs to DB2. Wrote interface modules, front ends and modified hundreds of Cobol programs including batch and CICS.
  • Worked with Business and IT users gathering requirements and ensuring changes were correct.
  • Performed on call duties and day to day maintenance of production. Cobol, CICS, DB2, DATACOM, Endeavor, Syncsort, Platinum Tools, Expeditor, VSAM, JCL, NDM, SQL.

Confidential, MN

Mainframe Developer

Responsibilities:

  • Converted mainframe credit card management system from old Metris system to new Confidential standards. This included modifying existing JCL and programs. Also enhanced their systems to accommodate new credit card Clients (AMEX, etc.).
  • Cobol, DB2, CICS, FTP, NDM, Changeman, Expeditor, VSAM, TSO

Confidential, MN

Developer

Responsibilities:

  • Designed and developed OFAC business requirements and systems for money laundering, fraud and Treasury list compliance.
  • Developed systems to transfer funds between banking entities. Developed systems to support fee charges for money transfers.
  • Supported day to day operations of the MoneyGram business of transferring funds. Helped transition routine support and maintenance to off - shore support.
  • Support and development of monetary CICS online transaction processors. Supported the Investment Department with their day to day management of their extensive stock portfolio.
  • Wrote Web pages and SQL scripts to process and send data to mainframe applications.
  • Analyzed and documented a large Medical Claims system for Clinic Doctors and Dentists. Produced system flow, detail flow and process flow documents. Used NATURAL Data Definition Module (DDM) based on ADABAS. Documented enhancement options with time estimates. Wrote management summary reports and recommendations. (DOS/VSE, Natural/Adabase, CICS, ICCF, VSAM, SAS, COBOL, Telon, Unix, Oracle, TSO)

Confidential

Developer

Responsibilities:

  • Designed and developed a new business debit card product and intenerated it into the existing card system. Produced detailed specifications and test scripts. Wrote interfaces to CICS to support the web applications.
  • Developed web pages with ASP/VBScript, JavaScript and HTML and used FTP to load data from the mainframe to a Unix Sybase platform. On - line (Data Warehousing, CICS, IMS, DB2, SAS, Assembler, Macro, COBOLII, Easytrieve, FTP, Connect Mailbox, TSO) environment.

Confidential

Sr. Programmer/Analyst

Responsibilities:

  • Performed day - to - day analysis and maintenance programming on Traditional Life Insurance/Annuity systems for this conglomerate. Supported Trad and Vantage systems daily with problem resolution and enhancements. Maintained and enhanced CSP screens. Mentored off shore consulting firm to take over support of the Traditional Life Application. Developed web pages with ASP/VBScript, JavaScript and HTML and used FTP to load data from the mainframe to a Unix Sybase platform. On - line Supported production and solved program defects in an On - line (CICS, IMS, DB2, Assembler, Macro, COBOLII, PacBase, SAS, Easytrieve, Focus, TSO) environment.

Confidential, MN

Sr. Lead Programmer/Analyst

Responsibilities:

  • Installed and custom modified a Mutual Fund Sweep package for commercial bank customers. Tested with users and trained them on the use of the project. Interfaced with the Vendor for successful implementation (Cobol, Assembler, DB2, PacBase)
  • Supported the Account Reconciliation and Payable Through legacy systems in the Treasury Management Department, which included user and programming support. Installed Network Data Mover (NDM) and CONNECT/MAILBOX and PEP+ for electronic transmission of customer files. Used FTP to transfer data from the mainframe to a Unix box loading up to Sybase tables.

Hire Now