DBA/Technology Resume

Vicky Carlton

SUMMARY:

Strong background in systems development, business analysis, project management, research and development.  Extensive experience with database management systems, data warehousing and internet application support.  Able to understand business requirements and identify the most appropriate technologies. Excellent communication and people skills.  Possess an excellent understanding of the business systems, programming languages, utilities, and technical infrastructure.

EDUCATION:

University of Cincinnati, general courses

Cincinnati State, Associate of Applied Business

 

TECHNICAL SKILLS:

System Design and Development:  
Analysis, Design, Development, Maintenance, Testing, Documentation, Implementation and User Training, Technical Project Leader, Project management

Operating Systems:                    
UNIX, Windows 2003/2000/98/95/ XP, IBM Mainframe

Data Bases:                                                       
ORACLE 7.x/8.x/9i, 10g, MS-Access, SQL Server  2000

Data Base Utilities:                                          
SQL Plus, ODBC, Toad, Quest Central for Oracle, Sql Developer

Data Warehouse Tools:                                   
Business Objects Supervisor/Designer, Reporting and Web Intelligence              

Reporting Tools:                                                
Crystal Reports, Word, Excel, Access, MS Project

Languages:       
SQL, PL*SQL, COBOL, CICS, PowerBuilder

 
PROFESSIONAL EXPERIENCE:

Consulting Company               May 07-till Mar 09 

Senior Consultant/DBA

Contracted to Ethicon Endo(Current)-Surgery  providing DA/DBA support for Oracle 9i and 10g databases to support Order to Case, Enterprise Data Warehouse and Siebel applications.

Contracted to General Electric (1 year)– Aviation to work on Military Projects involving Oracle Database and java applications. Install Oracle 9i and 10g Enterprise Edition on Windows Servers and on laptops for developers. Used Erwin for modeling database schema’s. Install database applications from partners on windows platforms.

Responsibilities:

  • Oracle Databases on servers and workstations, software installs, connectivity.
  • Supporting Developers
  • Work with users/developers to design portion of database needed for specific application.

Insurance & Investments Cincinnati, OH             
Nov 87-till Jan 06

Technical Support//Database Administrator   1997 – 2006

 Database Management Lead for overall database technology and architecture. This included hardware/software evaluation, selection, installation, implementation and application design as it related to database and database tools. Technical lead on Data Warehouse tools selection and implementation. Experienced in specifying and analyzing terms of statement of work (SOW) documents for consulting contracts and provided leadership in the selection of consultants. Responsible for ensuring compliance with software licensing. Responsible for defining, implementing, and enforcing best practices, standards, project  management  and change management procedures for databases. Reviewed and recommended Oracle training courses for IT staff.

Technical Lead in the selection and implementation of the Data Warehouse and Performance Data Mart. Tasks included requirements definition, evaluation and selection of products. Designed and implemented the ETL process.  Responsible for the creation, initialization and maintenance of the oracle data warehouse and data marts. Analyzed database structures and queries for performance improvements.  Made recommendations, implemented, and measured performance improvements. Implemented development tools to allow integration of mainframe COBOL application systems to oracle databases on NT.

Provided Technical project management, development and production support for applications such as iLytics OFAC compliance, database monitoring tools, Data Marts, Data warehouse, Business Objects, Client Service System, Client Information System, imaging, file tracking, agent location system, Internet security, messaging middleware (MQ Series), Contact Relationship Management (CRM), Payroll/Human resources,  Web infrastructure, and voice response.  Coordinated and schedule technical resources, liaison to user community. Performed performance tuning on internet applications and made recommendations.

Technical Support/Systems Specialist  Research and Development                                     1989-1997

Researched purchased, intergraded and implemented new technology, software applications, tools and products.  Prepared cost benefit analysis, negotiated contracts, provided training, developed standards and made recommendations for application design.  Introduced and supported products such as Rumba, Power Builder, Micro Focus Cobol, File-Aid, Panapt, Sybase, Oracle, Document Management Software.

Responsible for supporting the languages, utilities, tools used by the development staff to develop, support, and integrate business applications and databases.  These included SQL Developer, ERWIN, Power Builder, MicroFocus Cobol.

Experienced in the selection, implementation and support of business applications on the mainframe, desktop, Novell,  NT and Unix servers.

Senior Systems Analyst -  Payroll/Human Resources 1987-1989

Responsible for the multiple migration/implementations of Payroll/Human resources systems as result of acquisitions software/technology upgrades.

 Responsibilities:

  • Technical Lead/project management
  • Evaluation, selection, installation, implementation hardware/software solutions
  • Participated in development of logical data model and provided guidance to data administrators in use of Erwin tools.
  • Developed physical data models using Erwin.
  • Scheduling of technical resources
  • Monitors and tunes database and internet applications utilizing scripts and Quest Central for Oracle.
  • Performed oracle database/application upgrades and applies patches as required
  • Defined and maintains disaster recovery plans and performs offsite tests for applications and databases
  • Responsible for the creation, initialization and maintenance of the oracle data structures.
  • Wrote stored procedures, triggers, and SQL loader utility scripts for many applications
  • Provided backup support for SQL Server.  Integrated database customizations into vendor software.
  • Performed UNIX system administration responsibilities for 6 months while filling the position.

 Continuing Education/Interest

Internet application Development (PHP/HTML/XHTML/XML/AJAX//JAVA) Cascading Style Sheet (CSS)

Search Engine Optimization

Marketing campaigns (PPC/CPM)

Email Marketing

Collaboration/Social Networking/Sharepoint

RSS Feeds/Webbots/Crawlers

MYSQL

Google Analytics

Photography/Video/Podcasting/Videocasting

Wordpress

SurgarCRM

Cloud computing