PROFESSIONAL SUMMARY
Senior level Business Analyst with over 20 years business and information technology experience.  Experience with the full systems development lifecycle including management, creation and analysis of functional and technical specifications, design, analysis, uses cases, testing and documentation, utilizing standard SDLC methodology.  Excellent oral and written communication skills, backed up by strong technical skills.  Experienced in diverse industries with a heavy focus in the pharmaceutical and medical products area.  Takes pride interacting with all stakeholders - executives, managers, administrative personnel, end users, contract developers, and other IT professionals to deliver mission-critical projects on time and within budget.

Project Management                 
Adobe Acrobat fillable electronic forms
Business Analysis                    
Automated Form Processing
DBA-MS Access
Workflow Automation
Software Integration 
CRM systems

TECHNICAL SKILLS

Microsoft ACCESS, MS SharePoint, MS EXCEL VBA, Adobe Acrobat, Adobe Livecycle, MS Project, SQL Server, Crystal Reports 8.0 & 8.5,  FrontPage, Brio,  MS Word VBA, MS Outlook VBA, Visual Basic, Visio, VB.net, Windows XP, HTML, Javascript, ORACLE, COM, VB Script

REPORTING TOOLS

• MS ACCESS (up to Access 2010 with SharePoint)
• MS Excel, Word, Visio, MS Project
• Data Transformation/ETL
• BRIO
• Business Objects
• Crystal Reports
• Programming languages, especially various “flavors” of Basic, up to and including VB.net

INFORMATION SOURCES FOR REPORTING

• MS ACCESS databases
• SQL Server
• Oracle
• XML files
• SharePoint lists
• XLS and CSV files
• Application data, such as MS Project and MS Outlook
• Flat files

EDUCATION
MBA & BA in Computer Science

CLUBS
Toastmasters International

PROFESSIONAL EXPERIENCE

Olympus USA November 2010-Present  
Business Analyst

• Performed business analysis, design, programming, and documentation services for internal clients of Olympus Medical Systems Group.
• Conducted business analysis (JAD) sessions and process flow reviews with users.  Worked with stakeholders to design functional requirement specification (FRS) design documents-
• Full life-cycle application development experience – experienced in working with management and end users to gather reporting requirements, document requirements, design, write test scenarios, and develop/test/deploy reports to the production environment.
• Provided insight and analytics (especially graphing and exception reporting) on demand
• Coordinated with team members and end users to provide smooth change management
• Facilitated and managed requirements gathering meetings, preparing agendas and materials, as well as providing presentation documentation
• Implemented numerous automated data collection systems utilizing MS ACCESS and Excel.
• Worked with team members to implement quality assurance plans and testing
• Initiated internal TekSems (technical seminars) designed to facilitate sharing of employee knowledge base and reduce siloing.

Consulting Business Analyst August 2008 – November 2010  

• Transitioned major hospitality/entertainment organization to CRM software and
  methodology, providing documentation and training.  Targeted MS Access, SharePoint, PHP.
• Conducted business analysis sessions and process flow reviews with users.  Worked with stakeholders to design functional requirement specification (FRS) design documents, use cases, flow scenarios, simulations with widgets and templates, and visualizations.
• Implemented numerous automated data collection systems utilizing MS ACCESS, SharePoint, Outlook, and Adobe Acrobat fillable electronic forms for reporting and analytics.
• Development experience includes setting up extremely flexible report parameter specification options that allow users to specify the parameters in “Query by Example” forms.  In addition to limiting the records selected, these forms have also allowed the user to specify the fields to be reported.
• Provided assistance with UAT (User Acceptance Testing).
• Designed and distributed an assessment questionnaire with true/false, multiple choice, and textual responses for a regional chamber of commerce.  Reported results with multivariate pivot-table and crosstab analysis.  Adobe Acrobat fillable forms and MS Excel 2007.
  

OPT Therapy Services February 2006 – August 2008
Business Analyst

• Database administrator (DBA) and general IT support for therapy practice.  Managed projects to upgrade network services.  Provided on-going business analysis, technical and user support for accounts receivable and accounts payable systems.
• Implemented extensive upgrades to custom invoicing and accounts payable system.

• Acted as project manager, business analyst, developer and DBA to implement automated document/form retrieval system utilizing MS ACCESS.
• System developed was capable of processing and archiving e-mailed time sheets, patient reports, case reports, and other diverse forms. 
• Development experience includes setting up extremely flexible report parameter specification options that allow users to specify the parameters in “Query by Example” forms. 

Confidential July 2007 – February 2008 
Reporting Analyst

• Market research and business reporting analyst.  Using MS ACCESS, BUSINESS OBJECTS, and EXCEL, tracked, analyzed, and reported on sales of Zetia and Vytorin. 
• In addition to standard detail/summary reports, output included interactive pivot tables/charts and PowerPoint presentations.
• Conducted corporate research via multipage assessment documents.
• Extensive experience developing detail and summary reports of all types, including reports that include pivot tables and charts, both static and dynamic.  The dynamic pivot chart/table reports were produced in EXCEL and Business Objects.

Confidential October 2004 – February 2006 
Business Analyst

• DBA and business analyst in Human Resources Data Management, for centralized Human Resources data services and SHPS/SAP Implementation teams.  Project manager, business analyst and designer for productivity tracking system and all associated detail and summary reports.
• Conducted business analysis sessions with managers and administration staff to gather and document business requirements for integrated form submission reporting tool. Designed, developed and implemented integrated form submission reporting tool for the Central Data Services group.  Performed requirements gathering, business analysis, and development of all reports.  Re-engineered associated process flows.
• Experience includes developing reports based on user-entered data parameters and developing the associated data parameter input screens.  The data parameters entered are then used to filter the records from the data sources, utilizing views that I’ve defined in SQL.
• Development experience includes setting up extremely flexible report parameter specification options that allow users to specify the parameters in “Query by Example” forms.  In addition to limiting the records selected, these forms have also allowed the user to specify the fields to be reported.
• Most of the reports developed have been “on-demand” reports, which were generated when requested by users.  I’ve also set up “push” reporting, where reports were delivered to the user as Acrobat or EXCEL files via e-mail on a scheduled basis.  My experience includes setting up the scheduled reports from scratch (with VB coding), as well as using canned report scheduling applications.
• Upgraded dozens of MS ACCESS reports in conversion from legacy Human Resources system (HRIS) to SHPS and SAP-HR. Performed all data-mapping and report testing.
• Responsible for  scheduling systems

Confidential May 2002 – May 2004
Business Analyst / Application Development

• Business analyst / Senior programmer.  Designed and implemented system for automated delivery of scheduled reports to corporate and governmental (DYFS) clients utilizing MS ACCESS. Developed and programmed (VB) all reports using MS ACCESS, MS EXCEL, and ADOBE ACROBAT.  Designed and programmed scheduled report delivery system.

Confidentialn October 2001 – April 2002 
Reporting Analyst

• DBA and reporting analyst for short-term project to prepare data for world-wide corporate helpdesk system. Developed and programmed (VB) all required reports in MS ACCESS, MS EXCEL, and BRIO.

Confidential January 2001 – October 2001
Business Analyst / Programmer

• Chief technical person in charge of defining business requirements and designing, programming (VB), and implementing upgrades to the registration software for the company’s award-winning training department for blood chemistry analysis devices. 

Confidential July 2001 – August 2001 
Business Analyst/Programmer

• Developed a departmental budgeting tool.  Utilized MS ACCESS for data entry and storage, and MS EXCEL for analysis and reporting.

Confidential March 2001 – July 2001 
Business Analyst/Programmer

• Provided business analysis and technical services implementing a production tracking system. Developed all required reports using MS ACCESS.
  

Confidential July 1999 – December 2000  
Project Manager

• Project manager for a mission-critical business process management (BPM) system to handle order provisioning, with automated workflow and document retrieval.  Liasoned with users, conducting business analysis interviews and mapping business process flows. 
• Created use case and functional requirement specification (FRS) documents. 
• Utilized RAD techniques to simultaneously define business requirements and deliver system modules.  Trained end-users in classroom settings.  Created interface to extract data from order entry EXCEL spreadsheets and insert into multiple tables in MS-ACCESS database.

Confidential January 1995 – July 1999 
Business Analyst/Programmer

• As a business analyst, worked closely with senior management and department heads, created a compliance database in MS ACCESS to facilitate FDA/GMP issue resolution and activity tracking for 200 users across seven sites. 
• For a pharmaceutical quality control group, worked with a problem resolution SWAT Team to create a product sampling application using System Development Life Cycle (SDLC) methodology.  In response to FDA demands, system was defined, programmed in MS ACCESS, tested against UATs, documented, and implemented in five weeks.
• For a multinational European-based compliance group, created a database (based on the compliance database above) to facilitate activities to stay in compliance with European regulatory authorities, meeting periodically with team members from Western European countries in London.
• For an internal equipment preparation unit, created a real-time production tracking system and all production reports.  Designed and programmed reports in MS Access and Excel.
• For a human resources group, created a personnel succession planning database.
• For a strike contingency task force, created a personnel survey system, which allowed management personnel to quickly update a skills database via e-mailed MS Word forms. 
  

MicroEndeavors 1994
Consultant

• Developed custom database systems. 
• Trained users in MS ACCESS.  Scripted and narrated MS ACCESS video training tapes.

Confidential 1993
Consultant

• Developed MS ACCESS database system for European casualty insurance operations.

Confidential 1992
Consultant

• Developed database systems for paint additives marketing organization and conducted classroom training in MS ACCESS.

Confidential 1991 
Consultant/Trainer

• Conducted on-site classroom training in MS ACCESS for multiple Delaware Valley corporations.