PROFESSIONAL PROFILE

• Over8-yearsof experience, in designing and developing Business Objects Reports/Crystal Reports for different types of software applications.
• Strong experience in Central Management Console CMC , Designer, Infoview, Web Intelligence, DesktopIntelligence, Import Wizard, Report Conversion Tool and Services, Publisher, Crystal Reports and Xcelcius.
• Experience in building Universes, developing Reports, and analyzing OLAP data. Worked in various BOenvironments linking data from multiple sources, applying several functionalities, and using various Data Providers. Worked with many types of team members for different tasks. Tested reports for validating and verifying data.
• Extensively worked on Business Objects Ad-hoc Reporting by accessing data using Universes, Personal data files and Stored procedures.
• Designed Developed reports such as List reports, Parameterized, Form Letter, Mail Label, Sub Reports, Cross tab reports based on base tables, Views, Business views, Commands, Universes, Stored Procedures, Crystal .Net Reporting Component, involving formulas, sub totals and running totals.
• Expertise in writing reports based on business requirements, technical specifications and followed coding standards.
• Well experienced in preparing Report Prototype, taken sign off from the client, Prepared Report Design Document, Prepared User test cases for the report. Worked in Development, Quality and Production Environments.
• Extensively worked in Web intelligence reports using key functionalities such as using Combined query functions, Sub queries, Grouping, Custom sorts, Alerts, Tracks, Break, Variable Editor, Drill down/up, Rankings etc.
• Extensively used Report Conversion tool to Convert Deski Reports to Web Intelligence
• Immense experience in solving loops and traps using Contexts and Alias, setting up Custom Hierarchies, Derived Tables, Aggregate Awareness to enhance the performance of SQL
• Generated various reports with Features like Drill down, Alerts, Data Suppressing and Change Highlighting.
• Good Knowledge of Data Modeling using Entity-Relationship Model, Dimensional Data Modeling using Star schema and snow flake schema.
• Created documentation for deploying reports, scheduling reports installation of Crystal Reports on Client machines.
• Experience in designing Universes, writing LOVs, and good exposure with Slowly Changing Dimensions SCD .
• Well experienced in preparing Reports by using SQL Reporting Services SSRS and integrating in to .Net applications.
• Involved in Scheduling and publishing reports in Crystal Enterprise Environment/ Business Objects Enterprise XI R2 Environment.
• Experience in creating Clustering Servers and configuring Clustering Servers
• Excellent authority on developing reports in Crystal Designer using Oracle, SQL Server, Sybase and MS Access databases
• Experience in writing complexT-SQL/ SQL queries and tuned queries for better performance.
• Skilled in tuning the performance of SQL queries and ETL process.
• Involved in maintenance and development of T-SQL Procedures, Oracle Stored Procedures, Indexes, Triggers and Packages.
• Experience in different kinds of OLTP AND OLAP Systems.
• Knowledge on ETL tools BODI and BODS
• Strong knowledge in all phases of Software Development Life Cycle SDLC such as analysis, design, development, testing and implementation on various platforms.
• Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within time frame.
• Self-starter with good understanding and goal oriented approach in resolving issues.

Technical Skills:

PROFESSIONAL EXPERIENCE:

Client: Confidential

Role: SAP BOBJDeveloper

Responsibilities:

• Interacted with the Business Users to analyze the business process and gathered the requirements made necessary changes to schema objects to fulfill the reporting and business needs.
• Built universe on the designed schemas, well tested and exported them to repository using Business Objects Designer Module.
• Designed the custom Principals with in CMC tool based on the Business Requirements.
• Interacted with the Data Warehouse team and suggested ideas to improve the model of the Data Mart, which can help in tuning the SQL and improve the performance of generating reports.
• Created Derived Tables at the universe level to reduce the complexity of universe building.
• Extensively used Web Intelligence, Info view, reporter and explorer for querying, reporting and analysis tasks.
• Specified the standards for universes, Classes, Aliases, Simple and complex objects.
• Created filter objects, and formatted objects and measures within the universe for faster report generation.
• Used functions select, where, prompt to create predefined conditions, and prompts to filter the data in the universes.
• Testing and fixing issues in Universes, Reports, Objects, Conditions and LOV's List of Values .
• Defined Row Level Security restrictions for masking the secured data.
• Creating Standard reports, Cross tabs reports, Ad-hoc reports using the features like Ranking, Sorting, and functions to analyze the data. Used Web Intelligence to create Reports.
• Applied Multi-dimensional analysis such as slice and dice, drill functions on the reports.
• Extensively used various techniques like Merged Dimensions, Ranking, Breaks, Sorting, Ranking, Report Filtering, Query Filtering, Alters and sections to develop the Webi reports.
• Generated various numbers of reports on a daily, weekly and monthly basis using Webi and Deski.
• Created reports and sub reports using Crystal Reports.
• Created schedules to run on weekly, biweekly or monthly basis, according to end user requirements. Also, created Calendars in CMS to handle irregular intervals while scheduling.
• Involved in migrating Business Objects Universes and reports from Version 6x to Version XI 3.1 using the Import Wizard and migrated full-client reports to Web Intelligence reports using the Report Conversion Utility.
• Written PL/SQL Interfaces which include Packages, Procedures, Triggers and Oracle Objects Types.
• Designed dashboards using Web services Live Office connections to generate dashboards for Live Data.
• Expertise in developing Static and Live Flash enabled Xcelcius dashboards with dynamic refresh.
• Created reports from multiple sources functionalities like slice dice, drill down in Crystal Reports.
• Modified existing crystal reports and created new reports with cross tabs and sub reports based on the client requirements using Crystal Reports 2008.
• Developed various Multi-chart models that connect to real-time enterprise data using Query as a Web Service QaaWS and Live Office.
• Implemented Best Practices in Universe designing and Reports Development.
• Developed Cross Tab Reports, Sub Reports by using Crystal Reports 2008 and embedded Xcelcius onto Crystal Reports for better results and also provide users with clear understanding.
• Troubleshooting BO servers on Linux Operating System and Window Operating system
• Experience in Installing Business ObjectsXIR3 both SP1 and SP2 in Widows 2008 as well as Solaris 10 environment.
• Involved in integrating Business Objects Reports into IFTool Application by using Java SDK

Environment: Business Objects XI 3.1/4.0, Java 1.6 SDK,JBoss Server, Crystal reports2008, Crystal Reports XIR2.0, Oracle 10g, DB2, PL/SQL, Toadand windows XP/2008/Solaris

Client: Confidential

Role: SAP Senior Business Objects Developer

• Worked as a Production Support for BOXI R2 migration project.
• Troubleshooted issues in raised through migration from BO 5.1.7 to XI R2.
• Setting up rights to Business Objects Applications Infoview, WEBI, Designer, Dashboard Manager, Crystal reports, Desktop Intelligence DESKI for User groups in CMC.
• Responsible for solving the Complex and Major issues in Web Intelligence.
• Responsible for development of Web Intelligence Documents from scratch.
• Responsible for Recreating Web intelligence Documents which do not support the DeskiFunctionality,
• Responsible for the Re-design of web intelligence documents.
• Converted reports from deski to webi using the Report Conversion Tool RCT which have not been Converted or having issues with the Conversion.
• Imported reports from Source to destination Platform in both deski and webi using the Import Wizard.
• Created Backup for the repository BIAR file using Import Wizard.
• Created the reports using webi, Deski and Xcelcius.
• Responsible for testing the reports which were recreated before the post-deployment/Signoff verification procedures making use of the Source Documents.
• Responsible for monitoring the services In CMC and reporting the Admin Team.
• Interact with system users and stakeholders around specific work efforts / Issues for the deliverable.
• Involved in meetings on deciding strategies and planning the Workarounds for the Reports.
• Good experience in working with Ranks, Filters, Prompts, Folds, Functions, Formulas in reports for the Workarounds.
• Reported on weekly basis to Business Objects Project Team lead and Company's Project Manager on the Issues and met the time Limits Successfully.

Environment: Business Objects XI 3.1 Info view, Deski,webi, Universe Designer, RCT, and Import Wizard , Oracle 11g, Windows XP.

Client: Confidential

Role: BO Reports Developer

Responsibilities:

• Created reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, functions, Cross tab, Chart, Master/Detail, Formulas as per the requirement of the end-user and troubleshooting complex reports, increasing performance of reports.
• Designing, developing and analyzing Reports using Crystal Report XI R2.
• Create complex Web Intelligence Reports against multiple data providers.
• Design and develop Business ObjectsUniverse in Designer 3.1/2.0
• Modified exiting Universes and designing classes and objects using Universe Designer on XI R2/ R1.
• Involving in the administration of Central Management Console CMC for implementation of security at Report level, Folder level. Created Users, user groups.
• Involved in creation of Universes, Classes, Objects and Hierarchies for multi-dimensional analysis of database using Business Objects XI 3.1 for technical and sales departments.
• Developing Cross Tab Reports linked Sub Reports and graphs using Crystal Reports XI R2.
• Developing formulae using both the crystal syntax and the basic syntax to use in the reports and for reusability.
• Developed reports using drill down and hierarchal grouping functionalities of crystal.
• Exporting reports into various formats like Editable RTF, XML, PDF, HTML, EXCEL, and WORD using Crystal Reports XI for user.
• Publishing objects to Business Objects XI R2/R1 Enterprise system using Import Wizard, Publishing Wizard, Infoview and CMC.
• Wrote several database objects like package, stored procedure, views etc using Oracle PL/SQL.
• Worked closely with Business Systems Analysts BSA and business owners to collect and analyze reporting requirements, and profile source systems data to identify data structures anomalies and data definitions inconsistencies.

Environment :Java, Business Objects XI R2, Crystal reports8.5/10.0, Crystal Reports 2008 Oracle 10g, PL/SQL, Toad, Adobe Live Cycle Designer and windows XP2008/Solaris

Client: Confidential

Role: BO Reports Developer

Responsibilities:

• Involved in analyzing business requirements, functional requirements for developing universes and reports
• Involved in the designing and Building of Universes.
• Created Ad-hoc reports using Business Objects functionalities like Queries, Drill Down, Functions, Cross Tab and Formulas etc.
• Created various dashboards using Live Office connection.
• Created various static and dynamic dash boards by using Xcelsius.
• Created drill down dashboards with Xcelsius
• Used different kind of components for dashboard reports.
• Worked with Multiple data providers including Personal Data files to create reports
• Created Filters to improve the report generation by collecting the Report requirements.
• Written the unit test plans and preparing the system test plan.
• Designed several universes for Marketing and Sales Department. Involved in designing Web Intelligence and Crystal reports.
• Responsible to support the issues with reports on the crystal enterprise environments Development, UAT, Test and Production
• Designed PDF forms by using Adobe Live Cycle Designer

Environment :Business Objects XI R2, Crystal reports8.5/10.0, Crystal Reports 2008 Oracle 10g, PL/SQL, Toad, Adobe Live Cycle Designer and windows XP2008/Solaris

Client: Confidential

Role: Senior Crystal Report Consultant

Responsibilities

• Working with the end users to gather requirements for their reporting needs.
• Creating and documenting logical data models that would consolidate different data sources like Oracle, SQL Server and Access.
• Experience in configuring users and administering security.
• Experience in Migrating reports.
• Experience in Configuring LDAP, Oracle Access Manager, Oracle Identity Manager and Oracle Virtual Directory OVD
• Created complex Crystal Reports complex and used formulas, parameters, selection criteria, sub reports etc.
• Created views and stored procedures for Reports using complex SQL, PL/SQL, T-SQL.
• Worked on the migration of existing reports from Crystal Reports version 8.5/10.0 to SQL Reporting Services SSRS .
• Used CMC to schedule reports on the web. Implemented Folder level and group level security.
• Responsible for version controlling using VSS
• Developed Stored Procedures and Queries to validate the data at backend by using SQL 2005 and to execute the desired result at front end.
• Involved in writing reusable user controls
• Involved in creating DTS by using Microsoft SQL Server Integration Services SSIS
• Designing and developing Crystal reports and Microsoft Reporting services SSRS to generate reports as per client requirements.
• Maintain the Technical Specifications for the work done.
• Designed several universes for Marketing and Sales Department. Involved in designing Web Intelligence and Crystal reports.
• Responsible to support the issues with reports on the crystal enterprise environments Development, UAT, Test and Production
• Designed PDF forms by using Adobe Live Cycle Designer.

Environment: .Net 2.0, ASP.NET, C , ADO.NET, AJAX, Web Services, Visual Source Safe, UML, SQL Server 2000/ 2005, SSRS/SSIS HTML/DHTML, Windows XP, IIS, XML/XSL, SOAP, Crystal reports8.5/10.0 and Reporting services, Adobe Live Cycle Designer

Client: Confidential

Role: SAP BOBJ Developer

Responsibilities:

• Worked on validating the canned crystal reports with the end user and customized some of canned reports and created new reports as a part of new user requests.
• Created Static and Live Flash enabled Xcelcius dashboards with dynamic refresh.
• Streamlined SQL generation from Universes by implementing Aggregate Aware functions and Variables.
• Interacted with Users to know their Business views while gathering the Report requirements and provided Several Report Mock-ups to finalize the requirements.
• Converted business requirements FRD to technical requirement documents.
• Created and Formatted the Reports as per the Users Requirements using the features in Webi like Master/Detail, Charts, Cross tabs, Slice and Dice, Drill down, functions and Formulae to analyze the data. Created and distributed Report Templates to Users and Main Data Providers for created these reports are Universes.
• Created Derived Tables in the Universe to meet the Reporting Requirements.
• Involved in Creating Universes and Reports. Designed new Universes using features like Cardinalities, Aliases , Contexts and Hierarchies. Created Classes, Sub-Classes and Objects which include Dimensions and Measures .
• Created dashboards using Xcelcius 2008.
• Created user defined prompts, Smart Measures and complex conditions at Universe level for better performance.
• Created complex webi reports with multiple queries, custom sql, using complex fuctions, merging dimensions at report level, drill down, drill up, drill across, complex filters etc
• Created Reports using all the BO functions like Prompts, Dimensional and Measure variables to show accurate Results.
• Created alerters, filters and inserted Breaks in designing reports.
• Responsible to talk to business users and finalize on any enhancements/new requirements needed by reporting department.
• Created the reports using BOBJ functionality's like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae's etc
• Created reports using Info View and published to assigned users.
• Designed logic for Xcelcius 2008 dashboard in Microsoft Excel for Data Visualization.
• Worked with team closely with Functional Architect, DBA and Analysts.
• Experience working on Report testing to validate the results against the database.
• Maintaining Universes and Reports in multiple Environments Dev, Test, Pre-prod etc.
• Was involved in training the end users over the newly developed crystal and webi reports.

Key Technologies: SAP Business Objects Enterprise XI 3.1, Web Intelligence, Info view, Windows, Teradata V2R5, Teradata Utilities SQL Assistant, Fast Load,MultiLoad, BTEQ , Crystal Xcelcius, Crystal Reports XI and CMC.

Client: Confidential

Role: Crystal Reports Developer

Confidential Planning Software is a Multi - User and stand alone system, which provides the facility of planning the load schedules to the dealers. Apart from planning the load system also provides a means to maintain all information regarding the Dealers and Transporters. The strengths of this system are its descriptive interface, which are very user-friendly and the security features, which leaves very little chance for a user to Commit a mistake and context sensitive online help system. Confidential planning software is broadly classified into two modules, viz., Master Details, load Control Chart.

Responsibilities

• Involved in design of Crystal Reports which included designing Cross tab, Summary reports with parameters, sub-reports from tables, views and stored Procedures
• Using SQL, PL/SQL designed and developed Stored Procedures, Views for summary reports
• Worked closely with end-users and management for various reports design and developed reports that provided statistical information, which were used by the sales managers and the sales directors to estimate the performance of the sales reps, estimation of cash inflow, estimate year to date sales, and detail budgeting of the funds

Environment: VisulaBasic6.0, ADO, MS-Access, Crystal reports, and Windows NT