***** ****** ****.

El Paso, TX *****

Mobile.- 915-***-****

E-mail:

ad1lro@r.postjobfree.com

Daniel Isaac Valenzuela Calvillo

Objective

To develop my personal and professional skills by performing in a challenging and rewarding position in a growth-oriented organization expecting to diversify my responsibilities in finance and business administration utilizing both my technical and managerial abilities. Areas Of Interest

Finance, Administration, Accounting, Costing and Pricing. Education (2002-2006) Universidad Autonoma de Ciudad Juarez (ICSA) Bachelor Degree in Accounting

Skills

Excellent management of MS Office (Proficiency in Excel)

PLEX (Classic and UX), OneStream, HFM, SAP, SAP's SRM Tool, BPC, Business Objects, MFG Pro, QAD EE, Hyperion and Lotus Notes, CMS, JE Edwards, Knime and Tableau.

Strong administrative and accounting skills.

Teamwork oriented.

Focus on goal completion and results driven.

Ability to work with different cultural backgrounds.

Customer service focused.

Fully bilingual (English-Spanish).

Relevant Experience (May 2022 – To date) Seagate Technology. Sr Analyst- Corporate FP&A

• Revenue and COGS planning/forecasting/reporting.

• Close partnership with other functions as needed to Design, Build and Maintain all required systems, tools, methods, and processes to enable the capture and compilation of actual, plan and forecast data to support two key CFP&A led planning and forecasting workflows; Quarterly Plan-of-Record (POR) and Weekly Outlook (Flash).

• Support and participate in the creation and publish of presentation materials used in various forums, including senior executive level meetings to review, inform and influence actions and decision making related to the formation of corporate level financial plans and in- quarter execution.

• Development of custom Knime workflows to process large amounts of data in to condensed reports for internal customers.

• Quarter end Reporting and Reconciliation.

Achievements:

- Development of COGS tracker with ability to reconcile outlook vs actual and forecast.

- Successful transition to SAP.

- Translation of prior reports to new models including updated sources and consolidated databases.

(May 2021 – May 2023) Woodbridge Group.

Plant Controller

• Month End close.

• Daily KPI reporting (Scrap, Material usage, Labor trends, Overhead expenditure).

• Management of 3 P&L’s

• AR/AP management, review, collection and tracking.

• Yearly Budgeting.

• Monthly Forecast.

• Standard Cost Roll and revaluation.

• Supervision of accounting team (2 Sr. Accountants and 1 Clerk).

• Profit Margin analysis by customer and program.

Achievements:

- Implementation of a daily sales and expense tracker.

- In conjunction with the process engineering team developed a method to forecast hours worked per department and reconcile them vs actual to identify areas of opportunity and drive overtime.

- Successful budget for FY22 with proper backup and analysis.

(October 2018 – February 2021) Shape Corporation.

Sr. Senior Cost Accountant / Plant Controller

• Month End close.

• Weekly KPI reporting (Scrap, Material usage, Labor trends, R&M)

• Engineering Change Reviews.

• Yearly Budgeting.

• Quarterly Forecast.

• Standard Cost Roll and revaluation.

• Profit Margin analysis by program.

• Plant Controllable expense tracking.

Achievements:

- Companywide record on Scrap by aggressively tracking and assisting the production and Maintenance teams.

- Decrease the sales adjustments errors from shared service in Europe by 80%.

- Repair and Maintenance levels kept to budget after years of misses.

- Weekly track of Material content variations by program report implemented in the US division.

- Changed the standard Overhead calculation process from a divisional approach to a plant to plant basis to ensure proper performance costing.

- Budgeting process trainer for the Mexico division.

(July 2014 – August 2018) Johnson Controls / Yanfeng. Sr. Financial Analyst / AFM.

• Management of the Mercedes 251 program from assignment to end of production.

• Service parts quotation with a profitability mind set.

• Capital appropriation requests generation, and approval submission for new tooling equipment.

• Tooling recovery negotiations with customer both in new and refurbished equipment.

• Discrete invoice generation and collection tracking (LTAs, Capacity increases, Misc. negotiations).

• Pricing maintenance support (Price updates, discrepancies resolution, bump charts, trends and profitability analysis) for the three main European business units; Mercedes, VW and BMW.

• Pricing retro analysis, generation, proposal and resolution.

• Business unit AR management in a transitional environment from SAP to QAD EE.

• Cash application process improvement initiatives for teams dealing with several systems at the same time.

• Intercompany balance reconciliation assistance.

• Company administrator for customer 2 different customer portals and 6 different plants. Achievements:

- Completion of pay as used inventory control in Cottondale plant.

- Consolidation of more than 50K AR aging lines for Mercedes (92% of open AR).

- Resolution of unapplied cash balances in excess of 10 million dollars bringing the AR aging to current levels.

- Successful migration of PMSC and McCalla plants from SAP to QAD without any significant financial impact.

- Successful collections of 85% of outstanding discrete invoices.

- Timely customer price retro offsets with internal adjustment documents.

- 3 consecutive years of intercompany activity without out of balances

(November 2010 – July 2014) JCIM- Grand Rapids

Assistant Controller.

• Supervision of plant buyer.

• Budget review.

• Forecast analysis along with data entry in to BPC and subsequent reporting.

• Fixed Asset management. (Capitalization from CIP, transfer, sale and disposal).

• Finished goods costing track and update. (Data gathering, Routing, STD-UNFR push, final standards analysis and change rate review).

• EQU Track and review.

• Month end journal entries (Analysis on both permanent entries/ reclassifications and reversal accruals, posting and follow-up)

• Month end Balance Sheet GL, Ship to Bill and Sales reconciliations.

• Buyer skills, Purchase order requisition and approval.

• Daily key metric track. (Sales, Scrap, Labor, Cycle Count gain/loss).

• Account Receivables assistance (Misc. Deductions on payments, unidentified items in payments)

• Physical inventory assistance (Audit, count, tag capture and final balance analysis)

(January 2006 – October 2010) Johnson Controls Inc.- AENA SSC Accounts Receivable Analyst / Supervisor.

• Supervision of a team of 5 analysts.

• Provided support for accounts receivables activities transition from SSC Juarez to BBC Europe.

• Implementation of initiatives aimed to improve the performance of the department (IE. Cash Receipt tracker-CRT, Accounts Receivable Optimization Initiative-AROI)

• Self-bill discrepancy tracking and resolution.

• Perform account receivables collection, cash applications and unapplied amount analysis.

• Past due monitoring to ensure the goal was achieved and when possible surpass it.

• Month end analysis on General Ledger accounts end balance, posting and record archive for audit purposes.

• Identification, research, and resolution of receivables issues. (Customers facing chapter 11, discrete collection, billing and payment terms setup)

• Provide service for North America and Mexican plants as well as SSC departments.

• General knowledge in accounts receivable and banks departments. Member of United Way: Fundraising for different activities such as buying school supplies, shoes, birthday parties for orphans, or other children in need. Also raise awareness in JCI/YF of all people in need within our community. SSC Newsletter: Responsible to spotlight Accounts Receivables accomplishments, goals, social events and goals as wells as other important subjects of the department.

Contact this candidate