Crystal Reports Resume Profile

Summary

9 Years Information Technology experience within report development.
Proven experience in developing reports using Crystal Reports 2011/2008/10/8.5 that included multiple Sub-Reports, Parameters, SQL Expressions and Crystal/Basic Syntax Formulae.
Extensive Experience in Business Objects Designer, CMC, Infoview, Web Intelligence, Scheduler, Import wizard .
Experience in publishing Crystal Reports by using Crystal Enterprise and Business Objects.
Worked on canned reports and Ad-hoc reports using Business Objects Web Intelligence tools.
Worked with multiple RDBMS databases including Oracle, MS SQL Server, MS Access and associated SQL Dialects such as Transact SQL T-SQL , PL/SQL etc.
Developed complex stored procedures, views, functions etc. using SQL, PL/SQL, T-SQL.
Performance Tuning of database by creating and usage of indexes and gathering table and index statistics.
Extensive Experience of report development in Oracle BI publisher.
Extensive Experience in Access reports and VBA macro coding.

Confidential

Crystal Reports / Access Developer

Responsibilities:

Designed report libraries for CPA Ontario and other provinces using Crystal and Access Reports.
Created cross tab reports, parameterized reports, using running totals, sub totals and linked/unlinked sub-reports.
Extensively involved in using formula fields, parameter Fields, group selection and record selection in Crystal Reports.
Developed Access reports using VBA.

Environment: Crystal Reports 2011, Access, SQL Server and VBA

Confidential

Crystal Reports Developer

Responsibilities:

Improved the performance of reports from 25 hours to 3 hours. Increased one business day per month for business users in Month End.
Designed reports using Crystal Reports and SQL Server stored procedures and views.
Developed parameterized reports, cross tab reports based on base tables, views involving formulas, sub totals, running totals, and sub reports.
Created dynamic LOVS in the Business view manager to incorporate them to the parameters in the Crystal reports.
Developed various types of charts and graphs such as Bar Chart, Line Graphs, Pie Charts using Chart Expert of Crystal Reports.
Programed Web Intelligence reports using Business Objects universe as data source.
Deployed and Scheduled reports to be delivered to the users in Infoview.
Fixed defects with software vendors, IT department and business users documented revisions in Rational Change.
Won Peers' Choice Award for mentoring offshore team in India.

Environment: Crystal Reports 2008, CMC/ Infoview, Web Intelligence, SQL Server and IBM Rational Change

Confidential

Crystal Reports Developer

Responsibilities:

Designed and implemented reports for an online portfolio management system.
Created Cross Tab Reports, Pie and Bar Charts, and Parameter Reports, Running totals, Sub Totals and embedded linked and unlinked sub-reports.
Wrote complex stored procedures and views as data source in SQL Server.

Environment: Crystal Reports 10 and SQL Server.

Confidential

Oracle Reports Developer

Responsibilities:

Selected by management to assume development activities from subcontractor. Resulted in saving company 50 of the cost 150K of report development.
Designed and developed reports using Oracle BI Publisher and Oracle stored procedures and functions.
Created performance test scripts using JMeter.

Environment: Oracle PL/SQL, Oracle BI Publisher, Oracle Enterprises Taxation Management ETM , JMeter, Java, JSP, JavaScript, XML and AIX.

Confidential

Crystal Reports Developer

Responsibilities:

Prepared different financial reports such as consolidated income statements and balance sheets.
Created reports using Crystal Reports and SQL Server.
Designed complex reports using sub reports, manual cross tabs with extensive usage of Local, Global, and Shared variables at report formulas.
Coded stored procedures in SQL Server.

Environment: Crystal Reports 10, VB.NET, SQL Server and MS Visual SourceSafe

Confidential

Crystal Reports Developer

Responsibilities:

Created Cross Tab Reports, Pie and Bar Charts, and Parameter Reports, Running totals, Sub Totals and embedded linked and unlinked sub-reports.
Developed reports with Parameter fields, formulas, and heavy formatting.

Environment: Crystal Reports 8.5 and SQL Server

Confidential

VBA Developer / Helpdesk

Responsibilities:

Developed floor layout system for visitors to locate employees in department using Visual Basic Application.
Troubleshot hardware and software problems for over 100 end users.

Environment: Visual Basic Application VBA , Excel, Windows Server 2003, and Unix