John Horner Email & Phone Number

Excelsior, Mn, Us

Implemented SAP BW analytical applications in the areas of Profitability (CO-PA), Sales (SD), Marketing (CRM), Quality (QM), and Purchasing (PP). Member of core team to bring global procurement business analytics to Tennant. Successfully developed BI applications to analyze price impact/movement, defect activity, and low cost economy spend. Provided management with effective negotiating tools to improve vendor quality and reduce purchasing costs.Experienced in all aspects of BW development including backend ETL, frontend reporting tools, and performance tuning.ABAP / CMOD experience enhancing data sources on the source system and setting query variables and virtual key figures on the BW system. Standardized and integrated BW backend process chains into corporate centralized scheduling system. Skill Set Used: SAP BW 3.5, R/3 4.6C, ECC 6, ABAP, Bex Query Designer, Web Application Designer (WAD), Application Process Designer (APD), CMOD, UC4

As a Cognos, Oracle data warehouse developer and architect enhanced and supported a custom built BI architecture based on an Oracle database and Cognos frontend reporting tools. ETL components included SAP ABAP extracts, Unix and SQL scripts, Oracle PL/SQL. Data was stored in Oracle database and Cognos cubes. Application served business users around the world.Skill Set Used: SAP ABAP, Cognos Impromptu and Powerplay, Oracle, PL/SQL, SQL scripts, UNIX

As a contract Powerbuilder, Oracle PL/SQL Developer assisted with data separation and integration tasks related to General Mills purchasing Pillsbury. Using PL/SQL created process to identify and extract recipe data related to Pillsbury products that were recently sold to International Multifoods Corporation (IMC). Then customized a Powerbuilder application to format the selected recipe data into XML for delivery to IMC. Modified several Powerbuilder PL/SQL cost tracking/planning applications to meet new business requirements (fiscal year conversions, accounting changes, etc). Skill Set Used: Powerbuilder, Oracle, PL/SQL, SQL Developer, Unix, XML

As a contract Powerbuilder, Oracle PL/SQL Developer assisted in the development and support of a large customer loyalty application. Worked with a team of developers and the business operations group to deliver major releases of the application on a scheduled basis. Daily activities involved analysis of user issues recorded in TRACKER database, creating estimates, and developing code (Powerbuilder, PL/SQL packages and stored procedures, and UNIX Shell Script) to resolve issues. Also while at the same client, played a key role in implementing an XML messaging application which provides trading partners the ability to submit and track transaction data on a real time basis.Skill Set Used: Powerbuilder, PFC, Oracle, PL/SQL, SQL Navigator, Unix, XML

As a contract Microsoft Developer created VB COM objects to present recipe data to various web sites using XML and XSL technology. Created ASP web pages and COM objects to receive and store recipe data into a relational database. Developed VB program to run as an NT scheduled task extracting mainframe DB2 data into a relational database.Skill Set Used: Visual Basic (VB), COM, MTS, Active Server Pages (ASP), JavaScript, HTML, XML, DOM, XSL, SQL Server, DB2, Oracle, DirectConnect Gateway

As a contract Powerbuilder Developer developed a distributed sales and marketing reporting system used by over 600 users nationwide. Data pulled from multiple data sources and fed into Excel to create presentation ready workbooks. Object oriented design combined with special deployment feature, allows report changes to be released to all users in minutes (vs months). Server portion allows users to schedule reports to be created remotely.While at the same client also enhanced and supported a purchasing system, mentoring the client lead in Powerbuilder development.Skill Set Used: PowerBuilder, PFC, PowerClass, Oracle, DB2, DirectConnect Gateway

Ba, Computer Science

Education record