Sandeep Bansal Email & Phone Number

Gurugram, Haryana, India

Gurugram, Haryana, India

Gurgaon, India

• Managing operating leases across India and driving efforts in leading and managing operational risk of the portfolio• Supervise Other Income Source from Food Court & Leisure Business• Review financial and health of properties and provide regular inputs to the Top Management• Ensure cost improvement in rental profile of the business• Manage relationship with owners/mall management of operational properties• Address all asset related challenges in coordination with Landlord/Developer & cross functions in a timely manner.• Ensure timely lease renewal / extension /attornment• Identify and manage optimum utilization of leasable space• Support renovation / re-branding / special projects

Gurgaon, India

• Led property acquisitions in designated markets• Managed all property acquisition functions including analyzing & reviewing each new project in terms of financial, real estate, market, customer experience, etc. to ensure build-up of a qualitative pipeline in a Greenfield Market• Key player in analysis, development and implementation of strategic business plans & policies and contributing significantly in developing and delivering country portfolio aligned with business needs• Conducted RE Analytics for 100+ Cash & Carry and 500+ Retail Format stores by preparing & analyzing detailed project reports ensuring zero errors• Responsible for structuring & drafting of all allied documentation around the real estate transaction including ATLs, lease deeds, agreements, and other important documents• Managed more than 200 properties across India and drove efforts in leading and managing the operational risk of the India portfolio• Managed sub lease income portfolio of the retail business providing additional income with complimentary offerings to Easyday customer and increase footfall at stores• Formulated & assisted management on implementation of 5 Year Plan, Annual Operating Plan & other regular business updates• Presided Real Estate Committee Meetings comprising CEO/President, Real Estate Head-Walmart International & India Leadership for Real Estate approvals• Meticulously handled large lease/purchase transactions along with supervising all real estate payments related to security deposit, advances, rent, brokerage and all consultants’ payments• Guide, control and motivate team of 4 direct associates and more than 50 indirect associates, across different levels in Real Estate team • Acted as a chief liaison and SPOC between Walmart India (Franchisor), Bharti Retail (Franchisee) and Walmart International for all business purpose, compliance, process, procedure

Gurgaon, India

- Successfully opened 228 Retail & 20 Cash & Carry stores across India- Executed 4 different solutions across 7 verticals for Real Estate Global Technology Program- Lead manager for transition of Walmart’s Real Estate automation program - Headed Foreign Corrupt Practices Act (FCPA) Compliance program for Real Estate Function in Walmart India and highlighted gaps in few projects, saving Walmart from Business and Reputation Risks from these projects- Led successful transition of Real Estate function for Bharti and Walmart India- Awarded with “My Team Award” for demonstrating outstanding cross functional team work in Jun 2011 & Jan 2012 and received Certificate of Appreciation for excellent team work in 2010 & 2011

Gurgaon, India

Policy & Procedures:₋ Identified & implemented revisions to the policies & procedures governing the Walmart International & the Franchisor & JV Company Development Process as required₋ Assisted the Walmart International Manager of Administrative Controls in Performance of Compliance Audits for Store Development projectsReal Estate Committee Meetings & Preparation:₋ Reviewed financial aspects of all deals submitted for consideration to the above referenced RE Committees before presentation and approvals₋ Create & update the Agenda & IRR models used by all India Franchise Organizations for presentations of new store projects₋ Support the different Franchise teams, VP of Real Estate, India (Emerging Markets), SVP International Development, & International Executive Team on an as-needed basis by providing financial analysis of projects & proposals given various real-estate deal structures, varied operating assumptions, & lease buy-out opportunities₋ Development of additional systems & reporting to further streamline building integrity into the operating assumptions for various RE Committee presentations₋ Conduct Training of RE Managers, Development Directors, & Finance Support Team in India on Agenda / IRR completion & theory, Policies & Procedures, & REC Preparation processReal Estate projects developed under the Franchise Agreement & Joint Venture Agreement:₋ Monitor India project plans for compliance with approvals from International, Franchisor & JV Co Real Estate Committees₋ Work to minimize Walmart risk by holding Joint Venture & franchise partner accountable for performance₋ Provide oversight of & direction to Walmart Joint Venture & Franchisee coordination associate.₋ Responsible for development & audit of annual departmental budget₋ Ensure that the Administrative Control Group publishes regular monthly reports with assistance & oversight in completion of Annual IRR Reconciliations

Gurgaon

Started as a Senior Executive in May 2005 further worked as an Assistant Manager in Finance, and later positioned as a Deputy Manager for Finance in Apr 2007. I executed financial planning and processed project & working capital appraisals towards long/short term funds requirements through banks & financial institutions. Ensure optimum utilization of available funds towards the accomplishment of organizational objectives. Successfully liaised with banks & positioned funds to meet working capital requirements and executed plans for annual budget, comparing with actual & making variance analysis, recommending course corrections if required. Prepared variance analysis & statement of cash flows for internal/external reporting and provided financial overview & leadership for all major operating activities including development of business/profit plans. I prepared the profit & loss account and balance sheet and structure annual operational budget and implementing control measures to contain expenses within defined limits. Oversaw the planning, developing & implementation of short/long term plans, secured management approval for deal structuring & priced real estate transactions in coordination with Marketing Team. I solely managed organization restructuring including mergers/acquisitions, new company formation, sell offs, SPVs, ISO certification and PE. Acquired a company with Rs.350 Crores project valuation in 2 days and instrumental in setting up Paras Twin Tower, Paras Downtown Square and Paras Panorama. I smoothly completed ‘Paras Downtown Center’ for revenue recognition, contracts & financial closure & successful operations of the project.

Kolkata

- Accounts Receivables, Payables, Projects and other accounting- TDS, WCT working including filling of returns and MIS preparation- Finalizing Account up to Trial Balance- Banking Affairs- Company Affairs (ROC) matters. Assist CS in completing listing formalities on stock exchange.- Cost, Budgeting and Cash Flows- Statutory Audit- Supervise Accounting software implementationThis was my first corporate job. I joined Park Chambers Ltd. (old name) in May 2001 as Finance Executive in the Accounts & Finance Function. I managed Book Keeping and accounts of the company and project accounting for projects named ‘46D JK Millennium Center’, ‘Santosh Gardens’, ‘Basil Heights’ and ‘8 Ekdalia Road’. I raised monthly rent bills for ‘Park Plaza’ and ‘White House’ properties. I was instrumental in supporting accounting software team that was responsible to support core team of IT to identify opportunity, guide in terms user interface and business requirement, testing, reporting and pilot launch.I managed all direct and indirect tax deductions and payments like TDS, WCT, etc along with filling of returns and MIS preparations. I finalized accounts up to trail Balance. I supervised banking affairs shared cash flow statement on daily basis with senior management. I also did cost and budgeting along with preparing fund flow statement for managerial decisions.I assisted in internal, statutory and tax audit of the company.

Kolkata

• Statutory Audit of Banks and Company• Internal Audit• Taxation• Banking Affairs• Company Affairs like company formation, writing and keeping minutes of meetings and all Registrar of Companies related assignmentsI started my professional journey in July 1999 with this Audit firm as Audit Assistant. The idea was to gain on-job training while pursuing my Company Secretary Course. I did Bank Audit in Bihar and Bengal along with Internal, Statutory and Tax Audit of Manufacturing and other firms. While conducting auditing of second branch (of my career) in Bihar, I was able to identify difference in provisioning of bank interest that got highlighted at branch and my firm. I was responsible for preparing tax returns of individuals and corporate along with their financial statements. I was also responsible for daily banking affairs. This assignment also gave me opportunity to hone by computer skills. On the job, I learned Tally software and managed bookkeeping for the firm. Being Company Secretary Student, I took up complete responsibility of all Company Secretarial work of the firm and its clients. I was involved in company formation, writing and keeping minutes of meetings and all Registrar of Companies related assignments including filling of returns and statutory forms.

Mba, Finance, 8.16/10 Cgpa

Activities and Societies: Member of the Blitzkreig (Annual Fest) during MBA.1st year Summer Internship at Center for Monitoring Indian.

B.Com (Hons), Commerce

Higher Secondary, Commerce

Activities and Societies: Participated in cultural event on Diamond Jubliee Celebration

Secondary, Not Applicable

Introduction Leaders Program Graduate, Personal Training & Development

Activities and Societies: Curriculum GraduateCurriculum Graduate and Introduction leader along with assisting in production, registration.

Master Of Business Administration - Mba, Finance, General, 8.16 Cgpa