Data Visual Basic
Resume:
TARGET: Access/VBA Developer.
SUMMARY:
I have 15 years experience developing, administering, managing and
maintaining client applications at various levels and positions in Fortune
Utilizing:
. (VBA) Visual basic for Applications, Microsoft Access and MS SQL Server
2000 databases with Microsoft Access forms, reports, queries and tools
and MS PowerPoint for presentations and MS Excel.
. Utilized ODBC interface connectivity to back end Microsoft SQL Servers
and Oracle Server systems databases.
. Performed extensive Oracle and MS SQL data amalgamation creating complex
queries for reporting and the front end Client/Server application.
. SQL Server Databases development and administration.
. Developed a commissions application for more than one hundred and fifty
telecommunications sales agents and field operators in Microsoft Access
using Visual Basic.
. Managed and maintained a small office network on Windows 2000 Adv and
2003 Servers network systems with remote connection on a VPN(Virtual
Private Network) utilizing PC Anywhere and VNC(Virtual Network
Connector).
. Implemented detailed procedures and maintained daily application
functionality, assisted with requirement documents creation and adhoc
reporting, created detailed installation and configuration procedural
user and operational manuals, and help files.
. Acted as a resource to integration and system level testing and role-out.
. I am seeking a challenging position with personal growth and development
and this position is a perfect fit.
. In this current position at DentaQuest I maintain and ensure successful
daily and monthly financial data transfers from DantaQuest to Bank of
America, billing data to Cathedral for claims invoicing for dental
medical providers, I Create ftp windows scripts and maintain the the
company intranet updates.
. I have strong Data Analyst, and Applications Specialist skills,
Information Management, Programming, Software Design, Development,
Implementation and Reporting.
. I am a fast learner with tangible results and thrive very quickly in new
uncharted business opportunities.
PROFESSIONAL WORK EXPERIENCE
DentaQuest, Boston, MA - Full time Permanent Position Jun 2007 - Present
IT Technical Consultant - Applications Management, Creation and Development
Responsibilities:
. I Develop, Manage, Create Applications and Reports, Perform Data
Analysis, and Maintain MS Access, Excel and other in-house applications,
testing, and implementation and data connectivity using ODBC to SQL
servers.
. Project management, design, automation, and solution development of
various applications, including integrating existing user-developed
Access databases into MS SQL and Oracle servers, Excel reporting, back-
end and modifying front-end screens.
. I analyze business models, logical specifications, and user requirements,
design and test solutions for application environment.
. I provide Windows scripting of data transfers on company's ftp severs
using PGP encryption technology for HIPAA and SOX Regulations compliance.
. I administrator the NetSuite CRM system and Quest Analytics external
vendor applications used by the company.
. Provide general applications technical decision and support
ONPROCESS TECHNOLOGY, Ashland, MA - Contract Position Jan 2006 - May
2007
Applications Management, Creation and Development
Responsibilities:
. Developed, Managed, Created Client/Server Applications and Reports,
Performed Data Analysis, and Maintained MS Access, SQL Sever, Excel and
other in-house applications, tested, and implemented the solutions.
. Supported Program Managers in developing applications, creating business
rules for their departments, managed applications building, testing, and
maintenance, reporting utilizing MS Access, MS Excel, PDF and MS PPT for
Presentations, and applications life cycles.
. Assisted with data extracts, report creation and programming, and direct
customer data spec interpretations and warehousing.
. I was actively involved in applications development with MS ASP, MS
FrontPage and MS Access pages.
COMMEX COMMUNICATIONS INC., Andover MA - Contract Position Jan 2001 -
July 2005
Telecommunications Billing, Senior Software Developer, Data Analyst and
Reporting
Responsibilities:
. I performed extensive data analysis, reporting and data building.
. I captured data from the telephone careers data warehouses on their web
portals from their enterprise resource systems via internet interfacing
into MS Access and SQL specified tables, built and defined primary,
foreign keys and indexes.
. I mapped and modeled the data to existing customers' data for data
normalization and integration.
. I built and technically documented a telecommunications billing system
with call rating based on:
o CCMI - Local calls (Verizon)
o BillSoft - Federal, State, City and County Taxes
o Global Crossing - Long Distance Toll Calls
o Sprint - Long Distance Toll Calls
o OneStar - Long Distance Toll Calls
. I prepared user manuals for training in MS Word with imbedded screen
shots.
. I utilized MS PowerPoint for training purposes and analytical reporting
on a weekly status report presented to the business each week.
. I prepared small adhoc MS PowerPoint projects for sales agents for their
prospecting customers in the field.
AGILENT TECHNOLOGIES, HEALTHCARE SERVICES GROUP (HSG) NOW PHILLIPS MEDICAL,
Andover, MA - Contract Position Feb 2000 - Apr 2001
Software Development/Business Decision Support/Adhoc Reporting
Responsibilities:
. I designed and developed reporting Applications for the Supply Chain
Development Group using Visual Basic for Applications.
. I used MS FrontPage for intranet HTML web pages distributing Enterprise
Resource Planning Data.
. I retrieved SAP R/3 4.0 ERP/MRP data extracts, analysis and reporting.
. I extended my team work experience to the Business, Oracle Group and the
ISY Group.
. I provided in-house adhoc reporting support.
. Environment: MS FrontPage, MS Access, MS Excel, Visual Basic, BRIO QUERY
for the AS400, Oracle Forms, MS SQL, Windows NT, MS Office Suit, ODBC,
SAP R/3 Enterprise and Manufacturing Resource Planning Tools.
FIDELITY INVESTMENTS, One Federal St., Boston, MA - Contract Position
July 1996 - Dec 1999
Software Developer/Business Decision Support/Adhoc Reporting
Responsibilities:
. Developed a TechTrack Reporting Application using Visual Basic for
Application forms, reports, queries and Excel data exports on a Sybase
back-end repository database. The Fidelity Systems Enterprise Data
Hardware Housing System.
. The reporting tool was accessed via an Active Sever Page(ASP) on the
company's intranet.
. Assisted in adhoc reporting both on Unix and Windows Network Systems
Schematic layout and software installs.
. Extended software development support to other developers and staff.
. Maintained and analyzed data in MS SQL and Sybase Databases for reporting
purposes.
. Prepared and produced application's documentation and activity analysis.
. Maintained the project time reporting on Time Management Software.
. Attended several Microsoft developers' seminars for 1999 on using
Microsoft software development tools.
. A member of Microsoft Developers Group.
. Environment: Visual InterDev Development tools, RoboHTML for help files,
MS Access, MS Excel, Visual Basic, Seagate Crystal Reports, Sybase, MS
SQL, Windows NT, UNIX, MS Office Suit, ODBC.
BLUECROSS BLUESHIELD, Hingham, MA - Contract Position Mar 1996 - May
1996
Programmer/Analyst
Responsibilities:
. Designed, developed and implemented The Extract Application that tracked,
documented, reported and managed healthcare data.
. Re-designed and enhanced the Limiting Charge and The Internal Maintenance
Databases using MS Access.
. Built and stored backup files using Visual Basic 4.0.
. Provided in-house help-desk technical software support to users on a
NOVELL Network system.
. Prepared and compiled training manuals for end-users and provided in-
house training.
. Produced application's technical documentation and analysis.
WHITTIER REHABILITATION HOSPITAL, Haverhill, MA - Fulltime Permanent
Position Feb 1995 - Mar 1996
Database Management and Data collection
Responsibilities:
. Exceptional complements on development and implementation of The
Pulmonary Clinical, The Outpatient Outcome, The Clinical Human Resource
Inventory and The Functional Independence Measure-Follow-up Databases,
using MS Access and MS Excel.
. Built and stored backup files Visual Basic 3.0.
. Maintained The Uniform Data Systems and The Brief System Inventory
Databases.
. Generated charts, reports, forms and presentations using MS Access, MS
Word and MS PowerPoint.
. Provided in-house help-desk technical software support to users.
. Fully maintained the DOS and Windows95 operating systems on hospital
PC's.
. Worked on the CPSI UNIX platform.
. Wrote and compiled training manuals for end-users and provided in-house
training.
. Produced application's documentation and analysis.
EDUCATION
SOUTHERN NEW HAMPSHIRE UNIVERSITY SCHOOL OF BUSINESS, Manchester, NH
Mar 2008 - Jan 2010
MBA - Master of Business Administration Degree, Finance Graduate
Certificate
GPA 3.64 out of 4
SOUTHERN NEW HAMPSHIRE UNIVERSITY SCHOOL OF BUSINESS, Manchester, NH
Oct 2005 - Mar 2008
Bachelor of Science, Technical Management Degree
GPA 3.73 out of 4
. Member of National Honor Society Association and President's List
Recipient
. Certified Member of Gammer Nu Chapter, Delta Mu Delta International Honor
Society in Business Administration.
. Member of Granite State Chapter of Certified Fraud Examiners, New
Hampshire, US.
BUNKER HILL COMMUNITY COLLEGE, Boston MA 1991 - 1992
Associate Degree in Electronics Technology
THOMSON EDUCATION DIRECT-NATIONAL EDUCATION CORPORATION, Scranton, PA
Sept 1993 - Feb 1995
Two Programming Diplomas: Master Computer Programming (Diploma), Computer
Programming (Diploma)
LANGUAGES
. Microsoft Visual Basic for Applications (MS Access/ MS Excel), Microsoft
Access Database Development, Microsoft SQL Server Database Development
and Maintenance, ABAP Programming 4.6, C, HTML and ASP.Net and Java.
REFERENCES:
Furnished upon request.
Contact this candidate