SUMMARY:

• In - depth knowledge of database development related to on-line inventory control, bar code, billing, invoices, EDI, health care, manufacturing, Telecommunication, and Financial applications. Confidential .
• Result oriented, 20+ years if IT experience.
• Extensive experience in Data Migration, Data Mapping, System Conversion and Testing, Scripting, and Application Support.
• Designed, coded and tested program PL/SQL modules.
• Participate as a developer for new project using Microfocus COBOL, Pro*C/C++, Oracle, Unix Scripting, Perl.

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

PROFESSIONAL EXPERIENCE:

Confidential, Cincinnati, OH

Unix/Oracle Production Support

Responsibilities:

• Participate Confidential - Confidential Cincinnati OH team as PL/SQL Developer using TIPQA, Oracle, Unix Scripting, PowerShell.
• Centered point of contact between service provider and users/customer on a day-to-day basis (ITIL approach).
• Was a focal point for reporting incidents (disruptions or potential disruption in service availability or qualify (ITIL approach)
• As Unix Developer - Build jobs scripts to monitor system performance and Logs issue.
• Handling Production tickets using SLQ Developer and TIPQA application.
• Involved Oracle Centric procedure such as Triggers,
• Execute SQL statements, Store Procedure and advanced PL/SQL - Bulk Collect forall, join …
• On-Call (rotation) to support incoming Production alerts/issues.
• 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.
• Monitoring the TIPQA agents process (Active/Running….)
• Created/Modified/Removed TIPQ Login Id/pass for new/current users
• Installed new TIPQA released/ upgraded versions
• Bring up/down 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.

Confidential, Monroe, LA

Cobol/Pro*C/Web Developer

Responsibilities:

• Participate Confidential /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.
• As 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 the creation of test scripts; executing and documenting tests.
• 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.

Confidential, IL

UNIX Production Support Specialist

Responsibilities:

• Monitored/ alerted and corrected routine and complex technical issues using Oracle/Ksh/Perl/Powershell.
• As Unix Developer - Created Unix/Oracle tools to speed up the process of handling the tickets
• Develop and support billing application modules for telecommunications customer care software suite.
• Design and implement scripts (Korn/Perl/PL-SQL) for production revenue impacting issues.
• Contribute to automation efforts.
• Draft Shell/Perl scripts and PL/SQL scripts to resolve user acceptance testing and production defects.
• Create and execute validation and production support scripts for custom components. Documents, review, and execute performance tuning scripts.
• Centered point of contact between service provider and users/customer on a day-to-day basis (ITIL approach).
• Was a focal point for reporting incidents (disruptions or potential disruption in service availability or qualify (ITIL approach)

Confidential, Dallas, TX

Unix System Engineer, Web Developer

Responsibilities:

• 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.
• As 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

Confidential, Columbus, OH

UNIX System Engineer

Responsibilities:

• As 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.
• Provides day-to-day support of Department applications that are related to Control-M.
• 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.

Confidential, Temple, TX

PL-SQL Developer

Responsibilities:

• 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.

Confidential, Dallas, TX

UNIX Infrastructure/Configuration/Data Migration Specialist

Responsibilities:

• Set up and supported UNIX operating environment for Telegence, Tuxedo and WebLogic security control.
• Customized data base system catering for specific business client requirement.
• As 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.