OBJECTIVE:

Seeking a position in Business Intelligence reporting that will draw upon my extensive experience with SAP Crystal Reports SQL and my diverse IT background directly or utilize my background to grow into new Business Intelligence initiatives, with the goal of enhancing business operations and managing business critical processes and applications.

SUMMARY:

• Experienced with all versions of Crystal Reports, Crystal Reports Enterprise/Server and Crystal Dashboards with some experience with WebI and Business Objects Enterprise. I have developed financial and transactional/invoicing reports, operations and resource utilization reports, KPI and customer - facing reports, forms and letters, calendar and time-based reports and dashboard reports. I have worked for companies in television production, debit cards, VoIP, education, government and law enforcement, accounting and payroll, insurance and retirement investing.
• Developed reports that involve hundreds of formulas collecting metrics from disconnected data sources and displaying summary tables, reports made up entirely of a string of sub-reports, reports designed specifically to export cleanly to Microsoft Excel and CSV files for export and reports designed to print on pre-printed forms. I have used conditional formatting to enable reports to change based on data-driven criteria, global variables to pass data into and out of sub-reports, dynamic parameters to control the data source, and complex in-report table linking when scripting access to the database was not possible.
• Worked with a variety of SQL data sources, including views, stored procedures, dynamic stored procedures, views, recursive CTE expressions, functions, defined and parameter variables, sub-queries for data selection and data filtering, expressions for conditional data selection, and expressions for data conversion and analysis. I have developed data sources that utilize unions to combine multiple variations of like data sets as well as data sources that combine multiple unrelated data sets. I have designed custom databases to store massive quantities of data specifically to serve as data sources for reports.
• Throughout my work history, I have been able to deliver effective business intelligence solutions on schedule and on budget, contribute to the continuous improvement of business, development and IT processes, demonstrate strong analytical, organized and detail-oriented problem-solving skills, and exhibited a proven ability to work both independently and in a team of partners, customers, and managers

EMPLOYMENT HISTORY:

Crystal Reports Developer

Confidential, Santa Cruz, CA

Responsibilities:

• Maintained library of Crystal 8.5, XI and 2011 reports in SQL environment, including property and casualty, auto and general liability quotes, declarations and forms, claims reports, member activity reports and other customer facing and internal underwriting and operations reporting.

Crystal Reports Developer

Confidential, Duluth, GA

Responsibilities:

• Custom development of client internal and customer-facing reporting solutions for the Confidential planning and permitting system for city and county governments.
• Designed and developed standard reports in SQL and helped streamline report development process and best practices.
• Curated peer user support on Tyler Community, including technical blog posts, developed and delivered client training and user documentation for a Reporting Toolkit to support clients designing their own reports.

BI Reporting Developer

Confidential, Atlanta, GA

Responsibilities:

• Provided expertise to Internal Revenue Service project team’s efforts to design and build a Business Intelligence
• Reporting platform for a centralized cyber security business resiliency, continuity and disaster recovery enterprise application.
• Produced technical and user documentation in service of the project.

Crystal Reports Instructor

Confidential, Atlanta, GA

Responsibilities:

• Delivered basic and advanced instructor-led online training for Crystal Reports XI and Crystal Reports 2008.

Crystal Reports Developer

Confidential, Atlanta, GA

Responsibilities:

• Assisted the client in diagnosing and fixing issues with cattle management Crystal Reports Crystal Reports business intelligence solutions used to track cattle feedings, health and weight development.

Crystal Reports Developer

Confidential, Atlanta, GA

Responsibilities:

• Supported client analysis of email campaign metrics by modifying existing and developing new Crystal Reports business intelligence solutions for tracking the success of email packages, including content clicks, conversions, subscriptions and unsubscribes.
• Modified MAS 90 accounting reports for export to Excel.

SAP Reportapalooza Expert

Confidential, Atlanta, GA

Responsibilities:

• Promoted SAP Crystal Solutions as one of five Reporting Experts competing in Reportapalooza, a national marketing campaign involving challenges for the creation of dashboards, tutorial videos, blog posts and use of social and professional networking.

Crystal Reports Developer

Confidential, Atlanta, GA

Responsibilities:

• Assisted Customer Service Representatives by delivering report solutions for clients including payroll registers, checks, earnings statements, benefits and retirement savings exports, tax and WOTC analysis for Millennium 3 payroll management system on MS-SQL 2008 and Oracle databases.

Crystal Reports Developer

Confidential, Atlanta, GA

Responsibilities:

• Provided reporting continuity by creating suite of interbank loan analysis Crystal Reports business intelligence solutions in a new SQL database environment based on the source code and output of old Sybase based reports.

Crystal Reports Developer

Confidential, Atlanta, GA

Responsibilities:

• Addressed operational reporting deficiencies by modifying and creating Crystal Reports business intelligence solutions for defined contribution 401a and 457b retirement savings and defined benefit pension systems, including confirmation letters, benefits calculation forms, distribution process tracking and quarterly statements.

Crystal Reports Consultant

Confidential, Marlborough, MA

Responsibilities:

• Fulfilling key customer commitments by customizing traffic accident Crystal Reports business intelligence solution in accordance with strict government design requirements.

Implementation Manager

Confidential, Atlanta, GA

Responsibilities:

• Fulfilling key customer commitments by customizing traffic accident Crystal Reports business intelligence solution in accordance with strict government design requirements.

Crystal Reports Developer

Confidential, Atlanta, GA

Responsibilities:

• Created student performance analysis tools through the design and development of a suite of Crystal Reports business intelligence solutions for the new web-based Classworks educational software package.

Crystal Reports Developer

Confidential, Atlanta, GA

Responsibilities:

• Replaced faulty Excel-based process for customer retention and marketing performance analysis with reporting solution by performing business analysis and documenting requirements, including process, user interface and database design elements.

Reports Developer

Confidential, New York, NY

Responsibilities:

• Supported accounting requirements by customizing Work Order and Invoicing Crystal Reports business intelligence solutions in a SQL based ScheduALL environment.

Senior Reporting Engineer

Confidential, Norcross, GA

Responsibilities:

• Designed, developed and implemented Crystal Reports business intelligence solutions for internal operations and customer facing requirements in Remedy 7 Action Request System and Oracle environments.
• Facilitated budget management and resource allocation through Crystal Reports Server XI R2 and improved the efficiency of customer-facing reporting solutions by streamlining data sources and implementing requested design enhancements.
• Led an international team for the requirements analysis, database design, process management, report design and development, systems verification and implementation for a reporting solution that delivered on contractual reporting obligations for VoIP performance.
• Closed service delivery gaps and improved information analysis with solutions for issue tracking, incident resolution, service analysis and release management.

Crystal Reports Instructor

Confidential

Responsibilities:

• Developed and delivered interactive advanced Crystal Reports classroom training over the internet for global IT consultants.

Crystal Reports Server Analyst

Confidential, Suwanee, GA

Responsibilities:

• Developed business intelligence solutions in Crystal Reports Enterprise and SQL 2000 environment for stored value debit card system, summarizing financial transaction activity for analysis and reconciliation, performing fee revenue trend analysis, fraud and Interactive Voice Response (IVR) analysis, and corrupt transaction analysis.

Advanced Business Systems Analyst

Confidential, Atlanta, GA

Responsibilities:

• Designed, developed and delivered Crystal Reports business intelligence solutions utilizing linked tables, formulas, record selection criteria, dynamic elements, sub-reports, SQL views, stored procedures, and parameters.
• Supported financial operations through the development of Crystal Reports business intelligence solutions for month-end, receivables and general ledger analysis, paperless invoicing, dynamic dunning letters, and transaction auditing.
• Improved client services through the development of Crystal Reports business intelligence solutions to facilitate production operations through work order forms, resource assignments, project costing and tape stock slippage analysis.
• Simplified personnel management through the development of Crystal Reports business intelligence solutions for the scheduling of production talent through the analysis of resource and client activity and personnel utilization.
• Contributed to the growth of production services and products through the development of Crystal Reports business intelligence solutions to justify facility and personnel expansion and to analyze client activity for trends and aberrations.
• Developed, implemented and validated Y2K assurance for all ScheduALL application components.
• Facilitated business growth through the integration of new ScheduALL modules, application features and customized Crystal Reports into existing production operations through needs and application analysis.
• Maintained facility availability and operability while transitioning rooms, resources and services in coordination with operations and engineering teams to ensure alignment during migration to new digital studio.
• Enhanced user productivity by designing and delivering individual and shared ScheduALL learning opportunities through training materials, hands-on classroom sessions and one-on-one tutorials.
• Simplified payroll processing by developing Excel-based Time Sheet application for production personnel that automatically applied rules for regular, overtime, shift differential, freelance, and straight time employment.