RHEA MAE T. ATREGENIO
Blk **, Lot **, Ayala Altaraza SJDM Bulcan City
****************@*****.***
TECHNICAL SKILLS
Database System:
Oracle 11.3.0, SQL Server 2000/2005/2008/2016, MySQL, MS Access 2003/2007, PostgreSQL, PGAdmin4, AWS Redshift, S3 Bucket
Applications:
Unix Shell, JIRA, Toad, Putty, VMware, Virtual Box, Syncsort, DMExpress Server, Hadoop, Sqoop, Apache Flume, Hive, Rest API, Streamline, Redmine Tracker
Languages:
UNIX Shell scripting, C, C++, VB 6, VB.Net, Perl, HTML, PHP, Java, Python, R language
Operating System:
RHEL 6.0, Centos 7, Windows XP/Vista/7/10
PROFESSIONAL PROFILE
Junior Managed Services Engineer Nasc Technologies April 2018 – Present
-Systems Analysis & Technical Configuration
-Training and Support
-Reports Management
Big Data Specialist Firstmac Service Centre October 2017 – February 2018
-Develop reporting solutions to support Business Intelligence gathering, including resolving problems with data analysis and reporting services.
-Build and maintain data pipelines, stream processing system and construct complex queries using SQL
-Performed adhoc report extraction
-Write UNIX shell scripts to execute ETL programs
-Analyze the data in the source to look for data quality problems and write code to fix data quality issues or create code to log those errors for reporting needs.
-Performed data analysis as per the project requirements.
-Performed data analysis of Firstmac website, Facebook and Twitter page using R language - Monitor, maintain and troubleshoot ETL programs
Software Development Analyst Smart Communications, Inc June 2015 – July 2017
Production Support Development/Analyst
-Monitors data fix processes at the back end of the billing system.
-Investigates subscriber billing concern and immediately provides solutions to them effectively.
-Provides continuous enhancement on the existing data fix processes if necessary.
-Validated the daily and weekly status report of resources.
-Performed daily health check routines for the following elements:
a.Oracle database
b.Data backup
c.Data storages
Billing Configuration Development/Analyst
-Handles bill format configuration module for billing statements.
-Investigates bill format concerns and provides appropriate solutions to it effectively.
Software/Project Development
-Handles software development, testing, deployment and maintenance several projects involved (examples: postpaid billing promos, long term report extraction, adhoc report extraction, usage concerns, billing related concerns).
-Supports in the deployment of solution.
-Attended the weekly and monthly meeting
-Created a program that can monitor the status of processing for Smart/SUN postpaid billing.
-Monitor, maintain, troubleshoot, analyze and restore billing service downtime
-Created programs that automate the extraction of daily/monthly/yearly income of Smart/Sun partnership.
-Created a program that can monitor the CDR (Charging Detail Record) generation of Billing. This was used to monitor the pending CDRs in the database and the status of transfer to the application.
-Automates the following manual processes:
a.Monitoring tools of application and database management
b.Transfer of files to dump servers
c.Loading of data to database
EDUCATION
Bachelor’s Degree:
Our Lady of Fatima University, Quezon City Campus.
Bachelor of Science in Information Technology June
2010 – April 2014
ACHIEVEMENTS/HONORS
Scholar of Manny V. Pangilinan
SMART scholarship program
March 2010
Consistent Scholar for 3 years
Our Lady of Fatima University, Quezon City
March 2010 – 2013
Best in Physics
Paradise Farms National High School
San Jose Del Monte, Bulacan
March 2010
MVP in Volleyball
Our Lady of Holy Rosary Academy
S.Y. 2006-2007
CHARACTER REFERENCE
Mr. John Kendric Choa
Supervisor, Smart Communications, Inc
Mr. Jay Carlo Gomez
Supervisor, Smart Communications, Inc
Mr. Kelly Tsai
Senior Software Dev, Smart Communications, Inc