Game Designer / SQL data analyst and Full Stack developer
I am a professional Full stack developer having 7 + proven experience in game development and SQL data analyses. For many years I have worked on teams with project managers and developers to create rich websites, games and mobile applications for clients. I have created static and Flash animated illustrations for use in online advergames, designed and illustrated applications for iPhone, iPad and Android. I was responsible for managing the development and design of in house tools for torque engine games. Designed, textured and modeled 3d game objects and provided direction and feedback to maintain a similar look and style for all art throughout the game. I have created environment levels, scripted and wrote story driven in game tasks and edited documentation for sound effects and voice recording. Led the game design team adapting the existing board game to the iPad market, mapping out plans for acquisition, retention, engagement and monetization. Worked with the creative director to research and approach board game companies to discuss translation of their games from one market to another, coordinated between the game design team, art team, sound team and marketing team to ensure everyone was on the same page, working towards the same vision. I have created new game experiences, control systems and interaction paradigms, set up weekly design meetings to encourage better communication amongst the designers and allowed for improved allocation of design resources. Throughout my expertise I have created game scenarios, maintaining design documents so that design concepts are clearer to the rest of the team and assisted in the creation and tuning of rule sets in order to create more unique experiences for the user.
As a SQL data analyst I have designed databases, stored procedures, reports and data input interfaces using SQL Server, created and updated applications for internal company operations, developed fully functional applications, add-ons for various systems to better accommodate user needs and provide accurate information validation. I have performed analysis and presented results using SQL, SSIS, MS Access, Excel and Visual Basic scripts. Imported, exported and manipulated large data sets in multi million row databases under tight deadlines.Wrote and automated tools and scripts to increase departmental efficiency and automate repeatable tasks. I have manipulated files and their associated data for rapid delivery to clients or loading onto internal databases, collaborated with project managers, legal counsel, and other team members to gather data for projects. I have designed and populated specific tables, databases for collection, tracking and reporting of data, diagnosed and addressed operational data issues, modified and maintained oracle procedures using SQL and provided HelpDesk and Technical Support.