Data Warehouse
Resume:
NICOLAAS BOTES
** ********* *****, ********, *** Jersey 07866
******@*******.***
Senior IT Executive
Adept, Strategic Driver for Enterprise-Level Revenue & Growth Solutions at
Global Corporations
Technical & Business Strategies Accelerating Operational Efficiency &
Competitive Edge
M&A Integration – Data Warehouse Solutions – Executive Collaboration – Business
Intelligence – Security
NOTABLE DISTINCTIONS
Accomplished, strategic business partner
who builds viable technology and growth plans that -InfoWorld 100 Award
facilitate new revenue sources and operational -Computer World 2006 Laureate
improvements across enterprise organizations. Award
-Best of New York Award for
Trusted IT advisor and CIO/CTO confidant
projects advancing service to
recognized as pivotal strategic leader for long-horizon
the public
business assessments, integration support, and delivery
-Federal Computer Week Knowledge
of targeted technical improvements.
Management Award
Global technology strategist engaged in
-RCG Information Technology
ongoing C-level advisory roles of 1-10+ years. Fluent in
“I’ve known Nick for over a decade. His technical knowledge and business acumen are second to none.” –
Director Business Intelligence
“Nicolaas is one of the finest solutions delivery principals a technical and business leader par
excellence.” – Recruiting Manager
P ROFESSIONAL HISTORY
SENIOR DIRECTOR
EMBLEMHEALTH, New York, New York, 2010-Presant
Engaged at EmblemHealth (Hip/Vytra) since 2003 . Currently responsible for collaboration
with the business on developing, executing, and enforcing corporate data management policies &
procedures. Established an executive steering committee consisting of key business constituents
to govern and steward warehouse initiatives and content. Strategically manage data priorities
across the enterprise, ensuring timely execution as well as high levels of data quality, integrity,
availability and privacy. Ensure that data management methodologies include the steps,
activities, and deliverables required to constantly achieve high quality data. Ensure that the
applications adhere to defined data management practices, policies and procedures. Identify and
manage the resolution of data quality issues, such as uniqueness, integrity, accuracy, consistency
and completeness in a cost-effective and timely fashion. Worked effectively with business owners
to properly plan and optimize data driven business solutions. Identify and source into a
centralized repository all vital corporate and industry data stored in the business areas and
external entities. Work with the business to define business rules and supply this information to
the assigned IT custodian. Established an enterprise-wide data quality and governance team with
stewards responsible for the specific data areas
GLOBAL MANAGING PRINCIPAL – ENTERPRISE
SOLUTIONS RCG INFORMATION TECHNOLOGY, Edison,
New Jersey, 1994–2010
CIO-Level Authority High-Profile Initiatives at Fortune-Ranked Corporations
1 of 3 Global Managing Principals IT Solutions Leadership for Core Business Needs
Rose through technical leadership roles to step into complex client situations,
collaborating at C-level to assess and satisfy strategic/tactical business requirements. Deliver
leadership services and solutions for management consulting, business intelligence/data delivery,
ERP, system development, conversions, service-oriented architecture (SOA), legacy system
management, outsourcing, systems re-engineering, and application maintenance. Exceed
NICOLAAS BOTES
PAGE 2 OF 4
******@*******.***
objectives up to 218% with Board/CEO/CFO presentations securing key executive engagements.
Supervise 70+ team members at various U.S. and offshore sites, with 5 Directors and 2 Senior
Managers as direct reports.
Career-Defining Executive Engagements (Partial List):
Suffolk County High-ROI, Multibillion-Dollar Strategic Planning & Applications Deployment
Emblem Health Enterprise Data Warehouse, Data Quality, Governance, Compliance, & M&A
Projects
Pfizer Global Manufacturing Systems Development, Business Intelligence, & PMO Tracking
Dr Pepper Snapple Strategic Project Oversight Plus Incident Tracking & Plant Production
Lifetime TV Planning & Deployment for Data Mart, Sales Planning, Event Scheduling, Media
Viewer
ADP Enterprise Data Warehouse Strategy, Data Tool Selection, Data Mart, Customer Analysis
BASF Strategic Data Mart Consulting CVS Caremark Clinical System Upgrade Project
Management
Ann Taylor Enterprise Data Warehouse and Service Oriented Architecture
Revenue & Growth Impacts
Generated $3M+ annual revenue for Suffolk County with state-of-the-art,
award-winning kiosk solution allowing full data retrieval for centuries-old land
transactions of up to $40B. Facilitated innovative concept that united information sources
and gained substantial recognition throughout the U.S.
Added indexing and storage/retrieval for court minutes, Lis Pendens, consumer
affairs, abandonments,
liens, deeds, mortgages, historical/filed maps, judgments, and business
certificates.
Delivered system at significant savings over competing 3 rd-party quotes with in-house
development.
Leveraged Oracle, MS .NET, OCR, and FileNet technologies.
Supported 150% growth to 5 million members at Emblem Health over 4 years,
adding business intelligence, regulatory reporting, state filing, membership reporting, and
claims lookup capabilities from data warehouse.
Supported media buying needs at Lifetime TV, cutting costs of traditional
video distribution with metadata and related analytical functionality in Media Viewer
application; utilized SQL Server, MS .Net, Oracle, ERwin, Business Objects, and Pentaho
technologies/solutions.
Cost Savings & Efficiency
Boosted vendor performance supporting largest pharmaceutical
manufacturing operation worldwide at Pfizer Global Manufacturing with Procurement
Dashboard offering tracking and scorecard capabilities.
Facilitated contract renewal advantages, incentivizing top vendors by leveraging
ranking data.
Enhanced management plant production monitoring with Dr Pepper
Snapple Production Tracker allowing plant statistics analysis including nationwide
outage reporting via data warehouse reporting.
Developed measures to gauge plant safety with new Accident/Incident Tracking
system that facilitated
regulatory reporting to OSHA and other agencies for compliance purposes.
Leveraged SQL Server, MS .Net, and Cognos technologies.
Slashed numerous expenses with Pfizer cost-saving initiative that tracked
suggestions and trimmed billions in related costs annually.
Added Project Management Portal PMO tracking/management tool for
Pfizer, plus SharePoint Newsletter that facilitated communications with global newsletter
creation and distribution.
Strategic Planning & Advisory Roles
Took instrumental role as strategic, visionary advisor to Suffolk County annual
planning process over 10 years, addressing growth, budget, strategic and tactical
initiatives designed to maintain operational momentum.
NICOLAAS BOTES
PAGE 3 OF 4
******@*******.***
Built long-standing trust relationships with CIO and CTOs throughout
first/subsequent mergers over 4 years at Emblem Health; mentored executives by offering
best-practice lessons from multiple IT organizations.
Promoted self-sufficiency among corporate clients, adding strategic support
to strengthen IT organizations by evaluating technical skills and creating long-term
training recommendations.
Defined M&A strategy at HIP, working closely with CTO to identify and retain the
stronger of 2 systems.
Assessed due diligence steps, infrastructure needs, email/communications
systems migrations, and
business process consolidation steps in alignment with related IT systems
integration.
Advised Dr Pepper Snapple CFO and IT teams on application
build/deployment strategies, in addition to strategic direction for technical capabilities.
Consensus-Building & Governance
Won buy-in for systems integration among siloed Suffolk County groups with
education on integration value.
Guarded data integrity with governance initiatives affecting
technology practices, instilling quality stewardship by assessing data warehouse
maturity models and building blueprints for next steps.
Data Warehouse Applications
Created multi-year data warehouse initiative key to M&A growth, facilitating
post-merger data integrations for newly formed Emblem Health (formerly HIP of New York,
GHI, & Vytra), developing and driving best-practices roadmap incorporating data warehouse
environment best practices.
Integrated member, provider, employer group, claims, payment, billing, benefits and
broker data for
operational data access supporting call center, IVR, and Web applications plus
finance/actuarial analytics.
Delivered integrated strategy with 500+ daily feeds into 8 TB warehouse, using SQL
Server, Net, DB2,
Oracle, Informatica, DataStage, ERwin, Cognos, Business Objects, Landacorp, VIPS,
Medstat, and SAS.
Substantially increased revenue at Lifetime TV with Advertising Sales Data
Mart supplying complex analyses for advertising time slot sales, show rankings, and sales
commission calculations that allowed profitable contract negotiations with major
corporations for time- and audience-specific ads.
Built Enterprise Data Warehouse & Data integration hub, consolidating cross-
organizational data to
develop atomic-level warehouse and enable applications development from
operational data store.
Created novel secondary-event capability with application and rules engine supporting
in-show ad popups.
Played key role in ADP’s data management vision, defining Enterprise Data
Warehouse Strategy definition and Maturity assessment, plus implementation strategy
through creation of business matrix. Incorporated MS .Net, Oracle, Informatica, ERwin,
Business Objects, Crystal Reports, and Oracle Financials solutions.
Supported data management needs with customer master data tool
evaluation/selection; added .Net
based application to create customer organization/revenue reporting tool.
Increased sales monitoring capability, adding sales performance reporting with Sales
Data Mart.
Supported supply chain integration at BASF with development of SAP BW Data
Mart; worked in tandem with leadership teams to plan and execute data management
strategy.
Information Security
Architected and drove Auto Redaction Application for imaged documents,
leveraging Optical Character Recognition (OCR) technology to mask sensitive data
while allowing full Web image views.
IT Operations & Projects
Defined long-term, enterprise-level technology strategies in conjunction with
senior management teams at
client sites while handling daily IT operations and oversight of risk management, projects,
deliverables and resources; held authority for multimillion-dollar budget, project
accounting/reviews, and status reporting.
NICOLAAS BOTES
PAGE 4 OF 4
******@*******.***
Promoted consistency across IT function, working in partnership with CIOs,
development teams, and project management teams to drive implementation of agreed-
upon strategies and address recurring business issues.
Incorporated resource center, clinical intervention management system,
mailing system, co-pay waiver program, enterprise clinical rules engine, and other
member/therapy support features into upgraded Advance Clinical System for CVS
Caremark.
Supplied IT executive and tactical support to key clients including Vertrue,
EasyLink Services, Ann Taylor, Starwood Vacation Ownership, Concentra, Viewpointe,
NexGen, New York Life, XL Capital, and others.
Other Experience:
SENIOR DBA / PROJECT LEADER, PARCEL EXPRESS, 1993–1994 (EIS & data warehouse projects)
CONSULTANT, NETWORKING & DATA SYSTEMS, 1992–1993 (Systems development & database
design)
Contact this candidate