Resume

Document Sample
Resume Powered By Docstoc
					                                                                                 John Buschman

Home: 770-304-8375                                                                           Atlanta, GA
Cell: 770-354-2949                                                                  john587@hotmail.com

Summary

   Sr. level IT professional with 17 years of diverse experience implementing BI/CRM solutions
   designed to improve the operating efficiency and aide organizations with accessing strategic
   information. Industry experience includes: SaaS, sports & entertainment, casinos, retail, internet,
   banking, and insurance industries.

Experience

   Home Depot, Atlanta, GA
   Architect, Jan 2010 – Present
   SME for enterprise wide customer relations management (CRM) initiative. Designed all facets of the
   customer program which also included the new movers and trade area capture processes for
   marketing needs. As an architect, I am also responsible for all hardware and networking designs
   which included our Siebel UCM infrastructure as well as modifying the messaging mechanism for
   transporting lookups, inserts and updates for the store systems into our operational database.
   Accomplishments:
       • Able to negotiate Infor Epiphany CRM application’s license from $1million down to $93,000
       • Provided strategy and best practices for CRM national initiative
       • Successfully navigated 21 project work streams through full lifecycles in a single year
       • SME for Unica CRM implementation using Teradata sources and Oracle operational databases
       • Oversaw the (Siebel UCM), Trillium, and DB2 upgrade and capacity expansion process


   InZicht Consulting, Atlanta, GA
   Sr. Principle Architect, 2008 – Jan 2010
   Chief architect and SME for a full CRM implementation located overseas utilizing the SaaS business
   model. Identified standards and best practices for enterprise architecture, data architecture, ETL
   processes, system administration, marketing strategies for email and direct mail campaigns, and
   resource allocation. Mentored and conducted training sessions for the system administration team,
   business managers, data architects, and database marketers. Crafted a long-term client-firm
   relationship for ongoing support, upgrades, and future endeavors. Utilized SPSS Clementine for
   customer scoring and segmentation in order to provide true one-to-one email and direct mail
   campaigns. Aided with all aspects of management for the organization’s entire CRM team
   (consisting of both business and IT). Architected the Oracle data warehouse and data marts on Linux
   servers using the Erwin modeling tool. Developed BI dashboards, ad hoc reports, drill-down
   reporting, data mining, and predictive modeling.
   Accomplishments:
       • Completed a global system which is capable to support 1000+ clients in 9 months
       • Realized a cost savings of €200,000 within in the first 6 months through budget management
       • Created a streamlined process capable of on-boarding a new client within 30 days
   Hands-on Technology Used:
       Oracle 11, SQL, Erwin, Data Architecture, Data Modeling, Data Governance, Data Mart, Data
       Warehouse, Data Security, Data Analysis, Meta Data, BI, ETL, Weblogic, IIS, Linux, SQL Server,
       CSS, Epiphany Outbound Marketing & CME (version 7.1), CRM, Toad, .NET, Camtasia
Autotrader.com, Atlanta, GA
Sr. System Engineer, 2006 - 2008
Directed the full implementation of their CRM solution on Linux Servers utilizing Oracle RDBMS. Met
with vendors and conducted full RFPs. Championed for the creation of a enterprise data warehouse
and created the technical proposal for the CTO. Rendered reporting capabilities to a 100+ person
call center supporting $500 million in revenue. Directly managed a team consisting of 4
administrators. Architected Oracle data marts on Linux servers using the Erwin modeling tool.
Accomplishments:
     • Through our targeted campaign strategy we increased 2006 vs. 2007 revenue by 42%
     • First organization to incorporate user training videos into Infor's OM solution
     • Guest speaker at Infor's 2007 User Conference
Hands-on Technology Used:
     Oracle 11, SQL Server, SQL, Erwin, Data Architecture, Data Modeling, Data Mart, Metadata,
     ETL, Linux, Solaris, BI, Microsoft Office, Weblogic, Apache, Linux, JavaScript, HTML, OLAP,
     MOLAP, Epiphany Outbound Marketing (version 6.5), CRM, Toad, .NET


Churchill Downs, Louisville, KY
Sr. Manager CRM Systems, 2004 - 2006
Supervised the technical side of a full CRM implementation. Conducted change management for the
overall corporation and each of their (6) race tracks. Governed the design, development, system
administration, support, and execution of their solution. Furnished multiple training sessions to large
groups, IT personnel, database marketers, and executive team members. Provided one-to-one email
and direct mail campaigns based on SPSS Clementine’s customer scoring and segmentation
techniques. Directly managed a team of 8 which consisted of DBAs, administrators, and developers.
Architected the Oracle data warehouse and data marts on Linux servers using the Erwin modeling
tool. Constructed a redundant system on SQL Server RDBMS. Developed BI dashboards, ad hoc
reports, drill-down reporting, data mining, and predictive modeling.
Accomplishments:
    • Implemented the first CRM solution worldwide for the horse racing industry
    • Leveraged segmentation strategies to increase their loyalty program by 30%
    • Through our one-to-one campaign strategy we produced a 150% increase in patron wagering
    • Interviewed and published in CRM magazine and destinationCRM.com
Hands-on Technology Used:
    Oracle 10, SQL Server, SQL, BI, Data Architecture, Data Modeling, Data Governance, Data
    Security, Data Mart, Data Warehouse, Data Analysis, ETL, Metadata, Erwin, Weblogic, Linux,
    Windows NT, Apache, IIS, Javascript, HTML, Microsoft Office, OLAP, MOLAP, Epiphany
    Outbound Marketing & CME (version 6.5), CRM, Toad, .NET
NetBank, Atlanta, GA
Marketing Campaign Manager, 2003 - 2004
Managed the planning and execution of email and direct mail campaigns. Maintained a yearly direct
mail operating budget of $5 million. Supervised the implementation of their Epiphany 6.0 OM & CME.
Managed a team of 7 which consisted of marketers and consultants. Architected the Oracle data
marts on Unix servers using Visio. Uses ETL routines for accessing SQL Server RDBMS data.
Accomplishments:
   • Create a campaign strategy which produced a 28% increase in new customer accounts for 2003
   • Executed targeted campaigns which generated an increased revenue by 17% for the fiscal year
   • Recovered $100,000 in operating costs by assuming system administration responsibilities
Hands-on Technology Used:
   Oracle 10, SQL, BI, Data Architecture, Data Mart, ETL, Metadata, Weblogic, Unix, Apache,
   Microsoft Office, OLAP, MOLAP, Epiphany Outbound Marketing & CME (version 6.0), CRM,
   Toad


Nautilus Group, Vancouver, WA
Data Warehouse Tech Lead, 2002 - 2003
Directly managed a team of DBAs, data architects, and CRM system administrators through the full
Epiphany 6.0 OM & CME implementation lifecycle. Acted as the lead system administrator for their
solution. Organized training sessions for IT and business personnel. Sustained a 100+ person call
center responsible for $100 million annual revenue. Managed a team of 4 consisting of DBAs and
data architects. Architected the Oracle data warehouse and data marts on Linux servers using the
Erwin modeling tool. Developed BI dashboards, ad hoc reports, drill-down reporting, data mining, and
predictive modeling.
Accomplishments:
    • Constructed event-based campaigns which generated a 23% increase in 2002 revenue
    • Generated a cost saving of $50,000 by personally conducting training versus outsourcing
Hands-on Technology Used:
    Oracle 10, Erwin, Data Architecture, Data Modeling, Data Security, Data Governance, ETL, SQL,
    BI, Unix, Windows NT, Apache, Weblogic, IIS, HTML, Data Mart, Metadata, OLAP, MOLAP,
    Epiphany Outbound Marketing & CME (version 6.0), CRM, Toad


YouDecide.com, Duluth, GA
Systems Architect, 1999 – 2002
Designed, developed, and supported web-based software for the financial and insurance Industries
using C++, HTML, Java, SQL Server, and Oracle. Tasked with supporting and administration
duties for all call center applications on both Unix and Windows based operating systems. Utilized
Oracle and SQL Server RDBMS for data storage. Developed BI dashboards, ad hoc reports, drill-
down reporting, data mining, and predictive modeling. Managed offshore teams for various in-house
software enhancements.
Accomplishments:
    • Redesigned, reconfigured, and rereleased their CRM application which was not operational
    • Aided in the transfer of all applications to an outsourcing provider during the company’s buyout
Hands-on Technology Used:
    Oracle 9, SQL Server, Erwin, Data Architecture, Data Modeling, Data Security, Data Governance,
    ETL, SQL, BI, Unix, Windows NT, Apache, Weblogic, IIS, HTML, Data Mart, Metadata, OLAP,
    MOLAP, Epiphany Outbound Marketing & CME (version 6.0), CRM, C/C++, Toad, Java,
    JavaScript, eGain, Lawson, .NET
    Greenbrier & Russel, Atlanta, GA
    Consultant, 1997 - 1999
    Deployed to a leading telecommunication company in order to create a PL/SQL stored procedure
    which would handle the re-mapping of area codes for the greater Atlanta region. Assigned to a
    financial institution in order to provide monthly, quarterly, and yearly reporting for the senior
    management team. Contracted to a large shipping and freight company and tasked with creating
    product tracking stored procedures.
    Hands-on Technology Used:
        Oracle, PL/SQL, Stored Procedures, SQL Server, Toad, Linux, Unix, Windows NT, C/C++, Perl


    Catalyst International, Milwaukee, WI
    Software Engineer, 1994 – 1997
    Designed, developed, and supported supply chain software. Systems were built according to
    customer specifications and operated within any infrastructure. Worked with Oracle, Informix,
    Sybase RDBMS while on Unix, AIX, and Solaris servers.
    Accomplishments:
        • Created the company’s base product cycle-counting functionality
        • Redesigned and developed the company’s mezzanine sorting application
    Hands-on Technology Used:
        Oracle, Informix, Sybase, PL/SQL, Stored Procedures, Embedded SQL, SQL, SQL Server, Toad,
        Linux, Unix, Solaris, AIX, Windows NT, C/C++, Perl


Military

    Michigan National Guard, Ironwood, MI
    Sergeant E-5, 1990 - 1994
    Lead the communications department while conducting wartime scenarios. Administered the
    communications team and responsible for all equipment readiness. Refined the department's
    communication training program. Revised the roles and responsibilities of team members.


    US Army, Leavenworth, KS
    Specialist E-4, 1987 - 1990
    Communications specialist responsible for the operation and maintenance of the entire post's radio
    systems, telephones, and hand-held devices. Obtained a secondary military occupation specialty
    (MOS) to work directly with the post commander's elite protocol team acting as a liaison to military,
    government, and civilian VIPs.



Education

    B.S., Computer Science
    Michigan Technology University, Houghton, MI


    A.A., Computer Science
    Gogebic Community College, Ironwood, MI
Training

   Infor Outbound Marketing (OM)
   Infor Campaign Management Engine (CME)
   IBM Datastage


Honors

   2005 Insight Award Winner, Churchill Downs CRM Champion Award, IBM Information Integration
        Solutions Excellence, Case study presented by Gartner, Gartner Symposium ITExpo
   1990 Obtained (3) Army Achievement Awards, Received the Army's Commendation Medal

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:22
posted:2/26/2012
language:English
pages:5