welcome

Welcome

Welcome to the personal site of Ian Luke Kane. You’ll find my resume and a way to contact me below. I also have some incredibly old blog posts here that I’m leaving up more for posterity than anything since they’re all outdated and malformed. I like data. I like math. I like my bicycle. If you’re wondering what I’m thinking about these days there’s a good chance you can glean that from here.

e8

(Image by jared)

resume

Resume

PROFESSIONAL OVERVIEW

  • Experience working directly with management and customers in order to gather requirements and create quality products, both as a developer and manager.
  • More than a decade of design and administration experience working with database management systems in both transactional and analytical settings.
  • Extensive experience working with Business Intelligence applications such as SQL Server Analysis/Reporting Services and Logi Info.
  • Earned MSIT from Carnegie Mellon University. Graduated with the highest distinction granted.

EXPERIENCE

Wombat Security Technologies Pittsburgh, PA
SENIOR BIG DATA ENGINEER
August 2014 – Present

  • As Senior Big Data Engineer, responsible for the creation and management of Wombat’s near-real time data warehouse and BI applications for internal and customer-facing reporting.
  • Using technologies within AWS, built an Amazon Redshift and later a PostgreSQL data warehouse that incrementally updates every 15 minutes, allowing for a consistently updated environment able to power both internal and customer facing reports.
  • Maintain this infrastructure across three production environments in the US, EU, and Australia.
  • Act as DBA for transactional database performance improvements in a MySQL environment.
  • Develop BI solutions using Logi Info, JavaScript, and custom Java/Python code.
  • Responsible for the creation of complex SQL used for internal analysis of data.

Millennium Pharmacy Systems Pittsburgh, PA
DATA SYSTEMS ARCHITECT
May 2012 – August 2014

  • As Data Systems Architect, responsible for the creation and management of BI applications within the organization, including requirements gathering with senior executives, data modeling, and overall ownership of SSAS, SSIS, and SSRS processes.
  • Responsible for eight data marts ranging in size from tens to hundreds of gigabytes and pulling from multiple internal transactional systems, as well as Microsoft Dynamics and other third party data collectors, comprised of approximately five terabytes worth of source data.
  • Continually engage top executives and financial users in consultative strategy discussions to determine how to best use technology to meet business objectives.

SnapRetail (formerly OneCoast) Pittsburgh, PA
DIRECTOR OF BUSINESS INTELLIGENCE
April 2011 – May 2012

  • As Director of BI, responsible for overseeing reporting requirements and implementation, including interfacing with customers, creating necessary database infrastructure, and creating reports and reporting tools, including SSIS, SSAS, SSRS, Excel, and web based reports.
  • Organized sprints and releases with the team and owners using the VersionOne product management tool.
  • Managed development teams consisting of software engineers and database developers.
  • Continually engaged our customers in consultative strategy discussions to determine how to best use technology to meet business objectives.

DIRECTOR OF TECHNOLOGY SERVICES
March 2010 – April 2011

  • As Director of TS, responsible for overseeing the Agile software development process for the Technical Services department, which at the time served the two largest sales organizations in the gift and home décor industry in the United States, as well as various internal projects.
  • Organized sprints and releases with the team and owners using the VersionOne product management tool.
  • Managed development teams consisting of software engineers and database developers.
  • Continually engaged our customers in consultative strategy discussions to determine how to best use technology to meet business objectives.
  • Acted as Scrum Master for the group.

SYSTEMS ANALYST
November 2007 – March 2010

  • Developed and maintained the company’s data warehouse setting using SSIS packages, allowing for a consolidation of various company-wide systems and easier access to data.
  • Produced 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.
  • Worked with the marketing department in the creation of targeted lists of customers, enabling personalized messages and increased ecommerce sales.
  • Created various reporting capabilities using ADO.NET, VB.NET, C#, and Excel.
  • Overall, through the creation of enhanced reporting capabilities, decreased runtimes of various business processes several hundred percent.

CommunifaxPittsburgh, PA
DATA PROGRAMMER/ANALYST
May 2007 – November 2007

  • Responsible for the creation of 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 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.

University of Pittsburgh Medical CenterPittsburgh, PA
SENIOR RESEARCH ASSOCIATE
September 2004 – May 2007

  • 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.
  • Reduced data entry error and enhanced data integrity by instituting a double data entry system built with SQL Server stored procedures and an Access front end.
  • Improved performance of the legacy database system in Borland Paradox while migrating data.
  • Spearheaded an effort to convert nearly 100K paper documents into PDF format, and created an Access interface to query the documents, allowing for faster retrieval time and reducing space needs.

RECENT TECHNICAL EXPERTISE

OS

Linux: Ubuntu 14.04 LTS, CentOS 6.x, Fedora 22
Mac OS X: 10.11
MS Windows: Windows 7, 10

Databases

PostgreSQL 9.5, MySQL 5.6, MS SQL Server 2012, Amazon Redshift, DynamoDB

Applications

JetBrains DataGrip and PyCharm, Eclipse, Visual Studio, SQL Server Business Intelligence Studio, Logi Studio, VMware Fusion, Parallels, VirtualBox, WordPress, R, Attunity Replicate, Sublime Text, Slack, JIRA, Confluence, Git

AWS

EC2, RDS, Amazon Redshift, DynamoDB, S3, Data Pipeline, SNS, Security Groups, VPC

EDUCATION

MASTER OF SCIENCE IN INFORMATION TECHNOLOGYCARNEGIE MELLON UNIVERSITY

  • Pittsburgh, PA • Degree Date: August 2008 • QPA: 3.99/4.00 • Graduated with Highest Distinction
  • Interests: Database Management, Data Mining, Business Intelligence, and Management.

BACHELOR OF SCIENCE IN MATHEMATICS GROVE CITY COLLEGE

  • Grove City, PA • Degree Date: May 2004 • QPA: 3.88/4.00 • Summa Cum Laude Graduate
  • Member Kappa Mu Epsilon National Mathematics Honorary

INTERESTS

  • Biking, Hiking, Music, Running, Philosophy, and Juggling
  • Engaging in consulting work with small, local businesses and non-profits.
  • Teaching – Completed co-teaching two semesters of a course on “Intro to Full Stack Web Development” with the Saxifrage School in 2013.
contact-me

Contact Me

Your Name (required)

Your Email (required)

Subject

Your Message

What's 11 + 12?