SUMMARY:

• 7 years of IT experience with data analysis, design and implementation of Business Intelligence Reporting Solutions.
• Expertise in all modules of Crystal Reports and Business Objects Suite XI3.1/XIR2/6.5(Installation, Configuration, Dash Boards design, Up - gradation, Universe Design and Development, Report Development, Performance Tuning/ Optimization, User/Security Administration)
• Experience in Designing BO Universes and development of Crystal Reports, deskI and WebI.
• Experience in Business requirement gathering, Analysis and Documentation of the technical and User requirements.
• Worked on designing Dash Boards, Desk Intelligence, Web Intelligence reports, Desktop Intelligence Reports and Broadcast agent in Business Objects and Xcelsius.
• Experience using Business Objects XI - XI 4.0/XI3.1/XIR2/6.5, Designer, Desktop Intelligence, Webi Rich Client, Info View, Query as a Web Service, Live Office, Xcelsius, Launchpad.
• Experience in Designing and Development of Relational / Dimensional Database on Oracle9i/10g and MS SQL Server 2000/2005/2008.
• Hands on experience in Installing, Configuring and Troubleshooting the Installation issues of BOXIR2/ XI3.1.
• Involved in the development and implementation ofreportingsystem usingBusiness Objects XIR2, Infoview, DESKI.
• Expertise in creating the dash boards representations for various departments and consolidated reports using Xcelsius.
• Experience in the development of all components of a BI reporting solution leveraging the BO XI infrastructure
• Experience working on various Data warehouse Projects.
• Worked on Commercial Lines reports for different departments and clients.
• As a Clarity Report Writer creating design specifications for new reports and identifying and validating the appropriate technological solutions for various reporting needs.
• As a Report Writer created new reports, using a third-party report-writing tool, to display Clarity data.
• Profound knowledge of Extract, Transformation and Load (ETL) process using Datastage.
• Designed, implemented and migrated complex Universes and Business Objects Reports, Created classes, subclasses, objects, Cardinalities, Conditions, Contexts, Joins, External Strategies, Prompts and Aliases for resolving Loops and checked the Integrity of the Universes.
• Quickly develop sound understanding of existing BI application.
• Involved in Business Objects Testing at Report Level, Universe Level, and Data source Level
• Delivery competency to meet enterprise business requirements.
• Worked on dynamic and interactive models dat can be added to dashboards using SAP BusinessObjects Xcelsius 2008.
• Worked on multiple Data Sources (Sql Server, Db2, Oracle, Sybase, SAP BW, Access)
• Experience in users, Knowledge of facilitation, mentoring and Technical writing skills including documentation and editing of user manuals.
• Created complicated reports including sub-reports, graphical reports, formula base and well-formatted reports according user requirements.
• Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.

TECHNICAL SKILLS:

Business Intelligence: Crystal Reports 2008, Crystal Reports 9, SAP BO 4.0, Business Objects XI 3.1/XI R2/6.5 (Designer, Info view, Xcelsius, and BI Widgets)

Business Analysis: Functional Requirements Gathering, User Interviews, Business Requirements Gathering, Process Flow Diagrams, Data Flow Diagrams, Data Analysis, Requirements Analysis, Design, Data Modeling, Data Architecture, Data Flow, Data Cleansing

Dimensional Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Oracle Designer, Visio and Sybase Power Designer.

Databases: Oracle 10g/9i, MS SQL Server 2008/2005/2000 , MS Access, SAP BW

Environment: Windows7, Windows Server 2008/2003, Windows XP

PROFESSIONAL EXPERIENCE:

Confidential, La Palma CA

Reports Developer

Responsibilities:

• Worked on Crystal Reports 2008.
• Reports are generated usingBusiness Objectsfunctionality suchasSlice and Dice, Master/detail, Cross tab, User Responses, Formulas using Web Intelligence.
• Business Objects Testing at Report Level, Universe Level, and Data source Level.
• Testing at all phases of Business Objects.
• Working on the Reports related to the Hyperlinks.
• Generating various reports on Daily, Weekly, and Monthly basis.
• Involved in weekly Team Meetings with Application Development Team members on analyzing the projects.
• Responsible for maintaining Business information to support in development operations.
• Used WEBI for Accounts - Report Development for Smart Connect Project.
• Involved in All phases of Testing with respect to the Project Development.
• Involved in Resolution of defects in a specific time frame.
• Involved in Universe Development applying Index awareness and Aggregate awareness for improving queries.
• Scheduling Reports through Infoview.
• Used prompts to make Reports confined to a particular case as per business requirement.
• Provided for the Users.
• KT to Support team.

Environment: Crystal Reports 2008, SAP Business Objects 4.0 and XI 3.1, Teradata 13.0

Confidential, Dallas TX

Reports Writer/Developer

Responsibilities:

• Worked on Month End Reports created using Crystal Reports 2008.
• Installed and configured the BO XIR 3.1
• Migrated the reports, Universes from Business Objects XIR2 SP3 to XIR3.1.
• Business Objects Testing at Report Level, Universe Level, and Data source Level.
• Testing at all phases of Business Objects.
• Reports are generated usingBusiness Objectsfunctionality suchasSlice and Dice, Master/detail, Cross tab, User Responses, Formulas using Web Intelligence.
• Generating various reports on Daily, Weekly, and Monthly basis.
• Used Clarity as a External data warehouse for developing Clarity reports by Epic and Epic clients using Business Objects' Crystal Report
• Involved in weekly Team Meetings with Application Development Team members on analyzing the projects.
• Responsible for maintaining Business Intelligence information to support in development operations.
• Used WEBI for Accounts - Report Development for Commercial Lines Project.
• Worked on Commercial Lines reports for different departments and clients.
• Hands on experience working on Microsoft Office Excel 2007 Macros.
• Scheduling Reports through CMC (Central Management Console).
• Used prompts to make Reports confined to a particular case as per business requirement.
• Provided for the Users.

Environment: Crystal Reports 2008, Business Objects XI R2 sp3 and XI 3.1 (Full Client Desktop me and Web me), SQL SERVER 2005, MS Access.

Confidential, Alpharetta GA

Reports Writer/Developer

Responsibilities:

• Involved in the progress of migration the universe and crystal reports from Development region to QA and tan to Production.
• Responsible for analyzing, designing, implementing and maintaining complex components of Reporting / Business Intelligence information systems (business objects XI3.1) dat support critical business operations
• Developed complex reports, charts and other data analysis solutions on cutting-edge business intelligence technical platforms (business objects Full Client Desktop Intelligence and WEBI).
• Involved in performance tuning of Business Objects WEB Intelligence reports.
• Published, tested and scheduled reports in the Business Objects Enterprise Server.
• Created reports and modified by understanding business concepts and depth skills of Business Objects, Data warehousing concepts, Data modeling techniques, star schema and SQL language to implement the Universe and the Reports.
• Installed and configured Business Objects Enterprise XIR2.
• Involved in Unit Testing of the Business Objects reports.
• Involved in weekly Team Meetings with Application Development Team members on Analyzing ER Diagrams.
• Participated in review of Existing universes and their modifications to meet the user reporting requirements. Implemented enhancements to the existing universes, fixed joins and contexts problems, applied aggregate awareness to speed up the query time, created cascading prompts and new objects with customized LOV’s to support the current environment.
• Worked on Sql Server Database as on the basis of handling reports using Universe.
• Creation of reports like Reports by Period, Demographic reports and Comparative Reports.
• Created reports on web using Info View Portal distributed the reports to different users.
• Fixing the UAT issues raised by the client
• Created Drill-Down Hierarchies and their TEMPeffective and optimal use in Reports.
• Created New Classes and User Objects in designing the universes.
• Generated various reports on Daily, Weekly, Monthly and Yearly basis.
• Created Charts to display summary data using universe as main data provider.
• Involved in re-designing or customizing the existing Materialized Views and to suit the Reporting needs and pull the records from multiple tables using JOIN’s.
• Worked with ETL team to understand the details of load process, so dat we can build reliable and efficient reports.
• Developed Parameterized Reports, Cross tab Reports and Sub Reports involving complex formulas.
• Involved in redesigning of Existing Universe designs.
• Involved in performance tuning of reports by eliminating filters at report level.
• Recommended and implemented design changes to warehouse, fact tables and indexes to improve query performance
• Used prompts to make Reports confined to a particular case as per business requirement.
• Generated sub Reports, linked and unlinked Reports, Reports on demand

Environment: Crystal Reports 2008, Business Objects 3.1 (Full Client Desktop me and Web me), BO XIR2 SDK, SQL SERVER 2008/2005, BI Widget, Xcelsius 2008.

Confidential, Alpharetta GA

Reports Writer/Developer

Responsibilities:

• Converted theexisting Legacy reportsintoBusiness Objectsreportsfrom a given set ofBusiness Specifications.
• Involved in the development and implementation ofreportingsystem usingBusiness Objects XIR2, Infoview, DESKI.
• Reports are generated usingBusiness Objectsfunctionality suchasSlice and Dice, Master/detail, Cross tab, User Responses, Formulas, Calculation contexts/ extended contexts.
• Working with theBusiness usersforrequirements gathering, business analysis and making technical specifications for the reports.
• Createdclasses, objects & conditionsas per requirement of thereports.
• Identifying therelationbetween differenttablesand definingjoinsamongst the fields.
• CreatingContextsand Aliasesfor resolving Loops, and synchronization problems in theSQL.
• Worked on a Teradata managing serverinterconnected by the proprietary in accordance to the Report Development.
• Creatinglinked reportsforWEBI reportsusing open document functionality.
• Hands on Experience with Datastage for creating parallel jobs in an ETL Division.
• Worked on existing universes and created views in the Designer.
• Creating and deployingtheDashboardsusingDashboard Managerand extensive work on performance management.
• Scheduling the reports throughWEBIlevelby refreshing and sending to the in-box/ corporate documents.
• Built reports using multipledataprovidersand involve inperformance tuningof Reports.
• Involved inunit testingof reports andMigratingthe universes and reports todifferent environments.
• Involved in the process of development, testing,UAT and finally production.
• Interacting with DBA forbetter performance of reports.
• Creatingnew Connectionsandediting existingone to run the report in different database.
• PublishingandDistributionof reports forInfo view clients.
• Providingtroubleshootingfor various problems pertaining to thin-client reporting and formatting, design of universes and other BO complexities.

Environment: Crystal Reports 2008, Business Objects XIR3.1, Web Intelligence, Deski Report, Datastage, PL/SQL, DB2, SQL Server 2000, and Windows 2000/2003 Server.

Confidential, Hartford CT

Reports Writer/Developer

Responsibilities:

• Developed various Reports for Area wise, Regional, National, and Response Analysis using Crystal Reports/Business Objects XIR2.
• Designed Crystal Reports using version crystal 9 with Crystal reports formulas, Grouping, Parameters, Selection criteria to handle the report requests
• Responsible for developing thick/thin client canned reports using Business Objects and Web Intelligence.
• Tested about 80 Business Objects full Client reports in the BO XIR2/ Crystal XI/9 environment.
• Resolved loops and Traps, created complex Reports, Cross Tab and Master Detail reports by using BO Functionalities like Slice and Dice, Drill Down, Variables, Filters, Breaks, Alerters and other features.
• Installed and configured Business Objects Enterprise XIR2
• Performed a migration from Business Objects 6.5 to Business Objects XIR2.
• Worked with installing in both desktop and server products of B.O 6.5 on UNIX environment.
• Designed a questionnaire dat halps in requirements elicitation from end-users which halps in Universe and Reports Design.
• Coordinating with end-users and business analysts to understand the scope of business requirements, user expectations, and ensure the accuracy of reporting specifications
• Involved in different phrases of the project like analyzing requirement, planning, execution and maintenance.
• Responsible for defining the scope of the project, gathering business requirements, doing gap analysis and documents them textually or within models.
• Worked on Data Modeling using Dimensional Data modeling, Star Schema/Snow flake schema, fact & Dimensions tables, Physical & logical data modeling.
• Created users, groups and access rights using Central Management Console.
• Created classes and objects in universes using SQL Server 2005 database.
• Created complex new Universes, Linked with existing Universes from Data marts.
• Worked with Crystal Xcelsius for creating simple dashboards and simple crystal reports and convert those in to user interfaces like excel files, PowerPoint representations for better understanding.
• Extensively used report conversion tool for converting desktop reports to web intelligence reports.
• Used Informatica to design, code and test data extraction from multiple databases Oracle 9i and DB2.
• Business users to use Web Intelligence to create ad-hoc reports as well as view existing published reports.
• Created complicated reports including sub-reports, graphical reports, formula base and well-formatted reports according user requirements.
• Creating, maintaining and modifying the business critical reports using the Desktop Intelligence.
• Scheduled and monitored reports using Broadcast Agent Server.
• Participated in developing the Relational Model (Logical & Physical) and in documentation of technical methods of development as well as business related information regarding the design process.

Environment: Crystal Reports 9, Business Objects 6.5/XIR2, Performance Management, Oracle 9I, SQL and PL SQL.

Confidential

Reports Developer

Responsibilities:

• Responsible for the modifying the universe and creating aliases to resolve the loops and creating the objects dat are grouped into class.
• Created the reports (Master/Detail, Cross tab and Chart reports)inBusiness Objectsand Web Intelligence using the universes as the main data providers and writing the complex queries including sub queries.
• Designed, developed, tested and supporteduniverses and highly complex reports inBusiness Objects.
• Worked with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate functions.
• Exported the universes and the reports to the Repository to make resources available to the existing users.
• Involved in Adding of new Objects to the existing Universe as per end users request.
• Created BO reports in Web Intelligence and published them to corporate documents.
• Createdalerts in reports based on conditions according to user requirements.
• Exported Universe across differentenvironments domains from development to Production.
• Standard Templates were created for future Ad-hoc reporting needs.

Environment: Business Objects 6.5 Designer, Desktop Intelligence, Web Intelligence, SQL Server, Oracle 8.x, and Windows 2000/NT.