SUMMARY:

• Over 14 years of industry experience. Thorough background in both IT and Finance.
• Extensive implementation, development, and administrative experience with HFM, Hyperion Planning, Hyperion Essbase, and FDM.
• Strong database skills with Oracle and Microsoft SQL Server.
• Excellent understanding of Data Warehousing concepts, ETL methodology, and Information Systems integration.
• Certified Expert: HFM Applications Administrator, and HFM Implementation Consultant.

TECHNICAL SKILLS:

Financial Systems: Oracle EPM (Enterprise Performance Management) Systems HFM (Hyperion Financial Management), Hyperion Planning; Oracle EBS System R12, SAP

Database Systems: Hyperion Essbase, SQL Server 2008, OLAP, Oracle 11g, MS Access

ETL Software: FDM (Financial Data Quality Management), ODI, ERPi, Informatica

Programming Languages: SQL, PL/SQL, T - SQL; Perl, Shell Script, Batch Script, VBScript, JavaScript, ASP.NET, JSP; HTML, DHTML, XML, XBRL; Visual Basic, Excel VBA; Java, C#

Development Software: MS Visual Studio, TFS, SQL Server BI Development Studio, SSIS; OBIEE 11g, Crystal Reports; Toad, SQL Developer; Weblogic

Operating Systems: Windows Server 2008 R2, UNIX

Project Management: MS Project, MS Visio, SharePoint

PROFESSIONAL EXPERIENCE:

Confidential,Houston,TX

Lead Systems Specialist

• Oracle EPM (Enterprise Performance Management) systems development, implementation, and administration; version 11.1.2.1
• Manages Hyperion project development, system patching and upgrade.
• Mentors Hyperion developers on the team.
• Administrator for HFM, Hyperion Planning, Hyperion Essbase applications.
• Builds and maintains new Hyperion applications.
• Manages HFM applications, application security, metadata, rules, member lists, data forms, journals. Develops HFM rules according to business requirements.
• Develops and maintains ODI, ERPi, FDM applications.
• Provide day to day functional and technical support to HFM, Hyperion Planning, Essbase users.
• Maintains metadata for all Hyperion applications in EPMA.
• Develops Hyperion Planning application data forms, business rules, and manages security.
• Develops calc script, and load rules for Hyperion Planning and Essbase applications.
• Applies new patches for all Oracle EPM system components.
• Served as infrastructure architect during the Oracle EPM system 11 upgrade.
• Installed and configured EPM system 11 including HFM, Hyperion Planning, Essbase, FDM, ERPi.
• Installed ODI (Oracle Data Integrator), and configured it for ERPi data load via FDM.
• Created ODI repositories, agents, physical and logical schema in Topology manager.
• Performed application upgrade for HFM, Hyperion Planning, and Essbase applications.
• Developed FDM custom scripts to automate data load from Oracle EBS GL via ODI/ERPi with drillback feature for Hyperion Planning application.
• Customized Hyperion Planning JSP pages for the data forms to include additional dropdown boxes for user selection based on user privilege.
• Automated DR (disaster recovery) environment application refresh procedures for HFM, Hyperion Planning, and Essbase applications.
• Automated Essbase application data load procedures with batch and maxl scripts.
• Converted HFM Rules and Hyperion Planning business rules to Calc Manager format.
• Developed OBI dashboard for Essbase applications using Essbase Analytics.
• Development work in Data Warehousing and ETL, utilizing Informatica PowerCenter 9.x

Confidential

HFM and FDM Consultant

• Implemented system upgrade to Oracle Enterprise Performance Management system.
• Designed and implemented new HFM application to meet weekly close requirement.
• Performed functional testing, performance testing, and user acceptance testing.
• Automated metadata update and data load processes via Maestro job scheduler, sourcing from SAP GL.
• Provided production support and user training.
• Implemented system upgrade to Oracle Enterprise Performance Management system.
• Performed functional testing, performance testing, and user acceptance testing.
• Automated data reconciliation variance reporting process. Performed data validation for key financial data.
• Created training materials on HFM and FDM.
• Designed and implemented data reconciliation variance reporting process, comparing source data from Oracle EBS GL to consolidated data from HFM, utilizing Hyperion FDM.
• Automated data reconciliation variance reporting process for client.
• Provided system analysis document for current HFM and FDM systems, and training to FDM admin users.
• Performed system migration into production environment for both HFM and FDM systems.
• Automated data load processes via FDM custom scripts, sourcing from SAP GL.
• Advised on HFM and FDM application design, HFM metadata setup.
• Provided training sessions to HFM admin users.
• Served as HFM and FDM global application development lead and applications administrator, for the world's largest brand-name apparel marketers with sales in more than 110 countries.
• Designed and implemented FDM integrations to HFM applications.
• Designed and maintained HFM metadata, and member list.
• Maintained and enhanced complex HFM business rules according to client requirements.
• Automated data load processes via FDM custom scripts, sourcing from SAP GL.
• Developed data forms to collect cash flow and supplemental data.
• Orchestrated financial statement consolidation reporting for Americas, EMEA, and APAC regions.
• Designed and maintained HFM reports, SmartView reports, and Hyperion BI+ reports for end users.
• Created locations, import formats, mapping tables, and validation reports in FDM.
• Created training materials on HFM and FDM, provided training sessions to global users.
• Performed data validation for new HFM applications during system upgrade migration.
• HFM application developer. Assisted in designing and implementing a sophisticated HFM application, for an industry leader in data center networking solutions and services.
• Involved in the development of system infrastructure.
• Built inbound interfaces to Oracle EBS ERP systems; Developed sophisticated HFM business rules.
• Served as application development lead for HFM system upgrade projects.
• Developed data forms to collect statistical data; developed complex HFM business rules.
• Developed HFM reports, and SmartView reports for financial reporting.
• Automated HFM data load and consolidation process, utilizing Taskflow function, sourcing from SAP GL.
• Performed data validation for new HFM applications.
• Provided training sessions to both end users and admin users.
• Developed HFM reports, and SmartView reports for financial reporting.

Confidential,TX

Sr. Financial Systems Analyst

• Hyperion Financial Management Applications Administrator.
• Gathered system requirements from the Financial Accounting and Planning teams, and developed HFM business rules according to business requirements.
• Built and maintained new HFM applications; troubleshoot HFM applications related issues.
• Managed HFM applications, application security, metadata, rules, member lists, data forms, journals.
• Utilized Taskflow to automate month end close data integration process, including extracting data from General Ledger system, loading data into HFM, and consolidating data.
• Designed and maintained reports, row and column templates in Hyperion Reports.
• Designed and maintained SmartView templates for end users.
• Automated the ETL process from HFM to Essbase, including extracting selected data from HFM using Extended Analytics, transforming data using MS Access, and loading data into Essbase using ESSCMD / Essbase scripts. Automated and streamlined financial reporting tasks.
• Trained end users and created HFM training website. Documented HFM applications maintenance procedures for Business Continuity Planning (BCP) process.
• Led multiple HFM application implementation and upgrade projects.
• Implemented the HFM conversion project - from Oracle database to SQL Server database.

Confidential, Austin,TX

Financial Consultant

• Administrator of Outlooksoft Everest budget / forecast system. Maintained multiple Appsets / Applications in Everest. Maintained Outlooksoft CPM Web portal. Developed custom analysis reports and budget input templates. Automated data loading process. Developed and maintained business logic and assumptions.
• Performed P&L analysis, financial forecast, close, and reporting activities, utilizing Outlooksoft Everest, HFM, Hyperion Planning System, and Oracle Financials System.
• Provided thorough scenario analysis for financially justifiable decision-making. Collected data from various sources, conducted statistical analysis and product trend forecast.
• Developed web reporting application and conducted client training, using C#.NET, SQL Server 2005.
• Supported ad-hoc reporting needs that served as vital input in determining company strategic policy. Reported worldwide P&L data, utilizing data warehouse / OLAP technology.
• Worked with business partners to develop / enhance custom analytical applications for LOB P&L analysis, utilizing SQL Server 2005 analysis services, integrated services, C#.NET.
• Developed sound business process improvement for advanced financial and logistics applications to reduce costs and provide timely information.
• Conducted requirement analysis, provided architectural design for SQL Server and ORACLE databases. Developed financial data models, created multidimensional data cubes in SQL Server 2005.
• Project lead for Confidential financial security system, which manages user access to highly confidential data, compliant with GAAP rules, utilizing C#.NET and SQL server 2005.
• Assisted in business analysis, design, development and implementation of corporate performance management systems and business intelligence solutions.
• Translated business intelligence into business action through online behavioral analysis, performed information analysis and decision support. Business Analyst for Global Manufacturing and Fulfillment Systems
• Project lead for Confidential Volume Software Licensing & Reporting System. Led the plan, design, development, documentation, and launch process.
• Enforced conformity to CMM standards.
• Integrated business needs in determining methods and techniques for solutions.
• Performed cost benefit analysis for projects to ascertain feasibility and return on investment.
• Developed test scripts for all test scenarios. Performed thorough functional, regression, performance testing.
• Designed, implemented, and utilized a web-based defect tracking and analysis tool to provide comprehensive up-to-date analysis reports, resulting in 60% time savings.
• Acted as Global lead to introduce global order fulfillment system to European region and Asian Pacific region, reducing manual processing of orders by 50%.
• Maintained and enhanced Confidential Software & Peripherals Product Catalog Management System, Fulfillment System & Invoicing System, Volume Software Licensing & Reporting System. All systems were critical in supporting order management for Confidential software & peripherals orders at Confidential .com, and processed $50M in sales on a daily basis. Programmer Analyst for Global Manufacturing and Fulfillment Systems
• Developed financial reports for Finance department on Confidential Data Warehouse and Oracle databases.
• Provided reporting services to Sales and Service department. Reports were utilized to satisfy contractual obligations to Confidential 's corporate and public customers.
• Initialized and implemented automated financial reporting system, which gathered / stored sales data, and generated / distributed reports automatically based on user requests.
• Developed web based business process tool that streamlined operations, resulting in $1M reduction in operating expense.

Confidential

Financial Analyst

• Documented business requirements with detailed system specifications for personal financial planning and investment application. Prepared logic flow charts and detailed test plans.
• Collected data from various sources, conducted statistical analysis, and created performance reviews for individual and institutional investors.
• Constructed quantitative and qualitative valuation, including financial modeling, discounted cash flow, WACC, IRR, and price multiples analyses.
• Provided support to technical analysts with administrative details. Assisted in investment product research.
• Successfully managed personal portfolios by employing value investing principles.

Confidential

Automotive Engineer

• Conducted user survey, documented user requirements.
• Led a group of 7 people to complete the design of a car body by applying generic automobile principle & aerodynamic theory, utilizing AutoCAD software.