Finance Reporting Analyst Resume
3.00/5 (Submit Your Rating)
Milpitas, CA
TECHNICAL SKILLS:
Programming languages/Tools: SQL, MS ACCESS, VBA, Excel, VB, Hyperion BRIO, OBIEE, Crystal HOLOS, Informatica, DecisionPoint Warehouse, UNIX shell scripts, Perl, Cognos PowerHouse 4GL, COBOL
Databases: ORACLE, MS - Access
Applications: TOAD, MS Lync 2010, SharePoint, MS-Office, Google Document, Google Spreadsheet, Oracle 11i+, ServiceNow, SQL Navigator, MS Visual SourceSafe, PVCS
PROFESSIONAL EXPERIENCE:
Confidential, Milpitas, CA
Finance Reporting Analyst
Responsibilities:
- Supporting users on reporting issues, data gathering, ad - hoc analysis request using Hyperion Brio, Essbase, MS Excel, VBA
- Point of contact with IT on reports enhancements
- Assist in data validation on RevPro
- Preparing and automating period close financial packages
- Functional knowledge in booking, billing, revenue
BI Analyst
Confidential
Responsibilities:
- Support users on reporting issues, enhancements using Hyperion Brio, OBIEE
- Collaborate with offshore team on data warehouse changes
- Cooperate with auditors on SOX compliance documentation
- Knowledge in data warehouse, ETL
- Knowledge in BI tools - Hyperion Brio, OBIEE, Tableau
Operations Reporting Analyst
Confidential
Responsibilities:
- Interact with various groups in operations to understand reporting requirements, propose and provide solutions
- Functional knowledge in supply chain (inventory, WIP, BOM, PO,supplier), contract manufacturing finance, finance forecasting, data management
- Automate business process using MS Access VBA, Excel
- Data gathering and analysis using SQL, Excel
- Document business processes, prepared business requirements document (BRD)
- Serve as point of contact with IT on reporting requirements, enhancements prioritization, testing on Hyperion Brio reports
- Setup departmental server and automate reports distribution for 15 different applications using Excel VBA.
- Established effective process in handling users’ reporting request. Cleared 2 years backlog.
- Resolved over 50% of Brio incidents tickets
Confidential, Oakland, CA
Sr. System Analyst/Programmer
Responsibilities:
- Involved in creation of 9 OLAP & analytics vessel transportation applications (cargo management, equipment management and demand-supply forecasting of cargo flow) using Crystal Holos.
- Increased 2,000 users’ (worldwide) productivity and efficiency by consolidating data retrieval into one platform from multiple mainframe systems.
- Lead other developers and managed offshore team.