Jan Weinmann

Background

About Jan Weinmann

Senior Level Programmer Analyst with 28 years combined, 22 years ETL and 15 years SQL Server development. SQL Developer | ETL Developer | COBOL Developer Email: jan.s.weinmann@gmail.com Experienced Information Systems Professional, Programmer-Analyst and Database Developer with extensive experience extracting data from multiple formats and merging it into relational databases. Experienced with SQL Server, COBOL, BASIC, Ada, and C across a variety of platforms and operating systems in small to mid-sized companies and the military. Successfully balanced recurring tasks and new development. Managed and trained small teams. Self-directed and capable of working well both independently and as part of a team. CORE COMPETENCIES ETL Development ETL Tools: Data Junction, Pervasive Cosmos Queries, Views and Joins Stored Procedures and Functions SSMS Data cleansing, parsing and standardization Data Mapping VBA COBOL MS Office with Access Training/Mentoring CAREER ACCOMPLISHMENTS - Reduced target database design time by 80% for the VMS to SQL Server migration by developing a Visual BASIC tool- Migrated OLTP data collection scripts for 132 distinct ftp accounts to a new server over 2 months with 98% less than 30 minutes lag time, 100% less than 24 hours lag time and zero data loss. These routines had cycle times ranging from 10 minutes to once daily- Enabled the retirement of 4 VAX servers and one Unix server by migrating processing of the data for 40 distinct data sets to SQL Server- Reduced the number of data dependent errors resulting in 75% fewer customer requests for manual updates. Please contact me at (540) 793-3544 with inquiries for SQL Developer or ETL Developer opportunities.