Anil Teella
Bayonne,NJ
Summary
Data engineering and governance leader with extensive expertise in constructing scalable cloud data platforms, ETL/ELT pipelines, and reliable data controls for trading and analytics.
Overview
1
1
Certification
20
20
years of professional experience
Work History
Head of Data Engineering and Governance (Executive Director)
Castleton Commodities International
New York
08.2020 - Current
- Reviewed market, reference, and fundamental data from multiple sources and loaded datasets into Snowflake for energy trading signal generation across oil, natural gas, power, and power assets.
- Supported cross-functional data engineering and governance work to build scalable, trusted data systems.
- Built enterprise data platform while leading global team of data engineers to improve data access and reliability.
- Created governance framework, security controls, data lineage, and quality standards to support data integrity and compliance.
- Improved Snowflake platform performance and reduced annual costs by $1.5 million.
- Designed ETL pipelines for loading data into 2 petabyte data warehouse.
- Used AWS EKS, Iceberg tables, Glacier storage, SnapLogic iPaaS, Python, and Snowflake to deliver datasets for research teams and trading desks.
- Designed data lake storage architecture.
- Partnered with data scientists to build self-service model platform and knowledge bases.
- Worked with ERM team to capture trades through Snowflake and dbt.
- Built ETL and ELT pipelines in Snowflake, dbt, Snowpark, and SnapLogic, and trained junior and mid-level developers plus cross-team members.
- Adapted Monte Carlo data observability platform, Jitterbit, Zudy data catalog, and Alation for data discovery and governance.
- Delivered real-time market data ingestion for oil, natgas, and power curves, including futures, forwards, and indices, using Kafka.
- Served as SME for Snowflake database and data governance across organization.
- Led database migrations from OCI to PostgreSQL and Snowflake, and from SQL Server to Snowflake.
- Directed technical strategy, roadmap prioritization, and delivery.
- Modeled dimensions and hierarchies for analytics to improve data organization and retrieval.
- Used Cursor and Claude LLMs for AI-assisted development.
Lead Data Engineer
Equity Technologies, Deutsche Bank
New York
10.2016 - 08.2020
- Depot Global: Depot Global is golden source for Deutsche the bank's equity transactions and listed derivatives data across bank's global locations in AMRS, EMEA and APAC regions. Regulatory Operations and Applications (AML, Trade Surveillance and KYC) within the bank access data for different regulatory reporting and inquiries.
- Analyze, design and develop multi Terabyte scalable data warehouse (1 Billion messages per day), data mart solutions for Cash equities and listed derivatives in three global regions. Capture orders, executions, quotes, allocation messages from OMS and EMS and middle office booking systems using Solace middleware, Java, Oracle Exadata and Control-M.
- Developed datamart solutions for OATS, MIFID II reporting, and CAT event generation, enhancing reporting capabilities and compliance through the use of Oracle Exadata and Control-M.
- Analyze requirements, design and develop application to process Client executions data (Equities and Options) and calculate notional amounts, average prices for AML on heavy data volume.
- Provide Data out solutions for consumers within the bank for market conformity control, trade surveillance (Actimize, SMARTS), Trader Mandates, Volcker reporting, research fee unbundling, electronic blue sheets, ETracs (reconciliation of executions with exchange), 15c3(Client account protection). Professional clients using oracle pipeline table functions and pl/sql table types.
- Performed extensive data processing to maintain data integrity and quality through 3-tier checks, delivering scorecard data, exception summaries, and detailed analytics using Informatica IDQ, Oracle Exadata X6, Node.js, and React.
- Root cause analyses and performance tuning of sqls using oracle hints, execution plans, stats, indexes and index-organized tables and gv$ tables
- Contributed to physical relational data modeling, normalization, and best practices of relational database management systems.
- Developed python libraries to curate data, automate tasks and generate email alerts to trading desks
- Delivered numerous data extracts under tight deadlines for immediate analysis, including cost allocation across trading platforms, consolidating client subsidiaries for KYC, and tracking client activity by executions, notional amounts, and trade volumes over multiple months.
- Create and oversee change requests for deployment, ITAO responsibilities to oversee application infrastructure and implement internal controls
- Led and managed a team of junior developers, providing mentorship and guidance. junior developers
- Performed Database migrations and optimized the Exadata appliance usage for cost savings
- Worked on table partitions (range and hash) to maintain the heavy volume's scalability , maintainability and performance.
- Provided exceptions L3 support service, deep dive into equities and listed options orders and transaction data to provide informed insights for the business, compliance and regulatory teams.
- Worked on table partitions (range and hash) to maintain the heavy volume's scalability , maintainability and performance.
Lead Data warehouse and Oracle PL/SQL Developer Consultant
Bank of America Merrill Lynch
Jersey City, NJ
11.2012 - 10.2016
- Liquidity Risk Business Reporting and Analytics
- Load product data from ATLAS (Golden source) and LRS (Legacy Liquidity Risk System residing on DB2 database) source systems into LIBRA (a Multi TB DB). Create Dashboards, Datasets, Analytics and Reports using Python scripts, Quartz Framework and Oracle Database.
- Developed physical data model and designed table-driven ETL processes for data warehouse reporting on products such as Repo, Loans, Deposits, and Inter Company Debt.
- Worked on Slowly Changing Dimensions, Hierarchies, Pivoting, Data partitioning, windowing, PVDs, Measures and Analytics
- Developed interfaces that display dashboards and charts using Quartz framework and python scripts
- Virtual private database development for masking column data using Policies and Policy Groups.
- Executed database development for 4G reporting, specifically for Federal Reserve Bank and EBA LCR/NSFR compliance.
- Created tools for production and QA support, reducing developer dependency and streamlining support processes.
- Worked with US LCR and Cash Flow reports for Liquidity Risk
- Implemented and maintained phases of loaders including RAW, INFC, and FCT.
- Worked on pl/sql packages, views, triggers, indexes, hints, global temporary tables, table partitions (range and list), local and global partitioning strategies.
- Performance tuned sqls using execution plans, stats, gathering and AWR reports.
Sr Database and PL/SQL Developer Consultant
Brown Brothers Harriman
Jersey City, NJ
05.2012 - 10.2012
- Database development to implement the business logic for Mutual Fund Accounting System.
- Developed and implemented business logic to calculate distribution rates, post ledger amounts, and generate reports for periodic distributions to investors using pl/sql packages, triggers, tables, views, and indexes.
- Analyzed existing processes in pl/sql stored procedures and packages, recommending enhancements for improved performance.
- Executed heavy database object creation and conducted unit testing for Exchange Traded Funds application to ensure reliability.
- Performed reconciliation of ledger and sub-ledger reports to maintain financial integrity.
Sr Database and PL/SQL Developer Consultant
ING
Somerset, NJ
02.2010 - 04.2012
- Analyzed, designed, and implemented complex business logic for retirement benefits applications Task Manager and Power Image.
- Leveraged advanced PL/SQL features, including collections, types, ref cursors, global temporary tables, analytical functions, external tables, pipelined functions, table partitions, and various dbms family packages.
- Architecture and estimate the database solution for the applications.
- Developed and implemented batch job processes (daily/weekly) using SQL Plus Reports, FTP files, SQL Loader scripts, UNIX shell, and Tivoli workload scheduler.
- Design and develop data warehouse solution using Informatica
Data Warehouse Developer Consultant
Citizens Bank
Cranston, RI
07.2009 - 01.2010
- The project involves creating an ETL process by using Oracle PL/SQL, UNIX shell scripting to load the Operational Risk data such as loss data, hierarchies, issue data, audit and rating data into the data warehouse which was consumed by different groups to do the analysis and reporting by using Oracle BI.
- Developed repositories, dashboards, and reports using Oracle Business Intelligence tool to deliver actionable insights.
- Built Operational Risk data warehouse and reported the business requirements using Oracle business intelligence.
- Created dimension views, hierarchical views and cube organized materialized view to provide computed summary data and analytical measures for group policy framework, RCSA inventory and Assessments.
- Analyzed the requirements for Operational Risk data (such as compliance data, loss events, loss impacts, issue data) loading from vendor views into dimension table.
- Managed operational risk systems to enhance data processing efficiency across teams.
- Outlined key responsibilities to ensure project alignment with business objectives.
ETL and Reports Developer
State Street Corporation
Boston, MA
09.2008 - 07.2009
- Portfolio segment Analysis Reporting, Trading Systems - FX
- Portfolio Segment report analysis and development using ETL from multiple data sources such as FX database, Counterparty Management system and PD rating database using Oracle SQL
- Utilized loaders, external files, pipelined functions, and import/export utilities to streamline data integration processes.
- Developed exception, credit over limit, FX Credit Summary and Utilization reports for counterparties.
- Analyzed and categorized business-generated counterparties by fund families and investment managers, calculating usage-weighted risk ratings to enhance risk assessment.
- Macro Fund Analysis for Capital markets and Collective investment funds using Wall Street Systems, Open relational database and Risk data repository.
- Defined project responsibilities to ensure alignment with business objectives.
- Worked with multiple business areas and teams such as corporate audit, global markets and compliance for reconciliation of Risk and Credit exposure data.
Database Developer and Production Support Analyst
Wellington Management Company LLP
Boston, MA
09.2006 - 08.2008
- Gained hands-on experience in oracle database development, forms and reports development, process development, and production support for Wellington's enterprise application suite and reports.
- Responsibilities:
- ETL process to load Fee analysis data, investment style data into Fee Analysis System and daily transactions, holdings data into Data Mart.
- Developed processes to extract performance data for accounts, subaccounts, families, and clients, aligning with benchmarks on a daily, weekly, and quarterly basis.
- Implemented the automated process that generates the Transaction and Holding reports at Account and Sub Account level and FTP them.
- Executed daily cash, position, and check-free reconciliation processes to ensure accurate financial reporting.
Education
M.S - Computer Science
NMSU
LAS CRUCES, NM01-2006
B.Tech - Computer Science
Sri Venkateswara University
India01-2003
Skills
- Databases: Snowflake, Databricks, PostgreSQL, Redshift, Oracle 12c/11g/10g/9i/8i, DB2, Sybase, MS SQL Server 2022, MySQL
- Development tools: VS Code, PyCharmDBeaver, Toad, PL/SQL Developer, Rapid SQL, SQL Navigator, SQL Server Management Studio, SSH (PuTTY), Anaconda, Jupyter Notebook
- Web technologies: Data analytics, Data visualization, Java API development, Cloud architecture, HTML, Machine learning, Data governance
- Programming languages: Python, Java, Unix shell scripting, SQL
- Data modeling: ERwin, MS Visio
- Data governance tools: Monte Carlo, Alation
- Operating systems: Unix, Linux, Windows
- Reporting tools: Tableau, Power BI, ClickHouse, Streamlit
- ETL tools: dbt, SnapLogic iPaaS, PySpark data orchestration, Informatica 8x/9x/10x
- Other tools: AWS services, Git version control, Apache Airflow workflow automation
- AI tools: Claude, OpenAI, Snowflake Cortex
Certification
- CFA level 2 Candidate
- Snowflake Fresh Snow
- Derivatives Markets, Hedging and Risk Management
- Oracle Certified Associate
Timeline
Head of Data Engineering and Governance (Executive Director)
Castleton Commodities International
08.2020 - Current
Lead Data Engineer
Equity Technologies, Deutsche Bank
10.2016 - 08.2020
Lead Data warehouse and Oracle PL/SQL Developer Consultant
Bank of America Merrill Lynch
11.2012 - 10.2016
Sr Database and PL/SQL Developer Consultant
Brown Brothers Harriman
05.2012 - 10.2012
Sr Database and PL/SQL Developer Consultant
ING
02.2010 - 04.2012
Data Warehouse Developer Consultant
Citizens Bank
07.2009 - 01.2010
ETL and Reports Developer
State Street Corporation
09.2008 - 07.2009
Database Developer and Production Support Analyst
Wellington Management Company LLP
09.2006 - 08.2008
M.S - Computer Science
NMSU
B.Tech - Computer Science
Sri Venkateswara University