SUMMARY:

• A qualified, creative Information Systems professional, skilled in various programming languages, problem resolution, and technical assistance.

TECHNICAL SKILLS:

Applications: SAP, IDCAMS, Endevor, Essbase, Fileaid, IMS, SQL Server 7.0/2000/2005/2008 , 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 , SQL Server Reporting Services, SSIS, Business Objects, TOAD, HighJump, Confidential, Confidential, Mobi.

Languages: Visual Basic 4/6/.Net, ASP.Net, ADO.Net, JavaScript, HTML, COBOL, CICS, C/C++, MQ Series JCL, Visual C++, SQL, T - SQL, PL-SQL, DB2, ASIST, Easytrieve, QuikJob, ABAP, SAS, Focus.

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

PROFESSIONAL EXPERIENCE:

Confidential, Monroe, WI

Business Analyst

Responsibilities:

• Worked with users to create and modify numerous SSRS reports for the Confidential WMS. Created and modified views and stored procedures in SQL Server using T-SQL. Closed trucks in Confidential and High Jump. Modified data in Confidential, Confidential and HighJump using SQL Server.
• Ran select statements and modified data using Oracle/PL-SQL to support the WMS. Deployed Confidential software to Confidential MX8 RF scanners using Mobi Software. Administered the user acceptance testing and installation of Confidential seven times with a team of 4-15 under my direction.

Confidential, Glendale, WI

Database Developer

Responsibilities:

• Created tables and queries in SQL Server 2008 using T-SQL. Created SSIS tasks. Modified C# code for SSRS reports for recording information on hospital infusion devices.

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.

Confidential, Kenosha, WI

Reports Analyst

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 packages for Snap-on.
• Created and modified reports for internal users. The reports are in Excel or SSRS. Worked with users to develop resports and test cases.

Confidential, Madison, WI

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

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.

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.

Confidential, West Allis, WI

Reports Analyst

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 accetance testing.

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.

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.

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.

Confidential, Waukesha, WI

Software Engineer

Responsibilities:

• Modified and tested reports using SQL Server 2005, Crystal Reports 11, and VB.Net 2003 for purposes of tracking use of plows, salt, and sand for companies and municipalities.
• Wrote queries in T-SQL. 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.

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.