Oracle Sql Server

GRANT SCEARCE

Fort Worth, TX *****

(Phone) 817-***-****

Email: *************@*******.***

IT PROFESSIONAL

I have over 20 years experience in the IT industry. I have experience in a Jr Oracle DBA role. I am experienced in SQL development, report creation, triggers, schema and business stored procedure development. I have worked as a Developer/Consultant building Web and stand alone applications. As a Discoverer Admin I managed all BI reporting needs for international and domestic corporations. Most recently participated in project to convert Discoverer corporate reports to IMB Cognos standard reports.

CORE COMPETENCIES

Certifications:

10g Certified Oracle Associate /10g Certified Oracle Professional DBA

Linux+ Certified Professional /Sun Certified Java Programmer

Microsoft Certified Technology Specialist (VB.Net Web-Based and C# Windows-Based Dev.)

Oracle Discoverer,IBM Cognos Report Analytics, SQL*Plus,SQL Developer

Toad,MS Visual Studio

MS Excel, MS Access, SQL Server

SQL,PL/SQL

C\C++,Visual Basic (ver 6/.Net)\ VB Script\VBA

HTML, ASP

Systems Life Cycle (SLC/SDLC)

PROFESSIONAL HISTORY

GM FINANCIAL, Arlington, TX 03/2015 – 10/2017

Oracle Technical Analyst II

Primary corporate Oracle Discoverer developer/administrator for HR, Payroll, Benefits, Compensation, Learning Management, Recruiting and Leadership Development reporting groups. Supported Discoverer portion of database upgrade from Oracle 11i to Oracle R12. Work with consultant team in Discoverer Replacement Project to ensure existing business reports are accurately reproduced in the replacement reporting tool, IBM Cognos.

ARGO DATA, Irving, TX 09/2014 – 3/2015

Entry Level Programmer

Support new development of a multi tiered Banking Work Flow Management product. Development is in a proprietary language developed by Argo and a verity of web base languages (Html, Java Script, ASP, Xml, SQL, etc).

NAUTILUS HYOSUNG AMERICA, Irving, TX 08/2013 – 06/2014

Oracle Database Administrator

Supported Oracle 11g Database custom Service Center Management module, Inventory, Time and Materials, and Billing modules for nation's second largest supplier of ATMs. Created Schemas, triggers, stored procedures, managed user access, and backed up key tables as needed. Documented and executed request for manual data updates, data cleansing and bulk data imports.

Achievements:

Developed PL/SQL report scheduling process to create and distribute multiple reports per user needs reducing Service Center Agent group processing time by eight hours per day .

Created process for Extracting/Loading data from multiple spreadsheets into custom Oracle scheduling tables saving billing analyst six hour per upload.

Added audit reporting to Service Tech scheduling tables to improve billing accuracy.

AVIZION TECHNOLOGIES GROUP, Dallas, TX 06/2012– 04/2013

Contract Programmer

Lead development team in software/database upgrade of financial and point of sale applications for multi-regional plumbing/Air Conditioning supplier.

Achievements:

Development team Updated over 200 programs and 120 DB tables in nine month with only 12 issues report after Go-Live.

GENBAND, Plano, TX 12/2010– 05/2012

Sr Corporate Analyst

Oracle Discoverer Admin/SME (Subject Matter Expert) for international networking hardware/software supplier. Responsible for corporate report creation, EUL maintenance (backups, customizations and tuning), change control documentation, and user training in ad-hoc report creation. Secondary role of OBIEE Administrator Backup. Assisted in physical layer maintenance, report/dashboard development.

Achievements:

Replaced user intensive reporting processes by developing corporate level reports for AP, AR, Inventory, Order Management, GL, Sales, Projects and PO department leadership.

Created and tuned SQL (PL/SQL functions) reducing report processing time by as much as 90%.

Lead upgrade project to migrate Discoverer EUL and corporate reports into OBIEE.

DATA DELIVERY SERVICES, Plano, TX 04/2010– 12/2010

Transaction Processing

Monitored data file processing on multiple SQL Server database instances, processed user request and administer in-house software configuration settings for nation's second largest credit card processor.

Achievements:

Assisted DBA with T-SQL scripting projects.

ELECTRONIC DATA SYSTEMS, Plano, TX 07/2001–01/2008

Information Analyst, Oracle ERP Production Support

Primary role of Oracle Discoverer Admin/SME and Noetix Admin for the EDS 7-Eleven North American Corporate account. Maintained both seeded and custom production EULs (End User Layers) replicated across three to six Oracle instances. Created Discoverer reports used for business groups including HR, Payroll, AP, ADI, FA, GL, PC and PO. Created and tune source folder SQL and PL/SQL for EUL custom folders.

Secondary role of Applications Administrator for Oracle EBS rel. 11.5.8 to 11.5.10 included creating custom responsibilities, PL/SQL functions, granting user access and creating custom SQL scripts.Achievements: Managed 3 major Oracle upgrades (8i, 9i, 10g) to the Discoverer component including pre-upgrade testing, configuration tuning, creating upgrade scripts and implementing upgrades in all existing Oracle instances.

Coded the installation packages that automated the Oracle client upgrades to over 1000 network PCs in both Canada and the US.

Created training material and presented user training for ad-hoc reporting in Discoverer.

Developed billable hours tracking system for the level two production support team.

Supported code written in C, Visual Basic (ver 6/.Net), ASP and VB Script/VBA on Unix and Windows platforms.

INDEPENDENT CONSULTANT, Irving, TX 02/1999– 04/2001

Born Information Services/Smart Source

Consultant/Web Developer Supported code written in C/C++, Visual Basic 6, Java script, ASP, and VB Script. Developed web applications using n-tier architecture supported by Microsoft Transaction Server to manage COM+ objects, retrieve and Marshal data. Developed separate business objects and data objects to support data source switching (DB2, SQL Server 7).

Achievements:

Built COM objects used in ASP web pages to support rail routing call center apps for rail shipper.

Developed web applications using n-tier architecture for national jeweler's online catalog.

Contact this candidate