Sql Server Software Development

Davana

Email: **********@*****.***

Contact: 703-***-****

PROFESSIONAL SUMMARY:

Around 8 years of experience in Java/J2EE, Software Development Life Cycle, Object Oriented programming, developing and testing of Client/Server, Enterprise and Web Applications.

Experience in Web based application development using Java/J2EE, JSP, Servlets, JDBC, Struts, Hibernate, Spring, Web Services and XML Technologies.

Experience working on Web technologies: HTML5, CSS, Bootstrap, JavaScript ES5, Typescript, JavaScript ES6, AJAX, JSON, JQuery, AngularJS, Sencha EXT-JS and Angular 4/6/8.

SSSviews, indexes, sequences, stored procedures, functions, triggers and packages.

Experience in working with various J2EE Application Servers such as Apache Tomcat, JBOSS and IBM’s WebSphere.

Experience with NoSQL databases like MongoDB and Cassandra.

Experienced in building complex Single page applications with Vue Js components with Backbone Marionette wrappers for Routing.

Experienced in working with NodeJS andNPM modules like http, path, mongoDB and templating engines.

Having Good knowledge in developing Cubes and Dimensions using SQL server Analysis services SSAS .

Expert in performing T-SQL DDL/DML/DCL commands using SQL Server Management Studio SSMS.

Expert in designing enterprise reports using SQL Server Reporting Services SSRS 2005/2008 to generate drill down reports, drill through reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts.

Configured Kafka to read and write messages from external programs.

Developed end to end data processing pipelines that begin with receiving data using distributed messaging systems Kafka through persistence of data into HBase.

Cofigured Spark streaming to receive real time data from the Kafka and store the stream data to HDFS using Scala.

Experience in developing application in Single Page (SPA’s) using various JavaScript frameworks such as Angular 4/6/8, Angular JS and React JS.

Familiar with creating Custom Reusable React Components Library.

Extensive experience in developing applications Single Page (SPAs) using various JavaScript frameworks like Angular 2.0, React.JS and Back-end(Server) like Node.js, Express.

Experience working with Node.js to setup Web API’s using Javascript.

Creating custom, general use modules and components which extend the elements and modules of core Node.JS.

Experience in implementing usage of Node.js and NPM, especially for Node build processes like GULP.

Implement modules into Node JS to integrate with designs and requirements.

Extensive experience in design and implementation of Dependency Injection, Spring MVC architecture, Aspect Oriented Programming (AOP) and Auto wiring concepts in Spring Frameworks.

Experienced in developing and consuming SOAP and REST services using Spring framework.

Good understanding in Microservices architecture, Containers with Spring Boot based services in combination with RESTful web services.

Experience in AWS Solutions using EC2, S3, Elastic Load Balancer and Auto Scaling Groups.

Experienced in Docker to deploy Micro-services in modern containers to increase Isolation.

Experience in developing applications using Core java concepts like OOPs, Multithreading, Interface, Abstract class, collections framework etc.,

Experience in using IDE’s such as Eclipse, MyEclipse, IntelliJ and Visual Studio Code.

TECHNICAL SKILLS

Languages

C, C++, Java (J2SE 1.8/1.7/1.6/1.5, JEE 6 / 5), SQL, PL/SQL, Python, R, XQuery, UML2.0

Technologies

JSP2.1/2.0/1.2, Servlets2.x/3.x, JavaBeans, JDBC, RMI, EJB3.0/2.1, Hibernate4.x/3.x, Spring4.0/3.0, Web Services (SOAP, REST), SOA, JMS1.1, DOM Parsers, AJAX, JAXB2.1/2.0, JAXP1.x

Web Technologies

HTML 5/DHTML, XHTML1.1, JavaScript, jQuery, Angular-JS 1.5, Angular 2, React JS, Node JS, ExpressJS, Grunt, Gulp Typescript, CSS3, XML1.0, XSL, XSLT, Bootstrap

Development Tools (IDEs)

Eclipse 3.2/3.0/2.1.1, MyEclipse6.0/5.1.1, NetBeans3.3, MS Visual Studio 2015

Web/Application Servers

Tomcat 7.x/6.x, Web Logic 10.3/9.2/8.1/7.0, IBM WebSphere6.x/5.x/4.x, JBoss 7.0

Design Patterns

MVC, Front Controller, Session Façade, Singleton, Business Delegate and DAO patterns

Databases

Oracle 12c/11g/10g/9i/8i, MS SQL Server 2008/2005/2000, MySQL5.1/4.1, DB2 9.1/8.1/7.2

NoSQL Database

MongoDB (3.X), Cassandra

Platforms

Windows, UNIX, LINUX

Testing Tools

JUnit 4.x, Jasmine 2.3/2.4, Karma, Protractor 2.5/3.0, Selenium 3.0.1

Version Control

CVS, SVN, VSS, GIT.

Methodologies

Agile Methodology, Waterfall Methodology

Devops Tools

Ant 1.7, Maven 3.x, Gradle3.x, Jenkins (CI), Rational Rose, Log4J, Docker

Cloud

AWS (EC2, S3, CLI, Cloudwatch, Console,Lambda),Azure

PROFESSIONAL EXPERIENCE

Client: Sony Pictures, TX Oct 2023 – Nov present

Role: Full Stack Java Developer

Roles & Responsibilities:

Performed application development following Agile Scrum methodology by taking part in analysis, design, coding, unit, and integration testing of business applications.

Agile Sprint backlog grooming, sprint planning and Sprint review in Sprint Retrospective

Assist with communication, improving transparency, and radiating QA information

Used JIRA as the Scrum Tool for Scrum Task board and work on user stories

Designed, implemented and tested the Spring Domain Model for the services using Core Java.

Designed and developed a Restful APIs for different modules in the project as per the requirement.

Used a light front-end framework against the JSON API for their service requests.

Developed web pages using HTML5, CSS3, Angular 8, JavaScript.

Creating JavaScript reusable components and services to consume REST API's using Component based

architecture provided by Angular 8 and 10 and Used Webpack to build JavaScript modules.

Used spring framework for integrating the MVC components with business services.

Experienced in developing front-end systems with JavaScript, Bootstrap, HTML5, MVC frameworks

such as Angular JS.

Performed Web services testing between and third-party applications performance

functional testing of REST APIs using JMeter.

Developed test cases and performed unit test using JUnit Framework.

Involved in JUnit Testing, debugging, and bug fixing.

Used Gradle scripts for building and deploying the application in web/App servers

Experienced in generating logging by Log4j to identify the errors in production test environment and experienced in Gradle tools.

Database design and development including Tables, Primary and Foreign Keys, Indexes and Stored

Procedures.

Generated SQL and PL/SQL scripts to install create and drop database objects, including tables, views,

primary keys, indexes, constraints, packages, sequences, grants and synonyms.

Created automation scripts using Fitnesse tool for Appian in order to

regression test the application thoroughly.

Integrated Automation scripts (Fitnesse)

Developed user friendly suites for testing different types of queries: generic, custom, model, etc.

Maintained and supported four existing microservices of the application.

Client: Equifax, Atlanta,GA Aug 2021 – Oct 2023

Role: Full Stack Java Developer

Roles & Responsibilities:

Performed application development following Agile Scrum methodology by taking part in analysis, design, coding, unit, and integration testing of business applications.

Created and consumed SOAP and REST APIs using Apache CXF and Spring framework.

Resources were exchanged using RESTful web services with the data passed around in JSON format.

Developed backend REST API’s using Node and Express-JS and took part in setting up schema objects in mongoose for data retrievals.

Designed and developed Microservices business components using Spring Boot.

Implemented spring applications with Spring Boot and DAO design pattern for maximum abstraction of the application and code reusability.

Performed database design and implementation using SQL Server and data modeling tools.

Developed backup restore scripts for SQL Server as needed.

Rich development experience in creating tables, views, triggers, stored procedures, user defined functions and other T- SQL statements.

Developed OLAP cubes by using SQL Server Analysis Services SSAS, worked on performance tuning of SSAS cubes.

Developed user interface by using the React JS, Flux for SPA development.

Implementing and maintaining the reusable components in the Vue.JS.

Developed and Deployed the Application on IDE’s VS Code and WebStrom

Involved with bug fixing on functionality, performance and designing issues with Vue JSPlugin and Chrome Developer tools .

Development of Client Side validation techniques using JQuery and Vue JS directives.

Implemented react JS code to handle cross browser compatibility issues in Mozella, IE 7, 8, 9, Safari and FF.

Worked in using React JS components, Forms, Events, Keys, Router, Animations and Flux concept.

Worked on responsive design and developed a single ISOMORPHIC responsive website that could be served to desktop, Tablets and mobile users using React.js.

Worked on React JS Virtual Dom and React views, rendering using components which contains additional components called custom HTML tags.

Implemented various screens for the front end using React.js and used various predefined components from NPM and redux library.

Worked in using React JS components, Forms, Events, Keys, Router, Animations, and Flux concept.

Maintained states in the stores and dispatched the actions using redux.

Worked on creating dynamic web pagessql using HTML5, JavaScript, jQuery and AngularJS.

Experience in benchmarking Cassandra Cluster using Cassandra stress tool .

Managed Amazon Web Services (AWS) infrastructure with automation and configuration.

Converted existing JavaScript code into MVC pattern using AngularJS framework.

Created responsive web pages for the system using HTML5 and Bootstrap.

Implemented Kafka producer and consumer applications on Kafka cluster setup with help of Zookeeper.

Used Spring Kafka API calls to process the messages smoothly on Kafka Cluster setup

Supported and enhanced existing applications developed using Java, spring, Hibernate, JMS and REST web services.

Developed batch jobs using Spring batch and Spring scheduling to process XML files received from other systems.

Enhanced existing REST API’s by adding new operations using Spring, Jersey and created documentation for web services using Swagger.

Used Node.JS to structure JavaScript code to build Restful webservices.

Implemented generating the verification hash code using crypto package on Node.JS.

Used Nodejs to structure JavaScript code to build endpoints.

Extensively used Node.js tools like Gulp, Grunt, Web pack; Developed internal CLI applications using Commander Module for application build.

Used date-format and moment packages in Node.JS to save the timestamp in database converting into GMT. Involved in Test Driven Development by writing unit test cases.

Involved in writing Java API for Amazon Lambda to manage some of the AWSservices.

Responsible for using AWS Console and CLI for deploying and operating AWS services.

Initiating alarms in CloudWatch service for monitoring the server’s performance, CPU utilization, disk usage etc. to take recommended actions for better performance.

Installed application on AWS EC2 instances and also configured the storage on S3 buckets.

Used Ajax calls to make requests to external RESTful Web Services and injected the service into the controllers.

Implemented the design using SpringMVC, making use of concepts such as Dependency Injection and Annotation based transactions.

Used Spring MVC for the controllers used Spring Security for securing the web tier Access

Used Jenkins for continuous integration in which all development work is integrated and involved in deploying the application using Docker to AWS environment.

Worked on performance testing by creating a. jmx file for API as well as UI and tested in both the environment Dev/QA both by using a tool JMeter and load the test results.

Works with Data Integration developers to develop Data Integration Workflows and load processes

Supports the development and design of the internal data integration framework

Responsible for writing ATTD scripts with Cucumber, testing manually as well as automated.

Developed Kafka message listeners to consume messages from topics using Spring Kafka.

Had knowledge on Kibana and Elastic search to identify the Kafka message failure scenarios.

Implemented to reprocess the failure messages in Kafka using offset id.

Automate build process through Maven build framework

Used JIRA to assign, track, report and audit the issues in the application.

Environment: Agile Methodology, GIT, JSON, Maven, Node-JS, NPM, Jenkins, Version 1, Angular 2/4, Angular CLI, Type Script, HTML/HTML5, CSS3, SAAS, Spring Boot, Visual Studio Code, JMeter, Jasmine, Cucumber, Web pack, Karma, AWS, Docker, Bootstrap,Java 1.8,Java 11,Spring, Hibernate, REST, SOAP, Spring Batch, JMS, Junit, Mockito, Log4j, microservices, Kafka.

Client: New York Life Insurance, NY December 2019- July 2021

Role: Java/J2EE Developer

Roles & Responsibilities:

Involved in different stages of Software Development Life Cycle SDLC including analysis, designing, coding, and testing.

Profound experience in creating real time data streaming solutions using Apache Spark /Spark Streaming, Kafka and Flume.

Experience in handling messaging services using Apache Kafka .

Configured Kafka to handle real time data.

Implemented all web applications with object-oriented principle and design patterns.

Designed and Developed User Interactive (UI) Web pages using HTML5, React-JS, Bootstrap, CSS, JSX, jQuery, AJAX and NodeJS, Spring REST using Microservices.

Created reusable components used across various modules using React-JS, React-DOM, Bootstrap and JSX.

Migrating an On-premises virtual machine to Azure Resource Manager Subscription with Azure Site Recovery.

Virtual Machine Backup and Recover from a Recovery Services Vault using Azure PowerShell and Portal.

Security Patching on the Azure IAAS VMs through the Shavlik Patching Tool.

Worked with Bootstrap CSS for dialogs, tabs, date picker, model pop up's and advanced components to implement UI model.

Developed routing components in the application using react-router module for various components and views.

Developed the DAO layer for the existing applications using Spring, Hibernate and developed various business logic and reports using HQL and Hibernate Criteria.

Consumed Restful web services using apache Http Client for the data coming from external systems.

Involved in the development of presentation layer and GUI framework using Angular JS and HTML.

Involved in writing application level code to interact with APIs, Web Services using AJAX and Angular resources.

Used UI components, Angular JS directives, controllers, view and routing, service modules, validations using HTML5, applying styles using CSS, used JQuery to make Ajax calls.

Developed Spring JMS message listeners to consume JMS messages from queues and used Spring transaction management to manage the transactions in the application.

Worked with Spring framework at Business Tier and uses Spring container for initializing services and used Spring core annotations for Dependency Injection such as Bean, Component, Repository, Auto wired etc.,

Worked with Spring framework with Hibernate to map to Oracle database and mapping using Hibernate annotations.

Involved in setting up the application to run on AWS environment on multiple EC2 instances with ELB's using Bamboo.

Created various unit test cases and integration tests for the DAO, Service, and Controller components using JUnit, and Spring test support.

Worked with JIRA and Log4J for project management, tracking and monitoring errors.

Integration testing, bugs fixing, handling change requests and code reviews.

Worked with extensively Eclipse in development and debugging the application.

Environment: Java 1.8, JBoss 7, Oracle 11g, HTML, Jest, Enzyme, JavaScript, React-JS 0.13, Node-JS, BowerJS, Bootstrap, CSS, jQuery, AJAX, JSX, MongoDB, Spring, Hibernate, Eclipse, Atom, Grunt, Restful Web services, Gradle, Junit, ANT, Jira, log4j, Jenkins, AWS.

Client: Pepsi Co, Plano, Texas April 2017-December2019

Role: Java Developer

Roles & Responsibilities:

Extensively used various Spring Framework modules like MVC, JDBC Templates, Spring Security and AOP.

Experienced in Web based UI frameworks such as JavaScript, Ajax, jQuery, AngularJS, Angular2, Angular 4, ReactJS, Backbone JS, Tag Libraries, Custom Tags.

Experience with Spring frameworks like IOC, AOP, Spring Boot.

Supported the code builds by integrating with continuous integration tool (Jenkins).

Written Maven scripts, Installed Jenkins, written shell script for end to end build and deployment automation.

Build Continuous Integration environment (Jenkins) and Continuous delivery environment (Puppet).

Integrated delivery (CI and CD process) using Jenkins, Chef, and Puppet.

Design and developed custom and responsive single page applications using Angular 4.

Developed Web Services using SOA technologies such as SOAP, WSDL and REST.

Implemented custom CSS grid system with CSS media queries for mobile responsivenes.

Client-Side code was written in React JS, jQuery and server-side Code were developed using MVC4.

Participated in unit testing creating test cases using Junit and Mockito.

Fixing front end bugs (HTML, CSS, and JavaScript/jQuery errors) using unit testing and A/B split testing.

Designed and developed Selenium tests to verify functionality of internal business applications and verify resulting data.

Implemented Azure Application Insights to store user activities and error logging.

Deployed the tools Microsoft Azure Cloud Service (PaaS, IaaS), and Web Apps.

Tested front end code in multiple browsers to check cross browser compatibility.

Deployed the application in JBoss production server running in Linux platform.

Used design patterns like Singleton, Factory Pattern method.

Implemented REST Microservices using Spring Boot.

Experience in designing and developing applications on relational database like MongoDB.

Developed the J2EE application based on the Service Oriented Architecture.

Environment: J2EE, Spring 4.0 Framework, hibernate 4.X, HTML, JavaScript, Angular, React, JQUERY, JSON, SOAP, XML,

JAVA BEANS, Microservices, JDBC Templates, Azure Cloud, WebSphere Application Server, JBoss, Kibana, Grafana,Junit, Selenium, MongoDB.

Contact this candidate