"Exceptional ability to deliver information technology solutions in a
complex, high volume environment"
PROFILE
Business Analyst with a track record of diversified information technology
experience with industry leaders in insurance and pharmaceuticals.
Considered an expert in quality assurance, data analysis and application
development with an emphasis on regulatory compliance.
Technology Expertise:
. Application Development
COBOL 390, FOCUS 7.2, IBM 3090 Mainframe, Microfocus, TSO, JCL,
OM/MVS, MS Visual Studio, Visual Basic for Applications (VBA) for
Excel, VB6, VB.NET
. Database
MSSQL Server, T-SQL, Stored procedures, DB2/SQL, MS Access,
Relational Databases, Database Normalization, Data Analysis, POS
(Point of Sale)
. Web Development
Website construction, HTML, JavaScript, ASP.NET, CSS, XML
. Microsoft Office
Excel, Word, Access, Power Point, Visio
Core Competencies:
. Able to perform QA testing with timely and accurate results.
. Able to manage multiple projects and meet critical deadlines.
. Regarded as a self-starter, attentive to detail with a strong work
ethic.
. Key professional for training and mentoring new hires in complex
methods and techniques.
. Ability to author and revise standard operating procedures to comply
with government, industry, and company standards.
. Excelled in varied programming responsibilities requiring systematic
analytical techniques and strong written and verbal skills.
PROFESSIONAL EXPERIENCE AND ACHIEVEMENT
AESCULAP, Center Valley, PA 2010
IMS Database Specialist
Installed, supported and maintained IMS software and databases for internal
and external customers.
. Contributed to the technical support process by assisting and training
internal and external customers in the use of INSTACOUNT software
. Maintained the in-house databases (SQL Server) using stored procedures
and ad hoc queries using SQL scripts and T-SQL stored procedures.
. Provided IT technical support to in-house and remote staff
. Maintained and expanded documentation records and reports for all IT
interactions with internal and external customers
. Maintained and expanded on the troubleshooting database for tracking
customer problems and issues
. Resolved problems regarding INSTACOUNT projects by working with
customers and sales representatives
LEHIGH RUG SERVICE, Allentown, PA 2004 - Present
Information Technology Specialist (Part time)
Managed maintenance of computer system and two customer databases,
responsible for computer network, hardware, writing customer surveys and
collating data for a service-oriented business
. Maintained customer database using Microsoft Access making use of
Database Normalization Techniques to be linked with company website using
VB.NET, SQL and other .NET technologies.
. Developed a client-based application using VB.NET to edit files
downloaded from Quick Books Point of Sales software for uploading to MS
Access Database
HINDLEPOWER, INC., Easton, PA
Programmer/Project Manager (Independent Consultant) 2008 - 2009
. Project manager for development of automated configuration system for
electronic console with unique customization for each client to enable
company to realize cumulative sales of approximately five million
dollars.
. Extensive use of Visual Basic Application (VBA) for Excel
. Consulted with sales team for project specifications assuring accuracy
and timely delivery
. Performed testing of application to assure error free and user-friendly
operation
. Delivered weekly progress reports and system demonstrations to top
management
SDI Health, Plymouth Meeting, PA 2006 -2008
Quality Assurance (QA) and Production Analyst - Market Data Analysis
Produced and quality tested Market Analysis Reports for delivery to major
pharmaceutical corporations
. Created monthly/weekly pharmaceutical market analysis reports to
customers achieving a 100% on-time delivery record
. Developed and performed quality tests on reports using SQL Server 2005,
DTS, Visual Basic for Applications (VBA) scripts and Microsoft Access
Databases for testing data for accuracy and trending
. Managed small team efforts and delegated responsibilities for major
multi-report projects
. Independently managed transition of report production from development
in IT to production
CHUBB INSURANCE, Warren, NJ 2001 - 2005
Programmer
Produced, tested and implemented multi-program applications for the
financial department according to Sarbanes-Oxley requirements
. Created and delivered a mainframe Workers' Compensation System including
software development using COBOL 390 and FOCUS 7.2 on the IBM 3090
Mainframe involving numerous robust modules that included imbedded
DB2/SQL.
> Consulted daily with business customers in development ensuring
requirements were met
> Followed progress through implementation while maintaining existing
parallel system
. Maintained and updated Windstorm System improving data accuracy, lowering
regulatory assessments by tens of thousands of dollars annually.
ORTHO-MCNEIL PHARMACEUTICAL, Raritan, NJ 1982 - 2000
Associate Scientist - Quality Assurance Analyst
Highly skilled analytical chemist performing QA laboratory tests on
consumer and prescription pharmaceutical products
EDUCATION AND TECHNICAL TRAINING
Moravian College
Bachelor of Science, Chemistry with a Mathematics Minor
Chubb Institute
April - November 2000
Vocational Diploma - Computer Programming Honors Program
Microsoft Certified Professional Developer
(.NET Technologies)
Training and Certification
In progress