TRESSELINE C. COLEMAN LEWIS

**** ****** **** ********, ** 23234

804-***-**** Cellular acvpst@r.postjobfree.com - email

OBJECTIVE

To obtain a challenging position that will utilize my extensive technical skills and/or instructional skills with a progressively upward and growing company.

TECHNICAL SKILLS

ORACLE 9i, 10g and 11g, ORACLE SQL, PL/SQL, ORACLE FORMS 6i, 10g and 11g, ORACLE REPORTS 6i and 10g, ORACLE Trainer, ORACLE Application Express, Portal Development, PL/SQL Web Toolkit, JAVASCRIPT, SQL*PLUS, TOAD, JD Edwards EnterpriseOne, Data Modeler, Erwin, SQL DEVELOPER, JDeveloper 11g, SQL LOADER, C++, UNIX, Korn Shell Scripting, Perl scripting, SERENA CHANGEMAN, VISUAL SourceSafe, SERENA DIMENSIONS CM, TeamTrack, PVCS, Quality Center, COGNOS, HYPERION-BRIO SQR, HYPERION SUITE, HYPERION SQR PRODUCTION REPORTING, HYPERION INTERACTIVE REPORTING 9.3.1, OFFICE XP and 2003, Crystal Reports, VBA, VISUAL BASIC 6.0.and .Net, VISUAL STUDIO 6.0, 2005, 2008, and 2010, SQL REPORTING SERVICES, SQL Server, ADO.Net, ASP and ASP.Net, VBSCRIPT, JAVA, JSP, HTML, DREAMWEAVER, FRONTPAGE, DB2, DB2/UDB, SMS, ActiveX, COM/DCOM, MVS, COBOL II, MICROFOCUS COBOL, INFORMIX, SAS, IMS, TSO/ISPF, JCL, XPEDITER, DB/DC, DL/I, CICS, VSAM, Easytrieve, File-Aid, IDMS, ADABAS Natural, FORTRAN, PL/I, BASIC, ENDEAVOR, ROSCOE, Changeman, SYSM, FORTRAN, CA/IDEAL, ISQL, SPUFI, Platinum, Intertest.

PROFESSIONAL ACHIEVEMENTS:

DAYBREAK IT SOLUTIONS RICHMOND, VA 02/16-03/16

Oracle ETL Developer Consultant

Consultant for RTS Labs, Inc.

Utilize ORACLE 11g, PL/SQL, SQL Developer, for creating packages, procedures, and functions, Jira, and BitBucket.

ETL Technical and development support for the World Wide Express Freight system for sending shipping information from client to World Wide Express.

4 CONSULTING, INC. RICHMOND, VA 09/15-01/16

Oracle Developer Consultant

Remote Consultant for CSC, Inc. in Bath, Maine supporting Bath Iron Works/US Navy.

Utilized ORACLE 10g and 11g, FORMS, PL/SQL, SQL Developer, for creating packages, procedures, functions, and reports. Create and utilize UNIX and LINUX shell scripts, perl scripts, and Pro*C.

Technical and development support for the Pipe Scheduling Interface (PSI) system for ship building schematics.

Supported the Pipe Bending System and on a part-time when needed basis.

MAGELLAN HEALTHCARE RICHMOND, VA 09/14-08/15

Lead Programmer Analyst

Utilized ORACLE 11g, PL/SQL, SQL Developer and TOAD for creating packages, procedures, functions, and reports. Created and utilized UNIX shell scripts and perl scripts.

Utilized Subversion source control, Selenium testing tool, and JIRA project tool.

Lead Technical support for Total Drug Solution (TDS) System.

Technical Support for FL, AK, NH, NY, MI, TN, and NE Healthcare Accounts.

INSIGHT GLOBAL RICHMOND, VA 03/14-09/14

Senior Programmer Analyst

Consultant at Magellan Healthcare.

Utilized ORACLE 11g, PL/SQL, SQL Developer and TOAD for creating packages, procedures, functions, and reports. Created and utilized UNIX shell scripts and Perl scripts.

Technical Support for FL, AK, NH, NY, MI, TDS, TN, and WV Healthcare Accounts.

SWISSLOG INC. NEWPORT NEWS, VA 08/13-02/14

Senior Software Engineer

Utilized ORACLE 10g and 11g, PL/SQL, FORMS 10g, REPORTS 10g, UNIX, and TOAD for creating and forms applications, and reports; C++, .Net, and Visual Studio 2010 for Radio Frequency character based scanners.

Technical Lead for Baxter Pharmaceuticals warehouse inventory system.

Technical Lead for Warehouse Management Upgrade project.

Technical Lead for overseeing consultants assigned to projects on Baxter Pharmaceutical systems.

Created Technical, Design, and Test documents for each project assigned for SDLC.

ASTUTE BUSINESS LAS VEGAS, NV 05/13-8/13

Oracle Developer Consultant

Consultant at Diamond Resorts Intl. via AT&T.

Utilized ORACLE 11g, PL/SQL, Web Toolkit, JavaScript, HTML, and TOAD for creating online applications, procedures, functions, packages, and for performance tuning.

Modified online Island Club Resort application for adding cancellation/booking fee when cancelling or booking a reservation.

Created Technical, Design, and Test documents for each project assigned for SDLC.

PINPOINT IT SERVICES NEWPORT NEWS, VA 07/12-5/13

Software Engineer Consultant

Consultant at Swisslog Inc.

Utilized ORACLE 10g and 11g, PL/SQL, FORMS 10g, REPORTS 10g, UNIX, and TOAD for creating and forms applications, and reports; C++, .Net, and Visual Studio 2010 for Radio Frequency character based scanners.

Support Engineer for Baxter Pharmaceuticals warehouse inventory system software.

Created Technical, Design, and Test documents for each project assigned for SDLC.

Created new reports and modified reports that were printing overlapping data.

Created new SQL Package and procedure for handling last shipping and receiving dates.

Modified procedures to create save points and rollback data to the save points if any processing errors occur. This is for handling inaccuracies in shipping inventory data.

RESOLVIT, INC. RICHMOND, VA 04/12-5/12

Oracle Developer Consultant

Consultant at PPD, Inc.

Utilized ORACLE 10g, PL/SQL, FORMS 10g, REPORTS 10g, and SQL Developer for creating and forms applications, and reports.

Created new Quality Control Application for scheduling Project Audits, logging audit findings, responding to audit findings and emailing appropriate personnel for the audits.

Created database tables and audit tables for the Quality Control application.

DATA CONCEPTS, INC. RICHMOND, VA 10/11-04/12

Oracle Developer Consultant

Consultant at VA Department of Health.

Utilized ORACLE 10g and 11g, PL/SQL, Web Toolkit, FORMS 6i, 10g, and 11g, REPORTS 6i and 10g, and TOAD for creating and maintaining front end portal and forms applications, and reports.

Utilized HP Quality Center, PVCS, and Serena ChangeMan Version Manager.

Utilized PL/SQL, PL/SQL Web toolkit, HTML and JavaScript for creating Admin, User Management, and Agency Portal Screens and reports screens.

Handle tickets for new development or modifications needed to existing applications.

NETWORKING FOR FUTURE (NFF), INC. SUITLAND, MD 1/11-10/11

Oracle Developer Consultant

Consultant at the US Census Bureau.

Utilized ORACLE 10g, PL/SQL, FORMS, REPORTS, and TOAD for creating and maintaining front end forms applications and reports and performance tuning.

Utilized HP Quality Center, TeamTrack, and Serena ChangeMan Version Manager.

Utilized APEX tool, HTML, PL/SQL Web toolkit, and JavaScript for creating menu on Oracle Portal.

Developed reports online for individuals sworn in to work at the US Census Bureau.

Handled tickets for new development or modifications needed to existing applications.

Modified Security Screen for modifying or adding personal information when a contractor is hired or rehired to work at the US Census Bureau.

VACO RICHMOND RICHMOND, VA 11/10-12/10

Data Warehouse Developer Consultant

Consultant at UPS Freight.

Utilized PL/SQL, COGNOS, and TOAD for creating and maintaining ad-hoc reports.

Created reports for reporting multi-stops and one-stop runs for drivers.

CIGNA DENTAL SUNRISE, FL 05/08-11/10

Sr. Applications Development Specialist 05/09-11/10

Sr. Applications Development Specialist Consultant with Modis Inc. 05/08-05/09

Responsible for modifying applications utilizing Forms 6i and 10g and migrating them to 10g.

Created new ability for ordering directories online via the eService application for mailing pdfs.

Utilized PL/SQL and SQL to develop and modify Oracle packages, procedures and functions for new Network Segmentation for Customer Relationship Management (CRM) ERP system, eService projects with interfaces to .Net application, Explanation of Benefits and DHMO Checks system.

Utilized SQR, Perl and Shell Scripting in a UNIX environment for reporting and data manipulation.

Utilized Hyperion SQR Production Reporting tool for creating SQR reports for Customer Reporting Project and Interactive Reporting for creating dashboards for management reports.

Member of the Award-winning Customer Reporting Team that won an award for successful project development and implementation out of all Dental IT projects.

Completed Hyperion Interactive Reporting 9.3.1 in Designing Reports and Dashboards training.

Utilized SQL Developer, Oracle SQL*Plus, UNIX SmartTerm, Erwin, Hyperion Interactive and SQR Production Reporting in Hyperion Suite, Oracle 9i and 10g, JDeveloper 11g and Forms 6i and 10g, JD Edwards EnterpriseOne for development, performance tuning, and testing.

ROBERT HALF TECHNOLOGIES, INC. CORAL GABLES, FL 07/07-05/08

Software Engineer Consultant

Consultant at Gables Engineering, Inc.

Responsible for the migration all software and hardware product data from PVCS Tracker database to the Serena Dimensions Configuration Management software on Oracle 10g.

Responsible for determining the migration method to use in getting the PVCS Tracker product data into Serena Dimensions Oracle 10g Database.

Utilized PL/SQL and SQL to develop procedures and functions.

Utilized TOAD, TOAD Data Modeler, Erwin, and Oracle SQL*Plus for development and testing.

TRG, Inc. FORT LAUDERDALE, FL 07/06-07/07

Data Warehouse Unix/Oracle Developer Consultant

Consultant at AutoNation, Inc.

Team Lead responsible for automating and running weekly AutoNation Inventory reports for corporate executives utilizing EXCEL and VBA, SQL, Visual Basic 6.0 and .Net.

Created Reports utilizing Visual Studio 2005 SQL Reporting Services and deployed reports to the web server for Management to review online.

Utilized PL/SQL and SQL to develop procedures, functions, packages, and performance tuning.

Utilized Visual Studio 2005 Reporting Services, EXCEL and VBA, Visual Basic 6.0 and .Net, TOAD, UNIX Shell scripting, SQL Loader and Oracle SQL*Plus for development and testing in the Data Warehouse Group.

Utilized Visual SourceSafe for configuration management and version control of packages, procedures and functions, and Visual Basic and Visual Studio applications and Reports.

SYNERGY BUSINESS CONSULTANTS MIAMI, FL 04/06-07/06

Quality Assurance Developer/Analyst Consultant

Consultant at Norwegian Cruise Line.

Quality Assurance Developer and Analyst for the Data Warehouse department for the cruise line industry.

Audit all new or modified existing Oracle Packages, Procedures, Functions, and Views before promoting to production.

Utilized PL/SQL and SQL to develop procedures and functions.

Utilized TOAD, UNIX scripting and Oracle SQL*Plus for development and testing.

MOMENTUM CONSULTING MIAMI LAKES, FL 12/05-04/06

Software Developer Consultant

Consultant at Cordis Inc.

Modified existing Procedures and Functions to accommodate the data merger.

Utilized PL/SQL and SQL to develop procedures and functions.

Utilized TOAD and Oracle SQL*Plus for development.

Modified the Customer Inventory Metrics application, which acts as an ETL Tool, utilizing ACCESS, Excel, and VBA for Applications and PL/SQL for uploading data from Excel files into the Oracle 9i Database.

PARAMOUNT MARKETING CONSULTANTS FT. LAUDERDALE, FL 07/04-12/05

Project Manager-Sr. Programmer/Analyst

Project Manager and Senior Programmer/Analyst on an Oracle In-house Developed System utilizing Forms 6i, SQL, SQL/PLUS, TOAD, PL/SQL, Erwin, Data Modeler, Hyperion-Brio SQR, Form Builder and Oracle 9i.

Managed a team of consultants and overall system and systems processing for the company.

Recompiled and managed over 200 forms for the implementation of the Oracle System.

Created new application for managing tour allotments in the system for Time-share tours.

Created new application to check in guests as they check-in for tours and/or mini vacations.

Created application that automatically assigns a sales representative in the system to the guests, as they are checked-in for their tours.

Created and maintained over 200 reports using Hyperion-Brio SQR.

Created new application for managing gifting, accounts receivables, and daily register management.

FLORIDA CAREER COLLEGE MIAMI, FL 10/01-07/04

Instructor

Oracle Certified instructor who instructs all Oracle Development courses; Including, Oracle SQL and PL/SQL, PL/SQL Program Units, Build Internet Applications I and II or Forms I and II, and Oracle Reports.

Instructs Microsoft Office Applications consisting of EXCEL XP, WORD XP, ACCESS XP, POWERPOINT XP, OUTLOOK and other courses including VBA, Visual Basic .Net, ASP.Net, SQL Server 2003, Internet Fundamentals and Fundamentals of Math.

Received excellent instructor evaluations from students.

Instructor of the Term for the Fall B 2002 Term at Florida Career College.

TEKSYSTEMS MIAMI LAKES, FL 04/02-08/02

Consultant at Applica, Inc.

Senior Programming support for modifying programs for the New Data Warehousing project for online and batch systems.

Completed analysis of system to create system documentation for Data Warehousing project.

Utilized Microfocus COBOL, UNIX, INFORMIX, SQL, SAS, Crystal Reports, and shell scripting programming.

AMERICAN INTERCONTINENTAL UNIVERSITY WESTON, FL 07/01-08/02

Adjunct Faculty member who instructed Bachelor of Information Technology degree program course, Oracle SQL and PL/SQL utilizing SQL, PL/SQL and SQL PLUS 8.0.

Received excellent review of course from students and faculty department head.

Instructed Master of Information Technology degree program courses Beginning Oracle-Data Modeling and SQL and Oracle Forms and Reports utilizing SQL, PL/SQL and SQL PLUS 8.0.

UNIQUE MERCHANT SERVICES, INC. MIAMI, FL 04/01-03/03

Consultant for the CEO/President of the company and developed business plans and created contracts for the deployment of business.

Created numerical analyses for target market analysis for the pre-paid ATM, debit and phone card aspect of business.

Oversaw and assisted any new business projects and provided consulting support where needed.

VITAL COMPUTERS FT. LAUDERDALE, FL 09/00-01/01

Consultant at Compaq Computers, Inc.

Web Developer for developing and managing website for Compaq Latin America for the Customer Service Managed Services division. Developed sites in English, Spanish and Portuguese.

Developed website for Country Managed Centers for Compaq four main Latin America Centers, which are: Argentina, Brazil, Colombia, and Mexico. Also developed Houston and Puerto Rico sites.

Utilized Frontpage, Dreamweaver 4.0, HTML, ASP, ADO, JavaScript, C++, SMS 2.0, MSSQL Server 7.0, Photoshop, Paintbrush, Internet Explorer to develop and manage website.

AMERICAN CONSULTING NETWORK BOCA RATON, FL 06/00-09/00

Consultant at Cynocom, Inc.

Developer for maintaining the DB2 Universal Database for new Internet based, knowledge managed product called IASYST.

Created Stored Procedures for improving efficiency of data access. Incorporated the stored procedures, which are written in Java once compiled into HTML programs using Java Server Pages. Utilized DB2

UDB Version 6, HTML, JAVA, JavaScript, Java Server Pages, Star Team, C++ and DB2 Stored Procedures.

MAXIM GROUP MIAMI LAKES, FL 05/99-05/00

Consultant at Windmere/Applica Inc.

Senior Programming support for Data Warehousing, manufacturing order entry and inventory systems for online and batch systems utilizing Microfocus COBOL, UNIX, INFORMIX, SQL, SAS, Crystal Reports, and shell programming.

Utilized Visual Basic, ActiveX, and SQL to create an adhoc application for the CIO of the company for observing Salesman data down to an item level.

Developed new programs for new order deposits, inventory and Data Warehousing.

EDUCATION:

Doctor of Information Technology

Walden University -Online Expected completion 07/2017

Master of Information Technology

American InterContinental University Westin, FL 12/2000

Bachelor of Business Administration – Computer Information Systems major

North Carolina Central University Durham, NC 5/1989

ADDITIONAL INFORMATION:

Oracle Certified Administrator - OCA

Oracle Trainer

Contact this candidate