Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Domainknowledge
Timeline
Generic

Madhan Subbiah

Plymouth Meeting,PA

Summary

A Self Driven Professional with around 15+ Years of experience in Health Care Domain & BFSI (Banking Financial Service and Insurance). Highly Technical, Project Management Skills, Team-Oriented, Team handling, Client facing, maintenance & support experience in Life Sciences and Healthcare domain for Client Merck & Co with good exposure to applications: ESA(Enterprise Sharing Architecture), Workday, SIR(Single Identity Repository), AD(Active Directory), SPECTRUM(CRM application for Clinical Trial), EDC(Electronic-Data-Capture), CLMS(Clinical Learning platform), Exostar, SIP(Shared Investigator Platform) Highly skilled in managing database performance and upgrades for ongoing efficiency and achievement of corporate objectives. Innovative technical lead with in-depth understanding of software development and system design. Excellent communication skill and extensive experience working with client and partner. Detail-oriented team player with strong organizational skills. Good knowledge on Spark, Hadoop frame work. Actively involved in Databricks, PySpark,DBT (Data Build Tool),Airflow, AWS – S3, IAM. Ability to handle multiple projects simultaneously with high degree of accuracy. Hand-on experience in all phases of Software Development Life Cycle (SDLC) and software engineering methodologies such as requirement gathering, major & minor enhancements Development, Database migration, Data analysis, Performance tuning, integration, implementation, Extensive technical experience in Oracle, PL/SQL, Unix, Linux, HP ALM, Remedy, ServiceNow, Confluence, Jira for software development and production support. Lead Team for Production Support (level 2 and Level 3) as well as Development. Excellent Knowledge in Oracle - Performance Fine Tuning, Oracle Thread features

Overview

22
22
years of professional experience
1
1
Certification

Work History

Senior Technical Lead

MERCK
Pennsylvania, USA
02.2021 - Current
  • ZG - Zero Gravity Project – Study Optimizer
  • Work closely with Business to gather requirements and design a reliable and scalable data pipeline
  • Led Team of 10 in collaborative development of prototypes and designs for demonstration of concepts
  • Extract Source feed from Delta Lake of Gold Layer - medallion architecture
  • Design and develop data pipelines to ingest, store, and process data using DBT(ELT), leveraging Airflow
  • Hands-on Experience in Jinja and Macros in DBT to consume dynamic SQL’s
  • Developed PySpark code to extract the feed from DBT Models
  • Utilized panda data frames to convert spark data frames
  • Unload data from Databricks to AWS S3 in format of Compressed CSV folder
  • Oversee of GitHub repository, enforcing industry code version-control best practices and approving PRs
  • Involve in daily scrum meetings, sprint planning, sprint reviews and sprint retrospectives
  • Scheduled a Databricks Job using Job clusters
  • Invoke Databricks Job from Airflow
  • Developed and managed a team of data engineers, achieving a significant increase in productivity through the introduction of agile methodologies and continuous integration practices
  • Designed and executed a comprehensive data migration strategy from legacy systems to Databricks, reducing data redundancy and improving data retrieval time
  • Conducted regular training sessions on Databricks for the data team, enhancing their proficiency and leading to a 20% increase in team productivity.

Senior Technical Lead

MERCK
Pennsylvania, USA
02.2012 - 02.2021
  • Clinical Operational Reporting Environment (CORE)
  • A data warehouse resides on-premise with ORACLE as a RDBMS, built to provide support for End-to-End Provisioning to various downstream
  • CORE sources data from various authoritative sources
  • Aggregates and rollups data from various source systems
  • Publishes data to various subscribing systems
  • Manages workflow to publish data
  • Database environment having upstream & downstream applications subscribing data
  • Research Data Repository (RDR) is a centralized abstraction layer that facilitates the sharing of data between applications, reducing point-to-point and redundant interfaces
  • Subject Matter Expert for the Clinical Trial Applications
  • Involved in the continuous enhancements and fixing of production problems
  • Generated server-side PL/SQL scripts for data manipulation and validation and materialized view for remote instances
  • Attending meeting with business and understanding new requirement as well as existing requirement related code change to improve application productivity and functionality
  • Prepare effort estimation presentation deck for new release to present with Business representative and technical unit
  • Drafting project plan document and coordination with scrum master to create project in Jira confluence page
  • Involved in Impact Analysis and Design Documents
  • Code design, development, Unit Testing, System Integration Testing, UAT support, Release Management, Project Management
  • Deliver high level of service to clients to maintain and extend relationship for future business opportunities
  • Primary Role is to support Clinical data repository application as Level 3 by following change management, problem management and incident management
  • Attend daily meetings with application owner and provide status update of application
  • Manage all vulnerability of application including server, database, and application level
  • Coordinating with Business regarding downtime of application to support DB patch upgrades patch upgrade, Network patch upgrade, non-person account provisioning, Disaster recovery, Release implementation
  • Leading and Managing team including 10 members and assigning/distributing task
  • Expertise in Writing RDSM SQL queries for data validation at row and table level, Multiple-Column Sub queries, Scalar Sub-queries, and correlated sub queries
  • Partnered with cross project team members to identify and quickly address problems
  • Update customers and senior leaders on progress and roadblocks
  • Generate weekly and monthly status reports for helpful progress tracking
  • Identify and resolve risks to minimize project disruption
  • Mentor and guide staff to enhance performance and exceed customer expectations
  • Lead team meetings to access project progress and plan appropriately to meet deliver targets
  • Schedule and facilitate meetings between project stakeholders to discuss deliverables, schedules, and conflicts
  • Verify quality of deliverables and conformance to specifications before submitting to clients
  • Track project and team member performance closely to quickly intervene in mistakes or delays
  • Monitor project progress, identity risk and take corrective actions as needed
  • Maintain open communication by presenting regular updates on project status to customers
  • Work with customers or prospective customers to develop integrate solutions and lead detailed architectural dialogue to facilitate delivery of comprehensive solutions
  • Guide and influence existing partners on recommended upgrades and enhancements to integrated solutions
  • Lead Onsite and Offshore Team
  • Handle Client Escalation
  • Generate Added Value Ideas to the project
  • Extensively involved in preparation of pseudo-code for all complex releases
  • Major and Minor Enhancement of application
  • Resolution of Tickets (issues) on daily basis within the defined SLAs.

Module Lead

Mphasis
Washington - DC, USA
10.2011 - 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.

Module Lead

Mphasis
India, India
08.2006 - 02.2012
  • The Financial Industry Regulatory Authority (FINRA) is the largest independent regulator for all securities firms doing business in the United States
  • Created in July 2007 through the consolidation of NASD and the member regulation, enforcement, and arbitration functions of the New York Stock Exchange
  • FINRA is dedicated to investor protection and market integrity through effective and efficient regulation and complementary compliance and technology-based services
  • Develop the project as enhancement based on prepared requirement and Program Specification document
  • Writing stored procedures, functions and triggers in Oracle PL/SQL
  • Troubleshoot issue during peer review
  • Worked to support UAT and solving user’s queries.

Senior Software Engineer

Hewlett Packard
Chennai, India
04.2006 - 08.2006
  • ASHOK LEYLAND
  • Involved in preparation of control environment, a replication of production
  • Involved in coding for PL/SQL related activities
  • Involved in Unit, System and UAT Testing.

Software Engineer

POLARIS
Chennai, India
01.2003 - 04.2006
  • CITIBANK
  • Involved in Oracle 9i migration activities
  • Involved in preparation of impact analysis for the system
  • Involved in coding for Pro
  • C related activities
  • Involved in coding for PL/SQL related activities
  • Involved in coding for Unix Shell related activities
  • Involved in Unit, System and UAT Testing.

Education

Master’s Degree - Computer Applications

Indira Gandhi National Open University
New Delhi, India
01.2006

Bachelor’s Degree - Computer Applications

Madras University
Chennai, India
01.2002

Skills

  • SQL
  • PL/SQL
  • Unix/Linux - Shell Script
  • Pro
  • C
  • C Scripting
  • Korn
  • Bourne - Shell Scripting
  • Databricks
  • Dynatrace
  • Toad
  • SQL Developer
  • Subversion
  • GitHub
  • Remedy
  • ServiceNow
  • Jira
  • Confluence
  • SOAP UI
  • Informatica
  • 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

Accomplishments

  • Easy Adaptability and Grasp - System Knowledge within a short period of time
  • Solution to replace Oracle CDC which resulted huge savings for client.
  • Successful implementation of Oracle 19c migration.
  • Reduced Organization license cost of around 100k$ for Merck-Psync (Password synchronization) Application.
  • Successfully Implemented DR (Disaster Recovery) activity.
  • Innovation in Automation of Monitoring to reduce overall ticket count from the end-user as part of service improvement.
  • Performance Tuning – Improved overall run time processor for Provisioning Engine.
  • Awarded as ‘Innovator of June -13’ for bringing down the execution time of provisioning processor from 12 hours to 20 minutes.
  • Spot Excellence Award for reducing the run time of SQL Based Queuing Module from 48 hours to 2 hours which includes fine tuning around 81 queries.

Domainknowledge

  • Life Sciences and Healthcare (LSH)
  • Banking

Timeline

Senior Technical Lead

MERCK
02.2021 - Current

Senior Technical Lead

MERCK
02.2012 - 02.2021

Module Lead

Mphasis
10.2011 - 02.2012

Module Lead

Mphasis
08.2006 - 02.2012

Senior Software Engineer

Hewlett Packard
04.2006 - 08.2006

Software Engineer

POLARIS
01.2003 - 04.2006

Master’s Degree - Computer Applications

Indira Gandhi National Open University

Bachelor’s Degree - Computer Applications

Madras University

Similar Profiles

CREATE PROFILE
Madhan Subbiah