Bill Van Den Langenberg

Experience

• 

  State of Wisconsin Department of Health and Family Services DHFS DHSS

  Jul 1985 - Jul 1997

  Multiple Positions - Roles from Senior Programmer/Analyst – Team Lead

  • Lead the construction of all processes of source manipulation and translation• Responsible for anywhere between 2-25 programmer/analysts from 1985-1998. This included assigning workload, training/mentoring, reviewing status reports, resource requirements, and project deadlines/milestones• Developed the task lists, time estimates, and identified project deliverables• Implemented Storage Management System (SMS) and print output standards in JCL• Coordinate resolution of security problems, and provide a utility to implement the changes to the system• Worked with end users to define the business requirements for data retention and generate the technical specifications for the system to reduce storage costs by implementing new SMS standards• Determined business requirements and developed project definitions• Completed technical analysis and design• Monitor program changes and implementations• Acted as liaison between client and programmers for any clarifications or corrections• Developed agency-wide standards and procedural documentation• Developed productivity enhancing tools. Provided training to 30-40 IT staff on the uses of these tools as well as the uses of VIA SOFT and FILE-AID• Awarded for designing, developing, testing, and implementing an interactive front-end for a major State system to replace State's Income Maintenance Programs obsolete distributed batch data collection system• Designed, developed, tested, and implemented major system enhancements• Awarded for designing and developing an on-line query that combines information from three separate state systems. This query was developed to meet an external customer’s needsPlatform: MVS, DB2, CICS, IMS, IMS/DC, MFS, COBOL, SAS, JCL, ASM, REXX, JobScan, ENDEVOR, DCPX Show less

• 

  Brady & Company - IntelliMark IT Business Solutions

  Jul 1997 - Dec 1999

  Consultant
• 

  State of Wisconsin Department of Health and Family Services DHFS

  Jul 1997 - Jun 1999

  Independent Consultant

  ENDEVOR Administration Services and Library Management

• 

  State of Wisconsin Department of Workforce Development DWD

  Jul 1997 - Jun 1999

  Independent Consultant

  ENDEVOR Administration services and Library Management

• 

  Great Lakes Higher Education

  Jul 1997 - Sept 1999

  Consultant - Roles from Senior Programmer/Analyst – Team Lead

  • Analyzed programs, prepared program specifications, coded, tested, and implemented program changes• Helped 2 programmer/analysts identify business requirements for additional program specifications.• Participated with IS staff in data mapping sessions between Great Lakes and North Star business clients• Developed program specifications to validate and merge data extracted from the North Star system with Great Lakes data• Provided recommendations, impact analysis, task lists, time/effort estimates, and identified project deliverables• Lead data mapping sessions to incorporate Georgia data into the Great Lakes system• Investigated and resolved business and technical issues between Georgia and Great Lakes clients or IS staff• Prepared program specifications for other programmers and reviewed all test results with clients• Developed system test plan, prepared data, and implemented system tests• Lead the activities of 3-5 developersPlatform: MVS, DB2, CICS, COBOL, SAS, JCL, FTP, Foxpro Show less

• 

  Sundial Software

  Dec 1999 - Dec 2016

  • Web application development using Visual Studio C# and VB, ASP.NET, MVC, JavaScript, HTML, LINQ, etc.• Experience with SQL Server Management Studio (SSMS), SQL Server Reporting Services (SSRS), TSQL, Stored Procedures and SQL Server Integration Services (SSIS) • Develop new SQL Server Integration Services (SSIS) packages to meet business needs.• MS SQL table creation, manipulation, and stored procedure implementation• Develop exports and queries that meet provided specifications. • Develop and test stored procedures, views and functions. • Perform quality checks on reports and exports to ensure exceptional quality.• Design and develop SQL databases and write applications to interface with SQL databases. Show less

  • Microsoft Developer

    Aug 2012 - Dec 2016

  • Multiple Positions

    Dec 1999 - Dec 2016
• 

  Lands' End

  Jan 2000 - Jul 2012

  Consultant

  Multiple Roles• File transfer script & process administration utilizing PGP encrypt/decrypt, zip/unzip, Solaris Bash, Ksh, and Perl, and Windows VB script for secure Windows Share, FTP, SFTP, FTPS, and SSH transfers• Research, analyze, document, and migrate data transfer processes to IpSwitch’s MOVEit Central & DMZ• Designed and implemented custom integrations between MOVEit and subversion, TortoiseSVN, the enterprise scheduler (ESP), and the enterprise Monitoring package (Xymon) using the ESP API, MOVEit API, XML/XPath, Visual Basic script, z/OS Java, and JCL• ENDEVOR and Change Man Administrator• Propose, design, document, present, code, test, and implement many ChangeMan and ENDEVOR productivity, efficiency, and usability enhancements including enterprise scheduler, email, Assyst incident and change tracking, and Service¬-Now (cloud based incident and change management system) integrations• Problem determination, analysis, and solution development• CICS object definition, installation, and trouble shooting• Infrastructure upgrade project proposals, planning, management, and implementation• Document new and obsolete feature and functionality changes, and install, configure, test, and implement vendor software upgrades and maintenance for ChangeMan/ENDEVOR, Compuware tools (ABEND-Aid, XPEDITOR, File-Aid, and Strobe), ASG Jobscan/SeaSoft JCLplus, MOVEit Central, and MOVEit DMZ• ISPF Custom application and tool development and supportPlatform: Windows, Solaris, MVS, DB2, CICS, COBOL Show less

• 

  WebMD Ignite

  Dec 2016 - now

  Data Engineer

  • Defined Oracle and Greenplum databases and created and coded custom Python, Linux, and SQL scripts to load data.• Analyzed, validated, and reported data accuracy for client acceptance.• Modified MEDICOM (health risk assessment) ingestion system for new version 3 set of files layouts. • Enhanced the system to automatically ingest version 2 and 3 data into individual client databases. • This eliminated the need of having to create and run custom coding for each client.• Provided configuration entries for use by Automic for automation.• Utilized Jira in a Kaban environment for task assignments and documentation.• Defined and configured standard parameters and configuration entries for new client data ingestion, processing requirements, and tools like internal validation and calculation software, AWS S3, Birst, Eloqua ...• Monitored and debugged data ingestion processes for client data.• Validated data accuracy and trends and reported results.• Investigated data anomalies. Show less