We provide IT Staff Augmentation Services!

Senior Business Objects Developer Resume

Cincinnati, OH

SUMMARY:

  • 9 Years of data warehousing experience as a Business Intelligence Consultant primarily using SAP Business Objects, Information Design Tool, Universe Designer, Web Intelligence with expert level skills in Data Visualization, Data Analysis, Business Intelligence, ETL, Client/Server Systems, full life cycle implementations.
  • Experience in full software development life cycle implementations as a BI Consultant using SAP BO Business Intelligence 4.1/4.0, Business Objects XIR3/XIR2/XIR1, Crystal Reports and Xcelsius.
  • Expertise in connecting to Oracle 11g/10g, Teradata, SQLServer 2012/2010/2008/2005, IBM DB2, and MySQL as data sources using SAP Business Objects.
  • Excellent experience in Information Design Tool, Universe Design Tool, Web Intelligence, BI Launchpad, Import Wizard, Info View, Universe Designer, Central Management Console, QAAWS, Live Office.
  • Strong Experience in creating Universes from scratch for Adhoc reporting and canned reporting.
  • Experience in creating folder structures, setting up users/user groups in Central Management Console.
  • Experience in installation and configuring Business Objects, creation of repositories and security domain with user groups and security implementation.
  • Implemented Row Level Security, Folder Level security, Index Awareness, Hierarchies in Universes.
  • Expertise integrating Web Intelligence reports in web portals using opendoc for highly interactive reports.
  • Migrated reporting applications from Business Objects to Cognos and from Business Objects R3 to Version 4.1.
  • Mentored teams of onsite and offshore resources in best coding practices, technologies at various clients.
  • Performance tuned Universes & Web Intelligence reports to reduce the run time of reporting applications.
  • Strong ability to partner and work collaboratively with BA(s), Architects and ETL developers.
  • Efficient in all phases of the software development lifecycle (SDLC), coherent with Data Cleansing, Data Conversion, Performance Tuning, Unit Testing, System Testing, User Acceptance Testing (UAT).
  • Experience in analyzing Star Schema/Snowflake Schema, Dimensional Data Modeling, Logical and Physical Data Modeling using Toad Data Modeler, SQL Developer.
  • Strong knowledge and hands - on experience in Data Vault.
  • Experience in performance tuning SQL queries and ETL process.
  • Excellent Knowledge in Ralph Kimball & Bill Inmon Methodologies for designing data warehouse.
  • Knowledge in implementation of OLTP, OLAP systems and Data Marts.
  • Diversified experience using Business Objects reporting in Financial, Healthcare and Pharmaceuticals sectors.
  • Knowledge on Extraction, Transformation and Loading (ETL) using IBM InfoSphere Information Server 9.1/8.5/8.1, IBM InfoSphere Change Data Capture 10.2/6.5.

TECHNICAL SKILLS:

Databases: Oracle 11g/10g, Teradata, SQLServer 2012/2010/2008/2005, IBM DB2, MySQL

Reporting Tools: SAP BusinessObjects Business Intelligence 4.1/4.0, Business Objects XIR3/XIR2/XIR1, Information Design tool, Universe Design Tool, Web Intelligence, BI Launchpad, Crystal Reports, Xcelsius, Central Management Console, Tableau Desktop, Tableau Server, Cognos Report Studio

ETL Tools: IBM Information Server Suite 9.1/8.5/8.0, IBM InfoSphere Change Data Capture 10.2/6.5

Programming Languages: PL/SQL, T-SQL, Shell Scripting, C/C++

Operating Systems: Windows 7/XP, Linux, Unix, AIX 5.2/4.3, Mac

Data Modeling: Star Schema, Snow-Flake Schema, Dimensions & Fact Tables, Physical and Logical Data Modeling, SAP Power Designer, Erwin

Scheduling Tools: Tivoli, Autosys, ASG-Zena

PROFESSIONAL EXPERIENCE:

Confidential, Cincinnati, OH

Senior Business Objects Developer

Responsibilities:

  • Integrated crystal reports and Webi reports in online portal of Confidential .
  • Worked on Account Management, Integrated Payments and Payment reports
  • Developed several complex solutions and reports using Web Intelligence, Crystal Reports, Explorer, Dashboards, and Universes.
  • Worked on Database Expert, Section Expert, and Select Expert to develop the reports and used the Sub reports and used various customized formulae to create critical reports using Crystal Reports.
  • Prepared Functional Design Specification documents for the newly built crystal reports.
  • Worked on the enhancements in the crystal reports as per user needs and business requirements.
  • Designed Universes using Information Design Tool to support adhoc reporting.
  • Worked on resolving Fan Traps and Chasm Traps in the Universe.
  • Worked on Webi reports with multiple data providers.

Environment: BI Launch pad 4.1, Information Design Tool, Business Objects 4.1, Web Intelligence Rich Client, Crystal Reports 2013, Tableau Desktop, IBM Information Server 9.1/8.5, IBM Change Data Capture 10.2/6.5, Unix- AIX, Oracle 11g, DB2, SQL Server 2012/2008, IBM DataStudio, Toad for Oracle, SQL Developer, Tivoli

Confidential, Northbrook, IL

Senior Business Objects Lead

Responsibilities:

  • Collected Requirements from the business for Special Projects and managing them thru development, delivery and support.
  • Worked on creating Universes for Sales, Quotes & financials functional areas for Agent Side reporting.
  • Worked on Onsite-Offshore Model. Lead of a team, which comprises of 3 onsite and 5 offshore resources.
  • Worked on designing Proof of Concepts for business before the actual implementation of a requirement.
  • Developed several complex solutions and reports using Web Intelligence, Crystal Reports, Explorer, Dashboards, and Universes.
  • Worked on creating technical design documents.
  • Designed User Security for DASH Reporting Application.
  • Designed Data Security & Business security profiles for restricting access.
  • Performance tuned Business Objects universe for faster report turnaround time.
  • Ensure discussions and decisions lead toward closure.
  • Conducted code reviews and made sure quality solutions are built and best Practices/standards have been followed.
  • Created index awareness to improve the performance of the Universe.
  • Researched and evaluated alternative solutions and made recommendations.
  • Participated in design reviews and provided alternatives.

Environment: BI Launch pad 4.1, Information Design Tool, Business Objects 4.1, Web Intelligence Rich Client, Crystal Reports 2011, Oracle 11g

Confidential, Phoenix, AZ

Senior Business Objects Developer

Responsibilities:

  • Worked on enhancing and maintaining One Schwab Information Universe based on work requests created by the business community at Schwab.
  • Used linked Universes to give users a rich experience by creating a single universe for all the information needs.
  • Created objects using different Business Objects functionalities like @ prompt, @select, @where, @Aggregate Aware.
  • Resolved issues in the design of the Universe and worked on debugging and fixing any Web intelligence report issues.
  • Created Cascading List of Values and custom List of Values as per the user requirements.
  • Used Aliases and Contexts to resolve loops in the Universe design.
  • Used Derived tables to create custom SQL views according to the user requirements.
  • Executed unit and integrated system testing on design changes to ensure accuracy by creating test cases and carrying out peer review.
  • Effectively communicated with team members to exchange information and ideas.
  • Assisted in Maintaining Business Intelligence Best practices document at Confidential .

Environment: BI Launch pad 4.0, Information Design Tool, Business Objects 4.0/XI 3.4/3.1, Explorer, Designer XI, Web Intelligence XI, Desktop Intelligence, Crystal Reports, Teradata 13.11/13.10, Oracle 11g / 10g, Power Designer

Confidential, Auburn Hills, MI

Senior Business Objects Developer/ Analyst

Responsibilities:

  • Maintained and enhanced all Business Objects Universes and optimized them for reporting efficiency.
  • Assisted in the design of dimensional schemas to optimally capture data to support user analysis and reporting needs.
  • Analyzed user needs and created cardinalities, contexts, joins and aliases in the Universe accordingly.
  • Worked with business users and Data Architects to define all the dimensions and measures required for reporting.
  • Maintained the reporting environment, including scheduling, distribution, user permissions, and updating reports.
  • Interacted with all departments to define metrics and deliver canned reports to speed their decision-making.
  • Worked extensively with the major functionalities of BO like Breaks, Sections, Group values, Sorts, List of values (LOV), Pre-defined conditions, Calculations and Ranking.
  • Actively engaged with end users through training and support of Business Objects.
  • Prepared system documentation and metadata, as needed in compliance with project development lifecycle and internal data management standards.

Environment: Business Objects XI 3.4/3.1, Designer XI, Web Intelligence XI, Desktop Intelligence, Crystal Reports XI, SQL Server 2008/2005, DB2, Power Designer, Qlikview 11.0, Cognos

Hire Now