Umasankar Dhanasingh
Chennai
Summary
Over 8 years of experience as an Oracle PL/SQL developer specializing in the analysis, design, and implementation of business applications using Oracle RDBMS. Proven technology leader with expertise in database management and ETL development. Successfully managed heterogeneous migrations, enhancing project visibility and reducing turnaround times. Committed to leveraging technical skills to drive operational efficiency.
Overview
11
11
years of professional experience
Work History
Lead Technology
Synechron Technologies
Chennai
02.2022 - Current
- Managed Jira-related changes to enhance project visibility and streamline update process over one year.
- Designed and implemented Heterogeneous Migration from Sybase-16 to Oracle-19c using Oracle GoldenGate.
- Utilized bulk collections to enhance data retrieval performance and reduce context switching.
- Worked extensively with ref_cursor bulk collect PL/SQL collections to optimize data handling.
- Conducted performance tuning for Oracle RDBMS using explain plan and optimizer hints to improve response time.
- Retrieved data from external files and loaded into Oracle tables using tools like UTL_FILE, SQL*Loader, and External Tables.
- Applied Oracle supplied packages such as DBMS_OUTPUT, DBMS_RESULT, DBMS_JOBS, DBMS_LOB, DBMS_PROFILER, and UTL_HTTP.
Software Specialist
Azentio Software Private Limited
Chennai
11.2017 - 02.2022
- Executed 3 Months on-site implementation of business specifications for Jubilee Insurance in Uganda(Jan 14th 2019 to April 17th 2019).
- Conducted 6 Months project for business specification and time-and-material support for Jubilee Insurance in Kenya(Jun 30th 2019 to Dec 29th 2019).).
- Developed and maintained SQL scripts, PL/SQL packages, procedures, functions, and objects.
- Utilized expertise in Oracle database management, including queries, triggers, cursors, and stored procedures.
- Applied knowledge of query optimization techniques, including indexing hints and table partitioning.
- Performed query analysis and tuning activities using bulk binds and global temporary tables.
- Experience in Integration and extensions using custom schema with PLSQL and/or SoA gateway and XML.
- Good knowledge in extracted data from XML and loaded it into database.(Schema to Schema integration and data manipulation using synonyms, enhancing with third party
API using rest and Soap services)
Executive Trainee
SPi Technologies India Private Limited
Chennai
01.2015 - 10.2016
- Streamlined workflows by implementing process improvements, enhancing operational efficiency.
- Compiled weekly reports on project status, highlighting key accomplishments and challenges to inform stakeholders.
Education
Bachelor of Computer Applications - Computer Programming
Thiruvalluvar Arts And Science College
Kurinjipadi, Cuddalore Dist03-2013
Skills
- Oracle database management
- SQL scripting
- SQL & PL/SQL optimizations
- Performance tuning
- Data Modeling & Normalization
- Data retrieval techniques
- ETL development for XML and JSON
- Bulk Collect and FORALL
- Heterogeneous migration
- Migration and Integration techniques
- UNIX shell scripting
- B2B, B2C, Host-to-Host Integrations
Languages
English
Proficient (C2)
C2
Tamil
Native
Native
Technology & Tools
Database : Oracle 9i/10g/11g/12c/19c (SQL, PL/SQL, Stored Procedures, Triggers), Sybase16, PostgreSQL
Tools : Oracle SQL Developer, PLSQL Developer, Toad, Tectia(Linux), Interactive SQL
Version Control & CI/CD: Bitbucket, Git, Jenkins, Teamcity, Urban Code deployment (UCD), Liquibase-LSE
Ticket Tracking : JIRA, SASS, SSP (Self Service Portal)
Personal Details
Father's Name : Dhanasingh. R
Date of Birth : 07/27/92
Nationality : Indian
Marital Status : Married
Timeline
Lead Technology
Synechron Technologies
02.2022 - Current
Software Specialist
Azentio Software Private Limited
11.2017 - 02.2022
Executive Trainee
SPi Technologies India Private Limited
01.2015 - 10.2016
Bachelor of Computer Applications - Computer Programming
Thiruvalluvar Arts And Science College