Dipak Jena

Leading Edge IT, London                                                         Mar’ 23 – Till Date

Senior Data Engineer (Contractor)

• 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

Senior Oracle Finance Analyst/Developer

• 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

Oracle Consultant

• 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.

Staffordshire University, United Kingdom.                                   Jan’ 04 – Jan’ 06

M.S. Computer Science – Enhanced                                              Distinction

Bharathiar University, India.                                                              June’ 99 – May’ 03

B.Engg. – Computer Science & Engineering                                    Distinction 

College of Basic Sciences and Humanities, India.                 June’ 97 – May’ 99

Equivalent to ‘A’ Level                                                                     Distinction

Sainik School Bhubaneswar, India.                                June’ 92 – May’ 97

Equivalent to GCSE                                                               Distinction