Senior Database/ ETL/ Data Analyst

RAJENDER DICHPALLY

********.*********@*****.*** 973-***-****

PROFESSIONAL SUMMARY

Seasoned Senior Database Developer with over 15 years of IT experience, including 5+ years of hands-on work with Oracle Data Integrator (ODI) 12c and 19c. Strong expertise in Oracle PL/SQL, dimensional modeling, ETL, and data warehousing across capital markets and enterprise systems. Proficient in on-premise environments and automation using Unix shell scripting. Demonstrates excellent communication skills, with a history of successful collaboration across global teams and business units. Proven track record in leading teams, automating systems, and delivering robust database solutions.

CORE COMPETENCIES

Oracle PL/SQL Development – 10+ years (Stored Procedures, Triggers, Packages, Functions)

Oracle Data Integrator (ODI) – 5+ years (Versions 12c and 19c)

Unix/Linux Shell Scripting – Automation, Backup, Data Processing

On-Premises Database Management – Installation, Configuration, Patch Management

Dimensional Data Modeling – Star & Snowflake Schema Design

ETL Tools – SQL Loader, Data Pump, Informatica, SSIS, Oracle Data Integrator (ODI)

Database Performance Tuning – EXPLAIN PLAN, TKPROF, AWR Reports

Capital Markets & Banking Industry – VaR, Compliance, Trade Surveillance

Communication & Leadership – Team Management, Agile, Client-Facing Roles

TECHNICAL SKILLS

Databases: Oracle (10g–19c), SQL Server (2005–2019), Sybase, DB2, MS Access

ETL Tools: Oracle Data Integrator (12c & 19c), SQL Loader, Informatica, SSIS, Data Pump

Languages/Scripting: PL/SQL, T-SQL, Shell Script, Python, JavaScript, VBScript

BI Tools: SSRS, SSIS, Tableau, Crystal Reports, Cognos

Platforms: Unix/Linux, Windows Server

Tools: Actimize, SharePoint, Erwin, Azure, DBeaver, ICloud, Databricks (exposure)

PROFESSIONAL EXPERIENCE

Mizuho Bank – Manhattan, NY

Senior Database Developer / Analyst

March 2017 – Present - Led development and optimization of PL/SQL packages, procedures, triggers for risk and compliance systems (VaR calculations, management reporting). - Developed and maintained ETL pipelines using Oracle Data Integrator (12c and 19c) and SQL Loader. - Designed dimensional models for reporting systems using star and snowflake schemas. - Built automated data pipelines using shell scripts and ETL tools. - Tuned complex SQL queries using AWR, TKPROF for performance gains in high-volume systems. - Collaborated with trading and risk teams; developed reports for fixed income, equities, and compliance. - Exposure to Databricks for data analytics and transformation initiatives.

PricewaterhouseCoopers – Manhattan, NY

Senior Database Developer / Project Lead

Feb 2016 – Mar 2017 - Managed a team of 8 developers on Global Compliance Systems. - Developed and optimized PL/SQL and shell scripts in on-prem Oracle/Exadata environments. - Designed data warehouse layers with strong focus on dimensional modeling. - Created ETL processes using shell and Python scripts; integrated Bloomberg/Reuters data feeds.

Bank of America – Manhattan, NY

Senior Programmer (Actimize Projects)

Jun 2015 – Feb 2016 - Developed Oracle PL/SQL code for alerts and surveillance rules in Actimize. - Tuned Exadata queries to optimize performance of surveillance and compliance processes.

Ambac Assurance – Manhattan, NY

Senior SQL Developer / Data Analyst

Sep 2014 – Apr 2015 - Created SSIS packages for loading input files into databases. - Built SSRS reports and performed T-SQL optimization for reporting performance. - Automated database processes using shell scripts and Python.

JPMorgan Chase – Jersey City, NJ

Senior Database Developer / Project Lead

Sep 2013 – Jul 2014 - Developed data marts and reports for management using Oracle and SQL Server. - Built shell scripts for archiving, purging, and real-time replication monitoring.

(Additional experience with UNICEF, Nomura, Standard & Poor’s, United Water, Vitamin Shoppe, and Thomson Reuters available upon request)

EDUCATION

New York Institute of Technology

- MS in Computer Science, 1997

- MBA in Finance, 1994

- MBA in Marketing, 1993

CERTIFICATIONS & OTHER

Familiar with Agile methodologies – Sprint Planning, Stand-ups, Retrospectives

Strong understanding of capital markets, regulatory environments, and compliance systems

Knowledge of Work Order Management and Rent Collection Systems

Exposure to Databricks for modern data architecture and transformation workflows

Experience supporting production systems in on-prem and hybrid cloud models

Contact this candidate