Harpreet Mehal

• Partnered with clients and project managers to identify data needs and requirements, ensuring alignment with business objectives.
• Worked with Software Engineers and Product Managers to drive innovation and technical solutions within the practice.
• Led the development of the next-generation auditing tool using SQL, Databricks, Python, Apache Airflow, FastAPI, , Docker, DBeaver, Azure Repos, and GitHub.
• Designed and built scalable, efficient data solutions, new features, and applications, including ETL processes using Apache Spark, PySpark, Python, Databricks, and Azure.
• Developed robust data models and schemas to support data integration, transformation, and analytics.
• Ensured data quality, integrity, and security throughout all processes.
• Created a pillar-wide service using FastAPI, Python, and PostgreSQL to enhance internal capabilities and service delivery.

Working as a PL-SQL developer/Analyst for a Banking client.

▪Integral part of core team as a Platform Expert in Group Risk Data Warehouse project for Royal Bank of Scotland

▪ Liaised with BA's, client, lead designers for requirement analysis and steered walkthroughs of design artifacts with client

▪ Prepared functional and technical detailed design, created procedures and functions in PL/SQL for ETL and optimized code to

produce data extracts for liquidity risk reporting within SLAs

▪ Prepared technical implementation plan and coordinated deployment into different test environments; deployment and rollout

of release in coordination with all involved members(IT Project Lead, Test Manager, Database team)

▪ Provided standalone overnight/weekend support for critical test phases, production deployment and warranty phase

▪ Performed change request management activities, root cause analysis and technical proof of concept

▪ Organized knowledge sharing sessions(KM), quality control activities for CMMi Level 5 standards.

▪ Responsibilities also include Quarterly release implementation activities and support post releases.

Resolving and root cause analyzing the issues as a part of IT Team of the company.

▪ Creating SR’s with Oracle and working on them severity wise.

▪ Implementing the new features in Oracle EBS as per the requirements.

▪ Handling the issues raised by the company employees.

▪ Debugging and troubleshooting existing PL-SQL programming and applications.

▪ Providing solution on day to day issue with the functional knowledge and code analysis in Oracle Apps.

▪ Responsible for the code enhancement/maintenance of Oracle Purchasing and support of existing applications

▪ Understanding the business functionality of the tool used by client.

▪ Providing solution on day to day issue with the functional knowledge and code analysis.

▪ Debugging and troubleshooting existing PL-SQL code.

▪ Creating test plans for the fix implementation.

▪ Good team player and Proactive in taking initiatives.

▪ Proficient at completing tasks timely and meeting deadlines under diverse and high-pressure environments.

▪ Excellent communication, interpersonal and presentation skills with strong analytical mind-set.

▪ Providing technical support and defect fixes.

▪ Monitoring status of scheduled jobs and analyzing job logs in $U and Informatica.