Rakesh Koneru
************@*****.*** https://www.linkedin.com/in/rakesh-koneru-b95a586/
Experienced data analyst with a strong background in business intelligence and data-driven decision-making. Successfully created Business Intelligence Dashboards using Power BI and Excel, enhancing decision-making through actionable insights. Proficient in SQL, Python, and advanced data visualization tools, aiming to leverage analytical skills to drive impactful business outcomes in a data analyst role.
Professional Skills
•Analytics & Data Science: Advanced SQL querying and relational database management (Redshift, MySQL, Oracle, SQL Server), Data warehousing, ETL processes, and database design, Data integrity, security, and normalization
•Python: Data analysis and manipulation (Pandas, NumPy), Data visualization (Matplotlib, Seaborn), Machine learning and predictive modelling (scikit-learn, TensorFlow, Keras), Statistical analysis and hypothesis testing (SciPy, Stats models)
•Business Intelligence: Data connection and integration with multiple sources, Advanced visualization and dashboard design, Performance optimization and interactive dashboard creation
•Power BI: Data modelling, DAX, and M language for complex transformations, Interactive dashboard design and performance optimiza- tion, Integration with other Microsoft tools and advanced analytics
•Advanced Analytics Tools: Data import/export, statistical analysis, predictive modelling, and visualization
•Celonis: Process mining, data transformation, root cause analysis, and automation
•PySpark (Databricks on AWS): Data frame operations, Spark SQL, ETL pipelines, Machine learning with MLlib and stream processing
•Project Management & Collaboration: Requirement gathering, Jira, and agile methodologies, Cross-functional team collaboration and stakeholder engagement, IoT integration and strategic partnership development
•Executive Communication: Articulation of complex problems and solutions to executive audiences, Data-driven decision-making and process improvement advocacy, High energy, enthusiasm, and ability to wear multiple hats
Education
Montclair State University
Oct 2023 - May 2024
M.S., Business Analytics (GPA: 4.0)
• Coursework: Applied Statistics for Business Analytics, Data Analytics and Visualization, Database Systems for Analytics, Data Wrangling
& Analysis, Data Mining, Business Process Mining
Institute of Management Technology, Nagpur, India
Jun 2007 - Mar 2009
Post-Graduate Diploma, Marketing and Sales, Finance
• Coursework: Majors in Marketing and Sales, Minors in Finance
Acharya Nagarjuna University, Guntur, India
Jul 2002 - May 2006
Bachelor of Technology, Mechanical Engineering
• Coursework: Mechanical Engineering - Specialization in Industrial Production
Certifications
• Celonis Process Mining Fundamental: by Celonis
• SQL (Advanced): By HackersRank
Honors and Achievement
• Alpha Epsilon Lambda Honors Society Member of Alpha Epsilon Lambda Honors Society Academic Projects
Regression and Predictive Modelling Montclair State University
•Developed models to analyse effect of student opting debt for education and graduation rates using MS Excel, Power Query, PH Stat, and JMP
Python-Based Prediction Models Montclair State University
•Predicted reasons for customer churn in a supermarket using a Large Language Model (LLM) using Python based on customer feedback analysis.
•Developed a prediction model using Python for a credit card company to identify customers likely to churn soon, utilizing parameters such as spending patterns.
• Created an LLM model using Python to analyze customer sentiment based on feedback for an airline company. Process Mining Capstone Montclair State University
• Analysed ordering process inefficiencies and their impact on carbon emissions for a large chemical manufacturer using Celonis Analytics Practicum Capstone Montclair State University
• Examined healthcare disparities and telemedicine adoption in the US for TeleVU Inc. using Python and Tableau.
Professional Summary
• Celonis Rising Star - Business: by Celonis