SUMMARY:

• Having 11+ years of total working experience as Database Developer in IT with TCS and Tech Mahindra and Cognizant.
• 8+ months of onshore experience with leading investment Bank Client/users at Toronto(Canada) location.
• Experience in Development activities including Requirement Analysis, Design, Development, Testing, Implementation and Deployment of database objects like procedures, functions, views, triggers etc. in Oracle PL/SQL, Sybase database and MS SQL Server.
• Experience of working as DBA and performed activities like patching, version upgrade activities, user management, performance tuning, secured installation etc.
• Good hands on experience in shell scripting and UNIX and Linux commands.
• Hands on experience in working on Performance Tuning.
• 6+ years of working experience in Banking domain. Worked with leading banking clients like Confidential, Morgan Stanley.
• 1 year of working experience with Telecom Domain.
• Expertise in developing complex relational database objects like procedures, functions, triggers etc. and implementation of business applications using Relational Database management System (RDBMS).
• Good knowledge of autosys and worked on autosys jobs.
• Experience in working with SQL Loader.
• Experience in working with Talend - ETL tool.
• Oracle Autonomous Database Cloud Certified in 2020.
• Experience of Agile Way of Working.
• Done Python language Udemy course and attended live instructor in 2021.
• Knowledge of Java and C++ programming.

TECHNICAL SKILLS:

Languages: PL/SQL, T-SQL, Shell Scripting, Linux, Phyton

Operating Systems: Windows NT/9X/2000/XP, Unix

Tools: PL/SQL developer, Toad, SQL Loader, DB Artisan, DB Visualizer, SQL Server Management Studio, RADAR, Oracle Reports, Kintana, Clear case, Autosys, Bit Bucket, Udeploy, Talend Open studio, OEMM, Data Governance Centre

Databases: Oracle PL/SQL, Sybase 15.5 and MS SQL Server 2012

PROFESSIONAL EXPERIENCE:

Confidential

Senior Associate

Responsibilities:

• Worked as a Senior Oracle Developer in PACS Application.
• Used PL/SQL to create Packages and Stored Procedures and Functions.
• Worked on Agile Methodology.
• Good experience of design and development with ORACLE 11g, experienced in writing complex SQL queries, stored procedures, functions, cursors and packages using PL/SQL Programming.
• Responsible for testing through backend & UI both.
• Coordination with designers and other dependent teams to understand end to end requirements.
• Involved in release activity, handling calls with clients, designers and testers to understand the business functionality and implement the stories accordingly.
• Created and maintained low level design documents, unit testing logs and other supporting documents.
• Responsible for mentoring juniors within the team and helping/guide them in their tasks.
• Responsible for review code changes done by juniors within my team.
• Involved in resolving production live issue (bridge cases) by working closely with client and designers.

Confidential

Responsibilities:

• Worked as a DBA in OEMM-DGC Web Application.
• Worked on patching and upgrade activities on regular intervals.
• Worked on installing Secure s to make Web application more secure.
• Worked on managing firewall using iptables utility to manage incoming/outgoing traffic to web application port.
• Worked on enabling of SSO authentication using ADFS technology on DGC and OEMM.
• Worked on user management activities like grant/revoke access to application, manage access to shared folder on remote server etc.
• Worked on creation of new connected safe for automation password management.
• Worked on implementing security controls like Penetration testing, SEM-A implementation etc. to enhance security to protect Web application from hackers.
• Worked on managing regulatory requirements with respect to ING bank and provided necessary documentation and evidences for audit purpose.
• Coordination with tool vendors Oracle and Collibra team to troubleshoot any issues related to web application.

Confidential

Responsibilities:

• Worked as a Senior Developer in GL Application and prime Finance Team.
• Worked at a Client location at Toronto (Canada) and having good exposure to work closely with business user/clients.
• Responsible of end to end execution of SDLC cycle.
• Responsible for dividing the tasks within the team and helping them in their tasks.
• Worked on requirement analysis & responsible for resolving queries through a direct interaction with the Citi Clients for clarification of the same.
• Developed complex database objects like procedures, functions, packages, triggers, views etc.
• Worked on shell script changes.
• Responsible for testing through backend & UI both.
• Worked on preparing test cases & assisted testing team to test the DB objects & application.
• Responsible for deployment & post verification of changes implemented in Production.
• Responsible for providing post implement support to users in case of any issues.
• Worked on autosys job changes including new autosys jobs creation and modified the existing jobs as well.
• Done performance tuning of Stored procedures and queries.
• Good working experience of deployment tools like udeploy, bit bucket etc .
• Independently handled all the tasks assigned.

Confidential

Responsibilities:

• Worked as a Developer in GCIA (Global Centralized Information on Accounts) Project of Morgan Stanley account.
• Worked on requirement analysis & responsible for resolving queries through a direct interaction with the Morgan Stanley users for clarification of the same.
• Developed complex database objects like procedures, functions, packages, triggers, views etc.
• Wrote script to upload coverage for users in GCIA.
• Responsible for testing through backend & UI both.
• Worked on preparing test cases & assisted testing team to test the DB objects & application.
• Responsible for deployment & post verification of changes implemented in Production.
• Responsible for providing post implement support to users in case of any issues.
• Worked on RADAR tool which is used to provide data in reports to users.
• Worked on autosys job which is used to take & provide data to upstream & downstream applications through GCIA.
• Done performance tuning of SQL queries.
• Independently handled all the tasks assigned.
• Wrote scripts for project management tasks like deployment, grants etc.

Confidential

Responsibilities:

Worked as a Developer in the AIS (Assessee Information System) module of the ITAX Project at client location.

• Engaged with the customer proactively to understand the requirements and deliver solutions.
• Done analysis, development, testing & deployment of the stored procedure, functions, views etc. in Oracle.
• Worked on Oracle Forms and reports.
• Responsible for handling client related queries and Problem resolution of customer queries through Phone/Net Meeting.
• Prepared technical specifications, User manuals etc.
• Independently handled all the tasks assigned.

Confidential

Oracle 10g, PL/SQL Developer

Responsibilities:

• Functional Knowledge of Order Management (OM) module.
• Create sales order and Quote in Oracle Apps for Fusion10 Project.
• Worked on requirement analysis and done enhancement of existing procedures & packages in Oracle.
• Worked with Kintana and clear case to move custom objects from one instance to other.
• Worked on SQL Loader to load file data into Oracle database tables.