Sumant N.

Associate Consultant

Mumbai, Maharashtra, India9 yrs 1 mo experience

Most Likely To SwitchHighly Stable

Key Highlights

Expert in Data Engineering and Analytics within BFSI sector.
Proven track record in automating SQL processes for efficiency.
Skilled in data visualization to drive business insights.

Stackforce AI infers this person is a Data Engineering and Analytics expert in the BFSI sector.

Contact

Skills

Core Skills

Data EngineeringData AnalyticsData Visualization

Other Skills

Apache SparkAzure DatabricksBig DataBig Data AnalyticsData AnalysisData WarehouseESGRCETLETL TestingExploratory Data AnalysisHP Application Lifecycle ManagementHadoopHiveIFRS 17Insurance

About

• Building Dashboards for Risk Management sector in banking domain using SAS Visual Analytics, Tableau. Preparing data marts using SAS Programming • Experience of working in ETL under BFSI Domain - Testing team member in an Agile scrum, involvement in daily scrum meeting, updating the storyboard user stories and burn down charts • Responsible for applying transformation logic in Enterprise Data warehouse tables. Writing Teradata SQL queries and data analysis for backtracking the defects • Preparing Business Requirement Document (BRD), Functional Specification Documents (FSD) • Experience in SQL query building, Exploratory data analysis using Python, Advanced MS Excel analytical skills, Data visualisation using Tableau

Experience

Ey

Manager

Nov 2019 – Present · 6 yrs 4 mos · Mumbai Area, India

Tata consultancy services

2 roles

System Engineer

Jan 2018 – Nov 2019 · 1 yr 10 mos

Responsible for applying transformation logic in Enterprise Data warehouse tables and have successfully delivered the deliverables to the clients on time.
Responsible for Analyzing report requirements and developing the reports by writing Teradata SQL Queries.
Proposed and automated SQL scripts for creation of large datasets, reducing the time required for testing data preparation by 30%.
Created reports by joining data from various sources using Python, minimizing the efforts in development phase by 15%.
Analyzed the regular billing dataset using tableau and created data visualization to gather insights on customer data over the time period.
Involved in regular requirement release of the data warehouse.
Created Weekly, Monthly and Quarterly Business Monitoring reports on different Business Programs which helps Managers to take Decisions on the Programs.

Teradata SQLPythonTableauETLData WarehouseData Engineering+1