Sign in

Developer Information Technology

Paramus, New Jersey, 07652, United States
April 13, 2018

Contact this candidate


RAYMOND HSU, J. D., MBA degree candidate

*** *. ********* *****, *******, New Jersey 07652 d:201-***-****

Linkedin Profile:

Microsoft Excel / Access Database Solution Developer

MS Excel 2013/16 VBA (Expert), MS Access 2013/16 (Expert), Power BI, Power Pivot

IT professional developer with 15 plus years of success devising innovative and tailored automation and database solutions using MS Excel and Access to meet the ever-changing business requirements in the pharmaceutical, insurance and finance industries. Candidate has extensive business training in accounting and finance and is a holder of a J.D. degree.

Project Experiences

Sole Developer of Pharma Science & Technology Financial Analysis Access database app

Celgene – Summit New Jersey Mar2017 to Apr 2018

Sole contributor and developer of a MS Access-based database with split configuration for the finance department to be used by 90 plus scientists and analysts monitoring and forecasting expenses incurred for clinical trials, research expenses and invoices billed by third-party vendors and for generating ad hoc and canned reports comparing the expenses with the forecasts and budgets.

Developer of Technical Star Gate Productivity Checklist Access/Excel Application (3rd Assignment)

PepsiCo – Purchase, New York Mar2016 to Jan 2017

Recommissioned by PepsiCo to continue the development and enhancement of their global Technical Star Gate (“TSG”) Checklist Access/Excel tool for the Productivity component of the company wide implementation of the application.

Access VBA Promotion Planning Tool Developer with Microsoft Access database as the backend (2nd Project)

Pernod Ricard USA- New York, New York Oct 2015 to Feb 2016

Recruited again to continue the development of a global promotion planning tool (“PPT”) (using Excel as the frontend interface and Microsoft Access as the backend database).

Global SmartExcel Access Application Developer (2nd Assignment)

PepsiCo – Valhalla, New York Jun 2015 to Oct 2015

Sole contributor and developer of an Access/Excel VBA application to track and monitor that new products comply with the company policies and departmental protocols in each stage of their development from conception to launching into the markets.

Access/Excel Promotion Planning Tool Developer

Pernod Ricard USA- Purchase, New York Dec 2014 to Jun 2015

Sole code contributor and developer of an Excel VBA application used as a frontend with rich user interface that enables 200 plus users to enter, edit and store promotion campaign spending information and activation tactics, etc. at the sub-brand level for the upcoming fiscal year.

Excel Global Usability Application Developer

PepsiCo – Valhalla, New York Jul 2014 to Dec 2014

Sole contributor and developer of an Excel VBA application to track and monitor that new products comply with the company policies and departmental protocols in each stage of their development from conception to launching into the markets.

Lead Database & Program Developer (a Pfizer project)

Pharmalink Consulting – Short Hills, New Jersey Jun 2013 to Jul 2014

Lead role for the design and development of a database solution with rich graphic user interface to support a team of 25 users in the SharePoint environment to record, track and monitor the various processes and facets of 2000 plus legacy pharmaceutical action notices filed with various health departments across the globe.

Contract Developer on MS Access Database Application with Excel User Interface.

Pfizer Animal Health – Madison, New Jersey Oct 2012 to Apr 2013

Sole Contributor and developer of a pricing model application (“PMA”) using Microsoft Excel 2007 and Access 2007 as its backend in the implementation of a global pricing scheme. The stand-alone Excel pricing and reporting application enables users to retrieve and download past historical sales data in units, gross and net sales volume, gross and net prices and cost-of-goods-sold values.

Independent Consultant on Database Development – Paramus, New Jersey Mar 2011 to Oct 2012

Consulting and participating in the creating, developing of a litigation support application for law firm uses using Microsoft office suites.

Claims / IT Report Supervisor Jan 2002 to Feb 2011

Sompo Japan Insurance Company of America – New York, New York

Supervise, develop and maintain company-wide data analytics and reporting functions for various departments, external insured entities and company upper management use, e.g. loss runs, etc.

Education & Credentials

MCAS (“Microsoft Certified Application Specialist”) October 2017

Candidate for certification exam #77-600

SetFocus IT School – Parsippany, New Jersey Aug 2012 to Oct 2012

Completion of Business Intelligence Master’s program

Programs consisted of the study of T-SQL 2008R2, SSIS, SSAS, SSRS,

MDX & Data Warehousing and more

Dover Business College – Paramus, New Jersey Jun 2000 to Oct 2001

Certificate of Computer Programming & Database Development

Graduate School of Management at Rutgers - Newark, New Jersey Feb 1999 to May 2000

Master of Business Adm. in Finance & Information Technology

MBA Degree candidate

New York Law School – New York, New York Sep 1985 to Feb 1989

J. D. Degree awarded

Rutgers University at Newark- Newark, New Jersey Sep 1983 to May 1985

Bachelor of Arts, Major in Accounting

Contact this candidate