EXPERIENCE SUMMARY:

• 6 + years of experience in Data Warehouse reporting with BOXI R2/R3 SAP Business Objects
• Expertise in all phases of Software Development Life Cycle (SDLC) using Traditional and Agile Methodologies SCRUM MASTER .
• Involved in requirements analysis and designing of Business Objects Reports
• Expertise in Universe design, reports development in Business Objects Web Intelligence
• Expertise in Scheduling Business Objects Reports using Business Objects Central Management Console
• Experience in Oracle and SQL/PLSQL
• Extensive experience as a Report Developer / Analyst. Developed reports using Business Objects XI R3/R2/6.5 (Report Designer, Universe Builder, Web Intelligence, Desktop Intelligence), Info view.
• Experience using Business Objects Administration, Web - Intelligence, BO Developer Suite Web Admin tool, Supervisor, Designer, Web Intelligence/Info view and Crystal Suite.
• Efficient in optimizing and writing SQL queries and creating views in.
• Proficient in all phases of the Software development lifecycle SDLC, including requirements Definition, Analysis, Design, System Implementation, Performance Tuning, Testing and Support.
• Extensively Used CMC (Central Management Console) for user management, content management, and server management tasks and CCM (Central Configuration Manager) to manage local and remote servers
• Extensive experience in writing SQL and PL/SQL programs Packages, Stored Procedures, Functions, Triggers and creation of Tables and Indexes for back end development.
• Expertise in generating simple, complex and ad-hoc Reports from multiple data sources.
• Experience in interacting with Business Users / Business System Analysts to understand the business requirements and transform the business requirements into technical requirements.
• Experienced in creation of high level design, detail design, unit test plans System/Integration plans and traceability matrix based on business/technical requirements.
• Experience in Data Warehouse development working with Data Migration, Data Conversion, and Extraction/Transformation/Loading, using Informatica Power Center.
• Two complete end-to-end implementations as Business objects lead.
• Completed Two BO migration projects.
• Efficient in Optimizing, Debugging and testing SQL queries.

TECHNICAL SKILLS:

BI Tools: Business Objects XI 3.1/3.0/XIR2/6.x - Central Management Console, Central Configuration Manager, Web I/ Desk I, Designer, Supervisor, Broadcast Agent Scheduler, Crystal Reports 2008/ XI/10/9, Import Wizard, Report Conversion Tool.

ETL Tools: Abintio & Informatica

Platforms: Windows, UNIX

Databases: Oracle, DB2

Languages: SQL, PL/SQL

Others: Quality Center, Remedy, Clarity, SharePoint, MS Office, MS Visio

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix

Business Objects Technical Lead

Responsibilities:

• Worked as Lead on BO migration cum development project from BO 6.5 to BO XI 3.1
• Worked with the Business analysts for requirements gathering, business needs analysis, testing, and project coordination which acted as a base for the project initiation and implementation.
• Created Universes and Reports and Checked the Universes for Integrity and exported them to the Repository to make resources available to the users and groups.
• Designing, creating, enhancing, testing BO universe, reports.
• Resolved loops and traps by either creating aliases or contexts or by defining shortcut Joins.
• Created Ad Hoc Reports as per the users requirements.
• Applied slice-and-dice, drill-up and drill-down techniques in master detail reports for multi-dimensional analysis of retrieved data.
• Defined Hierarchies in Universe to provide the users with Drill down option in reports and Predefined Conditions to use in Business Objects.
• Imported/ Exported the Universes from/ to repository to make them accessible to end-users.
• Resolved several Universe and Report issues in the process of migration.
• Created Prompts, conditions and Filters to improve the report generation. Also used Alerts to improve the readability of the report.
• Created graphical representation of reports such as Bar chart, Pie chart etc. as per the end user requirements.
• Created number of formulae, conditional display of fields for complex calculations and used them in different sub 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.
• Developed several complex reports (include multiple groupings, drilldowns, parameter fields, formulas and retrieving data from more than one database) using Crystal Reports.
• Exported reports into various formats like PDF, HTML, EXCEL, WORD for end users
• Created and Tuned complex stored procedures in SQL server for faster execution.
• Created Web Intelligence and Desktop Intelligence reports with multiple data providers like Universes, Personal Data Files and free-hand SQL.
• Built queries to retrieve data in SQL Server through a universe and set up query conditions. .
• Wrote documentation for users on how to select necessary parameters and date frames for different selections
• Performed Unit testing and System testing of the developed reports

Confidential

Business Objects Lead

Responsibilities:

• Migration of Universes, Reports, other BO objects from BO 6.5 to BOXIR2.
• Business Objects universe designer and report developer.
• Analyzed the existing OLTP system, which is a Claims Management application with back-end Oracle.
• Gathering and analyzing the requirements
• Created universes, classes, objects, and predefined conditions in Designer.
• Created Joins, aliases and Contexts.
• Resolved loops by creating Aliases and Context.
• Optimizing the Universe to improve the performance.
• Created Web Intelligence and Business Objects full client reports.
• Complex reports were developed using Web intelligence (WEBI XI) and complex full client Business Objects
• Experience in creating various types of Reports like Cross tab Reports, Drill through Reports.
• Created, used customized, dynamic list of values (LOV’s) while creating Universes, Reports.
• Created User Prompts, Conditions and Filters to improve the report generation.
• Interacted with Business Objects technical team to solve the bugs involved in Business Objects.
• Met with the Business Analyst, Users and Businessleads to understand their needs. Modified universes and created reports for them accordingly.
• Defined Business Views and Business components with data connections.
• Provided Business Objects technical support team assistance to solve client technical issues.
• Provided End user support and guidance to use reports.
• Responsible for maintain the business objects enterprise server.
• Designed the Dashboards using Crystal Xcelsius for the Supply Chain Management.
• Worked on row level user security, helping to create SAP BO user variable loading security from the Windows AD group.
• Modified complex reports based on discussions with user groups and created various objects using built-in @functions (like @prompt, @select, @where, and @aggregate), complex SQL queries and joins.
• Designed the Security Architecture in the Business Objects XIR3.
• Created linked, unlinked and on-demand sub reports for various businessneeds, Reports scheduled for different file based / schedule based events, distributed in email, PDF and html format.
• Defined standards & production support documentation for other developers to follow.
• Conducted End user training for ad-hoc reporting & standard reporting.
• Tuning the SQL to improve the performance of the reports.
• Provided Training to Business Users about the Business Objects Reports.
• Conducting periodic training for business users on reporting techniques.

Confidential

BI Report Developer

Responsibilities:

• Worked with the Business analysts, end users, Data Modelers and the DBA for requirements gathering, business analysis, and testing, project coordination.
• Managing the Universes, Business objects products, Stored Procedures, Repository and Document domains.
• Creating User groups, Users, Database connections.
• Created new reports from the scratch for new requirements and modified some of the existing reports.
• Created new objects, Filters and Complex measure objects in the Universe.
• Created the new Views and Aggregate tables for report performance.
• Conducted training sessions for end users about using Business Objects Full client version and creating ad-hoc Reports.
• Extensive testing and migrating the reports or objects from Test to Production system.
• Worked along with the testing team to derive test cases for efficient Data reporting.
• Created different types of reports, like Master/Detail, Cross Tab and Chart (for trend analysis). Used filters, conditions, calculations, etc.
• Scheduling reports from the Broadcast Agent Server to only requested users.
• Worked extensively on Web Intelligence for any new requests and performance issues.
• Documented all the changes made to the Universes and Reports for future references.