ALICIA SARVARI, PMI Tel: 647-***-**** ad1cdz@r.postjobfree.com

PROFESSIONAL EXPERINCE

Financial Application Support Analyst Brookfield Global Integration (July 2015 – Present) Updating financial reports and Business requirements in Oracle E-business suite and RFC’s. Supporting and troubleshoot work Force Management and Timesheet Applications for Finance department. Monitoring and ensuring timely resolution, logging issues and resolutions for financial Application. Maintain documentations and providing end users training on Oracle Business Intelligence applications modules. Updating Oracle projects by end dates and key members on Oracle E- business suite applications modules. Creating enterprise Smartview reports and OLAP analysis. Providing technical support by analyzing OTL system. Business Report Analyst Shahrema (July 2014 – June 2015) Provided weekly and monthly reports and generated advertising sale ad- hoc reports in SQL Report Builder and MS Access. Created MS Access database to collect data systems in order to provide lists, status reports and management overview reports. Maintained computerized records of all payroll advancements. Created macro and pivot tables in MS Excel for project manager and marketing team. Created and maintained project documentations in the Microsoft Office applications for payroll system. Skilled in maintaining smooth flow of the payroll, troubleshooting and provided solutions to payroll problems. Business Developer Analyst Pacific Life (Feb. 2009 – June 2014) Created Report and extract data using MS Visual Studio and MS SQL Server Management Studio 2012 using Microsoft SQL Server. Supported and Administrated SharePoint server. Developed and Maintained MS Access Database to collect data systems in order to provide lists, status reports and management overview reports.

Generated and maintained customize financial hoc reports to support internal business needs for the reporting metrics compliance. Customized and tested forms and reports in Crystal Reports 2013 using MS SQL server. Generated financial dashboard reports in MS Access 2013. Created macro in Excel 2013 for financial spreadsheet. Searched, extracted and testes data using Microsoft Reporting Services 2012. Update project database management. Provided support to technical teams by analyzing data and reporting results using SharePoint 2013. Administrated including customizing User Profile Service, Properties and My Site configuration. Created custom lists, libraries, workflows, lists, libraries, pages, publishing, web parts, importing, exporting. Created and maintained SSRS reports in Report Builder 3.0 in SQL Server 2012 for accounting department. Business Application Analyst The Irvine Company – Technisource (Apr. 2006 – Jan. 2008) Generated and reviewed generated reports in Finances, Sales, Purchasing, Payroll and inventory Control modules for financial users, auditing process and account administration process. Generated and maintained customized financial hoc reports to support internal and external business needs including reporting metrics compliance. Managed the financial database access right. Gathered, documented and updated Business Applications requirements for financial users. Searched, extracted and tested data using Microsoft Reporting Services 2005. Provided ongoing status reports to management. Developed, customized and tested Reports in COGNOS Report Studio for accounting department. Modified and tested security group and security access permission in Timberline-IPG and AMSI DOS. Set up the new user for the following applications GEAC SmartStream, AMSI DOS, Timberline-IPG, Great Plains, COGNOS, Hyperion Essbase, Report Q and TIC Reporter. Customized and tested GEAC SmartStream financial application in PowerBuilder 9.0 using MS SQL server. Maintained and Supported Business applications for accounting department. Modified and tested user classes and the security class ID in Great Plains, security group and activity security in GEAC.

Application Developer Analyst IndyMac Inc. (Jan. 2003 – Apr. 2006) Developed, designed, tested, implemented and maintained custom software systems develop using Oracle Developer 2000/Oracle Forms & Reports 6i. Reported and tracked problems. Designed, programmed and tested financial applications in PowerBuilder 9.0 using MS SQL server. Generated and maintained customized financial reports for internal and external clients. Created a complete software document for technical specifications reference material. Modified and tested all objects including Tables, Stored Procedures, Triggers, Views and Rules. Tested, evaluated and supported database system using MS SQL Server 2000. Tested and evaluated financial transactions using SQL

& PL/SQL.

Created the Business Requirement Documents (BRD) and the Functional Requirement Documents (FRD). Functioned as a liaison between various business users and the technical team throughout the project lifecycle. Wrote test cases for conducting Use Acceptance Testing involved in creating User Manuals and training end users. Senior Developer Support Analyst Epicor Software Corporation (Jun. 1999 – Jul. 2001) Developed, customized and tested Forms and Reports in PowerBuilder 6.5 using SQL Server for accounting software (AP, AR, GL, Purchasing, Order Entry, Inventory, Vendor’s invoices and Payments). Customized and tested Forms and Report in Visual Basic 6.0, Seagate Info and Crystal Reports 7.0 and evaluated and analyzed solutions to the complex scripting code errors and bugs. Identified and tested Platinum ERA database system using SQL Server 7.0/ 2000 and PL/SQL for beta products. Managed the financial database. Extracted and tested data using Microsoft Reporting Services. Provided support to technical teams by analyzing data and reporting results. Maintained current patches and released enhancements for application server.

Reported and tracked problems for eBackOffice Suite by ticket number. Generated and maintained customized financial reports for internal and external clients. Created a new complete software document for customizing Distribution and Manufacturing reports and knowledge base documents. Planed and developed training and technical reference material for the department and Resolved PTRs in an intensive time frame.

Programmer Analyst Sun Life Financial Corporation (Sep. 1997 - Jun. 1999) Developed systems and programmed specifications, tested, and implemented new transactions in PowerBuilder 5.0 using Sybase SQL Server. Built MS Access database for the business users. Programmed and tested the financial transactions in COBOL and JCL using Mainframe environment. Provided effective on-going support for the Saber system. Programmed and tested the financial transactions in C++ using UNIX platform.

Developed, programmed specifications, and tested the agent commission reports in MS Access 97 using SQL Server connection. Supported development of a speciation control documents for MS Access Project Management Database.

PROFESSIONAL SUMMARY

A self-driven and highly motivated individual with great mathematical and analytical skills. Tech savvy and fully familiar with payroll software and various forms of payroll interface. Proven ability to process payrolls and maintain employee confidentiality for heavy volume firms without supervision. Hands of experience with MS SQL Server, query and databases and programming languages. Extensive experience in design and implementation of distribution Internet applications. Seven years of experience in systems analysis and design to client specifications in defined benefits, Real Estate, Mutual Fund, and accounting environments. Project planning and management, contract negotiation experience, information systems support, and problem resolution. Experienced in process planning, technical writing, financial reporting, and project documentation, plus user acceptance testing and user group training. Pursuing MBA certificate.

TECHNICAL SKILLS

Languages & Databases : Data Warehousing; SAP Payroll; MS SQL Server 2012; SQL Server Management Studio 2012; PowerBuilder 9.0; Visual Basic 6.0; Sybase; Developer 2000 Oracle Forms & Reports 8i; PL/SQL; Oracle 11i E-Business Suite; Seagate Info; Crystal Reports 2012; Reporting Services; MS Office 2012; MS Access 2013; SSRS Report Builder; MS Project 2010; Business Objects; MS Visual Studio 2012; Visual Studio.NET; SharePoint 2013; Project Management; Adobe; Publisher; InDesign, Photoshop and Dreamweaver. Big data Hadoop Platform and Application Framework.

Networks & Operating Systems: DOS; UNIX; IBM Mainframe; Client/Server; Windows (2013, 365 - XP, NT). EDUCATION AND CERTIFICATION

Bachelor Degree in Information Systems Diploma Computer Information Systems DeVry University (Oct. 2001) DeVry University (Jun. 1996) Certified Project Management Institute (PMI)

Coursera (May. 2016)

Certified Crystal Reports V.7 Introductory & Advanced Workshops & SI V.7 Administrator Center For Networks & Education, Inc. (2000)

Oracle Certified Professional (OCP) Program Certified Building Object Oriented Applications with PowerBuilder Xincon Computer School (1999) Authorized Visual Sybase Education Partner (1998)