We provide IT Staff Augmentation Services!

Sr. Bo Consultant Resume Profile

NM

Professional Summary:

  • Over 7 years of experience in Information Technology as Business Objects Developer
  • Extensive experience in analysis, design, development and implementation of Business Intelligence applications
  • Proficiency with Business Objectsenterprise Products, Universe Designer, Desktop Intelligence, Web Intelligence, Info View, Central Configuration Manager CCM , Central Management Server CMS and Central Management Console CMC
  • Participated in all phases of Software Development Life Cycle SDLC - RequirementAnalysis, Design, Development, Testing and Documentation
  • Experience in gathering Business Requirements Document BRD , System Requirements Specifications SRS , System Design Specifications SDS and functional requirements while working with the client and project managers
  • Developed Requirements Traceability Matrix RTM to assist and update stakeholders with the progress and successful implementation of project
  • Experience in working and implementing Crystal Reports XIR2/10/9/8 and Crystal Xcelsius.
  • Proficiency in design and implementation of Xcelsius Dashboards using QaaWs, Live office and XML sources
  • Good understanding of Data Warehousing Design Methodology, Data Warehouse Concepts, Database design and architecture including both OLAP OLTP data
  • Experience in using Star Schema, Snowflake Schemas and Multi-Dimensional models for faster and effective querying
  • Strong database experience using Oracle10g/9i/8i, MS SQL Server 2008/2005, MS Access.
  • Completed two full life cycle implementations for different modules in SAP BI/BW which involve Gap analysis, Blue Printing, Realization, Production support, Testing and Documentation
  • Proficiency in ETL activities such as Data Extraction, Data Modeling, Loading Full/ Delta upload , and scheduling, monitoring and process chains for automated data loads from different source systems
  • Conducted analysis of Big Data by successful installation, configuration and administration of Hadoop ecosystem components and architecture
  • Strong knowledge in developing, designing and implementing data mining models using neutral networks and logistic regression
  • Experience in a variety of industries such as Facilities Management, Finance, Healthcare, Insurance, Emergency Preparedness, Transportation, Oil Gas, Renewable Energy and Energy Conservation

Technical Skills:

Business Intelligence

Business Object suite XI R4/XI R3/ XI R2/6.5/5.1, Business Objects BI 4.0, SAP BW, Webi XI/6i/2.6, Designer, Reporter/Desktop Intelligence/Web Intelligence Rich Client 3.1 , Supervisor, Broadcast Agent, Info View, Crystal Reports 2008/XI/10, Crystal Enterprise, Central Management Console, Xcelsius, QaawS, Live Office, Xcelsius 2008/4.5, BI Launch Pad, Application Foundation 6i/2.5, OLAP Intelligence, ZABO

Data Warehousing

SAP BODS 3.0, Informatica Power Center V7

Data Modeling

Erwin, Visio, Framework Manager 8.4.

Databases

SAP BW 3.5, HANA 1.0, Oracle 11g, 10g, 8i/9i, SQL Server 2008/05/00, MS-Access, DB2 V6, Sybase IQ, Teradata V2R5.1/5.0, Siebel CRM 8.1/7.7

Development Tool

TOAD, SQL Management Studio, PL/SQL developer

Languages

C, C , tcl, HTML, XML, JavaScript, Visual Basic

Operating Systems

Windows NT/ 2003/2008 Server, Linux Ubuntu 12.0.14

Professional Experience:

Confidential

Sr. BO Consultant

Responsibilities:

  • SAP Business Objects developer to support BI requirements gathering to report delivery for new projects and made improvements to existing project reports
  • Participated in monthly meetings of Board of directors, stakeholders and staff to provide an update and help understand progress of their units
  • Involved in Software Development Life Cycle SDLC by gathering Business requirements and specifications from client and beta user groups and developed technical documents
  • Implemented Agile/Scrum project methodologies for stand-up meetings to provide updates for project team members and move the story cards accordingly
  • Worked with Central Management Console CMC to set security levels, publish and schedule reports
  • Designed Universes using SQL Databases to build queries in Web Intelligence, Crystal Reporting and Implementation of BO Dashboards
  • Responsible for design, deployment and maintenance of universes using BO web intelligence and scheduling reports on daily, weekly and monthly basis
  • Implemented Cardinality settings, Joins, Contexts, Conditions and Global Filters in Universe
  • Worked in Aliases and Contexts to resolve looping problems and used Derived tables methods
  • Implemented Custom Hierarchies for drill analysis and worked with Aggregate functions
  • Used Cascading prompts and Filters to minimize data cost and performed Drill operation for lower child level analysis
  • Applied Breaks and Sections in Webi reports and developed graphical charts and bars
  • Created Web Intelligence Ad-hoc and canned reports and implemented Ad-hoc Webi reports and Sub-Reports against Universes
  • Identified and removed bottlenecks to improve performance of Dashboards and personalized the dashboards to reflect user-specific alerts and metrics to track Key Performance Indicators KPI
  • Worked extensively with functions aggregate aware, select, prompt, where in the creation of dimensions, measures and conditions
  • Worked closely with DBAs to create aggregate tables to support Universes and dashboard.
  • Data Extraction Transfer Loading ETL using SAP BOBJ Data Services 4.0, loading data from SAP ECC system to SAP HANA and SAP HANA Data Provisioning using SAP LT replication server SLT , Flat Files, Data Extraction Connection
  • Used Import Wizard/ Life Cycle Management LCM tool and transported objects dimensions, measures, details, universes, connections, calendars, publications from Development to Testing to Production Systems

Environment: SAP Business Objects 4.0 Desktop Intelligence, CMC, CMS, Application Foundation, Data Integrator, Web Intelligence, Universe Builder, Import Wizard , BI7.0, Dashboards, Crystal Reports, ECC 6.0,BEx Analyzer, Oracle 10g, Windows 7, MS office, SQL Server 2005

Confidential

Sr. BO Consultant

Responsibilities:

  • Introduced the team to Agile Work principles, practices and disciplines in an interactive fashion that assists in teambuilding and applied Agile Work methodologies to existing problems
  • Developed Requirements Traceability Matrix RTM in order to assist and update stakeholders with the progress of the project for successful implementation
  • Scheduled recurring daily, weekly and monthly reports Webi, Deski, and Crystal Reports in Info View and used calendar based scheduling for reports
  • Developed reports using functionalities such as drill down, master detail tables, functions, slice dice, cross tab and formulas to speed up query and processing time
  • Improved the performance of reports by implementing Aggregate tables, Materialized Views, Creation / Re-building of Indexes and managing Cache
  • Modified dashboards with performance issues and prepared Gap analysis for clients Sakeholders
  • Designed, developed and managed universe in IDT for generating Pay roll reports, expense marketing reports and mapping data for marketing user group
  • Migrated BO content on a phased manner from Win 3.1 to Linux 4.1
  • Promoted them through new Promotion Manager Tool LCM into QA and Prod boxes
  • Worked closely with ETL developers to design, develop, test, maintain, and support the data architecture to ensure optimal performance and reporting flexibility while maintaining data warehouse quality standards
  • Selected data mining prospects for direct marketing including mailing, lead user and calling lists
  • Prepared reports describing the results of the program and made recommendations for reaching target demographics for a successful market entry
  • Tracked results of database marketing programs and gathered information for post-program analysis
  • Developed statistical models describing characteristics of respondents to the marketing program and presented program proposals for management to take advantage of database marketing opportunities
  • Coordinated and provided 24x7 production support both onsite and offshore for client

Environment: SAP BI 4.0 Web Intelligence Rich Client, BI Launch Pad, Information Design Tool, Data Foundation Business Layer , Business Objects XI 3.1, Universe Design Tool, Live Office, Promotion Management, Upgrade Management Tool , SAP BW 3.5, HANA 1.0, BI7.0, ECC 6.0, BEx Analyzer, Windows 2003server, DB Visualizer, Netezza, Oracle 11g, MS Office, SQL Server 2005

Confidential

BI BO Developer/ Admin

Responsibilities:

  • Developed universe for sales and marketing department to analyze sales and enable marketing team to make informed decisions
  • Used Designer Module to design universes, join tables, create prompts, queries and applied contexts and aliases to remove loops
  • Used Designer functions like Aggregate Aware to make use of aggregated table like year to date employee information, Total Funds allotted to employee for Each Fiscal Year FY and Prompt to allow the users to enter the values like Pay period Number, Fiscal year and calendar year when running reports
  • Defined hierarchies in universe to provide users with drill down option in reports and predefined conditions to use in Business Objects
  • Created various drillable Webi reports
  • Created ad-hoc reports with cascaded multiple prompts to retrieve required data for the user and minimize unnecessary load on the server
  • Created reports with heavy conditional formatting and functions to meet user requirements
  • Customized the reports with custom functions and loops to leverage the user reporting needs
  • Scheduled recurring daily, weekly and monthly reports Webi, Deski, and Crystal Reports in Info View and used calendar based scheduling for reports
  • Created various group based publications and distributed reports to the users
  • Setup predefined conditions in the universe level to restrict the volume of data to be pulled by users
  • Interacted with users to analyze changes and improvements they needed in existing reports and developed these reports to fulfill user requirements
  • Created Cross Tab Reports, Sub Reports and addressed chasm and Fan Trap using Multi Parse SQL
  • Prepared user documentation for hands on training for end user community

Environment: Business Objects 6.5.1 Supervisor, Designer, Reporter , Web Intelligence, BCA 6.5.1, 3 Tier BO, BO XI R2 CMS, CMC, CCM, Designer, Desk I, Web I, Import Wizard, Performance Management , BOXIR3, Crystal XI, BO XCelsius 2008 ,ORACLE 10g/9i, TOAD, Windows 2003 Server, Microsoft Excel 2007, UNIX, Informatica Power Center, SQL Server 2005

Confidential

Business Intelligence Consultant

Responsibilities:

  • Involved in the Requirements gathering, Development, UAT and production support phases of Business Objects Report development
  • Installed Business Objects version 5.1.3,
  • Created user groups and managed access privileges using Business Objects Supervisor
  • Responsible for Business Objects Repository, Web Intelligence maintenance and tuning
  • Performed release management of Business Objects reports using Broadcast Agent Server
  • Extensively used Designer to design various universes for different business groups
  • Created complex reports using cascading prompts, decode objects, etc.
  • Broadcasted reports Crystal Webi to individual recipients using InfoView scheduling functionality
  • Created roles/iViews in SAP portal for the users to access webi reports using single sign on
  • Designed, built, maintained Business Objects universes and repository
  • Created Dash boards, Key Performance Indicator scorecards using Crystal Xcelsius
  • Troubleshot problems and customized reports according to the specifications of the user group
  • Conducted info-sessions with end users on recurring basis to educate and communicate existing and new functionalities of Business Objects
  • Performed efficient tuning of SQL source queries for data load and usage of stored procedures
  • Used multiple join statements to retrieve data from multiple tables
  • Created stored procedures, views, triggers, user defined functions to incorporate the flow of business and invoked various stored procedures

Environment: Business Objects 4i/5i, broadcast agent server, Web Intelligence, Informatica Power Center, Visual Basic 6.0, Oracle 8i, TOAD, Windows 2000 Server, MS Excel 2007, SQL Server 2005

Hire Now