Project Coordinator Resume Hercules, CA - Hire IT People

SUMMARY

Highly organized data analyst and project coordinator, with three years of experience in developing dashboard visualizations for department level teams based on business enterprise data.
Recognized for achievements in validation and correction of ETL interface data tables in Azure, SAP and SalesForce.
Creative and insightful dashboard report architecture skills, proficient in use of DAX, SQL and R.
Proven ability to multi - task, to exert time management and to meet deadlines, with excellent verbal and written communication skills.
Designer of visually engaging and insightful dashboard visualizations encompassing scope of corporate visual identity and team goals.

TECHNICAL SKILLS

MS Azure
MS Access
Data ETL
SalesForce (SFDC)
SAP and Business Objects
MS Excel
Macros
Pivot Tables
VLOOKUP
Power BI Analytics Dashboards
DAX
SQL
R
Safety
Ergonomics

PROFESSIONAL EXPERIENCE

Project Coordinator

Confidential, Hercules, CA

Responsibilities:

Maintained local databases in Access for data tables not available in Azure cloud, and created SQL queries to combine data from multiple sources into interactive Power BI dashboards.
Compare SFDC service contract revenue to work order costs by product line, and ranked products by contract profit margin and new opportunities. Utilized SQL queries and R to customize visuals.
Built interactive Net Promoter Score (NPS) Power BI dashboard, allowing additional feedback correspondence and details to enrich survey data. Utilized Pareto charts, rolling NPS score trends and advanced drill-down. Actionable data improved customer experience and internal processes.
Audited SAP data for high-volume customer accounts for Accounts Receivable team, and identified extraction errors in the data warehouse for pricing, tax, shipping, over crediting and cash-application. Provided updated relationship diagrams to IT staff, and worklists for manual correction.
Supported Sales and Marketing group’s end-of-quarter push by providing custom Excel reports (VLOOKUP) clarifying the instrument installation end-to-end workflow, unifying multiple data sources in Google Sheets, Excel and Power BI to close sales and recognize revenue.
Audited customer account data tables after SAP deployment, tracking and correcting customer data load variances and invoice output settings via correspondence with account holders. This restored invoicing through various sales channels, supported collections, and increased revenue.
Built interactive Power BI dashboards for Service Logistics team to rectify SalesForce and SAP data extraction and transformation incongruities, thus improving flow of instruments, loaner administration and repair parts tracking to and from the service warehouse.

Chemist II

Confidential, Hayward, CA

Responsibilities:

Coordinated document revision project and acted as point-of-contact for QC, QA, research and compliance teams. Created Excel database of project milestones and created monthly progress reports for management teams.
Led purchasing and implementation of efficiency equipment such as sample bar code label system, page counters and labelers, ergonomic solutions and software.
Designed Excel data templates using advanced formulas, VLOOKUP, and pivot tables to harmonize chemical analysis result calculations for release and stability of extensive finished products portfolio.
Formed QC lab safety committee, performed independent safety audits and improved safety.

Senior Research Associate

Confidential, Walnut Creek, CA

Responsibilities:

Monitored end-to-end workflow of genetic samples submitted for sequencing and corrected data entry errors and process maps as issues arose.
Collaborated with Project Management Office and IT engineering team to implement complex database solutions while maintaining lab workflow.

Associate Scientist II

Confidential, Vacaville, CA

Responsibilities:

Coordinated extensive sample distribution schedule to work centers.
Created Excel database linked to OneNote dashboards to track key project sample lifecycles, and alert project teams to out-of-scope sample issues.
Drafted SOPs, reports and Certificates of Analysis related to lab project needs.

Validation Engineer

Confidential, Emeryville, CA

Responsibilities:

Maintained detailed formulation development databases in Excel, tracking formulation variances and linking performance to key formulation components.
Designed and maintained Excel templates for formulation design and stability data trending.
Designed monthly progress report dashboards for external partners using Excel and PowerPoint.
Oversaw internal documentation audits for FDA Pre-Approval Inspections (PAI).

We provide IT Staff Augmentation Services!

Project Coordinator Resume

Hercules, CA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship