Sayan Banerjee Email & Phone Number

Wilmington, Delaware, United States

As a Financial Planning & Analysis Intern at The Siegfried Group, I support the forecasting process and KPI maintenance, collaborating across departments to ensure accuracy. I am learning to provide critical insights on financial health and growth projections of the organization, helping the executive team make informed decisions. My work contributes to strategic planning and the company's success by delivering timely, reliable financial information. Through this role, I'm gaining valuable experience in financial analysis and cross-functional collaboration.

United States

• SLASHED stock analysis time from 3 to 1.5 MINUTES using YFINANCE library and CORR() function in PYTHON for NON-CORRELATED stock selection, improving portfolio diversification.• Developed PYTHON program analyzing 100,000 investment fund allocations across 3 STOCKS, determining optimal proportions for HIGHEST POTENTIAL RETURNS with LOWEST RISK.• Designed FINANCIAL FORECASTING tool in PYTHON, simulating 1000 scenarios of REVENUES and COSTS to PREDICT EXPECTED GROSS PROFIT and range, presenting results via HISTOGRAM.• Created dynamic INCOME STATEMENT in EXCEL updating GROSS PROFIT, EBITDA, and NET INCOME for 14 CLIENTS, 16 BRANDS, 9 PRODUCT SIZES using GETPIVOTDATA and SLICERS.• REDUCED analysis time from 40 to 25 MINUTES with EXCEL LOAN-REPAYMENT TRACKING SCHEDULE breaking down monthly payments into INTEREST CHARGES, PRINCIPAL REPAYMENT, and RESIDUAL DEBT.• Performed 50-YEAR FINANCIAL ANALYSIS in EXCEL, comparing CASH FLOWS FROM OPERATING ACTIVITIES against 5 INDUSTRY COMPETITORS using REGRESSION ANALYSIS for trends.• Used WINDOW FUNCTION, LAG, and CASE STATEMENT in SQL to generate 5-DAY MOVING AVERAGE returns for 20 STOCKS, flagging recent price changes.• Coded EXCEL VBA program with INPUTBOX FUNCTION to sort 10-YEAR monthly marketing cost data by LOCATION or COST CATEGORY in DESCENDING ORDER.• Projected EBITDA changes due to REVENUE, VARIABLE COSTS, and OPEX fluctuations for 2 CONSECUTIVE YEARS using EXCEL's BRIDGE CHART.• Self-taught PYTHON STOCK TRADING PROGRAM signaling buy/sell based on 3-DAY MOVING AVERAGES for 9 STOCKS, tracking profit/loss for $1,000,000 investment.• Boosted member engagement explaining EXPENSE LEDGER using birthday party analogy: INCOME CREDITS as arriving friends with gifts, EXPENSE DEBITS as leaving friends, BALANCE as sleepover friends.

Kolkata , India

Achievements: -• MENTORED audit interns on identifying and retaining evidence in the absence of the department head for 2WEEKS.• DETECTED ROYALTY OVERCHARGE worth $ 51,967 after researching and applying rules of ASC 606 on royalty income recognition.• FACILITATED improvement in decision-making to the appropriateness of corrective action over spare parts quality assurance within 4 DAYS through ROOT CAUSE IDENTIFICATION of product dimensions falling outside tolerance limits.• COMPLETED a 15-PAGE long professional audit report detailing findings and interpretations in a span of 3 DAYS.• INFLUENCED foolproof financial practices by initiating SUBSTANTIVE TESTING of purchase invoices against 100 REQUISITION ORDERS.• ELICITED assistance from non-compliant client personnel facilitating cooperative correspondence within 1WEEK.

Master Of Business Administration - Mba, Business Analytics

Master Of Science - Ms, International Financial Analysis

Master'S Degree, Accounting And Finance, First Class

Bachelor'S Degree, Accounting And Finance