Sandeep Gurram

Experience

• 

  IBSN India Pvt Ltd

  Jan 2009 - Jun 2009

  Tax Analyst

  • Analyzing the taxable income of individual• Preparation of tax returns• Providing feedback to the client regarding his returns• Providing Publications Information to the client to support him at the time of inquiry by the tax departments

• 

  FactSet Research Systems

  Jul 2009 - Mar 2011

  Research Analyst

  • Collation of Key series of different economies• Quality Audit of work done in between the Analysts• Interaction with the Product development team to ensure that the information is up to date• Preparation of quality reports on Monthly Basis• Prepared Training Manual for new hires

• 

  Thomson Reuters

  Feb 2011 - Nov 2013

  Senior Tax Associate

  • Analyzing the value of the Commercial Real Estate Property• Recording and analyzing Assessment Notices and Tax Bills issued by the Jurisdiction• Preparing and Keeping a track of Appeal documents• Preparing of Fund Request Report for clients to have bird’s-eye view on their payments

• 

  Ryan India Tax Services Ltd.,

  Nov 2013 - now

  Tax Specialist

  • Act as liaison between Hyderabad and US & Canada by assigning work to the team and ensure that all the assigned projects are completed within the deadline with the desired quality.• Adherence to the Service Level Agreements – productivity, turn-around-time, and accuracy• Update Manager on process performance and critical people issues.• Develop multiple tools to automate several internal tasks using VBA Script (Excel & Access).• Data Cleansing, Slicing and Wrangling/Munging with R for Analysis.• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer• Assist new hires by conducting such that they are productive on the floor in the shortest possible time frame.• Coordinate the team by preparing and sending daily production & error reports to the Management and other Regional Leads• Develop, maintain, and analyze Tax accounts, preparing periodic reports of payables for vendors.• Reconciliation of Accounts Payable by each Client and prepare a Fund Request Reports. • Review invoices and taking appropriate steps as per client requirements.• Provide on hold invoices reports and their clarifications. Show less

• 

  Ryan India Tax Services Pvt Ltd

  Jan 2017 - now

  Senior Business Analyst

  • Develop and maintain ETL (Data Extraction, Transformation and Loading) mappings using SQL Server to extract the data from multiple source systems that comprise databases like Oracle 10g, SQL Server 7.2, flat files to the Staging area.• Maintain SQL scripts and complex queries for analysis and extraction.• Expert in writing SQL queries and optimizing the queries in SQL Server 2014.• Excellent knowledge of Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.• Analyze raw data, data cleansing transforming using (SQL, excel & R Language), drawing conclusions by providing recommendations.• Understand given data, client requirements, goals and research for statistical methods to arrive at a solution.• Develop R program complying with the coding standards defined by technical management.• Good understanding and experience with machine learning algorithms like Linear/Logistic Regression, Neural Networks, Support Vector Machines, KNNs, Decision Trees, Random Forests, Clustering, Dimensionality Reduction. Show less

• 

  Ryan

  May 2022 - now

  Assistant Manager