Senior Level SQL Developer with 28 years combined, 22 years ETL and 15 years SQL Server development.SQL Developer | ETL DeveloperEmail: jan.s.weinmann@gmail.comExperienced Information Systems Professional, with extensive experience extracting data from multiple formats and merging it into relational databases. Six years processing healthcare data including eligibility, claims, EMR and demographic records, as well as provider data, provider specialty and demographic data. 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 COMPETENCIESETL DevelopmentSSIS, SSMSHealthcare Data and teminologyQueries, Views and JoinsStored Procedures and FunctionsData cleansing, parsing and standardizationData MappingGitHub Turtle SVN,Training/Mentoring CAREER ACCOMPLISHMENTS• Maintained an Enterprise Data Warehouse of over 1,000 tables and over 1 billion records.• Developed or did peer review on over 151 releases and changes.• Worked on 4 major projects that reduced the onboarding time of new Care Delivery Organization customers from several months to as little as 2 weeks.• Developed 4 larger projects and peer reviewed 2 others that reduced the runtime of the nightly cycle by as much as 30%.• Monitored the nightly cycle and responded to errors and job failures on a rotating basis.• Participated in onboarding training of 3 new developers• 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.
Listed skills include Transact Sql, Etl, Sql, Databases, and 23 others.
