We provide IT Staff Augmentation Services!

Senior Business Intelligence Lead Developer Resume

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

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

Data Modeling: 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

PROFESSIONAL EXPERIENCE

Confidential

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

Hire Now