Robert Fair Email & Phone Number

Database Developer• Designed, implemented, and maintained database objects including tables, views, indexes, foreign keys, stored procedures, user functions, and especially queries.• Used multiple relational DBMS platforms including Microsoft SQL Server, MySQL, PostgreSQL, and Oracle for a variety of projects and clients.Analyst/Developer• Developed requirements and design for web-based front-end to an identity and access management system.• Created screens using Visual Studio 2008, C# and ASP.Net.• Designed database tables in SQL Server 2005 and implemented business logic using stored procedures, views and user functions.Business Systems Analyst• Worked with users to define business requirement document (BRD) and wrote functional specifications for development• Modified existing stored procedures to fit the new environment. • Created queries to compare contents of each database table in test environment with corresponding production data. • Wrote bash script to be executed daily for running the new application against all of the input files.• Created test plan and test scripts • Used SQL for data manipulation in test staging and validating test results• Executed tests and logged defects into defect tracking systemLoad & Performance testing• Tested client web applications, using NeoLoad• Created test scripts from business process documents and information provided by the client, parameterized test scripts and validated scripts• Identified business cases to be used in the load test• Identified user profiles• Mapped business cases to user profiles, and allocated percentage of total virtual users to profiles• Prepared and presented reports detailing test results

Client: State of Ohio Bureau of Workers CompensationRole: Production Control AnalystProject: CMT (Change Management Transmittal) system• Maintained CMT (Change Management Transmittal) system, a web-based change management system written in ASP.Net and VB.Net with SQL Server database back end and Access reporting front end • Worked with all other BWC IT teams to troubleshoot problems with CMT system and solicit requests for improvements to the system • Wrote stored procedures and requested changes to database schema to support the changes • Scrubbed data and performed ad hoc queries for management • Wrote documentation and training material for CMT system • Documented existing production control processes and trained other team members in use of SQL, FTP, and IBM mainframe software tools • Administered CA:DocView database to control distribution of mainframe reports to Windows workstations • Performed production scheduling tasks on both IBM mainframe and UNIX platformsClient: CoreComm TelecommunicationsRole: DeveloperProject: Call Rating System• Maintained call rating application written in COBOL on OpenVMS operating system with Oracle back end database • Sole responsibility for reconciliation testing of rater data setup to support acquisition of new companies and conversion of their rating systems • Improved tools and utilities, such as centralized FTP script, e-mail notification to users of job start and completion, job scheduler changes, error detection and notification, source code management, compilation/link script, and raw file formatted dump utility. • Trained and advised client personnel on FTP, OpenVMS job control language DCL, SQL, and C language programming

Client: Qwest Communications (CenturyLink)Role: Lead Developer• Redesigned and directed a programming team to implement a system to replace hard coded logic with a flexible table-driven design. • System collected statistics from dial-up sessions and aggregated them for monthly billing.• Written in Oracle Pro*C on the OpenVMS operating system.Client: AirTouch Cellular (Verizon Wireless)Role: Developer• Designed, programmed, tested, and implemented a system to validate correctness and completeness of call record files received from a data transport system, prepare the data for input to the message processing system, and generate audit reports for the Revenue Assurance department. • Developed requirements for the system. • Performed the Year 2000 review and remediation of the Call Record Processing system. • Software tools included C, Oracle Pro*C, COBOL, BASIC, Oracle SQL*Plus, DCL, and PERL under the OpenVMS operating system.Client: LiTel Telecommunications/LCI (CenturyLink)Role: Developer• Worked on a multi-year project to replace the company's business systems with an integrated fourth generation language and relational database product called CA:DB running under the OpenVMS operating system. • Wrote approximately half of the conversion programs to translate customer and product data from flat files to the database. • Rewrote major batch subsystems Cycle Merge, Non-Metered Event Creation, and Summarization. • Troubleshooting Order Entry, Pricing and Call Record Processing systems. • Designed and implemented processes to convert multiple acquired companies' billing data and integrate into the centralized system.Client: Bank One (Chase)Role: Developer• Installed and implemented an MSA Fixed Assets Accounting system. • Converted assets on the existing system to MSA while successfully responding to rapidly changing requirements. • Written in COBOL running under the MVS operating system on an IBM mainframe.

Master Of Science, Aeronautical And Astronautical Engineering

Bachelor Of Science, Mathematics