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 enter/process defects to resolve discrepancies.• 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 UI; defined an obvious and consistent Navigation scheme, consistent appearance and behavior, and designs to preempt User confusion; identified usability deficiencies in the Product, and reflected usability concepts into improved UI mockups.• 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 for these new features. • 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), through UI data as it shows up on front end web pages; constructed complex SQL statements to assess and troubleshoot three tiers of data (DB, XML, UI), and verify defect fixes.• 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 various mixes of these profiles to test different Load usage scenarios; coordinated Performance Testing sessions during off-hours, executed tests, and published results for Management.

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 Excel spreadsheets with latest-run spreadsheets.• 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 Warehouse.

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 Cases and GUI specs; manage all Test Scripts in TestDirector; ensure that Test Scripts are updated to stay in synch with latest Change Request spec changes.Develop automated Test Scripts using WinRunner 7.0, and coordinate automation of critical Functional Areas Track Defects from discovery until resolution, using internally developed (Lotus Notes) Defect Tracking tool Worked on testing methodology for testing Java application tier before GUI becomes available; objective was to test Java components early, rather than waiting until GUI availability. Testing facilitated with JUnit, a set of utility classes for writing Java test code to instantiate and exercise Java application objects, and capture results for comparison with expected baseline values.

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, Internet Information Server (IIS) 4.0,Active Server Pages (ASP), HTML, SQL Server 7.0, WinRunner/LoadRunner, TestDirector, PVCS; Internet Health Care ApplicationDefined QA roles and process for those roles to ensure coverage of QA core competencies: Test Plan construction, Manual Testing, Automated Functional Testing, Performance Testing, Defect Management, SDLC process, QA Process, Release Management. Installed Mercury suite of QA tools: TestDirector, WinRunner, and LoadRunner for Enterprise use.Specified format for written Test Plan, and coordinated testing of separate functional areas by QA Analysts; testing effort included manual/automated Functional Regression Testing, Performance Testing, and Usability assessment.Guided QA Analysts' automation work, and assisted with WinRunner and LoadRunner automation.Managed Defect Tracking process in TestDirector to ensure defect resolution and optimize turn-around time. Ensured that all defects are adequately described and communicated to Development Team, and that communication between QA and Development is maintained. Ensured that QA Team verifies all repaired defects. Created meaningful Defect Status reports and ensured that Development Team is aware of defect priorities, schedules, and deliverables.Developed Defect Management Process so that key representatives (Development, Marketing, Content, Web Designer, and QA) consistently use TestDirector to manage all known defects. Identified key process deficiencies and implemented process to correct them.

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 e-Test Suite (Regression/Load testing tool for testing web applications); Internet Shipping ApplicationSpecified format for written Test Plan, and coordinated testing ofseparate Functional Areas by each of the QA Engineers; testing effort includedFunctional Regression, Load, and Human Factors testing. Deployed each software release onto test server, and post-configure/troubleshoot using "plumbing" tests; proceed with Functional Regression Testing of latest release, and validate all bug fixes.Implemented Issues Management logistics to optimize momentum on defect discovery and resolution; provided bug reports to management to help them assess risk and prioritize defect resolution.

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 4.0, MTS 2.0, DCOM, Active Server Pages (ASP) and HTML technologies, SQL Server 6.5, and SMTP.; Assessed all source code for hardware/network configuration dependencies; categorized and documented all existing and potential dependencies, and developed migration logistics plan for migrating each of the three tiers (client, web server, and database).Recompiled VB source code during troubleshooting/debugging/upgrading process into new working set of seven DLLs and one ActiveX Document; built MTS packages from upgraded DLLs, and deployed them on middle tier web application server.Built FTP and WWW virtual directory sites in IIS 4.0 to house required functionality of the Project Tracking system; configured these sites as required for user accounts, permissions, etc.; leveraged PCAnywhere tool in Shelton, CT to remotely configure software, registry, and monitor behavior of application; Isolated and resolved SMTP architecture problem with VB code implementation.Recompiled Wise Installation script to build new set of data files and CAB file for remotely deploying Project Tracking setup routine from web site location.Tested and verified continuing functionality for Project Tracking application after migration.Network Accounting and Network Statistics ProcessingProvided daily assessment, troubleshooting, and resolution of any incidental problems for hierarchy of NT/DOS batch processes. Batch processing was designed to:transfer critical load/usage data files; load raw data files into SQL Server 6.5 tables.post-process SQL data. Provided detailed documentation describing above processing logistics.

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 mainframe export procedure, and developed documentation to instruct mainframe personnel on export procedure.Developed over 100 SQL stored procedures to transform exported mainframe data in intermediate SQL tables into final, application SQL Server tables; transformation involved millions of data records.Customized each stored procedure to construct correct foreign key data; verified successful data conversion by checking referential integrity, uniqueness, and completeness of data in all tables. Messaging Application Programming Interface (MAPI) Research ProjectDeveloped VB 4.0 application demonstrating how to incorporate Microsoft OLE Messaging Library; application could send/receive e-mail with document attachments to recipients.Researched feasibility and benefits of leveraging Microsoft OLE Messaging Library into custom software applications.Product Forecasting ProjectDeveloped test plan for Client/Server VB 3.0 application; implemented test plan with SQA Robot automation scripts.Provided VB maintenance programming to fix defects and speed up turn around time on delivery dates. Quality Assurance workImprove quality of Approach software solutions by developing proactive and reactive, process-oriented methodologies to ensure software quality; process improvements covered documentation optimization, test plan preparation, defect management, and automated regression testing in a distributed, N-Tier environment.Designed and implemented concrete strategy for evaluating documentation quality, with the goal of optimized knowledge transfer among development team.

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 systems managers.

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.