SUMMARY:

• Over 11+ years of progressive experience in software design, development, support and maintenance of large scale applications in Insurance, Healthcare and Telecom industries.
• Exposed to all aspects of software development life cycle (SDLC) such as Analysis, Planning, Developing, Testing, and Implementing and Post - production analysis of the projects.
• Proficient with AWS cloud services Ec2, S3, RDS,DMS,SCT, VPC, IAM etc
• Experience with CI/CD process and tools
• Experience is writing Jenkins pipeline scripts for continuous integration and also for End to End automation for all build and deployments.
• Experienced in version control and source code manage tools GIT Hub, TFS and Dimensions
• Expert in Database Devops and migration of On-premises databases to AWS cloud
• Hands on experience in using XL Deploy and XL Release tools
• Worked on SonarQube and created custom code quality rules using XPATH query for PLSQL scripts
• Used Docket containers for eliminating source friction between development and opertations
• Sound understanding of Agile methodology
• Experience in working with object oriented programming language like groovy, Power Script and Java
• In Depth experience in Oracle/SQL Server: DDL / DML statements, complex SQL queries, Stored Procedures, Functions and Triggers.
• Proficient in using Rally and TFS(Team Foundation Server) for technical stories and defect tracking
• Good knowledge on creating Terraform scripts for AWS cloud infrastructure
• Familiar with UNIX commands, executing shell scripts
• Excellent communication skills, with strong troubleshooting, and problem solving ability
• Expertise in trouble shooting the problems generated while building, deploying and also in production support

TECHNICAL SKILLS:

Database:: Oracle, SQL Server

Operating Systems:: Windows, Linux

Languages:: Groovy,Oracle SQL/PLSQL and Power Builder, Java

Cloud Solution: Amazon Web Services (AWS)

Version Control: Git, TFS, Dimensions

Devops:: Jenkins, GIT, Docker, SonarQube, XL Deploy, XL release, Terraform, Jfrog

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

DevOps Engineer

Responsibilities:

• Created Highly available AWS RDS instances for SQL server and Oracle databases
• Migrated on premises SQL server database to AWS SQL server using DMS
• Used Terraform scripts for creating AWS infrastructure
• Setup High availability AWS environment for database
• Created customer rules using XPATH query for PLSQL scripts in SonarQube
• Developed Jenkins pipelines in Groovy for automation of database deployments
• Enabled splunk logging for Jenkins pipelines
• Implemented rollback functionality in case database deployment failure
• Working on Blue Green deployments for databases
• Used Jfrog as artifactory
• Used XL deploy for deploying SQL scripts on to the target databases

Environment: Git, Jenkins, Jfrog, XL Deploy, SonarQube, AWS,Docker, splunk

Confidential

Developer Lead and Onshore coordinator

Responsibilities:

• Interacting with the client to understand the marketing needs into technical requirements and recommend solutions based on those requirements.
• Explain it to team members and assign the tasks
• Track and delivery of users stories or requirements following Agile model
• Help team members in completing the deliverables on time
• Review the code developed by team members, ensure quality of deliverables and following coding standards
• Coordinates Devops process for successful integration and deployment across multiple environments.
• Continuously work on process improvement and automate the process where ever it is possible.
• Coordinate with QA team and resolve if any conflicts
• Collaborate with other teams and support groups to resolve issues where ever required.
• Track all the defects to closure using RALLY and TFS
• Analyzing PROD issues and bug fixes.
• Carrying out integration testing with other dependent applications.

Environment: TFS, RALLY, PowerBuilder 12.5 and 11.0, SQL server, Windows 7.

Confidential

Developer Lead and Onshore coordinator

Responsibilities:

• Leading Team strength of 17 members (12 offshore and 5 onshore). Scheduling calls, explaining Business requests and assigning tasks and clearing doubts while coding and following up until delivery.
• Coordinating with clients on resource related issues, new intakes and any resource cuts.
• Collecting business process requirements and documentation of requirements
• Consolidating requirements from Business and Analysts and maintaining them in Caliber.
• Preparing the Impact Analysis document and High-level design for the requirements
• Preparing High level and Low Level Design documents using SDP (Software Development Plan)
• Developing code/software as per the approved design documents using Power Builder 11 and Oracle 10g.
• Use Data windows where ever necessary and features such as PFC, Dynamic data windows and User Objects.
• Write Oracle Stored Procedures, functions, Triggers using optimising techniques to reduce load on database.
• Responsible for performance tuning of PL/SQL packages and SQL queries.
• Worked closely with DBA’s if any issues in PRODUCTION.
• Always used explain plan to check the cost and load of the newly introduced queries.
• Extensively used SQL Loader for loading tables.
• Provided numerous adhoc revenue related reports and yearly reports to clients.
• Performing Configuration Management by Checking-in the latest code in source control tool ~ Serena Dimensions.
• Creating Power Builder Builds using PowerGen for migrations and Manual builds for interim builds.
• Generated several reports screens in Power Builder 8.
• Review of code and relevant documentation like HLD, LLD, Test Plan documentations.
• Unit test plan execution.
• Documentation of Test Results.
• Setting up environment for testing by creating batch files to launch application and automatically point them to corresponding test environment.
• Carrying out integrated testing within the application and also in between the applications using Citrix Client Server.
• Carrying out Quality Assurance activities for all deliverables, so that code and test results are delivered without any defect.
• Tracking defects in Quality Center, update defect notes, descriptions, Estimated Fix dates and update it to right status at each level like RFT, Reject etc.
• Work on Production tickets and resolving them.
• Making sure the code backward compatibility so that the changes can be rolled back with ease if needed.
• Perform code walk through to check on the code standards and check for the completeness of the code.

Environment: PowerBuilder 8.0 and 11.0, Oracle 10g, Windows XP, PVCS, TOAD, Caliber and Remedy.

Confidential

Oracle PLSQL and Power Builder Developer

Responsibilities:

• Coordinating with clients on resource related issues, new intakes and any resource cuts.
• Collecting business process requirements and documentation of requirements
• Consolidating requirements from Business and Analysts and maintaining them in Caliber.
• Leading Team strength of 4 members (3 offshore and 1 onshore).
• Preparing High level and Low Level Design documents and maintain them in Qshare.
• Developing code/software as per the approved design documents using PowerBuilder 8 and 11.
• Migrated 8 applications from PowerBuilder 8 to Power Builder 11 and from PowerBuilder 11 to 12.5 with no post production issues.
• Designed Power Builder code dealing/traversing with huge COD based webservice and displayed in Grid.
• Designed Tree structure using Power Builder 8.
• Created Builds for Power Builder 8 and Power Builder 11 and 12.5.
• Generated reports screens in Power Builder 8.
• Developed several standalone tools Proactively in Power Builder to reduce Held Desk tickets.
• Setting up environment for testing using batch jobs.
• Created Shell scripts to generate few reports sent to Directors and Managers.
• Review of code and relevant documentation following Software development plan.
• Unit test plan executions were performed on the entire team’s performance and tasks.
• Documentation of Test Results and uploading it to Qshare.
• Communicating with the client on a day to day basis.
• Performing Configuration Management using PVCS - Serena Dimensions.
• Carrying out Quality Assurance activities for all deliverables, so that code and test results are delivered without any defect/Minimal defects.
• Working on Production tickets and resolving them on time.
• Making sure the code backward compatibility so that the changes can be rolled back with ease if needed using toggles.
• Perform code walk through to check on the code standards and check for the completeness of the code.

Environment: PowerBuilder 8.0 and 11.0, Oracle 10g, Windows XP, PVCS, TOAD, Caliber and Remedy.