SUMMARY

• Around Seven years of Business Intelligence experience; strong "hands - on" experience with SAP Business Objects XI 3.1/3.0/R2/6.5/(Designer, CMC, Dashboards, Xcelsius 2008, Crystal Reports 2008/ XI R2 and Info view)and Web Intelligence Crystal XI .
• Knowledge of different Schemas (Star and Snow Flake) to fit reporting, query and business analysis requirements.
• Experience in designing, building and maintaining Universes; resolving issues like loops & traps, designing complex objects using @prompt, @aggregate aware functions.
• Experience with data analysis, mapping source and target systems for data migration efforts and resolving issues relating to data migration and data creation.
• Experience performing UAT (User Acceptance Testing) and extensive experience in interacting with Department Managers and different levels of users and developers.
• Experience in creating Repositories, Folders, Groups, Users, assigning privileges to users and maintaining the Repository and working with Teradata Data Warehouse.
• Well qualified in creating Multifaceted Canned/Ad-Hoc reports using Business Objects, Web Intelligence.
• Proficient knowledge on BO XI Architecture and new features.
• Extensively used Business Objects Reporting functionalities such as Master Detailed, Cross tab, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
• Expertise in using Import Wizard to migrate reports and universes between different environments like development, testing and production.
• Experience in the documentation of system andBusinessrequirements and specifications, step-by step technical and user manuals, design and development of use and test-case scenarios and root-cause analysis, developing test plans, conducting user acceptance testing, training, and implementing new processes and technology.
• Strong experience with reporting and financial analytics in a Data Mart and Data Warehouse environment.
• Expert in tuning the performance of SQL queries.
• Experience in training Business Objects users, including walkthroughs and in-depth demos.
• Demonstrated ability to work both in independent and team-oriented environments
• Always eager to learn new technologies and tools quickly.
• Possess excellent communication, decision-making, Problem Solving, Analytical, and Interpersonal skills with result-oriented dedication towards goals.
• Excellent analytical, communication, problem solving, decision-making, presentation and organizational skills.

TECHNICAL SKILLS

Business Intelligence Tools: SAPBusiness Objects 4.0(Beta Version),BOXI 3.1/3.0/R2/R1/6.5/5.x (Designer, CMC, Supervisor, Broadcast Agent, Repository, Import Wizard, Web Intelligence and Info View, Desktop Intelligence, Crystal Reports 2008/XI.

RDBMS: Oracle 10g/9i/8i/7i, SQL Server 2000/2005/2008, PowerInsight EDW, MS Access

Languages: Java, J2EE, C, C++, C#, XML, Visual Basic, Asp.net, VB.net, T-SQL, PL/SQL, SQL

Data Modeling Tools: Erwin, Visio

IDE: Visual Studio .Net 2003/2005, Visual Basic 6.0

Application Software: Adobe Works, MS-Office Suite.

Operating Systems: Windows 7/Vista/ XP/2000/ 98/95, Windows NT 4.0, MS DOS

PROFESSIONAL EXPERIENCE

Confidential, Chesterbrook, PA.

Sr. Business Objects Developer/Crystal Reports Developer

Responsibilities:

• Was involved in Requirement sessions with the Business Users, Business Analyst and the Project Managers.
• Had weekly sessions with the Business and status meetings with the Manager to discuss the progress of the project.
• Had consistent sessions with the QA team and supported the QA team in the testing of the enhancements made in the Universes.
• Involved in support and maintenance of the Business Objects Application.
• Supported Production systems as required resolving production problems, and providing timely follow up on problematic reports.
• Scheduled reports in Infoview, send reports to users inboxes.
• Involved in Report and Universe Migration.
• Conducted Report Performance Report Testing.
• Designed the universes for various groups.
• Develop and Test the BO Universe and other related Objects.
• Involved in Enhancement of existing Universes and adding new tables & objects to the Universe as per the requirements.
• Resolved loops and traps using various methods alias and context.
• Developed several complex reports (include multiple groupings, drilldowns, parameter fields, formulas and retrieving data from more than one database) using Crystal Reports.
• Created Web Intelligence reports and complex queries using Merge Dimensions from multiple Data providers.
• Built queries to retrieve data in SQL Server through a universe and set up query conditions.
• Was also responsible for handling all the Operations and Production concerns involving Business Objects.
• Provided consulting support to Report developers (Business Users).
• Participated in Technical discussion for the development of reports.
• Used Life Cycle Management (LCM) for Universe Migrations to QA.
• Performed Knowledge Transfer to Key Business Users on using and developing Reports.
• Worked with Database Administrators, Application Developers & Business user's in order to ensure business requirements meet expected results.
• Created Webi documents and crystal reports and imported to Excel using Live Office.
• Developed dynamic Crystal Xcelsius Dashboards using Live Office.
• DevelopedCross Tab Reports,Sub Reports, and Parameter Reportsby usingCrystal Reports
• Tested the developed crystal reports andcreated test casesfor the testing team.
• Involved in Troubleshooting the data problems associated with reporting.
• Lead Business Objects Production Releases and coordinated with the Implementation team providing the knowledge transfer specifying the latest modifications and enhancements.
• Created and maintained all the required documentation regarding BO environment incorporating all the necessary changes going live.

Environment: SAP Business Objects Enterprise XI 3.1, Netezza, Web Intelligence Reporting, Designer,Crystal Reports XI, Windows 7.

Confidential, Hartford, CT.

Business Objects Developer/Crystal Reports Developer

Responsibilities:

• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements for Business Objects Universes and Reports.
• Worked with BW Consultants in Data Modeling, Data Loading, Scheduling and Monitoring.
• Coordination with Security team for Role creation in BW. Imported roles to Business Objects Enterprise.
• Uploaded master and transactional data from flat files and SAP BW.
• Created Process chains for Master data and transaction data loads with the help of Info Packages.
• Designed and developed new Universes as per the user requirements.
• Used Designer as a part of Universe Development for defining the parameters of Universe, inserting the tables, making joins, creating classes and objects.
• Created Hierarchies, complex objects using various @functions, aliases, contexts, Aggregate objects in the universe.
• Created Metrics, Analytics, rules, alerts and goals to build the Dashboards using Dashboard Manager and Performance Manager for Top Level Management to follow and take immediate actions on critical issues.
• Resolved loops using short cut joins.
• Exported the Universes to the Repository to make resources available to the users for ad-hoc reporting needs.
• Generated Web Intelligence Reports using the Universe as the main Data provider.
• Tuning of the reports for better performance.
• Organized data in the reports by using Filters, Sorting, and Ranking.
• Developed reports that involved the use of BO functions like crosstab, alerter, drill methodology, slice and dice, breaks, formatting, grand totals, charts etc.
• Applied Sections, Breaks, Report Filters and Query Filters and displayed the information in different blocks.
• Used Xcelsius to create Dashboards and visualized data.
• Designed and developed Crystal reports involving Sub-reports, Running Totals, Cross tabs and Charts with extensive formulas.
• Maintained/updated security definitions as needed including folders, reports, dashboards with BO security and Windows AD for user authentication with CMC.
• Scheduled reports using Central Management Console (CMC) in Business Objects Enterprise.
• Monitored and solved the issues encountered in Universes and reports.
• Assisted and was a part of the team of developers doing reporting on PowerInsight EDW with Business Objects3.1.
• Used Business Objects with PowerInsight to do statistical analysis and data display including tables, charts,etc.
• Exported reports into various formats like pdf and word for users.
• Helped the users in creating and maintaining the adhoc reports throughout the environment.

Environment: SAP Business Objects Enterprise XI 3.1, Oracle10g,PowerInsight EDW/Explorer, Web Intelligence, Live Office, Crystal Reports 2008, Designer, Windows 7.

Confidential, Thousand Oaks, CA

Business Objects developer

Responsibilities:

• Involved in interacting with users, gathering and analyzing requirements, logical and physical design of the reporting system.
• Designed new Universes and modified the existing Universes based on the business requirements.
• Used Designer Module to design Universes, joining the tables, creating prompts and queries and apply Contexts and Aliases to remove loops.
• Created User Objects including Dimensions, Details and Measures.
• Imported/ Exported the Universes from/ to repository to make them accessible to end-users.
• Created reports using various data providers such as universes, stored procedures, free hand Sql and personal data files (excel sheets and text files).
• Involved in creating the reports as per the business requirements like Customer information, services available using Web- I.
• Extensively used the Oracle Functions including the Analytical functions to create the complex objects in universe.
• Worked with database team and provided the input to create the Aggregate tables for Year to Date and FY-Year Ending Trending Analysis Reports.
• Created the reports for marketing group based on the Customer Experience data which was collected by an Automated Survey Tool.
• Generated the Business Objects reports involving complex queries, sub queries, Unions and Intersection.
• Extensively used various techniques like Sectioning, Ranking, Filtering, Slice and Dice to develop the reports.
• Created reports on the web using Web Intelligence and distributed them to different users through info view portals.
• Used Broadcast Agent for scheduling and distributing the documents.
• Supported the application by solving the trouble tickets which was created by the users.
• Monitored and solved the issues encountered in Universes and reports while migration and tested before moving to production.
• Coordinated with Business Objects Deployment and documented the entire project.

Environment: SAP Business Objects XI 3.1 (Designer, Rich client, Web Intelligence, CMC & Info View), Oracle 10g, Windows XP.

Confidential, Sunnyvale, CA

Business Objects Developer

Responsibilities:

• Optimized reporting environment to meet demanding needs of customers.
• Performed business analysis for Electronic Content Management, Membership Management and Accounting Management.
• Designed and developed data marts for reporting efforts.
• Created universes and reports in Business Objects.
• Involved in documenting detail functional specifications and executing technical scripts.
• Performed data mapping of Business Objects universes from 6.5 toXIR2.
• Created prompts and queries, parsing the Universes, applied contexts and alias tables to remove cyclic dependencies.
• To enhance the report performance worked with @functions (@aggregate aware, @select, @prompt, @where.
• Created Templates for standardizing the Structure of our Corporate Documents.
• Worked at length with the major functionality of Business Objects like Breaks, Alerter, Filters, Sorts, Query Prompt and Drill filters.
• Converted existing reports in Desktop Intelligence to Web Intelligence reports using Report conversion tool.
• Designed and developed Web Intelligence interface according to the Client requirements.
• Involved in developing manuals for user conferences.
• Involved in installing Business Objects, creating Repository, Users, and User Groups and prioritizing Security Levels for Users and User Groups.
• Provided production support for wide range of customers.

Environment: SAP Business Objects XI 3.0/3.1, Crystal Reports, MS Access, MS Excel, Dashboard Manager, Info View, MS Project, JSP, Windows 2000 Professional, Web Intelligence, Oracle8.1.

Confidential, South San Francisco, CA

Business Objects Developer

Responsibilities:

• Created new Attributes, Filters and Complex measure objects in the Universe.
• Maintained Reports from two different Universes.
• Created reports with graphical representation such as Bar charts, Pie charts for multidimensional analysis.
• Defined and created Hierarchies as per the business rule for the reports to be viewed at various Drill-down and Drill-up reports.
• Provided support to the Web Users and Full client users for any specific or performance issues related to the reports.
• Created the new Views and Aggregate tables for report performance.
• Worked on the SQL tuning and optimization of the Business Objects reports.
• Generated Web Intelligence reports from SAP OLAP sources.
• Created and Developed Stored Procedures, Packages.
• Worked along with the testing team to derive test cases for efficient Data reporting.
• Worked with Data Modeling Team and fixed Dimensional Modeling issues.
• Scheduled and monitored reports by using Broadcast Agent.
• Worked extensively on Web Intelligence for any new requests and performance issues.
• Conducted training sessions for Customers about using Business Objects Full client version and creating ad-hoc Reports.

Environment: SAP Business Objects XIR2/6.5, Crystal Reports XIr2/10, Performance Manager, Windows XP, SQL Server 2005.

Confidential

Business Objects developer

Responsibilities:

• Involved in installation of Business Objects XI R2 and repository creation.
• Created User groups, Users, Managed user privileges.
• Implemented Row level security & Object level security.
• Involved in the designing and Building of Universe, Classes and objects.
• Involved in Deployment of Universes and Reports from Development Environment into Production Environment.
• Resolved loops using Contexts, and Aliases.
• Created and linked reports using Open Doc Methodology.
• Developed variables and formulas according to the Report Requirement Template.
• Created reports for various Portfolios using Universe and free hand SQL as the main data Providers.
• Developed simple, canned and adhoc reports using various functionality’s like Queries, Sub queries, Alerters, Slice and Dice, Drill Down, Master Detail and Formulae’s etc.
• Worked on Various Sub-Reports and Cross Tab Reports.
• Worked on Database Expert, Section Expert, Select Expert and Group Expert and Hierarchical Grouping to develop the reports using Business View in Crystal Reports XI.
• Worked on Parametric fields, formula fields and summary fields.
• Used dynamic data connections to create reports using Business View in Crystal Reports.
• Worked with Data Modellers while working with Functional Requirements and done modifications for the Modelling.
• Created Business Objects Repository while building Business Objects solution and Created and tested classes and objects to organize the universe.
• Published and scheduled Business Objects Reports to users using Scheduler.
• Performed Unit Testing, System Testing and Performance testing for each report.

Environment: Business Objects XI R2, Crystal Reports XI R2, Oracle 9i/10g, SQL Developer.

Confidential

Business Objects Developer

Responsibilities:

• Developed Custom Hierarchies to support drill down reports.
• Exported the universes to the Repository to make resources available to the users.
• Mentored Business Users in Business Objects Live Office.
• Created, modified, deployed, optimized, and maintained Business Objects Universes using Designer
• Orchestrated a proof-of-concept of BO’s Performance & Dashboard Manager in order to resolve navigation and user load issues.
• Used Scheduler to process BO reports in off-peak times, so that peak time processing power is increased. Also done scheduling of the reports to various users in various formats according to their requirement.
• Involved in setting up user profiles, created groups and Categories using CMC.
• Configured Client Configuration Assistant to connect to the repository Oracle.
• Created sophisticated Drill Reports and Slice and Dice reports.
• Configured the Business Objects tools for enterprise-wide deployment.
• Created reports with Selection Criteria, Grouping, Sub reports, Cross tabs, Standard and Summary.
• Documented report parameters, fields, and logic used for developing of reports and universe in a word document.
• Generated Desktop Intelligence and Web Intelligence reports using open document methodology.
• Provided technical assistance/support to analysts, business community and respond to inquiries regarding errors, problems, or questions with programs/interfaces.

Environment: Business Objects 6.1/ 6.5/6.5.1, Crystal Reports.