Frank Chongtrakul

Experience

• 

  Network Solutions

  Jan 2005 - Jan 2006

  Information Systems Engineer, Data

  Hired as Hyperion Essbase developer/administrator. Setup and deployed license server, Essbase Analytic Services, Essbase Administration Services, and Hyperion Analyzer on Unix (Sun Solaris) environment. Developed and maintained Essbase applications and analyzer reports.Worked with finance for new initiatives and translated requirements into design and development. Developed and optimized Essbase batch processes using MaxL, ESSCMD, and Job Scheduler. Fine-tuned Essbase settings and wrote MaxL script to optimize Essbase cubes for data processing. Migrated applications from development to production. Defined user/group access and security. Show less

• 

  Freddie Mac

  Jan 2006 - Jan 2008

  Business Application Project Manager, Business Intelligence

  Implemented business intelligence applications using Hyperion, MicroStrategy, and Microsoft Office tools as part of investment accounting initiative for capital market division.Designed and developed management, analytic, and operational reports using Hyperion Intelligence, Hyperion Essbase, and MicroStrategy for investment accounting and tax groups. Developed Essbase applications, including development of calc scripts, defining outline and load rules, database, and load optimization sourcing from data mart. Developed Hyperion Intelligence (Brio) reports and later converted into MicroStrategy reports. Performed data analysis and reconciliation using SQL and other query-based tools for production environment. Show less

• 

  Accenture

  Jan 2008 - Jan 2009

  Consultant, Oracle/Hyperion System Integration

  Worked for Ameren as Hyperion reporting development lead, overseeing BI report development using Web Analysis, Hyperion Financial Reporting, and SmartView. Designed and implemented reporting capabilities for client’s financial system. Demonstrated and recommended reporting tools to best suit client’s needs. Managed team of two developers onshore and coordinated with offshore team to deliver reporting solution. Delivered BI reporting capabilities to client.

• 

  Fannie Mae

  Jan 2009 - Jan 2015

  Led and managed core team responsible for security accounting transition and conversion. Oversaw and managed team’s day-to-day data conversion execution and reconciliation of $130 billion portfolio and $2.6 trillion in trust liability. Participated in defining conversion scope, conversion strategy, conversion reconciliation strategy, business requirements, and conversion runbook. Assisted and guided reporting workstream to setup business requirements framework for reporting requirements.- Guided successful conversion of security accounting data with zero major incidents during production conversion.- Implemented conversion reconciliation points and produced validation results to satisfy audit with zero findings. Show less Worked in various roles, including project manager, business requirements lead, UAT lead, and tester. Oversaw $120 million budget and forecast for loan accounting initiative program. Collaborated with program manager, directors, and VPs in developing business case presented to board of directors. Created business and application use cases, process flows, and business requirements documentation throughout project delivery lifecycle. Engaged in data modeling, technical analysis, and research alternatives for development of business requirements. Conducted and oversaw functional and non-functional testing in UAT. Participated in annual BAU planning, including scope prioritization, budget forecast, and resource allocation. Managed contractors in delivering business requirements and conducting UAT testing.- Successfully delivered ten-plus projects, with responsibilities including resource and budget forecast, project planning and scheduling, and project execution.- Implemented email approval process with SharePoint workflow to increase approval efficiency, later serving as guiding principle for other teams and projects to follow. Show less

  • Data Conversion Lead

    Jan 2012 - Jan 2015

  • Senior Business Analyst

    Jan 2009 - Jan 2012
• 

  Common Securitization Solutions

  Jan 2015 - Jan 2020

  Led test automation team to implement Tricentis TOSCA, new testing tool. Established daily scrum to discuss with test automation team on progress of build, promoted collaboration with testers to understand test cycles and test suites, and delivered final product by set target date. Defined test automation strategy and advised automation team on best practices.Promoted and facilitated essential collaboration between test automation team and QA testers to understand needs and prioritize deliverables. Oversaw successful transition from IBM Rational Integration Tester tool to TOSCA within five months of leading primary team, including delivering regression, progression, and performance test suites for testing CSS platform.- Enacted and established backlogs to build enhancements for test suites, driving saving and reducing testing cycles. - Reduced manual testing by 50% by implementing automated test execution and validation as well as automating notification of pass/fail test cases, resulting in 20% reduction of overall test execution time (two-day saving in two-week sprint).- Slashed TOSCA licensing cost by 50% by switching license configuration from full development mode to execution-only mode during test execution.- Implemented reusable test objects and test blocks to reduce test cases and scripts build time Show less Established and implemented RPA practice in strategy, design, development, execution, and support via Blue Prism. Built team of RPA process analysts, developers, testers, and production support from ground up. Drove adoption of RPA across organization and collected use cases to build RPA pipelines, including showcasing capabilities of RPA to senior leaders (C-level executives) and building business cases and roadshows.Partnered with cross-functional teams and applied both attended and unattended RPA techniques to deliver best solutions for customers. Served as delivery manager to build processes to enable Agile delivery in two-week sprints and managed backlog and prioritization with business customers. Reviewed Process Definition Document (PDD), Solution Definition Document (SDD) and test cases to ensure processes are delivered with the highest quality.Implemented 30-plus processes to eliminate manual work, save time and money, enhance validation and audit, and cover high-volume processes otherwise impossible for humans to complete. Utilized bots to perform testing and validation to reduce defects and incidents both during test phase and production.Highlights:- Automated error-prone manual interest rates reset process.- Automated daily test environments and hourly internal/external websites checks to ensure each remained up and running.- Implemented disclosure reporting validation for one million securities using 100 bots to validate between company site against Freddie Mac and Fannie Mae during conversion dress rehearsals and final conversion. Uncovered ten-plus defects due to code or formatting issues causing data to randomly drop out or display incorrectly.- Automated tax data setup, calculation, exception clearing, and validation. Show less Headed team of 20+ resources including managers and multiple workstreams with $15 million annual budget for data conversion execution and reconciliation through two releases to onboard single-class and multi-class security data from Freddie Mac and Fannie Mae to Common Securitization Platform. Drove efforts in defining conversion strategy, scope, and timeline with both internal and external stakeholders (Freddie Mac and Fannie Mae).- Successfully converted 26 million loans and 1 million securities with $4.3 trillion worth of unpaid principal balance. Received leader of quarter honor (company’s highest award) for accomplishment.- Implemented validation points in conversion sequence, including use of RPA bots to ensure data quality.- Worked closely with testing teams and clients (Freddie Mac and Fannie Mae) through multiple dress rehearsals to test conversion execution sequence and validation, resulting in successful final conversion in production with no major incidents while completing ahead of time in both releases.- Implemented a model to simulate multi-class security conversion that allows the team to capture exception and perform correction to the conversion files before loading onto CSS Platform. This has reduced the multi-class conversion execution time by 30%.- Implemented hash validation to validate database changes. This to ensure data integrity and accuracy between CSS Platform code releases. Show less

  • Test Automation Manager

    Jan 2020 - Jan 2020

  • Process Automation Manager

    Jan 2017 - Jan 2020

  • Data Conversion Manager

    Jan 2015 - Jan 2018
• 

  Ashling Partners

  Jan 2021 - Feb 2024

  Robotic Operation Center Manager

  Provide managed services to 10+ clients for production monitoring, support and fix/enhancement of automations using UiPath. Manage on/offshore teams providing 24/7 coverage for process automations in production. Experience in building teams to support automated processes for finance, HR and operations departments supporting clients in multi-industry including healthcare, homebuilding, insurance, property management, and financial services.Lead support team activities in IT Service management, incident management and enhancements of process automations. Developed and maintained portfolio of IT Service Management policies and operating proceduresProvide advisory for support and run of automations in partnership with the COE Show less

• 

  GSA

  Feb 2024 - now

  Technical Project Manager