Confidential

Data analyst/Report writer

SQL Server 2008, Excel 2007

Data analysis

Creating reports and stored procedures in SQL Server and SSRS

Confidential

Demand Planner

VBA, Access 2003, Excel 2003, SQL Server 2000, Wal-Mart Retail Link system

Data analysis, programmer/analyst

• Enhancing and maintaining current Access/Excel application which forecasts the demand for Cotts products in Wal-Mart using VBA programming
• Analyzing current system and process in order to convert it to a SQL Server application. Access will be used for minimal front end
• Data analysis
• Converted 2003 Access and Excel applications to 2007 version

Confidential

Data analyst

• VBA, Access 2003, Excel 2003, Word 2003
• Design queries using Oracle's Business Intelligence tool
• Create reports, graphs and pivot tables to be presented in Excel and PowerPoint
• Rewrote and enhanced an Access application which dynamically creates a Word document according to a template. The document included graphs, tables and text that changed based on the underlying data

Confidential

Data analyst

MS Access, Excel

• Downloaded data files
• Created and ran reports

Confidential

Programmer/Analyst

• MS Access 97, SQL Server 2000
• Access, SQL Server Enhanced and maintained Access application which handled all aspects of the business other than accounting functions
• Tracked and completed requests for application changes
• Resolved bug reports

Confidential

Data Analyst

MS Access 2003, Excel 2003, Oracle SQL, TOAD

• Access, Excel Performed data analysis and data upload for Level 3 's bid for the US government's General Services Administration GSA Networx Enterprise Program which is a minimum 50 million dollar award for a variety of telecommunication services
• Access, Excel - Provided data to the Networx pricing team as needed in various formats including pivot tables and charts to aid in the decision making process
• Access - Designed and created a quoting database using the data submitted to the government
• Oracle/TOAD created queries to insert, view and update data. Also created a billing file extract to be sent to the government

Confidential

Programmer/Analyst

• MS Access 97/2002, Excel 2002, VBA programming, SQL Server
• Access, Excel, Outlook - Created timesheet entry application which tracks actual project hours for each resource, creates bi-weekly timesheet, allows supervisors to view and approve each timesheet and automatically creates an Excel workbook using VBA and emails it to the Payroll department, thereby saving many hours of data entry.
• Access - Rewrote and improved Guarantee Home application including data cleanup, added data validation to ensure data integrity and improving the user interface so as to be more intuitive
• Access - Converted multiple Access 97 applications to Access 2002
• Access, SQL Server - Converted applications from Access backend to a SQL Server backend
• Access - Converted Claims Tracking application from Paradox to Access

Confidential

Programmer/Analyst

MS Interdev, Active Server Pages, SQL Server 2000, JavaScript, Access 97/2000, SourceSafe

• Automated process for customers to request rebate checks and have them distributed automatically saving hundreds of hours of manual entry projected 15,000 requests .
• Enhanced and maintained critical application which kept track of customer purchases and rewards rebate points from those purchases and also the customer requests to redeem their rebate points
• Maintained numerous intranet, Access and Excel applications

Confidential

Programmer/Analyst

MS Interdev, Active Server Pages VBScript , SQL Server 2000, SourceSafe

• Created General Motors inventory management web application that assists GM dealers with locating and purchasing vehicles from either dealer stock or vehicles in production. Completed the project in 192 out of 320 projected hours.
• Created web application for General Motors which allows users to schedule vehicles for various activities such as storage, special events, transportation, etc. Completed project in 162 out of 255 projected hours.

New code testing

Confidential

Programmer/Analyst

Excel 2000, SQL Server 2000, Access 2000, VBA

• Worked in Healthcare Management department dealing with employee benefits, claims and HMO/PPO monthly charges data from HAP, Blue Cross, Unicare, SVS Vision, etc.
• Gathered user requirements by going over the manual process with users and discussing how the automated system should work
• Created functional specification and obtained user sign off
• Created SQL Server stored procedures
• Designed and coded application using VBA within Excel
• Developed test plan using sample criteria obtained from users
• Data required for processing is imported from a text file created from mainframe records into SQL Server using a DTS package
• Imported data is used and combined with other SQL Server data to dynamically produce a new workbook with multiple sheets pertaining to each of 10 situations
• Formulas are entered into other columns so that any changes to calculated columns are automatically recalculated
• Application then generates letters using mail merge techniques from MS Word objects
• Ad hoc reports using SQL Server 2000, Excel 2000, DTS Packages, Access reports