Kaustav Sarkar

Experience

• 

  Altisource

  May 2013 - Jul 2015

  Operations Analyst

  1. Designing and optimizing complex SQL queries using MS SQL Server and SQL Developer for ad hoc and daily reporting purposes.2. Automate daily reports/manual tasks through Visual Basic for Applications, Macros and Batch files.3. Interact with clients, stakeholders and global teams to understand gaps in process flows and redesign the same.4. Reduce repetitive tasks and manual human intervention for different business units by effectively setting up new integrated systems.5. Analysis of large-scale business systems and creating UML based modeling views like Use Case/Data Flow/Business Flow/Navigational Flow using MS Visio.6. Manage ResWare application as an Administrator, provide application support and perform UAT testing and prepare test cases for new releases.7. Training new hires on basics of SQL, Excel and VBA. Show less

• 

  TaxiForSure.com

  Jul 2015 - Apr 2016

  Data Analyst

  1. Manipulating, cleansing and processing large amount of data using SQL, Excel and R.2. Creating dashboards and reports and presenting the same to branch heads on a daily/weekly basis.3. Automate repetitive tasks using Visual Basic for Applications.4. Code complex SQL queries to extract raw data, use key parameters to simplify the same and analyze the data to get proper insight.5. Partake in meetings and help Program Managers come to decisive conclusion using data analysis.6. Taking up ownership of projects, working with respective stakeholders from all branches and executing the same under strong deadlines.7. Make presentations to aid higher management including the CEO, see clearer picture on advancement of current projects. Show less

• 

  FNF India Private Limited

  Apr 2016 - Feb 2022

  1. Built my own team of 7 and managed them to provide application administrative and reporting support for Fidelity National Agency Solutions for ResWare software.2. Identify workflow issues and process gaps and deliver strategic measures and permanent solutions within strict deadline for process development.3. Keep track of KPIs and deliver within SLA on issues with quality resolution.4. Automate reports for better scrutiny and deliver results to clients using SQL Server and SSRS.5. Work with different stakeholders on integration for smooth transaction of information. Show less 1. Provide full time administrative support on ResWare application.2. Identify workflow issues and process gaps and work on permanent solutions.3. Creating and scheduling reports using SQL Server, SSRS and Crystal Reporting. 4. Using SQL script and stored procedures to manipulate automation in ResWare. 5. Coding in SQL Server to create reports and stored procedure as per the business requirement on a daily basis.6. Partake in client calls to bring new projects to our Indian team and lead the same.7. Showcasing report to higher management on the progress of the team and discuss future scopes. Show less

  • Team Lead

    Apr 2018 - Feb 2022

  • Senior ATS Engineer

    Apr 2016 - Mar 2018
• 

  MeyMax Title Agency

  Feb 2022 - now

  ResWare Consultant