SUMMARY

• 3+ years of experience in complete Software Development Lifecycle (SDLC) using Oracle 11g/10g on Windows and UNIX platforms in the phases of Analysis, Designing, Development, Production support and Testing and well versed with basic DBA activities.
• Extensive experience in writing/debugging Oracle SQL, Dynamic SQL, PL/SQL code i.e. Packages, Stored Procedures, Functions, Triggers, Cursors, Ref Cursors, Constraints, Indexes, Views, Materialized Views, Database Links (DBLINKS), Sequences, Synonyms, and Global Temporary tables. Strong knowledge in using Oracle built - in packages (like UTL FILE, DBMS SQL), Cursor management, Exception handling etc.
• Used SQL analytical functions for customizing reports.
• Extensive hands-on experience with Client/Server technology using Reports 10g.
• Extensively involved in writing SQL Queries (Sub queries and Join conditions), PL/SQL subprograms and Query Level Performance tuning.
• Expert in Client-Server application development using Oracle 11g/10g, PL/SQL, SQL *PLUS, TOAD, SQL *LOADER.
• Exposure in using Tools like TOAD, SQL Developer and SQL*Plus for writing PL/SQL Programs.
• Experience in creating complex triggers or generate packages and indexes to increase performance and complex SQL queries for joining multiple tables.
• Extensive experience developing External tables and using Oracle utility tools like SQL*Loader, Import and Export programs.
• Extensively involved in SQL tuning, troubleshooting, debugging and fixing the codes/scripts.
• Developed Test Scripts, Test Cases and SQL QA Scripts to perform Unit Testing, System and Load Testing.
• Solid understanding of relational databases.
• Experience with data migration using BULK COLLECT.
• Experience in Cut Over Plan and Contingency Plan.
• Experience in providing 24x7 production support and handling and raising defects in JIRA Ticketing tool
• Experience in data modelling tool like Visio, MS Visual Studio.
• Worked in onsite - offshore model and experience in leading the technical team
• Thorough experience in oracle application SCM, TCA modules.

TECHNICAL SKILLS

ERP: SAP Business Objects

Application Tools: Informatica 9.0 ETL tool

Databases & Tools: Oracle 11g/10g, TOAD, SQL*PLUS, SQL*Loader, SQL* Developer, Visio, MS Visual Studio, LINQ.

Operating Systems: Windows NT/XP/2000/98, UNIX, Linux, MS-DOS

Languages: SQL, PL/SQL, UNIX, Core Java, C#

Scripting Languages: Unix Shell scripting, HTML, JavaScript

PROFESSIONAL EXPERIENCE

Confidential

Graduate Teaching Assistant

Responsibilities:

• Teaching Networking and data base related concepts to the students.
• Assisted Professor in conducting the lab experiments for over two semesters.
• Grading of the lab experiments and assignments for more than 50 students.
• Involved in clarifying the doubts with respect to lab sessions and concepts related to the courses they are associated with.
• Helped the students in developing the projects using network related concepts by CPT software.
• Involved in the designing of the data models for various students for the development of the database across different projects.
• Assisted professor in the password recovery for various routers across the University

Software: Oracle(11g), PL/SQL, MS VISIO, Cisco Packet Tracer (CPT Tool)

Confidential

Database Developer

Responsibilities:

• Design and develop PL/SQL packages, Procedures and Functions, Cursors, Ref Cursors and Triggers.
• Handling application DBA activities.
• Scheduled maintenance plans like daily & weekly backups, rebuild indexes, update stats.
• Developed complex scripts for automating batch processes which manage critical processes of the CRM system.
• Migrating database and applications to new releases and implemented changes to the Data Model.
• Worked Closely with Data Architect team to design and create scripts for objects such as tables, indexes, views, sequences, object types and collection types.
• Interaction with clients to understand the business flow and functional requirements of the application.
• Used Agile Methodology for the application development.
• Involved in HLD and LLD designing with the Business Analysts.
• Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views in Development and Production environment using PL/SQL and SQL*Plus.
• Designed Data Flow Diagrams (DFD’s) using Visio
• Assisted with required data analysis, interpretation, correction and presentation for various assignments
• Involved in scheduling the daily jobs and procedures using Autosys.

Software: Oracle(11g), PL/SQL, TOAD, MS VISIO, Unix, Autosys

Confidential

Oracle Database Developer

Responsibilities:

• Design and develop PL/SQL packages, Procedures and Functions, Cursors, Ref Cursors and Triggers.
• Handling application DBA activities.
• Scheduled maintenance plans like daily & weekly backups, rebuild indexes, update stats.
• Developed complex scripts for automating batch processes which manage critical processes of the CRM system.
• Migrating database and applications to new releases and implemented changes to the Data Model.
• Review and sign off functional design document
• Design/ Review Technical design document
• Include data modeling in the design documents
• Review/ Build Code
• Prepare execute test cases
• Involved in scheduling the daily jobs and procedures using Autosys.

Software: Oracle(11g), PL/SQL, TOAD, MS VISIO, Unix, Autosys

Confidential

Oracle Database Developer/ETL Developer

Responsibilities:

• Analysis of the specifications provided by the clients, Preparation of design Docs, Test Case, and Implementation documents.
• Created Views using a bunch of Joins, Union and minus operators on the reference tables which hold the data.
• Responsible for developing database objects and maintaining database deployment scripts, developing procedures, function and triggers
• Responsible as the Point of Contact (POC) for the Confidential Technical Team.
• Wrote/Modified stored procedures, Triggers for Database operations in Oracle.
• Presentations to cross-flow teams and client.
• Helping the project manager in preparing contingency plan & project planning.
• Regular monitoring the production databases and applications for any provisioning issues.
• Developed all the ETL objects using Informatica 9.5 which includes all the mappings, transformations and workflows.
• Effectively developed and tested Type 1 and Type 2 (Slowly Changing Dimension) mappings.
• Part of the migration team to migrate all the objects from Dev to Test and finally to PROD environment.
• Part of the production support team after the project had gone live.

Software: Oracle(10g), PL/SQL, Unix, Informatica (9.0), Autosys, TOAD