Chef de Projet DBA Delphi, Java

Publié le 18 novembre 2009 par Aggil

Five years of experience in software development. Have good knowledge of design and development on both Oracle and Microsoft SQL Server databases. Good knowledge in health care industries.

Skills

  • Languages & Scripting : Delphi, Java, JavaScript, Servlet, JSP, HTML
  • Operating Systems : Windows 2000/98/95, MS DOS, Solaris
  • Databases : Oracle, Microsoft SQL Server 2000,2005, Microsoft Access
  • Web Servers : IIS, Tomcat, Websphere, JBoss
  • Analysis & Design Tools : Oracle Designer, ER Win
  • Configuration Management Tools : Visual Sourcesafe
  • Methodology : Rational Unified Process (developing)
  • Other Special Skills : Crystal Report, Borland Report Builder

Education

Bachelor of Science – Information Technology, Natural Sciences University, Ho Chi Minh, Viet Name (2002)Attend JOSIN group of SaigonCTT company to research and learn Sun system (Solaris) and Networking (October 2002 – January 2003)Achieved MCP on Microsoft SQL Server 2000 Enterprise Edition.Completed two exams 70-228 : Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition and 70-229 : Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition

Relevant Work Experience

xxxx and AGGIL NT Consultant June 2004 –present

Project : xxxx

Project Description :This project is to develop an e-Commerce website to sell electronic accessories. It includes payment online using Paypal Checkout and Google Checkout.This project also builds an Ebay store to introduce these products.

Industry : E-commerce

Project Team Size : 6-12

Role(s) : DBA Leader, Project Lead

Skill Set Utilized : Microsoft Windows XP, Microsoft Windows Server 2003, Microsoft SQL Server 2005, DotnetNuke framework

Responsibilities :

  • Manage team
  • Communicate with customer on requirement, project issues
  • Administer SQL database server
  • Design database
  • Implement business logic at database tier
  • Research Marketwork to support checkout in Ebay.
  • Verify build.

Assignment Duration 6 months

Project : xxxx

Project Description :This project is to develop xxxx Quantum Choice healthcare information system. It is built on the MS.NET framework 2003 using Visual Basic.NET language and MS SQL 2000 database server.Quantum Choice is strategically divided into several interrelated components, including : QC Forms, QC Processing, QC Reporting, and QC EDIWorks.

  • QC Forms is responsible for forms management, rules definition, and data entry for health plans, members and eligibilities, providers, contracts, claims (institutional, professional, and dental), agents/brokerages etc. in the xxxx Quantum Choice system and viewing the processing results of adjudication, premiums billing, commission, and accounting transactions processes.
  • QC Processing is the back-end processing component, which is responsible for processing the data in variety areas of healthcare domain, including : profession/institutional/dental claims adjudication, premiums billing processing, commission calculation, and accounting transactions processing.
  • QC Reporting is responsible for generating diverse types of report based on entry data in the system and user-defined criteria
  • QC EDIWorks is responsible for defining the standards and formats of the data exchanged among Quantum Choice and other healthcare systems.

My work is supporting database for whole Quantum Choice product but mainly in QC Forms and QC Processing.

Industry : Healthcare Insurance

Project Team Size : 40

Role(s) : DBA Leader

Skill Set Utilized : Microsoft Windows XP, Microsoft Windows 2000, Microsoft SQL Server 2000, SQL Compare tools (SQL Examiner, Red Gate SQL Bundle)

Responsibilities :

  • Manage database team
  • Administer SQL database server
  • Review database design and give the feedback for client.
  • Communicate with onshore team / customer to solve database issues.
  • Implement business logic at database tier for QC Forms such as write procedures, functions, …
  • Work with members of project teams to make certain specifications are satisfied.
  • Make database scripts for the each build. Work onshore (xxxx, Oregon, US) for 6 months with following assignments :
  • Directly communicate with DBA team of customer to co-ordinate database activities with offshore.
  • Work with DBA team of customer on the database design
  • Work with customer to clarify the requirements and communicate with the development team

Assignment Duration 16 months

Project : xxxx

Project Description :This project is to port the existing MacNICU application from its current Macintosh / Helix platform to Crib Notes - a PC / Java (thick client) platform with SQL-SERVER and ORACLE as preferred databases.

Industry : Health Services

Project Team Size : 25

Role(s) : DBA

Skill Set Utilized : Macintosh, Microsoft Windows 2000, Oracle, PL/SQL Developer, Microsoft SQL Server

Responsibilities :

  • Write documentation of reports based on the existing MacNICU application.
  • Write database objects such as stored procedures, functions, and views in Oracle Database and convert these objects to SQL Server Database manually / using SQL Ways conversion tool.

Assignment Duration 7 months

Project : xxxx

Project Description :This project is to develop xxxx eService application that is a resource management service.

Industry : EServices

Project Team Size : 8

Role(s) : Developer

Skill Set Utilized : Microsoft Windows 2000, Microsoft SQL Server, Crystal Report, JSP

Responsibilities :

  • Mainly work with the Manager Workbench module that provides a friendly interface for the user to run online reports.
  • Build the reports by using Crystal Report.
  • Write SQL Server database objects such as stored procedures, functions, and views to get reporting data.
  • Maintain the project.

Assignment Duration 5 months

xxxx February 2003 – May 2004

Project : Technical Support Website

Project Description :This project is to develop a Web-based application for technical support service

Industry : Telecommunications

Project Team Size : 2

Role(s) : Developer

Skill Set Utilized : Servlet, JSP, Javascript, Apache Struts Framework, Jbuilder, Tomcat, Oracle, PL/SQL Developer, Microsoft Windows 2000

Responsibilities :

  • Analyze and design project based on Apache Struts Framework.
  • Design and building database on Oracle 8.1.7 with PL/SQL Developer tool.
  • Develop using JBuilder 9 Tools and Tomcat 4.1 Server.

Assignment Duration 4 months

Project : xxxx

Project Description :This project is to develop a web-based application for Internet fee payment service for Prepaid Card

Industry : Telecommunications

Project Team Size : 2

Role(s) : Developer

Skill Set Utilized : Servlet, JSP, Javascript, Visual Age, Websphere, Oracle, PL/SQL Developer, Microsoft Windows 2000

Responsibilities :

  • Analyze and design project.
  • Design and building database on Oracle 8.1.7 with PL/SQL Developer tool.
  • Develop using Visual Age Tools.

Assignment Duration 2 months

Project : xxxx

Project Description :This project is to develop a PC application to support a training management system for internal use.

Industry : Education

Project Team Size : 2

Role(s) : Developer

Skill Set Utilized : Delphi, Oracle, PL/SQL Developer, Oracle Designer, Borland Report Builder, Microsoft Windows 2000

Responsibilities :

  • Analyze and design project.
  • Design and building database on Oracle 8.1.7 with PL/SQL Developer tool.
  • Develop using Delphi language.

Assignment Duration 8 months