Gerald Gallimore

**** ********** *****

Wake Forest, NC 27587

336-***-****

ad5bj1@r.postjobfree.com

SUMMARY

Leveraging years of experience utilizing Unix, Oracle, DB2, and Teradata with a strong background in production support, systems analysis, and development for medical, pension, inventory, and sales applications. Additional acquired experiences include Oracle XML/Web Services Packages, Ab Initio, and IBM Cloud technologies.

EXPERIENCE

IBM, RTP NC

Production Support Analyst 06/21 to 04/24

Responsible for monitoring multiple batch processes in an IBM Hybrid Cloud environment. Activities include debugging workflow failures, implementing restarts, and executing steps to suspend/resume crons. Authored shell scripts to automate error detection and reporting. Tech Used: TWS, Argo, Kubernetes, Spark, Airflow, Kafka, DB2, DBeaver, GitHub, and Jira.

Curi, Raleigh NC

Data Warehouse Developer 01/20 to 4/21

Responsible for developing and maintaining Oracle packages, procedures, functions and PL/SQL programs in support of the Oasis (Medical Professional Liability Insurance) application. Provide break/fix support of the nightly batch processes. Tech Used: Toad 13.3, Oracle 12c Release 12.2.0.1.0, OEM (Oracle Enterprise Manager), Business Objects, Jira, GitHub, Visual Studio TFS (source code control), and Microsoft Teams.

Cognizant Technology Solutions, RTP NC (on-site at Credit Suisse)

Sr. Production Support Engineer 12/18 to 12/19

Responsible for production release activities, Unix environment maintenance, identifying process improvement opportunities to reduce break/fix incidents and coding to automate manual processes. Batch job monitoring and intervention for data/technical issues. Tech Used: Unix, Oracle PL/SQL Developer, Informatica, Control-M job scheduler, Service Now.

BCBSNC, Durham NC

Sr. Developer 03/11 to 12/18

Responsible for developing and maintaining Unix shell scripts, PL/SQL stored procedures/packages, and XML generation processes in support of a Care Management application (Care Radius). Authored a prototype to access Web Services from Oracle PL/SQL. Generated project delivery, unit test, and technical specification documents as required. Successfully completed introductory and intermediate Ab Initio Developer training courses.

Tech Used: Oracle (12c), Unix scripting (ksh, bash, awk, sed, perl)

Teradata (14.10.07.07) SQL Assistant, BTEQ and FastExport to extract case management data from the corporate Enterprise Data Warehouse. Created ad-hoc queries and BTEQ scripts on an as-needed basis.

Ab Initio 3.1.7.3 to implement multiple enhancements (and bug fixes) to existing claims authorization ETL processes. Successfully completed Introductory and Intermediate Developer training courses. Utilized GDE, EME (metadata/source code control), and Co>Operating System to create and modify graphs. Primary components included Sort, Scan, Rollup, Reformat, Gather, Merge, Partitioning, and Lookup Tables. Implemented Pipeline, Component, and Data Parallelism (and Multifiles) to facilitate performance improvements. Total combined experience with Ab Initio: 1.5 yrs.

GlaxoSmithKline, RTP NC

Consultant – Programmer / Analyst 10/10 to 03/11

Authored/maintained Oracle PL/SQL (packages, procedures, functions) in a Sarbanes-Oxley financial reporting application. Tech Used: Oracle (10g), Unix scripting (bash, ksh, awk, sed, perl), TWS (Tivoli) WebAdmin.

BCBSNC, Chapel Hill NC

Consultant – Production Support Analyst / Developer 07/09 to 10/10

Responsible for multiple roles in a Teradata, Oracle, Ab Initio, and Unix environment. Automated manual processes via Unix shell scripting by reporting the status of certain batch processes, and certain aspects of the system environment. Also resolved Ab Initio batch issues around orphaned temporary work/log files. Produced ad-hoc reporting on an as-needed basis.

Tech Used: Oracle (10g), Unix scripting (ksh, awk, sed, perl)

Teradata (v12) Manager, Admin, SQL Assistant, and BTEQ to perform support tasks and generate ad-hoc reports. Authored Teradata Stored Procedures to implement SLA Tracking automation and reporting.

Revlon, Inc., Oxford NC

Consultant – Programmer / Analyst 08/08 to 02/09

Implemented the US Accounting Cost Rollup project for the 2009 budget year in the GEMMS/Oracle application environment.

Coded Unix shell scripts and PL/SQL stored procedures in support of an Oracle Financials eBusiness Suite ERP migration (11.5.9 to 11.5.10). Modules included Accounts Payable, General Ledger, and Fixed Assets.

BCBSNC, Durham NC

Consultant – Programmer / Analyst 01/08 to 06/08

Developed new outbound data feeds utilizing Microsoft SQL Server 2000 (v8.00.760) and Transact-SQL. Maintained Unix shell scripts and authored Oracle PL/SQL stored procedures. Performed testing of Teradata BTEQ and Fastload utilities as part of an upgrade to V2R6.2.

GlaxoSmithKline, RTP NC

Consultant – Programmer / Analyst 08/06 to 01/08

Primary developer and data analyst for the Manugistics 6.1.8 Supply Chain Planning and Optimization application. Implemented batch process improvements (file versioning, disk space usage alerts, consolidation of common functions, process monitoring, and paging).

ASA / AON Consulting, Winston-Salem NC

Production Support Analyst / Developer 04/98 to 08/06

Program development and maintenance resource on a production support team using Oracle PL/SQL, Unix Korn shell, sed, awk, and perl in support of a pension payment application.

Additional work experience available upon request.

EDUCATION

Associate of Applied Science (A.A.S.), Data Processing, Northern Virginia Community College, Alexandria VA.

Contact this candidate