SUMMARY:

• Advanced MS Excel / VBA Developer
• Power BI
• Data Analysis
• Expertise in information management and technology
• Extensive experience with SDLC as it pertains to Quality Control (QC) systems and software in a CFR21 Part 11 regulated environment
• Experienced in creation of software development groups and the development, implementation, and enhancement of enterprise computer applications in both research and validated environments

TECHNICAL SKILLS:

Technology and Tools: Excel / VBA (Visual Basic for Applications) expert level ability) Laboratory Management Information Systems (LIMS) for QC data management Project Management Additional Programming: Visual Basic 6.0, Access, Oracle PL/SQL, T - SQL, UNIX Shell programming, PASCAL, LIL (Laboratory Interface Language)

PROFESSIONAL EXPERIENCE:

Confidential

Data analyst

Responsibilities:

• Create routine and ad hoc analysis and reports for internal and external clients and funders using Power BI, Excel, SQL Server SSRS and SQL Server SSAS.
• Creation of Power BI dashboards
• Automate data preparation / presentation using Excel VBA
• Streamline quarterly presentation of data to US Office of Special Programs (OSEP)
• Code various SQL reports in support of Top 40 report development for (OSEP), and tracking Confidential Special Collections

Confidential

Responsibilities:

• Develop and support an Excel / VBA application to manage donation records and report on donation data for a non-profit organization (completed).
• Provide instructions on computer basics to non-technical users
• Provide MS Excel and MS Word tutoring

Confidential

Responsibilities:

• Support data migration from one HR system (Brass Ring) to another

  (Employee Central / Success Factors) by developing extensive Excel / VBA code to transform and format data for upload

Confidential

Responsibilities:

• Create several Excel / VBA applications for Confidential Global resource allocation procurement process improvement, IMD risk management, etc.
• Build what if capabilities for resource allocation Excel application

Confidential

Responsibilities:

• Assist data analysis by developing Excel / VBA applications to allow analysts to visualize analysis results (graphically) and apply what if analysis of user selected data

Confidential

Responsibilities:

• Supporting research laboratory activities by developing Excel / VBA applications to allow scientists to apply standard screening algorithms to assay results
• Develop Excel / Access application to track biological samples
• Integration of R statistical programming language with Excel

Confidential

Responsibilities:

• Developed Excel / VBA interface to help pricing managers generate pricing sheets for online ads (similar to work at Microsoft below).

Confidential

Responsibilities:

• Development of Excel / VBA application to determine online ad pricing.

  Used internationally by Microsoft pricing managers

Confidential

Responsibilities:

• Project Management for implementation of enhancements of

  LabVantage Sapphire LIMS to improve laboratory efficiency

• Coded various Excel / VBA macros to analyze QC data

University of California

Confidential

Responsibilities:

• Taught Advanced Excel VBA automation

Confidential

Responsibilities:

• Coded hyperlink remediation macro in Excel using VBA in preparation for data migration
• Confidential Inc Consulted on LIMS selection. Coded Excel VBA to examine parse and format data from several thousand Excel files

Confidential, Foster City, CA

Manager

Responsibilities:

• Managed implementation of Thermo-Fisher Nautilus LIMS
• Support for existing LIMS including configuration, custom coding (Excel / VBA, SQL).
• Created custom applications in Excel / VBA to improve laboratory work flow efficiency tissue sample consolidation, etc.

Confidential, South San Francisco, CA

Consultant

Responsibilities:

• Project management and documentation of MCS / POMS interface, Delta V labeling and related drug manufacturing projects at newly acquired manufacturing site (Oceanside). Custom system enhancements to integrate the new manufacturing site into Confidential ’s work flow

Confidential, South San Francisco, CA

Consultant

Responsibilities:

• Maintain Thermo Nautilus LIMS
• Coded Excel / VBA application to prepare reports from multiple Excel workbooks

Confidential, South San Francisco, CA

Consultant

Responsibilities:

• Business analysis, design and development of custom enhancements for a CFR21 Part 11 FDA compliant Laboratory Information Management System (LIMS). Creation of QC documents.
• Consulted on development of FDA compliant custom drug stability QC LIMS application requiring adherence to FDA application development guidelines

Confidential, Fremont, CA

Senior Manager of Information Systems

Responsibilities:

• Facilitated data capture and analysis from multiple instrument platforms using VB 6.0 and Excel / VBA
• Automated the capture and consolidation of data associated with high throughput screening and characterization of hybridoma cells lines for over 100 target antigens

Confidential, South San Francisco, CA

Senior Manager

Responsibilities:

• Coordinated Beckman contractor and internal Confidential IT personnel to migrate Beckman LIMS QC data from non-Y2K compliant version to compliant version. Documented and performed validation testing for the project
• Managed software development groups responsible for corporate document management (NovaManage), laboratory information management (Beckman LIMS) system (supporting manufacturing QC), and middleware (BEA TUXEDO) as well as project management of system enhancements
• Streamlined FDA-mandated yearly trending analysis of approximately 1000 QC assays using Excel / VBA

Confidential

Senior Systems Analyst

Responsibilities:

• Extended the functionality of Beckman QC LIMS with business analysis and coding of approximately 10 LIL applications for improved laboratory and management activities.
• Increased the flexibility of LIMS’ GUI interface by preparing Visual Basic 5.0 applications to facilitate access to laboratory data.