Theresa Okpani
Professional Profile
Over 9 years of experience in Oracle PL/SQL development, design, requirements
analysis,  trouble-shooting, problem-solving, some database administration,
oracle discoverer, and system testing in consulting, healthcare, retail,
manufacturing, and government industries. 
·	More than 9 years of technical hands on Oracle, PL/SQL programming and
development experience.
·	More than 7 years of Data Analysis experience
·	More than 4 years of Data Modeling experience
·	More than 5 years of Oracle consulting experience
·	More than 3 years developing Oracle applications using Oracle forms and
reports
·	More than 2 years of Oracle 9i/10g discoverer experience
·	Posses very strong analytical, troubleshooting, problem solving, critical and
logical-thinking skills
Education and Certifications
·	Masters of Science - Computer Science, Jackson State University, Jackson,
Mississippi
·	Bachelors of Science - Mathematics, Fort Valley State University, Fort Valley,
GA
·	Advanced PL/SQL 8i certification, Oracle Corporation, Atlanta GA.
Industries
·	Manufacturing
·	Government	
·	Healthcare
·	Consulting
·	Education
·	Retail
Areas of Expertise
·	Requirements Analysis
·	PL/SQL programming and development
·	Trouble-shooting/Problem-Solving Oracle related issues
·	Oracle Forms and Reports Development
·	Oracle 9i/10g Discoverer
Experience and Skills
·	Oracle 8/9i/10g Enterprise Edition
·	Oracle 8/8i/9i/10g
·	Advanced PL/SQL8i
·	PL/SQL
·	SQL plus
·	Oracle 7.3x
·	SQLLOADER
·	C
·	Oracle 10g Discoverer 
·	Oracle Developer 6, 6i, 9i, 10g(Forms and Reports)
·	TOAD 7.x/8.x
·	Developer 2000
·	Windows NT/95/98/2000/XP
·	Oracle Database Administration
·	Project Management
·	Data Modeling
·	HTML
·	Oracle Datawarehouse Builder

Chronology of Experience

January 2007 to Present - Compuware Corporation
Industry:          Healthcare -- Healthways	
Position:          Sr. Oracle PL/SQL Developer
Environment:  Oracle 10g, 9i, 8i Windows NT/XP
Tools:              StarTeam, TOAD, ORACLE, SQLPLUS, PL/SQL, Oracle 10g
Discoverer 
Responsible Oracle9i/10g Development, PL/SQL Development, trouble-shooting and
resolving code related issues. 
Handled Conversion project. 
Handled PL/SQL code Analysis and modifications. 
Handled creation, modifications, and documentation of Oracle Packages,
Procedures, Functions, and Indexes. 
Handled creation of Oracle Tables, Triggers, and Materialized View. 
Handled creation of test plans, and technical specifications for developed
and/or modified objects. 
Handled loading data required for system testing, setting up necessary test
environment, 
and system-testing developed Oracle objects. 
Utilized TOAD 8.x for creating objects, modifications, trouble-shooting and
resolving issues. 
Utilized Oracle 10g Discoverer to administer and create reports.
Utilized StarTeam for check in/check out objects, and logging tasks. 
Utilized Oracle9i, SQLPLUS, Windows NT/XP for creating and modifying Oracle
objects. 
Oracle 11i /Oracle Financials Training - CBT

06/2006 - 12/2006 Oracle Developer/PL/SQL Programmer - Apex Systems, Atlanta,
GA.	
Responsible for Oracle9i/10g development, PL/SQL Development, trouble-shooting,
and resolving issues as they surfaced. 
Handled PL/SQL code modifications, enhancements and tuning. 
Handled Oracle Reports development, modifications, enhancement, and tuning and
Oracle 10g Discoverer Reports design, development, enhancement, and tuning. 
Created Tables, views, materialized views, wrote SQL scripts, Indexes, etc,
Analyzed Oracle objects, Resolved performance issues - like fixing Chaining
issues, and documenting projects. 
Responsible for Database objects performance tuning

Tools/Skills set include the following:

Create several Procedures, Functions, Views, Packages, Tables, Sequences,
Synonyms, Indexes, Materialized
Views, and Analyzing Oracle Objects and resolving Chaining issues in Oracle
Databases.
Analyze data and resolve Oracle related issues on a regular basis
Use Oracle versions 9i & 10g PL/SQL & SQL*PLUS for Back-End development of 
	modules for the projects
Use Oracle Discoverer (versions 4.x & 10g)
Use TOAD (versions 8.0 & 8.x - up to the latest version - 8.5), and PL/SQL
Developer
Use Windows NT/XP, Oracle 9i, Oracle 10g
Use SQLLOADER for Data Loading
Use Unix AIX


10/2004 - 06/2006 Oracle Developer/PL/SQL programmer - Atlanta Housing
Authority, Atlanta, GA.

Project - HR Benefits application
Responsible for developing over 100 new Custom Reports, Import/Export Utility,
Several Data Loading Projects, etc
Responsible for Oracle development, PL/SQL Development, Oracle Forms & Reports
6i/9i/10g. 
Loaded Data utilizing SQLLOADER, Oracle packages, functions, procedures
(Extensive PL/SQL Coding). 
Responsible for Data migration, Data cleansing, testing, trouble-shooting,
problem-solving, and resolving issues as they surfaced. Imported and exported
Oracle Objects. 
Handled PL/SQL code modifications, enhancements, and tuning. 
Designed, developed, modified, enhanced and tuned Oracle reports and Oracle
Discoverer Reports. 
Created Tables, Triggers, views, materialized views, and SQL scripts

Tools/Skills set include the following:

Create several Procedures, Functions, Views, Packages, Tables, Sequences,
Synonyms, and Materialized Views
Create several new custom Reports
Perform several Data Loads
Create new Forms and modify existing ones
Analyze data and resolve Oracle related issues on a regular basis
Deploy some Forms and Reports to the web
Use Oracle versions 9i & 10g PL/SQL & SQL*PLUS for Back-End development of
modules for the projects
Use Oracle Developer 6i (Forms 6i and Reports 6i)
Use Oracle Developer 10g (Forms 10g, Reports 10g, and Graphics 10g)
Use Oracle Discoverer  (version 10g)
Use TOAD (versions 8.0 & 8.x - up to the latest version - 8.5)
Use Windows NT/XP, Oracle 9i, Oracle 10g
Use SQLLOADER for Data Loading
.Use XMLSpy for XML Data Loading


11/2001- 10/2004 Oracle Database/PL/SQL Development, Oracle Developer-
Independent Work/Project

Project - Transportation Application
Worked on PL/SQL modifications/enhancement. 
Analyzed data, trouble-shoot/researched issues dealing with Oracle 8i/9i
databases. 
Performed Oracle database tuning for database objects and data warehouse
objects. 
Resolved row migration and chaining issues; exposure to Informatica. 
Documented some PL/SQL and SQL codes as well as other database objects. 

Project - Vehicle Permit Application for Department Of Aviation 
Handled vehicle permits, entering companies’ demographics, vehicle information,
and billing companies for the permits. 	 

Project - Application for Recreational Departments 
Tracking of students' sports enrollments, team assignments based on age grades,
payment history, activities enrolled in, 
coach assignments, and students' demographics. 

Tools/Skills set for above projects include the following:

Data Modeling, Database development using Advanced PL/SQL 	8i, SQL, SQLLoader,
and SQL*PLUS Scripting
Responsible for creating and assigning roles and profiles to Database users
Responsible for creating Procedures, Functions, Views, Packages, Tables,
Clusters, Sequences, Synonyms
Databases, Table spaces, and Snapshots
Analyzed data and resolved Oracle related issues on a regular basis
Trained/worked with Oracle 9i
Developed some web enabled Forms and Reports for the Security Vehicle Permits
project 
Responsible for deploying client/server Forms and Reports to the web
Used Oracle versions 8i & 9i PL/SQL & SQL*PLUS for Back-End development of
modules for the projects
Trained/exposure to Oracle Portal and Oracle Workflow, and Oracle 9iAS 
Used Oracle Developer 6  (Forms 6 and Reports 6)
Used Oracle Developer 6i (Forms 6i and Reports 6i)
Used SQL Server 2000
Used Oracle Discoverer  (versions 3.1 & 4.1.x)
Used TOAD (versions 6.0.4 & 7.3)
Used Windows NT/98/2000/XP, Oracle8 & 8i Enterprise Edition, Oracle 9i, Oracle
8i, Oracle 8x

12/2000 - 11/2001 Oracle Database Developer & Project Manager - SYNAVANT Inc,
Atlanta, GA: 

Projects - WMS, CRM, Realignment MTO, Renumbering MTO, Targeting, and
Distribution

Created, tested, debugged, and implemented Oracle database application project
modules utilizing Oracle8.x, Oracle8i, and Oracle8 Enterprise Edition, SQL*PLUS,
PL/SQL 8.0.5, PL/SQL8i, SQLLDR, TOAD - (versions 6.0.3 and 6.0.4), MS Access 2000
and Excel on Win NT/98/2000 - including Oracle Procedures, Views, Functions,
Packages, Triggers, Data Manipulation, Data Conversion, Data Load, Data
Extraction, Tables, Indexes, Synonyms, Snapshots, Sequences, Table spaces, and
Clusters. 
Worked closely with DBAs and other team members to plan, test and implement
several Oracle database related projects for customers. 
Analyzed data on a regular basis. 
Created, updated, tuned and modified Oracle Procedures, Functions, Packages,
Tables, and View for better performance. 
Developed Project scopes, test plans, executed the test plans, and assisted in
projects implementation. 
Participated in deploying client/server Forms and Reports to the web. 
Participated in team/customer conference calls/meetings to discuss new and
existing database projects and other related issues. Maintained daily operation
of proprietary applications. 
Developed and ran Oracle reports queries on daily basis for data extraction
utilizing SQL and SQL*PLUS. 
Performed Functional and data requirement analysis, and some light DBA work.
Involved in researching, analyzing, troubleshooting, and resolving Oracle related
issues as they materialized. 
Recognized by senior management for outstanding performance resulting in
receiving some days off bonuses. 
Met projects deadline. 
Always on call for after hours projects in-progress as the project manager.
Performed customer database cleanup projects consisting of millions of
records/transactions to enhance and tune the database for better performance


8/1999 -12/2000 Oracle Database Developer/Programmer/Analyst II - DHR, Atlanta,
GA: 

Project - Ga. Medicaid Billing, WMS, Insurance, Ga. WIC, Registry,
Immunizations, Financial, and Y2K    
                   
Performed Functional and data requirement analysis, and some light DBA work. 
Participated in the Development of Y2K Application using Oracle8 Enterprise Ed.,
PL/SQL 8.0.5, PL/SQL8i, SQL*PLUS, SQLLDR7.3, Oracle 8.x, 
Oracle8i, VB, MS Access97, Crystal Report version 7, Developer2000 (Forms 4.5
and Reports 2.5), Oracle Developer 6 (Forms 6 and Reports 6), and other related
tools. 
Developed several Oracle related new modules projects utilizing PL/SQL, SQL,
Procedures, Views, Triggers, Synonyms, Indexes, Functions, Packages, and
Snapshots on Windows NT, Novel, Windows 95/98/2000 Operating Systems. 
Researched, analyzed, troubleshoot and modified existing modules to fix defects.

Used TOAD (versions 6.0.2 & 6.0.3). 
Analyzed data on a regular basis. 
Researched/exposure to HIPAA standards and requirements. 
Involved in constantly testing Back End and Front End of Oracle Application
Modules for performance and correctness. 
Utilized/Worked on VB 6 (troubleshooting) and Seagate Crystal Reports version 7
(reports generation). 
Updated, enhanced, and modified Oracle Procedures, Functions, Triggers,
Packages, and Views
Developed test plans and executed the test plans. 
Created test scripts for Back end testing of modules developed. 
Formal training, exposure, good knowledge, and some experience in ASP. 
Participated in the development of user documentations and Online Help for the
Y2K applications project. 
Utilized Clear Quest software for defect tracking, recording and updates. 
Sometimes on call for oracle related issues as the only Oracle Developer on my
team. 
Utilized Source Safe software to add, check-in and checkout new and existing
code modules. 
Worked hand-in-hand and one-on-one with VB as well as Crystal Report Programmers
on Defect fixes as well as on new Module Development to check for data integrity
and data correctness as the only Oracle Database Developer on the team

8/1998 - 7/1999 Oracle Developer/Programmer/Analyst - J F F Corporation,
Birmingham, AL

Projects - WMS, Manufacturing, Financial, Billing, CRM, and Inventory
Used TOAD version 6.0.2. Analyzed data on a regular basis. Performed Functional
and data requirement analysis, and some light DBA work. Utilized Oracle8
Enterprise Edition, Oracle 8.x, SQL, SQL*PLUS, PL/SQL8.0.5, Stored Procedures,
Views, Tables, Functions, data Manipulations, and Packages to maintain and update
existing Applications code on Win NT/95 and Unix

6/1998 - 8/1998	Oracle Developer - C T G, Atlanta, GA
		          
Project - Billing Application
·Utilized ORACLE7.3.x, SQL*PLUS, PL/SQL2.3, SQL*PLUS Reports, SQL, Stored
Procedures, functions, Triggers, Indexes, Sequences, Tables, and Views on Sun
Solaris Unix operating system. 
Used TOAD version 6.0.2. 
Analyzed data on a regular basis. 
Performed Functional and data requirement analysis, and some light DBA work. 
Involved in CBT Training on Sun Solaris, Unix Shell scripting, Vi editor, and
web forms creation (HTML)

12/1997 - 4/1998 Programmer - Scottish Rite Children's Med Ctr., Info Sys &
Technology, Atlanta, GA			            
Projects - Patients' Account, Medical Records, Human Resources, and Patients'
Billing
Performed functional and data requirement analysis. 
Designed logical data modeling using entity-relationship technique. 
Created and ran reports on patient accounts, medical records, patient
admissions, etc. 
Modified, updated and maintained existing program report codes at the requests
of customers

9/1997 - 9/1998 Consultant - Chattahoochee Technical Institute, Computer
Department, Marietta, GA

Projects - Student Records, and Classroom Scheduling
Responsible for consulting using - Oracle 8 Enterprise Edition, Oracle 7.3.x,
Developer 2000, PRO C. 
Performed functional and data requirement analysis, and some light DBA work. 
Designed logical data modeling using entity-relationship technique. 
Developed students' classroom scheduling software using Oracle and its tools
(PL/SQL2.3, SQLLDR7.3, SQL*PLUS, SQL, Procedures, Functions, Views, Packages,
Indexes, Tables, Sequences, SQL*PLUS Reports, etc.), PRO C, and Developer2000
(Forms 4.5, Reports 2.5, and Graphics 2.5) on Windows NT and Windows 95. 
Developed Test Plan for testing the software and helped execute the test plan to
test the software 

3/1989 - 4/1996 Consultant and Teacher- Youth Development Campus, Augusta, GA

Projects - Billing, Employee Records, Inventory, and Customer Status Tracking
Tools used included- Oracle7.x, Developer 2000 (for 6months - Forms 4.5, Reports
2.5, and Graphics 2.5), C/C++, UNIX, win 95. Trained students in mathematics,
computer science, personal finance and G.E.D. 
Supervised and managed youth in classroom settings. 
Consultant for part-time projects utilizing Oracle7.3.x, Solaris UNIX, IBM
Mainframe and Windows OS (Procedures, functions, Views, Packages, PL/SQL 2.3,
SQL, SQL*PLUS, PRO C, HTML, NETSCAPE, WEB PAGES, SQL*PLUS Reports, Indexes,
Tables, and Sequences) to develop projects during summer vacations - (24 months
total time)

6/1997 - 8/1997 Oracle Programmer/ Consultant- Guru Software Training &
Development Services, Alpharetta, GA

Projects - Customer Status Tracking, Inventory, and Employee Records			         
 
Performed functional and data requirement analysis. 
Designed logical data modeling using entity-relationship technique.
Created the physical database and populated the database. 
Designed a relational database management system using Oracle8 Enterprise
Edition, Oracle 7.3.x and Oracle8x. 
Developed a status tracking software application for a building maintenance and
repair client using Oracle and its tools (PL/SQL 2.3, PL/SQL 8x, SQL*PLUS, SQL,
Procedures, Functions, Views, Packages, Tables, Indexes, Sequences, SQL, SQL*PLUS
Reports, etc.), and Developer 2000  (Forms 4.5 and Reports 2.5) on Windows NT/95

8/1996 - 6/1997Graduate Assistant/Consultant/Computer Science - Clemson
University, Clemson, SC

Projects - Compiler Construction, Financial, Inventory, and Billing		          
Involved in C/C++ and Java Programming languages (designed, developed,
documented, and executed programs).
Conducted Microsoft Office package (Word, Access, PowerPoint, & Excel) Lab
trainings, HTML, Netscape, Web Page (Designed, and developed web applications). 
Conducted Web Page design & development trainings for students in lab settings.

Utilized Elm, Vi and Pico Editors, and WordPerfect. 
Designed, coded, and implemented Compiler project utilizing C/C++ on Sun Solaris
UNIX, Windows 95 and Mainframe platforms. Served as Consultant for Part-time
projects utilizing Oracle7x (PL/SQL8x, SQL, SQL*PLUS, SQL, Procedures, Functions,
Views, Packages, Tables, Indexes, Sequences, SQL*PLUS Reports, Shell Scripting,
etc.) and Developer 2000 (Forms 4.5 and Reports 2.5). 
Designed and developed Personal Web (Home) Pages utilizing different Netscape
browsers. 
Managed and supervised both graduate and undergraduate students and 	

Professional Education and Training 
·	Professional Certificate (Georgia Teacher Certification, Mathematics), Augusta
College, Augusta GA.
·	Professional Certificate (Selected Computer Science Courses), Clemson
University, Clemson, SC.
Ancillary Skills
·	UNIX
·	Shell Scripting
·	SQL Server 2000
·	Java
·	Web Development
·	Crystal Reports
·	MS Access
·	Visual Basic