Melinda Layten

*** ***** ***** ***** ****. • Allentown, PA 18104 • acxtgx@r.postjobfree.com • 484-***-****

Dedicated, versatile professional with the ability to improve business performance by finding the heart of the story that drives performance. From executive dashboards, user stories and marketing decks, the right data can improve any business. Versatile history with multinational corporations and entrepreneurs. Qualifications include advanced education in biology, health care claims and billing databases, training in mathematics and hands-on experience as Programmer/Analyst. Caretaking experience in the oncology and clinical trial world, including the challenges of coordinating between doctors in different systems. Fast learner with knowledge of the agile software development life cycle and high level of technical proficiency.

Areas of emphasis:

•SaaS Application Support

•Large-scale Data Management

•Process & System Analysis

•Data Warehousing

•Executive Reporting and Dashboard

•Process Analysis & Detailed Requirements Gathering

•Documentation, Tracking & Reporting

•Public Speaking

•Database Programming

•User Training

•Creative Problem Solving

Technical Proficiencies:

•Platforms: UNIX, (Linux, SGI, SUSE), Windows (XP, NT, 98, ME, 2000)

•Tools: Workfront(AtTask), Enterprise-One ERP (E1), BPM, Oracle, Microsoft Word, Access, Excel, PowerPoint, Outlook, Perl, Shell Scripting, PL/SQL, Make, C, Java, Visual Basic (VB)

Professional Experience

Layten Analytics, Allentown, PA

Workfront Consultant @ Cisco, 10/2015 to 7/2016

Provided internal support for Workfront reporting and dashboards. Implemented a new Service Level Agreement (SLA) monitoring system within Workfront. Improved internal monitoring systems for internal marketing design teams.

Key Contributions:

•Improved SLA monitoring and Quarterly Business Review processing

•Trained power users on Workfront reporting to enhance user adoption

•Transitioned Quarterly reports from fixed dates to reusable dashboards

•Implemented reporting on reports to improve system maintenance

Synchronoss Technologies, Bethlehem, PA

IT Business Analyst, 2/2014 to 10/2015

Implemented an IT request, workflow and prioritization system in Workfront (AtTask). Became a subject matter expert in reporting, queue and workflow management. Redesigned IT Change Request management queue to improve accountability and reporting. Transitioned numerous operations queues from the poorly functioning CRM system to Workfront. Became an internal consultant in Workfront implementation and invited to speak at the Workfront user convention.

Key Contributions:

•Eliminated single point of contact bottlenecks in global IT request procedures

•Reduced email overload and enabled workflow queues and prioritization

•Designed business group dashboards and reporting to certify the procedures for PCI security

•Performed training for 500 users on new system

•Gained recognition as an expert on Enterprise queues, custom forms and workflow

Lutron Services via Hobbie Personnel, Coopersburg, PA

Scheduling Assistant, 3/2013 to 1/2014

Performed quality assurance on scheduling commercial service visits while refining procedures and developing new reporting tools. Provided rapid prototyping of scheduling tools in Microsoft Access, to enable long term integration with corporate tools in E1. Provided tools to ensure that closest, available, qualified tech is scheduled for each job, while ensuring that full-time techs are scheduled preferentially over per diem contractors.

Key Contributions:

•Brought in-house tech use efficiency from 80% to 95%

•Improved Zip Code Tools and Tech Qualification Procedures to contain travel costs

•Developed new reporting database to better analysis usage and expense patterns on a per job basis

Da Vinci Science Center, Allentown, PA

Educator / Guest Experiences, 9/2009 to 4/2013

Managed front-desk and store operations. Supervised and coordinated volunteers. Prepared reports on center usage for senior staff. Served as knowledgeable liaison responsible for providing insights on science center exhibits to guests. Initially served in volunteer role ('09 to '11) and stepped into paid, part-time position.

Health Market Science, King of Prussia, PA

Programmer Analyst, 12/2009 to 9/2011

Consulted with clients to identify needs, present solutions and coordinate projects that supported daily business operations in the healthcare, insurance and retail pharmacy fields. Extracted and managed large, customized health care provider and claims data sets by loading, matching, cleansing essential data. Streamlined and automated key aspects of data management and warehousing processes. Facilitated training sessions and led workgroups to educate team members and customers/users. Mentored new employees to sustain a productive, team-focused setting.

Key Contributions:

•Expertly performed Extract Transform Load (ETL) responsibilities by developing, loading, matching and cleansing customized data files.

•Developed and delivered custom data deliveries of master file and claims data to key clients in medical and health industries.

•Successfully transformed data (using Perl, Shell Scripting and PL/SQL) and closely monitored ETL load processes to ensure the accuracy and integrity of Oracle databases.

•Skillfully and effectively educated customers/users on projects, processes and systems.

•Collaborated with team members in completing client-centered projects within strict deadlines.

Stony Brook University, Stony Brook, NY

Graduate Teaching Assistant / Graduate Student, 1/2003 to 4/2008

Taught cellular biology, physical chemistry and introductory chemistry laboratory while pursuing advanced education in molecular and cellular biology. Conducted independent research on "Effects of Point Mutations on Protein Folding and Ligand Binding." Performed molecular dynamic protein studies of HIV Protease and Trp-Cage mutants and model systems to determine effect on tertiary structure.

Key Contributions:

•Skillfully organized terabytes of molecular dynamics data, and wrote scripts to transform and evaluate data according to experimental parameters.

•Created productive learning environments for small and large groups (25-50 students) and served as one-on-one mentor when needed.

•Expertly planned and coordinated complex projects including prioritizing goals, managing time and resources, tracking milestones and documenting/publishing results.

Applegate Farms, Branchburg, NJ

Computer Programmer, 6/1999 to 6/2002

Analyzed needs, set priorities and developed original databases to enhance operations for distribution company. Enabled leadership to work remotely while maintaining full, hands-on view of data. Wrote daily operations in Lotus Notes databases with programmatic ties to Mas90 Accounting system. Helped grow the company grow from 20 employees to a leading national supplier.

Maersk Data, Morristown, NJ

System Administrator, 1/1998 to 6/1999

Administered Lotus Notes servers for Maersk Shipping mail and websites. Led national roll out of fax servers to streamline processing of Bill of Ladings. Implemented monitoring of workplace Internet use.

Education

Master of Science (MPhil), Molecular and Cellular Biology

Stony Brook University, Stony Brook, NY

Bachelor of Arts (BA), Natural Sciences and Mathematics ~ 2002

Thomas Edison College, Trenton, NJ

Publications and Presentations: Full list of publications and presentations will be provided on request. Examples - Journal of Chemical Theory and Computation and Journal of the American Chemical Society.

Contact this candidate