We provide IT Staff Augmentation Services!

Senior Application Programmer Resume

2.00/5 (Submit Your Rating)

Dallas, TX

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.

We'd love your feedback!