VENKAT VEERAMNENI

• Designed and optimized databases for mobile and web applications, utilizing Relational and NoSQL solutions for performance and scalability.

• Migrated high-volume data from RDS to DynamoDB, enhancing throughput and performance.

• Revamped a mobile application, improving performance and adaptability to evolving business needs.

• Integrated GitHub Actions into CI/CD pipelines, automating builds and enabling rapid feedback loops.

• Developed AWS Lambda functions in Python and Node.js for serverless processing.

• Leveraged AWS services—Aurora RDS, DynamoDB, CloudWatch, Cognito, API Gateway, AppSync, VPC, EC2—to build scalable, high-performance solutions.

• Led AS400 to Oracle migration projects for Yale Medical School, Yale Dining, Student Information Systems, and Yale Admissions.

• Developed PL/SQL packages, stored procedures, functions, and triggers to meet business needs.

• Designed new forms and batch processes for Yale Medical School post-migration.

• Migrated Yale Dining to a new Oracle-based system, handling analysis, design, and development.

• Provided production support for Yale Admissions, resolving system issues and optimizing performance.

• Maintained Alumni School Committee (ASC) and financial aid applications.

• Worked extensively with UNIX shell scripting for automation.

• Proficient in SVN, Git, JIRA, ServiceNow, and Deployment Manager.

• Managed batch jobs using Autosys job scheduler.

• Implemented CI/CD pipelines with Jenkins, reducing manual intervention by 50% and increasing deployment frequency by 30%.

• Developed and supported Groovy on Grails applications for Yale University Transit.

• Experience with Spring Security and Hibernate frameworks.

• Developed applications using IntelliJ IDEA for Groovy on Grails and Java.

• Extensive experience with Ellucian Banner ERP, supporting academic administration in compliance with Banner standards.

• Engaged in daily client interactions to address production issues and new projects.

• Utilized Oracle External Tables for efficient data processing.

• Designed and developed a Data Warehouse using Oracle Materialized View Fast Refresh and Talend for reporting.

• Developed ETL solutions using Oracle Data Integrator (ODI) to migrate data from multiple sub-systems into a unified target system.

• Designed and optimized database objects (indexes, sequences, synonyms, views, materialized views).

• Developed PL/SQL packages, stored procedures, functions, and triggers to meet business requirements.

• Scheduled jobs using DBMS_SCHEDULER for automated processing.

• Built ODI packages, interfaces, and models to map and load data efficiently.

• Implemented bulk processing techniques like Bulk Collect and FORALL for performance optimization.

• Conducted query performance tuning using EXPLAIN PLAN and TKPROF.

• Developed UNIX shell scripts for batch processing and bulk data loading.

• Utilized Dynamic SQL to generate and execute queries at runtime.

• Analyzed PL/SQL processes, logs, and error files for troubleshooting.

• Authored technical documentation (system design, functional specs, release notes, data flow diagrams) using MS Word & Visio.

• Monitored SQL performance and optimized code to reduce execution times.

• Utilized EXPLAIN PLAN, ANALYZE, HINTS, and indexing for query tuning.

• Validated and managed STATISTICS as part of performance tuning.

• Extensive experience with healthcare data, including medical claims and clinical records.

• Managed FTP-based file transfers between UNIX servers.

• Strong expertise in PL/SQL and UNIX for Production Support.

• Led data migration from Oracle 9i to 10g.

• Developed and optimized Materialized Views for improved performance.

• Created PL/SQL stored procedures for month-end batch processing.

• Authored detailed design documentation based on business requirements.

• Automated Faculty and Student Appointment processes, transitioning from paper-based to electronic workflows.

• Developed PL/SQL stored procedures, functions, packages, and triggers for appointment management.

• Proficient in Dynamic SQL, BULK COLLECT, REF Cursors, and VARRAYS for efficient data handling.

• Extensive experience with Ellucian Banner ERP, customizing Oracle Forms and Reports (6i to 10g upgrade) for educational institutions.

• Built Oracle Forms using Built-ins, Triggers, LOVs, PL/SQL Libraries, Object Libraries, and Property Classes for consistency.

• Developed Faculty Appointment application using ColdFusion 8, jQuery, AJAX, and JavaScript.

• Involved in all SDLC phases, including design, coding, testing, implementation, and training.

• Designed ColdFusion applications for faculty and student data management.

• Conducted performance tuning, unit testing, and execution to enhance efficiency.

• Designed materialized views and contributed to logical & physical data modeling.

• Utilized TOAD for database development and query optimization.

• Developed UNIX shell scripts & PL/SQL procedures to automate month-end batch processing.