William Tran Email & Phone Number

United States

• Assist team with defining customer business processes and requirements. • Design and configure solution to specifications set by the customer. • Participate in each stage of the development lifecycle (analyze, design, implement, test, deploy and maintain) and take full ownership and responsibility of work. • Work collaboratively with cross-functional team members in different time zones. • Troubleshoot and resolve production issues on demand. Build new planning models as well as maintaining existing ones. • Analyze, define, and document requirements for data, workflow and logical processes. • Code, test, debug, and document new or existing programs to optimize performance and reliability. • Understand project goals and requirements, develop situations, and drive project to completion.

Work on system integration, data transformation, custom app development. Connect finance business users to Salesforce custom objects. Write documentation on workflows. Train users and troubleshoot technical issues. Facilitate and expedite manual processes to more reliable automated forms of data movements, eliminating human errors and ensuring consistency and reliability of results.

· Manage many X-Author for Excel by Conga related applications, train and assist junior members· Senior developer in a massive “large cart” project with Excel as front-end· Sole supporter of a sophisticated profitability X-Author for Excel application· Designer and supporter of Finance’s month-end preparations and reporting· Resolve all Salesforce tickets related to X-Author apps

San Francisco Bay Area

· X-Author for Excel by Conga app designer on the Salesforce platform with bidirectional data manipulations to facilitate and enhance end-user experience with data ownership· Employ extensive VBA usage for ETL and reporting automations· Serve as internal consultant to Professional Services division’s more challenging issues· Create demo apps for Dream Force and other sales purposes as needed· Clients include Abbott Diagnostics, Intel, Ally Bank, Visa, Greystar, SITA (Société Internationale de Télécommunications Aéronautiques), Micro Focus, Ruckus Wireless, Emdeon, Aussie Post, Lionbridge, Delphi, Genomics, CITI and more

Newark, Ca

· Manage all aspects of month-end revenue journals and reporting for HQ in Paris, France· Transform legacy data (Oracle, Costpoint, Discoverer, Hyperion) into user-friendly formats· Liaise between Finance and IT on budgeting as well as implementation matters· Tech guru for Finance month-end automation

· Chief designer and developer of Project Spotlight — a fully automated pan-brand sizing and packing tool· Develop new Purchase Order (PO) creation tool for GID, eliminating manual labor and human errors · Assist UK/Canada Team with many tools to help launch eCommerce sites· Ameliorate Visual-Top30 weekly sales report, removing messy user-interface and assembly· Create allocation tool for Piperlime New York, allowing for what-if scenarios forecasting

· In-house ETL expert for converting legacy data to user-friend data format and for reporting· Architect a complex Inventory Aging database pulling from disorganized input sources to produce outputs in consistently reliable standards with automated distribution mechanisms· Develop month-end journal prep tool which was circulated and used by many Finance users· Speed up annual Strategic Business Plan process with systematic validations of inventory product schedules and what-if scenarios· SuperUser membership for the Business Objects (BO) Reporting Team and Finance Essbase cube· Subject matter expert for Supply Chain Finance, both internal and external reporting· Employee Excellence Award for outstanding and exemplary work

B.A, Business Economics

Education record