SUMMARY:

• Over 12 years of experience in application development, database architectural design and development using Oracle Database (all versions).
• Proficient in Oracle 9i Forms/Reports.
• Well - developed multi-platform and computer language skills, gained from developing application software in Oracle Database (Oracle 8 and 8I, 9i, 11G) with OAS, 9iAS Portal, OLTP, Oracle PL/SQL, Oracle Workflow, TOAD, ClearCase, Clear Quest, SQL Server, Designer 2000, Forms/Reports 6i, Forms 9i, E-Business R12 upgrade.
• Data Warehousing experience with data Extract, Transformation and Loading (ETL for about more than 2 terabytes of records on the average) processing using PL/SQL and SQL Loader based tools, performance tuning, optimization, Microsoft Access, Progress, RDBMS, and Crystal Reports 10/BOXI.
• Created reports for business and financial activities via Oracle Financials - Account Receivable, Oracle HR, Payroll, and registering of forms and reports into Oracle Financials.
• Use Solaris UNIX- K-Shell and Bourne Shell scripting for software development.
• Proficient in requirements analysis, system analysis/design and logical data modeling using Platinum Erwin and Visio.
• Ensure that the data architecture of the application is in compliance with the vision of the enterprise data architecture in terms of data sources, data replication and best practices.
• Physical Database design, 3NF, including the support of the design and implementation of the physical databases to achieve acceptable levels of performance, security, and storage capacity.
• Assist in loading data from external data sources, archiving legacy data, recovering legacy data for analytical purposes, or assisting with providing external data feeds and data exports.
• Proficient in fuzzy logic by creating, modifying and visualizing fuzzy sets and fuzzy logic-based systems; Interpret algorithm based on fuzzy logic and put pictorial representation of the algorithm through a process flowchart using Visio.
• Languages Spoken: English, French, and Yoruba (Nigeria).
• Clearance: NACI Clearance - background check and MBI - Previous Years.
• Professional Federal Service Award: USA Food and Drug Administration, FDA 2008 Outstanding Service Award (06/2008); Signed by the commissioner, Food and Drug Administration.

TECHNICAL SKILLS:

Databases/Applications: Oracle - Oracle (8,8i, 9i, 10G, 11G) - SQL, PL/SQL, Oracle Workflow, OBIEE, OLTP, Oracle Express, Forms 6/9i, Reports 6/9i, TOAD, RAPID SQL, Structured Query Report Writer (SQR), Crystal Report, 9iAS, Oracle Discoverer and Oracle Application Server - OAS. Web DB, 9iAS Portal, Data Warehousing, and Oracle Financial 11i AR, AP and Report writing, Crystal Report 10/BOXI, PLATINUM ERWIN for Data Modeling, Oracle Business Intelligence Enterprise edition - OBIEE, Informatica, Imaging Processing & Management - IPM, Universal Contents Manage - UCM, Web Logic, Oracle Enterprise Business Suites 11i, R12 upgradeProgramming Languages Visual Basic 6.0, Pascal and COBOL

Internet/Web Tools: Microsoft FrontPage, OAS, 9iAS Portal, Oracle APEX, Web DB, HTML, Hotdog, IE 4.0, Paint Shop Pro 3, Paint, Macromedia Flash Professional, Oracle APEX

Operating Systems: MSDOS, UNIX (K-Shell and BOURNE Shell), Windows 95/98/XP/200 Pro/Me and Windows NT

Office Productivity Tools: WordPerfect, MS Office, VI Editor, and Ted, ultra edit for ORACLE coding

Other: Advanced troubleshooting, problem resolution, Project Management, Timeline, proficient skills on implementation and operations, as it relates to Relational Database Management System (RDMS)

PROFESSIONAL EXPERIENCE:

Confidential, Austin TX

Sr. Oracle Developer

Responsibilities:

• Functionally and technically support/use Application Management Data Automation -AMANDA version 6 application for City of Austin Government, Configuration setups of AMANDA folders and Valid Lookups and Default Procedures, Use Oracle, PL/SQL, PL/SQL Developer, and Web Portal for Confidential - Confidential permits automated for online payments in AMANDA via ROWMAN (ROWMAN - Right Of Way Management Approval Network) and Portal.
• The online payments for Confidential - Austin Department of Transportation permits were contained in the following folders: SB Sign & Banners, RW Right of Way, EX Excavation (Right of Way Excavation), UC Utility Co - ordination, DS Driveway Sidewalk, LC Concrete License, Confidential Folders Attachments for Confidential Folders, Change Requests CR, UAT Support, Confidential - make other folder types eligible for the online payment, Add Pending Payments to lookup.

Confidential, Dallas, TX

Sr. Oracle Developer/Data Modeler/DA

• Harris County Toll Road OLTP Production Support of EZTAG Web and OLCSC.
• Daily Production Heat Ticket Support.
• Account and Tag Management - new, Update & Delete (change of status).
• Toll Credit for VETs.
• Fraud Management.
• Inter-operability IOP- Peer and IOP-Hub.
• TransExpress Hung Payment resolution.
• Zero Dollar Toll - ZDT.
• DMV Weekly File Load & Reload.
• VTOLL & Violation Resolution & Automation.
• ICDB (Galaxy) Badge Automation using PL/SQL - Generate Badge ID for Employees.
• Tags Fulfillment.
• Fleet File Loads & Reloads and Troubleshooting & Resolution of Issues.
• Resolution of EZTAG Web and OLCSC - Online Customer Service issues.
• Various ad-hoc EZTAG reports.
• Setup of APEX Workspace, schema, users and perform APEX administration duties.
• Develop APEX applications - HEAT Reports.
• Troubleshoot HCTRA Heat Ticket issues and resolve them.
• Analyze and develop ad hoc reports using PL/SQL and SQL for business customers.
• Developed and perform Production Support of Electronic Transaction Consultant - Confidential on Toll Road Transaction Automation and Processing using PL/SQL, Oracle SQL and Modeler, TOAD, and other related tools.
• Developed Toll Violation Processing System payments and settlement counts using Oracle related technology and tools.
• Designed a DDD for Daily Toll Receipt Shortages for reimbursement by staff or Temporary staff using Visio, Oracle Modeler, SQL, and Oracle 12G and other related tools.
• Designed all function points and interface, data structure, physical and logical model using data modeling tools like Visio and ERWIN and objects for Daily Toll Receipt Shortages for reimbursement by staff or Temporary staff using company template standards and other Oracle related tools.
• Involved in developing Workflow processing using RAQ - Random Access Queue, Asynchronous Check-in, Synchronous Checkout, different patterns of Check-in and Checkout using Oracle PL/SQL and other related tools.
• Used UTPLSQL to perform Unit Testing for the above all projects.
• Involved in project DDD development and presentation to the management and users.
• Developed scripts and tested all scripts for loading toll rates for new calendar year.
• Analyzed, created a DDD and developed from the DDD WSDOT Occupancy Declarable Transponder - ODT using company standard templates, PL/SQL, SQL, Excel, TOAD, Modeler, UTPLSQL and other relevant tools.
• Use CVS and Clear case as Change Control Management Utilities.

Confidential, Katy, TX

Sr. Oracle Developer/Data Modeler

• Production support, Using Waterfall and Agile Technology - analysis and design of Oracle Imaging Processing & Management - IPM using Oracle Data Capture - ODC, Universal Content Manager - UCM, WebLogic, IPM, Oracle Database 11G, PL/SQL, SQL and UNIX.
• Oracle Financial R12 upgrade using Open Source DataLoad utility and Telne interface to perform incremental loads into Enterprise Business Suites R12 after extracting data from the Test instance for a period of time before going LIVE.
• Used Reverse Engineering using ERWIN to get all the logical objects related to the database. Map unmapped tables and create Surrogate Keys, and Foreign Keys for referential integrity in the logical rheme and make it available in ERWIN.
• ETL process (XML source file converted to CSV) of Igloo Production Scheduling - analyzed, designed (MD50) and coded to allow users to view and review Production Scheduling automatically and on-demand and as a replacement to the old manual method of review. Oracle 11G, PL/SQL, SQL, XML, EXCEL, OBIEE and UNIX were used for historical load and incremental loads using Time Stamp Delta. Also performed Unit Testing.
• Igloo Update Service developed using Oracle 11G, PL/SQL, SQL and UNIX to refresh IPM intermittently.
• Analyzed, designed (MD50) and automated IPM - Oracle Data Capture - ODC Input Agent, after converting from Direct Commit, Error documents using Oracle UTL FILE package, SQL Loader, SQL, Oracle 11G, Excel and UNIX.
• Major conversion of Igloo Financial Oracle seeded and customized Discoverer reports to Oracle Business Intelligence Enterprise Edition - OBIEE for Igloo manufacturing, operations, Order Management reports, Purchase Order, Account Payables, and Account Receivables.
• Used Oracle Enterprise Business Suites - EBS and Oracle SILOS for data lineage relationships between ETL Folder, ETL Mapping, OLTP columns and Data Warehouse Columns. Looked at seeded objects and mapping them with DW objects.

Confidential, The Woodlands, TX

Sr. Oracle Developer

• Used Waterfall and Agile Technology Develop ORALS Drug History ETL application using PL/SQL with Oracle 11g backend from IKM web services to stage, core and finally to the data mart for reporting. Also performed Unit Testing.
• Designed (3NF) and developed Meaningful Use Time Period for different practices for aggregation with Oracle package using stored procedures and PL/SQL in 11G Oracle backend.
• Modified and maintained Kettle - Pentaho ETL to resolve ticket issues and promote testing to UAT and finally to Production.
• Utilized stored procedure in PL/SQL and SQL for researching issues and developing new applications.
• Trained and used Informatica as an ETL tool to extract, transform and load data from source to targets.
• Developed and maintained Jasper reports using iReport.
• Performed analysis and developed ad-hoc queries to resolve issues.

Confidential, Houston, TX

Sr. Application PL/SQL Developer

• Worked on Confidential Affinity General Ledger Segment Reporting which is used to calculate and pay earned compensation and non-earned compensation (Advances, Guarantee and Bonuses) to all Affinity/Co-Brand Partners.
• Analyzed and designed the Confidential Affinity Compensation System (ACS) using: Oracle 11G, PL/SQL, Oracle Financial 11i, and Toad (for coding).
• Modified Incremental Standard Deal volume PL/SQL package to load the Standard Deal Volume (int4) by segment.
• Modified Reward deal Volume PL/SQL package to load the Reward Deal Volume (int18) by segment.
• Modified Odd Deal Volume PL/SQL package to load the Standard Deal Volume (int5) by segment.
• Used Oracle Financial 11i to load data, manage profiles, responsibilities, log files, output files etc.

Confidential, Lusby, MD

Sr. Application/PL/SQL Developer

• Full Fleet Core Management Systems - FCMS production support and development using Oracle database 11G, PL/SQL Forms, Reports and SQL ad-hoc queries to resolve Change Requests.
• Gathered and analyzed CR requirements related to FCMS Tags subsequently coding with PL/SQL.
• Created a PRR- Production Release Request to release into production.
• Promoted code into production instance every Thursday of the week.
• Analyzed, designed, coded, and released more than 60 production requests (AWRs) for the three sites of Confidential: Calvert Cliff, Lusby, MD, Nile Mile Point, NY, and Gina, NY.
• Migrated Fleet data from Legacy system to FCMS.
• Performed, installed and upgraded PV-Plus application modules including In-service Testing, Pump Curve, Check Valve and Relief Valve Modules.

Confidential, Chesapeake, VA

Sr. Application PL/SQL Developer

• Provided support to assist in the development, implementation, maintenance and operation of the United States Coast Guard - USCG (division of Home Land Security) Finance Center (FICEN's) Core accounting System (CAS).
• Utilized Oracle SQL/PL/SQL, SQL Loader, Oracle Forms, Reports 6i/9i, Crystal Reports (for Check Free application), and other IT tools to store them in Remedy Database as a backup repository.
• Developed Oracle Financial processes, reports and reconciled the accounting data related to TSA, DNDO and USCG payroll as they are made available from National Finance Center (NFC).
• Using Waterfall and Agile Technology Developed a robust Archival System using UTL package with Bulk Collect to archive terabytes of DHS data and register the three processes (archiving, validation and delete processes) in Oracle Financial 11i as Concurrent Programs.

Confidential

Sr. Developer/Analyst Developer

• Development using Oracle 10G SQL and PL/SQL (for ETL), Oracle EXPRESS (storage) in OLAP form, Oracle Business Intelligence (Dashboard and Answer) - OBI (physical, business and presentation layers), OBI Answers and Dashboard and POWER for reporting.
• Developed different Ad-hoc and recurring reports related to VHA first party and third party billings, collections and refunds; this report includes e-denial, e-pharmacy, etc.
• Troubleshot and resolved different anomalies that occurred during monthly data warehouse ETL and reporting using SQL and PL/SQL.
• Developed days to collect by Collected Amount report using PL/SQL Package, Oracle Express and POWER dashboard.

Confidential, Washington, DC

Sr. Developer/Analyst Developer

• Analyzed, designed, and developed using PL/SQL (Oracle packages, function and procedures), Oracle Forms, and Reports.
• Developed Oracle form PLL - Custom PLL, Excel (for result analysis), Rational (Clear Case and Clear Quest), UNIX, Citrix, Windows XP, and Functional setups and concurrent programs execution using different FMS Responsibilities for Oracle Financial 11i module Change Requests (CRs).