Naga Ravi Teja Lella

Projects: Web applications & Data analytics for Paysmart.AI | Jun 22 – Present

• Lead strategic design and implementation of scalable ETL frameworks using Alteryx and MS SQL Server, ensuring regulatory alignment with Fair Work Australia guidelines
• Architected end-to-end data pipelines and QA automation scripts in Python to streamline payroll compliance analysis
• Spearheaded the development of intelligent web applications to interpret complex FWO clauses, improving operational efficiency for clients
• Led cross-functional teams (data analysts, developers, testers) across multiple workstreams, driving agile delivery and stakeholder engagement
• Oversaw dashboard development using Tableau and Power BI to deliver high-impact KPIs and compliance risk summaries to C-level executives
• Provided technical mentorship to junior analysts and defined best practices for analytics and visualization across the project lifecycle
• Partnered with business leads to shape analytical roadmaps, risk models, and data governance strategies

Tech Stack: Python, SQL, Tableau, Alteryx

• Create Alteryx workflows for large data ETL and store the data in Microsoft SQL Server.
• Perform QA analysis on the data transformations using python.
• Develop KPI’s to show valuable insights to the client using Tableau, Power-BI.
• Develop standalone web application using python to provide user about the details related to various FWO clauses.
• Develop ML models to forecast/ predict risks in the employee payroll data.
• Mentor Analysts/ Grads in training them on various technologies such as Python, SQL, Tableau, Alteryx & Front-End technologies.

Tech Stack: Python, SQL, Tableau, Alteryx, Java Script (Basics), ReactJS, AWS

• Handling digital operations of 3 key business units: LG - OAKVILLE, LG – MIAMI & WROCLAW - POLAND
• The digital projects involve development of various web applications & Tableau dashboards.
• Provided KPIs, analyzed metrics and generated reports that were used at the highest levels of executive management to make decisions for all operations shop floor units.
• Led a team of 5 software engineers who are involved in various development activities such as Back End development, Junior Data Analysts & Tableau Developers.
• Eliminated nonessential manual data collection processes, Standardized data entry procedures, automated data collection and storage.
• Design data gathering structure aggregating all relevant metrics and sources providing comprehensive insights and reporting.
• The digital activities performed have shown a gross savings of approximately $580K for the customers/ business units.
• Prognostic Health Monitoring: Developed time-series forecasting models to predict the failures in the aircraft parts by gathering the data from flight sensors. This applications enables the maintenance staff to identify the defects in a pre-emptive manner and avoid delays in the maintenance process.

Tech Stack: Tableau, Python, Alteryx, SQL, SAP (Data Extraction), Selenium(web-scrapping)

• Worked with stakeholders/ BAs to design and build various visualizations. Translated various business requirements into specifications for implementing reports and dashboards.
• Created ETL pipelines in python for extracting the data from SAP and transforming it to the meaningful structure and loading it into the SQL database.
• Built and published 20+ interactive dashboards on Tableau which provides various insights & KPI’s such as OTD (ON TIME DELIVERY), Milestones, Productivity, Efficiency, Utilization, Turnback etc., for the operations shop floor.

Tech Stack: VBA, MATLAB, C

• Played a key role in formulating development strategies & managed development operations of Maintenance Software
• The maintenance software application is used for the training maintenance crew of AIRBUS aircrafts
• Client Relationship Management
• Got recognized for my excellence in development work and the in-time quality delivery with a spot award
• Ensured healthy relations and facilitated expertise to the client
• Developed VBA Macros to generate 2D drawings from 3D Part Models, which improved the efficiency by 80%
• Developed core-application software used for training maintenance crew for AIRBUS-A380 aircraft

Tech Stack: DOORS, Python

• Formulated system requirements for FLAP & SLAT actuation systems for KC-390 flight program
• Developed Python Scripts to verify FLAP & SLAT software in core-stand unit.

Tech Stack: MATLAB, Python, C

• Played a key role in formulating development & testing strategies for cockpit display
• Client Relationship Management
• Got recognized many times for my excellence in development work and the in-time quality delivery
• Delivered high quality services for customer delight & ensured minimum efforts consumption for efficiency standards
• Developed software modules for cockpit display applications such as PFD, NM, EICAS, DWM, & MAINTENANCE
• Performed unit testing using vista tool for the developed artifacts, to ensure the software is bug free
• Drafted automated software testing strategies deploying Python to increase the efficiency of artifacts implementation