Santosh Kumar (Freelancer)

Product Manager

Noida, Uttar Pradesh, India12 yrs 7 mos experience

Most Likely To SwitchHighly Stable

Key Highlights

12 years of IT experience in data analytics
Expert in Business Intelligence and analytics solutions
Skilled in mentoring teams on advanced BI tools

Stackforce AI infers this person is a Business Intelligence expert with extensive experience in data analytics and visualization across various industries.

Contact

rajputmca3@gmail.com LinkedIn

Skills

Core Skills

Business IntelligenceData WarehousingData VisualizationData AnalysisData Migration

Other Skills

ADFSAmazon Web Services (AWS)Azure Data FactoryAzure SQLData ModelingDatabase MigrationDatabasesETLMicrosoft Business Intelligence (MSBI)Microsoft SQL ServerPower BIPythonQlik SenseSQLSSAS

About

Senior Data Analyst with 12 years of IT experience, specializing in scalable and efficient Business Intelligence (BI) and analytics solutions, including the integration of Generative AI. Skilled in transforming complex data into actionable insights through tools such as Power BI, Tableau, and SSRS, and experienced in developing advanced dashboards, reports, and visualizations. Strong technical expertise in Snowflake, Snowpipe, Copy Command, and end-to-end data warehousing solutions. Over 8 years of experience in data analysis, data warehousing, project migration, and scripting with Python. Adept at mentoring and training teams on a broad range of technologies, including Power BI, Tableau, SQL, T-SQL, SSMS, SSIS, SSRS, SSAS, Python, Azure SQL, and Azure Data Factory (ADF). Passionate about enabling data-driven decision-making and enhancing business performance through advanced analytics and BI solutions.

Experience

Confidential

Senior Data Analyst

May 2021 – Present · 4 yrs 10 mos · Bengaluru, Karnataka, India · Remote

▪ 12+/ years of overall IT experience delivering efficient and scalable Business Intelligence and analytics solutions.
▪ Microsoft PL-300 and Azure AI-900 Certification have been completed.
▪ 8+years of hands-on experience in Power BI/Tableau reporting, creating analysis, Dashboards, and Visualizations.
▪ 4+years of hands-on experience in Snowflake, Snowpipe, Copy Commad and Data ware housing.
> Working as Snowflake cloud for ETL and queries in the data loading.
> Working on the Snow SQL.
▪ 8+years of hands-on experience in SQL Server Integration Services-SSIS Data Flow Tasks, creating SSIS packages, configuration, and deployment in SSIS Catalog.
>Provided training to new employees or existing on Power BI, Tableau, SQL, T-SQL, SSMS, SSIS, SSRS, SSAS, Python, Azure SQL, ADF.
▪ Strong Requirement and delivery Management skills with lift-and-shift experience in Azure IaaS ETL Delta loads process.
▪ Knowledge of Snaplogic, Team Leading, Scrum, Agile, and SDLC Methodologies.
▪ Lead in solution Design and Development, Sprint Planning Meeting, and Daily Standup Calls.
▪ Takes ownership in implementing backend and frontend BI Solutions in Microsoft SQL Server, SSIS, SSAS, and Power BI.
▪ Create database objects, Pipelines, Blobs, tables, views, stored procedures, functions, indexes, triggers, agent jobs, and scheduling in SQL Server 2012/2014/2016/2018

Snowflake CloudPower BITableauSQLSSISSSRS+6

Neosoft

Senior Data Analyst | Data Scientist

Oct 2018 – May 2021 · 2 yrs 7 mos · Mumbai Area, India

7 years of IT experience in Data Visualization, Data analysis, Data Cleaning, Data warehousing,Data modeling, Data designing and ETL/BI.
Woking as a Sr. Data Analyst on Web Werks Technology Pvt Ltd.
Hands on experience in Business Intelligence Tools(Power BI/Tableau/Qlik Sense/MSBI-SSRA,SSIS,SSAS) and Different RDBMS.
Having Good Knowledge of DWH concepts like fact table, dimension table and models.
Create Dynamic Dashboard and reports used Power BI/Tableau/QlikSense with used different visuals multiple chats, Visual card, KPI’s, Map cart, Multi card, tables and drill trough and drill down.
Working on various domains likes(Insurance, loan, banking, credit cards, Mutual Funds).
Knowledge in Data Extraction, Transforming and Loading (ETL) between Sources and Destination.
Worked on different type of transformation like Data conversion, drive column, multi cast, row count, merge, merge join, union, sort, condition split.
Worked on Different type of source and destination like Flat file, excel, OLEDB, RDBMS and NoSQL.
Involved in Defect review meetings with the development team along with the testing team for the resolution of the defects.
Involved in UAT testing of ETL/BI like count testing, Data validation, Duplication, Null value testing.
Knowledge of Creating and linked Microsoft Azure in Microsoft Management Studio.
Knowledge of Data Modeling like E-R Modeling and Dimensional modeling like (Star schema, Snowflake schema).
Working on Health Insurance domain (Create Health Insurance Data Schema and Objects).
Knowledge of RDBMS concept SP, Function all constraints, Joins, T-SQL like DDL, DML, and DCL.
Involved in create and monitoring jobs used for SQL agent job other workflow monitor.
Worked on Azure Data warehouse (Fact and Dimension Tables), Azure Power BI, Active Directory/Azure Data Factory(ETL/ELT)
Involved in Software development life cycle and Agile methodologies these process.

Power BITableauQlik SenseETLData ModelingData Warehousing+2

Innominds

Senior Software Engineer

Sep 2017 – Sep 2018 · 1 yr · Mumbai

Working Data visualization and Analysis (Power BI/Tableau/SSRS) On MS Azure for create and migration data to Azure SQL database/DWH, Power BI, MSBI used for created reports, ETL and dashboard with Different clients.
Working on Database Activities(Database migration/Support/Create Database Schema/Objects/Performance Optimization/DDL/DML/DCL/TDL Commnads/Cloud data migration)
Please find below Power BI Dynamic Dashboard.
1.Mutual Fund Dashboard
https://app.powerbi.com/view?r=eyJrIjoiZTI0YzM1ODEtNDYyOS00ZmY4LThiZmUtZWZmMjE0NTNlNTAwIiwidCI6ImU4MjFkMmY1LWRmYWUtNGYxZS05ZDI0LTk2N2JjYzk2MjA1MiJ9
2.Sale Details
https://app.powerbi.com/view?r=eyJrIjoiMThhMTM0NzEtNDViNC00NDUxLTg0MjEtZWFiYjg1NDI4OWU2IiwidCI6IjlkMWUwYWM0LTBhY2MtNGE5NC1iZTVkLTRjYzI2NTA1NDAzMSIsImMiOjh9
3. Cloth Sale with Drill Down
https://app.powerbi.com/view?r=eyJrIjoiNWViMDRlYzItMTBhMy00NjJlLWI4NGUtZDI5MzEyZDMxM2U0IiwidCI6IjlkMWUwYWM0LTBhY2MtNGE5NC1iZTVkLTRjYzI2NTA1NDAzMSIsImMiOjh9
4. Loan Dashboard
https://app.powerbi.com/view?r=eyJrIjoiZWVjOWE1MDAtMDExOS00NWY4LThlMWEtMjQ2N2EwOThlN2EyIiwidCI6IjlkMWUwYWM0LTBhY2MtNGE5NC1iZTVkLTRjYzI2NTA1NDAzMSIsImMiOjh9
5. Property Dashboard
https://app.powerbi.com/view?r=eyJrIjoiYTc1ZTVjMjMtYzkxNi00MWMyLTliMjMtZjIxYWRhNzRlYWE2IiwidCI6IjlkMWUwYWM0LTBhY2MtNGE5NC1iZTVkLTRjYzI2NTA1NDAzMSIsImMiOjh9
6. Order Tracking Dashboard
https://app.powerbi.com/view?r=eyJrIjoiMmVjODhhNWUtODI2NC00MzRhLTg5ZWEtNWYwZDMzZmQyYjE5IiwidCI6ImU4MjFkMmY1LWRmYWUtNGYxZS05ZDI0LTk2N2JjYzk2MjA1MiJ9