Data Engineer II: Developed initial scripts to pull data from various Public and Private APIs for an internal WatchdeskDevised a suite of scripts to merge various data sets within S3Developed python code to take in an SPSS document and return an edited SPSS document based on other passed in data via excel docMerged data using multiple sources using internal functions to load into S3Created Code snippets in Python to assist with systematic Data Quality checksIdentified opportunities to make processes more efficient and scale-able using new data productsSupported quick turn around survey analytic output and adhoc requestsDatabase Developer:Adapted ETL scripts to use data inputs from another systemDeveloped aggregation and reporting tables for client data setUpdated Legacy Code for additional functionality and auditing capabilitySupported Legacy Database functions while team member was out on extended leaveValidated stored survey data with SPSS output filesConfirmed, adapted and executed ETL processes based on format of incoming vendor data

Produced reports based on user requests and customer consultation using Cognos Report StudioAnalyzed and Edited existing reports for updates and error fixesDeveloped and Modified Cognos Framework as basis for reporting needsUtilized SQL and explored existing code to do investigation into data discrepancies to find root data causes for report differences and recommend adaptationsCompleted various Cognos Administration tasks as needed in both Cognos 10 and 11 environmentsCreated and Maintained Datasource connections in CognosDeployed frameworks between various environmentsWorked on Customization of new Cognos 11 installationTransitioned to Safe Agile work processes, utilizing scrum and user stories from ticket and project based workflow

Processed Files through Oracle ERP to create print request in order to test document layoutUsed HP Quality Center 10 to track test cases ran in Oracle ERP dealing with picking and receiving of goodsTested ability of Image Capture System to accurately gather and transfer information scanned

Deployed Code to Development and Production environments using internal tools and HP’s PPMCMaintained Non- Production environmentsResponsible for Weekly and Bi-Monthly updates to Address Database systems.

Responsible for general administration of the convention and oversees scheduling, staffing, and other duties related to the general running of the convention Assistant Director of Operations 2008 - 2008Head of Registration 2005 -2007Streamlined registration process and procedures

Created Oracle and Unix Accounts on various servers and databasesOrganized meetings of an internal Oracle user group, send out weekly newsletters/meeting minutesRedesigned process for automating remote Function Calls in a Disaster Recovery environmentMaintained space according to monthly estimates for critical serversTested and validated migration list and data model for the redesign of a client applicationAdapted development DDL into Data Model Specification DocumentAssisted in creation of Materialized Views and client project's base architectureDeveloped a script for forwarding files from one box to another at given intervalsExpedited technical tickets between multiple organizationsMigrated building block and finance applications to User Acceptance Testing , and from User Acceptance Testing through Production environmentsConducted table specific recovery of a production database Completed data moves between databases using various methods including database links, export/import and imports via data pumpConfirmed partition compatibility, gathered satistics and updated/confirmed indexes on tablesVerified structure and environment consistency across environments Resolved various issues pertaining to Query re-write, privileges or environment

Hired, supervised, trained and scheduled more than 70 concurrent employeesUtilized Symantec Ghost Solution Suite to assist in large-scale software deploymentCombined Perl, HTML and SQL to update and support dynamic pages for the labs intranet and external websitesRe-Structured Lab Assistant position to include evening supervisor and on campus point of contactFacilitated upkeep of over 300 machines in 7 different locations around campusOrganized location transfer of 4 offices, server room, workshop and 40-seat lab in a span of two weeksBuilt and deployed new modularized lab client for use in student labsCreated and managed a multi-talented team for various lab management tasks.

Supervised front-end operationsTrained new CashiersResponsible for Cash Office: balancing tills, completing and organizing paperwork