I am an experienced Programmer Analyst with over 8 years of expertise in developing robust PHP and ILE-RPG applications within enterprise environments. I excel at designing and optimizing database-driven solutions using DB2 and MySQL, delivering scalable APIs and internal web applications. I am proficient in code analysis, system optimization, handling system halts, and automating processes to boost operational efficiency. Throughout my career, I have worked on high-performance applications, RESTful APIs, and database migrations while collaborating closely with stakeholders to ensure alignment with business objectives. I am certified in SQL and C# programming, and I continually strive to drive business value through innovative problem-solving and programming solutions.

Ian Sandoval

I am an experienced Programmer Analyst with over 8 years of expertise in developing robust PHP and ILE-RPG applications within enterprise environments. I excel at designing and optimizing database-driven solutions using DB2 and MySQL, delivering scalable APIs and internal web applications. I am proficient in code analysis, system optimization, handling system halts, and automating processes to boost operational efficiency. Throughout my career, I have worked on high-performance applications, RESTful APIs, and database migrations while collaborating closely with stakeholders to ensure alignment with business objectives. I am certified in SQL and C# programming, and I continually strive to drive business value through innovative problem-solving and programming solutions.

Available to hire

I am an experienced Programmer Analyst with over 8 years of expertise in developing robust PHP and ILE-RPG applications within enterprise environments. I excel at designing and optimizing database-driven solutions using DB2 and MySQL, delivering scalable APIs and internal web applications. I am proficient in code analysis, system optimization, handling system halts, and automating processes to boost operational efficiency.

Throughout my career, I have worked on high-performance applications, RESTful APIs, and database migrations while collaborating closely with stakeholders to ensure alignment with business objectives. I am certified in SQL and C# programming, and I continually strive to drive business value through innovative problem-solving and programming solutions.

See more

Skills

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Intermediate

Language

English
Fluent

Work Experience

Programmer Analyst at Lamps Plus
January 1, 2017 - Present
Developed and maintained high-performance PHP applications for internal web interfaces, integrating with IBM i Power 9 databases supporting business-critical operations. Engineered RESTful APIs using Node.js and React, enhancing data accessibility and workflows for cross-functional teams. Authored and optimized ILE-RPG and CL scripts producing reports, improving data accuracy and reporting efficiency by 20%. Conducted code analysis to debug and improve production applications, reducing error rates and boosting system reliability. Performed system analysis and redesigned database structures, optimizing query performance and reducing data retrieval times by 15%.
Computer Repair Technician at Self-Employed
October 1, 2004 - Present
Provided in-home technical support across the Greater Los Angeles Area, resolving complex issues including network configurations and virus removal with an average resolution time under one hour. Demonstrated strong problem-solving skills and maintained consistent client satisfaction through reliable and efficient service delivery.
Database Developer (Contract) at LA County Fed
November 1, 2016 - September 4, 2025
Led the migration of critical data from Excel to a MySQL database ensuring data integrity and scalable data management. Designed and implemented relational database models including optimized tables, indexes, and stored procedures to support organizational needs. Collaborated with stakeholders to align database solutions with business needs, enhancing data accessibility and reporting capabilities.
Production Specialist at Bank of America
February 1, 2015 - September 4, 2025
Utilized AS/400 (iSeries) systems to execute SQL queries for financial reporting improvements. Developed Visual Basic scripts automating repetitive tasks, increasing team productivity by 25%. Conducted detailed data discrepancy analysis ensuring compliance and operational consistency.

Education

Bachelors of Science at California State University, Northridge
January 11, 2030 - May 1, 2007
Associate of Arts at Los Angeles Valley College
January 11, 2030 - May 1, 2005

Qualifications

Certificate in Structured Query Language
June 1, 2015 - September 4, 2025
Certificate in C# Programming
August 1, 2015 - September 4, 2025
Cardiopulmonary Resuscitation (CPR) Certified
November 1, 2009 - September 4, 2025

Industry Experience

Computers & Electronics, Financial Services, Retail, Government, Professional Services

Skills

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Intermediate