Data Analyst Warehouse

SRI KOLANU

Location: Charlotte,NC Mobile: +1-224-***-**** Email: ********************@*****.***

EDUCATION

M.S. Computer Software Engineering May 2023

University of Missouri Kansas City, Kansas City, MO B. Tech Computer Science May 2021

Kakatiya Institute of Technology & Science, Warangal, India PROFESSIONAL EXPERIENCE

Data Analyst: Ininics INC, Charlotte, NC JUN 2023 - PRESENT

● Designed, developed, and delivered business reports and dashboards using Excel and Tableau.

● Applied advanced Excel functions, Conditional Formatting and PIVOT tables, to validate data.

● Demonstrated ability to identify and solve complex business problems through data analysis.

● Performed extensive Data Validation, Data Verification against Data Warehouse(Redshift and Snowflake) and performed debugging of the SQL-Statements and stored procedures for business scenarios.

● Utilized Apache Spark and Spark SQL to proficiently process and manage large datasets and developed ETL pipelines using Apache Airflow.

● Applied web scraping techniques such as BeautifulSoup, to extract and parse relevant data from websites.

● Utilized python libraries such as Pandas, NumPy, and Matplotlib to manipulate, analyze, and visualize complex datasets

● Utilized AWS services S3, Glue, Athena to develop scalable data pipelines and perform SQL-based analytics with Redshift, enhancing data-driven decision-making.

Data Science Intern: Brain O Vision, Hyderabad, India FEB 2020 - DEC 2021

● Proficient in Microsoft Excel, Python, R, and SQL for data analysis, manipulation, visualization, and presentation, allowing for effective data-driven insights and communication.

● Developed interactive data visualizations using Matplotlib and Seaborn to effectively communicate findings.

● Utilized big data technologies, such as Hadoop and its ecosystem, for handling and processing large datasets.

● Strong analytical thinking and the ability to approach problems with a data-driven mindset.

● Collaborated with team members to create visually appealing and informative presentations using tools like PowerPoint, Tableau and PowerBI.

RELEVANT PROJECTS

IBM Data Engineering Capstone Project MAR 2023 - JUN 2023

● Designed a data platform for OLTP and NoSql databases to store the raw data.

● Designed and implemented a data warehouse and generated the reports from the data.

● Extracted data from MySql,PostgreSQL and MongoDB transformed and loaded into the data warehouse using Apache Airflow and Created the spark connection to the data warehouse and deployed machine learning models. Skills: Python, PySpark, MySql, MongoDB, DB2, PostgreSQL, ApacheAirflow, IBM Cognos, Hadoop, snowflake. MOVIE RECOMMENDATION SYSTEM OCT 2022 - DEC 2022

● Developed a personalized movie recommendation system using deep learning and collaborative filtering algorithms.

● Collected and preprocessed movie data from publicly available datasets, ensuring data quality and consistency.

● Implemented collaborative filtering approaches, such as user-based or item-based methods, to generate accurate and personalized movie recommendations.

● Created a user-friendly interface to allow users to input preferences and receive personalized movie recommendations, enhancing the overall user experience.

Skills: Python, MySql, Google Colab, Pandas,Spark, Scikit-learn, Tensor Flow. TECHNICAL SKILLS

Programming Languages: Python, C/C++, Java, SQL.

Big Data Technologies: HDFS, MapReduce, Hive, Apache Spark, HBase Web Technologies: HTML, javaScript.

Operating Systems: Windows, Unix, Linux.

Visualization Tools: Matplotlib, Tableau, IBM Cognos, Power BI Databases and cloud platforms: Oracle, MySQL, PostgreSQL, MongoDB, AWS. Additional Tools and Python Libraries: Apache Kafka, Apache Airflow, Jupyter, Skikit-learn, Tensor Flow, XGBoost. CERTIFICATIONS

Python for Data Science from IBM.

Certification from Hacker Rank on SQL.

Databases and SQL for Data Science with Python from IBM. Data Engineering Professional Certificate from IBM.

Contact this candidate