Experience Summary

• 14 years total experience using Crystal Reports; Crystal Enterprise, Oracle, SQL Server, VB and PeopleSoft.
• Used various version of Crystal Reports (5.0, 6.0, 7.0, 7.2, 8.5, 9, 10, XI) Also Crystal Enterprise (8.5, 9, 10 and 11).
• Worked in various industries, i.e., Insurance, Health Care, Manufacturing, Human resources and Government.
• Involved in requirements gathering with different users of the various departments, i.e., Litigation, Group Managed Care, Timekeeping, Administration, and Corporate Services.
• Configured and troubleshoot design and development of Crystal Reports.
• 7 years experience writing Stored Procedures and String Routines.
• Developed and published reports on Web using Crystal Enterprise according to user requirements and wrote specifications.

Technology
Crystal Enterprise: 8.5, 9, 10 and XI
Crystal Reports : 5.0, 6.0, 7.0, 7.2, 8.5, 9, 10, XI
Business Objects: R1, R2
Oracle : 8i, 9i and 10g
Oracle Forms : 3.2
MS SQL Server : 2000, 2003, 2005, 2008
MS Access: 2000
PeopleSoft HR : 7.0
HP PPM: Project and Portfolio Management
GUI (Front End) Development: Visual Basic (5.0, 6.0, .NET), Visual Studio.NET, Microsoft Front Page, VB Script, JavaScript, XML, ASP (3.0, .NET), CSP, JSP, HTML, DHTML
Operating Systems: Unix, Win2K, Windows NT, Windows Vista

Qualifications
Masters Degree –Physics and Electronics
Bachelors Degree –Physics, Chemistry, Math
Assignments
Confidential,Madison, WI
March 2009
Crystal Reports - writing reports

Confidential,– Memphis, TN – Insurance
6/23/2008 to 9/15/2008 – Crystal Reports Consultant
Business Objects XI R2, Oracle 10g, Data warehouse, TOAD

• Designed and developed Business Objects XI.
• Developed Reports for Medical Bill Provider (MBR) which were Telephonic Case Management (TCM) and Utilization Reviews (UR) reports.
• The developed TCM and UR reports help Sedgwick CMS clients better identify and ensure that the patient receives the quantity and quality of services which was consistent with their medical care needs.
• Designed and developed Bar charts
• Involved in Training the developers in Crystal Reports.
• The application was developed as a group of different reports to be used by the Program Managers.
• The application developed used Oracle10g database as the backend and the Crystal Reports XI as the front end. The data was being fetched from different tables, views in the data warehouse.

Confidential,Tallahassee, FL – Confidential,
1/31/2008 to 6/20/2008 – Crystal Reports Expert
Business Objects XI, Crystal Enterprise XI, Oracle 9i/10g, Rational Rose, Clear Quest, VB.NET, SQL Server, T-SQL

• Reports were designed and developed for Business Objects XI Release 2 and published using Crystal Enterprise Rel 2.
• Used Clear Quest application of Rational Rose Platform for trouble-shooting problem tickets and specs for reports, documentation etc.
• Designed Crystal Enterprise interface for Community Health Department (CHD).
• Used SharePoint as an archive to analyze and develop new reports using Crystal Reports XI.
• Conducted Meeting with users of Health Department to understand the various reporting needs of HPE/HMS System.
• Worked on Various reports like O/S Balance Report - current year only, Monthly Total report, Wildcard Query report, Operating Inspection Report by Purpose, Limited Use Reports - sort by faculty name, County 10 fields report, ATU maintenance entity form, Days to Issue report with all application types, Limited Use Facilities by Inspector, Construction Permits issued Report – subtypes, Mods to service facilities list.
• Created reports with .CSV format.
• Conducted Training for users, technical staff.
• Created implementation and training documentation for various reports and used SharePoint as a document repository.

Confidential,Columbus, OH – Confidential,
03/2006 to 04/28/2006 – Crystal Reports Star Contractor
Crystal Reports XI, Visual Studio 2005, Crystal Reports for Visual Studio 2005, SQL Server 2005 and Visual Source Safe 2005

• Designed and developed 90 Crystal Reports XI reports for Court - Criminal, Civil etc.
• Used ADO.NET with TableAdapter for XML Schema and XSD files.
• SQL Server stored procedures.
• Dynamic Image Linking and Dynamic prompt with cascading.
• Visual Source Safe 2005.
• Created Stored Procedures with T-SQL
• Created Report templates to give custom look and feel.

Confidential,West Palm Beach, FL – Confidential,
04/12/2007 to 01/30/2008 – Crystal Reports Consultant
Crystal Reports (8.5, XI), Business Objects XI, Crystal Enterprise XI, Oracle 9i/10g, Oracle SQL Developer, TOAD, VB.NET, T-SQL

• Designed and developed 8.5 and XI Crystal reports for Civil, Criminal, Public Defender, Sheriff’s Office departments.
• Designed and developed Crystal Reports XI for Ungerboeck Systems International’s EBMS (Event Business Management Software) which is a comprehensive ERP (Enterprise Resource Planning) application that provides CRM (Customer Relationship Management).
• Was Also responsible for Converting 8.5 reports to XI.
• Used Stored Procedure from Packages and Package Body to design and develop reports.
• Wrote stored procedures replacing tables.
• Trained staff in Crystal Reports, Stored Procedures and Documented all the processes.

Confidential,Omaha, NE – Confidential,
03/2006 to 03/2007 – Crystal Reports Consultant
Oracle 9i, Crystal Reports 9, Oracle SQL Developer, Apollo database

• Designed and developed reports for Workmen Compensation.
• Designed and developed various insurance reports for Underwriting, Management, Pricing, Experience, Accounting, Agency, Audit, Budget, Claim, Collection, Endurance, Labels, Marketing, Processing departments.
• Used Stored Procedure from Packages and Package Body to design and develop reports.
• Apollo Workmen Compensation application was developed to validate data. Analyzed data used complex queries.
• Mapped Apollo database with SQL queries to identify the data in the Apollo Workmen Compensation application.
• Was also involved in Data Dumping.

Confidential,– Omaha, NE – Confidential,
06/2005 to 03/2006 – Crystal Reports Consultant
Oracle 8i, Crystal Reports 9, JavaScript, HTML.

• Developed and trouble shot Crystal Reports 9.0 for nationwide clientele of ConAgra Foods.
• Analyzed data of Oracle 8i stored procedures, functions and packages.
• Supported application 24/7. Was on-call to make sure the customers have Crystal Reports working round the clock.
• Applied SDLC methodology for documentation.
• Trouble shot CSP written in JavaScript and HTML.
• Worked on various reports, i.e., Bill of Lading, Invoices, Packing Lists for Supply Chain market.

Confidential,Raleigh, NC –Confidential,
01/2005 to 06/2005 – Crystal Reports Specialist
Crystal Enterprise 9, SQL Server 2000, People Soft

• Designed and developed Crystal Reports for Accounts Payable and Asset Management Departments.
• Wrote Stored Procedures for SQL Server 2000 database.
• Mapped database tables to redesign reports.
• Analyzed data. Reduced report running time drastically with cross-tab tools.
• Used Net Meeting to access PeopleSoft application and modified query in PeopleSoft Query Manager.
• Validated data. Filtered data for reports for individual reports.
• Used JavaScript and HTML with Crystal Server Pages in the Crystal Enterprise 9 version.

Confidential,Omaha, NE –Confidential,
01/2004 to 12/2004 – Primary Systems Analyst
Oracle 9, Crystal Reports 9.0

• Designed and developed Crystal reports for Special Investigation and Law departments in the Insurance industry.
• Wrote Oracle Stored procedures with PL/SQL code.
• Mapped database tables from LawPack system to LawManager.
• Designed the document for integrating Crystal Reports into LawManager.
• Did requirements gathering of the various departments - Litigation, Group Managed Care, Timekeeping, Administration, Corporate Services, Outside Counsel Fees, Services and Compliance.
• Analyzed database tables using ERWIN diagrams.
• Converted the Sybase Infomaker SQL queries into PL/SQL Stored Procedures.
• Wrote reports using LawManager Notebook Wizard.
• Trained Law staff in writing Crystal Reports.

Confidential,Orlando, FL – Confidential,
10/2002 to 12/2003 – Crystal Reports/Enterprise Developer
Oracle 9, Crystal Reports 9.0, SQL Server 2000

• Installed and administered Crystal Enterprise 9 on Win2K Server.
• Designed and created new Crystal Reports – about 400 reports using MS SQL Server 2000 and Oracle 8i, TOAD, T-SQL
• Using Court Systems software eNACT, customized reports to print for each case.
• Developed reports for EMPANEL and eNACT court software.
• Developed and published reports on Web using Crystal Enterprise 9 according to user requirements and wrote specifications.
• Gathered Business User requirements and used stored procedures to write reports.
• Published Crystal Reports using Crystal Enterprise with Crystal Server Pages and HTML.
• Designed and created Payroll reports for EMPANEL software (Jury Management System).
• Identified the proposed modifications in the Payroll system and designed and created reports.
• Developed reports for Orange County, Florida, York County, Pennsylvania court houses.
• Trained Court House employees in Orange County Court House.
• Supported Crystal Reports 9 developers using Oracle 8i database (452 tables and 100 views) with performance, report publishing and user security problems.
• Designed and developed Crystal Reports for Special Investigation and Law departments in the Insurance industry.
• Wrote Oracle Stored procedures with PL/SQL code.
• Mapped database tables from LawPack system to LawManager.
• Designed the document for integrating Crystal Reports into LawManager.
• Did requirements gathering of the various departments - Litigation, Group Managed Care, TimeKeeping, Administration, Corporate Services, Outside Counsel Fees, Services and Compliance.
• Analyzed database tables using ERWIN diagrams.
• Converted the Sybase Infomaker SQL queries into PL/SQL Stored Procedures.
• Wrote reports using LawManager Notebook Wizard.
• Trained Law staff in writing Crystal Reports.

Confidential,New York City, NY – Confidential,
03/2001 to 10/2002 – Crystal Report Writer Analyst
Oracle 9, Crystal Reports 8.5, Crystal Enterprise 8.5, WIN 2K

• Installed Crystal Enterprise 8.5 on Win2K Server.
• Gathered requirements for reports development from FIA and HRA departments.
• Developed and published reports on Web using Crystal Enterprise 8.5 according to user requirements.
• Published Crystal Reports with Java Server Pages.
• Worked on Seagate Enterprise and Crystal Info server for configuration of reports for the users.
• Worked on standard code with COM and DCOM for installation of product at different client sites.
• Worked on dynamic link libraries in Visual Basic for OLE interfaces.
• Designed and created 1450 Crystal Reports using Oracle 8 database.
• Supported 12 Crystal Reports 8.5 developers using Oracle 8i database (230 tables) with performance, report publishing and user security problems.
• Solved errors in reports due to incorrect data entry by writing string formulas.
• Developed reports using Crystal Reports for TMTS (Training Management Tracking System).
• Developed Data Model for the Test and Production KP2000 databases (Oracle 8i) using Power Designer Web Architect tool.
  

Confidential,Rock Island, IL – Confidential,
04/2000 to 03/2001 – Crystal Report Writer / VB Programmer / Analyst
Crystal Reports 8.0, WIN 98, VB (6.0,7.0)

• Installed Crystal Reports 8.0 on Windows 98 OS.
• Converted Crystal Reports 6.0 to 8.0 in the existing VB platform.
• Published Crystal Reports with ASP.
• Gathered requirements for reports development from various departments in the insurance company.
• Supported 8 Crystal Reports developers using SQL Server 7.0 database (110 tables) with performance, report publishing and user security problems.
• Wrote specifications which include business rules for writing crystal reports.
• Mapped data connectivity via RDO, ADO, Crystal Reports Designer Component, Web Component Server.