Learn Data Skills
Beta
Avinash Kumar

Avinash Kumar

Data Analyst

Alexander Youth Network

Technologies

My Portfolio Highlights

My New Course

DAX Functions in Power BI

My New Course

Intermediate SQL

My New Course

Analyzing Data in Spreadsheets

Data virtuoso, playing the strings of information to create harmonious insights.

My Work

Take a look at my latest work.

course

Introduction to Power BI

course

Introduction to DAX in Power BI

course

DAX Functions in Power BI

course

Introduction to SQL

course

Intermediate SQL

workspace

Project: Analyzing Students' Mental Health in SQL

course

Analyzing Data in Spreadsheets

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

Alexander Youth Network | Oct 2021 - Present

Data Analyst

• Utilize historical data sets and planned product changes to model and query for business trends. • Responsible for tracking and reporting on operational initiatives, trends and status reports. • Moderate to expert understanding of data systems, data integrity, and data validation. • Understanding of data marts, data lakes, and data warehousing. • Extract information from a variety of source platforms, such as databases, data lakes, APIs, flat files, or other cloud-based platforms using Snowflake • Prepare the retrieved data for storage and analysis in Snowflake by transforming and cleaning it. • To rectify missing, inaccurate, or inconsistent data, use data quality checks and data cleansing procedures. • Execute data aggregation, enrichment, and other transformations in accordance with business needs. • To create and manage Snowflake schemas that are in line with business requirements, work with data architects and data engineers. • Responsible for project management duties such as defining scope, timelines, cost and agile methodology using azure devops. • Analyze AYN's operations for trends, volume, demographics, and operator metrics to support decisions • Utilize the analytics tools to carry out statistical analysis and ad hoc reporting as required using python. • Develop analytics to identify trend lines across several data sources within the organization. • Apply predictive analysis and tools (including an enhanced ability to quantify and qualify data) using python and machine learning algorithms. • Providing technical expertise in data storage structures, data mining, and data cleansing. • Create and maintain dashboards and publish reports to app server using Power BI. • Design, create and test SQL reports using SSRS. • Collect, extract, clean, transform and merge data using SSIS. • Creating data modeling, views and optimizing queries in Sql using Sql Server. • Using SAS, I do some statistical analysis to find outliers and improve efficiency by looking at different trends. • Strong organizational skills including attention to detail, and strong communication with clients.
Show More

Medical Mutual of Ohio | May 2021 - Aug 2021

IT Intern

• Created a dashboard to visualize control charts using SPC techniques. • One major concern of this project was to track finalized claims over time and look for any inconsistency or instability of the processes due to any change. • Used R Studio and IBM DB2 tools to work on data and used ETL techniques to normalize the data in a structured format. • With this project, Business teams of medical mutual can see outliers or out-of-control signals in data and can fix them if they occur. They can predict the outcomes for upcoming times by looking at past trends. • Analyzed claims data to identify patterns, trends, and anomalies. • Automate Claims Processing, detect fraudulent claims, and improve efficiency. • Streamlined workflows, reduced claims processing time, and enhance accuracy in claims adjudication. • identified patterns and factors that led to increased risk by analyzing historical claims data, demographic information, and health outcomes.

Cleveland State University | Aug 2020 - May 2021

Graduate Assistant

N/A

Nayapay | Feb 2018 - Dec 2019

Business Analyst

• Conferred with business application users in identifying and gathering user requirements and develop logical and physical specifications. • Reviewed requirements, specifications and technical design documents to provide timely and meaningful feedback. • Developed software requirements specification documents (SRS), functional specification document (FSD) and business requirements documents. • Developed database schema, use case diagrams, activity diagrams, sequence diagrams and UML diagrams. • Created detailed, comprehensive and well-structured test plans and test cases. • Acted as a liaison between business users and development team. • Coordinated with developers and QA team to explain system requirements. • Ensured continuous IT services delivery to support day to day business operations. • Wrote and executed test cases for new applications. • Involved in extensive DATA validation by writing several complex SQL queries and involved in back-end testing and worked with data quality issues and worked with end users to gain an understanding of information and core data concepts behind their business. • Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy DB2 and SQL Server database systems and exhaustively collected business and technical metadata and maintained naming standards. • Utilized Software Development Life Cycle (SDLC) to configure and develop processes, standards procedures, and Continuous communication with end users, stakeholders, project managers, SMEs, technical teams, and quality analysts and Prepared process flow/activity diagram for an existing system using MS Visio and re-engineer the design based on business requirements • Analyzed business requirements, system requirements, and data mapping requirement specifications, and was responsible for documenting functional requirements and supplementary requirements in Quality Centre. • Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables. • Troubleshoot data integration issues and bugs, analyze reasons for failure, implement optimal solutions, and revise procedures and documentation as needed.

Royal Cyber | Sep 2017 - Feb 2018

Software Engineer

• Performed tasks on IBM ODM and IBM Watson to test the real scenarios of the bank. • Worked for remote clients to fix technical errors and bugs and provide desired solutions to problems. • Served as a resource for development projects. • Troubleshoot and provide end-user support for databases in the assigned division. • Designs, implements, maintains, validates and analyzes data maintained in databases to ensure accuracy; identifies areas where data quality requires improvement and collaborates with team members to resolve issues.

My Education

Take a look at my formal education

Master’s in Computer and Information SciencesCleveland State University | 2021
Bachelor of Science - BS, Computer ScienceInstitute of Business Administration | 2017
Semester Exchange Program, Computer ScienceGadsden State Community College | 2016

About Me

Avinash Kumar

I possess 5 years of IT experience as a Business Analyst/Product Owner/Data Analyst with the ability to work independently and manage business expectations with a delivery-focused approach to work.

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free