Mary Varney Email and Phone Number

• Utilized customer portals, external secure platforms, and data mining tools to obtain highly sensitive customer data for use in engineering and programming. Received clearance from the U.S. government and high-profile customers to access program data through identity proofing and monitoring which allowed seamless and secure data transfers. • Analyzed customer models using K-Compare Revision software to create and present 3D change reports to engineering. Reports illustrated model revision changes reducing engineering hours and prevented programming errors. • Converted native customer 3D models using Creo, Catia, SolidWorks, and NX. Utilized K-Compare Validate software to ensure geometric data accuracy was maintained during model translation.• Sole user of K-Compare software suite and self-trained on new releases.• Managed the engineering database using Teamcenter and proprietary engineering data management programs to store sensitive customer drawings, 3D models, and industry specifications ensuring data accuracy and reliability. • Worked with Quoting and Program Management teams to create ad-hoc purchasing history, inventory control reports and delivery metrics utilizing IFS to aid in revenue planning and factory load scheduling. • Teamed with IT department to test new IFS releases and edit user operation manuals before general release guarding against production downtime and educated users on release changes. • Performed yearly self-audit tests confirming IFS best practices are being utilized within program management and in accordance with ISO compliance and introduced changes to processes as necessary.

• Collaborated with Demand Management team to develop and write new reports during transition from Oracle to SAP using Business Objects and Business Intelligence suite. New reports reduced data processing time and increased accuracy. • Coordinated with functional leads and business users to ensure data models/reports aligned with the global template and met approved local business requirements.• Created change request management tickets (ChaRM) to manage user report requests from development/design to testing to production release. Worked with requester to schedule testing, integrate design changes, and ensure seamless reporting transition.

• Monitored Oracle database for data discrepancies and provided demand managers with daily exception reports and monthly performance metrics aiding in factory efficiency, improving inventory management, and order fulfillment rates.• Teamed with Demand Management and Customer Care to manage product allocations and order expedites during a worldwide Tungsten shortage, alleviating customer anxieties.• Standardized and documented all database administration processes and procedures improving data quality and accuracy. • Maintained the Oracle forecasting database through early morning daily file imports and exports allowing efficient demand management day-to-day operations. Collaborated with IT to identify and correct data inaccuracies.

• Prepared weekly and monthly sales reports for sales force and client base using Microsoft Office programs aiding in new business generation, increased sales volume, and client cost savings. • Collaborated with new and existing customers to create online reports using company web portal allowing real-time access to sales, account, and order data. Teamed with IT to train end-users and maintain access.

• Created and maintained multiple, specialized billing platforms for a dedicated customer that streamlined monthly invoicing. Platforms used Microsoft Access, Excel and FileMaker Pro that exported into customer’s proprietary systems. Eliminated paper invoicing, increased staff productivity, and improved customer satisfaction. • Produced contract compliant monthly vendor report through research, audit, and analysis of multiple databases aiding management decision making regarding financial planning, forecasting, and customer spending.• Assisted the technical support team by providing database and connectivity support to the account including management of routine back-ups of pertinent systems and supported peers and management with software/hardware questions to improve productivity.