SSRS/SSIS & MS Access• Data mines, imports, exports and integrates data between multiple systems• Compiles and consolidates spreadsheets, databases, draw charts and graphs into reports for management decision making• Develop actionable dashboard reports for internal clients using various reporting and query tools, especially MS-SQL and Reporting Services • Create weekly, monthly and quarterly reports and presentations as needed for the Senior Executive Team to be presented to key stakeholders• Generate adhoc reports and queries from data warehouse for Finance and Operations dept.

Oracle Business Suites• Design various queries using TOAD by Quest• Upload AP volume invoices through AP Preprocessor and GL JE through ADI• iExpense approval limit setup and maintenance• Prepare monthly AR/AP/Unbilled reconciliation reports• Reconciliation between PA and G/L modules• Assist the intercompany reconciliation• Government compliance, SOX compliance and Internal audit data support• Prepare weekly billing and unbilled status reports to support project managerMicrosoft Access• Setup and maintain R&D tax credit calculation model database• Reconciliation / validation of data between various financial systems and other sources.Hyperion/Oracle• File census and surveys for U.S Dept of Commerce quarterly and annually

JD Edwards Financials• Use Microsoft Access/Excel and Crystal Reports to generate and distribute financial reports• Generate monthly and weekly reports in Microsoft Access and Crystal Reports to support divisional and regional managers.• Provide system and analytical support to senior management and operations• Assist in the analysis and presentation of PSMI operating results• Responsible for coordinating the compilation of comprehensive property and corporate level budgets• Prepare executive management decision database systems, which assist in strategy and goal changes• Prepare capital improvement actual vs. budget reports on a monthly basis• Import and export data from the SQL mainframe to structure in Microsoft Access to build Ad Hoc reporting.

• Write VB scripts for data import/export• Import data from Excel and Text format into Microsoft Access• Wrote queries and designed forms• Create new tables and modify data field properties and data type in Microsoft Access to support VB database• Build and modify forms and reports to improve performance