> INITIALIZING PORTFOLIO v15.0
Daniel
Mangalraj Andrews:
Data & Cloud
Engineer
Building scalable data solutions and leading Guidewire implementations. Expert in ETL, Data Warehousing, Azure, and Insurance Data Management.
> INITIALIZING PORTFOLIO v15.0...
> ACCESS GRANTED.
$
Data Expert & Cloud Architect
Building modern data pipelines and managing complex insurance data infrastructure.
Data Expert
& Cloud
Architect
I'm a seasoned Senior Consultant with 15+ years of experience leading Guidewire Data Management implementations and complex ETL-driven transformations in the Property & Casualty insurance domain. I specialize in migrating and modernizing legacy systems into the Guidewire Cloud, delivering scalable data solutions that align with business goals and regulatory needs.
My passion lies in using data and AI to drive operational efficiency and innovation. I enjoy solving complex data challenges that power insurance transformation and help teams make smarter, faster decisions.
Data is the new oil, but like oil, it must be refined to be valuable. The true power lies not in collecting data, but in transforming it into actionable insights that drive business decisions.
— A Data Professional's Perspective
Tech Arsenal
DATA ENGINEERING
TOOLS & PLATFORMS
CLOUD & INFRASTRUCTURE
ANALYTICS & BI
LANGUAGES
Selected Works
2010-2025Senior Consultant
3+ years
Led the end-to-end delivery of Guidewire DataHub migration from on-premise to Guidewire Cloud, ensuring alignment with latest platform versions and best practices.
- Played multiple roles including Lead Developer, Scrum Master, and Analyst
- Delivered successful POC for Metabase, enabling self-service analytics and promoting it to production use for business stakeholders
- Guided development teams on scalable ETL practices, performance optimization, and DataHub extensibility
- Actively contributed to agile planning, sprint delivery, and stakeholder demos, bridging tech and business
Associate Consultant
5 years 6 months
Leading ETL development for a major insurance transformation program, extending Guidewire DataHub to support downstream needs and enabling migration of legacy policy data into Guidewire PolicyCenter.
- Own end-to-end data modeling and curation to support statutory reporting, regulatory compliance, and accounting needs
- Define and update data mapping specifications for Datahub across Guidewire InsuranceSuite modules
- Provide architectural and technical guidance on ETL design, development, and performance optimization
- Support CI/CD pipeline integration and ensure smooth delivery through version control and deployment practices
Associate
4 years 3 months
Worked on multiple large-scale data integration and migration projects for clients in the Insurance and Financial Services domains.
- Commercial Data Lake Migration – Migrated actuarial and landing data marts to Hadoop/Hive from Netezza
- Customer Analytics Platform – Developed ETL for reporting on VIP and Signature customer segments
- Guidewire Data Management Implementation – Customize and Load Guidewire Datahub and Infocenter tables using SAP BODS
- Claims Data Migration – Converted legacy claims data into Guidewire ClaimCenter for multiple LOBs
Senior Software Engineer
2 years 9 months
Worked as part of the WebApps team supporting a suite of enterprise applications in the Engine Services and Supply Chain domain for a Large US Client in Aviation & Supply Chain Domain.
- Developed and maintained ETL pipelines using Informatica 8.6/9.1 for applications like data warehouses, provisioning systems, and customer communication tools
- Conducted requirement analysis, created mappings, and designed workflows to support business-critical data flows
- Acted as the sole functional resource in offshore capacity, interacting directly with client stakeholders
- Performed code optimization and performance tuning to meet architectural standards
CEO / Freelancer
1 year 7 months
Freelanced as Web Designer, Brand Designer through brochure, posters, logos, invitations & business cards designs and Social Media Influencer.
My Journey
2006-2026Computer Science Journey Begins
Engineering Education
Started Bachelor of Engineering in Computer Science at JEPPIAAR SRR Engineering College.
Entrepreneurial Start
Dansoft Solutions
Founded Dansoft Solutions, freelancing as Web Designer and Brand Designer.
Corporate Career Launch
iGATE Patni
Joined iGATE Patni as Senior Software Engineer, working on ETL pipelines for Aviation & Supply Chain domain.
Data Integration Expertise
Cognizant Technology Solutions
Joined Cognizant, working on large-scale data integration and migration projects in Insurance domain.
Consulting Career
CGI - Associate Consultant
Joined CGI as Associate Consultant, leading ETL development for major insurance transformation programs.
Onsite
CGI - Senior Consultant in Helsinki
Moved to Helsinki to work directly with clients as Senior Consultant, leading Guidewire DataHub cloud migration and delivering comprehensive tech solutions.
Continuous Growth
Data & AI Innovation
Continuing to drive operational efficiency through data and AI, solving complex insurance transformation challenges.
Education
Bachelor of Engineering - Computer Science
JEPPIAAR SRR Engineering College
2006 - 2010Schooling - Computer Science
St. Sebastians
1998 - 2006Certifications
Microsoft Certified: Azure AI Engineer Associate
Microsoft Certified: Fabric Analytics Engineer Associate
Microsoft Certified: Fabric Data Engineer Associate
Microsoft Certified: Azure Data Fundamentals
Microsoft Certified: Azure AI Fundamentals
Academy Accreditation - Azure Databricks Platform Architect
Guidewire Certified Specialist- Datahub and Infocenter Integration - Mammoth
Microsoft Copilot Sales Champion — FY25
Certified SAFe 4 Agilist
Informatica PowerCenter Data Integration 9.x: Developer Specialist
Awards
VALUed Tribe Member 2023
For contributions to the VALU Tribe while working within the Data Team
Platinum Award
APEX Platinum award for quarter two of 2021 for contribution to Guidewire COE and project delivery
Maestro of the Month Award
For contribution to Big data Project by reverse engineering complex Legacy code and coming up with technical documentation
EIM INS R&R Award
Quarterly Award for contribution to Anti money Laundering product implementation for insurance carrier
EIM INS R&R Award
Quarterly Award for contribution to Guidewire claims Conversion
Achiever of the Quarter Award
Quarterly Award for contribution to GAMS project and successful Informatica Version Upgrade
Languages
Tamil
Native or Bilingual
English
Full Professional
Hindi
Professional Working