Etl Solutions Developer Resume
PhiladelphiA
PROFESSIONAL SUMMARY:
Over 23 years of computer mainframe application systems analysis, design, development, testing, implementation, support, & maintenance, client server technology, mid - range computer system (AS/400), and Web technology
TECHNICAL SKILLS:
SOFTWARE: IBM WebSpere DataStage v8.5, v8.0.1 & v7.5, IBM WebSphere Transformation Extender v8.2, XML, XSD schema, JAVA, JSP, Servlet, JavaScript, HTML, COBOL, DB2, SQL, SPUFI, DB2 Stored Procedures, ORACLE 11g, SQL/PLUS, UNIX shell scripts, EAZYTRIEVE Plus (TSO, IMS, DB2), Expediter/TSO, CICS, IMS DB/DC, DL/1, MFS, BMS, Focus, VSAM, TSO/ISPF, JCL, NSYNC (TSO, DB2, IMS), FileAid (MVS, DB2, IMS), Focus, Version Merger, VIASOFT, IDCAMS, SyncSort, VISIO, Documerge, Comparex, ADR Librarian, MS Office, ChangeMan, Endeavor, EDISIM 5.0, Query 400, Query Manager, AS400 Stored Procedures & Commands using ALDON, MVS ESA, Z/OS, Windows XP PROF, Windows NT, Windows 95
HARDWARE: UNIX AIX, Windows Server 2003(Enterprise Edition), IBM 3090, UNIX SunOS 5.8
EXPERIENCE:
Confidential, Philadelphia
ETL Solutions DeveloperResponsibilities:
- Provided development, maintenance, testing, implementation, production support and documentation to ETF Re-engineering mainframe application system using COBOL II, DB2, SQL, JCL, INSYNC, Endeavor, Vizio, FOMI, Control-M
Senior Systems Analyst
Confidential
Responsibilities:
- Provided development, maintenance, testing, production support, and documentation using IBM WebSphere DataStage v8.5, v8.0.1, & v7.5 in the UNIX AIX and Windows Server 2003 (Enterprise Editon) environments accessing Oracle 11g, UDB DB2, and DB2 AS400. Coded UNIX shell scripts for the FTP protocols.
- Developed data mappings (XML and .xsd file formats) for the HIPAA transaction using WebSphere Transformation Extender (WTX) v8.2
- Part of the team that delivered a new software solution implemented in the Collections Department that improved efficiency and delivered cost saving results.
- This involved prototyping screens for the front-end using HTML; coding JavaScripts, Property files, JSP’s(Java Server Pages), JAVA programs, and modifying ServLets using WebSphere Application Development v5.1 as well as modifying and coding COBOL DB2 programs in the mainframe for the database retrievals.
- Provided development, maintenance, testing, production support, and documentation to various mainframe application systems (batch, on-line, & DB2 Stored Procedures) using COBOL II, EAZYTRIEVE, JCL, IMS, CICS, DB2, SQL, INSYNC, SPUFI, in IMS & DB2 databasesAS400 using Query 400, Query Manager, AS400 Commands with the ALDON interphase, Expediter/TSO, Endeavor, FTP, NDM, VSAM, FileAid, SQL/PLUS, VISIO, and EDISIM 5.0
- Awarded Best of the Best for 2005 as part of the team who designed and implemented a new IHM benefit-query tool providing unprecedented real-time access to MHS-derived member benefit data, electronic Member Welcome Kits, electronic Group Contracts, and situation specific Claim Payment Policy. This tool enables greater decision-making as well as improved quality review
- Awarded Winners Circle for 2003 as part of the team that implemented the ValuTech System. This is a claims payment management system that provides the ability to monitor and manage the timing of payment for all claim types. This resulted in both internal and external customer satisfaction, process improvement, and cost savings to the company in excess of $500,000