Designed, developed, and administered Sybase SQL ASA database. Designed application to collect and maintain registration contact information of Band Alumni. Incorporated backup, recovery, user security, data manipulation via triggers and stored procedures. Obligation includes ongoing support of all maintenance phases, mailings, reporting, and reconciliation of database. Organization founded in 1999 to support the Florida A&M University Bands.
Maintained, developed, mentor of team members, and user training of new system functionality for financial security trading applications. Modification of 6 applications deployed across NT network with individual integrated frameworks. Reverse engineered all databases to produce schema for database modifications and documentation using PowerDesigner. Internal code of stored procedures, DataWindows and application modified per user request.
Role: Jr. DBA / Sr. Lead Technical Analyst / Mentor
Skill(s): Sybase AIQ, ASA, ASE, PowerBuilder6.5, PFC, SQL, Windows 95
Developed marketing application to collect and report on specific demographic areas for campaign distribution. Revolutionary process developed to reduce internal billing of application maintenance through use of framework. Completed data repository re-design, conversion of interface support, additional modification of 200+ DataWindows, requirements gathering for initial and additional development, use of pipelines and stored procedures for data conversion. Auxiliary application written to support initial data load. Mentor to junior personnel.
Principal consultant to develop client/server application supporting freight tracking and reporting for management and dock personnel. Created framework and corporate layer, designed interface and business objects, tasked to research and develop distributed computing system, architectural structuring/re-structuring, performance tuning, coding, foundation and class implementation, and participant in corporate enterprise solutions. Implemented service-based window manager to expedite MDI window interface (author). Mentor and trainer to junior members of project team.
Partner alliance to provide innovative state-of-art system for state wide health facilities. Designed, developed, and administered database. Incorporated backup, recovery, user security, data manipulation via triggers and stored procedures. Written to support multiple databases with generic front-end access. Managed product development, quality control, physical distribution, product and packaging design, design interface and coding, created application class foundation and framework.
Developed HeaTreat process management system, a client/server application supporting multiple databases. Responsible for coding several application and administrative components for customer quotes, order entry, processing, scheduling, furnace operation and reporting. Recording real-time processing values of treated parts required complex SQL joins and unions. Object usage included DataWindows, tabs, treeviews, manipulation of dataobject attributes, and PFC functionality. Mentored to junior members of project team.
Development team effort to create multi-user client/server application, Preliminary Arraignment System. PARS consist of several interfaces; integrated in a WAN environment, developed for the DA's office, Philadelphia Police districts, and Municipal court system. Using 60+ tables, PARS tracks defendant, biography, and arrest information. Responsible for all report functionality both canned (official court documents) and ad-hoc (administrative), report maintenance and criminal verification interface. Implemented non-visual objects for SQL(dynamic, non-dynamic, and DataWindows oriented) and other generic user and data manipulation.
Principal developer for client/server development of Main Leaks and Services application. System provides tracking of city wide new and repaired pipes. Designed framework for MDI application utilizing non-visual objects and object inheritance. Developed system flow for data entry, reporting, and data tracking. Responsible for installation, upgrades and troubleshooting various components of application and database interface.
Role: System Integrator / Sr. Lead Technical Analyst
Skill(s): TimeLine, Dun & Bradstreet Information Expert, MVS Environment
System integrator of Choice Plus Benefit Plan for management employees. Successfully implementation of application accomplished via utilization of test transactions and client reports using IE. Responsible for analysis, requirements gathering, unit and system testing of payroll and personnel programs, data integrity via third party and internal sources. Trained employees to use methods put in place for third party data transfer, uploads, and data loads to main system.
Learned use of objects and object-oriented methods to provide analysis/design/development in a client/server environment. Constructed a variety of applications to utilize PB objects. Designed, developed, and administered ODBC-Watcom database, created demographic/inventory reporting application using bar-code interface. Modeled database, system functionality, framework, and non-visual objects for SQL access. Attended Advance PowerBuilder classes to facilitate existing developed skills.
Senior consultant provided analysis, coding, unit testing, and preparation of test plan and documentation for conversion of Medicare system. Provided mentoring to senior & junior team members of mainframe.
Skill(s): DB2, SQL, MVS Cobol II, SPFPC, Windows 3.x
Provided analysis, documentation, and coding for major conversion of Nynex, Rockwell, and Westinghouse client employee defined benefit system. Provided enhancements and support to existing system.
Role: Business & Technical Analyst / Jr. DBA / QA / Mentor
Skill(s): DB2, SQL, XDB, Microfocus Cobol, MVS Cobol II, Dialog Manger, ISPF, REXX, CLIST, JCL, Windows 3.x
Completed full life cycle development (analysis, design, coding, testing, implementation, conversion) for two Treasury Department systems (Reporting and Receivable, and Financial Accounting). Used Microfocus Cobol and XDB for initial batch development. Expert in coding dialogs panels, JCL skeletons, REXX execs. Provided user support for production and acceptance testing and system migration. Created documentation for trainers, documented and presented system test plan for Reporting and Receivable to senior directors. Created and loaded (via DB2 utility) data for test plan scenarios for end-user limited production testing. R&R collects and generates reports (at various government levels) for government receivable data (Direct and Defaulted Guaranteed loans, and Non-credit). The Financial system designed to receive adjusted trial balances from the entire government and convert them into consolidated financial statements (at various government levels).
Performed analysis, coding, and testing to produce reports and documents on 9790 Xerox Electronic printer for Child Welfare and Enforcement systems. Created system jobs for formatted data to merge with dynamic forms and graphic data. Produced user analysis documentation for new system interfaces. Mentored other members regarding mainframe skills.
Maryland Institute
for Continuing Professional Education of Lawyers
Role: Sr. Technical Analyst (sole developer)
Skill(s): Clipper 5.x, Dbase III, Windows 3.x
Provided analysis and development for three integrated Clipper-based systems (Mail List Generation, Merge process, and Target Collection) in a LAN environment. The systems provide educational programs, materials and course registration for attorneys. These systems were written to collect client address data for specific target mailings, select existing mailings for database (contents) merging, and gather information used in other sub-systems for statistical analysis. Incorporated several Clipper functions for array processing, screen and file creation (DBF and ASCII), edit criteria, and query (DBFs) criteria to accomplish user tasks. Provided on-going system maintenance and support.
Executive Office of
the President Office of Management and Budget
Role: Business Analyst / Sr. Technical Analyst
Skill(s): LBMS Case Tool, MS Word, DB2, SQL, MVS CICS, MVS Cobol, JAD, RAD, DFD
Developed high-level functional requirements, evaluated end-user software, performed analysis, coding and integration testing for the following: Budget Preparation System, Central Budget Management System, Office of Information Regulatory Affairs, and the Regulatory Information Service Center systems. Converted existing Model 204 and VSAM systems to DB2.
Researched, documented and presented plan addressing DB2 production implementation issues. Documented DB2 requirements and functional areas; based on industry standards; to provide sufficient information for the government to make decisions about processing, database back ups, security, system interfaces, etc.
Constructed data flow diagrams (LBMS), documented high-level requirements (current and desired) for all systems, researched architectural alternatives (hardware/software) that would facilitate user needs for re-engineered systems (OIRA and RISC). Participated in JAD and RAD sessions.
Evaluated end-user support tools (data entry, query, report writer) for multiple platforms. Developed method for evaluations to summarize, score and recommend support products. Integrated DB2/Cobol II conversion programs for BPS production environment.
Consulting-manager responsible for supervising team members in the Customer Management System Department working on the Customer Order Registration Entry projects in a multi-center environment. Performed analysis, design, development and maintenance for new system releases. Responsible for major enhancements and development to the following online systems: Customer Hierarchy, Location and Service Level Billing, Portfolio [multiple product invoicing], Information Product Specifications [on-line reporting] and Product Line. CORE provides account management for commercial customers with shared and/or dedicated access products.
Responsible for analysis, design and coding of all enhancements to Location and Service level on-line invoicing process. Other duties included project tracking, system documentation and problem resolution of production, test and acceptance regions. Participated as liaison for new customer support team for Finance answering questions pertaining to the hierarchical structure of CORE.
Skill(s): DB2, SQL, MVS Cobol II, JCL, CLIST, VSAM
Developed report programs for new Claim Management reporting system. Documented programs, job procedures, and ad-hoc user reports for acceptance and production. Developed test cycles scenarios for daily, weekly, monthly, unit testing and ad-hoc jobs. Devised match/merge process to produce management reports from DB2. Established new download procedures to produce reports for Actuarial Department.
Skill(s): AT&T Unix, MVS Cobol, MVS CICS, Microfocus Cobol II, IBM Series/I, Easytrieve Plus, Xerox 9700 Imaging Printer
Analyzed, coded, tested, and implemented Retail Lease New Business and General Ledger system. Re-wrote report applications for financial systems. Converted 30+ IBM Series/I on-line Cobol programs to AT&T UNIX. Created user and system documentation, file layouts, screen processing and system interface for production file transfers. Built formatted output and special forms merged with graphic data using Xerox's Imaging software.
Supervised, administered, and coordinated tasks for Corporate and Overseas Warranty batch and online systems. Responsible for system rewrites, unit and system testing, documentation, project implementation, production support, maintenance, development, and system conversions. Mentored new employees on standards and procedures. Developed and implemented Dealer Communication System to parse, change, delete transactions, and send acknowledgement of claims for transmission to dealers. Established pre-production system testing procedures using transmitted data.