Achyuth Ayinala

Achyuth Ayinala

Data Analyst
United States of America

About Me

Experienced Data Analyst with 3+ years of expertise in SDLC methodologies including Agile and Waterfall. Proficient in Python, R, SQL, and MATLAB with skills in data modeling, data visualization, and ETL processes. Demon…

Experience

Data Analyst

EPIC
Feb 2022 - Present · 4 years 5 months

• Follow the Agile Methodology of Project Management.
• Use packages like ggplot2 in R Studio for data visualization and generated scatter plots and high-low
graphs to identify the relationship between different variables.
• Created SSIS Packages by using transformations like Derived Column, Sort, Lookup, Conditional Split,
Merge Join, Union and Execute SQL Task to load into database.
• Collecting and iteratively refining specifications from management to augment current pivot table
reporting with high-quality dashboard visualizations in Excel.
• Extensively used ERWIN and Power Designer to design Logical and Physical Data Models, to forward and
reverse engineering data models and publishing data model to acrobat PDF files.
• Wrote several complex SQL queries to extensively test the ETL process.
• Working on developing Python script for the whole data science project life cycle including data
acquisition, data cleaning, data exploration, and data modeling.
• Performing data analysis and maintenance on information stored in MySQL database.

Data Analyst

EPIC, USA
Present

Followed the Agile Methodology of Project Management.
Used packages like ggplot2 in R Studio for data visualization and generated scatter plots and high-low graphs to identify the relationship between different variables.
Created SSIS Packages by using transformations like Derived Column, Sort, Lookup, Conditional Split, Merge Join, Union and Execute SQL Task to load into database.
Collected and iteratively refined specifications from management to augment current pivot table reporting with high-quality dashboard visualizations in Excel.
Extensively used ERWIN and Power Designer to design Logical and Physical Data Models, to forward and reverse engineering data models and publishing data model to acrobat PDF files.
Wrote several complex SQL queries to extensively test the ETL process.
Worked on developing Python script for the whole data science project life cycle including data acquisition, data cleaning, data exploration, and data modeling.
Performed data analysis and maintenance on information stored in MySQL database.

Jr. Data Analyst

Magna Infotech, USA

Utilized the Waterfall methodology of development for Requirements, Planning, Design, and Deployment.
Used Python library to represent data in a pictorial form for better understanding.
Created customized reports pointing to the reporting servers per the business request using Power BI.
Skilled in Python modules like Pandas, NumPy, Matplotlib, Scikit - learn, Pisidia, SciPy, PyTables and generating complex graphical data.
Cleaned and Organized data into Tableau & Tableau Prep using data mining processes using ETL, and data warehousing and designed a star schema using SQL Server.
Performed data analysis and data profiling using complex SQL queries on various source systems including SQL Server.

Skills

Analytics Data Analysis Professional Information Systems Management Data Mining Microsoft Access Statistical Analysis System (SAS) Structured Query Language (SQL) Data Representation Data Analysis Skills Power BI R Programming Language (R) Tableau Python PostgreSQL ETL Processes Problem-Solving Seaborn MS Excel Data Analysis AWS S3 Pandas DAX MS SQL MySQL Statistical Analysis AWS RDS NumPy PySpark Matplotlib Agile Waterfall MATLAB Data Modeling Informatica SSIS ggplot2 R Studio Excel ERWIN Power Designer Data Warehousing SQL Server Scikit-learn SciPy PyTables
Report this Profile?