We provide IT Staff Augmentation Services!

Pm/analyst Resume

Washington, DC

SUMMARY:

  • I am a unique business and technology professional with seven (7) years of experience as a Consultant and Business Analyst. I possess extensive hands on functional and technical experience in diverse environments, varying from Federal Leasing to Hyperion EPM, OLTP and OLAP software systems design and implementation. Additional skill sets including Financial Reporting following GAAP guidelines and Human Capital Management (HCM) experience. I have been progressively increasing my skills and responsibilities while participating in full lifecycle implementations of financial applications, project management, and supporting systems.
  • A well - liked, self-motivated, adaptable, cross-functional team member who is equally comfortable in working with those in technical roles to those in a business and management roles.

TECHNICAL SKILLS:

MS Office: suite including Excel, Power Point, Word, MS Access & MS Project, Visio, SharePoint, Hyperion System 11.X Planning, Hyperion Financial Management (HFM), Oracle Data Integrator (ODI), Financial Data Quality Management (FDM), Essbase Administrative Service (EAS), Hyperion FR Studio, Web Analysis, Workspace, Shared Services, SmartView, Essbase Add-in, Understanding of Agile development methodologies

Other Technical Skills: MS Visio, SQL, HTML

Relational Databases: SQL Server; Oracle SQL*Plus

Operating Systems: All Windows platforms, HP-UX 11.0, Solaris 2.6-9, AIX 4.3.x

PROFESSIONAL EXPERIENCE

Confidential, Washington DC

PM/Analyst

Responsibilities:

  • Reporting - Creating and producing reports from the USDAs Corporate Property Automated Information System (CPAIS)
  • Automated Reports, Forms and Queries in Microsoft Access that had earlier been manually maintained
  • Created Slide Presentations, Charts and Graphs in Microsoft Power Point for Office of Secretary and Governance Board
  • Managed Presentation and logistics communication at national USDA Real Property Training Summit
  • Work closely with CB Richard Ellis (CBRE) Transaction Managers and Senior Manager and USDA Real Property Managers (RPLOs) - Setting up meetings, working as an intermediary, following up between parties
  • Development and maintenance of Master Broker List, managing $4 million task order including all USDA Leasing Projects being worked by CBRE along with tracking payments made, awarded projects, and finalized lease packages received
  • Created SharePoint location for Maintaining all Leasing Documents submitted to and received from CBRE - Accessible by all USDA RPLOs
  • LASD Website Content development
  • Recording all Meeting Minutes
  • Development of Talking Points for Assistant Secretary of Agriculture to present seeking Congressional approval for the Leasing Accounting and Strategy Division (LASD)
  • Drafting and editing Job Task Analysis Forms and Service Level Agreements (SLAs)
  • Data Analysis in Microsoft Excel

Confidential, Washington, DC

Business Analyst III

Responsibilities:

  • System 11.1.2.1 Implementation of Hyperion Planning application including Hyperion Reports, SmartView, and Essbase
  • Participated in the requirements gathering efforts of the project for expense related planning processes.
  • Drafted requirements documentation for Hyperion Planning applications and used Requisite Pro to store and tag requirements for mapping to test cases in Quality Center.
  • Created and maintained locations on SharePoint for training documents and other documents
  • Developed test cases that were used in user acceptance testing (UAT)
  • Drafted user acceptance test (UAT) plan documentation for Hyperion Planning and FDM applications.
  • Created, designed and formatted technical specification documentation, such as architecture diagrams, process flows, and other processes needed to describe required system changes for development.
  • Performed user acceptance testing (UAT) for various Hyperion Applications.
  • Updated, maintained and ran tests in Quality Center.
  • Drafted and compiled final results summary documentation for UAT testing, including Test Summary, Requirements Traceability Matrix (RTM) created with BOXI Reports, Defect report from ClearQuest, Incident Report from Remedy, and the test Execution Report generated from Quality Center.
  • Assessed business operations and processes to understand procedures, information flows and handoffs, decisions, communications pathways and the like.
  • Managed the defect capture, reporting and resolution process during UAT using IBM Rational ClearQuest.
  • Migrated Hyperion Planning artifacts from TEST to PROD using Life Cycle Management (LCM) and performed validation and shake out in the PROD instance.

Environment: Windows 2003, Hyperion System 11.1.2.1, System 11 ODI, Oracle 10g

Confidential, Fairfax, VA

Business Analyst Level III

Responsibilities:

  • System 11.1.2.1 Implementation of Hyperion Planning application including Hyperion Reports, SmartView, and Essbase
  • Participated in the requirements gathering efforts of the project for expense related planning processes.
  • Drafted requirements documentation for Hyperion Planning applications and used Requisite Pro to store and tag requirements for mapping to test cases in Quality Center.
  • Developed test cases that were used in user acceptance testing (UAT)
  • Drafted user acceptance test (UAT) plan documentation for Hyperion Planning and FDM applications.
  • Created, designed and formatted technical specification documentation, such as architecture diagrams, process flows, and other processes needed to describe required system changes for development.
  • Performed user acceptance testing (UAT) for various Hyperion Applications.
  • Updated, maintained and ran tests in Quality Center.
  • Drafted and compiled final results summary documentation for UAT testing, including Test Summary, Requirements Traceability Matrix (RTM) created with BOXI Reports, Defect report from ClearQuest, Incident Report from Remedy, and the test Execution Report generated from Quality Center.
  • Assessed business operations and processes to understand procedures, information flows and handoffs, decisions, communications pathways and the like.
  • Managed the defect capture, reporting and resolution process during UAT using IBM Rational ClearQuest.
  • Migrated Hyperion Planning artifacts from TEST to PROD using Life Cycle Management (LCM) and performed validation and shake out in the PROD instance.

Environment: Windows 2003, Hyperion System 11.1.2.1, System 11 ODI, Oracle 10g

Hyperion Consultant

Confidential, Reston, VA

Responsibilities:

  • System 11.1.1.3 Implementation of Hyperion Planning application including Hyperion Reports, SmartView, and Essbase
  • Participated in the requirements gathering efforts of the project for expense, and workforce related planning processes.
  • Assisted in designing the application for annual budgeting and monthly forecasting of expenses, workforce, and revenue models.
  • Participated in discussion with the client about integrating Hyperion Planning and Oracle EBS using FDM and ODI.
  • Converted the existing Excel data input sheets in planning web forms for all three cubes. Created Smart lists for ease of data input for the users. Created menus so that users have easy access to other related data forms.
  • Executed conversions and validations for required data sets from the old Hyperion environment to the new Planning application.
  • Created task lists for different groups according to the functional areas so that users can complete their budget and track their progress.
  • Designed and created financial reports for trend reporting and variance analysis; created validation reports for workforce planning; created revenue reports by channels.
  • Installed software, created forms, business rules, allocation scripts, automation scripts, and admin documentation; organized testing and training during the course of implementation.
  • Designed and executed Metadata and Data integrations for Oracle GL, Oracle HR, and Oracle Projects related data into the Hyperion Planning environment via developed staging tables.
  • Also developed interfaces to build dimensions and load data into Planning and Essbase using Oracle Data Integrator (ODI).
  • Assisted with developing various test cases that were used in conference room pilots (CRPs) and user acceptance testing (UAT)
  • Actively participated during CRP and UAT testing cycles
  • Managed the defect capture, reporting and resolution process during CRP and UAT.
  • Migrated Hyperion Planning artifacts from TEST to PROD using Life Cycle Management (LCM) and performed validation and shake out in the PROD instance.
  • Assisted with developing end user training manuals that would be used to train planners both technology and process in the new system

Environment: Windows 2003, Hyperion System 11.1.1.3, System 11 ODI, Oracle Financials 12.1, Oracle 11g

Hire Now