Pawan Panthi

Data Analyst @ Unum

About

● Possess over 5+ years of robust experience in data analysis, specializing in data mining across vast structured and unstructured datasets, ensuring meticulous data validation, advanced data visualization, and proficient web scraping techniques. ● Well-versed in utilizing Integrated Development Environments (IDEs) including Visual Studio Code and PyCharm for efficient coding and debugging. ● Expert in executing complex Data Extraction, Transformation, and Loading (ETL) processes utilizing industry-standard tools such as SSIS, SSAS, and Informatica. ● Proficient in leveraging powerful visualization tools including Tableau, Power BI, and Microsoft Excel to transform data into actionable insights. ● Demonstrated ability to ensure data integrity through effective cleaning, preprocessing, and validation techniques. ● Strong understanding and practical experience with databases like MySQL and SQL Server, ensuring secure and efficient data handling. ● Working knowledge of all project lifecycle phases, from data acquisition, cleansing, and pre-processing, through feature engineering, exploratory data analysis, model development, testing, validation, to insightful data visualization.

Country

United States

City

Irving

Industry

Insurance

Skill

Data Analytics, Waterfall Project Management, NumPy , Microsoft Power BI, Power BI, Microsoft Excel, SQL Server Management Studio, Python (Programming Language), SQL, R, SAS (Programming Language), Statistical Analysis, Algorithm Development, IDEs , Pycharm, Jupyter Notebook , Writing, Testing, Debugging Code, NumPy

Experience

Data Analyst

Unum

2022-6 - Present · 4 yrs 4 mos

United States

● Efficiently applied Agile and Waterfall methodologies to manage and streamline complex data analysis projects, ensuring timely delivery and adherence to best practices. ● Demonstrating expertise in Python, R, SQL, and SAS for data manipulation, statistical analysis, and algorithm development, contributing to data-driven decision-making processes. ● Proficiently utilized IDEs such as Visual Studio Code, PyCharm, and Jupyter Notebook for writing, testing, and debugging code, enhancing project efficiency and code quality. ● Mastered a suite of packages including NumPy, Pandas, Matplotlib, SciPy, Plotly, SQL Alchemy, Beautiful Soup, Spark, and ggplot2 for sophisticated data analysis, visualization, and interpretation. ● Skilled in creating compelling data visualizations and dashboards using Tableau to communicate findings to technical and non-technical stakeholders. ● Managing and maintained databases including MySQL, SQL Server, and Mongo DB, ensuring data accuracy, security, and optimal performance. ● Leveraging cloud platforms such as Azure and AWS for scalable, secure, and efficient data storage and computing, optimizing the data infrastructure.

Data Analyst

The Cigna Group

2020-1 - 2022-5 · 2 yrs 5 mos

Texas, United States

● Implemented Waterfall methodology for structured software development lifecycle management. ● Developed Python programs using NumPy for efficient array manipulation. ● Utilized data science packages (Pandas, NumPy, matplotlib, SciPy) for advanced Python data analysis. ● Maintained and optimized Power BI reports, ensuring accurate and impactful data presentation. ● Skilled in leveraging tools like Tableau, Power BI, and Microsoft Excel to transform complex datasets into intuitive and impactful visual reports, driving insightful business decisions. ● Crafted SQL tables and complex queries with SQL Server Management Studio for robust data management. ● Ensured clear communication with management for precise requirement gathering. ● Conducted data wrangling and cleansing using SQL and Python, maintaining data integrity and quality.