Sreejith Nair

Data Engineer

Bengaluru, Karnataka, India15 yrs 10 mos experience

Most Likely To SwitchHighly Stable

Key Highlights

Expert in building scalable data pipelines.
Strong background in ETRM and cloud technologies.
Proven track record in optimizing data solutions.

Stackforce AI infers this person is a Data Engineering expert in Fintech and SaaS industries.

Contact

Skills

Core Skills

Data EngineeringCloud SolutionsEtrm DevelopmentJava DevelopmentEtrm ImplementationApplication Support

Other Skills

AlteryxApache KafkaApache SparkAzure ADLSAzure Data FactoryAzure Data LakeAzure DevOpsAzure Key VaultAzure Synapse AnalyticsC#Data WarehousingDatabricksETRMGit BASHGitHub

Experience

Shell

2 roles

Senior Data Engineer

Promoted

Oct 2019 – Present · 6 yrs 5 mos · Bengaluru, Karnataka, India

Designed and built end-to-end data pipelines using Azure Data Factory, Databricks/PySpark, and Azure ADLS for batch processing and data analysis.
Collaborated with data analysts and stakeholders to define data requirements and develop PySpark frameworks for data ingestion, transformation, and materialization to Synapse Analytic DB.
Implemented optimization frameworks for Databricks and Azure Data Factory, resulting in cost savings and improved SLAs for reports and the data platform.
Developed Spark Kafka streaming applications to ingest data from Kafka and integrate it into Spark pipelines.
Integrate diverse data sources, including databases, APIs, and streaming data, into a unified data platform. Implement solutions that enable near-real-time data access.
Analyzed client business processes to recommend optimal cloud data solutions for unique requirements.
Established an Azure DevOps CI/CD pipeline for deploying Azure Data Factory templates, Azure Data Bricks notebooks, and web applications.
Managed and automated code/template deployments using Azure DevOps for data projects.
Designed, tested, and built new and DR environments for data projects, particularly for Azure Databricks and Azure Data Factory.
Collaborated and gave consultation to multiple projects on Azure technologies, Databricks solutions and creating scalable solutions for Data Platform projects.
Created and implemented standard guidelines documents for data projects within Shell
Trading & Supply, improving the efficiency of data pipelines.

Azure Data FactoryDatabricksPySparkAzure ADLSKafkaAzure DevOps+2

Endur Developer

Apr 2017 – Sep 2019 · 2 yrs 5 mos · Bengaluru, Karnataka, India

Worked on Java and Oracle based solution in Endur GPNA to build real time interface between 2 ETRM systems Endur and Nucleus. The interface is used to push financial power trades from Endur (Swaps, Options and Basis swaps) to Nucleus for power trading.
Worked on Java solution to build Nomination report in LNG Endur. This report helps the traders to track the deal from deal booking to scheduling to settlement and invoicing. This solution maps the cargo for the deals in cMotion and generates report which assists the traders in tracking the status of cargoes and deals.
Developed Alteryx and Python based solution to automate report comparison in LNG Endur.
Developed solution for Sonar Qube integration for Endur code check ins.
Developed Auto Nom solution in Endur which creates nomination/scheduling deals based on a physical deals delivery for next month. This solution is run every day during EOD. It creates a COMM-TRANS deal which is nomination buy/sell natural gas physical deals.

JavaOracleETRMAlteryxPythonETRM Development+1

Accenture

3 roles

Openlink Endur Developer

Promoted

Jun 2014 – Apr 2017 · 2 yrs 10 mos

US Based Energy Trading Client : Openlink Endur implementation of Power
The project was on customizing Endur V14 for client’s Power trade using Open Component .NET.
Designed and built the Interfaces and extensions to import Power Volume and Compliance Events handling
Developed interfaces for PPA handling and UDW’s to manage user tables data.
Has worked on Back office desktop for configuration / development of deal events.
Has worked on Trading manager , Operations manager, Reference manager , Admin manager and Services managers.
US/UK Based Energy Trading Client: Application Support and Migration from V10 to V14
Designed and developed major enhancements for Credit Risk Interface for instruments like Power ,Gas.
Developed custom reports on Emissions in Report Builder.
Worked on UDSR scripts to develop custom simulation .
Worked on EOD run production support. Monitoring EOD process and resolving issues if any.
US/UK Based Energy Trading Client : Natural Gas Greenfield Implementation
Designed and built Connex interfaces between Endur and third party AC Control system to fetch forward prices and compare the prices. Provided support and fixed defects in other Connex interfaces
Developed UDW’s to manage user tables data. Also developed a Generic UDW through which multiple user tables can be managed through a single interface.
Developed various Operation Service pre process and post process scripts and also created custom reports using Report Builder.
Worked on EDW data warehouse interface using TPM. The interface loads reference, static , index and transaction data to DW systems EOD and Intraday. Also worked on configuring exception handling flow in TPM workflow.

Openlink EndurPower TradingJavaReport BuilderETRM ImplementationApplication Support

Senior Software Engineer

May 2010 – Apr 2017 · 6 yrs 11 mos

Sungard / CXL Developer

May 2010 – Jun 2014 · 4 yrs 1 mo

Was involved in development and support of ETRM application SunGard Entegrate . Developed applications to get the prices from exchange feeds like ICE , NYMEX and feed into system.
Provided support for End of Day process runs.
Developed processes in Unix Shell script and Oracle PL/SQL to download prices from ISO websites(CAISO,NYISO,NEISO) and load into tables.
Developed solution to monitor the trades that are published from an Exchange or Source like ICE,NYMEX,GLOBEX. The solution checks if a trade has made it to its final destination table in Entegrate or CXL which are the ETRM systems using TIBCO messaging queue.
Worked on data warehousing projects to retrieve data from multiple data sources like Softmar, ZEMA, and NYMEX and aggregate these data into a database. Developed java programs to fetch the prices and other trading information from the price curves.
Worked on CTRM Based Front-Office ETL project for Data Extraction, Transformation & Loading - for initial trading decisions for various commodities like Power, Gas, Oil/Crude, etc from vendors like NRGStream, ZEMA, etc. & from various data publishing sites like WSI, EIA, Bloomberg, Platt’s.

ETRMUnix Shell ScriptingOracle PL/SQLETRM Development