SUMMARY:

• Around 7 years of experience in Oracle PL/SQL Development in addition with DevOps Development.
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions and Materialized Views.
• Created Tables, Views, Constraints and Index.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Developed materialized views for data replication in distributed environments.
• Loaded Data into Oracle Tables using SQL Loader.
• Expertise in Dynamic SQL, Collections and Exception handling.
• Experience in SQL performance tuning using Cost - Based Optimization (CBO).
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
• Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.
• Experience in using AWS EC2, Docker, GIT, Kubernetes and Microservices architecture.
• Hand on experience on DevOps (CI/CD) process using Jenkins and other DevOps Tools.
• Built and deployed Docker containers to break up monolithic application into microservices, improving developer workflow, increasing scalability, and optimizing speed.
• Experience in building and deploying large scale applications with high available / responsive system.
• Knowledgeable in SCM practices such as Branching and code merge.
• Strong working knowledge of Cloud environment and tools.
• Hands-on knowledge of software containerization platforms like Docker and container orchestration tools like Kubernetes
• Experience in writing and executing Functional Test cases and share the report to Management.
• Experience with automation/ integration tools like Jenkins and developed Test Automation Framework.
• Experience with Selenium and automated the Sanity and Regression Test cases.
• Handled multiple roles such as System Engineer/Business Analyst, Developer, Tester, Scrum Master and Subject Matter Expert.

TECHNICAL SKILLS:

Programming Languages: Oracle SQL and PL/SQL, Core Java

Database: Oracle 8i,10g,12c

IDE/Text Editors: STS, TOAD, SQL Developer, Visual Studio

Version Control Systems: GIT, GITHUB and Bitbucket

DevOps, Cloud and Automation Tools: Jenkins, Maven, AAF, Kubernetes, Selenium, AWS, Docker, TestNG

Methodologies: Waterfall and Agile

Operating Systems: Windows, UNIX and Linux on Cloud

EXPERIENCE:

Confidential, Dallas, TX

Senior Application Programmer

Responsibilities:

• Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data
• Played as a Scrum master for critical projects.
• Generated PL/SQL scripts for data manipulation and validation and materialized views for remote instances
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to processing layer
• Created scripts to create new tables, views, queries for new enhancement in the application using SQL Developer
• Created indexes on the tables for faster retrieval of the data to enhance database performance
• Created records, tables, collections (nested tables and associative arrays) for improving Query performance by reducing context switching
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application
• Explain plan analysis on low performing SQL queries and providing recommendations to improve response time
• Work with data migration/development/testing teams for successful completion of performance tests
• Created archival/purge scripts to remove old data based on the business data retention policy
• Data analysis report generation and provide to Clients on the business growth
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD
• Implementing the DevOps process to automate the build and deploy activities.
• Experience architecting and supporting highly available and highly scalable infrastructure
• Manage the provisioning/building/configuring/maintenance of environments using automation where possible
• Maintained the code using version control system like Git
• Automated the build process using Jenkins and AT&T ECO pipeline
• Handled the containerization using the Kubernetes
• Deployed Angular applications on AWS EC2
• Implemented Declarative pipeline to automate the build and deploy process.
• Developed Test Automation framework using DevOps tools
• Played as a Scrum master for critical projects
• Debugging the Production issues and provide innovative solutions to Client
• Review of code changes, test procedure, test plans and other deliverables
• Involved in User Acceptance Testing, Production Verification Testing and deployment activities.
• Written Functional Test cases to test the entire application and executed it.
• Automated the daily Sanity Test and Regression test cases.
• Implemented the Test Automation framework with Java, Selenium, TestNG and Jenkins Pipeline.
• Involved in Agile/SCRUM process, attending daily stand up and completing tasks in sprints.

Confidential

Application Programmer

Responsibilities:

• Extensively involved in various phases of Software Development Life Cycle such as Requirements Analysis, Design and Implementation and Maintenance in Agile environment
• Developed complex PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic
• Generated PL/SQL scripts for data manipulation and validation and materialized views for remote instances
• Performance review/signoff of all DB deliverables (Indexes, Stored Procedures, Tables, etc.,)
• Profile DB queries to identify performance bottlenecks
• Compare baseline test results with the release test results and come with the recommendations
• Prepare coding standards document and PL/SQL performance checklist and distributed to the development team

Confidential, GA

Application Programmer

Responsibilities:

• Create SQL Server Jobs to schedule nightly jobs to process every day technician work data
• Create stored procedures to process data from staging to summary/reporting tables
• Involved in the design, coding, deployment and maintenance of the project
• Involved in test procedure, test plans and other deliverables
• Prepared artifacts like Test Strategy, UAT Release Notes, SCM document etc.