LSLakkoju Sandeep is a driven Business Analyst with experience in financial services and data pipeline automation. He possesses strong analytical skills, demonstrated by building automated systems using Python, SQL, and BigQuery. He is proficient in transforming unstructured data and developing comprehensive dashboards to drive business insights.
Experience
Business Analyst
GroMo
Built automated data pipeline to convert highly unstructured Excel data to a Columnar SQL Database using Python to enable a Web Dashboard for Sales Team - 100% Increase in Productivity. Built automated Payout System using SQL to process total of Rs. 10 Crores payments till date to our partners on a Daily basis - 100% Increase in Productivity. Built Business Overview Dashboard using SQL and BigQuery by Identifying relevant Product and Business Metrics through out Customer Journey for Executive Core Team. Built Dashboard to track Customer Acquisition Cost for Marketing Team by Accumulating and Attributing all Costs through out Customer Journey. Built Automatic Alert System using Zoho Analytics to notify significant daily changes in the Identified Key Metrics to relevant Stakeholders.
Sales Operations Analyst
Syneos Health
Built a self service analytical Dashboard from Scratch for the Strategic Pricing Team using Power BI. Built an automated Excel tool to generate insights of Sales Opportunities movements in the pipeline WoW using Power Query.
Management Trainee
Larsen & Toubro Limited
Built a simple linear regression model that can help forecast the progress of construction projects. Built a pipeline that can help retrieve historical project execution data instantly using Excel and Power BI.
Education
Indian Institute of Technology, Kharagpur
B. Tech & M. Tech Dual Degree
Mechanical Engineering
Damage Detection in thin Aluminum plates using Machine Learning. Used ML algorithms such as SVM, NN to locate the damage.