SUMMARY

• Over Seven years of Experience in Information Technology, implementing Information Systems utilizing Client/Server, Experience in Application Analysis, Design, Development, Testing and Implementation.
• Experience in Business Objects SAP BI4.0/XIR3.1/XIR3.0/XIR2 (CMC, Designer, Desk I, Supervisor, Reporter), InfoView, Rich Client, Web Intelligence, ZABO, Broadcast Agent 6.x/2.x, Schedule Manager, Broadcast Agent Publisher, Auditor, BO Application Foundation & Performance Manager.
• Expertise in universe designing/developing and generate reports with complex, business views, list of values (LOV).
• Experience in Installation, Configuration, Administration and Migration of BO BI 4.0/XI R3.1 and previous versions.
• Experience in Creating and Maintaining various complex Ad - hoc reports using Web I and Desk I/ Business Objects.
• Expertise in Dashboards to monitor business performance, insightful analytics, role based dashboards using Performance Manager and Application Foundation.
• Expertise in working with Xcelsius 2008/4.5 and Query as Web Services.
• Expertise working with BO Data Integrator Designer, creating DI Workflows and Jobs and executing them in Development & Test Environments.
• Extensive experience & solid understanding of Data Warehousing, Data Marts, Star Schema, Snow Flake, OLAP, Fact, Dimension table and Dimension table modeling.
• Efficient in Optimizing, Debugging, Testing SQL queries, views, stored procedures written in various Databases.
• Expertise in databases like Oracle, SQL Server, Teradata and MS Access.
• Experience in Rational Unified Process (RUP), Requisite Pro, Rational Rose.
• Created WEBI reports and Crystal reports and deployed them through info view with BW universe as source and created Inventory accuracy dash boards using Xcelsius.
• Experience in Interacting with Business Users to analyze business process and transforming requirements into screens, designing database, documenting & rolling out the deliverables and training them on various Business Objects components.
• A well-organized, goal-oriented, highly-motivated effective team member with excellent analytical, troubleshooting, and problem solving Skills.
• Excellent analytical, Interpersonal and Communication skills, fast learner, hardworking and good team player.

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i/8i, SQL Server 2005/2000, MS Access, Teradata

OLAP Tools: Business Objects BI 4.0/XIR3.1/XIR3.0 (CMC, CMS, CCM, Designer, Deski, Webi, Infoview, Import Wizard, Report Conversion Tool, Performance Manager, Query as Web Services, BI Services), ZABO, Application Foundation, Xcelsius 2008/4.5, Live office, Crystal Reports XI/11, 2008

ETL tools: SAP BI 7.0, BW 3.5

Documentation: MS Access, Quick Test Pro

Reporting: SAP BI BO 4.0,XI 3.1,XI 3.0,Xcelsius

Query Languages: T-SQL, PL/SQL, Oracle Forms 4.5/6i

Operating Systems: Windows 7/Vista/XP/2008 server/2003 server/2000 server

Web Technologies: HTML/CSS/XML

PROFESSIONAL EXPERIENCE

Confidential, Elkton, MD

Business Objects Consultant

Responsibilities:

• Gathered requirements from users for operational reports
• Provided Universe and Reports mockups for the better understanding of outputs to the users as per the requirements
• Hands on building logic for Oracle Views as per the requirement as sources to the universe.
• Conducted meeting on weekly basis with the users for better understanding of requirements and the development process
• Created several universes for various functional units (Finance, Sales and Logistics)
• Created Classes, Objects, Joins and Complex Conditions for each universe with specific naming conventions for each Functional Unit.
• Tuned universes to improve the performance by using aggregates
• Developed reports using combined queries, sub queries, optional prompts, delegated search, drill filters, ranking, dynamic calculations, hyperlink to link the reports and merge dimensions
• Created several Documents with multiple complex reports
• Improved the performance of reports by adding variables
• Converted all Desk I Reports to Web I Reports using Report Conversion Tool for Web I users
• Developed test cases and performed UAT as per the specifications
• Involved in moving universes and documents across DEV/VAL/PROD repositories using Import Wizard
• Automated document Scheduling, Publishing & Distribution for Web I & Info view clients
• Resolved issues(tickets) raised by users and supported them on timely basis
• Conducted User Training for all the users to help them understand the Business Objects interface, functionalities and report layouts.
• Provided high level documentation on each universe and report along with the functionalities

Environment: Business Objects SAP BI 4.0/XIR3.1(CMC, Designer, Desk I, Web I, Rich Client), Import Wizard, Report Conversion Tool, Schedule Manager, Info View, Auditor, Oracle 11g, Oracle EBS 12.1, SQL Server 2008, SQL, Windows 2003 server/XP.

Confidential, Wilmington, DE

Business Objects Consultant

Responsibilities:

• Interacted with Business Analysts and Business Users to understand, gather requirements.
• Analyzed functional and technical requirements and prepared deliverables including Software Requirement Specifications, User Interface Specifications, screen mock-ups, report mockups.
• Created different groups and allotted users with rights for Dev/Val/Prod environments in CMC.
• Designed and created fact table along with few dimension tables in database.
• Designed and developed multiple Universes applied various securities for restricting the data.
• Expanded the existing universe by adding Fact and Dimension Tables as per the requirement.
• Created complicated classes, objects, joins, conditions (using @select, @where, @prompt) & resolved loops using Contexts to remove cyclic dependencies on tables.
• Generated Cascading LOV’s as per the user requirement at universe level.
• Involved in complete Testing, Maintaining and Updating the universes.
• Created simple & complex reports using Dynamic Calculations, Hierarchies, list of values (LOVS), local Variables, Functions, Alerts, Ranking, Merge Dimensions and Drill Filters.
• Linked multiple Web I reports using Open Docs/Hyperlink.
• Created Optional Prompts and used Data Tracking to track updated data in Web Rich Client reports.
• Generated few MCRT reports using Crystal Reports for specific users.
• Created few Dashboards using Xcelsius to show responses of various costumers for all the campaigns conducted per year.
• Prepared SQL queries to test reports (Integration testing) & developed test cases to test the reports at high end in testing environment & tested reports accordingly.
• Automated document Scheduling, Publishing & Distribution for Web I & Info view clients, using Scheduler.
• Conducted User Training Sessions for Business Objects tool usage by preparing power points and provided detailed documentation for universe and reports.

Environment: Business Objects XIR3.1(CMC, Designer, Desk I, Web I, Rich Client), Import Wizard, Report Conversion Tool, Schedule Manager, Info View, Live Office, Auditor, SDK, Crystal Reports XI, Xcelsius 2008, Oracle 10g, SQL Server 2008, SQL, Windows 2003 server/XP.

Confidential, Bentonville, AR

Business Objects Consultant

Responsibilities:

• Interacted with business analysts & usage analysts to develop standard & ad-hoc reports according to functional specifications.
• Performed an Initial Study of current reporting application, to finalize data elements required for reporting.
• Updated existing Workforce Universe by adding new Tables, Classes, Objects, Conditions & prompts for new reporting requirements.
• Resolved Fan Traps & Chasm Traps in universe used @Functions like @Select, @Where @Prompt, @Aggregate to increase the performance of reports generation.
• Generated complex Ad-Hoc reports using multiple data providers like Universes, Free hand SQL, Stored Procedures, Personal Data Files, XML and Web Connect.
• Generated Audit Reports using Activity Universe for auditing which includes tracking the No. of users for individual report, long run reports to analyze performance etc.
• Tested all reports with different scenarios like query balancing, look and feel & formatting of the reports based on specifications.
• Used Schedule Manager for auto scheduling of Business Objects documents to perform tasks like refresh, print and save.
• Performed unit testing, system testing and user acceptances test (UAT) for universe & reports.
• Resolved various types of tickets & provided support.

Environment: Business Objects XIR2/6.5 (CMC, Designer, Desktop I, Web I), Info View, Schedule Manager, Auditor, ZABO, Crystal Reports XI, Oracle 10g/9i, SQL Server 2000, SQL, MS Office (Word, PPT, Excel, Access, MS Project etc..), Windows NT/2003 Server.

Confidential, Houston, TX

Business Objects Consultant

Responsibilities:

• Interacted with Business Analysts & Business Users to understand, gather & document requirements according to functional specifications
• Designed & developed Universes for multiple Databases & applied various securities for restricting the data
• Involved in complete Testing, Maintaining and Updating the universes
• Created templates to customize style & structure of the canned reports to maintain company standards
• Tuned up queries to improve Performance of the existing reports for various functional areas
• Prepared SQL queries to test reports (Integration testing) & developed test cases to test the reports at high end in testing environment & tested reports accordingly
• Automated document Scheduling, Publishing & Distribution for Web I & Info view clients, using Scheduler

Environment: Business Objects XIR3/XIR2(CMC, Designer, Desk I, Web I, Rich Client), Import Wizard, Report Conversion Tool, Schedule Manager, Info View, Auditor, Crystal Reports XI, Oracle 10g, SQL Server 2008, Teradata V2R12, SQL, PL/SQL, MS Office 2007 (Word, PPT, Excel, Access, MS Project etc..), APO(Tomcat-Apache), Windows 2003 server/XP.