Lokesh Sreenath Jakka Email & Phone Number

Fairfax, Va, Us

Fairfax, Va, Us

Vienna, Virginia, United States

United States

1.Analyzed and assessed railway component deterioration rates, including ballast balance and tie condition, to understand impacts on track geometry, employing "Visual Track Inspection" and "Maintenance Detection" methodologies for Class-1 Railroads.2.Designed, implemented, and maintained an integrated ETL pipeline within Azure Synapse, automating insight generation on new data arrivals with PySpark and SQL, resulting in a 30% reduction in Azure operational costs.3.Achieved a 89% accuracy rate in data alignment, significantly contributing to the research team's efforts in change detection and enhancing the reliability of the base data for further analysis.4.Developed custom Apache Airflow Python operators to facilitate seamless interactions with Azure Functions, Synapse, and Power BI through REST APIs, streamlining data workflow processes.5.Created a predictive Gradient Boosting Model to forecast track degradation for Class-1 railroads, achieving a recall score of 0.84 and leveraged database views for efficient data integration from Azure Blob to Power BI, resulting in a 50% improvement in report performance.6.Utilized Synapse Analytics and Azure Databricks for querying and processing large-scale datasets, harnessing Apache Spark’s distributed computing power for efficient data analysis.7.Visualized complex datasets using Power BI to provide intuitive, actionable insights into track condition and maintenance requirements, enhancing decision-making processes.8. Developing a prototype system to evaluate track structural health of railroad using Python to prevent track failure.

Urbana, Illinois, United States

Course SE100: Introduction to Industrial and Systems Engineering

Ahmedabad, Gujarat, India

1.Directed and implemented A/B testing to compare Zone picking and Wave picking strategies, optimizing warehouse operations and enhancing consolidation processes.2.Analyzed operational data using Python and MySQL, uncovering trends and inefficiencies that led to a 10% increase in productivity through the automation of routine data processing reports with VBA.3.Optimized worker time and steps by analyzing sales data, resulting in a 15% boost in daily productivity and operational efficiency.4.Streamlined SKU locations based on monthly forecasts to ensure efficient order processing and prevent resource shortages, enhancing supply chain reliability.5.Streamlined efficiency by integrating automatic price discount application into the ERP system using SQL Triggers6.Developed and deployed comprehensive dashboards to visualize key performance indicators (KPIs), achieving a 15% cost reduction through improved inventory management strategies.7.Resolved discrepancy claim ratio settlements by implementing thorough investigation protocols and negotiating effective resolutions, resulting in enhanced stakeholder satisfaction and reducing claim disputes by 20%.

Ahmedabad, Gujarat, India

1.Completed rigorous on-job training across Manufacturing & Supply Chain divisions, gaining comprehensive insights into the Automobile Industry's operations. 2.Contributed to designing a fool-proof detection system for the 'coolant pump inlet hole' in the Cylinder Head Machining Line, enhancing product quality and safety. 3.Transitioned to Warehouse Operations within the Supply Chain Division, further broadening operational understanding and efficiency.

Tiruchirappalli, Tamil Nadu, India

Roles and Responsibilities:1. Lead a team of 120 members with 5 team heads and 110 coordinators.2. Conducted Events, Workshops, and Seminars as a part of three-day symposium.3. Conducted Guest Lectures by the Industry Experts and Professors.

Vadodara, Gujarat, India

Worked along with Design & Engineering Services division to analyze Lubricating & Sealing systems of Compressors.

Tiruchirappalli, Tamil Nadu, India

Worked on "Enhancement of pool boiling on copper surface with porous material using coolant FC72" under the supervision of Dr. S Suresh. This project aims to address a problem in electrical components regarding excessive heating.

Master'S Degree, Industrial Engineering (Advanced Analytics), 3.89

Coursework: Fall-23 CS512 : Advanced Data Mining IE532 : Analysis of Network Data BADM594 : Independent Study Spring-23 CS411- Data-Base.

Bachelor Of Technology, Mechanical Engineering, 8.41