Jeremiah McMiller
Senior Business Intelligence Technical Lead
Email: abinvy@r.postjobfree.com Phone: +1-678-***-****
Professional Profile
I have over 14 years of expertise as a Business Intelligence and
Information Technology (IT) Consultant. I am responsible for and involved
in a wide range of consulting engagements covering IS strategies,
methodology development, BI center of excellence implementations, program
managing highly visible IT and non-IT initiatives, outsourcing studies,
vendor & contract management, IT implementations, change management,
business continuity planning & disaster recovery, global technology
deployments & rollouts, application development & integration software,
security infrastructure & policy development. I am a hands-on senior-level
consultant, offering extensive enterprise-wide technical competency and
business process expertise.
I have a proven track record and leadership abilities in launching, growing
and maintaining all facets of a BI BusinessObjects project (e.g. data
analysis, project management, business analysis, report development, system
administration, application troubleshooting, systems architecture design
and implementation, and user training).
Currently, I am the Business Intelligence Chief Architect for Pro-Ture
Consulting Services, LLC. In this role, I serve as the head advisor to the
Senior Managing Partner and I am tasked with building the Business
Intelligence Practice. I lead the Practice through obtaining many industry
Partnership/Certifications to include, Oracle Platinum Partners, SAP
Extended Business Partner, Microsoft Business Partner, APOS System Partner
and IBM Business Partner. My duties also include interviewing potential
candidates for project, writing and reviewing SOW/LOE, obtaining
Professional Services Agreements with clients.
While employed at BusinessObjects, I was a mentor in the SAP
BusinessObjects StarTrak program, where I was tasked with mentoring "up and
coming" Technical Architects within SAP BusinessObjects. My achievements
include managing one of Business Objects largest customer engagements
during the restatement of their financial earnings. I have Business
Intelligence experience in several industries including Finance,
Telecommunications, Government/DoD, Retail and Software. I am a
BusinessObjects Certified Professional - Crystal Reports and a Teradata
Certified Professional. I have strong SQL experience with RDMS to include
Oracle, SQL Server and Teradata. I completed several Business Objects
Migration projects to include: 1) migration from BusinessObjects 5.x/6.x/XI
to BusinessObjects XI Release 2; 2) performed conversion of several
thousand BusinessObjects (Desktop Full Client) reports using
BusinessObjects XI (R2) Report Conversion Tool; and 3) migration from other
BI tools (e.g. Microsoft, Oracle, IBM Cognos, SAS, MicroStrategy, etc.) to
SAP BusinessObjects and vice versa. My strengths include thought
leadership, program/project direction, global deployments through
structured lifecycle management (SDLC), team mentoring and integration,
communication and vendor management, low-level technical deep-dives and
troubleshooting, business process engineering/re-engineering, and
analytical research.
Technical & Business Skills
Applications
Business Objects Enterprise XI (Release 1, 2 and 3) Web Intelligence XI
Crystal Reports 5 / 6 / 7 / 8 / 8.5 / 9 / 10 / XI Crystal Enterprise v.
9 - 10 Business Views Crystal Info / Seagate Info 4.5 / 5 / 6 / 7.x
Business Objects Enterprise 6.1a / 6.5 PeopleSoft 6 / 7 & 8.x Crystal
Xcelsius 4.5 Data Quality XI R2
Operating Systems & Networking Technologies
Microsoft Windows 2003 Microsoft Windows NT DOS Microsoft Windows XP
Microsoft Windows 95, 98 TCP/IP Microsoft Windows 2000 LDAP Active
Directory
Database, Data Warehouse & OLAP Technologies
Teradata V2R5 Oracle 7 / 8 / 8i / 9i / 10g Microsoft SQL Server 6.5 / 7 /
2000 / 2005 Sybase SQL PL/SQL MS SQL Server DTS
Programming & Internet Development
Visual Basics ASP HTML PowerBuilder COBOL /CICS / JCL C/C++ BEA
Weblogic Server MS Internet Information Server IBM WebSphere v5 & v6
Tomcat Apache HTTP Server
Project Experience
Pro-Ture Consulting Services, LLC
September 2009 - Present
Kaiser Permanente - Silver Spring, MD
Head advisor to the Senior Managing Partner and is task with building the
Business Intelligence Practice for Pro-Ture Consulting Services, LLC.
Jeremiah duties also include interviewing potential candidates for project,
writing and reviewing SOW/LOE, obtaining Professional Services Agreements
with clients. Conducted and Participated in project planning sessions with
project managers, business analysts and team members to analyze business
requirements and outline the proposed solution.
Mr. McMiller worked extensively with Project documentations such as System
Specification, Technical Specification, Universe, Migration Strategies,
Crystal Xcelsius Dash Board Analysis and planning. Implemented business
plans and Migration strategies for BOXI Migrations.
Worked along with production support team to fulfill the end user
requirements and defining best solutions for the User tickets. Conducted
and participated in Executive Dash Board Design and Maintenance using
Crystal Xcelsius. Additional duties included working with Business leaders
and IT Managers in gathering requirements and distributing the work between
the IT teams. Worked with Kaiser's UAT support team in creating and testing
test cases for the BOXI migration project and conducting performance tuning
of the BOXI infrastructure. Optimize and performance tune BOXI and Teradata
infrastructures.
Environment: BusinessObjects XI R3, Teradata, Cognos 7.2, BusinessObjects
SDK
Eagle Creek Software Services
July 2008 - August 2009
WellPoint, Inc - Indianapolis, IN
Mr. McMiller worked as the Eagle Creek's Technical Lead for the Missouri
Legacy Facet Retirement Project. Responsibilities included developing
BusinessObjects XI universes from Cognos Catalogues, creating Web
Intelligence Reports, gathering business requirements and act as technical
liaison for WellPoint and Eagle Creek's Pierre Development Center.
Additional responsibilities included assisting with the setup Pierre Center
VPN connection, help troubleshoot connection issues and database
connectivity issues. Mr. McMiller duties also included reviewing, testing
and approving development work.
Environment: BusinessObjects XI, Oracle 9.2, Teradata, Cognos 7.2
SAP BusinessObjects, DoD & Aerospace Practice
February 2007 - July 2008
DoD/EIDS (Military Health System) - Falls Church, VA
Mr. McMiller worked as the Solution Architect and Project Manager for the
Executive Information Decision System (EI/DS) PMO office. Responsibilities
included developing a Business Intelligence Enterprise Architect for the
Military Health System (MHS) project. Task included developing a detail
project plan and providing a tested solution for a data center move,
developing a proven Enterprise security model, developing a detail
migration plan, provide Vision designs of the Enterprise Architect, ports
and protocols, SSL traffic flow and provides solutions to existing
BusinessObjects open cases.
MHS - Military Health System Management Analysis and Reporting Tool (M2) is
an ADHOC query tool used to obtain summary and detailed views of
population, clinical, and financial data from all MHS regions. M2 includes
MTF and purchased care data integrated with eligibility and enrollment
data; this integrated data enhances support to decision-makers at all
levels of the MHS. With M2 data, users can perform trend analyses, conduct
patient and provider profiling studies, and realize opportunities for
transferring healthcare from the private sector to the MTF is supported by
the SAIC integrator and managed by the EI/DS program office (manned itself
by IBA contractors). M2 is the MHS DEERS reporting solution.
Environment: BusinessObjects 5.1.7, BusinessObjects 6.5.1, BusinessObjects
XI R2, DB2, Oracle 10g, IBM PowerCenter, IBM Director, VMWare ESX and
Oracle App Server
DoD/Global Combat Support Systems-Air Force - Wright-Patterson Air Force
Base, Ohio
Mr. McMiller worked as the Technical Architect for the Global Combat
Support System at Wright-Patterson Air Force Base in Dayton Ohio.
Responsibilities included developing an installation package with detailed
step by step instructions so an untrained third party could follow in order
to stand up a production Business Objects XI R2 environment. The package
was developed from notes while setting up a development system. Additional
requirements included the installation and configuration Websphere 6.0.0.2
on a Windows 2003 server and to configured Business Objects XI R2 to
integrate with the Websphere Portal.
Environment: BusinessObjects 6.5.1, BusinessObjects XI R2, BusinessObjects
XI R2 Import Wizard, IBM Websphere 6.0.0.2, Oracle 9i and Teradata.
DoD/OSD - Ft. Lee, VA
Mr. McMiller worked as the Technical Architect. Responsibilities included
conducting a thorough evaluation of the current Production environment,
performed installation of Business Objects XI R2 SP2 on four Solaris
servers, conducted a sizing exercise to properly tune, provide fail-over
and fault tolerant. Additional requirements included preparing and
delivering a detailed document which included assessment of the current
working environment, general best practices for security setup to include
BOXI R2 security, LDAP and Active Directory and recommended system setting.
Environment: BusinessObjects 6.5.1, BusinessObjects XI R2, BusinessObjects
XI R2 Import Wizard, Solaris, Oracle 10g.
Defense Commissary Agency - Ft. Lee, VA
Mr. McMiller worked as the Technical Architect for the PMO Business
Intelligence Office for DECA (Defense Commissary Agency) at Ft. Lee, VA
military base. Responsibilities included conducting a thorough evaluation
of the current Production environment, performing several installations of
Business Objects XI R2 SP2 on four Blaze servers, conducting sizing
exercises to properly tune, provide fail-over and fault tolerant, and
configuring LDAP and MS Active Directory security plug-in-ins. Additional
responsibilities including performing a migration from BOE 6.5.1 to BOXI
R2, performing report conversions of several hundreds desktop intelligence
documents to web intelligence documents, designing security within the BOXI
R2 environment and configuring the BusinessObjects environment for email
capability.
Environment: BusinessObjects 6.5.1, BusinessObjects XI R2, BusinessObjects
XI R2 Import Wizard, BusinessObjects XI R2 Report Conversion Tool, Oracle
9i, Teradata and MS IIS.
SIAC - MHS -San Diego, CA
Mr. McMiller served as the Project Engagement Manager to manage the
migration of SAIC from their current Business Objects 5.1.7 to Business
Objects XI R2. Responsibilities include management of project team,
creation and implementation of detailed scoping project plan, risk
analysis, issues, project planning, communication plans and various
migration planning activities. Additional activities included scoping and
pricing of Phase II migration. This included detailed costing plan and
incremental migration activities. Worked with Business Objects Educational
resources to formulate a training plan tailored to the client's training
needs and budget.
Environment: BusinessObjects 5.1.7, BusinessObjects XI R2, BusinessObjects
XI R2 Import Wizard, BusinessObjects XI R2 Report Conversion Tool, MySQL.
Defense Logistic Agency - Columbus, OH (DLA)
Project Manager assigned to manage the migration of Defense Logistic Agency
from their current Business Objects 6.5.1 environment to the Business
Objects XI R2 environment. Responsibilities include management of project
team, creation and implementation of detailed scoping project plan, risk
analysis, issues, project planning, communication plans and various
migration planning activities. Additional activities included scoping and
pricing of Phase II migration. This included detailed costing plan and
incremental migration activities. Worked with Business Objects Educational
resources to formulate a training plan tailored to the client's training
needs and budget. Environment: BusinessObjects 5.1.9, BusinessObjects XI
R2, BusinessObjects XI R2 Import Wizard, BusinessObjects XI R2 Report
Conversion Tool, Oracle, Sybase 11, and MS SQL Server 2000.
SAP BusinessObjects, Public Practice
October 2005 - February 2007
PepsiCo -Frisco, TX
Technical Architects assigned to provide expertise in optimizing their
Business Objects Enterprise XI environment including architectural setup
and report design.
Environment: BusinessObjects 5.1.7, BusinessObjects XI R2, BusinessObjects
XI R2 Import Wizard, EPM, Crystal Reports XI, Oracle, Sybase 11, Teradata
and MS SQL Server 2000.
Convergys - Cincinnati, OH
Mr. McMiller was consulted for his knowledge of Business Objects XI R2 3rd
party security integration with PeopleSoft SSO. Mr. McMiller was tasked
with the task of providing Single Sign-On into PeopleSoft from the
Convergys's web portal through Business Objects InfoView. Mr. McMiller also
provided source code and documentation to Convergys IT team.
Environment: BusinessObjects XI R2, PeopleSoft Enterprise, PeopleSoft
Integration Kit, Crystal Reports XIR2.
Lehman Brothers -Jersey City, NJ (Lehman Brothers)
Technical Architect task with performing a BusinessObjects 6.5 and Crystal
Enterprise 10 to BusinessObjects Enterprise XI (R2) migration assessment
engagement.
Responsibilities included conducting an assessment of the Crystal
Enterprise 10 BusinessObjects 6.5 environment, designing a logical
representation of the recommended Business Objects XI R2 geographical
distributed environment, conducting a sizing exercise and the preparing a
Migration assessment recommendation and Summary of Finding documentation.
Environment: BusinessObjects6. 5, Crystal Enterprise 10, BusinessObjects
XI R2, Visio, Oracle, Sybase 11, and MS SQL Server 2000.
McKesson Technology Provider - Alpharetta, GA
Technical Lead assigned to manage the migration of BusinessObjects 5.1.4
to BusinessObjects Enterprise XI (R2) migration consulting engagement
consisting of two total consultants. Responsibilities included reviewing
and implementing BusinessObjects Enterprise XI (R2) security model,
converting over 3000 thousands Desktop Full Client reports using the
BusinessObjects XI(R2) Report Conversion Tool.
Environment: BusinessObjects 5.1.9, BusinessObjects XI R2, BusinessObjects
XI R2 Import Wizard, BusinessObjects XI R2 Report Conversion Tool, Oracle,
Sybase 11, and MS SQL Server 2000.
BCBS of North Carolina - Durham-Chapel Hill, NC
Technical Lead assigned to manage the migration of BlueCross BlueShield of
North Carolina from their current Business Objects 6.5.1 environment to the
Business Objects XI R2 environment. Responsibilities include management of
project team, creation and implementation of detailed scoping project plan,
risk analysis, issues, project planning, communication plans and various
migration planning activities. Additional activities included scoping and
pricing of Phase II migration. This included detailed costing plan and
incremental migration activities. Worked with Business Objects Educational
resources to formulate a training plan tailored to the client's training
needs and budget.
Environment: BusinessObjects 6.5.1, BusinessObjects XI R2, BusinessObjects
XI R2 Import Wizard, Oracle and Crystal Xcelsius.
Shaw Industries - Dalton, GA
Technical Lead for Business Objects team migrating the customer from
MicroStrategy to Business Objects XI R2. Management included the
management of the Business Objects team that was installing Business
Objects XI r2, configuration, migration and tuning of Business Objects XI
R2 environment. Other responsibilities included project status updates,
risk analysis, architectural documentation, project planning, project kick-
off, issues logs and customer relations. Worked with various team leads
within the customer location as well as Business Objects management to
verify that project items were delivered on time and within budget. Worked
with the key decision-makers on project related items.
Environment: Teradata V5, V6, BusinessObjects XI R2, MicroStrategy,
Crystal Reports XI R2
Turner Broadcasting System - Atlanta, GA
Lead Consultant for a migration report development initiative project at
Turner Broadcasting. He developed/migrated over 200 Crystal Reports running
against an Oracle database and PeopleSoft 8.8 Financial application. He
also performed classroom Technical training. This is also an ongoing
migration and is schedule for continue work for BusinessObjects.
Environment: BusinessObjects XI R2, Crystal Report XI R2, PeopleSoft 8.8,
Oracle, and T.O.A.D.
Kaiser Permanente - Silver Springs, MD
Lead Reporting Consultant for critical Report development initiative
project at Kaiser Permanente. He developed several Teradata Stored
Procedures and Crystal Reports using Crystal SQL commands running against a
Teradata database. Reports are being developed to support the recent
deployment (D3) of Kaiser's nationwide business intelligence system, Health
Connect.
Environment Crystal Report 10, ePublisher, Teradata, Teradata SQL Assistant
and MS Project
BearingPoint - Business Intelligence Practice - Atlanta, GA
May 2003 - October 2005
Mr. McMiller served as a Senior Consultant in the Global Technology
Services practice of BearingPoint. He is a Teradata Certified Professional
and has attended recommended Teradata instructed led classes. He is
responsible for and involved in a wide range of consulting assignments
covering business and IS strategies, effectiveness and efficiency studies,
outsourcing studies, development methods and service management. He has
managed and participated on many Business Intelligence Reporting projects
and Decision Support Systems.
Jeremiah's solution expertise includes Business Intelligence and Reporting
solutions with a strong background in Application Integration, Portal
Architecture, User and Configuration Management, Report Design and ETL
Analysis and strong SQL development experience. He has significant
technical lead experience and strong business acumen to compliment his
range of technical abilities. Jeremiah also has significant reporting
application experience to include BI dashboards, drill-down reports,
scorecards, KPI reports and ad-hoc reports with Business Objects/Crystal
Reports and SQL. The following project was performed while serving as a
Senior Consultant/Manager with BearingPoint.
Lockheed-Martin - Marietta, GA
Mr. McMiller worked as the Technical Architect task with performing a
Business Objects 5.1.4 to Business Objects Enterprise XI (R2) migration
consulting engagement consisting of three total consultants. After gaining
a clear understanding of the Business requirements and the current
production environment Mr. McMiller installed, configured and tuned the
Business Objects XI R2 environment and completed the migration from
Business Objects 5.1.4 to Business Objects XI R2. Mr. McMiller also
reviewed and implemented the Business Objects Enterprise XI (R2) security
model. Converted over several hundreds Desktop Full Client reports using
the Business Objects XI(R2) Report Conversion Tool. Mr. McMiller also
created Installation and Configuration Documentation, Technical
Requirements Documentation, and delivered an Architecture Engagement
Summary Documentation to the client. Mr. McMiller conducted knowledge
transfer sessions on management XIR2, crystal report development
strategies, and basic Universe development and deployment techniques.
Environment: Business Objects XI, Oracle 9i, Business Object Data
Integrator XI, MS Project and SQL Navigator
FedEx - Atlanta, GA
Provided technical and architect expertise in Business Objects/Crystal XI
integration with PeopleSoft financial for a global transport and business
services company.
Defined proposed solution architecture and provided implementation strategy
for pilot reporting initiative. Responsibilities also included user
management and security, reporting design, distribution, and testing. He
provided analysis of revenue and claims data. Develop matrix showing 24
months of Revenue and Claims fact data, year over year revenue change
percentage, percentage of claims paid and etc. for two operating companies.
Environment: Business Objects XI, Oracle 9i, PeopleSoft GL/AR, MS Project
and SQL Navigator
Catholic Health East- Philadelphia, PA
Mr. McMiller served as BusinessObjects Development Lead for a major
Healthcare firm. Jeremiah was responsible for analyzing the client current
Business Object system, interviewing users of the current system, make
recommendation and to provide a best practice overview and performing
upgrades to the current system.
Environment: Business Objects 5.1.7, MS SQL Server, ERWIN and Microsoft
Visio
Aetna - Hartford, CT
Project Lead for a top three insurance company to access their current
databases to determine if they meet current and planned reporting needs,
recommend appropriate user friendly and ad hoc query tools for the
Reporting team, determine if database structure is adequate and recommend
appropriate changes for efficiency, speed, and data analysis and develop
and present recommendation document. Jeremiah met regularly with members
across the company enterprise including, DBA's, infrastructure team leads,
project managers, developers, and end-users. He reviewed the top Business
Intelligence suites to included BusinessObjects/Crystal Enterprise,
Hyperion/Brio, Cognos/Reportnet, Microsoft Reporting Services, Micro
Strategy, Actuate and Information Builders. He reviewed several business
intelligence white papers from notable researchers to include Forrester
Researcher and the Butler Group.
Coca-Cola Company - Atlanta, GA
Team Lead for the detailed design and development phase of a customer care-
reporting project for world's leading manufacturer, marketer, and
distributor of nonalcoholic beverage company. Mr. McMiller developed the
detailed design of much of the functionality in the system. He met
regularly with the client and team members to resolve key requirements
issues that he ultimately elaborated in detailed design documentation. He
design and developer the data foundation, data connection, dynamic data
connections, business elements, business views and reports on the online
reporting system. He set guidelines for the design team and often
collaborated with other group member to establish good design principles.
Mr. McMiller worked with the DBA's and ETL experts to ensure timely
completion of project deliverables.
Environment: Crystal Enterprise 10, Crystal Reports 10, Business Views
Manager, Oracle, ASP, CSP, ERWIN and Microsoft Visio
Mirant - Atlanta, GA
Senior Report Developer/SQL Developer for a large energy company.
Mr. McMiller served as the Lead Reporting Analysis. He analyzed, design,
develop and maintain reports using Crystal Report 8.5. Mr. McMiller
gathered business requirements and created design documents. Mr. McMiller
trained end users on developing basic and advance reports.
Environment: Crystal Enterprise 8.5, Crystal Report 8.5, Oracle 9i
Education/Training & Certifications
Awarded a B.S. in Computer Information Systems from DeVry University,
Decatur, GA
Graduated Magna cum Laude
Business Objects Americas
Business Objects Certified Professional - Crystal Reports]
Business Intelligence Solution Accelerator (Delivery) Accreditation
Crystal Xcelsius 4.5
Business Objects Data Quality XI
Migration Specialist designation
NCR
Teradata Certified Professional
Business Intelligence Methodology Accreditation
Customer Names
Kaiser Permanente
WellPoint
DoD.GCSS-AF - Wright-Patterson Air Force Base, Dayton, OH
DoD/OSD - Monterey, CA
DoD/DeCA - Ft. Lee. VA
DoD/DLA - Columbia, OH
Eli Lilly - Indianapolis, IA
McKesson Provider Technologies - Alpharetta, Georgia
Shaw Industries Group, Inc - Dalton, GA
BellSouth/CGI - Atlanta,GA
Kaiser Permanente - Silver Spring, MA
BearingPoint, Inc - Atlanta, GA
Lockheed-Martin - Atlanta, GA
FedEx - Memphis, TN
Catholic Health East - Philadelphia, PA
Aetna Insurance - Hartford, CT
Coca-Cola NA - Atlanta, GA
AMLI Residential
Mirant - Atlanta, GA
Turner Broadcasting Systems - Atlanta, GA
Peachtree Software - Atlanta, GA
Jones Lang LaSalle - Atlanta, GA
DeKalb County Juvenile Courts - Atlanta, GA
Interliant - Atlanta, GA
UPS - Atlanta, GA