Lokesh

Data Scientist – Accenture AI Aug 2022-present Predictive Asset Management of Wooden Poles| American Energy Company

 Experienced in using Python, R and PowerBI for predictive analytics to assess the condition of wooden poles and predict their remaining lifespan.

 Got Exposure in developing and implementing predictive asset management strategies for wooden poles reducing CAPEX by 0.1 Million USD (9.2% ) and OPEX by 0.05 Million USD (13.4%) Annually.

 Proven ability to reduce (13% ) the risk of pole failures and improve (7.5%) the reliability of electrical distribution networks Data Quality Dashboard | International Manufacturing Company

 Developed a PowerBI solution for a paper manufacturing company to facilitate them with the Accuracy, Timeliness and Consistency of incoming data to perform further critical analysis and decisions.

 Created Azure Pipeline from Azure Data Factory services to write a Python script which takes raw data as input and store the output in. MySQL database was used to power the visuals in PowerBI. Transformed Operational Reporting Process | US Based Energy Utility Company  Designed and implemented an end-to-end data pipeline using AWS SFTP, Lambda, and S3 services to ingest and process data from various sources, including network drive, FTP site, and API.

 Preprocessed and transformed data based on Data models and KPI metrics, standardizing and cleansing it before moving it to a curated zone for consumption.  Loaded the final dataset into RDS tables, created views for Power BI reports, and connected various data sources using on-prem data gateway in PBI Desktop. Utilized Power Apps and Power Automate to update PI system data and send notifications, resulting in improved operational efficiency and informed decisionmaking for users Legal Entity Financial Quality Reporting | US Multinational Conglomerate

 Analyzed and modeled Financial data from Excel to Tableau, saving 2750 hours annually for a US multinational conglomerate.

 Developed advanced analytics reports, including parameterized and drill-down reports, enabling clients to shortlist legal entities based on financial metrics.

 Created a deep-dive dashboard for clients to track projects, accounts, and financial metrics across various legal entities, resulting in improved financial reporting structure and operational efficiency. Road Condition Monitoring | South Africa-based Diversified Resources Company

 Utilized Python and Advance Excel to clean and explore IoT sensor data of coal hauling trucks for a South African Diversified Resources Company's Road Condition Monitoring.

 Used Power BI to enhance predictive maintenance by creating custom visuals with DAX formulas, enabling identification of poor road conditions, key factors impacting truck vibration, resulting in data-driven decision-making and increased operational efficiency.