Jerry Ortiz Email & Phone Number

Santa Rosa Beach, Fl, Us

San Antonio, Texas, Us

Currently adopting emerging digital technologies which affect the application of scientific methodologies and/or quantitative analytical approaches to problem resolutions while leveraging business/analytical knowledge to participate in discussions with cross-functional teams to understand and collaborate on business operational objectives and influence strategic solutions.Applying scientific/quantitative analytical approaches to draw conclusions and make 'insight to action' recommendations and incorporating visualization techniques to delivers analysis/findings in a manner that conveys understanding, influences Executive management, drives business decisions, and influences business strategy.

San Antonio, Texas, Us

San Antonio, Texas, Us

Successfully completed BI & Data Analytic solutions for Executive and Mid-level Management thru deployment of Operational metrics, Enterprise KPIs solutions, and Application Scorecards for Enterprise Data Infrastructure & Analytics, Enterprise Content Mgmt divisions. These End-to-End solutions include the Data acquisition (In-House & 3rd Packages transaction systems); the Data transformation (IBM Datastage), the Data modeling & Storage (ERWin & Netezza), along with the Data visualization phases (SAP 4.2 through SAP IDT, SAP Dashboard Manager, Webi, Data Explorer, BI Launchpad & SAP Lumira) to provide Application team owners with new "In-sights" and App scorecards about the health of their applications (USAA IT GetHealthy Initiative program).

Subject Matter Expert (SME) on SAP BOBJ and BI Data Analytics using SAP BI XI - Release 3, BOBJ client tools, such as Xcelsius 2008 SP3. Recently, develop critical and high profile cutting edge Executive Dashboard solutions on the following SAP BI projects:APL Logistics

*After configuring SAP BI Enterprise Mobile, SAP BI Enterprise Mobile app is currently being able to access entire content of Business Objects artifacts, such as BO reports, BO dashboards, and Explorer InfoSpaces. In addition, OpenDoc 4.1 does allow for Pass-through Variables, Content Linking and BICS/QAAWS full support.*Completed a SAP BI 4.1 SP4 In-place upgrade to resolve many issues with BI 4.0 - missing critical functionality and instability. With new upgrade deployed, new critical BO Administration built-in functions, key enhancements to SAP BI Development tools, new BI mobile development tools (Design Studio for BI), new key SAP BO servers optimization and sizing tools, new direct data connectivity for IOS & Android support, plus all the new features for Big Data, such as SAP Lumira, SAP HANA and SAP ERP native connectivity - BICS/BEX support.Original Scope: Deployed of a brand new installation of SAP BI 4.0 SP6 Patch 11 by architecting and installing of SAP BI Enterprise Server and all correspondent SAP BI 4.0 SP6.11 Client tools to create a new BOBJ reporting framework for Oil & Gas division of Lewis Energy Group. This new framework includes the development of new SAP BI LaunchPad Portal, including multiple BI Workspaces, Explorer InfoSpaces, and highly interactive Dashboards and Reports. The new SAP BI reporting infrastructure was extended to include functional areas in Safety, Accounting, Payroll and Executive management through a new implementation of an Enterprise DW including a new architectural design and rollout of an Enterprise Functional organization hierarchy, Enterprise scorecard and KPIs for Senior Mgmt. In addition, to support this new reporting architectural design, new ETL SSIS packages were developed to support integration of multiple SQL back-ends to consolidate and incorporate a new Data Management strategy for the creation of the Enterprise Data warehouse.

* USAA ITCO – (Oct 12 to Present) Completed a very succesful implementation of IT Asset Mgmt Reporting project by assisting USAA ITCO with the full implemetation of brand new BI 4.0 architecture framework and a Data Mart with a Star Schema for new reporting capabilities of SAP BI 4.0 FP3 while addressing succesful implementatoin of IT Enterprise BI strategy, new operational datawarehouse with data governance and security compliance. Developed of BOBJ 4.0 Universe, BI Space, Security framework, Dashboards, and WebI reports for USAA IT Hardware Inventory Management Division.

Morristown, Nj, Us

• Ports America - PAS – Assisting Finance & Operations with a successful completion of a BI road map addressing their Enterprise BI strategic needs while delivering advance reporting and Executive dashboard deliverables with Xcelsius 2008; Migrated existing old SAP XI 3.1 BO servers to new data center and upgraded to newly installed Development and Production environment with latest version of SAP BI 4.0 FP3. Deployed BO Enterprise Development & Clustered Production environment with SAVVIS and along with Advance Data Analytics solution for Executive Mgmt of the Stevedoring Division.

Tempe, Az, Us

SRP BI Team lead for new SAP ERP implementation under the LASeR program, which would include the migration of legacy systems from Finance, Supply Chain and Human Resources. Developing Enterprise BI strategy for all data reporting, scorecards and data analytical solutions for these functional areas in regards to standard reporting, self-service, budgeting, forecasting & planning, to include strategic and prediction analysis to be used as along with Enterprise Corporate Data warehouse.

Scottsdale, Arizona, Us

Developing APL CLS financial and operational repository DB, data analytics for financials, productivity, quality and strategic Executive Mgmt dashboards and reporting tools to enable the analysis of warehousing, transportation and logistics operations. Deploying dashboard with data connectivity to MS Access to SQL 2003 server. Developing architectural design & BOBJ architecture for SAP BOBJ Xcelsius 2008 dashboards for Executive Management and Operational group and development Share Point 2007 for collaboration site of projects and publication of dashboards and reports.

Phoenix, Az, Us

Subject Matter Expert (SME) on BI and Data Analytics using BO XI - Release 3, BO client tools & Xcelsius 2008 SP3 and. Developed critical and high profile cutting edge Executive Dashboard solutions on the following BI projects:Completed Apollo Groups aka University of Phoenix - Marketing Executive & Academics OW Strategic dashboards using Xcelsius 2008 SP3. Deployed dashboard with data connectivity to SSAS cubes and BO Universe via Live-Office & QAAWS. Developing standards and architectural design for web services for production environment and publishing dashboard objects via SharePoint 2007 via web component on the intranet.

San Antonio, Texas, Us

•City of San Antonio - PBS&J Consultant to the Capital Improvement Services Management (CISM) division responsible for the 2007 – 2012 Bond Program. Developed CISM Projects Dashboard to represent Key Performance Indicators (PKIs) for 151 Projects approved and funded by the San Antonio 2007 Bond Program. The ultimate solution included two versions of the CIMS dashboard for Public and Internal audiences. In the Public version, any SA resident could go to SA web site, http://www.sanantonio.gov/2007Bond/, and access the dashboard under “2007 Bond Status Program” to identify any project managed and reported by this tool. The Internal version included additional functionality for Contractors to gain access to the Primavera schedule as well. These dashboards included multi-dimensional views of projects by Phases, Propositions and Scheduling enabled by a newly created hierarchy for this tool.

Indianapolis, Indiana, Us

• Developed WellPoint Executive Dashboard via Business Object Xcelsius 2008. This Data Analytics business tools was created to enhance the operational reporting, What-If modeling and forecasting capacity of staffing, Key Primary Indicators (KIPs) and other productivity metrics, such as work force capacity, project life cycle and project management performance and scorecards reporting. Multiple data sources were consolidated under a data warehousing strategy to support a future enhancement of a Business Object universe being deployed by to support this new dashboard.

multiple critical and cutting edge efforts for Data Analytics and Business Intelligence efforts and projects:Research & Analysis SME for Business Intelligence development and Data Analytics projects with plenty of working experience with multiple BI vendors, such as Cognos 8.1 and Business Objects XI. Assisted Reporting & Analysis Division to evaluate, test and implement a data warehouse strategy based on the functionality, flexibility and multi-dimensionality of SAP BI BOBJ tools.Developed $100 Billion Bank Capacity model to provide Executive management with valuable information to formulate productivity goals, capacity planning strategies, Outsourcing, and Escalation plans to appropriate address future staffing requirements for Bank capacity through 2012. This model has been extensively used by AVP of Infrastructure Support to achieve the $100 Billion bank strategy set up by the President of the FSB.Developed several business tools to enhance operational Capacity models, such as FSB Workforce & Staffing, Productivity Metrics, Capacity Workload and Employees Scorecards. All these models are a consolidation from multiple data sources including Enterprise Scheduling, and People Services (HR Division).SME for Cognos 8.1 project conversion for HR modules from 7.3 version. Assisted to develop multi-dimensional cubes, Scenario, HR KPIs & metrics to support strategic programs. These cubes were reported using via ReportNet and Cognos Dashboard Query tool. This tool was critical to SVPs to support operational growth by analyzing Turnover, Churn In-Out & Outsourcing programs and strategies.

Contracting employment as SME in the Medical, Marketing and Manufacturing industries for multiple projects in Data Analytics and Warehousing, Business Modeling, Forecasting and Planning. Duties were related to the following areas: Finance, Sales, Marketing and Information Systems. Finance duties were preparation, financial statements consolidation and analysis, P&Ls, Budget variance, cash flow, cost analysis reports, financial and forecasting modeling development.

Responsibilities were related to Finance and Information systems in order to meet business objectives, such as achieve financial forecasts, developed web-based portal financial system to capture, distribute and report all financial information for the Southwest regional offices.

Cloud Computing Architect, Cloud Computing

Phd Information Technology - Ongoing, Data Science And Analytics

Masters, Computer Information Systems

Bachelors, Finance, Accounting

Aa, Mis & Esl

Microsoft Certification, Ms Sql 2005 Business Intelligence Developer