Chaitanya Jajula

ad04bx@r.postjobfree.com 779-***-**** Illinois, USA

EDUCATION

Northern Illinois University Dekalb, IL

Master of Science in Management Information Systems Expected Graduation: Dec 2023

● Relevant Coursework: Database Management Systems, Business System Analysis and Design, Python, SAP ERP, I Project Management, Social Media Analytics for Business, Advance predict data analytic, Text Mining BVRIT Hyderabad College of Engineering for Women Hyderabad, India Bachelor’s in Electronics and Communication Engineering Nov 2020 SKILLS

● SQL (MS SQL Server, MySQL)

● Advanced Microsoft Excel ( VLookup, Advanced Formulas, Pivot Table, VBA, Macros)

● Microsoft Power BI

● Tableau

● Python (Pandas, NumPy, Matplotlib)

● SAS

WORK EXPERIENCE

Soulpro Infologix Hyderabad, India

Data Analyst Dec 2020 - Dec 2021

● Utilized Excel to review and manipulate raw data, resulting in a 20% increase in data accuracy and a 15% reduction in processing time.

● Utilized Tableau to create interactive dashboards that allowed for real-time analysis of customer behavior, resulting in a 15% increase in customer satisfaction scores.

● Collaborated with cross-functional teams to recommend customized insurance schemes based on individual customer needs, resulting in a 20% increase in customer satisfaction ratings. PROJECTS

Business 360 - Brick & motor and e-commerce [Power BI SQL Excel Dax Studio]

● Built a Power BI dashboard to analyze vrinda hardware's sales trends over the globe by gathering data from Excel/CSV files and a SQL database, creating a data model and visualizations in Power BI, and optimizing the report with DAX studio.

● The dashboard helped vrinda hardware understand different department's sales trends and make data-driven decisions. This project could increase the revenue by 10% and reduce data related expenses by 20% Sales Insights – Brick & motor business [Power BI SQL]

● Designed a Power BI dashboard to understand AtliQ hardware goods sales trend.

● The final dashboard was effective at displaying the sales trend of AtliQ hardware, allowing users to understand the data and make informed decisions.

● This dashboard could help in increasing the revenue at least by 7% in the next quarter. Revenue insights in hospitality domain – Cricket Analysis [Power BI Excel]

● Innovatech Solutions noticed a loss in their market share and revenue over a few months. To understand the cause of this loss, they needed a way to analyze this. I created a dashboard in Power BI using three months of data.

● With the created dashboard, the Revenue team of Innovatech Solutions were able to gain insights about their revenue trend. This could help in regaining their revenue and market share by 20% in the next month. CERTIFICATION

● SAP Certified Application Associate - Business Process Integration with SAP S/4HANA 2020

● Data Analytics using Power BI

Contact this candidate