SUMMARY

• Highly motivated, result focused Oracle DB & PL/SQL Developer 13 years of experience in programming as an Oracle and PL/SQL Development, Designing and Implementation, troubleshooting of SDLC agile methodologies.
• To Developed Business architecture using requirements such as Scope, Processes, Alternatives, and risks.
• Preparing PRD and FSD, SRS, and LLD, FS document, analysis, interviews, workshops, and workflow analysis.
• Assisting with the Business case, Planning and monitoring, Eliciting requirements, Requirements organization, Translating and simplifying requirements, Requirements management and communication, Requirements analysis.
• Good Experience in Oracle SQL & PL/SQL development and implementation & Production support 24/7.
• Creating the databases and database objects such as the tables, table spaces, synonyms, views, triggers, stored procedures, defaults, domains, and indexes.
• TO Developed Complex database objects like Stored Procedures, Functions, and Packages and Triggers using Oracle 11G, Cursors and Exception handling, Scheduling jobs with Autopsy’s.
• Good knowledge of SQL performance related features such as Query Optimizer (CBO), table partitions, Explain Plan, SQL Trace & Generating & Analyzing TKPROF & AWR reports, Gathering Statistics, hints, SQL Profiler, Automatic SQL Tuning adviser.
• Handling the Project Team with Clients Interactions and Co - Ordinations with Onsite and Supports, Worked Created SSIS, SSRS and SSAS Packages.
• Good Experience in Database and Business Intelligence technologies with expertise on ETL process and Reporting using SQL Server 2008/2005, SSIS and SSRS.
• Implementation of Error Logging & Handling, Data Flows, Reporting Services, Advanced SQL Querying & Program DB Security and Encryption, SSIS Package Deployment/Managements using SQL Server 2008.
• Created Various Reports according to the Business requirements, Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Worked in problem management, Resolving Tickets and bringing issues to the closure during product SIT & UAT and production support, developing the Oracle forms 10g, generating the reports 6i.
• The responsibilities of a Database Administrator include Physical database design, Database maintenance, Backup and recovery, Participation on the Decision support steering committee, Data Replication, Repository Management, Security administration, Database loading, Performance Monitoring and Summary table creation responsibilities between the support group and the user community.
• Maintaining a high-level view of the OLAP & OLTP environment and ensuring fit-for-purpose tool usage at the organization, Ensuring access to business and technical metadata from within the OLAP tool.

PROFESSIONAL EXPERIENCE

Sr. Software Engineer

Confidential

Tools: PL/SQL, Oracle 11g, ETL, SSIS, SSRS, SSAS, Oracle APEX, apache-cassandra-3.4, JAVA, Jenkins, SVN, JIRA

Responsibilities:

• To Development Database Writing with Procedures, Functions & Packages, and SQL Query Tuning Performances. Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Clients Interactions and Co-Ordinations with Onsite & Offshore Team Supports.
• Attending the Daily stand-up to update the status using agile methodologies.
• Involving fixing of bugs raised while testing of the product the Debugging the PL/SQL Coding using TOAD, Oracle 9i and 11g tools.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Involving fixing of bugs raised while testing of the product the Debugging the PL/SQL Coding using Cassandras, PostgreSQL DB tools. Analysis and reporting of testing defects, fixing the bugs.
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
• Analysis and reporting of testing defects, fixing the bugs. Analyzed and documented defects using bug tracking tools & Loading the Test data in to Cassandra DB using Bulk upload, Code review & performance manual functional testing.

Technical Lead.

Confidential

Tools: UNIX Shell Scripting, SQL Server 2008, SSIS, SSRS, SVN, JIRA, PL/SQL, Oracle 11g, JAVA, GEL, XOG

Responsibilities:

• Handling the Project with Clients Interactions and Co-Ordinations with Onsite and Supports.
• Writing with Procedures, Functions & Packages, SQL Query Tuning Performances.
• Taking Database full Backup, Transaction log backup & differential backup in daily Routine.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Diagnosing and tuning the server optimal performance using SQL Server 2008 SQL Profiler and Database Engine Tuning Wizards. Analysis and reporting of testing defects, fixing the bugs.
• Involving fixing of bugs raised while testing of the product the Debugging the PL/SQL Coding using TOAD, Oracle 9i and 11g tools.
• Taking Database full Backup, Transaction log backup & differential backup in daily Routine.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Generating the TKPROF report for Analyzing Tables and indexes tuning the query.

Sr. Oracle Developer

Confidential

Responsibilities:

• To Developed the Complex Tax accounting system with the set of rules governed by Income Tax department.
• Worked on Pre-processing, Account Receivables, Account Payables, and General Ledger Modules of Oracle Applications to account the Processing details of Tax Payer, Development Database Writing with Procedures, Functions & Packages, and SQL Query Tuning.
• Creation and modification in packages, procedures, functions and other PL/SQL objects. (Hot fix) and Enhancement (Change Requests), Involving ETL Process.
• Involved in the Migration of SQL Server doing schema re-engineering conversion of TSQL Stored Procedure to Oracle PL/SQL Transformation of all MS-SQL Data table to Oracle.
• Created Various Reports according to the Business requirements.
• Involves creation of objects (Tables, Views, and Synonyms) and data flow logic using stored procedures. Involving in tracking the data base changes, preparation of Unit test cases, Code review of System Test Scripts and Unit Test Cases, creation of Detailed Specification Documents.

Sr. Oracle Developer

Confidential

Responsibilities:

• Writing with Procedures, Functions & Packages, SQL Query Tuning Performances.
• Test data preparation and conditioning, Test case execution.
• Involving fixing of bugs raised while testing of the product the Debugging the PL/SQL Coding using TOAD, Oracle 9i and 11g tools. Analysis and reporting of testing defects, fixing the bugs.
• Creating test cases for bundling up of the reports both in Unit testing and in Integration testing for individual, Involving ETL Process.
• MS-SQL Server 2008 Implementation of Error Logging & Handling, Data Flows, Reporting Services, Advanced SQL Querying & Programming, DB Security and Encryption, SSIS Package Deployment/Managements.
• Created Various Reports according to the Business requirements.
• Provided support in UAT and Production issues and Running Batch for UAT.
• Performances of the produces while improving the tuning with explain plain and hints, force the Indexes.
• Generating the TKPROF report for Analyzing Tables and indexes tuning the query.

Sr. PL/SQL Developer

Confidential

Responsibilities:

• To Development for Money Marketing, Security and Testing of business applications.
• Writing with Procedures, Functions & Packages, SQL Query Tuning Performances, reports to meet the requirement worked on.
• TO Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using Oracle 11G, Cursors and Exception handling, Scheduling jobs with Autopsy’s.
• Involving fixing of bugs raised while testing of the product the Debugging the PL/SQL Coding using TOAD, Oracle 9i and 10g tools. Writing with Procedures, Functions & Packages, Tuning Performances, Unit Testing. Designed and Development of Reports, Running the EOD Batch in SIT.
• Involving in interacting with the client for clarifications and communicating the changes done at offshore, also uploading the status in the defect review meeting. Booking the Deal and Check for Queue, Upload the Product Process. Generating for E-Dealer reports and FICC Reports.
• Handling the Project Team with Clients Interactions and Co-Ordinations with Onsite and Supports,
• Optimized and modified the triggers, complex store functions, procedures, packages user data type.
• Performances of the produces while improving tuning with explain plain and hints, force the indexes, provided support in UAT and Production issues and Running Batch for UAT.

Sr. Oracle Developer

Confidential

Tools: Windows, SAP, PL/SQL Developer, Oracle 9i, 10g, SV, JIRA, Forms 7.3, Reports 6i, Crystal Reports

Responsibilities:

• Design, Development, Implementation, and Testing of business applications.
• Involved developing the customer Alpha & SAP Account & Cart Management using Oracle form 7.3 tools.
• Writing with Procedures, Functions & Packages, SQL Query Tuning Performances, Batch processing, Imports the validated data using SQL Loader.
• Involved development Generating the reports and data capturing, processing from the various filling Stations generating the report using (DB) ALPHA Server, generating the credit limit, Invoices daily & monthly using SAP Server.
• Created Various Reports according to the Business requirements.
• Involving fixing the bugs while testing of the product the Debugging the PL/SQL Coding using TOAD, Oracle 9i and 10g tools.

Sr. Software Engineer

Confidential

Tools: UNIX Shell Scripting, Toad, Oracle 9i, PL/SQL Developer tool, Clear case 5.2, JIRA

Responsibilities:

• Involved the creating self-assessment using Phoenix Application tool.
• Involved the co-ordination with the onsite team and reporting status to the team.
• Writing with Procedures, Functions & Packages, Tuning Performances, Unit Testing.
• Designed and Development of Reports.
• Creating test cases for bundling up of the reports both in Unit testing and in Integration testing for individual.
• Enhancement of the existing reports.
• Documentation of the reports Enhancement of the existing reports.
• Creating test cases for bundling up of the reports both in Unit testing and in Integration testing for individual.
• Provided support in UAT and Production issues and Running Batch for UAT.
• I have been responsible for development and coding standard change requests working with PL/SQL.