Data Analyst Financial

*SUMMARY OF QUALIFICATIONS:

Forward-thinking, personable, and results-driven professional seeking a challenging role where professional experience and strong interpersonal abilities can be applied to support an organization in achieving its goals. Competencies also include Category Insights, Strategic planning, procurement, pricing analysis, forecasting, financial and profitability analysis, and Project Management.

Strong analytical and problem-solving skills; demonstrated ability to communicate effectively across all levels of management; ability to multi-task and absorb information across vast products spectrum while adapting and excelling in changing environments.

PROFESSIONAL EXPERIENCE

SABIC, TX-Remote September 21-Present

Sr. Data Analyst

Transformed raw data into relevant insights using interactive and simple-to-understand dashboards and reports in powerBI

Implementing relevant HR metrics to determine the efficiency and impact of the workforce.

•Analyzing data and statistics for trends with regards to recruitment practices, motivation, turnover, and compliance with employment laws.

•Optimizing and implementing new data processes and systems.

•Compiling reports of data results and presenting these to senior managers.

•Analyze Headcount and Attrition and report any gaps

•Run analysis to understand company’s hiring process and any improvement needed as regards to recruiting suitable talents

•Migrated data from SAP via Excel into SQL & back into an in-house ERP system per requested

•Setup ETL to automate upload from Excel into SQL

•Strong SQL, SAP & Excel Experience.

Arcade Beauty, South Plainfield, NJ Oct 19-June 21

Senior Financial Analyst

•Track KPIs and prepare financial reports.

•Assists with budgeting and monthly close processes.

•Understanding key business drivers.

•Assists project teams with financial guidance.

•Develop financial projections and building financial models.

•Perform research and analysis as required.

•Analyze and report on end of month financial results/explain variance

•Run weekly Actual Sales report to track against budget

•Run weekly Actual pricing in ERP system vs Planned vs. YAG • Calculate monthly Actual customer rebate based on Sales target.

•Review and Analyze financial Statements.

Marcal Manufacturing Paper (dba Soundview Paper Company), Elmwood Park, NJ 2013- Oct 19

Trade Marketing Manager/Trade PRO System Guru

•Analyze and measure product/volume mix, and profitability by SKU and customer level.

•Partner with Field Team to develop trade spend budgets and promotional plans by customer; incorporate key insights from post-promotion analysis

•Engage in S&OP process to provide input, working collaboratively with cross-functional partners to improve forecast accuracy. Investigate fluctuations between the plan/forecast and actual sales trends

•Maximize BDF effectively by managing programs adhering to budget, analyze and provide insights into drivers of change for key metrics (e.g. gross sales, net sales, trade and profitability) versus prior year by customer and product

•Emphasis on Trade management maintenance to avoid spikes in Spend

•Reconcile and prepare monthly financial trade spend summary by channel for month end reporting and fiscal close

•Track sales monthly and report on significant changes against budget.

•Develop Net selling price profitability report to gauge profitability against company’s overall objectives.

•Continuous improvement of key metrics which impact cash (deduction aging) and reduces inefficient non-trade expenses (customer fines, logistics charge-backs, etc.)

•

Caswell-Massey LLC, Edison, NJ Jan 2012-Dec 2012

Financial Analyst

•Create and analyze monthly, quarterly, and annual reports and ensures financial information has been recorded accurately

•Conduct technical analysis and data mining activities to report on future and current financial performance

•Performs financial forecasting and reconciliation of internal accounts.

•Develops integrated revenue/expense analyses, projections, reports, and presentations.

•Analyze and resolve variances in financial results

•Perform loss control analyzes

•Used PeopleSoft in the preparation of General Ledger, Project costing and Cash management

UNIHIV-Michigan Nov 2009- Jan 2012

Financial Analyst

•Responsible for working with the director of operations and Accounting Services team and keeping them informed of UNIHIV’s financial status and ability to meet short and long term financial obligations as an NGO.

•Balance sheet preparation and reconciliation.

•Conduct Profit and Loss analysis

•Analysis of A/R and A/P accounts

•Assist in budget development and management

•Successfully planned and launched first-ever university-wide annual

•Preparing monthly financial reports and weekly status reports.

American International Group (AIG) Berkeley Heights, NJ. Mar 2008-Nov 2009

Actuarial Analyst

•Retrospective Analysis of accounts and policies in order to account for the financial losses during a policy period, and also forecast the future risk, premium and assessments

•Help develop insurance policies that insure policyholders against property loss and liability resulting from accidents, natural disasters, fires, and other events. They calculate the expected number of claims resulting from automobile accidents, which varies depending on the insured person’s age, sex, driving history, type of car, and other factors

•Conduct revenue and expense analysis, cost/profitability analysis, equity and asset analysis and also determine financial leverage (ratios).

•Preparing weekly compliance reports, and also create and analyze monthly, quarterly, and annual financial reports and projections

•Reconciliation of accounts using variance, trend analysis, financial forecasting.

•Perform data extracts from SAP (accounting system) for reconciliation of account

•Analyzed company’s financial position and performance using ROI, IRR, NPV, Net Pay back and TCO

•Used PeopleSoft to design and implement solutions to achieve optimal business goal.

Stryker Orthopedics/SQA Services NJ: Jan 2007-Dec 2007

Statistical Analyst

•Conduct statistical analysis to reduce and eliminate defects and Variance.

•Conduct system test to make certain any undetected error.

•·Review and analyze system design specification requirements to insure correct technical design

•Performed trending and analysis of incidents reports, analyze complex problems, interpret operational needs, and develop integrated solutions

•Responsible for hands-on execution and delivery of analytical solutions ranging from designing proprietary market research surveys, leading data analysis and modeling initiatives, to creating client presentations

•Used in depth knowledge of statistical process controls to assist in the Quality Assurance by developing statistical process control methods, and using results data to locate deficiencies within company’s manufacturing process.

EDUCATION:

New Jersey Institute of Technology, Newark, NJ

Bachelors of Science in Actuarial Science, Finance & Mathematics May 2007

Liberty University, Virginia, School of Business

June 2015

MBA

SYSTEMS:

Experienced in the use of SAP, VLOOKUP, PIVOT Table, CSPO, Solid WORD, OUTLOOK, GAAP, and SQL, XML Coding, MEI, VBA,

Excel Guru, R-statistical Studio, Qikview, Accumatica, Franconnect, Master Data, Bi Tools, CMS

Contact this candidate