Chris Valcarcel Email & Phone Number

Los Angeles Metropolitan Area

- Lead reports integration from IBM Cognos Analytics to Excel by replicating the Integrated Financial Accounting System (IFAS) process and implementing automation with BI.- Supported a $100M+ program with financial reports/modeling and tracked Awards, Sales, Operating Margin, Cash Reserve, ROS/ROC and EAC/ETC.- Constructed Financial charts to provide visibility across the Business unit and its subcomponents. Collaborated on training staff on IBM Cognos and how to input data for their program at the lowest level.- Created 2 Financial model tools with BI that tracked financial metrics at the Business unit, Organization unit, Major Program, and PNID level. Briefed the tool’s utility to our Comm Systems Director and it is on track to be used at BU level.

Redondo Beach, California, United States

- Collaborated in creating a Pricing and Negotiation tool with power Query/Pivot. The automated tool provides visibility across the financial lifespan of any proposal and its negotiation process. This reduced compiling and data size and proven beneficial across P&E and engineering team- Lead proposals (CROMs, ECPs, REAs) by collaborating with estimators and providing pricing analysis for each IPT lead- Created an Excel tracking tool with Power Query/Pivot for deescalating cost estimates, Standard WBS and control account mapping- Supported CEAM team by updating classified statistical charts and providing analysis regarding Cost Estimating relationships- Calculated TER (Test Equipment Rental) and ODC (Other Direct Costs) factors across Space Division and restricted program

Redondo Beach

- Managed $36M NCTA portfolio for Communication Systems Business area by running weekly and monthly reports, monitoring budgets, updating forecasts, and compiling monthly variance explanations.- Coordinated with PIs and Directors regarding time-phasing and EACs for NCTA projects- Managed RT&S LRAP Staffing workbook by updating actuals, target awards, staffing levels and coordinating with project leads regarding their employees’ SOW. Additionally, I improved the structure and updating-process on the workbook.- Created an automated Active Contracts Excel workbook that tracked contract award, cost, budget, headcount, etc with Power Pivot and Query. Reduced data-compiling time by connecting reports from SAP Business Warehouse and Access.- Built a Material Estimate and Cost (MEAC) automated file with Power Pivot/Query and Analyzer web. It is constructed with a Master Cost Element Material only list and DAX formulas to track ETC and ACWP- Implemented new tools on Excel such as a Directory using macros and retrieved reports with Power Pivot/Query

Manhattan Beach, Ca

- Lead the MBVG training program for new employees.- Completed Optical Dream training and achieved high-level expertise in customer service.- Administrated patient accounts tin the billing department which facilitated data transferring.

Bachelor Of Science - Bs, Accounting And Finance

Activities and Societies: - Financial Management Association member - Junior Mentoring Program Mentee - Corporate Mentoring Program Mentee.

Double Associate’S Degree, Business Administration, Behavioral Sciences

Activities and Societies: Math, Engineering and Science Achievement Program member