Brian Gaddi Ramirez

Client: Pioneer Insurance & Surety Corporation • Design and develop new applications and enhance existing applications on the Oracle APEX platform, enabling departments to save time and increase productivity by automating repetitive and time-consuming procedures. • Perform system analysis and system development tasks, optimizing operations, increases efficiency and reduces business costs. • Analyze functional business requirements to develop solutions and create technical specifications so that standards can be met, and the projects can be completed on time. • Collaborate with IT business units ensuring security and architecture requirements are fulfilled. • Continuously identify opportunities for application improvements, performance tuning and resolving issues, which optimizes systems or applications thereby reducing resource consumption to ultimately save money. • Reverse engineer existing obsolete applications so that it can be upgraded. This made the end-user experience better and helped the company maintain robust technology in their business operations. • Modify Linux-based Oracle Reports helping the company provide updated sensitive documents such as certificates and receipts to their clients on time.

Client: Metropolitan Bank & Trust Company • Helped the client’s system remain updated by converting an old Interbank Message application process to Oracle APEX. • Responsible for development of simple to medium complexity application design, programs, and related facilities according to approved business specifications, regulatory and company standards. • Collaborated with Business Analyst to provide design inputs and estimates in preparation of requirements document making sure that project cost is within the budget and timeline. • Documented system design and program specification in technical design document, making sure other programmers can maintain the programs in my absence. • Performed unit testing on written codes to ensure program perform per design at unit level, providing quality product release and low maintenance costs. • Conducted own investigation and resolution of errors reported during SIT and UAT.

• Developed Oracle Forms and Reports to extend system functionalities, which helped the company to release new insurance products. • Recommended solutions to problems encountered in program, providing user-friendly experience. • Created SQL scripts to extract production data from database based on user specification or requirements, helping them gather and analyze data faster. • Developed several application programs to automate repetitive tasks, thus maximizing other Department's productivity and in effect lessened company's operational costs.

Client: MAPFRE Insurance / PhilPlans First Inc. • Traced and corrected causes of error and unexpected output in system functionalities. • Built and designed applications whilst ensuring program efficiency. • Served as consultant in system applications development. • Performed data migration in Oracle Database Environment.

• Answer directory and general queries from the US, Canada and UK customers via SMS • Provide support to other customer service representatives