Database Developer/Administrator Resume Honolulu, HI - Hire IT People

SKILL:

RDBMS: MS SQL Server (2014/2012/2008/2005/2000/7.0 ), Oracle (12c/11g/10g), Foxpro, MS Access

Data Warehouse: ETL, SQL Server Integration Service (SSIS)

Design: Data Modeling/ERWin, Object - Oriented Analysis/UML

Report: SQL Server Reporting Service (SSRS), Crystal Report

Language: Visual Basic.Net, Visual Basic, C#, Java, C++/C

Web: IIS, ASP.Net/ASP, VBScript, JavaScript, HTML, CSS,XML

IDE: Business Intelligence Development Studio, Visual Studio.Net

Network: Windows 2012/2008/2003 Server, Internet/Intranet, TCP/IP

OS: Windows 10, Windows 7, Windows XP, Linux/Unix, DOS

Accounting: QuickBook 2011, Payroll Accounting 2011, Tax Report, MAS 200

EXPERIENCE:

Database Developer/Administrator

Confidential, Honolulu, HI

Responsibilities:

Installed, configured and maintained Microsoft SQL Server databases for Vision software.
Vision software is an enterprise application suite managing a large scale retirement community and healthcare organization in Confidential .
It was comprised of several components:
A financial module to handle billing, shipping, and payment of its vendors, residents, and staff.
A healthcare module handles information related to their physician and nursing staff.
The resident model generated reports on demographic profiles, nutritional information, medication services, and clinical data.
Performed Windows and DB administration tasks - e.g. SQL Server database backup, performance monitoring and tuning, and privilege management for corporate headquarters.
Developed ETL scripts (SSIS packages) to load data from application database into reporting database/data warehouse.
Refreshed SQL Server databases from production to development, UAT and training servers on regular basis.
Applied security patches and latest Microsoft Core updates on Windows and SQL Server instances to ensure compliance with cyber security policies.
Analyzed complex SQL queries to ensure optimal retrieval time and CPU savings.
Advised developers and architects on best methods on generating reports from data warehouse or OLAP databases.
Maintained database architecture in data dictionaries, entity relationship documents, database design/requirement documents.
Worked with product manager and scrum master on level of efforts and scope of each ticket.
Designed and developed key modules of Vision application via T-SQL codes, customized stored procedures, triggers, functions and views.
Leveraged SSRS to create customized reports as plug-ins to Vision software.
Used Business Intelligence Development Studio to develop client reports. Setup and configured Microsoft Reporting Services Server to host reports.
Vaccination Report
MealIntake Report (Bronze McKnight Award winner)
Demographics Report
Geriatric Functional Rating Scale(GFRS) Report
Defined XML schemas and implemented XML format to generate data of resident information
Developed and maintained SQL Server ad-hoc queries running on regular base
Provided user support for PC, Mac, Printer and Office software.

Computer Administrator

Confidential, Honolulu, HI

Responsibilities:

Maintained all corporate(Windows/Mac) computers were operational.
Work with technical team on debugging and fixing service desk issues.
Help with the accounting team on their day-to-day task and audit support.

Computer Lab Maintenance

Confidential, Honolulu, HI

Responsibilities:

Responsible for maintaining Windows XP computer lab for students and facility.
Supported user inquires and resolved issues from professors and students.
Performed system maintenance and applied security patches to all computers on the network.

Software Engineer

Confidential

Responsibilities:

Web application used to manage service desk entries for the company. It employed IIS 5.0 on Windows 2000 Server, SQL Server 7.0and Microsoft Transaction server (MTS).
Performed requirement analysis, database design, and development. Responsible for the Visual Basic 6.0 codes of both client and server components and ASP/HTML codes.
Web application used to keep track software, licenses, servers, and client, etc. Integrated with the SAP ERP system. It employed IIS 5.0 on Windows 2000 Server, SQL Server 7.0 and Microsoft Transaction server (MTS).
Developed ASP/HTML code to provide a rich and fast front-end for users.
Peer reviewed the code of fellow developers.
Client/Server application based on MS SQL Server 7.0, Visual Basic 6.0 and VBA. This application also used ADO, RDO, Crystal Report 7.0 and True DBGrid.
Maintained and enhanced back end SQL Server stored procedures and triggers.
Client/Server application used to manage the materials for producing cement. It was based on MS SQL Server 7.0, Visual Basic 6.0 and VBA. It also used ADO, RDO, Crystal Report 7.0 and True DBGrid.

Senior Programmer

Confidential

Responsibilities:

Maintained company’s payroll system.
Ensured all employee data, rate information, vacation/PTO, retirement funds, taxes are calculated correctly.
Generated management and accounting reports for C-level review.

We provide IT Staff Augmentation Services!

Database Developer/administrator Resume

Honolulu, HI

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship