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 tables store the transformed data.• Publish zone - to hold data in 3NF or denormalized form, with a semantic layer of views to insulate users from the underlying table design.• Ensure usability and functionality testing of existing data management platforms to align with business strategy.• Actively participate and drive daily project standups and checkpoint calls.• Coordinate SIT, UAT, release, and deployment activities.

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.• Regularly engage and consult with stakeholders to solve business problems through data, guiding the conversation rather than following orders.• Identify, design, and implement internal process improvements such as automating manual processes, optimizing data delivery, and redesigning infrastructure for greater scalability.• Create and maintain optimal data pipeline architecture for data ingestion and curation.• 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.• Possess strong knowledge of enterprise tools such as JIRA, ALM, and ServiceNow.

• 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.• 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.Responsibilities:1- Understand Business requirement with the help of Design Solution Document.2- Active participation in daily Technical session held for requirement clarification with all the Development/Business stakeholders.3- ETL development using Informatica 9.0, SSRS Reports development and integration with .NET Application.4- Worked on Database objects i.e. Views, Materialized views, Indexes.5- Worked on Performance Optimization for respective database objects using Execution Plans, Table Partitioning, Indexes etc.6- Coordination with offshore development team.7- Unit and System-Integration Testing.8- Deployment support.

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

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

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