Sr. Full Stack Java Developer Resume
NY
SUMMARY
- Over 7 years of Professional experience in Full Stack Development with design, development and maintenance of enterprise level distributed web - based software and client/server applications using Java/J2EE technologies.
- Effective at working in Agile environments using SCRUM methodologies and expertized in Software Development Life Cycle (SDLC), requirements specification, documenting Software architecture and design specifications, Implementation in Java, mentoring and architecture presentations to various stake holders.
- Strong Experience with technologies and frameworks like HTML, CSS, JavaScript, TypeScript, AngularJS, ReactJS, NodeJS, VueJS, Redux, JSX, AJAX, JSON, XML, jQuery, Bootstrap, ES6, BackboneJS.
- Expertise in the implementation of the Core concepts of Java, J2EE Technologies JSP, Servlets, JSF, JSTL, EJB transaction implementation and the JMS, Struts, Spring, Java Beans, JDBC, XML.
- Developed the application using Front Controller, Business Delegate Factory Pattern, Session Facade, Data Access Objects, Singleton, Used Session Facade, Abstract Factory, singleton, DAO design patterns.
- Expert in ReactJS principles such as one-way data flow, virtual DOM, JSX, and React Native for designing interactive User Interfaces. Familiar with creating Custom Reusable React Components Library.
- Worked with Redux architecture using complex Object Oriented Programming Solving (OOPS) concepts in improving the performance of the websites using ReactJS components, Forms, Events, Keys, Router, Redux, Animations and Flux concept and experienced in ReactJS using React Flux architecture.
- Strong working knowledge in Object-Oriented Programming Concepts of Core Java like Abstraction, Encapsulation, Inheritance, and Polymorphism, also knowledge in other concepts of Java like Collections, Multi-Threading, Exception Handling, Generics, Synchronization, Serialization, and De-serialization.
- Working knowledge of Angular CLI, Reactive Forms, Web Forms, and its Validations, in order to construct Desktop Applications with Angular 6, 8 and developed custom HTML elements using AngularJS directives.
- Worked with Angular and TypeScript as part of migration from JavaScript to Angular 6 and React.js, implemented AngularJS Expressions, Directives, Controllers, filters and created Angular JS service layer.
- Created TypeScript reusable components and services to consume REST API's using Component based architecture provided by Angular. Used Typescript and its features such as static typing, classes, and interfaces.
- Experience in Java/J2EE technologies like JSP, Servlets, JDBC, RESTFUL and SOAP-based Web Services, Hibernate, Spring, Spring Data, Spring Rest, EJB, spring data JPA, JSF, Struts, Servlets, JMS, JNDI.
- Hands on experience with Core Java 8 features like Functional Interface Programming, Lambda’s, Streams including extensive knowledge with concurrency, multi-threading, exception handling, filters, and Generics.
- Experienced in Functional, System, Regression, Integration, GUI (Graphical user interface) testing using both Manual and Automation Techniques. Proficient in working with web application's UI testing frameworks such as Karma, Jasmine, Protractor for Angular JS, Mocha and Chai for React JS and Backbone JS.
- Expertise in Core Java concepts, such as Multi-Threading, Generics, Exception Handling, Collections, Java Reflection, Annotation, Synchronization, Serialization and De- serialization and other tools like Lambda expressions in Java 8.
- Re-designed, re-architected and built the existing application using Java 11, Spring Boot, Spring Reactive Stack (Web Flux), GCP, PostgreSQL and Maven.
- Developed the application using Front Controller, Business Delegate Factory Pattern, Session Facade, Data Access Objects, Singleton. Used Session Facade, Abstract Factory, singleton, DAO design patterns.
- Experience in developing applications as Microservices using Spring Boot based on Service Oriented Architecture (SOA) with ESB (Enterprise Service Bus), implementedSpring Boot Microservicesto divide the application into various sub modules, Pivotal Cloud Foundry (PCF)and Engagement usingSpring Boot.
- Experienced in producing and consuming SOAP and RESTful Web Services using JAX-RS, JAX-WS, WSDL, JAX-B APIs and implemented using Jersey, Jackson and Spring REST libraries.
- Expertise in Spring framework using Modules likeSpring Core, Spring IOC, Spring Mongo, Spring JDBC, Spring Context, Spring JMS, Spring AOP, Spring Batch, Cloud Data and Spring Cloud Data Flow.
- Used Spring Core Annotations for Dependency Injection, Spring MVC for REST APIs, and built microservices using Spring Boot based on Service Oriented Architecture (SOA) with Enterprise Service Bus.
- Experience in Object Relational Mapping (ORM) using Hibernate 4.x, Hibernate OGM, MyBatis, and Spring Data JPA frameworks. All the functionality is implemented usingSpring Boot, JPAandHibernate ORM.
- Knowledge on Implementing and working on basic token-based registration/login/logout flow withReact Router v4and used the JSON Web Token (JWT) for the server-side user authentication.
- Worked on the OAuth 2.0 for accessing the cloud storages like Box, one drive, Google Drive, Drop box. Good Knowledge on working withOAUTH2.0to provide authentication and authorization to Rest services.
- Hands-on experience in using variousVersioncontrolsystems likeSVN,CVS,Git and SCM like Bitbucket, GitHub, GitLab and used them for performing branching, tagging, merging and maintenance.
- Worked on Gradle, ANT and Maven the build process and maintained the configuration file POM.xml for the continuous integration and stored the build artifacts in repository such as JFrog and Nexus. Involved in design and development of QA Automation test using programs as Postman, Swagger, AccelQ.
- Perform theAPI Testingfor the end points systems usingSwagger, POSTMAN toolsand make sure the end point are working fine. Knowledge Develop scenario-based testing for theJMeter scripts.
- Experience in developing automation framework for testing using Selenium, JUnit, TestNG, Mockito. And also extensively worked in executing tests by using Selenium grid/Testing in different/Cross Browser testing.
- Solid experience in Java Database Connectivity;JDBC API, Entity Beans, DAO Pattern, and configuring data sources onWeb sphereandWeb logic App Server.
- Experience in working with messaging systems likeKafka, RabbitMQ and knowledge of real time data analytics usingApache Sparkfor developing Spark streaming modules. Designed RabbitMQ queues and exchanges and binding relation between them, reading and downloading the RabbitMQ queue using multithreading by allowing n number of threads to record data in the file. And hosted all our micro services in AWS cloud infrastructure using Jenkins CI/CD pipelines.
- Ample experience in back-end technologies including SQL databases such as PostgreSQL, MySQL, and Oracle Database and NoSQL Databases such as DynamoDB, MongoDB and Cassandra. Hands-on experience in PL/SQL programming with complex SQL join triggers & stored procedures and created PL/SQL.
- Proficiency in deploying J2EE Applications archives (JAR, WAR and EAR) onIBM Web Sphere Application server,Apache Tomcat Web Server,andBEA Web Logic Application Server.
- Expertise in AWS such as EC2, AWS RDS, Dynamo DB, S3, SES, SQS, SNS, Elastic Compute Cloud (EC2), Elastic Load-balancers, Elastic Container Service (Docker Containers), and has written CloudFormation script a. Experience using AWS lambda and used other AWS services like AWS API Gateway configure restful using Dynamo DB we store database, Kubernetes, and Deployment of Cloud service includingJenkins and Nexus on Docker using Terraform.
- Working with the JIRA tool for quality center bug tracking. Analyzed production system problems tracked with Rational ClearQuest and JIRA. Switching JIRA HSQL database to SQL database/ my SQL/ oracle database.
TECHNICAL SKILLS
Web Technologies: jQuery, HTML, HTML5, CSS, CSS3, TypeScript, AJAX, DOM, RWD, DHTML, XHTML, JSON, XML, SASS, SCSS
Java Technologies: Spring, Spring Boot/MVC, Hibernate, Servlets, JDBC, JSP, JSTL, Swing, EJB, Scala
JavaScript Technologies: AngularJS, Angular 2/ 4/ 5/ 6/ 8/9/10, React.js, Redux, EXT.js, Backbone.js, Require.js, Node.js, Vue.js, Express.js
Database/RDBMS and ORM: Oracle, MS SQL Server, MySQL, MongoDB, Redis, Cassandra, CouchDB, PL/ SQL, PostgreSQL, Dynamo DB, Boto3, NumPy
Web Services: RESTful, SOAP, WSDL, UDDI, AWS (Amazon Web Services), Axis2
Testing Frameworks: JUnit, Karma, Mockito, Power Mockito, Jest, Log4j
Operating Systems: Windows, UNIX, LINUX, Mac OS.
Web Servers: Apache Tomcat, Glassfish, WebSphere, WebLogic, JBoss, Nginx
Tools: and Packages: GIT, IntelliJ IDE, Eclipse IDE, GitHub, Maven, Gradle, ANT, Jenkins, JIRA, Swagger, Grafana, Bitbucket, Docker, Kubernetes, Apache Camel, Kibana, Nexus, Ruby, Nagios, Hadoop, Jersey, Prometheus, Hive, MapReduce
Web Debug Tools: Apache Log4, Jira, Bugzilla, Maven 3.x, Gradle
Languages: Java, JavaScript, Python
Cloud: AWS, GCP, Azure
PROFESSIONAL EXPERIENCE:
Confidential, NYSr. Full Stack Java Developer
Responsibilities:
- Worked in designing, developing, and testing the web application by using the HTML5, CSS3, SASS, LESS, React, Bootstrap, and JavaScript, NodeJS, Redux.
- Developed user interfaces by using the ReactJS, Redux and skilled in leading frameworks such as React.js to build high-quality, scalable, and reusable components and Front-end solution.
- Used ReactJS to create custom components for data manipulations and display in company standard format. Using React.js for various predefined components from NPM (Node Package Manager) and Redux library. Developed single page applications usingReactRedux architecture
- Used React JS virtual DOM for client-side view rendering services, React-Redux for state management and React-Router for client-side routing for dynamically changing client-side content.
- Worked in Redux architecture using complex Object-Oriented concepts and improved the performance of the websites and worked with React Flux architecture and used Redux-form to manage form state in Redux.
- Implemented various screens for front-end and Redux-Sagas to manage side effects in React + Redux. Implemented flux pattern by using redux framework as a core dependency.
- Worked in React.js for creating interactive UI's using One-way data flow, Virtual DOM, JSX, React Native concepts also worked with Drag and Drop functionality using React-Draggable for developing dynamic client. Developed the web application with the newest React features centralized with Hooks.
- Developed front end Single Page Application (SPA) which can be bind data to specific views and synchronize server data with the server Sass, Bootstrap by using Angular 6 and backend using Spring boot.
- Extensively used Java 8 features such as lambda expressions, Parallel operations on collections, multithreading for effective sorting mechanisms. Used Streams and Lambda expressions available as part of Java 8 to store and process the data.
- Exposed APIs using Rest @RestController interface for producing and consuming JSON formatted data. Created aWCFService to generate API for use in the project.
- Configured JWT Token for authorization of spring services, extensively worked with making calls to APIs to fetch the data from the backend as JSON response and parse it on the User interface (UI).
- Migrated the web service resources of SOAP to Spring RESTful using Spring REST API with Spring Boot. And Experience in producing and consuming SOAP and RESTful Web Services using JAX-RS, JAX-WS, WSDL, JAX-B APIs and implemented using Jersey, Jackson and Spring REST libraries.
- Worked in implementing Micro Services, SOA with xml base web Services (SOAP/UDDI/WSDL) using Top Down and Bottom Up approach.
- Worked with testing tools such asUnit for Java,Quit for JavaScript,andA/B Testing for Website Design and its traffic flow. Mockito and used Jasmine for front end testing and automation framework like Selenium. Developed automation framework using Selenium, and TestNG with Java; Parasoft SOA
- Scaled microservices, distributed systems and server less applications using Simple Queue Service. Used IntelliJ IDEA IDEfor app development. Developed micro-services using Spring MVC and Spring Boot.
- Implemented functionalities using the Spring Boot, Hibernate ORM and also led in the development of JavaEE components using Spring MVC, Spring IOC, Spring Transactions and Spring Security modules.
- Developed strategy for integrating the internal security model into new projects with Spring Security, Spring Boot and implemented microservices using Spring Boot, and enabled discovery using Netflix eureka server. Worked with Docker to deploy Micro-services in modern containers to increase Isolation.
- Worked with the SPRING framework hibernate integration to maximize the Classical model view controller layer (MVC) Architecture.Implemented SPRING MVC application framework to create and configure of Java beans using SPRING IOC and used SPRING Hibernate support, transaction management.
- Implemented RESTful Web services to retrieve data from client side and made REST API calls from React and parsed the data to project to client and handled the security and Authorization using Spring Security and OAuth1/2.Developed the Web Services Client using REST, RSDL for verifying the new customer history to a connection.
- Implemented upgrading and migrating various versions of PostgreSQL database on different platforms. Responsible for all backup, recovery, and upgrading of all of the PostgreSQL databases.
- Used Version Control System GIT for maintaining GIT source code, pulled, pushed and performed merge requests into the Git Repository and deployed, configured GITrepos with branching, tagging and notifications.
- Developed DAOs (Data Access Object) using Hibernate as ORM to interact with DBMS - MySQL and Mongo DB. Optimized the full text search function by connecting to Mongo DB.
- Experienced on Tested Performance of Web and Mobile Applications and Generated Automation Test scripts using NeoLoad. Used Node.js for deploying POC and used for Bower and other development automation tasks.
- Worked on Thread handling to maintain continuity of execution and extensively implemented Multithreading concept to handle Transaction Management with isolation and propagation levels.
- Worked on setting up and configuring Kafka Environment in Windows from the scratch and monitoring it and standing up and administrating on-premises with Kafka platform on Windows and Linux environment.
- Used MAVEN as a Build Process and used generating Documentation, Reporting, and adding Dependencies. Performed daily Night Build & Weekly Build & Release for the product using Maven build scripts.
- Configured and maintained Hudson to implement the CI (Continuous Integration) process and integrated the tool with Maven to schedule the builds and also took the sole responsibility to maintain CI Hudson server.
- Designed and developed the framework to consume the web services hosted in Amazon EC2 instances.Participated in troubleshooting issues on AWS, Netflix Eureka and Cloud environments.
- Analysing of SOA based application with Solar / web service / apache ignite cache based systems for optimal usage.
- Performed configuration, deployment & support of cloud services including Amazon Web Services (AWS). Configured and developed application log files using SLF4J to log errors and trace only the required messages.
- Worked on AWS Deploying, managing, and operating scalable, highly available, and fault tolerant systems & managing the continuous delivery systems, methodologies on Amazon Web Services (AWS).
- Using JUnit test in Eclipse, developed Unit test cases and test suite, curl was also implemented to test. And also used Jenkins as the integration tool and improved scalability of applications on cross-platforms. Deployed the Application EAR and RESTful Services on JBoss Application Server.
- Involved in Production Support and Maintenance of the application and troubleshooting of Issues on JBoss by checking logs, payments etc.
- Used Bugzilla tool to track bugs and resolve them by identifying those bugs. Documented defects with high level of details, accuracy and informative steps using JIRA, Bugzilla
Environment: Java/JDK, J2SE/J2EE, HTML5, CSS3, JavaScript, JQuery, Spring, Spring Boot, Spring Batch, Spring MVC, AngularJS, NodeJS, Ec2, S3, SDK, MySQL, SOA, JDBC, AWS, Netflix Ribbon, Hibernate, REST, JSON, RESTful, Eclipse, MAVEN, JUnit, Jenkins, JBoss, Linux OS, MongoDB, GIT, PL/SQL, Docker, ANT, JIRA, Bugzilla, Kafka, JMS.
Confidential, Houston, TX
Full Stack Java Developer
Responsibilities:
- Provided strategic direction to handle Software Development life cycle phases like Requirement gathering, designing, estimating the timelines for the project.
- Designed, analyzed and developed the front-end and back-end Servlets, Bootstrap for designing, HTML5, CSS3, Ajax, Angular JS for developing presentation layer.
- Created the AngularJS app usingYeoman, Grunt and Bower and used Angular UI for component model.
- Actively involved in using MVC, HTML5 to enable client-side date to meet specific criteria by applying various validation variables and used theCSS classes to provide visual feedback on validation.
- Developed custom directives, Factories and Services in AngularJS and implemented code per coding standards and created AngularJS Controller to isolate the scopes to perform operations and extensively usedCoreJavasuch as Exceptions, and Collections.
- Expertise in consuming Restful web services using Node JS, AngularJS and jQuery along with JSON parsing to implement AJAX call and render the response data to User Interface.
- Used Typescript and its features such as static typing, classes, and interfaces. Created TypeScript reusable components and services to consume REST API's using Component based architecture provided by Angular.
- Developed SOAP based JAX-WS Web Service interfaces for integrating multiple systems, code re-usability. Analyze business requirements and develop various business delegates to integrate with Middleware services like JAX-WS using SOAP and REST.
- Worked on Rest Web services for backend services used Oracle for database services and RESTful web services using Jersey for JAX-RS implementation.
- Developed dynamic and interactive web applications using JavaScript. Worked with front end JavaScript technologies such as ES5, ES6 and source control systems like TFS and gained familiarity with GITHUB.
- Built an existing application using Java 8 using features such asLambdas,Streams, Observables, Completable Futuresalong with Spring Boot, Spring Reactive Stack, GCP, PostgreSQL & Maven.
- Developed Web Services using REST interfaces using MuleSoft's Mule Enterprise Service Bus (ESB) platform to deliver fast, reliable and scalable integration API code.
- Developed Restful Web services for other systems to interact with our system and secured the service with Spring-Security and Oauth-1.0.
- Used Spring MVC components to implement business layer and Spring Boot for Micro-services. Used the Spring IOC feature to get Hibernate session factory and resolve other bean dependencies also used Spring framework AOP features and JDBC module features to persist the data to the database for few applications.
- Utilized spring core, AOP andsecurity to build robust business operations with transactional support.Used Spring Inheritance to develop beans from already developed parent beans, Spring AOP for logging, auditing, and transaction management to distinguish business logic from cross-cutting concerns.
- Implemented ORM using JPA and Hibernate framework also worked on Integration of Spring and Hibernate frameworks using Spring ORM with the Spring framework to communicate with the back-end process.
- Developed the data access classes using JDBC and SQLquerylog4j for logging and SVN for version control.
- Developed Struts Action classes using Strut’s controller component and developed J2EE application using Servlets, JSP, JavaBeans and EJB and also entity Beans used for accessing data from the SQL Server database. Sound knowledge in SQL within Oracle, MySQL, MS-SQL Server.
- Implemented the function to send and receiveAMQPmessages onRabbitMQsynchronously and asynchronously, and sendJMSmessage toApache Active MQon the edge device.
- Had knowledge on Kibana and Elastic search to identify the Kafka message failure scenarios. Worked with Kafka Admin team to set up Kafka cluster setup on the QA and Production environments.
- Used Clear quest and Jenkins for Continuous Integration and deployment into Tomcat Application Server.
- Expertise on UI testing withJunit, Cassandra and Jasmineused for Angular Scripts. Developed unit and integration tests for existingmicro servicesusing JUnit, Mockito and Docker environments.
- Implemented Atlassian tools like Bitbucket, Bamboo and Jira for build and Maintenance of the project. Implemented HUB to the central interface to manage organization, manage users, view usage.
- Worked on Jenkins to implement the continuous integration (CI) and Continuous deployment (CD)process. Developed deployment workflows in Jenkins which includes prerelease,release,and Postrelease steps.
- Developed and Implemented MAVEN Scripts to automation of build process on MAVEN build tools to test the application manually and run the JUNIT Test suites.
- Developed ANT scripts to build and deploy the application in the WebSphere Application Server.
- Used JIRA tool for Issue/bug tracking, monitoring of work assignment in the system.
Environment: Java,J2SE/J2EE, JDK, RCP, AWSSDK, Git, Swing, JFC, Spring, Hibernate, Core Java, SOAP/Rest, Web Services, JavaScript, UML, Bower, HTML5, CSS, SASS, Sonar, WAS 8 WSDL, JIRA, JAX-WS, JAX-RS, MYSQL, JMS, Oracle, Angular JS, WebSphere, Spring, Spring Boot, Spring Batch, AJAX, jQuery, JUnit, Maven, ACTIVE MQ, Rabbit MQ.
Confidential, Phoenix, AZ
Java Developer
Responsibilities:
- Migrating the application to Cloud environment using the Amazon web services - EC2, S3 and various services of AWS.
- Created customized AMIs based on already existing AWS EC2 instances by using create image functionality hence using dis snapshot for disaster recovery.
- Involved in developing and delivery of a Micro service application utilizing almost of the AWS Stack including S3, EC2, DynamoDB, Kinesis, SNS and SQS.
- Developed messaging module using Spring JMS and ActiveMQ to exchange the information in more reliable and asynchronous way in Enterprise Applications.
- Used Simple storage services (S3) for storing snapshots and Configured S3 lifecycle of Applications & Databases logs, including deleting old logs, archiving logs based on retention policy of Apps and Databases.
- Developed code with Java SDK to connect with AWS Services. Worked with S3 for storing and retrieving data stored in the S3 bucket’s, AWS SQS for bulk email processing, Data backup and archiving on AWS using S3 and Glacier and Dynamo DB to store the data for metrics and backend reports.
- Worked with AWS API Gateway for implementing the Micro service architecture and the utilized ECS to deploy the Docker containers onto the servers.
- AWS Lambda was utilized for serverless implementations, where the functions were triggered when the database tables were updated and AWS Cloud Watch was utilized for alarms.
- Used Spring beans to encapsulate business logic and implemented application MVC architecture using Spring Boot framework.
- Used JAX-RS for creating RESTful web service where the request and response are in JSON format.
- Migrating existing application into REST/HTTP based Micro service architecture leveraging Spring Boot capabilities.
- Designed and developed the persistence layer using Hibernate persistent objects, for interaction with the databases.
- Implemented data reading, saving and modification by stored procedures in MySQL database and Hibernate criteria.
- Integrated Apache Kafka as the asynchronous messaging system implemented and it was Publish/Subscribe system.
- Participated to develop Authentication and security in Apache Kafka pub-sub system, integrated Apache Kafka for data ingestion. Developed test cases by using JUnit and spring integration test framework.
- Implemented Test Driven Development using JUnit, Advanced Rest Client and Log4j in developing test cases and determining application functionality.
- Participated in the design of user interface of the application using HTML5, CSS3, JSF, JavaScript and AJAX.
- Worked with GIT Version control system to track various aspects of the project.
- Developed build script using MAVEN to build, package, test and deploy application in application server.
- Utilized Jenkins for Continuous Integration and Continuous Delivery.
- Used Agile methodology to develop the application.
Environment: Java, J2EE, Hibernate, Spring, Junit, Mongo DB, Cassandra, Web Logic, HTML5, CSS3, JavaScript, jQuery, Linux, Kafka, Eclipse, AJAX, Angular JS, JSON, JSF, AWS (EC2, S3, VPC, RDS, Dynamo DB, Route53, EBS, Elastic, Load Balancer, Auto Scaling groups, SQS, Kinesis).
Confidential
Java Developer
Responsibilities:
- Performed the analysis, design and implementation of software applications using Java, J2EE.
- Involved in implementing the complete Application in the in-build MVC Architecture withAngularJS.
- Implemented design patterns like Data Access Objects (DAO), Value Objects/Data Transfer Objects (DTO), and Singleton etc. Developed JavaScript using Ember.js validations on order submission forms.
- Coded Modules in Java, HTML, JSTL, JavaScript, CSS, JSON, JSP and Servlets. Created dynamic HTML pages, used JavaScript for client-side validations, and AJAX to create interactive front-end GUI.
- Utilized Angular libraries likeAngular UI router, Angular resourceto make the powerful single page application and utilized angular storage to briefly store the information utilized as a part of dis application.
- Implemented the application usingSpring BootFramework and handled the security usingSpring Security.
- Implemented the MVC architecture using the Spring framework, Action Form bean and configured the Spring- config.xml file. Integrated jQuery Grid View for all Data View for the product.
- Extensively usedSpring JDBC templateandHibernatefor performing Database Transactions.
- All the functionality is implemented usingSpring Boot, JPAandHibernate ORM. Implemented Java EE components usingSpring MVC,Spring IOC,Spring transactionsandSpring securitymodules.
- Responsible for Setting up Web Services project usingWSDL in SOAP UIand provided setup halp to other team members. Used XML files in Sending/receivingXML requests using SOAP UI.
- UtilizedReact.jsfor its efficient dataflow architectureto create a lightweight and render efficient web app that searched projects via theGitHub APIthrough keywords.
- Used Apache Ant to compile java classes and package into jar archive. Wrote MySQL, PL/SQL queries, stored procedures, and triggers to perform back-end database operations.
- Worked on writing the Maven script for the build process and maintained the configuration file POM.xml for the continuous integration. Created a continuous integration system using Maven, Jenkins, Ansible
- Worked on SQL queries with Oracle SQL developer to select, insert, update, joins etc. for testing and development purpose in local environment.