JOSUE VAL VARGAS
Quezon City
Summary
Database management professional with solid track record in ensuring data integrity, optimizing performance, and maintaining complex databases. Strong in SQL, data modeling, and systems integration. Known for fostering team collaboration and delivering consistent results. Adaptable to changing requirements and highly dependable.
Experienced with database architecture, design, and management to support business operations. Utilizes SQL and data migration techniques to enhance system performance and integrity. Track record of leading database projects, showcasing strong understanding of data modeling and team collaboration.
Overview
26
26
years of professional experience
Work History
Database Manager
Traxion Tech Inc.
03.2024 - Current
- Managed database systems to ensure data integrity and optimal performance.
- Developed and implemented data management protocols to enhance security and accessibility.
- Analyzed complex datasets to support business decision-making processes.
- Streamlined database operations, improving response times for user queries.
- Collaborated with cross-functional teams to identify database requirements and solutions.
- Implemented BI solution framework for business intelligence projects.
Database Manager
Traxion Tech
03.2024 - Current
- Managed database integrity and security protocols to ensure data accuracy and compliance.
- Developed and implemented data backup strategies, enhancing disaster recovery processes.
- Optimized database performance through regular monitoring and troubleshooting techniques.
- Trained junior staff on database management best practices, fostering team knowledge sharing.
- Maximized resource utilization through capacity planning initiatives that identified opportunities for consolidation while maintaining service quality standards.
- Supported application developers during integration efforts by providing guidance on optimal schema designs and query optimizations that improve overall system performance significantly.
Technical Configuration Analyst
Hammerulo
04.2023 - 12.2023
- Analyzed configuration data to identify discrepancies and improve accuracy across systems.
- Developed and maintained comprehensive documentation for system configurations and processes.
- Collaborated with cross-functional teams to ensure seamless integration of configuration changes.
- Assisted in troubleshooting technical issues related to configuration management tools.
ETL Developer
Collabera
08.2022 - 01.2023
- Build workflows or processes from client requirements, through coding, testing, and documentation.
- Map source system data to the data warehouse, data marts or operational data store models.
- Collect, cleanse, and transform raw data based on business requirements, and load the data-to-data warehouses or a storage facility.
- Develop and test extraction, transformation and load (ETL) processes.
- Define and capture metadata and rules associated with the ETL processes.
- Adapt ETL processes to accommodate changes in source systems and new business requirements.
- Communicate status and respond to questions in a clear and timely manner.
Sr. Database Consultant
MacroIT Solutions
01.2018 - 08.2022
- Developing, testing and deploying SSRS reports to production environments
- Communicating with report consumers and other stakeholders to elicit and document reporting requirements and propose appropriate solutions
- Developing reporting requirements and obtaining sign off from business stakeholders
- Designing and developing report mock-ups and prototypes
- Provide Level 2 support and fulfilment of service requests for reports, acting as the primary escalation point for the Service Desk
- Develop and maintain operating procedures and support documentation for reports and the SSRS infrastructure Proactively engage on continuous improvement efforts for SSRS reports and their operation
- Work with the business analysts to identify and understand source data systems.
- Map source system data to the data warehouse, data marts or operational data store models.
- Develop and test extraction, transformation and load (ETL) processes.
- Define and capture metadata and rules associated with the ETL processes.
- Adapt ETL processes to accommodate changes in source systems and new business requirements.
Database Consultant
QuadIT Solutions
01.2016 - 01.2018
- Developing, testing and deploying SSRS reports to production environments
- Communicating with report consumers and other stakeholders to elicit and document reporting requirements and propose appropriate solutions
- Developing reporting requirements and obtaining sign off from business stakeholders
- Designing and developing report mock-ups and prototypes
- Provide Level 2 support and fulfilment of service requests for reports, acting as the primary escalation point for the Service Desk
- Develop and maintain operating procedures and support documentation for reports and the SSRS infrastructure Proactively engage on continuous improvement efforts for SSRS reports and their operation
- Work with the business analysts to identify and understand source data systems.
- Map source system data to the data warehouse, data marts or operational data store models.
- Develop and test extraction, transformation and load (ETL) processes.
Systems Analyst/Project Manager
Cravings Group
05.2012 - 01.2016
- Lead all the execution of technology strategies and provide IT solutions to business problems in order to achieve the company’s aim to establish operational efficiency
- Maintain close coordination with suppliers to ensure smooth operation and successful implementation of new projects, software/hardware purchase & its warranty and the deployment of system applications
- 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.
- Work as a team member with other technical staff, such as networking to ensure connectivity and compatibility between systems.
- 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.
- Other duties as assigned.
MIS Manager
Ubix Corporation
08.2011 - 02.2012
- Lead all the execution of technology strategies and provide IT solutions to business problems in order to achieve the company’s aim to establish operational efficiency
- Ensure network connectivity of all servers, workstations, telephony equipment and other network gadgets/appliances
- Responsible in the direction setting for the MIS Department including setting of priorities, coordinating, and reporting of department activities
- Project planning and execution of various system applications in the company (such as but not limited to: SAP/R3,VPN, Windows Server, MS SQL, POS, IPCAM, HRIS Payroll and Accounting systems)
- Maintain close coordination with suppliers to ensure smooth operation and successful implementation of new projects, software/hardware purchase & its warranty and the deployment of system applications
- Oversee system troubleshooting, database backups , network connections, data archiving, system upgrades, disaster recovery and provides expert support when necessary
- Manage servers, work stations, remote terminals, including database, emails, copier/printers (MFPs) and backup servers and their associated operating systems and software
- Responsible for all security aspects of the company—physical and software; and establish security policies and procedures
- ISO Documentation of procedures on system installations, configuration and user’s manual
- Perform miscellaneous job related duties as assigned
Office-In-Charge IT
Andok’s Litson Corporation
07.2006 - 09.2011
- Maintain and Administer Andok’s Web Portal
- Maintain and Administer BlackBerry Enterprise Server
- Administer MSSQL 2005/MySQL Databases
- Monitor Point Of Sales (BackOffice)
- Maintain/Manage/Administer SAP Database and Application
- Maintain Existing Payroll Database and Application (Foxpro)
- Technical Consultant, Payroll System (New)
- Maintain/Manage/Administer HRIS
- Create necessary reports
- Symantec Backup Exec 12 Administration
- Watchguard
- NetApp Administration
- MS Exchange Administration
- Budget Preparation
- Project Management
Computer Programmer
Maria L. Eleazar Memorial District Hospital
01.2002 - 07.2006
- Maintain Existing System
- Develop New System
Programmer
Banco San Juan
01.2001 - 07.2001
- Develop new system for the bank.
- Maintain the system developed.
- Train end users.
Programmer/Analyst
SUPERB Security Agency
12.2000 - 06.2001
- Designed System Flow of HRIS
- Develop new HRIS for the Agency.
- Train end users.
Programmer/Analyst
DATAMAG Systems, Inc. (Andok’s Litson Corporation)
03.2000 - 09.2000
- Develop new system.
- Maintain existing system.
- Train end users.
Education
PHP Programming (Basic) -
Informatics – Cyberzone – SM North – EDSA
02.2008
SAP Business One Basic Course - undefined
Mapua Institute of Technology
06.2007
BS - Computer Science
University of the East – Manila
01.2000
Skills
- Proficient in developing integrated systems
- Skilled in reporting tools and SQL databases
- Customer support
- System monitoring
- SQL proficiency
- Query optimization
- Backup and recovery
- Data migration
- Database design
- ETL processes
- Database security
- Relational databases
- Database administration
- Performance tuning
- Data warehousing
- Business intelligence
PERSONAL BACKGROUND
I was born on November 22, 1977 in Lopez, Quezon, stand 5’7” and weigh 154 lbs. I can speak English and Filipino. A Roman Catholic and still Single.
Timeline
Database Manager
Traxion Tech Inc.
03.2024 - Current
Database Manager
Traxion Tech
03.2024 - Current
Technical Configuration Analyst
Hammerulo
04.2023 - 12.2023
ETL Developer
Collabera
08.2022 - 01.2023
Sr. Database Consultant
MacroIT Solutions
01.2018 - 08.2022
Database Consultant
QuadIT Solutions
01.2016 - 01.2018
Systems Analyst/Project Manager
Cravings Group
05.2012 - 01.2016
MIS Manager
Ubix Corporation
08.2011 - 02.2012
Office-In-Charge IT
Andok’s Litson Corporation
07.2006 - 09.2011
Computer Programmer
Maria L. Eleazar Memorial District Hospital
01.2002 - 07.2006
Programmer
Banco San Juan
01.2001 - 07.2001
Programmer/Analyst
SUPERB Security Agency
12.2000 - 06.2001
Programmer/Analyst
DATAMAG Systems, Inc. (Andok’s Litson Corporation)
03.2000 - 09.2000
SAP Business One Basic Course - undefined
Mapua Institute of Technology
BS - Computer Science
University of the East – Manila
PHP Programming (Basic) -
Informatics – Cyberzone – SM North – EDSA