Designed the Data integration solutions with the development ofvarious components using Azure Data Factory and Azure Cloud Service. Defined detailed approach for major programs like General Data Protection Regulation (GPPR), Data Minimization, StudentData Integration Program and various Data Integration for the Performance Marketing platform.Design and developed Customer Churn and LTV predictive model using Linear regression for customer retargeting. Developed the CI/CD automation framework using TeamCity & Octopus for Data Factory (V1/V2), Worker role and Web Role using ARM template, C# and PowerShell scripts.Provided solution for the implementation of tools to identify vulnerabilities in the solution and block packaging (integrated with the CI pipeline) enhancing the application security.

Data Quality Engineer

Ø Data Analysis of source system and defined data models & data mapping

Ø Documented the data standards, data flows and conceptual data flows to identify the improvement in the physical data flow of the system

Ø Technical lead owning the support of the live system and End-to-End solution of the critical core Legal Service Data Store System built using Oracle Pl/SQL which integrates various source systems and provides data to front end system

Ø Defined and Developed the Data Subscription framework to enable secured data pull from the data store system by various systems

Ø Defined Strategy for the Integration of Data of the Data Store System with the C++ based Middle ware system which provides the data to front end system

Ø Analyzed and defined the data recovery of the Data Store and data sync-up approach with the Marklogic based new application system

Ø Provided technical assistance to the teams across product lines in SIO for database related issues

Ø Created proof of concept (POC) and test scenarios for critical projects like Oracle 11g upgrade and changes related to IP address upgrade

Ø Analyzed the requirements as part of the enhancement projects to provide the estimation along with project plan and high/low level solution design

Ø Performed peer review of the documentations and resolutions provided for the production support tickets

Ø Managed the quarterly as well as out of plan releases to production, this includes activities like interaction with release management, testing team, code deployments, defect fixes to CERT environment

Ø Involved in facilitating project review process at Design, Build and Testing phases

Ø Managed and maintained the core Legal Service Data Store System to ensure ZERO feed break and feeds run within SLA defined. This provided on time sync up of the upstream and downstream system

Ø Performed Data Mining and provided the data for the KPI defined by the operations team

Ø Created and presented Weekly Status Report and maintained the issues & risks tracker along with the mitigation plan

Ø Prepared and presented the application capabilities and innovation ideas to client for future transformation and simplification of the system

Ø Designed and Developed automation tool for “Database Feed Monitoring” using "Oracle Jobs" and C# which reduced daily maintenance effort and also helped in major data migration. The tool was shortlisted in the top 5 innovations

Ø Prototyped the data lineage framework starting from source system to target. This helped the source system identifying any data lineage issue by exposing the data related issues online

Ø Documentation of the workflows of the applications and thereby built a database with the business rules of the application

Ø Analyzed and Re-written three major VB 6.0 applications to C#.net and deployed into live environment with zero post production defects in short period. This was achieved with expert analysis of the application and designing capability

Ø Provided estimation and analysis related to enhancements and migrations of various applications

Ø Prepared high/low level technical specification document, Impact analysis document and test case for the application upgrade and enhancements

Ø Provided peer review of the unit test cases, system test cases and analysis documents of various enhancement

Ø Interacted with client to clarify queries and project document reviews

Ø Mentored team members and provided training to team to handle any new challenges in the projects

Ø Identified and reported any major risk in the project to the stakeholders on time

Ø Prepared weekly and monthly status reports

Ø Maintenance of the quality document and monthly metrics collection

Ø Expert analyst with the ability to quickly understand complex application design which helped uncovering and fixing important performance issues and integration issues related to the data migration projects

Ø Identified and fixed key issue in the integration of the Oracle databases of heterogeneous environment which improved the performance of web system

Ø End-to-end Designing and Development of 12 of the 18 modules of major multi-tier application system for Textile ERP system with technologies like C#, ASP, VB, Oracle, SQL Server

Ø Developed Cotton Stock Management and Payroll modules and incorporated unique location independent features which enabled the modules to be implemented in multiple location across locale

Ø Analyzed, Designed and Developed Sales, Electrical & Mechanical Maintenance and Production modules

Ø Integrated all the modules with the critical Costing module to generate critical MI reports

Ø Prepared and executed test cases for all critical modules

Ø Integrated the daily transactions of all the systems with Accounting system as part of system integration process

Ø Presentation, training and documentation of all major systems to the end users of the company

Ø Performance tuning of critical Payroll system in which the low processing time of batch process for attendance and pay slip generation was optimized to improve the performance of the system by 88%

Ø Developed complicated Wheel-Change Calculation Settings for Quality Control department to integrate the machine data with the Maintenance module as one of the special features of the system

Ø Designed and developed efficient Stock Process and Spin Plan Management System which was much appreciated by the user and Sr. management of the company