Crystal Reports / SQL Developer

Bruce H Bussell

Phone: 972-***-****

********@*******.***

CRYSTAL / SQL REPORTS DEVELOPER:

Skills and Accomplishments

• Have completed over 300 custom reports using Crystal 8.5 – 11 R2.

• Reduced turnaround time over 1,000%, from days to minutes by creating several Sarbanes-Oxley (SOX) compliant reports. Migrated reporting functions from Access/Excel/SQL system to Crystal Reports 11 on a SQL 2003 database.

• Achieved greater productivity; faster data retrieval and Crystal Reports performance using SQL Select scripts. Used SQL parameters to allocate report data selection functions to the SQL query process on the server.

• As a part of a 3 man team, upgraded and converted over 1000 reports to Crystal 11 for one company.

• Installed and set up Enterprise Manager 9 as the web-reporting tool for one organization’s reports.

Recent Crystal Reports

• Work with clients, gathering customer requirements, and determining reporting solutions.

• Data analysis to determine best way to access and use data, including many SQL Queries, up through SQL 2008

• Developed over 300 Crystal Reports and Extracts using Crystal 7 – 11 R2., including:

o Complex Formulas

o Sub Reports with Parameter Passing

o Text/CSV/Excel Extracts

o Custom Running Totals

o Graphs and Charts

o Drill Down Reporting

o Interactive Sorting

o Extensive use of Section and Field Suppression.

o Many SQL Select Queries, including use of SubQueries and Group By Clauses.

• Developed one very complex Crystal Report that had 9 Sub reports, 5 Sections, and two Graphs, all on one page.

• Created another report that contained 7 different reports rolled up into one with over 50 sections and 7 Group Levels. Sections printed in sets based on user supplied Suppression Criteria from SQL Stored Procedures.

Crystal Reports Contractor / Consultant, Oct 2000 – Present, for various clients:

Recently I have spent time upgrading my skills in Crystal Reports 12/2008, SQL 2008, and SSRS 2008.

City of Garland, Texas, 2010

Garland, Texas is a suburb of Dallas, Texas

• Reviewed and analyzed their FOCUS Reports and new matching Crystal Reports, and made recommendations on changes to improve performance, accuracy and productivity of the new Crystal Reports.

Newbay / MSI, 2008

Newbay provided telecommunications services to large wireless companies

• Created 17 telecommunications status drilldown reports using Crystal 11 R2 on an Oracle 10g database.

Cadbury Schweppes, Plano, TX, 2008

Manufacturer and Distributor of many kinds of Soft Drinks and Confectionary products

• Attained clients’ goal of being able to perform Excel Extracts of reports using Eportfolio 9.

o Created several complex SQL Select Scripts, including much use of SubQueries and Group By clauses, using an ADP Payforce - Oracle database.

o Added Crystal column headers for use in doing Excel Extracts, and published the reports using an ADP modified version of Crystal Enterprise Manager 9.

Concentra, Inc, Dallas, TX, 2007

Providing Worker’s Compensation and Healthcare Cost Management solutions

• Reduced time to create reports from several days to a few minutes by developing several Crystal 11 reports for their Sarbanes-Oxley (SOX) compliant audit controls system, on a SQL 2003 database. Crystal Reports were done as replacements for an old very time consuming Access/SQL/Excel reporting system.

• Included complex formulas, drilldown reports, horizontal stacked bar charts, special selection filters, custom color subtotals, and a Crystal 11 Data Only Excel Extract.

• Some reports had special sets of formulas to allow conversion of audit control question records 1-4 into a one line horizontal display for Yes/No answers.

• Did much SQL data analysis using SQL Enterprise Manager and SQL Query Analyzer, and created a set of custom SQL views for the reports.

Countrywide Builder Finance Group (BFG), Dallas, TX, 2006

Provided Real Estate Lending for Land Development and Single-Family Resident construction

• Performed design and development of Countrywide Loan Administration and Loan Portfolio Reports using Crystal 10 on a SQL 2000 database.

• Developed several Sub Reports with Parameter Passing, Custom Running Totals, many Formulas, and use of Section and Field Suppression.

AmerisourceBergen Specialty Group, Addison, TX, 2006

Delivers responsive and innovative healthcare products and solutions for Manufacturers and Healthcare Providers

• As a part of a 3 man team, upgraded and converted over 1000 reports to Crystal Reports 11.

• Changed each report from an ODBC to an OLEDB driver

• Re-mapped report db fields to the new database

• Modified formulas and updated report fields as needed

• Did parallel testing mostly using Excel Extracts to be sure the converted reports matched the original reports.

Goldman Sachs, New York, NY, 2005

Major Brokerage and Financial Services Company

• Helped setup and use Crystal Enterprise Manager 10 for company’s Web Reporting.

• Worked on a project creating a set of Crystal 10 reports for their Job Costing System, which ran on a Unix/UDB database.

JP Morgan Chase Bank, Dallas, TX, 2005

Large Banking and Financial Services Company

• Worked as an IBM Global Services consultant on a new Crystal Reports 8.5 project at JP Morgan Chase Bank in North Dallas.

• Project involved over 50 new reports for a Mutual Funds Processing System, including many Excel, CSV, Text, and Tab Separated extracts, and much SQL 2000 data mining to find test data sets for use with the Crystal Reports.

Jacuzzi Brands, Dallas, TX, 2004

Makers of a full line of pools and spas

• Created a set of Crystal 9 reports on a SQL 2000 database for their Microsoft CRM system.

Countrywide Home Loans, Plano, TX, 2004

Provided a wide variety of Consumer Home Loan services

• Helped create a new set of Custom Crystal 10 reports for their Checs financial data application, which ran on a SQL 2000 database

• Used a custom version of Enterprise Manager 10 as the web-reporting tool for the reports.

• Provided technical advice and assistance to several employees in order to help them understand how best to implement many different Crystal Reports features, including Excel Extracts.

Interstate Batteries, Dallas, TX, 2004

Providing a wide variety of batteries for almost every need

• Developed a new set of Crystal 8.5 Accounts Payable (AP) reports which ran on Oracle Stored Procedures to maximize performance, as they had previously found that using linked tables for their Accounts Receivable (AR) reports caused them to run much to slow.

• Reworked their set of AR reports to run on Oracle Stored Procedures, which greatly reduced the runtime for the reports. These AP and AR reports were done for their AIM Distributor / Vendor Application, which runs on an Oracle 9i database and uses an ASP Web front end to run the reports.

• SQL Data Analysis for the Oracle 9i database reports was done using the TOAD utility program.

• Assisted ASP Web developer on ASP / Crystal Parameter Passing issues when using Stored Procedures.

Volunteer Center of North Texas, Dallas, TX, 2003 - 2004

Coordinates Court appointed Volunteer Activities in the Greater Dallas - Ft. Worth area

• Installed and set up Enterprise Manager 9 as the web-reporting tool for organization’s reports.

• Developed a set of Custom Crystal 9 reports, on an as needed basis, for their new Microsoft CRM system, which runs on a SQL 2000 database.

• Data Analysis for the reports was done using SQL Query Analyzer.

Sterling Commerce, Irving, TX, 2003

Provides business-to-business e-commerce solutions for the electronic exchange of information

• Developed an initial group of Crystal 8.5 reports on a MySQL database for their new Control Center Network Traffic Monitoring product.

Selkirk Financial Technologies, Inc., Vancouver, BC 2001 - 2003

A leading global supplier of world-class treasury management tools and services

• Created many custom Crystal 7 and 8.5 reports, on an as needed basis, from my home in Dallas, TX, for their VB-based Treasury Management System, which ran on a SQL 7 database. Included using SQL 7 Enterprise Manager and Query Analyzer for Data Analysis.

CBIZ Property Tax Solutions, Carrollton, TX 2001

A national provider of property tax consulting and compliance services

• Created a series of custom Crystal 7 reports and Excel Extracts, on an as needed basis, for a VB-based Tax Manager system that ran on a SQL 7 database. Included working with SQL 7 Enterprise Manager and Query Analyzer.

• Advised CBIZ on how to reduce the runtime of one primary report from 2-3 hours down to 10-15 minutes.

• Also helped them upgrade from Crystal 7 - 8.5, implement the necessary Crystal 8.5 Runtime Requirements, and convert 60-70 reports.

Military

Served in the U.S. Air Force as a USAF Weather Officer

Education

Florida State University, Tallahassee, Florida

Bachelor's Degree, Major: Meteorology, Minor: Math

Contact this candidate