Jose Cerna Email & Phone Number

Houston, Tx, Us

Houston, Tx, Us

• Work independently or as part of a team to design and develop analytics/reporting solutions using Tableau and Excel.• Gather requirements to design and build templates to ensure the development of applications are meeting business goals.• Present and communicate the findings in an understandable and actionable way tailored to the audience and stakeholder’s needs. • Exercise data quality, normalization, integrity, validation, system integration and data model sustainability/usability. • Prepared and reviewed reports for all concerned parties

Houston, Texas, Us

As a Business Analyst, I interpret data and visualize it by:-Translating business processes, requirements and use cases to dashboards and visualizations by creating Power BI dashboards and Tableau. -Utilizing SQL to execute queries, joins, grouping, and views. -Exercise data quality, normalization, integrity, validation, system integration and data model sustainability/usability. -Applying advanced Excel skills through pivot tables, database creation and maintenance.-Other technological skills of note: Microsoft Teams, Microsoft Flows, Salesforce, Java, Javascript, HTML, XML, Network layers and protocols, and Project Management.

Assist and help customers, delivering a fulfilling customer experience. Decreased 20% of the man hours needed to receive and stock bakery inventory, by utilizing a structured receiving method. Cut-down inventory cost by 12%, by completing weekly inventory checks while forecasting needed inventory for future orders. Ensured highest Operational Readiness rating in 10+ years due to maintenance in cleanliness/sanitation of the bakery department. I also help facilitate multiple tasks in the bakery department by being a team player and having an organizational attitude.

Randolph Afb, Tx, Us

Averaged 77,508 LBS/year of fuel being offloaded to mission essential aircraft by removing and replacing fuel systems components on a KC-10, C-5, and C-17. Troubleshot and inspected the fuel systems of all 3 aircraft assigned to the duty station leading to the mission readiness of at least 90% of the aircraft. Managed two programs, Vehicle Maintenance and Supply Bench Stock, to ensure proper use in day-to-day operations and zero discrepancies for future inspections. Two outstanding unit awards were presented to 60 MXS Squadron, due to the vital role played by the Fuel Shop in operations and program management. Due to preparation and performance, I participated in 3 deployments and 7 mission reconnaissance teams allowing the shop flexibility with their personnel to ensure success. Finally, I maintained the fuel shop tool room by performing scheduled inspections, calibrations, checkouts, maintenance of tool logs, and receiving ensuing to zero discrepancies found during inspections.

Led the internet division of the company selling stair parts to distributors, contractors, and home re-modelers across the nation. Coordinated with the marketing and I.T. department to upgrade the company website, raising internet sales from $5K/month to $125K/month. Created an appreciation program which included customers and employees of House of Forgings, ensuing satisfaction across the board while decreasing order discrepancies by 35%.