Developer Data

JERSON BAJARIAS SERAD

SQL Database Developer II

Block 5, Lot 15, Veneranda Homes Subd., Yati, Liloan, Cebu

(+63)925-***-**** / (+63)956-***-****

*********@*****.***

***********@*****.***

www.linkedin.com/in/jerson-serad- 905393100/

SKILLS

• Knowledgeable in Network Configuration (LAN Technology), Hubs, Routers, software and hardware installation and repair

• In-depth experience in ASP.Net, Vb.Net, C#.Net, Crystal Reports, SQL Reporting Services, MySQL, SQL Server, Microsoft Access, CSS, JavaScript, SAP Basis, Systems QA, Testing & Support

• Experience using C, C++, Java, Delphi, Tableau, SSIS

• Typing proficiency: 40 – 60 wpm

CAREER SUMMARY

• Current SQL Database Developer responsible in creating new codes and modifying existing procedures that best suits the user requirements.

• Former SAP Basis responsible in implementing,

configuring, monitoring, tuning, and troubleshooting the SAP technical environment as well as scheduling and executing the SAP transport system.

• Five years of software application developer experience with a broad range of computer expertise.

• Experience in designing and integrating software applications as per the requirements of the clients, in the required time.

• Six consecutive years as computer instructor with thorough understanding in designing and delivering student learning activities integrated with software and hardware applications.

• Strong leadership and management skills.

• Self-motivated, team player and enjoys exploring, expanding, and learning new things and to be challenged. EXPERIENCE

PMAXGlobal – Philippine Branch SQL Database Developer II December 2018 – Present

• Identify areas for database schema and code improvement

• Develop reports in Crystal Application

• Coordinate with Reports Developers in visualizing the reports to be created

• Modify/create SSIS packages and ETL scripts for existing and new systems Projects/Tasks Accomplished:

• MaxContract (On-going)

- This project is use to determine the variance between the billed charge and contractual adjustment against the contract allowable amount for a specific procedure o Fetch data from a source database and stores it in the data warehouse for reporting purposes

Development Tools: SQL Server

• ServiceTrac Survey Response ETL Enhancement (5 months)

- This project ensures that ETL runtime execution will be faster o Fetch data from a source database and stores it in the data warehouse for reporting purposes

Development Tools: SQL Server

• ServiceTrac User Management Automation (3 months)

- Automates data gathering and creation of ServiceTrac Users o This project fetches users’ data from source database to the data warehouse without any user-interventions involved

Development Tools: SQL Server

PMAXGlobal – Philippine Branch SQL Database Developer – SME October 2018 – December 2018

• Participated in technical working groups to assist in identification of issues and development of solutions for the SQL Server Database system

• Developed SQL stored procedures, SSIS packages, Crystal, Tableau, SSRS Reports

• Reviewed scripts developed by colleagues prior to implementation

• Support tickets in-charge

PMAXGlobal – Philippine Branch SQL Database Developer I October 2017 – October 2018

• Developed reports in SQL Server Reporting Services, Crystal, Tableau

• Identify and write best possible codes in case of new deployments or when rewriting codes when migrating to newer version of SQL Server

• Participated in discussion involving the application creation and understand the requirements and provide the back-end functionality for the applications.

• Modify/create SSIS packages and ETL scripts for existing and new systems

• Fix any issues related to database performance and provide corrective measures

• Helped write and optimize in-application SQL statements Projects/Tasks Accomplished:

• Over-all enhancement of rePortal reports (4-5 months)

- This project reduces the time execution of each report when processing for top management needs o Generate an automated monthly report (Summary, Charges, Ledgers, etc.) and on-demand reports then exported it as .pdf files

Development Tools: SQL Server, Crystal Reports

• Client (SPN) Data Feeds (1 month)

- This task allows the client to view reports on a day-to-day basis o Generate daily reports (Charges, Ledgers, Aging, etc.) that exported data from Database to .csv files

Development Tools: SQL Server, SSIS

• Enhancements of AllScripts ETL (4 months)

- This project improves the ETL execution runtime / reduces processing time from 17 hours to 2 hours o Fetch data from different source databases and stores it in the data warehouse for reporting purposes

Development Tools: SQL Server

Carmen Copper Corporation SAP Basis / Software Quality Assurance September 2016 – October 2017

• Implemented and maintained the multiple SAP instances that comprises the SAP environment (DEV, QAS, PRD)

• Checked SAP system up & running

• Checked all backup operation results

• Monitored all SAP systems (work processes, users, system logs, short dumps, locks, disk space etc.)

• Managed SAP roles, users, authorizations and Transaction codes, profiles, requests and transport

• Prepared test plans based on business requirements

• Prepared test scripts and test scenarios based on test plans and prioritize testing activities

• Read all the documents and understand what needs to be tested

• Based on the information procured, decide how it is to be tested

• Executed all the test cases and report defects, define severity and priority for each defect

• Maintained effective communication with the Dev Team Lead on project limitation, capability, performance requirement and hardware interface changes.

• Performed end user support to all application systems. Carmen Copper Corporation Software Application Developer February 2011 – September 2016

• Maintained high standards of software quality within the team by establishing good practices and habits.

• Collaborated with other software developers, business analysts and database administrator to plan, design, develop, test, and maintain business applications.

• Prepared reports, manuals and other documentation on the status, operation and maintenance of software.

• Designed, developed, and unit test applications in accordance with established standards.

• Developed, refined, and tuned integrations between applications.

• Analyzed and resolved technical and application problems.

• Assessed opportunities for application and process improvement and prepare documentation of rationale to share with team members and other affected parties.

Applications Developed:

• Office Supplies Management System

o Preparation of material reservations

o Electronic Approval

o Audit logs and auto-messaging via Microsoft Outlook o Generate reports such as Material Reservation, Status Report

• Development Tools: C#.Net, SQL Reporting Services, and SQL Server

• Timekeeping System

o Monitoring of schedules, tardiness, leaves, overtime, absences, etc. o Imports live data from biometric fingerprint device to the database o Audit logs and auto-messaging via Microsoft Outlook o Generate reports such as Job Time Card, schedules, tardiness, leaves, overtime, absences, etc.

• Development Tools: C#.Net, SQL Reporting Services, and SQL Server

• Biometric Log Report

o Monitoring of employee logs

o Imports live data from biometric fingerprint device to the database o Generate log reports

• Development Tools: C#.Net, SQL Reporting Services, and SQL Server University of the Visayas – Main Campus Computer Instructor June 2005 – February 2011

• Handled basic and advanced computer subjects such as Fundamentals of EDP Concepts, Flowcharting, Visual Basic 6.0/.Net Programming, PC Troubleshooting, Database Management System, Networking

• Evaluated students’ performance fairly and consistently and returned student works promptly to promote maximum learning.

• Developed and explained methods that fairly measure students’ progress toward student learning outcomes.

• Collaborates with Department Chairperson and faculty on curriculum planning and development. Trainings & Seminars Attended

Introduction to Advanced Analytics with

Azure Machine Learning

Cebu Parklane International Hotel

November 10, 2015

Interconnecting CISCO Networking

Devices Part I

University of the Visayas

May 18 – 25, 2010

3D Animation and Visual Effects using

Maya

Cedf-IT, IT Park, Apas Lahug, Cebu City

April 26 – 30, 2010

Personal Data

Date of Birth : September 28, 1983

Place of Birth : Cebu City

Civil Status : Married

Height : 5’3”

Weight : 58 kgs.

Religion : Roman Catholic

Education

College

Bachelor of Science in Information Technology University of the Visayas 2001 – 2005 Secondary University of the Visayas 1997 – 2001

Primary

University of the Visayas 1991 – 1997

Character References

Ms. Beverly T. Lahaylahay Mr. Gerald S. Manigos Mr. Virgilio R. Encabo Enterprise Reporting Analyst SQL Database Developer, IT Department SQL Developer, IT Department MTL Cebu Business Outsourcing Solutions Inc. PMAXGlobal – Phil. Branch Savvysherpa Asia, Inc.

+63-915-***-**** +63-927-***-**** +63-977-***-****

Contact this candidate