Sakthivel Mahalingam

Gathered business and technical requirements and coordinated with technical peers to implement personalization, recommendation, and decisioning across customer channels. Built Kafka-driven Scala services and implemented data processing with Apache Flink, including schema validation and profiling frameworks.

Implemented offline ingestion to load data files into Redis and publish them for near real-time updates to online offers, rules, and inventory parameters. Developed Scala-based components and Apache Flink API data processing, including XML parsing and dynamic mapping to Redis.

Built and maintained an interface to ingest meter data from large CO2 datasets into the DART system for allocations and downstream Lawson processing. Developed MapReduce and ETL jobs for semi/unstructured data (XML/JSON/Avro), created Hive scripts for baseline generation, and implemented Apache Flink-based data processing with data quality validation.

Delivered CO2 financial analytics by creating executive and board dashboards and publishing KPI reporting through SSRS and Power BI. Orchestrated data pipelines with Azure Data Factory, developed database solutions using Azure Blob Storage, and deployed analytics using Azure Synapse Analytics and SQL Server.

Developed an EHS data warehouse for storing multiple subject areas and supporting detailed financial reporting and risk forecasting. Designed Teradata physical databases and optimized SQL, implemented slowly changing dimensions, and built SSAS Tabular models using Informatica, Star Schema, and DAX with Power BI/SSRS reporting.

Migrated Impact EHS&S data from a legacy vendor system into the Impact application and rebuilt Crystal reports in Power BI for stakeholders. Implemented ETL workflows, created/maintained database objects and users, and optimized SQL and Teradata stored procedures for automated testing.

Analyzed requirements and built the Emission Inventory Tracking solution used to estimate emissions, manage tanks/chemical data, and compare results against permit limits. Developed SSIS ETL packages and stored procedures, modeled star schema for SSAS Tabular cubes, wrote DAX measures, and created Power BI/SSRS reports while supporting production and performing code reviews.

Supported Intel’s iCost initiative to modernize inventory valuation and cost of sales processes by enhancing ETL and reporting for Finance. Created and optimized Teradata stored procedures and scheduled batch processing, and developed analytics reports using SSRS, Tableau, and Vertica-based ETL.

Developed a web services solution to manage Active Directory users and groups, enabling user navigation decisions based on rights. Built secured WCF services using ASP.NET/C# and supported production while performing code reviews and creating database procedures in PL/SQL.

Led an offshore team delivering mortgage admin panel functionality for loan originators and loan servicing workflows. Designed and implemented ASP.NET web forms and supported production, including development with SQL Server, XML/XSL, and JavaScript/AJAX.

Completed a Professional Training Diploma Course at SSI Limited (July 2000).

Earned a B.Sc. in Mathematics from the University of Madras while studying at D. G. Vaishnav College.

Earned an M.Sc. in Mathematics from the University of Madras while studying at D. G. Vaishnav College.

Completed an E-Com course at Zap InfoTech (April 2001).