Ankita Anand

• Developed and managed database procedures, views, and Jasper reports using Oracle and SQL, ensuring data accuracy and operational efficiency.
• Validated ETL processes and data transformations for accurate reporting; created scripts for data integration and maintenance.
• Partnered with cross-functional teams to define data requirements, enhance system functionality, and deliver database solutions on time.
• Administered version control, diagnosed and resolved database issues, and adapted databases to evolving needs.
• Optimized data retrieval performance with complex SQL queries.

• Client: HSBC Bank (UK)
• Project: Data segregation and standardization for large customer datasets according to HSBC standards.
• Skill Sets: Python, PySpark, ScalaSpark, Hive, GCP
• Responsibilities: Developed and debugged complex code in PySpark, Python, and ScalaSpark for a banking application with a GCP backend. Provided support for the Hive backend, including troubleshooting and issue resolution.

This application focuses on systems and processes that integrate human resource management (HRM) with information technology. It combines HRM principles, particularly its core activities and processes, with the IT field, where data processing system programming has evolved into standardized enterprise resource planning (ERP) software routines and packages.

Responsibilities:

• Writing complex SQL queries.
• Developing Stored Procedures.
• Designing database schemas.
• Maintaining databases.
• Generating weekly and monthly HRMS reports.
• Providing maintenance and support for the product.
• Managing database updates using the Export & Import Wizard.

Projects:

As an Associate Professor at an engineering college, I was involved in the academic education of B.Tech and MBA students.