Kim Jaihani
Peoria,USA
Summary
Dynamic Computer Engineering graduate with extensive experience in software development and testing, specializing in Oracle Integration Cloud solutions, SQL (DB2, Oracle, Snowflake, BigQuery), mainframe applications, and ETL DataStage platforms. Proven track record of driving innovation through the creation of tools and processes that significantly enhance project efficiency and quality. Expertise includes detailed design documentation, unit testing of OIC jobs, IBM DataStage jobs, COBOL programs, and JCLs, alongside comprehensive manual testing methodologies for both component and system testing. Recognized for exceptional performance through multiple employee awards and client accolades, reflecting a strong commitment to excellence and collaboration in high-pressure environments.
Overview
16
16
years of professional experience
Work History
Staff Software Engineer
Albertsons Inc
Phoenix, AZ
10.2019 - Current
- Led cross-functional teams to integrate new technologies into existing systems.
- Mentored junior engineers, fostering skill development and knowledge sharing.
- Mentored junior engineers, providing guidance on best practices and fostering professional growth.
- Conducted code reviews to ensure adherence to best practices and improve quality.
- Collaborated with product management to define project scope and deliverables.
- Evaluated emerging technologies, providing insights for strategic planning and implementation decisions.
- Consistently met project deadlines, prioritizing tasks effectively and maintaining open lines of communication with stakeholders.
- Performed root cause analysis on reported issues, swiftly resolving bugs while minimizing disruptions to users'' experiences.
- Collaborated with management, internal and development partners regarding software application design status and project progress.
- Authored code fixes and enhancements for inclusion in future code releases and patches.
- Created proofs of concept for innovative new solutions.
- Conducted data modeling, performance and integration testing.
- Developed conversion and system implementation plans.
- Supervised work of 15 programmers, assigned tasks and monitored performance against targets.
- Designed and implemented scalable applications for data extraction and analysis.
Specialist Software Engineer
Safeway Philtech, Inc.
Bonifacio Global City, Philippines
04.2013 - 10.2019
- Analyzed the Safeway’s Vendor management system and design DataStage job that will interface the Albertsons' vendor data to Safeway’s system.
- Analyzed different mainframe component that was affected by the addition of new divisions due the merging of Safeway and Albertsons stores.
- Lead the other half of 35 plus team members in preparation of the other 3 division (Portland / Seattle and Jewel Osco) rollouts while the other half is doing some implementation on the other 2 division (Intermountain / Denver) rollouts.
- Analyzed and prepared tasks assignments for each team members.
- Coordinate and did some initial requirements gathering with the business users for the rollout of the 3 new divisions.
- Supervised, delegate and track resource task assignments and prepared task completion report to the project manager.
- Developed a job that converts the Safeway US fiscal calendar to Albertsons calendar.
- Developed a job that dynamically creates jobs and submits it automatically to process almost millions of records at the same time. This helps the other teams in resolving the issues that they are encountering when they shift all their records from using the old Safeway calendar to use the New Safeway calendar.
- Developed a macro that helped business users to enter new store information in the Organization Master application. The macro automates the manual entering of store information in the OM CICS screen.
- Developed a job that converts the Safeway Canada fiscal calendar to Sobeys calendar.
- Minimized the conversion job that has a baseline run of 4 hours down to approximately 2 hours execution time.
IT Consultant
IT Managers, Inc
Makati, Philippines
11.2012 - 04.2013
- Developed and maintained software applications using Mainframe and Visual Basic to enhance functionality of Safeway applications.
Applications Programmer
Fidelity Information Services (FIS) Global Solution Philippines
Makati, Philippines
05.2012 - 11.2012
- Analyzed and modified IMPACS and ALS modules.
- Modified also impacted Easytrieve modules.
- Developed unit tests scripts for the impacted components.
- Developed an innovation or a tool that automatically converts IMPACS and ALS DAGs (data group) layout or a COBOL copybook into an Easytrieve layout.
Senior Associate Mainframe Consultant
Headstrong Philippines Inc.
Makati, Philippines
07.2009 - 05.2012
- Developed Test Plan and Test Cases based on the Functional Requirement
- Created test data for testing executions.
- Captured test results and escalate found defects and discrepancies
- Managed internal documents as the team’s CM Admin.
- Conducted Test Plans, Test Cases and Test Results walkthrough with the onshore clients.
- Developed a JOB that automatically translates Mainframe’s SPUFI (SQL Processing Using File Input) outputs to MS Excel readable file. This helped the team minimize the time effort in test data gathering and preparations. The created JOB processed the output of a SPUFI and then converted into CSV format which can be viewed in MS Excel for further formatting and presentation. Before this JOB was created, it takes a whole day transferring the output of a SPUFI query to an excel file and it also depends on the number of records that will be fetched by the SPUFI query. The output of the SPUFI query can fetch of up to thousands of records and when you transfer it to excel file, you will have to do a thousands of copying and pasting.
- Created JCLs or JOBs that further speeds up test results validations and more accurately.
- Developed a parser using Visual Basic 6.0 that helped the team minimize the time effort to analyze impacted components.
Education
Bachelor of Science - Computer Engineering
Pamantasan Ng Lungsod Ng Maynila
Manila, Philippines04.2009
Skills
- Experience with Oracle Integration Cloud (OIC) solutions
- Data transformation expertise in IBM DataStage
- Skilled in data manipulation using JSON and XML
- Mainframe application development
- COBOL software development
- Proficient in JCL programming
- Proficient in SQL across DB2, Oracle, Snowflake, and BigQuery
- C/C application programming
- Proficient in Visual Basic programming
- Proficient in Unix scripting
- System architecture design
- JIRA task organization
Timeline
Staff Software Engineer
Albertsons Inc
10.2019 - Current
Specialist Software Engineer
Safeway Philtech, Inc.
04.2013 - 10.2019
IT Consultant
IT Managers, Inc
11.2012 - 04.2013
Applications Programmer
Fidelity Information Services (FIS) Global Solution Philippines
05.2012 - 11.2012
Senior Associate Mainframe Consultant
Headstrong Philippines Inc.
07.2009 - 05.2012
Bachelor of Science - Computer Engineering
Pamantasan Ng Lungsod Ng Maynila
Awards/Recognitions:
- AFCSET MVP 2017 Awardee Safeway Philtech, March 2018
- AFCSET Above and Beyond the Call of Duty (ABCD) 2017 Awardee Safeway Philtech, March 2018
- February 2018 Appreciation Hour Awardee Safeway Philtech, February 2018
- September 2017 Appreciation Hour Awardee Safeway Philtech, September 2017
- June 2017 Appreciation Hour Awardee Safeway Philtech, June 2017
- Q2 2015 AppDev ABCD Awardee Safeway Philtech, July 2015
- June 2015 Appreciation Hour Awardee Safeway Philtech, June 2015
- AppDev Manila ABCD One Time Customer Compliment Safeway Philtech, May 2015
- April 2015 AppDev Manila Awardee Safeway Philtech, April 2015
- March 2015 AppDev Manila Awardee Safeway Philtech, March 2015
- Appreciation Hour for March 2014 Awardee Safeway Philtech, March 2014
- Appreciation Hour for May 2013 Awardee Safeway Philtech, May 2013
- Double Pat on the Back Headstrong, May 2012
- Cause for Applause April Award Headstrong, April 2012
- Cause for Applause January Award Headstrong, January 2012
- Pat on the Back Headstrong, August 2011
- Pat on the Back Headstrong, June 2011
- Pat on the Back Headstrong, May 2011
- Pat on the Back Headstrong, March 2011
- Cause for Applause September Award Headstrong, September 2010
- Pat on the Back Headstrong, September 2010
- Accenture Education Program – COBOL Helpdesk Award Accenture, May 2008
Trainings/ Seminars/ Continuing Education:
- Combined Spring and JPA / Hibernate Orange and Bronze, February 2019
- Java Enterprise Fundamentals Orange and Bronze, December 2018
- Programming in C# Edupro, December 2017
- ReconNET Training Safeway Phoenix, September 2016
- Accenture Education Program – Software Testing Trainee Accenture, June 2008
- Accenture Education Program – COBOL Trainee Accenture, April 2008