Ankit Rajesh

Designation : Data Scientist / BI Architect
Role : Data Consultant
Responsibility Overview–
• Creating, and upgrading dynamic dashboards for various programs, trainings, and outcomes.
• Management, articulation and reporting of Monitoring and Evaluation processes.
• Data cleaning, modelling, and reporting for Global projects and Annual Program Report.
• Creating models, templates and standards for data gathering and data management across projects.
• Data Analysis and detailed reporting on functional aspects of tools employed.
• Coordinating with service vendors for monitoring issues and service level.
• Intensive use of tools like Power BI, SQL, Excel, VBA, iSpring etc.
Notable contribution : Led the project to explore and bring in a new M&E tool to the organisation.

- Data Analysis and Financial reporting of credit, collection, its trends and impact.
- Analytics, Reporting and Visualization for Risk Management and Quality Assurance.
- Articulating business requirements for field collections and tele collections.
- Supervising and troubleshooting database issues for credit risk team.
- Coordinating with Czech Republic headquarter for strategy and database management.
- Creating data models for Debt Sales and monitoring of control groups.
- Use of tools like Microsoft Power BI, Oracle SQL, Tableau, Python, Excel VBA etc.
- ** Created models for Debt Sales of written off assets for different category loans. These models were floated for sale negotiations with buyer organizations.

- Work with business analyst groups to ascertain their database reporting needs.
- Create custom SQL queries for Reporting, visualization and BI reports.
- Perform Data Migration, Data Validation and stored procedure updates.
- Data Quality assurance and data Integrity checks on databases, sources, data sets.
- Data warehousing, transformation and database optimization.
- Improving user experience of applications and reports by user feedback.
- Agile framework for development projects. Programming and frontline code reviews.
- Worked on SQL, MSBI, SSIS, ETL, SSRS, SAP BO, Excel VBA etc.
- ** Leadership initiative in institutionalizing Agile framework.

Reporting expert in Citi Bank Project.
Responsible for development of Multidimensional Automated Reports in a Reporting Tool for Asset investments for High-Net-worth Individuals (HNIs)
Worked on tools like SAP BO, MSBI, SSIS, SSRS, Ab Initio, Oracle SQL
Notable contribution: Created multi layered reports on SAP BO for Citi bank project that optimized initialization time of reports by 60%