Data Analyst and Visualizer with over 50 projects completed and satisfied clientele from Finance, Retail, Media and Health industry. DATA ANALYTICS ☑️ Automated end to end process of analyzing annual reports and deriving key ratios and graphs for the consumption of institutional investors for an investment banking firm in China ☑️ Develop a Machine Learning model to calculate customer life time value (CLTV) to profile customer into various segments for an online grocery store in Puerto Rico ☑️ Develop a Machine Learning model on 8 million+ tweets in German language to perform sentiment analysis and create communities by analyzing the interaction between various tweeter user for a media house in Austria ☑️ Develop a Machine Learning Model to predict the likelihood of getting workplace injury based on age, department and work type for a health insurance provider in USA TRAINING & MENTORING ☑️ Conducted live workshops on Excel, Tableau and Power BI for students, professional and Entrepreneurs ☑️ Mentored over 50 students who either have completed or pursuing course in Data Analytics and Data Science
Developed various revenue and expense dashboards using tableau Developed prediction and classification models for text and images using python Conceptualized, developed and implemented various projects as a leader of the analytics wing of the team, which later can be taken up as a process Prepared Monthly financial variance analysis templates: Actual vs. Budget vs. Forecast, Prior year Comparisons Developed operating financial models of various competitors and guided the other team members by training them about the various intricacies involved in developing different financial models Prepared Standard Operating Procedures for various processes Conducted training programs and mentored new recruits of the team Interacted directly with clients for queries and clarifications and provided them required assistance in processing the financial data Conducted interviews for new recruit
Conducted research from the sales data for slow moving goods and discontinue its purchase in order to make room for new requirement Prepared debtors outstanding report on a weekly basis to identify from which debtor the due is to be collected Prepared creditors report to identify the vendors whose due is to be paid on a weekly basis Prepared a report on debtors collection to separate debtors who pays on time to those who fail to keep the commitment on a quarterly basis Prepared a report on the time frame of cash to cash to cycle on a quarterly basis Prepare other ad hoc reports as instructed by the management
Generated database of major players of the industry in Dhaka and Chittagong from secondary database Cleaned the data in terms of relevance, profitability and competitiveness to the company Met the decision maker to explore the scope of the market Collected primary data of Cement, Automobiles, Steel, Machinery and others from those meetings Complied both primary and cleaned secondary data and presented the report to the MD
Handled the the final link in the chain of mortgage (Default Claims), where I was required to interact with both attorneys to get the relevant documents and also Mortgage Insurance companies to file the required documents to process the claims. Updated property status on a monthly basis