We provide IT Staff Augmentation Services!

Senior Java/database Consultant Resume

SUMMARY:

  • Versatile consultant that can lead a team, design and code.
  • Senior Team Lead and Designer/Developer in:
  • Java SE/J2EE and Spring/Struts
  • XSL, XML and XSD
  • Data Modeling, ETL and SQL
  • Hands on Team Leader that can manage, lead and mentor team. Work on complete SDLC projects.
  • Work closely with Business Users to gather requirements and devise solutions to business problems.
  • Senior Financial Analyst for 2 years with 4 - year Bachelor Degree in Finance/Statistics from NYU Stern School of Business. Solid finance knowledge and experience.

TECHNICAL SUMMARY:

Web: J2EE, Java SE/Java 1.7, JSP/Servlet, EJB, JMS, JDBC, Swing, JUnit, ColdFusion and TWiki

Framework: Spring, Struts and Hibernate

XML: XSL (XSLT, XHTML, XSL-FO/FOP and XPath), XSLTC, SAX, DOM, XML Schema (XSD), JDOM and JAXB

Web Service: SOA, SOAP, WSDL and Axis

UI: Ajax/Dojo, JavaScript and HTML

Modeling: Erwin ERX, Sybase PowerDesigner, Visio and Rational Rose (UML/OOA/OOD/OOP)

Design Pattern: J2EE and Java Design Patterns

Database: Sybase, MS SQL Server, Oracle, IBM DB2, Informix and MS Access

ETL: Informatica and talEnd

Messaging Middleware: MQSeries

IDE: Eclipse, XMLSpy, dbArtisan and Toad.

Application Server: IBM WebSphere, WebLogic and TomCat

Operating System: Sun Solaris, IBM AIX, Linux and Windows Platforms

Scripting: UNIX Shell Scripting

Scheduler: Autosys

Methodology: Agile, RUP and XP

Apache: Ant and Log4J

Repository: CVS, SVN and Mercury Quality Center

Platform: Axiom Controller

PROFESSIONAL EXPERIENCE:

Confidential

Senior Java/Database Consultant

Responsibilities:

  • Design and code Core Java for existing Java/Sybase Compliance Application/Warehouse. Also, design and develop common Java Utilities Libraries. Performance tune and redesign existing Java Code.
  • Maintain Java Calculation Engine with code updates and bug fixes.
  • Gather requirements, design and develop Sybase tables and store procedures for extractions and calculations.
  • Develop Axiom Controller projects. Enhance and bug fix existing Axiom projects. Build entire Axiom projects/branches.
  • Maintain existing UNIX batch processes.
  • Work with Business Analysts to redesign application to extract, load and calculate existing processes.
  • Mentor and review business requirements with developers and testers.
  • Use Excel and SQL to analyze data and data abnormalities.
  • Manage relationships, coordinate and work with NY/Canadian/Indian developers, NY Axiom Vendor consultants, NY Business Analysts and Philippine/India QA to gather requirements, design, develop and test Axiom platform and Java/Sybase/Unix programs.
  • Collaborate with different groups to devise creative solutions and to make processes more efficient/effective.
  • Coordinate with different departments to meet tight deadlines and production software release.
  • Worked on the following Federal Form Filings projects: CCAR (FR Y-14Q), FR Y-14M, FFIEC 001, FR 2028a/s, FR 2046, FR 2052a, FR 2082, FR 2314/FR 2314S, FR 2502q, FR 2915, FR Y-8, FR Y-9LP, FR Y-11/FR Y-11S and FR Y-15.

Environment: JDK 1.7, Axiom, UNIX, and Sybase 15.

Tools: Axiom Controller, Eclipse, Putty, dbArtisan and Sybase.

Confidential

Senior Consultant

Responsibilities:

  • Used Spring and Hibernate for application and data tiers.
  • Converted the talEnd ETL and MS SQL Server to Informatica and Oracle Stored Procedures.
  • Migrated MS SQL data to Oracle database by utilizing Informatica.
  • Converted Windows Bat Files and Java classes to Unix Shell Scripts.
  • Coded in Autosys to run the UNIX script and Informatica workflow.
  • Worked on Data Mapping and Technical Documentations.
  • Data Architect and Java/Spring/Hibernate/ETL/XML Designer and Developer for a Wintel, Java, MS SQL Server, talEnd ETL and Tidal Scheduler application first version.
  • Used Spring and Hibernate for application and data tiers.
  • Designed and developed the XML/XSD to be consume by other applications. Coded in Core/Multi Threading Java and JAXB.
  • Worked with the Business Analysts and Data Source Providers with the flat file design and data content.
  • Designed and developed the Data Model to load the flat files. Worked with Front End Developers and Business Analysts to design and develop tables and indexes.
  • Designed and developed ETL to extract, load and transform the flat files into the databases.
  • Analyzed data and business requirements to dictate the data rules and work flows.
  • Gathered requirements, designed and developed Store Procedures to compute Monthly reports and clean historical data.
  • Designed and created Application Environments. Designed and created directory structures. Assisted with the SFTP directory structure and process. Created DDL and load data into the databases. Setup Java and ETL jobs. Worked with SA and Operators to automate the SFTP process and run the ETL jobs. Worked with SA and DBA to allocate file and database disk spaces.
  • Analyzed data to assist Business Analysts with understanding the data.
  • Used Informatica to transfer and load Employee and Internal Trades data into Oracle from internal sources.
  • Retrieved, transform and load External Broker Trades flat files by utilizing Informatica.
  • Assisted with the Oracle Database design.
  • Coded in Autosys to run the UNIX script and Informatica workflow.

Environment: Agile, JDK 1.6, Spring, Hibernate, JAXB, XML/XSD, Informatica, talEnd, Autosys, UNIX, Oracle, MS SQL Server and Sybase.

Tools: Eclipse, XMLSpy, Erwin, Toad, dbArtisan, Erwin, Informatica, talEnd, Oracle, MS SQL Server and Sybase.

Confidential

Team Lead and Java/XML/XSL Designer/Developer

Responsibilities:

  • Designed and code in Spring/Hibernate, JAXB and XSL/XSD/XML/FOP.
  • Took over a badly managed project and made the project a success.
  • Made the team of 6 work closer and individually responsible for their code. Managed expectation of the project with the managers and worked closely with QA to manage the larger bug list.
  • Created and managed the project plan and resources. Lead and mentor developers with the current system and new technology. Setup coding standards and code review. Managed the timeline of the project.
  • Communicated extensively with managers, business users and other developers. Act as liaison between the departments and the developers. Worked on the full project life cycle.
  • Worked extensively with Business Users to gather and finalized the requirements. Relayed and explained the requirements and business logic to the team.
  • Converted an existing Servlet to Web Service application.
  • Designed the XSD/WSDL/SOAP for JAX-RPC. Generated JAX-RPC/WSDL/SOAP code from WSAD.
  • Designed and created the XSD for SOAP messages.
  • Worked on the full project life cycle.
  • Used Java IO, Regex and JDBC batch insert to an Oracle database.
  • Designed and developed the JDBC and SQL code.
  • Designed and created the logical and physical data models by using RAD Visual Data Model.
  • Developed UNIX shell scripts.
  • Improved performance speed of 10 times from previous release. Previous release used single JDBC insert while the updated code used JDBC batch insert.

Environment: Agile, Ajax, JavaScript, JSP, Spring, Struts, Hibernate, JDK 1.5, Java IO, Regex, JDBC, Axis, XSLTC, XSL/XSD/XML/FOP, Oracle, DB2, Log4J, Ant and Linux.

Tools: Websphere, RAD, Eclipse, XMLSpy, CVS, Mercury Quality Center, Oracle and DB2 Clients.

Hire Now