Data analytics and Visualisation

MAYURESH BHOIR Contact: +1-571-***-****

E-mail: ***********@*****.***

BI Professional

Working as BI lead in J P Morgan Chase & Co., India

Over 13+ years of comprehensive & in-depth experience in the Information Technology (IT) industry with specialization in SAP Business Objects, QlikView, Tableau, Alteryx and expertise in Data Warehousing and Business Intelligence area.

Business Analytics professional with a proven history of delivering complex analytics projects including requirements analysis, vendor evaluation, business case development and feasibility assessment. A deep knowledge of statistics, analytics and IT systems is complemented by a flair for effective communication, quantitative and qualitative analytical skills for customer information quality and ability to quickly understand complex organizations, processes and systems and then act to create client value is a key strength. Designed and developed BI solutions and integration with databases and data warehouses for customers. Stayed abreast with BI technologies and new technologies. Consulted Solutions delivers global IT consulting expertise to the various industries. Developed and offered integrated, end-to-end IT solutions in targeted industry segments that support the client’s strategic, operational and financial goals. Analyzed and implemented business and technology change working collaboratively with business leaders. Performed overall project management, analysis, architecture, design, development and implementation of business intelligence initiatives.

SKILLS

13+ years of professional IT experience with strong background in using SAP Business Objects 4.1/4.2/4.3/3.1/XI R2

Experience in Business Objects Enterprise suite using Universe Designer, Information Design Tool, Web Intelligence Rich Client, Desktop Intelligence, BI Launchpad, CMC, Promotion Management tools

4+ years of experience in Tableau/QlikView in creating reporting dashboards and visualizations

1+ year of experience in designing and developing Alteryx workflows to publish datasets on Tableau server for dashboards in .TDE format

1+ year of experience in AWS - creating tables and materialised views in Redshift and connectivity of BI tools Iike SAP BO, Tableau to Redshift

Extensive experience working in SDLC and Agile development environment

Significant contributions to all project lifecycle phases, from blueprint and design to configuration, functional design, requirement analysis/definition/determination, test execution, issue resolution, training, go-live assistance and post implementation support

Implemented Agile Methodologies (Development iterations, Teamwork, Collaboration, and Process adaptability throughout the life-cycle of the project)

Involved in end user training, integration testing, resolving performance issues and production support activities

Involved in creating a technical design document for each of the reporting areas

Worked on business intelligence projects from inception to implementation and delivered high quality solutions in a timely manner meeting and exceeding the business requirements. This involved working with the top management and executives, business sponsors and IT department

Profound knowledge of RDBMS such as SQL Server, Oracle, DB2, Teradata, OLAP

CERTIFICATIONS

Tableau Desktop Specialist

TECHNICAL EXPERTISE

BI/Data Warehousing SAP Business Objects (R2/R3.x/4.1) Qlikview Tableau

Oracle ETL (BODS/Informatica) OBIEE PL/SQL

Sybase C/C++/Java SQL Server MS-SSRS

HONOURS AND AWARDS

‘SPOT Award at RBS in 2012 for exceptional performance in leading and mentoring team in development

BI Developer of the Year award in J P Morgan Chase in 2013 given by the client for creating interactive dashboards for top management

Developer of the Quarter award in Rolta India Ltd; for meeting the delivery targets before deadline

PERFORMANCE MILESTONES

ROLTA

Business Intelligence COE development and consulting

Resource management, scheduling and working with demand management to prioritise projects

Organically developed team from 15 to 45 by performance improvements, repeat business. Further growth by targeting more areas within client organization for growth opportunities

Improved data quality by implementing Data Rejection Strategy

WORK HISTORY

Senior Associate, J P Morgan Chase & Co., Since Aug 2015 Till Date

Project: Enterprise Scale Reporting Solutions using SAP Business Objects, QlikView, Tableau and Informatica (Agile)

Designed, developed, implemented, and supported QlikView dashboards. Integrated data sources and databases with QlikView, and designed and developed data models and backend queries for presenting data

Worked on Qlikview Server and Publisher, to manage user access, schedule refreshing of documents, mount completed applications

Designing data model from scratch to aid team in data collection to be used for Tableau visuals

Created Tableau Dashboards with interactive views, trends and drill downs along with user level security

Experience in creating Alteryx workflows using various IN-OUT, transformation and summary tools and publish them to Gallery

Responsible for training and giving guidance on SAP BO to team and end users for development and maintenance of the reports

Leading and working with the BA team to create and propose project charters, deliverables, scope and objectives

Working with other EDW team leads to develop project estimates and timelines

Supporting the project manager in identifying and managing risks, issues and change requests

Interviewed business and subject matter experts to determine business and data requirements during development of the detailed business and functional requirements

Working with the Business Intelligence and Architecture teams to develop the look-and-feel of the web-based BO reports and Detailed Analysis prompted reports

Investigating and analyzing data/business requirements translating complex derivations into reproducible methods to be developed in ETL and BI. Supporting and providing clarification to ETL and BI developers acting as a liaison with the business and subject matter experts

Environment: SAP Business Objects XI 4.1,4.2,4.3 Qlikview, Tableau, Informatica and Oracle

Software Engineer Lead, Rolta India Limited, Since Sep 2013 to Aug 2015

Client: Intel Corporation

Project: Migration from Microstrategy to Business Objects 4.1 (SDLC)

Implementation - Strategy Design, Plan, Execution

Extensively involved in all phases of project from Requirements Gathering, Blueprinting, Configuration, Development, Integration Testing, Cutover, Go Live and Post Go Live Support

Knowledge Management within the organization by accumulating, gathering, storing and distributing reusable documents with various projects

SAP Business Objects is a reporting solution providing reports for various areas

Gathering the reporting requirements from the business users by conducting workshops and meetings

Managing end to end delivery of business intelligence projects

User roll out, training management of users on BI Tool Business Objects

Team set up and working with authority to align team for short term and long term plans

Environment: SAP Business Objects XI 4.1 and Microstrategy

Senior Analyst, TekSystems Pvt Limited, Mar 2013 to Aug 2013

Client: J P Morgan Chase & Co.

Project: Creating BO reports for Sales & Marketing

Providing Data Warehousing Architecture, Analysis and Modeling consulting along with establishing the data warehousing best practices for J P Morgan Customer Usage Data Warehouse

Worked with leads to identify the data requirements and information gaps and outlined the diverse steps needed to build an integrated data system and an effective decision support system (DSS)

Analyzed the existing systems and the business user requirements for tactical and strategic needs

Defined the Architecture and the various phases to create the data warehouse

Created the Multi-Dimensional data model (STAR Schema) and enhanced it to meet the growing requirements due to corporate mergers

Interacted with the business users on regular basis to consolidate and analyze the requirements and present them the design results

Developed the Hierarchies, Item classes and reports using SAP Business Objects 4.0

Environment: SAP BODS, SAP Business Objects XI 3.x and Xcelsius 2008

Team Lead, Royal Bank of Scotland, Jun 2010 to Feb 2013

Project: Audit and Banking Domain

Understanding functional requirement about investments, insurance, real estates and loans.

Designing, developing and testing the Universes and applications

Building of Objects in Universes based on the business logic and developing the WEBI/DESKI Reports according to the requirement

Testing report data in SQL and replicating the client's environment under a test domain virtually to analyze pre deployment challenges and planning the required environment for actual deployment

Migration of existing environment from XIR2 to XIR3 using Import Wizard tool and database from SQL Server 2000 to SQL Server 2008

Creating new users and user-groups as per client requirement and provide rights

Scheduling the BO reports to user's Infoview inboxes, personal drives and through email in hourly, daily, weekly and monthly basis.

Setup of Business Objects DR server & maintaining in sync with the Production server

Environment: SQL Server 2005/2008, SAP Business Objects XI R2/3.1

Delivery Processing Associate, Integreon Managed Solutions, Jan 2009 to May 2010

Report generation in Business Objects XI R2 for client Clifford Chance, NY

Worked with the major functionality of BO like Breaks, Alerter, Filters, Sorts, Query Prompt filters

Extensively used calculations, rank, drill down, drill thru, formatting, and used prompts for creating BO reports

Involved in creation of various reports like cross-tab, master/detail reports according to the client requirement

Testing data using SQL Queries

XML generation through Qual for Legal Entity

Extensively worked on MS Office for Legal agreements

Environment: SQL Server 2000 & SAP Business Objects XI R2/3.1 and MS Office

EDUCATION

Masters of Computer Applications (M.C.A), Late Bhausaheb Hiray College, Mumbai University 2010

Bachelor of Science in Information Technology (B.Sc-I.T), D. G. Ruparel College, Mumbai University 2007

TRAINING

Data Science with R and Python

SAP Data Integrator/Data Services, SAP HANA

MS SSAS, MS SSIS, MS SSRS

Xcelsius 2008 & SAP Business Objects Administration

Microstrategy, Qlikview and OBIEE

Professional trainings on Inter-Professionalism and Leadership

Contact this candidate