PHILLIP TRAN

• Manage team to build out FTR trading desk systems leveraging full -stack knowledge from front end tools to database architect design and implementation (MS SQL Server 2019, SSDT, T-SQL, database design, tables, views, stored procedures, functions )
• Provide direct support to FTR trading desk needs including building /enhancements of analytical tools for desk trading needs
• Tools in VBA, C#, Python, and Python Dash web report with dashboards to help analyze data including, P&L calculations, price analysis, cost / revenue analysis.
• Performed regular updates to team leadership on quality metrics by communicating consistency problems or production deficiencies.
• Collaborated with team members to achieve target results
• Proved successful working within tight deadlines and fast-paced atmosphere

• Followed up with clients to verify optimal customer satisfaction following support engagement and problem resolution.
• Provide direct support to FTR trading desk needs including building /enhancements of analytical tools for desk trading needs. (Python, C#, Python Dash)
• Coordinate and collaboration with IT teams on data and analytical needs
• Extensive knowledge of several FTR markets (ERCOT, PJM, ISONE, NYISO, MISO, CAISO, SPP)
• Built new tools to streamline mundane processes and create more efficient process i
• Tools written in C#, Python to access market data via API (Rest API, SOAP) scraping data from website collection and storing data into database for quick data analysis.
• Continuous enhancement of knowledge of FTR market and to apply knowledge to enhance desk trading efficiency
• Create analytical web reports in Python Dash to allow traders to view and analyze data
• Optimized system and platform performance capabilities in most efficient, practical way possible

Skills: Python, C#, T-SQL, Python Dash, Database: MS SQL Server 2016

• Followed up with clients to verify optimal customer satisfaction following support engagement and problem resolution
• Broke down and evaluated user problems, using test scripts, personal expertise and probing questions.
• Maximized quality and productivity with thorough training and consistent monitoring of team performance.
• Coordinated logistics for stakeholders projects, organizing resources and schedules to meet demands.
• Lead team of developers to support front office stakeholders in data analytics, report design, application development, and data warehouse architect.
• Oversaw IT needs for business stakeholders including commercial trading floor, Risks, Regulatory Compliance
• Big data project, oversaw contractors, manage Azure services, utilize HADOOP, HIVE, PIG
• Review and manage COTS system, vendor management
• Develop/manage report visualization tools (Microsoft Power BI, SSRS, SSAS)
• Decrease COTS cost by 10% by performing usage and with in-house built solutions
• Skills: C#, VB.NET, VBA, , MS SQL Server (database design), Hadoop, Hive, ,Azure (HDP), SSIS/SSDT, multi-threading UDP

• Met with customers to gather, analyze and prioritize requirements.
• Devised and proposed solutions for new projects and enhancements to existing applications.
• Resolved problems, improved operations and provided exceptional service
• Participated in continuous improvement by generating suggestions, engaging in problem-solving activities to support teamwork
• Developed and maintained clear documentation for methodologies and applications.
• Support \developed exchange solutions for deal loading into ETRM system (ALIGNE)
• Built exchange interfaces to pull real-time data for trade clearing, daily settlement prices, and trade confirmations utilizing (Rest API, SOAP, C#) ICE (TradeCapture \ iMpact), CME/NYMEX, Nodal Exchange
• Support Risk team including developing new solutions, reporting needs, and daily request projects include (SSRS, SSAS, Microsoft Power BI).
• Lead developer for trade confirmation in Dodd-Frank implementation for trade regulator requirements
• Built \manage ETL process utilizing SSIS/SSDT to load data into data warehousing.
• SharePoint development
• Skills: C#, VB.NET, T-SQL, MS SQL Server (database design), Hadoop, Pig, Hive, VBA, Azure (HDP), SSIS/SSDT, SharePoint

• Participated with clients in discussion meetings.
• Resolved system test and validation problems to provide normal program functioning.
• Participated in design and planning exercises for future software rollouts.
• Wrote code for database-driven applications.
• System analyst and developer of new applications for ongoing business cycle processes.
• Maintenance\support on existing legacy software applications
• Database development in Sybase 12.0, SQL Server 2000, 2005, Oracle SQL (Oracle 9i)
• Development using following tools: .Net (VB, C#), ADO, XML , VB 6.0, VC++, VBA programs in Excel and Access
• Created and maintain Business Object reports and Universes for users to extract data from data warehouse.
• Design and implement data mart extracting data from data warehouse using following ETL tools: : 2000 DTS packages, 2005 SSIS packages
• Daily functions included: Database design, data modeling, architecture, store procedures, triggers design , Data warehousing ETL tool: SQL DTS packages 2K, 2005 SSIS packages, IBM WebSphere 5.X MQ (Message Queue) support