Robert D - DOC - DOC by pengtt

VIEWS: 19 PAGES: 6

									                                                   Robert D. Brunet

                                        SUCCESS PORTFOLIO
Client:                 Honeywell Technology Solutions, Inc. (AFSCN – SCNC)
Application Name:       Electronic IRON Database Change Request System (eIDCR) Phase II
Application Type:       Web-enabled Satellite Configuration Management, Tracking, and Reporting System
Development Platform:   C# / Microsoft Visual Studio
Purpose:                Web-enabled application that provides access to a centralized database accessed via a DOD secure
                        network. This application is a web-enabled Automated Remote Tracking Station (ARTS) configuration
                        management system used by satellite vehicle owners throughout the AFSCN to modify commanding
                        and telemetry settings at various tracking stations around the globe.

Client:                 L-3 Communications (AFSCN – SCNC)
Application Name:       Risk Management System (RMS)
Application Type:       Project Risk Management and Reporting System
Development Platform:   Microsoft Access 2007
Purpose:                Client/Server application that provides the SCNC Risk Management department with automated
                        tracking of all risks managed by the group. Functionality includes mitigation and contingency
                        planning, metrics gathering, parameterized ad-hoc management summary reports, and real-time
                        statusing of risks and issues stored in the system.

Client:                 L-3 Communications (AFSCN – SCNC)
Application Name:       Weekly Activity Report System (WAR)
Application Type:       Automated Weekly Activity Reporting Tool
Development Platform:   Microsoft Access 2003/2007
Purpose:                Client/Server application that provides a Systems Engineers the ability to enter Weekly Activity
                        Reports. Data and reports automatically provide management with “real-time” statusing of all projects
                        managed by HTSI within the SCNC Systems Engineering department. Additional capabilities include
                        automated generation of Microsoft PowerPoint presentations using Office automation tools.

Client:                 L-3 Communications (AFSCN – SCNC)
Application Name:       Weekly Status Report System (WSR)
Application Type:       Automated Weekly Status Reporting Tool
Development Platform:   Microsoft Access 2003/2007
Purpose:                Client/Server application that provides a Project Engineers the ability to enter Weekly Status Reports.
                        Data and reports are automatically providing management with “real-time” statusing of all projects
                        managed by L-3 within the SCNC software department.

Client:                 L-3 Communications (AFSCN – SCNC)
Application Name:       Software Change Request Form Estimator (CRF-E)
Application Type:       Automated CRF Project Development Estimation Tool
Development Platform:   Microsoft Access 2003
Purpose:                Client/Server application that provides a Project Managers the ability to enter basic parameters about
                        project activity and effectively estimate the number of hours required for completion. Estimates
                        include factors for project management, documentation, training, testing and implementation. The
                        application is supported with both tabular and graphical reports to improve long-term system efficiency
                        and management decision support.

Client:                 L-3 Communications (AFSCN – SCNC)
Application Name:       Weekly Status Report (WSR)
Application Type:       Automated Weekly Status Reporting and Tracking System
Development Platform:   Microsoft Access 2003
Purpose:                Client/Server application that provides a centralized database for weekly reporting of contract related
                        projects to Project Management personnel. The application makes full use of MS Office automation
                        including programmed email capabilities and MS Excel export functionality.
Robert D. Brunet                                     http://www.rdbrunet.com                                (719) 964-0234
IT Professional / Database Application Developer        Robert@rdbrunet.com                                     1|Page
                                                   Robert D. Brunet

                                        SUCCESS PORTFOLIO

Client:                 L-3 Communications (AFSCN – SCNC)
Application Name:       Electronic IRON Database Change Request System (eIDCR) Requirements Analysis / Phase I
Application Type:       Web-enabled Satellite Configuration Management, Tracking, and Reporting System
Development Platform:   C# / Microsoft Visual Studio
Purpose:                Web-enabled application that provides access to a centralized database accessed via a DOD secure
                        network. This application is essentially the next-generation of the application described below.
                        Additional security features were built in to the application as well as business rule logic to provide a
                        level of “artificial intelligence” to the online forms presented by the system.

Client:                 L-3 Communications (AFSCN – SCNC)
Application Name:       SCNC IRON Tracking and Reporting System (SITRS)
Application Type:       Satellite Configuration Management, Tracking, and Reporting System
Development Platform:   Microsoft Access 2003
Purpose:                Client/Server application that provides a centralized database accessed inter-departmentally by IRON
                        support personnel. This application allows users to enter IRON configuration data, submitted via an
                        IRON Database Change Request (IDCR), directly into the database system. Configuration
                        management, error checking, duplicate entry mitigation features were developed to ensure data
                        integrity. Production quality CDRL reports are also generated automatically within the system.

Client:                 Weiser Security Services (Contract Job)
Application Name:       Weiser Security Productivity Tracking System
Application Type:       Productivity and Contact Management System
Development Platform:   Microsoft Access 2003
Purpose:                Client/Server application that provides a centralized database accessed companywide via Terminal
                        Services. This application allows Sales Representatives from around the country to enter Client
                        Information Records, book Service Orders and automatically generate Weekly Production Reports.
                        Internal User Level Security was developed to allow Branch, Regional and Corporate Managers to
                        view data and reports specific to their needs.

Client:                 Krewe of Bacchus (Contract Job)
Application Name:       Bacchus Beads
Application Type:       Mardi Gras Bead and Novelty Sales Order Processing System
Development Platform:   Microsoft Access 2003
Purpose:                Client/Server application that provides a centralized database of Float Riders and Membership
                        information. Also tracks Inventory and Sales Orders of various Mardi Gras related novelty items.
                        Orders may be entered directly or through custom import utility that reads text files downloaded from
                        Client’s Internet Merchant site. Reports include Inventory Pick Sheets for warehouse distribution and
                        Summary Sales and Order Processing statistics.

Client:                 Lemmon Law Firm / NewOrleansIT.com (Contract Job)
Application Name:       Class Action Tracking System
Application Type:       Client Tracking And Reporting
Development Platform:   Microsoft Access 2000
Purpose:                Client/Server application that provides a centralized database of Clients/Plaintiffs,
                        Companies/Defendants, and Class Actions. All data is fully relational and is supported by itemize and
                        summary reports. Supported reports include Clients By Class Action; Clients By Company and sorted
                        Client Information Directory.




Robert D. Brunet                                     http://www.rdbrunet.com                                (719) 964-0234
IT Professional / Database Application Developer        Robert@rdbrunet.com                                     2|Page
                                                   Robert D. Brunet

                                        SUCCESS PORTFOLIO

Client:                 Catholic Charities Archdiocese of New Orleans (Employer)
Application Name:       S.M.I.L.E. Case Notes
Application Type:       Productivity Reporting and Analysis
Development Platform:   Microsoft Access 2000
Purpose:                Free standing desktop application that allows operators at S.M.I.L.E. Service Sites to track services
                        provided to clients and record Case Notes associated with them. This application also allows each
                        Service Coordinator the ability to report monthly and semi-annual service totals to HUD. These totals
                        are downloaded (via e-mail) to the Main Agency office for further processing and review by the
                        Administrative version of the application.

Client:                 Catholic Charities Archdiocese of New Orleans (Employer)
Application Name:       Daycare Attendance and Meal Tracking System
Application Type:       Productivity Reporting and Analysis
Development Platform:   Microsoft Access 97/2000
Purpose:                Free standing desktop application the allows operators at CCANO daycare programs to track daily
                        attendance by clients. This application also allows each program to monitor daily meal service activity
                        and report on monthly service totals. These totals are downloaded (via e-mail) to the Main Agency
                        office for further processing and review by the Administrative version of the application.

Client:                 Catholic Charities Archdiocese of New Orleans (Employer)
Application Name:       IT Department Help Desk Application
Application Type:       Support Services and Management
Development Platform:   Microsoft Access 2000
Purpose:                Comprehensive Help Desk application to provide case-based tracking of User initiated service requests.
                        This application tracks all Users, PCs, Service Requests, and Trouble Tickets and allows in-house IT
                        staff to respond by priority. Summary reports listing service related activities categorized by Priority,
                        Technician, Department and Program were also developed.

Client:                 Corporate Investigation Bureau (Contract Job)
Application Name:       Debt Management Reporting System
Application Type:       Productivity Reporting and Analysis
Development Platform:   Microsoft Access 2000 / Client-Server
Purpose:                Worked with management to develop a custom reporting application using Microsoft Access. This
                        application was linked via ODBC to a vendor provided package called DebtMaster. Custom reports
                        included Sales and Collections Call Activity Logs, Productivity Analysis reports and Daily Productivity
                        Goal reports and graphs.

Client:                 Whitney National Bank (Employer)
Application Name:       WNB Acquisition Bank Conversion System (WNB-BANK CONVERSION)
Application Type:       Bank Conversion Information Management System
Development Platform:   Microsoft Access 97/VBA/SQL-Server 7.0 / Client-Server
Purpose:                Automated due diligence process for facilitating new bank acquisitions. Managed all conversion
                        activity including main office, branch, contracts, invoicing and billing. Produced automated conversion
                        questionnaires delivered via e-mail to associated bank conversion team members. Updated internal
                        personnel on multiple action item status.




Robert D. Brunet                                     http://www.rdbrunet.com                                (719) 964-0234
IT Professional / Database Application Developer        Robert@rdbrunet.com                                     3|Page
                                                   Robert D. Brunet

                                        SUCCESS PORTFOLIO
Client:                 Whitney National Bank (Employer)
Application Name:       WNB NSF/OD Tracking System (WNB-NSF/OD)
Application Type:       Statistical Analysis and Reporting System
Development Platform:   Microsoft Access 97/VBA/SQL-Server 7.0 / Client-Server
Purpose:                Obtain data from corporate mainframe download to record NSF/OD activity by Bank Officer. Perform
                        conversions to calculate NSF/OD charges by bank branch and state. Print reports that demonstrate
                        NSF/OD activity by Bank Officer, Branch, Location, Group, etc. Print historical data tracking reports
                        for management use.

Client:                 Whitney National Bank (Employer)
Application Name:       WNB United Way Caring Card (WNB-UWCC)
Application Type:       Membership Management and Contribution Tracking System
Development Platform:   Microsoft Access 97/VBA/SQL-Server 6.5 / Client-Server
Purpose:                Maintain database of employee information. Track participation in the annual United Way giving
                        campaign. Optimize data entry to allow for multiple giving types including “Community Standard” –
                        percentage of salary, one-time gift, or weekly contributions. Print historical data tracking reports for
                        management use.

Client:                 Whitney National Bank (Employer)
Application Name:       WNB Trust Management System (WNB-TMS)
Application Type:       Membership Management and Asset Tracking System
Development Platform:   Microsoft Access 97/VBA/SQL-Server 6.5 / Client-Server
Purpose:                Maintain database of Trust members ranging in ages from birth to 18 years of age. Record all deposits,
                        withdrawals and maintenance costs. Track purchases and sales of Federally secured bonds used to
                        generate revenue for the associated trust fund.

Client:                 Whitney National Bank (Employer)
Application Name:       WNB Commercial Loan Pricing System (WNB-CLPM)
Application Type:       Interactive Loan Rate Calculator and Proposal System
Development Platform:   Microsoft Access 97/VBA/SQL-Server 7.0 / Client-Server
Purpose:                Based on a managed “cost of money” data matrix, this application provides Loan Officers throughout
                        the bank the ability to offer optimized loan rates to customers. The application uses a combination of
                        system code and interactive queries to determine the best possible rate based upon the customers
                        financial “relationship” with the bank.

Client:                 Whitney National Bank (Employer)
Application Name:       WNB Legal Administration Works (WNB-LAW)
Application Type:       Interactive Legal Services Management System
Development Platform:   Microsoft Access 97/VBA/SQL-Server / Client-Server
Purpose:                This application required the merger of 24 different Q&A databases into one interactive, multi-user
                        application. Complete case management forms and tracking capabilities were incorporated into this
                        application. In use by the entire Legal Department, this application includes over 300 reports and
                        manages activities for over 29,000 clients.

Client:                 Whitney National Bank (Employer)
Application Name:       WNB Credit Card Recovery System (WNB-CCRS)
Application Type:       Transaction Based Activity Monitor
Development Platform:   Microsoft Access 97/VBA/SQL-Server 6.5 / Client-Server
Purpose:                Used to compare credit card information to database of known cancellations and illegal credit card
                        numbers. Provided users with resources for recovering invalid credit cards at bank branches.


Robert D. Brunet                                     http://www.rdbrunet.com                               (719) 964-0234
IT Professional / Database Application Developer        Robert@rdbrunet.com                                    4|Page
                                                   Robert D. Brunet

                                        SUCCESS PORTFOLIO
Client:                 Whitney National Bank (Employer)
Application Name:       WNB Application Productivity System (WNB-APS)
Application Type:       Software Inventory Management & Tracking System
Development Platform:   Microsoft Access 97/VBA/SQL-Server 6.5 / Client-Server
Purpose:                Maintain current records on company owned software and licenses. Automated software check-in and
                        check-out system. Print invoice, PO’s and supporting clerical and administrative forms. Print usage
                        data for productivity analysis and tracking.

Client:                 Pioneer Productions (Contract Job)
Application Name:       Event Decoration Management System
Application Type:       Inventory Management & Order Processing
Development Platform:   Microsoft Access 97/VBA / Client-Server
Purpose:                Maintain customer, vendor and site information files. Build event decoration orders based on existing
                        inventory information. Incorporate photographic data with inventory information. Print proposals,
                        contracts, PO’s and supporting clerical and administrative forms. Print historical data tracking reports
                        for management use.

Client:                 Christian Brothers Jesuit Society (Contract Job)
Application Name:       Christian Brothers Fundraising System
Application Type:       Membership Management & Contribution Solicitation System
Development Platform:   Microsoft Access 95 / Client-Server
Purpose:                Maintain membership information. Track annual giving campaigns. Produce solicitation letters and
                        responses based on group activities. Print supporting clerical and administrative forms. Print historical
                        data tracking reports for management use.

Client:                 DeLaSalle High School (Contract Job)
Application Name:       Alumni Fund Raising System
Application Type:       Membership Management & Contribution Solicitation System
Development Platform:   Microsoft Access 95 / Client-Server
Purpose:                Maintain alumni information. Track annual giving campaigns. Produce solicitation letters and
                        responses based on group activities. Print supporting clerical and administrative forms. Print historical
                        data tracking reports for management use.

Client:                 Steals-N-Deals (Contract Job)
Application Name:       Steals-N-Deals Sales Management System
Application Type:       Advertising Sales Management
Development Platform:   Microsoft Access 95 / Client-Server
Purpose:                Maintain customer information for private and corporate clients. Print proposals, contracts, PO’s and
                        supporting clerical and administrative forms. Incorporate photographic data with customer orders for
                        proofing and ad placement. Print historical data tracking reports for management use.

Client:                 Mardi Gras Productions (Employer)
Application Name:       Event Decoration Management System
Application Type:       Inventory Management & Order Processing
Development Platform:   Microsoft Access 95/97/SQL-Server / Client-Server
Purpose:                Maintain customer, vendor and site information files. Build event decoration orders based on existing
                        inventory information. Incorporate photographic data with inventory information. Print proposals,
                        contracts, PO’s and supporting clerical and administrative forms. Print historical data tracking reports
                        for management use.



Robert D. Brunet                                     http://www.rdbrunet.com                                (719) 964-0234
IT Professional / Database Application Developer        Robert@rdbrunet.com                                     5|Page
                                                   Robert D. Brunet

                                        SUCCESS PORTFOLIO
Client:                 Downtown Development District / City of New Orleans (Contract Job)
Application Name:       Waste and Trash Removal Study
Application Type:       Statistical Analysis & Reporting
Development Platform:   Microsoft Access 95 / Single User
Purpose:                Data gathering application used for statistical analysis. Used to obtain data for identifying waste and
                        trash accumulating on the streets of New Orleans. Included comprehensive graphs used to demonstrate
                        program results.

Client:                 Downtown Development District / City of New Orleans (Contract Job)
Application Name:       Canal Street Development Review
Application Type:       Statistical Analysis & Reporting
Development Platform:   Microsoft Access 95 / Single User
Purpose:                Data gathering application used for statistical analysis. Used to obtain data for feasibility study to
                        determine the profit potential for developing 2nd and 3rd floor spaces in office buildings located on
                        Canal Street (main thoroughfare) in New Orleans. Included comprehensive graphs used to demonstrate
                        program results.

Client:                 Jerrico Event Planning (Employer)
Application Name:       Jerrico Event Management System (Jems)
Application Type:       Special Event Sales and Planning System
Development Platform:   Microsoft Access 95 / Client-Server
Purpose:                Maintain customer, vendor and site information files. Build event planning orders based on existing
                        vendor supplied inventory information. Print proposals, contracts, PO’s and supporting clerical and
                        administrative forms. Print historical data tracking reports for management use.

Client:                 Louisiana Tractor Company (Employer)
Application Name:       LTC Automated Tracking System
Application Type:       Inventory Management System
Development Platform:   Microsoft Access 95 / Single User
Purpose:                Maintain inventory of heavy construction equipment; tractors, backhoes, bulldozers, etc. Track new
                        and used items stored at national and international locations. List ask/bid/sale prices on each item.
                        Recorded sales and shipping activities.




Robert D. Brunet                                    http://www.rdbrunet.com                               (719) 964-0234
IT Professional / Database Application Developer       Robert@rdbrunet.com                                    6|Page
tors, backhoes, bulldozers, etc. Trac k new
                          and used items stored at national and international locations. List ask/bid/sale prices on each item.
                          Recorded sales and shipping activities.




Robert D. Brunet                                        http://www.rdbrunet.com                                (719) 964-0234
IT Professional / Database Application Developer       Robert@rdbrunet.com                                         6|Pa g e

								
To top