SUMMARY

• Six Plus (6+) years of experience in SAP BOBJ 4.1/4.0/3.1/3.0, XI R3/R2/6.5, Business Objects Web Intelligence, Desktop Intelligence, Universe Designer, Crystal Reports, Xcelsius, Infoview, Server Configuration, Dashboard, Infoview, Import Wizard, Upgrade Management Tool, CMC, QWAAS, Live Office.
• Working noledge and proficiency wif Business Objects Enterprise products namely Business Objects Reporting, Information Design Tool, Business Objects Designer, Business Objects Supervisor.
• Expert in generating Sub Reports, Standard, Cross Tab Reports and Graph/Chart Reports by using Chart expert of Crystal Reports.
• Strong skills in interfacing Business Objects, Crystal Reports wif sources such as Oracle, SQL Server, DB2, SAP Tables, Teradata, XML Files and Flat files.
• Created and Modified BO Universes. Exposure to Business Objects migration process. Very strong at resolving Join problems using Contexts and Aliases.
• Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
• Experience in Installation, Administration, Design Universe, Reporting (Desktop Intelligence & Web Intelligence) and Migration of Business Objects.
• Experience in Designing/Developing Universes/Data - Model, Developing Canned/Ad-hoc Reports, Scheduling and processing of reports using CMC. Expertise in Universe designing,
• Experience in generating various types of BO reports including Deski, Webi reports and Dashboards.
• Experience in Installation, configuration and migration of Business Objects and Crystal Enterprise to newer versions.
• Created users, roles, tables, permission granting, synonyms, indexes (SQL), User management, Import & Export of data using oracle export/import utility.
• Experience Creating Several Dashboards / Scorecards using Dashboard Manager and Crystal Xcelsius.
• Extensive experience in developing static and dynamic dashboards using Crystal Xcelsius.
• Created Wat-if scenarios in Crystal Xcelsius to demonstrate Business Benefits for teh Business Managers.
• Proficient in implementing several advanced features of Crystal Reports 4.1 and 4.0 / Crystal Reports Server 2011.
• Thorough hands-on expertise in Crystal Reports wif proficiency in using advanced Crystal Reports functionality such as Custom Functions, Web Elements, Crystal Formulas, Sub Reports, and Conditional Formatting etc.
• Interacted wif teh Business Users to gather requirements, Design Tables, standardize interfaces for receiving data from multiple operational sources, coming up wif load strategies of loading staging area and data marts.
• Good working experience in Data Modeling using Dimensional Data modeling, Star Schema/Snow flake schema, FACT & Dimensions tables, Physical & logical data modeling.
• Experience in PL/SQL Programming (Stored procedures, Triggers, Packages) using Oracle.
• Strong Experience in Software Development Life Cycle (SDLC). Aware about teh software methodology like agile, scrum and waterfall model. Responsible for gathering requirements from end users to arrive at requirements for report generation. Analyzed to data to ensure required reports can be generated. Performed Validation of BI / BO reports as per teh requirements.
• Strong understanding of RDBMS and Data warehousing concepts. Knowledge in Data mart development.
• ETL Experience using Informatica PowerCenter 9.0/8.1. Assisted in creating ETL Mappings.
• Extensively used Oracle Pl/sql and sql for report creation and testing teh reports. Created SQL Queries, Created SQL Queries, Performance tuning of teh code.
• Expertise and in-depth noledge of using Oracle PL/SQL in writing Oracle packages, stored procedures, views, and indexes.
• Experienced in writing complex PL/SQL scripts for conversion, loading, and maintaining data in different environments (dev, test and prod)

PROFESSIONAL EXPERIENCE

Confidential, Houston, Texas

Sr. SAP Business

RESPONSIBILITIES:

• Gathering business and user requirements for reporting purpose through meetings.
• Created a new publication and scheduled a new Crystal, Webi and Deski Reports.
• Maintained and Updated existing Universe, Crystal, Deski and Webi reports in order to meet User and Business expectation.
• Create Sub reports called/linked from teh main report to implement teh business logic.
• Generate reports wif parameters, sub reports, cross tabs, charts using Crystal Reports.
• Maintained, Updated and Created new users, groups for technical and non-technical person/team and provided them enough privileges in order to access Reports, Universes.
• Troubleshooting Reports, Universes and Business Objects servers to flawless work on Business Objects.
• Created/modified new and existing Stored procedure and SQL in order to meet teh user requirements.
• All BO users logins and Security checks verification and monitoring BO server including Test running wif optimal performance.
• Performance tuning of BO reports and universe and maintaining teh universes and reports.
• Monitoring all DB services and testing teh availability of all Universe connections to respective Databases.
• Server Installation, Maintenance, Patching and upgrading teh servers.
• Installation, migration and new implementation of BO server from BO XI 3.1 to BI 4.0.
• Worked on SQL Querying, Tuning and Optimization of reports.
• Developed View on Demand and Canned reports wif Date functions, Drill Filters, Breaks, grouping data, custom sorts displaying data in Free-standing cells in infoView and WEBI.
• Created enterprise level reports and also district level reports in infoView and WEBI. Tested those reports by validating through teh reports generated by Elite Enterprise.
• Created reports from multiple source universes and linked universes then merge teh common dimensions and created big reports. As well as used teh multiple query option to select teh data from multiple sources.
• Managed and Configured Servers (File Repository Server, Report Application Server, Web Intelligence Server, Destination Job Server, Program Job Server, Event Server)
• Created reports using Business Objects functionalities like queries, slice and dice, drill down, cross tab, master detail reports, formulas, etc.
• Watch teh SQL activity through SQL Monitor tool and tune teh server and query performance up to teh mark.
• Used teh Import wizard extensively to move teh content and users.
• Created and Maintained Users, folders, scheduled and published reports to Crystal Management Console. Monitored failed reports. Exported reports in Excel, PDF and saved on Shared Network drive, e-mailed to users as per teh requirements.
• Used teh Import wizard extensively to import existing user accounts, groups, categories, WebI

Environment: SAP BO 4.0/XI R2, Universe Designer, WebI, infoView, DeskI, SAP Crystal Reports 2011, CMC, Import Wizard, Dashboard, Oracle 10g/11g, SQL Server 2008, Flat Files, and Windows.

Confidential, San Jose, CA

Sr. SAP Crystal Report Developer

RESPONSIBILITIES:

• Requirement gatheird through team meetings and analyzed teh requirements for teh new custom universes. Analysis has done by designing a data model for all teh required fact and dimension tables referred from datamarts.
• Create various complex reports using SAP Crystal Reports 2011.
• Created sub-reports to fulfil teh business requirements and linked teh sub-reports into main report and also worked on optimizing teh report performance.
• Created number of formulas, running totals conditional display of fields for complex calculations and used them in sub reports.
• Created ad-hoc reports based on calculation and formulas based on requirements.
• Created Report templates, Summary Reports, Parameterized Reports.
• Used Groups, formulas, running totals and summaries in teh reports.
• Scheduled reports to run on daily/weekly/monthly basis and to distribute teh output in different formats to various users.
• Building Relationships between different tables according to requirements in database expert.
• Used Reference cursors, Unions, Joins extensively in Stored Procedures.

Environment: SAP Crystal Reports 2011, Oracle 11g, Flat Files, and Windows.

Confidential, Sacramento, CA

SR. SAP BOBJ DEVELOPER /Admin (SR. INFOADVANTAGE DEVELOPER)

RESPONSIBILITIES:

• Requirement Gatheird and analyzed different data sources in both Advantage and infoAdvantage.
• Analyzed teh requirements for teh new custom universes. Designing a data model for all teh required fact and dimension tables referred from datamarts.
• Installed Business Objects tools BO XIR3 along wif TOAD, Oracle Client 11g. Set teh database connectivity wif Universe Designer as well as BO security for Users and Developers.
• Created new universes based on teh Users requirements, data modelling and group meetings wif IT team.
• Created additional objects based on teh calculations provided by reporting developers, along wif teh existing objects from other parent universes.
• Resolved issues like Isolated Joins, Loops, and Contexts using Aliases and Contexts where ever appropriate.
• Modified teh existing universes and created additional objects as per teh requirements in teh change request. Tested teh modified universes by creating reports and by matching teh data wif teh report generated by AMS Advantage.
• Created complex conditions (Dates), Prompts and free hand custom SQL to create Derived tables in teh universe. Defined logical classes and objects and hierarchies for analysis and drilling on hierarchies in teh WEBI reports.
• Reports are created and data are analyzed in teh reports in order to test teh newly built Custom Universes.
• Performance tuning of teh custom universes was also handled by creating index awareness.
• Experience in building Business Objects Universes, Stored Procedures, Free Hand SQL methods and creating Complex canned and Ad-Hoc Reports using Business Objects reporting application like Web Intelligent /Info View.
• Worked on SQL Querying, Tuning and Optimization of reports.
• Developed View on Demand and Canned reports wif Date functions, Drill Filters, Breaks, grouping data, custom sorts displaying data in Free-standing cells in infoView and WEBI.
• Created enterprise level reports and also district level reports in infoView and WEBI. Tested those reports by validating through teh reports generated by AMS Advantage.
• Created reports from multiple source universes and linked universes then merge teh common dimensions and created big reports. As well as used teh multiple query option to select teh data from multiple sources.
• Documented teh technical document as well as user manual documents in order to halp users to select correct values for teh context prompts generated in teh reports.
• Well documented teh design of Universe and detailed classes/objects information wif macro enabled excel, all teh changes made to teh Universe, documented teh design of WEBI Reports and dashboards and teh changes made for future references in teh release notes.
• UAT Support and Solved teh issues in teh new created Universes as well as infoView and WEBI reports.
• Well documented teh design of Universe and detailed classes/objects information wif macro enabled excel, all teh changes made to teh Universe, documented teh design of WEBI Reports and dashboards and teh changes made for future references in teh release notes.

Environment: SAP BOBJ 4.0/3.1, BO XI R3/R2, Universe Designer, WEBI, InfoView, AMS ADVANTAGE, AMS InfoAdvantage, SAP Crystal Reports 2008, Toad, Oracle 10g/11g SQL, Flat Files, Windows.

Confidential, CT

SR. SAP BOBJ DEVELOPER

RESPONSIBILITIES:

• Requirements Gathering and Analysis for reporting efforts. Analyze teh requirements wif teh business users and come up wif teh technical specifications and Functional specification.
• Interacting wif teh business users to finalize teh BRS and get user sign off on it.
• Preparing teh system requirement specification document (SRS) based on BRS and user inputs.
• Developing Business Objects universe based Design documents
• Developing Business Objects reports based on report Design documents
• Exported teh Universe to teh Repository using designer for users to develop their own personal reports.
• Reporting was done against Claims Datamart.
• Played an active role in teh data modeling and Architecting teh new BO environment.
• Designed and implemented teh New Universes and in making relevant changes for existing universes.
• Creation of teh Universe wif Classes, Objects and Condition objects using Designer.
• Resolved universe issues like loops by creating aliases and contexts, traps, joins hierarchy, lov’s, parameters and connection issues.
• Setup teh row level security for better management of users’ data access.
• Worked on Developing Deski and Web Intelligence Reports using features like Drills, filters, Sort, Rank, Sections, Breaks, Alerts, merge Dimensions, Sub Quires and Multiple Data Providers.
• Created teh reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @Functions, Cross Tab and Formulas etc.
• Exported teh Business Objects reports to BO repository to be to be viewed by all users on teh intranet using Web Intelligence.
• Migrated teh Users, Groups, Universes, Personal Folders, Connections, Reports (DeskI & WebI), Excel, pdf and Instances to Production, Development and Test Environments using Import Wizard from BO XIR2 to BO XI R3 Environments.
• Performance tuning of BO reports and universe and maintaining teh universes and reports.
• Support teh development and production environment.
• Business objects universes were modified based on teh modification of oracle database.
• New reports were created based on teh business requirements in Business objects and crystal reports
• Business Views were used in creation of new reports.
• Extensively used SQL and PL/SQL scripts to test teh reports and create teh reports.
• As a Team member was involved in BO XI R2 Migration for Claims Approval Report - (Converting Deski reports to Webi Reports).
• Interact wif teh regional managers to identify teh most important metrics and conduct meetings to define teh philosophy and data flow for teh dashboard.
• Added users, user groups and managed teh access privileges of teh user community using teh CMC module of Business Objects XIR3.
• Created Cardinalities, Contexts, Joins and Aliases for resolving loops and checked teh integrity of teh Universe.
• Involved in Creation of Alerters wif various conditions.
• Created Dashboards using Dashboard Manager.
• Managed business objects servers
• Interact wif teh Business users and gather teh requirements.
• Documentation of requirements and solutions.
• Created crystal reports for teh business users.
• Used Business views to develop Crystal reports
• Test teh created reports and Universe - Test teh reports for source to target data, Test teh reports on DB, and Test teh universe objects for teh quantity and quality of teh data.

Environment: SAP BOBJ 3.1, BO XI R3/R2, Crystal Reports XI R2, XCelsius, HL7, HIPAA, ICD, NCD, CPT, Informatica 9.0/8.1, Toad, Oracle 9i/10g SQL and PL/SQL SAP BW, SQL Server 2008/2005, DB2, Flat Files, Unix, Windows.

Confidential, NY

SR. BO REPORT DEVELOPER

RESPONSIBILITIES:

• Requirements Gathering and Analysis for reporting efforts.
• Interacting wif teh business users to finalize teh BRS and get user sign off on it.
• Preparing teh system requirement specification document (SRS) based on BRS and user inputs.
• Developing Business Objects universe based Design documents
• Designed, Created and maintained teh universes and reports wif advanced formulas, joins and techniques.
• Ongoing maintenance of developed applications, and handling teh change requests to modify existing reports and universes.
• Scheduled teh reports to run daily, weekly and monthly, distributed teh reports to teh users via e-mail.
• Created users and groups and applied row level and objects level securities and object securities.
• Reports, universes, securities and universe restrictions to move from one environment to other.
• Redefined teh Business Objects security on users and groups and teh content.
• Maintained teh Business Objects servers in a highly available clustered environment.
• Developed reports based on Views, Stored Procedures and Commands in Crystal Reports designer.
• Written Stored Procedures, PL/SQL, Triggers and Views, to extract data based on teh Business requirement.
• Experience Creating Several Dashboards / Scorecards using Dashboard Manager and Crystal Xcelsius.
• Extensive experience in developing static and dynamic dashboards using Crystal Xcelsius.
• Published Crystal XCelsius Dashboards using QAAWS and LIVE OFFICE.
• Test teh created reports and Universe

Environment: Business Objects Enterprise XI R2/R3, Crystal Reports 2005, Crystal XCelsius, QAAWS, LIVE OFFICE, Universe Designer, Infoview, Performance Management, Dashboard Manager, Oracle10g, SQL Server 2005, SQL, PL/SQL, Apache Tomcat, TOAD, Windows Server 2003.