Crystal Reports Project

Naveed KHAN

Cell: 202-***-****

Email: ******.****@*****.***

Professional Summary:

> 5+ years of experience as a Software programmer on Crystal Reports,

SAP Business Objects (6.5 through XI R3), Informatica and Java

technologies

> Extensive background in all phases of the project life cycle including

requirements gathering, developing prototypes, functional

specification, design, implementation, debugging, testing and

documentation

> Expertise over preparing Report specifications, Database designs to

support the reporting requirements

> Extensively used Crystal Reports version 9 through XI R2 and have

migrated reports in development environment to Crystal reports 2008

> Worked extensively in developing Procedures, Triggers, Views on

database like Oracle 8i, 9i and 10g, SQL server 2000 and 2005

> Worked as a Business Analysts gathering requirements, functional

specifications, building test cases and other project relates

documents

> Designed and developed Crystal Reports, Sub reports, Gantt/Pie/Bar

Charts, Groups, Parameters, Formulae, Summaries, Cross Tab Reports,

Top N Reports for highlighting significant data, Summary Reports with

Drill-down capabilities.

> Worked using BOXI Designer, Business Intelligence platform, created

Web Intelligence and Desktop Intelligence reports in BOXI environment.

> Administered and Scheduled batch of reports in BOXI R3 environment

with multiple Data Sources. Used E-portfolio for accessing Crystal

Reports via Crystal Enterprise

> Experience converting Microsoft SSRS reports to Crystal Reports in

Business Enterprise Environment.

> Excellent Microsoft Office skills used for exporting and documenting

the work done in Crystal Reports

> Has good knowledge of Business Objects Enterprise XI Architecture,

experience in Installation, Migration, Configuration and Maintenance

of Business Objects Enterprise, Created Users and Groups in multiple

Business Objects environments, and Assigned Rights to Users.

> Knowledge of programming languages like C, JAVA 2.0

> Has comprehensive Data Warehousing, ETL and data integration

experience in developing ETL mappings using Informatica PowerCenter

> Active team player and as an individual with Excellent Communication,

Interpersonal skills, self motivated fast learner and good listener.

And has demonstrated ability to handle multiple tasks as well as work

independently or in a team

> Good understanding of Business Processes and a quick learner

Technical Skills:

Languages : JAVA, .NET, C, C++, SQL, PL/SQL, VB

6.0

Reports : Crystal Reports 2008, XI REL2, XI, 10, 9, Seagate

Crystal Reports 8.5, Business Objects XI

REL2, Visual

Basic.

RDBMS : Oracle 8i, 9i, 10g, SQL Server 2000,

2005, DB2,

TERADATA and MS-ACCESS

Database Debugging Tools : Toad, SQL Query Analyzer, SQL Programmer.

Version Management Tools : Microsoft Visual Source Safe, CVS, SVN,

PVCS.

Operating Systems : Windows 2000/XP/2003, UNIX

Application Software : Office - 2000 (Word, Excel, Power

Point)

Tools/Frameworks/Libraries : Eclipse, Hibernate, and JUnit

Web/Application Servers : IIS 6.0, 5.0, Tomcat Apache Server, BEA's

WebLogic

and IBM WebSphere

ETL Tools : Informatica PowerCenter 7.1, 8.1.1

CERTIFICATIONS:

. Business Objects Certified Professional for Crystal Reports 2008

(Registration number : 229388606 Validation number : 8567070 )

. Brain bench Certified Reports Designer for Crystal Reports XI

. Brain bench Certified Programmer for PL/SQL RDBMS Concepts

. Sun Certified Java Programmer (SCJP 1.4) and Brain bench Certified

Programmer for Java 2 Fundamentals

Projects:

CNA Insurance, Chicago, IL

Nov' 09 - Till Date

Crystal Reports Developer

Environment: Crystal Reports XI R2, Business Objects XI R2, Oracle 10g, SQL

Developer, Windows NT/2003

Project Description:

This Project is about RCT (Risk Control) Reporting wherein the data is

loaded in Oracle 10g database which serves as the datasource for the

Crystal Reports V XI R2. This database is daily updated so as to have the

most current data. The reports are then published onto the Business Objects

Enterprise to share it with the other report developers and with the

Testing team. The reports are then checked out after UAT.

Responsibilities:

> Designed reports in Crystal reports XI V R2 against Oracle 10g

database containing RCT tables and views.

> Worked with Business Analysts in finalizing the data requirements.

> Created Views, Synonyms and Store Procedures which is used as a

data source for designing reports.

> Used Grouping, Summaries, Parameters, Hyperlinks, Custom functions,

Formula fields, etc.

> Extensively used advance features of Business Objects Enterprise

like OpenDoc for Passing Parameters to other reports and also to

call one report from other.

> Used Print State and Evaluation time functions as well to control

the data reporting.

> Worked with Dynamic Cascading Prompts so as to get the most recent

and specific data for the parameters selected.

> Created Dynamic prompts using Business View Manager.

> Also used the DateTime, Ranges and String functions.

> Extensively used Shared variables between Main and Subreport.

> Worked with Select Expert, Section Expert, Group Expert, Template

Expert and Record Sort Expert.

> Also shared the Custom functions created with other developers

using Repository and Enterprise Explorer.

> Published reports in development and UAT environments for business

analysts and testing team to test these reports in Enterprise and

then check out.

> Created complex formulae for Time Period Prompt values like Rolling

12 Months, YearToDate, Year Ending, QuarterToDate, Month Ending and

Week Ending.

> Involved in Tuning and improving the performance of reports.

> Documented the data and work flow of RCT.

> Provided the post production support as needed so as to overcome

the issues faced during the migration of reports from Development

to Production.

HONDA of America Mfg, Marysville - OH/Arlington, VA Oct'

08 - Oct' 09

Crystal Reports/Business Objects Developer

Environment: Crystal Reports XI R2, Business Objects XI R2, Oracle 10g,

TOAD, Windows NT/2003, UNIX.

Project Description:

This Data Warehouse is constructed to stage the Parts Inventory related

data for an Auto company. Informatica is used to Extracting data from

source system to target systems. There are numerous sources of data coming

into the warehouse including flat files and Excel spreadsheets. This data

was massaged before loading it into destination and reports were created in

Crystal Reports XI R2 which included part-specific detail reporting, part

inventories etc.

Responsibilities:

> Developed reports in Crystal reports XI against Oracle 10g database

which hosted the Auto parts data

> Worked with Business Analysts on finalizing the requirements and in

creating BRS/SRS documents

> Administered Business Objects Enterprise, Central Management

Server(CMS)

> Worked with database developers in mapping the fields in the

requirements to actual tables in Oracle and created the SRS

documents

> Designed few Universes so that database underlying complexity is

hidden from programmers.

> Designed crystal reports based on Oracle tables/oracle stored

procedures

> Extensively used Oracle functions in creating PL/SQL procedure and

have also used different in-built functions in Crystal reports

formula editor

> Published reports in different development and UAT environments for

business analysts to test these reports in Enterprise and sign off

> Created reporting usage document which detailed the report design

> Created Views, Stored Procedures and Functions Using SQL, PL/SQL

> Responsible to update template Text Objects, Logos, Commands in the

Crystal Repository for other developers to share them

> Documentation to describe Program Development, Logic, Coding,

Testing, changes and corrections

> Responsible to support the issues with reports on the crystal

enterprise environments

> Created WebI documents, created alerts, filters and Inserted Breaks

in designing reports

> Complicated reports have been generated using stored procedures

> Performance tune and do the formatting fixes on the existing

reports

> Designed and developed reports, analyzed and established the links

to the existing reports with the new/migrated databases

> Used charts, grouping, and summary and optimized reports

performance

> Developed the confirmation letter reports which get mailed to

participants.

> Provided post production support as needed

National Education Association, Washington DC June

'07 - Sept '08

Crystal Reports /Business Objects Developer

Environment: Crystal Reports XI R2, Business Objects Enterprise, MS-SQL

Server, Windows XP

Professional

Project Scope:

The project mainly aims in loading the data from XML, flat files and other

data sources to SQL Server database and updates reports of NEA, which

deals in the educational products for it clients. Involved in developing

reports which involved daily turnover reports, forecasting of the sales and

market trend reports, accounts payable reports and expenditure/encumbrances

reporting.

Responsibilities:

> Created Reports that includes Grouping, Sorting, Alerting, Field

highlighting, Formula fields

> Worked as a Business Analysts gathering requirements, functional

specifications, building test cases and other project relates

documents

> Performed User Administration like managing User Rights and

maintained Global Level, Folder Level and Object Level security

> Created 2 Universe and extensively used it in report design.

> Manipulating data through various presentation styles such as Bar

charts, Pie Charts and Line graphs

> Converted Reports created in MS SQL Server (SSRS) to Crystal

Reports.

> Implemented Cross tab Reports and Sub Reports

> Designed and developed various types of Reports (Pivot, Tabular,

Chart Reports)

> Periodical Scheduling for Reports to run automatically. Complicated

reports have been generated using store procedures

> Synchronize reports using multiple data providers using Web

Intelligence

> Regularly analyze the reports in earlier builds and make

enhancements to them if possible, and include them in the current

build

> Responsible to make reports on checking the database and recommend

the updating in database if any.

> Interacted with the users to analyze the changes for improvement

they need in existing reports and developed the reports to satisfy

their needs and requirements

> Was responsible to develop customize reports requested by Clients

> Exported Reports into PDF and Excel formats.

> Responsible to make sure Email, FTP, and Unmanaged Disk options of

scheduling are always up and running.

> Also worked in Informatica using Filter and Update Strategy

transformations for DML operations

> Worked on Informatica job scheduling like Cron in UNIX environment.

RBMG INC (NOW NETBANK INC), Columbia- SC Jan '06 -

May '07

Crystal Reports Analyst

Environment: Crystal Reports 9/10/XI, Oracle 9i and Windows XP Professional

Project Scope:

This application is industry-leading mortgage processing system. System is

a complete mortgage solution, from the origination of the loan all the way

through automatic credit reporting and approval and finally loan shipping

to the servicing division.

Responsibilities:

> Responsible for performing administration activities such as

performance tuning of formulae, database tuning and Managing User

Access.

> Support the report issues and Administration of Crystal Enterprise

Server.

> Periodical Scheduling for Reports to run automatically. Complicated

reports have been generated using stores procedures

> Used NT authentication extensively on Enterprise side to

authenticate users into Crystal Environment.

> Worked as a Crystal reports developer for creating number of

reports for Credit, Sales, Document Funding, application Security

etc

> Regularly analyze the reports in earlier builds and make

enhancements to them if possible, and include them in the current

build.

> Worked with the end users and higher management to gather

requirements for reports and data analysis

> Created reports using Crystal Reports with Standard, Summary, Cross

Tabs, SQL, Command Objects, Selection Criteria, grouping, sub

reports etc

> These reports used Crystal formulas, Parameters, Graphical

Representations, etc

> Worked with TOAD to study the data in different systems and to

validate reports

> Created Views, Stored Procedures and Functions Using SQL, PL/SQL

> Published Crystal Reports in web based environment using Crystal

Enterprise

> Provided technical assistance, training and mentoring to Users and

Business Partners

New York City Health and Hospitals Corp, NYC - NY Apr

'05 - Dec '05

Crystal Reports Analyst

Environment: Crystal Reports 8.5/9, Oracle 9i, Toad and Windows Operating

System

Project Scope:

The New York City Health and Hospitals Corporation (HHC) are the largest

municipal hospital and health care system in the country. There was a need

to create complex reports on daily, weekly and monthly basis with a goal of

providing a progress statistics to the Health and Hospitals community.

Responsibilities:

> Developed reports on Oracle 9i using Crystal Reports 8.5

> Involved in creation of Reports, Formatting reports, generation of

charts

> Created complex reports using multiple queries and involved in tuning

the reports in order to increase the accessing speed

> Responsible to develop reports including complex formulae, Commands

and SQL Expressions

> Responsible to update template Text Objects, Logos, Commands in the

Crystal Repository for other developers to share them.

> Resolved the Performance issues/Data issues with Reports and

Procedures

> Exported Reports into PDF & Excel from Enterprise and resolved

formatting issues

> Modified the format and structures according to requirements

> Develop price settlement variances in the crystal reports

grouped by plant level

> Periodically scheduling for reports to run automatically, activity

optimization of queries, implementation and periodic maintenance

> Created Alerts, Filters, used Prompts and inserted breaks in designing

reports

> Assisted Tech Lead on creating product profiles to install and

configure Crystal Enterprise in Production environment

GE Health Care, NJ

Oct '04 - Mar '05

Crystal Reports /Crystal Enterprise Developer

Environment: Crystal Reports 9.0/10, MS-SQL Server, Windows XP Professional

Project Scope:

GE Healthcare provides transformational medical technologies and services

to its patients with broad range of products. The project includes

generating the statistical reports, periodically scheduling and optimizing

performance of reports.

Responsibilities:

> Participated in the design and coding of distributed reports tailored

to a specific business need or external client customization

requirements

> Developed monthly billing reports and modified late and missing

reports

> Used Reference cursors, Unions, Joins extensively in Stored Procedures

> Created parameterized Crystal reports and customize existing reports

for presentations using Summary Reports, Detail Reports, Cross-Tab

reports and Sub-reports

> Created database connections to connect to data sources

> Created several complex Stored Procedures, Views and integrated them

with Reports

> Published and scheduled the reports in Crystal Enterprise using

Crystal Management Console

> Worked closely with the DBA team to identify, resolve bugs and issues

related to the Crystal Reports and Stored Procedures

> Wrote complex Crystal Report formulas and code

> Presented detailed analytical reports to higher management

Contact this candidate