Ronald A. Signore

Creve Coeur, MO *****

e-mail: ad494p@r.postjobfree.com

Employment Experience

February 2021 - Present

Software Engineering Advisor – contractor remote - Wellcare, Tampa, FL.

Perform ETL related tasks to generate healthcare program reconciliation files from MongoDb source system. Create Talend jobs to extract data using desktop app and Talend Enterprise server. Establish requirements, modeled data and performed testing and validation. Analyze source source data using SQL Manangement Studio with MYSQL BI connector, as well as Studio3t. Preform API requests using REST and GraphQL. Load files to S3 storage, Provide data and support to integration team.

June 2020 – January 2021

Software Engineering Advisor – contractor – Express-Scripts, St. Louis, MO.

Performed ETL related tasks for Agile Kanban Tableau team. Migrated and validate SQL Server database from version 12.0.6372.1 to 14.0.3335.7. Wrote SQL server stored procedures to perform data extractions and loads. Created Talend jobs to execute REST calls to retrieve data from ServiceNow and Confluence, and load to SQL server. Maintained existing and create new Python processes to perform REST calls, executed SQL server stored procedures and performed bulk copies between servers using Powershell. Provided data support to team Tableau developers.

April 2020 – June 2020

Contract at Bayer ended at the onset of a global pandemic. Spent gap time looking for a new position, brushing up on existing skills, and learning new ones.

April 2019 – March 2020

Data Engineer – contractor – Bayer, St. Louis, MO.

Mentored team members on ETL best practices using SQL and Alteryx. Gathered requirements and perform data analysis and profiling. Created Tableau dashboards per user requests and mentored other team members new to Tableau. Debugged existing Access processes and converted to Alteryx. Helped support and train teammates on new software.

April 2018 – March 2019

ETL Developer – contractor – US Bank, St. Louis, MO.

Converted Oracle DB to Netezza by rewriting existing database objects and ETL processes. Created new Informatica mappings. Wrote UNIX shell scripts, embedded SQL and stored procedures. Created job schedules using Appworx. Ported data from Netezza into Hadoop data lake using HDFS, Hive, Sqoop and JDBC. Gathered requirements, performance tuned existing and new processes.

July 2014 – April 2018

Lead Software Engineer - Magellan Health, St. Louis, MO. Converted from

contractor to full time November 2014

New ETL development, testing, production fixes and debugging. Maintenance of existing ETL processes. Identify performance issues and solutions.

Designed, developed, tested and implemented solution to extract data from MongoDb and load to Oracle Data Warehouse using shell scripting, the MongoDb shell facility and Oracle SQLLDR. Support and enhance MongoDb integration process.

Support data warehouse operations, including production issues and automate manual tasks using shell scripting, Informatica, SQLPlus, and PL/SQL.

Debugged SSIS package and C# code using Visual Studio and Visual C#. Powershell scripting.

Mentor others on Operations standardized processes, Informatica and Snaplogic development, and MongoDb shell queries.

Informatica 9.6.1, Oracle 12c, SQL Server, SSIS, Visual Studio, Linux shell scripting, C#, Oracle, Toad, MongoDB, NOSQL, JavaScript, SQL Server, Netezza, Aginity

September 2013 – May 2014

ETL Developer – Daugherty Business Solutions – consulting for Reinsurance Group of America

ETL development and support – Informatica, Oracle.

Informatica development – Work with overseas clients to finalize and implement technical design specifications. Create, document and implement test plans. Duties include creating new processes, as well as adding enhancements to existing design templates. Implement Informatica web services consumer and http solutions to execute asp.net queries. Parse, transform and load the results of those queries. Perform data analysis as needed.

Data Warehouse daytime admin support – Informatica Powercenter administration. Cisco Tidal Enterprise Scheduler administration, including installation. Root cause analysis and resolution of data warehouse issues. Environment supported – Powercenter 9.1, Tidal 6.1, Oracle 11g, Linux, MSSQL, Samba, and windows servers.

Perform 24 hour on call duties on semi-monthly rotation. Determine root cause of production issues, propose and implement solutions.

Informatica 9.1, Oracle 11g, Tidal Scheduler.

April 2012 – August 2013

ETL Developer - Data Quality – Stockell Consulting – subcontracted to Monsanto, St. Louis, MO.

Automation of existing Standard Operating Procedures. Functions performed include requirements gathering, data analysis, development, testing and implementation. Create processes and user interfaces incorporating newly developed Web Services / Informatica Developer / Powercenter / Data Quality infrastructure. Configuration of testing framework utilizing Maven, IntelliJ.

Informatica 9.1, Unix/Linux, Oracle 11g, Web Services, SoapUI, WSDL, Maven, Subversion, IntelliJ.

August 2011 – April 2012

ETL Developer/Programmer/Analyst - Signature Consultants - subcontracted to Wells Fargo Advisors, LLC, St. Louis, MO.

Technical lead for automated file delivery and registration process – Design and implement enhancements to data extraction and file delivery processes. DB2, Informatica, Unix (ksh) scripting, NDM and Autosys environment. Responsibilities include creating technical designs and production turnover documents, coordination data transmission between Wells Fargo internal and external clients, maintenance and enhancements of system process, including Unix shell scripts, DB2 SQL, and Informatica mappings and workflows. Debug production issues and identify process bottlenecks.

November 2010 – August 2011

ETL Developer - Unisys Corp. - subcontracted to US Department of Agriculture, Rural Development Government Loan Program, St. Louis, MO.

Converting Informix/DB2 Data Warehouse to Informatica/Oracle - Re-engineering existing SQL to Informatica ETL processes, development, testing and implementation - Sun/Solaris environment.

October 2009 – November 2010

ETL Developer/Programmer/Analyst - Collabera Inc. - subcontracted to Wells Fargo Advisors, LLC, St. Louis, MO.

Create and document new Unix/Informatica/DB2 ETL processes and enhancements. Tech lead for automated file delivery and registration process - Create utility script and test plan to compare performance and accuracy between existing version of SyncSort for Unix to each an upgraded version of SyncSort and DMExpress. Create ksh process calling NDM to pull directory listings from remote landing sites. Serve as mentor for the onboarding of ETL Tech Leads. Resolve production issues. DB2, Informatica, Unix (ksh) scripting, SyncSort and Autosys.

March 2008 – October 2009

Sr. Software Consultant - Jacobson Staffing - subcontracted to Express Scripts, St. Louis, MO.

Data Warehouse Developer – New development and enhancements, designing, coding and testing. Assist in the engineering and design of new ETL processes. Interface with source system subject matter experts, project managers, data architects, as well as business users. Environment/Skills utilized -> AIX (ksh scripting), C, Perl, DB2, Informatica and Teradata. Personal: Ubuntu (debian) Linux, MySQL.

January 2007 – March 2008

Data Warehouse Developer/Support – Belcan Inc. www.belcan.com - subcontracted to Anheuser-Busch, Sunset Hills, MO.

Data Warehouse EDW Support – Problem identification, resolution, and enhancements relating to support group functions. Work is derived from 24x7 on-call paging system and user requests.

Data Warehouse ETL Programmer - Designing, coding and testing data warehouse applications for Anheuser-Busch sales, inventory, production line and forecast data.

Programming skills utilized: UNIX Korn shell scripting, support for Teradata, Oracle DLL, DML including Teradata CLI, fastload, and multiload and bteq scripting. Development / support for IBM Datastage Server, Enterprise Edition version 8.1. Monitor, update and add schedules to Tivoli Work Scheduler via client and composer scripts.

Developed system using TWS, UNIX, Datastage and Teradata to capture and log to Teradata all Data Warehouse processes run via Tivoli Work Scheduler.

March 2006 – January 2007

Data Warehouse Developer – Ciber Inc. www.ciber.com - subcontracted to Wells Fargo Home Mortgage, Clayton, MO.

Data Warehouse ETL Programmer - Designing, coding and testing applications for valuation and daily processing of bundled mortgage backed securities.

Supporting production oriented development and testing environment including running and debugging real time UAT batch processes.

Programming skills utilized: UNIX Korn shell scripting, DB2 DLL, DML including loader scripting, and IBM Datastage Enterprise Edition version 7.5 for parallel processing on IBM AIX 5.2 platform.

November 2000 – March 2006

Senior Programmer Analyst – US Bank, St. Louis, MO.

Data Warehouse ETL Programmer - Designing, coding testing new applications for Banker Performance Incentive Rewards program. Developing applications utilizing Ascential Datastage Server and Parallel Extender on UNIX platform. Providing technical assistance to team members.

Mainframe Programmer – Designing, coding, testing new and existing interfaces for Data Warehouse. Participated in conversion process for Firstar Bank acquisition of Mercantile Bank, then US Bank merger with Firstar.

Data interfaces include IBM UDB and Microsoft SQL Server. System interfaces include Performance Management, ATM, AFS/Commercial Revenue/Dealer Floor Plan, ALS, Credit /Debit Card, Direct Deposit, Fraud, and Trust .

Programming skills utilized: IBM/MVS/TSO COBOL, JCL, VSAM, Easytrieve, UNIX, DB2, ORACLE PL/SQL, Ascential Datastage ETL and C++.

1998 – November 2000

Senior Programmer - I-Structure, subsidiary of Level 3 Communications www.pksis.com - subcontracted to Pershing Technology Group, subsidiary of Donaldson, Lufkin & Jenrette, Florham Park, NJ.

Responsible for all phases of project life cycle for Pershing's Individual Retirement Account tax reporting and notification system. Includes working hand and hand with business users in the creation and evaluation of requirements, testing, production implementation and follow-up. Primary job functions are coding and testing with MVS COBOL, JCL, CICS and Easytrieve,

1996 – 1998

Information Analyst - Electronic Data Systems - subcontracted to AT&T, New Brunswick, NJ.

(includes period subcontracted to Electronic Data Systems from Chubb Programmer Resources 7/96 - 3/97)

Development and production support on commercial billing systems.

Coding in MVS COBOL, JCL, DB2.

Testing with Expediter, SPUFI and Microfocus COBOL.

Train team members on Expediter and AT&T concurrent development tool.

Development and production support of the bill edit and format processes for residential billing system

Testing with Expediter, SPUFI, and Microfocus COBOL.

Debugging and testing of new Microsoft Access based Employee Information Database

Assist in startup of Microsoft Access based concurrent development tool.

1990 – 1995

Prudential Reinsurance Co., Newark, New Jersey

Actuarial Analyst

Project Leader - Reinsurance Reserving, supervising two Actuarial Assistants for the purpose of estimating company's unreported

outstanding reinsurance liabilities. Projects include statistical analyses

of claims data, the estimating of ultimate losses, interacting with underwriting, accounting, and claims personnel, and presenting results

to senior management.

Revising, streamlining and documenting APL computer programs for the Reserving and Valuation areas. Designing menus to make programs more user friendly.

Preparing rate level comparisons and rate filings for submission to state insurance departments.

1988 – 1990

Clarendon National Insurance Co., New York, New York

Actuarial Assistant

Designed and updated spreadsheets for financial reinsurance contracts.

Assisted in estimating claims, setting reserves, and the rating of

non-standard auto lines using competitor analyses.

1988 Continental Insurance Co., New York, New York

Premium Adjuster - International Department

Maintained and updated an underwriting database

1986 – 1987

United Parcel Service, Maspeth, New York

Industrial Engineer

Scheduled tractor - trailer pickup and delivery operations, lowering

weekly transportation costs per package by an average of 15%. Trained delivery and distribution personnel in safe work methods, conducted driver performance audits and supervised delivery operations.

1984 – 1986

Jamaica Water Supply Co., Lake Success, New York

Industrial Engineer

Developed and installed a work measurement program for clerical units.

Program was designed to keep track of productivity and determine optimal staffing levels.

Education

1996 Top Gun Training Program - Focus on MVS COBOL / Client Server

Chubb Programmer Resources, Parsippany, NJ

Curriculum: MVS COBOL, JCL, TSO/ISPF, VSAM, Utilities, MS-DOS, MicroFocus COBOL/XDB, CICS/ESA, DB2/SQL, Novell LAN, Windows Environment/Word for Windows/Windows for Work Groups, C, C++, PowerBuilder, SYBASE, Object-Oriented Design and Data Analysis, Visual Basic

1984 Polytechnic University; Brooklyn, NY

M.S. Industrial Engineering

1982St. John's University; Jamaica, NY

B.S. Economics

Contact this candidate