Ayush K Email & Phone Number

• Conducted data analysis using Matplotlib and seaborn libraries to visualize data effectively.
• Implemented Spark with Scala and utilized Data frames and Spark SQL API for accelerated data processing.
• Established data and reporting infrastructure using Power BI and SQL from scratch.
• Developed large-scale data structures and pipelines using SQL and Python to standardize and organize data for insights and reporting.
• Conducted feature engineering, model training, and comparison, and back-testing using Python (Pandas, Numpy, and Scipy).
• Designed ETL processes for loading prospects into data marts and applied complex marketing segmentation for targeted mailing.

• Conducted Data Analysis to identify Data Sets, Source Data, Source Metadata, Data Definitions, and Data Validation.
• Created various profiles using Informatica Data Explorer (IDE) & Informatica Data Quality (IDQ) and shared them with business analysts for analysis.
• Worked on STAR schema for detailed data marts and Plan data marts involving confirmed dimensions.
• Performed Validation, Dimensional Analysis, Statistical Analysis, and Data Quality Validation in Data Migration.
• Generated portfolio analysis and P&L reports by performing risk analysis and risk management.
• Created multiple dashboards using Power BI - PowerPivot & Power Query tools.

Bengaluru, Karnataka, India

• Developed SAS macro sets and programs for verification processes and model implementation.
• Generated Data Models using Python and Azure Machine Learning for predictive applications.
• Predicted donor acceptance for charity organizations using Auto Machine Learning tools in Python.
• Participated in the design and development of a consolidated data warehouse.
• Applied predictive analysis techniques to analyze customer behavior.
• Applied Quality Management System Software for defining and implementing data quality.

India

• Assisted senior business analysts in defining project scope and business rules.
• Gathered business requirements and performed gap analysis.
• Created context and workflow models, information and business rule models, and Use Cases.
• Documented requirements and transformed them into functional and technical requirement specifications.
• Developed prototypes of new information processing applications.
• Assisted in developing applications and process mapping.