Timothy Loo Email & Phone Number

Portland, Or, Us

- Led and managed the full software development lifecycle for a React frontend fisheries data entry application, including planning, coding, testing, evaluation, and operational implementation.- Led the end-to-end design and development of a secure .NET Core backend system with essential API routes, incorporating Active Directory LDAP authentication and .NET Core Authorization in C#, to enhance data security, quality, and functionality within a seamless frontend application.- Identified opportunities to enhance automation and efficiency within the development process by implementing Dockerization of the development environment, resulting in streamlined setup, improved productivity, and updated documentation on software application processes and data management procedures.- Assisted in identifying and resolving minor technical issues, including data fixes, MySQL database updates, and table modifications, to uphold data accuracy and ensure data quality within software and data systems.

Honolulu, Hawaii, Us

- Led the transition of a manual child care assistance application to an efficient online system, ensuring user-friendliness and data security.- Developed backend APIs in Java and managed Oracle SQL databases to enhance data analysis and insights.- Collaborated in pair-programming and mentored new developers, fostering a culture of software quality and knowledge sharing.- Designed comprehensive databases to optimize data processes and reporting, adhering to industry best practices.- Engineered custom logic plugins using the .NET framework on the Microsoft platform, addressing technical challenges, automating tasks, and improving system efficiency while working collaboratively with cross-functional teams.

This app helps pick-up basketball players connect with others. Users can update their stats & profile, find teammates in their location, make & join events, and communicate with friends.https://github.com/Blue-Ocean-Mario/Mario- Implemented real-time messaging by creating a socket server.- Created secure NoSQL database & authentication.- Project Manager for a team of 6.- Professional & constant communication between client & team.

Developed the backend design & implementation for an ecommerce product overview page.https://github.com/sdc-green-lantern/TJ-Products-API- Designed the database schema for read speed optimization over write speed for a better user experience.- Implemented the ETL process for over 1 million products.- Optimized queries and increased read speeds from database down to 31ms from 3s.- Deployed backend to AWS EC2 services.- Increased the capacity of the backend to handle 2000 rps from 500rps at 78ms by implementing load balancing across 2 servers using nginx (noting about 60ms latency for loader.io testing server location).- Reduced the initial server lag spike from 15s down to less than 1s using caching in nginx.

Developed the frontend product overview page for ecommerce website, focused primarily on the questions & answers section.https://github.com/freshprincefecflamongos2/Front-End-Capstone-FEC- Used data transformation to work with data that wasn’t clean served from the API.- Set up the jest test environment for testing React components for my team.- Implemented the use of memoization to improve functionality of frontend to account for missing information from the API.

Developed a full-stack application that will provide you with cocktail recipes based on what you have available at home.https://github.com/TimothyLoo/MVP-Cocktail- Integrated information from multiple APIs.- Implemented a MongoDB database for persistent storage of ingredients.- Implemented sorting to show recipes for cocktails that contain the most ingredients you already have available.

Honolulu, Hawaii, Us

- Played a key role in the development and execution of user acceptance testing, demonstrating attention to detail and problem-solving skills in validating and verifying data accuracy for UIs managing teacher licensing and school officials, ensuring a seamless user experience.- Actively contributed to the end-to-end software development process, including development, testing, and production support of teacher licensing and school officials management UIs, addressing technical issues and providing effective customer service to internal stakeholders.- Utilized SQL to meticulously confirm, validate, and verify thousands of lines of teacher qualification course load information, ensuring data accuracy and consistency within the database, showcasing attention to detail and data management expertise.- Updated system documentation to enhance end-user and qualified official understanding of UI operation, demonstrating effective communication and user-focused documentation skills, while addressing user needs for improved data management and analysis.- Created informative video walkthroughs as part of user training for new UI features, exemplifying effective communication and problem-solving abilities, facilitating user onboarding and promoting efficiency and automation within the system.

Honolulu, Hi, Us

- Enhanced data integration and reporting by implementing SQL pulls into Excel.- Spearheaded the creation of reports and dashboards, optimizing reporting for the FP&A unit.- Prepared budget packet for CFO approval, ensuring financial transparency for the new fiscal year.- Managed the largest service contract for The Queen's Health Systems.- Developed proformas to assess the financial impact of system expansion for The Queen's Health Systems.

Honolulu, Hawaii, Us

Managing the performances and merits for 5 direct reportsMaintaining positions available for the rating unit and hiring new talent to fill those positionsMaintaining and improving standard processes of the rating unitProvide guidance for financial arrangements for over 200 accounts size that 100 – 50,000 covered livesProvide monthly corporate reporting for upper managementUpdated existing logs to track the performance of 16 self-funded accounts and 50 fully-insured accountsAssisting in creating an automated batch rating procedure for fully-insured groups to preemptively identify how over 200 groups are trendingWorked on RFP that secured additional business of over 6,000 covered lives

Honolulu, Hawaii, Us

Training new employees on the processes of the rating unitCreating 3 new desk procedures for standard processes of the rating unitPreparing monthly task schedules for 13 analysts in Rating UnitAuditing monthly, quarterly, and yearly reports for 14 self-funded accounts (5500, statistical reports, financial reports, financial accountings, billing reports)

Honolulu, Hawaii, Us

Preparing monthly and quarterly utilization reports for HMSA’s largest account that covers over 50,000 livesAssisting in the preparation of RFP documents and other financial reports for the largest union in the state spanning a 3-year contractSubmitting the factors and methodologies used in the renewal process to the State Insurance Division at minimum three times per year, and answering any inquiries and objections at an ongoing basisWorked on the RFP team that won the bid for a 3-year contract. This secured an account covering over 50,000 covered lives. The bid also added one new line of business

Honolulu, Hawaii, Us

Preparing and analyzing rate proposals and financial reports to support the Marketing Department in the account’s rate renewal process, and make high level decisions on rates for renewals and prospective new businessesPreparing and analyzing monthly, quarterly, and annual reports for accounts (5500, statistical reports, financial reports, financial accountings, monthly billing)

Teaching advanced swimming techniques, motivate hard work and competitiveness, managingand recording times at swim meets. Managing T-shirt sales and finance.

Honolulu, Hi, Us

Creating and conducting programs, assisting in the operations of the pool, provide customerservice to patrons in person and over the phone

Managing a group of individuals to complete tasks during events. Analyzing strengths andweaknesses of swimmers, creating workouts to address each swimmer’s individual needs.Motivate and encourage swimmers to achieve their athletic goals.

Marketing the effectiveness of our program to potential students and parents, assisting in theoperations of the pool, provide excellent customer service to program participants.

Filing and organizing documents, creating appraisal forms.

Computer Software Engineering

Computer Science

Bachelor Of Arts (Ba), Economics