Jeff Roper Email & Phone Number

Seattle, Washington, Us

ETL development with Informatica Cloud. Lead for the Data Infrastructure Replacement Project, a complex, high-impact project to restructure and simplify transit data that flows to multiple critical downstream systems. Duties included application and systems analysis, design, development and architecture; providing guidance to same or subordinate level applications developers; recommending standards, policies and technical directions; providing high-level customer support and reviewing project designs. Development was primarily in Oracle PL/SQL. Continue to provide support for DCHS.

Seattle, Washington, Us

Technical lead for DCHS Demographic Data Consolidation and KCRSN Data Exchange projects. Designed, developed and support DMHP Mobile application using ASP.NET MVC, Entity Framework, Ninject, Bootstrap, jQuery, Knockout, Automapper and Moq with IBM Informix Dynamic Server on Red Hat Enterprise Linux. Create systems and components to extract, process, distribute and report on data from Informix, SQL Server, Access, Excel , XML and flat files using SSAS, SSIS, SSRS, C#, SQL, XML, XSLT, XML Schema, awk, shell scripts and Informix 4GL. Developed C# application to parse and load email from Exchange server to SQL Server database using Exchange Web Services. Ported Perforce code repository to Team Foundation Server. Provide backup support for Linux Administrator/DBA and Help Desk.

Seattle, Wa, Us

Member of team developing Viroverse, a web-based laboratory notebook and data analysis platform implemented in Catalyst (a Perl MVC web framework), PostgreSQL and JavaScript on Linux and Mac OS X. Primarily responsible for continuing development and maintenance of online freezer sample tracking system.

Designed, coded and supported applications for Actuarial Financial Reporting group used to process, load and report on large data files using procedural and object-oriented Perl, SAS, SQL Server and Excel via Win32::OLE. Helped create and maintain Perl and SAS programs to automate monthly ARCVAL processing and publish results to SQL Server. Designed and supported SQL Server databases. Developed Console and Windows Forms applications in C#. Created and managed Subversion code repositories.

Wa, Seattle, Us

Designed and implemented PL/SQL, SQLX, XQuery, XSL and XML schemas as SmartCard External CD project technical lead. Implemented critical functionality for Cost Allocation Model and Stop Information systems in VB.NET, ODP.NET, PL/SQL and Visual Basic 6.0. Created Metro Online Neighborhood Pages application using VB .NET, ODP.NET, XML, SQL-Server and SQLX in Oracle. Worked with Perl, ColdFusion, JavaScript, VBScript and HTML on Windows w/IIS and Linux w/Apache as technical lead for Metro Online (http://transit.metrokc.gov) and Online Trip Planner (http://tripplanner.metrokc.gov). Coded in and supported Delphi 7. Nominated for Metro Transit Wall of Fame individually and as part of Stop Information System team in 2005, the Online Chat project in 2004 and the Custom Printable Timetables team in 2003.

Completed laboratory information management system and other applications using Visual Basic, Visual C++, Active Reports and SQL Server. Developed/maintained Intranet applications in Windows and Linux with HTML, Perl, VBScript, JavaScript, C, SQL Server and Daylight chemical database. Implemented web client/utility software in Perl and C for Windows, Unix/Linux and Macintosh. Configured/administered Linux servers running Daylight, Apache, Chili!Soft ASP, Samba, Squid, MRTG, Snort and ACID.

Wa, Seattle, Us

Worked in UNIX with Perl, C, Shell Scripts and HTML to develop, maintain and reconfigure Metro Online (http://transit.metrokc.gov). Moved site to Apache web server and brought up new Riderlink site. Configured and developed software for Internet kiosk pilot. Developed applications using Visual Basic, Access and Crystal Reports.

Baton Rouge, Louisiana, Us

Wrote Perl, shell scripts, Informix 4GL and COBOL in n-tier UNIX environment with Informix database.

Computer Information Systems

Ph.D., Linguistics

M.A., Linguistics

B.A., Classics