Summary
Overview
Work History
Education
Skills
Certification
Solution to replace Oracle CDC which resulted huge savings for client
Timeline
background-images
Madhan Subbiah

Madhan Subbiah

Plymouth Meeting,PA

Summary

Dynamic Senior Technical Lead with extensive experience at HCL America INC, adept at implementing agile methodologies to enhance project efficiency. Proven track record in delivering high-profile e-commerce projects, leveraging strong leadership and SQL expertise to foster innovation and client satisfaction. Skilled in risk management and strategic planning, ensuring successful project outcomes.

Technology professional prepared for leadership roles, bringing wealth of experience in project management and technical innovation. Proven ability to drive impactful solutions and streamline operations. Emphasizes team collaboration and adaptability, ensuring alignment with organizational goals while leveraging skills in software development and system architecture.

Overview

22
22
years of professional experience
1
1
Certification

Work History

Senior Technical Lead / Technical Project Manager

HCL America INC
02.2012 - Current
  • Streamlined project processes by implementing agile methodologies, resulting in increased efficiency and faster completion times.
  • Supported and executed simultaneous delivery of various e-commerce and mobile projects.
  • Communicated project plans and progress to key stakeholders and project contributors.
  • Identified risks early in the project lifecycle, developing mitigation plans to prevent schedule delays or cost overruns.
  • Established clear lines of communication between stakeholders by creating detailed status updates that kept everyone apprised of critical milestones throughout each stage of the project.
  • Successfully delivered multiple high-profile projects on time, ensuring client satisfaction and fostering long-term relationships.
  • Demonstrated strong leadership skills by effectively managing diverse teams and maintaining high levels of motivation, even during challenging periods of significant change or tight deadlines.
  • Assessed project milestones and team performance to keep staff on-task.
  • Developed strategic roadmaps for technology initiatives aligned with organizational goals while maintaining focus on resource allocation efficiency.
  • Spearheaded migration of legacy systems to cloud-based platforms for increased scalability, cost-efficiency, and security measures.
  • Fostered a culture of innovation within the technical team by encouraging experimentation with cutting-edge technologies and tools.

Module Lead

Mphasis
08.2006 - 02.2012

• ACBS is a comprehensive commercial lending and trading system that consists of integrated functional modules that support the lending process from deal building through servicing and trading

• ACBS integrates front-office origination, syndication, deal structuring, documentation, and credit approval, portfolio monitoring and trading with back-office servicing and accounting processes

• More than 100 lenders worldwide use the system, including Global 50, government and export finance, private bank and custody, and non-bank financial companies, U.S

• Regional banks and agriculture lenders

• Understanding business requirement from client and coordination with teams

• Continuous review of Business-critical database to proactively identify performance tuning issues

• Involved in tuning jobs, time/CPU consuming SQL queries

• Analyze AWS reports to identify on-going/proactive issues and work with DBA to resolve.

Software Engineer

POLARIS - CITIBANK
01.2003 - 04.2006
  • Consistently met project deadlines by effectively managing time and prioritizing tasks according to importance.
  • Analyzed proposed technical solutions based on customer requirements.
  • Developed scalable and maintainable code, ensuring long-term stability of the software.
  • Collaborated with management, internal and development partners regarding software application design status and project progress.

• Involved in Oracle 9i migration activities

• Involved in preparation of impact analysis for the system

• Involved in coding for Pro* C

• Involved in coding for PL/SQL

• Involved in coding for Unix Shell

• Involved in Unit, System and UAT Testing.

Education

Master of Science - Computer Science

IGNOU
NEW DELHI
01-2006

Bachelor of Science - Computer Science

MADRAS UNIVERSITY
INDIA
01-2002

Skills

    SQL

    PL/SQL

    Unix/Linux - Shell Script

    Pro*C

    Normalization – 1NF,2NF,3NF

    Database Model

    Korn

    Bourne - Shell Scripting

    Databricks

    Dynatrace

    Toad

    SQL Developer

    Subversion

    GitHub

    Remedy

    ServiceNow

    Jira

    Confluence

    SOAP UI

    Informatica

    ELT - DBT (Data Build Tool)

    Windows

    UNIX

    LINUX

    Airflow

    Autosys

    CRON - Unix/Linux

    SQL Loader

    External Table

    UTL_HTTP

    Replication

    DBMS SQL TUNE - Performance Utility

    TIBCO

    Liaison

    REST

    SOAP

    AWS Databricks

    Extensive Experience with Oracle Database

    Life Sciences and Healthcare (LSH)

    Banking

Certification

• Veeva Vault Platform

• AWS Certified Cloud Practitioner

• AWS Certified Solutions Architect – Associate

• Snowflake – SNOWPRO Certified

• Databricks Lakehouse

Solution to replace Oracle CDC which resulted huge savings for client

  • Replaced Oracle Change Data Capture (CDC): Developed and implemented a Trigger-based solution to replace Oracle CDC, addressing the discontinuation of support from version 19 onwards.
  • Cost Savings: Resulting in annual savings of [$500,000] for the client.
  • Enhanced Real-Time Data Processing: Improved data accessibility and processing speed through efficient Trigger implementation, significantly enhancing operational decision-making.
  • Cross-Functional Collaboration: Worked closely with client IT and business teams to ensure seamless integration and execution of the new solution, maintaining data integrity throughout the migration process.
  • Client Satisfaction: Received positive feedback from client stakeholders for delivering a robust solution that mitigated risks associated with technology changes and improved data management capabilities.

Timeline

Senior Technical Lead / Technical Project Manager

HCL America INC
02.2012 - Current

Module Lead

Mphasis
08.2006 - 02.2012

Software Engineer

POLARIS - CITIBANK
01.2003 - 04.2006

Master of Science - Computer Science

IGNOU

Bachelor of Science - Computer Science

MADRAS UNIVERSITY
Madhan Subbiah