Objective

I aspire to be associated with a company that can benefit from more than15 years of analytical, research, and software programming experience. I continually seek growth as a knowledge consumer while developing effective and efficient tools to meet business requirements. I thrive best in a collaborative environment.

Summary

Descriptors used by past managers and co-workers about this candidate: Go-to person, analytical trouble-shooter, an internally motivated and organized team player, flexible, open to suggestions, reliable employee who efficiently handled deadlines and multiple projects with minimal supervision friendly, eager to learn and goal oriented.

Technical Experience

• SQL, T-SQL, PL/SQL
• DB2 5 years , Informix 2 years , Oracle 7 years , Sybase SQL Server 3 years ,
• MS SQL Server 1 year , SQL Anywhere 2 months , PL/SQL 5 years
• Producing SQL results for application/reporting purposes
• Data conversion Nissan Motor Acceptance Corporation
• 2 and 3-tier Client Server Development
• Object Oriented Programming OOP
• PowerBuilder v.3.0 - 12.5, with PFC
• Info-Maker/Crystal Reports DB Management Report Writing
• Unix Shell Scripting Korn Shell Script Development and scheduled Cron jobs
• Interacting with management and users to identify and resolve business systems issues.
• Computer-based Training Development Air Force Starlifter
• QuickBooks

• R statistical computing language continuing personal growth
• Haskell language continuing personal growth
• SQL Server IIS DTS

Experience

Confidential

CGS Industry: Healthcare : Used SQL Server Integration Service SSIS to modify/deploy ETL packages to validate, extract, transform, and load data from heterogeneous sources Excel, CSV, Text file to data mart databases. Created tables, stored procedures, functions using T-SQL to map data from the data mart to various reports. Tools: MS SQL Server 2008, SQL Server Management Studio,SQL Server Integration Service SSIS , and SQL Server Import Export Wizard.

Confidential

Programmer/Analyst

MARCS Michigan Accounts Receivable Collection System : Created, modified/enhanced and maintained PL/SQL stored procedures and shell scripts linked MS Word to PowerBuilder using OLE, and revised corporate reportss. Tools: PowerBuilder 10.5, HP-UX, Crystal Reports, SQL Developer, and Oracle 11G.

Confidential Petroleum Distribution Software Development Consulting Industry: Petroleum

Created, maintained, modified/enhanced various sections of the Visual Supplier business application and reporting system. Tools: PowerBuilder 12.5 and

SQL Anywhere 11.

Confidential

Programmer/Analyst

AgriSoft. Created, modified, maintained various sections of the AgriSoft business application and reporting system. Tools: PowerBuilder and InfoMaker 10.5, PFC Class Library, PL/SQL, and SQL-Station with Oracle 10G and IBM Rational Rose ClearCase as the software configuration management tool.

Confidential Business Process Outsourcing and Information Technology services Industry: Healthcare

• MS Envision Mississippi project : Developed, maintained/enhanced and supported new functionality for a 3-tier Medicaid Information application. Tools: PowerBuilder 10.5, EAServer 5.50, and IBM DB2 as the DBMS
• DC OmniCaid District of Columbia project : Developed, maintained/enhanced and supported new functionality for a 3-tier Medicare/Medicaid Information System. Tools: PowerBuilder 10.5, EAServer 5.50, IBM Rational ClearCase, and IBM DB2 as the DBMS.
• TennCare Tennessee project : Analyzed, recommended enhancements, developed, maintained and supported the Medicare/Medicaid Information System and stored procedures. Tools: PowerBuilder 8, IBM Rational tools ClearCase, ClearQuest for takeover by ACS, MS Office Visio, SQL PL/SQL.

Confidential

• Election Systems Software Industry: Politics : As part of a team, I worked on the development of a repository system that captures historical election data for future viewing. Tools: PowerBuilder 9, Toad for Oracle 9.1, Oracle 10G and PL/SQL Oracle's Label-Based Access Control LBAC to create statistical election reports working in a SCRUM environment.
• Modified/enhanced various modules within the PowerProfile Voter Registration Application. Tools: PowerBuilder 9, Oracle 10G, and Toad.

Confidential

• TN Department of Children Services Industry: Healthcare : Enhanced/migrated the TnKids Tennessee child welfare program application from PowerBuilder 8 to PowerBuilder 11. Tools: Powerbuilder 8 11, EAServer 4.2 to EAServer 6.1 Oracle 10G as DBMS.
• Developed and maintained modules for a 3-tier application, TnKids, and the web client, SAT Service and Appeals Tracking . Tools: PowerBuilder 8, EAServer 4.2, Oracle JDeveloper 10g, JavaScript, SQL Oracle 8i as DBMS.

Confidential

Confidential

• Managed a team that supported and maintained various projects, including the Product Service Management System, PSMS, which interfaced between the corporate team and the service centers around the country. Tools: PowerBuilder 9.0, SQL with SQL Server 2000 as DBMS. The PSMS application contributed 25 to RAC annual gross income.
• Created and developed a system for delivering product reports and ad hoc reporting capabilities to service center management. Tool: InfoMaker.

• Interfaced with the Project Manager, management team and users regarding project scope, defining timelines, business rules to enhance the PSMS application.
• Converted a DOS Clipper based Service Order system to PowerBuilder 9.0 SQL Server 2000 as DBMS.

Confidential

• Interacted with management and users to define requirements toward the development of a management reporting application. Tools: Oracle's fine-grained access control structure and PowerBuilder 7.0
• Modified/enhanced performance tuned database objects on Oracle 9i using SQL Navigator 4.1 and PL/SQL

Confidential

• Interfaced with Subject Matter Experts and management regarding project scope,
• deliverables, application requirements and business rules
• Migrated/enhanced the Gas Management application, including the creation of a tool for the inter-application communication process within the integrated gas management system. Tools: PowerBuilder 5.0 PowerBuilder 8.0

Confidential

Created and modified reports for a loan servicing application. Tools: PowerBuilder 6.5, APOL class library, Crystal Reports, and PL/SQL with Oracle 8i as DBMS

Confidential

Chase Manhattan Industry Financial : Installed GetAccess software in the Solaris OS. Components consisted of CORBA services, JDK 1.1.7 and Oracle 8i

Developed, maintained, and supported various in-house applications for NTSC. Tools: VB 5.0, PowerBuilder 6.0, the PowerBuilder Foundation Class library and Sybase 10

Confidential

• Migrated the gas management system application. Tools: PowerBuilder 4.0 to PowerBuilder 5.0. Transitioned the 16-bit Win 95 Windows SDK calls from the application to a 32-bit Win NT environment. MS SQL Server 6.5 was used as the DBMS
• Defense : Developed a Group Forecast application. Tools: PowerBuilder 5.0, the PowerBuilder Foundation Class library and DB2 InfoMaker management reports
• Converted the Dealer Information System DIS application from MicroFocus Cobol and DB2 to PowerBuilder 4.0 and Sybase System 10. Utilized Sybase Power Designer to define, analyze, and map the data conversion process to meet the business requirements of the client server Dealer Information System
• Industry: Energy Services : Developed the Management Control System MCS for tracking human resources. Tools: PowerBuilder 4.0, PFC, and DB2 as DBMS

Confidential

Developed and maintained/supported new functionality for the Bus Operating Support System BOSS . Tools: PowerBuilder 3.0 and Sybase SQL Server 4.2 Created and modified AIX UNIX shell scripts and scheduled Cron jobs

Confidential

• Designed and developed multimedia computer-based and lecture-training systems for the Air Force C-141 project. Tools: Authorware, Sage, Visio, and Informix as the DBMS
• Proofed and revised instructor-based products consisting of both text and graphics