Ryan Conching Email & Phone Number

Honolulu, Hawaii, United States

-Worked cross-functionally and built rapport across different teams within the organization, and led strategic process improvements which saves the organization approximately 1,838 work hours per year-In 2021, led improving processes which produced the most time saving efficiencies from the Operations Excellence team-Built SQL queries, stored procedures, and reports, which automate manual Excel work processes, therefore driving out unnecessary work, improving efficiency, and eliminating manual errors, rework, and employee pain points-Analyzed and summarized data sets to then produce KPI dashboards and reports, delivered to EVP to easily analyze monthly or quarterly insights-Shadowed employee’s processes and listened to feedback from team leader and employees, to create process maps, analyze root cause analysis, and mistake proof current inefficient processes-Led meetings with large groups of employees of all levels to present and instruct regarding completed process improvements-Produced documentation and job aids to assist users troubleshooting and running process improvement tools

-Founded Hawaii Beer Fest in 2018. -Conduct meetings with upper management for potential sponsorship clients, venue acquisition, and marketing strategies for future events. -Cold call potential venues, sponsors, and fundraisers to source and secure new client accounts.-Create and present proposals to upper management to develop effective print/online campaigns.-Use of online and direct marketing along with social media to promote our events and find new clients.-Monitor and manage event budget in alignment with revenue target.-Coordinate with clients throughout event implementation.-Develop new accounts by online advertising, social media, cold calling, and networking.

Honolulu, Hawaii

- Responsible for gathering business requirements which are utilized to develop, maintain, design, and backup various databases using MS SQL Server- Use SSIS to create, prototype, debug, and test ETL processes to extract, transform, and load data from different types of document sources (flat files, Excel, etc) into MS SQL Server- Design, create, and test various reports that require it to be created on a repeated basis using SSRS- Create SSIS/VBA packages to automate reports to run monthly, quarterly, and annually, subsequently exported and formatted into Excel- Created, tuned, and maintained complex SQL queries to create views that are used for reporting purposes- Designed documentation to explain to a non-technical user how to execute my scripts for ETL processes- Maintain, create, execute, and troubleshoot batch files used to automate SSIS packages

- Gather and translate requirements from client to customize their initial implementation of their payroll software instance- Design, test, develop, and implement changes on the client’s online instance of their employee payroll software

- Create and deliver various test cases to confirm expected results for QNXT system- Gather requirements and translate them into technical specifications to thoroughly test specifications- Design complex SQL queries to find needed information to successfully pass test cases

- NET application modification and maintenance- Gathering requirements to assess user’s needs for creation, design, prototype, and maintenance of new applications- Database maintenance and modifications using MS Access and SQL.

-Developed applications using the full software development lifecycle.-Trained end users in using the asset management software.-QA Testing.-Transforming business requirements into technical modifications.