Jack Truong

Experience

• 

  BIOVIA

  Jul 2012 - Feb 2017

  IT Business Systems Analyst

  • Experience in working with various modules within Oracle EBS R12 architecture: Order Management, Inventory, Accounts Receivable, Accounts Payable, Purchasing, Fixed Assets, and General Ledger • Act as the initial point of support for finance and accounting teams globally; on a daily basis to resolve both technical and financial issues • Provide month-end support to the sub-ledger accounting modules to achieve day 1 close schedule • Provide ad-hoc reports for all levels of management • Act as a liaison between functional users and the technical team to develop better business practices and streamlined processes • Experience in configuring Oracle EBS R12 • Assist in administering Oracle 11g database and Oracle EBS R12 • Administer third party reporting software: Insight Reporting • Assist in integration of multiple financial systems through M&A activity • Assist in managing offshore team of consultants • Conduct and participate in several UAT sessions • Conduct and host meetings between technical and functional staff • Configure, implement, and administer third party tax software: CCH Prosystem Tax • Troubleshoot and tune slow performing SQL queries • Hyperion installation, configuration, and reporting Show less

• 

  DJO

  Feb 2017 - Nov 2017

  IT Business Systems Analyst

  • Primary point of contact for supporting accounting and finance departments• Project manage various 3rd application integration into Oracle EBS• Generate ad-hoc financial reporting• Daily support for accounting and various subledgers• Ensure accounting close schedules were on time

• 

  Zodiac Pool Systems

  Nov 2017 - Aug 2021

  IT Business Systems Analyst

  • Primary point of contact for accounting and finance across the Americas• Project manage custom application development in Oracle EBS for Rewards/Customer support teams• Work closely with Salesforce administrator to ensure data being passed between systems is accurate• Project manage 3rd party application integration for Oracle EBS accounting applications• Create UAT test scripts and conduct testing sessions• Manage meetings between offshore consultant teams and in-house technical/functional teams• Automate alert notifications in Oracle EBS• Provide day to day support for accounting/finance in Oracle EBS• Ensure day 1 closing of accounting books• Generate ad-hoc reporting as well as automate scheduled report deliveries from Oracle EBS• Develop SQL queries for reporting, troubleshooting, accounting reconciliation, and to maintain data integrity• Facilitate and review SQL/SOQL queries and packages/stored procedures Show less

• 

  NimbusLabs

  Aug 2021 - Jan 2023

  Jr. Salesforce Administrator

  • Maintain user accounts, roles, rules, and profiles • Build reports and dashboards according to client specifications • Maintain and create automation flows utilizing flow builder, process builder, workflows, and approval automation • Update/create page layouts, formulas, record types, fields, and other various customizations • Perform mass data imports/exports via data import wizard and data loader • Train users on new functionality and improved processes • Troubleshoot day to day issues in Sales and Service Cloud Show less

• 

  Coastal Payroll

  Jan 2023 - now

  Salesforce Administrator

  • Project manage Salesforce adoption, integrations, and project implementations• Administration of Sales and Service Cloud• Train users in Salesforce functionality, new processes, and building reports and dashboards• Build/maintain automation and enhance user experience via flows and page layouts• Utilize source control tools: Git, VS Code, and Workbench API• Perform mass data imports/exports via data import wizard and data loader• Integrate Hubspot CRM and Ownbackup• Maintain Salesforce releases, users, profiles, rules, and security Show less