I have completed masters from the University of Illinois at Chicago specializing in Management Information System. I have worked as a Data Analyst and have professional experience of over 3 years. Proficient in R language, Tableau, Advanced MS Excel, and SQL Programming for data management, exploratory analysis, and data visualization.
-
Experience
Analyst Intern- Alexander Group, Chicago, USA
Testing of Power BI metrics, calculated columns and measures created by AGI sales analytics team against SQL database
Created Power BI dashboards post-testing and data lineage document & repository for calculations and metrics.
Product Owner - BI and Analytics, Think and Learn, New Delhi, India
Assisted in planning and defining customer analytics product to AWS cloud
Acted as scrum master to define user stories and manage development cycles through JIRA for the customer analytics
Analyzed Customer database using R for the learning app through search content. Reporting of analysis of app search data for improvement in the process of content management.
Data Analyst, Hindustan Times Learning Centers, New Delhi, India
Data Analyst:
Analyzed reports to identify data trends and made recommendations leading to 20% increase in customer retention
Assisted in defining and architecting data models based on KPI design and information value chain analysis
Reporting Lead:
Led the implementation of complete cross-functional reporting solution using Tableau; collaborated with finance, sales, and human resources team to automate and generate daily and weekly reports
Collaborated with the business to define use cases and prioritize based on the value map to generate monetization
Formulated and defined the scope and format of reports for internal, external, and audit purpose reporting.
Maintained analyzed and presented data prototypes and final products to business and senior management. Communicated changes and enhancements to stakeholders and incorporated feedback into future projects
Managed data sets to support and monitor self-service reporting by the business stakeholders
Reviewed information for accuracy and reconciled data on periodic basis
Managed version control, report migration using GitHub and data integration testing
Testing:
Developed testing cycle plans, test cases to facilitate user acceptance and integration testing cycle for data migrations and reports using Ad-hoc queries
-
Projects
Predictive modeling to identify potential donors | Rapid Miner, Excel
Identified potential donors for the Paralyzed Veterans of America dataset to improve the cost-effectiveness of solicitations and compared different predictive models to maximize donations.
Regression Model for finding factors associated with property prices of Airbnb | R, Excel
Cleaned dataset for missing values and applied a linear regression model to analyze how prices are affected by various characteristics of property. Designed a visual dashboard to monitor performance of Envoy airlines | R, Excel, Tableau
Preprocessed data and generated dashboards to analyze and compare the performance of other airlines. Analyzed various delays & provided a recommendation to reduce the delays.