Bhavesh Mhatre

Client/Location: Ikea-Germany / Mumbai

Role and Responsibility:

• Managed all phases of the data warehouse development lifecycle, including requirements gathering, unit testing, implementation, and ongoing support.
• Facilitated Joint Application Development (JAD) sessions with business users and subject matter experts (SMEs) to define requirements and establish business and functional specifications.
• Documented user requirements and translated them into system solutions, developing implementation plans and schedules accordingly.
• Actively participated in collaborative sessions to design ETL (Extract, Transform, Load) job flows using PL/SQL scripts. Optimized and fine-tuned slow-running processes, and created detailed design documents that outlined the business functionality of each job.
• Applied database concepts including Transformer, Lookup, Merge, Join, Aggregator, Sort, Filter, and Remove Duplicates stages within ETL processes to cleanse and transform data for staging purposes.
• Analyzed data sources to design efficient query transforms and facilitated the loading of data from Landing to Staging areas.
• Automated batch processes using Control-M setup to ensure daily execution of batch jobs and data loading into Oracle Database.
• Managed version control of scripts using GitHub to maintain the latest updates and changes.
• Provided resolution for issues and offered on-call support for production databases, ensuring continuous system availability and performance.

Client/Location:

• Bank of Baroda Amalgamation (Finacle 11.x) / Mumbai
• Indian Overseas Bank (Finacle 10.x) / Chennai
• Sanima Bank Kathmandu (Finacle 7.x) / Nepal
• Aryavart Gramin Bank/Krishna Gramin Bank (Finacle 7.x) / Mumbai
• Mahindra & Mahindra Financial Services Ltd (Finacle 11.x) / Mumbai

Role and Responsibility:

• Analyzed business data and developed ETL process for migrating data from various legacy systems to Finacle (versions 7.x, 10.x, 11.x) and other target databases.
• Discussed various legacy database mappings with clients and mapped them to Finacle formats. Based on this mapping, developed ETL scripts and created packages, procedures, functions, and triggers for data extraction from source systems.
• Discussed BPD (Business Process Design) parameter mapping requirements with clients and developed ETL scripts.
• Developed a staging area in the ETL process to load and transform data into FINACLE and B@nc24 (Banking Application) formats.
• Designed PL/SQL query logic and developed procedures, functions, and triggers based on business logic to ensure accurate data transformation and integration.
• Loaded transformed data into Finacle modules including CASA (Current Account, Savings Account), TD (Term Deposits), Loans, General Ledger, Locker, TF (Trade Finance), and Collateral.
• Validated migrated data through pre- and post-migration reports to ensure it met quality standards and was accurately reflected in the new system.
• Resolved issues during data upload and integration.
• Updated ETL processes through multiple mock migrations and addressed client-specific requirements to ensure a smooth migration process.

Client: C-EDGE Technology (TCS SBI Enterprise)
Location: Mumbai
Project Duration: August 2016 to July 2017

Role and Responsibility:

• Designed a comprehensive data warehouse schema with well-defined relationships.
• Utilized SSIS (SQL Server Integration Services) to integrate data from Banc24 (TCS Core Banking Application) Oracle database into SQL Server 2008.
• Generated cubes in SSAS (SQL Server Analysis Services) by extracting data from dimension and fact tables, as well as data marts, to create reports according to client requests.

Client: Export Import Bank of India (EXIM Bank) Finacle 10.x
Location: Mumbai
Project Duration: August 2017 to May 2018

Role and Responsibility:

• Analyzed and maintained data to develop and implement reports in nSights BI Tool.
• Created reports for the Trade Finance module, including Letters of Credit (LC), Bank Guarantees (BG), Bills, and Forward Contracts (FC) using Finacle (10.x) database.
• Designed Oracle and SQL queries to generate reports using Jaspersoft iReport tool.
• Collaborated with the bank team to discuss report requirements, deploy reports in the BI tool, and schedule them as daily/weekly alerts.
• Managed the nSights BI system, providing support for over 300 end users.

Client/Project Duration:

• Allahabad Bank - TCS (August 2012 to December 2012)
• The National Bank for Agriculture and Rural Development (NABARD) in India primarily works with Regional Rural Banks (RRBs) and Cooperative Banks to support agricultural and rural development. (January 2013 to May 2013)

Role and Responsibility:

• Designed and implemented data archival processes to securely store historical data from various banking systems, ensuring compliance with industry regulations and internal policies.
• Analyzed data from legacy systems, such as Finacle and Banc24, and mapped source fields to target database fields for effective data archiving.
• Developed and maintained ETL processes to extract, transform, and load data into archival systems, optimizing data retrieval and storage efficiency.
• Ensured that procedures, functions, and triggers were aligned with the legacy system specifications.
• Generated reports on transaction data and to check archival status.