| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate
Executive SummaryEPM, Oracle Hyperion FDMEE, ODI, Cloud, OBIEE and Project Management are areas of expertise:EPM Intermountain Healthcare, State of California, Metrolink, Meredith, Pacific Coast Producers, US Steel, Zions Bank, Cabot, Verizon and PSCUFDMEE ERPi at Intermountain Healthcare and FDMEE at MetrolinkODI ETL for DFC, Pentagon, PSCU, Intermountain Healthcare, Exelon, ILS, Bellevue University, State of California, Zions Bank, US Steel, Cabot, Meredith and Pacific Coast Producers
Cloud OAC and OICS at Sofbang; AWS at State of California and Pentagon; OCI Data Integration for DFCOBIEE PSCU, Pentagon, Intermountain Healthcare, Zions, Exelon and US SteelProject Management Bertram McKee and Associates, Managed Information Systems, Palladium Group, 1Answer Solution, PWC, Accenture, Arete EPM, Sofbang and PSCUSolving architectural, data and integration issues related to reporting and forecasting. Ability to work with Finance, C-Suite and IT departments to implement Oracle Hyperion applications and Integration applications from beginning-to-end in multiple industries.Profile Twenty plus years of information technology experience in technical areas with an emphasis on project management, data warehousing, business intelligence, training, software asset management, data integration management, ODI Architecture and application development methodologies. Core competencies include Oracle Hyperion Financial Data Quality Management Enterprise Edition, Oracle Business Intelligence Enterprise Edition, Oracle Data Integrator, EPMA, Essbase and Planning, Project Management, Technical Sales and Oracle Hyperion System 9 & 11 Administration. Personally, billed over $750 thousand at Oracle/Hyperion and awarded Quarterly Award for Outstanding Performance & Lasting Contributions Q2 FY07. Seven years of sales and marketing experience with an emphasis on customer relations management, market research, territory management and supply chain management. Industry experience includes Public, Energy, Automotive, Insurance, Financial Services, Consumer Products, Non-Profit, Market Research, Telecommunication, Utilities, Manufacturing, Information Technology and Healthcare.
ExperienceCreoal Consulting, LLC/SMX January 2023 to Present
Principal Consultant ODI and Data Integration Development and trouble shooting. Support Pentagon Oracle EPM and other Oracle modules in an AWS O&M environment. Duties include troubleshooting, and design, development, and implementation of enhancements. Oracle Data Integrator (ODI) expert for the project and wrote code to correct issues in Production. Developed OCI Data Integration for Development and Production environments. Principal consultant uses a broad understanding of solutions, industry best practices, multiple business processes or technology designs within a product/technology family. Operates independently to provide quality work products to an engagement. Performs varied and complex duties and tasks that need independent judgment, to implement products and technology to meet customer needs. Applies methodology, company procedures, and leading practices.
Demonstrates expertise to deliver functional and technical solutions on complex customer engagements. May lead the solution design and implementation aspects of engagement(s) ensuring high quality, integrated software solutions within constraints of time and budget. May act as the team lead on projects, providing coaching, guidance, and feedback to develop skills of team members. Effectively consults with management of customer organizations. Participates in business development activities. Develops and leads detailed solutions for complex projects.Mphasis April 2022 to October 2022
Data Engineer - Helped developers with SQL issues during Scrums. Trained TRHC Personnel on SQL Server, Schemas, Joins, Data Types, Nested Statements and Keys. Attended knowledge transfer sessions on TruChart and Pace Logic. Assist Tier 3 with the sprint during Scrum Meetings. Passed all required onboarding and HIPAA training.
VDART April 2020 to March 2022
ODI Developer - Handled all Oracle Data Integrators Architecture and Development of all mappings for 18 counties and hundreds of scenarios. This includes installation of J2EE and Standalone Agents in Development and Production environments. This is for the State of California on AWS. Developed and Architect the 18 county Extraction project for the State of California Health and Human Services.
Setup ODI 12c for Standalone and J2EE Agents for Development and Production.
Provided ODI Mapping examples for ERWIN team for advanced Groovy scripts. Helped to get ODI implemented in Development and Production for the AWS Extraction project working with infrastructure team to configure both environments. Trouble shooting ODI Extraction Mappings for SQL to SQL, Oracle Control Append and Oracle DBLINK knowledge modules and executions.GWIZ, LLC April 2019 to April 2022Project Manager/ ODI Consultant Helped upper management with Oracle Data Integrator and Oracle Business Intelligence Enterprise Edition with managing subcontractors and issues. Helped with installation of Oracle Data Integrator. Lead and help manage OB1 project for PSCU a financial company. Managed consulting developers for several financial reports in OBIEE 12c. Handled Project Management including billing and managing subcontractors for the OB1 project. Helped to get ODI implemented in Development and managed contracts with PSCU.Sofbang, LLC October 2018 to April 2019ODI Architect - Helped Exelon with improving all mappings, packages and scenarios. Helped with the upgrade of ODI and managed onshore/offshore teams. Performed a code review analysis for Exelon (Chicago, IL) on ODI 12c load plans and managed onshore/offshore team of ODI developers. Provided process improvement recommendations based on the code review analysis for Exelon. Presented findings and recommendation to Exelon management and developers. Assisted with the upgrade and enhancement of the infrastructure for ODI 12c for the Exelon project. Evaluated OAC for Sofbang clients which included data integration with OICS. .EdgeRock Technologies, LLC April, 2018 to July, 2018ODI Developer Helped ILS with converting all stored procedures to ODI. Simplified and optimized the current process from one week to 45 minutes. Converted stored procedure for processing government data in ODI 12c for ILS a Boeing company (Memphis, TN). Optimized and simplified the current process in ODI for migration and parallel processing in the future. Provided living documents for the client for manual and ODI scheduled process.ODI Trainer Trained staff remotely on how ODI works as an ETL tool. Trained Bellevue University staff on ODI 12c on a remote contract (Remote McKinney, TX). Provided information on software to convert Data Stage to ODI interfaces.Arete EPM November 2015 to February 2018ODI Technical Lead and Anaplan Data Architect Helped the State of California with ODI development. Managed the offshore team in the Philippines. Helped Verizon with the implementation of data movement into Anaplan. Data Architect for a large Anaplan Verizon Project (Newark, NJ). Performed SQL aggregation of data and metadata for Anaplan. Provided Data Integration consultation to Verizon for Anaplan Connect and helped documented the Data Integration process for the Technical Design Document.
Assisted with the upgrade and testing of Oracle Hyperion11.1.2.3 to 11.1.2.4. Assisted with the evaluation of ODI 12c from 11g. Oracle Data Integrator Lead for the State of California project. Built and documented integration for Oracle Hyperion classic block storage to Oracle Hyperion aggregate storage with Oracle Hyperion 11.1.2.4 and ODI (11g & 12c).
Lead the Hyperion Technical Architecture Team for State of California (Sacramento, CA). Helping to solve issues with Oracle Data Integrator, WebLogic, PeopleSoft 9.2, Oracle Hyperion 11 and Oracle Business Intelligence Enterprise Edition. Managed offshore team in Philippines.
PWC September 2012 to September 2015Senior Associate Healthcare Consultant Helped several clients with ODI and Hyperion. Moved data from ERP systems to Hyperion using ODI. Managed offshore team for ODI and Hyperion.
Assisted with the upgrade and testing from 11.1.1 to 11.1.2 for Intermountain in Salt Lake City, Utah. Provided ETL and technical programming using ODI for Intermountain Healthcare in Utah. Built ODI interfaces in Oracle OnDemand environments and unit tested interfaces between PeopleSoft Financial System, Intermountain Oracle Enterprise Business Suite, Intermountain Kronos Analytics, Intermountain Hyperion Essbase 11.1.1, Intermountain Enterprise Data Warehouse and Hyperion 11.1.2 environments.
Managed offshore and onshore resources for ERP project and directly responsible for $300K in additional sales. Data Integrator Lead for Metrolink in Toronto, Canada. Built and documented integration from Oracle EBS 12 with Oracle Hyperion Financial Data Quality Management Enterprise Edition (FDMEE) 11.1.2.3.500 and ODI to Oracle Hyperion Planning. Lead implementation of FDMEE imported data to HFM, Planning and Essbase 11.1.2.3. Assisted in getting ODI access for PWC consultants and lead the effort to get PWC in a large regional bank for an OBIEE implementation.Accenture February 2010 to August 2012Hyperion Implementation Consultant Developed ODI interfaces for several clients, educated clients on Hyperion and ODI. Managed onshore/offshore teams.
Lead process team and development team with project documentation at a large metal company. Hyperion Solutions Architect for ODI, Hyperion Smart View, Hyperion Web Analysis and Hyperion Financial Reports for a large metal company (Pittsburgh, PA). Developed bottoms up project plan for Hyperion project at a large metal company and a large pharmaceutical company. Functional documentation of OBIEE Assembly Testing of reports. Aided with the conversion of data for a large insurance company (Bloomington, MN) using SQL. Lead Data Architect for a large energy company (Toronto, Canada) and a large pharmaceutical company (Newark, NJ).
Managed and interviewed Offshore and Onshore personnel using ODI for an Oracle - Hyperion Project.COMSYS July, 2009 to September, 2009
ODI Developer Converted stored procedures from Oracle database to ODI. Provided feedback on Verizon s Oracle Architecture. Assisted Verizon VSO team with ODI issues with Blob s and GLOBAL Package Variables. Worked with Verizon on calling and converting stored procedures. Provided ODI documentation for Verizon.Oracle/Hyperion May, 2006 to April, 2009Senior Principal Consultant Developed Hyperion Dashboards and ODI interfaces for several clients.
Integrated Oracle Hyperion EPM 11.1.1 with JD Edwards on DB2/AS400 for Pacific Coast Producers with ODI. Provided Hyperion technical information including ODI for proposals for several clients. Implemented Hyperion System 9 with Interactive Reporting for TD Bank, Liberty Mutual, MetLife, Sony, Lenovo, SAIC and Agilent. Utilized Dashboard Studio for tuning and design reports at SAIC and BPA. Installed Hyperion Performance Suite 8 for Johnson and Johnson. Provided technical and functional consultation on Hyperion Data Integration Management for Lockheed Martin and AOL. Developed and documented Oracle Data Integrator for Cabot and Meredith using Oracle database, Planning and Essbase 9.3.1 adapters. Installed and configured Oracle Data Integrator for USDA and Meredith using Oracle 10g RAC database repository. Utilized Hyperion Interactive Reporting with Oracle Business Intelligence Enterprise Edition Server at MetLife and TD Bank. Migrated Brio 6.6 BQY documents from OnDemand Server Repository and Broadcast Server Repository to Oracles Hyperion System 9.3.1 Repository for Motorola.
Developed and documented Drill Down capabilities from Financial Reports related content to Interactive Reporting for MetLife and TD Bank.1Answer Solutions, Inc. September, 2005 to April, 2006Project Manager, Trainer and Senior Technical Consultant Developed Hyperion Dashboards for several clients Implemented Hyperion System 9 with Interactive Reporting and developed project plan for Toyota. Optimized Hyperion Performance Suite for CIBC, PHH and Enbridge. Provided technical and functional consultation on query optimization, stored procedures, RFP s, views and JavaScript for several clients. Customized training for Enbridge and PHH on PL/SQL, SQL, Dashboards and data marts. Developed, documented and presented management reports for Enbridge Managers. Gathered requirements, provided defect management and met all milestones for Enbridge.Palladium Group, Inc. September, 2004 to August, 2005Project Manager and Senior Technical Consultant Developed Hyperion Dashboards and PM for several clients. Collaborated with Toyota on Hyperion Performance Suite transition to support for the Lexus Survey Redesign Project. Enhanced and managed the publishing of reports to production for the Lexus Survey Redesign Project. Developed at Texas Health Resources Executive Dashboards and provided MS SQL Server hints.
Wrote stored procedures and designed a Dashboard for the Daily Productivity Report at Texas Health Resources. Converted twenty plus Hyperion Intelligence reports to a new Larson database at Midway Home Entertainment.KeyPulse.com, Inc. March, 2004 to September, 2004Software Engineer and Consultant Developed Hyperion Dashboards for several clients. Implementing Hyperion Intelligence 8 corporate wide financial reporting system with MS SQL Server 2000 back end at Popular Financial. Developed several census reports in Hyperion Intelligence 6.6 for Cedars-Sinai Hospital. Trained Cedars-Sinai personnel on Hyperion Explorer, Hyperion JavaScript, EIS and Hyperion Performance Suite 8. Enhanced departmental reports for Oracle 9i data warehouse.Managed Information Systems, Inc. April, 2000 to February, 2004Project Manager and Technical Consultant Developed Hyperion Dashboards and PM for several clients
Project Manager for multiple projects that deal with data warehousing and report writing. Responsible for billing over $1 million on multiple projects. Provided technical sales consultation for current and potential clients on business intelligence. Developed financial, human resources, supply chain and manufacturing reports in Brio for several clients. Presented overall solutions for managing data to several clients as a project manager and a consultant. Supported Hyperion Intelligence projects for Accenture for over three years. Developed the icon and ASP intranet for a large independent school district. Managed the security for an Oracle 8i database and Hyperion Intelligence intranet project.Texas Instruments/Raytheon February, 1996 to April, 2000Software Asset Management and Technical Support Handled licenses and PM software for several vendors. Responsible for over $4 million of software and hardware maintenance contracts on UNIX and Windows NT platforms. Managed the distribution of scheduling and resource tracking software for projects worldwide. Successfully converted Distributed Project Management from MS-DOS to Windows 32-bit system. Handled network, project and server security of production systems. Implemented PMI project principles and related processes in an entrepreneurial, resource constrained environment. Assisted in the development of web-based CRM tool and metrics reporting tool. Won for the best presentation at the MicroFrame Users Group convention in 1999.
Technical SkillsOperating Systems: Windows 10, 2012 & 2016; UNIX and Linux
Oracle Products: OBIEE 12c, 11.1.2, Oracle Hyperion EPM 11.1.2.4, Hyperion Interactive Reporting, Hyperion System 9 Foundation, Oracle Data Integrator 10,11g & 12c, Hyperion Data Integration Management, Hyperion Planning and Hyperion EssbaseDatabases: MS SQL Server, DB2, Essbase and OracleProgramming Languages: PL/SQL, T-SQL, JavaScript, HTML, XML, SQL, JCL and COBOLStatistical Packages: SPSS and SASManagement Software: Wrike, JIRA, MS Project, MicroFrame, Rational Clear Case, Rational Clear Quest and Radia Software ManagementOther Software: Anaplan and Microsoft Office ProfessionalEducation, Clearance and CertificatesAnaplan Intermediate Model Building Certificate 2017Official Anaplanner Certificate 2017Oracle Hyperion BI+ 9.3 Administration Certification 2010Brio Certification 2004Secret 2024B.S. of Business Administration 1984Minor in MarketingOklahoma State University
Stillwater, Oklahoma
TrainingAnaplan Intermediate Model BuildingAnaplan Introduction to Model BuildingAgile and AnaplanAnaplan ConnectOracle BI 11g R1: Create Analyses and DashboardsHyperion Essbase Analytics 9.3 Boot CampHyperion Planning 11.1.2Hyperion Essbase 7.0 Boot Camp IHyperion System 9.3.1 AdministrationHyperion Financial Reporting 9.3 for Financial ManagementHyperion System 9 BI+ Web Analysis for Business UsersHyperion Performance Suite 8Hyperion System 9Hyperion Data Integration Management/ Informatica PowerCenterOracle Data IntegratorProject Management InstituteHyperion Top Gun 2007EPM Boot Camp 2012
AssociationsProject Management Institute MemberPresident and Co-Founder, North Dallas Diversified Investment Club, LLCMember Oklahoma State University Alumni AssociationAwards and RecognitionAddo Agnitio Award Honorable Mention for AccentureQuarterly Award for Outstanding Performance & Lasting Contributions for OraclePWC Select Senior Associate
|
