Dba Resume
Virginia, UsA
Summary of Qualifications:
Thirteen year’s experience as database administrator where I translated business requirements into analytic constraints. My background includes improving business processes using technology in multiple industries. Strong in organizing, analyzing, planning, designing, and programming capabilities. Able to grasp off-the-shelf software quickly. Team player with a positive attitude and demonstrated ability to work both independently and collaboratively in an environment of constantly changing priorities.
Technical Expertise:
- Oracle EBS R12 Financials Certified Expert Consultant, Payables
- Database Administrator for 13 years
- Webmaster for 11 years
- Proficiency in Microsoft Access, Excel, Word, PowerPoint, Outlook
- Bachelor’s Degree in Information Systems
ENTERPRISE
RESOURCE
PLANNING:
Oracle Applications 12 General Ledger, Oracle Purchasing, Accounts Payable, Accounts Receivable, Fixed Assets, Inventory, Order Management, Oracle Alerts, Budgeting, Procurement, ADI, Security, Forms, Reports, Application Object Library and System Administration; PeopleSoft
SERVERS:
Windows 95/98/2000/NT
DATABASES:
Oracle EBS R12 Financials applications, standard reports, concurrent requests and basic Database queries; MS Access
LANGUAGES:
SQL, Java, JavaScript, Java Applets, VB, VBScript, C++, COBOL, HTML, CSS, XHTML, Telnet, HTTP
WORKFLOW TOOLS:
MS-Office
PLATFORM:
Windows (2000, NT)
DESKTOP PRODUCTS:
MS-Office (Access, Word, Excel, PowerPoint), Outlook Express, Crystal ReportWriter, Dreamweaver, Photoshop, Illustrator, InDesign, Adobe Acrobat
METHODOLOGIES:
Application Implementation Methodology (AIM 3.0), SDLC
Professional Highlights:
- Technical and functional work experience in Oracle 12 Financials including troubleshooting;
- Experienced in set-up and customization of Oracle ERP Application modules including GL, A/R, A/P, FA, BOM, Inventory, OM, Purchasing, and CRM;
- Defined, customized, and set-up Flexfields, Oracle alerts, Oracle workflows, Currency type and Conversion Rate, ad hoc Reports
- Created Legal Entities, Operating Units;
- Created Procurement Set-up including Inventory Organizations and Parameters, Purchasing and Receiving Options, and Accounts Payable, Receivable, Purchasing, Order Management, and Manufacturing Setups including freight and taxes;
- Normalized Oracle database;
- Worked on creating views in Oracle for Crystal Reportwriter reports and generated and trained others on creating ad hoc reports;
- Updated and maintained HR database;
- Installed ethernet network for local non-profit organization.
Web
- Software: Dreamweaver, Photoshop, Illustrator
- Created website with sound, animation, security and database functionality for a local non-profit;
- Created slideshow to market local author’s book;
- Created customized images using Photoshop and Illustrator for local non-profit, researched, modified, and created graphics for web deployment;
- Created value sets and loaded same;
- Created rotating banners, rollovers, popups, interactive forms, and indicies;
- Established database connectivity for interactive forms and set up security;
- Used HTML, CSS, metadata, sound, hyperlinks, frames, tables, drag and drop;
- Proofread submissions for grammar, spelling, and flow of content prior to web deployment.
Education:
- Bachelor’s Degree in Information Systems
- Associate’s Degree in Network Support
Work Experience:
Confidential, Glen Allen, Virginia, U.S.A.
Confidential, Jan. 1993 - Aug. 2008
Claims Assistant, Database Administrator, and Webmaster
INFORMATION SYSTEMS
- Interacted with End Users, Program Managers, Developers, and Executive Level Management in sessions for Requirements Gathering in migration from two disparate legacy systems to Oracle EBS using web-based project tracking software; Worked with team in designing new system new system to meet business requirements, performed quality audits, testing, and managed company-wide training;
- Performed QA, testing, troubleshooting, and resolution of applications’ technical and functional issues;
- Performed full and incremental periodic data backups;
DATABASE
- Experienced in supporting the development and implementation of large scale, complex, commercial off-the-shelf software systems;
- Experienced in identifying data points, mapping data and data integration;
- Designed, created, and maintained combined caseload and administrative tracking system, corporate litigation financial tracking using GAAP, new claims log with automated reporting capabilities and trained others on its use;
- Produced periodic and ad hoc queries and reports in Oracle, Access and Crystal ReportWriter;
- Provided periodic maintenance of database and monitored security;
- Customized user input screens with various graphics to enhance security
- Analyzed business and reporting requirements, mapped information from disparate systems into one comprehensive database;
- Worked with open and close periods and workflow approval process in PeopleSoft; conducted research, troubleshooting, and resolution of manual payments issues;
- Modified database for Y2K compliance;
- Able to function as a hands-on technical resource as needed.
WEBMASTER
- Designed and managed website layout and functionality using HTML and CSS, color and fonts for emphasis, established cross references using hyperlinks;
- Responsible for maintenance of website, removing dated materials, and providing updates where applicable.
- Drafted educational case summaries for internal Legal Department accessible by executive management and departmental staff nationwide; Drafted policies and procedures “Claims Bulletins” and “Retained Counsel” brochure for online deployment.
TRAINING
- Trained new users and existing staff on producing Oracle based forms and reports;
- Performed quality assurance and audits;
- Developed proprietary training materials, online training program, assessments and remediation;
- Provided training to users on day-to-day business activities, software updates, enhancing and developing custom reports, and assisted in production issues;
- Automated timesheet functionality for tracking hours worked, breaks, lunch and overtime.