We provide IT Staff Augmentation Services!

Sr. Business Intelligence Consultant Resume

0/5 (Submit Your Rating)

Los Angeles, CA

SUMMARY

  • IT professional with over 8 years of experience in the Business Intelligence industry with concentration on Business Objects. I have extensively worked on various versions of Business Objects including 4.0/XI3.1/XIR2, Web Intelligence 4.0/XIR3/XIR2, Business Objects Designer XIR3/XIR2 and also the new Information Design Tool (IDT) in 4.0.
  • Extensive Experience in Creating Web Intelligence/Full Client/Desktop Intelligence Reports in Business Objects 4.0/XIR3/XIR2
  • Worked on Web Intelligence to develop and publish thin client reports.
  • In - depth knowledge in creation of WEBI reports and Dashboards using Crystal and Xcelsius
  • Expertise in retrieving data using Business Objects Universes, personal data files, stored procedures and free hand SQL methods.
  • Accomplished several projects governed by full SDLC model, from Requirement gathering, Analysis, Planning, Designing, Development, Test and deployment to production
  • Good analytical and documentation skills with ability to communicate at all levels
  • Exposure in ETL tools namely Business Objects Data Services (BODS) and Informatica.
  • Integrated data from various data sources like Oracle and SQL Server
  • Knowledge in Data Modeling using Dimensional Data Modeling, Star Schema Modeling, Snowflake Schema Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling
  • Utilized all business objects tools including CMC, Supervisor, Designer, BO Reporter, Web Intelligence, Broadcast Agent, BCA Publisher, Configuration tool, Performance Manager, Dashboard Manager, import wizard, Data Integrator in various projects
  • Good Experience in maintaining and scheduling reports in production environment and supporting users in creating Web Intelligence reports and administering the BO activities
  • Efficient in Optimizing, Debugging and testing SQL queries and stored procedures
  • Excellent communication skills, strong decision making skills, organizational skills, and customer service oriented
  • Excellent analytical and problem solving skills

TECHNICAL SKILLS

BI Tools: Business Objects 4.0/XI R3.1/R3.0/R2, Web Intelligence 4.0/XIR3/XIR2, Designer, Desktop Intelligence, Crystal Reports 2008, Xcelsius 2008/2010

Data Modeling: Star-Schema Modeling, Snowflake- Schema Modeling

Languages: HTML, XML, T-SQL PL/SQL, SQL*Plus, C++, C, Java

Reporting Tools: Crystal Reports 8/8.5/9/10, SQL Server Reporting Services (SSRS)

Data Modeling Tools: Erwin 4.0, Microsoft Visio

Database Technologies: MS Access, ORACLE 10g/9i/8i, MS SQL Server 2005

ETL Tools: Data Services, Informatica

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles CA

Sr. Business Intelligence Consultant

Responsibilities:

  • Involved in gathering, analyzing, and documenting business requirements and data specifications for Business Objects Universes and Reports.
  • Converted universes from unv to unx and then modified reports respectively.
  • Created several Universes to meet the reporting and dashboard requirements
  • Worked on Business Objects XIR3.1 environment
  • Involved in joining the tables by creating aliases to resolve the loop
  • Interacted with end users, regularly in order to generate the reports required, these reports were generated using Business Objects functionality such as Slice and Dice, Master/detail, User Responses and Formulas
  • Converted Deski Reports from XIR2 environment into Webi 4.0 then repointed the data sources to unx
  • Creation of Universes by retrieving the data from various data sources, defining the connections necessary. Generating various numbers of reports on a daily, weekly and monthly basis.
  • Created Universes by retrieving the data from various data sources, defining the connections necessary. Generating various numbers of reports on a daily, weekly and monthly basis.
  • Created complex conditions (Dates), Prompts and free hand custom SQL to create Derived table in universe.
  • Performed UAT testing on the converted universe and reports in 4.0 to assure data was accurate and the formatting was correct
  • Designed and created reports based on technical specifications provided.
  • Defined logical classes and objects and hierarchies for analysis and drilling on hierarchies in the WEBI reports.
  • Developed universe user documentation guide for the end users reference
  • Generated the Business Objects reports involving complex queries, sub queries, Unions and Intersection.
  • Tested the aggregate awareness to ensure the query is pulling correct level of aggregation.
  • Created Dashboards using static data from Excel as data source. Also retrieved dynamic data using multiple options such as query as a web service, XML and Live office.
  • Using Live office imported Webi reports in Excel and Created Xcelsius visualization based on these reports.
  • Created Queries, Cross Tab tables, Master Detail reports using formulae’s and variables.
  • Applied slice-and-dice, drill-up and drill-down techniques in master detail reports for multi-dimensional analysis of retrieved data.
  • Applied sections, Breaks, Calculation, Report Filters and Query Filters and displayed the information in different Blocks. Linked reports in Web Intelligence using Open doc function.
  • Connected to Business Objects Repository as a Business View and created reports
  • Scheduled reports through CMC and InfoView. Developed and deployed complex Webi reports

Confidential, Thousand Oaks, CA

Business Objects Consultant

Responsibilities:

  • Migrated universes, reports and security domain from 6.5 to Business Object XIR3 Using Import Wizard
  • Produced technical document and user manual for migration from one built to another built of Business Object
  • Converted Deski (Desktop Intelligence) reports to Webi (Web Intelligence) reports using Report Conversion Tool
  • Used Crystal Report XI Enterprise to design the front end reports
  • Defined KPI’s Metrics (Key Performance Indicators) to analyze the user adoption to BI as a part of Data Governance Goal.
  • Used QaaWs (Query as a Web Service) to feed data into Xcelsius.
  • Created complex Xcelsius dash boards to reflect User Adoption Metrics.
  • Used Web connector in Xcelsius to import data from QaaWs.
  • Maintained business and process metadata collected for data related Work Flow Enhancement projects within Bank tools Business Objects, and or designated bank database.
  • Configured the Webi, Deski Server. Configured Apache Tomcat, IIS 6.0, VM Ware.
  • Created different CMS clusters and also different server groups to gain performance.
  • Set up LDAP and NT authentication for Crystal and Business Objects users.
  • Analyzed specs and database model to generate the reports for the sign-off specs
  • Wrote procedures for the complex reports and list of values for the parameters
  • Established user groups and users and assigned privileges.
  • Wrote functions to reduce code in procedures like Address, Full Name, Active members
  • Created Business Objects Web Intelligence & Desktop Intelligence reports and published on the INFOVIEW.
  • Involved in migration and deployment of the universes and reports across multiple repositories.
  • Published report to Enterprise server, to get the report access from INFOVIEW.
  • Used Team Track to track the status of the report by developer, state and comments.
  • Created reports using Crystal Reports with Standard, Summary, Cross Tabs and Grouping.
  • Worked in Crystal Reports including creating reports from various formats including: Access, SQL, Oracle, XML, Txt files etc.
  • Optimized Crystal Reports performance for large reports(reduced page generation time)
  • Prepared user documentation for hands on training for end user community
  • Created alerts, breaks, filters and ranks in the report

Confidential, New York, New York

Business Objects Developer

Responsibilities:

  • Designed and implemented oracle based security in Business Objects
  • Resolved Loops using Aliases and Context, Addressed chasm trap and Fan Trap using Multi Parse SQL
  • Created Custom Hierarchies for several groups
  • Was involved in Star Schema customization / Design session
  • Oversee daily activities of the project SDLC process and coordinate activities of team members, ensuring that module goals are met within predetermined time frames.
  • Provide the first level support to approximately seven groups
  • Design and develop the best practices
  • Re-define the security in XI R2 and implemented the best security model in XI R2 using new security features
  • Optimized the XI R2 system performance by fine tuning the XI R2 servers
  • Implemented the minimal customizations of Info View in XI R2
  • Co-ordinate with MSI team on Business Objects full client deployment
  • Developed reports in Desktop Intelligence & Web Intelligence XIR2
  • Participated in designing the Oracle to Business Objects XI R2 Security Bridge.
  • Wrote a full functional specification document for the security to be implemented in Business Objects XI R2.
  • Acquired an excellent understanding and work experience of EXCEL functions in Xcelsius
  • Developed General Ledger and Accounts receivable universes using Designer 6.5.
  • Developed reports in Web Intelligence. Created complex Universes and report for GL, AP and AR
  • Customized Rapid Marts of PeopleSoft GL, AP and AR
  • Designed and Developed Xcelsius dashboards / analytics and exported to several formats
  • In Xcelsius used single value, selector, mapped, chart, background, collaboration and text components
  • Migrated repositories from Development, System Test, Performance Test, UAT, Production, SLA and to Disaster Recovery using migration tool by creating BIAR files and moved it to the Destination System
  • Performed ETL tasks using SSIS (SQL Server Integration Services)
  • Help client to deploy Business Objects XI 2.0 on 7 different environments (Development, System Test, Performance Test, UAT, Production, SLA, Disaster Recovery)
  • Created KPI visualization for the client dashboard using Live data (Query As a Web Service) which address the performance of the LOB at the Organization Level
  • Used Data Integrator to Import data from various sources into data warehouse

Confidential, New York, New York

Business Objects Developer

Responsibilities:

  • Business Object Universe, Business Objects Reports and Business Objects repository were used extensively.
  • Created Universe level objects and measures using the business rules provided.
  • Created complex views to overcome loops and contexts.
  • Derived Tables, Aggregate awareness are used in universes. Involved in building the data repository.
  • Involved in Administration of Business Objects. Maintained user security on the BO Universes.
  • Deployed, Scheduled published the developed and tested reports on BOXI R2 Production Servers.
  • Web I Reports are created and deployed through Info View and Customized Web I Front end.
  • Complex Crystal XI Summary as well as Detail reports are created based on business request.
  • Created Auditor reports and tracked user access of reports and Universes.
  • Created Dashboards and Speedo meters for churning analysis-using Xcelsius.
  • Customized the dashboards for better manageability of overall performance
  • Maintained and Applied patches to Development, UAT and Production Servers to keep them in sync.
  • Worked with Business Users to develop system requirements, analyze data Elements and continuous end-user support. Performed data validation and analyzed test results.
  • Used BCA scheduler to run recursive reports Daily, Weekly, Monthly as requested by the end users and stores the output in their inboxes.
  • Created different categories to simplify it to the users to locate the reports.

Confidential, Cincinnati, Ohio

Reports Developer

Responsibilities:

  • Created several Deski reports and Crystal Reports
  • Analyzed existing database and Designed Universe by using BO 6.5 Designer Module
  • Created Classes, Dimension objects, Measure objects and Detail objects in the universe
  • Resolved issues related to RDBMS flaws such as Fan Traps, Chasm Traps using BO multi parse SQL functionality
  • Analyzed data using Slice/Dice and Drill Mode
  • Prepared different report layouts and blocks like Tables, Cross Tabs and Charts
  • Combined Budget with actual data Spreadsheet from Oracle using Linking Feature
  • Created and Published Reports through Web Intelligence, Info view portal
  • Checked Universes for Integrity and exported them to the Repository to make resources available to the users and groups.
  • Used Alert in various reports according to user requirement
  • Updated and maintained Universes based on changing user requirements and data source changes
  • Created templates to standardize the structure of corporate documents

We'd love your feedback!