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 layer• 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 • 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 layer• 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 store• Designing the technical architecture for the data lake needed to source the source file using the AWS S3• Creation of the integration architecture to deliver the source data to operational data store using AWS Glue• Use of AWS crawler for creation of data lake meta store and using AWS Athena for querying the data lake• Technical design of the operational data store using Snowflake as the database • Creation of data ingestion to the data store using bulk upload using Snowflake Copy Command• Designing continuous data ingestion using data pipeline and using data stream• Scheduling of regular data stream using Snowflake tasks and snowflake scheduler• Creation of temporary, transient and temporary tables to support the data storage• Creation of views/ secure view and materialized view to support business layer and consumption layer• Creation of cluster keys for effectively using micro partition for table with large data sets • Creation of stored procedure and user defined functions for supporting the creation of business layer of data store•Implementation of time travel and failsafe for data recovery strategy •Implementing column level dynamic data masking for data security along with RBAC implementation •Creation of reader account for securing data with other non-snowflake user for data analytics purpose and creation of data share for snowflake user within the account Show less

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 • 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 application for Finance and Risk for AWS Implementation• Setting up of OneSumX application for risk and finance using Amazon EC2 instance and utilizing S3 storage for application file storage• Performance Testing of the application and configuring the OneSumX system to meet the client defined SLA.• Integration of OneSumX application with upstream and downstream system using ETL transformation (Informatica 10.1) and utilizing MFT (Managed File Transfer) for file transfer• Creation of Disaster strategy document and performing DR activity to ensure application availability in case of any disaster.• Creation of Expected Credit loss reports using SQL Server Reporting Service • Installation of the SAP Business Objects and setting up the Universe for the SOX reporting• Creation of data analytics reports for SOX reporting using SAP Business Objects• Deploy latest application code and application site specific release to sub production and production environment using GitHub and following change management policy.• Audit Support for Expected Credit Loss and FAS91 accounting policy and coordinating with external auditors for ensuring application compliance.• Application migration for the OneSumX application (Finance and Risk) from on premise to AWS infrastructure• Design and Planning for the secure application data transfer from on premise to AWS using AWS S3 Show less

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 • 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 Creation Request document to setup the infrastructure for Vertex O Series installation and deployment in Amazon Private Cloud (EC2) and in-house client infrastructure• Installation of Vertex O Series and configuration of the application to integrated with ERP systems.• Setup taxpayer, taxability driver, customer setup, taxability mapping and conditional mapping in Vertex O Series• Creation of flexible fields, tax assist rules (pre and post condition rules), lookup tables, user defined tax rules, user defined max tax rules and user defined basis rules.• BCI data configuration and scheduling of tax journal jobs and tax data export jobs• Vertex O reports setup and scheduling of the returns report file required for tax filing.• Exemption certificate setup and managing of customer certificates using Exemption certificate manager present in Vertex O Series• Unit Testing of the configured Vertex O Series application based on requirement for motor vehicle lease sales tax determination.• Defining the data elements required for integration with ERP systems.• Data Migration Strategy for migration of sales and use tax related data fields from Legacy system to new ERP systems.• Integration of Vertex O Series with contract origination system for lease origination and integration of Vertex O Series with lease servicing system to support contract lease servicing till end of term.• Participate in integration testing and provide data required for integration testing involving Vertex O Series Show less

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 • 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 application.• Discussion with technical team regarding the integration of Vertex O series in client environment• Working with business to identify all the data elements related to Vertex O Sales Tax determination.• Capacity planning required for Vertex O deployment and performance testing planning.• Coordination with Infrastructure team to create plan for deploying Vertex O application.• Analyzing the sales tax discrepancy for current state by using the Vertex Batch Client Interface Utility• Creation of Migration Strategy Document related to Vertex O Integration Show less

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 • 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 users in the Netezza Database• Monthly patch update and placing of monthly data files for vertex 6.0 application.• Upgrade of the PTMS 5.2 application in sub production and production environment• Creation of EFile upload process for loading tax bills in Lease Tax Administrative solution (LTAS) application.• Designing and construction of Asset Backed Securitization (ABS) system jobs for update of insight data in ABS Retail Database• Creation of audit reports related to Lease Tax Administrative Solution (LTAS) application Show less

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 • 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 provisioning using Sec1• Creation of Oracle Database backup method and creation of database backup schedule Show less

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• Implement automation and enhancement for web-based reporting portal.• Coordination… Show more • 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• Implement automation and enhancement for web-based reporting portal.• Coordination with team associates for incident closure.• POC related to masking of PII data in sub production environment using Data Masking Tool Show less

Banchelor Of Engineering, Computer Science And Engineering

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