Jim Peuster Email & Phone Number

Kansas City, Missouri Area

- Data Warehouse Development- Develop requirement, test, and deployment documents- Worked with Hyperion 11 Studio and web interactive to create and process reports- Developed and maintained UNIX shell and SQL scripts

Kansas City, Missouri Area

Contracted to UMB Bank to provide Data Warehouse programming support.Authored requirement, test, and deployment documentsWorked with Hyperion 11 Studio and web interactive to create and process reportsDeveloped and maintained UNIX shell and SQL scripts

Greater St. Louis Area

Support the role of Oracle Application DBA via PL/SQL programming, DB tuning/debugging, and other skills as needed.

Provided Oracle Application DBA and configuration management services to Northrop Grumman.

Support office and field staff in an automated field data collection environment.Report to the Local Census Office Manager on the status of the technology used in the office and take action to ensure that the technology is available.Provide technical guidance and support to all staff for the various automation activities for each operation.Evaluate and coordinate automation operations to efficiently support all office functions.Select, train and supervise Technical Support Supervisors.Responsible for managing property assets.Conduct onsite LAN/WAN hardware diagnostics for infrastructure cabling and hardware such as Customer Switching Unit/Digital Switching Units (CSU/DSU), router, switch, NetWare servers, PC's and Voice over Internet Protocol (VOIP) telecommunications. Deploy and configure the Live Scan digital fingerprinting system. Monitor its use and provide technical guidance.

Administer Microsoft Office applications and Active Directory server. Develop and document special projects that include syncronizing global calendar with Pre mobile device, and consolidation of multiple contact list sources into one global contact list. Create documentation using ESRI ArcGIS tools to meet the requirements of the planning commission.

Managed the process for creation, quality assurance, and delivery of geo spatial enabled data layers. Data layer formats include ESRI shapefiles, Garmin POIs, and Google KML.Created web based documentation of the MCH Geo process using WIKI and Open Office draw. Used the documentation to cross train MCH personnel. Managed the deployment of an ERDAS TITAN GeoHub. Coordinated with ERDAS support to ensure a quality deployment. Redesigned the MCH data layers used by the GeoHub to be user friendly.Configured the SRC Portfolio Explorer and ESRI geocoding engines for geocoding the MCH data layers.Conducted a study to compare the point placement from multiple geocoded sources. Documented the findings and presented the findings to management.Utilized Alteryx to automate the creation of the quarterly data layers in order to provide a quality data layer.Utilized ESRI ArcGIS tools to verify the integrity of the shapefile and to verify the location of the geocoded POI.

Lead a work team in the planning, testing, and deployment of a new Oracle database server. In the process, documented the existing process infrastructure environment.Designed, developed, and deployed software solutions that transformed data and created reports using Oracle tools, Windows NT scripting, and ETL tools. Improved the existing data load process, both in quality of the data and decreased the time required to execute the load.Created web based documentation of the data load process using WIKI and Open Office draw. Used the documentation to cross train MCH personnel and to provide a working repository for the process. Administered application objects in an Oracle 9i and ACCESS database environments.Deployed personal development environments using Oracle 9i and 10g. Evaluated and recommended database engines and development tools.

Managed a virtual User Acceptance Testing team that interfaced with the business UAT team for the deployment of a new directory application.Coordinated with business UAT lead to jointly develop the test plan for the multiple test cycles based on specifications provided from the Project Management Office and the development teams.Coordinated with the UAT test team, the development teams and system infrastructure team to identify and provide data environment required for successful execution of the client’s test cases. Worked with the business team and the Amdocs team to identify and resolve defects found during the test cycle.Participated in meetings to resolve defects, review test execution, and make software go/no go decisions.Used Mercury Quality Center to create and track test requirement requirements/rules, test cases, test sets, defects, and progress. Mentored testers on the use of the tools used during a test cycle.

Coordinated development of work plans to map and verify milestones for testing and deployment of vendor releases.Coordinated capacity planning of Oracle and HP/UX environments to ensure availability and optimal performance.Coordinated disaster recovery plans for the workgroup and the software application.Designed, developed, and deployed software solutions that transformed data and created reports using Oracle tools, UNIX scripting, NT scripting, C, PERL, COBOL, and MQ Series.Designed, developed, and deployed web applications that access Relational Database Management Systems using JavaScript and PERL.

Developed deployment plan for initial installation and follow up releases for a white pages directory application.Coordinated with the application vendor, infrastructure groups, and internal development team to develop a plan to test vendor releases for the white pages directory application.Coordinated with the application vendor, infrastructure groups, and internal development team to ensure the test environment was configured and ready for the vendor release testing.Coordinated with the internal development team to evaluated and recommended development tools.

Developed and implemented software and hardware solutions for Designated Operator Services, Prepaid Calling Card, E911, Computer Aided Dispatch.Developed software to create billing records and reports from a telephony switch output logs.Administered application objects in FoxPro and MS SQL Server database environments.

Developed and implemented software applications using SQL, COBOL, and SCOBOL.

Designed, implemented, and maintained financial application systems.Provided technical solutions for applications utilizing multiple computing platforms.