Crystal Reports Developer
Resume:
Ravinder R Vurady
____________________________________________________________________________
__
Summary of Experience:
. 11 Years of experience in Report Writing using Crystal Reports, Business
Objects, ASP, Oracle, Sybase and Sql Server.
. Expert in creating reports using Crystal reports, Oracle Reports, Webi
and Crystal Enterprise/BO XI.
. Specialized in creating complex query reports using Oracle 8/9i/10g, Sql
server 7/2000, Sybase, DB2, MS Access.
. Expert in Creating Views, Stored Procedures and Functions in Sql Server
7/2000/2005 and Oracle.
. Experience in gathering requirements, creating design documents and
technical documents for the reporting needs.
. Expertise in Analyzing, Coding and Implementing Sql queries and Stored
Procedures using various RDBMS.
. Experienced in writing complex formulas in crystal reports, SQL queries
using Crystal Designer, migration of Crystal reports in different
versions.
. Excellent interpersonal communication, problem solving skills,
documentation skills and Business analytical skills.
. Experience in user training and documenting the methodologies and
requirements.
. Possess good knowledge in Business Objects, Cognos Power Play, Impromptu
and transformer.
. Proficient in Data Warehousing Concepts, OLAP tools and creating Reports.
SKILL SET:
Reporting Tools Crystal reports 8.0/8.5/9.0/XI/R1/R2,
Crystal Enterprise8.0/8.5/9.0/XI, WEBi,
Cognos 6.0, Business Objects XIR2
Operating Systems WINDOWS 95/98/2000/ NT 4.0, Unix, DOS 6.22.
Databases / RDBMS Oracle 7.3/ 8.x/9i/10g, MSSQL Server
7.0/2000/2005, Sybase12.0, MS Access and DB2
Languages C, VBScript, PL/SQL.
Gui Visual Basic 6.0
Web Technologies ASP 3.0, Java, JavaScript, VBScript, HTML,
IIS 4.0/5.0.
Olap Tools Cognos Power paly 6.0
Others DTS, Visual Source Safe, Visual Interdev,
TOAD, Java, PVCS, Clear Case and Ms Excel.
Education /Certifications:
Master of Computer Applications (MCA)
TekSystems Inc.
Pfizer Pharmaceuticals, Great Valley, PA
Jan 2010 - Sep 2010
Change and Configuration Management
Title: Lead Report Developer & Data Analyst
. Provided the reports for the BA's and designing Ad-hoc reports for the
clients on configuration Items from multiple sources.
. Designed and produce the reports for Business Analysts to work with
the end clients to get the desired data for the new data fields.
. Compared the source Database reports and target database reports for
the accuracy of the data collected and transformed.
. Designed reports from various sources (Wyeth and Pfizer).
. Designed Drill Down, Standard and Sub Reports using Crystal Reports
XI.
. Exported reports into various formats like PDF, EXCEL, WORD and RTF
Formats from the application.
. Created Parameterized reports, Drill down reports & Summary reports.
. Created reports with extensive use of formatting options such as
Grouping, Sorting, Drill-down and Parameter prompts.
. Created Unit Test Cases for all the Reports.
. Tuned Queries to improve the performance of report.
. Successfully analyzed and solved complex problems arising during the
testing and production phase.
. Created all type of Formulas for the Reports to meet the end user
requirements.
. Extensively used formula fields, parameter fields, Group selection,
record selection, and Crystal syntax in Crystal reports.
. Involved in validation of Reports.
. Performed Multiple Joins of Data base Tables.
. Defined Business Views and business components with data connections.
. Involved in Unit Testing and Production support of the reports.
Environment: Crystal Reports XI r2, Business Objects XI-r2, Webi Reports,
Sql Server 2005, Oracle 10g, TOAD, MS Access, Excel and SharePoint.
Informatic Technologies Inc
New Jersey State Police (NJSP), West Trenton, NJ
Oct 2004 - Dec 2009
Uniform Crime Reporting System
Title: Sr. Reports Developer
. Involved in gathering requirements, analyzing and Creating Reports for
Various Departments in NJSP.
. Created Standard reports, Cross-tab Reports using Crystal Reports XI
. Created Static, Dynamic and Dynamic Cascading Prompt parameters.
. Published reports on the web using Crystal Enterprise/BO XI Publishing
Wizard and CMC (Central Management Console).
. Created linked, unlinked and on-demand sub reports.
. Extensively involved in using of formula fields, parameter fields,
Group selection, Custom Functions and record selection in Crystal
reports.
. Involved in Creating Users, Folders and Groups in CMC.
. Involved in scheduling the monthly and Weekly reports using Crystal
Enterprise XI.
. Involved in writing Custom Functions to be used in other Functions.
. Extensively involved in writing Views, Stored Procedures and Queries
in Oracle and testing the data.
(Environment: BOXIR2, Oracle 10g, StartTeam 5.0, Excel, Java, ASP, RDC,
Unix and Windows XP)
GCATS and Fauts Systems
. Involved in gathering requirements, analyzing and Creating Reports for
Various Departments in NJSP.
. Created Standard reports, Group Reports using Oracle Reports10g
. Created Static, Dynamic Prompts.
. Converted existing Crystal Reports to Oracle Reports.
. Created the reports using Frames, Repeating Frames and functions.
. Extensively involved in writing Views, Stored Procedures and Queries
in Oracle and testing the data using PLSql Developer.
. Created queries using Add Command object in Crystal Reports XI.
(Environment: Oracle Reports 10g, Oracle 9i/10G, PLSql Developer,
StartTeam 5.0, Excel, Java, Unix and Windows XP)
E-Daily, HR and Expungement Systems
. Involved in gathering requirements, analyzing and Creating Reports for
Various Departments in NJSP.
. Created Standard reports, Cross-tab Reports using Crystal reports8.5.
. Extensively used linked and unlinked Sub Reports.
. Involved in customizing the web pages Using JavaScript, JSP and ASP to
run the reports for end users.
. Published reports on the web using Crystal Enterprise and Crystal
reports.
. Extensively involved in using of formula fields, parameter fields,
Group selection, and record selection in Crystal reports.
. Involved in integrating the reports to the Java application using RDC
and ASP.
. Involved in scheduling the monthly and Weekly reports using Crystal
Enterprise.
. Involved in writing Custom Functions to be used in other Functions.
. Involved in integrating the Crystal Reports to Web Applications using
ASP, Java Script and JSP.
. Extensively involved in writing Views, Stored Procedures and Queries
in Oracle and testing the data using PLSql Developer.
(Environment: Crystal Reports 8.5, Crystal Enterprise 8.5, Oracle 9i,
PLSql Developer, Java, Asp, StartTeam 5.0, Excel and Windows XP)
Broader Software LLC
IBM, Fairfax, VA
Apr 2004 - Sep 2004
California Commission on Teacher Credentialing, CA
Cashiering Web Reports
The California Commission on Teacher Credentialing awards credentials and
certificates on the basis of completion of programs that meet Standards for
Educator Preparation and Standards for Educator Competence. We worked on
ODS (Operational Data Store) to generate the various types of Reports and
published them on to Crystal Management Console to be able to accessed by
the end user.
. Created standard reports, cross-tab Reports using Crystal reports 9.0.
. Extensively used linked and unlinked Sub Reports.
. Published reports on the web using Crystal Enterprise9.0 and Crystal
reports 9.0.
. Extensively involved in using of formula fields, parameter fields,
Group selection, and record selection in Crystal reports.
. Involved in publishing the reports to CMC and Creating Users and
Groups.
. Involved in Scheduling the Documents and Letters (Reports) using CMC.
. Involved in writing Custom Functions to be used in other Functions.
. Created formulas using Crystal and basic syntax.
. Extensively involved in coding stored procedures, writing Views and
Queries in Oracle using TOAD.
. Extensively Involved in Training the Employees in Crystal Reports and
Enterprise.
(Environment: Crystal Reports 9.0, Crystal Enterprise 9.0, Oracle 9i,
TOAD, Siebel 7.5, Actuate 7.0, Excel and Windows XP)
Pepsi Bottling Group, Somers, NY
Jul 2003 - Mar 2004
APS Web Reporting
Title: Crystal Reports Developer
The Pepsi Bottling Group (PBG) is the world's largest manufacturer, seller
and distributor of Pepsi-Cola beverages - some of the world's most
recognized consumer brands. PBG generates about $10.5 billion in annual
sales. It operates in the United States, Canada, Greece, Mexico, Russia,
Spain and Turkey, accounting for more than one-half of the Pepsi-Cola
beverages sold in North America and about 40 percent of the Pepsi-Cola
system volume worldwide.
. Created standard reports, cross-tab, sub reports, using Crystal
reports8.5.
. Published reports on the web using Crystal Enterprise8.5 and Crystal
reports 8.5.
. Uploaded the reports to Crystal Management console (CMC) to be used by
Java application.
. Extensively involved in using of formula fields, parameter fields,
Group selection, record selection, and Crystal syntax in Crystal
reports.
. Extensively involved in coding Stored procedures in Sybase using Rapid
Sql to accept the parameter's as a string from Java front-end
application.
. Extensively involved in SQL, PL/SQL coding creating complex queries,
stored procedures, using Sybase to give better results at Crystal
Reports.
(Environment: Crystal Reports 8.5, Crystal Enterprise 8.5, Sybase,
Embarcadero RapidSql7, PVCS, Java, Excel and Windows 2000)
Hitec Infotech Inc
Marriott ExecuStay, MD
Feb 2003 to Jun 2003
Crystal Reports Developer
Marriott International, Inc. is a leading worldwide hospitality company.
Marriott International has more than 2,600 lodging properties located in
the United States and 63 other countries and territories. Marriott
ExecuStay provides a Fully furnished corporate housing to executives and
travelers who need temporary accommodations for a month or longer. We
Developed The Reports on Reservations, Customer Billing, Services That are
provided for the customers and Locations.
. Involved in creating the various reports using crystal reports 8.5
according to specifications.
. Reports generated and scheduled as per the requirement.
. Used parameters, Formulas, running totals and Crystal Functions to
Convert Data according to the specification of the report.
. Designed, tested and implemented reports successfully on time.
. Developed Drill-Down, Cross Tab, Standard and Sub Reports.
. Created Temporary Tables, Indexes and UDF's (User Defined Functions)
using T-Sql in Sql Server 2000
. Created queries, stored procedures and views in Sql Server 2000 using
T-Sql to be able to customize the reports.
. Developed views using base tables and customized them to use in the
reports.
. Extensively used Crystal Reports 8.5 to generate various reports and
import them to web using CIZER Web Reporting Tool in PDF Format.
. Involved in exporting the reports to Excel Format according to the
user requirement.
. Involved in modifying the Existing Stored procedures, which were used
for Reports.
. Documentation is done for the maintenance users to maintain reports
for updating.
(Environment: Crystal Reports 8.5, Cizer 2.7, Sql Server 2000, Excel and
Windows 2000)
NTEU, Washington. D C.
Aug 2002 - Jan 2003
(National Treasury Employees Union)
NTEU Web Reporting:
Title: Reports Developer
The National Treasury Employees Union is the nation's largest independent
non-postal federal employees union. It represents 155,000 government
workers in the Internal Revenue Service, United States Customs Service,
Federal Communications Commission, Department of Health and Human Services,
FDIC, Nuclear Regulatory Commission, and many other agencies within the
federal government. This application gives the details of members and Non
members of the organization who are working in the different federal
government organizations .We provided the reports for each organization on
the member's list and nonmembers list, their payments for the fiscal year
and pay period, difference between two fiscal years and New Member Reports.
. Created standard reports, cross-tab, sub reports, drill down reports,
on-demand sub reports using Crystal reports8.5.
. Published reports on the web using Crystal Enterprise8.5 and Crystal
reports 8.5.
. Created users, groups and folders for each agency 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: Oracle8i, MS Sqlserver2000, Ms Access, Windows 2000,Visual
Basic 6.0,ASP3.0, Crystal reports 8.5 and Crystal enterprise 8.5).
Subaru Motors, TX
Dec 2001 - Aug 2002
Subaru DealerManagementSystem:
Title: Crystal Reports Developer
The main aim of this application is to monitor the dealers of the Subaru.
This application
Provides the complete information about the dealers, which includes the
contact person name, appointment date, dealer code, sales region, and
invoice information and day today price through this project. This system
provided the reports on Active dealers list; dealers region, dealer's
history and dealers contact information according to the requirement of the
Dealers and Internal People. We provided the facility to change the
password information through this project
. Created Reports using Crystal reports 8.5.
. Created ad-hoc reports, sub reports and cross-tab reports using
crystal reports.
. Published reports on the web using Crystal Enterprise8.0.
. Created formulas using Crystal and basic syntax.
. Extensively involved in using of formula fields, parameter fields,
Highlighting Expert, record selection, and Crystal syntax in Crystal
reports.
. Designed Web Pages using Asp, JavaScript, VBScript and HTML.
. Involved in writing Front-end Validations Using JavaScript.
. Involved in writing Views, Procedures and Tables using T-SQL and Sql
Server 2000.
(Environment: Windows 2000, Crystal reports 8.5, Crystal Enterprise8.0,
CSP, HTML, JavaScript, Asp 3.0, IIS and MS SqlServer).
Cesp Pvt. Ltd., India
Sep 1999 - Jul 2001
Automation of APTransco & APGenco, Hyderabad.
Title: Software Developer
This Project helps in maintaining the employee details of electricity
department (AP Genco and APTransco). This application will help to know the
individual employee history, which include
their zone name, starting post in electricity department, details about his
promotions, remarks if any, Present status etc... This system provided the
reports on employee history for every Zone.
. Designed and developed reports using Crystal reports 7.0.
. Created ad-hoc reports, sub reports and cross-tab reports using
crystal reports.
. Created formulas using Crystal syntax.
. Designed Web Pages using Asp, JavaScript, VBScript and HTML.
. Involved in writing Front-end Validations Using JavaScript.
. Involved in writing Views, Procedures and Tables using oracle.
(Environment: Crystal Reports7.0, Crystal Info, Oracle 8i, IIS, ASP and
Windows 95/ NT 4.0.)
Dealer Information System:
Feb 1999 - Sep 1999
Laxmi Impex Pvt.Ltd. Hyd, Ind
Title: Software Developer
This Project Deals with trading of oil in bulk quantity. This particular
Software has been developed keeping in view the needs of a Broker/Agent Who
is actually dealing with some oil suppliers and whose job is to find the
Buyers for this particular product and organize the dealings starting from
arranging number of tankers for the buyers based on the quantity ordered by
the buyers and then on delivery receiving or making arrangements for demand
drafts to be sent to sellers by the buyers.
. Designed and developed various dealer information reports, cross-tab
reports, drill down reports using Crystal reports.
. Created Views, Tables and stored procedures using Oracle.
. Performed testing using Win runner
. Created Reports according to the requirement of the dealers and users.
. Integrated Crystal reports with Visual Basic.
. Used Visual Basic ADO for Connectivity to the database.
(Environment: Windows NT, Crystal reports, Crystal Info, VB and Oracle).
Automation of Gold loan Unit for Citizen Bank: India
Sep 1998 - Feb1999
Citizen Co-Op Bank, Hyd, Ind
Title: Software Developer
The main aim of this project is to Automation of Gold Loan Unit at Citizen
Bank. This Project consists of two modules Member Information Module and
Gold Loan module. The Member Information module consists Member details of
the banking system. To eligible for gold loan the customer must and should
be a member of the society. The gold module deals with the total automation
of the gold loan where the gold loan transactions are been done. This
system allocates a unique loan no to the customer and enters the item
details for which he needed the loan. This system preserves the Old
transaction of the members. So, the bank people will know the history of
the customer before sanctioning the loan to the customer.
. Designed and developed reports using Crystal reports 7.0.
. Created users and roles using Seagate Crystal Info.
. Created Cross-tab and sub reports using Crystal Reports.
. Developed Complicated Screens using Visual Basic 6.0.
. Created tables, views and procedures using Oracle.
. Developed COM objects using VB.
(Environment: Crystal Reports7.0, Crystal Info, Windows 98, VB, VBScript,
and Oracle 7.3).
Contact this candidate