Summary
Overview
Work History
Education
Skills
Websites
Timeline
Generic

Rajni Mahajan

Toronto,Canada

Summary

Accomplished Oracle Specialist at BMO, I enhanced database performance through expert SQL tuning and ETL process development. My strong problem-solving skills and technical documentation expertise ensured data integrity and reliability, driving significant improvements in user experience and operational efficiency.

Overview

17
17
years of professional experience

Work History

Oracle Specialist

BMO
05.2022 - Current
  • Designed complex reports using SQL Server Reporting Services.
  • Performed backup and recovery of databases on a regular basis.
  • Monitored database performance and troubleshooted issues related to slow running queries or deadlocks.
  • Developed ETL processes using SSIS packages for loading data from various sources into a data warehouse environment.
  • Used T-SQL scripting language for creating stored procedures, functions, triggers.
  • Resolved customer service requests related to database errors or performance issues quickly and efficiently.
  • Integrated multiple data sources into one unified view using views or joins in SQL queries.
  • Conducted unit testing of all database objects before deployment.
  • Maintained security by creating user accounts and granting appropriate privileges.
  • Created database objects like tables, views, indexes and synonyms in Oracle 11g and 12c databases.
  • Optimized existing queries for better performance using SQL query tuning techniques.
  • Analyzed and resolved complex database and data integrity issues to maintain high availability and reliability.
  • Managed database backups and disaster recovery plans to ensure data preservation.

Senior Oracle Consultant

TD Bank
06.2018 - 12.2021
  • Enhanced database performance by 30% through optimizing star schema and relational models, ensuring faster data retrieval and improved user experience.
  • Troubleshoot and resolve data issues to ensure data integrity and accuracy.
  • Implement Test Driven Development and Test Automation strategies to ensure code quality and reliability.
  • Develop and maintain Oracle/PLSQL code, including API, stored procedures, packages, functions, triggers, and transactions.
  • Work with IT analysts/developers to track change request progress.
  • Develop solution artefacts viz Technical Design documents, develop error handling, recovery, strategy documents.
  • Monitors incidents to ensure timely resolution in accordance to service level agreement.
  • Used agile methodology in the project and automated system scripts for backups, data transfers etc.
  • Provide support for a period of time following implementation.
  • Oracle Modules: Oracle EBS R12 Modules: Order to Cash, P2P, FA, AP, GL, WMS (Oracle Shipping and Logistics), FAH, CC&B (CRM module).

Oracle Consultant

Rogers Communications
06.2017 - 12.2017
  • Implemented security measures such as roles, privileges, profiles within Oracle environments.
  • Assisted with data migration from legacy systems into Oracle databases.
  • Created and maintained complex database objects, such as tables, views, indexes, packages and procedures in Oracle databases.
  • Provided technical support for the development of reports with tools such as SQL Plus and TOAD.
  • Defined backup strategies for critical data residing in an Oracle environment.
  • Analyzed current architecture of existing applications built on the Oracle platform in order to recommend modifications or improvements.
  • Developed programs using PL and SQL stored procedures, functions, triggers and packages to meet application needs.
  • Performed troubleshooting of post-release software faults to support live service and installed software patch design.
  • Coordinated testing and validation procedures through software development lifecycle.
  • Applied prescribed policies to programming syntax in compliance with internal language policies.

Oracle Consultant

Wipro Infotech Ltd
10.2013 - 06.2017
  • Deliver high-quality solutions within tight deadlines in a fast-paced, collaborative environment.
  • Participate in code reviews to ensure code quality and adherence to best practices.
  • Running the Depreciation program as per depreciation Calendar.
  • Generating the Accounting Entries and Transferring data to GL.
  • Created and maintained documentation in the form of user guides and specifications.
  • Helped by ensuring timelines are met by identifying critical issues as they arise.
  • Provided production support after implementation of respective reports.
  • Oracle Modules: Oracle E-Business R12 Modules: Order to Cash, P2P, AP, AR, OM, INV, PO, HRMS, GL, WIP.

Senior Software Engineer

Flsmidth Private Ltd
05.2011 - 10.2012
  • Worked on new Discoverer Reports and modifying existing Discoverer Reports in Oracle Applications.
  • Working on customization of finance interfaces in Oracle R 12 using GLDI.
  • Integration of Shipping and Logistics modules with Oracle SCM module and fetching reports.
  • Working on creating new forms of Shipping and Logistics modules in Oracle SCM module.
  • Customization of Account Analysis Report in Oracle R12.
  • Delivered reports on PO module.
  • Provided expertise on Requisitions Setup as part of Procure to Pay cycle.
  • Managed Procure to Pay Processes-Manage Contract, Execute Purchases.
  • Responsible for User acceptance test plans.
  • Involved in all development, deployment and Unit testing aspects of the project.
  • Prepared and created Documentation in the form of user guides and specifications - MD070, MD0120.

Software Engineer

Nucleus Software Exports Ltd
05.2010 - 05.2011
  • Worked on modules Order to Cash, P2P, Purchasing, Account Payables and Inventory.
  • Development of various conversions and API like Item Category, Item Locator, Item on Hand Quantity, Purchase Requisitions.
  • Involved in Designing the Technical Specifications for Conversions and Interfaces using Oracle PL/SQL.
  • Development of various RDF and xml reports in AP, AR and Inventory and Projects modules.
  • Responsible for developing Migration Scripts for Concurrent Programs and Custom Objects.
  • Participate in code reviews to ensure code quality and adherence to best practices.
  • Involved in Custom Forms development in Oracle Apps.

Software Engineer

Fujitsu Consulting Private Ltd
08.2008 - 05.2010
  • Development of HRMS Conversions like Employee Salary, Employee Tax (City, State, Federal, County).
  • Development of PO interfaces, Blanket PO Interface, Customer Conversion.
  • Developed Interface to import PO Receipts in Oracle from third party system.
  • Designing Technical Specifications for Conversions and Interfaces.
  • Developing Migration Scripts for Concurrent Programs and Custom Objects.
  • Developing various XML, RDF Reports.
  • Working with Oracle Form Personalization to alter seeded form behavior.
  • Developing new Forms and uploading them into EBS.
  • Developing PL/SQL procedures, functions, Packages, Triggers, Objects for inserting, updating, retrieving and validating of data to achieve the mission critical tasks, Creation of Different Database Objects like Views, Synonyms, Indexes, Sequences etc.
  • Developed various objects like Item Vendor Details (Procedure), Valid and Invalid Item Detail (Report), Employee Billing History Details (Report).
  • Involved in development of various conversions like Involved in developing of various Conversions like Approved Supplier's List Conversion, Sourcing Rule Conversion, Sourcing Rule's Assignment Conversion, Supplier's Conversion.
  • Preparing the Test scripts of various API's.

Education

B.E. - Information Technology

Beant College Of Egg And Tech
Gurdaspur, Punjab, India
01.2007

Skills

  • Billing Systems (CC&B)
  • Customer Management
  • Discoverer Reports
  • FAH (Financial Accounting hub)
  • Fixed Assets
  • General Ledger Desktop Integrator
  • General Ledger (GL)
  • Informatica Power Center 951
  • Inventory (INV)
  • Oracle Alerts (ALR)
  • Oracle Forms / Oracle Reports
  • Oracle Purchasing (PO)
  • Oracle SQL and PL/SQL
  • Oracle XML/BI Publisher and Oracle Reports
  • Order Management (OM)
  • Payables (AP)
  • Receivables (AR)
  • SQL Loader
  • SQL plus
  • SSIS
  • Stored Procedures
  • SYSADMIN
  • Toad
  • Unix/Linux
  • UTL_FILE
  • WMS (Warehouse Management Systems)
  • ALM
  • JIRA
  • Quality Centre
  • Oracle database management
  • Database performance tuning
  • ETL process development
  • SQL Server Reporting Services
  • Data integrity analysis
  • Technical documentation
  • Problem solving
  • Agile methodology
  • Coaching and mentoring
  • Risk management

Timeline

Oracle Specialist

BMO
05.2022 - Current

Senior Oracle Consultant

TD Bank
06.2018 - 12.2021

Oracle Consultant

Rogers Communications
06.2017 - 12.2017

Oracle Consultant

Wipro Infotech Ltd
10.2013 - 06.2017

Senior Software Engineer

Flsmidth Private Ltd
05.2011 - 10.2012

Software Engineer

Nucleus Software Exports Ltd
05.2010 - 05.2011

Software Engineer

Fujitsu Consulting Private Ltd
08.2008 - 05.2010

B.E. - Information Technology

Beant College Of Egg And Tech

Similar Profiles

CREATE PROFILE
Rajni Mahajan