Richard Waswrick's Email Addresses & Phone Numbers

Software Developer Consultant @ VW Credit, Inc. Libertyville, ILSenior Software Engineer @ Vantage Point Corporation From September 2016 to May 2017 (9 months) Kenosha, WI.Net Developer and DevOps Resource @ Volkswagen Credit Inc. Accomplishments as .Net Developer• Designed and developed numerous WCF services o This is includes the interface, data access, data model, schema and business rules...

Software Developer Consultant @ VW Credit, Inc. Libertyville, ILSenior Software Engineer @ Vantage Point Corporation From September 2016 to May 2017 (9 months) Kenosha, WI.Net Developer and DevOps Resource @ Volkswagen Credit Inc. Accomplishments as .Net Developer• Designed and developed numerous WCF services o This is includes the interface, data access, data model, schema and business rules o All created in C# using Entity Framework, LINQ, SQL Server, Oracle and .Net o Services integrated with VCI customer facing applications as well as back office processing• Designed, developed and supported numerous BizTalk applications o These applications leveraged the ESB toolkit for pure messaging scenarios o Designed and developed Maps, Schemas, Pipelines, custom pipeline components, custom functions, orchestrations, itineraries and policies• Designed and developed internal MVC applications o Enterprise level applications designed to facilitate development activities o Created using MVC 6, ASP.Net 5, Entity Framework 6, SQL Server 2012 and TFS 2013 Accomplishments as DevOps Resource• Implemented Microsoft's Release Management tool o Created PowerShell scripts and C# utilities that extended the tool’s functionality o Collaborated with development, infrastructure and operational teams o Trained resources on how to leverage the tool • Designed, implemented and supported tooling that automated all aspects of BizTalk deployments o Integrated BizTalk Deployment framework with our BTS applications as well as custom PowerShell scripts and MS Build scripting o This provided a stable, consistent, secure and maintainable approach for deployments• Collaborated with development and operational teams on implementing deployment automation improvements in areas beyond BizTalk o Conducted training sessions on how to leverage the new automation in deployments From September 2012 to October 2016 (4 years 2 months) Greater Chicago AreaData Architect @ Volkswagen Credit Inc. Accomplishments as Lead Data Architect, 2007 - 2012:• Designed the overall logical and physical data model for VCI’s data warehouse• Designed the centralized dealer repository data model and provided guidance on the data access layer construction• Currently leading a team of eight ETL developers and four data architects during all phases of the SDLC• Heavily involved in all aspects of the SDLC process whether working on requirements with business users or pairing with ETL developers• Created numerous ETL and database design specifications that were handed off to developers for construction• Actively involved in both development and design of warehouse data model and data integration• Created documentation pertaining to the warehouse architecture as well as VCI’s data integration strategy• Served as technical advisor to management for database, ETL, application, and infrastructure decisions• Served as application manager for enterprise metadata capture and reporting• Managed and coordinated multiple critical 3rd party vendor application upgrades• Created the ETL and database performance lab environment and leveraged it to prove out beneficial ETL and database performance enhancements From September 2007 to March 2012 (4 years 7 months) Greater Chicago AreaLead Database Developer and Application Developer @ Protiviti Position: Application Developer and Lead Database DeveloperPrimarily responsible for database design and development, but worked as an application developer on specific projects.Accomplishments:• Designed and developed OLTP data models to support the company’s suite of applications• Designed and developed data access layer in C# for .Net web forms application• Designed new security engine that dramatically improved performance, reduced code maintenance costs and simplified development• Developed C# security access layer and data model that leveraged the new security database structures• Designed new reporting data model that reduced maintenance costs, simplified development and improved performance• Hands on involvement in correcting poor performing T-SQL to reduce query durations and server load• Performed functional analysis for new feature enhancements, including time estimates and impact analysis• Provided guidance to database developers and application developers on best practices, in addition to addressing performance or logic errors• Served as one of the technical advisors to senior management for business product development• Provided technical risk assessments for new and on-going product development for use with QA project planning From June 2004 to September 2007 (3 years 4 months) Greater Chicago AreaApplication and Database Developer @ Robert Half Technology Position: Application and Database Developer, General application development on front-end application as well as back-end applicationsAccomplishments:• Wrote complex T-SQL queries for generating reports and large portions of the database layer for applications• Developed C# windows data import utilities that enabled data migrations from multiple data sources• Updated and maintained C# web applications• Web form .Net development, data access layer and business rules• Developed small SQL Analysis Services data cubes and integrated Reporting Services with interactive reports.• Developed scripts and encapsulated them in DTS for the migration of data during application release upgrades.• Provided SQL server database infrastructure support and troubleshooting to multiple clients From August 2003 to June 2004 (11 months) Pleasanton, CAApplication and Database Developer @ Capital Returns Inc. Position Application and Database Developer - Worked as senior member of database team and was responsible for estimating, planning and delivery of multiple applications.Accomplishments:• Designed and developed ETL process to scrub and normalize relational data from disparate sources for use in reporting and the company’s extranet• Updated and maintained extranet site used for clients in classic ASP• Designed and developed general ledger return system that integrated SQL Server and the client’s legacy COBOL system• Designed and developed replication strategy for the distributed desktop applications• Developed XML schema and documents for two-way synchronization with client’s legacy applications• Provided performance analysis with hardware and software recommendations to maximize environment efficiency• Identified and optimized poorly performing T-SQL stored procedures which resulted in over 40% application performance improvement and eliminated application timeouts From November 2000 to August 2003 (2 years 10 months) Greater Milwaukee Area