UPENDAR KONERU

Highly motivated Data Analyst seeking a challenging role to leverage analytical and technical skills, contributing to organizational success through data-driven decision-making.

Proficient in utilizing Advanced Excel functions and formulas for in-depth data analysis. Strong background in Management Information Systems (MIS) and data analysis, with experience in data visualization, data modeling, business intelligence and VBA Automation. Enhanced data quality and accuracy by using Excel and VBA to implement data cleansing, transformation, and validation rules and procedures. Streamlined and improved business processes and workflows by using Power BI and Qlik Sense to integrate and automate data collection, analysis, and presentation. Ability to use batch files to schedule and automate tasks, such as running backups and data exports at specific intervals. Worked on integration of Power Automate with various applications, both Microsoft and third-party, to enable seamless data flow and collaboration. Worked on renaming contracts and assigned for reviewing using Batch file Automation. Developed tools at project level to handle the progress of the project. Reconciliation of contracts and organize them in a proper way to help the team for summarization. Proficient in creating interactive reports using Power BI and Qlik Sense and share with stakeholders. Experience in cloud base visualization tool Klipfolio. Developed and maintained a KPI dashboards with real time insights into key performance indicators. Proficient in data modeling, extraction, transformation, and visualization using Power BI. Strong knowledge of Data Analysis Expressions (DAX) for advanced calculations and measures. Expertise in VBA Excel Macro development, automating repetitive tasks, and enhancing functionality. Proven track record of collaborating with teams, understanding business requirements, and delivering effective solutions. Development of training materials and conducting sessions for end-users.