| 20,000+ Fresh Resumes Monthly | |
|
|
| | Click here or scroll down to respond to this candidate Candidate's Name
PHONE NUMBER AVAILABLEEMAIL AVAILABLEWORK EXPERIENCE:Office of Development, Yale University, CT Business Intelligence Analyst Oct 22- Current Collaborated with internal Stakeholders like Finance, Schools and Units, Communications and marketing, alumni affairs, to gather & document business requirements, creating 10+ data visualization & 5 automated dashboard reports using Tableau and Power BI, optimizing coding structures & standard metrics to support BI efforts. Managed 8 BI projects from inception to completion, including work plans, timelines, and status updates testing dashboard functionality and calculations, and visualizations using internal databases and other tools.
Coordinated with IT to integrate 20+ new data fields and calculations in the data warehouse, ensuring data integrity and security. Developed 15 prototypes and mock-ups to define complex business requirements iterating on solutions and providing analytical support for BI solutions development and deployment, aligned with business needs. Designed and implemented efficient ETL jobs processes to extract data from diverse sources, transform it into usable formats, and load it into a centralized data warehouse, reducing data processing time by 30% Developed 10+ test cases and participated in the A/B testing and quality assurance process, facilitating data stewardship and governance processes, and developing 5 metrics to monitor usability, data quality, test design, analysis and validation. Contributed to the establishment and maintenance of robust data quality standards, high-quality end-user documentation, and governance processes, ensuring data quality, integrity, and compliance with industry best practices. Updated and maintained 10+ automated dashboard reports and end-user documentation for dashboard specifications.
Conducted technical research development and data profiling using Python and SQL to recommend innovative data solutions, resulting in enhanced business value and strategic decision-making, increasing efficiency by 15%.Accounting, Finance, Economics and Decision Sciences, WIU, IL Research Assistant Aug 21- Jul 22 Extracted & Transformed CO2 emissions dataset for the United States to develop a quantitative model and perform exploratory data analysis for 50 states for over 20 years using Microsoft Excel, resulting in a comprehensive report Click here
Applied logarithmic Mean Divisa Index (LMDI) Approach & decomposition analysis to identify factors influencing CO2 emissions and built Tableau/Power BI reports on the Percentage change in CO2 emissions and decomposition of emission for over 20 years.Northern Power Erectors Ltd. Business Analyst Aug 19 - July 21 Collaborated with cross-functional teams to design & implement process improvements, analyzing business requirements to translate them into technical specifications for development teams, resulting in a 15% improvement in process efficiency. Utilized SQL Server and T-SQL to query and manipulate large datasets, ensuring data accuracy and integrity to develop, deploy high-quality data architecture & maintain 20+ interactive automated dashboard reports in Tableau & Power BI, employing DAX and Power Query for advanced data transformations, calculations, and complex data analytics models. Participated in CRM system implementation, ensuring seamless integration with existing processes to streamline customer interactions and improve satisfaction, increased efficiency by 22%. Conducted technical research and data profiling using Python and SQL to recommend innovative data solutions, enhancing business value, and driving strategic decisions, identifying key business trends and insights, and improving decision-making efficiency by 18%. Created and assisted in development & maintenance of automated products reports in Tableau for senior management, improving data-driven decision-making. Conducted market research analysis to identify trends and opportunities for strategic business decisions and supported multiple projects, including scheduling, resource allocation, and progress tracking.Analysis on Non-Performing Loans on Business Cycle, IL Independent Finance Research Jan 22- May 22 Developed quantitative model, performed regression analysis & linear programming, on structured data set to understand the effects of macro-economic factors on NPL, using Statistical packages Matlab, R and Python Conducted extensive research on macroeconomics factors and their theoretical relationship. Created Power BI report to analyze the correlation between macroeconomic factor and NPL considering various policies.Women on Western, WIU, IL Student Volunteer Project Lead Sept 21- Dec 21 Deployed a data pipeline using SQL and Scala/Spark to extract, transform at a Macro level, and load data. Optimized marketing campaigns using reinforcement learning, increasing donations by 37%.Technology Business Incubator, IIT Delhi Business Consultant May 19- Jul 20 Provided Quantitative risk assessment to tech startups to improve financial management. Assisted startups with marketing and technology resources management.Netflix Twitter Sentiment Analysis Independent Research Dec 18- May 16 Developed a model using Python (NLP and EDA) to analyze market changes based on consumer sentiment. Deployed the model with Java to generate responses on 100k posts to validate the model and its applicability.EDUCATION:Western Illinois University Master of Science in Quantitative Economics Aug 2022University of Petroleum and Energy Studies Bachelor Business Administration May 2020SKILLS AND CERTIFICATIONSMicrosoft Excel and word, Blackbaud, CRM, ERP, SQL, Tableau, MS Power BI, DAX queries, Python, Hadoop, R, JIRA, Qlik, Quantitative analysis, Statistical Analysis, Regression Analysis, Data Cleaning & Sorting, Strong Analytical Skills, UAT & A/B Testing, Data Engineering, Statistics |