Sql Server Crystal Reports

**********x***

* ***** ** ** **********, involved in all phases of Software Development Life Cycle such as Analysis, Design, Development, Testing, Implementation, Maintenance, and Report Development using Crystal Reports, Crystal Reports Enterprise and Business Objects Enterprise.

Experience in analyzing data and developing reports using Crystal Reports 2008 V1/XI R2/XI R1/10/9/8.5, Business objects 3.1/XI R2/6.5, Info View, Web Intelligence and ZABO (Zero Administration Business Objects).

Extensive experience in developing very Complex Crystal Reports using Sub-Reports and Cross Tab Reports and Complex Query Reports using Oracle 8i/ 9i, SQL Server 7.0/2000.

Involved in Scheduling and Publishing Reports in Crystal Enterprise via. Crystal Publishing Wizard, Crystal Management Console and also in Business Objects Enterprise 3.1/XI R2 Environment.

Strong BI, OLAP, Data warehousing experience with Business Objects Enterprise, Business Objects, Web Intelligence, CMS (Central Management Server), CMC (Central Management Console), Import Wizard, Publisher, Broadcast Agent.

Extensive work experience with large data warehouses using Star schema, Snowflake schema as well as normalized data structures.

Job roles include gathering business requirements, establishing functional specifications, translating them to design specifications.

Wrote various SQL queries using joins and sub queries in Oracle database to develop a set of custom SQL Views for reports. Expertise in SQL programming.

Experience in development, deploying & scheduling Crystal reports in Crystal Enterprise or BOE.

Worked on Central Management Console for managing, deploying and configuring the reporting infrastructure.

Specialized in creating query reports using SQL Server, MS Access and Oracle.

Experienced in writing complex formulas in crystal reports, SQL queries using Crystal Designer, migration of Crystal reports in different versions.

Experience in working with Crystal Xcelsius.

Experience with creating hierarchies, predefined conditions, customized Lists of Values, Derived Tables and in using @ functions.

Created different types of reports like Cross-tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub-reports with formatting options such as Charting, Mapping, Grouping, Sorting, Alerting, Field highlighting, Drill-down, Parameter prompts

Generated Sub Reports, On Demand Reports, Linked Reports, Mailing Labels, Cross Tab Reports and Graph Reports. Expert in using shared and global variables across the crystal reports. Developed Drill down, Top N, Summary reports

Good communication skills, analytical skills and documentation skills. Excellent interpersonal skills with ability to interact with end-users, managers and technical personnel.

TECHNICAL EXPERTISE

BI / OLAP Crystal Reports 2008/XI R2/XI R1/X/9/8.5, Crystal Reports Enterprise XI, Business Objects 3.1/XI R2 [WebI, InfoView, CMC, PM, DM], Business Objects 6x/5x

DATA MODELING Star-Schema Modeling, Fact & Dimension, RDBMS

DATABASE: Oracle 11g/10g/8i/ 9i, MS Access

MS SQL Server 7.0/2000

TOOLS SQL Developer, SQL*Plus, TOAD

WEB TECHNOLOGIES VB script, Java Script, HTML, XML, DHTML, Microsoft Front Page, Asp.net

OPERATING SYSTEM Windows 95/98/NT/2000, and Windows XP

OTHER MS Office, Adobe Acrobat, Loftware

Contact this candidate