Business Intelligence Data Analysis

+1-443-***-**** ad5s9d@r.postjobfree.com edu KUMAR MALYALA LinkedIn : anil-kumar-malyala Github : AnilKumarMalyala 5 years of experience in Data Analysis with Design, Modeling, Development, Implementation, and Testing of Data Warehouse applications. Well-versed in carrying out the entire Software Development Life Cycle (SDLC), Agile, and Waterfall Methodologies. Proficient in reporting, data visualization, and dashboard development using MS Excel, Tableau, and Power BI. Understanding of Data cleaning, Data Wrangling, Statistical Data Analysis, Exploratory Data Analysis and Predictive Modeling using R, Python. SKILLS

Languages/ Libraries Python((Pandas, NumPy, Matplotlib, Scikit Learn), SAS, R, C, SQL, HTML/CSS Tools /Databases AWS, Spark, Qlik Sense, Tableau, Power BI, Alteryx Dialogflow, Docker, Mongo dB, Postgres, Streamlit, Flask, Azure, Git, Microsoft Excel, ArcGIS

Certifications AWS Certified Cloud Practitioner

EXPERIENCE

Maryland Dept. of Information Technology : Business Intelligence Intern June 2023 — present Crownsville, MD

• Contributing to an ongoing project focused on dashboard development and Key Performance Indicators (KPIs), instrumental in achieving a 20% increase in data accuracy through active participation in data cleaning and data validation processes. Achieved seamless project coordination and enhanced outcomes through consistent and transparent communication with stakeholders.

• Engineered interactive data visualizations in QlikSense for cross-functional teams, resulting in a 30% improvement in data accessibility and a 20% increase in stakeholder engagement.

• Architected a series of Python scripts to streamline and expedite data retrieval and transformation tasks on the Maryland open data portal, resulting in a 40% reduction in manual effort.

• Conducted a comprehensive 2-day training session on QlikSense for beginner-level participants from Maryland State Agencies. University of Maryland Baltimore County : Graduate Research Assistant Jan 2023 — May 2023 Baltimore, MD

• Developed and deployed an intelligent conversational chatbot to answer students’ queries at the University of MarylandBaltimore County (UMBC) using GCP Dialogflow, Ngrok, and the OpenAI algorithm.

• Utilized webhook technology to integrate the chatbot with a Python script, facilitating real-time data access and delivery to students. Integrated the chatbot with Slack, a widely used messaging platform, to improve accessibility and user engagement. Reduced student querywait times by 29%.

IndianOil Corporation Limited : Data Analyst July 2018 — Aug 2022 Korba,India A global Fortune 500 firm dealing in the production and distribution of petroleum products.

• Worked with Python and SQL in retrieving the data, performing data analysis, and finding insights.

• Utilized machine learning models to perform predictive modelling and forecast demand, reducing inventory costs by $50,000 annually.

• Designed and implemented data visualization dashboards using tools like Tableau and Power BI to track metrics resulting in a 15% reduction in response time to critical incidents.

• Created Tableau dashboards utilizing concepts of calculated fields, data blending and LOD expressions and increased the adoption by 35% using interactive design.

• Executed the development of ad-hoc reports by crafting intricate SQL queries. Enhanced reporting efficiency, reducing query response time by 25% and increasing data retrieval accuracy by 15%.

• Proficient in SSIS (SQL Server Integration Services) for designing, developing, and deploying ETL (Extract, Transform, Load) packages to automate data workflows and streamline data integration processes.

• Expertise in writing complex SQL queries, stored procedures, views, triggers and functions to manipulate, retrieve, and analyze data efficiently within SQL Server databases.

EDUCATION

UNIVERSITY OF MARYLAND BALTIMORE COUNTY Baltimore, MD Masters in Data Science CGPA: 3.97/4.00 Aug 2022 — May 2024 NATIONAL INSTITUTE OF TECHNOLOGY KARNATAKA (NITK) Surathkal, India Bachelor of Technology, Electrical And Electronics Engineering Jul 2014 — May 2018 PROJECTS - UNIVERSITY OF MARYLAND BALTIMORE COUNTY Newark Liberty International Airport Delay Prediction

• Developed a prediction model using Random Forest, XGBoost to forecast average gate arrival delay at Newark Liberty International Airport and achieved an accuracy of 83.3%.

• Conducted statistical analysis and data cleaning on five years of data, performed sentiment analysis utilizing techniques such as Latent Dirichlet Allocation (LDA), word cloud and GridSearchCV to optimize hyperparameters and identify factors behind the surge in delays in 2022., which resulted in a decrease of factor identification time by 15%. Uber Trips Analysis

• Analyzed and processed a 3-year Uber dataset comprising 10 million rows using PySpark, and ensuring efficient handling of large volumes of data. Leveraged Docker to deploy Apache Spark containers with a 30% reduction in analysis time.

• Constructed regression model using Random Forest to predict user traffic with an accuracy of 89.4%.

Contact this candidate