Assisted in creating Big Data / Hadoop architecture from scratch. Wrote custom Flume-NG sinks for game data log ingestion into HDFS. Wrote custom Avro Serializer for game data log storage. Wrote Flume-NG RabbitMQ Consumer source.Designed and implemented a Netty based log message listener utilizing load balancers for scalability. This server stored messages in target RabbitMQ clusters.Designed and implemented Apache Tomcat based Esper CEP server, exposing streams / queries via REST services and consuming data from RabbitMQ topics. Wrote exploit detection real time queries for catching in game exploiters and notifying key personnel. Created various mapreduce jobs in Java, including a load test simulator, CCU calculations, etc. Authored various pig scripts for ETL pipelines and transformations. Setup and wrote scripts to expose flume ingested external tables and partitions in Hive.Various work with SSIS / SSRS as needed. Ad-hoc analysis of big data as needed / requested.

Created Microtransaction models for City of Heroes: Freedom free to play launch. Assisted in overhauling Account History model. Designed automated verification and data validation ETLs, responsible for controlling workflow logic and alerting administrators when data problems were encountered. Overhauled indexes and implemented partitions within Oracle Data Warehouse. Created SSAS cube models to calculate various business metrics.

Designed log collection system for generic games (economic events). Prototyped game data warehouse system using Hadoop and HBase. Leveraged Microsoft Reporting Services for Cryptic Studio’s reporting presentation layer. Converted existing Excel reports into automated reports. Migrated Data Warehouse from MySQL to PostgreSQL, and acted as DBA for PostgreSQL environment. Responsible for providing ad-hoc reporting to executive management and various departments. Scripted extracts from proprietary data store for account information, characters data, and transactions, and loaded data into SQL. Overhauled existing reporting infrastructure to create more reliable daily reporting. Developed ETLs using Talend, applying business/corrective logic to data streams. Acted as DBA for MySQL data warehouse environment. Developed dashboard in Adobe Flex for live chat system used by customer service.

Built analysis systems for various clients, from Financial Analysis, Sales Forecasts, and other projects. Mainly leveraging IBM Cognos TM1 cube analysis engine, interacting with various SQL management systems.Built SQL queries from transactional systems and data warehouses from large data sets, performing ETLs when neccesary for cube analysis. Built dashboard solutions which interacted with cubes, to deliver data to clients in a more effective manner. Also designed reports in Excel when requested by clients. Requirements gatherings, transulating business requirements into end user reports and cube structures.Experience using Rules and Turbo Integrator within IGM Cognos TM1.

Gathered requirements from game development team to design and publish reports based on game log data.ETL Development to load game data log files into Data Warehouse, correlating log data with in game content data and platform data (user account information).Migrated existing ETLs from staging database to using Pentaho Data Integrator, allowing for more flexible load frequency and eliminate the need to stage data in a single database.Leveraged Crystal Reports to design reports from game server data warehouse, and delivered reports using Business Objects server.Researched methods and various programs for further reduction of load times and real time data analysis. Prototyped and presented viable solutions to management.Designed and implemented a game metrics collection service in Java, which used Esper, a complex event processing engine. Platform performance metrics fed through this service and was displayed using Adobe Flex charting.

Worked with MS SQL database, synchronizing between SAP via .NET connector. Developed Crystal Reports based off of MS SQL Database for Sales, Logistics, and Customer Service.Administrated and configured TechExcel CRM.Configured Cisco routers, SonicWall firewall appliances, and managed switches.Managed IT office location move, including wiring Cat5 and server room configuration.