SUMMARY:

• Around 8 years of experience in various phases of Software Development Life Cycle and Agile methodologies involving Analysis, Design, Development and Maintenance of Business Applications using Oracle Relational Database Management System.
• Experience as Oracle Developer (application design, development, performance tuning and problem troubleshooting) in OLTP and OLAP environments.
• Worked comprehensively in all phases of SDLC using WATERFALL and AGILE methodologies including SCRUM.
• Experience in Design and Implementation of PL/SQL Stored Procedures, Functions, Packages, and Database Triggers for Oracle Relational Databases.
• Proficient in the Data Manipulation using SQL for the retrieval of data from the Relational Database (inner joins, outer join, group by, order by, cursors, etc)
• Proficient in Oracle Tools and Utilities such as SQL*Loader, TOAD, SQL Developer, and PL/SQL Developer
• Experience in Design and Implementation of PL/SQL Stored Procedures, Functions, Packages, Ref Cursors, Constraints, Database Links, UTL file and Triggers, views, Join for Oracle Relational Databases.
• Strong experience in developing SQL/PLSQL Scripts/Programs for Data Analysis, Extraction, Transformation and Loading (ETL) mechanism
• Proficient in the Data Manipulation using SQL for the retrieval of data from the Relational Database (inner joins, outer join, group by, order by, cursors etc.).
• Extensive development experience in data designing, mapping, Loading data, Testing and Tuning databases.
• Hands on experience in working with advanced PL/SQL concepts such as Collections, Objects, records, Native dynamic SQL.
• Extensive experience in Performance Tuning of SQL queries & Views using Explain Plan.
• Proficiency in Microsoft Business Intelligence technologies like MS SQL Server Integration Services (SSIS).
• Experience in integration of various data sources like SQL Server, Oracle, DB2 and Flat File, Excel File.
• Highly proficient in packages to extract, transform and load data (ETL) using (SSIS), designed packages which are utilized for tasks and transformations Data Conversion and Pivot tables.
• Extensive experience in working with standard Microsoft software applications like Word, Excel, Microsoft Project, PowerPoint and Visio.
• Good Knowledge in data extraction, transmission and loading.
• Possessing good knowledge in ETL Informatica Architecture about Nodes, Domain & Services. Also, working experience with Admin Console.
• Well - versed with ETL Informatica performance tuning process involving bottleneck identifications, analyzing thread statistics, optimizing components and using parallel partitions.
• Experience in installing and upgrading Power Center software. Possessing good knowledge in Admin console and ETL Informatica Architecture.
• Strong analytical skills with ability to quickly understand clients’ business needs and identify available data sources and the relationships that exist within them.
• Experience in Oracle Apps 11i GL, AP, AR, OM modules.
• Experience in Production Support and the ability to provide time-bound and quality driven solutions have cultivated decision-making and analytical ability.
• Knowledge in designing and developing Web based Applications using J2EE technologies like Java, Servlets, Jsp, JavaBeans, HTML, JavaScript, CSS, JDBC, XML, Struts, JUnit and web services.
• Good knowledge in using Teradata utilities (SQL, B-TEQ, Fast Load, Multiload, Fast Export, Tpump, Visual Explain).
• Ability to learn and adapt quickly in a dynamic environment and Ability to work on multiple projects against aggressive deadlines.
• Excellent Communication, Writing, Presentation, Workforce Management, Interpersonal and Analytical skills, along with the ability to work on multiple projects and prioritize workload
• Self-starter can work independently as well as a good team player.

TECHNICAL SKILLS:

Databases: Oracle 11g/10g/9i, SQL Server 2008

ETL Tools: Informatica power center 9.x/8.x

DB Utilities: SQL*Plus, SQL*Loader

RAD tools: Oracle Reports 6i, WinScp, and FTP etc

Languages: SQL, PL/SQL, C, Java.

Version Control tools: PVCS, IBM Rational Synergy 7.1

Operating Systems: Windows7/Vista/XP/UNIX (Sun Solaris, HP-UX)

Developer Tools: Reports 10g, TOAD 10.6, 10.1, 9.6.1, 8.5, 8.1, Eclipse IDE

Web Technologies: HTML, XML Publisher

PROFESSIONAL EXPERIENCE:

Confidential, New York

Sr PL/SQL Developer

Responsibilities:

• Worked with Designers and developers to translate data requirements into the physical schema definitions for oracle.
• Developed many complex PL/SQL programs and modified the existing PL/SQL program units.
• Developed several stored procedures and functions using advanced oracle concepts such as Bulk Binds, Bulk Collects to improve performance.
• Developed SQL scripts, packages and procedures for Business rules check to implement business rules.
• Experience in working with utilities like SQL*Loader, External Tables, Import, Export to extract and load large volume of data.
• Created the tables and sequences for the experimental data load capture.
• Wrote Packages to store the business rules and exceptions and wrote PL/SQL code to load data from the flat file to the tables.
• Involved in data migration from Production to test and created test data for analyzing problems, providing solution.
• Modified the queries by using less functions in the Where condition for reduction of time for Performance issues.
• Worked closely with front-end engineer to design and tweak RESTFUL API used by the frontend.
• Written complex Oracle SQL queries with complexity using Inner/Outer joins, Indexes, Sequences, Union All, Intersect & Minus set operators.
• Rich experience in writing SQL queries, Anonymous blocks, Views, Materialized views, PL/SQL procedures, functions, packages, triggers, cursors, collections, Ref cursor, cursor variables, System reference cursor, Dynamic SQL.
• Created materialized view on remote database and automated scheduler of refreshing of materialized view on source side.
• Experience in query optimization, performance and tuning (PL/SQL) using SQL Trace,
• Created Stored Procedures for Batch Processing and involved in moving large data using Bulk Insert for all methods.
• High End-Client Interactions for solving User Acceptance Testing (UAT) issues.
• Automated Quality Check tasks by creating PL/SQL procedures, cursors, functions and dynamic SQL Enhanced it with creating exceptions for error handling.
• Performed constant monitoring and performance tuning of oracle database, checking the most expensive queries.
• Developed scripts using UNIX commands to perform complex file processing.
• Involved in the creation and modification of Packages and Triggers.
• Extensively worked using autonomous transaction and triggers to keep the track of DML operations (insertion, updating and deletion).
• Extensively used the oracle exception handling techniques for implementing all types of exceptions to process errors.
• Tuned the SQL queries and complex Procedures to improve performance.
• Extensively worked with third party database tools like SQL Developer & PL/SQL Developer.

Environment: Oracle 11g, PL/SQL Developer, SQL Developer, SQL*Loader, Windows 8/Windows 10, UNIX, Eclipse IDE

Confidential, NY

Sr. Oracle Developer

Responsibilities:

• Generated DDL scripts and created and modified database objects like Tables, Views, Sequences, Functions, Procedures, Indexes, Packages, Records and Collections using TOAD.
• Involved in performance tuning using Oracle Hints and Explain Plan for existing Views and Queries.
• Improved the performance of Materialized View Refresh from 4 hrs to 25 min using WITH clause/MATERIALIZE HINT, Indexes and Bulk Processing.
• Provide quality operations support for production environment. Work with QA and provide support to provide timely technical resolutions for defects.
• Gathered the business requirement from clients and translated the business details into technical requirements.
• Enhanced a module's performance in a preexisting product by 2800% faster (reducing runtime from 16 hours to 40 mins) adopting a more efficient data accessing path than the old one.
• Used Bind Variables while writing Dynamic SQL to improve performance.
• AUTONOMOUS TRANSACTION PRAGMA is used in the procedures to log the status when error occurs.
• Created relevant staging tables to load data, identified the business validation rules. Created SQL Loader scripts using UNIX shell scripting and PL/SQL
• Tuned sql queries based on recommendations from OEM. Sql tuning performed with the help of AWR reports.
• Monitored the Applications and database using OEM and OAM.
• Build several Unix Shell scripts for PLSQL programs to schedule them on Control M
• Involved in the LOGICAL & PHYSICAL DATA MODELING of the CSPORTAL application.
• Involved in performance tuning using HINTS, EXPLAIN PLAN.
• Involved in writing complex SQL Queries to implement the business requirements.
• Used SQL* Loader and UTL FILE Packages for data conversions and interfaces.
• Used packages to extract, transform and load data (ETL) using Informatica, designed packages which are utilized for tasks and transformations Data Conversion and Pivot tables.
• Expertise in handling System Analysis and Business Analysis related issues when the application is in earlier stages.
• Involved in client interaction, handling change requests and implementing the application on the client side.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained the batch processes using Unix Shell Scripts.
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data.
• Coordinated with the business analysts for requirements analysis.
• Used techniques like direct path load, external tables for loading the data faster.
• Developed technical design documents by reviewing functional requirement documents in an agile environment.
• Involved in preparing the test scenarios and performed unit tests on PL/SQL programs.
• Involved in creating various utility scripts to generate log files in UNIX using shell scripts

Environment: Oracle 10g/11g, TOAD 12.6, SQL*Loader, Windows Server 2008/Windows 7, UNIX, IBM Rational Synergy 7.1, Eclipse IDE

Confidential, MD

Sr. Oracle Developer

Responsibilities:

• Develop SQL* Loader scripts for data extraction and transformation.
• Extensive use of Collections like Index By Tables and nested tables.
• Used PLSQL to Extract Transform and Load (ETL) the data into Data Warehouse and Developed PL/SQL scripts in accordance with the necessary Business rules and procedures.
• Developed control files for SQL* Loader and PL/SQL scripts for Data Extraction/Transformation/Loading (ETL) and loading data into interface Tables (Staging area) from different source systems and validating the data.
• Designed and developed several complex database procedures, packages. Extensively used features like Cursors, autonomous transactions, distributed transactions, exception handling, Dynamic, pl/sql tables, bulk load methods, optimizer Hints, Cursor variables and returning of multi record set from procedures and functions
• Validating extracted data from Legacy system.
• Developed various Informatica workflows to load the Transactional data and Reference data for various products.
• Created various Informatica mappings to validate the transactional data against Business rules, extract look up values and enrich the data as per the mapping documents.
• Developed various Informatica Workflows to load the data from various upstream systems using different methodologies i.e. trigger based pull, direct pull & file-based push.
• Developed stored procedures / packages to run ETL jobs to extract customer information from OLTP database into data warehouse.
• Involved in the LOGICAL & PHYSICAL DATA MODELING of the PAYPAL application.
• Partitioned Tables using Range Partitioning, List Partitioning and created local indexes to increase the performance and to make the database objects more manageable
• Used Bulk collect and For-all-in stored procedures to improve the performance and make the application to run faster.
• Tuned SQL queries based on recommendations from OEM.
• Implemented Data ingestion process using UNIX Korn shell scripts resolved application issues in UNIX production environment. Read and interpreted UNIX logs
• Implemented various UNIX scripts to generate the data in CSV and txt format
• Wrote custom support modules for implementation using PL/SQL, Unix Shell Scripts
• Worked on logical and physical data modeling and created Materialized views.
• Create Implementation plans and deploy applications to QA and Production environments.
• Actively interacted with product owners for requirement clarification ensuing risk mitigation.
• Worked in collaboration with QA team in creating and validating the Test Cases.
• Assist ADM and product owner in implementing AGILE within the team.

Environment: Oracle 10g/11gTOAD 10.1, TOAD DATA MODELER 3.4, SQL*Loader, Windows Server 2008/Windows 7, HP-UX

Confidential, PA

Oracle Developer

Responsibilities:

• Wrote SQL, PLSQL, SQL*Plus programs required to retrieve the selected data from the Data repository using cursors and exception handling.
• Used PLSQL to Extract Transform and Load (ETL) the data into Data Warehouse and Developed PL/SQL scripts in accordance with the necessary Business rules and procedures.
• Before ETL, Involved in Data Analysis, Data Design, Data Integration and Data Mapping.
• After ETL, Involved in Data Validation, Data Performance in loading target table and for reporting purpose.
• Developed control files for SQL* Loader and PL/SQL scripts for Data Extraction/Transformation/Loading (ETL) and loading data into interface Tables (Staging area) from different source systems and validating the data.
• Developed various complex Informatica workflows to perform ETL operations.
• Worked with XSD and XML files (sources & targets) to read & parse the data and load into the target DB.
• Enhanced the performance the Informatica Workflows by optimizing the Look-up caches and implementing push-down optimization.
• Designed the architecture for the error handling mechanism of the transactional data.
• Developed various Mappings to load data from various sources using different Transformations.
• Extracted data from different sources like Oracle, Flat files, External files and transformed the data based on Business requirements and loading into Oracle target database.
• Created and modified database objects such as Tables, Views, Materialized views,
• Indexes, Sequences and constraints, SQL queries (Sub queries and Join conditions).
• Used Bulk Collect, Bulk Insert, Update functions in the ETL Programs.
• Created and used Table Partitions to further improve the performance while using tables containing large number of columns and rows.
• Extensive use of Oracle External Tables which is used to load the flat files (Essbase Extract) into Oracle Database.
• Implemented various automated UNIX shell scripts to invoke PL/SQL anonymous blocks, Stored Procedures/Functions/Packages using SQL PLUS session in silent mode.
• Extensively involved in performance tuning using Explain Plan, DBMS PROFILER and Optimized SQL queries, created Materialized views for better performance.
• Over 80 objects are analyzed to ensure modifying existing structure will not create potentially unwanted behavior to downstream processes.
• Involved in creating various utility scripts to generate log files in UNIX using shell scripts
• Documented the PL/SQL packages, log files, locations and descriptions, log tables and possible error codes and message descriptions
• Developed UNIX Scripts for the calling of Packages, and SQL loader jobs
• Detected and corrected bugs during system integration and user acceptance testing using agile methodologies.

Environment: Oracle 9i, SQL*Plus, TOAD 10.1, SQL*Loader, Windows Server 2003, HP-UX

Confidential

Responsibilities:

• Involved in design and development of the database design.
• Involved in Bulk loading of data from non-Oracle data sources using SQL * Loader.
• Participated in system analysis, data modeling and database designing which included creating tables, views, indexes, synonyms, triggers, procedures and packages.
• Developed Shell and PL/SQL scripting for regular maintenance and production support to load the data in regular intervals.
• Wrote complex SQL scripts using joins, sub queries and correlated sub queries.
• Involved in the design, development, testing and maintenance.
• Troubleshot production problems and worked effectively with other team members to identify and address problems.
• Provided input into project plans for database projects providing timelines and resources required. Involved in SQL tuning using SQL-Trace, Explain plan utilities.
• Responsible writing UNIX Shell scripts.

Environment: Oracle 9i, SQL*Loader, PL/SQL, Toad, UNIX Shell Scripting.