Nov 2021 – Jan 2025 · 3 yrs 2 mos

Jul 2020 – Nov 2021 · 1 yr 4 mos

Jun 2013 – Jun 2020 · 7 yrs

• Database Architecture team is responsible for gate keeping all database related activities like Design, Database development, Code Reviews, Production roll outs, Query Optimization, Performance Tuning and Health of the production systems.
• Responsibilities:
• Managing Mid to Senior level Database Architects
• Responsible for OLTP databases full life cycle(Design to Production Roll out)
• Responsible for Warehouse Data Modeling, ETL Integrations and Reporting
• Data Visualizations
• Responsible for the health of Production Database Systems
• Performance Tuning / Performance Bench marking
• Capacity Planning
• Database and Hardware Upgrade Activities
• Database Stress Runs
• Achievements:
• Built the Center of Excellence Team by recruiting the whole team
• Database Version Upgrades to 11g/12c
• Added new database stack like MongoDB, MySQL, PostgreSQL etc
• Groomed the team in Performance Tuning, Capacity Planning, Data Modeling
• Query Tuning with improvement up to 90%
• Scale up the Database Systems by 7-10x by solving concurrences at the database layer
• Migration Workflow for Data Migration to support multiple Mergers & Acquisitions
• Automated Reports to inform the change in Query Executions by comparing with baseline
• Hourly KPI Reports from Production Infrastructure to keep business up to date
• Part of GDPR, PCI, KYC, Regulatory Reporting projects

Jul 2007 – May 2013 · 5 yrs 10 mos

• Game Platform team is responsible for the central systems (includes Account, Wallet & CRM) of the Game Products.
• Responsibilities:
• Responsible for OLTP databases full life cycle
• Warehouse Data Modeling, ETL Activities & Visualizations
• Requirements Analysis and Feasibility study
• Functional Reviews and performance reviews
• Query Optimization, performance tuning and performance benchmarking
• Developed tools to minimize the DB operational activities
• Support in QA, UAT and Go-Live phases
• Performing Technology POC (eg: EBR, VPD etc…)
• Database Migrations (Version Upgrades, Moving to RAC)
• Achievements:
• Built the Multi-Tenancy System
• Built the Multi-Currency System
• Code Decoupling
• Common Database level frameworks
• Familiar with Regulatory Requirements

Dec 2003 – Jun 2007 · 3 yrs 6 mos

• Ezecash is the transaction processing system which allows users to make deposits and withdraw their balances and is integrated with more than forty payment processors.
• Responsibilities:
• Requirements Analysis
• Application and Database Design
• Database Development
• Unit Testing
• Query optimization and performance tuning
• Code Reviews, Functional Reviews
• Support in QA & Go-Live phases
• Achievements:
• Refactored Payments Module
• Built the Chargebacks/Invoice/Resolution process workflow
• Refactored the Payment Processor Configurations

Jul 2000 – Aug 2003 · 3 yrs 1 mo · Hyderabad

• STRABUS software solutions is a pvt ltd company based in Hyderabad which offers different financial products for Financial Institutions. As part of this project, I got the opportunity to work on multiple financial services modules like Equities, Derivatives, Money Markets, Fund Accounting (Mutual Fund Back office system), Portfolio Management System, Wealth Management System and DP Back Office
• Responsibilities:
• Development
• Database Design
• Unit Testing
• Code Reviews, Functional Reviews
• Support in QA & Go-Live phases
• Post production Support
• Achievements:
• Fund-Accounting(Mutual Fund Bank Office) System for CAMS
• Treasury System for SBI Capital Markets
• PMS System for ENAM
• EPFO-Back office for SBI
• WMS for ABN-Amro and HDFC Securities