Allan Ray Gagani

Allan Ray O. Gagani B3 L39 Lynville Residences Phase 1, Brgy. Palo-Alto, Calamba, Laguna, Philippines-/- Summary of Qualifications Allan has a total of more than 20 years of professional experience in the IT field as a Systems Developer/ Analyst. He is currently working at Microchip Technology as Senior Database Analyst II working in wide variety of programming languages such as C# .NET Core, Blazor, C# .NET Web, MS SQL, Oracle, MySQL, Tableau and VBA. He was previously employed at Hewlett Packard Enterprise as a Technology Consultant and Accenture as Associate Manager as an ABAPer. Overall, he has broad experience in database management systems all through his career. He has sharpened his skills not only in software development but also in technical design, documentation, problem solving and decision making. To simply describe him, he is extremely independent, a very good problem solver, innovator, an excellent troubleshooter and quality contributor. Allan also has experience teaching as a part-time IT/CS instructor in ICCT Colleges Foundation. Expertise Expertise Years of Expertise Relevant Technical Expertise: MS SQL Server C# ASP.NET Javascript MySQL Oracle Crystal Reports VBA Visual Basic 6.0 Tableau >10 >10 >2 >6 >6 >6 >5 >5 <1 Relevant Industry Expertise Semiconductor Real Estate Solutions Academe 5 yrs 5 yrs 7 yrs 3 months/1 semester Relevant Work/Project Experience Microchip Technology Operations (Philippines) Canlubang, Calamba, Laguna Dec 04, 2017 – Present Position Senior Database Analyst II Roles Working as a developer of software systems, mostly database solution for Reliability and Failure Analysis Team. Usual task involves discussing customer issues, information gathering about the current and new processes, formulating plan and solution, proposing the solution, coding and developing, testing and implementation.\ Supports legacy systems Accomplishments and Projects FA (Failure Analysis) Laboratory Reservation and Utilization System-- a web application that enables the team to book a schedule on lab equipment usage. The team can also monitor the status of the equipment (vacant or not) and its utilization during a certain period of time. FA Incident Tabular Report-- implemented a SQL script/job that compiles all the open incidents into a tabular report and sends it to all team members for daily monitoring. Reliability Work Integration– a web application that enables the end-users to encode the Reliability step by step processes into the system such as material-interaction-induced failure, mechanically induced and environmentally induced mechanisms. FA Endorsement Log– a web application for logging FA case endorsements. This allows the team to monitor the progress of the step by step processes of handling FA cases. This also allows the superiors to manage the team member assignment who will handle the cases. FA Dashboard monitoring system– a web application designed for US counterparts that enables them to view, track and organize handling of FA cases that is connected to the global application called Failure Analysis Web. Database Mapper-- a Windows application tool to import data from a Sharepoint Application (xml database format) to Microsoft SQL Server Hardware and Equipment Inventory System-- a web application that comprises hardware and laboratory equipment. Failure Analysis Online-- a web application system that handles step by step Failure Analysis operations and processes. Development of middleware to export data from Oracle DB to MS SQL. Created VBA tools for small tasks Web Server management and deployment. HP – Enterprise Services Taguig, Philippines Sep 17, 2012 – March 2017 Position Technology Consultant II Project Type ABAP Technology Support Roles Develops ABAP reports/tools & fix bugs whenever necessary. Optimizes design & performance of ABAP programs. Provides software design which includes project estimates, detailed design document, UTP and other related documents. Provides support/investigation on SAP production regarding critical issues. Accomplishments Provides technical support & investigation of critical issues encountered by ABAP tools, reports & jobs. Fix bugs from existing reports & tools. Enhances existing reports. Proposed technical design and solution. Optimizes source code and performance. S2C Wave project (April 2013 – July 2014) Developed 10 objects including a major ABAP report, 2 report tools and 7 function modules which 6 of those are RFC. Turkey e-Bookkeeping project (May 2014 - Present) Developed 1 major report with 6 RFC function modules Averaged to 1-2 ticket/s resolution per day during base work assignment from Sept 2012 up to February 2014. Worked in BCP (Business Continuity Plan) tool written in C# .NET that would send SMS to different teams/members during calamity. The tool receives & collects information and this is very helpful to know the condition of each member. Currently working and learning Change management process. ICCT Colleges Foundation Cainta, Rizal, Philippines Sep 23, 2013 – Jan 2, 2014 Position Faculty – College of Computer Studies Description Taught courses in Javascript, Database Management/File Processing and Digital Electronics & Logic Design. Accenture Makati, Philippines Nov 2011 – Sep 2012 Position Senior Software Engineer Project Type Telecommunications client / HR Time related/ ABAP, ABAP-HR Roles Develops & maintains programs based on client needs. Provides software design which includes project estimates, detailed design document, UTP and other related documents. Assists co-team players in order to meet target deliverables. Provides support/investigation on SAP production regarding critical issues under Time related modules & programs. Accomplishments Modified existing SAP HR Time program under Disability Infotype that involves populating new record after a record validation with the use of BDC. Modified an infotype structure PS9210 (Disability) to add a new field (FMLA indicator). The development also involves dialog programming. The requirement is to add a field to Infotype screen 9210. Also modified existing SAP HR Time program under Disability Infotype that involves checking a certain IT2012 (Disability record) and populating new IT9210 record with the use of BDC. Provided assistance to onshore people as support whenever there are program testing related to SAP HR Time programs. Created an internal quiz tool for a project using VBA macro tool. Provided assistance to enhance existing Skill Inventory tool written in VBA macro. Provided assistance to Project Management tool used by both offshore and onshore project managers using VBA macro. Accenture Taguig, Philippines Sep 2011 – Oct 2011 Position Senior Software Engineer Project Type Wine manufacturing client/ SAP SD Roles SAP SD/MM Testing Responsibilities Conducts testing and execution of scripts prior to UAT. Accenture Taguig, Philippines Apr 2011 – Aug 2011 Position Senior Software Engineer Project Type Center Bench Roles Study and learn through online trainings. Participates in process & activities in Center Bench. Accomplishment Trained in SAP ABAP Bootcamp and was able to complete and successfully pass the final assessment for the program receiving a grade of 89. Completed required training based on Accenture standards. Involvement in Center Bench administration as a training coordinator. Ortigas & Co., Lmtd. Partnership Pasig, Philippines Jun 2009 – Apr 2011 Position Senior Programmer Project Type Real Estate / IT Dept. Roles Develops and maintains in-house applications & reports. Debugs applications whenever necessary. Supports SAP data migration. Responsibilities Developed an internal website application called Property Helpdesk Management System. This application keeps records of tenant requests in form of job/service orders. It helps to monitor pending job/service orders and the quickness of response time of building administrators. Developed an SMS application as a support to Property Helpdesk Management System. It has a GSM modem that sends information regarding job/service orders to building administrators each time a job/service order has been encoded by building administrator assistants. Enhances a middleware program that collects raw data from a timekeeping device and converts it to a CSV file readable by a web application. Developed a billing report via internal web used in monthly billing for Greenhills Shopping Center tenants. Developed an online Employee Opinion Survey to aid the Human Resources Department’s need to conduct a yearly survey for employees. Prepared scripts for data migration to SAP. Provided support to legacy systems. Infomax Systems, Solutions & Services Makati, Philippines Apr 2008 – Jun 2009 Position Software Developer Project Type Development/ Software Products Roles Develops and maintains company product for clients and in-house applications Debugs applications whenever necessary Responsibilities Added a report function to the company’s main product, InfoCapture; a software that can capture character by using OCR technology to scan documents. Indexed data are stored in a database for easy searching and retrieval of documents. Worked on the revision of an Image Viewer called InfoView; a software which enables users to access/retrieve scanned images/documents easily. Also added new functionalities such as allowing user to send images via fax, email and retrieve images in zipped format. Worked on Human Resources system using C# ASP.NET with Web Service. Worked on software called CD Viewer; a portable, non-install software that allows exported CSV and images from the InfoCapture software to be viewed on a local machine with an easy search function and image viewer. Worked on software capture lite version via Web Application written in C# ASP.NET. Debugs the main product (InfoCapture), create new functionalities and enhancements. Empire East Land Holdings, Inc. Makati, Philippines May 2004 – Feb 2008 Position Junior Programmer Project Type Real Estate – MIS Dept. Roles Develops and maintains in-house applications & databases. Provides general evaluation & testing for developed applications. Provides training & demonstration for the end-users regarding developed applications. Deploys system for use. Follow-up and debug the system whenever applicable. PC Troubleshooting Responsibilities Development of following systems: Sales Inventory Real Estate & Treasury Timekeeping Buyer’s feedback & Customer Care Service Payroll Construction Site Worker Charging Management Seminars & Trainings Attended Topic: 5s Year Attended: 2006 Topic: Writing Effective Business Letter Year Attended: 2008 Topic: Corporate Image Enhancement Year Attended: 2009 Topic: Introduction to JAVA Year Attended: 2010 Topic: Introduction to ABAP SAP Year Attended: Oct. 2010 Topic: SAP ABAP Bootcamp Duration: 1 Month Year Attended: May 2011 Topic: SAP ABAP HR Duration: 5 Days Year Attended: Aug 2011 Topic: SAP ABAP Advance Programming Duration: 4 Days Year Attended: Dec 2011 Educational Background and Credentials College University of the East -) Claro M. Recto Avenue, Metro Manila Bachelor of Science in Computer Science April 20, 2004 Tan Yan Kee Scholar High School University of the East -) Claro M. Recto Avenue, Metro Manila March 2000 4th Honorable Mention (2nd Year) Elementary Mater Carmeli School - D. Tuazon Avenue, Quezon City March 1996 Deportment Awards (Grades 1, 2 and 6) Personal Details Date of Birth: May 30, 1983 Place of Birth: Sta. Cruz, Manila Age: 41 years old Gender: Male Civil Status: Married Citizenship: Filipino Height:5’7 ft. Weight:153 lbs. SSS No.:- Tin No.:- Spouse: Ma. Christina B. Reyes-Gagani Children: Ezra Luna Mariquel R. Gagani Musika Tala Marie R. Gagani Isaiah Skylar Ritchie R. Gagani References Name Company Position Contact No. John Emmanuel Talon Hewlett Packard Enterprise Lead Technology Consultant - Bernadette Navarro Empire East Land Holdings, Inc. Supervisor – MIS- Franemil Ramos Empire East Land Holdings, Inc. AVP – MIS- Johanna Blacer Ortigas & Co., Limited Partnership IT Supervisor- Arturo Abad Ortigas & Co., Limited Partnership HR Supervisor-