Java Developer Ms Sql

Sean Xinhao Zhao

**** ******** **., ********, ** 43026

Phone: 614-***-**** (Cell)

****.****.****@*****.***

Professional Summary

* ***** (up to now) of experience in financial business. (JPMorgan Chase)

18 years of experience in Tele Communication Industry (Mostly JAVA Web applications).

2 years of experience in eCommerce Industry (VC++ Windows Applications)

5 years of experience in Financial Business (part time job at night and weekend) (Windows application of VC++, Web

Application of Java)

1 year of experience in Compensation Insurance Business

1 year of experience in Controller Hardware Industry

1 year of experience in Software Image Process Industry

Role Summary

Huntington National Bank: Contractor

Worked on Payment Request System with Restful API, Azure, SQL Developer(Oracle). MS SQL(SQL Server).Java 17, IntelliJ and Agile, IBM Message Queue.

JPMorgan Chase: Sr. Java Developer

Worked on the new project, Started the framework of retrieve huge data from one system and upload to cloud database with Spring Batch, worked with admin team to manage the running schedule with AutoSys.

Worked on the new project, with Spring Boot, Restful API & React API

Wrote a MS SQL queries to build a tool for a product owner team.

Discussed with user team to approach the UI design.

Developed and designed RESTful API using Spring Boot and Spring Batch on Mortgage, CIB(Chase Investment Bank) and Cyber Security web projects

Utilized React to develop a mortgage web application with MSSQL to CRUD database.

Utilized Java 8, 11 to create the backend for cyber security and investment dashboard projects

Used MS SQL and MySQL for a mortgage project and a stock web project

Worked in primarily a Scrum/Agile environment in mortgage, investment and cyber security projects

Coached the entry level developer to add new features.

Upgrade a tool for customer service to solving bank account transferring issues.

Analyzed the data with SQL to find the issue customer report it.

Wrote the steps of analyzing for new team member.

CenturyLink/IBM: Lead Software Developer

Worked on a new branch project of a large project. Started a framework and build a team.

Discussed with user team to find out what they need.

Design the framework and review with them to make an approach

Lead a team and design a project for young developers

Utilized Java 8 to develop the backend of web inventory application and a wireless application

Utilized HTML CSS on the frontend for a web inventory application and a wireless application

Worked in both Agile and Waterfall for a web inventory application

Interacted with Project Managers for a web inventory application

Skills used are Java, EJB, Weblogic, JBoss, Servlet, JSP. HTML, CSS and Oracle queries.

REsponsibilies

1.In Chase

Worked on the new project, Started the framework of retrieve huge data from one system and upload to cloud database with Spring Batch, worked with admin team to manage the running schedule with AutoSys.

Worked on the new project, with Spring Boot, Restful API & React API, writing a MS SQL queries to build a tool for a product owner team. Discussed with user team to approach the UI design. Coached the entry level developer to add new features.

Upgrade a tool for customer service to solving bank account transferring issues. With SQL, analyzed the data to find the issue customer report it. Wrote the steps of analyzing for new team member.

2.In CenturyLink & IBM

Worked on a new branch project of a large project. Started a frame work and build a team. Skills used are Java, EJB, Weblogic, JBoss, Servlet, JSP. HTML, CSS and Oracle queries.

Discuss with user team to find out what they need. Design the frame work and review with them to make an approach

Lead a team and design a project for young developers

3.In Sterling Commerce

Researched a new web project with JSP, C++ and Java to CRUD(create, read, update and delete) MS Database. And coach 2 young developers

Skills

J2EE, Java8 and Java 11, 17, Spring Batch, RESTFul, POI, React, Spring Boot, Maven,

EJB, SOAP, Struts, Servlet, Axis2, SAX, JMS, JAXB, JFreeChart, Google Map Library, Android Map Library, HACL, Batik, Shell Scripts, JUnit, Cucumber, Spring, VC++

WebServices, Weblogic, JBoss, Tomcat, Hibernate, JPA, Mybatis

JSP, HTML, CSS, XSL, XML, JSon,

SQL Studio, SQL Plus, SQLDevelopers, TOAD, CVS, WebMethods

Oracle SQL, Store Procedures, SQL Server

SourceTree, Git, Git Bash, CVS, Agile

Windows, Linux/Unix, Cygwin64

Visio

Trained in Resolve Systems, Groovy

Photoshop

Experience

Contractor Oct 30h, 2023-Present

Huntington National Bank

Role: Payment Request System, Java 17 Developer, Spring Batch, Restful API, Junit Test. Azure, Json, Swagger, Thunder Client, MS SQL, Maven, IntelliJ, Agile, Spring Boot, MS SQL(SQL Server), SQL Developer(Oracle). IBM Message Queue.

Added Restful API controller(@GetMapping, @PostMapping) to hit Oracle DB and MS SQL DB.

Using Spring Boot to create controllers, services and DB objects

Writing queries on Oracle and MS SQL

Writing Junit Test and QA Test for the features I added.

Writing Doc for the logic of my code.

Using Azure tools as commit and push the code

Using Azure tools to do business document stories

Using Fuse to deploy the code to QA and Product systems.

Analyzed the data from DB to fix the issues.

Writing Swagger for user and QA to testing

Discussing with product owners and QA team to design the code.

Demo the code to the user team.

Full Time Dec 12th 2017, Aug, 2023

JPMorgan Chase – Columbus, Ohio

Role: Cyber Security, Java Developer, Spring Batch, Jira, Json, MS SQL, Maven, Eclipse, Agile, Spring Boot, Stored Procedure, IntelliJ.

Responsibility:

Worked on the new project, Started the framework of retrieve huge data from one system and upload to cloud database with Spring Batch, worked with admin team to manage the running schedule with AutoSys.

Added new a button on React to direct to a new branch of data CRUD

Help teammate to code on React.

JPMorgan Chase – Columbus, Ohio Dec 18th, 2017- Des 11 th,2021

Role: Product Support SQL Developer, Oracle SQL. Splunk. Maven. Tomcat8, Java8. Agile, Jira, Jenkins. Junit, Bitbucket. Most SQL, Splunk, Debug. Part time develop tools with Java8.

Responsibility:

Worked on Splunk system to analyze the data transfer in DB

Built a tool for product support with Spring Boot, Restful API and React with Oracle DB.

Contractor Feb. 6th, 2017-Des 15th,2017

JPMorgan Chase – Columbus, Ohio

Roles: Design and developed a web project with Java8, Material-UI(React, Node) JavaScript, Maven, Spring Boot, Hibernate, JPA, MyBatis, POI, JUnit, Cucumber, Oracle 11. SQL Developer, Agile, Git(Git Bash), Jira, Json and Restful, Webservices.

Responsibility:

Developer UI application with React with MS SQL DB.

Lead Software Dev Apr 2015 – Feb 3rd, 2017

IBM – Dublin, Ohio

Client : CenturyLink, (Monroe, LA), Building a team for developing a automation of router activation. It could be built on Java, Shellscript, Cygwin, Cron, Oracle SQL queries, Visio, JBoss, MySQL, Spring, Maven.

Resolve Systems, Groovy.

Client : PPL, (Pennsylvania Power & Lights), Shell Scripts, WebMethods, Webservices, JUnit, Oracle SQL Queries

CenturyLink, Please see bellow

Smart Meter Project. Worked on Smart Electricity Meter project. Transfer the meter data from utility poles to central server. It is java base project and running on Linux/Unix server with Shell Scripts.

Lead Software Dev, Sr. Software Dev. Mar 1998 – Mar 2015

CenturyLink – Dublin, Ohio

Roles: Designed and developed web applications from front-end to back-end, Oracle Database, SQL

Queries, Store Procedure, JDBC, EJB, Weblogic/JBoss/Tomcat, Webservices, Restful, Struts2, JSP, HTML, XSL, XML, Java Scripts, CSS, Ajax, Jquery, Shell Scripts, JUnit.

Libraries used: Struts, Servlet, Axis2, SAX, JMS, SOAP, JAXB, Castor, Jfreechart, HACL, POI, Google Map,

Android Map, Batik, CORBA, VC++

Tools used: Eclipse, CVS, Dimensions, Build Forge, TOAD, SQL Developers, SQL Plus,

Systems: Windows, Unix/Linux, Android.

Build IPAM (IP Administration Management) – Web based project running on Oracle database

Build Remove Control – Web based project to assign IP and Router to customer. Webservices project

Lead an ARIN (American Register Internet Name) web application, Restful project

Build Router Activation – Web based project support on Windows and Android(Mobile) system.

System Architecture (Consultant) Feb 1998 – May 2002

ValuEngine – Columbus, Ohio

Roles: Wired the intranet in office (5 computers), Set up the DNS for internet. Installed SQL Server,

ODBC, JDBC, Made a Windows application for CRUD data from SQL Server with VC++. Made a web application for CRUD data from SQL server with Java (Servlet, JDBC, HTML, Java Scripts). Built up a developer team (5 developers).

Software System Architecture, Sr. Software Dev. May 1997 – Feb 1998

Celerity Technologes(Care Works) – Dublin, Ohio

VC++, MFC, Windows NT, SQL Server,

Sr. Software Dev. Aug 1995 – Apr 1997

Sterling Commerce – Dublin, Ohio

VC++, MFC, Windows NT, SQL Server, MS Mail Server

Sr. Software Dev. Aug1994 – Jul 1995

Allen Bradley – Mayfield Heights, Ohio

VC++, MFC, Windows NT

Software Engineer. Sept 1994 – Jul 1995

Computer System Company – Parma, Ohio

VC++, MFC, Windows

Education

Master of Science: Electrical Engineering Feb 1989 – Present

University of Akron – Akron, Ohio

Bachelor of Science: Electrical Engineering Feb 1979 – Feb 1983

Shanghai University – Shanghai, China

Contact this candidate