Senior Data Analyst - Business Intelligence Resume
3.00/5 (Submit Your Rating)
PROFESSIONAL SUMMARY:
- Self - motivated, dedicated and reliable professional with proven team leadership and experience in overseeing financial systems, managing risk, rebuilding infrastructure, and new system conversions.
- Cross-functional team leadership Financial and cost analyst Oversee AP and AR staff
- Project design and management P&L, budget and forecast Data/system migrations
- Asset analysis and management Reconciliation and reporting Documentation analysis
- Cost and pricing issue resolution Prevent or eliminate errors Key solution resource
TECHNOLOGY:
Proficient with advanced Microsoft Excel (V-lookups, pivot tables and macros); Microsoft Access and Microsoft Word; SharePoint; Business Intelligence; Business Objects; Business Warehouse; ERP, SAP, EDI; Infor Cloud Suite; JD Edwards; and new system conversions.
EXPERIENCE:
Senior Data Analyst - Business Intelligence
Confidential
Responsibilities:
- Perform extensive research, data and documentation analysis, networking with IT and business units, and formatting and loading of historical data during conversion of ERP system to Infor Cloud Suite.
- Provide cross - functional leadership, guidance and direction to cross-functional team comprised of business units and IT personnel during this technical conversion designed to significantly improve business intelligence, productivity and financial processes in alignment with corporate objectives.
- Selected as solution resource responsible for resolving transmission errors from international divisions; also performed mass updates, which resulted in preventing and eliminating any errors or discrepancies.
- Streamlined data formatting and documented processes to facilitate access by multiple users throughout various business units.
- Designated as troubleshooting resource, which included successfully identifying, preventing and eliminating errors; formatted data using advanced MS Excel to optimize load and minimize errors.
- Participated in strategy meetings with key decision makers; built solid collaborative relationships.
- Worked closely with AR, Customer Data Management, Contracts Department and sales reps.
Senior Financial Analyst
Confidential
Responsibilities:
- Conducted extensive research, analyzed existing data, and set up new customers in SAP; awarded authority for approval based on senior management s trust in personal integrity and accountability.
- Managed user process for EDI and non - EDI customer partners using GHX supply chain management and business intelligence tool.
- Downloaded new customer and change reports for international divisions weekly and monthly from SAP and converted data to Microsoft Access; resulted in improving data integrity and cost reduction.
- Selected to conduct weekly auditing of colleague and customer master outsourcing firm.
Financial Analyst
Confidential
Responsibilities:
- Performed monthly reporting and reconciliation of budget, actuals and forecast for IT Delivery using various budgeting tools including SharePoint and Business Objects.
- Worked collaboratively with Procurement, Finance and various project managers to successfully reconcile the IT Delivery Department project budget and cost center financials.
- Reconciled over 20 consultants labor and travel costs using SAP, Clarity, MyBlueBadge and Concur.
- Selected as technical support to business analysts to reconcile master data after acquisition by Pfizer.
Fixed Assets Analyst
Confidential
Responsibilities:
- Managed accounting policies and internal controls; ensured that project managers complied with capital/expense project accounting, including investment thresholds, depreciation and tax.
- Analyzed assets under construction and process authorization forms to successfully close projects and create fixed assets based on company s Assets Master Record Template and Segment sub - components.
SAP Analyst
Confidential
Responsibilities:
- Provided cross - functional team leadership while Team leader responsible for supporting two projects: Product Hierarchy Reconstruction and Global Labeling.
- Updated product hierarchies; located correct department, project manager, status, and tax code within a database comprised of over one million part numbers.
- Exported mass data from SAP into Microsoft Excel; analyzed data and prevented or eliminated errors; updated data sets as needed.
- Quickly learned new labeling software; designed over 100 labels to be used upon go-live.
Fixed Assets Accountant
Confidential
Responsibilities:
- Managed all fixed assets during an ERP conversion from JD Edwards to SAP, including purchase order creation, invoice processing and asset retirements.
- Trained warehouse managers to create purchase requisitions and receive goods in SAP.
- Filed gross receipts, real estate and personal property tax returns and payments within deadlines.
- Worked with Accounts Payable to improve the process of entering and paying fixed asset invoices.
Fixed Assets Analyst
Confidential
Responsibilities:
- Reconciled monthly spending on ERP conversion project; migrated data from JD Edwards to SAP.
- Trained and directed Shared Services Team on how to perform accounting for fixed assets in SAP.
- Team member responsible for testing and documentation of fixed assets module (FI/CO) design.
- Identified and resolved risks associated with budgets and vendor contracts with all departments.
- Created a tracking tool to monitor project spending against budget during ERP conversion.