Prema Pingale

• Analyzed large amounts of data to identify trends and find patterns, signals, and hidden stories within data.
• Developed complex dashboards and reporting tools to track business performance metrics.
• Created dashboards to monitor and track key performance indicators.
• Implemented business intelligence solutions to increase operational efficiency.
• Used business objects, business intelligence and other reporting tools to extract data from data solutions and data warehouses.
• Developed and implemented data governance policies and procedures.
• Used business objects, business intelligence and other reporting tools to extract data from data solutions and data warehouses.
  Deployed predictive analytics models to forecast future trends.
  Assisted with creating data cubes and OLAP models to improve data analysis.
  Created data models to support decision-making processes.
  Developed data mining algorithms to identify and classify patterns in data.

Projects:-

• Developed data mining algorithms to identify and classify patterns in data using Python and achieved 70% of accuracy.
• Created and automated data visualizations to present insights and tell compelling stories.
• Scrape Twitter data with Python: - Designed dynamic and browser compatible pages using Python to extract data from Instagram and Twitter with the hashtag to get number of tweets and trending hashtags as output
• Achieved 85% accuracy
• Market Research & Competitor Analysis: -
• Developed a fully automated application to identify direct and indirect competitors using research to reveal their strengths and weaknesses
• Reduced manual efforts by 75%
• Topic Modeling & Summarization of Legal Documents: - Deployed Python app that extracts words from a document, cleans the retrieved text, models the document's topics using an unsupervised automatic keyword extraction method, gathers online information about the derived phrase, and provides a visual summary which improves efficiency by 50%
• Data Validation & Transformation of Excel Reports:
• Developed numerous Regulatory and custom reports in Python and delivered over FTP/email to clients which reduced the manual work by 70%.
• Analyzed large amounts of data to identify trends and find patterns, signals and hidden stories within data.
• Developed customized reports, summarizing and presenting data in visually appealing format.

• Conducted credit risk assessments and developed financial models to evaluate the performance of investment portfolios
• Worked with clients to complete all regulatory reporting requirements, IFRS changes, including semi-annual and annual reports within deadlines
• Ensured that securities are classified correctly for financial reporting purposes
• Created Excel applications (VBA, Macros) to import historical data which include multiple databases, and perform various statistical analyses, charts, and graphs
• Developed multiple Excel/VBA Forms for data capture and report generation
• Developed procedures in MS Excel for export and import of data to and from MS Access
• Imported data from SQL Server into Access
• Developed user-defined functions to calculate performance attributions, Sharpe ratio, and various other functions to evaluate investment manager’s performance.

• Automated daily excel reports such as Recruiter Scorecard and Daily Performance Matrix reports on a weekly and daily basis and sent them as attachments using VBA macro
• User forms for data capture and report generation using VBA and advanced Excel techniques
• Designed and developed the database tables and forms in MS Access
• Designed Dashboard, a front-end Excel/user form-based application that connects to back end Access databases using Excel/VBA
• Automated the printing process of excel reports such as performance matrix report and Budget spending report on a monthly and Year to Day basis and sent them as an email attachment using Excel/VBA macro
• Created dynamic charts such as Needle charts, Pie charts & Bar charts displaying vital data such as Time allocation and Budget spending through VBA

• Developed a simple and easy mechanism of a database application for users to enter data without having to enter data into numerous delivered screens using Microsoft Excel/Access/VBA
• Converted Excel formulas into VBA code including V-lookup, H-lookup
• Created Tables, Link tables, Queries, Forms, and Reports in Access from scratch.

• Preparation of daily / weekly / monthly MIS reports
• Consolidate monthly updates and publish reports
• Provide support to the sales operation team to meet and sustain client targets by providing accurate and timely analysis.