KEVIN NGUYEN-QUOC – US Citizen

adbbtd@r.postjobfree.com - 214-***-****

Skype: khoanam27

Bachelor of Computer Science

Concordia University

(Montreal – Quebec – Canada)

Summary: Result oriented, 20+ years Information Technology experience.

In-depth knowledge of Database Development related to Aviation, Manufacturing, Telecommunication,

Electronic Data Interchanged (EDI), Health care, Banking, On-line inventory control, Bar code, Billing, and invoices Applications.

Extensive experience in Data Migration, Data Mapping, System Conversion and Testing, Scripting, and Application Support.

Involved in multi-platform new project developments using Microfocus COBOL, Pro*C/C++, Oracle, Unix Scripting, Perl. Designed, coded and tested program PL/SQL modules full cycle.

Technical Skills:

Platforms: UNIX, HP-3000/HP-9000, Solaris, HP-UX, AIX, Linux

Database: Oracle, Sybase, Informix

Programming: UNIX scripting, Perl, Pro*C/C++, Oracle, ESQL/C, PL/SQL, PowerShell

Software & Tools: Amisys Advance 4, Suprtool, Enabler,Telegence, Kenan ARBOR, EDI, Crystal Reports, Autosys, Appworx, CA-Unicenter, MQSeries, Tuxedo 8.0, SQL*Plus, Toad, Control-M, Visual Studio 2010, ASP.NET 4.0, VB 2008. VI Editor, Service Now, EXCEL Macros,TIPQA., HTML, CSS, XML

09/19 –Present Cognizant (CVS Pharmacy )– Mesa– AZ

Title: Project Manager – tier 3 Lead Production Support

Training for Debt Evaluation System. AVM and machine learning. Lead break-out team to evaluate/classify incident tickets. Managed module of time usage for reallocation of training effort.

08/18 –06/19 Atos Syntel (Fedex )– Memphis – TN

Title: Unix/ Oracle Database Developer

Unix Developer Application and Release Support

Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).

Developed Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL

Developed materialized views for data replications.

Partitioned large Tables using range partition technique

Created Packages and Procedures to automatically drop table indexes and create indexes for the table

Defect analysis production issue through Workflow (ETL/python)– Oracle data (Toad) – Unix Script (bash)

Analyzed, design, develop, test and implement distributed (Callidus) Landing Pad/Commissions applications as part of a system development team.

Production Support all tickets (Dev/UAT/Prod)

Maintained and Developed Unix/Oracle Scripts

Created Oracle tables, Clearing Space on Unix System, File Creation and Uploading

Fixing Revenues Load Date and Support ICMS project as needed

Create script to purge trigger files

Processed and monitored Payfile/Commission

Run ICMS Pipeline

Ran Eligibility, checked log file, monitor process, ran Eligibility Extract Query to send data to eligibility team for commission process

The revenue bucketing process occurs normally and automatically, however if there is a request, our team handle the manual run of Revenue Bucketing

Handled New Quarter Process where Goal Setting History and Goal File Upload need to be verified and some Global Variable Flag-Revenue-Quarter needs to be checked

Modified typemap.config file to control process such as ETL workflow, inbound, outbound, number of table partition

Created many EXCEL scripts to handle big data to reduce the manual process

Handled Measure-X (data correction) where there is a bug found and code change is still waiting for approval.

Developed and administered Unix Cron jobs

Run Incentive/Multiple/TPF Queries on demand

Modified and created load scripts for Informatica Inbound/Outbound feeds load data into Callidus Application

Debugged issue by examine WorkflowLogs (Informatica – PowerCenter v 9.5.1)

Maintained the typemap Config to defined filetype with Unix Script, Informatica and dependencies

Executed Informatica Workflow as well as Oracle Procedure to load data from Flat file to Database on demand.

Generated and exported parameter file name, which required to execute Workflow and Procedure Parameter file.

08/17 –07/2018 Artech Information Systems(Caerospace Inc) Oklahoma City - OK

Title: Unix/ Oracle Developer.

Handled system administration and applications for Linux servers..

Ensured satisfaction with member merchants by designing and implementing customer testimonial system.

Supervised the modernization of software development practices

Handling Production tickets using SLQ Developer

Experience in Oracle supplied packages,Dynamic SQL, Records and PL/SQL Table

Loaded Data into Oracle Tables using SQL Loader.

Worked on Ref Cursor, External Tables and Collections

Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes

Monitored the Task Schedule, clean cache on Window Servers

Modified SAP IDM to make sure it connects to Production

Handled CheckList Servers refresh

Wrote EXCEL Macros/Scripts for Data Handling

Developed and administered Unix Cron jobs

Software licensing control

Collaborated with test engineers in designing according to the designing phase in Article software development

Validate JSON messages in Rabbit MQ

Created and sent a message to a local queue/remote queue/client-server

Read and identified MQ errors

Part of MQ administrator team (1 year experience)

08/15 –06/2017 Capgemini (GE-Aviation)– Cincinnati – OH

Title: Unix/Oracle Production Support Senior Specialist.

GE Part, Sub-component Quality Assurance.

Participated in GE-Aviation Cincinnati OH team as PL/SQL Developer using TIPQA, Oracle, Unix Scripting, PowerShell.

Unix Developer - Build jobs scripts to monitor system performance and Logs issue.

Handling Production tickets using SLQ Developer and TIPQA application.

Involved in Oracle Centric procedure such as Triggers,

Executed SQL statements, Store Procedure and advanced PL/SQL – Bulk Collect forall, join …

Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS

Created Shell Scripts for invoking SQL scripts and scheduled them using crontab

On-Call (rotation) to support incoming Production alerts/issues. Center point of contact between service provider and users/customer on a day-to-day basis, reporting incidents (disruptions or potential disruption in service availability or qualify (ITIL approach)

Edit and debug PL/SQL program units – Manipulate and export data.

Handled many applications Web-base/Unix-base/Window-base

Modified and enhanced XML codes.

Monitored the TIPQA agents process (Active/Running)

Created/Modified/Removed TIPQ Login Id/pass for new/current users

Installed new TIPQA released/ upgraded versions

Implemented TIPQ Server/Oracle/Services/Interfaces

Fixed TIPQA application issue (data related) – Contacted/reported TIPQA Supplier on new issue.

Installed Task Scheduler to Shutdown/bring up TIPQA servers

Examined Java Log files, Code review of existing Java application.

Applied changes if required in Java application functionality such as some additional modules as

well as refactor the existing modules or methods.

04/14 –12/14 MRI Network Telecom(CenturyLink) – Monroe – LA

Title: Cobol/Pro*C/Web Senior Developer

Participated in Amdocs/Cajunc/Enabler as a developer for new project (Ensemble AR/Collections) using Microfocus COBOL, Pro*C/C++, Oracle, Unix Scripting, Perl, Powershell.

Build jobs scripts to load information to OP tables to run jobs on demand.

Unix Developer - Build Unix Scripts to load Oracle Data, to count number of bytes for Cobol File Description.

Designed, coded and tested program PL/SQL modules.

Maintained, tuned and repaired applications; performed preventive maintenance activities; provided user support.

Assisted in creation of test scripts; testing execution and documentation.

Front End Developer to customize Company Website using Java Script, CSS, HTML, XML

Handled BMC remedy process to provide easy and efficient automation on ticket tracking.

01/12 – 03/14 Collabera(Amdocs Telecommunications) - Champaign – IL

Title: UNIX Production Support Senior Specialist

Monitored/ alerted and corrected routine and complex technical issues using Oracle/Ksh/Perl/Powershell.

Unix Developer - Created Unix/Oracle tools to speed up the process of handling the tickets

Developed and supported billing application modules for telecommunications customer care software suite.

Designed and implemented scripts (Korn/Perl/PL-SQL) for production revenue impacting issues.

Contributed in automation efforts.

Draft Shell/Perl scripts and PL/SQL scripts to resolve user acceptance testing and production defects.

Created and executed validation and production support scripts for custom components. Documents, review, and execute performance tuning scripts.

02/11 – 09/11 Artech(Maxim Integrated) Dallas - TX

Title: Unix System Engineer, Web Developer

Upgraded Cyborg Server Hardware (Flipper/Shamu).

Installed/ Complied/Completed bench march tests for 5.2 Microfocus Cobol, SAMBA Toad 10.6.2, Visual Studio 2010, and Oracle to ensure free errors operations.

Data migration and tested functionality of old and new server platform.

Unix/Perl Developer - Fixed Perl scripts

Created PL/SQL test cases and executed unit and system testing.

Determined needs and modifications, and implemented changes upon approval.

Recommended solutions to problems related to software design.

Front End Developer to customize Company Website using Java Script, CSS, HTML, XML

06/10 – 12/10 Ajilon(JPMorgan Chase)_ Columbus -OH

Title: UNIX System Engineer

Unix Developer - Implemented client requests for the enterprise and line of business applications (AIX/Linux/Solaris). Created UNIX/SQL-Oracle/Perl Scripting tools to speed up the installation of Control-M/Server-Agent on UNIX computer.

Wrote Advanced Queuing database package to send messages to clients based on events.

Coded and implemented PL/SQL packages to perform Application Security and batch job scheduling.

Maintenance of jobs using BMC Control-M product.

Job Configuration and Scripting.

Part of team to standardize Control-M process across all departments.

Provided departmental day-to-day support with Control-M application.

Used PL/SQL collections, SQL Analytics functions, Cursors, Indexes, Constraints, built-in packages

Extensively used SQL Loader, UTL_FILE and External Table mechanisms to load legacy data, feed files data and data from various sources into the Oracle database tab

Performance tuning of the query using hints and explain plan.

03/07 – 12/09 Scott & White Health Plan, Temple -TX

Title: Amisys Programmer/Unix Operational Environmental Support/

PL-SQL Developer

Participated in two Amisys Advance Upgrades (Amisys 1 to Amisys 3 and Amisys 3 to Amisys 4), including code change, test scripts, and source codes.

Wrote PL/SQL packages to calculate Missing Information and Determining Eligibility in the processing of a Medical/Health Families Application.

Documented business rules, functional and technical designs, test cases, and user guides.

Created Databases, Tables, Views, Stored Procedures, Triggers.

Created vast amount of UNIX/Korn-Shell/Autosys/ Perl/Oracle/Pro*C/C++/PL/SQL/Awk/MF COBOL/Suprtool scripts and utilities to:

Support Security Environment Compliances.

Assist programmers to identify errors during data migration and conversion.

Enhance data performance and supported data base multi-functions.

Optimize cost saving by accelerating computer and real time data base migration, bench mark test and error free operations.

05/05 – 02/07 Amdocs/Cingular, Dallas - TX

Title: UNIX Infrastructure/Configuration/Data Migration Specialist

Set up and supported UNIX operating environment for Telegence, Tuxedo and WebLogic security control.

Customized data base system catering for specific business client requirement.

Unix Developer - Wrote UNIX utilities to support environment and clean up Oracle data. Monitored UNIX conversion disk space, upgraded, carried out maintenance and other production activities. Detailed validation and coordination of data implementation across multiple environments and platform data migration.

Built and ran UNIX/Perl scripts to change password of 32 Operation UNIX accounts monthly which controlled UNIX accounts firewall security system.

Assisted and alerted managers be aware of out-of-sync source code and monitor the expiration of licensing by creating Ad-hoc UNIX scripts, 2rd party software such as MF COBOL, C/C++ Compiler, geotax, Corba, SyncSort, Sybase, Oracle, MQSeries, Tuxedo 8.0, TWS, Java, Perl, and taxware.

Handled BMC remedy process to provide easy and efficient automation on ticket tracking.

02/04 – 4/05 Scott & White Health Plan, Temple -TX

Title: Amisys Programmer/Unix Operational Environmental Support

Upgraded Scott & White HealthCare Processing system and utilized Oracle backend and converted from Amisys on HP-3000 to Amisys 1 on HP-9000.

Sole person to take care of all Perl Scripts.

As Unix Developer - Created vast amount of UNIX/Korn-Shell/Autosys/ Perl/Oracle/Pro*C/C++/PL/SQL/Awk/MF COBOL/Suprtool scripts and utilities to:

Alert end user’s data base root cause problems.

Assist client platforms and detailed technical supports.

Debug multi-software systems, syntax and functional errors.

Assist managers to trouble shoot client’s requests and specific requirement

98 – 04 EXCEL/VarTec Telecom, Inc., Dallas - TX

Title: Senior Programmer Analyst/PL-SQL Developer

In-charge of Full Life Cycle project using SQL/Korn Shell/Perl/Pro*C/C++/Unix/Sysbase to support Kenan ARBOR Billing System.

Participated in API Project (ECCO/ARBOR tables interface/conversion) using UNIX/SQL/Perl/Pro*C/C++, COBOL Micro-Focus.

Website Developer for Reporting/Logs/Problem Solving Method for tracking down source codes v/s batch jobs (using Java/Java Script).

System Development, Technical Trouble Shooting, and Production Support (Kenan ARBOR Billing) using Sybase (Excel) and Oracle (VarTec).

Technical lead Oracle programmer for training and task assignment for entry-level programmers.

Coded and implemented PL/SQL packages to perform Application Security and batch job scheduling.

Additional Certifications/Trainings:

C/C++ Language

Informix Database (SQL/Relation Design/Optimization)

NetExpress (Microfocus COBOL)

Oracle

Sybase

Java

MQ Series

Contact this candidate