SUMMARY:

• More than 9+ years of programming experience as an Oracle PL/SQL Developer in all phases of Software Development Life Cycle (SDLC) including Analysis, Design, Data Modeling (Logical and Physical) and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Worked with Revenue Assurance team for revenue reconciliation.
• Worked on SQL/XML standard functions and Oracle Database - provided functions and packages for generating XML data from relational content Reading and writing XML to/from files.
• Worked on externally organized tables.
• Worked on DBA stuff.
• Highly competent in gathering user requirements and converting those into software requirement specifications.
• Expertise in designing of HLD, LLD, Data Model and Database Development Lifecycle, Risk & Gap analysis.
• Expertise in creating relational database development, for creating complex database queries, writing Constraints, Indexes, Views, Packages, Stored Procedures, Cursors and Functions using PL/SQL in Oracle databases (8i, 9i, 10g, 11g and 12c).
• Experience in using Oracle supplied packages such as DBMS SQL, DBMS JOB, and UTL FILE to read and write into files.
• Implemented PL/SQL advanced concept like Bulk Collects, Bulk Inserts Ref Cursors, Collections, Dynamic SQL, Autonomous transactions, Table Partitioning and External tables.
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans, Tk-Prof and Table Partitioning.
• Proficient in Oracle Tools and Utilities such as SQL*Loader, Import/Export, EXPDP/IMPDP.
• Migrated large data between different data sources to Oracle databases.
• Experience in development of custom Oracle forms and reports application.
• Expertise in data modeling, Normalization, database design, data loading, data retrieval, modification, and archival techniques.
• Proficient in Oracle database creation, table space management, creating database links, schemas, profiles and roles, managing control, redo log and data files.
• Used several Oracle provided packages such as DBMS JOB, DBMS PROFILER, DBMS STATS and DBMS SCHEDULER packages.
• Working Knowledge on UNIX, Windows and UNIX Shell Scripting.
• Skillful in working with the tools like SQL * PLUS, TOAD, PL/SQL Developer.
• Good experience in data modeling using Erwin Data Modeler: Creating entities, relationships, sub-types, schemas and ERD to database schemas.
• Good experience in Software Engineering Processes (Agile and Waterfall Methodologies). Development of software project based on users’ requirements and meeting deadlines to satisfy users' needs.
• Good exposure of Golden gate technology for real time data replication between multiple databases.
• Worked on Java,hibernate,angular Js applications.
• Communicate with the business users or functional team to identify, analyze and translate business needs into functional specifications.
• Experience in designing/migration from RDBMS application to MongoDB.

TECHNICAL SKILLS:

Operating Systems: WINDOWS98/NT/2000/XP, UNIX, Linux

Languages: SQL, PL/SQL, JAVA,ORACLE XML

Scripting Languages: Unix Shell, Perl, Java Script

RDBMS Database: Oracle 12c/11g/10g/9i/8i, SQL Server, MS-Access

NO Sql Database: MongoDB 3.2

Other Tools: Golden Gate, TOAD, SQL developer, SQL Navigator, Oracle Enterprise Manager, Oracle Apex 5.0.3, SQL*Plus, SQL* Loader, putty, SVN

Project Management Tools: VSS, Microsoft project, Rally

PROFESSIONAL EXPERIENCE:

Confidential

Oracle PL/ SQL Developer/ Tech Lead

Responsibilities:

• Writing oracle package with help of built in XML package to read XML data from files.
• Writing packages and procedure to read or generate XML data to downstream.
• Impact Analysis, Interaction with business to understand the requirement.
• Migrated Dev wizard Data into SLIM to enable Oracle project to consume data from SLIM.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Set up golden gate replication to provide data to various downstream system.
• Automated various type of report to avoid manual work.
• Created PL/SQL stored procedures, functions and packages for various functionalities
• Worked on performance tuning to improve the user experience at UI side by enable them to fetch data at one central location and created mechanism to push the data to that location by offline process.
• Involved in exporting and importing data from one stage database to another.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE and AUTOTRACE.
• Involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used BULK COLLECT and FORALL for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Used to sqlldr to load migrated data from Dev Wizard.
• UTL FILE package.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Worked on data migration and to and GG setup for upstream and downstream system.
• Created various Unix script to maintain the data file and manage the files on the server.
• Used ETL to provide data to downstream system for reporting and warehouse purpose.

Confidential

Oracle PL/ SQL Developer/ Tech Lead

Technologies: Oracle 11g, Oracle Apex UNIX, Java, JavaScript, JQuery, Splunk,XML

Responsibilities:

• Impact Analysis, Interaction with business to understand the requirement.
• Reading and generating XML content in Oracle.
• Involved in the continuous enhancements and fixing of production problems.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Developed a tool to take backup of entire data model and store it in flat files on daily basis
• Created PL/SQL stored procedures, functions and packages for various functionalities
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in exporting and importing data from one stage database to another.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE and AUTOTRACE.
• Involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used BULK COLLECT and FORALL for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Create unix script for running the rman backup on this server.
• Used crontab to schedule the unix jobs
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.

Confidential

Team Lead

Technologies: JAVA, Oracle 11g, UNIX, SSIS

Responsibilities:

• Played key role in implementation of RECC network in MoneyMap.
• Analysis of requirements for new project and impact analysis.
• Preparation of High Level & Low Level Design documents.
• Development of code as per the business requirements
• Providing fixes to the issues identified in testing phase.
• Packaging of the developed component to be deployed in production environment.
• Provide production support for the deployed project till it is stabilized
• Received client appreciations for the projects I worked on
• Create data ware house like report based aggregate data to SSAS.(used ETL to accomplish this)
• Created various unix shell script to purge the files on file system and scheduling oracle procedure for purging.

Confidential

Team Lead

Technologies: .Net, Oracle 10g, UNIX

Responsibilities:

• Created PL/SQL stored procedures, functions and packages for various functionalities.
• Involve in testing, bug fixing and deployment
• Post production support.
• Handling ad-hoc requirement like providing data to upper management for future planning.

Confidential

Technologies: .Net, Oracle 10g, UNIX

Responsibilities:

• Involved in Designing user interfaces.
• Writing efficient business logic.
• Involved in code development and bug fixing.
• Database Designing
• Creating Stored Procedures.
• Created various unix shell script to maintain the external file and loading it in our system