Previous Job
BIDW Subject Matter Expert
Ref No.: 18-03365
Location: Pleasanton, California
Start Date / End Date: 06/11/2018 to 12/28/2018

Participate in project planning sessions with IT and Business Teams to analyze business requirements and outline the proposed solution. . Build the new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections. . Use Derived tables to create the universe for best performance, and use context and alias tables to solve the loops in Universe. . Export the Universes to the Repository to make resources available to the users for ad-hoc report needs. . Generated Reports using the Universe as the main Data provider and also using the personal data files provided by the users. . Develop critical reports like drill down, Slice and Dice, master/detail for analysis. . Create complex reports using the multiple data providers and synchronized the data providers by linking the common objects to create the common report . Implement Security Features of Business Objects like row level, object level and report level to make the data secure. . Provide the security access management by creating users/groups and folders. . Develop universe user documentation guide for the end users reference. . Provide training for end users for generating their own report including complicated report. Qualifications and Skills required Data warehousing and Business intelligence experience. Strong Business Objects Universe design and report development experience (4-6+ years) About 7-10 years of total experience in Information Technology Industry. . With Strong Knowledge in all phases of Software Development Life Cycle (SDLC) such as developing, testing, Migrating, Administrating, security management and production supporting on various platforms like Unix, Oracle, SQL, TOAD etc. . Technical hands-on expertise using OLAP tool Business Objects 4/5.x/6.0 /XIR2 (Reports, Designer, Web Intelligence, Info view , and Supervisor) . Experienced in interacting with business users to analyze the business process and requirements and transforming requirements into screens, designing database, documenting and rolling out the deliverable. . Experience in Installation and configuration, Creation of repositories and security domain with user groups and security implementation. . Knowledge on BO XI Architecture and new features. . Expertise in Universe designing, developing and generating complex, Ad-hoc, dashboard Reports, Business views, List of values along with User Acceptance Test and data accuracy Test. . Proven abilities in creating complex reports by linking data from multiple data providers, using free hand SQL, stored procedures and functionality like Combined Queries. . Extensively use of Business Objects reporting functionality such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.

Must have domain knowledge of change, incident, problem and configuration management.
Comfortable using quantitative approaches, creative data analysis, algorithm development and modeling to create assumptions based on historical data and testing thresholds to predict future performance.
Additional Skills Preferred: R, SAS, SQL Server Business Intelligence Development tools, Sybase IQ
Is a specific license of certification required?
Is a Motor Vehicle check required?
Is a Health Screen required?
Is a Physical Exam required?
Which department will this resource be working in?
Hours per Day 8
Hours per Week 40
Total Hours 1,160.00