Post Job Free

Resume

Sign in

Oracle Manager

Location:
Park Forest, IL
Posted:
June 02, 2014

Contact this candidate

Resume:

ANTHONY JACKSON

SUMMARY:

Anthony Jackson is an information technology professional who not only

possesses a high degree of technical expertise, but also has a unique

blend of interpersonal, communication and presentation skills that

make him a valued asset to any organization. He has the ability and

experience to perform tasks ranging from feasibility and planning to

testing and implementation both from a developer's and analyst's

perspective.

Hands-on Programming Expertise

ASP.NET, VB.NET, C#,PL/SQL, Java, Oracle Application Express, CSS,

SQL, DDL, DML, T-SQL, VBA, Java, JavaScript, J2EE, HTML, HTML 5, ASP,

JSP, JSF, ADF, SAS, C, Pro-C, C++, Object C, Shell Script, PHP, Perl.

VBA, Visual Basic 6.0, SPSS, Fortran, XSLT, XML, Prolog, WML, Flash

MX, Flex, C#, Stored Procedures, Database Triggers, JDBC, ODBC, EJB,

Java Beans, Java Servlets, UML, COM+, Active x, DCE Security Service,

SSH, SSL/TLS, LDAP, ETL, UNIX, Linux, MVS, Windows, AIX, CICS, Sun

Solaris, RT-11, CPM, RSTS-11, VAX VMS

Enterprise Systems Proficiency

Oracle RDMS 8e, 9i, 10g, 11g, 12c, RAC, ASM, RMAN, Oracle Enterprise

Manager 10g Grid Control, Oracle Application Server 10g, Oracle E-

Business Application Suite R12, Oracle Portal, APEX, Oracle

Applications, Oracle Developer 2000, Oracle Forms and Reports. Oracle

Portal 10g, IBM Web Sphere portal, IBM DB2, UDB, IBM LDAP severs, IBM

Tivoli Identity Manager, ITDI, Microsoft SQL Servers 2000/2005, MS

DTS/SSIS

Professional Experiences:

11/13 - Present Northern Trust Bank

Sr. Oracle DBA - Performances Advocate

. Developed and Reviewed Oracle Performance best practices for all

of the 130 development teams.

o Reviewed statistics influence the optimizer, best way to

gather statistics, timing of when to gather statistics,

differences in 10g and 11g.

o Detriment root cause of Oracle database performance issues

considerations include Oracle wait events, SQL plan

changes, blocking, I/O, network bandwidth, etc.

o Documented anticipated performance issues given projected

system growth, variations of data load, user volume, etc.

o Installed Custom developed performances tools on all NT

Oracle Databases (~400)

o Recommend, Coordinate and Implement database configuration

changes to improve performance.

o Developed, debugging and tuning complex SQL and understands

the best ways to incorporate database requests into

application programs.

o AWR (Automatic Workload Repository) to determine system

level performance issues such as buffer busy, latches and

enqueues, cluster related findings, I/O related findings.

o - ADDM (Automatic Database Diagnostic Monitor) to see the

Top SQL which are causing performance issues, along with

the ability to make suggestions for improvements

o ASH (Active Session History) to help determine 'Transient

performance related issues'.

. Designed and Developed NT DBA Tools a proto-type Apex web site

to manage NT Databases.

o System Function are:

. Execute DML/DDL and SQL on Oracle, Sysbase, and MS

server database.

. Maintain metadata on databases and their development

life cycle.

. Replace existing link kshell menu system.

. Provide advance reporting.

. Run Kshell script for web site.

08/12 - 11/13 Dell Consulting

Sr. Oracle Consultant

. Design and implement Oracle Apex system using SOA, JavaScript,

HTML 5, and CSS.

o Developed Customer Service and Sale APEX Website for the

Affordable Care Act with REST SOA, Oracle Application

Framework (OAF), and BPEL

o Interfaced Oracle APEX XRM system to Oracle E-Business.

o Developed Stored Procedures with XMLDB to interface Web

Services to database tables

o Developed automatic test scripts for QA team.

. Mentor developers and delivered training in APEX development,

PL/SQL, Oracle SOA and OAF.

o APEX Web Services

o XMLDB, XML, XSLT

o OAF

. Work with offshore development teams in Bug fixes and support of

Oracle systems.

. Led code reviews and design sessions for Oracle system

development.

o Weekly meeting with Offshore development Teams

o Approved code changes for UAT and Production systems

. 24/7 Technical support manager for one week of each month.

o Troubleshooting/problem-solving for user problems

o Led Fire Call team of DBAs, Network Techs, and developers

o Developed Root cause analyses

o Document Support active

O2/12 - 08/12 CBOE

Sr. Software Engineer

. Gather requirements from regulatory user for options trading

surveillances.

. Wrote requirement, as-build, test plan and operation documents

for Pre-Arranged Trade and Dual Representation surveillances

systems

. Designed and developed batch PL/SQL process for both Pre-

Arranged Trades and Dual Representation surveillances, reducing

the time from 3 hours to 3 min.

. Designed and developed enhancements to J2EE surveillance web

site with Springs, JQuery and AJAX.

. Implemented Pre-Arranged Trades and Dual Representation

surveillances into product system.

Technical Environment: UNIX, LINX, Oracle RDMS, CSS, HTML 5, WEB 2.0,

JavaScript, J2EE/Java, XML, Struts, Springs, JQuery, and Oracle 11g RDMS

01/12 to Present Day Spring LLC.

Part Time Architect and Development Consultant

. Designed and developed AWS Cloud scheduling and inventory

system.

. Developed Safari, IPHONE and IPAD apps user interface to the

scheduling and inventory system with JavaScript, HTML 5 and CSS3

apple web kit tools.

. Implemented 2D and 3D transforms for IPHONE and IPAD

. Designed and coded system with ASP.Net, C# and Oracle PL/SQL

. Developed Database design and stored procedures.

. Implemented HTML5 offline Storage for personal schedules.

Technical Environment: Oracle 11g, CSS, HTML 5, WEB 2.0, C#, Microsoft

Visual Studio 2005, JavaScript, Dojo, XML, GWT, and Oracle 11g RDMS

6/09 to 02/12 Argonne National Laboratory

Sr. Software developer / DBA

. Designed and developed online systems for analyzing the security

and resilience of U.S. critical infrastructure and key resources

that are threatened with disruption from natural hazards,

accidents, or deliberate acts such as terrorist attacks.

. Responsible for leading a group of technical resources from

design phase to the completion of several large, multi- customer

implementations

. Designed and developed an inventory management system for PSA

with Oracle apex, JavaScript, Dojo framework, and PL/SQL

. Enhanced PSA Tracker system for DHS, increased response time and

report accuracy by incorporating Oracle Text and Data base

turning.

. Developed report generator integrated into Oracle Apex based on

MS Word 2003 XML formatting, which allows user friendly creation

of ad hoc reports.

. GIS tracking of PSA based on data mind techniques operating on

MS Outlook files and Oracle Apex. Indentify PSA and act ivies on

world map created with ArcGIS and JavaScript.

. Developed online dashboard for security and resilience index

with AnyCharts, HTML 5, WEB 2.0 and Oracle Apex.

. Developed PL/SQL engine to generate charts and graphs based on

SQL statements stored in Oracle tables.

. Designed and developed PL/SQL packages to analyze survey

questions to calculate comparative indexes useful to DHS and

Business Owners

. Developed convention plans for 10g databases to 11g.

. Migrated 20 10g Databases to Oracle 11g.

Technical Environment: Oracle Apex, CSS, HTML 5, WEB 2.0, VB.Net, asp.Net,

ArcGIS, Arc Objectives, JavaScript, Oracle ADF, Dojo, J2EE/Java, XML, GWT,

Flex and Oracle 11g RDMS

3/09 - 6/09 Metropolitan Water Reclamation

Sr. Developer / Architect and DBA

. GIS web site for tracking flood plains programmed with

VB.Net, asp. Net, ArcGIS, Arc Objectives, JavaScript, Oracle

ADF, and Oracle 11g RDMS

11/08 - 3/09 Williams Insurance Inc

Sr. Developer / Architect and DBA

. Web based customer relationship system developed with oracle

Apex, Oracle 11g RDMS, XML, HTLM, PL/SQL, and JavaScript.

. Develop Oracle 11g database for customer information on AWS

Cloud

. Develop stored procedures to calculate insurance cost, P/L

and payment plans.

. Developed documentations and ERD

. Translate VB 6 system to Oracle Apex

. Develop direct mail system in Oracle Apex.

Technical Environment: Oracle Apex, VB 6,, JavaScript,, XML, Flex and

Oracle 11g RDMS, AWS

11/06 to 11/08 Zurich American Insurance

Sr. Developer / Architect

IRAM Project manager and System Administrator

. Responsible for leading a group of technical resources from

design phase to the completion of large,

Multi-divisional customer implementation with agile and

continuous integration

. Managed the burn in period of Zurich's IRAM system - Account

management for over 60,000 users

. Developed User Documentation and Trained users

. Developed and implemented new system functions

. Develop function specifications for IRAM integration with

other system, (FCT, ZSPIRE, and RETRO)

. Managed system outage team while solving major system

problems

. Lead business partner meetings

. Reported to upper management

. Trained offshore support team

. Reduce system outages from 60% to 00.9%

Technical Environment: MVS, Linux, UNIX, Window XP, VB, VBA, Java,

JavaScript, Flash, Flex, XML, Web Services, J2EE, PHP, PL/SQL, T-SQL, JDBC,

ODBC, IBM DB2, Stripes, Struts, Spring

10/05 to Creative Automation

11/06 Business Intelligent Architect and Developer (Full Time)

. Design and developed Direct Mail Data Warehouse systems for

BMG and Yahoo small business with Oracle Apex and Oracle 10g.

. Managed a team of 5 DBA and 3 developers

. Installed Oracle 10g and related tools, developed backup

system, Database Administration plans and procedures

. Administrated oracle 9i, 8e and Microsoft SQL Server 2000,

2005, 2008

. Installed and trained staff in Business Objects XI R2

. Create direct mail marketing systems and Business information

Dashboards for BMG and Yahoo

. Developed new Business Intelligent products for CA customers

. Installed and administrated Oracle application Server 10g

. Developed Oracle portal 10g applications

. Converted Oracle forms and reports to J2EE applications on

Oracle application server

. Developed XML ETL system for RDMS

. Implemented a J2EE based financial accounting system for

Oracle Application server 10g and Oracle

Technical Environment: Oracle 10g 11g Oracle Apex MVS, Linux, UNIX, Windows

Java, JavaScript, Flash, Flex, XML, Web Services, J2EE, PHP, PL/SQL, T-SQL,

JDBC, ODBC, IBM DB2, Stripes, Struts, Spring, Oracle Application server 10g

4/05 to 10/05 MasterCard

Senior Computer Scientist (Business Intelligent systems)

. Designed and developed a Marketing Analysis System and Data

Warehouse, backend build on Oracle 10g, OLAP, BI, SAS and

Linux. The User Interface consisting of web base Flash MX,

Html, XML, and web services.

. Installed Oracle 10g and related tools, developed backup

system, Database Administration plans and procedures

. Design and developed marketing analytic reporting tools with

BI beans, Data warehouse Builder, and Oracle Discoverer.

. Engineered Data Cubes based on Oracle rollup and cube

technologies for TV, Radio, and Print marketing data

. Constructed MasterCard Marketing Data warehouse

. Installed Oracle 10g and related tools, developed backup

system and Database Administration plans and procedures.

. Design and developed marketing analytic reporting tools with

BI beans, Data warehouse Builder, and Oracle Discoverer.

. Used Warehouse builder and Data Stage to developed ETL system

based on advance multilayer business rules of the credit card

industry.

Technical Environment: MVS, Linux, UNIX, Window XP, VB, VBA, Java,

JavaScript, Flash, XML, Web Services, J2EE, PHP, PL/SQL, T-SQL, JDBC, ODBC,

IBM DB2, Stripes, Struts, Spring

3/05 to IRI International

4/05 Principal Consultant

. For IRI International, develop a marketing Data Dictionary

based on installed Oracle web portal 10g.

. Design and implemented ETL solution for Data Dictionary and

Data Warehouse, PL/SQL and Java, loading data from mainframe

COBOL files to Oracle Portal 10g

. Software and Operating systems; Window 2003 AS, Linux, Java,

JavaScript, MVS, COBOL, PL/SQL, HTML

Technical Environment: Oracle Portal 10g, Oracle 9i, OID, Oracle 10g AS,

Window 2003 AS, MVS, Java, JSP, JavaScript, Window Script

11/04 to Oracle Corporation

3/05 Applications Development Consultant - Project Leader

. For Tribune newspapers, design and developed intranet Web

application for the scheduling, tracking, sharing, and

editing of news stories, websites, and multimedia content.

. Installed and configured Oracle 10g Portal, Applications

Server, LDAP, Oracle ODS

. Trained staff in Oracle Portal 10g development and

maintenance, PL/SQL, Erwin, Jdeveloper, EM, OID, LDAP

. Engineered ETL and data conversion system to transfer legacy

data from mainframe to relation database using Ab Initio and

Oracle data pump.

. Developed custom editing system with stored procedures,

PL/SQL, JAVA, JavaScript, JSP and HTML

. Linked real time multimedia storage with Web Portal and

custom editing tools

. Engineered Wireless Portal with WML, XSLT, and Java AWT

Technical Environment: Sun OS, Java, JavaScript, PL/SQL, Stored

Procedures, Oracle Portal 10g, Oracle AS 10g, OID, LDAP, Oracle 9i, Dream

Waver, MS Visual Developer, shell script, SQL, WML, XSLAT, Html

2/04 to City of Chicago CHA

11/04 Principal Consultant - Project Leader

. Directed team of developers, engineers, and QA testers

. Designed and developed Call center information and support

system. SQL server 2004, Java, JDBC, AWT, C++, C#, .NET,

NetBeans

. Documented complicated business rules for managing housing

and customer request.

. Develop database design and ER Diagram

. Produced function specifications from user requirements using

UML standards.

. Wrote acceptance test plan and development project plan

. Developed user interface to SQL server (GUI) with Java Swing

and AWT

. Coded Business rules to transform legacy data to new system

used custom ETL written in micro COBOL and T-SQL

. Engineered Backup and Database procedures. Installed SQL

server 2000. Managed Development team

Technical Environment: Window 2003 AS, SQL Server 2000, Stored Procedures,

JDBC, JAVA, AWT, Swing, TCP/IP, ERWIN, NetBeans

2000 to A.C. Nielsen

2004 Product Development Engineer - (Full Time)

. Responsible for the design, development, coding and testing

of application systems based on Oracle Database, SAS and

related technologies, Including Application server, EJB, and

J2EE technologies.

. Including hands on design and coding of the following

systems:

. Marking Mix analysis modeling system. Sales analysis system

based on EJB web services with wireless phone interface,

Media analysis system, Product sales and Media information

data warehouses with Oracle database and Oracle Portal

technologies. Work flow and automatic analytical reporting

system based on Oracle AS and Oracle database technologies.

OLAP reporting web services.

. Provided programming team technical and functional leadership

and technical direction

Technical Environment: Window 2003 AS, SQL Server 2000, Stored Procedures,

JDBC, JAVA, AWT, Swing, TCP/IP, ERWIN, NetBeans, Linux, Unix, VBA, VB 6.0,

.Net, Warehouse Builder, Data Stage, Oracle 8e,/9i/10g, Oracle 11i, Tomcat,

JBoss, Java, J2EE, EJB, Shell Script

1985 to National Technologies Unlimited Inc

2000 Principal Consultant / Managing Partner

. Responsible for sales and providing consulting services to

fortune 500 companies, serving as the Principal consultant to

client base for System Development and Implementation,

Project Management, Data Base Design and Management, Data

modeling and Data warehousing, Performance tuning, E -

Commerce design and development, Oracle Training and

development. Anthony Jackson through NTU INC performed all

of the following consulting assignments.

. Managed Consultant force of up to 20.

Other Consulting Assignments

Principal Consultant

. Motorola Inc. - Worldwide educational reservation and

scheduling system

. Annie Lee and Friends Inc - Web based POS and management

system

. Tap Pharmaceuticals Inc - Designed Developed and Implemented

TapMed

. SCR Medical Transportation, Inc. - System Analysis, AR and

Fleet Management design and development

. Christ Hospitals, Humana Inc. - Designed and developed

. Emergency Room management system

. Network MCI - Design and developed conferring reservation

. Johnson Controls - Principal DBA and Project leader

. Ameritech Chicago - Principal DBA and Project leader

. C.N.A. Insurance - Visual basic and Sybase development

. Leo Burnett - Power Builder, Sybase, DB2 development/ lead

DBA

. Abbott Labs - Oracle, Sybase, PL/SQL development and

training, Oracle reports and Forms

. G.D. Searle - Sybase, SQL development and DBA training

. NCR Corporation - Sybase, Data base design, GUI interface

development

. Unocal - Sybase, C/C++ development

. Abbott Labs - AIX, IBM RISC 6000 testing and support

. Cook Country Recorder of Deeds - Strategic planning

. IBM Software - mainframe to Unix conversion

. Sherwin Williams - Laboratory Automation and Data base design

. U.S. Robotics - LAN system design

. Datalogics - C development for SGML - development manager

EDUCATION:

MS Computer Science

Governor State University

. Course work completed in 2005 with 4.0/4.0 GPA

. Master Project "The formalized languages of the DNA"

. Publications in Computer Science

. International Presentations in Computer Science

Graduate Studies in Computer Science

. Studies in Bioinformatics DePaul University

. Studies in Machine Intelligence Toyota Technological Institute

at Chicago

PHD Studies in Physics

University of Illinois

. Completed two years of course work with no degree

. Teacher Assistant Physics

. Research Assistant Physics

BS in Physics

Eastern Illinois University

. Student Tudor

. Research Assistant



Contact this candidate