Home

Mayuresh - Business Intelligence specialist

[email protected]

Location: Navesink, New Jersey, USA

Relocation:

Visa:

MAYURESH Contact: +1 201-777-4306 E-mail: [email protected] BI Analyst Working as BI Analyst in J P Morgan Chase & Co. Over 14+ 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 14+ years of professional IT experience with strong background in using SAP Business Objects 4.3/4.2/4.1/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 2+ 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 like 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.3) 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 WORK HISTORY BI Analyst, SOIMEX Denimagic Inc., Since July 2022 Till Date Client: J P Morgan Chase, NJ, USA Project: Client Onboarding Lifecycle Tool Working with the business users to understand the architecture, data Model, business logic and rules to be applied to meet the reporting needs. Discuss with stakeholder teams to capture high level transformation rules, produce features, define metrics and User Interface Design Document acceptance. Adapt agile methodology keeping tap on progress and coordinating between business and development team Co-ordinate with Scrum master to create epics, stories bugs and tech-spike JIRAs with acceptance criteria Playing role of subject matter expert in designing data sources or data modeling for Tableau dashboards and BO reports Prepare STTM (source to target mapping) for report development Writing complex SQL queries to read data from source databases to analyses source system after joining multiple tables. Working on the design and development of visualization solutions and create Business Requirement documents and plans for creating Tableau dashboards. Working with data creating workflows in Alteryx from multiple sources to generate tde file. Create semantic layer (universe) and financial/management reports in SAP BO using Web Intelligence and Information Design tool Working with BI Infrastructure team to connect SAP BO and Tableau to Redshift Schedule data refresh for weekly and monthly increments based on business changes to ensure that the views and dashboards displayed the changed data accurately. Work with users and help them on UAT. Environment: SAP Business Objects XI 4.3, Tableau, Alteryx, Oracle Senior Associate, J P Morgan Chase & Co., India., Since Aug 2015 To April 2022 Project: Client Onboarding Lifecycle Tool 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, Alteryx, 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, Teradata Senior Analyst, TekSystems Pvt Limited India, Since 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 BI Developer, ITREE Consulting & Chenoa Software Inc Since Jun 2010 to Feb 2013 Client: Royal Bank of Scotland 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, India, Since 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 Keywords: cprogramm cplusplus business analyst business intelligence rlang information technology golang microsoft procedural language Colorado New Jersey New York South Carolina