Unix Developer
Lentus Solution Inc.
Total years of experience :8 years, 9 Months
• Production support of BIDW(Business intelligence and Data Warehousing) systems and processes
• Handle Daily/weekly/monthly ETL tasks
• Creation/Enhancement of Reports using ARC KPI
• Create new processes to address user requirements
• Enhance and optimize existing processes.
• Data Extraction/manipulation using Vertica Database
• Understand existing systems, processes and procedures to effectively support users
• Investigate and resolve issues raised by users via ticketing system
• Deliver service requests
• Tools: ARC BI, ARC Sync, Vertica Database, unix (shell scripting), ms office, ticketing system
• Gathers inputs from technical groups necessary for the project.
• Assess and review requirements submitted from technical and business groups.
• Creates technical documents necessary for the implementation of the project, it includes the following:
SRS (System Requirements Specifications)
TIP (Technical Implementation Plan)
DFS (Detailed Functional Specifications)
WBS (Work Breakdown Structure)
Project Catalogue
• Identify and requests resources of the project.
• Conducts technical kick-off to discuss the overview of the project, high-level Timeline and gather SLAs from the assigned SMEs.
• Review DFS submitted by the vendor and monitor their development.
• Handles and monitors the overall technical activities of the project. • Executes unit testing together with the vendor.
• Prepares firewall definition and security requirements compliance documents to be able to perform connectivity towards Globe systems.
• Conduct meetings to update the project team regarding the on-going and upcoming activities, risks, callouts (if there are any) and dependencies (if there are any).
• Plan, coordinate and oversee the execution of the technical activities. • Checks/modify test cases submitted by QA Lead/Tester.
• Monitors/executes activities during testing. • Troubleshoot errors encounter during testing.
• Prepares operations readiness documents (i.e. user manual, admin manual, project catalogue and CRF) for proper turn-over to operations team.
• Responsible for cutover activities and monitoring afterwards.
• Monitors the stability of the system for 30 days after cutover to production.
• Support Production Issue
• SDLC Process
Projects at Globe Telecoms:
• Martini
Project Martini aims to enable the existing prepaid mobile Internet capabilities and services for postpaid subscribers.
• DAD’s PH1
Project DADs will enhance the SIM activation process by allowing prepaid subscribers to select their preferred mobile number and available promos at the point of activation.
• DAD’s PH2
Aims to deliver the technical implementation strategy of Project DADs Phase 2 that seeks to deliver CSR’s SIM Activation GUI module.
• Skeeds
Aims to provide Filipinos in the foreign country with a cheaper way to make calls in the Philippines by assigning a Virtual Number to Globe mobile subscribers) and Project Deeds (which allows Globe and TM Subscriber to call abroad cheaply by calling an assigned Globe Virtual number to a foreign subscriber)
• Payment Service
Aims to replace the existing credit card provider of Payment Service from Yes Payments to iPay88. User experience shall be retained.
• OTA
It aims to address the application’s need for a Single-Sign-On authentication.
• Razor
Replace the CSP BAU to control transaction handling more efficiently and allows API externalization such as operator billing.
Take control back from the content providers the control of the product, content, and service catalogs and deciding how and when to push requests through the system
• Globe Sweden
Migrate all number ranges from Legacy IN to Amdocs IN
• Develop and enhance scripts/programs based on user or performance requirements with major focus on report extractions (adhoc and regular-frequency), batch or bulk uploading/corrections and recon purposes.
• Familiarization of assigned systems to properly design and develop scripts/programs based on requirements.
• Coordinate and liason with users to assess and verify requirements.
• Coordinate with support teams to facilitate operationalization of scripts/jobs/programs
• Documentation of scripts/jobs/programs created for reference of the technical team.
• Actual migration of scripts/jobs/program to production in coordination with support teams (Sysad, DBA, etc).
• Monitor/regenerate/execute scripts/programs that are not operationalized to ensure regular frequency and availability of reports are maintained.
• Compliance to internal ISG policies for operationalization and change management.
• Creating/Developing In-house script
• Support Production Issue
• Creates files for data conversion (XSLT).
• Executes programming scripts to create prototypes of the database product.
• Loads data in different environments. Reviews iterative test loads to confirm that the implementation adheres to the design specifications.
• Performs intensive testing and inspection of the products, which includes but not limited to:
o Proofreading online data against requirement
o Verifying online functionalities such as links and search capabilities
o Providing own assessments and comments on better ways to display the data o Certifying fixes and enhancements as new and reload databases
o Testing applications and user interface
• Maintains configuration files and documents by updating Polytron Version Control Systems (PVCS) for version control. Updates and maintains document management systems (Twiki) with standard operating procedures on database products.
• Resolves reported issues filed as defects in the defect tracking tool (Test Track Pro).
• Checks and ensures completeness of information and data to effectively perform the assigned task
• Makes decisions on work processes to meet schedule and target productivity
• Investigates cause of delays, client-feedback and production errors and prepares report
• Analyzes data provided to check for format and structure consistency. Compares current and previous data to determine any differences or inconsistencies. Ensures that data conforms to the requirements specified by the Information Provider (IP). Ensures that the data structure is (OvidSP) platform compliant.
• Determines product specifications
• Prepares written account of project/process particulars.
• Troubleshoots reported issues for database updates (update currencies). • Creates Work Order for the databases
• Communicates with client and the vendor to be able to gather all needed information
• Updates tracking tool to reflect actual work, progress, status • Recommends and implements process review and improvement
• Speaks of ideas clearly and articulately in all presentation and situation may it be for internal or external clients; ensures that the point or idea is well expressed and understood.
• Corresponds with and generates reports for the clients with all regard for style and language.