Financial Analyst Data Analysis

GNANAVENI BALASUBRAMANIAN

San Diego, CA 310-***-****

*****.****@*****.*** https://www.linkedin.com/in/gnanaveni-balasubramanian-ba868877/ SUMMARY AND PROFILE

As an experienced Project and Program Accountant and Financial Analyst with over 5 years of service, I consistently meet strict deadlines and manage data with 98% accuracy rate. I've reduced data processing times by 30% through automation, enhancing efficiency, and improved data-driven decision-making, resulting in an increase in revenue for my organization. I've successfully analyzed datasets with over 1 million records, delivering actionable insights that streamline processes and boost profitability. My clear communication skills have reduced project completion times by 20% and increased data-driven decision adoption by 25%. I remain at the forefront of data analysis by attending 3 industry conferences annually, staying up-to-date with the latest tools and methodologies. I prioritize work-life balance and maintain a 100% compliance record in data handling audits. My goal is to continue delivering quantifiable data-driven solutions that drive business success. Core Competencies

Data Analysis: Proficient in data collection, cleansing, and analysis with a track record of delivering accurate and actionable insights.

Automation: Skilled in streamlining repetitive tasks and processes through automation, resulting in increased efficiency and reduced processing times.

Clear Communication: Effective at translating complex technical findings into understandable insights for both technical and non-technical stakeholders, facilitating informed decision-making. Continuous Learning: Committed to staying current with the latest data analysis tools and methodologies through regular industry conference attendance.

Compliance and Data Security: Maintain strong focus on data security and privacy, with 100% compliance record in data handling audits.

Skills

Earned Value Management (EVM) Billing Month End Close Out Accounts Receivable Account Reconciliation GAAP indirect Cost Allocation Forward Pricing Rates /Incurred Cost Proposals Submission Reporting : (IPMR),(IPMDAR) (EACs) SAP Change Requests Charts Presentation in Power BI Data Analysis Statistical Analysis Data Visualization Data Mining Machine Learning Database Management, Data Cleaning Data Modeling Data Governance Data Warehousing Predictive Analytics Data Security and Privacy Problem-Solving, Critical Thinking Project Management Communication Team Collaboration Continuous Learning Mentorship

PROFESSIONAL EXPERIENCE

Namaom Consulting Services : Power BI and power query Oct 2023-Present Work on budgeting and forecasting models :Small scale businesses.Business development sales projects based on the needs of the business - Small scale businesses.Sap projects. Principal Proposal Analyst, Northrop Grumman Corporation Sept 2019 – Sept 2023 Aeronautics Sector – Triton and Global Hawk Programs- Project Lead for Budget and Forecasting, Fund Monitoring,Invoice Processing and Financial Management

Experience in Government contracting and procurement for FFP, Time and materials, Fixed Price, Cost plus incentive fee, Cost Reimbursable contracts and CPFF contracts. Work with the close out invoice process for all contacts and provide training to the employees for the close out procedures for all types of contracts.

Worked on billings for Cost Reimbursable, Progress Payments, Fixed Fee and Time and Materials contracts and close out invoices with the budget analysts.

Record and review journal entries for the month end closing processes, Indirect rate and the forward pricing allocation entries, and preparation and submission of incurred cost proposals to the government.

Follow GAAP,CAS and FAR principles and standards

Advanced SAP experience in all business areas relating to billing, invoices, accounts receivables and accounts payables and the general ledger postings.

Supports and prepares documentation for audits .

Lead multiple projects in finance management administration, monitoring and tracking project costs for the program level and the sector level, month-end and year-end submission of forecasts and financial reporting and budgeting formulation and management.

Experience supporting full Earned Value Management programs with cost or schedule deliverables as well as Integrated Baseline Reviews (IBR)

Worked on calculating EAC every month to adjust gross margin adjustments. Used the following calculations to find out TCPI (to complete performance index ) TCPL(Target)= work remaining/cost remaining and calculate efficiencies CPI and SPL where CPI =BCWP/ACWP and SPI= BCWP/BCWS. Fav >1 and unfavourable is <1.0; calculation baseline execution index = Total tasks completed/(Total tasks on baseline finish on or prior to current report period*Tasks without baseline finish dates): EAC= ACWP +(BAC-BCWPCUM)/CPL CUM

MS Project scheduling experience in a high-tech engineering environment.- MS project scheduling experience and have change management,develop project documents such as activity attributes, activity lost, assumption log,basis of estimates, duration estimates,lessons learned register,milestones list,project schedule network diagrams,project team assignments, resource calendars, resource requirements and risk register.

Prior support of $20M+ Cost Plus programs.- Supported more than 15-20 valued $20M + Cost plus incentive fee and fixed fee contracts

IPMR/IPMDAR reports for submission to customers - Submitted Integrated Program management Reports and Integrated Program management Data analysis reports to the government as a project lead .

Creation of Work Authorization Documents (WAD), Control Account Plans (CAP), and Variance Analysis Reports(VAR)

Worked for a program sales volume of $250 M per year and analyzed three weekly reports and two monthly reports for program level presentations.

Worked with a team of 15 people in business management and with three program managers and acted as a lead for four projects( Grant funding, EAC,Invoicing and Forecasts and Budgets) simultaneously.

Trained cross-functional teams of 15 people, and provided support to them in troubleshooting processes.

Appointed as point-of-contact for invoice processing and trained and coached cross functional team members for the approval process and acted as liaison with Accounting and Finance divisions of the organization.

Accomplishments:

Developed and maintained various charts, enhancing data visibility and accuracy by 20%.

Improved delivery date adherence by 15% and on-time reporting by 25%.

Resolved 90% of invoice processing issues, reducing payment delays by 20%.

Conducted effective one-on-one meetings, resulting in 30% increase in issue resolution efficiency.

Contributed to 15% improvement in forecast accuracy through Material Base Forecast Tool.

Created Funding Memos(Purchase requisitions), reducing procurement delays by 10% and track orders and cost overruns by 5%. Earned Value Analysis such as SPI, CPI, TCPI, EAC and VAR.

Led cross-functional improvement initiatives, increasing project efficiency by 10% and reducing operational issues by 20%.

Presented charts that led to 15% improvement in parts delivery predictability and 10% reduction in financial discrepancies.

Skills/Tools Utilized:

Experience in Government contracting and procurement for FFP, Time and materials, Fixed Price, Cost plus incentive fee, Cost Reimbursable contracts and CPFF contracts. Work with the close out invoice process for all contacts and provide training to the employees for the close out procedures for all types of contracts.

Microsoft Office products experience - MS Word, MS Excel features such as advanced formulas, pivot table and slicers and other excel functions and MS Powerpoint skills.

Knowledge of FAR, ADS, FTR and other regulations and work with compliance department

Enterprise Resource Planning: SAP and SAP S4 HANA. Worked on invoice issues and resolving them in regard to posting periods and fiscal year changes; trained employees in cross functional teams for the procedures to approve invoices and Purchase authorization procedures.

Trained end users how to create the PR, PO, GR and Invoice.

Other responsibilities included: Creating the process documents; integration and application of financial management and information systems; production support for Accounts payable specifically for invoicing and invoice related matters.

AVCorp Industries Inc [Aerospace Manufacturing], Gardena, CA December 2018 - April 2019 Manufacturing Financial Analyst and Cost Accountant

Worked on three projects simultaneously and analyzed two weekly reports for forecasting and cash flow statements and sales volume of $100M project estimates. Worked on both government contracts and commercial contracts of various client sizes.

Enhanced financial analysis accuracy by 10% in monthly reporting to management.

Implemented cycle count procedures, reducing inventory shrinkage by 20%, streamlining inventory management. Reduced inventory discrepancies by 15% through accurate tracking of physical inventory/WIP.

Experience supporting full Earned Value Management programs with cost or schedule deliverables as well as Integrated Baseline Reviews (IBR)

Prior support of $20M+ Cost Plus programs.

Creation of IPMR/IPMDAR reports for submission to customers.

Work Authorization Documents (WAD), Control Account Plans (CAP), and Variance Analysis Reports (VAR).

Additional general duties: Led month-end and year-end closing entries,Indirect rate and forward pricing journal entries, improving financial accuracy and compliance; Worked on financial reports and audit policies and procedures.

Leadership Functions: Managed two accountants for Accounts receivable and Accounts Payable; Appointed as point-of-contact/liaison for external auditors of our company

Tools/Skills Extensively Utilized: Knowledge of FAR, ADS and FTR; FlexNet, Vision, SAP(General Leger upload and posting entries), and Crystal Reports for data-driven decision-making advanced Excel skills

(VLOOKUP, SUMIFS, Power Query, Power Pivot) for efficient data analysis. O’ Neill Digital Solutions [Printing Manufacturing], Los Angeles, CA Oct 2013 - Nov 2018 Staff Accountant and Cost Analyst/Billing Analyst

Managed bank transactions, created General Journal and Ledger entries per GAAP standards, and conducted Financial Statement Analysis for informed decision-making.

Worked on five simultaneous projects with three project managers and worked with two weekly reports and month-end reports for budget forecasting and analyzing the variances.

Generate customer billings and review billings for accuracy and send it to the customer.

Reconciliation of bank transactions and other accounts, especially prepaid accounts.

Accounts receivable duties : Enter all bank transactions into the system and apply to responsible accounts, run accounts receivable aging reports and collect the invoice amounts from the customers and provide excellent customer service.

Project cost tracking for different jobs, Cost estimation, Billing and analyze variance reports.

Supervised team of two Accountants, overseeing A/R, A/P, inventory, G/L, account reconciliations, and contributed to policy framing for plant accounting improvement.

Worked on terms and conditions of new proposals and creation of new purchase orders and work on procurement of receiving and consumption of materials. Worked with the contracts valued for $10M .

Led month-end and year-end closing procedures in compliance with GAAP, ensuring financial accuracy.

Provided valuable support documentation for external audits, assisting Assistant Controller.

Analyzed and resolved reporting issues, improving accounting operations and accuracy.

Proficient in MS Dynamics NAV and advanced MS Excel, including Power Query and BI tools for data analysis.

Travel and Transport, Inc - Omaha, NE June 2008 - August 2013 Financial Accountant

Managed the invoicing process, sending 40-45 invoices to managers for review and delivering bills to clients of various billings (10 clients - $2M in billing; 10 clients - $90k in billing, 10 clients - under $50k)

Project managed 15 small contracts and 5 big management fee contracts for corporate travel bookings

Analyzed 7-8+ reports weekly to finalize the charges of billing to customers

Collaborated regularly with Client Service Manager and clients, through effective communication and addressing inquiries promptly.

Built proficiency in Agresso and AS400, responsible for creating and verifying various reports, ensuring data accuracy and preparing invoices.

Worked on different types of contracts and responsible for all accounts from contracts sign up to the close.

Additional duties/responsibilities included: Executed general ledger entries in accordance with Generally Accepted Accounting Principles (GAAP) for accurate financial records; handled professional fee credit card processing, streamlining payment procedures; played a key role in making journal entries during the month-end closing process.

EDUCATION AND OTHERS

Madurai Kamaraj University, India

Bachelor’s in General Law.

Manonmaniam Sundaranar University, India

MBA. Commerce

Madurai Kamaraj University

BBA. Commerce

Accomplishments

● Improved financial accuracy and reporting through rigorous reconciliation and adherence to GAAP.

● Efficiently managed various tax types, minimizing liabilities and ensuring timely tax returns.

● Contributed to strategic business growth by providing financial analysis and creating business plans.

● Streamlined Accounts Receivable and Accounts Payable processes for error-free transactions and improved financial reporting.

Certifications

● Graduate Certificate in Project Management — University of California, Irvine - completed in 2023

● Certified Intelligence Professional Elite Level Certification — Academy of Competitive Intelligence - completed in 2023

● Certification in SAP FI/CO - completed in 2013

● Certification SAP Warehouse Management - completed in 2020

Contact this candidate