SUMMARY

• More than 7 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design, and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Experience with Data flow diagrams, Data dictionary and Database normalization theory techniques, Entity relation modeling and design techniques.
• Experience in Client - Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD, SQL*LOADER.
• Good knowledge in front end development using oracle forms/reports6i/9i/10g.
• Experience in creating master detail forms and adding alerts.
• Experience in deploying forms and reports on the web.
• Experience in developing forms based on views, tables and procedures in tabular and form layouts.
• Experience in developing both web layout and paper lay out reports in various styles based on the user requirements.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Experience in Oracle supplied packages, Dynamic SQL, Records, PL/SQL Tables and Exception Handling.
• Expert knowledge in dimensional modeling, Star Schema modeling, Snowflake modeling, fact and dimension table design, physical and logical Data modeling using oracle SQL developer data modeler 4.1.1 or ERWIN 3.x/4.x
• Experience with Oracle Supplied Packages such as DBMS SQL, DBMS JOB, UTL FILE, DBMS SCHEDULER, DBMS STATS.
• Good experience on scheduling, inserting, updating jobs using. JIL file with
• CA Workload Automation AE (AutoSys Edition) r11.3.
• Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
• Worked extensively on Ref Cursor, External Tables, and Collections.
• Experience in performance tuning and Query optimization using Explain Plan, TKPROF, HINTS and SQL Trace utilities.
• Experience in SQL performance tuning using Cost-Based Optimization (CBO).
• Good knowledge of key Oracle performance related features, such as Query Optimizer, Execution Plans and Indexes, for faster execution.
• Good knowledge on Oracle cluster aware cache Coherence and Oracle in memory database Times Ten.
• Strong Experience in Extract, Transform & loading (ETL) data in Applications & Develop Data models using Star Schema & Snow Flake Schema’s.
• Good experience with data intensive applications with 100 or more queries per second which demands sub second response times.
• Good knowledge on capacity planning and assessment for huge DB applications which includes Server Hardware Capacity, Network Assessment and File System Assessment.
• Experienced in UNIX shell Scripting.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

TECHNICAL SKILLS

Operating Systems: Windows 8/7/XP/2000, Linux, UNIX, OS X

Languages: SQL, PL/SQL, C, C++, Pro*C

Scripting Languages: UNIX shell scripting

GUI’s Technologies: Developer Suite 10g/6i (Forms, Reports), Crystal Reports 9/10, Erwin, Oracle SQL Developer Data modeler, Erwin 4.x/3.x

Databases: Oracle 12c/11g/10g/9i/8i, Oracle Times Ten, SQL server 2012/2008, Oracle XML DB, MS Access

SCM tools: JIRA, Confluence (Atlassian), ClearQuest

BI Tools: SAP Business objects, OBIEE

Utilities: SQL* Plus, SQL* Loader, SQL Navigator, SQL Developer, Toad, ETL tools Informatica Power Center

Scheduling Tools: Autosys, Control-M, Crontab

Packages: Micro Soft Office Suite- MS-Word, MS-Excel, MS-Power point, MS-Outlook, MS-Access

PROFESSIONAL EXPERIENCE

Confidential, IRVING, TX

Oracle PL/SQL Developer

Responsibilities:

• Direct interaction with the IT and Business teams for requirements gathering.
• Design and Code Reviews or any other deliverables prepared by the team members.
• Preparation of effort estimation for various tasks taken up.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Strong Experience in Extract, Transform & loading data in Applications & Develop Data models using Star Schema & Snow Flake Schema’s.
• Worked on SQL*Loader to perform bulk data loads into database tables from external data files.
• Designed and developed Oracle PL/SQL Procedures, Functions, and Database Triggers and involved in creating and updating SQL Packages to meet business requirements.
• Created UNIX shell scripts to automate data loading, extraction and to perform regular updates to database tables to keep in sync with the incoming data from other sources
• Created Materialized Views for extracting the data from remote database.
• Wrote complex SQL queries to extract data from various source tables of data warehouse.
• Created various Function Based Indexes to improve performance significantly.
• Good experience in physical and logical Data modeling using oracle SQL developer data modeler 4.1.1.
• Extensively worked with JIRA for tracking bugs, issues tracking and project management functions.
• Experience in creating master detail forms and adding alerts.
• Experience in deploying forms and reports on the web.
• Experience in developing forms based on views, tables and procedures in tabular and form layouts.
• Creating test cases for System Testing (Development Environment), Integration Testing (UAT) and Production (Post Implementation Review).
• Good knowledge on Oracle Times Ten in memory database.
• Involved in Creation of tables, Join conditions, Correlated sub queries, Nested Queries, Views for Business Application Development.
• Extensively used Collections with bulk bind to insert and update millions of rows into target
• Extensively used advanced features of PL/SQL like Ref Cursors, Collections (Nested tables and Varrays) and Dynamic SQL.
• Used Oracle packages like DBMS STATS to collect statistics of many different kinds as an aid to improve the performance and UTL FILE to read and write operating system text files.
• Worked on Exception handling, to trouble-shoot PL/SQL code and to display the error messages in the application.
• Used Explain Plan, SQL*TRACE, TKPROF for tuning the SQL statements by creating indexes.
• Supported the testing team with Defect Management, Requirement Analysis and SQL development for back-end and regression testing.
• Created List reports, cross tab reports, charts, sectional reports, & Drill through reports by using Cognos Report studio.
• Involved with business and functional people to collect and gather requirements
• Implemented Mock report layouts before the actual report implementation.
• Creating value prompts, Date & time prompts, Text box prompts, cascading prompts
• Hide and Show the objects by using conditional blocks
• Handled Production issues and manage the same in issue log.
• Involved in design meetings with Mainframe team, IBM MQ team, SOA Web service (service Oriented Architecture) team and Application DEV teams along with DB team.
• Involved in design SIGN OFF meetings with Architecture team and implemented the suggestions as per the meeting minutes.

Environment: Oracle 11g/12c, oracle Forms 11g/10g, Oracle PL/SQL, SQL Developer 4.x, TOAD 9.1/10.5, WINSCP FTP tool, SQL loader, Pro*c, Oracle Times Ten, Autosys Job Scheduler r11.3, Oracle SQL developer Data Modeler 4.1.1.

Confidential, Austin, TX

Oracle PL/SQL Developer

Responsibilities:

• Rigorous technical analysis using Oracle’s 10g (upgrading to 11g) features for providing better solutions.
• Preparation of wrapper scripts for all the database processes and data quality checks using Unix Shell scripting.
• Extensive usage of Oracle External Table Concept to extract Data from feed File sent to FTP feed file location.
• Monitoring the schedules and timely escalations to the project management and client in case of any slippages.
• Extensively involved in using HINTS to direct the optimizer to choose an optimum query execution plan.
• Planned, led and oversaw all release activities from defining design strategies, data policy, transformation rules and coding standards.
• Experience in deploying forms and reports on the web.
• Performed unit test on the developed code to ensure that its bug free.
• Experience in developing forms based on views, tables and procedures in tabular and form layouts.
• Experience in developing both web layout and paper lay out reports in various styles based on the user requirements.
• Wrote custom support modules for upgrade implementation usingPl/Sql, Unix Shell Scripts,Pro*C.
• Solid experience of creating PL/SQL Packages, Procedures, Functions, Triggers and Materialized Views to retrieve, manipulate and migrate complex data sets in Oracle Databases.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions.
• Used Advanced Explicit Cursors Concepts like FOR UPDATE, WHERE CURRENT OF Clause.
• Involved in GO-LIVE zones and provided support through ON-CALL sessions.
• Created Tables, Views, Sequences, Constraints, Indexes (B* Tree, Bitmap and Function Based).
• Performed unit test on the developed code to ensure that its bug free.
• Used Pragma Autonomous Transaction to avoid mutating problem in database triggers.
• Developed test plan documents for all back end database modules.
• Good knowledge of using Control-M Scheduler.
• Experience in SQL performance tuning using Cost-Based Optimization (CBO).
• Good knowledge of key Oracle performance related features, such as Query Optimizer, Execution Plans and Indexes, for faster execution
• Maintained a series of UNIX shell scripts to manage batch order processing.
• Involved with Application Development team to implement Proof of Concept on Oracle Times Ten.
• Involved and helped application development teams to implement load tests to asses load on APPLICATION layer and DB layer and noticed the performance bottlenecks on DB side and provided fixes as per need.

Environment: Oracle 11g, Oracle Forms 11g/10g, Oracle PL/SQL developer, TOAD 9.1/10.5, VI editor, FileZilla FTP tool, SQL loader, Oracle Times Ten, Proc*C, Control-M Scheduler, Solaris 10.

Confidential, Albany, NY

Oracle PL/SQL Developer

Responsibilities:

• Analyzed and overviewed the database design for better understanding the relations, associations and dependencies within the database.
• Discussed and analyzed business functionality with the client and the developers.
• Generated SQL and PL/SQL scripts to install create and drop database objects including Tables, Views, Primary Keys, Indexes, Constraints, Sequences and Synonyms.
• Developed and modified PL/SQL packages, procedures, functions as per customer requirement to make new enhancements or resolve problems.
• Wrote complex SQL queries to retrieve information from the databases depending on user requirement.
• Good Understanding of OLAP Functions.
• Created PL/SQL program units to implement DML, DDL statements using Dynamic SQL.
• Used theMergestatement to select rows from one or more sources for update and insertion into one or more tables.
• Created triggers to automatically populate different tables and also to restrict the data being inserted to the tables.
• Good working knowledge on Oracle Forms and Reports 11g/10g.
• Created Bitmap Indexes on low cardinality columns as they result in reduced response time for queries and substantial reduction of storage space.
• Wrote control files and loaded the data into the Oracle database with SQL Loader.
• Used PL/SQL Developer Tool to do the backend development.
• Wrote complex Oracle SQL using joins, sub queries and correlated sub queries.
• Implemented Materialized View for extracting the data from remote database.
• Handled various Exceptions to trouble-shoot PL/SQL code.
• Used PL/SQL Collections (Nested Tables and Varrays) in complex backend packages.
• Coded UNIX shell scripts to call SQL scripts and to manipulate the returned data.
• Extensively worked on Explain Plans and various hints for Performance tuning.
• Involved with various teams in design meetings and coordinated with MQ team, MAINFRAME team and Application development teams about DB schema design and changes as per release plan.
• Involved and helped application development team for POC on Oracle Coherence.

Environment: Oracle 10g/11g, oracle Forms 10g, Pro*C, Solaris 10, Windows XP, SQL, PL/SQL, SQL*Loader, PL/SQL Developer, TOAD, OpCon batch job scheduler.

Confidential, Parsippany, NJ

Oracle Developer

Responsibilities:

• Created the Object Relational Database Tables with all the necessary Constraints.
• Direct interaction with the IT and Business teams for implementation of CDW and Developing the Data warehouse with multiple customizations pertaining to each country.
• Developed back end interfaces using PL/SQL Packages, Stored Procedures, Collections and Triggers.
• Used All Control Structures like IF, CASE, For, While Loops for standard PL/SQL programming.
• Created PL/SQL program units to include DML, DDL statements using Dynamic SQL.
• Created and managed primary data base objects such as Tables, Views, Sequences, and Synonyms.
• Involved in optimizing database performance by analyzing database objects, creating indexes, creating materialized views etc.
• Loaded data from flat files to temporary tables in Oracle database using SQL*Loader, Collections for better performance.
• Worked in Maintenance of the system and debugging of the code whenever necessary.
• Used Exception Handling for validation of input and displaying the error messages in the application.
• Used Explain plan, TKPROF to gather the statistics along with analyze command for performance tuning.
• Extensively used UNIX shell Scripting to call the procedures and functions.
• Tested, Installed, Documented and provided On Call Support for the Applications.
• Created test data and performed various tests in load test environment to gauge the DB performance.

Environment: PL/SQL, Red Hat Enterprise Linux 6, SQL, SQL*Plus, SQL DEVELOPER, SQL*Loader, Oracle 10g, Windows XP.

Confidential, Moosic, PA

Oracle PL/SQL Developer

Responsibilities:

• Interacted with the end users for gathering of requirements and analyzed them.
• Worked with the development team to design, develop, test and implement the system.
• Developed ER Diagrams, Data flow diagrams based on the requirement.
• Created prototype reporting models, specifications, diagrams and charts to provide direction to system programmers.
• Developed Model Diagrams and Input/output structures for the data entry screens.
• Used efficient Joins, Indexes and Correlated queries for Query optimization.
• Developed Control files, SQL*Loader scripts, Oracle import and export scripts for data loading, migration and backup of Oracle data.
• Extensively used PL/SQL to implement cursors, triggers and packages and to develop stored procedures, functions.
• Implemented Record Insert, Record update and also used Insert All to load the data into multiple tables.
• Created the Shell scripts to automate the execution of the PL/SQL subprograms and to move the data to store in historical folders.
• Used Collections like varrays, nested tables extensively.
• Involved in programming, debugging, and unit and system integration testing of modules.
• Used SQL trace facility and TKPROF along with Explain Plan to accurately assess the efficiency of the SQL statements when the application runs.

Environment: Oracle9i/10g, Windows XP, PL/SQL, SQL*PLUS, UNIX, SQL*Loader, UML.

Confidential

Oracle Developer

Responsibilities:

• Gathered requirement from the business users, prepared functional specification and design documents.
• Prepared program specification and development of PL/SQL packages, procedures and functions as required by the business users.
• Generated server side PL/SQL scripts for data manipulation and validation.
• Analyzed the existing method for data repository refresh and then developed a new package with tuned queries to improve the performance and reduce the time taken for the refresh.
• Loaded data into oracle database from flat files using SQL*Loader.
• Created Materialized View for extracting the data from the remote databases.
• Wrote PL/SQL procedures to generate DDL scripts that created database objects dynamically based on user inputs.
• Generated and maintained Keys, Constraints and Relationships between the tables for OLTP database.
• Good working knowledge on UNIX Shell Scripting.
• Optimized critical queries to eliminate Full Table Scans, reduce Disk I/O and Sorts.
• Fine Tuned SQL statements for the maximum efficiency in various schemas across databases using Oracle Hints, explain plans and Trace sessions for Cost based and Rule based Optimization.

Environment: Oracle 9i, Windows NT/2000/XP, HTML, SQL*Plus, PL/SQL, SQL*Loader, Toad.

Confidential

Oracle Developer

Responsibilities:

• Gathered the Requirement from the business user and prepared the program specifications.
• Involved in keeping track of Previously-Exported patients and archived them for future reference Purpose.
• Created the PL/SQL packages, procedures, functions applying the business logic to update the Patients' database.
• Created custom triggers to automatically populate different tables and also to restrict the data being inserted to the timesheet tables.
• Design and developed the scripts to create table, views, indexes and sequence.
• Created the custom tables to import the Patient's data and insert into the database tables.
• Developed the SQL*Loader scripts to load data into the staging tables from the flat files.
• Extensively used DTS package in Migration of the data from the previous timesheet database in SQL Server database to Oracle 9i.
• Worked in Maintenance of the system and debugging of the code whenever necessary.
• Used Exception Handling for validation of input and displaying the error messages in the application.
• Extensively involved in tuning the queries and applying hints for faster and better performance of the SQL queries.

Environment: Oracle 9i, SQL Server, PL/SQL, SQL*Plus, SQL*Loader, TOAD 10, FTP, DTS Package, MS- Office, UNIX (Putty), Perl Scripts, MS Office, MS Visio.