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.