Danh Pham
Wylie,TX
Summary
Experienced full-stack software engineer with over 16 years of hands-on expertise in designing, developing, and maintaining robust applications across various platforms (on-premises and cloud). My focus has been on data-related projects, and I bring a wealth of experience in data engineering, ETL processes, and database optimization. Proficient in multiple programming languages, databases, and frameworks. Passionate about big data, optimizing performance and delivering high-quality solutions.
Overview
17
17
years of professional experience
2
2
Certification
Work History
Solution Architect / Full Stack Software Engineer / Application Developer (PLSQL)
FPT USA Corp.
03.2020 - Current
- Collaborated with cross-functional teams to analyze requirement to design and implement software solutions for customer to replace the existing system
- Developed transaction posting to handle traffic of 3 million daily transactions, handle payment/billing processing function to comply with customer requirement
- Optimized performance for file processing dependency by using ForkJoinPool Java to handle recursive tasks involving sub tasks processing to utilize CPU resources on on-promise system
- Optimize query for reporting by using materialized views with partition tables, optimized indexes, execution plan.
- Analysis heapdump file using Jconsole, JVisualVM, AppDynamic
- Participated on most parts of projects including software design, develop and unit testing, support team, review code and solve problem
- Designed efficient database structures, including triggers, functions, procedures, and packages to handle big data and file processing
- Knowledge on streaming data and data pipeline using Streams, Ignite, Kafka, Hadoop, Spark, Big Query to send/handle messages and images from plaza/lane controller to Back Office System in real time and nearly real time
- Integrated with Git and CI/CD, Jenkins, Nexus, deploy application to docker container.
Full Stack Software Engineer / Application Developer (PLSQL)
FPT USA Corp.
01.2016 - 03.2020
- Collaborated with cross-functional teams to gather requirements, analyze, design, and implement software solutions for CUSIOPHUB to integrate with 7 agencies.
- Working on detail design for a project that can handle 7 agencies.
- Developed transaction posting for daily million transactions, processed around 100 daily files from multiple agencies.
- Handle big file processing by using Java/Camel threads, ExecutorService, batch processing, split big file by small chunks for threads run and control volume data to avoid OutofMemoryError/GC overheat, and using MERGE INTO to insert/update batch to PARTITION tables to improve performance.
- Designed efficient database structures, including triggers, functions, procedures, and packages to handle big data and file processing.
- Created meaningful reports using Crystal Reports and Oracle Report.
- Investigated and provided solution: Fixing connection leak, memory leak, and GC overheat limit issue for Java Spring Boot application by analyzing/monitoring dump file using Jconsole, JVisualVM.
- Improve big file writing to database by using multiple threads and MERGE mechanism with a partitioned table.
- Improve reporting performance by adding an ETL process, using incremental aggregation for missing or changed data only. Partition/sub-partition the table by date, range, and other criteria.
- Review and optimize indexes for tables.
- Analyze and resolve UI problems by using Chrome Developer Tool to fix JavaScript and jQuery issues.
- Integrate and manage source code with SVN.
Full Stack Software Engineer / Application Developer (PLSQL)
FPT USA Corp.
08.2013 - 12.2015
- Collaborated with cross-functional teams to gather requirements, analyze, design, and implement software solutions for Tolling system
- Handled transaction posting, payment processing for Tolling system
- Developed and maintained web applications using Oracle, Java, and reporting tools
- Designed efficient database structures, including triggers, functions, procedures, and packages to handle big data and file processing
- Integrated and managed with SVN
- Handled data warehouse ETL to show on report.
Application Developer (PLSQL)
FPT Software Ho Chi Minh
06.2012 - 07.2013
- Collaborated with cross-functional teams to analyze requirements, design, and implement function for Tolling system
- Participated on most parts of projects including software design, develop and unit testing, support team, review code and solve problem
- Developed and maintained web applications using Oracle, Java, and reporting tools
- Designed efficient database structures, including triggers, functions, procedures, and packages to handle big data and file processing
- Created meaningful reports using Crystal Reports and Oracle Report
- Integrated and managed with SVN
- Handled data warehouse ETL to show on report.
Full Stack Software Developer
FPT Software Ho Chi Minh
09.2011 - 06.2012
- Analyze and upgrade the existing system from .Net 2.0 to 4.0 for an investment company.
Full Stack Software Developer
3D Homes
03.2011 - 09.2011
- Research new technologies and develop a 3D website using Java, Away3D, Flash, ActionScript, JavaScript, jQuery, and CSS.
Full Stack Software Developer
FPT Software Ho Chi Minh
01.2009 - 03.2011
- Analyze and understand requirements, design using UML model, research, and build applications on Windows Mobile, and write unit tests.
- Coordinate with team members and team leader for reconciliation, reviewing, and release.
- Develop application using .NET 2.0, ASP.NET, C#, WCF, MS SQL, Reporting Service.
- Using SVN to manage and control source code.
Full Stack Software Developer
FPT Software Ho Chi Minh
12.2007 - 01.2009
- Analysis and understand requirement, design using UML model, research and implement function, and write unit testing, coordinate with team members and team leader for reconciliation/reviewing/release
- Develop website using .Net 2.0, ASP.NET, C#, JavaScript, jQuery, CSS, MS SQL, Oracle, Crystal Report.
- Using SVN to manage and control source code.
Education
Bachelor of Science in Computer Science -
Ho Chi Minh University of Science (HCMUS)
04.2009
Skills
- SQL
- PLSQL
- Data Warehouse
- ETL
- Kafka, BigQuery
- Cloud OCI, AWS, Databricks, Spark, Python, Azure Databricks
- Java, Springboot
- ExecutorService batch processing
- ForkJoinPool stream processing
- JavaScript
- Jquery
- Strut 10 to 20
- Net 20 to 40
- ASPNET
- MVC
- C#
- Mendix
- Elastic Search
- Open Search
- CI/CD using Jenkins, Nexus, Maven, Github
- Automation using Cucumber
- Docker container using ansible/podman
- RAG with NLP llama 3, Hugging Face, OpenAI
Certification
- Databricks Certified Data Engineer Associate, 06/04/2024
- MCPD .Net 4, 06/01/2012
Languages
English
Professional
Vietnamese
Full Professional
Affiliations
- Learning from Youtube, LinkedIn, Udemy, Microsoft Learning
Accomplishments
- IBTTA reward 2019 for successfully developing and delivering CUSIOP project to customer to handle multiple agencies with big data and file processing (Central United States Interoperability Hub (CUSIOP Hub) | IBTTA | International Bridge, Tunnel and Turnpike Association).
- Company Individual Recognition.
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Timeline
Solution Architect / Full Stack Software Engineer / Application Developer (PLSQL)
FPT USA Corp.
03.2020 - Current
Full Stack Software Engineer / Application Developer (PLSQL)
FPT USA Corp.
01.2016 - 03.2020
Full Stack Software Engineer / Application Developer (PLSQL)
FPT USA Corp.
08.2013 - 12.2015
Application Developer (PLSQL)
FPT Software Ho Chi Minh
06.2012 - 07.2013
Full Stack Software Developer
FPT Software Ho Chi Minh
09.2011 - 06.2012
Full Stack Software Developer
3D Homes
03.2011 - 09.2011
Full Stack Software Developer
FPT Software Ho Chi Minh
01.2009 - 03.2011
Full Stack Software Developer
FPT Software Ho Chi Minh
12.2007 - 01.2009
Bachelor of Science in Computer Science -
Ho Chi Minh University of Science (HCMUS)
Similar Profiles
Tria Claire A. DucayTria Claire A. Ducay
Senior Business Development Manager at FPT SOFTWARE, FPTSenior Business Development Manager at FPT SOFTWARE, FPT
Susan SchmitSusan Schmit
Client Experience Specialist at Lifestyle Hearing Corp; Collier Hearing; Hear USAClient Experience Specialist at Lifestyle Hearing Corp; Collier Hearing; Hear USA
Kerianne AronsonKerianne Aronson
Material & Supply Chain Specialist at Schenck USA CorpMaterial & Supply Chain Specialist at Schenck USA Corp
Rahel AlemayehuRahel Alemayehu
Control and Reporting Senior Analyst at PepsiCo Inc.Control and Reporting Senior Analyst at PepsiCo Inc.
Martin ToukoMartin Touko
Warehouse Worker at Ashley Furniture WarehouseWarehouse Worker at Ashley Furniture Warehouse