We provide IT Staff Augmentation Services!

Business Objects Lead/admin Resume

CA

SUMMARY

  • SAP Business Intelligence Consultant with over 4 years of experiences in various technologies relating to Business Intelligence.
  • Experienced working on multiple versions of SAP Business Objects i.e XIR 3.1, and XIR 4.0.
  • Worked in top media and health care industries with vast knowledge of business models and data flow .
  • Hands on experience with development of multiple reports in Web Intelligence, Desktop Intelligence, Xcelsius (Dashboards) and Crystal Reports.
  • Administered Business Objects XIR 3.1 and XIR 4.0 environments.
  • Proficiency in SQL language utilized for development of reports and universes.
  • Strong knowledge of Data Modeling Concepts, snow flake schemas, multi star schemas, extended star schemas etc.
  • Experienced in customer interactions for requirement gathering, working closely with clients and gathering business level information to be utilized to create universes, reports for ad - hoc and canned reporting usage.
  • Worked closely in creating test cases, performing UAT and testing reports and universes to ensure quality delivery.
  • Assisted in creating ETL Jobs for Informatica and Data Stage tools to capture ideal data for reporting and archiving purposes.
  • Worked on multiple database systems including Oracle, Teradata, MS SQL Server, IBM Db2.
  • Being a key project player, observed multiple full Life Cycle for projects, which included Requirement Analysis, Planning, Designing, Development, Test and Roll-Out / Go Live.
  • Good analytical and documentation skills with ability to communicate at all levels.
  • Managed onsite and offshore teams for Production Support activities as well as for development projects.
  • Proactive person with good teamwork and collaboration capabilities, with strong interpersonal skills to ensure maximum performance and maintaining a good work environment.

TECHNICAL SKILLS

Operating Systems: Windows Server 2003/2005/2008 , Red Hat Linux, Unix (AIX)

Business Intelligence Tools: SAP BO XIR 3.1, 4.0, Crystal Reports, Xcelcius

Database Systems: SQL Server 2000/2005/2008 , Oracle 9i/10g/11g, DB2 9.7/9.8, MS-Access

Languages: SQL, PL/SQL, T-SQL, C++

ETL Tools: IBM DataStage, InformaticaOther Tools: HPSM, QC, Remedy, Lotus Notes, Ms-Office Package, Outlook, Visio, Toad, SQL Developer, Sql Assistant, Service Now

PROFESSIONAL EXPERIENCE

Confidential, CA

Business Objects Lead/Admin

Responsibilities:

  • Involved in gathering, analyzing and documenting business requirements, functional requirements and data specifications for business object universes and reports.
  • Lead Offshore and Onsite teams for coordinated development and Production Support activities.
  • Managed User level securities across all three environments, Development, QA (Quality Assurance) and Production.
  • Managed Folder structures for Report level and Universe Level within Business Objects.
  • Managed multiple access levels on all environments.
  • Worked with LCM (life cycle manager) and Import wizard for migration of content between environments.
  • Utilized Import wizard for taking weekly BIAR backups for all Reports and Universes.
  • Worked extensively to ensure proper scheduling times for all reports, Including but not limited to reports sent to user inbox, and emails.
  • Worked with Publication for Webi Reports.
  • Managed Application level access, Connections and Events for Production server.
  • Involved in troubleshooting for developers in case of report level / SQL code level issues.
  • Leveraged multiple teams to co-ordinate efforts ensuring maximum uptime.
  • Involved in Data-Analysis, Data-Digging for resolving / answering data level issues to the end-clients.
  • Worked closely with BI Architects to in corporate server level changes.
  • Involved in Testing SAP BI 4.0 Upgrade, Testing client end tools, including Launch Pad, IDT, Designer and Xcelsius 2011.

Environment: Business Objects 4.0, XIR 3.1 with Infoview, Oracle 11g, Teradata 12, MS-SQL Server, MS-Office 2010, Windows 7 .

Confidential, NY

Business Objects Consultant

Responsibilities:

  • Involved in multiple sessions with Business Users to understand and capture Business Level requirements for reporting needs.
  • Collaborated with Business Analyst, Data Modelers, DBAs to ensure data flow and match requirements for reporting needs.
  • Created several Webi reports, Deski reports and Dashboard reports for graphical presentation.
  • Coordinated L1, L2 and L3 support team members.
  • Analyzed user requirements. Find solutions to technical issues; extend technical assistance.
  • Improved support process and procedures.
  • Optimized and enhanced some of the existing reports to reduce processing time.
  • Developed reports using filters, prompts, sorts, groups, subtotals, free hand SQL and multiple data providers.
  • Worked extensively with (@select, @aggregate aware, @where, and @prompt) to overcome the problems with database when integrating with Business Objects
  • Creating aliases, contexts and short cuts joins by resolving loops, cardinalities and integrity checks of the universe.
  • Set up Aggregate Awareness to enhance the performance of SQL transactions.
  • Tuned the reports for better performance using SQL.
  • Conducted Business Objects and Web Intelligence training session to train the users.
  • Elaborated Service Level Agreements among support team leaders.

Environment: Business Objects XIR3.1, Oracle 9i, Teradata 11, IBM DB2, MS-Windows XP, Remedy, Ms-Office 2007.

Hire Now