EXPERIENCE SUMMARY:

• 9+ years of IT experience as a Devops Engineer, MSBI / MS SQL Developer with increasing responsibilities involving analysis, requirement gathering, database design and development.
• 3+ Years of Experience in Devops tools Chef, Ansible, Docker, Jenkins, vagrant, Nagios and ELK.
• 6+ years of Experience in SSIS Packages implementation and SSRS Reports Development.
• Working on DevOps tools like Chef and Ansible.
• Working on writing Shell scripts.
• Working on Intellij and Sublime.
• Experience in several AWS services EC2, VPC, S3, Cloud Watch, Auto scaling configurations etc..
• Experience with Amazon Web Services, having worked with VPC, EC2, RDS, Cloud Front, Cloud Trail, Cloud Watch, ELB etc
• Administration/Maintenance experience of source control management systems, such as Subversion (SVN), and Git.
• Experience in development of build scripts using Maven, Gradle and SBT.
• Administration/Maintenance experiences of continuous integration build engines, such as Jenkins.
• Deployed Nagios to Monitor syslogs of unix systems.
• Experience on Amazon EC2 cloud deployments using Devops tools Jenkins & chef/Ansible.
• Expertise in build automation tools like Jenkins, Maven, and Nexus for build management.
• Hands on experience with code coverage tools like Sonarqube.
• Extensive experience in Jenkins master - slave for multi machine builds.
• Experience supporting and troubleshooting Linux (Debian, Ubuntu, CentOS, and/or Redhat) and the underlying networking application and stacks.
• Experience with containerization and orchestration technologies (Eg: Docker, Kubernetes etc).
• Good Understanding of Software Development Life Cycle (SDLC).
• Good hands on to support for multiple environments and as well as communicating with different teams.
• Hands on experience in delivering container based deployments using Docker.
• Having knowledge on setting up and managing Docker private repository.
• Having experience in creating custom Docker images using Dockerfile.
• Having knowledge on Docker Networking and Docker clustering using Swarm.
• Hands on experience on Cookbook development for the automation using Chef.
• Hands on experience in creation of Virtual environments using Vagrants.
• Strong in preparing the Release Packages to QA, SIT and UAT Environments.
• Experience on Build and Deployment process for Apache Tomcat Application Server projects.
• Exposure to administration of server such as Tomcat.
• Experience in supporting applications on different platforms Windows and Linux environments.
• Experience in implementing and adapting to Release/Change Management Process.
• Followed best practices, optimize processes, adapt new technologies, quick learner and hardworking individual.
• Possess good interpersonal, documentation and oral communication skills, positive work attitude.
• Deploying WAR,EAR,JAR files in Tomcat application server and WebLogic server on different environments
• Experience in using Bug/Defect tracking tools like JIRA.
• Experience practicing AGILE methodologies.
• ETL packages scheduled in SQL server job Agent on a daily basis.
• Experience in data integration and data analytics from multiple source systems like Oracle, Excel, CSV, SQL Server and files system.
• Used transformations like Derived Column, Conditional Split, Multicast, Union All, Lookup’s, sort and Execute.
• Configuration and Performance improvement of SSIS Packages.
• Involved in migration of DTS packages to SSIS 2008.
• Created SSIS Packages for Incremental Loading and slowly changing dimensions for Cubes.
• Experience in creating the SSRS Reports using Sub reports, Drilldown reports, Drill through reports, parameterized reports and linked reports as per client's requirement
• Having Good knowledge in SSRS Report, server and Report Manager Configurations like deploying, security and scheduling the reports.
• Developed various kinds of Tabular, Matrix, Drill-down, Charts and web receiving reports using SSRS.
• Having good knowledge on Database Migration, Restoration, Backups and Log shipping.
• Having good work experience on Performance Tuning of stored procedures.
• Experienced in SQL Profiler, Database tuning advisor, AdaptSql tools for troubleshooting SQL Server performance problems.

TECHNICAL SKILLS:

Configuration Management Tool: Chef, Ansible

Version Control Systems: Subversion, Git, TFS, VSS

Build Tools / Script Languages.: Maven, Gradle, SBT, Shell scripting and Ruby

CI Server Continuous Integration: Jenkins

Project Management Tool: Jira

Application Servers: Apache, Tomcat, Web Sphere

Databases: Sybase ASE 12.5 and MS SQL Server 2005/2008/2012

Business Intelligence: SSIS, SSRS,SSAS

Operating systems: Redhat, Centos, Ubuntu and Windows

PROFESSIONAL EXPERIENCE:

Confidential, Fort Lauderdale, FL

Responsibilities:

• To automate build process for the native java environment, compiling the project source code and packaging using the build script.
• Integrated ant with Shell scripts created in Bash shell to automate the builds for the Java based applications.
• Managed the deployment activities for multiple server instances by enabling password less Ssh.
• Integrated Git and Maven, SBT with Jenkins to implement the continuous integration process.
• Created UNIX scripts for build activities in QA, UAT, Staging and Production environments.
• Created the branches in Git to implement the parallel development process.
• Involved in Jenkins and SonarQube Administrator.
• Perform base line activities for sonar analysis.
• The build artifacts like wars are deployed into a Tomcat application server by integrating the Shell Scripts
• Maintained UNIX and Linux environments for deployments..
• Used Jira to track the Change requests and Release requests for all the approvals and signoffs and other necessary attributes.
• Maintain release artifacts and ensure rollback to a previous release with minimum downtime.
• Implemented Configuration Management, Change Management policies and Procedures.
•  Involved in development of Test environment on Docker containers and configuring the Docker containers using Kubernetes.
•  Managed AWS EC2 instances utilizing Auto Scaling, Elastic Load Balancing and Glacier for our QA and UAT environments as well as infrastructure servers for GIT and Ansible.
• Used Amazon S3 for multipart upload of data and to host static web content in AWS Cloud. 
• Configured AWS Route53 to route traffic between different regions. 
• Responsible for various repository management activities in Git like branching, tagging, rebasing and merging.
• Experience deploying and maintaining multi-container applications through Docker. 
• Used Ansible to manage Web applications, Environments configuration Files, Users, Mount points and Packages.
• Experience in writing Ansible playbooks.

Environment: LINUX, Shell scripting, SQL, Tomcat, JENKINS, SVN, Sonar, Change Management

Confidential

Responsibilities:

• Managing software source code, change control, configuration management, build and deployment activities, and Setup Build & Release mechanism for new product lines.
• Configure the Continuous integration tool Jenkins.
• Responsible for taking the source code and compiling using maven and package in distributable format, such as a JAR,WAR
• Create new Linux servers using AWS and setup storage, load balancing using EBS, S3 and ELB services.
• Setup the EC2 Instances for Dev, QA, UAT and Production Environments.
• Create AMI’s for the EC2 instances and use them to scale up and scale down multiple servers on a need basis.
• Configure the all the server using Configuration Management tool CHEF and Perform Bootstrap operation.
• Upload the generated jar file into AWS S3 Bucket using Jenkins jobs.
• Configure the Jenkins job using Build tool Maven in Aws instances.
• Perform the static code Analysis using SonarQube and Base line Activates.
• Code deployment on Pre-SIT, QA and UAT environment.
• Build, package and deploy the project deliverables on test environments as distributed updates and promoting to higher environments.
• Monitoring application servers and fixing issues if any. Written the Shell Scripts for Automating Deployment.
• Inform through mail the compilation errors to the responsible team with error logs
• Analyzing application logs in order to determine the possible cause of issues and reporting errors directly to the dev. team,
• Improve transparency in software build, configuration management, release and deployment practices for expertus product and solution provisions
• Maintaining validation documentation after deployment.
• Maintaining the backups of the applications before deployments through automated scripts.
• Assisting developers by taking care of configuration items.

Enivronment: Chef, AWS, Shell scripting, Java, J2EE, Apache, Tomcat, Jenkins, Linux,Maven.

Confidential

Environment: SQL Server 2008, SSRS, SSIS, Adapt Sql, Sql Profiler

Responsibilities:

• Designing and developing SSIS packages for loading insurance patient information Into the DataBase.
• Used control flows like For Each loop container, for loop container, Sequential container, Dataflow tasks etc. used in developing in SSIS Packages.
• Debugging SSIS Packages for various data issues.
• Preparing unit test cases for package development.
• Involved in creation of T-SQL objects like stored procedures, functions Tables.
• Involved in performance tuning of stored procedures and long running queries.
• Designing Adhoc Reports in different types of formats as per client's requirements.
• Created SSIS Packages for Incremental Loading and slowly changing dimensions.
• Created the SSRS Reports using Sub reports, Drilldown reports, Drill through reports, parameterized reports and linked reports as per client's requirement.
• Created subscriptions for SSRS Reports.
• Captured Sql trace files for long running queries, used database tuning advisor to tune the queries.

Confidential

Environment: SQL Server 2008, SSRS, SSIS

Responsibilities:

• Developments of various database objects like procedures, functions, triggers & View etc.
• Responds to service tickets/requests on timely basis.
• Interacting with different upstream and downstream application to smoothly flow of data.
• Preparing user documentation such as RCA, System specification and Test cases.
• Involved in performance tuning of queries and stored procedures.

Confidential, Denver

Responsibilities:

• Analyzing client requirements.
• Understanding complex existing application.
• Preparation of Functional design, Detail design, and test case document.
• Preparation of data mapping.
• Worked in Facets 421, 431, 451, 470 versions.
• Created CBA and HBA XML Wrappers with various steps like ExecSP, Execute Program, File Copy, File Rename, and so on to run from the tidal.
• Created CBA and HBA XML Wrappers to run VBScript functions, stored procedures, Sql queries in a file, and so on.
• Created and modified stored procedures, tables, views, etc in SQL Server 2005/2008 and in Sybase ASE 12.5.
• Writing code to meet the standards of Trizetto.
• Testing on all possible cases of data and Creating packages to import data.
• Fixed all issues that arose during the implementation/testing phase.
• Preparation of A011 document.

Confidential

Tools: T-SQL 2005, SSRS,SSIS.

Responsibilities:

• Writing Stored Procedures, Triggers and User Defined Functions for the benefit of users.
• Creating Indexes whenever it is required by analyzing the queries
• Providing consultation on SQL Server to our development teams.
• Coming up with custom-tailored backup/restore and disaster recovery plans for production servers and Optimization of queries for performance issues.
• Creating users and granting access privileges
• Involved in enhancement, SSIS Package designing and generated SSRS Reports.
• Involved in creating complicated reports.
• Created Store Procedures

Confidential

Tools : T-SQL 2005,SSRS

Responsibilities:

• Writing Stored Procedures, Triggers and User Defined Functions for the benefit of users.
• Creating Indexes whenever it is required by analyzing the queries
• Providing consultation on SQL Server to our development teams.
• Coming up with custom-tailored backup/restore and disaster recovery plans for production servers.
• Performing Export, Import to Reorganize the Database.

Confidential

Tools : T-SQL 2005

Responsibilities:

• Maintaining Backup/Restore operations.
• Implement and maintain database security by creating the Users, Roles and assign privileges required
• Designing the Database and Database objects like Table, Views, Triggers and Procedures.
• Installation of Databases like MS SQL Server.