Gagandeep S. Email & Phone Number

Halifax, Nova Scotia, Canada

As Senior manager I am leading AI & Analytics insurance practice in Halifax with head count of 40 plus. Leadership Role:• Responsible for the growth and maintaining a steady stream of associates in Halifax for project allocation and delivery from Halifax delivery center.• Experience in working with recruiters, delivery managers and client partners on the strategic initiatives of the firm.• Involved in designing and reviewing roadmap for key delivery accounts.• As product owner extensively involved in developing user stories for development teams in conjunction with business use cases.• Lead the design, development, and implementation of data models to support business requirements.Project Role: Product Manager /Business Analyst• Experience working with business users on developing user stories for development teams in insurance domain.• Experience in data modelling using Erwin. Develop current and common data models for Raw and Standard Layers. Well Versed with data modelling standards aligned with Insurance Industry.• Experience in Reverse Engineering model in Erwin using macros, databases, sql scripts etc.• Responsible for standardizing, alignment of project artifacts as per Acord Guidelines.• Enhanced performance of ETL frameworks and database models. Enhanced existing data models based on changing subject areas.• Experience working on Data Vault, Snowflake and Claim Center.• Designed and developed data vault models, including hubs, links and satellites to capture and integrate data from various sources efficiently.• Translated the technical names to business naming conventions following insurance industry standards.• Involved in developing and reviewing the data models with architecture teams and business users to make sure data model is in-line with business requirements.

As the Lead Data Engineer , Designed and Developed CI/CD Pipelines using Kafka, Snow pipe. Led Insurance Data Initiatives of the North Star Adobe , North Star Galileo , SMS Opt In and SMS Webchat .Designed and develop pipelines to place data in the raw and standard layer. Experience in writing complex SQL scripts, stored procedures and ETL packages in Snowflake. Hands on experience in control-m job, Github for Code management, Eclipse for Code deployment. Experience using AWS S3 Buckets, Beak Glass, ESP (Job Monitoring).

Halifax, Nova Scotia, Canada

Role: Associate Director, Data Services Platform (Chief Data Office)Delivery Team Management and Data Governance:o Managed a delivery team based in Halifax, overseeing project execution, team performance, and development.o Led implementation of Data Governance projects in Finance and Risk domains, ensuring compliance and data quality.o Authored team's quarterly OKRs (Objective and Key Results), developed project plans, and escalated risks and blockers to SMT for resolution.o Implemented Agile methodology, conducted backlog maintenance, sprint planning, and retrospective sessions.Key Data Governance Initiatives:Collibra Data Governance Implementation:o Implemented and managed Collibra Data Governance Center, enhancing data quality and compliance.o Implemented data governance policies, standards, and workflows using Collibra.o Conducted data lineage and impact analysis, collaborated with data stewards to maintain business glossaries and data dictionaries.Data Quality Initiatives:o Implemented DQ checks using Information Analyzer and ETL, enhancing data quality framework.o Conducted Proof of Concept for Stewardship center in DQ Exception Console (DQEC).o Enhanced Data Quality Exception handling process, improving performance by 80%.o Reduced execution time from 5 hours to 1 hour using multi-loop architecture in ETL.o Designed and developed reports, dashboards, and analysis using Tableau.o Setup Data Quality Summary, Rules, Exception dashboards, and reconciliation dashboards, implemented KPIs for RTB dashboards.Applications Management and DevOps:o Managed DevOps team for code packaging, DBA reviews, version control, production deployments, and post-production validations.o Centralized source code for 11 project applications, improving efficiency and consistency.o Improved Data Quality batch execution by 30%, enhanced scalability and performance of DQ checks.o Developed and modified data models, ensuring alignment with business requirements.

Halifax, Nova Scotia, Canada

Delivery Team Management:o Managed a delivery team based in Halifax, overseeing hiring, training, and performance evaluations to ensure a cohesive and skilled team.o Implemented Agile methodologies, resulting in a 20% increase in project delivery efficiency and a 15% reduction in time-to-market for new solutions.o Led a team training program on advanced ETL techniques, resulting in a 25% improvement in data processing speed and accuracy.o Successfully navigated team through a complex project phase, achieving a 98% on-time delivery rate and surpassing client expectations.o Introduced performance metrics and KPI tracking, leading to a 30% improvement in team productivity and accountability.Development and Strategic Leadership:o Spearheaded the development of a new platform for non-deterministic testing (NDT) rules for insurance plans.o Extensively worked on FORM 5500 changes in compliance with guidelines from the Department of Labor, US.o Spearheaded the optimization of ETL workflows, resulting in a 40% reduction in processing times and improved resource utilization.o Implemented data quality initiatives that reduced error rates by 50%, enhancing decision-making accuracy for business stakeholders.o Streamlined report generation processes, reducing report delivery times by 25% and improving responsiveness to business needs.o Collaborated with cross-functional teams to redesign database schemas, resulting in a 30% improvement in query performance and data retrieval. BI Development and Technical Expertise:o Engineered BI solutions that reduced dashboard loading times by 50%, enhancing user experience and decision-making efficiency.o Optimized SQL queries and database indexes, resulting in a 40% improvement in database performance and query execution times.o Implemented automated monitoring and alerting systems, reducing downtime by 30% and improving system reliability and availability.

India

• Managed a team that worked for a healthcare client.• Responsible for planning, designing, building, testing and implementing project releases based on business requirements.• Provided management oversight, process review and best practice in all areas of Business Intelligence development and deployment.• Lead activities that include design and development of automated data extraction routines from the central repository for Data Exchange systems using Informatica 9.1 and Teradata.• Lead design and development efforts on unified OBIEE 11g reports, dashboards and data extractions across multiple business units and data sources.• Experience with design and implementation of OBIEE repository (RPD).• Responsible for profiling of data to support business data analysis as per client standards.• Managed large team , escalations, risks, issues and concerns for the project delivery.

India

• BI Solution Development:o Designed and implemented end-to-end BI solutions using Informatica 9.1 for ETL processes and OBIEE 11g for BI reporting.o Translated ETL mappings into Greenplum scripts for optimized data processing efficiency.o Managed version control and deployment of Greenplum scripts across environments using Git-Hub and Jenkins.• Data Integration and Warehouse Management:o Standardized, enriched, and integrated complex data from 6 upstream systems into a centralized Enterprise Warehouse.o Unified data sources to support BI layers for 4 critical business functions, enhancing analytical capabilities.o Implemented enterprise warehouse solutions to provide real-time data for business operations.• BI and Analytics Enablement:o Implemented OBIEE to integrate Customer, Product, and Marketing data domains, enabling data-driven decision-making.o Developed and optimized OBIEE presentation and repository layers for effective data visualization.o Utilized Oracle BI Answers, Dashboard, and BI Publisher to deliver actionable insights to stakeholders.• Data Modeling and Optimization:o Conducted detailed pre-studies to understand input objects from source systems such as SFDC, Eloqua, DnB.o Designed scalable Enterprise Warehouse models capable of accommodating future data growth.o Led efforts in data extraction, cleaning, enrichment, de-duplication, and warehouse population.

India

• Responsible for planning, designing, building, testing and implementing project releases based on business requirements.• Provided management oversight, process review and best practice in all areas of Business Intelligence development and deployment.• Managed the client expectations and ensured the delivery of objects as per the plan.• Lead activities that include development of automated data extraction routines from the central repository for Data Exchange systems using Informatica 9.1 and Teradata.• Part of SME group that provides technical solutions for analytics to various projects as per requirement.• Lead design and development efforts on unified OBIEE 11g reports, dashboards and data extractions across multiple business units and data sources.• Experience with design and implementation of OBIEE repository (RPD).• Responsible for profiling of data to support business data analysis as per client standards.• Managed the people, escalations, risks, issues and concerns for the project delivery.

India