Professional Summary:

• Over 6 years of experience in Crystal Reports, and other Data ware housing and Database Applications.
• Hands on experience in successful implementation of all project life cycle stages from requirements gathering through implementation and enhancements.
• Experience in Crystal Reports 2008/XI /10/9/8.5/7.5/6.0, Crystal Enterprise 10/9/8.5, Business Objects

XI 3.1/XI R2/6.5/5.0.

• Worked with Crystal Report XI for creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports, drilling reports, analysis reports and data reports.
• Strong data analyzing experience in designing Crystal Reports and very expert in writing complex formulas at the summary level and group level to implement the business logic.
• Worked on joins, views, stored procedures, functions using SQL, PL/SQL, T-SQL and good in documenting the testing process.
• Well versed in sub-reports linking, parameters, drill-downs, cross tabs, sorting and grouping data, graphs and diagrams, precise formats, formulae and record select conditions depending upon selection criteria.
• Involved in database design and modeling for reporting purposes.
• Experience in Business Objects XIR2 with excellent DESKI, WEBI, INFO VIEW and SQL skills.
• Experience in using personal data files, stored procedures and creating complex ad-hoc reports using Crystal Reports.
• Expertise in integrating Crystal Reports with Universes, Oracle, & MS SQL Server using Tables, Views and Stored Procedures.
• Experience in defining queries, generating drill-down report in Crystal Report.
• Trained Users on how to create reports using Crystal Report Designer and deployed Reports.
• Worked in both ad-hoc and complex report environments.
• Effective in work situations requiring an abilityto manage multiple and concurrent projects and responsibilities.
• Exceptional ability to quickly acquaint with new concepts and technology.
• Strong analytical, problem solving skills and a good team player with excellent communication and interpersonal skills.

Technical Skills:

Reporting Tools:Crystal Reports 2008/XI/10.0/9.0/8.0/8.5/7.5/6.0,Crystal Enterprise 10/9.0/8.0/8.5,
Business Objects XI R2/6.5/5.0, Designer, WEBI Info view, CMC
RDBMS: Oracle 10g/9i/8i/8.0, MS SQL Server 2000/2003/2005, Sybase, MS
Access, DB2
Languages: Java, C, C++, Visual Basic6.0, SQL, PL/SQL, HTML, UML, XML,
SQL*Plus, SQL Analyzer, TOAD, Oracle SQL Developer, ERWIN
O/S: Windows NT/95/98/2000/ME/XP, Solaris 9, HP AIX,UNIX
Other Tools/Utilities: MS Office

Professional Experience:

Confidential, Berkeley, CA May 2010 to Current
CRYSTAL REPORTS DEVELOPER
This project involved supporting the Donor Stewardship Office Reporting using Crystal Reports 2008.

• Creating and modifying existing reports using Crystal Reports 2008.
• Design complex Crystal reports like Sub reports, Cross tab reports, Formulas, Parameterized reports, Dynamic grouping reports and Summary reports.
• Used Groupings, Formulas, interactive Sorting, Sum Totals and Summaries in the reports.
• Used conditional formatting and customized the reports as per the requirements.
• Supported Gift Acknowledgement area by creating various reports like First Time Donors Report, Memorial and Honorific Notifications Report, Chancellors Builders Report, Vice Chancellors Builders report and Birthday Card Report etc in WEBI and crystal.
• Used generalized formulas using both Crystal and Basic Syntax.
• Creation of Templates in Crystal Reports.
• Used Crystal reports 2008 advanced features like Dynamic and cascading Prompts.
• Worked in suppressing null values in the reports.
• Created reports using @Prompts Function and defined various Formula Variables in WEBI
• Produced reports and exported to Excel based on User requirements.
• Updated the specs with Mappings.
• Worked on Sub Totals, Running Totals according to report requirements.
• Wrote SQL Queries including complex sub queries in creating crystal reports.
• Exportedreports into various formats like PDF and EXCEL.
• Worked on infoview for creating WEBI reports.
• Formatted, summarized, filtered, sorted and grouped data in Crystal Reports and organized fields into sections and suppressed sections within a report.

Environment: Crystal Reports 2008, SQL, PL/SQL, Infoview, Business Objects XI 3.1, Web Intelligence, Central Management Console (CMC), Oracle 10g, SharePoint, TOAD 9.7.2.5, Oracle 10g, Oracle SQL Developer.

Confidential, Rockville, MD Jan 2010 to April 2010
CRYSTAL REPORTS DEVELOPER

Confidential, is a b2b e-commerce and integration services company. This project involved supporting, enhancing existing reporting needs and developing new reports using Crystal Reports.

• Analyze business requirements and translate functional specification.
• Helping Reporting team to build reports by writing SQL and PL/SQL queries.
• Developed complex Cross tab reports that were both manual and crystal generated.
• Global, shared and local variables are used in creating user-driven requirements and used complex reusable formulas and variables in the reports.
• Worked with the existing users, point solution leads and other planners to translate report functional specifications into Crystal reports.
• Generated the Crystal Reports such as GRR Report, Trading Partner report and Inter Connect report.
• Created cascading dynamic parameters in Crystal Reports to allow the end-user to select prompt-filtered data.
• Involved in the designing and Building of complex BO Universe, classes and objects and working with business views.
• Involved in creating WEBI reports.
• Formatted, summarized, filtered, sorted and grouped data in Crystal Reports and organized fields into sections and merged and suppressed sections within a report. Applied concepts such as queries, functions, parameters and formulas
• Worked on Sub Totals, Running Totals according to report requirements.
• Designed Crystal Reports with Crystal reports formulas, Grouping, Parameters, Selection criteria to handle the report requests.
• Designed reports with linking sub reports to a master report, underlay formatting, and passing data between reports and integrated the report with hyperlink.

Environment: Crystal Reports XI, TOAD, Oracle SQL Developer, Business Objects XIR2, WEBI, Infoview, Designer,ASP.NET, UNIX, SQL, Xcelcius, PL/SQL, Oracle 9i/10g, Windows XP, Solaris.

Confidential, Columbus, OH Jun 2008 to Dec 2009
CRYTSAL REPORTS WRITER

Involved in developing PPRF framework which provides sales and product performance analysis for companies new products using Crystal Reports and Business Objects XIR2.

• Involved in gathering business principles and standardization for reports.
• Create parameterized Crystal Reports using Charts, Cross-Tab, Sub-reports and Running Totals.
• Created changes in the database according to new requirements.
• Used Crystal Reports XI to develop monthly, quarterly, yearly reports.
• Created cross-tab reports, master-detail reports and reports that were created on a daily basis according to the outlined requirements.
• Involved in converting existing Crystal Reports to Business Objects as part of effort to convert to Business Objects
• Involved in the effort to minimizing existing Crystal Reports. This effort involved analyzing existing reports and detecting any duplication of functionality.
• Used Designer to implement universe, joining the tables, creating prompts and queries, solving loops, fans and chasms, parsing the objects and applying contexts and aliases to remove cyclic dependencies.
• Involved in documenting the existing Reporting framework, summarizing reports and their scheduling information.
• Used PL/SQL to develop procedures, functions and packages to implement the business logic and Scheduled reports on a daily, weekly, monthly basis in Crystal Enterprise.
• Co-ordinate with Database team to load data to dev and test databases.
• Involved in designing and modeling the reporting database.
• Involved in analyzing existing databases used by various People Soft applications, Java Applications and creating new database for storing the extracted information
• Used data provider to use the classes and objects created in Designer for generating daily reports.
• Created reports from excel files using Crystal Reports and BO through personal data files.
• Used techniques such as slice and dice, scope of analysis, ranking, section, alerting, filtering, and grouping.
• Using Check Integrity involved in testing the Business Objects
• Exporting reports to repositories in dev, test environments.
• Created user defined objects, functions and variables.
• Exported data to a local file format such as text or excel.
• Used Oracle Discover tool to generate reports.
• Scheduling and Maintain Batch jobs for data transfers.
• Enhancing existing Crystal Reports.
• Involved in the performance tuning of the Crystal Enterprise servers, assisting in setting up clustered Crystal Enterprise servers, load balancing Crystal APS servers.
• Involved in gathering and analyzing end user report requirements and translated functional requirements to technical requirements.
• Implemented and optimized stored procedures and queries and effectively designed reports.

Environment: Crystal Reports XI, Crystal Reports 2008, Business Objects XIR2,BO XI 3.1,ASP .NET,C#,
VB .NET, XML, SDK, Desktop Intelligence, Designer, Web Intelligence, Xcelcius, UNIX, PL/SQL, Oracle 10g, DB2.

Confidential, Dallas, TX Oct 2007 to May 2008
CRYSTAL REPORT WRITER

Dealer Information System deals with reporting on Corporate Customers of TXU Energy Products. The reports developed provide analysis capabilities to view by locations and time periods the distributions made in detail.

• Understanding Business/User requirements. Interacted with the users and Business Analysts to prepare the requirements documents.
• Involved in developing reports for tracking the top revenue generating Corporate Customers in various regions, and generating reports on the seasonal variations in revenue by various customers.
• Involved in developing Dynamic (Parameterized) reports for finding the new customers added for particular time period, and Invoice details for a given customer for a given time period.
• Involved in Free Hand SQL methods and creating Complex and Ad-Hoc Reports using Crystal Reports XI.
  Created reports using Crystal Reports XI with Standard, Summary, Cross Tabs, SQL, Command Objects, Selection Criteria, grouping, sub reports, Top N Reports for highlighting significant data etc.
• Was involved in knowledge transfer to users. When reports were created, I interacted with the users to tell them how the report works and how it was designed, how the report runs, filters used, how to input data in prompts etc.
• As the ad-hoc report writer, coordinated daily meeting with users to help me understand the exact reports they were looking for.
• Was involved in creating Test Cases and Documentation and worked with QA Team to test the reports.
• Involved in migration process of old report which were developed in 6.x version to XI version
• Created reports and exported to excel, csv and text files according to user requirements.
• Created a wide variety of charts like pie chart, area chart, bar chart, 2d and 3d charts
• Analyze and Fix SQL queries to resolve the report issues.
• Extensively used various techniques like Slice and Dice, Ranking, Filtering, Sectioning, Grouping, Formatting, Alerting to develop reports.
• Worked with ASP.NET as front end and developed crystal reports.
• Distributed reports for users in different groups through corporate documents into different domains.
• Involved in analyzing tuned complex Queries, Stored Procedures for faster execution and developed database structures.
• Created reports using Parameter fields were developed to let the users enter values to the reports in order to filter the records based on their needs.
• Customized reports by adding new features such as report alerts, cross-tabs, running total, sub-reports and drill-down fields.
• Provided effective work independently from specifications and with a diverse group of developers and end users to analyze business needs and translated that need into deliverables.
• Created number of formulae based reports, running totals conditional display of fields for complex calculations and used them in different sub reports, container reports.
• Created complex reports with hyperlinks and used the report linking techniques.
• Used SQL*Loader, Import / Export to load data from external data sources in the development, test and production environments.
• Worked on creating SQL queries embedded in PL/SQL functions, procedures and packages. Wrote complex sub queries using outer joins and PL/SQL operators.
• Used database links, materialized views to speed up query execution.
• Exported the reports developed using the Crystal Reports to the Repository.

Environment: Crystal Reports XI/10, TOAD, SQL* Loader, ASP.NET,UNIX, SQL, Xcelcius, PL/SQL ,Oracle 9i/10g, Windows XP, Solaris.

Confidential, Dallas TX May 2007 to Sep 2007
CRYSTAL REPORT DEVELOPER

Commercial Non Performing Assets Detection system develops various reporting products that enable the users to analyze and detect future delinquencies based on various characteristics of the loans.

• Developed reports for analyzing commercial and small business loans using Crystal Reports 8.5 and Business Objects 6.5.
• Distributed reports for users in different groups through corporate documents into different domains
• Creating, developing, testing and maintaining the universe.
• Analyzed the existing database and designed the universes using designer module for generating reports.
• Resolved loops by creating Aliases and resolved traps by creating context.
• Created reports using the Universes and Free-hand SQL as data providers.
• Exported universes to the repository to making resources available to the users.
• Worked on Query Panel, Prompts, Report Layout and formatting.
• Involved in development of complex reports.
• Created Reports showing the sales of various Drug products in a particular Year, Quarter and Month using Business Objects.
• Generated analytical reports like Slice and Dice, Drill Down, Cross tab, Master Detail and Formulae features.
• Used Designer as a part of Universe Development for defining the parameters of Universe, Inserting the table ,making Joins, Resolving loops, Creating Classes and Objects.
• Involved in creation of Filters, @prompts and setup hierarchies for Multidimensional Analysis.
• Exported the Universe t o Repository for making available to Business Objects users and Web Intelligence users.
• Applied sections, Breaks, Calculation, Report Filters and Query Filters and displayed the information in different blocks.
• Created Universes for various functional areas of high level reports group.
• Created Contexts and Aliases to resolve chasm and fan traps in Universes.
• Created Joins, Contexts, and Aliases for resolving Loops.
• Used SQL against database the database to check data retrieved.
• Created join strategies while designing the universes.
• Created different universe s which contains the information about customers.
• Gathered information and created report for billing of a customer.
• According to the customer information created complex report using Universe as main data provider.
• Exported the universes to the Repository making resources available to the users.
• Linked the Universes to share the common components between the universes.
• Created reports according to different cell phone plans like individual plan, family pan and family time plan.
• Involved in applying Drill-down to the dashboard items that allowed users to quickly drill into important figures for more detailed information and common filters are applied to all dash board elements for specific range of data.
• Exported the Reports to the Broadcast Agent and used the Broadcast Agent Server to Schedule and Monitor the Reports.
• Created Master Detail and Cross Tab reports to view the data in an analyzed way.
• Created and modified the existing Universes by adding new classes/objects, prompts, hierarchies based on the business requirement.
• Involved in managing users, groups, folders and published reports using crystal management console, in exporting and scheduling of reports using Crystal Enterprise and generated WEB Reports by using Reporting Portal.

Environment: Crystal Reports 8.5, Business Objects XI R2,XML, Sybase, Xcelcius, SDK,PL/SQL, Desktop Intelligence, Designer, Web Intelligence, Dash board, Info view, UNIX, TOAD (Oracle 9i, Oracle 10g), Dashboard, ASP.NET,MS Office, Windows 2003.

Confidential, Bangalore, India May 2005 to Jul 2006
CRYSTAL REPORT DEVELOPER

Commercial Real Estate Reporting framework provides users/management with information about the loan performance in the real estate portfolio.

• Developed Crystal 8.5 Reports
• Involved in data modeling for the reporting data warehouse.
• Created various Crystal reports for different modules involving cross tabs, sub reports, chart and graphs.
• Actively worked on design, development, and documentation of Crystal Reports and created ad-hoc reports.
• Created documentation for deploying reports, scheduling reports & publishing them to Users.
• Created new reports with formatting or standard templates, applying sorts, Calculations, Breaks and Ranking to data and opening, Modifying, Saving and sharing existing reports.
• Tested some of the reports developed by other Crystal developers.
• Independently worked on reports and met the goals within the time constrain.
• Created filters to aid in creation of analytical reports.
• Strong experience in Data Analysis, developed Ad-hoc reports and complex reports by using Crystal Reports.
• Created organized and formatted reports, folders and other contents.
• Analyze the requirements document for testability. Test Cases and Test Procedures are written in Excel sheets.
• Created several Crystal Cross Tab Reports and Complex Sub Reports using Report Designer.
• Created documentation for deploying reports, scheduling reports & publishing them to Users.
• Involved in unit testing for all the reports and extensively tested the reports with test database, and gave the possible test cases to the testing team and was part of the production support team
• Individually developed various database objects like Indexes, Triggers, Views and Stored Procedures and created reports from multiple data sources using stored procedures.
  

Environment: Crystal Reports 8.5, Crystal Enterprise 9, Oracle 9i/8i, TOAD, SQL* Loader, .NET, XML.

Confidential, Hyderabad, India Jun 2004 to Apr 2005
CRYSTAL REPORT DEVELOPER

Developed Reports and created data models for insurance clients. The project scope was to design and build a warehouse for decision support for Life Insurance clients.

• Involved in designing the database based on the requirement documents using Erwin modeler
• Developed reports using Crystal Reports 9.0 and SQL Server Reporting Services 2000.
  Developed and implemented procedures to ensure the quality, usability and accuracy of reports.
• Developed several reports such as Standard, Summary, Cross-tab, Charts, Graphs, Drill-down, Labels with formulas, SQL Expressions, Grouping, Sorting, sub reports, Parameters etc.
• Created formulas and store procedure and different Alerts based on the conditions.
• Involved in interacting with end-users and generated various reports according to end-user requirements.
• Interacted with the users for understanding and gathering business requirements.
• Involved in preparation of various reports of different modules and coordinating with the clients, participating in the weekly calls and meetings regularly.
• Also worked as part of the Client Services Reporting team and participated in the full life cycle development of advanced reporting solutions from requirements gathering, data analysis, report design and testing, scheduling and maintained reports as per client or user needs.
• Involved in business requirements and functional specification reviews to evaluate business requirements and write technical specifications.
• Involved in data loading using C scripts.
• Testing data load scripts and Unit testing Crystal Reports.
• Performed Unit Testing for all the reports.

Environment: Oracle 9i, Crystal Reports, PL/SQL, SQL*Plus, XML,Windows 2000, Linux.

Education:

• Masters in Management Information Systems
• Bachelors in Engineering In Computer Science