PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Performed required analysis of data provided from internal SQL databases as well as data from CME and other external sources.
• Participated in team and one - on-one meetings with managers in order to obtain information required to build in-house MS Access /VBA applications for process enhancement. Each of these application was accompanied by documentation,, and online User Guides.
• Provided instruction and assistance to junior and intermediate level coworkers.
• Acted as a liaison between contractors, team leads, and management on several projects.
• Used my extensive background and verbal communication skills to provide solutions to enhance existing applications, create new ones, and assist others with the development of their own tools.

Confidential

Responsibilities:

• Reviewed and analyzed an existing PDST databases.
• Normalized databases and tables. Established standards for data formats and naming conventions.
• Interacted with the primary users to identify specific needs and requests of all users.
• Created a prototype of the new Access interface, reviewed the designs with management to receive approval prior to development and release.
• Designed, developed, and coded Access VBA applications using data-driven and table-based queries and combo boxes, dynamic QueryDefs to eliminate the need for repetitive macros, and tab based interfaces to reduce wasted screen space and pop ups.
• Developed an application to calculate the number of clients enrolled in the Multiple Sclerosis drug programs, broken out by level and type.

Confidential

Responsibilities:

• Assess users’ needs, based upon information obtained during meetings, phone calls, and limited documentation
• Analyzed existing manual processes used to reconcile data
• Designed and developed data-driven Reconciliation application to compare InfoLease and PeopleSoft data for consecutive months, and generate Excel spreadsheets, as well as displayed data.
• Designed and wrote user documentation and materials.

Confidential

Responsibilities:

• Met with Senior Management to assess the existing processes
• Assisted in the creation and presentation of a more stable application platform
• Reviewed specifications from primary users and IT contacts
• Designed and created an Access-based data -entry application using a SQL Server backend database for Purchasing, Sales, and Inventory
• Used SQL and VBA code to extract data from external sources
• Developed dynamic controls for user-specific front-end entry screens
• Used advanced form development techniques and methodology to create customized look-and-feel for the PSI forms.

Confidential

Responsibilities:

• Reviewed and analyzed an existing data processing model
• Learned the needs of the Specialty Pricing department
• Worked with the department manager and users to obtain specs
• Created a prototype of the new Access interface
• Designed, developed, and coded a data-driven, multi-user, secured, relational database application allowing the group to offer a range of prices for pharmaceutical products, based upon category, type, quantity, and supplier.
• Met with application designer to discuss the requirements of the reporting application
• Analyzed and detailed the required tasks.
• Designed and built user interface for mailing campaign list reporting.
• Created VBA based objects for multiselect list boxes, SQL query generation, and User-Defined functions for Fiscal Date management, hidden/viewable objects, and report specific parameters.
• Built reports displaying historical data, grouped by year, category, and volume of business.

Confidential

Responsibilities:

• Assessed condition of existing application and improved design flaws.
• Normalized database. Created functional relationships between tables.
• Replaced multiple redundant macros with VBA code, UDFs and SQL queries.
• Met with user community, management, and developers to determine the need for the creation of new software.
• Designed objects, menus, and architecture for the application.
• Created a real-time, multi-user system, which allows each department to process customer information, transfer loan statuses, and produce reports.

Confidential

Responsibilities:

• Stabilized database by creating consistencies across tables
• Improved table structures by redefining field-level properties
• Created user activity Audit Trail procedure
• Redesigned Reports Module to make it more dynamic
• Redesigned interface, made forms modal, secured data, prevented unacceptable modifications at the data entry level.
• Created User Guide to serve as a and user document

Confidential

• Assignment: Normalize an Access database, develop a Direct Marketing application
• Met with users and management to identify status of existing application, and manage the development of a normalized database
• Created templates of new table structures, imported data from various sources to populate tables
• Wrote Access/VBA queries and modules to process user transactions related to List Management.
• Rewrote forms, created data-driven selection objects, and modified SQL code to reflect new structures and field names.
• Developed a robust, criteria driven, Report Module, allowing the user to request data based upon any of over 1000 variations of selected field values.
• Assignment: Develop an Investment Product Sales Application

Confidential

• Created Access tables and associated forms for user interface.

  Migrated existing Clipper/FoxPro for DOS application into MS Access format.

  Coded and utilized data-driven controls on forms.

  dministered MS Access database for a Visual Basic 5 application.

  Assignment: Develop and maintain Securities Lending and stock market investment programs

• Maintained and converted securities lending application.

  Designed and developed Novell LAN based financial applications.

  Monitored performance of various systems written in a variety of languages including FoxPro, Power Builder, Clipper, and Databus.

  Converted applications from FoxPro (DOS) to FoxPro for Windows and MS Access.