PROFILEAs a Data Solution Lead, I drive the Engagement with Business units and identify their Reporting and analytics needs. Conduct workshop and document the KPI, Reports, Gen AI use cases. Identify Day to day reporting and historical reporting.Work with a team of Data Architect, Modeler, Business Analysist, Source System SME, lead data engineer & Reporting/Dashboard lead to Develop scope document, Solution Proposal, Solution Architecture Diagram, Implementation Architecture, Sizing & Capacity planning document.Present the Proposal in CXO forum and initiate business case approval and funding approval.As a Data Warehouse Architect, I lead the following activities:Lead the design and implementation of end-to-end Data, Analytics & Reporting solutions for clients. Designed, built and deployed E-2-E Data Lake solution for a large corporation, enabling efficient data storage and retrieval.Help in Developing configurable loading pattern for data warehouse, ensuring flexibility and scalability for multi-tenant Storage & consumption.Involved in the Data Vault Modelling for cross business function products/services, lead a team of engineer to perform Data profiling, DQ checks & approval of Data Models in Data Model forum.Involved in the design & Delivery of large data migration projects, ensures project meets its key milestone on time with quality and Business stakeholders are aware in advance about Milestone deliveries.Help in designing Architecture, Blue Print to Implement multi-tenancy data warehouse solutions for a Large Corporation which helps in optimal resource utilization.Involved in the design and delivery of automated reference data solution, streamlining data management processes.Involved in the ML & Gen AI Solutions for various customers, help to build them a stable data base which helps in training and iterative testing of the ML Models.Provided mentorship and guidance to a large data team, enhancing their engineering skills and expertise.

As a Tech architect/Tech PM I was responsible for below critical Milestones:● Build & Delivery E-2-E Data Integration and Reporting solutions for a Transport & Toll Automation Client for NJ & Florida states. ● Consolidating the KPIs across multiple subject areas (i.e. Purchase order, inventory, Customer, Accounts, Payments, Order processing) into a single BI Portal. ● Data/application analysis, Blue printing ETL Architecture, Data Modelling, Data Migration and help in the design of the BI Dash Boards● Planning of Project Milestone and Delivery● UAT planning, aligning Customer staffs and defect capture, Scope analysis, change management and iterative delivery● Worked as Tech Architect in Zyphor which is Lbrands’s owned product to conduct campaigns and visual dashboard and sentiment analysis on the social media data. With Zyphor, user is able to create templates and based on template multiple campaigns can be created for a period of time. Based on the campaign dates and other specifications data from social media is loaded into Hadoop Platform and ElasticSearch cluster using Spark Streaming. Data is aggregated and queried using presto on top of hive

● Worked as a Tech Architect for the Exchange Traded Derivative (ETD) DataMart, which served as a one-stop Data Warehouse (DWH)/Business Intelligence (BI) solution for users across the APAC and EMEA regions.● Spearheaded the design and maintenance of the information architecture platform for Global ETD trades, ensuring the seamless flow of financial data into the enterprise data repository.● Led the migration and rebuilding efforts for the central Enterprise Data Repository, modernizing the data infrastructure and improving the reliability of financial trade reporting systems.● Played a key role in the development of financial and BI reports, ensuring they met the needs of internal stakeholders across multiple regions.● Designed and implemented an ETL framework to automate the Asia Pacific regulatory reporting requirements, ensuring compliance with local financial regulations.● Developed a packaged ETL solution that included an interface layer with Oracle DB for staging and main tables, significantly streamlining data processing for regulatory reporting.● Integrated the solution with reporting layers using Business Objects (BO) and Unix scripts, enabling seamless data extraction and reporting.● Improved the efficiency and accuracy of the reporting process, reducing manual intervention and providing timely insights for stakeholders.

As a Principal Data Warehouse Lead with extensive experience in the Insurance and Financial Services sectors, I specialize in architecting and delivering scalable, high-performance data warehousing and business intelligence solutions. With over 10 years of experience in the DWH space, I have successfully led the design, implementation, and optimization of multiple data warehouse solutions, focusing on both technical and business alignment.I have worked extensively with Informatica and Oracle technologies, managing data warehousing projects for global insurers. My key expertise includes collaborating with clients' BI boards, project stakeholders, and business analysts to deliver architecture and data solutions that meet organizational objectives and ensure seamless service delivery. Additionally, I have a strong track record in pre-sales and solution architecture, working closely with clients to provide the most effective and cost-efficient solutions.● Led the Maintenance of two independent Data Warehouse (DWH) applications based in Stockholm and Copenhagen for a major Swedish insurer.● Managed the Informatica-Oracle based DWH solution for the Swedish application, where data from various subject areas of the insurer’s OLTP systems were extracted and stored in Oracle DWH for analytical purposes.● Oversaw the integration of data extraction processes using Informatica to ensure data was correctly loaded into the Oracle DWH, enabling real-time business intelligence reporting through OBIEE.● Provided pre-sales support and led solution architecture efforts in the DWH space, collaborating with internal teams and client stakeholders to design and implement tailored solutions.

Worked as Data Warehouse Developer. Requirement analysis and delivery of standard operation reports using SQL/SASAuto Finance Data warehouse is a collection of subject oriented, integrated, time variant non-volatile Collection of data used for management decision making process. The Data Warehouse provides business users the ability to do analysis over time. This helps them to answer various business questions on behaviour analysis, profitability of customers over time, usage and profitability of products, retention of profitable customers and marketing promotions.