Mohammed Anas

Mohammed Anas. K.M Kerala, India. Mob: - Email:-Summary • Overall 5 years of experience and 2 years in Data Engineer Projects. • Currently working with Makonis Software Solutions as Data Engineer. • Good understanding of Data Analysis fundamentals and experience in designing and implementing solutions is looking for a similar role and position in a progressive organization. Work Experience Designation: Data Engineer Organization: Makonis Tenure : February 2020 To June 2022. Duties and responsibilities: • • • • • • • • Design and develop ETL integration patterns using Python on Spark. Data acquisition from internal/external data sources Migration of data warehouse from SQL Server to Hadoop and Hive. Designed and built Data Quality frameworks for covering Data Quality aspects like Completeness, Accuracy, coverage using Python and Spark. Optimization of Hive queries using best practices and right parameters and using technologies like Hadoop, YARN, Python, PySpark. Developed spark applications in python(PySpark) on distributed environment to load huge number of CSV files with different schema in to Hive ORC tables. Worked on reading and writing multiple data formats like JSON,ORC,Parquet on HDFS using PySpark. Involved in converting Hive Queries into various Spark Actions and Transformations by Creating RDD and Dataframe from the required files in HDFS. • Responsible for data ingestion into Bigdata using Spark Streaming and Kafka. Designation: Machine Learning Trainee Organization: Makonis Tenure : May 2021 to October 21 Duties and responsibilities: • Web Scraping, Data Visualization & Regression Modeling. • Compiled pricing data for competitive analysis by performing web scraping in python. • Created charts in Jupyter Notebook to perform preliminary analysis & visualize data using Matplotlib. • Clustering , Classification & Creating FastAPI Framework • Conceptualized & implemented a sentiment analysis tool to rate the financial competence of companies • Deploy Machine Learning models as a Microservice using FastAPI Designation: Data Analysis. Organization: Accenture Tenure : From June 2016 to June 2019 Duties and responsibilities: • Plan, design, and implement application database code objects, such as stored procedures and views. • Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction. • Analyzing product, market, and share trends to build data. • Design, build and deploy BI solutions. • Designing, developing and maintaining business intelligence solutions. • Presenting information through reports and visualization. • Create visualizations and reports for requested projects. • Develop and execute database queries and conduct analysis. • Create data objects (DDL). • Prepare documentations for database applications. • Memory management for database systems. • Develop database schemas, tables and dictionaries. • Ensure the data quality and integrity in databases. • Create complex functions, scripts, stored procedures and triggers to support application development. • Take regular database backup. Educational Profile a) Academic Qualification • Bachelor of Computer Applications from Bangalore University in the year 2015. Underwent the course at Garden City College, Bangalore. • Plus-Two (Science) from Board of Higher Secondary Examinations, Kerala in 2011. • SSLC from Board of Public Examinations, Kerala in 2009. b) Technical Qualification Excellent knowledge in Computer Basics and Internet. TRAINING/COURSES • • • • Python Basics and Intermediate - O'reilly. Data Analysis with Pandas and Python - O'reilly. Spark and Python for Big Data with PySpark – Udemy. Google Analytics for Beginners | Hands-On Training – Udemy. • • Oracle 11G Database. UI Path - RPA Basics Additional Skills • Packages: Scikit-Learn, Numpy, Scipy, Pandas, NLTK, BeautifulSoup, Matplotlib, Statsmodels, Jupyter Notebook. • Azure Data Factory, Azure Data Lake Storage, Databricks. • Statistics/Machine Learning: Statistical Analysis, Linear/Logistic Regression, Clustering, Graph Theory, Regularisations. • Strong skills in SQL development. • An in-depth grasp of SQL reporting, analytics and business intelligence. • Excellent understanding of database structures, principles, theories and practices. • Great problem solving and analytical skills. • Good knowledge in python. • Good knowledge in Simulation, Static Visualizations, pandas Series and DataFrames. • Working on Business process diagrams and process flow charts with RPA tools. Skills • • • • PYTHON, SPARK, ORACLE, SQL, FastAPI, UIPATH, GITHUB, Pyspark Microsoft Azure Data Factory, Hadoop Power BI Microsoft Excel I hereby declare that the information given above is true and correct to the best of my knowledge and belief. Mohammed Anas K.M