Dawn Bauer Email and Phone Number
West Des Moines, IA, US
Dawn Bauer's Location
West Des Moines, Iowa, United States, United States
Dawn Bauer's Contact Details
Dawn Bauer work email
- Valid
- Valid
Dawn Bauer personal email
n/a
Dawn Bauer phone numbers
About Dawn Bauer
Special Skills: -- Exceptional organizational and analytical sills. -- Ability to problem solve and troubleshoot effectively. -- Ability to get projects done in a timely manner and within budget -- Enjoys multi-tasking either on a team or independently -- Strong people skills; ability to communicate well between the users, managers and development staff -- Flexible, self-motivated, yet knows when to seek guidance therefore requiring little micro-management -- Energetic and enjoys challenges and change
Dawn Bauer Work Experience Details
-
Farmers Mutual Hail InsuranceWest Des Moines, Ia, Us -
Data Architect IiFarmers Mutual Hail Insurance May 2019 - PresentWest Des Moines, Ia, UsResearches business objectives and data requirements by consulting with developers, product owners, end users, and management. Analyzes, validates, and designs data models, structures, and processes that meet the business objectives with a focus on data integrity, efficiency, and quality. Designs, builds, and maintains relational databases and data warehouses including creating and running scripts containing the appropriate data definition language. Troubleshoots data performance issues and provides tuning analysis and engineering recommendations. Prepares, tests, and executes DDL/DML scripts for monthly releases.
-
Software Developer Iii | Etl & Rma TransmissionsFarmers Mutual Hail Insurance Jan 2015 - May 2019West Des Moines, Ia, UsDuring the acquisition of John Deere Crop Insurance, sole developer of getting all ETL processes related to the government Risk Management Agency (RMA) transmissions up and running which included rewriting all the mainframe scheduling jobs into our JAMS scheduler, standing-up Informatica’s 680 data mappings and workflows as well as the corresponding UNIX jobs all within a regulated 6-month timeframe. Responsible for supporting the day to day mission critical ETL business operations specifically related to RMA transmissions which required being on-call and long hours. Back-up support for another 1400 ETL jobs related to actuarial processes (ADMS), nightly batch loads and the Data Mart. Currently using Rally in an agile environment. In 2017, sole ETL developer of moving all 680 ETL jobs out of Informatica and into Centerprise which included setting up a new data warehouse/lake. In 2018 continued with current support duties while doing Java support using IntelliJ, Hibernate and Spring as well as JSP, html, jQuery and JavaScript.
-
Software Developer Ii | Etl, Data Warehouse & Bi ReportingFarmers Mutual Hail Insurance Jul 2011 - Jan 2015West Des Moines, Ia, UsDuring the migration out of our legacy system, became a Business Intelligence ETL Developer on the Data Warehouse & Business Intelligence Reporting team. Participated in the selection, upgrades, and installations of technologies to support the growth and adoption of the EDW concept. Worked closely with the Data Architect to help define the data warehouse structure (Star Schema). Helped design, configure, test and maintain the enterprise data warehouse (EDW) in a way to help the company make better business decisions. Was the sole ETL developer for the data warehouse which comprised of hundreds of complex ETLs with in-depth SQL as well as ETLS for the day to day mission critical business operations specifically related to RMA transmissions. Daily Monitor and troubleshoot ETL and system performance, including optimization and tuning of data loads. Support the data warehouse and BI initiatives including data analysis, process efficiency, source to target data mappings and job scheduling. Helped design BI reports using Logi Analytics against the data warehouse. Have extensive in-depth knowledge with the RMA related tasks associated with Crop Insurance including PASS, ITS, Funds, ROE, Fullbook, CIMS and PHTS. Designed a small MS Access application to handle all our Data Definitions for our project.
-
Programmer / Analyst | Operations Production SupportFarmers Mutual Hail Insurance Oct 2006 - Jul 2011West Des Moines, Ia, UsDeveloper on the Operation Production Support Team supporting a Visual Basic Application using an Oracle database for the Crop Insurance Industry. Participated in all aspects of the software life cycle: Research, analysis, design, development, testing, implementation, maintenance & support. Supported both MPCI and Crop Hail systems and monitored the critical nightly Unix batch jobs for errors (roughly 50 jobs). Co-Managed all Oracle Releases into our production environment weekly and have extensive knowledge of MPCI data builds for the Risk Management Agency (RMA) including DAS|PASS, Funds, Fullbook, ITS, CIMS and PHTS. Completed a two-year Claim rewrite project as the sole developer with one Business Analyst. Mentored, coached and assigned duties to employees on the Operation Team and documented the Unix Release processes. Have strong customer facing skills and have had direct internal customer contact.
-
Sr. Application DeveloperPioneer Hibred International Inc Jun 2002 - May 2006Sr. Application Developer | OperationsDeveloped an application for the Dell Axim Pocket PC’s using an UltraLite database, WSDD (Java AWT), Active Sync & Manage Anywhere tools. The application allowed North American inspectors to enter information directly into a PDA, instead of on clipboards and then download this information via Mobilink to our Oracle database. Co-lead a Crop Insurance conversion from PowerBuilder 8.0 to a web based Java application that was outsourced to India developers. Gathered all the necessary requirements from the users into UI Catalogs and then communicated this information to the developers in India on a daily basis. Designed and developed all 35 reports with Crystal Reports XI and used Visio to develop the screens for the documentation. Supported two Visual Basic 6.0 applications for the laboratories that kept track of DNA Plates and testing. Designed and maintained a Visual Interdev Conditioning Scheduling application using a Visual Basic COM object developed in-house, an Oracle database, ASP, HTML and XML connections to an R/3 database. Supported the Operations and Supply departments.Technologies: Java/AWT, WSAD & WSDD, Visual Interdev, HTML, ASP, CSS, JavaScript, Visual Basic, Visual Basic COM, PowerBuilder 8.0, Access, XML, Toad, Crystal Reports XI , Business Objects, Sybase Manage Anywhere, Oracle 9i, SQL Server, R/3, FoxPro 2.0 | 5.0
-
Senior Software ConsultantPioneer Hibred International Inc Jan 1998 - Jun 2002Consultant | Sr. Programmer Analyst in Research Dept. under UniversalTechWorked on multiple applications over the course of the contract for the Research and Regulatory Departments. Four Web Applications all of which used Visual Interdev with a PowerBuilder COM object to connect to a Sybase database. The Regulatory and Rams were web applications were designed from scratch both using COM/OCX controls designed in Visual Basic. Geanno and Prism Request were pre-existing web applications that needed small improvements. In addition, converted (Access 2.0 to Access 97) and supported both the RTS and Trials applications. Huge enhancements were made to both systems to the screens, code and reports. ASH, SystemTracking, and Plasmid Preps applications established applications that were converted from FoxPro 2.0 to FoxPro 5.0. Small changes were made to increase speed and improve performance. Supported, maintained and made major enhancements to the LCMS and LCMStaging applications. (PowerBuilder) Designed a small application in Visual Basic to convert text files to a FoxPro database (BATS Input). Designed and developed an Access application to store, import, export data and weigh data. (PLNC system, Crop Protection, Six Sigma). Technologies: Visual Interdev, HTML, ASP, CSS, JavaScript, Visual Basic, Visual Basic COM, PowerBuilder 8.0, Access, XML, Crystal Reports XI , Business Objects, Oracle 9i, SQL Server, FoxPro 2.0 | 5.0
-
Software ConsultantPolk County Victim Services Sep 1997 - Jan 1998Consultant | Systems Analyst | ASC sub Quest LLCWorked on a small team of three in doing research, analysis, design and development to convert 4 separate existing systems previously designed in Metafile to 1 application in Visual Basic using an Access database. Was the only VB developer. This application kept track of Volunteers, Contracts, Group Sessions, Violent Crime, Rapes and Sexual Assaults and consisted of 101 tables. Confidentiality was a must. Used Crystal Reports for all reporting.Technologies: Visual Basic 5.0, Access ‘97, Crystal Reports 5.0
-
Software ConsultantSitel Corporation (Fisi) Jan 1997 - Sep 1997Consultant | Systems Analyst | Quest LLCResearched, analyzed, designed, developed, tested and implemented a new Life Insurance and Annuity application in Visual Basic 4.0 with an ACCESS 2.0 database on a Novell Network. The application exported and imported text files daily, produced on-line quotes for life insurance and annuities, sent daily faxes (batch) to agents throughout the country and allowed the ability to accept on-line life insurance applications. Used Crystal Reports for all reporting.Technologies: Visual Basic 4.0, Access 2.0, Crystal Reports, Novell
-
Software ConsultantState Of Iowa Jan 1996 - Dec 1996UsState of Iowa (ICAR)Consultant| Systems Analyst | Technology Services CorporationResponsible for the analysis, research, design, development and quality assurance of a new system to keep track of all of Iowa’s Corporations’ new employees that must be registered with the State of Iowa. We used Visual Basic 4.0 and deployed against an IDMS mainframe database by using CA-Server. This system would read a text file sent to the State, by the Iowa Corporations, and store it in an Access database for up to 90 days. After the 90 day period was complete, the data was copied onto the IDMS mainframe using a Middleware product call EDA/SQL.Dept. Of Human ServicesConsultant| Systems Analyst | Technology Services CorporationAnalyzed, designed, developed, tested, implemented and maintained a Child Welfare system using Visual Basic 4.0 and Access 2.0 on an NT Server. This system kept track of hard to manage children, their parents and/or guardians and allowed a checklist to be performed on a 1-month, 3-month, 6-month and 1-year interval. Also organized, documented and led multiple training sessions throughout the State of Iowa. Crystal Reports was used as the reporting tool for over 100 reports.Technologies: Visual Basic 4.0, IDMS Mainframe, CA-Server, Access 2.0, Middleware EDA/SQL, NT Server, Crystal Reports
Dawn Bauer Skills
Visio
Microsoft Sql Server
Testing
Data Warehousing
Sql
Software Documentation
Oracle
Process Improvement
Management
Visual Basic
Access
Xml
Asp.net
Business Analysis
Project Management
Etl Tools
Informatica
Centerprise
Star Schema
Unix
Logixml
Crystal Reports
Business Objects
Jams
Sybase
Sybase Sql Anywhere
Db2
Vbscript
Java
Javascript
Java Awt
Wsad
Css
Powerbuilder
Foxpro
Web Applications
Asp
Microsoft Excel
Microsoft Access
Software Development
Agile Methodologies
Business Intelligence
Software Development Life Cycle
Microsoft Office
Dawn Bauer Education Details
-
Iowa State University - Ivy College Of BusinessBusiness & Psychology -
Ellsworth Community CollegeBusiness
Frequently Asked Questions about Dawn Bauer
What company does Dawn Bauer work for?
Dawn Bauer works for Farmers Mutual Hail Insurance
What is Dawn Bauer's role at the current company?
Dawn Bauer's current role is Data Architect II at Farmers Mutual Hail Insurance.
What is Dawn Bauer's email address?
Dawn Bauer's email address is da****@****fmh.com
What is Dawn Bauer's direct phone number?
Dawn Bauer's direct phone number is +151572*****
What schools did Dawn Bauer attend?
Dawn Bauer attended Iowa State University - Ivy College Of Business, Ellsworth Community College.
What are some of Dawn Bauer's interests?
Dawn Bauer has interest in Volleyball, Social Services, Rugby, Environment, Science And Technology, Golf, Animal Welfare, Health.
What skills is Dawn Bauer known for?
Dawn Bauer has skills like Visio, Microsoft Sql Server, Testing, Data Warehousing, Sql, Software Documentation, Oracle, Process Improvement, Management, Visual Basic, Access, Xml.
Who are Dawn Bauer's colleagues?
Dawn Bauer's colleagues are Marilyn Matthews, Michele Starr, Jessica Wolfe, Cspo, Csm, Pmi-Acp, Trisha Carlile, Usman Zulfqar, Van Thompson, Kyle Klann.
Free Chrome Extension
Find emails, phones & company data instantly
Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Aero Online
Your AI prospecting assistant
Select data to include:
Total price:
$0.00
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial