Ayush Gaur Email & Phone Number

Richardson, Tx, Us

United States

- Practiced a full-scale Agile methodology, actively participating in Sprint Planning, Sprint Reviews, Retrospectives, and dailyScrum meetings to drive project efficiency.- Conducted advanced statistical analyses, including hypothesis testing and regression analysis, to support data-driven decisionmaking.- Analyzed both functional and non-functional data elements, performing detailed data profiling and mapping from source totarget environments.- Executed exploratory data analysis (EDA) using R and ggplot2 to uncover insights such as device efficiency variations.- Developed interactive dashboards in Tableau to monitor key performance indicators (KPIs) and product performance,integrating data from multiple sources.- Utilized reverse engineering techniques to connect with existing databases and generate graphical entity-relationship (E-R)diagrams for system analysis.- Engaged in comprehensive data flow analysis, data modeling, physical database design, forms development, performanceoptimization, and tuning.- Collaborated closely with cross-functional teams to design and implement a scalable data warehouse architecture, improvingdata retrieval and boosting accessibility by 35%, leading to enhanced reporting and operational efficiency.- Performed complex SQL-driven data analysis and profiling across various systems, including Oracle, to ensure data integrityand accuracy.- Partnered with Data Stewards and Data Architects to ensure accurate data capture in the data warehouse, playing a key role indata quality assurance efforts.

India

- Led the implementation of the Waterfall Methodology, generating key deliverables across various stages of the SoftwareDevelopment Life Cycle (SDLC).- Conducted numerous ad-hoc data extractions for business analysis and performance monitoring, utilizing advanced SQLscripting.- Spearheaded data validation, profiling, defect cleanup, and quality improvement initiatives, ensuring accuracy and consistencyin datasets.- Engaged in comprehensive data analysis and assessment using Python, alongside libraries such as NumPy and Pandas, toenhance data quality and reliability.- Developed PySpark applications in a distributed environment to efficiently process vast amounts of CSV files with varyingschemas into Hive ORC tables.- Leveraged Power BI analytics to optimize supply chain management, reducing inventory holding costs by 25% and increasingfulfillment accuracy by 30% through real-time tracking and demand forecasting.- Collaborated with the Data Warehouse team to build Dimensional Models and analyze ER-Diagrams, streamlining dataarchitecture.- Executed advanced data analysis and profiling with complex SQL queries on multiple source systems, including SQL Server, toderive actionable insights.- Demonstrated proficiency in data cleaning, wrangling, analytics, integration, and showcased strong critical thinking, problemsolving, communication, and presentation skills.- Analyzed complex datasets using statistical models and machine learning algorithms, resulting in a 15% increase in customerretention rates.- Used Google Docs, and Google Sheets, to collaborate in writing data and code documentation and reporting insight to themanager.

Master In Business Analytics

Business Analytics with R Database foundation for business analytics Advanced statistics for business analytics Financial Accounting Data.

Bachelor Of Commerce - Bcom

Education record

12Th Board Gseb, 99.76 Percentile