Abdul Hai Hazari

• Definity Financial, a forward-thinking Auto and Property insurer, embraced innovation by modernizing its data and claims systems. This involved migrating from traditional mainframe/SAS/Hadoop environment to Google Cloud Big Query data lake/warehouse and implementing Guidewire Claim Center. The initiative aimed to create a more agile and data-driven organization, better equipped to meet the evolving needs of the insurance market.
• Defined and executed data transformation roadmap aligned with business goals for Claims modernization.
• Led cross-functional teams (onshore/offshore), business stakeholders and senior leadership (Claims, Finance-GL, Actuarial, ICM, BE) to deliver scalable data products using GCP BigQuery, Airflow, and Python.
• Championed data governance practices by implementing metadata and lineage tracking via Collibra.
• Collaborated with senior stakeholders to translate complex business needs into scalable data solutions.
• Prepared Data models to support reporting and analytics for General Ledger reconciliation, broker performance analysis, ICM calculations, and actuarial modeling as per new data source.
• Mentored junior analysts and contributed to team development through coaching and technical guidance.
• Improved data accuracy by 95% by implementing data validation checks and by resolving data inconsistencies.
• Participated in Agile sprint planning, daily stand-ups, and sprint reviews/retrospective to deliver the products in iterative manner using JIRA and Confluence.
• Managed process of data ingestion and transformation to ensure high quality data delivery.
• Documented BI solutions best practices ensuring clear design, development and maintenance guidelines.
• Project: Guidewire Claim Center Data Transformation (Auto & Property)

Project: Investment Management (Manulife Investments Management).

• ML Portfolio Management team leverage underlying equity/Real Estate/Infrastructure data to protect and grow investor assets. Being part of Data Analytics team, Performed Data Migration Engineering Role.
• Collaborated with cross-functional teams to define data requirements and ensure alignment with business objectives.
• Established documentation standards for data models and workflows, improving knowledge sharing within the team.
• Applied different techniques to parse messages (ex: JSON, XML) and perform multiple data manipulations
• Ingested financial markets data via different consumption methods (APIs, SFTP, SQL connectors) through Informatica and Python.
• Analyzed product owner queries and developed multiple cross functional Power BI Dashboards applying agile methodologies
• Managed offshore development teams to successfully migrate 50+ reports to Power BI system
• Prepared data models and performed ad-hoc data analysis using T- SQL, Stored Procedures, Materialized Views to extract business insights from various source of data.
• Worked with different team members applying reporting tool Power BI and ALM to track defects and fix them.
• Mentored junior data engineers on best practices in coding standards and database management techniques.

Project: Healthcare Insurance (SAG AFTRA Plans)

• SAG AFTRA Revenue department manages payroll and claims of different clients involving individual actors and different agencies. Responsible for Data Model preparation, Pipeline investigation, ETL preparation and test cases execution
• Developed data ingestion pipelines to consume XML data for Payroll processing department using Alteryx & Python ETL methodology from Salesforce API.
• Performance improvement of existing ETL flows by identifying bottleneck
• Implementation of T- SQL, Stored Procedures or Materialized Views to extract business insights from data.

Project: Healthcare Insurance (TMG Health)

• Responsible for Requirement gathering, fit-gap analysis, test cases preparation and execution for Green Plum Warehouse ODS transformation project for Claims and Enrollment Department Data
• Implementation of ETL (Informatica) process to ingest data from traditional SQL server to PostgresSql in incremental manner
• Creation of Active Batch Scheduler jobs to run different ETL processes in parallel to optimize time(150+ table load)
• Performance improvement of existing ETL flows by identifying bottleneck (Time reduction of 40%)
• Source File involving XML, CSV and Sql server tables for Claims/Enrollment data.

Project: Pharmaceutical Industry (Sanofi Aventis)

• Responsible for management of data warehouse processes implementation and enhancements (ETL/Reporting)
• Implementation of 3 end to end ETL (Informatica) and Reporting process involving cost worth of 800K USD(Approx).
• Successful integration of AWS cloud, Python, PostgreSQL, Qlik systems for data ingestion and Report analysis
• Creation of different data models following snowflake schema data structure
• Successful data Migration (Clinical) from SAS source system to Oracle (ODS)
• Generated Multiple interactive dashboards in Qlik & Tableau to generate business insights for leadership

• Responsible for preparation of functional specifications, User cases, data model diagrams and ETL solutions.
• Worked with senior leadership for Tableau discovery project to finalize Tableau as Visualization tool for client
• Developed ETL components to load billions of transactional records using Syncsort and Hive technologies.
• Successful integration of Teradata, Syncsort and google cloud technologies to ingest data
• Standardized and automated manual monitoring process to save 80 percent of manual effort for daily activities

• Responsible for preparing technical specifications, test case execution applying agile methodology
• Successful integration of ERP system and informatica to send separate files to different business units (52)
• Performance Improvement of daily/weekly ETL processes i.e Cost and time saving of Client due to better performance.
• Planned, Built and released code as per business requirement for various applications and platforms – Unix/Linux, Windows etc.
• Administered or Managed of Dev/QA server versioning, Software Releases, Code Conflicts, and code Repositories
• Project: Banking and Finance Industry