Integrations, database, reporting

• Boomi integrations support and development• Modifications to boomi integrations, including database targets of Sql Server and Postgres.• Monitor / resolve support tickets• Develop groovy SFTP script using Java Secure Channel (JSch) in lieu of boomi SFTP connector

Boomi integrations via UKGO boomi integrations via UKG Dimensions application. SFTP, API, data extracts and imports.O People ImportO Accrual ResetO Schedule ImportO Payroll ExportO Business Structure Import

Boomi integrations via UKGcertified boomi professional developer• Certified boomi professional developerO boomi integrations via UKG Dimensions application. SFTP, API, data extracts and imports.O Timepunch ExportO Workload Volume Census ImportO Leave Case Export

Boomi integration developer• Systems integrations using Boomi with restful API's, some Amazon Redshift database connections and Amazon S3 bucketsBoomi integrations include:• Freshservice incident ticket creation, restful API• Runlogs housed in AWS Redshift table with S3 unload, query, selects• Greenhouse recruiting to ADP Restful API's Some webhook exposure• ADP - Redshift Restful API's for Employees, departments • ADP - Egencia .csv file creation, sftp, email via Microsoft.graph• ADP - Netsuite Employee information sync

Database and systems integrations using Boomi and Sql Server. Also some API integrations with Boomi, including RingCentral and Amazon SQS Messaging.

• System support for enterprise data. Jobs monitoring and issue resolution. SQL. Snowflake. Oracle. Sql Server. On call support of enterprise systems. Some API discovery.

• Cloud and on-premise systems integrations using Dell Boomi iPaaS. Some MySQL.

• Sql Server 2014, table indexing, ETL, data extracts, analysis, queries, ssis, database tuning, user interface application administration. C# exposure; modifications to existing text-to-database solution, testing, working through tutorial examples.

• Sql Server 2014, queries, table creation, sql scripts, data mapping. Data migration from legacy legal records management systems into web-based FileTrail Information Governance system, both on-premise and cloud.

• SQL query writing, Data Aggregation for Dashboards, Actuate SQL-based reporting, Advanced Query Tool (AQT), database work, DB2, ETL with iWay. Support and development in the data warehouse and data mart. DOS scripting. File Transfer Protocol FTP. Some Business Objects.

• Database work in 4D (relational db based on sets and arrays), a relational database. Patient revenue cycle. Payments, charges, collections, reconciliations.Interact with relational databases on a daily basis. Extract data by building queries via user interface, create complex queries, analyze data imports for trends and process inbound files with some client interaction.

Various database development and support positions, mainly Sql Server.

client server contract

Cobol, jcl, vsam, DB2