Jay Bryan Email & Phone Number

• Develop processes and scripts for migrating data from Client’s existing software.• Develop and modify business logic embedded in SQL stored procedure, triggers and functions.• Write scripts to convert and automate data conversions.• Assist in developing strategies for standardizing and consolidating processes.• Plan, coordinate and conduct the analysis of client business processes and functional requirements and the preparation of appropriate documentation to communicate and validate the information.• Assist with the interpretation of user requirements into feasible options, and communicating these back to the business stakeholders.• Monitors and resolves data related support requests from the organization.• Install custom software and setup system variables for product to be run.• Work with over 30 cores to configure data into usable information.

• Buy and sell futures, options and stocks during market hours. Set up wired/wireless network and provide technical support to small business owners and friends when not trading

• Maintain ISO class 8 clean room environments. • Weigh and prepare drugs for inclusion in solutions batches. Check Tallies for drug factor, valid expiration date and lot number. Change quantities to reflect amount of drugs used. • Calculates and records data in official plant documents. Complies with plant rules/FDA regulations pertaining to cGMP, Safety and personnel related matters.• Adjust P.H. of solution including Dextrose, Sodium, Antibiotics using various acids and caustics.• Test water for conductivity, P.H. and oxidation qualities.• Use HMI to regulate temp, pressure of solution to fill bays.• Use database to control inventory for products used to make I.V. bags, Issue and return all products relating to work order BOM.• Use fork truck to move film from warehouse to clean room.

Austin, Texas Area

• Designed access database that would show all shipments on any given day and that allow audits of work orders easier• Designed / maintained excel spreadsheet for work orders, cost effective crates and boxes for shipments that allowed the company to more robust and flexible• Worked with the engineering team on special needs and supported the sales team by assisting with pre-sales activities• Pulled kits for production according to master schedule and stocked and organized offsite warehouse

Austin, Tx

• Position required knowledge of Access database, queries, macros, SQL, ETL tools, and FTP to transfer/receive files.• Performed steps to extract, map, clean, manipulate, convert, and normalize data for database updates.• Applied Automotive Aftermarket guidelines to analyze and properly process data. • Utilized company’s policies and procedures in order to analyze data to create a reliable cost efficient end product.• Utilized appropriate tools and developed solutions as required to meet project objectives.• Provided manager with accurate timelines, processes, project status reports and timesheet daily.• Maintained appropriate communication within the team and perform other duties as assigned by manager.

Austin, Texas Area

• Worked closely with purchasing, engineering, manufacturing, and customers to identify any specific changes in customer requirements in order maximize production. Troubleshoot and resolve any issues in a timely manner.• Reviewed Master Production Schedule daily to establish priorities of specific customer orders.• Coordinated and expedited flow of material, parts, and assemblies according to production and shipping schedules.• Used data collected from various software programs to create Crystal Reports, Access databases and Excel spreadsheets to analyze and trend specific customer usage of inventory for maximum output.• Performed Inventory Cycle Counts, decreasing inventory discrepancies to less than 1% overall annually.• Ensured proper procedures are followed and accurate documentation is prepared for all work orders within each area.• Documented and audited processes of facilities for ISO 9000 Certification.• Assisted in the training of staff on policy and procedures.

Austin, Texas Area

• Provide customer service support to over 60 key accounts generating annual revenues ranging from $10,000 to $10 million per account each year, working closely with clients such as Managers of Operations and Directors of Departments.• Provide customer service support by handling customer orders, inquiries, and complaints; being recognized for building excellent customer relationships.

Education record

Information Technology