We provide IT Staff Augmentation Services!

Business Systems Analyst Resume

5.00/5 (Submit Your Rating)

Washington, DC

Qualifications Summary

Solutions-oriented senior-level Business Analyst, Technical Lead, Deployment Lead with expertise leading the design, development, of financial applications and supporting systems. I managed a broad range of next-generation technology solutions from industry leaders.

  • Advanced level of technical proficiency coupled with highly refined business analysis skills, demonstrated by repeated success in the analysis, design and management of innovative IT solutions that directly promote internal and client business growth.
  • Strategic planner with skill leading IT operations, including Hyperion applications design, enterprise system initiatives, systems analysis and migrations, and implementation efforts.
  • Demonstrated ability producing detailed Business applications and IT policies, procedures, and performing change/configuration management, process engineering, and documentation coordination.
  • Dynamic communications skills; successful at developing and maintaining lasting relationships with key clients, while fully communicating technical solutions to users and executives at all levels of technical proficiency.

Hyperion Administration HFM / Project Management / Network Infrastructure Design
Network Security / System Implementations

Technical Proficiencies

Application Development /Support:

Hyperion 11.1.2.1, 11.1.1.3 Financial reports, HFM, Security, Data Loads, Business Rules, Hyperion Systems management 11.1.1.2, 9.3.1, HFM 4.1,BI+ Workspace, Web Analysis, Financial Reporting, Upstream / FDM Mappings and Data Validation, Full Installation Documentation and Knowledge Transfer, Hyperion Enterprise Administration 5.5.5 , Reports & Analyzer, HFM Web Forms Excel Retrieve HE, and HFM, Upstream / SmartView , BEA Weblogic, SSL , IIS ,SQL Server 2000 and 2005,Oracle 9i DBA, 10G,11g R12, JDE, MASS90/200 Analyst /DBA, Rational Rose, MFG Pro 8.5f DBA, ADP-HRIS Administrator / DBA, Help Desk Management, Network Administrator, Desktop Support,

Reporting Documentation Best Practices:

Hyperion Reporting, Crystal Reports XI, Business Intelligence, MS SQL Server Reporting Services
Writing Data Dictionaries, Project Plans and Deliverables, Process Reengineering, RFP’s, RFI’s, SOW’s, SLA’s, Visio 2007, MS Project , Parasol DBA (Medical Records Systems) , ITIL / ITSM , Sarbanes-Oxley Compliance, Change Management, USGAP-IFRS

Professional Experience

Confidential / Senior Hyperion Programmer/Analyst / San Francisco / 07/2010-Present
Baltimore/ Reston/ Boston /New York City/ Jersey City
Confidential
HFM 11.1.2.1, 9.31 Systems Administration / FDM 9.3 /Data Management / Planning Training

  • Hyperion Environment Build 11.1.1.2, Essbase on AIX , HFM ,FDM on Windows 2008, Oracle Database
  • Development of 11.1.1.2 Planning User Training
  • Finance / IT Liaison Hyperion Project Manager
  • Informatica Data Mappings , Business Process Reengineering, Change Management
  • Administration Tasks (Task/Data Audits, Tuning, Log Reviews)
  • Business Rules development , Data migration between development and production environments
  • Security/User provisioning ,Troubleshoot / Debug production issues ,Task Flow Management
  • Support batch and nightly processing ,Support data loading through both FDM and HFM
  • Maintain FDM mappings ,Database management including indexes building and table optimization
  • Develop Hyperion data extracts for loading into a data warehouse
  • Client Facing, Proposals / Project Management

CSC Hyperion Senior Manager / Confidential, Houston, Boston 05/2011-11/2011
Hyperion HFM 9.3.1.2, 11.1.1.3, 11.1.2.1

  • Financial Report Development, HFM, HSF,HPCM
  • Administration Tasks (Task/Data Audits, Tuning, Log Reviews)
  • Business Rules development , Data migration between development and production environments
  • Security/User provisioning ,Troubleshoot / Debug production issues ,Task Flow Management
  • Pre and Post sales application support
  • RFP and RFI Preparation
  • Data Analysis
  • Application Documentation
  • Smartview Support
  • Petro Chemical Industry, Oil and Gas
  • Financial Services
  • Proposal Development
  • Site surveys
  • Client Facing pre sales technical project management

Confidential /Business Systems Analyst Washington DC04/2010-07/2010
Working as a Business systems analyst I support the FP&A, Business Development & Technology and Capitol Markets department through their Monthly and Quarterly forecast and Budget process. I assisted the departments in the Redesign and Reengineering of the budget transfer and month end close process. Working as a Business Technical Liaison I coordinated the redesign of Hyperion Essbase cube and Hyperion Planning application functional upgrades.

  • Hyperion System 9.2 and 9.3 and 11 Test, Development and Production environments
  • Essbase, Planning, HFM, FDM, HPCM,HSF and Financial Reporting.
  • Facilitate knowledge transfer to financial IT staff and documented systems configuration.
  • Work as IT Liaison / Project Manager for various new application deployments and as General IT support for hardware and software upgrades.
  • Application Development and Upgrade Requirements gathering and documentation.
  • Business Process Analysis, Development and Reengineering,
  • Architectural Advisory Documentation and Deliverables
  • Change Management, Process and Data Standardization

Confidential /Business Systems Analyst / San Francisco /Chevy Chase / New York
Confidential 03/2009- 03/2010
Established and cultivated strong relationships with customers, and Vendors while providing a broad range of financial application consultative and network engineering support services. Traveling to client facilities and working closely with customers at all technical levels to identify needs, determine custom solutions, and deliver full-scale technical services and products, and documentation.

  • Windows 2000 & 2003 server Administration, Vista & Mac OSX workstation support.
  • Hyperion System 9.2 and 9.3 and 11 Test, Development and Production environments
  • Essbase, Planning, HFM, FDM and Financial Reporting.
  • Facilitate knowledge transfer to financial IT staff and documented systems configuration.
  • Work as IT Liaison / Project Manager for various new application deployments and as general IT support for hardware and software upgrades.
  • Remotely support Hyperion System 9 Migration for 8.3 Financial reports. Assisted in the developing departmental specific dashboards .Assisted in development of custom code for Zero Admin Client to mimic functionality of prior environment. I produced instructional documentation on dashboards creation.
  • Application Development and Upgrade Requirements gathering and documentation.
  • Business Process Analysis, Development and Reengineering, Change Management
  • Architectural Advisory Documentation and Deliverables
Confidential /Sr. Principal Consultant / San Francisco 4/2008- 7/2008

Traveled to customer sites throughout the United States to installing and configure new Development, Test, and Production Hyperion 9.3.1 Environments on Windows and Solaris operating systems.

  • The environments consisted of Essbase, BI+ ,Workspace, HFM, Planning , FDM, and SmartView .
  • The backend databases were MS SQL Server 2000 or 2005, and Oracle 9i and 10g.
  • Produced complete documentation of all installs and facilitated knowledge transfer to the management
  • Remotely supported customer’s environments.

Confidential / Hyperion Analyst / New York 4/2007-8/2007
Worked as HFM technical liaison I researched, installed, and documented the HFM applications for Mellon / Bank of New York merger.

  • Responsible for synthesizing of all existing repots to a smaller workable sub subset for all users. This included all retrieves, smartviews, Excel workbooks, and existing, Bank of New York HFM and Mellon Bank Enterprise reports. My other duties included creating an HFM Tutorial for all end-users.
  • Business Process Analysis, Development and Reengineering,
  • Architectural Advisory Documentation and Deliverables
  • Change Management, Process and Data Standardization

Confidential/ Business Systems Analyst / San Francisco, Los Angeles, New York 9/2006-4/2007

  • Established and cultivated strong relationships with customers, and Vendors while providing a broad range of financial application consultative and network engineering support services. Travel to client facilities and work closely with customers at all technical levels to identify needs, determine custom solutions, and deliver full-scale technical services and products, and documentation.

Confidential/ Business Systems Analyst , Project Manager / New York 6/2006-9/2006
Working with Senior Business Management for Pfizer Human Health as a Project Manager .

  • I prepared the Phased Budget Plan RFP, and worked closely with senior management to select the HFM Web forms development vendor and supervise their activities.
  • Liaised with senior corporate managers and migrated “Beacon” the “HP” in house Financial Forecasting application to the new HFM Forecasting application.
  • My Main responsibility was to the Global corporate finance group to manage the implementation of the HFM Phased Budget a multi currency Market P&L, and Product sales tracking and forecasting application.
  • Application Development and Upgrade Requirements gathering and documentation.
  • Business Process Analysis, Development and Reengineering,
  • Architectural Advisory Documentation and Deliverables

Confidential / Hyperion Analyst/ New York 1/2006-5/2006
Senior Accounting and IT management support as a technical Liaison.

  • Researched and document the HFM applications development by a third party vendor, and coordinate the applications integration.
  • I managed the daily operation of the Hyperion Environment. User account creation, security class changes FDM Applications Support, Mappings and Data Validation, andnetwork architecture as related to application security.
  • Working as an IT Liaison I facilitated the knowledge transfer from the third party vendor and document their efforts and the architectural design of the server environment.
  • Coordinated efforts to coincide with SAP,JDE and PeopleSoft software development group on compatibility issues, upgrades and patches. Also I was involved in the SOX compliance, security testing and Audit. Lead Network Security and Architecture meetings on application flow, design and security planning for the Hyperion HFM Global deployment.
  • Application Development and Upgrade Requirements gathering and documentation.
  • Business Process Analysis, Development and Reengineering,
  • Architectural Advisory Documentation and Deliverables
  • Change Management, Process and Data Standardization

Confidential / Sr. Administrative Analyst/ New York 7/2005-11/2005
Working as a technical Liaison. with Senior Operational and Technical management

  • I Instituted Long-Term structure and strategy for implementation of the MATIS applications support and data management team. This involved documenting current and future process flows, business rules, Writing Data Dictionaries, Project Plans and Deliverables and Process Reengineering.
  • Evaluated all input data and its sources and standardized all data collection types. Developed a new MS SQL 2000 database and designed a robust reporting schedule for Management and Planning. Also using Crystal Reports XI I designed new automated client care reports based on statistical analysis of Medicaid services vendors, and HRA employee performance.
  • Application Development and Upgrade Requirements gathering and documentation.
  • Business Process Analysis, Development and Reengineering,
  • Architectural Advisory Documentation and Deliverables
  • Change Management, Process and Data Standardization

Confidential/ Citigroup / Technical Lead / New York 2/2005-6/2005
Established and cultivated strong professional relationships with retail branch senior staff, in order to facilitate and organize the timely deployment of NextGen IV project hardware and software up-grade.

  • Consisting of project planning, purchasing, and documentation for 21 retail sales sites in all of the 50 United States. I supervised installation technicians groups varying in size from 5-35 technicians. Acted as technical support for the remote sites through the installation process.

Confidential / Business Analyst ,Project Manager / San Francisco, Los Angeles, New York, NY 2003-2005
Established and cultivated strong relationships with customers while providing a broad range of consultative network engineering and financial application support services. Traveled to client facilities, while working closely with customers at all technical levels to identify needs, determine custom solutions, and deliver full-scale technical services and products. Supervised 5-35 member teams in providing network administration, server infrastructure establishment, system configuration, administration, and support services.

Key Achievements:

  • Implemented a Hardware Load Balanced environment for HFM traffic and Virtual Addressing.
  • Worked with Senior Accounting and Management as a Hyperion HFM Consultant. Migrated the global accounting department from using Hyperion HE Excel retrieve to Hyperion HFM Excel Retrieve. This entailed a rewrite of all the Excel retrieve formulas and a redesigning the Data Grid for the Year End Global Sales Management Report.
  • Successfully established Windows-based network and systems infrastructures for numerous clients throughout New York, Los Angeles, and San Francisco.
  • Prepared and delivered comprehensive training to users at all technical skill levels.
  • Managed full life cycle hardware & software upgrade projects for 21 braches of a large financial services company, supervising groups of 5 to 35 technicians per site.
  • Successfully recovered mission critical data from corrupted disk for high profile author, as well as replacing faulty hardware to fully recover new work and ensure system operability.

Confidential / Business Systems Analyst / Various Clients, NY and CA 1996-2003 Completed numerous short- and long-term in-house contractual positions, focused on financial applications, network engineering, systems administration support for industry leaders. Provided network, desktop and technical support resolving issues with network connectivity, hardware, and Financial Applications. Designed and implemented backup and recovery procedures Authored and maintained application and server manuals for numerous client projects, streamlining training of new staff members
Key Client Projects:

  • Confidential: Worked with Senior Accounting and Management as a Hyperion HFM Consultant. Migrated the global accounting department from using Hyperion HE Excel retrieve to Hyperion HFM Excel Smatviews. This entailed a rewrite of all the Excel retrieve formulas and redesigning the Data Grid for the Year End Global Sales Management Report.
  • Confidential: Successfully ensured reliability and functionality of desktop and network infrastructure, supporting over 200 users in Windows 2000 and Exchange 5.x environment; concurrently served as information security DBA. Analyzed and documented user requirements for medical applications and established user environments for remote access.
  • Confidential: Provided comprehensive network design and administration services for 1500-member DOD -telecommunications provider.
  • Confidential: Managed migration to ADP SQL Server for payroll department, as well as coordinating all Y2K upgrade initiatives.
  • Confidential: Project Management for Y2K upgrades, including migration to Oracle Financials. Supported JDE developers as our duties coincided during Oracle financials upgrade. Researched and documented all Y2K issues for networked financial applications and equipment.
  • Confidential: Managed the migration to MFGPro financial applications / MRP system. Also ensured seamless Y2K rollover, including management of NT Server/Workstations, Novell systems, Exchange, and migration of LAN infrastructure.
  • Confidential: Worked as the office Manager supporting Equity sales, Research and Corporate Finance, and Trading Floor support. Coordinated end-user support of ILX, Bloomberg, and in-house client accounts applications.
  • Confidential: Applications support, Hyperion 4.3, Oracle 7.0, BBB, S1vb, Lotus Notes 4.1, Rational Rose
  • Confidential: While at GBI I worked in the Networking and Helpdesk support area on the BGI Global Antivirus Eradication Project. Worked with both the San Francisco and the London offices to customize the Global policies for the San Francisco office environment and right a comprehensive eradication plan document.
  • Confidential: Provided desktop support to the Cupertino Corporate offices, Lotus Notes, Windows and Financial Applications Support.

Learning Network, (Pearson Publishing) / Business Systems Analyst / San Francisco, CA 2000 – 2001
Performed ongoing systems engineering, network design, and infrastructure administration services, working closely with cross-functional business and technical teams throughout all phases of large-scale projects to continually improve network operations.
Key Achievements:

  • Managed all aspects of Hyperion 4.3--5.1 Migration, also managed all Hyperion daily operations for executive offices and financial departments, including application upgrades and user support.
  • Produced and maintained concise technical documentation, streamlining operations while clearly articulating network topography, and applications design.
  • Migrated the finance department to MAS 90, from In-House application.
  • Managed the Migration of the HR / Payroll single user application to the ADP-HRIS multi-user Oracle based application.
  • Planned system to manage telecommunications and network assets company-wide.

Confidential / Medical Device Development (1989-1991 and 1993-1996)

  • Baxter Novacor Healthcare--- Artificial Heart R&D Technician
  • Peripheral Systems Group---CADD Design and Drafting R&D , Angioplasty Catheter Research
  • Cybex Systems --- R&D Robotics Technician
  • LTD Ceramics--- Quality Engineer Alumina , IC Manufacturing Engineering
Education and Training

Oracle 9i DBA Certificate
Hyperion Enterprise Administration Certificate / HFM
UNIX Systems Management and Administration

Business and Finance

We'd love your feedback!