Ian Kane

Current

• Systems Analyst at OneCoast

Past

• Data Programmer/Analyst at Communifax
• Website Development Consultant at University of Pittsburgh
• Senior Research Associate at UPMC

• Teaching Assistant at Carnegie Mellon University
• Mac Specialist at Apple

see less...

2 more...

Education

• Carnegie Mellon University
• Grove City College

Recommended

1 person has recommended Ian

Connections

50 connections

Industry

Retail

Websites

• My Blog

Ian Kane’s Summary

More than four years of experience working with MS SQL Server 2000-2008 in both transactional and data warehouse systems, both in design and administration.

Two years of experience working with Business Intelligence applications such as SQL Server Reporting Services and Analysis Services.

Extensive experience working directly with management and customers in order to gather requirements and create quality solutions.

Master of Science in Information Technology from Carnegie Mellon University. Graduated with the highest distinction granted.

I am a problem solver who enjoys facing difficult and interesting problems in innovative settings.

Ian Kane’s Specialties:

Systems: Windows XP/Vista, Mac OS X: 10.2 - 10.5, Linux: Ubuntu, CentOS

Databases: MS SQL Server 2000/2005/2008, MS Access 2000-2007, Oracle 10g, SPSS, Borland Paradox 3.0-4.0

Languages: SQL, C#, VB, ASP.NET, Java, HTML/XHTML, CSS, PHP

Applications: MS Windows: MS Visual Studio 2005/2008, SQL Server BI Studio 2005/2008, Mac OS X: VMware Fusion, iLife 2004-2008, iWork, Cross-Platform: Eclipse SDK, Adobe Dreamweaver/Fireworks, MS Office 2000-2007, Mathematica, TeX/LaTeX, Wordpress

Ian Kane’s Experience

• Systems Analyst

  OneCoast

  (Privately Held; 201-500 employees; Wholesale industry)

  November 2007 — Present (2 years 1 month)

  Develop and maintain the company’s data warehouse in a team setting using a variety of DTS and SSIS packages, allowing for a consolidation of various company-wide systems and easier access to data.
  
  Produce various data marts from the data warehouse, allowing for near instantaneous access of data through Excel 2007 pivot mechanisms and SQL Server Analysis Services.
  
  Created a hierarchical reporting structure for various financial metrics within the company using SQL Server Reporting Services, giving almost real-time data on sales numbers.
  
  Work with the marketing department in the creation of targeted lists of customers, enabling personalized messages and increased ecommerce sales.
  
  Create various reporting capabilities using ADO.NET, VB.NET, C#, and Excel.
  
  Overall, through the creation of new and revamped reporting capabilities, runtimes of various business processes (e.g. monthly commission statements) have decreased several hundred percent due to process enhancements.

• Data Programmer/Analyst

  Communifax

  (Privately Held; Marketing and Advertising industry)

  May 2007 — November 2007 (7 months)

  Responsible for the creation of consumer mailing lists for companies such as Verizon Wireless, Sheetz, and Dad’s Pet Care, enabling these and other businesses to engage in intelligent and effective marketing strategies.
  
  Maintained and updated SQL Server 2000/2005 databases for these clients, and wrote scripts to fulfill list creation functions and various quality control checks.
  
  Explored options in conjunction with the Analytics department in order to effectively model targeted marketing campaigns.
  
  Streamlined and updated various automated processes by converting SQL Server 2000 DTS packages into SQL Server 2005 Integration Services packages and by modernizing numerous scripts.
  
  Consistently met inflexible deadlines and worked on multiple promotions simultaneously in a fast-paced work environment.

• Website Development Consultant

  University of Pittsburgh

  (Educational Institution; Higher Education industry)

  November 2005 — May 2007 (1 year 7 months)

  Developed and maintained the HTML, CSS, and content for the websites of two associate professors at the University of Pittsburgh, accelerating the transfer of research information to interested parties, including PDF copies of published articles, training materials for administering psychological assessments, contact information, and biographical sketches.

• Senior Research Associate

  UPMC

  (Non-Profit; Hospital & Health Care industry)

  September 2004 — May 2007 (2 years 9 months)

  Served as the data manager in a longitudinal study of childhood and adolescent depression and anxiety for the Department of Adolescent Psychiatry within the University of Pittsburgh.
  
  Developed a relational database system composed of an Access 2003 user interface and a SQL Server 2000 back end.
  
  Reduced data entry error and enhanced data integrity by instituting a double data entry system built into SQL Server stored procedures.
  
  Improved performance of the legacy database system in Borland Paradox while migrating data into the newly created database system.
  
  Spearheaded an effort to convert nearly 100,000 paper documents into PDF format, and created an Access interface to query the documents, allowing for faster retrieval time and reducing space needs.

• Teaching Assistant

  Carnegie Mellon University

  (Educational Institution; Higher Education industry)

  August 2006 — December 2006 (5 months)

  Taught two recitation sections of the course “What Philosophy Is” to undergraduates of Carnegie Mellon University, including sections on ethics, metaphysics, and epistemology.
  
  Planned and executed weekly teaching lessons to engage students in introductory philosophical concepts and held additional office hours.
  
  Thoughtfully evaluated both papers and homework of 25 students and maintained responsible teacher/student interactions.

• Mac Specialist

  Apple

  (Public Company; AAPL; Computer Hardware industry)

  August 2004 — August 2005 (1 year 1 month)

  Directed customers toward complete and appropriate Apple computer solutions.
  
  Communicated effectively to computer users of all experience levels by shaping technical concepts to the user’s understanding and demonstrating solutions in engaging and exciting ways.
  
  Enriched the lives of Apple customers by supplying unparalleled customer service.

Ian Kane’s Education

• Carnegie Mellon University

  MS , Information Technology Management , 2006 — 2008

  Research interests and coursework included the following: Database Management, Data Mining, Business Intelligence, and Management. Graduated with the highest distinction granted.

• Grove City College

  BS , Mathematics , 2000 — 2004

  Summa Cum Laude Graduate

  Activities and Societies:

  Kappa Mu Epsilon National Mathematics Honorary, Delta Rho Sigma Housing Group, Steel City Ministries

Additional Information

Ian Kane’s Websites:

• My Blog

Ian Kane’s Interests:

Blogging, Backgammon, Biking, Philosophy, and Juggling. Engaging in consulting work with small, local businesses and non-profits.

Ian Kane’s Groups:

•    Carnegie Mellon Alumni
•    Grove City College Alumni
•    Pittsburgh Tech Council
•    H. John Heinz III College at Carnegie Mellon University

Ian Kane’s Contact Settings

Interested In:

• career opportunities
• consulting offers
• new ventures
• job inquiries
• expertise requests
• reference requests
• getting back in touch