Lohith Lohith Aleti Reddy
Data Analyst @InfoCepts
Signup · Get unlimited contacts
WORK HISTORY
Data Analyst @InfoCepts
Designed and developed interactive Power BI dashboards to track key business metrics including sales, supply chain, and inventory turnover, improving reporting visibility and reducing decision-making time by 30%.• Built and optimized advanced DAX measures for sales growth, profitability, variance analysis, and forecast accuracy across 50+ product categories, enabling more precise forecasting and faster insight generation for stakeholders.• Built efficient data models and relationships in Power BI by integrating data from SQL Server, Excel, and Azure based sources, improving data preparation and cutting query load times by up to 30%.• Automated report refreshes and scheduled reporting workflows through Power BI Service and Gateway, improving reliability and reducing manual effort.• Worked with business users and leaders to define KPIs, create useful financial and operational reports, and boost data adoption across teams, leading to increased use of analytics in decision-making.• Wrote and optimized complex SQL queries, joins, CTEs, and stored procedures in Oracle to extract, transform, and prepare data, enabling faster report generation for analytics• Performed trend, variance, and correlation analysis using Power BI and SQL, identifying inefficiencies and cost drivers that led to process changes and a 10% reduction in operating costs.• Automated weekly inventory and business reports using Excel macros and Power Query, reducing manual processing time by 60%.• Implemented validation checks, reconciliation processes, and cross-system comparisons that reduced reporting errors by 30% and improved overall data accuracy.• Worked closely with IT and data engineering teams to identify and resolve Power BI dataset issues, leading to faster refresh times, more stable dashboards, and more reliable decision making.
EDUCATION
University of Central Missouri
Master's Degree, Computer Science
Guru Nanak Institutions(GNI)
Bachelor of Technology, Computer Science
ABOUT LOHITH LOHITH ALETI REDDY
With a strong academic foundation in computer science from Guru Nanak Institutions and ongoing postgraduate studies at the University of Central Missouri, I currently contribute as a Data Analyst at InfoCepts. I specialize in Power BI dashboard design, data modeling, and advanced DAX measures, seamlessly blending data from SQL Server, Excel, and Azure to enhance reporting accuracy and efficiency. My work focuses on delivering actionable insights into key business metrics such as sales, supply chain, and inventory turnover. At InfoCepts, I have collaborated with teams to automate reporting workflows via Power BI Service and Gateway, driving operational efficiency and enabling better decision-making. My goal is to leverage data analytics to empower organizations with scalable, data-driven solutions. I am motivated by fostering informed decision-making and building systems that promote efficiency and agility. My collaborative approach ensures alignment with organizational goals and enhances team success.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.