Vivek Pant Email & Phone Number

Waxhaw, NC, US

• Analyze and document the requirement for the existing applications on MapR prior to their migration to the cloud.
• Collaborate with IT Architects to implement cloud data management best practices in an agile environment.
• Develop the Conformed/Refine/Publish zone layers zone by rewriting existing SQL code in Snowflake using DBT models.
• Conformed zone - These views are subsets of required fields for the business function warehouse.
• Refine zone - To integrate, cleanse, and enrich data with additional attributes, restructuring and integrating it. This zone stores intermediate data during transformation as transient tables, while Snowflake permanent.
• Publish zone - to hold data in 3NF or denormalized form, with a semantic layer of views to insulate users from the underlying table design.

Paris, France, FR

Paris, France, FR

Paris, France, FR

• 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.

• 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.

• 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.

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.

Paris, France, FR

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.

Paris, France, FR

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.

Paris, France, FR

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

Noida, Uttar Pradesh, IN

• 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.

Plainsboro, New Jersey, US

• 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.

West Delhi, IN

• 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.

New Delhi, Delhi, IN

Worked on MIS project.

Mca

Graduation, Bachelor Degree