SUMMARY

Piyush Kumar

Data Analyst

CA 513-***-**** ad1doi@r.postjobfree.com

* ***** ** ********** ** Data analysis, Design, Modeling, Development, Implementation, statistical analysis, Business intelligence Quantitative field, Testing of Data Warehouse applications and project management.

Experience in all phases of Software Development Life Cycle including System Analysis, Design, Data Modeling, Implementation, Work collaboratively with marketing and Support, maintenance of various applications.

Extensive knowledge of statistical programming languages such as R and Python.

Proficiency in using various packages in R and Python - like ggplot2, NumPy, Pandas, Matplotlib, and SciPy for Data Analysis.

Working experience in using visualization tools such as Tableau and Power BI to create insightful dashboards, resulting in a 30% improvement in reporting efficiency and a 40% increase in data-driven decision-making.

Knowledge of Data Interpretation, Data Analysis, and Data Integration by using Databases like MySQL and MS SQL Server.

Understanding of Data cleaning, Data Wrangling, Statistical Data Analysis, Exploratory Data Analysis, Data Wrangling, and Predictive Modeling using R, Python, statistical modeling, coding, debugging, and Data visualization. EDUCATION

Master of Business Analytics

HULT International Business School, San Francisco, CA Bachelor of Electrical and Electronic Engineering

SRM University, Chennai, India

SKILLS

Methodologies: SDLC, Agile, Waterfall, Azure

Language: Python, R, SQL, MongoDB, SSIS

IDEs: Visual Studio Code, PyCharm

Packages: NumPy, Pandas, Matplotlib, Seaborn, SPSS, ggplot2 Visualization Tools: Tableau, Power BI, Microsoft Excel Database: MySQL, SQL Server, MSSQL

Other Skills: Data Cleaning, Data Wrangling, Critical Thinking, Communication Skills, Presentation Skills, Problem- Solving, Data Analysis, Data Quality, Data Management, Data Analytics, Data Modeling, Microsoft Office Operating System: Windows, Linux

EXPERIENCE

Hartford Financial Services Group, CA Sep 2023 - Current Data Analyst

Working on data cleaning, exploratory analysis, visualization, and mining using SQL/ Python/ R.

Developing Python scripts to automate data analysis processes, resulting in a 50% increase in efficiency and allowing for real-time data monitoring and reporting.

Create interactive dashboards and visualizations using Tableau, providing stakeholders with real-time access to key performance indicators (KPIs) and resulting in a 40% reduction in report generation time.

Conducting data cleansing and validation procedures in Excel, resulting in a 15% reduction in data errors and improved data integrity.

Use SQL queries to extract, transform, and load data from databases, optimize data retrieval and manipulation, and reduce query execution time by 25%.

Demonstrated expertise in leveraging cloud computing platforms, including GCP, AWS, and AI technologies, optimization machine learning solutions deployment. Achieved a 15% improvement in operational efficiency and scalability, showcasing proficiency in implementing cutting-edge AI capabilities.

Performing Data Management duties acquired validated, processed, stored, and protected data for reliable accessibility to data users.

Fusion Software Technologies, India Nov 2019 - Aug 2022 Data Analyst

Involved in requirements gathering and source data analysis and identified business rules for data migration and for developing the data warehouse.

Developed and implemented data wrangling workflows, reducing data cleaning and preparation time by 60% and enabling faster data-driven insights.

Conducted comprehensive data cleansing and validation processes, resulting in a 20% increase in data accuracy and reliability for critical business decisions.

Designed and implemented interactive dashboards using tools like Tableau and Power BI to distill complex datasets into clear, actionable insights for stakeholders, resulting in a 20% increase in data-driven decision-making.

Spearheaded a cross-functional team and business objectives to establish data quality standards, leading to a 25% improvement in data accuracy across all systems and applications.

Extracted, interpreted, and analyzed data to identify key metrics and communicate them through visualization and storytelling.

Collaborated with cross-functional teams and business stakeholders, employing written and verbal communication skills, to identify issues and implement business process improvements, resulting in a 15% enhancement in overall data quality for diverse products.

Demonstrated expertise in meticulous planning and implementation of data mapping and transformation strategies, optimizing migration processes to overcome challenges such as metadata preservation, file format conversions, and infrastructure-related issues, resulting in a 20% increase in efficiency.

Created and implemented optimized database structures in SQL Server, leading to a 70% improvement in query performance and enhanced data retrieval speed.

Strategically orchestrated seamless data migrations across diverse storage solutions, including SharePoint, employing ETL technologies and achieving an outstanding 98% overall success rate.

Assisted in collecting and cleaning data from multiple sources, resulting in a 35% improvement in data quality.

Ensured seamless transitions and maintained data integrity throughout migration projects at Fusion Software Technologies, providing rigorous quality assurance and post-migration user support, contributing to a 95% user satisfaction rate.

Except Technology, India Nov 2017 - Oct 2019

Data Analyst

Led the development of innovative solutions at Except Technology, utilizing Machine Learning algorithms, supervised learning skill and statistical analysis, yielding a 20% enhancement in system intelligence and predictive capabilities within the dynamic healthcare IT environment.

Conducted comprehensive data analysis using Power BI, identifying cost-saving opportunities that led to a 30% reduction in operational expenses and improved overall profitability.

Applied Python libraries such as Pandas and NumPy to manipulate and clean data, reducing data cleaning time by 40% and enhancing data quality by 20%.

Developed data-driven quality improvement initiatives, resulting in a 10% increase in patient satisfaction scores and improved overall healthcare outcomes.

Conducted Data analysis including acquisition, cleansing, transformation, modeling, visualization, documentation, and presentation of results.

Led rigorous analytics-driven data analysis, uncovering trends, patterns, and anomalies. Delivered actionable insights and recommendations, driving a 20% improvement in overall business performance.

Engineered automated Excel-based reporting tools, reducing manual reporting efforts by 10% and enhancing report generation efficiency. Additionally, designed and implemented a highly accurate (98%) time series forecasting model, contributing to a 30% reduction in excess inventory levels.

Collaborated with executives along with management for data management proposals to potential clients and participated in vendor management.

Engineered a database with advanced data modeling techniques, achieving a 30% enhancement in data retrieval speed and system responsiveness, to store patient information, including visit history and financial data.

Led a team in migrating a legacy database to MSSQL, successfully completing the project 20% ahead of schedule and reducing data transfer errors by 15%.