Ramesh Balasubramanian
Summary
Strategic data analytics architect with a strong focus on delivering innovative solutions and effective reporting strategies. Proven ability to enhance operational efficiency and optimize data management processes across diverse sectors, including Financial Services and Manufacturing. Expertise in leading high-performing teams to achieve significant business outcomes through advanced visualizations and AI technologies. Extensive experience in enterprise architecture and cloud computing, driving successful software implementations and optimizing IT infrastructure.
Overview
28
28
years of professional experience
1
1
Certification
Work History
Solutions Architect - Data
CGI
04.2024 - Current
- Architected BI data analytics frameworks through dimensional modeling and efficient data loading patterns.
- Developed baseline pipelines using Apache NIFI to standardize data ingestion processes.
- Created detailed data dictionaries for BI and operational sources to improve clarity.
- Collaborated with Harley Davidson to align data attributes with CGI systems, identifying functional gaps.
- Designed ERD and logical data models for loan origination products to facilitate analytics initiatives.
- Resolved critical production issues by implementing effective BI solutions and performance tuning strategies.
- Established monitoring routines to ensure data quality checks and observability in batch loads.
- Evaluated emerging technologies to enhance system performance and integration across client environments.
Data Management Consultant
Charles Schwab
06.2022 - 01.2024
- Established and lead a Data/Process Governance for the Migration program.
- Cataloging the Migration Artifacts and Datasets.
- Migration of Data and Conversion of both ingestion ELT/ETL scripts (SQL, Shell, Alteryx and Python scripts) and consumption artifacts (Inhouse Spreadsheet Report generation tool, Self Service reports, Tableau, BO, power BI) for GCP.
- BQ SME for Training, Data Engineering and Architecture for Data Analytics and Insights Org.
- Multinational Financial & Insurance Services Company.
Vice President, Data Engineering Tech Lead
Bank of America
03.2019 - 05.2022
- Led the Strategic Data Enablement Program to deliver a unified, single source of truth for stakeholders including regulators, auditors, data scientists, and enterprise analytics platforms—focused on Treasury Transaction Data.
- Designed and implemented data contracts and pipelines to integrate data from legacy systems into modern treasury data platforms.
- Architected and modeled datasets in Authorized Data Stores (Exadata, HAAS, ELK) for use in stakeholder tools, APIs, and search platforms.
- Spearheaded development of Data Lakehouse architecture, including Medallion architecture, data pipeline setup for various data sources and Cloud Datawarehouse targets, and ELK implementation.
- Designed enterprise Snowflake architecture for multi-region deployment with workload isolation and governance policies, supporting more than 1000 users.
- Established cost governance framework with resource monitors, tagging, and dashboards; achieved more than $500k in annual savings.
- Defined RBAC hierarchy and masking policies for PII.
- Drove compute/storage design for Oracle Exadata, HAAS, and ELK clusters.
- Oversaw data preparation and delivery for AI/ML use cases, enabling regular consumption by Data Science teams.
- Global Bank and Financial Services Company.
Senior Manager (PL) – Database Engineering and Architecture
Jewelry Television
02.2005 - 02.2019
- Stabilization of OLTP Database and Enterprise Monitoring setup for performance and availability of application services.
- Data Integration of the Order Management and Inventory data with Oracle Financials.
- Data Center Migration and Disaster Recovery Plan and execution at a regular interval.
- Physical Design and Implementation of Enterprise Data warehouse.
- Data Modelling for Promotions, Shipping Automation and Order Management in-house applications.
- PCI DSS security policy implementation for Data in transit and Data at rest.
- IAM implementations.
- Master Data Management of Customer and Product Data.
- Teleshopping Network specialized in selling Jewelry and Gemstones.
Oracle Financials and Inventory Implementation Consultant
Perot Systems
06.2003 - 01.2005
- ERP Modernization of a Global Manufacturing Company with the implementation of Oracle Financials, HRMS, Payroll, Incentive Compensation, iProcurement, Purchasing, Inventory, Shipping modules.
- As Techno/Function Consultant.
- Gather requirements for Customization and migration of data from the in-house legacy systems.
- Implementation setup, Customization changes to the UI and Reports.
- Migration of data from the legacy to the ERP.
- Data Integrations Internally and Externally Through EDI formats.
Software Engineer
Computer Science Corp / Gulfstream Aerospace (General Dynamics)
03.2000 - 05.2003
- Implementation of an Inventory and Manufacturing tool and its integration with SAP (FICO).
- Software Engineer worked as part of the implementation of vendor software and the financials data to be integrated with the GL and payables in SAP.
Associate Computer Engineer
Tata Consultancy Services
08.1997 - 02.2000
- Development of Accounting Software for Accounts Auditing offices for the Government.
- Project Lead and Software engineer involved in the End-to-End development and implementation of Accounting Software and its reporting modules.
Education
Bachelors in electrical engineering -
National Institute of Technology
SilcharSkills
- Exadata and Oracle
- HAAS and GCP BigQuery
- SQL Server and MySQL
- Postgres and Redshift
- Snowflake and Databricks
- ElasticSearch and MongoDB
- DynamoDB and Teradata
- Hadoop and Dataproc
- Oracle GoldenGate and Informatica
- Dataflow and Glue
- Kafka and Shell scripting
- Python and PySpark
- Scala and Java programming
- JavaScript and Erwin modeling
- Collibra and Kibana analytics
- Apache Superset and Tableau
- Power BI and Looker reporting
- Oracle Reports and Data Architecture
- TOGAF framework
- Docker and Kubernetes orchestration
- GIT version control
Certification
- Bachelors in electrical engineering – National Institute of Technology, Silchar
- Sun Certified Java programmer
- Oracle Certified Associate
- Third Place in Data Science Code-a-thon team event
Areas Of Excellence
- Analytics and Reporting Solutions
- Business Transformations in Cloud
- Team Leadership and Management
- Vendor Management & Collaboration
Timeline
Solutions Architect - Data
CGI
04.2024 - Current
Data Management Consultant
Charles Schwab
06.2022 - 01.2024
Vice President, Data Engineering Tech Lead
Bank of America
03.2019 - 05.2022
Senior Manager (PL) – Database Engineering and Architecture
Jewelry Television
02.2005 - 02.2019
Oracle Financials and Inventory Implementation Consultant
Perot Systems
06.2003 - 01.2005
Software Engineer
Computer Science Corp / Gulfstream Aerospace (General Dynamics)
03.2000 - 05.2003
Associate Computer Engineer
Tata Consultancy Services
08.1997 - 02.2000
Bachelors in electrical engineering -
National Institute of Technology