Vijay Venkatesan
Simi Valley
Summary
Accomplished Technical Architect offering 13 years’ experience in comprehensive design and development of infrastructure and architecture for software projects. Attentive collaborator and communicator from project conception to completion. Creative in devising solutions to improve business operations and meet client’s technical needs. Seasoned team leader possessing the technical and interpersonal skills to provide exceptional project deliverables.
Overview
13
13
years of professional experience
1
1
Certification
Work History
Manager
Capgemini - (On Assignment @ Farmers Insurance)
06.2024 - Current
- Implemented performance metrics to monitor team productivity and drive continuous improvement.
- Facilitated technical training sessions to elevate staff competencies and promote best practices.
- Enhanced customer satisfaction by resolving disputes promptly, maintaining open lines of communication, and ensuring high-quality service delivery.
- Designed and developed scalable data pipelines to streamline data processing workflows.
- Established best practices for data governance, ensuring accuracy and compliance across datasets.
- Developed custom reporting tools using BI software to provide actionable insights for stakeholders.
Senior Data Architect
Tata Consultancy Services - (On Assignment @ Farmers Insurance)
12.2023 - 05.2024
- Provided solutions as part of Metlife claims data migration from source (Charlie, CAF) to Farmers GWCC.
- With a good understanding of existing data structure, quality, and volume and have aided in effective migration.
- Extensively worked on mapping the existing data fields to their equivalents in the Guidewire system, ensuring compatibility and accuracy.
- Extracted data from legacy system using Informatica PowerCenter while ensuring data integrity and security.
- Converted the extracted data into formats compatible with the Guidewire system, which may involve data cleansing, normalization, and transformation.
- Performed initial load of the transformed data into the Guidewire system using predefined data loading mechanisms and tools provided by Guidewire.
- Performed thorough testing and validation to ensure that the migrated data behaves as expected within the Guidewire environment.
Data Archiving SME
Tata Consultancy Services - (On Assignment @ Farmers Insurance)
12.2022 - 11.2023
- As part of the California Privacy Rights Act (CPRA), insurance claim data needs to be archived into Informatica's Data Archive solution. As an SME on the project, I assisted in configuring the Archival, Retention and Legal Hold rules that need to be applied on the claim data.
- Utilized my 10+ years of data archiving expertise to develop the scoping model for proper resource allocation and timeline projections for different programs.
- Created multiple Oracle views and procedures in the source database using data from different tables.
- Provided data archiving solutions for legacy applications such as CUDA, Compass and Facts, which got merged with Farmers Insurance.
- Created materialized views in the archive database, to resolve performance issues experienced in the original reports.
ETL Architect
Tata Consultancy Services - (On Assignment @ Farmers Insurance)
04.2018 - 11.2022
- Interacted with Business partners to identify/understand requirements, design specifications, expectations and vision in key projects like Enterprise Payments Channel (EPCS) and Vendor Integrations such as Mitchell and Enterprise.
- Identified ETL specifications based on business requirements and created ETL Mapping documents and high level documentation for product owners.
- Handled end-to-end development and implementation of reconciliation reports between Farmers Insurance (Guidewire) system and payment vendors (like Paymentech, Hyperwallet, etc).
- Managed code reviews and ensured that all solutions and processes are aligned to architectural specifications and standards.
- Handled App & API Integration of Informatica Intelligent Cloud Services (IICS).
- Developed integrations using IICS - CDI service for 3rd party vendor Integrations.
- Developed Informatica Cloud mappings, Data Synchronization tasks, Data Replication tasks using IICS.
- Worked with API/Web Services using application integrations for 3rd party applications using JSON Web Token (JWT) authentication.
- Configured the IAM policy through the AWS console to securely control access to Amazon S3 resources.
- Developed Source & Target transformations to connect Amazon S3 V2 object to read/write data. Worked with Server-Side Encryption (SSE-S3 & SSE-KMS) Encryption before writing the data to Amazon bucket.
- Extensively worked on XML Parser/generator, Java transformation through MQ messaging systems.
- Implemented a POC using FiveTran - HVR (High Volume Replication) to populate a data warehouse from cloud.
Siebel CRM Subject Matter Expert
Tata Consultancy Services - (On Assignment @ Farmers Insurance)
03.2016 - 03.2018
- Performed configuration and scripting development for Siebel tools to introduce new enhancements and updates.
- Created documentation for managed Siebel environments to support multi-disciplinary development efforts.
- Collaborated with Mule and Sterling Indicator developers to address integration bugs and performance defects in operational assets.
- Analyzed production logs and data for potential issues during troubleshooting investigations.
- Developed monitoring for 3rd party integrations with Inbuilt automation tools like SPLUNK.
- Provided solution using eScripting to develop complex business rules based on client requirements.
- Implemented auto service request creation using workflows and process invocation methods.
- Led corporate-wide initiatives to help guide enterprise and business level goals.
- Worked with team colleagues, internal IT and vendor partner to troubleshoot system issues and verify timely completion of upgrades, resolutions and maintenance tasks.
- Created workflow diagrams and Gantt charts to clearly demonstrate processes and timelines.
Siebel CRM Developer
Tata Consultancy Services - (On Assignment @ American Airlines)
02.2012 - 03.2016
- Conducted tests to identify issues and make necessary modifications. Implemented security measures to protect vital business data.
- Built databases and table structures for Siebel CRM applications.
- Wrote and maintained technical and functional specifications to document database intentions and requirements.
- Actively worked on Siebel EIM task for data migration from legacy system to Siebel.
- Created Inbound and Outbound Web Services via middleware systems to integrate with Airline domain vendors.
- Created batch process to automate retrieval and archival process within Siebel applications.
- Implemented Task UI and EBC's.
- Designed and deployed BIP reports for analytics and airline ticket confirmations. Supported the Siebel upgrade from 8.0 to 8.1.
- Created Business Components, Views, Screens, Audit Trail, Business Objects and EIM tasks to support business requirements.
Education
Bachelor of Engineering - Computer Science
Anna University
04.2011
Skills
- Informatica Power Center
- IICS Cloud Services
- ILM
- Data Integration
- Data Migration
- Data Encryption / Decryption
- Guidewire Claim Center
- OBIEE
- Siebel CRM
- Splunk
- SQL - Oracle/Sybase/Informix
- Unix Shell Scripting
- Autosys / IWA
- Python
- AWS Glue
- DBT
Certification
- Informatica Cloud Data and Application Integration R36
- Certified SAFe 5 Agilist (SA)
Timeline
Manager
Capgemini - (On Assignment @ Farmers Insurance)
06.2024 - Current
Senior Data Architect
Tata Consultancy Services - (On Assignment @ Farmers Insurance)
12.2023 - 05.2024
Data Archiving SME
Tata Consultancy Services - (On Assignment @ Farmers Insurance)
12.2022 - 11.2023
ETL Architect
Tata Consultancy Services - (On Assignment @ Farmers Insurance)
04.2018 - 11.2022
Siebel CRM Subject Matter Expert
Tata Consultancy Services - (On Assignment @ Farmers Insurance)
03.2016 - 03.2018
Siebel CRM Developer
Tata Consultancy Services - (On Assignment @ American Airlines)
02.2012 - 03.2016
Bachelor of Engineering - Computer Science
Anna University
Similar Profiles
LAURA TAYLORLAURA TAYLOR
Auto Claims Representative at MetLife Insurance Merged to Farmers InsuranceAuto Claims Representative at MetLife Insurance Merged to Farmers Insurance
Stephanie RuarkStephanie Ruark
Insurance Agent at Farmers Insurance / United Healthcare InsuranceInsurance Agent at Farmers Insurance / United Healthcare Insurance
LAURA TAYLORLAURA TAYLOR
Auto Claims Representative at MetLife Insurance Merged to Farmers InsuranceAuto Claims Representative at MetLife Insurance Merged to Farmers Insurance
Kyle FullerKyle Fuller
Intern at Pasadena MediaIntern at Pasadena Media
Brandon DevalkBrandon Devalk
Physical Therapist at Bartley Physical TherapyPhysical Therapist at Bartley Physical Therapy