John Shanks

John Shanks Email and Phone Number

Senior Consultant @
John Shanks's Location
Greater Madison Area, United States
John Shanks's Contact Details

John Shanks personal email

John Shanks phone numbers

About John Shanks

Business Intelligence Professional with a passion for building tools that help analyze data.Specialties: Business Intelligence. Microsoft Business Intelligence SSIS, SSAS, SSRS, T-SQL, Business Objects, and Essbase.

John Shanks's Current Company Details
Baker Tilly US (Talavant)

Baker Tilly Us (Talavant)

Senior Consultant
John Shanks Work Experience Details
  • Baker Tilly Us (Talavant)
    Senior Consultant
    Baker Tilly Us (Talavant) Jan 2017 - Present
    Madison, Wisconsin, United States
  • Beacon Hill Staffing Group
    Business Intelligence Developer
    Beacon Hill Staffing Group Jul 2016 - Dec 2016
    Madison, Wisconsin Area
    On contract with Vortex Optics, in Middleton, WI, doing Business Intelligence work.
  • Trek Bicycle Corp
    Business Intelligence Developer
    Trek Bicycle Corp Aug 2009 - Jan 2016
    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.
  • Trek Bicycle
    Senior Analyst
    Trek Bicycle Mar 2005 - Aug 2009
    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.
  • Trek Bicycle
    Decision Support Analyst
    Trek Bicycle Oct 2000 - Mar 2005
    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.
  • Trek Bicycle
    Programmer/Analyst
    Trek Bicycle Jan 1997 - Oct 2000
    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.
  • Demco, Inc
    Developer/Analyst Ii
    Demco, Inc Jan 1993 - Jan 1997
    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
  • Ags Information Services
    Consultant
    Ags Information Services Jan 1992 - Jan 1993
    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.
  • Ags Information Services
    Computer Consultant
    Ags Information Services Jan 1991 - Jan 1992
    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.
  • Winona State University
    Software Tester
    Winona State University Jan 1989 - Jan 1991

John Shanks Skills

Ssis Data Warehousing Business Intelligence Ssrs Business Intelligence Tools Analysis Services T Sql Databases Microsoft Sql Server Sql Etl Business Objects Erp Ssas Essbase Crystal Reports Jd Edwards Data Modeling Sdlc Data Marts Relational Databases Agile Methodologies Mdx Database Design Powerpivot Data Analysis Data Warehouse Architecture Data Integration Olap Dax Business Analysis Analysis Sql Server Integration Services Sql Server Reporting Services

John Shanks Education Details

Frequently Asked Questions about John Shanks

What company does John Shanks work for?

John Shanks works for Baker Tilly Us (Talavant)

What is John Shanks's role at the current company?

John Shanks's current role is Senior Consultant.

What is John Shanks's email address?

John Shanks's email address is jo****@****ant.com

What is John Shanks's direct phone number?

John Shanks's direct phone number is (800) 313*****

What schools did John Shanks attend?

John Shanks attended Winona State University, Winona State University.

What skills is John Shanks known for?

John Shanks has skills like Ssis, Data Warehousing, Business Intelligence, Ssrs, Business Intelligence Tools, Analysis Services, T Sql, Databases, Microsoft Sql Server, Sql, Etl, Business Objects.

Not the John Shanks you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.