Ajay Kumar

PROFILESUMMARY Performance oriented professional & a fast learner 5+ work experience in Data Analyst Data Analyst developing data model designs for dashboards in various domains as per the requirements to client and Management. Expertise in SQL Database , AWS redshift ,Hive, Advanced Excel SAS ,Python Machine learning and probability staticstics ,Power Bi , using Report and creating Dashboard . Experience in writing complex SQL queries and Stored Procedure involving multiple tables inner and outer joins. Optimization, use of Joins and Subqueries. Writing the stored procedures and Function. Understand business requirements in BI context and design data models to transform raw data into meaningful. insights Developing visual reports, dashboards and KPI scorecards using Power BI desktop. Using The Power Bi for Data Visualization also using DAX function , table, chart, formula. Knowledge of Quality process, excel, PowerPoint, spreadsheets, google docs, Responsible for loading, extracting and validation of client data . Experience in Optimizing the Queries by creating various Clustered, Non-Clustered Indexes and Indexed views. Works in an Agile environment and is familiar with agile methodology. Build the Custom Transformations for Activities in Business Process and implement the Custom KPIs for different Use cases to meet the client requirements. Build process data visualization in the dashboards within Celonis / relevant process mining tools. Perform the Monitoring Enhancement of the Business Process Flexible team player who prospers in a fast-paced data driven environment based on current and past experience Skilled understanding of data analysis to effectively interpret findings in a way that makes sense to end users.