Edwin Aragon Email & Phone Number

Houston, Tx, Us

Houston, Tx, Us

Mattoon, Illinois, Us

Assisting in budgeting, forecasting, long-range planning, implementation and business strategic analysis for Access & COGS. Conducting financial analysis, modeling, forecasting, and reporting efforts to provide timely support to cross-functional operational teams.

Houston, Texas, Us

Primary responsibilities include managing and assisting with Corporate Main Office budgets, including Warehouse and Service departments. Building new financial models that tell the story of cost trends and new ways to estimate budget cost by department via data analysis with 3rd party software and data tables.Sr. FP&A & Finance Manager• Budget Planning & Forecast- Annual budget cycle, monthly reporting and quarterly re-forecasts, and long-range strategic planning efforts. Identify cost drivers for each GL and implement these drivers to enhance budget accuracy.• Financial Analysis- Prepare ad hoc analysis and financial models to help drive better decision making.• Financial Reporting- Create new reports and tools to assist in the management of business and implement/integrate new processes and software to maximize utility in reporting.• Budget Variance Analysis- Coordinate implementation of forecast creation, including use of historical and statistical methods, while incorporating actual versus budgeted and forecasted.• Financial KPI’s- Responsible for creating financial/performance metrics for Warehouse and Service departments such as Fuel Cost, Field Service Tickets, Maintenance Tickets, Auto Shop and more.• CAPEX Project- Assist with budgeting capital projects such as new store design, maintenance repairs, vehicle purchases.• Data Analysis/Data Modeling- Improve and enhance current/new reporting to maintain reporting accuracy and efficiency. Integrate 3rd party source data with financial to obtain cost driver detail.

Katy, Texas, Us

Sr. FP&A• Market Research & Competitor Analysis- Tracked and compared competitors Sales and EBITDA performance via Bloomberg.• Financial Reporting- Assisted with developing and building financial models, monthly financial overviews and quarterly dashboards for MoM meetings and Board of Directors.• Budget Variance Analysis- Coordinate implementation of forecast creation, including use of historical and statistical methods, while incorporating actual versus budgeted and forecasted.• Financial KPI’s- Responsible for the delivery of scorecards for business leaders. Maintain and publish KPI’s to ensure that financial objectives are met. Sr. Financial Data Analyst• ETL- Experience in working with large data sets and extracting data from difference sources to provide business partners with better insights.• Cost Variance Analysis- assisted with capturing annual cost savings for direct imports by tracking ROI on strategic sourcing initiatives, projects, and purchase orders.• Retail Sales Projection & Forecast- Assisted with MoM and Yearly retail sales projection and forecast for products. Monitored retail price points by measuring price standard deviation.• Vendor Performance Analysis- Tracked and provided insights on vendor performance based on quality control metrics and KPI’s.• Vendor Cost Analysis- Provided business partners with historical vendor cost analysis for cost negotiations overseas for all Private label products.• Vendor Quote Comparison Analysis- Created a model to compare vendor cost quotes in order to achieve the lowest cost during product development.• Product Performance Analysis- Tracked product performance based on product return analysis and defective return analysis.• Financial Reporting- Created high level financial summary reports that tracked, sales, cost, margin, and defectives for division VP’s to modify and enhance current business processes.• Dash Board Creation- Created dashboards with key metrics and measured COGS

Houston, Texas, Us

Primarily responsible for compiling statistical information and creating various reports for project related activities by extracting information from client-provided data. Create and maintain a statistical database and to ensure integrity of data for statistical analysis, resulting from project-work from Banks and Credit Unions.Responsibilities: -Interfaces with clients via telephone, email and WebEx to obtain and verify the integrity of data requested both prior to and during client projects-Downloads clients Income and Expense reports, General Ledger reports for analysis, or compiles from other sources, statistical information used to prepare graphs and various reports for product and project analysis.-Works with internal management and consultants to complete project work and maintain database(s)-Assists in the validation and tracking of client project results-Assists in the creation and maintenance of various templates and databases to advance the efficiency of project work.

Recruited by ex-Manager from Litton Loan Servicing. Role is to elicit, analyze, specify, and validate the business needs for delivering fee disclosure documents to Valic’s plan sponsors, while applying proven communication, analytical, and problem-solving skills to help support the development process, and to ensure that project deliverables are met according to specifications.Responsibilities: -Coordinated the building, testing, and deployment of application maintenance tasks and configuration changes. -Communicated changes, enhancements, and modification of business requirements – verbally or through written documentation – to managers. . -Developed and utilized standard templates to accurately and concisely write system procedures and department day-to-day procedures. -Analyze and verify requirements for completeness, consistency, compressibility, feasibility, and conformity to standards for IT department.

Repeatedly promoted during 12-month tenure with Litton Loan Servicing LLP; culminating in current responsibility for coordinating all department projects and supervising a team of 15 administrative professionals by delegating efficiently, and utilizing each individual's talents as a part of our team. Results:Developed efficiency-enhancing workflow/process improvements that made it possible to accommodate increasing responsibilities necessitated by staff reductions.Managed department projects that consisted of 20 staff members in processing 20,000 loans with a combined asset value of $7 million. Decreased project expenditure by 15% through implementing needed control in the areas of loan processing’s, standardizing loan ordering procedures, and meeting all project deadlines.Saved thousands of dollars in fees and improved the response-time with our direct outsource vendor.

Assisted clients with their health care accounts and filing of proper insurance claims. Contributed to increasing the company's assets through proper business ethics and work efficiency.

Master'S, Business Management And Administration

Bachelors, Political Science