We provide IT Staff Augmentation Services!

Systems Analyst Resume

New Jersey, NJ

SUMMARY

EXPERIENCE

Confidential,January 2009 – Current
Financial Systems Analyst
Responsibilities

  • Maintenance and Development of SAP BPC(Outlook Soft)
  • Manage and run weekly soft and monthly/year end hard closes
  • Responsible for end user support for 650 BPC end users
  • Serve as functional and technical escalation point for BPC related issues
  • Development of BPC Planning, Consolidation and reporting cubes
  • Development of BPC reports in evdre/evget syntax
  • Provide formal and ad-hoc financial reporting as required
  • System administrator for Concur, Microsoft Great Plains, Arabia and Xign
  • Gather and implement end user feedback for financial reporting.
  • Document, train and transition new process to tier one & two staff
  • Evaluate and advise management on new financial systems
  • Develop and implement KPI based reports for senior management

Accomplishments

  • Managed upgrade from BPC 5.1 to 7.0
  • Developed and implemented transition from desktop client to a remotely client run on thin clients.
  • Redesigned operations reporting cube, data extract and reporting
  • Developed automated upgrade roll out strategy for BPC upgrade.
  • Led conversion of over sixty custom BPC reports from evget syntax to evdre syntax

Confidential,August 2007 – January 2009
Financial Systems Analyst
Responsibilities

  • Maintain and develop Essbase data cubes
  • Liaison with IT infrastructure to support management reporting applications
  • Provide end user support for Essbase spread sheet ad-in and Cognos Executive Viewer
  • Develop and maintain company earnings statements, and other management reports
  • Teach end user training classes for management reporting tools.
  • Develop and implement VBA scripts to automate essbase reporting
  • Serve as back up data steward for financial data warehouse.
  • Develop and maintain documentation for reporting systems, and report packs

Accomplishments

  • Obtained Oracle Hyperion Essbase developer certification
  • Designed Essbase redundancy and failover system
  • Led development of expense reporting pack for senior management
  • Created as is documentation for earnings packages, and Essbase systems

Confidential,April 2006 – August 2007
Systems Analyst
Responsibilities

  • Support software applications (Kronos, Medsys, Accpac)
  • Responsible for designing preparing internal and external Reports (SQL, Excel and Crystal Reports)
  • Lead implementation of new software products
  • Construct complex SQL Queries
  • Conduct end user training
  • Mange SQL server 2000 databases

Accomplishments

  • Led Care voyent implantations(Medical Billing, Scheduling and Accpac Interface)
  • Interim project manager for Care Voyent Implementation
  • Complied and reported entire agency fiscal budget in Accpac
  • Designed edited and rolled out numerous Crystal Reports
  • Converted Patient information and demographics from legacy systems

Confidential,November 2005 – April 2006 (Temporary)
Contract Functional Analyst
Responsibilities

  • Support account payable and purchase order modules for an Oracle web applications platform
  • Research and resolve vender file issues
  • Provide Support to AP and PO modules
  • Scrub and maintain the vendor file
  • Write reports using various ad-hoc reporting tools
  • Revise and test end user training materials for accounts payable and purchase order modules

Confidential,June 2003 - May 2005
Securities Administration Analyst II (December 2004 – May 2005)
Responsibilities

  • Prepare and file monthly 8-K, 8-KA, yearly 10-K, and form 15 filings with The SEC
  • Reviewing XML code in SEC filings
  • Designing and running queries on the Securities Database
  • Working with investment bankers on SEC filing requirements
  • Reviewing legal documents to determine reporting requirements
  • Designing and updating spreadsheets to track the status of securities
  • Working with business development to obtain legal documents

Accomplishments

  • Completed the largest Form 15 filling in Wells Fargo history.
  • Completed Numerous 8-K filing

Operations Clerk II (June 2003 – December 2004)
Responsibilities

  • Maintain and tracked documents pertaining for over 800 RMBS and CMBS bonds held in trust with equity in excess of two hundred billion dollars
  • Building and maintaining a resume tracking database to track resumes from there receipt through the hiring process
  • Obtaining, tracking, and entry of USAP documents for over seventy mortgage servicers
  • Processed database change requests

Accomplishments

  • A total overhaul and reorganization of two large compliance libraries
  • Completed the SEI account changes for charter consolidation
  • Nominated for 1st quarter 2004 team excellence award
  • Frequent recipient of cash “On the spot bonus rewards”
  • Gained a good overall understanding of the loan securitization process, secondary mortgage market, and the different roles played on bonds such as Master Servicer, Trustee and paying agent.
  • Played a vital role in the preparation and execution of power of attorney documents
  • Designed a training activities manual

SKILLS, INTERESTS &ACTIVITIES

  • Proficient in SQL
  • OLAP Cube development
  • Essbase cube and report development
  • High competence in Crystal Reports, Business Objects, Query analyzer, SQL management console and Microsoft Excel
  • Excellent analytical skills

EDUCATION

Received Bachelor of Arts
Major in History Minor in Political Science

CERTIFICATIONS

Oracle-Hyperion Essbase Certified Developer.

Hire Now