Relevant Experience

Confidential Talascend (July, 2010-Current)

Role: Contract DBA / MIS Project Manager

• Implemented a Apache, MySQL and PHP server then deployed a project management and CMS accessible via the intranet to manage the multiple internal projects.
• SAP preparation of data hygiene approached by reinstalling SQL Server 2005 to include SSIS and SSRS on a under utilized server. Linked other internal databases such as Oracle, FoxPro and other SQL Servers. Packaged views and stored procedures and delivered them through SSRS with parameters as needed. Controlled permissions based on user / department.
• European Union’s Reach compliance IT liaison in charge of identifying hazardous substances in engineering databases by exploding the bill of materials (BOMs) and traversing an extensive network of items. Resultant work enabled engineers to correct offending items quickly and customers and vendors were notified to the new international trade agreement laws and changes.
• Improved performance of an Oracle installation 200% by adjusting memory allocation. All reports improved in time to render, but some notable reports that took over 5 hours to render now do so in one hour. Further work will involve optimizing inefficient code.
• CribMaster Project IT Representative. Installed and deployed this inventory management system and preloaded it with users and key card access codes from various data sources including payroll, gate time system and the current, antiquated ERP system built in FoxPro. 
  

Confidential (Jan, 2009-July, 2010)

Role: Managing Partner

• Developed company philosophy that centered on a “zero loan” organic business model that tapped into the skill sets and knowledge base of the stakeholders and the open source community. The business earned contracts for a Fortune 50 telecom and a global IT resources company and grew to accommodate two full-time employees and several contract positions as needed.
• General business administration / Accounting: Managed budgets, bank reconciliations, tax liabilities, payroll and accounts receivables using Quick books (online and desktop versions).
• General marketing responsibilities included developing corporate brand, case studies, and small direct mail programs as well as developing presentations and proposals.
• Project management of a team of four individuals ranging in skill sets from backend SQL developers to graphic designers.
• Daily workload includes MS SQL Server development using SSIS, T-SQL for a Fortune 50 telecom. On-site data hygiene process improvement for a multi-national defense / manufacturing corporation.

Confidential

Role: Data Warehouse Administrator (Dec 2007-2009)

• Managing all aspects of the Consumer Data Warehouse (CDW), including data purchase, hygiene, integration; touch-point strategy development; automated Customer Relationship Management (CRM) maintenance for all sales channels; business rule development and maintenance. Managed a data budget of over three hundred thousand dollars annually.
• Developed, guided and executed an Address Keying Project that allowed the AJC to use existing platforms to geocode using MapMarker ESP. The resulting work allowed a unique key to compare billing systems records, DISCUS records and 3rd party data and develop a cohesive view of customers while eliminating the need to outsource the process (savings of $125 thousand annually).
• Develop touch point strategies (and subsequent data base queries) for Advertising and Direct Response mailings, targeting specific demographics and/or newspaper loyalty segments using MS SQL, Claritas’ Consumer Point, and other proprietary systems (MAAX).
• Executed multiple “Market Intelligence” reports and maps using MapInfo Pro v.9 and MapMarker Pro (client side) for VP level executives.
• SQL Solution for Outside Sales’ Channels payroll that calculates and warehouses commission paid on individual subscriptions.
• Comprehensive CDW demographic data audit. Audit resulted in discontinuation of two 3rd party vendors in favor of a third vendor, with an instant annual cost savings of $40,000, an increase of nearly 200,000 addresses, higher quality demographic data and a $70,000 annual savings with USPS Computerized Delivery Sequence (CDS) qualification

Role: Advertising Preprints’ GIS Analyst (2005-2007)

• Developed AJC’s Target Market Zones’ (Sub-ZIP zones) structure—a sophisticated, newspaper-carrier-route driven solution using MapInfo Pro, MapBasic, MapInfo SpatialWare and MS SQL server 2000. Sub-ZIP program generated $65,000 in incremental revenue as of December, 2007 (first quarter in effect).
• Developed a GIS data repository for enterprise-wide access. Worked closely with I.T.’s DBA’s for production and access.
• Responsible for building location-based advertiser intelligence using MapInfo and MapMaker.
• Demonstrated Mosaic Segmentation analytics, augmented by distance analytics for AJC advertisers. Resulting in over $55,000 in incremental revenue on the first report.
• CDS Qualified 6 metro-Atlanta area ZIP codes, resulting in large savings.

Confidential

Role: Multiple: Primarily Network Support (1997-2002)

• For this small computer company that managed the IT for multiple regional banks in the Southeast. Integration of small banks with Fiserv
• Responsibilities included premise wiring, network support, server installation and deployment and other network related support.

Technical Knowledge base & SkillSet

• MS SQL 2000, 2005 Developer (6 yrs)
• T-SQL including stored procs, udfs, views, query optimization (5 yrs)
• MS Access (5 yrs)
• PitneyBowes MapInfo products (5 yrs)
• Data Modeling, Analysis & QA (i.e. CRM, Reporting, data audit, db modeling, etc) (intermittently)
• MS SQL Server Integration Services (4 yrs)
• MS SQL Server Reporting Services (<1yr)
• MS SQL DBA Responsibility security, network (<1 yr)
• PHP (2 yrs)
• HTML, CSS, Java Script, (2 yrs)
• Other: Office products, Eclipse, Photoshop, Gimp, OpenOffice, FTP, Shell scripting, PGAdmin III, Crystal Reports, MySQL Workbench, Unix, Windows

Published In:

• Paste Magazine
• The Piedmont Review
• The 30-A Review
• Atlanta\'s Finest Dining

Certifications, Classes and Notable Accomplishments:

• Vice President of the Atlanta Journal-Constitution\'s GIS User Group
• Speaker at the Atlanta MapInfo User Group (Topic: Voronoi Polygon Rendering and Aggregation and Newspaper Route Structures)
• Technical Consultant for Reach Out Marketing
• Certified MS SQL Server 2005 class 2780
• Deans List -- Georgia State University, Atlanta.
• Awarded the G.E.M. Award for Innovation by the Atlanta Journal-Constitution in 2006
• Co-founder of LookTerra, inc.

General:

• Extremely creative in problem-solving with strong analytical abilities and a keen eye for problem mitigation.
• Strong command of communication with a focus on information aesthetics and audience access—verbal, written and visual.
• Rapid learner. A penchant to grasp complicated concepts quickly.
• Innovative, self-starter who enjoys leading others to successful execution of objectives.

Education

• B.A., English
• B.F.A, Painting T.B.A.

Interests

GIS, travel, technology, web applications, neuroscience, psychology, rock climbing and hiking