We provide IT Staff Augmentation Services!

Bi Lead Resume

NJ

SUMMARY

  • Overall 12 Years of total IT experience in Business Intelligence Data Warehousing, Report Design, Application support and Functional responsibilities.
  • Total 8+ years of experience in SAP Business Objects BI 4.x, R3.x
  • Technical hands - on experience with BI 4.2/ BI 4.1 /XI R3.1, including IDT, UDT, Universe Designer, Infoview, BO Launch Pad, Web Intelligence Rich Client, Crystal Reports & Live Office.
  • Strong experience in development of Universes from IDT/UDT & Universe Designer and Web Intelligence Reports.
  • Successfully generated reports using BO reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
  • Excellent in performance tuning and optimization in BO
  • Strong knowledge in Client/Server Architecture, Relational Databases RDBMS, Data Modeling, fact tables, dimension tables, Star schema and snow flake schema
  • Responsible to support the issues with reports on the Business Objects Enterprise environments Development, UAT, Test and Production
  • Experienced in Teradata, Netezza, Oracle 11g/10g/9i, SQL Server 2000/2008 databases.
  • Strong database concepts with experience in using Teradata, Netezza, Oracle 11g/10g/9i, SQL Server 2000/2008, MS Access 7.0/2000, and GUI tools SQL Plus, Toad, and SQL Developer 2000 and Teradata Sql Assistance.
  • Experience in all phases of Software Development Life Cycle SDLC
  • Lead for team of developers and extensive experience in Onshore-Offshore model.
  • Worked for US Clients: Confidential, Confidential, Confidential, Confidential .
  • Domain knowledge on Media, Manufacturing and Pharma.
  • Excellent teaming and Interpersonal skills, leadership qualities, detail oriented, innovative, self-motivated and quick learner.

TECHNICAL SKILLS

Business Intelligence: SAP Business Objects 4.x and 3.x tools Universe Designer, Information Design Tool (IDT), Universe Design Tool(UDT), Info View/Launch pad, Web Intelligence Rich Client, Crystal Reports XI R2/2008, Live Office

Databases: Oracle 12c/11g/10g/9i, Teradata 14, SQL Server 2000/2008 and MS-Access

Data Modeling: Star Schema, Snowflakes Schema

Front end tools: TOAD, SQL Navigator, SQL Developer, Teradata SQL Assistant

Programming Languages: PL SQL, SQL, Toad, +, VB

Web Technologies: MS Share Point (Basics), HTML, DHTML

PROFESSIONAL EXPERIENCE

Confidential, NJ

BI Lead

Responsibilities:

  • Providing solutions to End Users with all the report related issues logged in Service Now
  • Responsible to support the issues with reports on the Business Objects Enterprise environments Development, UAT, Test and Production
  • Participating in daily status meetings to update the status and task prioritization
  • Designed, developed Universes from different data sources using Universe Designer, IDT. Checked the Universes for Integrity and exported to the Repository to make resources available to the users and groups. Defined BO Classes, Objects, in the Universe, defined Cardinalities, Contexts, Joins and Aliases and resolved loops in Universes using Table aliases and contexts. Worked on different databases and connected to universe.
  • Used multiple data providers and multiple universes to build reports. Created Master Detail reports, used complex queries, functions, variables, cross tabs and used charts in the reports. Worked on SQL queries at universe level and report level
  • Created Webi Reports for more detailed and granular level data based on selections. Worked on Query designer to build the reports in the Web intelligence. Worked on scheduling of reports in different export formats such as .csv, excel, word, .pdf
  • Developed crystal reports using various Charts and Graphs like Bar Chart Side by Side, Stacked, Line graphs, Pie Charts. Created charts in Webi reports with multiple drill down levels. Created user prompts to select multiple or period of data
  • Responsible to support the issues with reports on the Business Objects Enterprise environments Development, UAT, Test and Production
  • Extensively worked with formatting the reports according to the user requirements. Created Breaks, Filters at Different Levels of the reports and applied ranking in the Webi reports
  • Coordination and work along with the ETL team to ensure the timely execution of feeds to the reporting tables as well as testing the quality of data and providing inputs to them
  • Wrote complex views, functions and stored procedures using SQL, PL/SQL, to be used in Reports development
  • Developed universe user documentation guide for the end users
  • Provided for end users for generating their own report including complicated report

Environment: s: SAP Business Objects BI 4.2 tools Information Design Tool (IDT), Universe Design Tool (UDT), Web Intelligence, Oracle 12c and Teradata 14.10

 
  • Writing PL SQL Stored Procedures to load data into tables
  • Working with MS-Access, VBA

Environment: Oracle, MS Access, VBA, PL SQL, SPSS

Hire Now