Robert J. Ohrstedt
Download this as a Word Document
References available on request.
Experience |
|
DataScan Technologies / GA Current Job Description: New Development, enhancement and maintenance of very large banking applications for Application Service Provider. Interface with Web services through XML, external applications via EDI. Leading team of 9 Developers in various technologies, including Visual Foxpro, Visual Basic, Oracle, Active Server Pages, COM, DCOM, IIS.
Glenwood Middle School / VA 2005 Adding Homework component to middle school web site. Using HTML, PHP, C#, MySQL to allow teachers to post homework assignments and students to see assignments. Site design, Page design, Data analysis and schema developed using Visio. Utilizing Visual Studio 2003 for construction.
M. Leco & Associates / PA 2004-2005 Responsible for business analysis, data analysis, business process optimization, new systems designs, integration and project management for all current mission critical applications. Modeling of Business Processes, Data Flow architecture, Data Definition, Database Schema, Taxonomy, Data Integration, XML Data Migration, Web Services and User interface design and development. Developed Data Interchange from numerous Hospital systems to and from in-house collection systems, Migrated data from numerous sources into SQL Server via XML. Migrating applications from FoxPro 2.6, VFP 5, VFP 7 to VFP 9 with SQL Server and .NET integration; enabling for Web access to in-house software, integration of mobile technology, document imaging and management, FTP and data exchange services. Programming in Visual FoxPro 9, SQL Server 2000, XML, SOAP, C#. CASE tools included Visio, DbDesigner, Microsoft VS Modeler.
GCom2 Inc. / PA 2003 Developed and maintained compliance reporting applications for the mutual fund industry. Responsible for business analysis, data analysis, data migration and integration between disparate systems and into SQL Server. Administered and Re-developed corporate website in accord with specifications written by the marketing department. JavaScript, COM, HTML, DHTML, Web Services, SOAP; Extensive use of VFP 7 and Microsoft SQL Server. Data and interface models developed with xCase, Erwin and Visio.
Political Campaign / OH 2002 Designed, developed, monitored, and assured accuracy of system to electronically transmit campaign finance reports to secretary of state. Integrated local solution with requirements of state electronic filing system. Designed, developed, and maintained campaign web site on my server, using HTML, DHTML, COM, JavaScript, VBScript, Oracle, XML, SOAP, Visual FoxPro 6 &7. Developed site design, process model, interface design, data integration with state government’s Campaign Finance Database.
State of Ohio / OH 2002 Migrated government accounting system reporting module. Introduced Visual FoxPro’s Object Oriented Design and construction model by explaining concepts and methodology for rapid application development with VFP. Analyzed business processes and system under development to deliver open architecture reporting module.
Mark-Ed Resources / OH 2002-2003 Brought inventory and ordering system to the web as an on line catalog and shopping cart according system. Project management, supervision of sub-contractor, troubleshooting design issues, and technical issues, proposed solutions, constructed catalog / cart. Used XML to communicate between in-house, shopping cart and Web service, assuring synchronization of data. Integrated web application SQL data with in-house FoxPro based system. Used Visual FoxPro 7, SOAP, HTML, VBScript, JavaScript, Microsoft SQL 7, Internet Information Server.
Cleveland Housing Network / OH 2000-2001 Define Requirements, Design, Develop, Deploy and support custom applications for Community Redevelopment Organization. Responsible for the maintenance, documentation, support and creation of mission critical applications for project management, construction, real estate transactions, rental property administration, fund raising, and neighborhood statistical profiling. Assisted in Network maintenance, troubleshooting, and repair. Assisted with web site support, troubleshooting, and maintenance. Supervised up to five other programmers. Led project development teams. Initiated solutions for business opportunities, and led development of applications. Use of CASE tools to speed analysis and design work, including Microsoft Visual Studio Modeler, Visio, xCase.
Cuyahoga Community College / OH 2000 – 2003 Teach courses in Object Oriented Analysis and Design, Systems Analysis and Design, Use of models and CASE tools for understanding businesses processes, data flow, system requirements, data schema, database and User Interface development. Introduced Stored Procedures in both Microsoft SQL Server and Oracle. Led students in design lab with Visio and Erwin. Designing Web Pages, SOAP, Data Communications, DOS for Technicians, A+, Networking, Software and hardware troubleshooting, Computer Concepts, Internet Technologies, networking, network administration, data administration and migration, data interchange and modeling..
InfoDoc / OH 2000 Client support and maintenance of custom line of business application for tracking shipment of automobiles from factory to dealer. Design, Develop, Debug, and deploy fixes, enhancements, and changes as ordered by clients. Data interchange with proprietary auto manufacturer’s inventory and transportation systems. Utilized both Visual FoxPro 6 and Microsoft SQL Server 7. CASE tools included Visio and xCase
L&S Courier / OH 1999-2000 Analyze, design and development application to integrate delivery tracking, vehicle use, billing and receivables for mid-size floral delivery service. Modeled processes, data flow, data exchange and developed schema and User Interface with Visio and xCase. Microsoft Visual FoxPro 5.0.
Cleveland Clinic Foundation / OH 1999 Develop application for payroll department to track United Way contributions, send reminders, acknowledgements, etc., and assure withholding and distribution of contributions per instructions of employee. Analyzed process, data flow, established data definitions and schema, utilized both text and XML for data interchange. Microsoft Visual FoxPro 6.0, Oracle, Microsoft SQL Server 6.5. Microsoft Visio and Visual Modeler were primary CASE tools.
International Paper / PA 1998 Analyze, design, construct, and deploy application to facilitate real-time monitoring of paper manufacturing process. Lotus Approach user interface, Visual FoxPro middle tier, and MS SQL database, data interchange with proprietary process management applications, Data flow, Data Definition and Schema development.. Utilized Visio as CASE tool.
Council of Churches / PA 1998 Design, develop, deploy, and support a system for fund raising, membership monitoring and retention, organizational change and strategic expansion
Various Local Churches / PA 1987-1999 Design, develop, deploy, and support Church Fund Accounting and membership tracking system. Support, troubleshoot, and repair of hardware, software, and operating system issues.
American Industrial Painting / AL 1987-1990 Design, develop, deploy, and support accounting system for major industrial painting company. Support, troubleshoot, and repair of hardware, software, and operating system issues.
Volunteers of America / OH 1984 – 1987 Directed the planning and implementation of new computer technologies for a large, non-profit organization. Used FoxBASE to develop specialized database applications, designed workflow procedures, re-organized and supervised customer service / call center staff. Organized and coordinated PC use for administrative functions, developing applications and procedures to streamline operations and make staff more productive. Tripled proceeds from fund appeal in one year. Doubled contributions of in-kind goods. Reduced call center expenses by one third with automation.
Evangelical Lutheran Church in America /IL 1980 – 2001 Pastor: Direct / Administer organization; plan, direct and lead programs and projects; strategic planning, conflict resolution, advertising, sales, member care, teaching youth and adults., public speaking at community functions, weekly preaching. Preparing lesson plans and teaching, public presentations, governing documents and reports, fundraising, direct mail and telephone campaigns for outreach. Published newsletters for both parish and community.
|
Education |
|
Master of Sacred Theology |
|
|
1993 Trinity Lutheran Seminary |
Columbus, Ohio |
|
American Religious History |
|
Master of Divinity |
|
|
1980 Trinity Lutheran Seminary |
Columbus, Ohio |
|
Theology and Ministry |
|
Bachelor of Arts |
|
|
1975 Capital University |
Columbus Ohio |
|
History and Philosophy |
|