Mahendra Allam
Leander,TX
Summary
Database developer with 12 years of experience in Oracle PL/SQL, specializing in advanced SQL techniques and ETL workflows. Adept at designing and optimizing database objects and implementing robust solutions that improve application performance and data management across enterprise environments.
Overview
13
13
years of professional experience
Work History
Sr.PL/SQL Developer
State of Texas (DFPS)
Austin, TX
05.2025 - Current
- Collaborated with business stakeholders, data analysts, and architects to understand requirements and translate them into technical solutions.
- Involved in the complete Software Development Life Cycle (SDLC), including requirement analysis, design, development, testing, implementation, and support.
- Partnered with cross-functional teams to build, validate, and deploy scalable database applications and solutions.
- Designed and developed Oracle database objects such as tables, packages, procedures, functions, triggers, and views using PL/SQL and TOAD.
- Implemented PL/SQL components to support business processes and improve application performance.
- Scheduled database jobs and email notifications through Oracle Scheduler utilities to automate recurring business activities and enhance operational efficiency.
- Utilized advanced SQL and PL/SQL programming techniques, including collections, cursors, dynamic SQL, materialized views, and performance tuning methodologies.
- Developed high-performance SQL statements involving complex joins, subqueries, set operators, indexes, and database optimization techniques.
- Built and supported ETL workflows to extract, transform, validate, and load data across multiple source and target systems.
- Performed large-scale data migration and integration activities using database utilities and bulk data-loading mechanisms.
- Managed source code repositories and maintained database release documentation through Git-based version control processes.
- Conducted peer reviews to improve code quality, maintainability, and compliance with development standards.
- Implemented data security measures and supported regulatory compliance initiatives, including data protection and privacy requirements.
- Utilized Autotask PSA and Datto platforms to streamline service management, ticketing, and operational workflows within MSP environments.
- Developed and maintained integrations with external applications through RESTful and SOAP-based web services.
- Designed and maintained database indexing strategies to enhance query execution efficiency and optimize overall database performance.
- Loader, and Unix Shell scripting to ensure accurate and efficient data processing.
- Produced detailed technical documentation, including database architecture, functional and technical specifications, workflow diagrams, ETL design documents, deployment procedures, and end-user guides.
- Implemented PL/SQL triggers to automate business processes, enforce application rules, and ensure data consistency across database objects.
Sr.PL/SQL Developer
VERTEX-ONE/Georgia Natural Gas
Atlanta, Georgia
05.2024 - 05.2025
- Developed complex database objects including Stored Procedures, Functions, Packages, Triggers, Views, Sequences, Synonyms, Cursors, and Ref Cursors using SQL and PL/SQL to support Billing, Metering, Customer Management, Supply Chain, and Warehouse Management applications.
- Designed and developed ETL programs to load supplier, customer, product, inventory, and transactional data from multiple source systems into Oracle databases.
- Developed PL/SQL routines for usage estimation, data validation, and exception handling to enhance meter processing accuracy for both interval and non-interval meters.
- Designed and implemented PL/SQL programs for billing cycle processing, bill adjustments, proration, and rate recalculations in compliance with utility business and regulatory requirements.
- Developed flexible PL/SQL billing structures to support multi-utility billing, multiple rate plans, and different usage measurement units.
- Implemented PL/SQL validation rules to detect and prevent duplicate billing, missing usage records, and incorrect tariff calculations.
- Collaborated with QA and testing teams to design and validate PL/SQL test cases, including edge cases such as zero usage, negative usage, and estimated meter reads.
- Integrated Oracle applications with third-party systems such as Outage Management System (OMS) and Customer Information System (CIS) to streamline data flow and improve operational efficiency.
- Worked on Banner Customer Information System (CIS) to support utility business operations, including customer management, billing, metering, and service order processing.
- Designed and maintained database objects including Stored procedures, Functions, Packages, Triggers, Views, and Materialized views to support Banner CIS application.
- Developed interfaces between Banner CIS, Meter Data Management System (MDMD), ERP, Outage Management Systems (OMS), and other enterprise application.
- Participated in Oracle application migration from Oracle 11g to Oracle 19c, refactoring PL/SQL code to ensure compatibility and scalability while enhancing overall application performance.
- Automated batch processing for meter data collection, reconciliation, billing, and energy forecasting using PL/SQL, Oracle Scheduler, SQL
- Loader, Shell Scripts, and Unix Cron.
- Created SQL
- Loader Control Files and automated data loading processes using Unix Shell Scripts.
- Loaded and migrated data from legacy systems into Oracle Data Warehouse environments while ensuring data integrity and business rule compliance.
- Performed data cleansing and validation to eliminate invalid, duplicate, and inconsistent records from Data Warehouse tables.
- Developed complex SQL queries using Inner Joins, Outer Joins, Correlated Subqueries, UNION ALL, INTERSECT, MINUS, Analytical Functions, Sequences, and Indexes.
- Created and maintained Indexes to improve query performance and optimize database access.
- Performed SQL and PL/SQL performance tuning using EXPLAIN PLAN, SQL
- Trace, TKPROF, AUTOTRACE, Oracle Optimizer Hints, and Bulk Collect technique.
- Optimized SQL execution plans by utilizing Oracle Optimizer Hints and performance tuning best practices.
- Implemented robust exception handling in PL/SQL programs to improve application reliability, debugging, and maintainability.
- Automated Oracle and Informatica workflows using the Unix Cron Utility in Unix environments.
- Extensively used TOAD for developing, debugging, and optimizing Oracle PL/SQL code.
- Developed SQL Server Stored Procedures and Functions to migrate data from legacy SQL Server databases into Oracle Data Warehouse tables.
Sr.PL/SQL Developer
FDNY(Fire Department of New York)
Brooklyn, NY
10.2023 - 05.2024
- Gathered business requirements from data analysts and architects, performed technical analysis, and proposed effective database solutions.
- Contributed to the complete Software Development Life Cycle (SDLC), including analysis, design, development, coding, testing, debugging, deployment, and production support.
- Collaborated with cross-functional teams to design and maintain enterprise database applications, enhancing functionality through development and testing.
- Developed and maintained database objects including Tables, Views, Materialized Views, Indexes, Stored Procedures, Functions, Packages, Triggers, Cursors, Ref Cursors, Collections, and Dynamic SQL using Oracle PL/SQL.
- Created and maintained PL/SQL packages, procedures, and functions to meet specific business and functional requirements, ensuring robust database performance.
- Developed PL/SQL procedures utilizing DBMS_SCHEDULER to automate scheduled jobs, including weekly email notifications to users.
- Wrote complex Oracle SQL queries using Inner Joins, Outer Joins, UNION ALL, INTERSECT, MINUS, Sequences, Indexes, and Analytical SQL techniques.
- Designed and developed ETL processes using T-SQL, SSIS, and Oracle PL/SQL to load, transform, and validate data.
- Loader, and PL/SQL.
- Maintained T-SQL and PL/SQL source code using Git and documented database changes following version control best practices.
- Conducted code reviews and enforced SQL coding standards, naming conventions, and development best practices.
- Implemented data security features including data encryption, data masking, and GDPR compliance standards.
- Worked with Autotask PSA (Datto) to configure Contracts, Projects, and Service Desk modules and integrated applications using Autotask REST and SOAP APIs.
- Troubleshot database performance issues, employing EXPLAIN PLAN, DBMS_OUTPUT, and query optimization techniques to enhance overall application efficiency.
- Worked with Oracle Cloud Infrastructure (OCI) services including Compute, Storage, Networking, Oracle Database, and Identity and Access Management (IAM).
- Developed, deployed, and maintained cloud-native applications and database solutions on Oracle Cloud Infrastructure (OCI).
- Integrated Oracle databases with cloud-based applications using Oracle Database services and OCI infrastructure.
- Followed Oracle best practices and industry compliance standards for secure application development and cloud deployments.
- Developed database deployment scripts for creating and maintaining Tables, Views, Indexes, Constraints, and other schema objects.
- Designed and developed Tableau dashboards and visualizations to support business reporting and analytics.
- Provided production support by analyzing issues, troubleshooting defects, and implementing timely resolutions for business users.
- Created and optimized indexes to improve SQL query performance and database response time.
- Loader, and Unix Shell Scripts.
- Created comprehensive technical documentation, including database design documents, functional specifications, process flow diagrams, ETL mappings, deployment guides, and user documentation.
- Developed PL/SQL database triggers to enforce business rules and maintain data integrity.
- Analyzed SQL statements, reorganized database objects, and optimized execution plans to improve application performance.
- Developed complex reports and ad hoc SQL queries to support client reporting requirements and production support activities.
- Provided on-call production support, resolved user-reported issues, and implemented application enhancements and bug fixes.
- Environment: Oracle 10g, PL/SQL, UNIX, TOAD, T-SQL, Oracle Forms 9i/10g, Autotask, Reports 9i/10g, Erwin, IBM WebSphere DataStage, MKS Integrity, CVS, SUN Solaris, MS SQL Server.
Sr.PL/SQL Developer
TCS/Barclays
, New Jersey
08.2022 - 09.2023
- Developed complex database objects including Stored Procedures, Functions, Packages, Triggers, Views, and Cursors using SQL and Oracle PL/SQL.
- Executed SQL and PL/SQL performance tuning through query optimization, indexing strategies, execution plan analysis, and parallel processing techniques to enhance overall database performance.
- Tuned SQL statements using EXPLAIN PLAN, SQL Trace, TKPROF, Index Rebuilding, and Oracle performance optimization technique.
- Improved SQL execution performance by analyzing execution plans and implementing query optimization strategies.
- Designed and optimized Indexes to improve query execution and overall database performance.
- Optimized large-volume data processing using Bulk Collect, Bulk Bind, PL/SQL Collections, and Ref Cursors.
- Utilized Ref Cursors and Collections to efficiently retrieve and process complex result sets involving multiple table joins.
- Implemented robust Exception Handling in PL/SQL programs to improve application stability, debugging, and error reporting.
- Analyzed, debugged, and enhanced existing PL/SQL Procedures, Functions, Packages, and Triggers to support new business requirements.
- Developed Stored Procedures and Triggers to implement and enforce business rules and data validation.
- Participated in PL/SQL code reviews and implemented enhancements to support new business requirements.
- Developed database deployment scripts for creating and maintaining tables, views, indexes, and other schema objects to support application enhancements.
- Performed data migration activities while ensuring data accuracy, consistency, and integrity.
- Leveraged Parallel Processing techniques to improve SQL execution performance for large-volume data processing.
- Collaborated with production support and operations teams to troubleshoot and resolve production issues, while ensuring compliance with defined SLAs.
- Analyzed database objects, including tables and indexes, to identify and implement performance improvements.
- Resolved QA defects and application issues by performing root cause analysis and implementing effective solutions.
- Developed and executed Unit Testing and Integration Testing scenarios to validate application functionality and database changes.
- Worked with Oracle APEX for application development and database-driven web solutions.
- Worked with Python, Apache Spark, and Machine Learning technologies for data analysis and processing.
- Extracted, transformed, loaded, and analyzed Oracle database data using Python, and analyzed large datasets using Hive, Hadoop, and Apache Spark.
- Utilized AJAX techniques to improve application responsiveness by reducing page reloads and enhancing user experience.
- Managed database environments including Oracle 10g, 11g, 12c, and 18c.
- PLUS, Informatica, SQL
- Loader, CVS, Autotask, TOAD, UNIX, Shell scripting. Python, Scala.
- PLUS, Informatica, SQL
- Loader, CVS, Autotask, TOAD, UNIX, Shell scripting. Python, Scala.
Sr.Oracle PL/SQL Developer
Geometric Ltd/Ford
Chennai
11.2016 - 06.2021
- Developed Oracle PL/SQL applications supporting Warehouse Management Systems (WMS) and logistics business processes.
- Designed and developed database objects including Tables, Views, Sequences, Synonyms, Stored Procedures, Functions, Packages, Cursors, Ref Cursors, and Triggers to support warehouse transaction processing.
- Developed complex SQL queries using Joins, Correlated Subqueries, Analytical Functions, and advanced SQL techniques to support business reporting and operational processes.
- Designed and implemented interfaces between Warehouse Management Systems (WMS), Enterprise Resource Planning (ERP), Transportation Management Systems (TMS), and third-party logistics (3PL) applications.
- Developed inventory movement logic to support receiving, put-away, picking, packing, shipping, returns, and inventory transfers.
- Developed and maintained batch jobs to synchronize inventory across multiple warehouse locations, enhancing data consistency.
- Built automated processes for cycle count reconciliation, inventory adjustments, and stock validation to improve inventory accuracy.
- Supported daily warehouse batch processing, monitored scheduled jobs, resolved production failures within SLA timelines, and participated in month-end inventory closing activities.
- Improved application performance by implementing Bulk Collect, Bulk Bind, PL/SQL Collections, and Ref Cursors for efficient high-volume data processing.
- Implemented robust Exception Handling in PL/SQL programs to improve application reliability, debugging, and maintainability.
- Automated Oracle and Informatica workflows using Unix Cron Utility, Shell Scripts, and Oracle scheduling utilities.
- Created Unix Shell Scripts and SQL commands to automate data processing tasks, streamlining workflows and reducing manual effort.
- Designed and developed Informatica Mappings to extract data from flat files and relational databases into staging areas and load it into the Data Warehouse.
- Developed Informatica ETL solutions using transformations including Aggregator, Lookup, Router, Source Qualifier, Filter, Expression, Sequence Generator, Update Strategy, Joiner, and Union.
- Developed reusable Workflows, Worklets, Mappings, and Mapplets to improve ETL reusability, maintainability, and performance.
- Developed Shell Scripts to automate business processes and ETL execution.
- Created ABPP (Agile Business Process Platform) workflows to orchestrate Oracle Packages, Informatica Workflows, and Shell Scripts according to business requirements.
- Deployed application code across Development, QA, UAT, and Production environments while maintaining version consistency using IBM ClearCase.
- Created and executed Test Cases for verification, validation, and regression testing of Change Requests to ensure application quality and business compliance.
- Environment: Oracle 10g / 11g/12c, SQL, PL/SQL,Pro
- C, SQL
- PLUS, Informatica, SQL
- Loader, Oracle Forms 9i/10g, Reports 9i/10g, CVS, SOAP, REST, TOAD, UNIX, Shell scripting, apex, css, JavaScript.
Oracle SQL Developer
Capgemini
Chennai
06.2013 - 10.2016
- Developed Oracle PL/SQL database objects including Stored Procedures, Functions, Packages, Cursors, Pipeline Functions, and Triggers based on business requirements.
- Created and maintained database objects including Tables, Views, Materialized Views, Synonyms, Sequences, and Indexes to support application development.
- Collaborated with business users and clients to gather and analyze business requirements, translating them into actionable technical solutions.
- Designed logical and physical database models by defining entities, relationships, data flows, and database structures.
- Participated in database design, normalization, and data modeling to ensure scalability, integrity, and optimal performance.
- Applied knowledge of Data Warehousing, Normalization, ETL processes, documentation, preventive maintenance, code reviews, automation, Stored Procedures, and Triggers during application development.
- Integrated and merged customer data from multiple source systems into the Enterprise Data Warehouse while maintaining data integrity and consistency.
- Implemented robust exception handling and data validation to identify, log, and process invalid or inconsistent data records.
- Developed and implemented data archival and purging strategies to remove obsolete data while maintaining database performance and compliance.
- Automated database processes and batch operations using Unix Shell Scripts and AutoSys scheduling.
- Developed and maintained PL/SQL programs to implement complex business rules and optimize database processing logic.
- Prepared and delivered technical presentations and knowledge-sharing sessions on Oracle database architecture, PL/SQL development, and database operations.
- Optimized SQL queries and PL/SQL programs using Oracle Optimizer Hints, EXPLAIN PLAN, SQL Trace, profiling techniques, DBMS_STATS, and Cost-Based Optimization (CBO) to improve application performance.
- Environment: Oracle 10g, PL/SQL, Oracle FMW, Xml, Visio, UNIX Shell scripts, SVN, Toad, SQL Developer, HP Quality Center, SQL
- Loader, Import Export, Autosys.
Education
Master Degree - Computer and Information Systems
New England college
NH01-2022
Bachelor Degree - Computer Science
JNTU K
INDIA01-2013
Skills
- Database management
- Project management tools
- Programming Languages: SQL, PL/SQL, T-SQL, Unix shell scripts, SAS, C/C/C#, Perl, XML, Java, HTML, VBNET, python, spark, apex, JavaScript
- ETL tools
- Data warehousing design
- Development tools
- Tools: TOAD, SQL
- PLUS, SQL Developer, SQL
- Loader, Crystal Reports, Tableau, Forms 6i/9i/10g, Reports 6i/9i/10g, Workflow Builder and XML Publisher
Timeline
Sr.PL/SQL Developer
State of Texas (DFPS)
05.2025 - Current
Sr.PL/SQL Developer
VERTEX-ONE/Georgia Natural Gas
05.2024 - 05.2025
Sr.PL/SQL Developer
FDNY(Fire Department of New York)
10.2023 - 05.2024
Sr.PL/SQL Developer
TCS/Barclays
08.2022 - 09.2023
Sr.Oracle PL/SQL Developer
Geometric Ltd/Ford
11.2016 - 06.2021
Oracle SQL Developer
Capgemini
06.2013 - 10.2016
Master Degree - Computer and Information Systems
New England college
Bachelor Degree - Computer Science
JNTU K