Data Analyst Quality Assurance

SUMMARY

Dinesh Mahankali

Data Analyst

973-***-**** *****************@*****.*** Dallas, Tx

Converts complex datasets into actionable insights using SQL and Python for thorough data analysis and preprocessing.

statistical methods and predictive modeling to enhance decision-making and drive business strategies.

Creates compelling visualizations with Tableau to effectively present findings to diverse audiences. Ensures high standards of data quality and governance through meticulous quality assurance practices.

Optimizes and manages design projects, ensuring adherence to technical requirements and improving system performance.

Drives organizational design and change management initiatives to enhance efficiency and effectiveness.

Proficient in applying advanced statistical methods with R and Python to discover trends, patterns, and relationships within complex datasets.

Experience building predictive models to support data-driven decision-making and generating detailed reports with SQL and Excel to deliver key insights.

Evaluated design costs and compiled detailed project packages, which included design layouts, bills of materials, and equipment ordering information, to ensure effective project implementation.

Directed efforts in organizational design and planning, focusing on change management and root cause analysis to enhance processes and improve overall organizational effectiveness. SKILLS

Methodologies: SDLC, Agile, Waterfall

Programming Language: Python, SQL, R

Packages: NumPy, Pandas, Matplotlib

Tools: Tableau, Power BI, Advanced Excel (Pivot Tables, VLOOKUP), Quick Sight IDEs: Visual Studio Code, PyCharm, Jupyter Notebook Database: MySQL, PostgreSQL, MongoDB, SQL Server

Cloud Platforms: AWS, Microsoft Azure

Operating Systems: Windows, Linux, Mac OS

EXPERIENCE

Data Analyst June 2023– June 2024

Deloitte - Dallas, TX

Gathered and verified data from various internal and external sources, using SQL for database queries and Excel for data aggregation, ensuring accuracy and reliability.

Cleaned and preprocessed raw data using the Python programming language with Pandas library, addressing missing or inconsistent data to prepare it for analysis.

Applied R and Python statistical methods to interpret complex datasets, identifying patterns, trends, and correlations.

Created visualizations using tools like Tableau to develop charts, graphs, and dashboards that effectively communicated findings to non-technical stakeholders.

Built predictive models and performed statistical analysis using R and Python to enhance data-driven decision-making processes.

Generated comprehensive reports using SQL for database queries and Excel for data manipulation, summarizing key insights for business operations.

Ensured data quality and integrity using SQL for database management and contributed to data governance policies with tools like Excel for documentation and data validation. Design Analyst Oct 2020 – Apr 2023

Arka Groups - Hyderabad, TS

Implemented rigorous database quality assurance checks, ensuring data accuracy and consistency for reliable analytics and decision-making.

Designed and optimized broadband communication systems using advanced design software, enhancing system performance and meeting technical specifications.

Partnered with external vendors to develop design criteria, preparing detailed layout and design drawings to ensure alignment with project requirements.

Monitored construction and installation processes to ensure compliance with established drawings, specifications, and schedules, guaranteeing adherence to project standards.

Conducted design cost reviews and generated comprehensive project packages, including design prints, bills of materials, and equipment ordering information, to support efficient project execution.

Led efforts in organizational design and planning, including change management and root cause analysis, to optimize processes and support effective organizational structure. EDUCATION

Master of Science in Information Technology -Indiana Wesleyan University, Indiana, USA Bachelor of Science in Civil Engineer - Sathyabama University, Chennai, India Design Analyst Oct 2020 – Apr 2023

Arka Groups - Hyderabad, TS

Implemented rigorous database quality assurance checks, ensuring data accuracy and consistency for reliable analytics and decision-making.

Designed and optimized broadband communication systems using advanced design software, enhancing system performance and meeting technical specifications.

Partnered with external vendors to develop design criteria, preparing detailed layout and design drawings to ensure alignment with project requirements.

Monitored construction and installation processes to ensure compliance with established drawings, specifications, and schedules, guaranteeing adherence to project standards.

Conducted design cost reviews and generated comprehensive project packages, including design prints, bills of materials, and equipment ordering information, to support efficient project execution.

Led efforts in organizational design and planning, including change management and root cause analysis, to optimize processes and support effective organizational structure. EDUCATION

Master of Science in Information Technology -Indiana Wesleyan University, Indiana, USA Bachelor of Science in Civil Engineer - Sathyabama University, Chennai, India

Contact this candidate