Sql Server Crystal Reports

Prava

Crystal Reports Developer 303-***-****

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

Professional Summary

• Seven years of experience in designing and developing CRYSTAL REPORTS for different

type of applications with excellent knowledge of VB, C/C++, ORACLE, SQL SERVER, SQL

SERVER REPORTING SERVICES (SSRS), Embedded Programming.

• Experience in deploying different types of reports using Crystal Reports Version XI/ 10/ 9.0/

8.5/8.0 of Crystal Reports/Crystal Enterprise and Business Object Enterprise XI R2.

• Administrative experience in Business Objects Enterprise XI R2 creating Users, Groups,

folders, and assigning rights to the Users/ Groups. Also, created Dynamic LOVs from Business

Views.

• Designed report with complex sub reports, Cross Tabs, Drill down, OLAP reports, formulas,

functions, parameters, scheduled reports, alerts, multiple grouping, running totals, Charts, graphs,

mapping, multiple sections, conditional hiding/formatting, mailing label, standard etc.

• Extensive experience in developing complex reports using Cascading Prompts, Parameters,

Sub-Reports, Groups, Cross tabs, SQL Expressions and Crystal/Basic Syntax Formula.

• Developed various charts and graphs like Bar chart (side by side, stacked), line graphs, pie

charts etc by using chart expert utility of Crystal reports.

• Experience with conversion from older versions to Updated Versions.

• Conversant with Analyzing, Coding and Implementing SQL queries.

• Worked with SQL Server 2000/2005, AS400, Oracle 7/8/ 8i and 9i, MS Access 2003.

• Created various SSRS reports and Data Transformation Services (DTS) packages.

• Created, maintained and optimized Stored Procedures.

• Experience using Business Objects XI –XI R2, 5.1.7/6.0/6.1, Supervisor, Designer, reporter,

Broadcast agent, Web Intelligence Explorer / Reporter.

• One year experience in Web development using XML, HTML, JavaScript, Java Script,

mySQL.

• Experience with .NET application platform and development using VB.Net.

• Worked with end users and technical users.

• Well versed in documenting the procedures, views, specifications and gathering the

requirements.

• Highly motivated and eager to rise quickly and take on greater responsibility.

• Excellent problem resolution and communication skills with ability to work in a fast-paced

enviroment.

Technical Summary

Operating Systems Windows 95/98/2000/XP, MS DOS 6.22, Unix

Databases Oracle 8.x/9i/10g, MS Access, MS SQL Server 6.5,7.0/2000/2005,

AS400, Sybase12.0.7, and DB2

Language VB, C, C++, VB, Java, JavaScript, PHP, Pascal, SQL and PL/SQL

GUI Visual Basic 6.0, SQL Profiler. TOAD, SQL*Loader, DB Visualizer

Reporting Tools Crystal Reports 8.0/8.5/9.0/10.0/XI, Business

Objects 10.0/XI R2, SSRS 2000 - 2005

Web Applications ASP 3.0, JavaScript, VBScript, HTML, XML, VB .Net 2003, ASP

.Net., FrontPage, Dreamweaver.

Professional Experience

Greyhound Lines, Inc., Dallas, TX Nov 2008 – Present

Crystal Reports / SQL Server Reporting Services (SSRS) Consultant

Greyhound Lines, Inc. (1914) is the largest provider of intercity bus transportation, serving more than

2,300 destinations with 13,000 daily departures across North America. It has become an American icon,

providing safe, enjoyable and affordable travel to nearly 25 million passengers each year.

Responsibilities:

• Explored and analyzed the existing Business Objects Enterprise (BOE) environment and

different reports on Production.

• Administered the BOE Server performing different task such as adding AD users to the

Central Management Console (BOXI), creating enterprise user, assigning rights, creating

folders and publishing reports in different folders.

• Worked with DBA’s to migrate BOE database from existing production server to new server.

• Duplicated the existing OTP and TRIPS reports from US to Canadian versions and set their

destinations to different folders on Intranet.

• Extensively worked in creating different types of reports including standard report, sub

reports, cross tab report, Map report, command based report etc. Created Test Cases and

backout procedures for those report (Crystal and SSRS).

• Scheduled reports to run hourly, daily, weekly and monthly based on their requirements.

• Updated all the SWIFT reports on Intranet to reflect new goals.

• Created Fleet Stat Map Report which reflects all the US locations with the number of buses at

Start of day, number of actual versus planned buses, gain-losses, totals for different regions, etc.

• Migrated Crystal Reports into SSRS and deployed them on Report Server.

• Created and deployed various SSRS reports in Calendar and Standard layouts with static

and dynamic parameters.

• Created Data Transformation Services (DTS) packages which reads data from text files and

loads it into tables. Also, created those tables to load those data in Development Server.

• Extensive knowledge in writing formulas using crystal syntax, shared variables and

expressions (fx).

• Strong experience in writing complex SQL queries.

• Excellent performance in meeting deadlines.

• Documented the report features for future reference.

Environment: Crystal Reports XI, Business Objects Enterprise XI, Windows XP, Oracle

10g, SSRS 2000, 2005, SQL Server 6.5, 7; DB Visualizer 6.5, Sybase 12.0.7 and MS Excel.

Progress Rail Services, Albertville, AL Feb 2008 – Oct 2008

Crystal Report Developer

Progress Rail Services, a division of Caterpillar, is a leading supplier of rail, rail anchors and track work

components as well as maintenance of way equipment, railway signal devices, reconditioned freight car

parts, railcar repair facilities, and railcar and locomotive leasing. Progress Rail Services Corporation has

expanded to become one of the largest providers of railway products and services in North America, with

facilities in 27 states, Canada and Mexico.

Responsibilities:

• The ICAR project involved Designing and developing reports based on the Business

requirements for the two modules namely Finance (FA) and AAR Billing (CRB).

• Analyzed user requirements, procedures and problems in order to automate processing. It

involved the process of evaluating the purpose and content of the reports.

• Duplicated the existing PHP reports (FA) from the CAS System in Crystal Reports.

• Created AAR Billing reports from scratch based on the specification.

• Direct contact with the end users helped to understand the goal of the project from their

perspectives and their expectations.

• Extensively worked in creating different types of reports including standard report, sub

reports, cross tab report, command based report, Chart report etc. Involved in tuning reports

for optimum performance. Optimized the report to export to excel cleanly.

• Also, created reports based on Views and Materialized Views.

• Involved in validating the reports and publishing in InfoView once they are ready for UAT.

• Involved in administrative tasks creating users, groups and assigning different rights to the

groups in Central Management Console (BOXI R2). Also, managed the reporting properties

including database credentials, parameters, folder management.

• Created LOVs for dynamic parameters from Business Views in Business Objects Enterprise

XI R2.

• Moved the reports to production once they finalized by the users.

• Extensive knowledge in writing formulas using crystal syntax and shared variables.

• Strong experience in writing complex SQL queries using Analytical Functions.

• Worked in time constrain and met deadlines.

• Documented the report features for future reference.

Environment: Crystal Reports XI R2, Business Objects Enterprise XI R2, Windows XP,

Oracle 10g, SQL Developer, PL/SQL, PHP, and MS Excel.

John Morrell & CO., Sharonville, OH June 2007 - Jan 2008

Crystal Report Developer

John Morrell & Co. is one of the nation's largest producers of private label processed meat products.

Morrell supplies a majority of the Country's largest retail chains and foodservice distributors with a wide

variety of fresh and processed private label items. The focus of John Morrell & Co. is to supply high

quality products that meet consumers' taste requirements and nutritional needs.

Responsibilities:

• Involved in fixing & maintenance of the existing Crystal Reports to meet user requirements.

• Created a Recap Summary Sub Report of an existing UPC Performance Report.

• Created various parameterized Payroll Reports and applied their standard template.

• Worked extensively on Joins, Left Outer Joins, Sorting, Summary, Count, Grouping,

Filtering, and Drill down features.

• Created formulas using Crystal and Basic Syntax.

• Optimized the report to Export to Excel without blank columns/rows.

• Altered date range of the Stored Procedure to pull a year worth of data ending six months prior

to last sales close.

• Made changes on the Stored Proc according to the specification.

• Conducted Unit Test of the codes.

• Tested the reports after the development phase to validate data before going to production.

• Published the reports on Business Objects Enterprise XI R2 using Publishing Wizard.

• Assisted the administrator in administrative tasks such as creating Users, Groups and assigning

different rights to Groups in Central Management Console.

• Scheduled the report to run according to the specification: run every Tuesday morning to email

the result to the respective users in Excel format.

Environment: Crystal Reports XI R2, Business Objects Enterprise XI R2, Windows XP,

AS400, Oracle 10g, PL/SQL, and MS Excel.

Rohm and Haas, Philadelphia, PA Jan 2007 - May 2007

Crystal Report Developer

The project was for the Pharmaceutical and Medical division of Rohm Haas, a leading specialty materials

company. Responsibilities included working with the clinical analytics team on the measurement of

provider performance, quality improvement initiatives, and various ad-hoc requests. The application had

OLAP features like Drill Down analysis, Multidimensional analysis, Prompts, Exception Highlighting

and User Privileges. Developed new catalogs related to medicine name, description, expiration date,

vendors list etc to be used by the research and marketing department.

Responsibilities:

• Worked with business users and analysts to get the requirements for the reports.

• Involved in user meetings to gather and analyze the reports requirements.

• Created User Defined functions for sharing formulas across multiple reports.

• Created Custom Templates in Crystal Reports.

• Generated and developed reports using Crystal Reports with Standard, Summary, Cross Tabs,

SQL, Selection Criteria, grouping, sub reports etc.

• Used SQL for writing stored procedures, views, and user defined functions.

• Optimized the reports to Export to Excel without blank columns/rows

• Validated the data on the reports

• Published the reports using Crystal Enterprise XI.

• Involved in fixing & maintenance of the existing Crystal Reports to meet user requirements.

• Created numerous Alerts that are executed based upon certain conditions.

• Developed PIE and BAR Charts with Drill down option using Drill down Report Expert.

• Passing parameters from Java to Crystal Reports XI.

• Involved in migration of Crystal Reports from 8.0 to XI.

Environment: Crystal Reports 8.0/XI, Crystal Enterprise XI, Java, JSP, Windows NT 4.0,

Oracle 9i, MS Access, and PL/SQL.

Sprint Nextel, Overland Park, Kansas Aug 2006 - Dec 2006

Crystal Report Developer

Sprint Nextel is one of the leading telecommunication companies providing wireless and wired

communication services. The project involved designing and developing reports on a weekly basis and

publishing them on the web using crystal reports.

Responsibilities:

• Designed various types of reports with Complex Formulas, Custom Functions, SQL

Expressions, Parameters, Drill Down and Sub Reports.

• Designed reports and Cross Tab Reports.

• Used complex formulas and functions in the reports. Also designed the reports with multi level of

groupings.

• Designed reports with conditional formatting, Sorting and Running Totals Enhancing existing

repots by adding computed columns.

• Created different type of reports like Master / Detail and Charts, used filters, conditions,

calculated columns.

• Designed reports with linking sub reports to a master report, underlay formatting, and passing

data between reports and integrated the report with hyperlink.

• Designed the Scheduled reports based on conditions and designed report with Alerts and

Parameters.

• Designed report with Group, Group by intervals, Groups selection and Hierarchical Grouping and

Summary Group report.

• Exported reports into various formats like EXCEL, PDF, HTML, RTF, and WORD for the

user.

• Designed complex reports with Maps and all type of Graphs.

• Designed Report Templates.

• Published and scheduled reports in Crystal Enterprise 10.0 using Crystal Management

Console and Crystal Publishing Wizard.

• Converted Reports from MS-Access to MS-SQL Server 2000/Crystal Reports 10.

• Designed Reports based on Views, Tables, Commands.

• Automated the Productions and Management reports and provided numerical consistency through

Drill Down and multiple groupings.

Environment: Crystal Report 9.0/10, Java, Crystal Enterprise 9.0/10, MS-SQL server-2000,

Oracle 9i, Windows 2003 Server

Genentech Inc, South San Francisco, CA Jan 2006 - July 2006

Crystal Developer

Genentech is among the world’s leading biotech companies, with multiple products on the market for

serious or life-threatening medical conditions and over 50 projects in the pipeline. The company is the

leading provider of anti-tumor therapeutics in the United States. This project was called Commercial

Expense Management System (CEMS) ; it keeps track of all the expenses across the all the projects in

Genentech Inc. CEMS is subdivided into Expense Wizard, Budget Tracking, Content Reports, Budget

Reports, Administration, and Global Pages. CEMS database will be updated from Lawson system.

Responsibilities:

• Extensively involved in creating Ad-hoc queries and SQL statements on demand.

• Involved in gathering and analyzing the requirements.

• Involved in preparing functional and technical specification.

• Involved in development and modification Budget Reports and Content reports.

• Involved in modification of - Budget Variance report and Expense detail report.

• Developed new report - Budget report by project strategy report.

• Developed reports for Commercial Events and Promotional Material projects.

• Involved in publishing Crystal Reports to Crystal Enterprise.

• Worked with Crystal Management Console.

• Created stored procedures on backend and invoked/integrated in Crystal reports.

• Built complex SQL and PL/SQL programs.

• Involved in migration of Crystal Reports from 8.5 to 10.

Environment: Oracle 8i/9i, PL/SQL, SQL, SQL Navigator, Crystal Reports 8.5/10, Crystal

Enterprise, Java, Windows NT.

Covance, Pennsylvania, PA March 2005 - Dec 2005

Crystal Reports Developer

Covance is one of the world's largest and most comprehensive drug development services companies has

the people, global resources and problem-solving culture to respond to pharmaceutical and biotechnology

clients' toughest drug development challenges. It provides a portfolio of preclinical and clinical

development and commercial service offerings delivered through industry-leading non clinical testing

services, the world's largest central laboratory network, and a global team of clinical trial professionals

and cardiac safety experts.

Responsibilities:

• Developed Crystal Reports 9.0 to address diverse levels of the organizational requirements

ranging from Individual employees to a complete line of operations.

• Published and scheduled reports in Crystal Enterprise using Crystal Management Console and

Crystal Publishing Wizard.

• Developed Views in SQL Server database to be deployed in the reports for better performance.

• Developed Cross Tab Reports and Sub Reports by using Crystal Reports.

• Developed, formatted, complex reusable formula reports and reports with advanced features such

as conditional formatting, built-in/custom functions usage, multiple grouping reports.

• Worked on Sub Totals, Running Totals according to report requirements.

• Worked on database expert for managing data source connections and linking activities.

• Worked on Group expert, select expert, sort expert, section expert for different report formatting

activities.

• Created different reports and made modifications in the system as per user requirement.

• Developed various reports based on Multiple Parameters and Prepared Test Plans and Test Cases

for all the Reports and documented the Results.

• Maintained the proper documentation for future enhancement.

Environment: Crystal Reports 10/9.0, Crystal Enterprise 10, SQL Server 2005, TOAD, PL/SQL,

Windows 2000/NT.

United Health Care Insurance, Minnetonka, MN July 2004 - Feb 2005

Oracle PL/SQL & Crystal Reports Developer

UHC provides popular health plans and number one rated service to business and government employers,

labor unions, and individuals of all ages from recent graduates to Medicare beneficiaries.

Responsibilities:

• Created standard reports, cross-tab, sub reports, drill down reports, on-demand sub reports

using Crystal reports10.0.

• Developed various Charts and Graphs like Bar Chart, Line charts, Pie Charts etc by using Chart

Expert.

• Published reports using Crystal Enterprise.

• Created users, groups and folders for each area in Crystal Management console (CMC).

• Extensively involved in using of formula fields, parameter fields, Group selection, record

selection, and Crystal syntax in Crystal reports.

• Extensively involved in SQL, PL/SQL coding creating complex queries, Views, Stored

procedures to give better results at Crystal Reports.

• Created formulas using Crystal and basic syntax.

• Involved in writing the Frond-end Validations using HTML and JavaScript.

Environment: Oracle9i, PL/SQL, Windows XP, Crystal reports 10 and Crystal enterprise 10

State Farm Insurance, Bloomington, IL Jan 2003 - June 2004

Reports Developer (Finance Team)

State Farm Insurance is one of the largest insurance companies in United States and it offers a broad

range of insurances and has full range of managed care programs for individuals, families, employer

groups and seniors.

Responsibilities:

• Generated reports using Crystal Reports 8.5.

• Create different type of reports including Cross-tab, Conditional, Drill-down, OLAP and Sub

reports.

• Worked closely with Finance Analysts, gathering data from discussions.

• Create reports include formatting options such as Grouping, Sorting, Drill-down, Parameter

prompts.

• Modify report content and export reports in multiple formats based on user input.

• Involved in Writing SQL Queries, Views and Stored Procedures on SQL Server 2000.

• Involved in all team meetings involving users and other team members.

• Performed Unit testing while developing reports and worked along with QA group.

• Involved in recursion, unit and QA testing of the screens that were developed.

• Designed Complex reports using sub reports, manual cross tabs using Crystal syntax with

extensive usage of Local, Global, and Shared variables at report formulas.

Environment: Crystal Reports 8.5, Crystal Enterprise 8.5, SQL Server 2000, SQL, PL/SQL and

Windows XP

Exxon Mobil, Houston, TX Mar 2002 - Dec 2002

Crystal Report Developer

Exxon Mobil is an industry leader in the energy and petrochemical business whose organization structure

is built on a concept of global business and is designed to allow Exxon Mobil to compete most effectively

in the ever-changing and challenging worldwide energy industry.

Responsibilities:

• Deployed reports using dynamic connection of data sources and published reports within Crystal

Enterprise system and on the web using web based component Crystal Publishing wizard.

• Administered Crystal Enterprise System using components like Crystal Management Console

for publishing reports on the company’s Intranet and involved in the implementation of security

at Report level, Folder level. Created Users, user groups, roles.

• Excellent experience in Scheduling Reports using e-Portfolio and Management Console.

• Developed Production/Development reports using Crystal Reports 8.5.

• Various Report Forms developed include Cross Tab Reports, Sub Reports, Standard Reports

and Master/Detail Reports.

• Developed complex reports based on multidimensional data using OLAP reporting technique to

figure out the monthly, quarterly, and annual sales of different product grades from different

geographic locations based on different customers.

• Developed PIE, BAR and LINE Charts with Drill down option using Drill down Report Expert.

• Applied heavy formatting for reports and developed reports with necessary Formulas and

Parameter fields.

• Involved in inclusion of linked as well as unlinked Sub-Reports along with the primary reports.

• Created parameterized reports with multiple values using tools like SQL command, Select expert,

Selection Formulas and Formula workshop to filter the records.

• Created and tuned complex Stored Procedures for faster execution and developed database

structures, Crystal Dictionaries according to the user requirement.

• Used MS Access 2000 for Ad-hoc Reporting and simulating SQL Queries & views from the

SQL Server database.

Environment: Crystal Enterprise 8.0, Crystal Reports 8.5, CSP, Windows NT, Oracle 8.0,

PL/SQL, Visual Basic 6.0.

NIIT, Kathmandu, Nepal Jan 2001 - Feb 2002

C Programmer

Responsibilities:

• Designed, coded, tested, implemented, and validated business, and technical information

technology related programs and applications using the SDLC methodology.

• Identified, analyzed, and devised solutions to business and technical information technology

problems.

• Interacted with customers regarding business and technical information technology needs

• Participated in implementations, upgrades, and conversion projects.

• Participated on empowered, virtual teams

• Managed projects within scope of responsibility

• Worked flexible hours

Education:

• Bachelors in Computer Science from Kathmandu University, Kathmandu, Nepal

References Available On Request

Contact this candidate