GANESH DAKSHINAMURTHY RAMAMURTHY
CHENNAI
Summary
Dynamic Senior Development Manager with expertise in data modeling and SQL optimization at Standard Chartered. Successfully led complex data migration projects, enhancing data integrity, and performance. Proven team leader, skilled in ETL development and data reconciliation, driving impactful solutions that improved operational efficiency across multiple markets. In-depth knowledge in the custody domain, and data for securities services.
Overview
13
13
years of professional experience
Work History
Senior Development Manager
Standard Chartered Global Business Services Pvt Ltd
Chennai
05.2019 - Current
- Created conceptual, logical and physical data models for use in different business areas.
- Optimized SQL queries and database schemas for performance improvements in data retrieval operations.
- Optimized existing queries to improve query performance by creating indexes on tables.
- Analyzed user requirements, designed and developed ETL processes to load enterprise data into the Data Warehouse.
- Collaborated with cross-functional teams to gather requirements and translate business needs into technical specifications for data solutions.
- Automated data quality checks and error handling processes to ensure the integrity and reliability of datasets.
- Worked on complex migration projects to migrate data from NCS to TCS BaNCS for custody.
- Framed migration logic for corporate action static and transaction data into the integrated TCS BaNCS application V19.
- Developed migration code using Java and migrated data from over 25 markets into the application, which constitutes over 80% of the overall CA volume.
- Developed an end-to-end reconciliation dashboard for migrated data and data quality issues, which enabled users to perform data verification at a faster rate.
Senior Software Engineer
SG3 Capital Inc
Boston
08.2017 - 12.2018
- Developed robust proprietary software applications, such as trade execution tools, web content mining, and user interfaces.
- Developed responsive web design using Vue.js and Node to monitor for any updates in the prices of cryptocurrencies across different exchanges.
- Created a web scraper using Elixir that monitors around 300 websites for updates and modifies the frontend with a specified frequency for every website, and different notification alerts based on priority.
- Designed a MongoDB database to store prices of cryptocurrencies across six different exchanges.
- Performed an analysis based on the rates of cryptocurrencies across exchanges, and checked if there is any arbitrage.
- Created an automated backup strategy to store backups of the prices of various cryptocurrencies across exchanges.
- Assisted with ad-hoc projects like data analysis, which involves collecting data using Google Finance and frequently monitoring for any updates.
Software Engineer
Tata Consultancy Services Ltd
Chennai
08.2012 - 07.2015
- Automated data feeds from external financial systems and integrated them into production data marts.
- Optimized long-running queries using indexing strategies and query optimization techniques.
- Generated complex subqueries and correlated subqueries.
- Monitored performance and optimized SQL queries for maximum efficiency.
- Created a logic to segregate inconsistent data from data sources during data migration into the Oracle SQL platform.
- Developed an automation tool to verify post-migration data using Oracle SQL and shell scripts, which generated end-user reports for over 100,000 users across 27 countries.
- Designed and developed a Data Verification Tool that sample-tested cross-sectional data involving multi-factual dimensional entities.
- Provided database support and maintained code for TCS Core Banking Solution (TCS BaNCS).
Education
Master of Science - Computer Information Systems
Northeastern University
Boston, United States Of America05-2017
B. Tech - Information Technology
Anna University
Chennai, India05-2012
Skills
- Data modeling
- SQL optimization
- ETL development
- Data migration
- Data reconciliation
- Data analysis
- Team leadership
- Software development
Timeline
Senior Development Manager
Standard Chartered Global Business Services Pvt Ltd
05.2019 - Current
Senior Software Engineer
SG3 Capital Inc
08.2017 - 12.2018
Software Engineer
Tata Consultancy Services Ltd
08.2012 - 07.2015
Master of Science - Computer Information Systems
Northeastern University
B. Tech - Information Technology
Anna University