David Coleson Email & Phone Number

Oklahoma City, Oklahoma

• Created repositories for and populated with project management and architecture diagrams• Worked with Vendors and Compsource technical groups to resolve processing problems• Performed weekly deployments • Monitored weekly progress and status via Rally • Proposed new processes and controls to improve work through-put • Technologies: Cognos, Oracle, SAP BODS • Modified reports and confirmed results with business customers

Boston Ma

Overhauled the design and code of existing dashboards, graphs and reports to provide accurate and user-friendly customer reports. Established and incorporated standards in the form of style sheets, print-formats, drill-downs; developed common report components and user-defined functions to create a reporting application vs. a set of standalone of reports.Enhanced SQL and report code to optimize response and performance times to set the stage for establishing SLA’s.Established procedures to test the accuracy, quality and reliability of the report outputs.Resolved configuration problems and greatly reduced the number of outstanding backlog issues.Developed new reports, graphs and dashboards.Technologies: WebFOCUS 7.7.05 & 8.05, HTML, JavaScript, MS Office Suite, Oracle 11

Provided project management and business analysis for numerous projects; integrated SQL Server\DB2 Data for reporting which allowed Store Operations to re-engineer reporting metrics, and Accounting to establish reconciliation controls for credit card processing and collections.Developed reporting applications for Human Resources and Credit Card Reconciliation. Performed a Business Area Analysis (Business Process Improvement) for the P&L process and delivered a proposal to eliminate risk and improve the processes.Established and cultivated technical vendor relations and provided statement of work for services provided by vendors.Gathered requirements and created system documentation.Technologies: WebFOCUS 7.7.03, ETL, IIS Webserver, Cognos, Report Writing, SQL Server, Data Integration Tools I-Way Data Quality Center, I-Way Service Manager, MS Office Suite.

Dallas/Fort Worth Area

Developed a dashboard to allow FDIC Management to monitor and measure agency progress for Closed Banks and provide congressional regulatory Information.Technologies: WebFOCUS 7.6.11, Oracle, MS Office Suite

Developed Business Intelligence solutions in the form of Dashboards, ETL procedures, HTML pages, and Reports at customer sites. Mentored and assisted customers on software implementations, IBI tool suites and problem debugging.

Developed a WebFOCUS self-service web reporting system application consisting of WF Reports, Graphs, and web pages to support Oklahoma Child Welfare Services to meet federal regulations and compliance. Resolved development issues such as 508 Compliance, configurations and Oracle interfaces. Coded and tested the application, helped customer resolve licensing issues. Technologies: Oracle Star Schema Data Structures, Tomcat, WebFOCUS V7.8.

Managed requirements for network/hardware/OS/software migrations from HP PA-RISC to HP Itanium processors for the Federal Employees Payroll System. The migration also consolidated operations from many to one central data center. Developed a web reporting system, porting and transforming data into an Oracle DB- UNIX server, then building web reports with that information using Data Migrator and WebFOCUS. Managed customer relations, expectations, and provided solutions for new business requirements. Implemented a "Production" aircraft maintenance reporting system that allows Air Force personnel to manage the AMC fleet worldwide, via a browser connection (vs mainframe). This was especially useful to support the Iraqi war effort. Technologies: JavaScript, DHTML, I-Way ETL, II's Webserver, WebFOCUS, Oracle 9i/10g, Windows NT and Sun Unix. Managed a team of software developers. Implemented software processes for project planning and tracking, management reporting, and configuration management. Introduced software Lifecycle, and project management controls into the development environment in support of the USAF ACPINS application.

Re-engineered the business process and the technology platform of the Asset Tracking and Disposal Application from a mainframe to a client server platform. Produced a business requirements document and associated matrices, managed change control, worked with customers to define test case scenarios, presented a technical design phase and list of deliverables. Technologies: PowerBuilder 7.0, Oracle 8I, OSSP, (the Air Force version of CMM), Framework (predefined Objects & class libraries).

Implemented the Ernst and Young project management methodology product, Navigator AME, in Fleming Companies' I/T environment; assist management associates in the principles of project management and system development life-cycle concepts; duties of an internal project management consultant. Published Project Management Guidelines, implemented client/server architectures, introduced Capabilities Maturity Model concepts, gained approval for associate PMI certification training, implemented customer service level agreement, performed a Project Management "GAP analysis". Technologies: Navigator AME, Microsoft Office 95 & 97, Novell LAN, Windows 95, Oracle 7.3 NT Server, Capabilities Maturity Model.

Lead a team of three analysts to identify and document the business requirements for the Aircraft Management Information re-engineering project at the FAA. The effort was on an international scale. Implemented CASE technology and management procedures for the project, documented current and future requirements for five functional business areas, developed project plans and schedules, consulted with FAA management personnel, captured requirements using the techniques of JAD, Process and Data Modeling, published business requirements document. Technologies: CASE, ORACLE, PowerBuilder, ADABAS/Natural, Information Engineering.Kerr

Managed software development project teams, participated in the implementation of new software development tools and techniques; developed technical designs, coded, tested and implemented software solutions for business needs. Delivered a Natural Gas Operations and Accounting System consisting of over 2,500 modules and that supported four functional business areas. Delivered an EDI credit invoice system. Delivered a systems analysis of the Refining Accounting System in preparation for re-engineering. Piloted CASE tool code generation; and repository tool management techniques. Established development processes and guidelines for the implementation and use of ADABAS/Natural. Upgraded release versions for ERP financial software GL, AP and Fixed Assets. Technologies: ADABAS/Natural, CASE, Microfocus COBOL, DB2, CICS, Information Engineering, Structured Analysis & Design.

Supported the bank's marketing staff by providing technical designs and programming to convert acquired banks for the First National Bank and Trust Company. Major accomplishments included the conversion of 47 acquired banks to the First Data software Florida Software (ERP), Commercial Loans and CD applications. Performed legacy conversion to new commercial loan system (Florida Software ERP; supported multiple bank conversions for the FDIC bank closures. Technologies: COBOL, XPF COBOL, IMS DB/DC, VSAM

Provided programming and technical designs to maintain production financial applications. Reduced the processing time for the general ledger month-end run by 66%. Technologies: COBOL, IMS, Configuration Management.

Provided system consulting, technical designs and programming for production claims processing at Blue Cross/Blue Shield of Western New York. Automated Dental Claims processing system. Auto Workers claims processing, performed Time Motion Studies, and supported the Claims Processing Staff. Technologies: COBOL, Assembler, JCL, IBM Mainframe Utilities