SUMMARY

I am a highly committed and passionate Oracle PL/SQL Developer having an overall experience of 9 Years in IT Industry, with majority of domain expertise in Telecommunications and Banking and rich experience in customer facing applications like Oracle Tele Services (CRM), OSS - BSS support, systems based on VOIP Telephony, programs like Global Readiness for Global Banking & Markets etc.

TECHNICAL SKILLS

Application/Languages: Oracle E-Business Suite (Teleservices) - CRM

(Inbound/Outbound Call Centre Functionality): Oracle PL/SQL, RDBMS - Oracle SQL Database 9i,10g,11g,12c, UNIX Commands & UNIX Shell Scripting, Advanced Microsoft Excel, ETL - Informatica (Mappings & Transformations) - Basics, Oracle Forms & Reports - Basics

Tools/Utilities: Oracle PL/SQL Developer, SQL Developer, TOAD, SQL Plus, Oracle BI Publisher, Informatica Data Quality, Putty, WinSCP, Tortoise SVN, IBM Rational Team Concert, BMC Remedy Control-M Jobs, Crontab, AutoSys Scheduler, JIRA, SQL Loader, Data Loader, Eclipse, Confidential XenApp, Apache Tomcat, GitHub

Areas of work: PL/SQL Objects Development & Enhancements, Database Modelling, BI Reporting, Performance Tuning/Query optimisation, Data Analysis & Testing, Data Migration, Bulk upload, Production Support & Deployments, Data Partitioning, SFTP Connectivity

Domain: Telecommunication, Manufacturing, Banking, Travel & Hospitality, Real Estate Firms

PROFESSIONAL EXPERIENCE

Confidential

Oracle PL/SQL & BI Developer

Technology: Oracle PL/SQL 12c, Oracle BI Publisher

Tools: TOAD, Tortoise SVN, WinSCP, JIRA, Oracle Template Viewer, dbms scheduler, utl file, Autosys

Responsibilities:

• Involved in Data Analytics - Data Integration and Reporting
• Creating packages, procedures, triggers, functions, views etc. as a part of reporting data and to load various flat files to our systems
• Creating complex queries for various kind of customer reports, defining parameters (within procedures) transmitted via JSON and generating the XML feed.
• Creating lookup codes for various fields needed as dropdown in frontend reports
• Creating various Excel, PDF, RTF templates using BI Publisher
• Defining various XDO METADATA for the necessary fields of the report templates
• Use of template viewer to validate the report output
• Involved in data integration (Inbound/Outbound) from flat files using UTL FILE
• Scheduling jobs using dbms scheduler and Autosys for Inbound/Outbound Integrations.
• Enhancements and optimization of existing objects for performance benefits
• Working with consultants on various requirements gathered in JIRA.

Confidential

Oracle SQL Developer

Technology: Oracle SQL 11g, Selenium Testing

Tools: Oracle SQL Developer, Data Modeler, Eclipse, JIRA, Git HUB

Responsibilities:

• Involved in Bulk Data Transfer and Validation, data being migrated from source to target systems using Informatica Power Centre
• Defining SQL Queries and transformation rules for pushing the data to target
• Writing SQL Queries by use of: Joins and Subqueries to consolidate the data from various tables
• Hierarchical Queries to fetch the hierarchy data
• Oracle defined functions to pull data from various tables Analytical Functions
• Data Modeling for defining the relation between tables
• Analyzing data and preparing SQL scripts using optimization techniques
• Running the validation scripts using Maven Eclipse and tracking the data errors
• Working with Analysts on various requirements gathered in JIRA
• On call participation with Client to understand the functionality and plan for work
• Task Management in GitHub.

Confidential

Oracle PL/SQL Developer

Technology: Oracle PL/SQL 11g,12c, UNIX

Tools: Oracle SQL Developer, Putty, JIRA

Responsibilities:

• Creating Packages, Procedures and Functions to implement business logic.
• Use of Bulk Collections for data fetching and data insertion via triggers.
• Monitoring of Performance of SQL Queries and tuning it using Indexes, Hints etc.
• Running the various scripts through UNIX commands.
• Creation of Views and Materialized Views.
• Use of Compound Triggers
• Involved in Database Migration of Airlines Inventory systems to AWS (Amazon Redshift)
• Interacting with Business Analyst to understand the business requirements and actively participating in project meetings

Confidential

Oracle PL/SQL Developer & Data Analyst

Technology: Oracle PL/SQL 10g, UNIX

Tools: TOAD, Putty, RTC, JIRA, BMC Control-M, SQL Loader

Responsibilities:

• Loading various flat files into Oracle tables using SQL Loader.
• Connecting the source systems via key authentication for SFTP transfer of flat files to our server
• Creating Dynamic SQLs and Control Scripts
• Creating Triggers to maintain history data
• Creating various Oracle Partitions for Data Management
• Use of Control-M jobs for running the scripts automatically
• Creation of Indexes and Grant privileges
• Working with Business Analysts on new requirements using JIRA.

Confidential

Oracle PL/SQL Developer (Production Support)

Technology: Oracle PL/SQL 9i, Oracle EBS (Teleservices) - CRM, Microsoft SQL Server

Tools: Oracle PL/SQL Developer, SVN, SQL Plus, WinSCP, Putty, Apache Tomcat, Crontab,Data Loader

Responsibilities:

• Implementation (Development) of Change Request (Fixes) and Ticket Solving.
• Designing custom solutions as per the requirements.
• Providing functional training to client.
• Preparation of technical documents, configuration setup documents
• Creating Packages, Procedures, Functions, Triggers, Tables, Views, Indexes, Sequences, Synonyms etc.
• Creating Records, Collections, Ref Cursors and used Bulk Collect for fetching various data items
• Experience in many Exception Handling, including user defined to handle various errors.
• Server monitoring and server bouncing based on Apache Tomcat.
• Enhancements in JSP and JAR files.
• Debugging and testing of application, SQL procedures
• Defining executable concurrent program and assigning it to request group.
• Creation of value Sets and lookups.
• Creation of JAR files and various objects for migration of Viznet data based on SQL Server to Oracle TeleServices.
• Scheduling jobs for running various sub-programs using Crontab.
• Application maintenance, performance improvement, production roll out handling & deployment.
• Have experience on usage of Explain Plan, Trace utility and tuning queries.
• Have experience in monitoring and killing locks on tables.
• Developed objects for data flow from Oracle Tele Service to Remedy and to an end user Portal system; integrated through EAI (Enterprise Application Integration).
• Involved in Data Archiving and Data Purging by writing procedures for the same.

Confidential

Oracle PL/SQL Developer

Technology: Oracle PL/SQL 9i, Oracle Forms & Reports

Tools: Oracle PL/SQL Developer, Citrix, RTC

Responsibilities:

• Monitoring of applications and reviewing the code based on SQL Server by accessing the Confidential XenApp.
• Server Monitoring and Server Restart if any application is not accessible
• Work with Oracle DBA to release any lock sessions and report any performance issues.
• Minor Enhancements in Oracle Forms & Reports
• Enhancements in excel reports using Macros
• Troubleshooting the issues and any modifications needed in the existing query.