SUMMARY:

• A qualified, creative Information Systems professional, skilled in various programming languages, problem resolution, and technical assistance. I have many years experience with SQL writing queries, views and stored procedures.

TECHNICAL SKILLS:

Applications: SAP, IDCAMS, Endevor, Essbase, Fileaid, IMS, SQL Server 7.0/2000/2005/2008/2012, 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, Talend, Git.

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.

Operating Systems: UNIX, MVS, DOS, Windows 95/98/2000/NT 4.0/XP/7/8/10.

PROFESSIONAL EXPERIENCE:

Confidential, Fort Atkinson, WI

BI Developer

Responsibilities:

• Reran Talend jobs using scheduler and manually. Modified stored procedures in SQL Server. Used Git for version control. Created several talend jobs which extracted data from the DB2 database for internal and external clients.

Confidential, Plano, TX

SQL Programmer/Analyst

Responsibilities:

• Created or modified numerous SQL queries, stored procedures, and SSRS reports using SQL Server database. These objects in SQL Server were for tracking of drug dispenses at hospitals and nursing homes nationwide.

Confidential, Elgin, IL

SQL Programmer/Analyst-Contract

Responsibilities:

• Upsized Access database to SQL Server. Converted reports, queries, and forms to use SQL Server database. Created SQL statements to merge tables in SQL Server. Went thru the software quality assurance steps as testing, coding, and code reviews.

Confidential, Rockford, IL

SQL Programmer/Analyst

Responsibilities:

• Created queries, stored procedures, and views in SQL Server 2012 using T-SQL. 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. 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.

Confidential, Carpentersville, IL

Business Analyst/SQL Developer

Responsibilities:

• 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.

Confidential, Monroe, WI

Business Analyst/SQL Developer

Responsibilities:

• 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 using T-SQL.
• Closed trucks in Kewill and High Jump. Modified data in Kewill, Datex and HighJump using SQL Server. 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. Worked with users to modify documentation and go thru User Acceptance Testing. 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.

Confidential, Glendale, WI

Database Developer

Responsibilities:

• Created tables and queries in SQL Server 2008 using T-SQL for OLTP processing. Created SSIS, also known as ETL, tasks. 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 Confidential . Performed error testing on reports and other software. Went thru the software quality assurance steps as testing, coding, and code reviews.

Confidential, Hoffman Estates, IL

Reports Analyst

Responsibilities:

• 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. .

Confidential, Kenosha, WI

Reports Analyst/SQL Developer

Responsibilities:

• Modified data in databases for sales staff and franchisees of Confidential 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. Created and modified reports for internal users. The reports are in Excel or SSRS. Worked with users to develop reports and test cases using TFS. Went thru the software quality assurance steps as testing, coding, and code reviews.

Confidential, Madison, WI

Database Developer/SQL Developer

Responsibilities:

• Created UNIX 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 Confidential t. 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.

Confidential, Clinton, WI

Database Analyst

Responsibilities:

• 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.

Confidential, Menomonee Falls, WI

Reports Analyst

Responsibilities:

• 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.

Confidential, West Allis, WI

Reports Analyst/SQL Developer

Responsibilities:

• Created documentation with input of users when necessary. Created tables, queries, functions, and stored procedures using T-SQL in SQL Server 2005. Worked with users to create many pivot table reports in Excel 2003/2007. 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.

Confidential, Marinette, WI

Database Analyst

Responsibilities:

• Created documentation for new database. Worked with users and subject matter experts to gather requirements and create a new Access 2003 databases for the purposes of tracking of suppliers, maintenance companies, and parts for a new class of warship. The database imported data from
• SQL Server and other outside sources as an ETL process. Worked with users and went thru User Acceptance Testing(UAT) for database. This was in a RAD environment. This database was in a snowflake schema. Went thru the software quality assurance steps as testing, requirements gathering, coding, and code reviews.

Confidential, Madison, WI

Business Analyst

Responsibilities:

• Worked with users to gather requirements and create several new Access 2003 databases for the purposes of tracking of medical supplies such as proteins and antigens. The databases have forms, queries, and ad-hoc reports for display of data and importation/exportation of data to/from Excel 2003. Worked with users and went through User Acceptance Testing (UAT) for databases. The information is used for transplants. Conducted a feasibility study for possible translation of data from Access, Excel, and Prism to SQL Server. Went thru the software quality assurance steps as testing, requirements gathering, coding, and code reviews.

Confidential, Milwaukee, WI

Programmer

Responsibilities:

• Worked with users to modify Access 2003 database to export data to Excel spreadsheets for reporting purposes for tracking dealer’s goals and results. Worked with users to develop test cases and went thru user acceptance testing. This was with very little documentation. This database was in a snowflake schema. Went thru the software quality assurance steps as testing, requirements gathering, coding, and code reviews.

Confidential, Waukesha, WI

Software Engineer

Responsibilities:

• Modified and tested reports using Crystal Reports 11, SQL Server 2005, and VB.Net 2003 for purposes of tracking use of plows, salt, and sand for companies and municipalities. Wrote queries in T-SQL for OLTP processing. Modified user case test procedures documents using MS Word. Created new test cases and worked with users for user acceptance testing. This was in a RAD environment. This database was in a snowflake schema.

Confidential, Chicago, IL

Business Analyst

Responsibilities:

• Gathered requirements and worked with users to create databases with forms and ad-hoc reports in Access 2003 and Excel. The reports were used to check the validity of the data for a conversion from AS400 to SAP. Created database with tables, forms, queries, and reports for tracking of expenses for the HR department. Went through User Acceptance Testing (UAT) with users on databases. This was in a RAD environment. This database was in a snowflake schema.