We provide IT Staff Augmentation Services!

Oracle System Analyst Resume

5.00/5 (Submit Your Rating)

SUMMARY

  • Oracle Fixed Assets: Excellent understanding of the Oracle Fixed Assets module and its integration with AP, PO, PA and GL. System configuration sat up and maintenance of assets categories, depreciation methods, calendar, and locations for corporate and tax books. Prepared data for conversion and reconciliation: data mapping, migration. Designed reports based on functional and financial specifications. Uploaded mass additions and adjustment. Run interfaces for mass additions and retirements.
  • Oracle 11i Applications: Performed Oracle system administrator tasks like creating users and defining roles and responsibilities. Analyzed the current business requirements, suggested best practices, and designed a new process flow. Participated in conducting operational training for the users to work on various financial modules. Created user manuals for the customized programs.
  • Key Strengths: A process-oriented leader whose ability to consistently create infrastructure and streamline operations has resulted in significant cost savings, increased efficiency and improved quality. Analytical problem solver, strong in leading the design and implementation of new processes and procedures to improve integrity of financial and business data. Outstanding communication skills proven by effective interaction with management, clients, vendors, staff and team members. Ability to quickly learn and apply new technologies. Fluent in Spanish; conversational French, Italian and Portuguese.
Professional Experience

Confidential, Atlanta, GADec 2008 to Present
Sr. Fixed Assets Analyst

Requirement gathering, gap analysis, coordinated the mapping of current and future business processes, creation of desktop procedures, stakeholders identification, communication and stabilization plans. Prepared project plan and schedule of activities required for the Oracle Fixed Assets and Tax Books implementation for the US and Canada; 400,000 assets worth 2B. Defined system setup and configuration, calendars (fiscal, tax, and short tax years), depreciation methods, categories, etc. Prepared testing scripts, conducted testing and validation process. Designed data mapping conversion and prepared legacy data for testing and for final upload. Prepared training material and trained end-users. Performed testing for Oracle patches and/or upgrades.

Confidential, Atlanta, GADec 2007 to Sep 2009
Oracle Fixed Assets Consultant

Accomplishment: Successfully completed the integration of an acquired company into Oracle Fixed Assets (11.5.10).
Reviewed and determined data mapping requirements, database tables to update, asset categories, depreciation methods, locations, and other modifications as needed. Prepared data files to upload. Planned, prepared, and conducted integration testing and final uploads for corporate book and tax books. Performed gap analysis of tax books, developed and implemented necessary solutions. Trained end-users, accountants, tax and fixed assets managers.

Confidential, Atlanta, GA Jan 2006 to Dec 2007
Senior Fixed Assets Accountant, System Analyst Fixed Assets

Accomplishments: Implemented a FAS database. Automated reconciliation of fixed assets to production, billing and inventory reports.
Re-created 3 years of fixed assets accounting data for corporate and tax books. Prepared data files to upload. Planned, prepared, and conducted integration testing and final uploads. Established standard processes for the weekly fixed assets inventory in the USA and Mexico locations. Created financial reports for FA, GL and AR.

Confidential, Atlanta, GA Oct 2004 to Jan 2006
Senior Fixed Assets Accountant, Oracle System Analyst - Fixed Assets

Accomplishments: Achieved the implementation Oracle Fixed Assets (11.5.9).Coordinated the fixed assets inventory of 205 locations.
Prepared project plan and schedule for all activities involved in the Oracle Fixed Assets implementation. Defined system and book controls, fiscal years, calendars, depreciations methods, investment tax credit, prorate and retirement conventions, as well as descriptive, locations, and categories flexfields. Designed data mapping and prepared legacy data for testing and for final upload for corporate and tax books. Created FSG and Discoverer reports. Provided training to senior management, accountants and tax analysts.

Unemployed May 2003 to Oct 2004
Took a complete curriculum of IT classes including Unix, Solaris, SQL, PL-SQL, Oracle 9i database administration, Oracle 6i Developer, Oracle 11i eBusiness Suite architecture - business and technical-, module integration, system administration, workflow, and alerts.

Confidential, Atlanta, GA Jan 1999 to May 2003
Business Manager

Accomplishments: Credited with implementing an automated inventory control system, resulting in reducing inventory management functions by 50%.
Administered and processed Accounts Payable, Accounts Receivable and Payroll functions including Sales, Payroll, State and Federal Tax returns, profit and loss, financial record keeping, purchasing, inventory, safety/security, quality adherence and management reporting. Formulated and managed marketing and operational plans. Established and monitored customer service strategies. Researched and directed the deployment of new technology solutions to automate previous manual functions. Managed and enhanced business relationships with vendors, including contract negotiations and pricing strategies. Hired, trained and mentored staff of 10 employees.

Confidential, GA, WA and VA Feb 1989 to Jan 1999
Accountant, Senior Fixed Assets Accountant, Fixed Assets Systems Analyst

Accomplishments: (1998) successfully completed the implementation of Oracle Fixed Assets (10.7) while also being a contributor to the GL implementation. (1997) leaded the integration of more than 18 GEFA companies to a consolidated Fixed Asset System (FAS). (1997) successfully coordinated the transfer of fixed assets -database and accounting- controllership from Washington to Virginia. (1994) re-designed system to automate the receipt and processing of invoices. Solution was recognized for reducing payment procedures from 12 to 3 hours. (1992) Recognized for the idea to process the employee travel expense reimbursements (15.6M annually) through the payroll system.
Selected to manage and monitor company's fixed assets valued at more than $250M. Updated and maintained company's Fixed Assets database. Analyzed and ensured integrity of financial data for multiple companies and sites. Coordinated monthly and quarterly closings, prepared variance analyses of balance sheet accounts, facilitated the preparation of annual financial statements, reviewed account reconciliations. Documented fixed assets policies and procedures. Supervised and mentored staff of 2 employees. Prepared project plan and schedule for all activities involved in the Oracle Fixed Assets implementation. Guided technical team with definition of system and book controls, fiscal years, calendars, and depreciations methods, as well as descriptive, locations, and categories flexfields. Designed data mapping and prepared legacy data for testing and for final upload. Organized documentation to train accountants, financial and tax analysts.

Educational Background

Bachelor of Business Administration in Management & Economics
Bachelor of Science Degree in Accounting
Oracle Fixed Assets11i

Technical Skills: FAS-Best-Sage Software, Oracle 11i System Admin, Oracle 9i DBA, Oracle 6i Developer Forms & Reports, Unix, Linux, PeopleSoft, JD Edwards, Macola, Hyperion, Monarc, Crystal Reports, Microsoft Access, Excel, Project, Word.
Other Training: Six Sigma Green Belt, Project Management (PMI).
Languages: Fluent English and Spanish; conversational French, Italian, and Portuguese.

We'd love your feedback!