SUMMARY:

• SAP BI/BO consultant with 5 years of experience in Information Technology with expertise in Business Objects, SAP BW, Business Intelligence, server management seeking employment.
• Worked with Directors, Managers, Leads and Business users to gather reporting requirements, involved and implemented feasible SAP Business Intelligence, Business Objects solutions in order to meet business challenges.
• Extensive knowledge of SAP Business Intelligence using SAP Business Objects4.0,XI - R3.1/R2/6.x with Info view, Web Intelligence, Data Integrator & Quality, Webi Rich Client, Desktop Intelligence, Crystal Reports 9/10/XI/2008, Xcelsius 4.5/2008, Central Management Console (CMC), Central Management Server (CMS), and Central Configuration Management (CCM).
• Expertise in designing Business Objects universes and complex BO reports using Universe Designer and, both full client and Web Intelligence Reports respectively.
• Good Experience and analytical skills in reporting requirements into drill-down/drill-across universe support, and review designs with business users.
• Excellent skills in analysis and business requirements gathering from end users to the client and experience in documentation of developed applications.
• Experience working on Business Objects Architecture & Administration. Created Users and Groups and setting the rights on them using Central Management Console (CMC). Scheduled Crystal Reports in CMC on Daily, Monthly, Weekly basis. Debugging the Problems in the Crystal Reports.
• Excellent communication, interpersonal, training, analytical and technical skills.

PROFESSIONAL EXPERIENCE:

SAP BI/BO Consultant

Confidential, St. Louis, MO

• Managed entire project lifecycle - worked with customer SMEs to get an understanding of the source systems, requirements gathering through implementation including - preparing the functional, scope, mapping documents and high level and low level design specification documents
• Designed and linked universes to share common objects, created various classes and objects using Universe Designer, Involved in joining the tables using appropriate cardinalities and created aliases and contexts to resolve the loops in the schema, Implemented Security Features of Business Objects 4.1 like report level, row level, and object level to make the data secure
• Created complex reports (with multiple queries including complex free hand SQLs with analytic functions, set operators such as Union, Intersect, Minus), hyper linked reports, aggregates requiring complex design approaches such as synchronized dimensions and joined tables, drill features etc. across the enterprise
• Established Business Objects best practices in the areas of Universe design (IDT), Report development and Business Objects Administration, Migration techniques
• Created Web Intelligence Reports for multi-dimensional analysis demanding complex data presentation patterns displaying summarized, detail data such as Master/Detail, crosstab reports with extensive use of sections, alerts, ranks, variables, Formulae, etc
• Created complex reports involving Master/detail and Cross-tab and Combined Queries and Sub-queries
• Created Web Intelligence Reports and used Events for scheduling the reports
• Created new Business Objects users and User Groups using Business Objects CMC Module and assigned privileges, and Set up LDAP, SSO authentication for Business Objects users
• Used Business Objects LCM application (Life Cycle Manager) to promote Universes, Reports, data connections and other objects between Business Objects environments
• Defined templates for the Standard and ad-hoc reporting with standard formatting and required logos
• Performance tuning of complex business objects reports and developed Test Scripts and Test Cases to bring down the refresh/retrieval times
• Involved in Performance Testing of all the reports, which helped in analyzing its performance before moving into production
• Developed visualization dashboards using SAP Lumira for the Business Users
• Trained end-users (non-technical) in creating ad-hoc Webi Reports against the Universe and documenting the procedures
• Implemented projects using agile and waterfall methodologies

SAP BI/BO Consultant

Confidential, Sparks, MD

• Worked with business users in collecting project specifications by conducting user requirement gathering sessions, follow up meetings and workshops
• Developed reports for managers to existing reporting requirements, developed the KPI reports for Agent’s performance, at region, territory and channel level
• Developed Dashboards and Scorecards for data management, data quality reports for decision making ability and analyzing data.
• Worked on Designing and Building of Universes, creation of Classes and Objects using Universe Design Tool. Used the Information Design Tool (IDT) to create Universe by creating Connection, Data Foundation and Business Layer
• Created new Universes and fine-tuned existing ones by resolving join problems, setting up aggregate awarenessand, defining hierarchies
• Created Joins and resolved loops by creating Aliases and Context
• Used Filters, Prompts, Alerts, Cross-tabs, Charts, Demographic Charts, multiple parameters, flash objects
• Worked on Setting up hierarchies in the Universe for providing drill down options in the reporting environment
• Built Cross-tab reports, Standard reports, Drill-Down Reports using filters, alerter, parameters using Crystal Reports
• Created List reports, cross tab, KPI reports and drill through reports, What If Analysis, complex Reports, ad-hoc reports, Running Totals, Trends using Tabular Joins, SQL and Integrated with Web applications
• Created Reports using Desktop Intelligence, Web Intelligence Reporting and Xcelsius dashboard design
• Made Reports user friendly by implementing user prompts, alerters, conditions and filters
• Created Web Intelligence reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, Cross Tab, Master/Detail and Formulas
• Created User Prompts, Conditions and Filters to improve the report generation
• Tuned SQL to improve the performance of the reports
• Provided training to business users about Business Objects reports.