Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

RAVISH TILLU

New York,NY

Summary

Results-driven and seasoned IT professional with over 19 years of experience in designing, developing, and automating Regulatory reporting and client-server applications. Currently serving as Director/Technical Lead, specializing in Federal Reserve mandated reports for Intermediate Holding Company(IHC) reports, Liquidity Reporting, CCAR (Comprehensive capital analysis and review) reporting, Branch offices and FINREP Reporting, Basel-III calculation by coding the Regulatory Reporting rules and complex calculations using AxiomSL Controller view Regulatory Reporting software, Data Engineering and Architecture.

Overview

1
1
Certification
15
15
years of professional experience

Work History

Director - IT Regulatory Reporting

Mizuho Americas Services - Mizuho Financial Group
New York, NY
01.2024 - Current
  • Currently working as a Director of IT Regulatory Reporting for the design, architecture and full automation of Federal Reserve mandated reports for IHC (Intermediate Holding company) FRY9C, FFIEC009, FFIEC031, FRY15, FRY9LP, FRY11, FR2314. Liquidity reporting of FR2052a, FINREP reports, TIC series reports, Branch Reports - FFIEC002, FR2644 and FR2900, end to end by building the data consumption pipelines from data warehouse (on snowflake on Azure cloud platform) to AxiomSL Controller View software platform using oracle database on AWS cloud. Coding the complex regulatory reporting rules and complex mathematical calculations as per the Federal Reserve guidelines/Instructions in AxiomSL Controller View Software used for regulatory reporting.
  • Worked on designing and architecting the Datawarehouse in Snowflake on Microsoft Azure Cloud.
  • Building the Data Integration to Extract, load, transform and clean the data from multiple source systems into Schema for Axiom reporting application.
  • Building the data pipelines from Datawarehouse to extract the data and load in AxiomSL Controller view.
  • Implementation of proper controls and processes with recommended steps for IAM(Identity and Access Management) to the AxiomSL Controller view regulatory reporting software tool.
  • Analyzing the data and coding the complex reporting rules in AxiomSL Controller view as per the Federal reserve reporting instructions and firms data attributes using datasources, datamodels, modify models, shorthands, portfolios, aggregation and feeding it to the freeform report.
  • Analyzing and reviewing the reporting numbers and raising the data quality issues with enterprise datawarehouse for fixes.
  • Building the controls and processes in AxiomSL Controller view as per the audit requirements and documenting the same.
  • Acting as subject matter expert on AxiomSL Controller view and providing best practices recommendations to the team.
  • Building of reconciliation reports as per business and management requirements in AxiomSL Controller view which helps in analyzing the data gaps, inconsistency in reporting numbers.
  • Complete automation of end to end report generation process in Axiom.
  • Setting up regulatory reporting specific processes as per the audit requirements and reporting calender as well as documenting of the same on Confluence.

Associate Director

RBC Capital Markets
Jersey City, NJ
02.2015 - 01.2024
  • Design, architecture, development, and full automation of Federal Reserve mandated reports, ensuring compliance with recommended standards for various reports, including but not limited to: - IHC (Intermediate Holding company) FRY9C - FFIEC009 - FFIEC031 - FRY15 - FRY9LP - FRY11 - FR2314 - CCAR (Comprehensive capital analysis and review) reports of FRY14 Series – M/Q/A - Branch reports of FFIEC002, FR2644, TIC series.
  • Lead end-to-end development by building data consumption pipelines from the data warehouse to Axiom SL Controller View.
  • Manage the design and architecture processes, ensuring the implementation of automation strategies for efficient and accurate report generation.
  • Oversee the entire lifecycle, from data cleansing and loading on Oracle 19c, 12c databases to enriching ledger and subledger data with reference data and user-maintained tables.
  • Implement automation workflows within Axiom for seamless and efficient report generation.
  • Managed team of 9 developers, involved in capacity planning, sprint planning, and complete delivery of applications within agreed timelines and quality standards.
  • Worked closely with the Project Management Office on budgeting, vendor coordination, and technical training of team members.
  • Acted as a single point of contact for regulatory reporting applications, liaising with senior management, product owners, RISK IT (Audit), and Project Management Office.
  • Documented all technical architecture designs using flowcharts on Confluence and provide walkthrough for stakeholder approval before implementation.
  • Designed and developed complex control reports in Axiom, collaborating with report owners to enhance regulatory filing processes.
  • Lead the installation and upgrade of Axiom applications and Oracle databases, ensuring compliance with required standards.
  • Identify issues in the development lifecycle and implement automation and checklists to prevent recurring problems.
  • Write Python scripts to check data readiness in Datawarehouse in consumption API, scheduling using Stone Branch scheduler tool.
  • Coordinate with DBA teams for database creation and data encryption for the Axiom application.
  • Automate Unit Testing, generate regression reports in Axiom, and share with QA and UAT teams.
  • Offer production support during off-business hours to finance users during the reports filing window.

Senior Associate - Projects

Cognizant Technology Solutions, CTS
New York, NY
10.2013 - 02.2015
  • Collaborated with the Change Management Team (CMT) to understand requirements and functional design, contributing to the creation of technical design documents.
  • Reviewed technical design documents created by other team members, ensuring alignment with project objectives and standards.
  • Built regulatory reports in Oracle 11g using PL/SQL, Toad, SQL Plus, Axiom SL Controller View Version 8.8.1, UNIX shell scripting, and scheduled tasks using Autosys.
  • Created PL/SQL procedures, functions, and packages in Oracle 11g to support the implementation of regulatory reporting requirements. - Implemented complex regulatory capital rules in Axiom SL Controller View, coding SQL queries in data sources, datamodels, and rules in portfolios and aggregations.
  • Coded bridge mapping to report balances on the IHC report FRY9C, ensuring accurate representation of financial data.
  • Contributed to coding CCAR reports FRY14M, FRY14Q by developing freeform report templates and coding datasources, datamodels, portfolios, and aggregations.
  • Played a key role in automating various regulatory reports, ensuring efficiency and accuracy in the reporting process.

Technical Leader

IGATE Technologies Inc.
Downers Grove, IL
12.2011 - 10.2013
  • Analyzed business requirements, engaging with users and Product leads to gain in-depth knowledge and clarification of requirements.
  • Prepared comprehensive functional and technical design documents for Oracle and Unix, leveraging expertise in functional and technical aspects.
  • Coordinated with the WEB application team to align with designs. - Identified test cases/scenarios per business requirements and created detailed functional documents.
  • Designed database tables, implementing proper partitioning techniques, and ensuring data integrity using integrity constraints in Oracle 11g with tools like Toad and SQLPLUS.
  • Developed Oracle 11g database objects, including packages, functions, procedures, and triggers, updating technical documents accordingly.
  • Obtained approvals for functional and technical documents from stakeholders, including the business team, product leads, and technical architect.
  • Developed various database objects based on technical and functional documents.
  • Created and modified Oracle stored procedures, functions, packages, and triggers using Oracle PL/SQL to implement business rules and processes.
  • Wrote optimized Oracle SQL queries based on table indexes and well-ordered joins.
  • Conducted Performance Tuning of Oracle SQL queries using tools like SQL tuning advisor, SQL Plan Management, Hints, and Explain Plan. - Utilized Oracle PL/SQL collections, including associative arrays, for high-performance in-memory processing and loading data into target tables.
  • Implemented strategies for gathering Oracle tables, index statistics, and histograms to improve overall query performance.
  • Leveraged Oracle 11g features like virtual columns and reference partitioning, along with performance improvement features like result cache hints and result cache for functions.
  • Worked on loading data from external systems in the form of files (CSV files) using PL/SQL procedures and Oracle utilities (SQL*LOADER), external tables, and Oracle Data Pump.
  • Conducted unit testing of the developed code in Oracle PL/SQL.
  • Prepared and reviewed system integration test cases/plans with cross-functional teams and product leads.
  • Worked and coordinated with business users for User Acceptance Testing (UAT).
  • Addressed defects encountered in System Integration Testing (SIT) and UAT testing.

Education

Bachelor of Engineering Technology - Electronics

Mumbai University
Mumbai, India
05-2007

Skills

**Axiom SL Controller View**

  • Solution Architect and Senior Axiom Developer - Versions: v1014, v1074, v9933

**Cloud Technology**

  • AWS Certified Solution Architect
  • Snowflake Datawarehouse
  • Microsoft Azure

**Database**

  • Oracle: 19c, 12c, 11g, 9i - PL/SQL, SQL, Performance Tuning, Data Masking for PII

**Tools**

  • PL/SQL Developer: 70 and 1102
  • SQL Developer
  • Toad for Oracle
  • Toad 116
  • Informatica (For ETL)

**Scheduling Tools**

  • Stone Branch
  • Tidal
  • Autosys
  • CAWA (Computer Associates Workload Automation)

**Version Control Tools**

  • GitHub
  • Microsoft Visual Source Safe 60

**Platform and OS**

  • RHEL (Red Hat Enterprise Linux)
  • AIX (IBM AIX)

**Scripting Language**

  • Python 3
  • Axiom Scripting Language

**DevOps**

  • Jenkins
  • Urban Code Deployment
  • Axiom Accelerator

**Documentation and Work Tracking**

  • Confluence for documenting Report Designs, information, and flow charts
  • JIRA system for tracking and logging user requirements, bugs, and progress tracking in Scrum using JIRAs

**Job Function**

  • Requirement Analysis
  • Architecture and Design
  • Development and Unit Testing
  • Integration and Performance Testing
  • Offshore Coordination
  • Change Management
  • Support Activities
  • Status Reporting

**Domain**

  • Finance
  • Supply Chain Management
  • Insurance Domain

Certification

  • AWS Certified Solution Architect - Associate

Timeline

Director - IT Regulatory Reporting

Mizuho Americas Services - Mizuho Financial Group
01.2024 - Current

Associate Director

RBC Capital Markets
02.2015 - 01.2024

Senior Associate - Projects

Cognizant Technology Solutions, CTS
10.2013 - 02.2015

Technical Leader

IGATE Technologies Inc.
12.2011 - 10.2013

Bachelor of Engineering Technology - Electronics

Mumbai University
RAVISH TILLU