Job Title : Customer Experience AssistantEntrusted with carrying out keen monitoring of designated premises using CCTV systems to pick up signs of threat and risks and warn the stakeholder well in time to safeguard life, property and premisesFamiliarize with the layout and coverage of a CCTV system in the assigned premisesPreserve footage, as per instructionMaintain confidentiality as per organizational procedureRecord and report events as per procedureScan and monitor premises as per site instructionsObserve irregular situations keenly , Anticipate threats/ risks and Respond to a security situationCommunicate with security person for the concerned designated premises effectivelyDetect suspicious activity/ perceive abnormal movements and generate early warningShould be proactively inform the concerned person if any threat is anticipatedJob Location : VadodaraShifts : Night shifts

Job Title : Sr. SQL DeveloperJob DutiesJob Summary:We are seeking a Senior SQL Developer with expertise in SQL Server, SSRS, SSIS, and Power BI to join our dynamic team. The ideal candidate should have strong experience in databases, SQL development, report generation, and data visualization. This role requires the ability to work independently while collaborating with cross-functional teams to deliver robust data solutions.Key Responsibilities:Work independently within a team and manage priority tasks efficiently.Collaborate with developers and stakeholders to translate requirements into innovative data solutions.Develop, optimize, and maintain SQL Server databases, stored procedures, views, and functions.Design and implement SSRS reports for business intelligence and decision-making.Develop and maintain ETL processes in SSIS for seamless data integration.Create interactive Power BI dashboards and reports, ensuring data accuracy and performance optimization.Work with various data sources, including SQL databases, APIs, Excel, and cloud-based solutions.Ensure data security, governance, and integrity across all reporting and database environments.Apply best practices in records management, information discovery, content management, and business process management.Required Skills & Qualifications:Bachelors Degree in Management Information Systems, Computer Science, or Computer Engineering.3+ years of experience in SQL Server Transact-SQL (T-SQL) development.Proficiency in SQL Server 2008, 2008 R2, and 2010 (configuration, maintenance, and development).Strong expertise in SSRS (SQL Server Reporting Services) for report generation.Strong expertise in SSIS (SQL Server Integration Services) for ETL development.Nice to have experience in Power BI development, including DAX, Power Query, data modelling, and visualization.Experience or excellent knowledge with Delta table format warehouse, one lake, Data pipeline, and Fabric solution.Ability to normalize relational databases and optimize queries for performance.Experience in writing complex SQL queries, stored procedures, functions, and views.Strong analytical and problem-solving skills with attention to detail.Strong communication and collaboration skills.Location : Vadodara (WFO)Timings : 2-11 PM

Negotiate business terms and letters of intent for the renewal of existing store leases Drive high occupancy cost savings through the renegotiation of leases Proactively manage a high-volume renewal pipeline in advance of critical lease action dates Develop and manage relationships with landlords, brokers, and development partners Develop and manage relationships with Prime internal partners in Construction, Legal, Lease Administration, Finance, and Store Operations Prepare Deal Memos and financial spread sheets for presentation to leadership for approval Maintain and update real estate document data base for all assignments Other duties as assigned Key Qualifications Bachelor s degree in business, real estate or related field Excellent written and verbal communication skills Strong negotiation skills and a proven track record of occupancy cost savings Strong organizational skills and the ability to work in a fast-paced environment with a high volume of annual real estate transactions Strong knowledge of retail leasing concepts, store PL analysis, lease clause interpretation Strong math skills Proficient with Excel, Power Point, and other Microsoft Office products

Invoice Tracking and Coding Monthly Variance Reporting Vendor Invoices, Follow-Ups & Payment Inquiries Vendor Permits & Dispatch Vendor Insurance Management Respond/ Make Conference Room and Amenity Reservations (Property Calendar & Reservations) Assist in Customer Move-In / Move-Out (Onboard / Offboard Customer) Assist in Make-Ready Cases Work Order Management Inspection Scheduling Equipment Inventory Customer Renewals Emails Any Ad-Hoc Requests from Property Manager Customer Updates & Letters Vendor Agreements and New Vendor Setup Property Inspections Service Request Response / Routing Profile New Warranty Profile New Permit Generate Work Orders Audit open Work Orders & Service Requests Schedule / Review Preventative Maintenance Review Service Contracts against Delivery & Invoices Spot-Check Invoices vs Work Orders and Contracts Follow-Up on Collections Investigate Recurring or Large Variances Search Alternative Vendors / Check Prices Review Service Utilization Review Work Orders for Pricing Opportunities Spot-Check Work Orders Spot-Check Online Inventory Review Property Inspections for Opportunities & Trends Reconcile Reserved Spaces with Current Customer List Generating & Reviewing DINK Reports Janitorial Spread Sheet Update Update Building Directory Sending Email To Vendors For Bid Collection Mailbox Assignment Cases Created Report Customer Alerts Email 3-day Notice to pay rent Work with the Property Manager on all aspects of Property Management Qualifications: Bachelor s or master s degree in operations, Accounting, Finance, or related field Minimum 1-2 years of relevant, hands-on experience

Drafting and Design: Create detailed technical drawings, plans, and schematics using CAD software. Prepare architectural, structural, mechanical, electrical, or civil drawings as required. Update and revise existing drawings based on changes and modifications. Collaboration and Communication: Work closely with engineers, architects, and other team members to understand project requirements and specifications. Communicate effectively with project managers and team members to ensure that designs meet technical and regulatory standards. Technical Documentation: Develop and maintain accurate and up-to-date documentation for all drawings and plans. Ensure that all drawings comply with company standards and industry regulations. Quality Control: Conduct self-checks and peer reviews of drawings to ensure accuracy and completeness. Identify and correct any discrepancies or errors in the drawings. Project Management: Manage multiple projects simultaneously while meeting deadlines. Assist in project planning and scheduling to ensure timely delivery of drawings. Continuous Improvement: Stay updated with the latest CAD software developments and industry best practices. Participate in training sessions and professional development activities. Qualifications : Education: Associate degree or diploma in Drafting, Engineering Technology, Architecture, or a related field. Bachelor s degree preferred. Experience: Minimum of 2 years of experience in drafting, preferably in an engineering or architectural environment. Proficiency in CAD software (e.g., AutoCAD, Revit, SolidWorks, etc.). Skills: Strong technical drawing skills with a keen eye for detail. Good understanding of engineering and architectural principles. Excellent problem-solving skills and ability to work independently. Strong organizational and time-management skills. Effective communication and teamwork abilities. Certifications: Certification in CAD software is a plus.

This is a full-time on-site role as a Property Accountant at Stemmons Business Services Pvt. Ltd. located in Vadodara. As a Property Accountant, you will be responsible for financial statements, journal entries, accounting, finance, and financial reporting. Your day-to-day tasks will involve analyzing financial data, preparing financial statements, managing journal entries, and ensuring accurate and timely reporting. Other responsibilities: Prepare Monthly Financial Reports Monthly journal entry preparation and uploads Financial statement preparation, review, and analysis Bank reconciliations (research and record outstanding cash items Maintain monthly schedules for recurring journal entries (Insurance, taxes, Depreciation/Amortization) Calculate monthly accruals for contract services. Record monthly mortgage payment (interest, principal, and escrow payments) Calculate monthly expense allocations between Mall and Tower Review entries for Partners Interest. Prepare supporting schedules for financial package. Analyze balance sheet accounts. Maintain schedule of prepaid commissions. Post financial reports in Internal portal and files. Qualifications Strong knowledge of financial statements, accounting, and finance Experience in preparing and analyzing journal entries. Proficiency in financial reporting Must possess M.Com / CA Inter / MBA Experience should be 3+ Years (Inclusive of Article ship) Additional qualifications that would be beneficial Previous experience in the real estate industry Strong analytical and problem-solving skills Excellent attention to detail

This position supports a US-based commercial real estate leasing team, focusing on document standards and reviews, reporting, and management of the lease approval process. This position will use Yardi Voyager for accounting purpose as primary accounting software. This position addresses tight deadlines and multitude of accounting of Accounts payable, utility invoices, utility project, vendor statement verification , Accounts Receivable , Cheque verification, statement downloading , profile set up, expenses report, Bank Reconciliation Statement, Lease entry, Collection process, any other USA accounting work and any outside work etc. Also multitude of accounting including depreciation statement , Fixed Asset tracker, New lease set up, treasury management , audit and any other work etc. Required minimum 1 year of experience in Accounting

Data Analysis and Reporting: Collect, analyze, and interpret financial data from various sources. Prepare reports, financial statements, and presentations for senior management or clients. Analyze key performance indicators (KPIs), financial trends, and market conditions. Budgeting and Forecasting: Develop financial models to forecast business performance. Assist in the creation and management of budgets. Provide regular updates on budget variance and suggest corrective actions. Financial Planning: Assist in long-term financial planning to ensure sustainable growth. Recommend strategies for improving profitability, cost control, and financial efficiency. Reporting to Stakeholders: Provide financial insights through various reports to stakeholders (onshore management in US) Ensure compliance with accounting standards and regulatory requirements. Present financial reports, highlighting critical findings and recommendations. Risk Management: Analyze financial risks and suggest strategies to mitigate them. Required Skills and Competencies Team leading: Manage & groom a team of Financial Analysts along with individual contribution. Analytical Skills: Ability to process large amounts of data and identify patterns and trends. Financial Modelling: Proficiency in building financial models to forecast future performance. Attention to Detail: Accuracy in financial reporting, analysis, and forecasting. Communication Skills: Excellent Communication skills for regular Interaction with an onshore team in US. Ability to present financial data clearly to non-financial stakeholders. Problem-Solving: Able to assess complex financial situations and recommend actionable solutions. Technical Skills: Proficiency in financial software and tools (Excel & office skills are must). Knowledge of Financial Regulations: Understanding of accounting principles and regulatory frameworks (USGAAP knowledge is an added advantage for the profile) Educational Requirements Bachelor s degree in finance & accounting , or a related field. Qualified Chartered Accountant with 4 to 7 year or MBA with 6 to 12 of relevant experience

Have the ability to work independently within a team and follow through with priority tasks Be creative with requirements set forth by the other developers Have the ability to work with all of the products within the Microsoft Office Product Suite Have a background in SQL Server development technologies Have a background in development technologies such as ASP.NET, Web Services, SQL Scripting, SharePoint C#.NET, ASP.NET, JavaScript, and HTML, JQuery Must be able to look at existing applications and develop Job Specifications Bachelor s Degree Preferably Management Information Systems, Computer Science or Computer Engineering majors Proficient with Microsoft Visual C# 2010 Proficient with ASP.NET Must be able to develop Silverlight solutions Javascript, HTML, JQuery WCF and ASMX web services Proficient with SQL Server 2008 and 2008 R2

This position will be provided various document files (PDF, WORD, EXCEL) with the task of creating new records within company database system and inputting property-specific details into our internal investment form. Applicant will also provide periodic progress reports and communicate regularly with the Acquisitions team. Additional tasks of obtaining market information, real estate investment details. Create new database records in company database system by inputting data from provided sources Evaluate assets with regards to the company s underwriting standards. Digitally store and organise due diligence. Check existing database for any update Provide weekly progress reports and regularly communicate with the Acquisitions Analyst All other duties as assigned Should have experience on working with financial data and have excellent attention to detail skills. Analytical thinker with research proficiencies as well as advance excel knowledge should be more preferable.