Sayantan Chakraborty (সায়ন্তন চক্রবর্তী)

Sayantan chakraborty (সায়ন্তন চক্রবর্তী)

bookmark on deepenrich
location of Sayantan Chakraborty (সায়ন্তন চক্রবর্তী)Kolkata, West Bengal, India
Followers of Sayantan Chakraborty (সায়ন্তন চক্রবর্তী)14000 followers
  • Timeline

  • About me

    Sr. Data Analyst @ PwC People Technology | Ex - KPMG | Ex - PwC AC KOL | Microsoft Power BI | SQL | Power Automate | Alteryx

  • Education

    • Swami vivekananda institute of science & technology

      -
      Bachelor of technology - btech computer science
  • Experience

    • Pwc

      Sept 2018 - Mar 2019
      Consultant

      -> Has experience as Data Analyst of the CAAT (Computer Aided Audit Techniques) team, on SAS 99/ISO 240 Journal entry testing for various clients providing auxiliary support to various PwC audit teams.-> Works with the Data Assurance (Computer Aided Audit Techniques) Team, serving PwC UK clients providing auxiliary support to their respective Audit teams. The assignments involve data transformation, cleaning and loading using analytical tools like ACL, Alteryx, and MS Excel.

    • Aqb solutions pvt ltd

      Aug 2019 - Apr 2020
      Associate software developer

      -> Worked as a part of Python Development team on Linux platform to provide Software designing and GUI solutions for various Business platforms.-> Worked on a project of a Legal Analytics company of USA where I basically analyzed, manipulated and processed the data through MySQL and written python code using selenium as an Automation tool for crawling unstructured data from various websites and saving it to the database.

    • Pwc

      Oct 2020 - Mar 2022

      As an Experienced Associate, I have worked as part of a team of problem solvers with extensive consulting and industry experience, helping our clients solve their complex business issues from strategy to execution. Specific responsibilities include but are not limited to:-> Has experience as Data Analyst of the CAAT (Computer Aided Audit Techniques) team, on SAS 99/ISO 240 Journal entry testing for various clients providing auxiliary support to various PwC audit teams.-> Works with the Data Assurance (Computer Aided Audit Techniques) Team, serving PwC Canada, PwC Caribbean, PwC UK, PwC Brazil clients providing auxiliary support to their respective Audit teams. The assignments involve data transformation, cleaning and loading using analytical tools like ACL, Alteryx, and MS Excel.-> Have prepared numerous automations using Alteryx and Python on different areas of business. The automations contained to prepare a standard workflow for converting an unformatted data to a structured and formatted dataset, a standard workflow to check the integrity of data based on several risk criteria's. This has resulted in 28% process efficiency of the total time required to perform the task done by the team and saved many valuable client hours as well.-> Provided training on Alteryx, Python and SQL to our broader team. Show less -> Has experience as Data Analyst of the CAAT (Computer Aided Audit Techniques) team, on SAS 99/ISO 240 Journal entry testing for various clients providing auxiliary support to various PwC audit teams.-> Has experience in working on different ERP datasets like Datalink, QuickBooks, Oracle, SAP H4 Hana, Great Plains, Microsoft Dynamics, Sage 50 etc. Analysis of the financial data (General Ledger, Trial Balance, Chart of Accounts, P&L & Balance sheets) and providing sufficient analysis to the audit team requirements. Show less

      • Associate 1

        May 2021 - Mar 2022
      • Consultant

        Oct 2020 - May 2021
    • Kpmg

      Mar 2022 - Sept 2022
      Associate consultant

      -> Worked in the Data and Analytics team under the KPMG Global Service's Consulting practicewhere I designed, built, and configured workflows to meet business processes and applicationrequirements.-> Developed and maintained data workflows to be used by Tableau and other BI tools.-> Worked on different projects for different industries, primarily in Merger and Acquisitions. -> Experienced in developing Alteryx workflows for Data Migration projects thereby outputting the end results in SQL Server to create XMLs using stored procedures. Show less

    • Pwc

      Sept 2022 - now

      As a member of the PwC People Operations and Technology team, supporting the Workday Functional team’s leads and team members in:--> Managing the data for US, MX, wholly owned AC's (Shanghai and Bangalore), AC Kuala Lumpur & SDC2. In addition to managing the data, also providing data governance; data validation, auditing, and testing; integration governance, and consultation.--> Analyzing and visualizing data using Power BI. Performing ETL operations in Alteryx to clean & prepare data for further analysis.--> As a member of the US/MX Data Stewards team, being consulted at the very first when data or system issues arise. Also conducts multiple audits to proactively solve data issues before they are even raised. These audits allow the team to see trends and react by collaborating with teams to find root cause and work to resolve issues. ---> Responsible for building Workflows in Alteryx for data modeling. Use Alteryx outputs and other sources to create dashboards in Power BI for PwC Business Services team in the US.--> Responsible in single handedly building, maintaining, and updating the PwC People Operations and Technology's dashboards as well as leadership reports, leveraging multiple programs/platforms such as Alteryx, Power BI, google Sheets/Excel, Slides/PowerPoint.--> Managing expectations of multiple stakeholders and projects simultaneously. Show less

      • Senior Associate

        Jun 2024 - now
      • Associate 2

        Sept 2022 - Jun 2024
  • Licenses & Certifications