We provide IT Staff Augmentation Services!

Senior Business Intelligence Lead Developer/tableau Developer Resume

Nashua, NH

SUMMARY:

  • Over 9 years of experience working as a Business Intelligence consultant using SAP Business Objects BI 4.2,4.1,4.0, XI R3/R2/6.X, Business Objects Designer, Reporter, Supervisor, Central Management Console, Info View(BI Launchpad) and Web - Intelligence, SAP Lumira, Design Studio, Tableau Desktop & Server.
  • Enthusiastic, Quick & Self learner, Team player, Team lead, Solutions Architect and always willing to run extra mile to implement Efficient & Robust solutions with new methodologies
  • Expert in performing BI Product analysis, Building strategies, Roadmap, documenting Pros and Cons of different tools, bridging gaps on analytic solutions
  • Well versed with other BI Tools, SSIS, SSR, SSAS, Power BI & OBIEE, Qlikview, Qliksense and willing to work new technologies
  • Strong knowledge in overall BO XIR2/3.0/3.1/BI 4x application architecture and able to Design, Deploy, Support the application architecture
  • Advance level experience creating dashboard analytics for over 3 yrs using Tableau Desktop and Tableau Server, version 10.x/9.x/8.x and administration including adding users, groups, permissions, connections & scheduling tasks.
  • Converted complex Xcelsius dashboard into Tableau dashboards using features Cross-Database joins, data blending, parameters, sets, bins, custom hierarchies, complex calculated fields, interactive filters, references, annotations etc.
  • Well versed in creating story boards & dashboards using Lumira & Design Studio
  • Extensive work experience in migration of Business Objects XI R2 to XI R3 and XI R3 to 4.0
  • Well versed in SAP Business Objects (XIR3.0/3.1 and BI 4.0/4.1/4.2) with experience in Supervisor, Designer, Reporter, BCA (Publisher and Scheduler), Web Intelligence 2.5/2.6.1/6.0 , Infoview,BI Launch Pad, Dashboard Designer, Design Studio, Auditor and Schema Design
  • Expertise in retrieving data using Business Objects Universes, personal data files, stored procedures and free hand SQL methods, Experience in using Triggers, Stored Procedures, Views and materialized views
  • Experience in installation, administration and upgrading versions of BO both desktop and server products on both Windows and UNIX environments.
  • Experienced in designing Universe and creating reports web intelligence and Desktop Intelligence report
  • Thorough knowledge and followed the process of ITIL
  • Certified in ITIL Foundation V3
  • Experienced in migration of SAP Business Objects XI R3.1 to BI 4.0
  • Provided Administrative support on day-to-day basis, Created & managed user groups, User securities, Biar files back up
  • Designed Data Models OLTP/OLAP data models
  • Expert in Architecture, Design and Deploy Dashboards Designer(Xcelsius Dashboards) using different dashboards connectivity tools Live Office, Qaaws, Query Browser and BI Web Service
  • Developed POC's Dashboards using Qlik View, Qlik Sense & Power BI
  • Expertise in retrieving data using Business Objects Universes, personal data files, stored procedures and free hand SQL methods. Solid knowledge of SQL and PL/SQL.
  • Worked with Dimension modeling using Star Schema, Snowflake schema (ROLAP)
  • Good knowledge and experience in using Oracle 9i/10g, EBS11.5.10.2 & 12.1.3,MS SQL Server 2000/2005/2008/2012/2014 , Epic Cogito, Netezza & DB2
  • Being a key project player, observed & Implemented a full Life Cycle of a project, which included Requirement Analysis, Planning, Designing, Development, Test and Roll-Out / Go Live

TECHNICAL SKILLS:

BI Tools: SAP Business Object (6.x/XIR 2/3.0/3.1/4.0/4.1/4.2 ), IDT(Information Design ToolUniverse Designer, Supervisor, Web Intelligence/Desktop Intelligence, Crystal Reports 2008,10, Info View(BI Launch Pad),Crystal Xcelsius4.5/2008,Dashboard Design, Design Studio, Business Objects Explorer, SAP Lumira, Business Objects DataServices,(CMC)Central Management Console, Import Wizard, Upgrade Management

Tool:, Business Objects Data Services 4.x (ETL Tool), SAP Hana SPS 10,Tableau Desktop Server

Databases: Clarity Database, Epic Cogito Database, Oracle 10g/9i, Oracle EBS11.5.10.2 & 12.1.3, Teradata 13, MS SQL Server 2000/2005/2008 R2, MS Access,DB2

Star: Schema (ROLAP) Modeling, Snowflake Modeling, Physical and Logical Diagrams

Languages: SQL, PL/SQL, Visual Basic 6.0, VB .Net, C/C++

Operating Systems: Windows 95/98/2000/NT/XP/Vista/7, Linux

Application Software: MS Word, Excel, MS Access, MS Power Point

Other Tools/Utilities: SQL Navigator, TOAD, IIS5/6, Management Studio, Apache, Web Sphere 6, BEA Web logic 7, Enterprise Architect

EXPERIENCE:

Confidential, Nashua, NH

Senior Business Intelligence Lead Developer/Tableau Developer

Environment: SAP BI 4.1 sp5 & 4.2 sp3, Salesforce CRM, Wave Analytics, Peoplesoft, SQL Server 2014, SSIS,SSAS, Dashboard Designer, Lumira, Design Studio & Tableau

Responsibilities:

  • Responsible for supporting reporting analytics and dashboards for Marketing, Customer Support & Finance department group
  • Gathering Requirements, Analyzing, Developing Webi reports, Modifying existing Dashboards & Crystal Report, Creating storyboards in Lumira Discovery
  • Product analysis on different tools Dashboard Design, Lumira, Design studio, Tableau, documented pros & cons and created a road map for conversion project
  • Converted complex Xcelsius Marketing dashboards into Tableau Dashboards, Replicated Drill down, drill up, Interactivity, context/global filters, LOD's, Row level Data security, Crosstab, interactive dynamic visibility to replicate existing Xcelsius Dashboards
  • Upgrade & migration from BI 4.1 sp5 to BI 4.2 sp3
  • Thorough analysis of SAP Hana to handle the challenges of large data sets
  • Developed SSAS Cube Tabular as data source to support ad-hoc reporting and dashboard need for Power users of Marketing & Finance teams and build Tableau Dashboards

Confidential, Waltham, MA

Senior BI Consultant/Solutions Architect

Environment: SAP BI XI 3.1 sp6 & SAP BI 4.2(Sandbox Environment), PeopleSoft ERP, Oracle 11g Data base, Xcelsius Dashboards XI 3.1 sp6, InfoSol Infoburst & 3D Dashboards( Confidential Own Dashboard Tool) & Tableau

Responsibilities:

  • As a part of DSX Finance global team I was responsible to Analyze & Provide solutions to the existing data & Performance issues with the Universes(which was Built on transactional real-time Database), reports & Dashboards and Re-design to new solution design to fix the data accuracy & performance
  • Responsible to communicate with global business users(France, UK & India)for New Reports requirement gathering, Support on production issues pertaining to Reports, ETL(Business Objects Data Services) & fulfil enhancement requests
  • Worked on designing a Conceptual & Physical Data Mart(Star Schema) for Expense Module - Requirements gathering & data profiling, Determined existing & Missing information in existing Data Warehouse, Located & documented the source & Target data field to fulfil the need of the Expense Data Mart
  • Supported & enhanced existing Xcelsius dashboards using Infosol Infoburst XDC’s cashed queries (Third party tool used to execute & save database queries in Memory for improved dashboard performance)
  • Converted requested Xcelsius dashboards in to Tableau Dashboards
  • Worked with Infra team to Assess BO Existing Environment, prepare Server Sizing & Install BI 4.2 in Sandbox Environment for users & Developers familiarity before planned Go-Live

Confidential, Lancaster, PA

Senior SAP Business Objects consultant/Dashboards Architect

Environment: SAP BI 4.1, Epic Clarity, Epic Cogito data warehouse, SQL Server 2012, Dashboard Design 4.1

Responsibilities:

  • Responsible for gathering requirement from senior management and define the scope of the project for Executive Operations & Quality dashboards and reporting analytics.
  • Responsible for designing, developing and implementing strategic solutions
  • Assisted ETL to bring the data from different sources (Epic Clarity, Midas, Press Ganey) to Epic’s Enterprise Data Warehouse Cogito for reporting need
  • Created master universe using IDT(Information Design Tool) to create 2 Executive dashboards(Quality & Patient Safety Dashboard & Executive operations Dashboard) and adhoc webi reports
  • Architect and developed the Quality & Patient Safety dashboards in Dashboard Design 4.1 using Query Browser connectivity
  • Supported the Design and development of 6 level drill down dashboard using heavy excel functions, Dynamic Visibility and flash variables
  • Architect and Design Quality & Patient Safety Dashboards in Dashboard Design 4.1 using BI-Webservice as connectivity from WebI reports as backend data feed for this dashboard
  • Converted the existing Scorecard & Administrative Universe from .UNV to .UNX and made the changes to universe as per the new EDW(Cogito) data model for adhoc reports need for power users

Confidential, Cambridge, MA

Senior Business Intelligence Consultant

Environment: SAP BO XI 3.1, Oracle EBS 12

Responsibilities:

  • Responsible for Analyzing, Planning and modifying new & existing programs within the established project methods and procedures
  • Analyzed existing requirements for reporting need and Created Complex Universe using UDT on Oracle EBS 12 data base for Adhoc reports & Canned reports of Batch Control Tower Project
  • Created couple of complex reports tested and rolled out to Production
  • Used report publication and report bursting to send the reports daily to end users as per their geographic area
  • Fixed day to day issues with reports and enhanced the look and feel of the Webi Report as per the end users requirement
  • Gathering requirements and analyzing the report needs for Batch Yield Project

Confidential, Rochester, MN

SAP Business Objects Consultant/Xcelsius (Dashboard Design) Developer

Environment: SAP BO XI R3.1,Xcelsius 2008, Dashboard Design 4.1,Crystal Reports XI 2011, BI 4.0 & BI 4.1, Database - Oracle 11g & SQL Server 2012, SAP BW, ETL - Data stage

Responsibilities:

  • Responsible for gathering and analyzing the requirements for end users, Stake holders and propose appropriate approach and solutions with sample POC's and implementing strategic solutions
  • Architecture multiple complex dashboards from scratch Using Dashboards Design(Formerly Xcelsius Dashboards), Designed the workflow of each dashboards which includes choosing the right components depending on the Requirement, Data analysis and dimensionality of the data and choosing the right connectivity tool depending upon the data sources and availability
  • Worked closely with ETL resource to bring the Cerner Rules data from 3 different database sources to fulfill the Reporting & Analytics need using Informatica tool on Oracle 11g Data base
  • Created multiple adhoc and canned reports for Cerner project on Webi and Crystal Reports
  • Converted and recreated the existing Crystal reports to Webi reports
  • Worked closely with Business Analyst to define the scope of the project for Clinical Decision Support and Project Performance Portfolio dashboards
  • Worked on optimizing the performance of the dashboards. Reduced the dashboard loading time by scheduling the backed source webi reports for the live office
  • These complex dashboards have immense interactivity back and forth with more than 20 child dashboards using flash variables depending upon the departmental and the data selection
  • Created multiple Cross Tab report over Cube data using SAP Business Objects Analysis for OLAP
  • Created 2 complex Dashboards using Design Studio with Information design tool(IDT) Universe as back end data source to fulfill the end users need of accessing Dashboard Analytics through I-Pads (Mobile Applications)
  • Wrote CSS coding to design and develop the look and feel of Design Studio dashboard components and HTML coding to design the webpage
  • Integrated Design Studio SDK to enable the Export dashboard to PDF, PowerPoint, Word & Excel
  • Modified the existing universes for performance tuning and maintained common dimensions across all the universes with unique naming as a part of clean up activity
  • Created Universe from scratch with BW Bex data sources Using IDT(Information Design Tool) for Webi Reporting, Crystal Reporting & Dashboard need of Clinical Decision Support,Worked closely with BI Lead to prepare Test Plans, User acceptance testing and tested Webi & Crystal Reports and The Dashboards
  • Extensively worked on Production support to resolve issues with Webi Reports, Crystal Reports & Xcelsius Dashboards, Users security & Access issues following the Incident, Problem & Change management of ITIL

Confidential, Burlington, MA

SAP Business Objects Admin/Developer

Environment: SAP BO XI R3.1, Database - Oracle EBS 11 & Oracle EBS 12, ETL - Informatica

Responsibilities:

  • To fix existing Universes, DeskI and WebI reports as client has upgraded from Oracle EBS 11.5.10.2 to 12.1.3 which has additional tables and change in the existing tables structure
  • Extensively worked on to enhance the Universe performance by applying Index awareness, aggregate awareness and pushed reports aggregation to Universe
  • Resolved loops and traps in multiple complex Universes after adding additional table from new EBS 12.1.3 as data source
  • Applied data securities-row level securities according to the management level hierarchy
  • Tested multiple DeskI and WebI reports with new EBS,DW and ODS data providers by taking production data snapshot in Dev and UAT for accurate validation of data
  • Migrated Universes, DeskI and WebI reports from Dev to UAT and resolved reports issues as part of SIT

Confidential, Trenton, NJ

SAP Business Objects/Xcelsius Consultant

Environment: SAP BO XI R3.1, Xcelsius Dashboard 2008, SAP BW, Database - Oracle 10g, ETL

Responsibilities:

  • Worked with business analyst to define the scope of the project for Marketing online clients
  • Created POC dashboard with Tableau tool for Marketing online clients
  • Created OLAP Universe from scratch with SAP BW as data source for reporting and dashboard analytics
  • Architecture Xcelsius Dashboards for Marketing online clients assigning user lever securities at Universe
  • Performance tuning on Existing dashboards and skimmed down the Live Office connection to improve dashboard performance,Provided feasibility and gap analysis for upgrading BO XI R3 to BO XI R4 version and gave recommendations, Worked with BOXI-4.0 Dashboard design, Information design tool, Interactive Analysis in sandbox environment for POC
  • Converted Universes from .unv to .unx format in Information Design tool to add more data providers in the same universe to support WebI analytics and POC Dashboard
  • Used Business Intelligence Web Service(BIWS) as a data connection to enhance the dashboard performance
  • Integrated Dashboard analytics to SharePoint portal to access through clients websites
  • Trained end users to create ad-hoc reports using Webi

Confidential, Chester brook, PA

SAP Business Objects Developer

Environment: SAP XI R3.1, Netezza, Informatica

Responsibilities:

  • Helped Business SME’s and Project Manager in defining the scope of the project and gave the timelines to create Master Universe from Netezza database
  • Helped data architect in designing the snowflake schema considering functional requirements and the purpose of Master Universe to create adhoc reporting
  • Worked with ETL resource to support and fill the gap between Client’s data dependencies with their vendor agencies
  • Created Master Universe for adhoc reporting, Converted existing large number of Deski to Webi reports through RCT,Created Senior executive level Web Intelligence reports
  • Applied Object level securities and row level securities on data, depending on the Senior Executive level and Management level access,Helped offshore team in creating Promotional material metrics(PMM) ad-hoc reports,Performance tuning on existing Universe and WebI reports
  • Created UAT test plans and Performed UAT testing on Master Universe & Webi Reports
  • Knowledge sharing of the project with team & User training on Webi reports

Confidential, Trenton, NJ

SAP Business Objects Consultant/Xcelsius Developer

Environment: SAP BO XI R3.1, Xcelsius Dashboard 2008, SAP BW, Database - Oracle 11g, ETL

Responsibilities:

  • Gathered functional requirements and designed Technical specifications
  • Build the Universes for Business Analyst report generation using Designer from the Data base Oracle 10g
  • Develop and create classes with Dimension, Detail & Measure objects.
  • Develop Custom hierarchies to support drill down reports.
  • Provided support for Business Objects XI R3.1 production environment. Common tasks such as Report formatting, adding new objects and tables to the report, applying filter conditions, LOVs filtering were addressed on day to day bases. Also created multiple AdHoc reports based on users request to provide quick solutions to problems
  • Extensively worked on complex Xcelsius Dashboards to reflect analysis of the business for different departments, Created dashboard with hierarchical data and linked it multiple BO Infoview reports using OPENDOC functions
  • Extensively worked on dynamic visibility and good understand with all the Xcelsius components functionality.
  • Created refreshable dashboard using Live Office, custom components using Adobe Flex to support dashboard’s 4 level of drill down.
  • Embedded alerter using various components such as chart, gauges and progress bars to display statistical KPI of the business
  • Extensively involved in User training which was done for different Business Objects tools specially Web Intelligence for UAT Users

Hire Now