Data Analyst

Ajay Vishnu Inakollu

+1-214-***-**** **************@*****.*** LinkedIn Denton, TX

SUMMARY

Data Analyst with over four years of hands-on experience in business intelligence, automation, and data analytics. Proficient in Excel, SQL, Tableau, and Power BI for creating insightful reports and interactive dashboards. Skilled in advanced data modeling, ETL processes, and predictive analytics using Python and AWS. Strong background in machine learning, healthcare data analysis, and conducting thorough User Acceptance Testing (UAT). Adept at data cleaning, optimizing data quality, and supporting data-driven decision-making. TECHNICAL SKILLS

Methodology: SDLC, Agile, Waterfall, Scrum, Kanban Languages: Python, SQL, PL/ SQL

Statistical Software: SPSS, SAS, R

Packages: NumPy, Pandas, Matplotlib, SciPy, SeaBorn, Scikit-learn Databases: MySQL, SQL Server, MS Access, Oracle, NoSQL Cloud Computing: AWS (EC2, S3, RDS, Lambda), Azure, GCP Machine Learning Frameworks: NLTK, Spacy, TensorFlow, Keras Data Analytics Techniques: Data Warehousing, Data Cleaning, Data Visualization, Data Pipelines, A/B Testing, Predictive Analytics Visualization Tools: Tableau, Power BI, Advanced Excel (Pivot, VLOOKUP, Data Analysis), SSRS, QlikView

ETL Processes: Python, SQL, SSIS, Excel Automation Automation Tools: Apache Airflow

IDEs: Google Colab, Anaconda, Jupyter, Android studio, VS Code Healthcare Data Terminologies: ICD-10, CPT, HCPCS Codes Project Skills: Requirements gathering, Agile (Scrum), POC to Production, UAT (User Acceptance Testing), Project Management Certifications: Google Analytics, Azure Cloud, Tableau Certification PROFESSIONAL EXPERIENCE

Data Analyst

Accurate Health Group LLC, USA Aug 2022 – Present

• Utilized the Waterfall methodology for development, including comprehensive requirements planning, design, and deployment.

• Executed SQL queries to extract and analyze data from relational databases, achieving a 10% improvement in data accessibility.

• Optimized data models to significantly increase efficiency by 25% and drastically reduce processing time for large datasets (>1TB).

• Improved overall data quality by 15% through thorough data cleaning and preprocessing, significantly enhancing data accuracy.

• Performed advanced statistical analysis and data mining, consistently delivering actionable insights for strategic decision-making.

• Developed and automated efficient ETL processes using Python, SQL, and SSIS, significantly reducing manual data handling by 20%.

• Created interactive dashboards and reports using Tableau, Power BI and SSRS, improving data accessibility and understanding.

• Reduced infrastructure costs by 30% through leveraging AWS to ensure scalable and efficient data processing and storage solutions.

• Enhanced fraud detection accuracy by 40% by effectively applying advanced machine learning models to identify fraudulent cases.

• Reviewed and analyzed medical claims data for accuracy and compliance, supporting effective healthcare business decision-making.

• Conducted comprehensive User Acceptance Testing (UAT) for healthcare analytics projects, ensuring regulatory compliance.

• Leveraged extensive knowledge of ICD-10, CPT, and HCPCS codes to validate healthcare datasets, increasing data accuracy by 20%.

• Partnered with cross-functional teams to define and track key performance indicators (KPIs), increasing operational transparency. Jr. Data Analyst

Sigma InfoTech, India Jun 2019 - Jul 2021

• Developed real-time web applications with Python and Flask, consistently delivering interactive data visualizations to end-users.

• Conducted exploratory data analysis (EDA) using Python, identifying key trends and actionable insights to inform business strategies.

• Automated complex data extraction and transformation processes using SQL and Python, improving data pipeline efficiency by 20%.

• Created and maintained 50+ SQL scripts for extracting and analyzing data from medical claims databases, enhancing accuracy.

• Deployed interactive Power BI dashboards to provide real-time insights into key business metrics, improving decision-making.

• Analyzed large datasets using various advanced statistical techniques, validating hypotheses and supporting data-driven decisions.

• Optimized complex SQL queries and indexing, reducing data retrieval times by 30% and improving overall system performance.

• Automated scheduled data pipeline processes with Apache Airflow, ensuring timely data updates and reducing manual interventions.

• Managed and optimized MySQL databases, ensuring data integrity, performance optimization, and consistent data availability.

• Translated business requirements into technical specifications, enabling effective data solutions and smooth project execution. PROJECTS

Predictive Maintenance Optimization

• Engineered a predictive maintenance solution using Python and SQL, achieving 92% accuracy in predicting equipment failures.

• Constructed Tableau dashboards visualizing equipment health, leading to a 15% cost reduction and improved operational efficiency. Sentiment Analysis of Customer Reviews

• Orchestrated a machine learning model using NLP, achieving 90% accuracy in categorizing customer reviews and improving by 15%.

• Utilized libraries like Spacy and NLTK, reducing processing time by 30% and using Power BI to enhance data interpretation by 40%. EDUCATION

Master of Science, Business Analytics

The University of Texas at Dallas August 2021 - May 2023 Scholarship(s) - Dean’s Excellence Scholarship

Bachelor of Technology, Electronics and Communication Engineering SASTRA University, Thanjavur, Tamil Nadu, India June 2016 - June 2020

Contact this candidate