BILL PHILLIPS
3609 Stocklea Way  *  Lexington, Kentucky 40515
 [Send email to request phone number] 76-9201  *  

BUSINESS ANALYST/BUSINESS INTELLIGENCE

Proven IT leader, senior system engineer and project leader with more than 20
years of experience improving operational performance, accuracy, and reliability
by expertly aligning technologies with corporate goals. Expertise elevating
productivity through skillful execution of innovative systems development,
design, and implementation initiatives. Strategically manages resources to cut
costs and deliver highly effective solutions and support. Dynamic leader focused
on sparking innovation, building strong relationships, and exceeding strategic
objectives. Areas of expertise:

Leadership  *  Strategic Planning  *  Business Intelligence and Reporting  * 
System Implementations
Emerging Technologies  *  Process Automation  *  Conversions  *  Client and
Vendor Relations 
Process Reengineering  *  Quality Assurance  *  Test Plans/Scripts  *  Cost
Reductions 
Compliance  *  Network Security  *  Tax/Financial Systems  *  Warehouse Systems

Staff Supervision  *  Network Infrastructure  *  Technology Acquisitions 
Process Development  *  Vendor Selection  *  Systems Engineering
Need Analysis  *  ETL  *  SAP  *  Visual Basic .Net  *  VB 6.0
SQL Server  *  Client Server  *  AS/400  *  Magic  *  RF

PROFESSIONAL EXPERIENCE

ASHLAND, INC., Lexington, Kentucky  *  1985-2008
Diversified FORTUNE 500 chemical company, providing innovative products,
services, and solutions. 

Senior Systems Engineer (1998-2008): Oversaw IT support for multiple
departments. Served as primary IT liaison with clients. Coordinated IT staff
efforts during implementations. Consulted with business clients to implement
required changes. Resolved network, Internet access, security, and server
availability issues. Led design, development, testing, and integration of hosted
and non-hosted applications. Determined best practices, trained clients, and
supervised procedure documentation. Supported international tax processes for
SAP, including VAT and tax audits. Researched historical information, and
presented IT perspective during audits. Ensured compliance with IT audit and SOX
requirements. 

Operational and Process Improvements  *  Business Intelligence, Conversions and
Enhancements

 *  Slashed processing time for sales tax audit requests from 1 month to 1 day
by implementing tool to extract data from SAP Data Retention Tool (DaRT). 
 *  Reduced headcount 90% by streamlining processes for all areas of U.S. Tax
support. 
 *  Ensured accuracy of corporate tax data, including $1.3 million monthly
accrual and 15 million annual tax bills, by providing ETL processes for data
during conversion to ePropertyTax.com application. 
 *  Decreased processing time 10 hours per night by taking over implementation
of Apropos call center BI software using Cognos Report-Net and SQL server, and
modifying reporting processes. 
 *  Enabled reporting of historical sales from GL by developing new income tax
sales reporting database. 
 *  Increased accuracy of audited information by revising retrieval procedures
for sales tax information filings to use DaRT as source instead of business
warehouse. 
 *  Allowed monthly rent payments for franchise locations by enhancing real
estate management system.
 *  Eased conversions to SAP and JD Edwards by rewriting all Property Tax System
(PTS) interfaces.
 *  Insured GL balanced to supporting detail by adding verification control to
PTS accrual processing. 
 *  Made it possible to distribute property tax reports electronically by
modifying reporting processes.
 
BILL PHILLIPS  *  Page 2  *  

ASHLAND, INC., Continued

System Implementations

 *  Played key role in timely implementation of property tax system by serving
on technology acquisition project, influencing vendor selection, and creating
data maps and interface specifications.
 *  Facilitated replacement of legacy HR systems with Human Capital Management
(HCM) module from SAP by coordinating QA testing for 31 interfaces with benefit
providers, and writing test scripts.
 *  Automated assignment of highway use tax charges by implementing new system
for 170 clients.
 *  Consolidated multiple AFE systems by implementing new AFE routing and
approval system. 
 *  Streamlined asset depreciation reporting by participating in implementation
of JD Edwards system, including writing reports on JD Edwards using Star report
system to extract depreciation expenses. 
 *  Developed processes around PTS by using Visual Basic, SQL Server, Access,
and VBA to create reporting and interfaces that could compensate for application
deficiencies. 
 *  Implemented PTS to handle $2 million monthly property tax liability
accurately by collaborating with vendor to define accrual process.

Cost Reductions

 *  Cut operating expenditures by leading technology acquisition and vendor
management project to retire employee expense reporting system and outsource
work.
 *  Expedited transition of financial, AP, AR, and supply chain systems to run
on single worldwide platform by participating in GlobalOne rollout of SAP and
modifying interfaces. 
 *  Replaced all PCs in supported departments by coordinating rollout and
explaining implications to clients. 
 *  Accelerated GlobalOne project by authoring template for GL and AP format
conversions.
 *  Eliminated operating costs and downtime during monthly accrual and asset
load processes by implementing SQL Server version of PTS.
 *  Boosted income by developing process to record surplus real estate
properties and post to Web site for prospective buyer viewing.
 *  Accelerated asset dispositions by modifying processes to remove assets from
property account. 
 *  Provided accurate tax reporting by modifying asset retrieval process to
re-classify owned assets that company had leased before purchasing.

Systems Engineer (1991 to 1997): Supported applications on IBM System/38 and
AS/400. Developed, implemented, and maintained applications in COBOL, including
warehouse, P&L, online reporting, and price tracking. Designed systems on AS/400.
Programmed in COBOL and OS/400. Served as database administrator. Provided
operational support. Ensured timely communications and security. 

 *  Minimized processing time by converting retail warehouse system from
Datapoint network to IBM System/38.
 *  Permitted centralized control of retail merchandise pricing and collection
of product movement and replenishment information by implementation of JDA and
Warehouse Control systems.
 *  Optimized order tracking accuracy for retail group by developing mobile
inventory system for all trucks. 

Note: Additional career positions include Programmer/Analyst at ASHLAND, INC.

EDUCATION

Bachelor of Science in Applied Mathematics and Music 
Centre College, Danville, Kentucky