EXPERIENCE SUMMARY:

• Oracle Certified Professional with over 12 years of Information Technology experience in developing web - based multi-tiered applications using Oracle PL/SQL and UNIX/Shell Scripts
• Wrote stored procedures, functions, packages and triggers as per the business requirements.
• Coordinated with offshore team, Assigning the incidents, defects and development work
• Created new database objects like Tables, Views, Synonyms and sequences
• Working experience using Records, PL/SQL Tables, Objects, Collections (Nested Tables and Arrays), and Bulk methods to improve the performance of the application
• Executing PL/SQL blocks using cursors, REF cursors, exception handling, Collections -Nested tables and Index of Table and Dynamic SQL
• Created constraints on the tables for data validations and for maintaining the clear data without any issues.
• Expertise in Database Performance Tuning and Optimization using Oracle Hints, Explain plans and Table partitioning.
• Working knowledge of SQL Trace, Explain Plan and TK-Prof for performance tuning and database optimization.
• Experience in advanced PL/SQL concepts like Bulk collect, PL/SQL tables and Dynamic SQL for DML operations for better performance.
• Working experience on IBM Data-Stage ETL tool
• Expertise in ETL Design & Development using Oracle PL/SQL
• Worked on implementation of STAR Schema Modeling having FACTS and Slowly Changing Dimensions
• Knowledge of Oracle PL/SQL and advanced database programming concepts such as cursors, stored procedures, functions, and materialized views
• Working experience worked on Queries performance tuning, Gathering table statistics
• Data modeling experience with ER-win and Data Flow Diagram
• Experience in writing Shell Scripts for the process automation
• Strong work experience into Managing team for Development and Production Support, Onshore-Offshore coordination, Data Warehouse Projects using Scrum Methodology.
• ITIL V3 Certified. Aspiring for CSM/PMP certification.
• Good focus on project management, Multiple Project Deployments, Team handling, innovation and automation.
• Exposure to Financial, Manufacturing, Credit Card MIS (PRIME DB), Insurance and Mutual Fund Domain.
• Hands on work experience into Data Modelling, DB Security, DataStage8.7, Informatica7, Oracle, SQL Server and Netezza etc.
• Expertise in delivery of error-free code
• Excellent interpersonal and communication skills

TECHNICAL SKILLS:

Languages: Oracle PL/SQL 9i and 10g, UNIX (Shell Scripting)

Databases: Oracle 9i/ 10g/ 11g

Tools: PL/SQL Developer, TOAD 9.0

Platform: Windows, Linux (User Level), Shell Scripting (Korn Shell)Concepts: OOPS, Advanced PL/SQL

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Oracle Developer

Responsibilities:

• Involved in requirement analysis
• Engaged in design discussion with the Architect team
• Converted design into deliverables (Oracle PL/SQL) and ODI
• Created new database objects like Tables, Views, Synonyms and sequences
• Working experience using Records, PL/SQL Tables, Objects, Collections (Nested Tables and Arrays), and Bulk methods to improve the performance of the application
• Executing PL/SQL blocks using cursors, REF cursors, exception handling, Collections -Nested tables and Index of Table and Dynamic SQL
• Autonomous Transaction management for Audit purpose
• Mentored the offshore Team.
• Involved in delivery discussion and post-delivery customization

Environment: Oracle PL/SQL, Data Integrator

Confidential

Sr. Oracle Developer

Responsibilities:

• Coding into Oracle PL/SQL, Data Integrator
• Strong working exposure to Oracle Package, Procedure, Function, and various other objects like Table, constraints, external tables etc
• Peer Code review and following coding standards setup
• Code deployment checklist and coordination with DBA team for code deployment on Staging, UAT and Production DB
• Involved in requirement analysis
• Engaged in design discussion with the Architect team
• Converted ETL design into Oracle PL/SQL deliverables
• Mentored the team
• Involved in delivery discussion and post-delivery customization

Environment: Oracle 10g PL/SQL, Crystal Reports

Confidential

Sr. Oracle and ETL Developer

Responsibilities:

• Involved in gathering business requirements and preparation of Functional and Technical Requirement Documents.
• Work allocation to offshore team and follow-up along with delivery for UAT and Production deployment.
• Monitoring the overall project health and follow up with Project Leads to track the progress of Design and development of ETL jobs, prepared mapping design documents to capture ETL transformation logic.
• Writing Oracle PL/SQL Procedure and/or Functions
• Executing PL/SQL blocks using cursors, REF cursors, exception handling, Collections -Nested tables and Index of Table and Dynamic SQL
• Define and Monitor Sprints and keep track on the progress of each sprint.
• Closely working with the business users for the changes/progress notification.
• Managing standup call for each sprint.
• Managing Deployment, coordination with Multiple onshore/Offshore Team.
• Stakeholders notification on overall Project Health.

Environment: Datastage8.1, Oracle 10g PL/SQL, Shell Scripts

Confidential

Oracle PL/SQL Technical Leader

Responsibilities:

• ETL functionalities implementation using Oracle PL/SQL
• Created constraints on the tables for data validations and for maintaining the clear data without any issues
• Worked on Triggers and Regular expressions
• Working experience using Records, PL/SQL Tables, Objects, Collections (Nested Tables and Arrays), and Bulk methods to improve the performance of the application
• Executing PL/SQL blocks using cursors, REF cursors, exception handling, Collections -Nested tables and Index of Table and Dynamic SQL
• Developed the code as per design code document provided by the client
• Constantly interacted with client from the beginning of work till handover to Data Operation team
• Responsible for loading data on production, displaying sample claims in application to client, and obtaining customer satisfaction

Environment: Oracle 10g, SQL Developer, PL/SQL

Confidential

Senior Associate Software - Performance Tuning

Responsibilities:

• Performance tuned Oracle SQL queries and Procedure/Functions
• Performed Unit testing and test case documentation
• Engaged in BI reporting for further analysis and decision making charts
• Involved in providing support to System testing and Unit testing
• Involved in preparing the deployment documents
• Involved in providing the KT to application support team.

Environment: Business Objects, Oracle 10g SQL

Confidential, Charlotte, NC

Senior Associate Software - Oracle PL/SQL

Responsibilities:

• Convert ETL Programs into Oracle PL/SQL Code
• Written expertise in Oracle Package, Procedure, Function, Trigger, Sequences etc
• Utilized SQL*Loader to load flat files into database tables.
• Created new database objects like Tables, Views, Synonyms and sequences in EXADATA.
• Working experience using Records, PL/SQL Tables, Objects, Collections (Nested Tables and Arrays), and Bulk methods to improve the performance of the application
• Involved in requirement analysis from onsite business users
• Engaged DFD, HLD, LLD, and database designing
• Engaged in functional understanding of accounting entries
• Provided post production support
• Involved in process execution of change requests
• Designed ETL for sending the daily accounts data to production server
• Involved in preparation of unit test cases and execution of unit test cases.
• Responsible for performing code reviews

Environment: Oracle 10g, PL/SQL, J2EE

Confidential, Columbus

Senior Software Engineer - Database

Responsibilities:

• Engaged in RA from onsite
• DB Designing for ERP, normalized up to 3rd NF
• Engaged in coding (Oracle Package, Procedure, Function, Trigger) (100%)
• Oracle Query Optimization
• Involved in writing complex VIEWS and Materialized Views
• Engaged in flow design, coding, and testing database objects
• Participated into Oracle code review
• Involved in deployment with DBA Team
• Interacted with the client for multiple requirements

Environment: Oracle, PL/SQL, J2EE

Confidential

Consultant

Responsibilities:

• Optimized Oracle SQL queries to retrieve data from 500 GB ICICI bank Credit Card DB (80%)
• Interacted with user for the different requirement
• Documented the requirements
• Provided data to the users

Environment: Oracle 9i, PRIME Database (500GB)

Confidential

Senior Officer

Responsibilities:

• Designing UI using ASP.NET (20%)
• Business Logic in Oracle Procedure, Function (80%)
• Interacted with the user for the different requirement
• Engaged in coding
• Responsible for implementation
• Interacted rigorously with the client

Environment: Oracle 10g, ASP.NET

Confidential

Management Trainee

Responsibilities:

• Designing UI using ASP.NET
• Business logic in form of Oracle PL/SQL (Procedure, Function)
• Interacted with the user for the different requirement
• Engaged in coding
• Responsible for implementation
• Interacted rigorously with the client

Environment: Oracle 9i PL/SQL, ASP.NET