Darrell Coffee Email & Phone Number

Microsoft SQL Table-Value functions, SSRS Bank Industry Survey project.

Have received Unisys ‘Silver Performance Recognition’ awards.Listing of Full life cycle team projects were I performed database architecture, SQL programming, majority of SSRS Reports, and SSIS integration of national data warehouse with region 4’:• Financial Charter Budget Tracking Tool – large application for consolidated tracking ofproject Appropriations, Commitments, Obligations, and Planned Obligation funds.• Regional Associates Training Database – Courses, Training schedules, CE credits.• Service Center Building Maintenance – Tool for tracking building maintenance duties.• Occupancy Agreement Log – tracking tool for government lease changes and signatures.• Federal Executive Board Website - Public and Administrative web sites.• Billing Data Accuracy – Excel analysis and reporting project.• Continuing Operations (Emergency COOP) Inject (MS Access / VBA application)• Inventory Reporting Systems --MS Access/VBA interfaces with ‘Unicenter Software’• Asset Performa – Federal Owned and Leased properties Asset Planning Compiler, Analysis • E Ovation – an awards, certificate based storefront web application. • BIS Mirror Administrator – A Central Office ‘Business Information System’ data warehouse.• Work with Lotus Notes team providing structural and database assistance.

• Information Technology experience covers 18+ years.• Systems Analysis includes communication with government clients to gather and documentProject requirements, updates, and maintenance, with available resource considerations.• RDMS Database proficiency includes Database Architecture -- normalized for integrity and efficiency,T_SQL Programming -- queries, stored procedures, user-defined functions, Views, SQL Agent Jobs, database triggers; SSRS Reports for projects including links, Charts and Graphs..• Use BIDS (Business Intelligence Development Studio) for SSRS (SQL Server Reporting Services), • Used SSIS for ETL Region 4 mirroring of national data warehouse, project test data.• Team leader for providing SSRS reports employing advanced features, including Ad-Hoc reports, URL hyperlinks, drilldown, custom expressions, charts and graphs• Working knowledge of Microsoft .Net Framework and development. Skills include building Microsoft Solution Framework, in a full life cycle, team environment.

• SQL Server 7 / 2000 Database Administration. Data Warehouse architecture and design, Data Transformation (DTS) from multiple OLTP systems.• Monthly reporting: current and historical Sales, product inventory, advanced Accounting and Financial data, Marketing Analysis, Sales Commission and Bonus reporting. Optimized load with VB6 applications and Stored Procedures. Heavy Ad Hoc, T-SQL reporting requirements. Reporting via Crystal Reports, MS Excel and MS Access.• Created “Sales Data Central” application allowing Sales Reps and Region Managersto download current weekly and monthly reports from the Data Warehouse websiteto laptop computers: Server staging with VB6 and T-SQL; Client side Access/VBA.• Developed “IT Time Tracking” for managing IT projects and tasks involved in the ERP conversion and E-Business development at Graham-Field, stakeholder approved requirements were tracked to requesting departments.• Provided web maintenance for GrahamField.com and company intranet.• Project Leader for .NET projects (Look-and-Feel Committee Leader and E-Commerce integration) ASP.NET-VB, ADO.NET.

Obligation funds.Regional Associates Training Database - Courses, Training schedules, CE credits.Service Center Building Maintenance - Tool for tracking building maintenance duties.Occupancy Agreement Log - tracking tool for government lease changes and signatures.Federal Executive Board Website - Public and Administrative web sites.Billing Data Accuracy - Excel analysis and reporting project.Continuing Operations (Emergency COOP) Inject (MS Access / VBA application)Inventory Reporting Systems --MS Access/VBA interfaces with 'Unicenter Software'Asset Performa - Federal Owned and Leased properties Asset Planning Compiler, Analysis E Ovation - an awards, certificate based storefront web application. BIS Mirror Administrator - A Central Office 'Business Information System' data warehouse.Work with Lotus Notes team providing structural and database assistance.; MS SQL 2000) / Web manager (VB.NET/ASPX)SQL Server 7 / 2000 Database Administration. Data Warehouse architecture and design, Data Transformation (DTS) from multiple OLTP systems.Monthly reporting: current and historical Sales, product inventory, advanced Accounting and Financial data, Marketing Analysis, Sales Commission and Bonus reporting. Optimized load with VB6 applications and Stored Procedures. Heavy Ad Hoc, T-SQL reporting requirements. Reporting via Crystal Reports, MS Excel, , and MS Access.Created "Sales Data Central" application allowing Sales Reps and Region Managersto download current weekly and monthly reports from the Data Warehouse websiteto laptop computers: Server staging with VB6 and T-SQL; Client side Access/VBA.Developed "IT Time Tracking" for managing IT projects and tasks involved in the ERP conversion and E-Business development at Graham-Field, stakeholder approved requirements were tracked to requesting departments.

Presented and supervised company's I.T. systems and services to clients.Full life cycle applications project planning, management, and development.Provided MS Visual Basic 6.0, T-SQL, Oracle Developer 2000, PL/SQL, and MS Access/VBA programming in various fiber design projects.; Sponsored 'Lawrenceville Java Users Group' as part of AJUG (10 months study group)Compass -- R.O.A.D. Systems Manager (Relational Operations Address Database)ROAD links Digitized drawing file addresses to an Oracle database. The Addresses are set to US Postal Service standards and emergency 911 requirements (VB6). The System Address file and client's Billing files are reconciled. The process visually links HFC (Hybrid Fiber Cable) System to customer's can-we-serve, marketing, and other relational database applications.Provided original ROAD System design, architecture, and programming (PL/SQL -VB6). Directed Microstation 95 C programming to link CADD drawing files to Oracle 7.3 database (migrated to Microsoft SQL Server 7.0)Served as Database Architect and Administrator for all Focus1/Microstation 95 projects. Supervised Address Database Profit Center, Two Shifts, 8 Operators.

Bba, Accounting

As, Computer Information Systems