Andy Jones Email & Phone Number

Brentwood, TN

Greater Nashville Area, TN

Support, expand, and maintain data repositories for corporate-wide reporting initiatives. Stage data from production applications through denormalized repositories into data warehouse model databases. Perform Microsoft SSAS cube development using Visual Studio. Perform data warehouse model development using Microsoft SQL Server T-SQL and Samsung-Harman.

Greater Nashville Area, TN

• Maintained company intranet and developed custom web applications in-house using multiple skills in programming technologies including: HTML, ASP, VB Script and SQL Server Stored Procedures and Queries
• Upgraded a major reporting tool, Actuate. This involved migrating over three hundred reports and two hundred automated jobs with no loss or downtime
• Administered a major reporting tool, Actuate o Maintained user logins, security groups and report distribution lists for 300+ users including external business partners o Maintained report scheduling and distribution
• Supported all phases of report development o User requirement gathering and report design o Created store procedures, views and queries as needed
• Implemented/Supported Vendor Managed Inventory (VMI) system using Infor Collaborative Demand Planning on SQL Server 2005 o Implemented/maintained user interface screens o Created initial data loads and daily data updates
• Designed/Implemented Sales Data Warehouse system o Designed/ implemented using ProClarity, SQL Server 2000 and Analysis Services o Created data load processes from ERP system, update dashboard metrics, and distribute.

Greater Nashville Area, TN

Worked on ERP upgrade project. Convert reports and underlying views, stored procedures, functions and triggers to new data base schema. Technologies being used are SQL Server 2000 and Actuate report designer.

Greater Nashville Area, TN

Worked on web based school attendance and grading system. Responsibilities included development/maintenance of XSL documents that control the presentation/maintenance of the various data components of the system, development/maintenance of programs to encapsulate business logic and create XML documents for use with the XSL documents. Also map data and.

Greater Nashville Area, TN

Worked on web based school attendance and grading system. Responsibilities include development/maintenance of ASP, development/maintenance of Stored Procedures and data conversions from OSIRIS dos based system. Technologies used were ASP, JScript, VB script, Visual Basic 6.0, Visual Interdev and SQL Server 2000.

Worked on COM wrapper for third party client to handle communications and translations between BPCS ERP system running on an AS/400 and a web based generic front end hosted on a Windows NT/2000 platform. Technologies being used are Visual Basic 6.0, Microsoft Access 2000, and IBM client access.

Greater Nashville Area, TN

• As a member of the Store Systems Support group designed, implemented and supported systems that ran in stores or ran in support of store operations at corporate headquarters. Standard projects utilized Visual Basic.
• Designed and implemented data warehousing for store sales and labor information using Microsoft OLAP server, Cognos Powerplay, Visual Basic 6.0, SQL Server 7.0, Stored Procedures, and DTS Packages.
• Designed and implemented Intranet pages for the viewing/entry/updating of stores with missing daily sales figures and for the viewing/entry/updating list of temporarily closed stores. These were done the Visual.
• Designed and implemented a job submission and monitoring service to run on store machines. This utilized the Windows Scripting Host and VB Script.
• Setup a Windows Media Server to test for feasibility of using for live broadcast over VSAT connection to stores. Involved assembly of necessary hardware. Installation of software, including Windows 2000 server, and.
• Designed and implemented prototype email system using Outlook 2000 and VBA as a method of providing a highly restricted email system to the stores over a VSAT connection.

Greater Nashville Area, TN

• For Deloitte & Touche as a Project Leader for a Project and Resource Management System. The assignment involved both a process definition component and a software development component. The process definition.
• As a consultant for an international filter manufacturer; designed, and implemented a series of sales proposal systems to allow the sales force to build sales proposals for various types of customers. The project was.
• Analysis, design and implementation of financial systems with new business function. Nissan Logistics Corporation. Primary support for Accounts Payable, Accounts Receivable, and Lease vehicle systems. This included the.

Greater Nashville Area, TN

As a Consultant Programmer Analyst for a state government, was responsible for the design, development and implementation of various applications using COBOL, VSAM, DL/I, TELON (batch and on-line), in both the CICS and IMS/DC teleprocessing environments.

Greater Nashville Area, TN

Responsible for the design and development of programs using COBOL with VSAM. Primary duty was the maintenance of the MSA accounts receivable system; including, but not limited to, applying system patches, system trouble shooting, and general user support. The environment was COBOL, DL/I and VSAM under both DOS/VSE and OS/MVS/XA.

Designed, developed, and implemented programs using Easytrieve Plus and COBOL with VSAM, DL/I, and CICS in a variety of areas such as sales analysis, net profit, and manufacturing. Environment was an IBM 4381 under DOS/VSE with COBOL, DL/I, CICS, VSAM, EASYTRIEVE PLUS and GENER/OL.