SUMMARY

• Over 10 years of IT experience in PL/SQL Development and Robotics Process Automation Development with tool UiPath and Siebel administration and UNIX.
• Strong knowledge in SQL, PLSQL , UNIX
• Strong knowledge in Informatica Power center tools over 2 years .
• PL SQL/Oracle developer with Golden Gate knowledge
• Oracle PL/SQL with knowledge of the most recent updates.
• Experienced in data modeling, And good in deployments.
• Good in tuning and optimization of sql queries and Plsql subprograms.
• Well experienced in writing PL/SQL Packages, Functions, Procedures, Cursors & Triggers to implement business logic.
• Experience in Design, Development, Implementation and support as Oracle Developer in Production and Development using Oracle Tools.
• Extensive experience in Oracle database
• Comprehensive involvement in all phases of application lifecycle development be it analysis, development, testing, debugging and User Acceptance Testing (UAT) with QA team.
• Extensive query optimization and performance tuning. Created the integrity constraints and Database Triggers and Dynamic SQL for the data validations and Used PL/SQL Tables and Records
• Excellent interpersonal and strong communicating, problem - solving skills.
• Worked in strict deadlines without compromising on the quality.
• Good knowledge in data warehousing techniques.
• Good experience in building the datamarts
• Handled bigger releases and delivered without any bugs.
• Analyze and fix the performance issues with DBMS PROFILER.
• Loaded the data into the tables using SQL*Loader
• Expertise in Understanding and Analyzing Application Requirements.
• Created relevant staging tables to load the CSV files, identified the business validation rules
• To Configure and create extension columns for the Base table.
• Siebel server setup and its maintenance Checking for DEV, system integration testing (SIT), User Acceptance Testing (UAT) and Prod servers daily.
• Have Knowledge on AWS Concepts
• Repository migrations and production deployments.
• Hands on Experience in Siebel CRM 8.1 Applications.

TECHNICAL SKILLS

Database System: PL/SQL, Oracle 9i/10g, PostgreSQL

ETL Tool: Informatica 9.6.1.

RPA Tools: UiPath

Scripting: shell, Unix shell scripting

Operating system: Linux 6.x/7.x, Windows, Unix

Languages: PL/SQL, Siebel, RPA UiPath,Unix

PROFESSIONAL EXPERIENCE

PL/SQL Developer & Oracle Database Administrator

Confidential

Responsibilities:

• Designed the tables and scenarios for the customer information.
• Coordinate with clients and gather the requirements.
• Good knowledge in Postgres DB.
• Taken care of both 1F and iEN application access and adding new fields in VPM
• Given access to VPM all users
• Oracle dba activities.
• Monitoring piwik report every month access for both 1F and iEN.
• Written the packages and required functions to get the questionnaire information.
• Taken care of releases into production without bugs.
• Test the requirements and got the good feedback from the clients.
• Knowledge transfer of development to other resources in the project.
• Responsible for Creation of database objects like tables, indexes, views, Procedures, Functions, Packages, Triggers, synonyms.
• Developed complex queries on Database and developed PL/SQL Procedures to give in nice strategic plans to higher level of management.
• Collectively used different types of control statements in order to process and manipulate data in the Stored Procedures.
• Developed Triggers to enforce complex business rules and to audit changes to data.
• Created tables and modified table structures by adding new column to existing table and populate data into that column
• Responsible for PM Assignment matrix

Environment : - Environment: - PL/SQL, Toad, PostgreSQL Pg. Admin, Windows SQL Server 2014, Excel

Senior PL/SQL Developer

Confidential

Responsibilities:

• Designed the tables and scenarios for the customer information.
• Coordinate with clients and gather the requirements.
• Handled a team size of three members.
• Created the mappings in informatica required for the cdustomer touch points.
• Written the packages and required functions to get the questionnaire information.
• Taken care of releases into production without bugs.
• Test the requirements and got the good feedback from the clients.
• Knowledge transfer of development to other resources in the project.
• Responsible for Creation of database objects like tables, indexes, views, Procedures, Functions, Packages, Triggers, synonyms.
• Developed complex queries on Database and developed PL/SQL Procedures to give in nice strategic plans to higher level of management.
• Collectively used different types of control statements in order to process and manipulate data in the Stored Procedures.
• Developed Triggers to enforce complex business rules and to audit changes to data.
• Created tables and modified table structures by adding new column to existing table and populate data into that column

Environment : - PL/SQL, Toad, Windows SQL Server 2014, Excel

Senior PL/SQL Developer

Confidential

Responsibilities:

• Designed the tables and scenarios for the customer information.
• Coordinate with clients and gather the requirements.
• Handled a team size of three members.
• Created the mappings in informatica required for the cdustomer touch points.
• Written the packages and required functions to get the questionnaire information.
• Taken care of releases into production without bugs.
• Test the requirements and got the good feedback from the clients.
• Knowledge transfer of development to other resources in the project.

Environment : - PL/SQL, Toad, Windows SQL Server 2014, Excel

PL/SQL Developer

Confidential

Responsibilities:

• Handled the team which consists for 4 members.
• Part of technical and functional discussions with Italian business team.
• Planned releasing activities and able to release with compromising the quality of work.
• Designed the tables and scenarios for the customer information.
• Coordinate with clients and gather the requirements.
• Handled a team size of three members.
• Written the packages and required functions to get the questionnaire information.
• Taken care of releases into production without bugs.

Environment : PL/SQL, Toad, Windows SQL Server 2014, Excel, HTML, Java Script, CSS.

Senior Oracle Developer

Confidential

Responsibilities:

• Created new Tables, Indexes, Synonyms and Sequences needed as per new requirements.
• Designing the flow of the projects and writing the util packages.
• Gathering reports format, understanding the functionality of the report.
• Interaction with the client for the requirements.
• Developing the logic according to the report format using the oracle report builder.
• Created Access Controls based on User roles.
• Interaction with the client for the requirements.
• Dealing with Packages, Procedure, Functions, Tables, Views, Indexes, Synonyms and Queries for reports.
• Coordinate with the client

PL/SQL Developer

Confidential

Responsibilities:

• Report Development
• Played an effective part in defect fixing and ticket resolution
• Involved in fixing performance issues of RFW components
• Involved in issue resolution during SIT and UAT
• Part of support activities during Go-Live
• Familiar with usage of PL/SQL Developer, Toad and Crystal Reports.
• Conducted trainings on RFW Development and published documents for the reference of team members
• Knowledge transfer of development to other resources in the project.

Environment : - PL/SQL, Toad, Crystal Reports