John Shanks Email and Phone Number

On contract with Vortex Optics, in Middleton, WI, doing Business Intelligence work.

Design , Develop and implement data warehouse using Microsoft Business Intelligence toolsDesigned and developed ETL process, using SSIS, retrieving data from JD Edwards OneWorld 9.1 ERP system.Maintain existing and create new data marts as needed.Maintain existing and create new Analysis Services Cubes as needed.Developed Reports in Reporting Services.

Design, Develop, and implement new business reporting systems, using Business Objects XI.Worked with Andrews Consulting Group to implement a Data Warehouse system, using SQL Server.Maintain existing and create new data marts as needed.Developed reports in Business Objects Web Intelligence, Crystal Reports, and Business Objects OLAPI tool.Main contact for worldwide reporting needs, for sales and distribution systems.

Design, develop, and implement new business reporting systems, using Showcase Strategy, and Essbase/400.Designed and implemented worldwide Data warehouse system.Assisted in converting European subsidiaries from DOS FoxPro applications to JD Edwards One World.

Design, develop, and implement new business systems.Designed and implemented Domestic Data warehouse system, using Showcase Strategy, and ESSBASE/400.Assisted in developing Dealer Extranet, using LANSA and HTML.Wrote applications, using LANSA.and RPG, to help business adapt to changing needs.Maintain existing HFA applications in order to adapt to changing business requirements.

Analyze, Design, develop, and implement new business application systems using CASE technology.Maintained existing applications, using LANSA.and RPG, in order to adapt to changing business requirementsLead multi-task, single resource projects.Contributed to development of systems to continually improve the corporate productivity, quality, and customer service.Wrote key business applications to help convert from a Bull DPS700, to an IBM AS/400. Systems included invoicing, credit… Show more Analyze, Design, develop, and implement new business application systems using CASE technology.Maintained existing applications, using LANSA.and RPG, in order to adapt to changing business requirementsLead multi-task, single resource projects.Contributed to development of systems to continually improve the corporate productivity, quality, and customer service.Wrote key business applications to help convert from a Bull DPS700, to an IBM AS/400. Systems included invoicing, credit memos, forecast maintenance. Show less

Answered any technical questions users had.Monitored system performance and performed necessary tasks to improve performance.Performed network administrator tasks.Helped move data center; Helped rebuild a 200-node Banyan network from the ground up.Designed and implemented a Paradox database for hardware and software inventory.

On assignment to IBM participated in the development of software to support the health care industries.Responsible for analysis, design, and development of IBM Medical records software using IMAGE PLUS/400.Designed and developed Inter Communications Function Software in order to link two medical records systems, on two different AS/400's.