Financial Data Analyst Resume Samples

Description :

1. Supported cost accounting to develop, maintain, and update product standard costs.
2. Analyzed product standard costs fluctuations from the prior year and provided a summary report to management.
3. Prepared supplemental schedules on key accounts impacting gross margin, the expense to revenues, and distribution costs, performed reviews of processes and procedures to identify and quantify profit opportunities and efficiency improvements.
4. Prepared reports, analysis, and explanations for monthly manufacturing variances.
5. Supported cost accounting in data entry or review, and maintenance of all item master set up and bill of material data in Oracle Cost Accounting Application.
6. Created ad hoc reporting and analysis and implement custom reporting requests.
7. Provided accurate, courteous and professional service to all internal and external clients.
8. Performed all daily reporting functions with minimal supervision.
9. Provided assistance and technical support to end users to research data anomalies and communicate reporting procedures.

Experience

7-10 Years

Level

Senior

Education

Certification

Description :

1. Presented monthly financial results to finance directors outlining actual performance against forecast.
2. Experienced in the creation of annual budgets and forecasts for operational sales and costs.
3. Responsible for the creation and evaluation of sales plans for approximately 1,500 retail stores.
4. Skilled in large dataset report building using multiple workbooks, access tables, and VBA coding.
5. Prepare powerpoint presentation of monthly financial review for VP of Operations.
6. Discovered $100k in unknown accrued revenues from special project account analysis.
7. Created an audit process to reconcile repair costs and improved accuracy of financial metrics.
8. Experienced working with ERP systems such as Hyperion, MicroStrategy and business objects.
9. Utilized VBA coding to efficiently maintain and distribute weekly and monthly reports to the field.
10. Performed reporting and ad-hoc analysis for repair, warranty and insurance department management.

Experience

5-7 Years

Level

Executive

Education

BS

Description :

1. Involved in extracting data from multiple sources such as SQL Server, DB2, and excel by using SQL in toad analysis, and VBA technics to meet business requirements.
2. Held the meeting with ba and test designee for troubleshooting, such as fix data error, understand business logic and find error root cause.
3. Used t-SQL script created and dynamic query, meanwhile created automatically monthly, annually and other regularly report.
4. Ran the statistical model in excel file and check the data accuracy based on the model.
5. Created materialized views, temporary tables, CTE (common table expression), and correlated subqueries, nested queries, and various forms of control structures including dynamic SQL query, case statement, if-else statement, for loops, while loops for sample development.
6. Evaluate data transfer processes to identify efficiency shortfalls and determine long-term needs and wants.
7. Assists with the monthly financial close process, including the preparation of a month end reporting package.

Experience

2-5 Years

Level

Entry Level

Education

MS

Description :

1. Reviewed the cash flows for accuracy, if necessary, regenerated and saved the cash flows.
2. Assisted or identified the reconciliation items and adds detailed comments.
3. Assisted and actively researched/resolved the discrepancies with various agents and clients.
4. Monitored workflow to ensure the accuracy of the cash flow reports and cash reconciliations.
5. Liaisoned with internal groups/counterparts to ensure the accuracy of transaction flow and follows up on outstanding issues.
6. Resolved issues effectively and timely for cash flow and reconciliation deadlines.
7. Coordinated with the internal and external parties to resolve any settlement or deal transaction issues.
8. Assisted and prepared various reports, as needed, for internal employees.
9. Processed and reconciled the data attribute differences in various systems for reporting purposes.
10. Actively monitored the securities settlement process and initiates resolution within the scope of authority, as needed.
11. Learned deal-specific documents/indenture for performing test calculations and the report sections.

Experience

10+ Years

Level

Management

Education

BS

Description :

1. Gathering, combining, and processing the member data to create insightful reports which focus on developing holistic perspectives of membership trends by translating data into ready-to-use tools for executive decision-making.
2. Producing data reports via salesforce, utilizing quantitative and qualitative research and analytical methodologies and their application.
3. Analyzing the external and internal information resources to highlight important data points and membership trends.
4. Acting as the main analyst for member data, dashboards, and reports in Salesforce.
5. Developing MS Excel reports, which identified misappropriated funds through outstanding invoices.
6. Developing financial reports and briefing binders covering accounts receivable payments and accounts payable payment receipts and membership status using MS Excel.
7. Providing the analytical support for the department's/company's long-range strategic plan and overall performance.

Experience

2-5 Years

Level

Junior

Education

BS

Description :

1. Serving as subject matter expert/module delegate for PeopleSoft HCM commitment accounting and general ledger integrations including system upgrades or implementation of new features/modules.
2. Managing all day-to-day operations related to regular payroll distribution processes in PeopleSoft HCM and Finance including journal generation of the weekly, biweekly, and monthly payrolls.
3. Responsible for the various reconciliations which includes the validation of the data integrity between the subsystems.
4. Working directly with users internally within finance and externally with the departments to develop operational reports using business intelligence tools.
5. Peoplesoft functional issue resolution - including management of payroll interfaces, data integration, data extracts/reporting requests, and developing payroll analyses for management.
6. Leading the functional development/testing of system processes or implementation of new business processes related to peoplesoft hcm commitment accounting.
7. Developing and presenting the recommendations for business solutions through research and analysis of data and business process and implement when appropriate.
8. Developing and maintaining the business process documentation for data management HCM and financials operations as well as training documents.

Experience

5-7 Years

Level

Executive

Education

BA

Description :

1. Recognized as a trained superuser and subject matter expert for the institution’s major transition from its legacy system to the epic portfolio.
2. Identified workflow gaps to improve patient identification, patient satisfaction and timely reimbursement of over $30m in services annually.
3. Successfully assisted revenue cycle management, clinicians and other stakeholders across the enterprise with modifying existing processes.
4. Increased the productivity, reduced redundancy and failed edits by 45%.
5. Extracted and compiled data from several disparate sources to pinpoint high-cost items that affect established rates and contract performance.
6. Developed and maintained a tracking system/database in Microsoft Excel (using pivot tables, Vlookups, etc) to identify trends and increase the efficiency of high-level charge analysis and pricing projects.
7. Analyzed monthly and quarterly financial reconciliation reports of $15m in transplant and elective services for quality assurance and provide accounts’ status in the revenue cycle to senior management.
8. Verified accuracy and compliance of healthcare data for an annual corporate audit of more than $8m in billed revenue.

Experience

10+ Years

Level

Management

Education

BA

Description :

1. Interpreted data from primary and secondary sources and make them to a single report.
2. Prepared daily, weekly, monthly and quarterly reports and provided data to executive officers.
3. Created analytical data mining and analysis based upon existing performance and data reports.
4. Worked in a data analyst support role that signified functions of existing programs to improve system optimal running.
5. Performed daily data queries and prepared reports on the daily, weekly, monthly, and quarterly basis.
6. Used advanced excel functions to generate spreadsheets and pivot tables.
7. Adding advanced functions like Hlookup, Vlookup, Sumif, Countif, Nestedif, Round, Proper, Lower and Upper.
8. Executed SQL queries for daily, weekly reports and scheduled many reports.
9. Strong knowledge of VBA, developed many macros from scratch.
10. Tested and implemented in daily, weekly and quarterly reports, VBA code modules include loop functions such as for, if and implemented with arrays.

Experience

2-5 Years

Level

Junior

Education

BS

Description :

1. Analyzed financial data from external feed providers and created mapping logic to load feed data into the global financial database.
2. Coordinated and tracked the financial data collection procedure of data feed providers to ensure standardization of global financial data.
3. Project lead in the implementation and enhancement of new and existing data feeds.
4. Direct communications with external data vendors for data integration and on-going maintenance.
5. Worked closely with developers to enhance and maintain the quality of the product.
6. Researched and responded to financial data questions from internal and external clients regarding financial accounting concepts and feed-related technical issues.
7. Analyzed and suggested the improvement of financial data definition and quality.
8. Due diligence validation and testing of fundamental and equity issue data using SQL query performance.
9. Developed and organized training for special projects involving select financial data items.

Experience

10+ Years

Level

Consultant

Education

MS

Description :

1. Analyzed and reported actual operation performance vs. Plan and identify causes for variances.
2. Identified key indicator of cost-saving or areas where performance can be improved across the business.
3. Developed and maintained various financial models and standard templates distributed to use by whole finance team during the planning process, ensuring data accuracy and integrity.
4. Performed monthly balance sheet, income statement and variance analysis in financial position/budget.
5. Assisted client create stewardship reports in powerpoint on a timely basis to access expenses, order volume, pricing tiers, and order turn-around-time in charts, table, and graphs.
6. Improved productivity and operational efficiency by developing automated reporting/forecasting tools.
7. Created management dashboard/metrics in order to track and evaluate operational performance.
8. Provided ad-hoc reports and analysis as required to support management decision and strategic initiatives.
9. Responsible for monthly close activities, including journal entries, variance analysis, and reconciliations.

Experience

2-5 Years

Level

Junior

Education

MS