Applying Oracle PL/SQL Lead Expertise

Ramachandran Nandhagopal Email: ***********@*****.***

Oracle PLSQL Lead Developer Project Lead Location: Overland Park, Kansas

LinkedIn: https://www.linkedin.com/in/ram-n-521b5017/ Mobile: +1-913-***-****

Oracle PLSQL Java SpringBoot Angular REST API Kafka Snowflake Python GitLab Agile JSF EJB Business Analyst

Work Experience

Delivery Project Lead Mphasis Corporation T-Mobile Location: Kansas Feb 2022 - Till Date

●Enhanced query performance and SQL efficiency by applying execution plan hints and Bulk Collection, cutting over an hour of daily repetitive tasks.

●Developed advanced PL/SQL scripts using regular expressions for data validation, enhancing data accuracy by 25% and reducing data-related issues by 15%.

●Backend Development: Expertise in Spring Boot, leveraging its features for building RESTful APIs, microservices, and integrating complex business logic.

●Frontend Development: Advanced proficiency in Angular, creating dynamic, responsive, and performance-optimized web applications.

●I extensively utilized parallel execution and the APPEND hint to optimize the performance of large-scale data operations. By enabling parallel execution, I was able to process queries across multiple threads, significantly reducing execution time for resource-intensive SELECT and DML operations.

●Experienced in the CI/CD process, utilizing Jenkins for automating build and deployment pipelines, UDeploy for application deployment and release management, and Terraform for infrastructure automation to ensure scalable and consistent cloud resource provisioning

●Designed and optimized Linux shell scripts to automate system administration, enhance workflow efficiency, and monitor system performance.

●Possess strong expertise in working with JSON and RESTful APIs, specifically within database-driven applications and microservices architectures. Experienced in using JSON for data exchange, including parsing, generating, and manipulating JSON objects in PL/SQL procedures and functions.

●Automated repetitive tasks such as backups, log management, system updates, and implemented system monitoring scripts to track resources, disk space, and active processes.

●Leveraged awk, sed, and grep for efficient text processing, log analysis, and data transformation.

●Optimized Logic for Updating CLOB Data (Using Append).

●I utilize Splunk to swiftly identify and resolve bugs during development by analyzing real-time logs and performance metrics.

●Skilled in maintaining cloud applications using Docker for containerization, EKS for scalable orchestration, and AWS services such as S3, SQS, SNS, and Lambda for efficient cloud infrastructure management.

●Led the team to deliver high-quality projects on time and within budget, boosting client satisfaction. Collaborated with cross-functional teams to gather business requirements and design scalable, efficient database solutions.

●Extracted data from diverse sources using PySpark's DataFrame API, enabling efficient integration and processing. Leveraged PySpark SQL to run advanced queries for complex data wrangling and aggregation

●Developed optimized stored procedures and functions, and implemented effective database indexing strategies, significantly enhancing data processing, query execution speed, and overall system performance.s

●Hands-on experience with CI/CD configuration in GitLab, automating PL/SQL deployments (DDL/DML).

●In-depth knowledge of GitLab workflows, including branching, pipelines, and merge requests.

Sr. Software Engineer Mphasis LTD Sprint Corporation Location: India Feb 2015 to Feb 2022

●PL/SQL Solution Design: Designed and implemented innovative PL/SQL solutions, including custom packages, to automate repetitive tasks, saving the team an average of 15 hours per month.

●Performance Tuning: Leveraged Bulk Collections to enhance performance and minimize context switching between SQL and PL/SQL engines.

●Issue Resolution: Utilized Pragma Autonomous Transaction to address mutating table issues in database triggers.

●Robust Exception Handling: Implemented comprehensive exception handling for better debugging and clearer error reporting.

●Backend Java Development: Contributed to backend development using Core Java, JSF, and EJB3, integrating enterprise systems via REST and SOAP APIs.

●Database Optimization: Focused on data modeling, replication, performance tuning, and overall database optimization within the Oracle environment.

●Task Automation: Automated routine tasks like backups, log management, and system updates, improving operational efficiency.

●Efficient Text Processing: Used awk, sed, and grep for efficient log analysis, text processing, and data transformation.

●Deployment Automation: Created deployment scripts for seamless code deployment, configuration management, and environment setup.

●Applied Agile principles to optimize project management processes, enhance team communication, and consistently deliver high-quality projects on time and within budget, driving increased client satisfaction.

●Mentorship: Mentored junior team members, fostering their professional development and improving overall team performance.

●Project Efficiency: Accelerated project timelines through effective resource allocation and task delegation

Senior Programmer -Development Kumaran Systems (P) LTD Bell Canada Location: India Jun 2010 to Feb 2015

●Ticketing Solution Development: Designed and implemented a ticketing solution for Bell Canada, streamlining issue tracking and resolution processes.

●Mentorship: Provided mentorship to junior developers, fostering their professional growth and enhancing team productivity.

●Agile Development: Led the development of scalable applications using agile methodologies, ensuring timely and efficient project delivery.

●Quality Assurance: Executed feature test cases manually using Quality Center, validating and reporting defects through Clarify to ensure product quality.

Past Experience

●Software Engineer Coromandel Infotech (I) Ltd TMB Bank Location: India Dec 2007 - June 2010

●Software Developer Shriram Groups Location: India June 2007 - Dec 2007

Career Overview

●16+ years of experience as a Java/Oracle PL/SQL Developer, specializing in business applications using Oracle RDBMS, Oracle Forms, and Reports.

●Expertise in data analysis, modeling, development, testing, and documentation across full project lifecycles.

●Proficient in all SDLC phases and Experienced Backend Developer with expertise in Core Java, JSP, JSF, Primefaces, EJB3, and Java REST APIs and transaction management.

●Developed a responsive user interface for the e-commerce platform using Angular, enabling customers to browse products, add items to their cart, and complete purchases seamlessly across devices.

●Extensive experience in RDBMS, EAV Model Databases, and optimizing performance with Indexes, Execution Plans, and Query Optimizer

●Inserted large data, using APPEND can improve performance significantly as it avoids logging undo/redo and maintains the table's high-water mark, making future inserts faster.

●Designed innovative PL/SQL solutions (custom packages) that saved 15 hours/month by automating repetitive tasks and launched PL/SQL training for 15 team members, increasing project delivery speed by 30%.

●Proficient in Kafka Consumer Topics, data flow diagrams, ER modeling, and advanced Exception Handling for debugging and error management.

●Hands-on experience with Google Cloud and Azure to manage and scale database solutions

●Expertise in SQL Loader, External Tables, Dynamic SQL, and partitioning techniques (Range, List, Hash) for large datasets.

●Proficient in AWS services like S3 for storage, SQS for message queuing, SNS for notifications, and Lambda for serverless computing, enabling efficient and scalable cloud application management.

●Experienced in Agile (SCRUM), Waterfall methodologies, and version control with GitLab ( CI/CD pipeline), delivering high-quality solutions on time.

Skills

●Programming & Scripting: SQL, PL/SQL (Schema / DB Link / Synonyms/ DBMS Scheduler / Triggers/ Procedures/ Functions/ Packages/ Indexes), PySpark, Python, MLlib, Pandas, SQL, Java, JavaScript, Struts, EJB, JSP, JSF, SprintBoot, Angular, JQUERY, Java Rest API, Kafka Consumer, Event Hub, SQL Query fine tuning, Advanced SQL Queries

●Databases: Oracle, MS SQL Server.

●Database Tools: Oracle Forms, Oracle Birt Reports, SQL Navigator 5.5, PLSQL Developer, SQL Developer, TOAD for oracle.

●Big data Monitoring platform : Splunk 8.1.5.3

●Business Intelligence : Tableau

●Versioning Tools and Processes: GitLab, GitHub, CVS, SVN, Agile & Jira.

●Cloud Platforms : Google Cloud, Azure, AWS (S3)

Certification

●Sun Certified Java Professional, 2009

Education

●Bachelor BSc Maths University of Madras India Chennai 2003

●Masters MCA University of Madras India Chennai 2006

Contact this candidate