Rajneeta Nag

• Successfully led visualization team to deliver necessary data to QlikSense dashboard, thereby reducing manual QA/QC validation effort for eight reports from 200 hours per month to just one hour, utilizing UiPath(RPA Tool) and Alteryx for validation and gained recognition and promotion
• Developed a Recommendation system Machine Learning problem for Appraisal Team in US, thus reducing the appraisal cost approximately 40%
• Improvised on Schedule H regulatory reporting process for CCAR models continuously working with approximately 10 stakeholders
• Implemented automation using Alteryx and SQL, effectively reducing workload of seven employees and cutting down manual effort from 90 hours to just 3 hours quarterly, with one full-time employee.
• Led a team of 4 members in completing a project to automate Manual filling of around 90 forms each month became challenging, so fully automated process, allowing task to be completed automatically using Python and gained recognition.
• Completed Machine Learning Specialization Certification from DeepLearning.AI

• Worked on LGD validation reports, thereby managing risk effectively using SQL queries in Impala and Microsoft Azure.
• I have taken on an Individual Contributor role, which involves managing stakeholders, learning new things, writing queries, performing automation, preparing documentation, and creating PowerPoint presentations, among other tasks.
• Additionally, I assisted database teams with Tableau visualizations to comprehend percentage of data differences during transition from Oracle database to an EDH database.
• Automated 5 excel reports using VBA and Power Queries

• Created multiple SQL stored procedures to run batch processes for client reporting in Tableau.
• Specializing in HR Analytics, I streamlined 12 excel reports into 2 using Alteryx
• Developed a Tableau dashboard to analyze scenarios before and after COVID-19.
• Developed SSIS packages to automate data extraction and report generation.
• Received client commendation for the swift resolution of their business issue of Employee Issues at one place.
• Utilized Power Query for diverse data extraction and integrated it into Alteryx to automate reporting. Additionally, developed VBA subroutines to automate Excel reports and efficiently troubleshooted as needed.

• Primarily focused on email marketing monitoring using Excel and VBA macros, I consolidated five weekly and five daily reports into a single Excel dashboard for enhanced monitoring.
• Created SQL queries to extract email data from the oracle database

• Acquired comprehensive understanding of private equity, venture capital, startup enterprises, and their business processes.

• Additionally, I prepared daily Excel reports for various companies, documenting fluctuations in their income and expenses.

• I have acquired knowledge of SQL through various training sessions at work and have also learned Python for web scraping tasks.

• Received recognition for quality score above benchmark

• Gained a solid understanding of the Google search engine.

• Cross Sold various banking products according to customer needs and managed a well sorted client portfolio

• Acquired an in-depth knowledge about various retail banking products.

• Efficiently analyzed and resolved customer complaints.