Junn Brian Jason T - Emmanuel Casilang
|Emmanuel L. Casilang | |
| | |
|181 Leo St., Villarica Subd. Cainta, Rizal | |
|Home : N/A | |
|Mobile : +63 977 1273880 | |
|E-mail : EmmanuelCasilang@ | |
|Website: emmanuelcasilang. | |
| |
|SUMMARY OF QUALIFICATIONS |
| |Adobe Photoshop, Macromedia Flash, Windows Movie Maker, Magento, Wordpress |
|Application: | |
|Languages: |PHP, JavaScript, HTML, CSS, Coldfusion, VB6, C/C++, Joomla |
|Platforms: |Windows 7/XP/2000/98, Linux |
|RDBMS: |MySQL , MSSQL, PostgreSQL, MS Access |
• An experienced software engineer, database administrator, and web designer.
• Currently a freelance programmer / consultant (accepting contract based project, software/database/web design consultation)
|WORK EXPERIENCE |
| |
|(August 2017 - Present) |
|Freelance Programmer / Consultant. |
|Home Based |
|Construction Projects Management System. |
|Magento Shopping Website. |
|Wordpress Websites. |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
|(February 2014 – July 2017) |
|Consultant |
|Jollibee Foods Corporation |
|Pasig City |
| |
|Job Designation: |
| |
|Engineered the Forecasting System (“SDOQ” Store Default Order Quantities) of the “Store Web Ordering System” (SWS) based on |
|historical data. The said system is currently being used by Jollibee, Chowking, Greenwhich, and Mang Inasal. |
|Developed and automated several tools that solved the issues encountered in their Web Ordering Operations. 1.) Duplicate Order |
|Filtering 2.) Delivery Frequency Checker 3.) Late Order Monitoring. |
|Fixed major/minor system bugs. Organized the Store Grouping. Added database input validation. Removed null password flag. |
|Implemented Lead Time (scheduled) Tasks. |
|Improved the overall performance of the Web Ordering System (SWS) through efficient coding and database management. Generated Sales|
|Order Files in a few seconds. Archived old database records. |
|Migration of the Web Ordering Systems’ database record to accommodate the transition of the Operations Management Systems from |
|Oracle to SAP. Also added new features in the SWS system to offset functions previously done in Oracle. |
|Provided documentation for the new modules/tools/features developed. Documentation includes flowcharts, screenshots, links, and |
|troubleshooting method, depending on guide classification (User Manual / Admin Manual). |
|Supported the system users. Educate the Order Management team on lead time ordering computation based on store group (and item |
|class ordered by stores). On-the-spot solutions to Pinnacle Warehouse Projects/Issues (Peak Season). |
|Implemented Project Giant in the Ordering System. This helped the Order Management to address a large volume of increase of store |
|orders during peak season (November and December, 2014). |
|Integrated Project Shield in the Ordering System. A special loading of forecast based on the pre-computed orders done by BSIE |
|(Business Solutions Industrial Engineer) to address supply and delivery concerns during peak season 2015. |
|Created a module to modify and upload weight and volume (minimum and maximum) allowable orders “Project Jedi”. This helped the |
|Logistics with their daily trucking delivery schedules and operations. |
|Added a table reference with running balance for the implementation of the weekly and daily capping. This helped the Purchasing |
|Department to allow only a certain kind of items to be ordered when there is a limited supply. |
|Developed the Order Blocking and Unblocking. This helped the Finance Department to collect fee from unsettled balance from previous|
|orders, before allowing the stores to make additional future orders. |
|Initiated the creation of PG Item Analyzer Tool LJCF to help the Order Management and the support team with regards to the |
|visibility of any items of any SBU (Jollibee, Chowking, Greenwhich, Mang Inasal, and Red Ribbon). |
|Database migration from SQL ASCII postresql 8.1 (EC2 server) to UTF 8 postgresql 9.5 (RDS server) in parallel to the Coldfusion to |
|Railo application switch over. This enable the application load balancing to be implemented without license cost. |
|Automation of email sending of active Jollibee items for the Data Management team. Also provided a link for them to view and export|
|the data manually in case there is an email issue or network problem. |
|Analyze the requirements, timing, and execution dates for the lead time changes of the stores. This helps ensures that the forecast|
|and lead time is in parallel run to avoid errors and issues. |
| |
|Pioneered the loading of the Red Ribbon FCPO data into the Ordering System. This is based on the raw materials available during Red|
|Letter Days. Also knowledge transfer the procedure to the IBM support team. |
|Investigated and provided root cause analysis and solutions, to the inquiries and issues encountered by the stores, and Order |
|Management, both in application and database level. |
|Guided the support team in handling the issues and concerns raised by the stores and other users of the systems like Purchasing and|
|Order Management. Also provided them with several tools to serve the needs of the users. |
|Lead the technical execution and implementation of Project UOI (Unit of Issuance) initiated by BSIE (Business Solutions Industrial |
|Engineer) to implement multiples of ordering by the stores. |
|Added a feature to tag an order as manually uploaded to SAP, to ensure that the EPO (electronic purchase order) will still be |
|available for the stores to download. Also allows multiple orders to be tagged as uploaded via special handling. |
|Injected an Order Number Mapping to assists the stores in verifying their orders in case the PO and DR have a mismatch. This |
|ensures that orders can be validated and tallied using the Old and New order numbers. |
|Verified and checked the queries done by the support team to serve the request of the Order Management team, to ensure that queries|
|will run without error and avoid potential impact to the system. |
|Checked and loaded Project Armor, for Jollibee and Chowking stores, with data provided by BSIE (Business Solution Industrial |
|Engineer) to reserve the orders of the stores, and ensure deliveries for peak season (November and December 2016). |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
|(September 2013 – January 2014) |
|Freelance Developer |
|Home Based |
|PHP projects. |
| |
| |
|(October 2012 – August 2013) |
|Systems Developer |
|Primer Group of Companies |
|Malate Manila |
| |
|Job Designation: |
| |
|Fix bug issues both front-end and back-end, upgrade outdated versions of Joomla and configure existing modules to work with the |
|update, enhance response time and increase feed limit, and redesign the existing web based system used by the company (The Portal).|
|Gives new user access to The Portal and modifies existing users’ access rights by request. |
|Developed the Vendor Creation Validation (VCV) to validate the vendors created. Compares data (real-time) from two different |
|servers with varying database structures (MSSQL) under several Small Business Units (SBUs). Includes search (id, name, tin), date |
|range (report coverage), vendor selection (specific, all), column sorting (any field), and export to excel (filename based on |
|selected information). |
|Created the Concession/Consignment Report for concession or consignment sales. Will generate only the approved sales of the |
|selected reports. Includes user access login, date range selection, specific report selection, “Add To List Feature” (depending on |
|report selected) a list of different sites, regions, brands, or companies will be available that can be added to generate reports. |
|Also includes dynamic column display, export to excel, and monthly/yearly sales comparison. |
|Modified the “Paper Bag” to “Knowledge Bank” used for file management. It is used to upload, download, and view company files. |
|Includes user login, upload files (super users), category selection, multiple file upload, view uploaded files (associates and |
|managers), download files (managers), send feedback or request, define user access rights (super users), and create categories |
|(super users). |
|Made the Salesman Productivity Report for concession or consignment sales only. It is used to generate report regarding the |
|productivity of each salesman for the specific date covered. Includes LDAP (Lightweight Directory Access Protocol) login, inclusive|
|date range, company report selection, and export to excel. |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
|(November 2010 – September 2012) |
|Freelance Developer |
|Distribution and Control Products Inc. |
|Mandaluyong City |
| |
|Created the company’s website and support/maintain it. |
|Clean client PC from virus and added additional security. |
| |
|(July 2009 – October 2010) |
|Regular Systems Engineer |
|Allied Banking Corporation |
|Makati City |
| |
|Job Designation: |
| |
|Developer for Centralized Client System |
|(Allied Bank is currently using this system which contains confidential information regarding all the clients of the bank and their|
|respective accounts) |
|Analyze user requirements (Analyze the needs of the users of the Centralized Client System from different departments like |
|[Checking And Savings Account Department, Loans Department, Trust Department, Remittance Department, Treasury Department, and |
|Special Assets Department] through electronic and personal communication.) |
|Enhance and maintain existing modules and develop new requirements (Enhance both the frontend and the backend of the existing |
|system. Decrease the time spent for storing/retrieving data using efficient coding, develop new requirements by adding additional |
|features and functionalities of the system as needed/requested by the users and as approved by the management. Creates an updated |
|manual for the system for every additional modules/functionalities/features integrated, and gives hands-on training on how to use |
|the added/altered features) |
|Provide user support (Provides support and solution for the system users from different Allied bank branches all over the |
|Philippines regarding technical problems and/or familiarity with the use of the Centralized Client System through phone call, |
|email, or mail.) |
|Technologies: PHP/HTML/JavaScript/CSS/ Perl /PostgreSQL/PL-SQL |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
|(October 2008 – January 2009) |
|I.T. Instructor |
|AMA Computer College - Pasig |
|Pasig City |
| |
|Subjects Handled and Topics Discussed: |
| |
|Operating System and Network Administration (Different Microsoft Operating Systems, Primary Network Components, Network Resource |
|Access, Network Topologies, OSI Networking Model and its layers, etc.) |
|Web Development (Parts of the HTML codes, Creating Paragraphs, Linking Web Pages, Creating Lists, Inserting Pictures, Creating |
|Tables, Importing Images and Creating Image Links, Spanning Rows and Columns, Creating Framesets, Creating a Calendar, Creating a |
|BINGO card, Creating a personal website called “MyFrienster” – fully functional with Home Page, Profile, Pictures, Shoutout, |
|Friends, and Applications, etc.) |
|Java Programming (Basic Steps in Writing, Compiling, and Running a Java Program, Displaying the Square Root of a Number in Both |
|Java Application and Java Applet, Java Numeric Data Types, Getting Input in Both JOptionPane and BufferedReader, Mixing the |
|Input/Output of Both the JOptionPane and BufferedReader, Adding Two Numbers Given by the User – Using Conversion from String |
|Variable to Numeric Variable – Both in JOptionPane and BufferedReader, Create a Java Applet that Computes the Total Grade of the |
|Student for the Whole Trimester, Using Loops – Do Loop, For Loop, and While Loop, Using Arrays – String and Numeric, Create a |
|Calculator Program in Java Applet, etc.) |
|Assembly Language (Number System Conversion, Steps in Writing, Assembling, Linking, Testing, and Running a TASM Program, Create a |
|Program that Displays the Sentence “Hello, world!” in Microsoft Turbo Assembler, Daily Maintenance Summary Checklist, Getting an |
|Input and Using a Conditional Statement in TASM, Getting an Input and Displaying It, Getting Multiple Inputs and Displaying Them, |
|Breaking Down Each Line of Codes and Identifying the Basic Elements, TASM GRAPHICS – Produce different colors using the binary |
|number system and place them in a specific row and a specific column in the screen, etc.) |
|Information Technology Hardware and Software (Overview About Computer Troubleshooting, Power On Self Test beep codes for AMI and |
|Phoenix BIOS, Computer Hardware Troubleshooting, Computer System File Manipulation, Computer Software Troubleshooting, Computer |
|Hardware, Software, Assembled a Central Processing Unit – CPU, etc.) |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
|(January 2008 – April 2008) |
|I.T. Support |
|Izone Technologies Inc. |
|Pasig City |
| |
|Tasks and Accomplishments: |
| |
|Created the “Freedownloadzone Call Recording Tracker” and “MP3 Tracker”. Also created an “Automatic Database Extractor” and other |
|program used to manage the usernames, passwords, and records of the database used in the given company |
|Monitor and troubleshoot system network errors (Network Traffic, Test Calls, Reports, Screenshots, etc.) |
|Maintain the stability of the software systems used in the company (Security Access, Virus Scans, Software Updates, Downloads, |
|etc.) |
|Conduct research and provide solutions regarding computer issues both software and hardware (Automation, Dual Boot, Installations, |
|Storage Capacity, Compatibility, Windows Restrictions, Hard Disks, Monitor, etc.) |
|Provide support and assistance to agents and staffs by providing solution and information to different technical issues (Server |
|Connection, Recording and Transferring Calls, Customer Problems, Internet Connection, Local Connection, etc.) |
| |
|2003 - 2007 |
|Freelance Programmer |
| |
|Accomplishments: |
| |
|Created the “Automated Bus Ticketing System” database software; Software used: Microsoft Visual Basic and Microsoft Access |
|Taught Java Programming (Principles of Compiler Design) in Cainta Catholic College; Software used: Java Development Kit |
|Conducted Seminars like Java Programming and Structured Query Language (SQL) in Sienna College, Taytay; Software used: Java |
|Development Kit and Microsoft Access |
|Lead the creation and presentation of “National Service Training Program” (NSTP) Introduction Software ; Software used: Adobe |
|Photoshop De Luxe, Sound Recorder, and Powerpoint |
|Created several computer games like “Critical Strike”, “Arsenal”, “101”, etc.; Software used: Microsoft Visual Basic, Adobe |
|Photoshop De Luxe, and Sound Recorder |
| |
| |
| |
| |
| |
|EDUCATION |
| |
|College: Average = 1.4 |
|B.S. Computer Science |
|Cainta Catholic College |
|Cainta, Rizal |
|Chess Varsity Trainer |
| |
| |
|Highschool: Graduated as Valedictorian |
|Highschool Diploma |
|Wesleyan Academy |
|Cainta, Rizal |
|Leadership Award |
|Best in Math, Science, English |
|Citizen Army Training (CAT) Corps Commander |
|Chairman of Student Legislative Assembly |
| |
| |
| |
| |
| |
REFERENCES:
1.) Mr. Richard Santarin – Jollibee Foods Corporation Research & Development Manager
Mobile: +63 908 886 4193
2.) Mr. Erwin Tan – Primer Group of Companies Project Manager
Mobile: +63 917 803 6988
3.) Ms. Shenna Fajardo – Allied Banking Corporation Junior Assistant Manager
Mobile: +63 922 809 1851
4.) Mr. Junril Berame - AMA Computer College Officer-In-Charge Dean
Mobile: +63 916 446 5596
5.) Dr. Joel C. Javiniar - Cainta Catholic College VP for Academics / College Dean
6.) Mrs. Cecilia C. Cerezo - Cainta Catholic College Registrar
Cainta Catholic College Tel No.: 248-2788/248-1871
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.