Summary
Overview
Work History
Education
Skills
Timeline

Sindhu Murugappan

Oracle Database Expert In PL/SQL, RAC Infrastructure, Oracle DBA, Blue Green Implementation, Automation Using Rundeck, Etc
Chennai,TN

Summary

  • Technocrat with 13+ years of exceptional experience in Oracle 10g & 11g PL/SQL, Oracle RAC Architecture, Oracle DBA, OGG replication, Unix Shell scripting, Python scripting, BigData, Hive, Spark, Data Analytics, Machine Learning, etc
  • Strong people management; managed a high performing technical team of 16 members
  • Expertise in Design, performance improvement, fixing heated production issues, problem solving with a passion for technology with skills in grasping the big picture and applying technology / mix of technologies that meet business needs while minimizing risks
  • Have achieved Zero Downtime implementation with Blue-Green method adoption; resolved various lock/dead-lock, slowness issues in production; performed online reorg on tables and indexes; worked on Oracle Text Indexes for fuzzy pattern matching
  • Automated (application) DB object implementation in production using Shell Scripting and Run Deck
  • Provided DevOps solutions for database related source/script maintenance and implementation

Overview

9
9
years of post-secondary education
13
13
years of professional experience

Work History

Senior Manager

Standard Chartered GBS Pvt Ltd
Chennai, TamilNadu
07.2017 - Current
  • Working on wholesale banking payment system - STS (Straight Through Processing) system and Cash Data Lake systems.
  • Working on a huge DB environment with 46 schemas in 4 DBs built on 2 nodes RAC architecture with SAN storage; handling Manual Load management of nodes.
  • Overall Database technical manager taking End-to-End responsibility of anything related to database activities including design and code review and sign-off, production issues fixing, System Improvement Plan and implementation, performance improvement, release management, automation, etc
  • End-to-End control of all non-production environments including Database creation, Storage management, Access Management, RMAN backup, OGG/CDC replication setup and management.
  • Migration of multiple stand-alone databases to an existing RAC environment.
  • Done a POC in building machine learning model for deriving appropriate Rejection Codes with the user input Rejection reason for payments.
  • Contributed for building Data Lake for our portfolio in the bank, using BigData Hive, Spark, Python scripting and Microstrategy reporting in T1/T2/T3 architecture.

Delivery Module Lead

Mphasis Pvt Ltd
Chennai, TamilNadu
07.2014 - 07.2017
  • Worked for American International Group (AIG) - Legal Entity management (LEM) system.
  • Lead a team of 3 members
  • Individual contributor - handled requirement gather, design, development, testing and implementation from offshore
  • Used advanced concepts like DBMS_PARALLEL_EXECUTE, Bulk collection, RefCursors, DBMS_PROFILER, SQL Loader, Partitioning, Table Audit Management, etc
  • Created Autosys jobs to execute a PL/SQL proc or shell script

IT Analyst

Tata Consultancy Services
Chennai, TamilNadu
08.2010 - 07.2013
  • Worked for SCB client from their location in Chennai in projects like STP (Straight Through Processes) and STS (Straight Through Service)
  • Used advanced concepts like Oracle Text Server and developed a text pattern matching application, Materialized Views, External Table, SQL Loader, etc
  • Have done Performance tuning, requirement gathering, development, implementation support.

Programmer Analyst

Cognizant Technology Services
Chennai, TamilNadu
06.2007 - 08.2010
  • Joined as fresher through Camus selection and worked for various clients like Abbott, Astrazeneca, etc from off-shore
  • Worked on Oracle, Cold Fusion, ASP.NET, etc
  • Worked on Development and Support projects

Education

10th Std -

MBN Govt Girls Hr Sec School, Chrompet, Chennai, Chennai
04.2001 - 03.2002

High School -

Hilton Matriculation Hr Sec School, Chennai
04.2002 - 03.2004

Bachelor of Science - Mathematics

Meenakshi College For Women, Kodambakkam, Chennai, Chennai
04.2004 - 03.2007

Master of Computer Applications -

Madras University (Part-Time), Chennai
04.2007 - 03.2010

Skills

    Oracle 10g & 11g (SQL & PL/SQL), Oracle RAC, Oracle DBA

Unix Shell Scripting, Python scripting

Zero Downtime implementation - Blue Green method, Deployment Automation of DB object changes

Design Expert, Performance improvements, Heated production issue fixes, DB Lock expert

BigData Hive, Spark, Data Analytics, Machine Learning

OGG Replication

Timeline

Senior Manager - Standard Chartered GBS Pvt Ltd
07.2017 - Current
Delivery Module Lead - Mphasis Pvt Ltd
07.2014 - 07.2017
IT Analyst - Tata Consultancy Services
08.2010 - 07.2013
Programmer Analyst - Cognizant Technology Services
06.2007 - 08.2010
Madras University (Part-Time) - Master of Computer Applications,
04.2007 - 03.2010
Meenakshi College For Women, Kodambakkam, Chennai - Bachelor of Science, Mathematics
04.2004 - 03.2007
Hilton Matriculation Hr Sec School - High School,
04.2002 - 03.2004
MBN Govt Girls Hr Sec School, Chrompet, Chennai - 10th Std,
04.2001 - 03.2002
Sindhu MurugappanOracle Database Expert In PL/SQL, RAC Infrastructure, Oracle DBA, Blue Green Implementation, Automation Using Rundeck, Etc