SKILLS SUMMARY

Business Analysis/Design: 10 years

Client/Server: PowerBuilder 12.5 12 yrs PFC 3 yrs Jaguar 3 mos.

Database: SQLserver 9 yrs Oracle 3 yrs Sybase 3 yrs DB2 2 yrs

Database Programming: SQL 17 yrs Transact-SQL 11 yrs PL/SQL 3 yrs

Data Modeling: 2 years Erwin 3.5 2 yrs PowerDesigner 1 yr

Project Management: 7 years Supervised up to 16 I.T. Professionals

MS Project 5 yrs Project Workbench 2 yrs

Web Development: 6 years Cold Fusion MX 6 yrs Dreamweaver 3 yrs

HTML 6 yrs Javascript 1 yr Crystal Reports 1 yr

HIGHLIGHTS OF ACCOMPLISHMENTS

• Received Management Award for saving company hundreds of thousands of dollars at A.C. Nielsen
• All enhancements were completed on time and accurately in a very time sensitive legal environment at Complete Claims Solutions
• Completed integrated ordering, inventory control, shop floor, packaging, and scrap management system that greatly improved accuracy and control of sensitive material processing at Sennett Security

WORK HISTORY

Confidential

Role: Oracle DBA/SQLserver Developer

Completed numerous enhancements and fixed several defects in five Powerbuilder applications that are at the core of the business. Modified both SQLanywhere and SQLserver databases. Created more than 50 stored procedures and modified nearly as many.

Confidential

Role: Developer/Technical Lead

Enhanced and solved technical issues for patient information system using PowerBuilder 12.5. Provided technical direction to junior team members and provided architectural direction to management and team. Created several web service datawindows. Designed and created several SQLserver tables with indices to implement to application features.

Confidential

Role: PL/SQL Developer/Oracle DBA/SQLserver Developer

Maintained Oracle PL/SQL stored procedures and packages. Assisted junior team members with writing SQL. Created and maintained Oracle databases 10g including backups and restores. Maintained security for Oracle and SQLserver databases. Created several SQLserver 2005 databases. Created several web sites and connections to SQLserver. Modified several SSIS packages. Created over 30 FTP and SFTP sites.

Confidential

Role: Developer

Migrated a PowerBuilder 11.5 application from Sybase ASE to Oracle 11g. Re-wrote hundreds of embedded SQL and dynamic SQL objects. In addition, created/modified many stored procedures in PL/SQL that were not correctly migrated to Oracle.

Confidential

Roles: Business Analyst/Developer

Analyzed, Designed, and prototyped enhancements for Global Sourcing system enhancements. Developed many new screens and modified several existing programs to various Merchandising applications using Powerbuilder and PFC e.g. GSS, Dashboard, POM, PO Modeling . Wrote many Oracle and DB2 SQL queries to analyze data.

Confidential

using PowerBuilder 10.5 in a time critical environment. Also, created and modified tables, triggers, indices, and stored procedures using SQLserver 2005 in DEV and TEST environments.

Confidential

Roles: Technical Lead/DBA/Data Modeler/Business Analyst/Web Developer

Planned and Scheduled all tasks and milestones for the IMPACT project and managed client expectations. Performed all analysis and design and created Requirements and Technical Design documentation along with prototypes. Designed database using SQLserver Data Modeling tool.

Functioned as DBA to create database, tables, indices, triggers, constraints, and stored procedures. Developed all web based programs for IMPACT using Cold Fusion MX, HTML, Dreamweaver MX, and Javascript. Created hundreds of stored procedures using Transact-SQL and maintained the client's Distribution system using Powerbuilder 7.

Confidential

Roles: Technical Lead/DBA/Data Modeler/Programmer Analyst

Planned projects, developed Requirements documentation, and created data model diagrams for 4 new web sites. Developed web pages using Cold Fusion MX, HTML, Dreamweaver MX and Javascript. Wrote all stored procedures to interface with SQLserver 2000 and functioned as DBA for each web site's database i.e. schedule backups, maintain security, and performance tuning .

RESULTS: All projects completed successfully and on time.

Confidential

Roles: Programmer Analyst/DBA

Completed performance enhancement and maintained a key company system written in PowerBuilder 6.5. Functioned as DBA on SQLserver 7 database. Created customer reports using Crystal Reports.

Confidential

Role: Developer

Re-wrote Distribution system from PowerBuilder 6.0 to 7. Added capability to generate bar codes for all shipping documents.

Confidential

Roles: Web Developer/Powerbuilder Developer

Developed intranet application for Private Global Banking for customers to view statements online. Used Cold Fusion 4, Javascript, and Oracle.

Completed interface application to Mexico's central bank for sending foreign exchange transactions using PowerBuilder 7 and Sybase 11.

Confidential

Role: System Analyst/Data Modeler/Developer

Designed and prototyped system to provide tool and part information for the F/A-18. Used PowerBuilder 7 to prototype and design. Created data model using PowerDesigner. AND...

Confidential

Developed a 3-tier application to monitor county expenditures with its vendors using PowerBuilder 7, Jaguar CTS, and Oracle 7.3.

Confidential

Roles: Web Developer/Powerbuilder Developer/Database Developer

Developed several new windows using PowerBuilder 5.0.4 and the PFC as a redesign of the Earthworks application. Developed several Cold Fusion web pages and stored procedures for data access and update using SQLserver 6.5. Created data model using PowerDesigner and acted as DBA.

RESULTS: Completed project ahead of schedule.

Confidential

Role: Business Analyst/Data Modeler/Database Developer/PB Developer

Completed Functional Analysis and Technical Design for new Minority Business Development system. Created Data Model using Erwin 3.5.Developed all programs for Accounts Payable front-end and a reporting subsystem using PowerBuilder 6.5. Wrote several stored procedures using Transact-SQL Sybase 11 .

RESULTS: Successfully implemented the Minority Business Development

system on time as well as the Reporting sub-system.

Confidential

Provided Powerbuilder technical assistance to client employees for an application that was behind schedule. Used PB 6.5, OLE Automation server, and Oracle DB. RESULTS: Project successfully completed.

Confidential

Role: Developer

Developed several intranet pages for Job Application, Candidate Profile, and Job Posting systems using distributed Powerbuilder 6, PFC, HTML, Javascript, SQL Anywhere. RESULTS: Projects completed.

Confidential

Role: Developer

Developed several windows using Powerbuilder 5.1 and a class library.

Wrote over 50 stored procedures using a SQLserver to integrate Maintenance and Repair Facilities.

Roles: Technical Lead/Data Modeler/Database Developer

Planned and scheduled for new Sales Support System using MS Project.

Performed analysis and design and created all signoff documents. Created logical/physical data models using S-Designer. Developed prototypes and all windows using PowerBuilder 5 and PFC and wrote 19 stored procedures using PL/SQL.

RESULTS: Successfully completed project as new marketing tool for

company to streamline existing and create new business.