Dipak Jena

Leading Edge IT, London Mar’ 23 – Till Date

Collaborate with client to design and build their data warehouse (ETL/ELT) in Snowflake and implement end to end pipelines for finance dashboards and reporting, resulting in 25% reduction in operational cost.
Migrate client data from Oracle Netsuite into Snowflake using Fivetran/DBT achieving 20% pipeline efficiency and reducing data processing costs.
Work with data architect team to make sure snowflake tech stack & data are compliant.
Deliver all client MI reports and dashboards using Thoughtspot for real-time business decisions.
Setup the CICD/Pipeline for automated release and maintenance process using Gitlab and docker/container.
Quick turnaround for client Incident/Problem tickets on regular basis by doing gap analysis between business requirements and any deviations.
Live Data warehouse monitoring for any possible processing enhancement using performance tuning.
Manage and train client access management on snowflake & thoughtspot and be audit compliant.
Mentoring and upskilling junior data engineers and clients.

Natwest Group, London Feb’ 15 – Dec’ 22

Natwest Markets Finance Lead Engineer (Contractor)

Day to day management of complex Oracle Ledger application suite for ledger data management to make sure daily finance accounting, data integrity & reconciliation goals are met for bank’s 100% data compliance.
Daily data reconciliation with all front office trading systems data using Oracle DB & OBIEE to make sure business KPIs are met, and source reconciliation is 100%.
Daily Incident/Problem management by using PL/SQL query tuning and fixing oracle routines using query planner, OWB/ODI etc.
Solving critical user queries by querying large DBs to churn millions of data points and analyse it Front to back matching the data flows and accounting entries.
Scrutinising and implementing Oracle guidelines/principles for 99.9% ledger availability and data consistency.
Driving Digitization and Automation (AIOps) for database process simplification and performance improvement using SRE/DevOps and support user queries using digital BOT.
Integral part of Cloud migration journey in AWS & GCP for NWM finance including leaning of database and strategizing data move on to cloud.
Running daily scrums across regions for team comms and tracking performance.
Mentoring and upskilling junior engineers.

Royal Bank of Scotland, London Dec’ 10 – Oct’ 14

Designed and developed new applications for Bank of England, Wallstreet, SGL score, RWA securitization using OWB, PL/SQL, XML. This involved data migration between schemas and building warehouses for querying large DB objects and optimizing routines to support regulatory reporting for 100% compliance.
Analysis, design, development and documentation of a new reporting solution (Finrep & BASEL) to meet bank’s stat and reg reporting requirements. This included Oracle Apex development for UI too.
Solid in-depth analysis of SGL (Single General Ledger) database architecture and large database warehouses for future-proof modeling and design.
Planned and developed indexing strategies for database performance tuning and portioning used for millions of daily transactional data.
Analysis, design, development and documentation of Risk Securitization (CRD3) and Group Risk Data Warehousing system for 100% risk compliance.

Cheshire County Council, Chester July’ 05 – Dec’ 10

Designed, developed, and implemented all Oracle modules (GL, AP, AR, P2P, I2C, HR) for Cheshire County Council’s data requirement including DBA and System administration capabilities, resulting in 30% reduction in operational cost.
In-House Apex development for Oracle Projects and migration of DB to R12 for Oracle support compliance.
Designed and developed Oracle Dashboard for Schools and Officers using Oracle BIP and OBIEE which helped with real time business decisions.
Automated custom in-house Oracle PL/SQL routines churning millions of data points on daily basis to provide critical business information for the county managers.
Built and Managed Noetix (Finance) and Incisus (HR) End User Layers (EUL) and developed in-house views using Noetix Views Administrator and Noetix EUL Generator for Discoverer reporting suite.

About