SUMMARY:

• 8+ years of experience in Software Development and System Analysis with expertise in working with databases and data warehouses technologies.
• Technically adept and confident software programmer with exceptional skills in coding and documentation.
• Expertise in Oracle database design and writing SQL queries and PL/SQL programming.
• Good working knowledge on server side programming (procedures, functions, packages, Triggers, views, synonyms and collections).
• Experience in writing complex SQL queries and tuning capabilities.
• Developed highly scalable batch processing/Scheduler processing PL/SQL stored programs to improve performance of batch jobs
• Experience in Oracle EBS Financials Modules (AR and GL)
• Experience in handling Third party tools such as PLSQL Developer, Toad, Winscp and Putty and Secure Shell Client.
• Experience on Job schedulers like $U and Tidal (TES).
• Experience on UNIX commands and Good at shell scripting.
• Experience on Core Java and WebLogic server maintenance activities.
• Experience on rally for project management and use case maintenance.
• Experience on Oracle Core DBA concepts like export/import of DB/Tables, oracle installation, table space management and Back up and recovery.
• Hands on knowledge on Big Data Technologies (Hadoop Framework) and its eco systems like HDFS, MapReduce, HBase, HIVE, Pig Latin, Sqoop, Zookeeper and Oozie.
• Experience in interacting with the clients for new requirements and enhancements.
• Ability to quickly learn system functionalities, programming languages and other applications/software.

TECHNICAL PROFICIENCY:

Languages: SQL, PL/SQL, Core Java

Web Technologies: HTML, XML, JSP, Servlets

Operating Systems: Windows 7/XP/2003 and UNIX/Linux

Databases: Oracle 9i, 10g, 12c, My SQL, Teradata

Tools: SQL * PLUS, TOAD, PL/SQL Developer, Winscp and Putty, BMC Remedy, Dollar Universe ($U), Tidal Job Scheduler.

ETL Tools: Informatica

Reporting Tools: SAP Business Objects

PROFESSIONAL EXPERIENCE:

Confidential

Technology: Oracle SQL, PL/SQL, Oracle 12c, Oracle ADF and Tidal.

Responsibilities:

• Contribution on NGCCRM Development and production Bug Fixes.
• Wrote database PL/SQL procedures, Functions, Packages. Creating/modifying the database tables, triggers and collections.
• Good experience on job scheduling tools ($U and Tidal) to Create, Launch, Monitor and Schedule the batch jobs.
• Wrote reconciliation scripts and automated the reports for business.
• Experience in writing complex SQL queries and tuning capabilities.
• Developed highly scalable batch processing/Scheduler processing PL/SQL stored programs to improve performance of batch jobs.
• Involved in new design and architectural changes.
• Experience in interacting with the clients on new requirements and attending the solution discussions with upstream and downstream applications.
• Experience in writing the test cases and rally project management.
• Preparing the SQL Queries for Business Objects reporting.

Confidential

Responsibilities:

• Contribution on Confidential Application Development and production bug fixes.
• Wrote database PL/SQL procedures, Functions, Packages. Creating/modifying the database tables, triggers and collections.
• Good experience on job scheduling tools ($U and Tidal) to Create, Launch, Monitor and Schedule the batch jobs.
• Changing the ETL (Informatica) mappings accordingly and loading the data in DWH
• Experience in writing the test cases and rally project management.

Confidential

Responsibilities:

• Contribution on RRR Application Development and production bug fixes.
• Wrote database PL/SQL procedures, Functions, Packages. Creating/modifying the database tables, triggers and collections.
• Good experience on job scheduling tools ($U and Tidal) to Create, Launch, Monitor and Schedule the batch jobs.
• Changing the ETL (Informatica) mappings accordingly and loading the data in DWH
• Experience in writing the test cases and rally project management.

Confidential

Technology: Oracle 10g,Adobe Flex,J2EE,Hibernate,Weblogic 9.2/10.2,UNIX

Tools: PLSQL Developer and Putty.

DB designer and developer

Responsibilities:

• Contribution to Database Design and Development Activities.
• Wrote database PL/SQL procedures, Functions, Packages. Creating/modifying the database tables, triggers and collections.
• Understanding the UNIX shell scripts (from TPS1) and coding equivalent Oracle procedure and functions in to TPS2.
• Experience in SQL queries tuning and PLSQL programs tuning.
• Developed Oracle objects like Indexes, views and synonyms.
• Responsible for writing unit test cases with valid proofs.
• Assisting Testing team in writing the System Test cases and also coordinated with them in executing and validating them.

Confidential

Technology: SQL, PL/SQL, Oracle 10g, Oracle Forms and Reports.

Developer

Responsibilities:

• Developed code for Stored Procedures, Functions and Packages to fulfill business requirements.
• Developed accurate SQL queries to pulling the data from database tables.
• Developed procedure, functions and packages for external validations.
• Testing - Unit testing and Acceptance testing.
• Co-ordinate and participating discussions with on site programmers or project Managers
• Understand the overall project functionality and giving quick response to the user Queries.
• Program Specification Document.
• Provide end user support for application development.

Confidential

Technology: Oracle10g SQL,PL/SQL and Forms/Reports 6i

Developer

Responsibilities:

• Responsible for analyzing the specifications provided by the client for new business requirements.
• Developed PL/SQL Procedures, Packages, Sub Programs, Cursors and Triggers.
• Developed report SQL queries to pulling the data from various database tables.
• Responsible for writing Triggers, Views and synonyms.
• Responsible for design and development, testing and implementation of Oracle Reports.
• Testing - Unit testing, Integration testing and Acceptance testing.