Sathya Kesavan

Sathya Kesavan Senior Data Engineer --linkedin.com/in/sathya-kesavan-9343b2ab Trichy, Tamilnadu, India Summary Dynamic and results-driven Senior Data Engineer with 8+ years of experience designing and architecting scalable, enterprise-grade data ecosystems for SaaS, BFSI, and Educational sectors. Proven expertise in building high-performance ETL pipelines, data migrations, real-time analytics platforms, and self-service data solutions that empower data-driven decision-making. Currently leading the development of an Enterprise Data Warehouse (EDW) model, optimizing data centralization, and implementing cutting-edge data governance frameworks to ensure data quality, security, and compliance. TECHNICAL SKILLS Analytical Skill: Data Analytics Data Architecture Data Warehousing Data Visualization Data Modelling EDW/Data Vault Model Data Profiling Statistics Application Integration ETL/Data Pipeline Master Data Management Programming Language: SQL PL/SQL Spark SQL Python Pyspark DAX C# Unix Cloud & Database Expertise: Snowflake Databricks AWS services MS SQL Server Oracle Redshift Netezza ETL & Visualization Expertise: Power BI SSRS SSIS Datastage Domain Skill: Financial Reporting Subscription Based Revenue Model Billings and Collection Expense Analytics CRM Media and Education Banking SOX/ITGC Soft Skill: Analytical & Problem Solving Project Management Technical Trainer Team Player Troubleshooting & Solution Provider Experience Freshworks Senior Data Engineer - Big Data Analytics Chennai, India 02/2022 - Present Cloud-based software company offering customer engagement and business collaboration products. • Leading the design and implementation of a cutting-edge Enterprise Data Warehouse (EDW) architecture that integrates data from diverse sources and processes event streams to generate near real-time, actionable insights. This ongoing project focuses on centralizing organizational data and streamlining workflows to empower faster and support advanced analytics initiatives. • Design and Implemented seamless data integration from various applications into a central Data Warehouse, enabling real-time financial reporting from Rest API or other heterogeneous sources. • Achieved a 57% reduction in book closing time from 12 to 5 days, dramatically streamlining accounting workflow and saving countless human hours as a result of developed application integration solutions. • Led expense analytics development, reducing paperwork by 75%, provided insights on cost-saving opportunities via KPIs. • Automated payroll data pipeline with Python, saving 15 days/month, improved data accuracy, and ensured data governance, data integrity standards and compliance. • Built Power BI dashboards to deliver real-time financial insights, incorporating constant currency analysis to mitigate inflation effects. • Developed key Financial Insights Dashboard in Power BI, visualizing data for earnings reports, supporting stakeholder engagement. • Established SOX/ITGC compliance, enhancing data accuracy and adhering to industry regulations. Mr. Cooper Senior Data Engineer A financial services company that provides mortgage services. • • • • • • • Designed ETL using SSIS packages, eliminating 30+ manual reporting processes. Developed customized scripts using C# to refresh Pivot tables and automated file transfer tasks. Created Power BI executive reports and dashboards based on business requirements. Proficient in writing DAX expressions and derived various measures and calculated columns in Power BI. Optimized stored procedures and database queries, accelerating execution time by 80%. Modeled semantic data models to enable Power BI self-service reports, reducing report requests by 20%. Performed data profiling to identify data quality issues, reducing data quality issues by 30%. Chennai, India 06/2021 - 02/2022 Experience University of Canberra - Wipro Limited Chennai, India Senior Data Engineer 01/2020 - 06/2021 A global information technology, consulting and business process services company and worked for the university of Canberra client located in Australia. • • • • • Designed and developed application integration projects for data synchronization using SSIS and C#. Developed data integration project between Marketo System and Dynamics 365 using plugins. Enhanced Oracle forms and reports and resolved critical business problems. Planned and developed secure file transfer solutions in SSIS to eliminate security threats and manual efforts. Created proofs of concept for solutions such as automatic class notes creation during lectures. HarteHanks - Wipro Limited Chennai, India Data Engineer 05/2017 - 10/2019 A global information technology, consulting and business process services company and worked for US marketing firm. • Enhanced data accuracy through developing business rules for customer data processing solutions. • Improved data migration accuracy by 95% by automating testing with SSIS package for Signal hub cloud technology. • Delivered MSBI platform solutions to develop and deploy ETL and reporting. Lloyds Bank - Wipro Limited Chennai, India Software Engineer 09/2016 - 04/2017 A global information technology, consulting and business process services company and worked for the Lloyd Bank client in UK • • • • Educated in Lloyd banking domain and front end banking sites built on Content Management services. Gained understanding of business processes implemented in Lloyd, Halifax and BOS. Delivered outcomes within agreed deadlines. Contributed to business process and technical specification documentation. Education K Ramakrishnan College of Engineering Trichy, India Bachelor of Engineering in Computer Science Department 07/2012 - 03/2016 Certification Microsoft Certified: Data Analyst Associate Recognized as Microsoft certified: Data Analyst Associate. Key Achievements Streamlined Financial Reporting Reduced book closing time by 57%, saving significant human hours. Enhanced Query Efficiency Optimized queries to accelerate execution time by 80%, improving performance. Payroll Automation Success Increased operational efficiency by automating payroll, saving 15 working days monthly. Built Expense Analytics Engine Achieved 75% reduction in accounting paperwork, enhancing cost control insights.