Gunnard Fredrickson

 Gunnard Arthur Fredrickson Jr. 1230 Meadowbrook Dr, Cleveland, WI 53015 -(cell) Email: - SUMMARY: A qualified, creative Information Systems professional, skilled in various programming languages, problem resolution, and technical assistance. I have many years of experience with SQL writing queries, views and stored procedures. I also have 12 years of experience in ETL. Applications: Talend, SAP, CA-7, IDCAMS, Endevor, Essbase, Fileaid, IMS, SQL Server 7.0/2000/2005/2008/2012/2016/2017/2020, MS Access 97/2000/2002/2003/2007, Microsoft Office, PowerPoint, VISIO, Formula One, Crystal Reports, Tactician, Oracle, Visual SourceSafe, Adobe Acrobat, MS Excel 2003/2007/2010/2012/2016, SSRS, SSIS, Business Objects, MySQL, TOAD, Datex, HighJump, Kewill, Mobi, Infor Syteline, TFS, Git, Postman, Salesforce, Mailchimp, Power BI, Snowflake, Teradata. Languages : Visual Basic 4/6/.Net, ASP.Net, ADO.Net, JavaScript, HTML 4.0.1, COBOL, CICS, C/C++, MQ Series JCL, Visual C++, SQL, PL-SQL, T-SQL, DB2, ASIST, Easytrieve, QuikJob, ABAP, SAS, Focus. PostgreSQL, Python. Operating Systems: DOS, UNIX, MVS, Windows 95/98/2000/NT 4.0/XP/7/8/10. WORK HISTORY December 2022- Positec Tool Corp, Charlotte, NC-worked remotely March 2025Lead Talend Developer Created, modified, and ran queries in SQL Server Azure. Created and modified numerous Talend jobs. Promoted jobs to Talend Management Console. Scheduled jobs in Talend Management Console on AWS. Critical in making sure that customer orders were transmitted successfully and in timely manner to the warehouses for fulfillment. Increased productivity at the warehouse fulfillment by 50%. The Talend jobs used XML, txt, csv, and xlsx files in addition to restfulAPI calls. Some jobs moved input and output files between SFTP and S3. This was in a SAAS environment. Created and designed several reports in PowerBI. Worked with stakeholders to ensure accurate data for reports to Finance. October 2022- Charles Schwab, Phoenix, AZ-worked remotely January 2023SQL Developer-Contract Complete Created, modified, and ran queries in Teradata. Attended daily scrums as this is an agile environment. Conducted peer reviews of other developers work. July 2022- Blue Cross of Idaho, Boise, ID October 2022ETL Developer-Contract Complete Created, modified, and ran queries to modify data in SQL Server. Attended daily scrums as this is an agile environment. Documented Talend 7.2.1 jobs using Excel and Word for the purposes of conversion to another application. November 2021- Cigna, Tampa, FL July 2022Software Engineer-Contract Complete Created, modified, and ran queries for Teradata and DB2. Created and ran queries to modify tables in Teradata. Created tables in Teradata. Created documentation for DBA to modify data in the production environment. This was in an Agile environment. This was for medical insurance. . September 2020- Gainwell Technology, Augusta, ME November 2021Lead SQL Developer/ETL Developer-Fulltime Created technical design documents for external and external users. Created and ran ETL jobs to load data into Oracle DB. Created tables and views for Oracle DB. Created and ran queries using Oracle DB. Created reports in SSRS. Created tables and stored procedures in SQL Server. This was for Medicare/Medicaid databases. . August 2019- Horizon Systems, Sheboygan, WI April 2020Lead BI Developer/Reports Analyst/Business Analyst-Fulltime Worked with external users when gathering requirements, creating, and modifying numerous SSRS reports for various insurance companies. Created and modified many SQL Server stored procedures. Created and modified VB.Net code for the purpose of creating PDF documents for insurance quotes and applications. Modified SSAS cubes. This was done using SQL Server 2017. This was also done thru CI/CD. Provided application support to outside clients when necessary. . February 2019- Levatas, Palm Beach Gardens, FL June 2019Lead SQL/Talend Developer-Contract complete Created numerous Talend jobs to move data from SQL Server 2016, Mailchimp, and Salesforce to a Snowflake EDW for data integration for an external client. Extracted data from JSON formatted files into Snowflake. Helped evaluate various ETL tools such as Matillion, Alooma, FiveTran, and Talend. Worked on ensuring the Master Data Management for the external client of Levatas. Created schemas and tables in Snowflake which is on AWS. Created and ran statements to grant access to Snowflake. Mentored others in the use of Talend. Used tMap and tMapXML components. Attended weekly Agile Scrum meetings and gave feedback on progress of various tasks. Installed, architected, validated, and developed critical Talend features for managing data migration into Snowflake. Administered Talend Enterprise installations. Performed MDM on the Snowflake DB to verify that the data was correctly inserted from SQL Server, Mailchimp, and Salesforce. November 2018- TASC, Madison, WI January 2019SQL/Talend Developer-Contract complete Modified existing Talend ETL jobs. This was done thru CI/CD. Created several new Talend jobs which took data from MySQL and SQL Server and loaded it into a MySQL EDW for data integration. Put data from MySQL and SQL Server into JSON formatted records. Created mapping documents using MS Excel. The MySQL was on AWS. Also converted data from one format to another format. Also converted data from SQL Server to MySQL. Used GIT for version control. This was in an Agile environment. Used tMap components. Attended weekly Agile Scrum meetings and gave feedback on progress of various tasks. May 2016-September Rate Watch, Fort Atkinson, WI 2018 Lead Talend ETL Developer/SQL Developer/Reports Analyst/Business Analsyst Modified existing Talend ETL jobs. This was done thru CI/CD. Created and tested over 10 new Talend ETL jobs which extracted data from the DB2 EDW for internal and external clients. Reran Talend jobs using the scheduler and manually when necessary. Worked with users to test and modify existing Talend ETL jobs. The data was sent to external and internal users. In the case of external users this was sent as excel spreadsheets or text documents either by email or sent to a SFTP site. Some of the Talend ETL jobs did transfer data from the DB2 database to SQL Server. Modified stored procedures in SQL Server Management Studio (SSMS) and used Git for version control. Verified SSIS packages which went against SQL Server. Created documentation on data flows, processes and existing jobs using Visio. This was a data warehouse system containing information on deposit rates, loan rates, and fees from various financial institutions nationwide. The data warehouse was set up in a star schema. Went thru the software quality assurance steps as requirements gathering, source code control, coding, testing, and code reviews. Worked with the DB2 DBA to perform Master Data Management tasks. Created PostgresSQL queries and stored procedures. The PostgresSQL database was on AWS. Used GIT for version control of the application using the PostgresSQL. Mentored others in the use of Talend. Used tMap compnents. Ran data mining queries against the database to find bad data for data cleanup purposes (MDM). Provided application support to outside clients when necessary. January 2016-May AlixaRX, Plano, TX 2016Lead SQL Programmer/Analyst/Reports Analyst./Business Analyst Worked with internal user to create or modify numerous SQL queries, stored procedures, SSIS packages, and SSRS reports using SQL Server database. Created SQL queries and stored procedures in SQL Server Management Studio (SSMS). The data was made anonymous to comply with the HIPAA rules. Created SSIS packages to pull data and fill tables for SSRS reports to pull against. Gathered requirements from internal users. Worked with users to test SSRS Reports. These objects in SQL Server were for tracking of drug dispenses at hospitals and nursing homes nationwide and also contained ICD9 information. Provided application support to internal clients when necessary. October 2015- IT Stability, Elgin, IL January 2016 Lead SQL Programmer/Analyst-Contract Upsized Access database to SQL Server. Converted reports, queries, and forms to use SQL Server database for data integration. Created SQL statements to merge tables in SQL Server Management Studio. Mentored others in the use of SQL Server. Documented data flow using Visio. Performed MDM to verify the data was correct. June 2015-August Vision Financial Corp, Rockford, IL 2015Lead SQL Programmer/Analyst/Reports Analyst-Fulltime Used SQL Server Management Services to create queries, stored procedures, and views in SQL Server 2012 using T-SQL. Worked with other developers to perform Master Data Management tasks. Worked with users to modify and create SSRS reports. Created SSIS or ETL packages using Visual Studio for the purpose of converting data for FTP. SSIS packages to pull data from SQL Server. Did data mapping for the FTP purposes. Wrote queries in MySQL. Made recommendations to Vision Financial for new reporting tools such as Tableau and Jaspersoft. Went thru the software quality assurance steps as requirements gathering, source code control, testing, coding, and code reviews. Provided application support to internal clients when necessary. January 2015-June Otto Engineering, Carpentersville, IL 2015Business Analyst/SQL Developer/Reports Analyst-Contract Complete Modified and created forms for Infor Syteline ERP using VB.Net. Created stored procedures, triggers, tables, and views in SQL Server 2012 using T-SQL for OLTP processing. Modified and created SSRS reports. Assisted in the design of the database by creating the tables necessary to forms. Tested new and modified forms and reports for errors. Worked with users to modify documentation, develop test cases, and go thru User Acceptance Testing. Went thru the software quality assurance steps as testing, source code control, coding, and code reviews. October 2011-October Colony Brands, Monroe, WI 2014Lead Business Analyst/SQL Developer/Reports Analyst Worked with managers, stakeholders, and users to create and modify numerous SSRS reports for the DATEX WMS. Created and modified tables, views, and stored procedures in SQL Server Management Studio (SSMS) using T-SQL. Closed trucks in Kewill and High Jump. Modified data in Kewill, Datex and HighJump using SQL Server. Created Unix shell scripts to update the database for Red Prairie. Ran select statements and modified data using Oracle/PL-SQL to support the WMS. Administered the user acceptance testing and installation of DATEX seven times with a team of 4 to over 15 under my direction. Modified Ramp ETL packages when necessary and did data mapping and data conversion for the EDI transmissions. Worked with 3rd party warehouses to correct EDIs when necessary. Deployed Datex software to LXE MX8 RF scanners using Mobi Software. Wrote queries in MySQL and modified data in MySQL Assisted in the design of the database by creating tables necessary for some report processing. The Datex WMS database was in a snowflake schema data warehouse. Worked with users to perform Master Data Management tasks. Worked with users to modify documentation and go thru User Acceptance Testing. This was for the bakery and cheese making supply chain. Performed error testing on reports and other software. Performed performance testing on queries prior to implementation in production. Went thru the software quality assurance steps as requirements gathering, testing, release management, product integration, and coding. Provided application support to outside clients when necessary. August 2011-September True Process, Glendale, WI 2011 Database Developer-Contract Complete Created tables and queries in SQL Server 2008 (SSMS) using T-SQL for OLTP processing. Created SSIS, also known as ETL, tasks. The SSIS packages pulled data and filled tables for SSRS reports. Modified C# code for SSRS reports for recording information on hospital infusion devices. Created SSRS reports for hospital infusion devices. I used healthcare information to create the reports for the clients of True Process. Performed error testing on reports and other software. Went thru the software quality assurance steps as testing, coding, and code reviews. April 2011- AT&T, Hoffman Estates, IL June 2011 Reports Analyst-Contract complete Created tables in Oracle using TOAD. Exported data from SAP Business Objects into Oracle using TOAD. Imported CSV files into Oracle using TOAD. Created queries in Oracle using PL-SQL. Created reports from Oracle in Excel 2007. Worked with users to develop reports and test cases. Performed error testing on reports and other software. Went thru the software quality assurance steps as testing, coding, and code reviews. February 2011- Snap-On Diagnostics, Kenosha, WI April 2011Lead Reports Analyst/SQL Developer-Contract Complete Modified data in databases for sales staff and franchisees of Snap-On Diagnostics using T-SQL, SQL, and PL/SQL. The databases are SQL Server 2005, Oracle, and MS Access 2000. Created SSIS, also known as ETL, packages for Snap-on. The SSIS packages pulled data for the reports. Created and modified reports for internal users. The reports are in Excel or SSRS. Used SQL Server Management Studio (SSMS). Worked with users to develop reports and test cases using TFS. Went thru the software quality assurance steps as testing, coding, and code reviews. Provided application support to Internal clients when necessary. July 2010-January CPM Marketing Group, Madison, WI 2011Database Developer/SQL Developer-Contract Complete Created UNIX shell scripts as a part of ETL packages to load data into a data warehouse. This was considered as a data warehouse as many of the files contained transactional information in the form of actions that were performed on a patient. These Oracle databases were in a Linux/Unix environment. Consulted with outside clients to create data maps and code maps for files imported from clients. The files consisted of demographic information, ICD9, and CPT information. The clients are hospitals, physician groups, and clinics nationwide. This was using healthcare information that was received from the clients. Assisted in the design of the databases by creating the tables necessary for the processing of the files from the clients. Did data mapping and data conversion for bringing in the data from the hospitals and clinics. groups, and clinics nationwide. This was using healthcare information that was received from the clients. Assisted in the design of the databases by creating the tables necessary for the processing of the files from the clients. Did data mapping and data conversion for bringing in the data from the hospitals and clinics. Provided application support to Internal clients when necessary. June 2010-January Red & White Dairy Cattle Association , Clinton, WI 2011Lead Database Analyst-Contract Complete Converted SQL Server 2000 database to SQL Server 2005. Converted MS Access 2003 database to MS Access 2007. Converted ETL packages to load data into the SQL Server 2005 database. Worked with users to develop test cases using TFS. March 2010-May 2010 Kohl’s, Menomonee Falls, WI Reports Analyst-Contract Complete Created several new crystal reports based on a connection to Oracle in addition to DB2 based upon documentation. Added filter to specifications document to reflect changes to existing reports using MS Word 2003. Modified Oracle PL-SQL to allow existing Crystal reports to be used for new e-commerce fulfillment center. Worked with users to develop test cases using TFS. This database was in a snowflake schema. Used SVN to promote reports for testing purposes. September 2008- M&I Bank, West Allis, WI January 2010 Lead Reports Analyst/SQL Developer Created documentation with input of users when necessary. Created tables, queries, functions, and stored procedures using T-SQL in SQL Server 2005 {SSMS). Worked with users to create many pivot table reports in Excel 2003/2007. The reports were used for statistical analysis of customer credit card use. Created many SSIS ETL packages using Visual Studio 2005 for the purpose of extracting data from text files, Excel spreadsheets, or tables in the SQL Server database and manipulating the data further for reports. Exported data from SQL Server using stored procedures to Excel 2003/2007. Created reports using SQL Server Reporting Services (SSRS) from documentation created with input from users. Created reports using Business Objects. Went through User Acceptance Testing(UAT) on new reports and reports that were modified. This was for a terabyte size database. The largest table was approximately 180 million records. This data warehouse was for credit cards that M&I issues. This was in a RAD environment. Worked with users to develop test cases and went thru user acceptance testing using TFS. This database was in a snowflake schema. Performed performance testing on queries prior to implementation in production. Went thru the software quality assurance steps as testing, requirements gathering, coding, and code reviews. Ran data mining queries against the credit card database to determine credit cars use by users. Provided application support to Internal clients when necessary. Used SVN to promote reports to production. EDUCATION June 1994 DeVry Institute of Technology, Irving, Texas Bachelor of Science in Computer Information Systems Graduated Cum Laude.3.6 GPA October 1999 to Richland College, Dallas, Texas April 2000 Visual Basic 6.0 I & II, VBA for Office 97, Block certificate for Visual Basic March 2001 SAP Education, Dallas, Texas ABAP Workbench:Concepts & Tools Developing User Dialogs August 2004 Brainbench Certification SQL Certification January 2012 HighJump University HighJump Advantage Administration Class January 2012 HighJump University HighJump WebWise Class January 2012 HighJump University HighJump Advantage Architect Class October 2018 Udemy Learn Power BI Fast October 2018 Udemy Data Warehouse Concepts: Basic to Advanced June 2019 Udemy Data Integration(ETL) with Talend Open Studio April 2020 Udemy Talend Recipes : How to Solve Problems Using Talend May 2020 Udemy Python for Absolute Beginners June 2020 Udemy Modern Data Warehouse Concepts June 2020 Udemy Snowflake decoded – Fundamentals and Hands-on training July 2020 Ss-elearning Scrum Fundamentals Certified