Monika Sharma

• Executed data requirement gathering and schema design for client-specific analytical needs.
• Collaborated with clients to define KPIs and transformation logic for ETL pipelines.
• Designed and implemented an end-to-end data pipeline for ingesting structured (CSV) and semi-structured (JSON) files using Azure Data Factory.
• Developed parameterized ADF pipelines for dynamic file ingestion from Azure Blob Storage, with error handling and logging.
• Transformed raw data using PySpark, including schema normalization, filtering, and joining datasets.
• Loaded, cleaned, and aggregated datasets into Oracle database tables for downstream analytics using JDBC connectors.
• Monitored data pipelines, resolving ingestion and transformation failures in production systems.
• Analyzed source systems, conducting root-cause analysis of data inconsistencies.
• Generated reports and extracts using SQL-driven data models tailored for clients.
• Built custom dashboards on centralized data marts to enhance data accessibility.
• Delivered training and documentation for onboarding new clients onto data platforms.

Client - Royal Bank of Canada (RBC)

• Enhanced Global Plus systems based on business requests and regulatory compliance.
• Conducted requirement and design analysis to identify project needs.
• Collaborated with vendors FIS and Symcor for system improvements.
• Led team through code reviews and task assignments to ensure quality.
• Trained team members on Global Plus functionalities and best practices.
• Developed and implemented system solutions to enhance operational efficiency.
• Provided production support, ensuring system reliability and performance.

Client - Bank of Montreal (BMO)

• Executed key regulatory projects including FATCA, AML, and CRM2 for Global Plus Application.
• Ensured compliance with FATCA regulations, effective January 1, 2014.
• Implemented Management Action Plans to align Wealth Management operations with AML Enterprise Manual standards.
• Enhanced client reporting transparency through amendments to CRM2 related to account performance and fees.
• Managed Canadian Qualified Intermediary obligations under FATCA and Canadian Income Tax Act.
• Coordinated reporting processes for US Reportable Accounts to CRA under CDN Intergovernmental Agreement.
• Streamlined adherence to regulatory frameworks impacting wealth management operations.

Client – Warner Music Group.

• Led project to implement Global Content Data Management system for metadata management.
• Centralized database functionality related to music content from single point of contact.
• Conducted client interactions to gather requirements and ensure alignment throughout project.
• Managed database activities, including writing stored procedures and performance tuning for SQL queries.
• Performed code reviews and resolved bugs to maintain system integrity.
• Developed functional documents based on requirement gathering and analysis.
• Prepared comprehensive business reports to support data-driven decision-making.
• Provided Level 2 production support to address operational issues effectively.

Client - Carnival Cruise Lines (CCL)

• Developed screens and reports using Oracle Forms 6i and Reports 6i for enhancements.
• Provided technical and functional support for applications, including Shipboard System and Casino Financial Systems.
• Implemented a replication mechanism between Shore side office and ships.
• Migrated Oracle databases from version 7.2.0 to 10g for improved performance.
• Designed data replication mechanisms utilizing Oracle Scheduler Jobs.
• Created PL/SQL procedures to enforce business rules for data replication.

Client - Income tax of India (ITAX)

• Migrated application from Forms 4.5 and Reports 2.5 to Forms 9i and Reports 9i.
• Consolidated 36 database instances into a single instance.
• Developed PL/SQL procedures to enhance functionality.
• Executed system testing to verify application integrity.
• Facilitated user acceptance testing to ensure requirements met.
• Retrofitted change requests and updated documentation accordingly.
• Conducted user training sessions for effective system utilization.
• Managed iPMS and performed system administration tasks.