Lan Q. Pham
Allen,USA
Summary
Dynamic IT Specialist with a proven track record at Enagic USA, Inc., excelling in Python and PL/SQL. Achieved a remarkable reduction of trouble tickets from 96 to 0 at AT&T through innovative coding solutions. Strong problem-solving skills and a commitment to enhancing IT systems drive my success in delivering impactful results.
Overview
26
26
years of professional experience
Work History
Operation Manager
Nina Chicken Seafood & Yogurt LLC
Fort Worth, Texas
01.2022 - Current
- Managed daily operations to ensure high standards in restaurant performance.
- Created work schedules for eight staff members to enhance workflow efficiency.
- Oversaw inventory management while interacting with customers to improve dining experiences.
- Generate payrolls and tax documents.
- Resolve daily transactions through payroll system utilization.
IT Specialist
Enagic USA, Inc
01.2019 - 01.2022
- Daily provided IT support and technical assistance
- Maintaining IT documentation and inventory.
- Manage, configure, and daily trouble tickets troubleshoot.
- Implement improvements for the organization’s IT systems.
- Offer technical assistance for queries/issues related to computer system and service.
Specialist- Application Developer
AT&T
Richardson, TX
01.2009 - 01.2019
- Managed daily trouble tickets for Telegence Dealer and wrote codes to resolve many tickets for Telegence Dealer, this helped reduce the number of tickets from 96 to 0 by the end of the year.
- Promoted code to Telegence QC for testing and coordinated with Amdocs folks to have code delivered to production on schedule.
- Supported development delivery of Commission and Ripple projects including Cross Upgrades, Next, IMEI mismatch, Locals Dealer Turnkey on time, within scope, and with in budget.
- Supported the billing release by running scripts (PL/SQL) to check for the new fields created for Telegence Dealer tables and compared them to make sure all tables and schemas are correct.
- Supported development delivery of Unix to Linux Migrations for TLG Dealer application and database by ensuring migrations are successful and issues addressed quickly.
- Lead Telegence Dealer trouble tickets meeting with Senior Director, team members, and other team members.
- Completed documentation of the High Level Design (HLD), Detail Design (DD), and Application Detail Design (ADD) for multiple projects and represented to Project team and other.
- Responsible to resolve the trouble tickets for Telegence Dealer.
- For Embedded SQL, I wrote multiple data layers in C and embedded Oracle (PL/SQL) inside the programs, those data layers will trigger to select, insert, delete, or update data that the Telegence Dealer system needed.
- Owned and managed defects for Telegence Dealer and resolved and reported to leadership
- Involved development team to rewrite code for Telegence Dealer and this resulted that the Telegence Dealer will not be dependent on Amdocs system or other systems.
Application Production Support
Cingular Wireless
Richardson, TX
01.2003 - 01.2009
- I’ve worked in a variety of application support teams and took on roles as needed which is included writing codes, supporting, and testing.
- My experience working in a variety of team members has helped me improve while working with each application support team including QC Team, Change Management Team, Commissions Data Integrity, TPC, …
- Establish and implement Telegence Dealer code push forms, documented what have been changed for all codes. Work closely with Change Management team to have the ECR emergence code push create, and all trouble tickets need to be delivered on time.
Application Software Developer
SBC
Richardson, TX
01.2000 - 01.2003
- Wrote codes that collecting data from AR systems so when the journal job (DCRSJOURN) running. These datas will ready for another daily job (DCTRXCRE) to run. These jobs will handle millions transaction each day, and finally have the extract job run to extract the data from Telegence Dealer system to Horizon system.
- Involved to write the program called Manual Change Dealer. The program will read the operational table for the change dealer program and create a file in the same format the TPC team provided.
- Write multiple reports program using Focus report and Cobol to track internal Telegence Dealer data, calculate, and help to report the missing data. The reports helped team members to find out the root cost of many issues.
Education
Bachelor Degree - Computer Science (CS)
University of Central Oklahoma (UCO)
OKSkills
- Python
- Java
- C and C
- Cobol and Pascal
- Oracle and PL/SQL
- Unix and Linux systems
- Windows 7 Professional
- Telegence dealer system
- Prism and SONAR
- PuTTy and Unix shell scripting
- Korn shell and Windows PowerShell
- Microsoft Excel
Training
- Python
- Java
- Java scripts
- HTML
- Prism
- SONAR
- Agile
- API
- Mobile First
- R Programming (Big Data)
- Cloud
- Linux
- CLI
References
Information will be updated later.
Technology And Skills
1 yr), Prism (> 2 yrs), SONAR (< 1yr), PuTTy (6 yrs), Unix (16 yrs), Unix Shell script (16 yrs), Korn Shell, Window Powershell, Microsoft Excel, AT&T tSpace
Personal Information
Status: U.S. Citizen
Timeline
Operation Manager
Nina Chicken Seafood & Yogurt LLC
01.2022 - Current
IT Specialist
Enagic USA, Inc
01.2019 - 01.2022
Specialist- Application Developer
AT&T
01.2009 - 01.2019
Application Production Support
Cingular Wireless
01.2003 - 01.2009
Application Software Developer
SBC
01.2000 - 01.2003
Bachelor Degree - Computer Science (CS)
University of Central Oklahoma (UCO)