Jeevan Chaudhari

 Jeevan Chaudhari   E-P:-  ❘ Professional Summary A competent professional with 13+ years of experience in Information Technology Industry in services as well as in product development. I have strong background in Analysis, Design and Development of Product development, Applications, Business Intelligence Solutions, Data Modeling and Data Warehouse applications. An effective leader with proven ability in leading and guiding the team during the different project phases and enabling knowledge sharing among the teams. Currently responsible for design and development of Business Intelligence product called "Genix". I have rich experience in scrum management being scrum master for various products. Domain exposure :- BSFI , Airline Accounting Petrochemical , Oil and Gas , Refinery , Utility ❘ Work History FreeLancer (Nov 2021 – till Date) Domain: - Business Intelligence, DWH, Visualization Project: - Artemis Real Estate Partners (WIP) Client is into management of real estate properties. They use third party cloud solution to manage all properties. We are building analytical solution using Rest API provided by cloud solution. Role and Responsibility – As a BI expert I have to provide basic architecture and design. Development of script to consume rest API with bearer token Analyze rest API for data format. Consume Rest API in Power BI and Build data model. Define KPI and develop visualization for KPI Project: - The LedgerLabs (DWH based on Quickbooks) (WIP) Client is using QuickBooks Application to maintain his accounting billing books. In This project we are using Azure ADF to build a complete Datawarehouse and dashboarding solution for client ABB GISPL (March 2019 –Apr 2021)- Designation :- Principle R&D Engineer Role :- Product Development Architect and Scrum Master Product Details: - ABB Ability™ Genix Industrial Analytics and AI Suite is end to end analytical solution for utility , paper-pulp and shipping industry. Genix Dashboard Manager is key product in entire suite. This is home grown dashboard development and management product developed using Angular/react framework using NodeJS as backend. It serve as frontend for application where dashboards needs to be integrated. Role and Responsibility – I Was part of architecture group for Genix Analytics platform Managed implementations using Agile Methodology. Involved in Sprint Planning, Backlog Creation, retrospectives. Requirement gathering and Analysis - Collaborated with clients to determine project specifications and scope. Worked as architect for NodeJS restful services, Mongo dB/cosmos as backend. [product called Knowledge Service Hub] Data Modelling for product in both relational and no SQL DB. Responsible for requirements , planning and development of Genix Dashboard Manager Designed and implemented Security Model for Users and Data and audit. Analyzing Risks in advance and provide solutions to mitigate the same. Designed deployment strategies for nodeJS API, Web projects [i.e Dashboard Manager] . Inspiring, training and mentoring team members to ensure smooth adoption of new projects and skill sets. Managing onsite and offshore teams and collaboration.  Worked with Data integration teams to develop python restful API to process. Responsible for managing resources in Azure. [i.e. Web app Services, Gilt repo for specific product lines.] Rolta India Ltd (Rolta BI and Big Data PVT LTD )- Technical Architect Mumbai, Maharashtra • 12/2010 – 07/2016 and 01/2017 to till date 15/01/2019 Team Size : 15 Project Details - Rolta OneView™ (Flagship Product of Rolta) is a web-based business intelligence application that empowers personnel to make on-time decisions at all levels of the organization. Rolta OneView™ provides a platform to improve performance and overall operational effectiveness by aligning the work-process. Efforts of personnel with the goals of the business and provides a center for collaborative decision making leading to lower risk. Rolta OneView establishes a cross-functional paradigm shift, uniting users around one view of their business. Role and Responsibility – Inspiring, training and mentoring team members to ensure smooth adoption of new projects and skill sets. Managing onsite and offshore teams and collaboration.  Managed implementations using Agile Methodology. Involved in Sprint Planning, Backlog Creation, retrospectives. Requirement gathering and Analysis - Collaborated with clients to determine project specifications and scope. Setting up best practices and checklist for developing Dashboards and Reports to improve performance and reduce rework. Analyzing Risks in advance and provide solutions to mitigate the same. Designed deployment strategies for Business Intelligence Solution. It includes standalone implementations, High Availability (HA) , Cluster  , deployment   at various client places on different OS platforms like  Window, Solaris, linux system. Designed and implemented Security Model for Users and Data.  Configuration of third party Authentication like Windows AD, Ldap. Design and created SOP for production backup strategy and implementation. Designed and  Developed of Enterprise Level Data Model for Data- Warehousing projects using various databases like Oracle , SQL server , HANA . It includes HANA Information View Modeling. Explain Data-Model to ETL and reporting team. Guide ETL team about data load strategies and frequencies.  Designed and developed Cloud enabled solution and deployed the solutions as software as Service (SaaS). Performing Design Review and Code review of Team. Responsible for performance optimization of SQL Queries ,  Dashboard and Reports Design Development and review of semantic Models like Universe (IDT) , RPD ,  Tableau Data Source, HANA information Views. Design and Review of Dashboards created using tools like Sap Business Objects Design Studio, Web Intelligence, Dashboard Design, OBIEE, Tableau, and Mean/Mern Stack. Travelled frequently onsite for Requirement Analysis, Development, Deployment, UAT, Business User Training. Clients :-  StatOil Norway ,  Petroleum Department of Oman , Salalah Methanol Oman  , Ras Gas Qatar , Cairn India , Smart DCC UK, Varanasi Smart City India , Holy-Frontier US.  Citius Healthcare Technology PVT LTD- Technical Architect Mumbai, Maharashtra • 07/2016 to 01/2017 Team Size: 4 Project Details - Analytics platform development using Infor Business Intelligence suite of product in Healthcare Domain Role and Responsibility - Managing onsite and offshore teams and collaboration.  Managed implementations using Agile Methodology. Involved in Sprint Planning, Backlog Creation, retrospectives. Requirement gathering and Analysis - Collaborated with clients to determine project specifications and scope. Development and design of ETL and data loading mechanism. Managing DB objects. Migration strategy for existing BI platform to other BI platform (BO to SSIS) Client :- Infor Kale Consultants Ltd - Analyst Programmer Thane, Maharashtra • 12/2009 - 12/2010 Team Size:  6 Project Details - Kale Consultants Limited is a leading solutions provider to the global Airline, Airports, Logistics and Travel industry. They have premium segment product for the Airline Revenue Accounting called PRISM which enables the End users to do Adhoc Queries and run the existing reports .KCL has hosting solutions as well as the license services for the same. PRISM catered following Services to the Customer  To run Pre-developed Reports for various departments like Sales, Revenue Accounting and Operational Reports for Airline etc.  Automate MIS reports and Ad-hoc reports for various departments based on the Extraction fired. Training  of the Business Object Product Suite to Fresher and Business Users ❘ Skills Communicating with clients Team leadership Scrum Management Product Management Technical Architecture Data Modeling Agile Methodology Visualization Tools:-. Power BI, Tableau, SAP Analytics Cloud (SAC), Lumira, Design Studio, OBIEE, WEBI, Dashboard Design (Xcelsius) SAP BO CMC, Tableau Server Databases: SAP HANA, Oracle, SQL Server, MongoDB , cosmosDB(Azure) Programming Languages: SQL, Python, JavaScript, NodeJS, Data Streaming Platform: Apache Kafka Data Modeling Tools: - Oracle Data Modeler, Erwin Cloud: - Azure, HCP (Hana Cloud Platform), SAC, EC2 Version controller: - Git, azure Repo. Technical Training ❘ Certification Power BI Essentials Issued By: - LinkedIn Learning CPE 71 Power BI Desktop Issued By: - LinkedIn Learning Learning Python Issued By: - LinkedIn Learning ❘ Clients ABB Genix Analytics Suite [Product] StatOil Norway (Onsite) Ragas Qatar (Onsite) Petroleum Dept. Oman (Onsite) SMC Oman (Onsite) Holy Frontier US Smart DCC UK PETRONAS Malaysia Varanasi Smart City Cairn India ICICI Bank ICICI Securities Japan Airline British Midland Airways ❘ Education Shailesh J. Mehta School Of Management Mumbai, MH • 2010 EGMTP: Management Sardar Patel College Of Engineering Mumbai, MH • 2007 B.E.: Mechanical Notice Period :- Immediate Joinee Understanding the requirement and Business logic from business user and Business logic. Deployment of the Business Objects and security Setup at Client Side.(Windows Server ) All Kind of the Admin Work. (Folder Creation , Folder level Security , User Creation, Groups, group Level Security ,Application Level Security, Licensing) Worked on Customization of the Infoveiw for the proper display of the product logo of the PRISM. Understanding the Database structure, Design and deployment Universe using Business Objects Designer. Complex Universe Design is handled including the linked Universes and Aggregate awareness for Performance tuning Creating Deski or Webi reports as per the user requirement. Creating Free hand SQL reports Using Deski. Optimizing the reports, Performance Tuning of the reports Project related Documentation Itree Consulting PVT LTD (Previously Idecisions India PVT) - BI Consultant Andheri, Maharashtra • 02/2008 - 12/2009 Projects :-   ICICI Prudential  (MIS Department)                   Duration: Feb 2008 - Aug 2008                   Team Size: 3 ICICI Securities                    Duration:  Aug 2008 - Dec 2010                   Team Size: 2 Role and Responsibilities Understanding the requirement and Business logic from business user and Business logic. Understanding the Database structure, Design and deployment Universe using Business Objects Designer. Creating Deski or Webi reports as per the user requirement. Creating users and handling security related issues. Creating automated Crystal  Xcelsius Dashboards using  Live Office Project related Documentation