Summary:

• Over all 5+ years of experience in Design, Analysis, Development and Implementation of Software Application Development under different environments using Business Objects and Crystal Reports.
• Expertise in SAP Business Objects XI Suite (4.0/3.1) , CMC, Designer, Desk I, BI Launch Pad (Info view), Rich Client, Interactive Analysis (Web Intelligence), Import wizard, Report conversion tool, Performance Manager, Live Office, Life Cycle Manager, Crystal reports.
• Excellent in Troubleshooting for all the issues in Crystal Enterprise and Reports.
• Experience in all phases of Software Development Life Cycle (SDLC) such as developing, testing, Migrating, Administrating, security management and production supporting on various platforms like UNIX, Windows 2000/03/XP/7.
• Developed complex query’s using web intelligence including merging and custom query’s.
• Experience in working on Worked with different databases like SQL Server, Oracle.
• Experience in developing Universes using Business Objects Designer -Universe Methodology involving the creation of underlying database structure, resolving the loops, creating classes & objects, conditions & joins and finally testing the integrity of the Universe.
• Created Ad-hoc, canned reports and tested the reports in full-client and WebI environment for migration purposes, scheduled and published the reports using Broadcast Agent.
• Created many BIAR files to handover the reports to QA team to start testing on it.
• Hands on experience in Installing, Configuring and Troubleshooting the Installation issues of BOXIR2/R3.
• Good knowledge of Dimensional modeling, Data migration, Data cleansing, Data profiling, ETL Processes, Data mining, Data audits.
• Strong knowledge on Crystal /Business Objects/ SQL /Software’s.
• Expertise in all modules of Crystal Reports and Business Objects Suite (Installation, Configuration, Dash Boards design, Up-gradation, Universe Design and Development, Report Development, Performance Tuning/ Optimization, User/Security Administration)
• Expertise in creating the dash boards representations for various departments and consolidated reports using Crystal Reports.
• Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks
• Excellent in writing Complex queries, stored procedures, functions.
• Experience in Crystal Reports (Designing, Sub-reporting, Cubes, OLAP, Adhoc queries, Drilldown, Cross-tab etc.), Crystal Enterprise Server (Publishing, Scheduling, Creating Users/Groups/Roles, Export/Import, Mailing reports to respective target users in Intranet/Internet), Client/Server and Web application development.
• Tested reports developed by other Crystal developer and MS SSRS.
• Unit testing of the real-time Dashboards and Business Objects reports by data validations by comparing data against the client standard reports both in crystal and WebIreports.
• Worked with End-To-End implementation of Data warehousing team and Strong understanding of Data warehouse concepts, Technology using Star Schema, Snowflake Schemas and Multi-Dimensional Models in respective to query and analysis requirements.
• Involved in Data Modeling, Data Mapping and ETL Processes.
• Extensive experience in writing SQL Queries, PL/SQL.
• Experience in generating reports using Crystal reports and Brio.
• Excellent Knowledge on DW Concepts such as Star schema, Snowflake Schema, Fact and Dimensional tables.
• Experience in testing the reports for QA team.
• Scheduled and published reports using the Business Objects Enterprise Server and provided access to different user groups through Info view.
• Designed reports in Crystal Reports XI and 2008 with complex command objects to optimize response time and performance of the reports.
• Excellent analytical, time management, interpersonal skills and a good team player with excellent oral and written communication skills.
• Good experience in working on Source controls Rational Clear Case and Clear Quest. Finding issues using version tree and history of the checked in file or the root file.

Education:

• Bachelor’s in Computer Science, JNTU-Hyderabad, India.

Technical Skills:

Business Intelligence

Business Objects Suite 6i/XI/XIR2/XIR3.1, BOE Premium Suite, Business Objects SDK, WebI, Desktop Intelligence, Performance manager ,Crystal 2008/4.x.

Languages

C/C++, PL/SQL, Java, J2EE, PL/SQL, .NET.

Web Technologies

HTML, XML.

RDBMS

MS SQL Server 6.5/7.0/2000/2005/2008, Oracle 8i/9i/10g, MySQL, MS Access 97/2000.

Operating System

Windows 9X/NT/2000/XP,2003, Sun Solaris, Unix, Linux

Tools

SQL * Plus, Toad, SQL Navigator, Clear Case, Clear Quest, Rational Tools, MS Office.

Professional Experience:

Confidential,Burbank, CA May 2012- Oct 2012
SAP Crystal Report Developer
Responsibilities:

• Responsible for developing and maintaining WebI Intelligence reports, Crystal Reports, in development cycle of client requirements and analysisclient needs.
• Responsible in making many reports from scratch and also modifying the existing once.
• Involved in working in more than one project and meeting the deadlines and finishing the work.
• Involved in the design, develop and review of the new reports standards.
• Involved in short term dead line projects analyzing the needs and modifying the existing report.
• Interact with business users and support them if any problem arises.
• Involved in building universe from scratch adding variables for reports at the universe level.
• Involved in making centralized universe for all the reports and doing the context for the joins.
• Running the unit test for the BO report and comparing to the Clients CV report.
• Running and testing required queries and reports before publishing and test the performance
• Involved in Creation of Crystal Report Reports, Created ODBC Connections, database Connections, stored procedure using oracle.
• Customized the formatting of the Crystal Report using formula’s at the section level.
• Created formula’s for Crystal Reports and stored it on the Crystal Repository to be used across the organization. Created reports with dynamic grouping based on parameters.
• Created stored procedures and functions to support the report against SQL databases.
• Created complicated reports including sub-reports, graphical reports, formula base and well-formatted reports according user requirements.
• Customized data by adding Filters, Calculations, Prompts, Summaries and Functions
• Created linked, unlinked sub reports. These sub-reports were built to open on-demand or inline to the main report.
• Provided training for end users for generating their own report including complicated report.
• Created organized and formatted reports, folders and other contents.
• Customized data by adding Filters Calculations, Prompts, Summaries and Functions.
• Built static parameter list to get static user information and dynamic parameters retrieving data from the database table dynamically at run time. These parameters were mostly used with record selection formula.

Environment: Crystal report 2008,Business Objects 3.1, Business Objects 4.0, SQL Server 2005/2008, Clear Case, Clear Quest, Excel, Oracle and Windows Vista.

Confidential,a Xerox Company, Baltimore, MD July 2010-April 2011 SAP Crystal Reports Developer
Responsibilities

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications about the financial system for Business Objects Universes and Reports.
• Worked as Onsite lead, offshore coordinator and senior technical consultant.
• Responsible for Creating the New Reports and also maintaining the Existing Reports.
• Involved in testing the reports for different clients
• Involved in writing Technical specification documents (TSD) and Report Design Document (RDD) based on report client specifications.
• Created new reports and also modified many existing reports and successfully completed the project within the time given.
• Published Reports in BO Enterprise (Info View) via. Business Publishing Wizard and Central Management Console (CMC).
• Involved in deploying Business objects contents in production environment by using Import wizard.
• Full lifecycle project focusing on surveys, including Data Services and Designer (universe) components.
• Developed Ad-hoc Reports using Business objects Universe as the Data source in Web Intelligence.
• Involved in migration of universes and reports from ST/UAT to production using Import wizard.
• Solved the session time out problem in Info view by creating complex crystal reports.
• Effectively solved issues like fan trap and Chasm trap while creating the universes
• Extensively used crystal reports 2008 in generating new reports with multiple sub reports which uses shared variables from the main reports.
• Worked on different remote machines for testing the build for the client in a given time period.
• Involved in creating complex formulas for generating the Cross- tab reports with different Trending reports with Charts on both Crystal reports and MS SSRS.
• Creating Objects in Business View Manager and data foundations to the right path which pulls the data from the database based on the joins established.
• Extensively used crystal reports 2008 in generating new reports with multiple sub reports which uses shared variables from the main reports.
• Used multiple data providers to create complex reports and synchronized the data providers by linking the common objects to create the common report.
• Responsible for Creating Complex and Multi-Dimensional reports using Master/Detail, Cross-Tab.
• Created reports on web using Info View Portal and Web Intelligence, distributed the reports to different users.
• Well versed in various formatting types in Business objects.
• Extensively used Calculations, Variables, Drill Down and Slice and Dice for creating Business Objects reports.
• Responsible to create LOVs using Business View Manager (BVM) for Dynamic Cascading prompts.
• Expertise in importing, exporting, changing Properties, modifying Reports Using Business Enterprise Portal (Info view).
• Creation of ODBC connections.
• Coordinating between onshore and offshore teams, work alongside with Project manager in assisting the project onshore and offshore.
• Involved in Unit Testing And Integration Testing.

Environment: SAP Business Objects XIR3.1, SAP Crystal Reports 2008/XI, SQL Server, Brio reports Tool, Crystal Designer 2008, MS SSRS, Java SDK, JSP, Business View Manager, Clear Case, Clear Quest, MS-Excel, MS-Word, Windows XP and UNIX.

Confidential,Norfolk, VA Aug 2009- June 2010
Crystal Reports Developer
Responsibilities:

• Work included Universe Designing, Requirement Gathering, Setting up Joins, Cardinalities, and Solving Traps using Contexts and Aliases and Updating Universes based on additional Requirements etc. using Designer.
• Developed Crystal Reports from SAP BW (Business Warehouse).
• Responsible for Creating the New Reports and also maintaining the Existing Reports.
• Published Reports in BO Enterprise (Info View) via. Business Publishing Wizard and Central Management Console (CMC).
• Involved in writing Technical specification documents (TSD) and Report Design Document (RDD) based on report client specifications.
• Responsible to Designing Universe with the Business requirement and the Aggregations, classes, Variables, Parameters conditions, Derived Tables, contexts etc.
• Responsible for implementing the security credentials at different Levels of Functional and technical requirements in user level and the object level restrictions in the Universe Designer XI 3.1.
• Highly involved in creating API with the front end Application and responsible to restrict the data based on the user credentials with respect to the Business objects XI R 3.1 info view categories and folders restrictions.
• Responsible for Designing Universe in Business Object XIR3.1 to get the Data from different Sources (Oracle, Teradata, Flat files, Excel Files)
• Involved in creating complex formulas for generating the Cross- tab reports with different Trending reports with Charts.
• Creating Objects in Business View Manager and data foundations to the right path which pulls the data from the database based on the joins established.
• Extensively used crystal reports 2008 in generating new reports with multiple sub reports which uses shared variables from the main reports.
• Responsible to create LOVs using Business View Manager (BVM) for Dynamic Cascading prompts.
• Created hierarchies and predefined conditions using Business Objects.
• Created Joins, Contexts, and Aliases for resolving Loops and Universe Tuning and checked the Integrity of the Universes.
• Changed the universe parameter settings to optimize the performance of universe.
• Created WEBI reports, MS SSRS & Crystal reports and deployed them through Info View with Universe as Source. Used Variables, User defined objects, Scope of analysis, Drill mode, Prompts, and Conditions to make reports accurate and easier for analysis.
• Involved in using Job Server in creation of real time jobs. And also involved in Performance tuning at source, transformation, and target levels.
• Involved in Improving Report Performance with Caching.
• Expertise in importing, exporting, changing Properties, modifying Reports Using Business Enterprise Portal (Info view).
• Created Materialized views, stored procedures, Functions, triggers, Synonyms, Views for Reports using complex SQL, PL/SQL.
• Created Reports based on Views, Stored Procedures and Commands. Modified existing Report based on the User requirement and created running totals, sub-totals and used Crystal syntax to create complex formulas for the Reports.
• Involved in creating Dash Boards for the Monthly/Quarterly/Yearly Analysis using Crystal.
• Created new reports and also modified many existing reports and successfully completed the project within the time given.

Environment: SAP Business Objects XIR3.1, SAP Crystal Reports 2008/XI, MS SSRS, Oracle 10g, SQL Server, Crystal Designer 2008, Epic Op-time, Win NT & UNIX.

Confidential, Apr2007-July2009
Oracle/Crystal Reports Developer
Responsibilities:

• Involved in Design and Development of Database.
• Involved in the software development process, established the goals and requirements of the application, data collection and analyzing the data as well as business flow.
• Extensively worked in retrieving the data from the database for solving complex queries.
• Wrote Unix Shell Scripts, and Performance tuning of the application.
• Developed job queues, which work similar to Queue series for running the program asynchronously.
• Created Stored Packages, Procedures and functions in Oracle 9i using SQL and PL/SQL for the Audit Trail using Oracle 9i as backend.
• Used Oracle 9i new features such as merge for various transformations.
• Worked on table partitioning (Range and List) and deploying various methods of indexing like local indexes and global indexes on portioned tables.
• Involved in creating procedures for Raw Data Reports using PL/SQL.
• Created linked sub reports (regular and On-demand) as well as unlinked Sub-Reports along with the Primary reports.
• Troubleshooting for all the issues in Crystal Enterprise and Reports.

Environment: Oracle 8i/9i, SQL, PL/SQL, Crystal Reports 2005& 2008, TOAD and Windows 2000.