AMOL VIKAS PATIL - Portfolio
Loading...
Image

Amol Vikas Patil

Chief Manager , Tech Delivery

About Me

As a Data Warehouse and Business Intelligence professional, I bring over 13 years of experience in designing, building, and maintaining enterprise data warehouses and Business Intelligence platforms. My career has been defined by my dynamic and results-driven approach, particularly within the Insurance sector. I have successfully led numerous DWH projects, managed data warehouse operations, and ensured data integrity, consistently delivering high-quality results.

I excel in mapping client requirements and collaborating with various stakeholders, including Service Providers, Managers, and Consultants, to develop, transition, and customize processes that align with specified guidelines. My expertise extends to Project Delivery, where I offer robust support in Data Warehousing, Data Lake, Business Intelligence, Analytics engagements, and Data Governance. I am adept at handling regulatory, compliance, financial, underwriting, operations, and reinsurance processes in the Insurance domain, providing comprehensive solutions that drive efficiency and productivity.

Recognized for my interactive and motivational leadership, I have successfully directed cross-functional and multi-cultural teams, leading, coaching, and mentoring team members to achieve optimal productivity and resource utilization. I am committed to leveraging my skills and experience to help organizations build and maintain state-of-the-art data warehousing and Business Intelligence platforms.

Name: Amol Vikas Patil
Degree: Bachelor of Computer Engineering
Experience: 13+ Years
Phone: +91-7977469094
Email: amolpatil1059@gmail.com
Address: Palava phase 2 Dombiwali, Maharashtra, India (421204)

Core Competencies

Data Warehousing & ETL Development

95%

Business Intelligence & Data Visualization

90%

Data Governance & Quality Assurance

85%

Data Modeling, Migration & Integration

90%

Project Management & Execution

95%

Client & Stakeholder Management

85%

Experiences

Chief Manager - Tech Delivery

ICICI Lombard General Insurance, Mumbai | January 2023 – Present

As the Chief Manager of Tech Delivery at ICICI Lombard General Insurance, I spearheaded the transformation of our daily reporting process, ensuring the seamless delivery of approximately 200 reports to various channels. This significant improvement enhanced operational efficiency and data accuracy. My leadership in migrating all reports to the Informatica Cloud from the legacy Informatica system was pivotal in modernizing our reporting infrastructure, resulting in improved performance, scalability, and reliability of our data processes.

Enterprise Data Manager

SBI General Insurance, Thane | February 2022 – December 2022

Reduced the DWH refresh time, also created recon for different claims systems. Administered end-to-end operations from business requirements gathering to PowerBI dashboard preparation. Managed existing data warehouse as well as led the new system data warehouse design including business interaction, requirements gathering, and coordination with the team for effective system development and implementation.

Corporate Manager - DW

Reliance General Insurance, Mumbai | November 2020 – February 2022

As the Corporate Manager for Data Warehousing at Reliance General Insurance, I played a critical role in enhancing our regulatory reporting functions. I successfully streamlined these processes, ensuring timely and accurate compliance with regulatory requirements. Additionally, I developed and implemented an innovative in-house application, akin to a regulatory reporting tool, which significantly improved our data management capabilities, reduced manual effort, and ensured higher accuracy and reliability in reporting.

Manager - IT

Tata AIG General Insurance, Mumbai | August 2010 – October 2020

Directed & administered multiple projects including Data Lake Implementation, Qlik Implementation, Cognos Migration, Sybase IQ DWH, New System ETL, and Data Mart Design. Prepared P&L reports for generating necessary financial information to determine profitability and help the Finance team to close P&L on the 3rd of the month which were earlier closed by the 10th of every month. Created reporting dashboards for top management for taking strategic decisions. Communicated with key business users for gathering business requirements, developed logic in SQL, and created store procedures for future use for regulators and internal auditors. Developed Reinsurance reports which are sent to Reinsurers by the company.

Projects Undertaken

Cognos 7 to Cognos10 Migration

Successfully migrated from Cognos 7 to Cognos 10, enhancing reporting capabilities and system performance.

DWH Implementation in Sybase IQ

Implemented a Data Warehouse using Sybase IQ, improving data storage and retrieval efficiency.

Qlik Sense Implementation

Implemented Qlik Sense for advanced data visualization, providing interactive and insightful dashboards for business users.

DataLake Implementation

Led the implementation of a Data Lake to consolidate and manage large volumes of diverse data for analytics.

DWH and Data Marts in Oracle

Developed and maintained Data Warehouses and Data Marts using Oracle, facilitating efficient data management and reporting.

Regulatory Reporting in SSIS

Streamlined regulatory reporting processes using SSIS, ensuring compliance and accuracy in reporting.

Operation Journey with Oracle, ODI, and PowerBI

Managed an operational journey project integrating Oracle, ODI, and PowerBI, enhancing data operations and visualization.

Key Relationship Group Reporting Informatica, IICS

Successfully developed comprehensive reporting for the Key Relationship Group and successfully providing an actionable insights to stakeholders.

Education

Bachelor of Computer Engineering

Pune University

Graduated with a Bachelor of Computer Engineering from Pune University in 2008, equipping me with a strong foundation in computer science principles and engineering practices.

Contact Me

Feel free to reach out! I'm always open to new opportunities and collaborations. Let's connect and explore how we can work together to achieve great results.

© Copyright Doledgeindia. All Rights Reserved.