Kaustav Sarkar

Kaustav Sarkar

Operations Analyst

Followers of Kaustav Sarkar708 followers
location of Kaustav SarkarKolkata, West Bengal, India

Connect with Kaustav Sarkar to Send Message

Connect

Connect with Kaustav Sarkar to Send Message

Connect
  • Timeline

  • About me

    ResWare Admin/Consultant | SSRS Reporting | SQL | US Mortgage | Ex - Fidelity & Altisource

  • Education

    • Pailan College of Management and Technology

      2008 - 2012
      B.Tech Computer Science 8.14
    • Central Model School

      2006 - 2008
      Higher Secondary Computer Science 63.17%
    • Lycee

      1991 - 2005
      High School 68%
  • 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
  • Licenses & Certifications

    • Web Developing using PHP

      HCL Infosystems Ltd.
      Jun 2011
  • Honors & Awards

    • Awarded to Kaustav Sarkar
      Star Performer for Quarter 2 for 2014 Director of Title Services, Altisource Aug 2014