John Huynh

I graduated from University of Oklahoma in 2000 with a bachelor's in computer science. With over 20 years of software engineering, data engineering and full-stack web development experience, I have been able to master my ETL and data warehouse skills.

In my data / software engineer position at BOK financial, I was responsible for optimizing data delivery, automating manual processes, modifying software, identifying and correcting errors, directing software programming, and preparing reports on programming blueprints. This experience exposed me to the entire data/software engineering process, earning me recognition in 2013 when I Led and managed a team of six in developing new financial management software (FastLoan).

Bank of Oklahoma- Tulsa, OK 

Data Engineer (Data Management and Business Analysis), 08/2014 to Present 45 hours/week

• Designed and supported software systems, interfaced with internal business units and software development teams.
• Responsible for designing and developing standalone Windows and client-server applications using .NET Framework, MS Jet and MDAC technologies (implemented in C#, ASP.NET, MS Access, Oracle).
• Supported customers with technical solutions, defined requirements, created and maintained artifacts, and assembled large, complex data sets that met functional / non-functional business requirements.
• Researched commercial off-the-shelf (COTS) software products and cloud services in the field of Data Engineering, analytics, ETL, and automation.
• Developed and managed Extract Transform Load(ETL) or Extract Load Transform(ELT) using Base SAS, SAS Macros, SSIS, Informatica, Jscript, Perl and Linux Shell Scripting to support data management activities.
• Wrote web services and middle-tier components (DLL/Assembly) and implement (REST, C#, ADO.NET, Security, Encryption, AWS Glue/ Lambda).
• Developed multiple effective improvement workflows.
• Performed API level testing, system testing, black box functional testing, UI testing, and security to ensure quality and security compliances.
• Reviewed project proposals/plans to determine scope, time and cost.
• Ensured success of initiatives, identified potential risks and anticipated points of resistance, and recommended specific plans to mitigate or address the concerns.
• Automated tasks pertaining to Cloud Security, Container Security, Configuration. Performed hardening, baselining, vulnerability management, penetration testing, and Securing CI/CD.
• Served as the focal point for customer relationship management for assigned programs.
• Worked with the Scrum Master, Product Owner, the DevOps team, and the community of engineers.
• Participated in risk analysis and security tests and evaluations. Ensured appropriate levels of compliance/security. 
• Promoted quality by performing change reviews, recognizing system deficiencies, and implementing effective solutions.
• Planned, and maintained hardware and software change plans including requirements, design, technical documentation, and procedures.
• Completed and validated multiple Systems Operational Test Events.
• Cross-trained with other specialists. 
• Identified and leaded projects to drive automation and process improvement. 
• Interfaced with stakeholders to establish project requirements, deliverables, cost, and schedules to meet customer requirements.
• Maintained highly secure and available systems (24/7 basis and worldwide) by adhering to and implementing industry best business practices for the technologies deployed, according to SOX, FCRA and FTC.

• Created and customized SSIS packages (ETL and Script Component) to load data from difference sources.
• Designed and constructed SOA Web Services (WebMethods and .NET).
• Involved through all phases of Systems Development Life Cycle of Financial Data Warehouse. 
• Worked on designing of complex data models by using Embarcadero.
• Modified, maintained and optimized SQL server database.
• Developed mobile banking application for the iPhone by using Xcode (Objective-C).
• Created and designed a consumer-facing online loan application web by using MVC (C# and Entities Framework). 
• Analyzed system requirements in response to new or existing business requirements, risks, and costs.
• Utilized customer request/reporting system to develop metrics/project plan/test plan/cases and other technical documentations.
• Recognized technical problems or design flaws and recommended preventive or corrective action.
• Tested, validated and updated procedures during each step of implementation and deployment processes, using manual and automated testing.
• Implemented standard operating procedures to ensure appropriate levels of compliance/security.
• Be responsible for maintaining, expanding, and scaling the websites and web services (cloud).
• Worked closely with engineers and other technical teams to ensure quality of deliverables.

BS. Computer Science @ University of Oklahoma 2000