SUMMARY

• 7+ years of experience in software designing, developing and debugging of multi - tier applications, providing modular solutions based on object-oriented principles.
• Experience in developing client-server technologies using Java, J2EE, JDBC, JSP, Servlets, Springs Core, Spring MVC, Spring Boot, Hibernate, and Web Services (REST API).
• Experience in web development using HTML5, CSS3 (SAAS, LESS), JavaScript with ES6, jQuery, Bootstrap,Typescriptand AJAX technologies.
• Experienced in CoreJavaconcepts involving Collections, Multithreading, Exception Handling, Data structures and OOPS concepts like Polymorphism, Inheritance, Abstract Classes.
• Experienced in working with Spring Framework and spring modules like Spring MVC, Spring AOP, Spring Boot, Spring JDBC, Spring Data, Spring Security and Spring Core.
• Hands-on experience on working with AmazonWeb Services like EC2,S3, Amazon SimpleDB, AmazonRDS, Amazon Application Load Balancing, AmazonSQS, AWS Identity and access management, AWS Cloud Watch, Amazon EBS and Amazon Cloud Front.
• Expertise in Analysis, Design, Coding, Development, Implementation, and performance tuning in PL/SQL, as part of various Data Warehouse Development and Data Migration projects executed for major clients across globe under Agile, Waterfall, Scrum environments
• Hands-on experience in relational databases like Oracle10g/11g, DB2, MySQL, MS SQL Server, using SQL and PL/SQL
• Experience in handling messaging services usingApache Kafka.
• Expert in setting up the logging framework using SPLUNK.
• Strong skills in Oracle server-side programming which includes writing simple and complex SQLs, PL/SQL, Functions, Procedures, Packages, creation of Oracle Objects - Tables, Views, Materialized views, Triggers, Partition tables, Indexes, Synonyms, User Defined Data Types, Pipelined functions, XML DB functions, and advanced PL/SQL concepts
• Proficient in programming by using the IDE tools like Net Beans, Eclipse, IntelliJ, Rational Application Developer (RAD) and JDeveloper for application development.
• Experience in designed fully distributed system with the use of Restful API and Microservices.
• Hands on experience in tuning SQL queries for enhancing the database performance.
• Experience in Understanding complex performance issues and worked with DBAs to suggest valuable ways to fix the problem.
• Experienced in writing UNIX shell scripts, manipulating files, transferring files using different UNIX commands and Scheduling jobs using Crontab.
• Hands-on experience withTableauwith implementation of innovative ideas implemented as dashboards. Collaboration with various departments forTableaudevelopment. Used analytical skills to deliver insightful dashboards.
• Experience in Continuous Integration (CI) and Continuous Deployment (CD) using Jenkins.
• Hands on experience using version control tools like GIT and SVN.
• Experience working with Agile Methodology Environments which includes Scrum and JIRA for issue tracking.
• Experience in Unit Testing the applications using Junit, Selenium, TestNG, Mockito, Cucumber,and Power mock Framework and developed logging and standard mechanism based on Log4J.
• Ability to learn and adapt quickly to the emerging technologies and to work in fast paced deadline-driven circumstances without compromising the quality.
• Extensive experience interacting with cross-functional, global teams and communicating project information to multiple levels in an organization.
• Able to work with little or no supervision. Good communication and time management skills.

TECHNICAL SKILLS

Languages: Java/J2EE, JDBC, SQL, PL/SQL, T-SQL, HTML

Database: Oracle9i, Oracle10g/11g, SQL Server, MySQL, Elastic Search

Framework: Spring 3.0/2.0, Spring Boot, Spring Data

Cloud Technologies: AWS

IDEs/Utilities: STS, Eclipse, IntelliJ

Webservices: SOAP, REST

Web Technologies: HTML, Java Script, JQuery

Build Tools: Maven, Gradle.

Database Tools: SQL Developer, TOAD, SSMS

Operating Systems: UNIX, Windows XP/VISTA/7

Other Tools: Github, Gitlab, Maven, JIRA, Jenkins, APIGEE, IntelliJ

PROFESSIONAL EXPERIENCE

Application Developer

Confidential - Virginia

Responsibilities:

• Responsible for Developing new enhancements for Confidential On Time (VZOT) application and programs based on the technical design specifications using PLSQL.
• Responsible for designing and Developing spring boot microservices to migrate the legacy application to Java using spring boot and spring cloud, also registered those services in discovery using netflix eureka
• Developed few standalone micro-services to handle day to day install and repair clocks based on customer needs.
• Used Spring boot, Spring data, Spring MVC for REST API’s and for developing the application and logstash, Splunk for logging the application logs.
• Worked to modify the logs into Json format and push them to Kafka topic to display them in Splunk using logstash.
• Implemented Spring Security oAuth authentication at API Level and also basic authentication to increase the security in the cloud environment.
• Used MAVEN as build tool to build the micro services and deployed the micro services to the AWS cloud in multiple regions using Jenks CI/CD Pipeline.
• Deployed the front end and backend Micro services into AWS cloud using Jenkins and automated the process for spinning up multiple instances or enabling autoscaling and update the Memory allocation for the microservices.
• Participated in migrating the application into cloud environment using AWS and also worked with multiple systems that contact VZOT for the smooth migration.
• Worked closely with Apigee team to expose the services via proxy using APIGEE.
• Closely worked with Kafka Admin team to set up Kafka cluster setup on the QA and Production environments to replace IBM MQ process.
• Developed Spring Kafka API calls to process the messages smoothly on Kafka Cluster setup.
• Have knowledge on partition of Kafka messages and setting up the replication factors in Kafka Clusters.
• Responsible for Managing and Supporting day to day activities for Confidential On Time (VZOT) application that handles Due date management which gives due date to customer as per tech capacity.
• Developed Oracle PL/SQL Packages/Procedures/Functions that include collections, ref-cursors to pass the data between Java applications/Reports and the database.
• Perform source data analysis and profiling to identify the source systems for the Data Warehouse and perform distribution analysis for the data on various systems to resolve conflicting scenarios.
• Create indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Implement oracle scheduler jobs that schedules scripts which run on equal time intervals. This migrates data from transactional databases to reporting databases.
• Create visual dashboards in line with the analytical uniformity using the Advanced Analysis of Tableau Desktop, and organizing Dashboard views and objects.
• Responsible to deploy Microservices in UAT and Production cloud environments using Jenkins.
• Worked as Onshore lead to gather business requirements and guided the offshore team on timely fashion.
• Collaborate with business and development representatives to identify key features, develop functionality, set up implementation strategy, identify design flaws, create and implement tests to validate that intended software features and enhancements are functioning properly.
• Troubleshoot and resolve database or related technical issues as they arise, demonstrating agility in day-to-day support of multiple projects and critical processes, including 24 x 7 operations.
• Agile is followed in a 2-week sprint model which includes daily scrum calls, sprint planning, reviewing sprint backlog, mid sprint review, sprint release, followed by sprint retro meets.
• Following Iterative/Agile process for the sprint-based product delivery. Involved in Sprint planning, daily stand ups, Grooming session, and Sprint retrospective.

Software Developer

Confidential - Charlotte, NC

Responsibilities:

• Developed and enhanced application usingjavacore andjavaEE, Web services (Spring BOOT), HTML 5, CSS, Angular Js, JavaScript, AJAX, JSON, Spring framework (MVC, IOC, AOP).
• Involved in the analysis, design, development, deployment and testing phases of Software Development Life Cycle (SDLC).
• Used Java Micro service architecture using Spring Boot for rapid development and modular deployment of functionalities in a highly scalable, highly available and fault tolerant systems in Cloud environment.
• Defined the testing strategy and prepared test cases and scripts for various phases of Unit and System Testing.
• UsedREST ClientandPOSTMANto test the rest based services and usedJunitandMockitoto test the middleware services.
• Developed java controller classes for implementing different actions like retrieving list of investors, querying investor profile information.
• Setup and maven build configurations for the newly createdmicroservices using Spring Boot.
• Used Log4j libraries for logging and managing code base. created complex stored procedures, functions, triggers to generate reports that delivers on monthly or weekly basis based on the client requirement.
• Created PL/SQLstored procedures, functions and packagesfor moving the data from staging area to data mart.
• Identification of dataflow/workflow issues, as well as finding the source of the issues and resolving them.
• PerformedSQL and PL/SQL tuningand Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Extensively involved in usinghints to direct the optimizerto choose an optimumquery execution plan.
• Implement advanced PL/SQL constructs like Oracle-supplied packages, Nested tables, Varrays, Records, REF Cursors and Dynamic SQL to connect and communicate databases with front end systems.
• Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Used Bulk Collections, Indexes, and Materialized Views to improve the query executions.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables in PL/SQLblocks and even have experience with exception handling.
• Experienced in Extracting, analyzingdataand presentingdatain graphical format that helped managers to make business decisions.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
• Create UNIX shell Scripts to embed Oracle packages and Stored procedure to schedule batch jobs.
• Performed code fixes to fix the damaged production data in the data warehouse.
• Ensured 24x7 database availability, reliability and security while in a production environment.

Environment: Java, Spring boot, Spring, Oracle10g/11g, SQL, PLSQL, Toad, SQL Developer, Korn Shell Scripting, SVN, Tableau 9, AQT, JIRA, AUTOSYS, Golden Gate, WinSCP UNIX, Hadoop, hive.

PLSQL/ETL developer

Confidential

Responsibilities:

• Involved in different phases of SDLC for all the new modules including Physical and Logical Design, Code Development, Testing, Implementing and Maintenance.
• Involved in Data loading from other databases and text files into Oracle database using Informatica.
• Worked on InformaticaPower Center 9.6.1 - Used Source Analyzer and Target designer to import the source and target database schemas and the Mapping Designer to map the sources to the target, Mapplets and Transformation Developer.
• Involved in creation and usage of stored procedures and loading of data into data marts using Informaticapower center on Daily basis.
• Involved in the process of data fixes for sales reports and finance reports.
• Worked on database interaction layer for insertions, updating and retrieval operations of data from ORACLE database by writing stored procedure.
• Optimized/Tuned mappings for better performance and efficiency. Performance tuning of SQL Queries, Sources, Targets and sessions.
• Maintain Development, Test and Production mapping migration Using Repository Manager. Also, used Repository Manager to maintain the metadata, Security and Reporting. Modeling and populating the business rules using mappings into the Repository for Meta Data management.
• WroteSQLqueries using Joins, sub queries and inline views to retrieve data from the database.
• Created Cursors, Collections and database triggers for maintaining integrity constraints and implementing the business rules.
• Created Pl/SQL functions, procedures, packages, triggers according to the business requirements.
• Coordinated with front end design team to provide them with the necessary stored procedures and packages and necessary insights to the data.
• Defined indexes on various tables to improve the performance of the queries for reporting purpose
• Proactively tunedSQLqueries and performed refinement of the database design leading to significant improvement of system response time and efficiency.
• Developed SQL loader scripts to load data from various forms like flat files, csv’s etc into staging tables.
• Participated in moving data from production environment to testing and development environments to test the performance of application.
• Involved in bug fixing and production support after the application moved to production.

Environment: Oracle9i, SQL developer, Informatica Power Centre9.6.1, putty, TOAD, Winscp. Unix, JIRA, UNIX.