Praveen Kumar

PRAVEEN KUMAR Email ID:- Contact No: - Skype:- live:praveen.kashhyap About me: ● 5.5 yrs of total IT experience: o o o Mindtree-Larson and Turbo group (Module Lead) Jun-19- Jun 20(Full time) EduCBA (Content Writer)Part time Job Infosys Technology Ltd (SSE) Jan, 2015 - May, 2019(Full time) ● 4.5+ years working in Data analyst, Python, SQL, IT/Customer support, documenting and business reporting, Operational research, pyspark. Educations: ● ● ● ● ● PGDCA(Computer Application)-Subharti University---------------------------(65%)---Completed (in Jun 2020) PGDM (Business analytics-Exec) from IMT, Ghaziabad ---------------------(66%) Completed (in Mar 2019) B.Tech/Engineering (ECE) from PSIT, Kanpur (UPTU)-------------------------(68%) Completed (in Jun 2014) XII (12th) with Science Stream (CBSE)----------------------------------------------(71%) Completed (in Jun 2009) X (10th) with Science Stream (CBSE)-----------------------------------------------(90%) Completed (in Jun 2007) Tech Skills: Technology Languages Tools OS : Data Analysis, CRM, Power BI, Data science, Big Data, Hadoop -ecosystem, Banking, Agile, AWS, Network devices basic. : Python, SQL , Py-Spark, HIVE : Python libraries like Pandas, matplotlib for EDA, Anaconda, Jupyter, ETL, Putty, GitHub, JIRA, Rest API, Incident management tools like Zendesk, servicenow, Ms Excel, POWER BI, Ms office tools, Tableau : Windows and Unix Area of expertise: ● ● ● ● ● ● ● ● ● ● Dash boarding and Reporting with Power BI and Excel IT/Customer supports on ticketing tools like zendesk and had worked under pressure SLA.I had also experience in providing customer technical support Expertise in creating DataFrames and Dataset from RDD and files for further processing. Have done the data cleaning and preprocessing through features engineering and helped in doing predictive modeling for clients. Expertise in descriptive analysis for data mining insight using EDA in python language on health and financial data. Expertise in creating algorithm /doing requirement analysis and have created POCs using Regression/PCA/KNN. UI/UX tastings Expertise on running spark jobs locally as well as yarn cluster mode and monitor the job. Experience in using pushing and pulling GitHub repository Good understanding of Partitioning, bucketing concepts in Hive and experience in designing both Managed and External tables in Hive to optimize performance. Synopsis of Projects: Financial service solution as Module Lead Jun19–Jun20 Technologies : Py-Spark, Python, Big data, Oracle, Sqoop, Amazon S3, GIT-Hub for version control, customer support Project Description: The objective of this to build an analytical engine that will process the input debtors list from parquet files. Was leading work in governance risk compliance team to give the financial information and insights. Responsibilities: ● Daily communication with client and customers for the support and queries for daily files. ● Done coding of py-spark to append daily incremental files to existing parquet. ● Done coding in py-spark and python to process the input files across partitions and Generate daily treasure LIR report for the client. Banking Client as Data analyst Feb 18 - May 19 Technologies : Python libraries, Credit risk modelling, Excel,POWER BI, GitHub VC, Tableau, FICO Project Description: The objective of this project is to meet with the client’s requirements like analyzing data after cleaning and preprocessing of data and develop an algorithm that predict risk while crediting loans and also do the descriptive retail analytics using python libraries for datasets if and when required. We used PD, LGD (Loss given default) and EAD modelling. Responsibilities: Performed data cleaning and preprocessing ● Conduct daily calls with clients. ● Helped in creating a regression model for PD, LGD for Scoring. ● Visualize and report it the client with dashboarding and reporting Banking Client as Technical support engineer Jan 17 - jan 18 Technologies : Power BI, Python , Excel, SQL Project Description: The objective of this project was to do analytics and build a reporting interface according to client requirements. Tasks is to analyze the access log file from the server and make an application to determine the downtime for maintenance. Have also analyzed and done POCs for patient health/EHR data. E-commerce (RICOH) as L2,L3 support for customer Jul15- Dec16 Technologies : SQL-Loader, SQL Query ,Oracle EBS, Reporting and incident management tool, CRM Project Description The objective of this project was to setup account for the customers with correct access and responsibilities through mails, chats and incident management tool. I was also required to meet client's Techno -functional requirements like loading conversion rates in GL interface, creating reports through query in required formats from template according business needs. Achievements and activities: ● ● ● ● Certified in Python language from Microsoft - May,2018 Infosys Certified Big Data Developer Certified in Bigdata from Coursera-SanDiago-2019 Writing technical post on websites like kaggle https://www.kaggle.com/prakr89/machine-learning-inpython medium https-different-tables-joins-in-sparkda58c7879ad6 Personal Details: ● Languages ● Hobby ● Native : Fluent in English and Hindi speaking and writing : Writing technical posts on Internet, Social Media & Caring Animals : India