SUMMARY

• A competent professional with more than 8 years of extensive experience in developing oracle applications using Oracle 12c/11g/10g/9i/8i and PL/SQL in diverse sectors including Insurance, Pharmaceutical, Banking, Health care and Aeronautical.
• Good Knowledge in Oracle Architecture, Data Dictionary, DBMS Packages and Normalization Techniques.
• Rich Experience in developing PL/SQL Stored Procedures, Functions, Packages, Triggers, Shell - Scripts and SQL Loader Scripts.
• Strong knowledge in Oracle Cursor Management, Collections, Hierarchical Queries and Exception Handling.
• Reduced time for night batch jobs by reviewing PLSQL code and modifying database parameters.
• Experience in application development using various advanced features of Oracle like Bulk Techniques, Table Functions, Autonomous Transactions, Dynamic SQL, Object Types and Records.
• Ability to implement Agile Methodology according to constraints and business needs.
• Expertise in distributed query Performance Tuning by using EXPLAIN PLAN, SQL Trace and TKPROF Utilities, Hints provided by oracle.
• Extensive experience in Data Migration techniques using Oracle External Tables, SQL* Loader, Import/ Export, Bulk and Batch Processing.
• Implemented DBA tasks such as creating users, granting and revoking privileges on database objects and taking backups.
• Good hands on experience in creation of database objects like Tables, Views, materialized views, indexes, Synonyms and Sequences.
• Worked in Client-Server application development using Oracle Forms Builder 11g/10g/6i and Oracle Reports Builder 11g/10g/9i/6i.
• Worked onlayout design, Data models which used Placeholder, Summary, Formula Columns and prepared user manuals for objects developed usingReports and FormsBuilder.
• Worked on Scenario Matrix, Query/ReportAnalysing, Validation and testing various forms built using FormsBuilder.
• Good working knowledge of UNIX and AIX operating systems.
• Expertise in performing Data export, Import and various operations using Toad.
• Extensive experience in Database query tuning, Performance tuning (HINTS, EXPLAIN PLAN).
• Experience on Client-Server application development using Oracle PL/SQL, SQL *PLUS, SQL Developer, TOAD, SQL*LOADER.
• Thorough knowledge of front-end reporting toolsCrystal Report.
• Expert knowledge using Normalization Techniques for database design with Relational technology.
• Experienced in Data Analysis, Data Modeling, Development, Testing and Documentation of projects.
• Involved in Unit Testing and Systems Integration Testing.
• Provided assistance in Logical and Physical Data Modeling using ERWIN.
• Experienced in Dimensional Data Modeling using Star and Snow Flake schema and creating Entity Relationship diagrams and Data Modeling using Toad and Visio.
• Working experience in creating reports based on Tables, Views and Procedures.
• Experience in writing Technical design documents and developing unit test documents.
• Experience in developing Perl and UNIX Shell Scripts.
• Experienced in Extraction, Transformation and Loading (ETL) process using PLSQL and tools like Informatica Power Builder and Oracle Data Integrator.
• Worked on ETL process using PL/SQL to populate the tables in OLTP and OLAP Data Warehouse Environment.
• Extensively worked on Extraction, Transformation and Loading of data from various sources like Oracle, SQL Server using ODI.
• Responsible for all activities related to the development, implementation, administration and support of ETL Processes for large scale data warehouses using Data stage ETL tool.
• Experience of building and maintaining Microsoft Excel Spreadsheets, Pivot tables and Macros.
• Excellent Analytical, Programming and Reporting skills.
• Coordinated with DBAs, QA, Release Management and external team for technical needs and to ensure the timely release of project.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.
• Excellent team player working in various team sizes performing cross-functional roles.
• Highly self-motivated and excellent time management skills. Strong interpersonal and communication skills.

TECHNICAL SKILLS

Databases: Oracle 12c/11g/10g/9i, SQL Server 2005/2008, DB2, Metadata

Languages: SQL, PL/SQL, Pro*C, C/C++, JAVA, .net, T-SQL, XML, UNIX Shell Scripting, Perl Scripting, SQL*Server

Oracle Tools/ GUI: Forms 11g/10g/6i, Reports 11g/10g/9i/6i, Discoverer 4i/10g, Oracle APEX 5.0.1/3.2

Database Tools/ Query Tools: TOAD, PLSQL Developer, SQL*DEVELOPER, SQL*Loader, Oracle SQL*Plus, SQL Navigator, Facets, BI Publisher

Data Modeling Tools: MS Visio, ERWIN, ER Studio, Toad Data Modeler

ETL/ Data ware housing Tools: Oracle Data Integrator, Oracle Warehouse Builder, ODI, Informatica Power Center 8.1/8.6

Reporting Tools: Qlik View 11.2/10.0/9.0 , OBIEE 10

Web Technologies: HTML, HTML5, XML

Other Scripting Tools: Secure Shell, Putty, WINSCP, DOS Prompt

Oracle Utilities: SQL Loader, UTL FILE, TRACE, TKPROF, DBMS Utilities, etc.

Operating Systems: Windows Family, HP Unix, Sun Solaris, Linux

Version Control Systems: Visual Source Safe, IBM Rational Clear Case, AccuRev, SSRS

Ticketing Systems: Service Now, Track Studio, HP Service Center, JIRA

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

Sr. Oracle Developer

Responsibilities:

• Analyze the Business Requirements (BRD) and convert them into Technical Specification (Technical Design Document).
• Extensively developed PL/SQL Packages, Stored procedures, Triggers and finely tuned them for performance. Extensively used PLSQL tables and Bulk loader programs for processing data and loading into oracle tables.
• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Develop ETLs using PL/SQL in Oracle 11g/12c to extract, transform and load data from OLTP into Warehouse.
• Involved in the generation of User Interface using Oracle Forms by extensively creating forms as per the client requirements.
• Proactively tuned SQL queries leading to significant improvement in system response time and efficiency.
• Created Schema Using the XML schema.
• Building UNIX shell scripts for data migration and batch processing.
• Involved in all working on all phases of Software development life cycle (SDLC).
• Taken active part in Analysis, Development & Testing Phases during working with projects.
• Developed user interface Forms, Reports, PL/SQL Packages, Procedures, Functions and Database Triggers to meet the business requirements.
• Generated XML using the Procedures, Functions and Packages.
• Developed and customized existing reports as per client specific requirements using Oracle Reports Builder 10g.
• Used Oracle 11g/12c and Reports 6i designer to create new reports. I am also using these tools to update the existing reports.
• Used Oracle Forms to create new forms and maintain the existing forms.
• Worked with SQL loader, created control file scripts to dump the data in to the mapping tables and process the data accordingly.
• Involved in Database Performance Tuning using Oracle Hints, Explain plan, TKPROF, Partitioning and Indexes.
• Executing XML files in Putty using UNIX commands.
• Tracking logs in Putty using UNIX.
• Wrote generic PL/SQL code modules (PL/SQL Libraries) for Reports to handle data manipulations on client.
• Involved in working with the ODI ETL tool.
• Created and used Table Partitions to further improve the performance while using tables containing large number of columns and rows.
• Designed and implemented client-server application using Oracle Forms Builder.
• Partitioned Tables using Range Partitioning, List Partitioning and created local indexes to increase the performance and to make the database objects more manageable.
• Involved in delivering high performance code using advance concepts like Bulk Collect, Collections, and Dynamic SQL.
• Created and modified several UNIX shell scripts according to the changing needs of the project and client requirements.
• Created multiple UNIX shell scripts to import data into Oracle using the SQL*Loader.
• Created and monitored the Oracle DBMS JOBS as a part of weekly tasks.
• Design, develop, implement, and assist and in validating ETL processes.
• Analyzed and resolved issues with current and planned systems as they relate to the migration and integration of data.
• Created PRO*C programs for Handling Data which comes in flat file and for handling data loads from Windows/Unix environment.
• Supporting the existing and new Data Stage applications in order to smooth functioning of the applications.
• Worked as a module lead and managed roles and responsibilities for testing, defect fixing, applying performance tuning methodologies and migrating ETL components to DIT (Development Independent Testing), SIT (System Independent/Integration Testing), UAT (User Acceptance Testing) and production environment.

Confidential, Orlando, FL

Oracle Developer

Responsibilities:

• Actively involved in interacting with front end users and gathered User Requirement and Online System Specification.
• Created number of database objects like Tables, Views, Indexes, Synonyms and Materialized views using SQL Loader.
• Involved in creating Procedures, Functions, Packages and Triggers to facilitate functionality in different modules.
• Created Data Mapping files for the data coming from different web services.
• Assisted with implementation/upgrade of AutoSys and troubleshoot errors.
• Created many common components of UNIX and Perl Scripts.
• Developed Ad hoc Reports (SQL or PL/SQL scripts running in Unix System) to extract data from database and deliver to user in Excel format.
• Created Audit Tables and implemented complex business logic using triggers.
• Used cursors, for cursors and Ref Cursor (dynamic SQL) for fetching data and processing it.
• Avoided Mutating table errors by using different methods like Pragma Autonomous Transaction, Statement Level Trigger and multiple Triggers.
• Worked onXMLalong with PL/SQL to develop and modify web forms.
• Responsible for problem identification and resolution of failed processes or jobs and assisted customers in troubleshooting issues with their applications in AutoSys.
• Used Bulk processing for better performance and easy retrieval of data, being a part of performance tuning of the procedures and packages.
• Performed Ad Hoc querying/reporting for outbound email marketing, created subscriptions for monthly reports, bulk importing of data and met with stakeholders for requirement gathering that may affect the project.
• Developed UNIX Shell scripts to automate repetitive database processes.
• Used MOD PL/SQL that allows to create Web Applications using Oracle stored procedures.
• Created Crystal Reports with multiple drilldown and sub-reports. Loaded the data into the tables using TOAD and SQL*plus.
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.
• Modified in Perl scripts due to database changes using SQL and Oracle PL/SQL.
• Used SQL *LOADER to load large amounts of data from external files to database.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Monitoring nightly ETL batch flow and resolving the issues and directing it to concerned person.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Designed and developed ETL processes using Data Stage designer to load data from Oracle, MS SQL, Flat Files (Fixed Width) to staging database and from staging to the target Data Warehouse database.
• Worked on requirement analysis, coding and testing various modules in a software development life cycle.
• Developed Unix Shell Scripts to Schedule jobs to automate tasks of loading data into Tables.

Environment: Oracle 11g, PL/SQL, SQL*Plus, SQL*Loader, SQL Developer, UNIX, TOAD, Erwin, Oracle Forms 10g, Crystal reports.

Confidential, Ossining, NY

Oracle Developer

Responsibilities:

• Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.
• Involved in logical modeling and physical modeling of application.
• Designed Technical design document MD070 for the business requirements.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Involved in creation of Conceptual Modeling covering all the business requirements.
• Loaded the data into database tables using SQL*loader from text and excel files.
• Developed data model, SQL Queries, SQL Query tuning process and Schemas.
• Created SQL*plus reports as per client's various needs, and developed business objects.
• Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
• Developed SQL scripts, packages and procedures for Business rules check to implement business rules.
• 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.
• Developed custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 10g and Oracle Forms builder 10g respectively.
• Developed Master Detail, Detail reports using tabular and group above reports.
• Developed Procedures for efficient error handling process by capturing errors into user managed tables.
• Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.
• Worked with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Created some oracle objects for OLAP.
• Used Toad for creating PL/SQL (trigger, sequence, stored procedure).
• Developed Perl scripts for extracting and transferring data from external systems.

Environment: Oracle 11g, SQL, PL/SQL, TOAD 11.5.1.2, ERWIN, ETL, XML, SQL*Loader, SQL*Plus, Oracle Forms & Reports 10g, UNIX, SQL Developer

Confidential, NJ

Oracle Developer

Responsibilities:

• Analysed and overviewed the database design for better understanding the relations, associations and dependencies within the database.
• Analysis of business functionality with the client and the developers.
• Depending on the business requirements, created and modified database objects like Tables, Indexes, Stored Procedures, Materialized Views, Functions, Packages, Triggers and Synonyms to make new enhancements or resolve problems.
• Created various SQL and PL/SQL scripts as required.
• Extensively used Cursors, Ref Cursors and Exceptions in developing Packaged Procedures and Functions. Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Worked on complete SDLC (Software Development Life Cycle) including system analysis, High level design, detailed design, coding and testing.
• Creation of database objects like Tables, Views, Procedures using Oracle tools like SQL*Plus, SQL Developer and TOAD.
• Supported APEX application and conducted performance tuning for SQL.
• Developed several pages in Oracle Apex for the Mortgage banking applications which involved complex business logics and needed customizations.
• Developed various complex queries to generate various reports based on the requirements.
• Used VI editor for PL/SQL scripts and UNIX Shell Scripting for regular maintenance and production support to load the data in regular intervals.
• Performed Performance Tuning using DBMS PROFILER package, this checks the run time behaviour and tunes the PL/SQL programs. Involved in writing Triggers in various levels like Database level, Table level to track information about users (login, logout information).
• Involved in setting up the DBMS JOB package which allows a user to schedule a job to run at a specified time
• Developed screens and Reports using Oracle Forms and Reports.
• Involved in creating Indexes to avoid the need for large-table, full-table scans and disk sorts, and for fast retrieval of data from database objects while generating reports.
• Created Complex Triggers for generating primary key values and for implementing the complex Business logic.
• Involved in Bulk loading of data from non-Oracle data sources, flat files using SQL * Loader.
• Optimized SQL and PL/SQL Query performance using Oracle utilities like Explain Plan, SQL-Trace and TKPROF.
• Worked with Bulk Collects to improve the performance of multi-row queries.

Environment: Oracle 10g, Forms 10, Reports 10g, SQL * Plus, TOAD, SQL*Loader, Teradata, SQL, PL/SQL Developer, UNIX, Linux, Windows XP.

Confidential

Senior Database Developer

Responsibilities:

• Created PL/SQL Stored Procedures, Functions, Triggers and Packages for implementing business logic.
• Extensively used Cursors, User-defined Object Types, Records and Tables in PL/SQL Programming.
• Handling the tickets which comes into the queue based on the priority level. Ping the users in the chat window and confirm from them if they are able to login.
• Developed PL/SQL packages using Indexes, Joins, Bulk Collects and Bulk Variables.
• Developed control files for SQL*Loader and PL/SQL programs to load and validate the data into the Database.
• Solving the issues which users get while working on this production Application server. Also call them and find out the issue they are going on and solve it.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Implemented features including Materialized Views for better performance of summary tables, Autonomous Transactions, Coding Dynamic SQL Statements.
• Involved in SQL Tuning by creation of indexes, rebuilding Indexes using Explain Plan, SQL Trace and TKPROF Tools.
• Created UNIX Shell Scripts for automating the execution process.
• Created Packages, Stored Procedures and Functions to be called by Java modules.
• Designed and Created several Customized Reports using Oracle Reports 10g.
• Designed and developed front-end applications using Oracle Forms 10g.
• Developed Procedures and Triggers for Oracle Forms and Reports.
• Involved in writing complex queries to generate reports as per client requests as part of production support.
• Coordinated with DBA in improving Database Performance.
• Involved in developing test plans and test cases based on high-level and detailed designs.
• Involved in Production Support and troubleshooting data quality and integrity issues.

Environment: Oracle 10g, Toad 9.6.1, Putty 0.62, RCS, SQL*Plus, UNIX, HP QC client, Windows XP.

Confidential

Oracle Developer

Responsibilities:

• Built and maintained SQL scripts, indexes, reports and queries for data analysis and extraction.
• Developed Triggers, Functions, Cursors, Materialized Views.
• Developed new processes to facilitate import and normalization.
• Created and used DB- links to connect to other local and QA databases.
• Developed new functionality in the existing application as part of change requests.
• Worked on Defect Analysis, Bug Fixes and complex enhancement requests.
• Provided hands on support to the users.
• Developed APIs to validate inputs and retrieve data for frontend applications.
• Developed and customized several forms including Tabular, Mailing Label, Matrix and Matrix with groups.
• Developed test scripts for Forms and also involved in functional testing of these Forms.
• Extensively used SQL* LOADER and SQL Scripts to load data fast.
• Worked on Materialized Views to improve the performance of distributed queries.
• Developed various UNIX Shell Scripts to generate Ad Hoc reports.
• Involved in developing Extraction-Transformation-Loading (ETL) process using SQL*Loader and PL/SQL package UTL FILE.
• Used ERWIN to develop logical and physical database models.
• Created Control Files and usedSQL* Loader to upload bulk data into database from external files.
• Involved in formulating general methodologies, naming conventions and coding standards for various Procedures and Packages.

Environment: Oracle 9i, MySQL, Oracle Forms 6i, Oracle Reports 6i, Perl Scripting, PL/SQL TOAD, UNIX, SQL*LOADER, ERWIN.

Confidential

Oracle Developer

Responsibilities:

• Developed screens using Forms 6i.
• Developed PL/SQL Modules-Administration Manager (AM), Cession Manager (CM), Report Manager (RM), Database Utility (DU) modules.
• Extensively involved in SQL Tuning of PL/SQL modules development.
• Used PL/SQL web toolkit to develop programs for web enabling.
• Used Web request broker and PL/SQL agent for the connection to the Oracle database.
• Created reports in Oracle Discoverer by importing PL/SQL functions on the Admin Layer, in order to meet the sophisticated client requests.
• Developed Billing and Policy exhibit reports using Reports 6i which are sent to reinsures on regular basis.
• Developed extract reports using Reports 6i to upload information to the policy valuation/ Accounting system as well as custom reports for internal use.
• Conducted Unit and Functionality Testing of the above modules.
• Performed the documentation of the modules and reports generated.
• Implemented Shell Scripts for scheduling batch jobs, diagnostics.
• Responsible for Performance Tuning of the Forms and Reports code modules using EXPLAIN PLAN, SQL*TRACE, TKPROF and TOAD utilities.

Environment: Sun Solaris 8.0, Windows NT 4.0/2000 Oracle 9i, Discoverer, PL/SQL, TOAD, Forms 6i, Reports 6i, Shell Scripting (KORN)