Phat Tran Email & Phone Number

- Analyzed, developed and maintained new/ customized database scripts, functions, stored procedures for application development.- Designed technical specifications and database diagram.- Improved the performance of complex SQL queries and tuning indexes, stored procedures.- Refactoring and optimizing existing data structures.- Tracking logs (XML, JSON) in database to troubleshoot issues and fixing bugs.- Transferred and standardized data from MongoDB to SQL Server.+ Project:o External: FPT Play, IPTV, Smart TV, Foxy Hotel.o Internal: Content management system (CMS), Inside V3.

- Planed and manageed scope, resources, changes, risks, issues of projects.- Be involved in the software development process of clarifying customer's needs.- Analyzed new/ customized functions and issues with development teams. Building data model diagram, design and create databases for Dev team.- Supported BA to review/ adjust SRS (System Requirements Specification), Function Prototype.- Managed database migration between SQL Server and Oracle (using API, linked server).- Writing/ adjust scripts cursor to implement the migration between SQL Server & Oracle and view, function, stored procedure, trigger for main processes (screen function, dashboard for web and mobile app).- Created SQL jobs for capturing new report data into baseline table and history data weekly cleanup.- Designed and developed BI dashboards. (sell in, sell out, product sales density, period compare MTD/ YTD)- Designed and builded static reports module such as: Inventory, Purchase, Order management, KPIs, MCP, Tracking, Display/ POSM, QR Code.- Performed UAT, Pilot and Go-live with customers. Training DMS for end-users (head office, distributor, supervisor, PG, sales)+ Project: Hop Tri, Cau Dat Farm, Viet Australia, US Mart.

- Supported for customer and internal to create, organize and check master data.- Designed and created reports based on customer’s requirements (KPI tracking, timekeeping, revenue, ...)- Onsite tech support and get feedback from end-users during implementation. - Documented business process, identified customer training needs and created training documentation.+ Project: Kido Group Tuong An, QSR VietNam, Francia Beauty, Vianco, Jotun.