• Designed a data workbook which combined logistics and allocations for physical product orders over $1M. The formula-centric workbook creates csv files for import into NetSuite and verifies the accuracy of the orders created in NetSuite.• Enabled management to quickly view textbook depository sales and inventory data by converting the raw data files provided by the book depositories into actionable Excel / Google sheets workbooks. The workbooks provided daily views into Amplify’s ~$75M yearly sales transacted through state book depositories instead of relying on quarterly summaries. • Collaborated with piers and provided solutions for cases when customers provided allocation details requiring heavy text manipulations to quickly transform the data into formats required by Amplify processes

Continued support of the American Museum of Natural History's children and youth education program data needs.

Supporting the data management needs of the American Museum of Natural History’s children and youth education programs. Requests are completed with a high level of precision, tested, and well documented. Solutions are provided – not excuses!• Automated the data entry of student information by creating a Visual Basic macro within Microsoft Excel. The program cleanses and standardizes the information before executing the appropriate SQL commands against an Access database. The resulting automation reduced data entry time for ~2,600 students from 8 - 9 weeks by multiple museum volunteers to 1 - 2 days by one person.• Collaborated with different stakeholders in Education to determine their procedural pain points. The created programs and processes addressed their issues by automating the reconciliation of class rosters with registration and payment details. The programming decreased the reconciliation time from hours to minutes. The new processes also helped the receivables process by quickly identifying missing payments and enabled faster creation of program metrics. • Introduced data integrity and cleanliness into systems where duplicate students, households, schools, and application details were common. The data integrity is maintained largely by the well thought out logic incorporated in the data entry macros.• Improved the customer’s form completion experience by choosing Qualtrics question elements that work well on both mobile and desktop devices. Template literals were frequently employed throughout the forms to personalized the customer’s question and the readability of the form was enhanced by utilizing CSS to format the appearance of text.

• Prioritized active user requirements for Zebra’s firmware over the air (FOTA) update service.• Performed user acceptance testing for the first release of Zebra’s refreshed asset visibility dashboard.

Data Steward for Cisco’s +$10B Services Portfolio Catalog which improved ease of ordering by presenting Cisco’s 200 fixed-priced service offers and 130 solutions in a simple, smart, and relevant structure. • Assembled SQL queries for service bookings and revenue reports. Created Visual Basic macros which not only cleansed over 1M data points but also created pivot tables for further manual refinement. Crisp visualizations were created that helped the team easily determine areas of opportunities within services based on booking growth trends.• Automated data processing steps that validated and created unique multi-element data uploads for various tools. The automation made it possible to add HTML formatting and system linkages to the data in seconds instead of waiting months for programmatic implementation.

Project Manager (contract position) for Cisco's Portfolio Transformation team• Created business requirements and user interface mock-ups for a new configurable service type. The new service type reduced Request for Proposal response time by 80% and saved $250K in operational costs during the first year of use because major parts of the service were configurable and the new type leveraged pre-approved milestone-based deliverables.• Facilitated software testing and provided detailed communication of issues found with recommendations for fixes.• Eliminated technical debt by identifying under-performing service SKUs that required decommissioning. • Performed release integration testing and created web-based release notes and training guides.

Provider of Photography and Digital Technician services.Operate on-set digital photography capture systems, create workflows, and provide training for digital capture systems.Consultant for photographers and photography studios in areas of system backups, color management, workflow optimization, and digital asset management.

Responsible for all computing equipment and digital cameras on a professional photography set. Ensured a smooth workflow and resolved any technical issues. • Automated common digital technician on-set tasks such as printing, backups, and camera raw file crosschecks with AppleScript. The automation reduced the amount of time required to wrap up computing at the end of a photo shoot. • Created training guides for cameras, printing, monitor profiling & calibrating, and capture software session setup. • Document the client's job by providing reports of all files released to the client (either on printed media, CD/DVD/email), all necessary client contacts, exact processing specifications, and any issues that occurred on set.

• Architected and programmed a web-based reporting system for the performance data collected by NetIQ monitors running on over 1,200 Windows servers. Project met deadlines even after budget and staff reductions. • Provided programming and administrative support for a large NetIQ monitoring infrastructure of over 1,200 Windows-based servers.

Gathered business requirements, developed and tested business-critical mainframe software written with PL/I + DB2 databases.• Designed and created programs that provisioned the necessary login IDs to corporate computing systems for new hires. The changes to the on-boarding process required coordination with Human Resources and finance teams. The new process provisioned ids for new hires by 12:00 pm on the day the new hire started. Previously, a new hire had to wait over a week for access to email, desktop, and mainframe applications. • Created and drove detailed project requirements and daily operations plans for two business-critical mainframe systems, DB2 databases, and Sun connectivity servers running DB2 Connect. • Actively participated in all aspects of the development lifecycle of a web-based application.• Often unified the team by successfully presenting a compromising position when differing approaches were presented.