Summary
Overview
Work History
Education
Skills
Workingstatus
Timeline
Generic

Rajesh Mohanty

Scarborough,ON

Summary

  • Dynamic and results-oriented PL/SQL Developer with over 10 years of experience seeking a challenging position where I can leverage my expertise in PL/SQL programming, IBM DataStage, Unix, Linux, WinSCP,XML and IBM Workload Scheduler to contribute effectively to the success of the organization. Seeking an environment which provides carrier growth through a continuous learning process and helps in keeping myself dynamic, visionary and competitive with the changing scenario of the corporate world
  • Highly skilled PL/SQL Developer with a proven track record of designing, developing, and maintaining complex database solutions. Proficient in writing efficient SQL queries, stored procedures, triggers, and functions. Extensive experience in IBM DataStage for ETL processes, along with expertise in Unix, Linux, WinSCP, and IBM Workload Scheduler for efficient data management and automation. Strong problem-solving abilities and a collaborative team player.
  • 3+ years as a Tech lead and IT Team Lead roles for various high budget IT Projects in Utility domain.
  • 8 + years in production Support role for multiple Oracle, IBM , Off the Shelf and Customized applications
  • 10 years cumulative experience in utilities, healthcare, banking, insurance (P&C) and finance domains

Overview

10
10
years of professional experience

Work History

PL/SQL Developer

Enbridge Gas Distribution
11.2023 - Current
  • Planning Sprints, working on KANBAN Boards, Distributing Stories points
  • Leading a team in a highly paced environment to delivery a high budget project well before deadline with minimal post go live defects
  • Involved in full SDLC cycle of Planning, Analysis, Design, Development, Testing and Implementation
  • Part of the Team which designed the ER Diagram
  • Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions
  • Created and modified PL/SQL and SQL Loader scripts for data conversions
  • Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs
  • Wrote SQL, PL/SQL programs required to retrieve data using cursors and exception handling
  • Worked on XML along with PL/SQL to develop and modify web forms
  • Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization
  • Created custom Oracle Application Framework (OAF) Pages for Custom application
  • Responsible for Defect Triage and resolution
  • Created Unix scripts for proactive monitoring of daily batch processes.
  • Creating Custom XML BI Publisher Reports.
  • Develop BO Webi reports for users.
  • Creating Weekly Status Reports.
  • Making Project estimations.
  • Developed requirements for system modifications and new system installations.
  • Reviewed project requirements to identify customer expectations and resources needed to meet goals.
  • Leveraged Agile methodologies to move development lifecycle rapidly through initial prototyping to enterprise-quality testing and final implementation.
  • Coordinated testing and validation procedures through software development lifecycle.
  • Resolved customer issues by establishing workarounds and solutions to debug and create defect fixes.
  • Analyzed user needs and software requirements to determine design feasibility.
  • Analyzed code and corrected errors to optimize output.
  • Recommended improvements to facilitate team and project workflow.
  • Conducted peer code reviews to ensure quality and adherence to coding standards.
  • Collaborated with cross-functional teams to gather requirements and translate business needs into technical specifications.

PL/SQL Developer

Cognizant Technology Solutions
Toronto, ON
09.2021 - 11.2023
  • Organized and Facilitated Creating Sprints, performing Sprint Planning including daily stand-ups, demos and retrospectives
  • Conducting system study and coordinating with team members for requirement mapping, system design and implementation
  • Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation
  • Part of the Team which designed the ER Diagrams
  • Mentored multiple teams to be self directed with strong conflict resolution, transparency and determination skills
  • Wrote sequences for automatic generation of unique keys to support primary foreign key constraints in data conversions
  • Created and modified PL/SQL stored procedures and triggers
  • SQL Loader scripts for data conversions
  • Developed and modified triggers, packages, functions and stored procedures for data conversions and/SQL procedures to create database objects dynamically based on user inputs
  • Experience in working on IBM TWS(Tivoli workload Scheduler)
  • Contributed towards resource management, status reporting, organizing weekly onshore-offshore status meetings
  • Wrote SQL, PL/SQL programs required to retrieve data using cursors and exception handling
  • Worked on XML along with PL/SQL to develop and modify web forms
  • Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization
  • Perform Root Cause Analysis (RCA) on Severity 1 and 2 production Issues
  • Created Exception handling packages and procedures to help ease the process of debugging and display
  • Worked on Supporting multiple applications hosted on Amazon Web Services(AWS)
  • Creating Unix shell scripts for deployment across multiple environments.
  • Collaborated with other teams such as DBA's, Data Architects and System Administrators for resolving any issues related to Oracle databases.
  • Monitored system resources utilization like CPU utilization, memory usage.
  • Optimized SQL queries for better performance by analyzing execution plans and query optimization techniques.
  • Created scripts to automate daily tasks such as backup jobs and scheduled jobs.
  • Prepared documentation for all the processes involved in developing a software product.
  • Participated in Database Design Discussions with Business Analysts and Application Teams.
  • Identified and resolved various issues related to data integrity, security and performance tuning in Oracle databases.
  • Created test cases for unit testing of new or existing PL and SQL code.
  • Analyzed user requirements and developed stored procedures to meet those requirements.
  • Deployed production ready applications on multiple environments.
  • Provided technical support including troubleshooting problems reported by users and developers during application development phase.
  • Developed stored procedures, functions and packages using PLSQL to support the application development needs.
  • Developed shell scripts for automating routine maintenance tasks like index rebuilds and reorgs.
  • Performed debugging of existing PLSQL code as part of bug fixing activities.
  • Performed Database Administration Tasks such as Creating Users, Granting Privileges.
  • Involved in Performance Tuning activities like creating Indexes, Partitioning Tables.
  • Designed complex database objects like tables, views, triggers and indexes as per business requirements.
  • Implemented exception handling mechanism using error logging package in PLSQL.
  • Tested databases and performed bug fixes.
  • Optimized SQL queries and stored procedures, reducing execution time by significant percentages.
  • Created and maintained database objects including tables, views, indexes, and triggers to ensure data integrity and performance efficiency.
  • Designed and developed complex SQL queries for data analysis and extraction to support business decisions.
  • Utilized version control systems to manage changes to SQL scripts and database objects, ensuring consistency across environments.
  • Analyzed and resolved complex database and data integrity issues to maintain high availability and reliability.
  • Implemented ETL processes using SQL and additional tools to migrate data across different systems.
  • Participated in data modeling sessions, contributing to the development of logical and physical database designs.
  • Automated routine database tasks through scripting, reducing manual intervention and improving productivity.
  • Documented SQL development processes, creating a knowledge base for best practices and troubleshooting.
  • Collaborated with cross-functional teams to gather requirements and translate business needs into technical specifications.
  • Evaluated and integrated new database technologies and tools to enhance development efficiency and system capabilities.
  • Developed database schemas, scripts, and models in collaboration with application developers to meet project requirements.
  • Monitored database performance metrics and made adjustments to configurations and hardware to meet scalability demands.
  • Conducted database tuning and performance monitoring to ensure optimal system functionality.
  • Provided technical support and training to end-users on database querying and reporting tools.
  • Conducted peer code reviews to ensure quality and adherence to coding standards.
  • Wrote user manuals and other documentation for roll-out in customer training sessions.
  • Collaborated with support team to assist client stakeholders with emergent technical issues and develop effective solutions.
  • Improved and corrected existing software and system applications.
  • Identified opportunities for process improvements to decrease in support calls.
  • Integrated object-oriented design and development techniques into projects to support usability goals

IT Team Lead- SQL

TATA Consultancy Services
Toronto, Ontario
10.2014 - 09.2021
  • Led the development and optimization of PL/SQL code for critical business applications, resulting in improved performance and scalability
  • Designed and implemented complex stored procedures, triggers, and functions to meet business requirements
  • Collaborated with cross-functional teams to gather requirements and deliver high-quality solutions within project timelines
  • Utilized IBM DataStage for ETL processes, ensuring seamless data integration and transformation
  • Automated data management tasks using Unix shell scripting, Linux, WinSCP, and IBM Workload Scheduler, reducing manual efforts by 30%
  • Developed and maintained PL/SQL code for various modules of enterprise applications, adhering to coding standards and best practices
  • Conducted performance tuning and optimization of SQL queries, enhancing application efficiency
  • Worked closely with QA teams to perform unit testing and resolve defects in a timely manner
  • Provided production support and troubleshooting for database-related issues, ensuring minimal downtime
  • Contributed towards resource management, status reporting, organizing weekly onshore-offshore status meetings.
  • Coordinated closely with project managers to ensure timely completion of tasks.
  • Participated in meetings with stakeholders to discuss requirements gathering, system architecture design, testing procedures.
  • Resolved conflicts between team members in a professional manner.
  • Created training materials for new hires onboarding process into the IT team.
  • Managed team of 8 software engineers and provided technical guidance on projects.
  • Conducted regular performance reviews for the IT team members.
  • Documented various processes related to system implementation and maintenance activities for future reference.
  • Assisted in developing strategies for improving overall efficiency of the IT department.

Education

Bachelor's degree in Electrical Engineering -

Biju Patnaik University of Technology - Bhubaneshwar, Orissa
05.2014

Skills

  • Utility, Manufacturing Domain Knowledge
  • Business Process Analysis
  • Requirements Gathering
  • Data Analysis
  • Stakeholder Management
  • Project Coordination
  • Systems Implementation
  • Risk Management
  • Communication Skills
  • Problem-Solving
  • SQL
  • PL/SQL
  • Unix
  • XML
  • Interface development using Oracle seeded APIs
  • Oracle E Business Suite (FA, QUALITY, INVENTORY)
  • Oracle Application Framework (OAF)
  • BI Publisher XML reports
  • Conversions
  • Oracle Workflow builder
  • IBM Infosphere DataStage
  • SAP BO Webi Reports
  • Java Tools Used
  • SQL Developer
  • PL/SQL Developer
  • Oracle E-Business Suite
  • J Developer
  • Oracle Forms Developer
  • Oracle Reports Developer
  • SAP BO Webi
  • IBM Infosphere Datatsage9
  • Putty
  • WinSCP
  • Toad Methods
  • Agile Methodology
  • Waterfall Methodology
  • Utilities Domain
  • Insurance Domain
  • Agile development methodologies
  • Java
  • Data Validation
  • Performance Improvements
  • Transaction Management
  • Performance Tuning
  • Hardware upgrades
  • SQL reporting
  • Relational databases
  • Data Migration
  • Documentation Management
  • Data Warehousing
  • Database Design
  • Analytical and Critical Thinking
  • Planning
  • Problem Resolution
  • Time Management
  • Attention to Detail

Workingstatus

PR

Timeline

PL/SQL Developer

Enbridge Gas Distribution
11.2023 - Current

PL/SQL Developer

Cognizant Technology Solutions
09.2021 - 11.2023

IT Team Lead- SQL

TATA Consultancy Services
10.2014 - 09.2021

Bachelor's degree in Electrical Engineering -

Biju Patnaik University of Technology - Bhubaneshwar, Orissa

Similar Profiles

CREATE PROFILE
Rajesh Mohanty