Vladimir GUERVIL
PL/SQL developer – Application Support
***, **** ** **, ********, NY,11210
: adg4gt@r.postjobfree.com
IT-Tech with more than 7 years in different field of IT environment Database, Programming, Pc repair. Continuously seeking new opportunities to improve myself in IT world.
Experiences
NATIONAL TELECOM(NATCOM) Port-au-Prince, Haiti NOV 2010 – Apr 2019
Telecommunication services provider offering GSM mobile services
Nov 2010 – August 2011
IT Support - C# Programming - SQL Programming
Install Windows Operating system on several PCs
Support employee to use shared Printer over the network
Support employee to use MS Office ( Word, Excel, Power Point )
Install application client on PC client to connect to our Database
Adding new function in C# client application employee can use to Manage Customer information (programmed application layers)
Build Procedure/Function on MS SQL
Building desktop application in C# to make billing payment for postpaid subscribers
Write SQL queries to store, sort, and Extract data, MS SQL, MySQL, Oracle 10g,11g 12c
Create Database Objects such as Procedure, trigger, views, Sequence,index
Nov 2011 – March 2015
Team Leader of Application Section(IT department) – PL/SQL Developer and Application Support
Deployment of Java Web application (Tomcat) on application servers
Preparing maintenance plans and upgrading schedules for the organisation’s systems
Troubleshoot and debug application, using advanced query and programming skills. Conducts root cause analysis including coordinating with different teams to arrive at a possible solution
Monitoring Java process using MM Tools client
Configure error alarm to monitor application logs
Format Call details record (CDR) file
Extract Data to build Report from Oracle and MS SQL database
Create new database objects on Oracle, Partionining table
Coding PL/SQL (Functions, Packages, Store procedures, Triggers)
Work with Software development Team to provide SQL Script
Backup Application Code on SVN server
Maintained the interconnect database and Billing system including building the monthly report using SQL script to extract calls data
Creating Trigger to automate some task and implement new policy from other departments
Getting KPI information(HDD storage, CPU, Memory, log file size) from all application servers running Linux Operating system using linux command.
Writing more complex and optimized queries, changing the way data is stored or structured
April 2015 – Apr 2019
PL/SQL Developer IT deputy manager – IT Billing department
PL/SQL Programming ( Create store Procedure, Packages, Functions, Triggers, Views, DBLink, Records, Nested Tables, Cursors)
Configure JobSchedule on oracle database
Troubleshooting of complex systems issues
Automated and streamlined key tasks via SQL scripting
Create indexes on tables for SQL tuning purpose
Implement new application code from Software development Team mostly JAVA code
Analyze and collaborate effectively with Software development team to implement business requirement
Work closely with BI Team to process RAW Call details record file (CDR) from Billing System and import into Database
Collaborate with Product Strategy Team to convert the Business need in to Technical complex queries
Manage IT-staff task assignment
Analyzing KPI report of all Linux application servers
Tuning/Optimize SQL, PL/SQL Code, Partionining table
Configure Crontab job on linux application server to delete applications logs file
Collaborate with various departments and perform research on all data processing functions.
Technologies : MS Office, MS SQL, Oracle 10g, Oracle 12c, Java SE, Tomcat, Windows 7, windows10, Linux, Visual Studio(VB), PL/SQL
VIETTEL TELECOM (Remote Contract ) - April 2020
SQL REPORTING – PL/SQL DEVELOPER
Collect sales data transaction from Oracle database and export to CSV format
Create Procedure, Function, Triggers
Update old procedure base on Business requirement
Import data into database from Excel file
Provide sales transaction to Product Strategy department
Education and Certification
August 2020 – Until now
SimpliLearn Alumini – Online Class
Full Stack Java Developer
February 2019 – August 2019
Brooklyn Adult Learning Center - BALC
Associate Degree, Information Technology
Comptia A+ Certification (Certified)
Comptia N+ Certification(Certified)
August 2011 – November 2011
TRUNG TAM DAO TAO VIETTEL (Vietnam) – Training Course
Oracle SQL Fundamentals (Oracle 11g)
Linux
Overview GSM Technology
Java SE
2007 - 2010
Canado -Technique
Associate Degree in Information Management System
2000 - 2007
Collège Jean XXIII (Les Freres de Sacre Coeur )
High School (Bacc I & II)
Language Skills
Language read, written and spoken English, French, Creole