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.

• 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.

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.

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.

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.
• Provide customer service support by handling customer orders, inquiries, and complaints; being recognized for building excellent customer relationships.

Education record

Information Technology