PROFESSIONAL SUMMARY:

• Over 7 plus years of professional work experience in Analysis, Design, Development, Testing, Business Intelligence, Data Warehouse /Data Mart design and implementation of client server applications.
• 6 years of strong experience using SAP BI 4.0/Business Objects XIR3/XIR2/6.5 with extensive experience in Universe Designer, Report creation using Desktop Intelligence & Web Intelligence and, Central Management Console, Data Stage.
• Proficient in created reports using SAP Business Objects XIR3/Business Objects XI R2 functionalities such as Queries, Formula, Drilling, Horizontal, Vertical, Form, Cross Tab and Charts.
• Experience in building Universes, retrieving data using Universes, Personal data files, and created reports using the SAP Web Intelligence
• Experience in working with Business Objects Universes & Query development
• Experience in working with creating Data warehouse using Informatica, ETL Functions and related OLAP tools
• Experience in working with Microsoft PowerPoint, Visio, Word, Excel and Outlook, Lotus Notes
• Strong experience with the creation of Universes using the Information Designer Tool R4
• Strong experience publishing and distributing Business Objects reports via the BI Launch Pad R4 (InfoView).
• Knowledge in data warehouse concept and star schema
• Looking for committed, stable employment with a long - term vision.

TECHNICAL SKILLS:

Technology and Tools: SAP Business Intelligence Suite 4.1 SAP Information Design Tool 4.1, Universe Design Tool SAP Web Intelligence Rich Client, SAP Web Intelligence Java Interface SAP BI Launch Pad, Central Management Console, Query as a Web Service Business Objects XIR2, XIR3 Oracle SQL/PLSQL, SQL *Plus, Oracle SQL Developer Toad Data Warehousing

PROFESSIONAL EXPERIENCE:

IT Applications Analyst (BO Developer)

Confidential, NYC, NY

Responsibilities:

• SAP Business Objects XI 4.x - Universe design, Information Design, WebI, Dashboard
• SAP Business Objects BI 4.1 (Information Design Tool 4.1, WEBI Rich Client)
• Supported to EU and executives, production support
• Troubleshoot and resolved various issue
• Installed, Setup, Configured SAP Client tool like SAP BI R4 Information Design Tool.
• Administered Business Objects security, groups, and users under supervision of SAP BI administrator
• Created universes using the Information Designer Tool R4
• Chasm trap, Fan trap, and Loops, resolved joins short cut join, Outer join, Theta Join
• Developed Hierarchies to support drill down reports used @functions like @select, @prompt, @where, @variable, and @Aggregate Aware
• Index Awareness
• Created number of standard reports and queries based on the existing classes/objects
• Produced Reports and exported to Excel based on the user requirements
• Filtering data using subquery, combined query prompt, and Input controls
• Ranking data using database ranking
• Enhancing the presentation of the reports
• Organizing the data with section, breaks and sorts
• Merging the data from dimension using various data source
• Migration from 3.0 to 4.1
• Relational UNV converted to UNX
• OLAP UNV re-created in UNX
• Involved in Upgrading SAP Business Objects Enterprise to SAP BI 4.0
• Migrated Universe/Reports from R3 to SAP BI R4
• Used Upgrade management tool
• Tested all the report after migrating to SAP WEBI using SQL script in TOAD.
• Used Free hand SQL script to run the query
• Created tables, Views, joins and used union, minus, intersect
• Tuned and optimize the query using indexing
• Build the query based on right outer, left outer and full outer join
• Used nested query for complex report
• Optimized and tuned Universes and reports
• Integrated QAAWS with Xcelsius as universe designer data provider
• Published and distributed Business Objects reports via the BI Launch Pad R4 (Former InfoView)

Environment: SAP BI R4, SAP BOXIR3, BI Launch Pad, SAP Webi Rich client xir3, Web Intelligence,, CMC, Oracle 10g, MS Office 2007, Xcelsius 2008, Query as a Web Service, Excel 2007, and Windows 7, TOAD.

Confidential, Stamford, CT

Sr. Business Objects Developer

Responsibilities:

• Design and modified existing Universe.
• Set up Aggregate Awareness and Index awareness for faster performance of the reports.
• Experienced creating reporting universes and data repositories and configuring BO software to meet end user reporting needs
• Created Universe with Classes, Objects and Condition objects
• Developed Hierarchies to support drill down reports
• Full client reporting designs and Development
• Experience with custom prompt development, Filters, Rank, Sorts, Slice and Dice, Crosstab, Charts, Master Detail, Alerter, Drill, hierarchies
• Used different data sources like Personal Data files, stored procedure, freehand SQL and Universe.
• Web Intelligence report Design and Construction from scratch and existing.
• Work with business users, Business analyst, DBA to design Web intelligence reports.
• In depth knowledge of the Business Objects architecture and Web Intelligence reporting
• Work with report structure- Java report panel and Create complex reports and report specifications.
• Used functions formula and functions like Aggregate, date and time, character, Document, Data Provider, logical, Numeric, Miscellaneous.
• Used Query technique like combination Query, Union, Minus, Intersect Query and used In, ForAll, ForEach, Context, Where operators.
• Work with sorts, filters, ranks, Breaks, Alerter, Drilling, create charts, and cross tab reports.
• Create user, groups, folders and setup rights & privileges on it and setup row/object level security.
• Installation of Business objects xir2.
• Migration 6.5 to XIR2
• Migrated more than 150 reports from 6.5 full client and web intelligence reports to XIR2 environment
• Test all the report after migrating to xir2 environment.
• Created views, Synonyms and wrote procedure in Oracle 10g.
• Level 3 production support
• Trained users and mentor juniors and database developer better to interface with business objects suite XIR2
• Used Confidential application IT Governance to create packages and package line to promote/ re-promote the Universes from Dev to UAT and UAT TO PROD

Environment: BOXIR2/6.5, Web Intelligence, Desktop Intelligence, Supervisor/CMC, Oracle 10g, Toad 8.5, Clear case, IT Governance, MS Office 2003, Windows XP.

Confidential, MI

Sr. Business Object XIR2 Developer

Responsibilities:

• Installed and Configured Business Objects XIR2 on Windows
• Strong experience designing hierarchical reports, dashboards and drill-down Cross-Tab reports development and tuning in Oracle
• Created User and Groups and assigned security, settings and rights through CMC
• Created Security approach and design document
• Defined and designing a security design in XIR2.
• Involved in migration of repository to BOXIR2
• Web Intelligence (WEBI) and full client experience
• Central Management Console (CMC).
• Business Objects Enterprise Framework experience.
• Educated and trained users on Business Objects XIR2
• Documented reports & universe specifications and design
• Performance Management and Capacity Planning
• Designed, implemented, distributing, and maintaining universes.
• Tuning universes and reports for better performance
• Create Dashboards, complex reports, and migration strategies.
• Designed Universes, Classes, and Objects using Business Objects Designer, BOXIR2
• Report creation: Calculations, Variables, Drill Downs, and Slice & Dice.
• Defining project scope and pre-sales support
• Designs, develops and implements mappings/transformations based on source-to-target specifications
• Provides design input to the data integration architecture.
• Assists in defining Inoformatica 7.1 ETL development standards and conventions
• Assists in defining metadata that needs to be captured for each transformation process
• Performs monitoring and tuning of Inoformatica 7.1 ETL jobs
• Provides operational support to production Inoformatica 7.1 ETL processes and code on an as-needed basis
• Extracting data for multi-dimensional analysis
• Business Objects XIR2 experience with filters, user objects, variables, and stored procedures
• Experience with Cardinalities, contexts, Joins, and Aliases to resolve loops and verify the integrity of the universes.

Confidential, NJ

Oracle Developer

Responsibilities:

• Perform applications development, programming, and support using Remedy, SQL*Plus, and PL/SQL in relational database environment
• Design processes to enhance Oracle related performance items
• Wrote PL/SQL packages to implement the logic of Bills of Material based on the sales orders and to implement the logic of Production Monitoring based on the inventory control using Dynamic SQL
• Involved in Database design and modified database design to increase performance and usability.
• Developed Stored Procedures implementing the business logic
• Developing, database triggers.
• Migrating and creating new databases.
• Involved in the Database design and maintaining database security, and tuning
• Developed reports using Business object facility

Environment: Oracle8i, Pl/SQL, Erwin 4.5, Toad, Windows NT, UNIX, Shell Scripting.