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.