Akhil Boga 📊

Experience

• 

  Anagha Softech Pvt Ltd

  Jan 2018 - Apr 2018

  Data Analyst Intern

  • Utilized SQL for querying and manipulating data, enhancing data retrieval speed and accuracy.• Employed basic data visualization techniques using tools like Matplotlib or Seaborn to present data insights visually.• Executed ETL processes using Hadoop, Ab-initio, and MDM systems, ensuring efficient data integration and management.• Leveraged Python data frame libraries such as Pandas for data manipulation tasks, streamlining data processing workflows.• Ensured data quality and integrity by performing data preprocessing tasks, including data cleaning and normalization. Show less

• 

  Tata Consultancy Services

  Apr 2018 - Dec 2021

  Data Analyst

  • Implemented ETL processes using Python and SQL, automating data integration tasks and reducing manual effort by 40%.• Created insightful reports using Power BI, enabling stakeholders to gain insights into key performance metrics.• Developed data models for the company's data warehouse, enabling efficient data storage and retrieval• Managed database systems, ensuring data availability, reliability, and security in compliance with industry standards.• Employed Docker and Kubernetes for containerization and orchestration of applications, enhancing scalability and reliability.• Streamlined data pipeline deployments using Jenkins for CI/CD, reducing deployment time and increasing efficiency. Show less

• 

  University of North Texas

  Jan 2023 - May 2023

  Instructional Assistant

  - Utilized Tableau, PowerBI, Vizhub, and a wide range of Python libraries (Pandas, NumPy, matplotlib, seaborn) to enhance student understanding of complex data through interactive visualizations.- Guided students in hands-on projects that utilized Python for data analysis and visualization, including machine learning and NLP applications for extracting valuable insights.- Demonstrated effective use of MS Excel for data preprocessing, cleaning, and transformation, preparing students for advanced analysis using specialized tools.- Guided students in the application of NLP for text analysis, sentiment analysis, and text summarization, enhancing their knowledge of natural language processing techniques. Show less

• 

  DataEdge

  Jul 2023 - Mar 2024

  Data Analyst

  • Engineered data ingestion and transformation processes in SQL and Python, integrated with cloud-based data lakes on AWS,supporting scalable and reliable data storage solutions.• Implemented ETL processes using Python, SQL and HQL, ensuring efficient data extraction, transformation, and loading.• Performed data cleansing and preparation using Python libraries like Pandas, ensuring high data quality for analysis.• Utilized R and Alteryx for advanced data analysis and visualization, improving the accuracy and clarity of reports.• Conducted statistical analysis and hypothesis testing to derive actionable insights, leading to a 15% increase in revenue.• Leveraged cloud platforms such as AWS and GCP to deploy and manage data infrastructure, reducing operational costs. Show less

• 

  Betty Hardwick Center

  Mar 2024 - now

  Senior Data Analyst

  • Built and optimized data pipelines using Python, SQL and Apache Spark, enabling real-time reporting and advanced analyticsfor internal stakeholders, which improved data accessibility by 30%.• Developed PowerBI and Tableau dashboards to assess patient demographics and directly reported to CAO and CFO.• Implemented SQL stored procedures for nightly data refreshes, ensuring up-to-date information for business operations.• Developed and maintained data analysis scripts using Python, leveraging libraries such as NumPy and Pandas.• Automated BAU data processing tasks using Unix Scripting, reducing manual effort by 20%.• Deployed and managed data infrastructure on GCP and AWS, optimizing cost and performance for data processing tasks. Show less