frank nwadike

QUALIFICATIONS PROFILE

Oracle IT / Accounting professional with proven success in driving revenue and profitability in technical/functional environments. Experienced in operations; technical, analytical project planning, negotiations, team building, training, systems management, report building, account maintenance, administrative support, and financial management through data analysis and account reconciliation. Background in IT integration, RDBMS: Oracle 9i, 10g and 11g, 12c Databases: Red-hat Linux5.8, 6.5,7.2 Linux/Unix, Windows 2003 Server, Database Administration: Backup & Recovery, Data Guard, RAC, Data modeling, Oracle Tools & Utilities: RMAN, Export/Import, SQL*Loader, STATSPACK, SQL Trace, SQL, Explain Plan, SQL Server 2008, 2012, 2014, JDeveloper, Remedy ticketing system, RMAN, OEM, OIM, OAM, STATSPACK, AWR, and ADDM.

Roles /Areas of Expertise:

ASM, OIM, OAM, UNIX, Sun Solaris 10, HP-UX 11 (64 bit), IBM AIX 5.0, Enterprise Linux 6.5. Business, Technical, Infrastructural and Management Acumen

Systems / Technologies:

SQL Server 2014, IBM Rational Architecture, MS Office (Access, Excel, PowerPoint & Word), SQL Server 2014 Data Quality Client, Structured query language (SQL), Oracle PL/SQL, Visual Basic.Net (2005/08), Excellent knowledge of RDBMS/Oracle, Java, RedHat, UML, MS SQL Server Database Administration, Oracle, Eclipse, Applied Systems EPIC & TAM, Applied Systems EPIC & TAM, Project Management, IBM Systems and compatible operating system-Linux, Hogan, Internet Explorer, Netscape Explorer, Oracle Virtualbox, HTML

Education / Specialized Training:

Knowledge:

SKILLS TRAINING SOFTWARE:

Master of Computer Information Systems Kennesaw State University – Kennesaw, GA 05/2008 – 05/2010

Bachelor of Science, Mathematics Lagos State University -Ojo, Badagry, Lagos, Nigeria 09/1988 - 05/1992

SQL Server 2012, 2014 SQL Database Design

SDLC

Database Developer

Oracle O.O.P

Data Analysis

LAN/WAN

TCP/IP System Analysis &Design

SSIS

ROUTERS

SWITCHES

Core Java

UML RDBMS

Data Processing Use Case

ETL

SQL Server 2014, Oracle, IBM Rational Architecture, Eclipse

MS Office (Access, Excel, PowerPoint & Word), SQL Server 2014 Data Quality Client

Structured query language (SQL), Oracle – PL/SQL, Visual Basic.Net (2005/08)

Excellent knowledge of RDBMS/Oracle, Java, RedHat, UML

MS SQL Server Database Administration, Applied Systems EPIC & TAM

Project Management, IBM Systems and compatible operating system-Linux, Hogan

Internet Explorer, Netscape Explorer, Oracle Virtualbox, Applied Systems (TAM), HTML

PROFESSIONAL EXPERIENCE

AtgWork

02/2016- Present

OracleApp DBA Consultant

Pritchard and Jerden Inc

04/2014 – 01/2016

Account Payable Analyst

Pritchard and Jerden Inc

09/2009 – 04/2014

Accounting Analyst II

Brown & Brown Insurance

02/2005 – 09/2009

Accounting Analyst I

MBNA America Bank, Newark, DE

09/2001 -02/2005

Operations Deposit Specialist

KEY RESPONSIBILITIES & ACCOMPLISHMENTS

Atgwork– Atlanta, GA February, 2016 – Present

Oracle Consultant

Sound knowledge in the domain of Identity Management. Conducted/Designed Proof of Concepts for Identity management solutions to various businesses (Presentation/Demo setups). Hands on working experience with Sun Identity Manager/Oracle Identity Manager. Involved in Design & Implementation of Oracle Identity & Access Management suite.

Install new versions of the Oracle RDBMS and any other tools that access the Oracle database.

Periodic checking the Health of the Database, recommend and make the necessary changes.

Plan and implement backup and recovery of the Oracle database.

Regularly refresh the databases

Apply quarterly Oracle patches to databases

Monitor the Alert and Trace log files for errors

Oracle SOA suite, (11g and 10g): Install, configure, enable high availability, upgrade, backup and recovery, tuning, and disaster recovery, and configure SSO for WebLogic, Enable SSO logins from MS Active Directory.

Provide architectural expertise for Oracle Identity Management and Oracle Access Management 11 1 1 5 0

Perform installation, administration, and maintenance of Oracle databases 10g, 11gR2, RAC, 12c on various platforms RHL 5.8, 6.5, 7.2

Perform constant and occasional database backup and recovery using RMAN

Managed Oracle databases on multiple platforms including Linux and Windows.

Use import/export tools to transfer information between a source and target databases.

Experience in Oracle Enterprise Manager, RMAN, Data Guard, and RAC

Manage redo log files in archive log mode for online backup.

New Horizon Computer Learning Center– Atlanta, GA April 2016 – November 2016

IT Training (MCSA)

Install, configure, and maintain Microsoft SQL Server Databases

Perform database backups and restores.

Import and export data to and from databases using SQL server import/export wizard and SSIS data tool.

Design and create tables, fields, indexes, keys, constraints and relationships defined by the software requirements

Incorporate required business rules utilizing stored procedures, constraints and other database objects

Use joins from multiple tables to make parameterized reports for management

Design and implement stored procedures, triggers, tables, functions, views, indexes and writing join statements.

Analyze database schemas, tables and indexes to improve performance

Plan, implement and maintain security at the database level.

Flexible, willing to learn work in a team environment, provide leadership to other team members.

Modify current databases by adding tables, indexes, and constraints

Excellent T-SQL programming skills.

Excellent knowledge of Relational Database Management Systems (RDBMS), Data Warehouse Concepts.

Good understanding of Extraction, Transformation and Loading (ETL) process using SSIS application tools.

Successfully retrieve business information from the data warehouse.

Perform knowledge base discovery

Debugging, error handling, and troubleshooting SSIS packages

Data cleansing using SSIS Package and DQS

Utilize the Pivot and Unpivot command to modify tables while retrieving data from database

Ability to identify and implement entities, domains, and attributes needed in a relational database management system

Monitor and maintain the physical database system and take necessary actions to ensure database is available and functioning properly

Administer, test and implement computer databases

Pritchard and Jerden Inc – Atlanta, GA April 2014 - January 2016

Account Payable Analyst

Communicated with carriers (via phone, mail or email) to research and resolve discrepancies on invoices.

Operated computers programmed with accounting software to record, store, and analyze information to make timely payments.

Debit, credit and total accounts on computer spreadsheets and databases, using specialized accounting software.

Pritchard and Jerden Inc – Atlanta, GA September 2009 - April 2014

Account Analyst ll

Gather data for internal audits through database management.

Reconciled direct bill commission statements in accounting system.

Matched order forms with invoices and record the necessary information

Spearheaded resolving delinquent accounts issues

Brown & Brown Insurance – Atlanta, GA February 2005 – September 2009

Accounting Analyst I

Process and monitor all Financial agreements and vendor payables. Collect and process all received checks by posting clients payments on TAM

Accelerated collection of Aged Receivable on balances over 25 days.

Post checks to GL and Company accounts

Reconcile direct bill company payables

Generate commission reports for Producers

MBNA America Bank, Newark, DE September 2001 – February 2005

Operations Deposit Specialist

Operated the ultra-mailers/Bowe Machine by ensuring that all documents are processed with accuracy while meeting deadlines and quotas. Addressed internal and external customer calls requesting account adjustments.

Expedited customer specialty cards regularly on a timely manner

Transferred funds between accounts upon customer’s request.

Issue necessary/requested payout checks to bank customers from MMA

Verified check signatures and filed CD and savings account forms for assured security.

Entered data and completed job requests into database system.

Balanced out the postage from different meters daily.

Accountable for monitoring downtime of machinery operations daily.

Contact this candidate