SUMMARY:

• Having 5+ years of experience as ORACLE Database Developer in software development,
• Implementation and has expertise in SQL, PL/SQL Code, SQL Performance tuning.
• Good knowledge of Database management system implementation with SQL, PL/SQL, Constructive skill in developing stored procedure, user defined functions and packages.
• Application of cursors, runtime handling of error using exception.
• Well - acquainted in working with complex SQL queries with Joins, Functions, Sub-queries, Views and Set operators.
• Good knowledge in writing the code to fire the Application Level Triggers, Created Database, Triggers over DML Statements.
• Experience in creating the tables, sequences, synonyms and constraints for the experimental Data load capture.
• Good exposure on Object oriented concepts and Advanced topics Like Analytical Functions, Indexes and Partitioned Tables in SQL.
• Expert in coding complex, UTL FILE package, collections, records types, PL/SQL Tables and Ref Cursors.
• Good ability to quickly grasp new concepts and technologies possessing problem solving skills
• As well as hard working and above all a good team player.
• Ability to work in a team as well as independently, Enthusiastic to take challenges.
• Worked on Databases like Oracle, SQL Server, Netezza and Worked on integrating data from Flat files like fixed width /delimited, XML files.
• Supported on Unit testing, Functional testing and User Acceptance testing on UNIX and Windows Environment and worked on solving the incidents/Defects and providing hot fixes, writing and debugging to find out the problems in mappings, troubleshooting and rectifying ETL bugs.
• Participated and understood business requirements, discussed with Business Analyst to gather and analyze the requirements and to prepare business rules.
• Good knowledge of requirement analysis and validation, database design, solution design.
• Experience in Database Backup and Disaster Recovery procedure and Replication.
• Proficient at using Excel for Data Analysis and using Advanced excel functionalities like Pivot, Vlookup and More.

TECHNICAL SKILLS:

Core skills: Software Development, Enhancement and Maintenance.

Programming Languages: PL/SQL, SQL, SQL *PLUS, SQL*LOADER, Unix Shell Scripting, XML

Database: Oracle 11g/10g/9i, MySql, SQL Server, Netezza

Operating Systems: Windows XP / Vista / Windows 10/08/07, UNIX, Linux, Redhat.

Tools: SQL Developer.

Database tools: Oracle SQL Developer, SQL plus, Toad, Aginity Workbench, MySQL Xampp.

EXPERIENCE:

Confidential, NEW YORK, NY

Oracle/Sql Developer

Responsibilities:

• Creating different database objects like tables, views and manipulating them using SQL queries.
• Gathering the functional requirement and implementation of business logic.
• Writing complex SQL queries using joins, sub queries and correlated sub queries to retrieve data From the database.
• Developing Stored Procedures, Functions, Triggers and user - defined Packages.
• Checking Business Validations using Triggers.
• Handling User defined and Built-in Exceptions.
• Loading data from flat file into Oracle database using SQL Loader
• Good exposure on Exception Handling.
• Generating Load Data for Application tables of Billing from Legacy System.
• Understanding the Legacy database structure along with application functionalities.
• Designing the solution for existing business requirements.
• Developing various functions and stored procedures for populating Target tables.
• Writing minus queries to check the correctness of the data migrated.
• Tuning and Monitoring the Performance of Existing code.
• Handling the Incidents for Breaks in Inputs and billing system and Defects due to Gap between Upstream and Downstream applications.
• Performance tuning in Oracle.
• Delivering within strict timelines.
• Involving in the full development cycle of planning, analysis, design, development, testing, and implementation.

Environment: Oracle 11g, Flat files (fixed width/delimited), MS-Excel, UNIX shell scripting, Putty, WinScp.

Confidential, Chicago, IL

Oracle/Sql Developer

Responsibilities:

• Work as an SQL Developer and establish strong relationships with end users and technical resources throughout established projects.
• Work closely with the development team to provide support for database objects (stored procedures/triggers/views) and performing code review.
• Work closely with Application Developers to ensure proper design and implementation of database systems Database administration including performance monitoring, access management and storage management.
• Create, develop and maintain SQL processes for channel performance data warehousing Created Mapplets and used them in different Mappings..
• Created Workflows and Sessions to load data from the SQL Server, Oracle, flat file, and XML file sources that exist on servers located at various locations.
• Responsible for creating business solutions for Incremental and full loads.
• Created different parameter files and changed Session parameters, mapping parameters, and variables at run time.
• Created high-level design document for extracting data from complex relational database tables, data conversions, transformation and loading into specific formats.
• Created schema objects like indexes, views and sequences.
• Developed standard and re-usable mappings and Mapplets using various transformations like Expression, Lookups, Joiner, Filter, Source Qualifier, Sorter, Update strategy and Sequence generator.
• Created and modified as SQL plus, and sql loader scripts for data conversion.
• Creating indexes on tables to improve the performance by eliminating the full tables scans and views for hiding the actual tables and to eliminate the complexity of the large queries.

Environment: Oracle 11g, WinScp, Linux, XML, SharePoint, Quality Center.

Confidential, Dallas

Jr. Oracle Sql Developer

Responsibilities:

• Generating Load Data for Sanofi from Legacy PV systems to Argus 8.1.
• Understanding the Argus 8.1 database structure along with application functionalities.
• Designing the solution for existing business requirements.
• Developing various functions and stored procedures for populating Argus tables.
• Writing minus queries to check the correctness of the data migrated.
• Tuning and Monitoring the Performance of Existing code.
• Handling the Incidents for Breaks in Inputs and Sanofi outputs and between Upstream and Downstream applications.
• Performance tuning in Oracle.
• Delivering within strict timelines.

Environment: Oracle 11g, Flat files (fixed width/delimited), MS-Excel, UNIX shell scripting, Putty, WinScp.