SUMMARY:

• 12 years of experience in system analysis, design, development, testing, debugging and deployment of Web based applications using Microsoft technologies (ASP.NET with C# & VB programming as front end & SQL Server & Oracle as backend).
• Expertise in Database Designing and back - end programming in the areas of Database Tuning, Query optimization, SQL and PL/SQL including Stored Procedures, Functions, Packages and Triggers in Oracle database.
• Expertise in Automating .Net Build and Deploy applications using PowerShell, Bash Scripting, Ansible Python Modules.
• Strong experience in building DevOps Jenkins CICD Pipeline Jobs using Groovy Script.
• Expertise in Automating Windows & Linux Application Boxes using AWS Cloud formation templates (EC2, EBS, S3, EFS, ELB, ENI, IAM, Security Groups, Lambda, Auto Scaling, KMS Keys) & Ansible playbooks.
• Good Experience in using Siteminder SSO & SSL/TLS 1.2 Certs.
• Good Knowledge on Orchestration Tools like Docker Swarm and Kubernetes.
• Strong experience in Cassandra NoSQL Distributed database setup.
• Good Experience in using Splunk & Datadog for monitoring Application & System logs.
• Good Knowledge on deploying services to Cloud Foundry.
• Strong knowledge in Object Oriented Concepts (OOPs) with best practices like SOLID principles and Design Patterns.
• Good experience in developing Microservices using Spring Tool Suite (STS).
• Good experience in developing RESTFUL services in both Java & .Net using Spring Tool Suite & Windows Communication Foundation.
• Good Experience in Advanced JavaScript frameworks like Angularjs, jQuery, Bootstrap JS (Flexible to quickly learn & work with other frameworks).
• Expertise in Microsoft Technologies such as ASP.Net 4.0, WCF, WPF, ASP.NET MVC4, Web API, ASP.NET Web services, VB.NET, C#.Net, AJAX, ADO.Net, Entity Framework, IIS, SQL Server 2008, SSIS, SSRS.
• Good Knowledge in Data Structures & Algorithms.
• Having Good knowledge in Operating System & Networking Concepts.
• Extensively worked on GIT/Stash/Bitbucket, Confluence, JIRA, and Artifactory.

TECHNICAL SKILLS:

Operating Systems: Windows 2000/XP/2012 R2, Unix ( Red Hat Linux, CentOS, Ubuntu)

Languages: C# .Net, VB .Net, Java Spring Boot, C & Data structures, C++, Python, PL/SQL, HTML, CSS, XML and XSLT.

Scripting Languages: JavaScript, VBScript, jQuery, Windows PowerShell, Groovy Script, Unix Bash Script, Angular JS, Bootstrap JS.

Web Technologies /Middleware: ASP.NET, MVC 4, Web API, WCF, Entity Framework.

Cloud Technologies: Amazon Web Services (IAM, VPC, EC2, EBS, EFS, ENI, S3, Subnets, Security Groups, ELB, ALB, KMS Keys, RDS Oracle), Cloud Foundry.

CICD: Jenkins

Configuration Management Tools: Ansible, Chef, Puppet

RDBMS: Oracle 12c, 11g/10g/9i/8i, SQL Server 2000/2005/2008, MS-Access 2000.

NoSQL DB: Cassandra & Mongodb

In Memory Cache: Oracle Coherence, Mongodb

Web Servers: IIS 6.0/7.0/8.0, Apache Tomcat.

Version controls: Stash/Git/Bitbucket, VSTS, Subversion, SVN, TFS

Methodologies: Dojo, Agile, Waterfall Model

Other Tools: Visual Studio. NET 2010/2012, Visual Studio Code, Eclipse, Spring Tool Suite (STS), Toad for Oracle & SQL Developer, SQL Server Management Studio, Erwin Data modeling, JFrog Artifactory, JIRA, Confluence, Super Putty, Oracle Data Integrator (ODI), Splunk, Datadog, Wily, Tableau, Sonarqube, Fortify Scan.

PROFESSIONAL EXPERIENCE:

AWS DevOps Engineer

Confidential

Responsibilities:

• Automating AWS Infrastructure setup for VEPS Application.
• Created Cloud Formation Templates for the below AWS Resources. (Security Groups, EC2, EBS Volumes, Application Load Balancer, Lambda, Auto Scaling, S3, EFS, RDS-Oracle, Aurora PostgreSQL ...Etc.)
• Perform AWS Re-hydration process for every new Verizon AMI release.
• Perform CFN-NAG check through Infrastructure Certification process (ICP).
• AWS Security Groups Clearance from Security Team.
• Software Provisioning Using Ansible.
• Created Ansible playbooks using Ansible modules / PowerShell / Bash Script / python / Jinja2 Templates for the below ones.
• Structured the code using Ansible Roles like DEV / SIT / STG / PROD.
• Created Custom AMI’s for the below applications
• .Net Application Servers - Windows
• Java Application Servers - Linux
• Jenkins Slave Node - Windows
• Cassandra Cluster ( Multi-Region) - Linux
• Linux ODI Batch Server
• Developed below Jenkins Job's for Continuous Integration & Continuous Deployment (CICD).
• Dot Net Build & Deploy Jenkins Pipeline Jobs: Automated Windows .Net Applications Build process using PowerShell & Groovy script.
• Cloud Foundry Deploy Pipeline Jobs: Automated Java Cloud Foundry Deploy Process using Bash Scripting.
• Setup CICD Pipeline Jobs for Disaster Recovery Setup (DR).
• Installed Splunk & Wily agents in all VEPS production application boxes.
• Support Splunk Infrastructure setup for VEPS application (Setup Local SPLUNK Indexer & pushed Application/System/IIS Logs).

AWS DevOps Engineer

Confidential

Responsibilities:

• Created 12 Node cluster across the AWS region and in different Availability zone with Replication factor 3.
• Automate the cluster creation using Ansible & Jenkins Pipeline Jobs.
• Cassandra Data Model for Verizon Gift Card Module.
• Scripts for Cassandra One time data load.
• Create Schema, Roles, Tables, Grant Scripts, and Materialized Views.
• Develop Java RESTFUL Microservices to asynchronously push data to both Oracle & Cassandra DB using Spring Boot Application.
• Create corresponding AWS Cloud Formation templates & Ansible Playbooks for Infrastructure Automation.
• Test High Availability and Network failure scenarios.
• High level documentation on confluence.

AWS DevOps Engineer

Confidential

Responsibilities:

• Develop a single page front end application - SPA for Verizon Internal Business Reports using Angularjs.
• Build & Deploy the application in Linux using pm2 start.
• Release Manager to maintain code in Git/Stash with new TAGS per release & execute Jenkins Build & Deploy jobs.

AWS DevOps Engineer

Confidential

Responsibilities:

• Developed new modules for Auto pay enrollment & de-enrollments.
• Angular Modules - Entire application structured with in modules & sub-modules.
• Angular Controllers - Developed using Angular best practices.
• Angular Views - Developed responsive web pages as per the requirement using VZ Bootstrap.
• Developed custom Directives and Services in AngularJS.
• Used Angular UI Routing mechanism for client side navigation.
• Develop RESTFUL services using Windows Communication Foundation - WCF.
• Coordinate & deploy the daily Database scripts using Liquibase jobs.
• Analyze and fine tune long running DB PL/SQL queries.

AWS DevOps Engineer

Confidential

Responsibilities:

• Understand the existing Build & Deploy manual process for all above applications.
• Create PowerShell script for both build (MS Build) & Deploy .Net Applications.
• Create Linux Bash script for both build (Maven) & deploy Java Applications.
• Create Linux Bash script for deploying Oracle DB Objects using Liquibase.
• Create parameter driven Jenkins Build and Deploy jobs using PowerShell & Shell script plugin.
• Used Extended Choice Parameter, Active Choices Reactive Parameter, String Boolean, Label, and Node Parameters for the Jenkins UI design.
• Parameter Driven Build Script with placeholder’s.
• Parameter Driven Deploy Script with placeholder’s.
• Encrypt/Encrypt Script for DB Connection String & Answer sets.
• Create Jenkins Validation Jobs for
• Stash/Git Connectivity.
• JFrog Artifactory Connectivity.
• WinRM Connectivity.

Sr. .Net Developer (Pfizer)

Confidential

Responsibilities:

• Created RESTFUL services using ASP.NET Web API for exposing to external applications.( supports JSON & XML format)
• Created ASP.NET MVC4 pages based on the change requests.
• Razor Views
• Models
• Controllers
• Involved in production code fixes.
• Prepared database coding standards template and the shared across the team to follow.
• Created a lot of new procedures/functions/synonyms & packages as part of new enhancements (Change Requests).
• Implemented Exception Handling and database Transaction management (COMMIT & ROLLBACK) in oracle procedures.
• Reviewed and provided the comments to the scripts developed by the team.
• Created a log/Audit table in Oracle to mark the success/ failure of the jobs.
• Automated daily monitoring of Materialized Views refresh through Email Notifications by creating a notification procedure triggered by an oracle job.
• Involved in architectural discussions with business team.
• Troubleshoot lot of the Complex SQL queries by Analyzing query execution plan, applying the required indexes, partitioning the huge tables with Local indexes to improve the query performance.
• Prepared Database deployment installation instructions document.
• Created DB links in Oracle to pull data from external database sources like SQL server/ Informatica Data Services (IDS).
• Written complex SQL queries that has XML data column in Sql server.
• Release and change management of Production deployment.
• Updated the Design & Requirement Specification document with the latest client requirement changes.
• Performed unit testing, debugging and fixed the production issues.

AWS DevOps Engineer

Confidential

Responsibilities:

• Redesigned entire application using MVC architecture and created high level & detail design document.
• Created UI Screens using Razor views.
• Created Controller classes to handle & execute application and data logic.
• Created Model Objects using Entity Framework for data retrieval & modification using Context Object.
• Developed new WCF Services (XML over HTTP) to achieve Service Oriented Architecture (SOA) and communication between heterogeneous applications.
• Developed Service, Operational & Data Contract classes as per the design.
• Used Factory and Singleton design patterns.
• Created few new PL/SQL Stored Procedures as per business requirements.
• Analyze, redesign and fine tune long running PL/SQL complex queries by applying table partitioning with local indexes to improve query performance.
• Created Test Driven Application with valid test cases using Assert Statements.
• Created Master Pages to maintain consistent layout across the pages for the mobile application.
• Created custom user controls to provide reusability & rich user interface.
• Coordinate with QA Team to troubleshoot, debug and fix the production issues.
• Used Visual Source Safe as version control.

AWS DevOps Engineer

Confidential

Responsibilities:

• Lead the team size of 4 people.
• Designed Entity Diagrams using Erwin Data Modeling tools.
• Used SQL Developer for Oracle tool for migrating the Microsoft SQL Server 2000 objects (procedures/ functions/ triggers etc. ) to corresponding objects in Oracle
• Prepared database coding standards template and the shared across the team to follow.
• Identified frequently occurred migration issues.
• Analyzed migration issues and documented the resolution steps and the same is shared across the team to follow.
• Created a structure by creating packages & procedures with in it.
• Created a log/Audit table in Oracle to mark the success/ failure of the migrated objects.
• Manually converted few complex Microsoft SQL Server 2000 queries to Oracle by identifying and using oracle compatible datatypes & predefined/inbuilt functions.
• Listed down all the SQL Identity columns in SQL server 2000 and created sequences in oracle to implement the auto increment functionality for those columns in oracle.
• Troubleshoot lot of the Complex SQL queries by Analyzing query execution plan, applying the required indexes, partitioning the huge tables with Local indexes to improve the query performance.
• Implemented Exception Handling for all PL/SQL procedures.
• Code review the scripts developed by the team.
• Prepared Database deployment installation instructions document.
• Created CRON Jobs for auto scheduled in oracle.
• Export the SQL Server table data in to CSV files.
• Created SQL Loaded script files to load data from CSV files to corresponding Oracle target tables.
• Created migration scripts for the one time data load in oracle
• Prepared High level & detailed design document.
• Performed unit/smoke testing, debugging and fixed the errors before QA testing.

Software Developer

Confidential

Responsibilities:

• Involved in Production Support & Maintenance.
• Identified the list of CSV and Fixed Length files shared by SAP team in shared location.
• Created the required Temporary tables in Oracle to push data from SAP files to these TEMP tables
• Used SSIS tool to dump data from flat files to target oracle temporary tables.
• Created Stage and final tables for the corresponding TEMP tables
• Written scripts by applying Transformation rules on TEMP tables and load data in to corresponding Stage tables
• Written scripts to filter unwanted data and load it to final master tables.
• Created a structure by creating packages & procedures with in it.
• Reviewed and provided the comments to the scripts developed by the team.
• Created a log/Audit table in Oracle to mark the success/ failure of the onetime data load process for individual flat file.
• Troubleshoot lot of the Complex SQL queries by Analyzing query execution plan, applying the required indexes, using bulk inserts & updates to improve the query performance.
• Created and auto scheduled the jobs in oracle.
• Created migration scripts for the one time data load in oracle
• Updated the Requirement Specification document with the latest requirement changes.
• Updated the Design Specification document with the latest client requirement changes.
• Performed unit testing, Debugged and fixed the errors before submitting modules to QA.

AWS DevOps Engineer

Confidential

Responsibilities:

• Involved in Production Support & Maintenance.
• Analyzed all the client requirements and prepared high level architectural diagram for the application
• Created High-level & detail design specification documents.
• Developed few of the ASP.NET web pages using C#
• Written few business functionalities in Data Access Layer (DAL).
• Performed code reviews and provided review comments accordingly with some best practices.
• Created procedures/functions/triggers using T-SQL and applied exceptional handling.
• Reviewed and provided the comments to the scripts developed by the team.
• Performed smoke level testing for the newly developed pages and also integration testing.
• Performed unit testing, Debugged and fixed the errors before submitting modules to QA.

Jr. Software Developer

Confidential

Responsibilities:

• I have involved in end-to-end delivery of this application and participated in requirement and analysis phase.
• Analyzed all the client requirements and prepared high level design specification document.
• Complete ownership of development and unit testing of above mentioned modules.
• Created UI web pages using ASP.Net with C# programming.
• Created Ajax method calls through Javascript using XMLHTTP objects.
• Configured LIMS-LINK ( Instrument Connectivity ) to our Application and tested the Animal weighing functionality
• Implemented business functionalities logic in Data Access Layer (DAL).
• Created Virtual directories and hosted the application in IIS 5.0.
• Developed several shared Assemblies ( GAC - Global Assembly Cache ) & are reused in other projects with in the same application
• Written Code to deallocate unused memory objects for unmanaged code.
• Created stored procedures/functions/triggers using TSQL.
• Performed smoke level testing for the newly developed pages and also integration testing.

AWS DevOps Engineer

Confidential

Responsibilities:

• Prepare design specification document with latest UI Screen layouts.
• Re-create UI screens and integrate to underlying Middle & Data Access Layers.
• Re-write data reader’s logic with data sets & pagination in various modules that will improve Connection handling with database and fix the outstanding bugs of 3.1 versions.
• Perform thorough end-end application testing.

AWS DevOps Engineer

Confidential

Responsibilities:

• Involved in end-to-end delivery of this application and participated in requirement and analysis phase.
• Implemented the 3-Tier Architecture in developing the .NET applications.
• Developed business components that help in automating the background checking process.
• Documented the functional design and technical design aspects of 3-tier applications.
• Used C#.Net, ADO.NET, XML, XSLT and user defined class libraries in developing the business components and entities as a part of Application Layer
• Used ASP.NET and JavaScript in developing the presentation layer
• Build user controls using .Net, ASP.NET.
• Developed Business and Data tier using .Net, COM+, ADO.Net.
• Developed code behind classes and reusable components in VB.Net.
• Implemented Forms-based Authentication to authenticate the users.
• Developed Interfaces for data exchange using Oracle, ASP.Net, XML XSL and XSLT.
• Developed several .ASMX pages (Web Services) & the same services are utilized in other heterogeneous applications using WSDL Url ( Web Service Description Language)
• Developed Stored Procedures and User Defined Functions in SQL Server 2000, Oracle, PL/SQL for the business components as a part of data access layer
• Involved in designing and documentation of flows and functional diagrams using Visio.
• Deployment of Application on Test and Server and testing of application.
• Done integration testing and functional testing.