Amit Kumar

Data extraction using valuable data source with Collaboration with the data engineering team to collect data. Data processing, Cleaning and validating data using SQL, Pandas. Use Power BI, Matplotlib, Seaborn, Plotly for data analytics and data visualization dashboard and reports. Compile and analyze large amount of data to find patterns and solution related to business issue by using statistical Analysis (Python libraries- NumPy), hypothesis testing and mathematical calculation on data. Develop Clear visualizations to convey complicated data in straightforward fashion. Technology Used / Backend: Power BI, SQL, Python and Google sheets, EDA & FE, Pandas, Matplotlib, NumPy.

Performed root cause analysis for bad data by querying almost 2 million records and then loading them in a jupyter notebook. Closely worked with data engineers to understand data structure and wrote python routines to collect the desired data set. Identified inefficiencies and lack of validations in the business processes. Prepared demonstrations for senior management leading to strict enforcement of loan and credit validations, saving $1.5 million in fraud. Worked in a web traffic data analytics process using SQL and Power BI, surfacing UX problems and increasing web traffic by 25%, resulting in a 10% sales increase. Technology Used / Backend: Power BI, SQL, Python, Pandas, Google sheets, EDA & FE.

Auto classification of health care documents (prescriptions, doctor notes, equipment orders) using python. Prepared various BI dashboards in Power BI for insurance business reports. Evaluated and analyzed insurance claims dataset using Excel V-lookup, Chi-square, Normal and T- distribution. Removed outliers using Python and Pandas. Helped business decide on dynamic pricing by identifying business insights and forecasting trends for future months using time series analysis. Worked closely with the engineering and business team. Technology Used / Backend: Power BI, SQL, Python, Pandas, Google sheets, EDA & FE.

Trainee engineer assisting the Boeing team at Air India Engineering Station – IGI Airport. Responsibilities included preparing daily, weekly, monthly, and quarterly revenue analyses. Preparing all KPIs network-wise, region-wise, route-wise, and flight-wise. Preparing ad-hoc commercial reports for management analysis. Running analytics and helping implementation of analytical & visualization tools to aid decision-making. Technology Used / Backend: Python, SQL, Microsoft Excel, Pandas, Matplotlib, Power BI, EDA& FE.