Prathamesh Kamath Email & Phone Number

Bengaluru, Ka, In

-Conducted a Proof of Concept (PoC) comparing the performance of Qlik Replicate with Informatica PowerExchange, resulting in the selection of Replicate. This decision led to cost savings of 10% and reduced development effort by 40%.-Setup, development and administration of Qlik Replicate for real-time change-data-capture, reducing load times of large volumes of data by 70%.- Redesigned and streamlined the data flow architecture for Advanced Supply Chain Planning (ASCP) by replacing Informatica with Qlik Replicate, resulting in 70% reduction in load times and increasing SLA compliance to 99%. This innovative and highly-efficient design was recognized with the Wabtec Technology Excellence Award 2024 in the category of Design Excellence.-Employed the Qlik Enterprise Manager Python API to create Python scripts for diverse Replicate automations, including external job scheduling, metadata collection, task migration, and backup operations.-Developed essential QlikView dashboards for Finance, including the AP Global Metrics Dashboard and the Coupa On-Hold Invoices Metrics. Additionally, crafted multiple dashboards for PLM utilizing data extracted from the Teamcenter database.-Design, Develop and Implement ETL workflows in various ETL Tools (Informatica PowerCenter, Qlik Replicate, Informatica PowerExchange) for various domains (Supply Chain, Finance, Engineering PLM).-Writing Complex SQL/PLSQL queries to extract, transform and load data into Oracle Data-Warehouse.-Collaborating with Business stakeholders to understand reporting requirements and translating them into KPIs/Visualisations using tools like QlikView.

Contributed to the development of the Master Data Management Platform being developed for the data storage of the company.-Developed Triggers, Functions and Constraints using Java and TIBCO EBX Libraries.-Developed Database Schema Files for Tables using XML.-Used Web Application for creation of Data spaces and Views, Testing of Permissions and SOAP/REST Data Services and Creation of Workflows.

- Developed a Human-Computer Interface (HCI) application to control mouse movements and clicks using facial expressions to improve accessibility, using Python and OpenCV.- Developed Video Conferencing web solution using HTML, CSS, JavaScript and Django Framework. Features include Video Call, Text Chat, Screen Sharing with Annotations, and Co-Browsing.