Praveen Kumar

Data Analyst @Fameweb Technologies

Faridabad, IN

A technology startup focusing on innovative online solutions.• Automated data transfer from external sources to main tables using Shell scripting, with custom “get” and “put” functions for dynamic data manipulation.• Automated manual Excel-based reports into Tableau and Power BI dashboards with advanced interactivity filters, highlights, URL, and parameter actions.• Designed and developed interactive dashboards and reports from multiple sources using advanced features: Data Blending, Global/Context Filters, LOD Expressions, Hierarchies, Calculated Fields, Custom Charts (Waterfall, Pareto, Funnel, Butterfly).• Worked with diverse data sources such as SQL Server, Oracle, MongoDB, Excel, and files hosted on SharePoint.• Performance optimized Tableau and Power BI dashboards using best practices and Row Level Security (RLS).• Published, scheduled, and managed automated refresh cycles and subscriptions for multiple dashboards.• Deployed dashboards and data pipelines across higher environments, ensuring seamless version migration.• Wrote and optimized complex SQL queries to extract, analyze, and transform large datasets.• Designed and maintained relational and non-relational databases, ensuring data integrity and security.• Implemented ETL workflows using Python (Pandas, NumPy, Matplotlib, Seaborn) for data cleaning, transformation, and exploratory data analysis (EDA).• Utilized Power BI DAX functions and Power Query for creating calculated columns, measures, and automated insights.• Applied statistical techniques, including correlation, hypothesis testing, and probability distributions for data interpretation.

Sector Skill council

IT-ITeE

Sector Skill Council

Assessor In Actor Job Role

University of Delhi

Bachelor of Arts - BA

Sector Skill Council

IT-ITeS

SVKM's Narsee Monjee Institute of Management Studies (NMIMS)

Master of Business Administration - MBA

Sector Skill Council

Assessor In Social Media Influencer Job Role