ELISEO JR. CAAYON JOPIA

• Own end to end solutioning and delivery of data transformation programs and initiatives to realize quick gains, while working with team stakeholders to bring the best tools and delivery methods
• Understanding client requirements, developing data strategy, architecture and solutions that meet client requirements
• Apply knowledge and explain the benefits to organizations adopting strategies relating the new solutions capabilities covering data supply chain, data governance and data ops
• Responsible for the data transformation from client’s raw ERP data to bring into the centralized data warehouse to create insights through data model ready for user’s consumptions
• Responsible for creating, modifying stored procedures and any CRUD related operation that need to be implemented as part of the solutions within SQL server RDBMS
• Implemented Meta(Facebook) and Google Analytics integration
• Responsible for documentation for the process using confluence
• Expert in using Hubspot and JIRA for project management and ticketing management
• Responsible for deploying changes into the tabular model
• Responds to all client’s issues and resolving them in a short turnaround time as possible.

• Leading and supervising BI developers ensuring that highest standards are met timely
• Advising, mentoring and supervising the project team in possible solutions to problems as and when they arise
• Reviewing projects deliverables for compliance with the company standards specifications to discuss with Architects for approval where required and to User Acceptance Testing where appropriate
• Primary point of contact in the administration, maintenance, support and other aspects of the development in the Microsoft Business Intelligence (MSBI) platform (Reporting Services (SSRS) and Analysis Services (SSAS) delivered through SharePoint
• Working closely with users from the Human Capital, Finance, IT, and Operations departments
• Develop, document and maintain existing and new applications and processes Problem resolution, system administration and development of business rules, system interface using tabular model interfacing with Power BI, SSRS and Excel Gather and document user requirements in a clear and organized manner Work with infrastructure team on application upgrades, patches and other system maintenance in a timely manner to ensure optimal performance and high system availability SSRS / SSAS Administration Creating SQL, MDX, and DAX SME scripts to be used in creating tabular model.

• Design, develop and execute software solutions to address business issues
• Provide architectural blueprints and technical leadership to our IT team
• Evaluate and recommend tools, technologies and processes to ensure the highest quality product platform
• Collaborate with peer organizations, quality assurance and end users to produce cutting-edge software solutions
• Interpret business requirements to articulate the business needs to be addressed
• Troubleshoot code level problems quickly and efficiently
• Manage, design database using SQL Server
• Design reports using SSRS and Crystal report
• Automate excel spreadsheet computation using VBA
• Successfully develop and implement several systems such as Customer and Sales Management System, Capacity Planning System, Returnable Box Barcoding System
• Leading the development and implementation of Human Resources Information System.

▪ Development of Project Implementation Plan. - Monitors the cost, calculate the number of resources for the project and deploy it for the project.

▪ Making sure financial transactions and reports are correct and in accordance with company policies. ▪ Understanding client requirements and responsible for a comprehensive strategy for achieving successful outcome of the project.

▪ Responsible for developing a good relationship with the respective clients, get inputs from the client and communicate to the team members of the project.

▪ End to End management and co-ordination of the project and responsible for the successful completion of the project.

▪ Arrange all the facilities to the team who are working on the project, provide training, support and extract the best out of the team.

▪ Solve complex problems which arise in the project and responsible for the outcome and finish the project with great quality and on time.

▪ Design schedule for the project, and set time line for each member of the team and delegate specific task to each members of the project.

▪ Responsible for the timely completion and responsible in of the completion of the project within the stipulated budget.

▪ Predict risk factors and eliminate it for the successful completion of the project.

▪ Frequently reporting about the project to the clients on exactly about the progress of project, if it is laid down in the proposal.

▪ Implemented all module of EXACT ERP core system from scratch until finish for 1 Year that includes modules (Sales and Distribution, Material Management, Production Planning, Financial and Asset Management).

▪ Integrate vertical web solutions (EDI) and mobile and touch panel application.

• Services Philippines (Japanese - Casino Machines
• Manufacturing) Lot 1 Block 8 Millennium Drive Cor., Quality St., Light and Industry & Science Park 3, Brgy
• San Rafael Sto
• Tomas Batangas, Philippines Successfully implemented the ERP (Exact Globe Enterprise Suite in all department including Supply Chain Management, Sales, Production, Engineering and BOM, QA, Warehouse, Logistics and Finance and Accounting
• Provide management and user's reporting needs using crystal report
• Focal person on deployment of Intranet Sites of the company for user's need
• Provides oversight and guidance to project management team
• Facilitates and resolves project issue and problem (primarily focusing on those escalated outside of the core project team)
• Obtains required project resources when they are required and manages / resolves resources issues
• Manage and monitors the project budget, schedule and scope
• Supports Project Management Team in resolving issues / problems, mitigating risks, and otherwise supporting their execution of project activities
• Responsible for providing, selecting, developing and implanting standard methodologies, processes, templates and tools throughout the project / team
• Responsible for managing and supervising all project technical resources related to application development (including application customization and portal development), infrastructure for all application environments (Production, testing, training, etc.) and integration with other application / organizations
• Responsible managing and supervising all activities related to the deployment and operation of the production ERP solutions, including solution deployment and ERP Help Desk
• Responsible for ensuring the availability and integrity of all operation systems, server hardware, and related tools and services, to support all application environments (production, development, testing, trainings, etc.) Also responsible for maintaining the configuration for all environments
• Responsible for installation, administration and maintenance of Databases and managing any other data resources for all environments (production, development, testing, training, etc.)
• Responsible for leading, coordinating and tracking all project communication initiatives to ensure that information is disseminated in an accurate, consistent, effective and timely manner.

• Ensure the timely and accurate generation of all corporate internal reporting, consistency and standardization amongst the various types of reports and databases and manage the various reporting tools utilized by the company
• Analyze, interpret and report financial and operational performance trends from various channels & departments, identifying areas performing outside of expected results
• Develop efficiencies to increase the effectiveness of reporting and consolidate & maintain departmental reports used internally and externally such as to other departments, senior management, and Head Office staff and reporting units
• Develop and maintain new standardized metric reporting on a routine basis, i.e., define, create, automate, and maintain operational cyclical reporting
• Manage and own the reporting project management process to identify the needs, document requirements and obtain sign off from owner and coordination with Enterprise Data for implementation
• Active participation in the development of a data warehouse and subsequent reporting enhancements, including the creation of new reporting templates and analytical reports
• Maintain a reporting schedule and documentation of reporting procedures
• Generate and maintain control documentation of reporting procedures to comply with governance audits and regulatory requirements
• Will also build audit process to ensure data integrity and efficiency
• Perform ad hoc duties in accordance to business needs.

• Code, test and troubleshoot programs utilizing the appropriate hardware, database, and programming technology
• Maintain and modify programs; make approved changes by amending flow charts, develop detailed programming logic, and coding changes
• Test and develop programming modifications
• Confer with users to gain understanding of needed changes or modifications of existing programs
• Resolve questions of program intent, data input, output requirements, and inclusion of internal checks and controls
• Analyze performance of programs and take action to correct deficiencies based on consultation with users and approval of supervisor
• Program documentation of problems and resolutions for future reference.

• ERP (Exact Software Version 3.7) management, maintenance and configuration that includes: Sales Ordering, Costing, Manufacturing, Inventory and Accounting modules
• Manage and administer the whole computer system of the company
• Collect information to analyze and evaluate existing or proposed systems
• Research, plan, install, configure, troubleshoot, maintain and upgrade hardware and software interfaces with the operating system
• Analyze and evaluate present or proposed business procedures or problems to define data processing needs
• Prepare detailed flow charts and diagrams outlining systems capabilities and processes
• Research and recommend hardware and software development, purchase, and use
• Troubleshoot and resolve hardware, software, and connectivity problems, including user access and component configuration
• Select among authorized procedures and seek assistance when guidelines are inadequate, significant deviations are proposed, or when unanticipated problems arise
• Record and maintain hardware and software inventories, site and/or server licensing, and user access and security
• Install, configure, and upgrade desktop hardware and peripherals to include; network cards, printers, modems, mice and add-in boards
• Write and maintain system documentation
• Conduct technical research on system upgrades to determine feasibility, cost, time required, and compatibility with current system
• Maintain confidentiality with regard to the information being processed, stored or accessed by the network
• Document system problems and resolutions for future reference
• Design, implement and maintenance of the company's website
• Maintain and update the servers and workstation
• TCP/IP addressing, LAN and WAN Network Troubleshooting
• File Backup and File recovery
• Active Directory maintenance and configuration
• E mail configuration and maintenance using several email client software: MS Outlook, Windows Mail, Pegasus and Mozilla Thunderbird.

• Design and implement the Comparative Sales Report, Rental System and Check Releasing module. ▪ Maintain and manage servers and controllers in selling area and in Credit Department. ▪ Maintain server and all workstations in all departments in Manila branch.
• Maintain and manage all POS machines in selling areas.
• Repair and Troubleshoot Printer, Power Supply, Motherboards and any computer peripherals. ▪ PC Troubleshooting, Installation, Testing (Hardware and Software).
• WinDss Sales System maintenance and configuration.
• TCP/IP addressing, LAN and WAN Network Troubleshooting.