SUMMARY

• Having 6+ years of experience in programming as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Experienced in all stages of System Development Life Cycle (SDLC): analysis, design, coding, testing, UAT and post production support.
• Implementation and technical expertise in Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• Good Knowledge on Client - Server application development using Oracle PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
• Extensive Experience in Customization of forms and reports and development of Conversions, Interfaces.
• Expertise in creating and modifying database objects like Tables, Indexes, Views, Triggers, Sequences, and Materialized views using SQL and PL/SQL.
• In depth knowledge and experience in features like Bulk Collect, Merge, Case and PL/SQL supplied packages.
• Extensive experience in SQL, PL/SQL, Developer 2000(Forms 6i/9i/10g, Reports6i/10g), PowerShell Scripts, SQL* Loader, XML Publisher and Oracle 8.x/9.x/10g.
• Proven track record meeting with management and executives as the subject matter expert in SOA.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Expert in integrating the SSRS reports into web applications using Report viewer control, URL methods and creating data driven subscriptions to different users using Report Manager. Used TFS for version control and project tracking.
• Transferred and retrieved data to and from FTP Servers to Oracle Database.
• Extensive experience in writing stored procedures, triggers and very strong in PL/SQL.
• Having good Experience materialized views for data replication in distributed environments.
• Expertise in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables and Dynamic SQL, Collections and Exception handling.
• Extensive experience in developing SQL scripts to validate the databases tables and reports data for backend database testing.
• Extensive experience in Performance Tuning of SQL queries & Views using Explain Plan, SQL Trace and TKPROF utilities
• Expertise in developing PL/SQL Stored Procedures, Packages, Functions, Triggers, Indexes, PowerShell scripting, Performance Tuning.
• Experience in preparing data for prepared test cases.
• Implemented SQL*Loader to load data into tables and also used Dbms Utility package.
• Experienced in Performance Tuning and analyzing using TKPROF, SQL Trace, and Explain Plan.
• Performed unit testing, system testing and UAT testing.
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Excellent Knowledge in analyzing Data ware house by building cubes using SQL Server Analysis Services (SSAS).
• Experienced in Oracle Supplied Packages such as DBMS SQL, DBMS JOB and UTL FILE.
• Expert knowledge in creating Test Cases, Test Scenarios to test all the business requirements.
• Supported functional data warehouse projects.

TECHNICAL SKILLS

Microsoft Technologies: C#, VB.NET, ASP.NET,ADO.NET, T-SQL

Web Technologies: HTML, CSS, JavaScript

RDBMS Technologies: MS SQL Server 2005/2008/2012, SSIS, Datawarehouse

Code Repositories: TFS and SVN

Reporting Tools: SSRS

Methodologies: Waterfall, Agile

Other tools: MS Office, MS Visio, MS Project, Power Point

Operating Systems: Windows Server, Windows 7, Windows 8,Windows XP/VISTA, Visual studio 2005, 2008

PROFESSIONAL EXPERIENCE

Confidential - Raleigh, NC

PL SQL Developer

Responsibilities:

• Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.
• Involved in designing ER diagram using VISIO, to set the logical and physical relationships of database.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Worked on Oracle partitioned tables and queries.
• Loaded the data into database tables using SQL*loader from text and excel files.
• Developed data model, SQL Coding, SQL Query tuning process and Schemas.
• Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.
• Used Bulk Collections, Indexes, and Materialized Views to improve the query executions.
• Created scheduled and schedule now reports.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system to SQL server.
• Wrote C++ scripts for Unit tester.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
• Creating and enhancing daily, monthly, yearly jobs using UNIX shell Scripting.
• Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
• Developed and customized number of reports using Oracle Reports and Forms.
• Used Oracle JDeveloper Database tools to write triggers and procedures, Function.
• Created materialized views.
• Performed SQL and PL/SQL Performance tuning and Application Tuning using various tools like TKPROF.
• Used Bash script for database connectivity using DBI which connects to backend database drivers.
• Developed UNIX Shell scripts to run various utilities & wrote UNIX Cron jobs for the scheduled batch processes.
• Created Shell Scripts and used Crontab in UNIX environment for scheduling routine tasks.
• Implemented High availability using Golden Gate Replication.
• Used Toad for creating PL/SQL (trigger, sequence, stored procedure).

Environment: Oracle 11g, SQL, PL/SQL, TOAD, UNIX, Forms and Reports 11g, MS Windows 7, VISIO, Golden Gate, Informatica Power Centre.

Confidential - Raleigh, NC

PL SQL Developer/Production Support

Responsibilities:

• Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
• Involved in development, maintenance of Triggers, Joins, Cursors and Views.
• Developed procedures, functions and packages to implements the system's business logic using PL/SQL.
• Created new database objects like Procedures, Functions, Triggers, Indexes and Views in Development and Production environment in PL/SQL and SQL*Plus.
• Involved in maintaining and writing several PL/SQL Stored procedures and SQL queries for populating the daily and historical tables.
• Created Shell scripts to access data and setup runtime environment, and to run Oracle Stored Procedures, Packages.
• Developed UNIX Shell Scripts, customized and developed Oracle Forms and Oracle Reports using Oracle Forms 9i/10g and Reports 9i/10g.
• Optimized the performance using PL/SQL table types and record types.
• Involved in SQL and PL/SQL programming for ODI and oracle.
• Played a key role in designing the dimensional modeling of star schema for the enterprise data ware house of ODS.
• Participate in upgrading Oracle database (s) and Oracle Warehouse Builder to Version 11.2.0.4
• Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Review data transformation rules and provide technical suggestions in data transformation logic and pseudo code (PL/SQL)
• Built custom forms using Oracle Forms 9i/10g Builder to fulfill the business requirements of the client.
• Wrote SQL queries to develope test data for use during test execution.
• Perform Inbound Interface by creating Temporary tables, then Validate data and then Load into Interface Tables by using SQL Loader.

Environment: Oracle 10g / 11g/12c, SQL, PL/SQL, SQL*PLUS, SQL*Loader, Oracle Forms 9i/10g, Reports 9i/10g, TOAD, UNIX, Shell scripting, HP PPM, Oracle Warehouse Builder 11.2.0.2.

Confidential

PL SQL Developer/Production Support

Responsibilities:

• Developed new features and maintained database being used in different business units for different functions
• Participated in Interacting with Team and Analysis, Design and Development of database using ER Diagram, normalization and relational database principles.
• Developed SQL Server Stored Procedures, Tuned SQL Queries using Indexes and Execution Plan.
• Developed User Defined Functions and created Views
• Created Triggers to maintain the Referential Integrity.
• Prepare detailed statistical reports in MS Excel to track progress of weekly, monthly and quarterly customers and sales growth.
• Reviewed existing business procedures and recommended and implemented changes.
• Tuned and Optimized SQL Queries using Execution Plan and Profiler
• Rebuilt Indexes and Tables as part of Performance Tuning of database
• Responsible for coding and naming standards of the objects and program code.
• Extensive experience with T-SQL, Functions, Views, Created complicated SQL procedures to meet the requirements of the systems being developed.
• Automated the sql using BI Reporting tool Crystal Reports and scheduled them as required by Business users.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Assigning/Training Team with new enhancements during Production or GO-Live phases.
• Provided Training/Knowledge transition(KT's)
• Deploy the code in various environments.

Environment: C#, ASP.NET 3.5, HTML, CSS, JavaScript, Microsoft Visio, Visual Studio 2008/2010, DB2, SQL Server 2005, Windows Server 2008.

Confidential

PL SQL Developer/Production Support

Responsibilities:

• Created and modified Database objects like Tables, Stored Procedures, Views, Triggers and Packages etc.
• High degree of proficiency in gathering user specifications from business users and preparing detailed Business Requirement Documents (BRD's).
• Tuning queries in SQL. Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Extensively used bulk collection in PL/SQL objects for improving the performance.
• Communicate with Client effectively.
• Optimize the SQL statements, PL/SQL programs.
• Participated/Guided UAT's during releases and migrating them from Dev-QA-Production before GO-Live phase.
• Involved in full development cycle of planning, Analysis, Design, Development, Testing and Implementation.
• Preparing the Analysis document for the defects and defect fix.
• Responsible for coding and naming standards of the objects and program code.
• Extensive experience with T-SQL, Functions, Views, Created complicated SQL procedures to meet the requirements of the systems being developed.
• Automated the sql using BI Reporting tool Crystal Reports and scheduled them as required by Business users.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Assigning/Training Team with new enhancements during Production or GO-Live phases.
• Provided Training/Knowledge transition(KT's)
• Deploy the code in various environments.

Environment: SQL, PL/SQL, UNIX, Oracle 11g database, PL/SQL, OLTP, Crystal Reports

Confidential

PL SQL Developer

Responsibilities:

• Worked with various functional experts to implement their functional knowledge into working procedures.
• Developed application and database triggers, functions, procedures, and packages in PL/SQL, Oracle11g as back-end.
• Creation of database objects like tables, views, procedures, packages using Oracle tools like SQL Loader, SQL* Plus and PL/SQL.
• Created various SQL and PL/SQL scripts for verification of the required functionalities.
• Created Records, Tables, Objects, Collections (Nested Tables and Varrays), Table Partitioning and Error Handling.
• Worked on optimizing existing procedures and functions using PL/SQL.
• Worked on User Exit, Dynamic SQL and PL/SQL block in PL/SQL.
• Created various Database triggers using PL/SQL.
• Have converted old data from Flat files to Oracle database Using SQL * Loader
• Developed screens and reports using Oracle Forms 10g/Reports 10g
• Designed and developed user interfaces for customers using Oracle 9i/10g Forms Builder.
• Wrote various kinds of SQL queries involving Correlated Sub queries, UNION, Inner and Outer Joins
• Developed UNIX Shell Scripts and PLSQL procedures to import and export data.
• Worked on XML along with PL/SQL to develop and modify web forms.
• Performed performance tuning for queries on highly transactional OLTP datadase systems.
• Designed ETL Jobs using SAP BOBJ Data Integrator.
• Provided On-Call support for OLTP as well OLAP RDBMS and other maintenance jobs.

Environment: SQL, PL/SQL, UNIX Shell Scripting, Oracle 10g/11g, Toad, SQL*Plus, SQL*Loader, PUTTY, MS Office, Windows XP, Oracle Reports 10g, Oracle Forms 10g.