Jaideep Mehra

First Abu Dhabi Bank:

• Led end to end development of SAS AML (Anti-Money Laundering) Flow, ensuring robust compliance and risk mitigation for financial institution.
• Successfully integrated diverse data sources (transactional, customer, external) into AML flow, achieving comprehensive risk analysis.
• Led the design and development of a scalable data warehousing architecture, resulting in improvement in data retrieval and analysis efficiency.
• Spearheaded the design and development of the AECB Flow to streamline data warehousing operations.
• Proactively addressed data integration challenges, ensuring the timely delivery of accurate data to stakeholders.
• Managed end-to-end ETL processes, including data extraction, transformation, and loading, ensuring data accuracy and timeliness.
• Automated data ingestion processes, reducing manual effort by 30% and improving data freshness.
• Conducted performance tuning and optimization of SQL queries, reducing query execution times by 25%.
• Designed and maintained data models using ODI tool, enabling efficient data storage and retrieval.
• Implemented data quality checks and data governance practices, reducing data errors.
• Developed and maintained ETL workflows using ODI (Oracle Data Integrator), Informatica PowerCenter, ensuring data consistency and accuracy.
• Created and managed data dictionaries and documentation for data warehouse components.
• Monitored and managed data warehouse performance, resolving issues promptly to minimize downtime.
• Assisted in disaster recovery planning and testing, ensuring data integrity in case of system failures.
• Experience in PL/SQL Development, Design and Implementation of Business Applications using the Oracle RDBMS.

CISCO:

• Worked on creating Service now data replications by using Snow mirror tool.
• Having good knowledge of ServiceNow modules like ITOM, ITSM, Discovery, Service Mapping, ITIL, CMDB and its Table hierarchy structure.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Created Packages and Procedures automatically drop table indexes and create indexes for the tables. Worked extensively on Ref Cursor, External Tables and Collections.
• Developed Materialized Views for data replication in distributed environments.
• Developed various custom Views for data exposure in distributed environments.
• Created various clean-up jobs for huge data tables by using DBMS.JOB
• Effectively made use of Table functions, Table partitioning and collections.

HEWLETT PACKARD INC. :

• Designed and implemented new functionality on CPQ process related to price calculations, deal process and products load process as per business requirements.
• Extensively worked on Database objects like tables, Views, Indexes also involved in Implementing Procedures, Packages and triggers according to the requirement.
• Testing DB performance periodically and analyzing top SQLs with in a stipulated time using Data Dictionary views.
• Actively done PLSQL development and SQL query writing based on the requirement
• Plan migration to given SQL using best explain plan.
• Conducting performance meetings on regular basis, for proactively resolving the issues in the Database.
• Research and trouble-shoot application problems using PL/SQL programming skills.
• Good experience in supporting applications running in Unix/Linux environment.