JAY ALLEBORN
* ******* ***** ? Pittstown, NJ ****7 ? 908-***-**** ?
*********@*******.***
INFORMATION TECHNOLOGY MANAGER - BUSINESS INTELLIGENCE
Information Technology Professional with over fifteen years of experience.
Specialize in providing the leadership, technical knowledge, and direction
for the successful implementation of business intelligence, data
warehousing and reporting solutions. Experience supporting information
demands for several business areas including Accounting, Finance, Customer
Service, Sales, Operations, and IT. Hands-on manager with strong
leadership, coaching and organizational skills. Successful Stanford
Certified Project Manager, coordinating and participating in all phases of
the system development life cycle, from requirements definition to system
design, build, test, training and support.
Extensive experience with all features, operations and architecture of
industry leading business intelligence suite of tools. Strong programming
background with over ten years of software development and distribution.
Proven expertise with data warehouses, data marts, and operational data
stores in leading DBMS products utilizing relational, snowflake and star
schema data models. Proactively research and evaluate new releases of
Business Intelligence products, working with business management to
maximize effectiveness of strategic investments.
PROFESSIONAL EXPERIENCE
HEWLETT-PACKARD
HP FINANCIAL SERVICES - Murray Hill, NJ
May 2002 - Present
HP Financial Services provides global leasing and financial asset
management solutions to customers of all sizes, including a full range of
value-added services to help businesses improve cash flow and reduce total
cost of ownership.
IT Solutions Manager - Global Data Management
Jan 2008 - Present
As Solutions Manager, responsible for creating the go-forward global
strategy and road map for information management. Work with Business
Process Managers and Development Managers to ensure IT and Business
strategies are in alignment. Develop process to drive information
standardization and governance to improve data quality. Apply portfolio
project management methodologies to manage new opportunities and business
initiatives.
. Managed DCC project - delivered in 6 months - consolidation of all
data warehouse and reporting infrastructure as part of HP's global
initiative of data center consolidation.
. Retired eight systems, applications and servers, as part of the
consolidation contributing to Hewlett Packard's $1 billion in annual
savings.
. Responsible for the project planning and management resulting in
successful migration of 1400 reports, Informatica mappings and 1.5
terabyte data warehouse.
. Provided scheduled communication to business partners and training
presentations to over 1500 users.
GLOBAL INFORMATION MANAGER
Jan 2005 - Dec 2007
As the Global Information Manager, supervised, prioritized and directed the
workload of report and ETL analysts and developers globally. Established
rapport with business partners for definition of reporting and
informational needs. Responsible for all report development, maintenance
and support. Managed reporting and data warehouse production releases.
Earned Green Belt certification for process improvements regarding
Invoicing and Customer Satisfaction.
. Managed development of operational data store and data mart for ad-hoc
reporting of sales information.
. Conducted Joint Application Development (JAD) sessions working with
business managers to identify information needs.
. Successfully deployed global installation/upgrade of Business Objects
6.5.1 for 2000+ user environment.
. Managed software upgrades of Informatica 6 to 7 and Oracle 9i to 10g.
. Manage Data Warehouse releases and enhancements - analyze report
requirements impact to data warehouse, assist in the design and review
of data models.
. Participate in design of database tables and data
extraction/manipulation routines using Informatica ETL tool.
. Create Global process and standards for reporting and design and
deployment.
. Actively participate in trouble-shooting, production support and
maintenance activities ensuring customer satisfaction.
. Conduct performance reviews and staff evaluations providing feedback
and areas of improvement.
. Participated in Sarbanes-Oxley (SOX) audits and implemented compliant
process controls.
NORTH AMERICA INFORMATION MANAGER
May 2002 - Jan 2005
As the Product Manager of Business Objects, responsible for all
administration, installation, maintenance and security. Facilitated
enterprise wide deployment of Business Objects desktop and server products,
including Supervisor, Designer, Reporter, Explorer, WEBI, ZABO, Broadcast
Agent, Auditor, and Application Foundation. Managed all upgrades to
application software and hardware to improve performance and capacity
without service interruption. Conducted training classes for IT and
business partners on Business Objects functionality.
. Managed reconciliation reporting project for validation of Global
merge of Compaq and HP system data.
. Collaborated with business managers to identify requirements and
information needs.
. IT representative on Customer Satisfaction Team - provided input,
questionnaire review and analyzed survey results.
. Attained Green Belt certification for process improvements regarding
billing and invoicing resulting in greater customer satisfaction.
COMPAQ
COMPAQ FINANCIAL SERVICES - Murray Hill, NJ Mar 2001 -
May 2002
Compaq Financial Services provides global leasing and financial asset
management solutions to customers of all sizes, including a full range of
value-added services to help businesses improve cash flow and reduce total
cost of ownership. Compaq merged with HP in 2002.
NORTH AMERICA INFORMATION MANAGER
Mar 2001 - May 2002
. Managed the conversion of legacy crystal reports and stored procedures
to Business Objects reports and universes.
. Design and build complex Business Objects Universes to enable data
access by report developers and end-users.
. Automated month end book close financial reporting which significantly
reduced processing time and increased report accuracy.
TOTAL RESEARCH CORPORATION - Princeton, NJ
Jan 1994 - Feb 2001
Total Research specializes in the development and application of predictive
marketing research and other advanced research technologies. Total Research
also provides integrated marketing services, including e-products and
services used to assist clients worldwide in applying information and
insight to marketing practices. Harris Interactive purchased Total
Research in 2002.
Held various positions that contributed to the growth of the company.
Manager - Computer Applications Development Department
Nov 1998 - Feb 2001
. Created Business Objects reports and developed customization of
WebIntelligence front-end to provide web based reporting system
utilizing the WebIntelligence SDK.
. Maintained relationships and interacted with clients such as
Microsoft, IBM, and Qwest on multi-million dollar projects.
. Delivered Customer Master Data for use in global customer satisfaction
studies.
. Coordinated project planning and implementation of developed systems.
. Architected SQL Server data warehouse web application to provide on-
line query capabilities.
. Developed international customer database solutions using Visual Basic
front-end and SQL Server/Oracle database backend.
. Designed XML conversion applications for import into SQL Server
database.
. Programmed bulk e-mail/triggered e-mail automation utilizing Visual
Basic, SQL Server, Outlook and Exchange.
. Created report automation applications using Microsoft Excel, Access
and Visual Basic.
. Supervised the Application Development staff, contactors and virtual
teams. Maintained project schedules, task lists and delegated
assignments.
. Recommended methods for the automation of processes and the costs
involved.
. Met with clients to gather specifications and provide project status
reports.
Programmer Aug 1997 -
Nov 1998
. Created and maintained various applications for data collection,
manipulation, exchange and reporting.
. Programmed Visual Basic/Access front-end to Oracle database server to
access data for reporting.
. Created Microsoft Office solutions using Visual Basic for
Applications, ODBC, and Active X controls.
. Developed import/export applications to automate data conversion from
fixed ASCII to Access database or Excel spreadsheet formats.
. Responsible for product installation and general troubleshooting to
insure client satisfaction.
Spec Writer/Senior Specifications Writer
Jan 1994 - Aug 1997
. Created cross-tabulated reports of survey data using CfMC C-Mentor
software for analytical/statistical analysis and presentations.
. Created and implemented Visual Basic conversion program of survey data
for Excel spreadsheet presentation.
. Established specifications and code programs to check data for logic
and validity.
. Executed and maintained proprietary multivariate methodologies using
SPSS software.
COMPUTER PROFICIENCY
. Business Intelligence: Enterprise Business Objects XI R2/6.5/5.x
(Supervisor, Designer, WebIntelligence, Broadcast Agent, Application
Foundation/Dashboard Manager, Business Objects SDK, Crystal Xcelsius,
Informatica.
. Database Systems: Oracle 10g/9i/8i, SQL Server 2000/7.0, MS Access.
. Operating Systems: Microsoft Windows XP/2000/NT/Server 2003, VM Ware.
. Web: IIS 6.0, Tomcat/Apache.
. Programming Languages: VB.NET, ASP.NET, Visual Basic, SQL, ASP, VBA,
DTS.
. Desktop Applications: Microsoft Office Suite (Word, Excel, Access,
Outlook), Microsoft Project, Microsoft Visio, Erwin 4.1.
EDUCATION & CREDENTIALS
STANFORD UNIVERSITY, Stanford Advanced Project Management (APM) Program
Stanford Certified Project Manager (SCPM) - February 2006
SAINT LEO COLLEGE, Saint Leo, Florida
Bachelor of Arts in Business Administration - May 1992
Specializing in Management