Robert Scheffel Email & Phone Number

Westport, CT

• Verify financial data integrity, writing complex SQL queries for pre/post-ETL processing of Accounting database into oracle Data Warehouse.
• Troubleshoot ETL target data using ad hoc SQL queries, Error Logs, and Data Mapping Documents; determine if problems are due to bad source data or due to ETL processing.
• Verify Report data from automated Data Reconciliation tool, ensuring its reports are showing correct data, consistent with independent SQL queries. Investigate any differences between report data and SQL data, and.
• Develop Excel VBA macros to consolidate data from multiple spreadsheets into one, aggregating and calculating Trending results. Report allows monitoring of daily data loads.
• Create custom SQL reports in ALM to pull Test results from ALM for daily status meetings.
• Determine appropriate business keys for correct querying of tables.

Stamford, CT

• Defined Usability/UX Guidelines for creating a positive User Experience for next generation Medical Imaging product. Guidelines defined Information Architecture, behaviors, appearance, and aesthetics for an intuitive.
• Managed testing of new features, mentoring team of six Testers; defined process for mapping functional requirements into Test Cases, ensuring that all Requirements were covered; oversaw the progress and test coverage.
• Recorded Virtual User Performance scripts, troubleshooting and enhancing scripts to embody desired functionality; incorporated these Virtual User scripts into Load Test scenarios.
• Maintained QTP/WinRunner functional test scripts, updating existing scripts to make calls into new Framework functions; maintenance involved updating perl scripts that were invoked from QTP.
• Identified Process points of failure, advocating and implementing improvements.

• Functional testing of worldwide Property Management system; used advanced techniques to verify correct data for all three application tiers, from Oracle data tier (SQL), through web services tier (SOAP/WSDL testing).
• Lead on Performance testing effort; recorded and enhanced LoadRunner scripts, and correlated scripts to handle dynamic data returned by the server; designed sets of scripts to cover important User profiles, and created.

Wilton, CT

• Developed data-driven QTP scripts for 30 reports, to ensure that report output remains correct and unchanged with each release of software. Automation embedded utilities to convert PDF to Excel, and compare baseline.
• Created LoadRunner scripts that record baseline performance numbers; for each release, identified any changes from baseline performance numbers.
• Used SQL to troubleshoot database/application problems, and verify fixes.
• Verified Hyperion BI reports by comparing report data with independent SQL queries from the underlying databases; verify that ETL process has no loss/change in data from one data transform to the next into the Data.

QA Lead on Foreign Exchange (FX) Options Trading Project; N-tier architecture employing Delphi GUI / Java Application Server / Oracle Database. Develop test scripts covering recordings of over 30 different FX Option types, including American, European, Exotic, Partial, Compound, Complex, and Exchange Traded.Construct manual Test Scripts, derived from Use.

Hired team of seven QA Analysts to provide QA core competencies to the company. Established goals and identified process improvements to optimize Software quality. Implemented proactive QA processes to build better software, and reactive QA measures to inspect and test the software that has been built.Technology exposure: Visual Basic 6.0, ActiveX/DCOM.

QA Lead; managed QA and testing effort for strategic Internet application; development effort included ten Developers and four QA Engineers.Technology exposure: Visual Basic 6.0, ActiveX/DCOM, Internet Information Server (IIS) 4.0, Microsoft Transaction Server (MTS) 2.0, Active Server Pages (ASP), Microsoft Message Queue (MSMQ), HTML, SQL Server 7.0, RSW.

Analyzed critical Sprint applications to understand all issues involved with migrating applications from Connecticut facility to Virginia facility. Provided VB code maintenance, troubleshooting, and resolution of all configuration issues to ensure 100% successful migration effort.Project Tracking ApplicationVB ActiveX Document application employing IIS.

Data Migration ProjectDesigned and implemented migration of critical corporate mainframe database to new SQL Server tables for custom Client/Sever application.Used SQL Server bulk copy program (bcp) to export/import corporate mainframe data into intermediate SQL table structures; worked with customer's mainframe personnel to troubleshoot and correct.

Designed and developed software documentation and operations manuals for international lottery firm.Developed and implemented abstracts for project lifecycle documentation, including Software Requirements, Software Design, and Functional Specification.Developed operations manual for retail lottery agents. Developed DEC VAX/VMS configuration manual for.

Authored proposals in response to RFPs for computerized Toll Collection Systems. Interviewed engineers and technicians to obtain technical, background information for RFP.

Implemented Computer Integrated Manufacturing Software (CIMS) for a major computer manufacturing firm; OS/2 software written in C and Presentation Manager. Prepared technical documentation to improve understanding of CIM architecture among consulting group.

Developed Clipper/C applications software for Electrical Metering Project. Software development involved remote data acquisition via modem, system configuration, data management, reporting, and archival subsystems. Installed software/hardware at customer site. Provided software/hardware support, documentation, and data analysis for end-users.

Implemented MIS software using PRO-IV relational database language, running under UNIX, for complete HMO system. Gathered requirements from end-users.Implemented working design into software modules, under guidance of MIS Director. Developed and maintained software documentation and end-user documentation.

Bachelor Of Arts, Mathematics And Computer Science

Ba, Mathematics And Comp. Sci.