Daniel Wise Email & Phone Number

Database Field Expansion ProjectIBM System iRPGLE, RPG--, RPG/FREE, CL, CLLE, SQL, DB2, WDSC--RDPI

Refund Premium Project. .- State Rate Change (NC and TN). - DB Designed within ILE environment.- I5/OS,RPGLE, ILE/FREE, CLE, DB2, SQL,and Aldon . - Corporate level project.

BCBSNC (Healthcare). See information under Blue Cross Blue Shield project.Phase III consisted of completing NC state mandates for healthcare reform by adding enhancements to the existing real time healthcare insurance members database. This four-phase project has a statewide impact and is scheduled for completion in June 2011.

Implemented and upgrade to a SOA COBOL ILE /DB2 TCP/IP interface. The client needed to upgrade their newly implemented member(s) database application (PowerMHS). This contract involved documenting the legacy system, updating client on what the application does, fact finding, performance tuning with iDoctor tools, new development, coding error handlers, and training. Project also involved the rewrite of COBOLII programs batch code from the Original Programming Model (OPM) to an Integrated Language Environment (ILE) developing new applications using COBOL ILE, JDBC, XML, procedures, embedded SQL, API's, service programs, and binding language. Created and implemented datamart for reporting. Addition, responsibilities included assignments within all phases of SDLC (specifications, design, development, testing, integration and support).

Developed and implemented a real time message exchange socket communications protocol using service-oriented architecture (SOA), voice, service implementation, elementary access details, Contract, RPGLE, CLLE, RPG/FREE, embedded SQL, and service instance. This real time banking application interface saved the company over $1,200 in license fees per each core install, replaced a (third party) 5250 utility and greatly simplified the process for externalizing ILE business logic. As team project leader, I led a team of three through planning, data modeling, development and deployment of a .com third party package. The package converted AS400 green screens to GUI giving the application a Windows look and feel. The package allowed rapid deployment and real time updates for core screen configuration. Developed combined and enhanced voice and internet banking batch interfaces, Streamlined and enhanced internal applications; modernized management solutions and added functionality into a modern application framework; also, automated manual processes which simplified the supply process and reengineered core systems without major disruption. Finally, additional responsibilities included assignments within all phases of full life cycle development of core banking applications. Also worked with other core vendor applications to interface with this client real time services (CBS, JH and JHS)

Primary assignment involved the auditing of the company accounting applications. Assignment also involved the development and programming of new modules and service programs to update AR, Claims, and GL systems using a combination of COBOL400, embedded SQL, CLLE, and COBOL/ILE procedures. Implemented archive rule for production and new reporting to catch out-of-balance conditions within the cycle processing during month-end closing. Also implemented and coded new programs to report pay mode and pay code changes for online processing, reengineering core systems without major disruptions. In addition, analyzed and developed new documentation outlining the new development within the Point insurance applications, analyzed and collected perfommance data to improve system batch processing.

Developed and implemented new software modules, object programs, service programs to enhance and automate online processes within Claims Adjudication applications using a combination of RPGIII/400, RPGIV/ILE, CLLE, embedded SQL, COBOL/ILE and Java programming code on the AS400. Also, troubleshot and resolved OPM and ILE objections issues within the nightly cycle processing. Project included 80 hours of in-house training on existing Claims adjudication system applications.

Cluster LeaderResponsibilities include managing and developing the Year 2000 project for European sector subsidiaries in Italy, France and Germany. Project involved Y2K date conversions on the AS400 and ES9000 platforms using RPGIV, COBOLII, COBOL/400 and CLP. Also designed and implemented a knowledge database to record problems and eventual resolutions encountered during testing and implementation of the modified code rollout. Other project tasks included project risk and quality estimating, project planning, end-user interfacing, methodology, programming applications changes to meet Y2k standards renovation, troubleshooting and problem resolution (within the full Y2K cycle). Another achievement was the implementation of an automated testing tool (WinRunner) in the AS/400 environment.

Responsible for development of a data warehouse using DATAMART to unite 21 remote AS400 sites online using the following: VB, Crystal Reports, ODBC, sub-file processing, JCL, CLP, DB2, SQL, COBOLII, COBOL400, OCL and CL. Assisted in development of Y2K procedures, using ISO Date format to modify the in house applications to ensure accurate date conversion for the cost and maintenance (Legacy) applications. Additional enhancements and new developments of online/batch processing applications utilize COBOL400, CLP, EMBEDDED SQL, DB2, on the following platforms: ES9000, AS/400, S/36 and Microsoft LAN. All enhancements and applications were developed and maintained for manufacturing and financial applications with new code per user specifications (ad-hoc reports). File design utilized DDS, VSAM and DB2 (tables). In addition, provided problem management and user support for new/existing applications in the newly linked sites nationwide.

Modified and enhanced the MRP applications between two platforms using COBOLII on the (ES9000), COBOL/400, RPGII and RPGIII on the (AS400). Developed, tested, and installed in-house reporting applications within the Operations Center. Worked with acquisition team on data and method analysis; help developed and implemented five-year Strategic Systems Plan. Other accomplishments include instituting Disaster Recovery Policies/Procedures and the reduction of paper expense by $45K annually, with the design and implementation of an end-user reporting database.

Help developed tax strategy used to implement online tax transactions.Trained personnel on PC-based interim application and maintained supplier relations with software partners. The transaction process represented 20% of each division's tax collection.