Crystal Reports Developer

REKHA BALUPARI

Phone-224-***-**** ********@*****.***

PROFILE

. Five years of extensive experience in delivering critical solutions at

various levels of Software Development in Databases and Reporting

. Four years of experience in design, development and implementation of

Reports using Crystal Reports 8.5/10/XI, Crystal Enterprise 8.5/10/XI,

SQL and PL/SQL

. Experience in Database Development using Oracle 10g/9i/8i, MS SQL Server,

Teradata and MS Access.

. Created different type of reports including: SQL Command, Cross-tab,

Drill-down, Top N, Summary, Grouping, Sorting and Sub Reports.

. Extensive experience in Data Analysis, Data Mapping, Writing technical

specifications and gathering business requirements from end users.

. Proficient in conducting design sessions, User Acceptance Testing, User

Training, Knowledge transfer and Documentation.

. Excellent problem resolution and communication skills with ability to

work under pressure in a highly visible role and work in a team

environment.

SKILLS

Reporting Tools Crystal Reports 8.5/10/XI/2008, Crystal Enterprise

10/XI, Business Objects Enterprise XI

Databases Oracle 10g/9i/8x, Teradata 7, SQL Server 6.5/7.0/2008,

MS Access 97/2000

Database Tools SQL Plus, PL/SQL Developer, TOAD, SQL *Loader, Oracle

SQL Developer

Programming C, Visual Studio 2008

Tools

Web Technologies HTML, XML, DHTML

Operating Windows XP/NT/2000/98/95

Systems

EXPERIENCE

University of Michigan, Ann Arbor, MI

March 2010- To Date

IT-Architecture Engineering & Construction

Role: Reporting Consultant

The University of Michigan is one of the top 18 universities in the world

and the highest ranked U.S. public university. Responsible for design,

development and implementation of New Reports and resolving issues & errors

of migrated reports.

Responsibilities:

. Performed data analysis, requirements gathering and created data mapping

documents to develop the reports using Crystal Reports 2008.

. Writing SQL commands for processing business logic in the database.

. Understanding the source data and Involved in detailed designing and

development of moderate to complex reports.

. Developed new reports in operations, Inspection, Project accounting,

Approval Tracking categories.

. Responsible for resolving migration errors of Crystal Reports

. Primarily involved in ensuring quality of over 50 reports and performing

defect root cause analysis.

. Troubleshoot the complex Production issues and resolve the issues.

. Consult with the client to analyze system requirements, identifying

associated risks and resolve problems.

. Troubleshooting the complex issues and errors in the reports.

. Post implementation support including data integrity checks, technical

support and troubleshooting.

Environment: Crystal Reports 2008 SP2, MS SQL Server 2008, MS Visual Studio

2008

Nationwide Insurance, Columbus, OH

May 2009 -February 2010

IT- Enterprise Information Systems

Role: Reports Developer

Nationwide Insurance offers vehicle, property, life, travel, pet & farm

insurance protection.

Responsibilities:

. Actively involved in the data analysis, business requirements for

Business Reporting using Crystal Reports 10/XI and understanding the

source data.

. Each Application provides information about the Applicant, Applicant

relationship, Applicant contact, Beneficiaries, Application, Application

Producer, Application Sales Representatives, and Application Status etc.

. Developed Reports using Crystal Reports 10 using Standard, Summary,

Grouping, Formulas, Cross Tab, Sub Reports and SQL Command

functionalities.

. Administered Crystal Enterprise servers using Crystal Management Console.

. Responsible for migration of Crystal Reports from development to model

office testing environments and to production environment.

. Scheduled reports using Crystal Enterprise 10 to be exported to shared

folders and to be emailed to the business users in required file format.

Environment: Crystal Reports 10/XI, Business Objects Enterprise XI, Oracle

10g/9i, Rapid SQL, Oracle SQL Developer, Erwin, Windows NT 4.0.

University of Michigan, Ann Arbor, MI

October 2008- March 2009

IT-Plant Operations

Role: Reporting Consultant

Responsibilities:

. Actively involved in the data analysis, requirements gathering for

Business Reporting using Crystal Reports XI Release 2.

. Understanding the source data and Involved in detailed designing and

development of moderate to complex reports.

. Developed Reports in Crystal Reports XI Release2 using Standard, Summary,

Grouping, Formulas, Cross Tab and Sub Reports functionalities.

. Responsible for resolving migration errors of Crystal Reports from

Production environment to testing environments.

. Primarily involved in ensuring quality of over 180 reports and performing

defect root cause analysis.

. Consult with the client to analyze system requirements, identifying

associated risks and resolve problems.

. Troubleshooting the complex issues and errors in the reports which failed

the user acceptance testing.

. Completed Unit testing and Integration testing.

. Post implementation support including data integrity checks, technical

support and troubleshooting.

. Responsible in short listing resumes and Interviewing Candidates for the

Reporting Consultant position.

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

11g, Oracle SQL Developer.

Kaiser Permanente, Oakland, CA

January 2008 - August 2008

Management Information Analysis

Role: Crystal Reports Programmer

Kaiser Permanente is the largest nonprofit health care industry in the

United States serving 8.6 million members in nine states.

Responsibilities:

. Primarily involved in the data analysis, business requirements for

Business Reporting using Crystal Reports 10/XI.

. Understanding the source data and Involved in designing and Creation of

Intermediate tables for reporting purposes.

. Developed Reports using Crystal Reports 10 using Standard, Summary,

Grouping, Formulas, Cross Tab, Sub Reports and SQL Command

functionalities.

. Scheduled the reports using Business Objects Enterprise to export the

reports in MS Excel/PDF to various business users.

. Designed Test Cases based on the requirements and worked with Business

Analysts to test the reports.

Environment: Crystal Reports 10/XI, Crystal Enterprise 10/XI, Oracle

10g/9i, Rapid SQL, Windows NT 4.0.

Auto Desk, San Rafael, CA

November 2006 - November 2007

Role: Reports Developer

AutoDesk is the leading provider of computer aided design software. One of

their products AutoCAD is widely used in the industry.

Responsibilities:

. Actively involved in the data analysis, business requirements for

Business Reporting using Crystal Reports 10/XI and understanding the

source data.

. Developed Subscriptions related reports using Crystal Reports 10/XI using

Standard, Summary, Grouping, Cross Tab, Sub Reports, Charts and SQL

Command functionalities using formulas, filters.

. Designed Test Cases based on the requirements and worked with Business

Analysts to test the reports.

. Responsible for migration of Crystal Reports from development to testing

environments and to production environment.

. Scheduled the reports using Business Objects Enterprise to export the

reports in MS Excel/PDF to various business users.

. Created Crystal Reports User documentation and involved in end user

training.

Environment: Crystal Reports 10, Business Object Enterprise, Oracle 9i and

Windows NT

Delta Dental, San Francisco, CA

January 2006 - October 2006

Role: Crystal Reports Developer

Delta Dental is a member of the nationwide Delta Dental Plans Association

covering 50 million Americans and dentists nationwide. Delta Dental offers

a variety of dental benefit plans to individuals/families and seniors.

Responsibilities:

. Writing SQL commands for processing business logic in the database.

. Creation of different types of reports like Standard, Summary, Grouping,

Cross Tab, Sub Reports and SQL Command functionalities using formulas,

filters.

. Developed various reports to extract the data in MS Excel format for the

analysts to further process the data.

. Created functionalities to export the reports to PDF, Excel, Text and

Word documents

. Scheduled reports using Crystal Enterprise to be exported to shared

folders and to be emailed to the business users in required file format.

. Production monitoring and resolving post production issues.

Environment: Crystal Reports 9/10, SQL Server, Oracle, Windows NT

Bharat Heavy Electricals Limited

June 2004 - June 2005

Hyderabad, India

Role: Team Member/Developer

Bharat Heavy Electricals Limited is the largest engineering and

manufacturing enterprise in India in the energy related infrastructure

sector.

Responsibilities:

. Clarified the requirements by talking to the user groups and accordingly

modified the functional and technical specifications.

. Developed / modified scripts to create tables, views and executed them

using SQL Plus.

. Developed / modified scripts to rectify data errors and executed them

using SQL Plus.

. Developed / modified Oracle PL/SQL codes like stored procedures,

functions, triggers etc based on technical and functional specification

documents.

. Ran batch jobs for loading database tables from flat files using SQL

Loader.

. Involved in documenting the modifications and intended functionalities.

. Prepared unit test cases and executed the same.

Environment: Oracle 9i, PL / SQL, TOAD, Windows 2000, Visual SourceSafe,

SQL Loader

EDUCATION

Bachelor of Technology, JNT University, India

Contact this candidate