Amita Nawal

About Amita Nawal

BUSINESS ANALYSIS • Elicit & Translate Business requirement to User…

Experience

1. Consultant Ii

   EXL

   Sep 2021 — Present · Gurugram, IN

   Data Analysis & Monitoring: Worked on a monitoring tool (MAT) built on SAS.• Excel VBA Development: Developed an Excel VBA tool to automate the reconciliation process for Capital Market trades. The tool was designed to facilitate real-time data extraction and transformation,comparing trade data from multiple sources to identify mismatches in notional amounts.• Proc SQL Utilization: Utilized Proc SQL to extract and analyze diverse datasets, ensuring accurate insights aligned with stakeholder requirements, facilitating informed decision-making.• Power BI Reporting: Improved reporting efficiency by moving from Excel to Power BI, cutting report generation time by 40%. Created interactive Power BI dashboards for easy real-time data visualization, aiding decision-making.• Automation with python: Developed a python tool to automate quality checks of recon book, and compliance documentation, increasing efficiency by 30 %.• Stakeholder Collaboration: Collaborated with stakeholders to ensure effective communication and alignment on client feedback. Working on Documenting clients requirement in form on BRD & FRD and prepare configuration document. Worked on identifying the key data requirement, data prepared mapping core system enhancement for project implementation. This led to the development of new features that precisely addressed the needs of our clients.

Skills

• Team Management
• Auditing
• Business Development
• Valuation
• Accounting
• Customer Service
• Microsoft Excel
• Market Research
• Tax
• Microsoft Office
• Microsoft Word
• Financial Modeling
• Managerial Finance
• Finance
• Financial Reporting