Fred Johnson

ad33k1@r.postjobfree.com

608-***-**** (cell)

Summary

Experienced SQL Server Developer with a proven track record in database design, development, implementation, and optimization. Proficient in writing complex SQL queries, stored procedures, functions, and triggers to support business requirements. Skilled in performance tuning, indexing strategies, and database optimization techniques to enhance system efficiency. Collaborative team player with strong analytical and problem-solving skills, capable of understanding and translating business needs into technical solutions. Continuously staying updated with the latest technologies and best practices in database development. Adept at working in fast-paced environments, delivering high-quality solutions within tight deadlines.

Skills

• Database Design and Development using Microsoft SQL Server (T-SQL),

• SQL Query Optimization

• Stored Procedures, Functions, Triggers

• Performance Tuning

• Indexing Strategies

• Data Modeling

• ETL Processes

• Database Administration

• Troubleshooting and Debugging

• Team Collaboration

• Code Development: SSIS, SSRS, VB, Visio, C++, C# Work Experience

Senior ETL Developer, Wisconsin Physician Insurance, INC. 11/2022 to Present Coded, tested and updated T-SQL and SSIS packages handling millions of claim data rows. Edited a multitude of stored procedures and SSIS packages from DEV to TEST to PRODUCTION environments. Worked in a team environment within an AGILE framework. Worked in DevOps for code storage and possess overall Azure skills. Debugged and documented complex SSIS packages for processing a federal government file that can give WPS a $9 million dollar refund.

Senior Data Warehouse Developer, NeuGen, LLC. 10/2019 to 7/2022 Coded and tested several key programs to bring off-shore EDS consulting back in house to a newly hired EDS internal team. Optimized SQL queries revising 1,000s of lines of code for internal business customers. Wrote Excel macros regarding the same. Wrote C# programs to automate manual processes saving hours of time for the EDS team. Deployed a myriad of new stored procedures from DEV to QA to PRODUCTION environments. Worked in a team environment within an AGILE framework. Developed programs in SSIS to perform ETL work for both inbound and outbound file creation. Wrote ETL SSIS claims packages for The State of Wisconsin ETF (Employee Trust Fund), a key customer of WEA Trust Health Insurance—a sub-company of NeuGen. Worked in DevOps for code storage and possess overall Azure skills.

Senior ETL Developer, Employee Benefits Corporation, Inc. 5/2018 to 4/2019 Managed almost 1,000 inbound interfaces for this multi-million-dollar TPA. Performed file validations using SSIS Packages to extract, translate and load EDI inbound files. Coded many different data file conversion programs using SQL and C# as well as creating and maintaining SSIS packages. Created reports using SSRS for end users. Resolved data issues with customers via conference calls and e-mails. Worked in a team environment within an AGILE framework. SQL Technical Consultant, HRchitect, Inc. 8/2016 to 8/2017 Accomplished several successful Ultimate Software data conversions using SQL as the conversion tool. Designed and built high-visibility customer interfaces between Ultimate Software and key vendors such as T. Rowe Price and Bank of America/Merrill Lynch. Received data conversion training and interface development training through Ultimate University. Numerous other small projects include company transfers and check history loading. SQL Senior Consultant, ihouse (a HUB International company) 6/1998 to 8/2016 Accomplished over 200 successful conversions along with technical coding to deliver complex software. Participate in customer design, build and testing scenarios. Built, tested and designed software packages tailored specifically for customer system needs. Exceeded customer expectations on complicated data conversions and system interfaces and/or electronic data interchanges. Specifically, enhanced human resource and payroll systems with customization, new modules and technical report writing. Managed other developers with complicated technical work and all related training involved. Designed, built and implemented $1 million ETL interface project for AFC, Inc. by writing custom software. Conducted design meetings with system analysis for Mesirow Financial. Created data flow diagrams for business analysis of interconnected systems. Made system and process recommendations based on automation, data interfaces and/or process improvement. Performed business analysis for large vendor HR/Payroll systems including current and future state diagrams. Met with customers in a variety of industries to determine needs analysis across business units. Participated in benefit plan analysis, design and open enrollment rollout. Balanced system costs and needs against customer budgets concerning both money and staffing. Completed over 50 software implementations with internal controls such as version, timing, and user acceptance. Analyzed and designed customized reports for over 100 different customers. Produced process documentation for $100 million payroll operations. Designed, built and implemented automated interfaces between HR/Payroll systems and benefit carriers. Successfully completed over 20 conversions involving multiple stakeholders. Senior Project Lead Programmer (Young Brothers, Honolulu, HI) Met with customer stakeholders in HR, Payroll and Finance including executive leadership. Created workflow diagrams of current state analysis of systems and processes. Worked with end users to discover current system usage. Researched and developed both executive and user requirements for new system recommendations. Built and delivered a comprehensive blueprint document outlining current and future state analysis along with detailed project task specifications for development. Conducted discovery meetings for data analysis, design and mapping from current to future state systems. Scheduled and conducted conference call meetings with project team. Functioned as project leader including timeline and milestone management from project start to completion. Senior Programmer/Analyst (Walgreens, Deerfield, IL) Completed the analysis and design specifications for PSET (Profit Sharing Enrollment Tool). This consisted of on-site meetings to define and document current operating mainframe pension rules. Performed analysis and design on complicated pension enrollment rules and documented the variety of employee cases and rule exceptions. Wrote program specifications for the comprehensive list of employee cases. Used the documented program specifications to codify the rules programming in Microsoft SQL Server. Documented test case scenarios during the process of unit, system and end-to-end testing. Installed and delivered all final programming in a live HR/Payroll system. Used version control for software updates including internal code comments for such versions.

Insurance Analyst, AON Direct Group 6/1994 to 6/1995 Analyzed banking insurance policies for over 100 nationwide banks. Made insurance coverage recommendations for over 100 policies. Completed and submitted insurance applications to multiple insurance carriers. Founded the Banker’s Insurance Center in Washington D.C. Sales representative for the Banker’s Insurance Center. Directed sales and marketing campaigns using direct mail, telephone, fax and e-mail. Supervised an intern for research and development. Education

BA in Economics, Wheaton College (Wheaton, IL)

MBA in Insurance, UW-Madison (Madison, WI)

MS in Information Systems, UW-Madison (Madison, WI)