Vivek Singh

Senior Application Developer @ Wawanesa Insurance

About

With over 13 years of experience in cloud ETL modernization, data integration, and financial system transformation, I’ve built my career at the intersection of technology, analytics, and business impact. From leading Informatica PowerCenter to IICS migrations to designing data pipelines that power decision-making across finance, claims, and compliance, my focus has always been on making enterprise data more accessible, accurate, and actionable. At Wawanesa Insurance, I’ve led multiple modernization initiatives — from mainframe-to-Guidewire migration to BlackLine automation and IICS cloud transformation — each delivering measurable results like 40% faster processing, 25% higher data accuracy, and reduced operational costs. My experience bridges ETL architecture, AWS and Oracle data platforms, and BI ecosystems such as Power BI and MicroStrategy, translating technical complexity into strategic outcomes for stakeholders. I believe great engineering is not just about code — it’s about collaboration, accountability, and foresight. Whether mentoring developers, optimizing performance across hybrid platforms, or automating QA regression, I bring a mindset of continuous improvement and a passion for building data solutions that enable smarter business decisions.

Country

Canada

City

Winnipeg

Industry

Insurance

Skill

Informatica IICS, PowerCenter, Cloud ETL, AWS (RDS, Redshift), Teradata, Data Integration, Data Governance, ETL Optimization, API Integrations, Guidewire, Microsoft Power BI, MicroStrategy, Agile Development, Project Leadership, Financial Systems, Fraud Analysis, Automation, AI for Operations, PL/SQL, Project Management

Experience

Senior Application Developer

Wawanesa Insurance

2018-6 - Present · 8 yrs 4 mos

Winnipeg, Manitoba, Canada

Building cloud-native ETL and data integration frameworks that power insurance finance, claims, and compliance reporting. Leading modernization of enterprise data systems through Informatica IICS, AWS, and Oracle platforms — enabling faster insights and reducing operational overhead. Partnering across actuarial, finance, and technology teams to drive reliable reporting, fraud detection analytics, and regulatory compliance initiatives. Delivered major transformation programs such as IICS Cloud Migration, BlackLine automation, and Credit Score Reporting, improving data accuracy, audit readiness, and time-to-market for financial decisions.

Application Developer II

Wawanesa Insurance

2014-5 - 2018-5 · 4 yrs 1 mo

Winnipeg, Canada Area

Contributed to enterprise-wide modernization under the Strategic Systems Renewal (SSR) initiative, supporting migration to Guidewire InsuranceSuite. Designed and maintained complex ETL workflows across multiple data domains, optimizing performance and enabling scalable reporting solutions for claims and policy data. Recognized for technical excellence and reliability, promoted to Senior Application Developer to lead modernization and automation projects across financial systems.

Senior Etl Developer

Capegemini Consulting India Private Limited

2012-5 - 2014-4 · 2 yrs

Pune Area, India

Developed and optimized ETL processes for large-scale data warehousing and regulatory reporting for the Barclays fraud and risk division. Collaborated with global teams to translate business rules into data-driven solutions, ensuring data accuracy, compliance, and reporting integrity. Improved system performance and reduced manual reconciliation through automation and process redesign. Enhanced stakeholder satisfaction by delivering consistent, audit-ready data solutions across business functions.

Software Engineer

TATA AutoComp Systems Ltd

2011-5 - 2012-5 · 1 yr 1 mo

Pune Area, India

Supported ETL and reporting development for enterprise applications within the BFSI sector. Contributed to the design and execution of data pipelines, ensuring reliability and performance in production environments. Built a strong foundation in SQL, data modeling, and enterprise data flow design, setting the stage for a career in ETL modernization and analytics.