Vivek Pant

• Led a team of engineers to deliver customer-centric data integration and modernization initiatives, reducing latency by 25% and enabling real-time customer profile activation. • Designed and implemented scalable ingestion pipelines (batch + streaming) in Snowflake using DBT and FiveTran HVR, aligning with enterprise data strategy for segmentation and personalization use cases. • Enabled downstream data consumption by MongoDB from Snowflake pipelines, supporting real-time customer profile queries and activation across digital experience platforms. • Enabled downstream data consumption by AWS Postgres using the FiveTran HVR, supporting real-time customer profile queries and activation across digital experience platforms. • Modernized legacy infrastructure by transitioning to cloud-native Snowflake architecture, leveraging Snowpipe and Streams to unify disparate sources (CRM, sales, analytics) into a consolidated data lake. • Partnered with product owners and business stakeholders to translate requirements into architectural blueprints, ERDs, and source-to-target mappings, aligning technical delivery with strategic marketing objectives. • Established data quality and governance frameworks with embedded validation controls, ensuring 99.9% data integrity and compliance with enterprise standards. • Implemented data security protocols using Protegrity and Snowflake Dynamic Data Masking, ensuring compliance with PII and GDPR guardrails across ingestion and activation workflows. • Developed conceptual, logical, and physical data models with metadata, lineage, and technical definitions aligned to ACORD Annuity Standards, enabling standardized reporting and unified advisor insights. • Leveraged Amazon Neptune Graph DB to model complex customer relationships and journeys, enabling advanced segmentation, personalization, and campaign analytics across digital experience platforms.

B2B (Business to Business) was implemented to integrate various RSA Insurance partners and to create a platform that supports quick and effective partner integration. Re-using the existing assets is the main concept behind this implementation. B2B platform integrated IT solutions in a partner environment with RSA solutions via web services. It had partners in personal line properties, commercial line products, and personal & and commercial line vehicles. Key Benefits: 1) The focus in the B2B program has been put equally on meeting the functional requirements of the partners, and on providing a solution that is reusable, configurable and scalable across all layers of technology. 2) Ability to add new affinity partners and hook up to systems in a shorter time frame due to Plug n Play architecture. 3) The architecture reuses already existing assets, keeping the cost down and this would be used for future Implementations. 4) Enhanced customer experience and efficiency. Responsibilities: 1) Keep track of all the Application Development items. 2) Incident Management in HPSM adherence to SLA. 3) Keep track of defects logged in HPQC and defect queue management within the team. 4) Requirement Analysis, Design Creation, Bug fixing, Coding, and deployment. 5) Preparing WSR and MBRs for customers' review. 6) To Create PowerShell-based Deployment scripts. 7) Regular interaction with the Onsite/Business team. Highlights during Project: 1) Maintained high-quality deliverables resulting in several zero defect deliveries. 2) Client acknowledgment for maintaining excellent delivery track.

The Contract Origination Strategic Management Online System (COSMOS). COSMOS is a web-based software application that automates the pricing contract creation and approval process and provides a secure, searchable repository for executed documents for St Jude Medical Inc., USA. Overall system overview: 1) Create new contracts, amendments, and pricing acknowledgments. 2) Route contract requests for approval according to a defined approval hierarchy. 3) View document approval status, revision history, and change request audit trail. 4) Create new contracts with less worry about accidentally creating overlapping contracts. 5) See only the documents they are authorized to see based on their responsibilities or regional or hospital affiliation. 6) View or maintain application data, including: Product floor values Eligible Cross Products sold between the divisions Shipping Terms 7) Contract Rebate Setup. 8) Rebate Processing and calculations. 9) Rebate Reports. Responsibilities performed: 1) Requirement Analysis, System Design, Prototype Creation, Developed webpages, Reports, and ETLs. 3) Created ETLs and Stored Procedures containing complex business logic for Sales Reports and various types of Rebate processing. 4) Direct client coordination. 5) Identifying all possible Unit Test cases and peer review. 6) SIT and UAT support, and bug fixes. 7) Participated in the deployment process for all the environments. Highlights during the project include: 1) Zero defects deliverables.

Experienced in Front-End application development using Microsoft based technologies (ASP.Net, C#, HTML, Ajax, JQuery, LINQ, SQL Server)

Designed and delivered enterprise-scale data lake solutions unifying disparate sources (CRM, call center, transactional systems) to support customer-centric analytics and segmentation use cases. • Implemented data governance frameworks (Collibra, metadata catalogs, lineage documentation) ensuring compliance with enterprise standards and regulatory guardrails (PII, SOX, BASEL III, BCBS). • Developed and optimized relational and conceptual data models (Stage, Raw, SOF) to support scalable customer profile creation and journey analytics. • Partnered with cross-functional teams to translate business requirements into logical data workflows and governance strategies, aligning technical delivery with organizational objectives. • Conduct use case analysis and create Business Requirement Documents (BRD), Functional Design Documents (FDD), Detailed Design Documents (DDD), and SCMP documents. • Collaborate with stakeholders including Data Sourcing, Technical Analysts, Middleware, and AWS Platform teams to resolve data-related technical issues and support data infrastructure needs. • Develop Proof of Concepts (POCs) for new functionalities to meet deliverables. • Design and implement data modeling solutions using Enterprise Standard Out Files (SOFs). • Present and communicate modeling results and recommendations to internal stakeholders. • Perform data profiling and analysis activities to establish, modify, and maintain data models. • Regularly engage and consult with stakeholders to solve business problems through data, guiding the conversation rather than following orders. • Build the infrastructure required for optimal extraction, transformation, and loading (ETL) of data from various sources using HiveQL and AWS-based Big Data technologies, including Amazon EMR (with Apache Hive), AWS S3, AWS RDS (Postgres), Amazon RedShift, and orchestration tools such as Step Functions, Airflow, and EventBridge.

• Build and maintain an enterprise data warehouse platform, including ETL processes and data architecture requirements. • Collaborate directly with Data Architects to develop high-quality data solutions in a collaborative and agile environment. • Define and track project schedules by coordinating with internal and external teams. • Design and build data management solutions based on business requirements, ensuring a seamless transition from development to production operational support. • Provide consulting and subject matter expertise to business units and other internal teams, fostering professional relationships across the organization. • Ensure the ongoing viability, usability, and functionality of existing data management platforms in alignment with business strategy. • Analyze, plan, and define data architecture frameworks, including security, reference data, metadata, and master data. • Research data acquisition opportunities, identifying internal and external data sources, and develop a data management plan aligned with organizational data strategy. • Collaborate with the Chief Data Officers (CDO) group to maintain Enterprise List of Value and User Specific List of Value by integrating Collibra tool application data with the data warehouse to store and maintain reference data. • Use the Collibra tool to maintain List of Value, create and maintain Data Lineages for various data warehouse projects, and ensure technical documentation meets audit compliance and analytical needs to ensure compliance with enterprise standards and regulatory guardrails (PII, SOX, BASEL III, BCBS) • Understand source raw files and relationships from new applications, maintain Business Glossaries, and create and maintain physical and logical data models using the M1 Data Modeling tool. • Work closely with the Data Modeling team to model DWH layers, 3NF data modeling, SCD Type 1/Type 2/Cross Reference/Relationship tables, SIF, and SOF (Standard Input/Output File).

• Plan and strategize by researching, identifying potential problems, and devising solutions to ensure successful outcomes for end users. • Gather and design requirements, interpreting architecture and design while adhering to programming and documentation policies defined by EPLC. • Design data structures to meet business requirements. • Develop an Enterprise Data Warehouse using IBM Banking Data Model, including SCD Type 1 & Type 2 tables for Data Store. • Build Bank Data Warehouse applications using ETL tools such as WhereScape Red and Informatica, and MPP databases like Pivotal Greenplum and Postgres. • Automate ETL jobs using workload automation tools like CA Autosys. • Develop automated processes to capture information from disparate source applications into the Data Warehouse, translating and mapping relevant source values with standardized LOV defined in Reference Data Management tools like Collibra. • Perform query and data profiling using simple to complex SQL statements. • Produce detailed data flow diagrams to demonstrate how data should flow through the system and how it should be transformed. • Optimize performance of poorly performing ETL jobs and stored procedures/functions. • Provide production support for ETL jobs and data-related issues.

The project was a continuation of the initiative whose purpose is integration of the Retirement Plans group of advisors into the oraganization umbrella of systems and services. The primary goal of this project was to help Retirement Plan Advisors to more effectively manage profitability and productivity by creating a reporting system that provides predefined views of combined plan, asset, and revenue data. This will relieves retirement plan advisors of several labor intensive manual tasks they must perform to combine plan data with asset and revenue data. Led the continuation of an enterprise initiative to integrate the Retirement Plans group of advisors into the organization’s umbrella of systems and services. • Designed and developed ETL workflows in Informatica 9.0 and integrated SSRS reports with .NET applications, delivering unified reporting capabilities for retirement plan advisors. • Engineered and optimized database objects (views, materialized views, indexes) to support scalable reporting and analytics. • Improved system performance through execution plan analysis, table partitioning, and index optimization, reducing query latency and enhancing advisor productivity. • Coordinated with offshore development teams to ensure seamless collaboration and timely delivery of project milestones. • Conducted unit testing and system integration testing, ensuring accuracy and reliability of reporting solutions. • Provided deployment support and post-implementation validation, enabling smooth rollout of reporting systems across the advisor network.

Requirements and Analysis, documenting the business requirement. • Responsible for developing End-user-specific Web-Application interfaces using C#, ASP.Net, LINQ, ORM, and Oracle. • Responsible for writing Stored Procedures, UDFs, Cursors & and DTS packages in Oracle. • Unit Testing & Bug fixes.

• Requirements and Analysis, documenting the business requirement. • Responsible for developing End-user-specific Web-Application interfaces using C#, ASP.Net, LINQ, ORM, and Oracle. • Responsible for writing Stored Procedures, UDFs, Cursors & and DTS packages in Oracle. • Unit Testing & Bug fixes.

• Requirements and Analysis, documenting the business requirement. • Responsible for End-User application development using VB.Net, C#, and ASP.Net. • Unit Testing & Bug fixes. • Production Support.

Worked on MIS project.