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

Designed and Developed the Data integration solutions using Azure Data Factory and Azure Cloud Service Assessed the CRM platform and defined detailed approach for the Azure tech stack for the platform which includes major programs like GDPR, Data Minimization, SV Data Integration Program and Customer Data Platform Integration Developed the CI/CD automation framework using TeamCity & Octopus steps for Data Factory (V1/V2), Worker role and Web Role using ARM template, C# and PowerShell scripts Integrated the test automation suite in the project CI/CD pipeline thereby enabling Continuous testing in non-Prod environments Enabled automated test execution reporting using Specflow/ Pickles and BDDfy for individual build in the project pipeline and dynamic stub for system testing automation using Azure Function and Sandbox Provided sprint Demos and program level Demos of the story to the Business Stakeholders, Program Stakeholders and Project teams Performed Static testing of the features during refinement ensuring completeness of the solution and provide early feedback with no critical defect leak during test execution Defined the path to live and lifecycle for the project along with the automation strategy for real time and batch data integration Coordinated with various platform teams for the environment setup to enable E2E integration testing and with the Campaign management team as well as upstream teams for the User Acceptance Testing and Triage Production Issues Design and implemented Customer Churn and LTV predictive model using Linear regression for customer retargeting 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 Defined the approach and performed the Performance testing for different components of the platform along with enabling Automated Early-Performance Testing in the project pipeline before releasing to live environment Implemented various process improvement initiatives to improvise faster and quality delivery by ways of early feedback