Pankaj Mahato
Gurugram
Summary
Highly analytical Data Analyst with 3 years of progressive experience, adept at transforming complex datasets into actionable insights. Proficient in SQL, Python, Excel, and Power BI, with a proven track record of developing data-driven solutions and automating processes to foster business growth. Experienced in diverse corporate environments, including National Australian Bank, P360, and Optum.
Overview
3
3
years of professional experience
Work History
Software Engineer
Reqpedia Technologies (United Healthcare- Optum)
04.2024 - Current
- Spearheaded data-driven automation for an Optum-based LLM project (VOICE), developing a chatbot that automated 40% of routine data-related tasks and reduced turnaround time.
- Led the end-to-end development and deployment of an automation project, streamlining operations and cutting manual data processing effort by 70%.
- Engineered Selenium-based automation solutions to optimize data ingestion pipelines, enabling the efficient delivery of 2.5 million records within a month.
- Built interactive dashboards in Tableau for data visualization, providing actionable insights to stakeholders and improving decision-making processes.
- Designed and delivered PowerPoint presentations to communicate complex data findings in an accessible, visually compelling manner to both technical and non-technical audiences.
- Collaborated with cross-functional teams to translate business requirements into robust, data-driven solutions, ensuring project success and stakeholder alignment.
- Contributed to Risk Management by identifying and monitoring critical SLAs (Service Level Agreements), proactively flagging potential breaches, and recommending mitigation strategies to maintain operational excellence.
- Supported ongoing SLA compliance reviews and reporting, helping ensure timely delivery and minimizing risk exposure across key business processes.
Software Engineer
Optiks Innovation
08.2023 - 04.2024
- Applied SQL and Python for comprehensive data analysis and leveraged Selenium for automation, optimizing critical data workflows.
- Implemented automated data validation and testing processes, achieving an 80% improvement in data efficiency and accuracy.
- Delivered data automation solutions that reduced manual data preparation and reporting efforts by 40%.
- Developed data-backed project projections and predictive models that contributed to an 8% increase in project profitability.
- Created interactive Tableau dashboards to visualize complex data trends, supporting faster, more informed decision-making for stakeholders.
- Collaborated to enhance data automation processes within the system, improving data flow and reporting capabilities.
- Introduced innovative data workflow automation techniques, enhancing overall operational efficiency.
- Contributed to Risk Management by identifying and monitoring critical SLAs, helping mitigate potential breaches and ensuring consistent service delivery.
System's Engineer
Infosys - National Australian Bank
03.2022 - 08.2023
- Utilized SQL extensively to design, query, and manage databases, ensuring data integrity and reliability for critical banking operations.
- Developed and executed Python scripts to automate repetitive data extraction and processing tasks, significantly improving productivity.
- Leveraged Selenium to build robust automation frameworks for web-based data collection and processing workflows.
- Performed rigorous review and debugging of data scripts to ensure data accuracy and resolve issues promptly.
- Collaborated with cross-functional teams to define data automation requirements and deliver high-quality, data-driven solutions.
- Performed data analysis to identify trends and patterns, providing valuable insights for strategic decision-making.
Education
Civil Engineering -
Siliguri Institute of Technology
08.2021
Skills
- Excel
- Python
- Pandas
- Powerpoint
- Tableu
- Data cleaning
- SQL Database Design
- Query Optimization
- Dashboard creation
- Data synchronization
- Defect tracking
- Visual data representation
Timeline
Software Engineer
Reqpedia Technologies (United Healthcare- Optum)
04.2024 - Current
Software Engineer
Optiks Innovation
08.2023 - 04.2024
System's Engineer
Infosys - National Australian Bank
03.2022 - 08.2023
Civil Engineering -
Siliguri Institute of Technology
Similar Profiles
Scarlett GilScarlett Gil
Medical Assistant II at United Healthcare- OptumMedical Assistant II at United Healthcare- Optum
Alexia WoodardAlexia Woodard
Remote Billing Specialist at United Healthcare- OptumRemote Billing Specialist at United Healthcare- Optum
Miriah BoocherMiriah Boocher
Clinical Resource Lead at United HealthGroup, United Healthcare, OptumClinical Resource Lead at United HealthGroup, United Healthcare, Optum
Ashish ChandraAshish Chandra
Commercial Order Creation Manager at Orange BusinessCommercial Order Creation Manager at Orange Business
Megha TanwarMegha Tanwar
HR Manager at Varank Tech Private Limited (Formerly Verchaska Infotech)HR Manager at Varank Tech Private Limited (Formerly Verchaska Infotech)