We provide IT Staff Augmentation Services!

Etl Datastage Developer Resume

Princeton, NJ

SUMMARY:

6+ years DataStaage ETL developer experience with Server 8.0 and Enterprise 8.5. 10+ years Oracle 10G SQL, SQLPLUS, Sqlloader15+ years UNIX/LINUX ksh, bash, system administration, file manipulation.

SYSTEMS:

  • IBM WebSphere Information Server 8.0, Enterprise edition 8.5
  • DataStage Designer, Director, Administrator
  • HP - UX B.11.23 ia64 and Fedora LINUX
  • SAP (Business Partner, FS-RI, FS-CD, FI-GL, FI-RMNL)
  • ORACLE 10G
  • TOAD for ORACLE 9.5
  • ERWIN
  • SQL, PL/SQL, SQLPLUS, SQLLOADER
  • HP Quality Center 9.2
  • MicroFocus COBOL on HPUX application programming
  • Microsoft Office Suite 2007 for XP, Vista, Windows 7
  • HP Compaq Windows Vista XP, Vista, Windows 7

PROFESSIONAL EXPERIENCE:

Confidential, Princeton, NJ

ETL Datastage Developer

Responsibilities:

  • Design, code and test a solution for automatic update of zero dollar chargbacks in MODELN database table with 200 million rows.
  • Created Sql Developer code and tables for development and testing.
  • Created Sqlplus code and bash script to control job executed from cron with log and results emailed to key users.
  • Datastage 8.5.
  • Fedora/Redhat/LINUX education and training including LINUX Bash scripting, File System administration, User administration, VMBOX, Veritas Cluster, Veritas Volume Manager configuration, LVM, Raid configurations, Autofs, NFS, cron, ssh, and sftp. IBM WebSphere - Enterprise Edition Parallel Extender study and practice for consulting opportunities in NJ area.
  • Talend ETL development to convert NJ CASS systems to CURAM package using Talend open source ETL tool on AIX platform. This was a short assignment due to HP global downsizing business objective.

Confidential, Princeton, NJ

ETL Datastage Developer

Responsibilities:

  • DataStage 8.0 ETL, UNIX scripts and Oracle programming and technical support converting legacy International Confidential systems to SAP FS-RI, FI-GL, FS-CD, and Business Partner.
  • Code complex ETL jobs using hash files, Oracle OCI, Oracle Bulk Loader, complex transformation logic routines and sequencers to transform legacy Contract Confidential system files to Oracle tables for loading into SAP FS-RI.
  • This included writing and executing over 100 validation queries using SQLPLUS with results updated in Oracle table and Excel spreadsheets for user signoff.

Sr. Programmer Analyst

Confidential

Responsibilities:

  • Develop UNIX shell scripts, COBOL programs and procedures to handle critical data file transfers, and access to remote systems in Brussels, Singapore, London and Australia.
  • Develop VB macros to manipulate and format data in excel pivot tables.

Confidential, Exton, PA

Sr. Programmer Analyst

Responsibilities:

  • Consulting for Confidential and Confidential Plan Service migrations from Wang VS COBOL to UNIX servers.
  • Provide MicroFocus COBOL and UNIX programming support.

Confidential, Philadelphia, PA

Manager of Systems and Programming

Responsibilities:

  • Manage all aspects of production programming and design for Auto Club Membership, Sales, and Emergency Dispatching Systems.

Hire Now