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