Resume

Sign in

Data Visual Basic

Location:
3079, United States
Posted:
May 27, 2010

Contact this candidate
Sponsored by:
TalentDesk
Post Jobs to
Multiple Job Boards &
Get more Candidates
Try it Free!
Start your 30-day
Free Trial

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