Oracle Database Software Applications
Resume:
Steven Brock
Fleming Island, Fl *****
*******@***************.***
Professional Summary:
** ***** **** ** ********** in the IT industry. Expertise in system analysis, design, development, and implementation of software applications.
20 years plus of hands-on experience in EDI using different tools like WebSphere Transformation Extender (former DataStage TX/Mercator), Sterling, Gentran, Ecmaps on Windows NT, UNIX, zLinux, Mainframe, Implementing EDI with DB2, Oracle and XML, json.
Experienced in EDI Transactions 110, 114, 204, 214, 270, 271, 278, 810, 820, 823, 830, 834, 846, 850, 855, 860, 861, 867, 870, 990, 997, 999, 270, 271, 276, 277, 835 and 837.
Familiar with ANSI X12, 4010, 5010, 6010 standards.
Familiar with SWIFT ISO 15022 /7775 Message Types
HIPAA Standards: Knowledge of Electronic Data Interchange (EDI) X12 standards, In depth technical knowledge of HIPAA Transaction Sets is strongly preferred - 837, 835, 270/271, 276/277, 278, 834, NSF, UB92, HL7.
Experience in communicating with trading partners, sending documents through VAN, using FTP, etc.
Expertise Interface programs for importing data from feeder systems to different modules using Oracle database, SQL*Loader, PL/SQL, Perl and UNIX Shell scripts.
SQL ETL with oracle database objects. Testing and SDLC in all DEV/QA/Prod regions.
IBM WTX, IBM WMB, IIB, ACE, and WMQ. To support business requirements.
Extensive experience with IFD, Map Designer, Launcher and ITXA Standard Processing Engine (SPE), MRN, MRC, Launcher Administration
Websphere Message Broker, IIB, ACE v10 Build from scratch for implementation.
Good experience with SQL Server.
Good analytical skills and documentation from business requirements.
Translation/Mapping Tools: WebSphere Transformation Extender IBM Transformation Extender (ITX/ITXA)
Extensive experience in Fine tuning systems and troubleshooting.
Design Studio: Map Designer, Integration Flow Designer, Database Interface Designer.
WTX Resource Adaptors: Archive (TAR), Archive (Zip), Batch File, CICS, Connect Direct, Database, E-Mail, FASP Aspera, FTP, File, GZIP/ZLIB, HL7 MLLP, HTTP, IBM WebSphere MQ (Client), IBM Websphere MQ (Server), JMS, MSMQ, Microsoft Excel, Mongo DB, OpenPGP, Oracle AQ, PDF, SNMP, SOAP, Shell Script, Socket, SPE, Static File, Sterling, Websphere Extreme Scale.
Operating Systems: UNIX/ zLinux operating systems and shell scripting
Database: Relational database design - DB2, Oracle MS Sql server
Good knowledge of SOA Tools (ESB, Development, Testing, Resource Registry, Toad )
System Integration: FTP, Message queuing (MQ Series, JMS, MSMQ - WebSphere MQ )
Launcher Event Server configuration and applied integration.
I lost my hearing in the united states navy which sometimes affects my speech I am partially hearing impaired.
I have been in the software development field for more than 28 years. I have provided numerous Fortune 500 companies with full life cycle software development including requirements definition, design, architecture, development, testing, implementation, upgrades, migrations, and support. I have experience as an IBM Data Integration specialist and team leader, providing motivation and guidance to my team whether on-site or offshore. My experience includes different domains like supply chain, health care, manufacturing, insurance, and finance.
Professional Expérience :
HCL vendor client app labs systems (headhunter)
– State Farm @ HCL Global Systems Atlanta, Ga.
IBM Transformation Extender Software Developer
June 2023 – June 2024
Upgrading WTX 9 to ITX 10 in Linux Environnait
Testing and migrating systems
On call duty rotation 24/7 during process
Assisting and mentoring novice team membres on upgrade
Working with upper management on timelines
Manage and test code in git for deployment to linux regions
ITX v10 map designer
oUpdating maps and troubleshooting functional maps to meet requirements
oType tree augmentation for maps as needed
oRecompliling msl and deplolying new compiled opjects in v10 environment
oTesting
ITX 10 launcher
oRecompiling msds to msl and deploying them to new environments
oPerforming quality assureance in an agaiil evironment to insure data has not been compramised during the transition.
oAnalyzing traces and audit logs for issues and resolving tickets during testing.
.ITX database interface Designer
oModifing mdq’s to meet new databases
oTesting new mdqs with mysql to confirm properly populating tables.
oAnalyizing traces and audits for issues and resolving tickets during testing.
Medical Leave
June 2023 – Oct. 2023
Convalescent leave (wife recovering from hospital)
IBM Architect Advisor
CVS Corp HQ, Chicago, Illinois
Insight Global (headhunter)
(Remote in Florida)
Jan 2023 – June 2023
Using ITXA/ITX applications with Launcher v10
To accept X12 by allowing ITX/ITXA Archive of inbound data, with database tables.
Using ITXA validating trading partners and Compliance check to validate trading partner data.
Reporting on the 837 P/I/D invalid data in the form of a 999.X12 transaction.
Archiving Oracle databases with mdq’s taking claim data information and populating them using sql puts.
Having real time data flows in ITX Launcher with IFD.
Using WTX Map Designer, Type Trees, Integrated Flow designer, Data base interface designer.
Passing the valid data to the Repriced/Adjudication process,
moving that data for a level 1 check, if valid after check, call the appropriate ITX map and process the data downstream to its destination,
else if invalid level 1 checks, move the invalid data to a separate error processing for internal reconciliation.
ITXA trading partner setups for X12 data with SPE.
IBM Applications Architect
Humana Corp HQ, Louisville, KY
Atos-syntel (headhunter)
Feb 2020 – Dec 2022
Managed group of 6 Developers, 1 Business Analyst and 2 offshore personnel.
Humana Application Architect and Team Leader IIB 10/ACE12 and ITX 9/ITX10.1.1 built 8 zLinux boxes Migrating from IIB 10 to Ace 12 and Sterling ITX 9 to Sterling ITX 10
Configuring ACE12 with ITX 10 and testing to ensure new flows worked correctly
Software Development Lifecyle (SDLC) in an agile environment with 2 week sprints on daily scrum meeting to project time and budget to meet the budget and monitor progress.
Oracle databases and tables for end points and errors and reporting New York State Medicare PACDR 837 P/I/D 834 Enrollment, 820, 835 999/277/TA1 Acknowledgements back to from New York State.
The daily scrum meetings around New York State constantly adding additional requirements proved to be a challenge for my team, but NYS kept paying the budget for these “functions” and we continued to create them to meet their needs.
Utilizing SQL statements query internal database tables and pull claim payment information to determine cost and analysis for HICPIC and Diagnosis codes.
Call stored procedures within data flows to determine business functions on 837 PID
Sterling SPE/ITXA v9 trading partner set up for z/Linux Deployment (8 z/Linux boxes.)
CICD Pipelines for deployments in GIT Azure Repos, Florida State Medicare 270/271, z/os Cobol Copybook to X12 270 from Batch to Realtime, 271 to Proprietary file layout into Oracle tables.
ITX\A Sr. Developer
Federal Employee Procurement Office Center / BCBS CareFirst, Washington, D.C.
Alta Its (headhunter)
May 2018 - Nov 2019
Created, Developed, and maintained WTX Maps for HIPAA X12 Transactions.
Created, Developed, and maintained IBM Transformation Extender Advance Launcher and compliance check process flows.
Build and implemented Blue Exchange Sterling ITXA Maps for 820, 835, 837P, 837I, 837D, 834, 270,271, 276,277, 999 in an IBM Sterling B2bi AIX environment.
Development to testing into production full SDLC in 2-week sprints, in daily Scrum Meetings as Agile methodology environment every team member taking turns being the scrum master.
Utilizing Jenkins for deployment to on-Prem cloud promoted all the SQL, Oracle, Sterling BPM with related ITX Maps and trees within GIT to DEV/QA/Prod environments.
Fully integrated a migration from existing ECMAP to ITX solutions for the 837 Professional, Institutional and standardization process for dental.
Extensive use of ITXA Compliance Check map managing IBM PMRs and technical documentation. Development of new workflows and full SDLC. Development to production full SDLC in an Agile methodology
IBM ITXA Architect / Sr. Application Developer
Superior Vision Inc. Baltimore, MD
Liberty Personal (headhunter)
Mar 2017 - Mar 2018
Created, Developed, and maintained WTX Maps for HIPAA X12 Transactions.
Created, Developed, and maintained ITXA Launcher and compliance check process flows.
Using ITX adapters query db2 with SQL statements that create type trees using MDQ’s.
Resource registry, MRN, MRC, Map Designer, Database Designer, Integrated Flow Designer as well as Launcher administration and Management console. process all transactions for healthcare X12 with Sterling ITXA
HIPAA X12 Transaction sets, 837P, 837I, 837D, 835, 820, 999, TA1, 270/271
Design, develop and manage internal systems and external trading partners. IBM Transformation Extender (ITX) and similar EDI translators Monitor and manage ITX processes.
Testing data integration from source to database tables using SQL, and agile methodology with 2-week sprints and daily scrum meetings with manager as scrum master.
Senior Programmer Analyst
AmeriHealth Caritas, Philadelphia, PA
Transfermations Inc (negotiated contract directly)
Jun 2016 - Mar 2017
Participate in the design and development solutions of EDI applications.
Participated daily stand-ups, weekly meetings with executive management and stakeholders.
SDLC of Code, through test, QA, Prod environments testing each to ensure data integrity.
develop documentation around the testing and new code creation.
Developed IBM Transformation Extender (ITX) and managed ITX processes for 837 (PID),277, 835, 999, TA1.
With ITX using the Integration database designer create the type trees from oracle tables and with 837 P/I data for claims to reconciliated 835 for payments.
Software Development Life Cycle for end-to-end testing, assuring optimum performance, availability, security, and capacity. Upgraded enhancements of EDI application/services
In an agile environment provides updated status and progress in projects and milestones.
Migration/Installation of IBM ITX/ITXA Software (on Site)
Capital BCBS, Harrisburg, PA
Co-enterprise (lead contractor sub-contractor of them)
Installation)
Oct 2015 - Dec 2015
Set-up of ACE 11 Sterling ITXA 10 in z/Linux environment exporting of old Trading Partner Manager trade links into new TPUI and MSSQL Database. Installation and configuration of ICD 10 2016 code values into SPE.
MS SQL Database SQL with ITX Applications reading and writing to tables.
Creation and installation of stored procedures for ITX into oracle tables
Updating old ICD 9 tables from pattern to code lookups and replacing those tables with ICD10 codex.
Handed off knowledge transfer in the form of documentation to client for further evolutionary cycles and sprints in agile work environment. AIX /Unix/ Windows
Migration/Installation ITX v9 IIB v10 (on site)
AmeriHealth Caritas, Philadelphia, Pa
Transfermations Inc (negotiated contract directly)
Sep 2015 - Oct 2015
ITX Maps for X12 Transactions 277, 837 Institutional, 835 created reviewed and implemented. Scripting created and tested with SPE called for software as a service (SaaS). SPE Performance Testing and deployment to DEV/QA/Prod.
Participating in Development and Project Planning/Migration in a management waterfall type environment.
Database SQL and ITX Application milestones for processes Quality assurance regions, then hand off to client for production support and further cycles in development and modifications. Linux/Windows
Handed off knowledge transfer in the form of documentation to client for further evolutionary cycles and sprints in agile work environment.
Sr. Application Developer
Costco Inc. HQ, Issaquah, Wa
VanderHouwen and associates (headhunter)
Jan 2015 - Sep 2015
IIB9 Broker Flows and WTX mapping retail purchase orders, Advance ship notice and Purchase order changes to Costco proprietary data model.
WTX trees, maps, and message flows for real time processing.
Oracle Databases SQL using Toad to test complex sql prior to putting in Broker Flows. Z/OS mainframe connections with WMQ and IIB Broker flows, used z/os file aid to check data in copybook layout.
Reviewed Cobol programs for modified downstream applications WTX Maps. Participating in daily scrum meetings and weekly sprints. Created and monitored Queue Manager Queues.
Client Technical Professional
IBM Corp, Jacksonville, Fl
Fulltime employee of IBM
Sep 2012 - Jan 2015
Deliver use case centric solution demonstrations to business and technical audiences. Consult with clients of all sizes and across industry sectors, leveraging technical expertise from sales counterparts.
Demonstrate IBM Industry Solution products and solutions at partner events, trade shows and conferences. Engage with existing and potential clients to identify business opportunities.
Technical consulting with clients and helping clients design technical solutions. Ensure client satisfaction with IBM solutions IBM db2 databases SQL at client sites for POC with WTX applications.
Proof or concepts with clients to demonstrate capabilities of the IBM Stack and stand up POC around the country at client sites.
Participated in lunch and learns at client sites and showing IBM software within the WebSphere groups.
Professional certifications
1999 - TSI Mercator, Danbury, Ct
2001 - Ascential Datastage TX Software Certifications, Boca Raton, FL
2012 - IBM Websphere Transformation Extender
Education
Cittone Institute
Princeton, NJ
Associate degree
Sep 1991 - Jun 1993
Focus:
Assembler 400, ANS Cobol / Cobol 400, RPG II, RPG III, RPG 400,AS/400 CL, JCL
Skagit Valley Community College
Oak Harbor, WA
Sep 1985 - Jun 1987
Focus:
Advanced Mathematics
Embry Riddle Aeronautical University
USS Enterprise/NAS Whidbey Is. Oak Harbor
Associates Degree
Mar 1985 - Jun 1987
Focus:
Jet Engine Power Plant (J52) of A6/KA6D Aircraft (Intruder), NAMTRAGRUDET (*active-duty US NAVY),A6E/KA6D Intruder Power Plant and Related Systems, AD “A” (A6 Intruder) Power Plant Systems)
Contact this candidate