Crystal Reports Sql Server

Name: PRASAD STEPHEN TALLURI

Email: *************@*******.*** Phone: 815-***-**** (H)

Experience Summary

• 14 years total experience using Crystal Reports; Crystal Enterprise, Oracle, SQL Server,

• Used various version of Crystal Reports (5.0, 6.0, 7.0, 7.2, 8.5, 9, 10, XI, 2008. 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

Software Version

Crystal Enterprise 8.5, 9, 10 and XI

Crystal Reports 5.0, 6.0, 7.0, 7.2, 8.5, 9, 10, XI, 2008

Business Objects R1, R2

SharePoint

Oracle8i, 9i , 10g and 11g

Db2 9.7

Oracle Forms3.2

SAP 6.2

MS SQL Server2000, 2003, 2005, 2008

MS Access2000

PeopleSoft HR7

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, Windows Server 2003

Qualifications

Degree and Date University Major and Specialization

Masters Degree – 1970 Osmania University Physics and Electronics

Bachelors Degree – 1968 Osmania University Physics, Chemistry, Math

Experience:

December 1996 – Present – Independent Consultant

Worked for fortune 1000 clients nationwide. Partial assignments are enclosed below:

April 2009 – Present

• Technical support to clients sometimes over phone. Designed and developed reports in XI and 2008 versions. Wrote stored procedures, functions, views in PL/SQL with data analysis

TDS – Madison, WI Telecommunications

March 2009

Crystal Reports - writing reports

• Designed and developed Business Objects XI.

• Analyzed the data using ERWIN.

• Studied the documentation of views and Oracle code.

• Trouble shoot the existing reports.

• Reduced report running time using cross-tab tools.

• Wrote Materialized Views for Oracle 10g database.

Sedgwick CMS – Memphis, TN – Insurance

8/2008 to 3/2009 – 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) - 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

• Table Function and Pipelining

• 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.

Department of Health – Tallahassee, FL – Health Care

2/2008 to 8/2008 – Crystal Reports Expert

Business Objects XI, Crystal Enterprise XI, Oracle 9i/10g, Rational Rose, Clear Quest, SharePoint

• Reports were designed and developed for Business Objects XI Release 2 and published using Crystal Enterprise Release 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.

Palm Beach County – West Palm Beach, FL – Government

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

• 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.

FirstComp Insurance – Omaha, NE – Insurance

04/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.

Cott Systems – Columbus, OH – Civil, Criminal Court; Government

01/2006 to 04/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.

ConAgra Foods Omaha – Omaha, NE – Logistics

06/2005 to 01/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.

Stock Building Supply - Raleigh, NC – Logistics

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 individual reports.

• Used JavaScript and HTML with Crystal Server Pages in the Crystal Enterprise 9 version.

Mutual of Omaha – Omaha, NE – Insurance

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.

Court Specialists Inc. – Orlando, FL – Government

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.

HRA 180 Water Street – New York City, NY – Government

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

Royal Neighbors of America – Rock Island, IL – Insurance

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.

Cigna HealthCare – Kankakee, IL – Health Care

06/1999 to 03/2000 – Data Analyst / Crystal Report Writer

Crystal Reports 7.0, WIN NT 4.0., VB 7.0

• Installed Crystal Reports 7.0 on Windows NT 4.0.

• Designed, developed and deployed reports with Crystal Reports 7.0 using VB Report Designer.

• Component, stored procedures, data definition files and parameters.

• Supported 4 Crystal Reports developers using SQL Server 7.0 database (170 tables and stored procedures) with performance, report publishing and user security problems.

• Gathered business user requirements for reports development from various departments in the healthcare company.

• Documented the specifications and business rules.

Remote Backup Ltd – Wellington, New Zealand – Accounting Software

12/1996 to 06/1999 – VB Programmer / Analyst / Crystal Report Writer

Crystal Reports (4.5, 5.0, 6.0) and VB ( 5.0,6.0)

• Supported Accounting Software NZA Gold throughout New Zealand.

• Developed the following reports using Crystal Reports in Accounting: Payroll, Profit and Loss, Balance Sheet, Invoice, Purchase Orders, Debtor/Credit Analysis, Packing Slips, Statements, Cash Flow, Budget Analysis, Job Costing, Chart of Accounts.

• Developed Visual Basic application to calculate prices for manufacturing industry given profit margin.

• Designed, developed, tested, implemented, maintained and supported VB applications.

• Analyzed user requirements and liaised with the users throughout the project development phase.

• Designed and developed Cross-Tab reports.

• Developed Web pages containing animation and multimedia.

Contact this candidate