Professional summary:

• 7+ years of application development experience; strong "hands-on" experience with Business Objects XI, Web Intelligence Crystal XI and Xcelsius in a large environments Experience in designing, building and maintaining Universes.
• Worked on multiple migrations (6.X to XIR2 platform) as well as upgrade (XIR2 to XI 3.1) projects.
• Business Intelligence , design, development and deployment using SAP Business Objects from version 5 to current XI 3.1,XI 3.2.XI 3.4.
• Experience in designing, building and maintaining Universes; resolving issues like loops & traps, designing complex objects using @prompt, @aggregate aware functions.
• Web Intelligence XIR2/XI3.1 report development Specialist
• Experience with data analysis, mapping source and target systems for data migration efforts and resolving issues relating to data migration and data creation.
• Knowledge of implementing Cascading Prompts, custom Hierarchies and filters as well as Broad Knowledge in resolving loops(using aliases, short cut joins, and contexts) and traps(Chasm and Fan traps) while designing universes.
• Proven abilities in creating complex reports by linking data from multiple data providers, using free hand SQL, stored procedures and functionalities like Combined Queries.
• Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
• Always eager to learn new technologies and tools quickly.
• An enthusiastic and project-oriented team player with solid communication and leadership skills and the ability to develop creative solutions for challenging client needs

Technical Skills:

Reporting Tools: Business Objects 5.1+/XIR2 /XI 3.1, Designer, Desktop Intelligence / Web
Intelligence, InfoView, Import Wizard, CMC, Crystal Report, Xcelsius 2008.
Operating Systems: Windows XP/2000/2003/NT, Server, Vista, UNIX.
Databases: Oracle 8/9/10,11, MS SQL Server 2000/2005, Sybase, Teradata, MS Access
Programming Languages: SQL, PL/SQL, HTML

Education:

Bachelor of Computer Science and Information System.
SAP BusinessObjects Certified Professional.

Experience:

Confidential
Tampa, FL
Business Objects Consultant
January 2011– Present

• Publish universes to the repository and made them available to the appropriate user groups.
• Published reports and schedule them to different user groups.
• Created and modified the existing Universes by adding new classes/objects, prompts, hierarchies based on the business requirement.
• Used the Aggregate Awareness feature of Business Objects for the Optimization and Performance tuning of Universes.
• Developed and maintained standard and ad hoc reports based on business and technical requirements.
• Gathered requirements from users to plan full system deployment including cluster design and software analysis.
• Designed, developed, tested and successfully delivered 18 reports previously developed in Actuate e.Report Designer Professional to SAP BO XI 3.1 Web Intelligence documents
• Worked on migrating existing reporting applications from XIR1 to XIR2 and also migrating universes from test to production environment.
• Used Designer to build universes and detected problems such as traps and loops in universes and resolved problems like aliases, contexts.
• Provided Dynamic date’s solution to end users for month to date report, year to date report, prior six years report, and prior six weeks reports.
• Developed custom hierarchies to support drill down reports and created derived tables for better performance of the universe.
• In Central Management Console, created folders, users, groups, granted permissions and handling versatile business security according to company requirements and worked extensively on Servers and Server Groups.
• Trained end users in developing ad hoc reports through Web Intelligence.
• Work on migrating existing reporting applications from XIR2 to XIR3.1..

Environment:
BusinessObjects XIR2 (Reporter, Designer), BusinessObjects XI 3.1, MS Excel, Window XP InfoView,CMC, CCM, Web Intelligence , Xcelsius2008, MS Server 2005, Teradata.

Confidential
Minneapolis, MN
Business Objects Developer
February 2010– January 2011

• Designed and developed executive dashboards using Crystal Xcelsius using LiveOffice as connectivity tier with Web Intelligence reports as the source.
• Updated existing universes in XIR2 with additional objects according to user requirements.
• Monitored, tracked reports progress against project plan.
• Assessed and analyzed mid to complex level SQL from existing Actuate reports to evaluate the necessary report parameters, columns, prompts and filters for successful report conversioAddressed system-specific issues, and evaluated alternate approaches and new additional requirements
• Created Aliases and Contexts for resolving Loops and checked the Integrity of the Universe.
• Consolidated canned reports from different data sources that included Excel, Oracle and Access.
• Involved in documenting alternate approaches for data consolidation for different business units.
• Created Aliases and Contexts for resolving Loops and checked the Integrity of the Universe.
• Performed UAT of Web Intelligence reports in development

Environment:
Oracle 10g, BusinessObjects XIR2 in production and Business Objects XI 3.0 in development, InfoView, Window XP.

Confidential
New York, NY
BusinessObjects Developer
February 2009 – February 2010

• Created, modified and enhanced Universes using BusinessObjects Designer for every user requirements including specific dimensions and measures.
• Always checked cardinalities and integrity of the Universe and corrected any logical or SQL problems.
• Created Universes for various functional areas of high level reports group.
• Created Contexts and Aliases to resolve chasm and fan traps in Universes.
• Customized LOVs in Universes for quicker performance of reports.
• Created Joins, Contexts, and Aliases for resolving Loops and Universe Tuning and checked the Integrity of the Universes.
• Used SQL against the database to check data retrieved.
• Created the joins strategies while designing the universes.
• Changed the universe parameter settings to optimize the performance of universe.
• Created different universes which contains the information about the customer like,cust_name,address,ph_no,plan_used,mins_used,mins_remaining,rollover mins.
• Created derived tables to avoid loops and traps of universes and worked on breaks, ranks, alerter and drill filters.
• Designed and developed executive dashboards using Crystal Xcelsius using LiveOffice as connectivity tier with Web Intelligence reports as the source.
• Updated existing universes in XIR2 with additional objects according to user requirements.
• Monitored, tracked reports progress against project plan.
• Worked with business users to identify additional report requirements and document client requirements.
• Created universes and reports in Business Objects XIR2 and XIR3.
• Created multi master detail reports in Business Objects and adhoc reports in thin client Infoview.

Environment:
BusinessObjects XIR2/XIR3 (Reporter, Designer, Supervisor), Infoview, MS Excel, Windows 2000 Professional, UNIX, Web Intelligence XIR2, Oracle 10, SQL Server for CMC.

Confidential
Jacksonville, Florida
BusinessObjects Consultant
January 2007 - January 2009

• Managed three different projects for a wide range of users – developed project plans, deliverables and guidelines.
• Designed and created BusinessObjects Universes, Classes and Objects for management systems and worked on gathering requirements from Business users.
• Worked on gathering business requirements interacting with the business analyst team.
• Worked on Updating existing universes in 6.5 to XIR2 with additional end user requirements.
• Managed migration of objects from development to test to production using import wizard.
• Performed Documentation, report development; actual vs. forecast vs. budget reporting.
• Created different reports containing charts showing revenue and operating income by different divisions, market share of newspaper by circulation.
• Created complicated reports including sub-reports, graphical reports, formula base and well-formatted reports according user requirements.
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
• Provided knowledge transfer for cross-functional team in India when the project was outsourced.
• Developed and deployed complex canned reports.
• Created templates for standardizing the structure of corporate documents.

Environment:
Oracle 10g, BusinessObjects XIR2 in production and Business Objects XI 3.0 in development, InfoView, Window XP.

Confidential
Uniondale, NY
BusinessObjects Administrator / Developer
March 2006- December 2006

• Created WEBI/DESKI reports involving complex queries, sub queries, Unions and Intersection.
• Used Designer Module to design universes, joining the tables, creating prompts and queries and applied contexts and aliases to remove loops.
• Sole BusinessObjects expert for the entire corporation of 100+ users. Involved all faces of BusinessObjects; administration, design, development and deployment.
• Utilized BO for reporting and analysis of data.
• Assessed and analyzed mid to complex level SQL from existing Actuate reports to evaluate the necessary report parameters, columns, prompts and filters for successful report conversion
• Addressed system-specific issues, and evaluated alternate approaches and new additional requirements
• Created Aliases and Contexts for resolving Loops and checked the Integrity of the Universe.
• Performed UAT of Web Intelligence reports in development
• Trained Power Users/Managers to create reports in WebI

Environment:
MS PowerPoint, MS Access, SQL, Business Objects XIR2, Info View, Web Intelligence 6.1.3, MS SQL Server2008, UNIX , Teradata.

Confidential
Bethpage, NY
BusinessObjects Developer & Administrator
April 2005- February 2006

• Part of team tasked with migrating existing reporting applications from 6.5 to XIR1 and XIR2.
• To enhance the report performance worked with @functions (@aggregate_aware, @select, @prompt, @where.
• Coordinated with developers and business users in formulating report requirements.
• Involved in creating User Training Manual for training end users in reporting functionality and performed end user training through online and in-class sessions
• Involved in design/approach, project team calls and meetings
• Addressed system-specific issues, and evaluated alternate approaches and new additional requirements
• Created universes and reports in BusinessObjects 6.5
• Reviewed data mapping of BusinessObjects Universes from BO 6.5 to XIR2
• Created multi master detail reports in Business Objects and ad-hoc reports in thin client Infoview
• Designed and developed Web Intelligence interface according to the Client requirements
• Revamped an entire suite of 15 hyperlinked Web Intelligence reports into a set of 4 reports using BusinessObjects innate cube and object drill down functionality to replace hyper linking
• Conducted reporting sessions and presentations for business users
• Updated existing universes in XIR2 with additional objects according to user requirements
• Developed high end interactive Web Intelligence reports from scratch with cascading prompts, drillable hierarchy levels, custom date time prompts, report level variables and filters and multiple openDocument hyperlinks
• Consolidated canned reports from different data sources that included Excel, Oracle and Access.
• Involved in documenting alternate approaches for data consolidation for different business units.

Environment:
MS Project, MS Access, MS Excel, Windows XP, UNIX, Web Intelligence 6.1.3, Oracle 9i, Teradata, Share Point, MS PowerPoint, SQL, Business Objects XIR2, InfoView.

Confidential
New York, NY
Sr. Business Intelligence Consultant
December 2004 - March 2005

• Involved in gathering project level requirements, design/approach, calls and meetings.
• Major efforts involved migrating from existing 6.5 system to XIR2; trained users and prepared documentation.
• Performed requirements gathering for new reports to be created using Web Intelligence.
• Addressed system-specific issues, and evaluated alternate approaches and new additional requirements.
• Created Aliases and Contexts for resolving Loops and checked the Universe Integrity.
• Performed data mapping of Business Objects Universes in XIR1 and XIR2.
• Developed and deployed Complex reports in full client and thin client.
• Responsible for design, development and administration of Universe structure. Added 60+ aggregate tables in the Universe along with setting up contexts, object incompatibilities and created two dozen measure objects with @Aggreagate_Aware functionality
• Converted all Desktop Intelligence reports to Web Intelligence and resolve issues, where this conversion caused errors, reports were recreated using Web Intelligence.
• Developed reporting requirement specification document from legacy Mainframes.
• Performed UAT of Web Intelligence reports in development.
• Performed analysis on accounting related activities that included disbursements, receipts, fair value accounting, government claims and loans.

Environment:
MS Project, MS Access, MS Excel, Windows 2000 Professional, UNIX, Web Intelligence 6.1.3, PowerBuilder, Share Point, MS PowerPoint, SQL Server 2000.

References: Available on request