Developer Crystal Reports
Resume:
archana REDDY
**********.*******@*****.***
Summary of Experience:
1. Over 6+ Years of experience in Crystal Reports, Business Intelligence,
Data warehouse, Client/Server and Web application Software design,
analysis, development and implementation.
1. Strong Expertise design and development of simple, complex and Ad hoc
reports using Crystal reports 8.5/9.0/10/XI and Crystal Enterprise
8.5/9.0/10/XI.
1. Proficient in designing Intranet and Internet based database
applications.
1. Proficient in design, development, deployment and administration of
Business Objects Universes, Web Intelligence.
1. Expertise in writing complex formulas in crystal reports, SQL queries
using Crystal Designer, migration of Crystal reports in different
versions.
1. Work with Business Users and team leads to develop system
requirements, analyse data Element and continuous end-user support.
1. Excellent communication and interpersonal skills.
1. Versatile team player with proven problem solving skills. Worked
independently as well as in team environments.
1. Extensive experience in Requirement Analysis, Functional Analysis,
Excellent Conceptual and Logical Thinking, Teamwork, Goal Oriented.
1. Good knowledge and understanding of object-oriented design techniques.
1. Used Visual Source safe and MKS to handle version control.
1. Expertise in using report tools like Crystal Reports 8.5, 9, 10, XI
having developed over 400 complex Crystal Reports including Sub
Reports, Cross Tab, Charts, label containing formula and date wise
filtration features.
1. Extensive experience with creating various kinds of Crystal Reports
containing formula and date wise filtration features, run time
calculation, conditional formatting features.
1. Involved in developing screens of application using Spring and
hibernate.
1. Spring MVC architecture is used.
1. Implemented MVC architecture using RAD 7 IDE.
1. Used Hibernate as the ORM mapping tool.
1. Involved in designing screens using JSP and Servlets.
1. Address business needs. Assist business analyst in performing
functional testing.
Technology Skills:
Languages : HTML, PL/SQL, SQL, XML.
Reporting tools : Crystal reports 8.5/9.0/10/XI, Crystal Enterprise
8.5/9.0/10/XI, BO Web intelligence XIR2
Databases : Oracle 8i/9i/10g, MS Access, MS SQL Server 2000/2005
Operating Systems : Windows 2000/XP/VISTA, MS-DOS
Web/App Servers : Apache Tomcat, Web Sphere Server 6.0, MS IIS 5/6.0
Technologies : Spring, Hibernate, JSP, Servlets
Packages / Tools : MS Office, SQL Developer, TOAD, SQL Plus
EDUCATIONAL BACKGROUND:
1. Bachelors in Pharmaceutical Engineering
1. Sun certified Java Programmer 1.4
PROFESSIONAL EXPERIENCE:
Blue Cross Blue Shield, Columbia, SC
June 08- Till Date
Sr. Crystal Reports Developer
Blue Cross Blue Shield is one of the largest Insurance companies
offering healthcare insurance to individuals, families and businesses. The
Performance Analysis & Reporting system was designed to measure the
information about incident management, configuration management, change
management, problem management, financial management, risk management and
operation infrastructure management. This application provides metrics to
CMS in order analyze the overall assessment of management program. This
system creates reports to provide metrics to the management system to steer
and control the global IT organization which spread all over the world.
Applications include MRTSV2, ITSV2, Proven Track, CBIC-ITS, CBIC-IRIS.
Project: Medical Review Tracking System (MRTSV2)
Roles & Responsibilities
1. Designing and analyzing Reports using Crystal Report XI R2.
1. Involved in developing screens of application using Spring and
hibernate.
1. Spring MVC architecture is used.
1. Implemented MVC architecture using RAD 7 IDE.
1. Used Hibernate as the ORM mapping tool.
1. Involved in designing screens using JSP and Servlets.
1. Developing Cross Tab Reports linked Sub Reports and graphs using
Crystal Reports XI R2.
1. Developing formulae using both the crystal syntax and the basic syntax
to use in the reports and for reusability.
1. Using dynamic cascading prompts and static parameters for different
record selection criteria.
1. Built reports using drill down and hierarchal grouping functionalities
of crystal.
1. Created alerts and filters in several reports.
1. Created Deski and Webi ad-hoc reports using various Universes.
1. Exporting reports into various formats like Editable RTF, XML, PDF,
HTML, EXCEL, and WORD using Crystal Reports XI for user.
1. Modified exiting Universes and designing classes and objects using
Universe Designer on XI R2/ R1.
1. Resolving loops using aliases and contexts by checking the integrity
and also developed user objects.
1. Involved in developing screens of application using Java J2EE.
1. Used spring and hibernate in developing the application.
1. Used Groups, formulas, Interactive Sorting, SQL Commands, SQL
Expressions, Dynamic Cascading Prompts, running totals and summaries
in the reports.
1. Creating various object Attributes, Facts, Filters, Attribute element
Prompts.
1. Publishing objects to Business Objects XI R2/R1 Enterprise system
using Import Wizard, Publishing Wizard, Infoview and CMC.
1. Used Schedule Manager to change the database parameters for multiple
reports at once while migrating reports between environments.
1. Extensively worked with different types of Sub reports and tuned the
reports for optimum performance.
1. Involved extensively in designing future enhancements of the
application.
1. Extensively used SQL Developer (Oracle).
1. Wrote several database objects like package, stored procedure,
triggers etc using Oracle PL/SQL.
1. Configuration Management (CM using MKS) and release management
provided QA/Production Support (24X7).
1. Created, modified views and created indexes in the database for
performance tuning.
1. Interaction with the End users for the Functional requirements and
Design specifications
1. Gather the business requirements, Analysis of user requirements and
outline the proposed IT solution.
1. Address business needs. Assist business analyst in performing
functional testing.
Environment: Java, J2EE, RAD 7 IDE, Jsp, Servlets, Spring, Hibernate,
Tomcat server, Crystal Reports XI R1/ XI R2, Oracle10g, MKS version
control, SQL Developer and PL/SQL.
Project: Inquiry Tracking System (ITSV2)
Roles & Responsibilities
31. Involved in developing screens of application using Spring and
hibernate.
31. Spring MVC architecture is used.
31. Implemented MVC architecture using RAD 7 IDE.
31. Used Hibernate as the ORM mapping tool.
31. Involved in designing screens using JSP and Servlets.
31. Involved in communicating with registered clients to resolve the
requirements issues and to deliver the best results more than what
they expect.
31. Involved in designing reports using crystal and generate queries in
SQL Developer and Oracle10g database.
31. Used Groups, formulas, Interactive Sorting, SQL Commands, SQL
Expressions, Dynamic Cascading Prompts, running totals and summaries
in the reports.
31. Extensively worked with different types of Sub reports and tuned the
reports for optimum performance.
31. Involved extensively in designing future enhancements of the
application.
31. Address business needs. Assist business analyst in performing
functional testing.
31. Gather the business requirements, Analysis of user requirements and
outline the proposed IT solution.
31. Created and used queries using Add Command object in Crystal Reports
XI.
31. Involved in scheduling the daily, Weekly and monthly reports using
Crystal Enterprise XI.
31. Extensively involved in using of formula fields, parameters, Group
selection and record selection in Crystal reports.
Environment: Java, J2EE, RAD 7 IDE, Jsp, Servlets, Spring, Hibernate,
Tomcat server, Crystal Reports XI R1/ XI R2, Oracle10g and MKS version
control.
American International Group, Inc, Jerseycity, NJ
January 2008- April 2008
Crystal Reports Developer
American International Group, Inc. (AIG), a world leader in insurance
and financial services, is the leading international insurance organization
with operations in more than 130 countries and jurisdictions. AIG
companies serve commercial, institutional and individual customers through
the most extensive worldwide property-casualty and life insurance networks
of any insurer. This project is Involved in enhancing existing reports and
creating some more new reports meeting the requirements.
Roles & Responsibilities
1. Participated in detailed report design and created design
specification documents at report level.
1. Created dash board reports for top level management to view the
performance of the organization.
1. Extensively involved in using of formula fields, parameters, Group
selection and record selection in Crystal reports.
1. Used conditional formatting to the reports as per the requirements.
1. Involved in writing command objects for the report generation.
1. Involved in scheduling the daily, Weekly and monthly reports using
Crystal Enterprise XI.
1. Involved in writing Custom Functions to be used in other Functions.
1. Extensively involved in writing Views, Stored Procedures and
Queries in SQL Server and testing the data using PL/SQL Developer
and used them in creating the reports.
1. Created and used queries using Add Command object in Crystal
Reports XI.
1. Involved in the migration of Business Objects XI R1 to XI R2SP2.
1. Creation of synonyms for common objects.
Environment: Business Objects XIR1/XI R2 SP2, Crystal Reports XI R1/ XI R2,
Windows 2k3/2k, Universe Designer, Web Intelligence, Publishing Wizard,
Import Wizard, SQL Server 2000.
Power Systems Inc., Titusville, FL
March 2006 - Dec 2007
Crystal Reports Developer
Description:
The objective of this project is to provide specialists with
individual results regarding satisfaction with their performance throughout
the year among Managers and Financial Analysts they have supported. These
results are developed in Crystal Reports for individual performance
evaluations.
Responsibilities:
1. Developed reports with different and multiple parameter fields and
multiple grouping for different hierarchy levels and published them
using the Crystal Enterprise 10.
1. Transformed 120+ crystal Reports from Business Objects 6.5 to
Crystal Enterprises
1. Exported reports into various formats like Editable RTF, XML, PDF,
HTML, EXCEL, and WORD using Crystal Reports XI for user.
1. Developed formatted, complex reusable formula reports and reports
with advanced features such as conditional formatting, built-
in/custom functions usage, multiple grouping reports.
1. Designed and implemented Ad hoc Reports, Extracting Data from an
SQL Server database.
1. Responsible for developing provisioning reports for various
groups and upper management.
1. Various Report Formats developed include Sub Reports, Cross Tab
Reports, Standard Reports and Master/Detail Reports.
1. Responsible for development of standard reports in Crystal version
10 for the Vendor Sell buyback database and was the key report
developer and Prod support for the project.
1. Actively involved in gathering user Requirements, User/System
Documentation, user training and testing developed reports for
final deployment.
1. Involved in tuning of Crystal Reports for better performance and
worked with PL/SQL and TOAD designed by Quest software for query
analysis.
1. Developed various stored procedures and functions in Oracle to
improve the performance thus concealing complexity from the front-
end application.
1. Deployed reports on the web and scheduled reports using Crystal
Management Console.
1. Involved in the administration of Management Console for
implementation of security at Report level, Folder level. Created
Users, user groups.
1. Created various objects Attributes, Facts, Filters, Attribute
element Prompts and Metrics.
1. Developed, tested and implemented Business Objects Universe
modifications.
1. Created several Universes as per the user needs.
1. Involved in developing the financial reports for the Financial
services Dept and successfully published the highly formatted
reports and met with the end user requirements.
Environment: Crystal Enterprise 10, Crystal Report 10, Oracle 9i, SQL
Server 2000
Eastern Financial Credit Union, Miami, FL July
2005 - Feb 2006
Enterprise Administrator/Reports Developer
Description:
Insight is a full-scale customer banking operations software module.
The entire banking operations included account settlement, processing,
overrides, cycle and balance details etc. The purpose of this application
is to determine and grab the information for each department and identify
the expenditures associated.
Responsibilities:
1. Designed and analyzed various complex Reports using Crystal Report
reporting tool.
1. Designed and implemented Ad hoc Reports, Extracting Data from an
SQL Server database.
1. Developed various Charts and Graphs like Bar chart (Side By Side,
Stacked), Line graphs, Pie -Charts etc by using Chart expert of
Crystal Reports.
1. Created various types of reports of type Standard, Cross Tab, Drill
Down, Sub Reports, Form Type, Letter, and Label Type etc.
1. Developed Report controls to send the Parameters to Reports.
1. Created Graphical and Statistical reports of different Natures and
Types.
1. Used multiple sub reports, pass through parameters and pass by
parameter linking for generating complex reports for management.
1. Gather, analyze, transform, and validate business requirements into
system requirements.
1. Define and enforce standards and conventions (definition, naming,
and abbreviation).
1. Work with Business Users and team leads to develop system
requirements, analyze data Element and continuous end-user
support.
1. Experience managing user accounts and group accounts in Crystal
enterprise environment.
1. Extensive experience working with End Users, Business System
Analysts in understanding their requirements, assisting in
providing technical solutions and implementing them.
1. Handle daily operation and support and define standards,
guidelines, and best practices.
1. Group lead in Migration process from Business Objects 6.5 to
Crystal enterprise10.
1. Conduct on-going tuning and monitoring to maintain and improve the
performance and stability of the environment as well as to plan and
implement upgrades and migrations.
1. Maintain the client's work plans and status reports facilitate
departmental status meetings; manage small project assignments.
1. Work with production team to coordinate and assist in roll-out of
releases.
Environment: Seagate Crystal Reports 8.5/10/XI Windows NT/2000, XML,
Business Objects 6.5, Crystal Enterprise 10 and Oracle 9i
Narne Solutions Pvt Ltd, India Aug 2003 -
May 2005
Data Analyst / Reports Developer
Description:
The system is an interface between a Weigh Bridge and Computer. The
system maintains the database for suppliers, materials, Vehicles and weight
details. The system generates supplier-wise, material-wise, Vehicle-wise
and Other MIS reports.
Responsibilities:
1. Study the existing system and analyse the existing reports and
supporting the user requirements.
1. Writing PL/SQL procedures for Summary/Consolidated data for
creating reports.
1. Responsible for creating monthly files for sales support team with
the data needed for the Marketing needs.
1. Creating the Reports for IWS Team, this supports the sales on WEB.
1. Created the Complex reports using stored procedures, Views, Info
queries.
1. Created complex reports with sub reports, parameters, drill down,
graphical reports, cross tabs, dynamic grouping reports.
1. Preparing the requirements Document (PRD) and working with the
database support team to design of tables, writing PL/SQL
procedures and loading the data for Reporting needs.
1. Publishing the reports in Crystal enterprise using crystal
publishing Wizard.
1. Posting, scheduling and distributing the reports using crystal
enterprise e-portfolio.
Environment: Crystal Reports 7.0, Oracle Database, Windows 95.
Contact this candidate