Prasanna Aditya Varma Alluri

Portfolio Quality Management

• Conducted regular audits to ensure compliance with company policies of 20% variance in dual valuations for 100+ residential/commercial/industrial/specialized collaterals of BBG-EEG segment for 3 quarters
• Oversaw categorization of lending in prime/sub prime and outskirts of Hyderabad city for 12 months
• Revalued and assisted review of 42 NPA & Regular delinquency accounts for 2 quarters

Transaction Resolutions

• Delivered swift response to 100+ valuation queries, concurrence on fair valuations to Credit & Business Banking of AP & TS.
• Drafted and assisted concurrence for 4 100 Cr> Working Capital & Multiple Banking Consortium cases (School, Industry, Hospital & Office Park)
• Interacted with credit/business on retail banking assets related to acceptance of collaterals & consulted with peer tech heads, appraisers and professionals on market practices in industry
• Served as primary point of contact for technical support issues, resolving valuation disconnects quickly to minimize turn around time for credit team.
• Established positive work environment by addressing any escalations for Business teams.
• Fostered open communication channels to valuation vendors in meetings to resolve conflicts with one bank approach

Monitor Real Estate Trends

• Drafted and assisted publish of monthly newsletter with updates about industry trends, regulations and notable transactions for 12 months
• Updated and published Annual Bluebook for Hyderabad & Vishakhapatnam with property rates of 343 locations (Residential & Commercial Lands/ Office, Residential-Commercial shop rates)
• Captured and maintained transaction references, property listing quotations, sale data from real estate agents

Technical Trainings

• Coordinated technical training and professional interactive (physical/online) sessions with credit & business teams on basic technical terminologies & property marketability issues
• Assisted and conducted 15 interactive training (physical/online) sessions with valuers on income approach, mortgage acceptance guidelines, collateral policy, site inspection remarks and appraisal report quality
• Organized, moderated & published minutes of meetings for 5 interactive training sessions to internal/external stakeholders (Credit, Ops, Business, Valuers & Central team)

Pro-active Strategic Changes & Control

• Assisted in implementing central guideline to mandate income approach for specialized collaterals.
• Reviewed policies within scope of property manual & regional building by-laws to lower acceptance complexities
• Collaborated with central team on system integration of collateral related home loan processes in workflow charts of Project exception approval master sheet, scenarios and rejection templates.

• Worked on Lease Rental Discounting, Loan Eligibility Calculations, and Repayment Schedules for Warehouse of 4 lakh Built-up-area.
• Assessed Leveraged/ Un-leveraged Cash Flows, IRRs of Project, Equity, and Acquisition
• Calculated Warehouse Project Purchase Value, Project Exit Revenue, and Sensitivity Analysis
• Prepared Construction Cost Schedule, Payment and Finance Repayment Schedule for proposed conceptual High-rise residential project.
• Developed Project Financing for Joint Venture, Private Equity, Pre-sales, and Hybrid models for proposed conceptual High-rise residential project.
• Analyzed Project Profits and IRRs of all financial models of proposed conceptual High-rise residential project.

• Conducted end-to-end market research through primary and secondary research methods on Real Estate Market in Hyderabad
• Gathered data on competitors to analyze prices, sales and methods of marketing and distribution.
• Summarized sale value of all upcoming, ongoing residential projects of Top Real Estate Developers in city in 2021.
• G+2 Villa structure site planning & execution observation.
• Analyzed reading of structural and architectural drawings of G+2 Villa.
• Tracked key metrics of project type, location, units, floors, price per sq. ft and built-up-area to develop spreadsheets and data models for 25 Real Estate Developers in city.

• Thoroughly understand the production, operation, distribution, route optimisation and marketing of Sid's farms dairy products.

• Conceptualized and re-designed the complete pictorial distribution network of the firm to gain insights of the complete day to day supply chain process