Ayan Datta Email & Phone Number

Dallas, Texas, United States

Responsible for designing end to end data architecture. Introduction of new methodology and implement best practice related to data warehouse and big data architecture.

Dallas, Texas, United States

• Reviewing and analyzing the existing data architecture for Insurance Data Mart
• Designing the end-to-end data architecture using data vault technique for the new Insurance Data Operational Data Store (IODS). Different layers of design include operational layer, business layer and the consumption.
• Creation of Data Mapping document to map source data field with data store
• Defining the data cleansing and data validation rule for storing the data in the data… Show more
• Defining the data cleansing and data validation rule for storing the data in the data store
• Designing the technical architecture for the data lake needed to source the source file using the AWS S3

Dallas, Texas, United States

• Business Requirement Gather from business related to IFRS9/ CECL and FAS91 guideline.
• Creation of Business Requirement Document for new accounting guideline implementation
• Installation and setup of OneSumX for Finance and OneSumX for Risk in the client environment and creation of integration pipeline
• OneSumX Application migration from on premise data center to AWS cloud infrastructure and automation of future data syncing
• Creation of Architecture Blueprint for OneSumX… Show more
• Creation of Architecture Blueprint for OneSumX application for Finance and Risk for AWS Implementation

Dallas, Texas, United States

• Creation of Functional Specification documents and Configuration documents based on client specific requirements.
• Creation of architecture blueprint document for defining the Vertex O Series deployment and integration in client environment
• Creation of integration specification documents and defining the integration specification requirements for Vertex O series for automobile lease tax
• Vertex O Series hardware sizing and capacity planning documentation
• New Environment… Show more
• New Environment Creation Request document to setup the infrastructure for Vertex O Series installation and deployment in Amazon Private Cloud (EC2) and in-house client infrastructure

Dallas, Texas, United States

• Analyzing the state-by-state methodology for lease sales tax calculation for automobile leases
• Identifying the special state specific tax rules and identifying method of handling the specific tax rules using Vertex O Series
• Preparation of migration strategy for migrating sales tax related data from Legacy system to new Servicing system
• Discussion with business regarding the requirement for sales tax determination and updating the requirements in DOORS… Show more
• Discussion with business regarding the requirement for sales tax determination and updating the requirements in DOORS application.
• Discussion with technical team regarding the integration of Vertex O series in client environment

Kolkata, West Bengal, India

• ETL Process design and development for the reconciliation process related to the Property Tax Management System (PTMS) application and AP check reconciliation process from PTMS to PeopleSoft
• Development of the Integration process between CRS (Cash Receipt System) application and Aveksa Tool
• Provisioning of Automated Security process for Netezza Database by integrating sec1 with Netezza
• Designing and construction of the reconciliation process for migration of data warehouse… Show more
• Designing and construction of the reconciliation process for migration of data warehouse users in the Netezza Database
• Monthly patch update and placing of monthly data files for vertex 6.0 application.

Kolkata, West Bengal, India

• Installation of Vertex 6.0 in sub production and production environment for commercial finance portfolio
• Automation of Unix script for SIC Restart activity related to Vertex 6.0 integration with SAP ERP
• Import and export activity using data pump utility for Oracle Database
• Creation of PL SQL procedures for loading data to oracle database
• Upgrade of Tableau application to 7.0 version
• Automation of Tableau Application Active Directory Synchronization script for access… Show more

Kokata, India

• Designing and implementing web-based portal for report solution to facilitate application performance monitoring and reporting.
• Development of Service Management Tool and Maintenance
• Data Analysis and Coordination
• Development of PL SQL codes related to various web-based project.
• Unit testing and system testing
• Production implementation and maintenance manual creation and update

Banchelor Of Engineering, Computer Science And Engineering

Isc(Indian School Certificate), Physics, Chemistry, Computer Science, Mathemetics