Hemant Shah Email & Phone Number

Bengaluru, Ka, In

Bengaluru, Karnataka, India

Bengaluru, Karnataka, India

Responsibilities:● Setting up a team of Yardi Professionals in India.● Support Property and Investment Management requirement across APAC, EMEA and USA region.● Leading the custom reporting team across the 3 regions by using YSR, Columnar/SQL and Custom templates.● Identifying and driving effective and efficient processes.● Involve into a data integration project (upstream-downstream).● Defining Data Standards, Governance around the data quality and reporting exceptions pro-actively.● Partner with several stakeholders like Internal Risk & Control team, Business, Asset Managers, Controllers, Operation teams, Property Management Company, Accounting Vendors and Auditors.● Conducting Yardi Training for above Stakeholders.● Responsible for any Enhancement and Technical Developments, Risk and Security Assessments.● Liaison with the team for their Career Development needs, training and Performance Management.● Productivity and Capacity tracking for Management reporting.

Hyderabad, Telangana, India

● Managing team of 10 team members spread across Hyderabad, Chennai, Warsaw, Bucharest, New York and Los Angeles.

India

Part of Digital and Technology team (Yardi) and responsible for work management of Report developers and Ops team spread across Hyderabad, Warsaw, Bucharest, New York and Los Angeles.● Establish best practice standards for databases, process, tools and methodologies.● Advisory role for data integration project, defining data governance and standards.● Documenting project requirement/maintain play book, project coordination, execution, continuous status update and closure of project.Tools: ServiceNow, Azure Dev Ops, Jira tool, Yardi Voyager, Client Central, SQL Server, PowerBI and Alteryx

Bengaluru, Karnataka, India

Alternatives - Global Real Assets Tech Ops and Data Governance support.Active role in MRI to Yardi migration.● Lead Tech-Ops support for USA, Europe and ASIA region from Bangalore location.● Migrated function for Global Real Asset processes from NY to Mumbai office in Year 2007.● Acted as a technical business analyst for MRI Software to Yardi migration and setup of internal analytical tool for Alternatives Global Real Asset team.● Strong in MRI Software table structure, SQL queries and creating new reports or troubleshooting existing ones.● Act as a product SME and partner with internal technology team on various strategic initiative.● Involves in conducting business requirement session, documenting project requirement/maintain play book, project coordination, execution, continuous status update and closure of project.● Partner with internal business team, technology team, operation team and third-party vendors and various property managers for stakeholders’ operational needs.● Provide guidance or directly work on resolving users troubleshooting queries on Yardi Investment Management (Commercial and Multifamily database) and InvestorPlus. ● Ensuring data integrity of various applications used for reporting by designing rules to check any gaps pro-actively.● Manage upstream and downstream data feed for Yardi.● Identify and drive process re-engineering and automation with the help of either Yardi or Intelligent Automation tools like Xceptor, Alteryx, MS-Access and MS Excel VBA.● Review of project charter, scorecard, identifying any risk in process, maintaining productivity and capacity tracker.● Responsible for staff performance review, training, development, onboarding & offboarding.Tools: SQL Server & MS-Access for querying, MRI – Real Estate Property Management tool, Yardi Voyager Commercial and Multi-family, Investor Plus, Client Central and JIRA tool for story writing.

New Jersey, United States

Mumbai, Maharashtra, India

Involved in 2 data audits for data warehouse migration. (Oracle-Teradata & Teradata-SybaseIQ)Worked with ICICI Bank BIU-Data warehouse Department for enabling the data to enhance ERV (Existing Relationship Value) of the customers (UPSELL & CROSS - SELL), acquire new customers through campaigns and facilitate the generation of a variety of MIS reports & regulatory requirement. Tools used: RDBMS – Oracle, Teradata V2R5, SQL Server, Foxpro, Sybase IQ & MS-Access Other application and utilities – SAS, Clementine, CM3, TPump, FastLoad, MLoad, FastExport, BTEQ, Queryman/SQL Assistant, Statistic wizard and Visual plan