Client : GoogleAutomation & Transformation

Clients: Google, GonukkadProcesses: GPay (A Google Product), Gonukkad (MEC)• New process setup (Gonukkad): Worked with management on logic building to measure KPIs and developed end-to-end data pipelines and infrastructure in GCP.• To fetch lakhs of rows of data using APIs, web scrapping and DB connectors. Automated ETL Pipelines in python to ensure timely data ingestion in cloud storage for business reporting and KPIs which results in increase in overall ingestion time by 45 Percent.• Engineered and optimized various table views in Azure database, streamlining data accessibility and analysis efficiency to reduce query time and enhancing overall data management processes.• Conducted comprehensive research and analysis to uncover two critical software bugs, leading to therecommendation of implementing an automation-driven process within the development team, resulting in increased efficiency and reduction of manual workload.• BQ logic building & dashboard development in looker studio: Business Profile Performance, Merchant Calling, Growth Comparison, Top Performing Merchants, Ops violation, service level agreement (SLA) etc

• To develop and manage ETL pipelines through primary and secondary data sources, resulting in reduction of data retrieval time by 30 percent and errors by 20 percent.• Logic building for any new/existing business KPIs with CFT managers to meet the business goals.• Facilitated seamless operations and technical workflow by generating ad hoc reports tailored to specific needs, ensuring timely insights for informed decision-making.• Developed Outward and Sales performance dashboards in metabase. Which results in orders breach avg. reduction by 4 percent across the warehouses.• Worked with team to prepare and reconcile client’s monthly billing data.

• To Collect and Analyze Data for MIS, Kaizens, COPQ, Rejection etc and present insights to Plant Management.• To Undertake regular Internal Process, Product Audits and verify Closures for Non-Conformities found.• Identify control gaps in processes, products and system through in depth research. Suggested inputs for improvements.