We provide IT Staff Augmentation Services!

Data Modeler Resume

Columbia, SC

TECHNICAL SKILLS

Operating Systems: LINUX, UNIX (Sun, Solaris, AIX, HPUX), Windows 95/98/NT4/XP/2000

ERP: SCT BANNER CIS / Ventyx Customer Suite 2.2.1 - 4.2 (15 years, last used 2009)

Databases & Servers: ORACLE 7, 8i, 9i, 10g, 11g (15 years, last used 2013)

Development Tools: TOAD, SQL Developer, Oracle Forms Developer 9i, 10g; Oracle Reports Builder 10g;Oracle Forms 5.0, 6.0, 6i; SQL*Plus; Toad; PL/SQL Developer; FTP; PVCS, Pro*COBOL, UNIX shell script, Java, Java Script

Programming Languages: C, Pro*C, SQL, PL/SQL, Oracle Forms 6i, COBOL

Job Scheduling: UC4 Application Manager (formerly Appworx)

Office Tools: Microsoft Office; Open Office

Special Skills: Oracle database and application performance analysis and tuning, debugging and problem resolution, requirements gathering, public speaking, good communication skills

PROFESSIONAL EXPERIENCE

Confidential, Columbia, SC

Data Modeler

Responsibilities:

  • Ellucian Banner to ODS data transofrmations.
  • Evaluate report designs then build and schedule data ETL
  • Support for University of South Carolina reporting for all campus locations
  • Build and scheduled UC4 jobs and process flows
  • Submit request documentation for report promotions to higher environments
  • Wrote documentation for every object developed and deployed
  • Convert MS SQL Server T - SQL to Oracle PL/SQL
  • Wrote report to recommend workflow enhancements
  • SQL*Loader control files
  • Nightly load monitoring and error corrections

Confidential, Charlotte, NC

Data Modeler

Responsibilities:

  • Designing data models for national retail bank.
  • ERWin data models
  • SQL Developer data models
  • Write SQL queries and PL/SQL scripts
  • Catalog and document current data warehouse
  • Assist in design of underlying architecture to facilitate reports

Confidential, Greenville, SC

Data Modeler

Responsibilities:

  • Designing data models for grocery store retailing reports.
  • Database was on an Exadata box and one on Superdome box
  • ERWin data models
  • SQL Developer data models
  • Write SQL queries and PL/SQL scripts
  • Catalog and document current data warehouse
  • Assist in design of underlying architecture to facilitate reports

Confidential

Data Modeler and Oracle DBA

Responsibilities:

  • Designing data models for a replacement MMIS system for the State of South Carolina to replace antiquated mainframe system.
  • Designed data models for EDI 837 I, 837P, and 834 transactions
  • Planned, designed, and developed PL/SQL package procedures for MULE ESB interfaces
  • Assisted with system architecture
  • Building tablespaces and implemented data redaction policies
  • Presentations to upper management
  • Managed Oracle databases.
  • Install and configure Oracle EDQ.
  • Managed Red Hat/Oracle Linux 6.x virtual servers.
  • Responsible for hiring decisions for personnel related to database work.
  • Writing XLC documentation for reporting to CMS.
  • Some work with NoSQL databases (MongoDB and MarkLogic)

Hire Now