Crystal Reports XI Developer

Skills

Employment History:

Confidential

Senior Crystal Reports Developer

Responsibilities:

• Utilized Crystal reports to develop and modify reports.
• Developed Crystal Reports and formatted the same with respect to the requirements. Added parameters, special fields, formulae and used multiple data sources to create the reports.
• Developed various Charts and Graphs like Bar Chart Side by Side, Stacked , Line graphs, Pie Charts etc. by using Chart expert of Crystal Reports 2008.
• Created Cross Tabs Reports and Sub-Reports using by using Crystal reports XI.
• Developed complex reports in Crystal Reports using multiple sub reports and drilldown features.
• Created Reports using Crystal reports formulas, Grouping, Parameters, Selection criteria to handle the end user requests from Tables, Store Procedures, Views and Command Objects.
• Published and Scheduled Reports in Crystal Enterprise using Crystal Management Console and Crystal Publishing Wizard.
• Had experience on dealing with client and Project Management Skills.
• Designed Universes with Single and Multiple resources using Universe Designer/IDT with Oracle as the data Provider and solved various loops and join complexities by using aliases and Contexts. Created Conditions, hierarchies and Cascaded prompts for hierarchical display of input parameters.
• Used Toad data modeler, data analysis and to query the SQL scripts generated by the Business Objects and also to query for results against Oracle database for analysis.
• Created temp data in the Database for development purposes using Toad for Oracle.
• Interacted with CURAM and CONNECTURE team to identify the architecture of Notices on a higher level.
• Analyzed XML Codes for identifying discrepancies w.r.t report elements.
• Created complex Health Insurance templates and reports for these that involved multiple data providers and involved complex graphical notations.
• Setup guidelines and standards for development of Reports to improve quality assurance and consistency of the reports across various environments.
• Migrating reports and universes to a different environment and to perform backups as a BIAR using LCM.
• Acted as a Liaison between the Development team and the Testing team for identifying the defects using HP -ALM as the defect tracking tool.

Environment: SAP Business Objects BI 4.0, IDT, PL/SQL, Windows 2008/XP, Oracle 11g/10g, J2EE, TFS, Visual Studio, .Net 3.0 Framework, ASP.NET, C , VB.NET.

Confidential

Senior Crystal Reports Developer

Responsibilities:

• Involved in requirement's gathering phase for universes, reports .Interacted with Business Users, Stake holders and Managers in finalizing the documents.
• Performed Fit gap analysis for the report and universe requirement.
• Had experience on dealing with client and Project Management Skills.
• Involved in designing, developing and maintaining new and existing universesusing Business Objects Universe Designer Tool UDT and Information Designer Tool IDT .
• Created a new universe using IDT.
• Worked with the DBAs to come up with additional 10 aggregate tables to address performance
• Utilized the concept of Aggregate Awareness in improving the query performance in reports
• Created Derived tables so as to utilize these tables in universe design.
• Created reports such as Major constructions over 80 , reimbursement reconciliation reports using the features of Sub-Reports.
• Created Various Bar Graphs and Pie Charts.
• Created Reports using Crystal reports XI formulas, Grouping, Parameters, Selection criteria to handle the end user requests from Tables, Store Procedures, Views and Command Objects.
• Published and Scheduled Reports in Crystal Enterprise using Crystal Management Console and Crystal Publishing Wizard.

Environment: SAP Business Objects/XI R3, Pl/Sql, SQL Server, Windows 2008/XP, Teradata and Oracle 11g/10g, TFS, Visual Studio, .Net 3.0 Framework, VB.NET, C , ASP.NET.

Confidential

Crystal Reports Developer

Responsibilities:

• Involved in analysis and requirements gathering and translating high-level business requirements into logical business dimensional model
• Worked on Business Requirement Documentation, source to Data mapping and came up with the new tables in the Data warehouse for Report Development.
• Created two new universes based on the report requirements. Maintained and enhanced 5 previously built universes.
• Had experience on dealing with client and Project Management Skills.
• Worked with DBA's to create aggregate tables to improve the performance of the query by reducing down the size of the result set at the data provider level.
• Created Reports using Sub-reports and Cross-tab reports.
• Created Parameterized reports by using both Static and Dynamic Parameters.
• Created Various Reports using OLAP Grids.
• Used Prompts, Filters, Drill downs, Calculations such as Grand Total and Running Total.
• Used various features called Grouping, Alerts, and Highlight Expert to modify reports.

Environment: SAP Business Objects XI R3, Business Intelligence, Designer, Crystal Reports XI, TFS, Visual Studio, .Net 3.0 Framework, VB.NET, C , ASP.NET, Web Intelligence, Pl/Sql, SQL Server, Oracle11g/10g, and SVN.

Confidential

Crystal Developer

Responsibilities:

• Designed and Built Universes using Designer by defining joins, cardinalities between tables and applying contexts and aliases to remove cyclic dependencies.
• Created complex Condition Objects for easy reporting, Aggregate-Aware objects for better performance.
• Applied mandatory Universe and Class filters to restrict the data.
• Created new universes and also modified the existing universes by adding new tables and objects based on the new report requirements.
• Updated the existing Universe by adding new tables, classes, objects, predefined conditions and prompts as per reporting needs.
• Create custom LOVs List of Values and custom Hierarchies for drilling down to lower levels in the reports.
• Created the reports using Business Objects functionalities like Combined Queries, Slice and Dice, Drill Down, Functions, Cross Tab, Master Detail and Formulae etc.
• Involved in migration from existing BOXIR2systems to BOXIR3.1in all four Environments Dev, Test, Pre-Prod, and Prod .

Environment: Business Objects XI R2, Business Intelligence, Web intelligence, CMC, CCM, Crystal Reports XI, Pl/Sql, SQL Server, TFS, Oracle 10g, Toad, UNIX.

Confidential

Business Objects Developer

Responsibilities:

• Maintenance of Security, Universe and Document Domains, Users, groups and row level Security.
• Installation and configuration of Business Objects 6.5.1 Enterprise Server Products.
• Worked on creating new reports using Crystal using the existing Universes.
• Involved in the design of Logical Data Model and Physical Data Model using ER-Win.
• Designed developed, maintained and tested universes for supporting Ad hoc, canned reports and implemented advance features such as aggregate awareness, context, etc.
• Created the Repository structure to manage the security and deployment options throughout the installation.
• Setup guidelines and standards for development of Reports to improve quality assurance and consistency of the reports across various environments.
• Created tested the universe for other reports using Business Objects functionality like Queries, Slice and Dice, Drill down, Functions, Formulae etc
• Used sorts and ranks in reports, where the sorting and ranking takes place based on the user Criteria through prompts.
• Scheduled the reports to the appropriate users using Broadcast Agent.

Environment: Business Objects 6.5.1/5.1.2, Sql Server 2005, Crystal Reports XI, Crystal 10, Business Intelligence, Web Intelligence 6.1, ZABO, Pl/Sql, Erwin 4.1, Excel and Windows 2003.