SUMMARY:

• Database developer with 8+ years of experience in application design, development, testing, implementation and maintenance. Extensive knowledge of Oracle 7i/8i/9i/10g/11g, RDBMS concepts, including ETL process and ETL tools like Oracle Warehouse Builder, Informatica as well as experience in extraction, transformation and loading from multiple sources into data warehouses. Experience in all phases of the project Life cycle - Requirement gathering and Analysis, Database design, Database development, Application development, Test, Implementation and support in domains like Insurance, Financial and Health Care etc.
• Proficient working experience with SQL, PL/SQL and used TOAD in many development projects.
• Expertise in performing Data export, Import and various operations using TOAD, SQL DEVELOPER.
• Developed Advance PL/SQL using Cursor, REF Cursor, and Native Dynamic SQL. Developed Complex trigger using PL/SQL for data integrity and enforcing business rules.
• Experience in developing External Tables, Joins, indexes and Database Triggers.
• Moved columns of data in and out of database tables using PL/SQL program units by passing collections as parameters.
• Experience in developing logical and physical database design, data modeling using Erwin.
• Extensively worked on the Extraction, Transformation and Load (ETL) process using PL/SQL to populate the tables in database.
• Extensively worked on Oracle SQL, PL/SQL tuning in OLTP and DWH applications using STATSPACK, Explain Plan, TKPROF, and Hints.
• Well experienced in creating detailed design and technical design documents and worked with project management teams and business stakeholders to make modifications.
• Extensive experience in data migration techniques using Oracle External Tables, SQL* LOADER, UTIL file loader and batch processing.
• Experience On working with TFS, SVN, Git Version control tools.
• Experience in working with Perl and Unix Scripting.
• Experience in application development using various advanced features of Oracle like Bulk Collections, Table Functions, Autonomous Transactions, Dynamic SQL, Object types and Records.
• Strong Trouble-shooting, Problem solving, Analytical & Design Skills.
• Comfortable to work with a team or work individually.
• Highly motivated self-learner with ability to develop proficiency and adapt to new technologies and methods in a short period of time.

TECHNICAL SKILLS:

Methodologies: Star Schema, Snowflake Schema

Programming: Visual Studio 6.0, C, C++, Visual Basic 3.5/6.0,PL/SQL

Internet Technologies: HTML, XML & VBScript

Database: Oracle 7i/8i/9i/10g/11g

Operating Systems: MS-DOS, Windows NT/2000/ XP Pro, UNIX

Other Tools: Toad, SQL Loader, PL/SQL Developer, Tortoise SVN, Informatica Power Center 8.6.X/6.1

Data Analysis: Requirement Analysis, Business Analysis, Detail Design, Data Flow Diagrams, Data Definition Table, Business Rules, Data Modeling, Data Warehousing, System Integration.

Data Modelling Tools: Erwin 4.5/4.0/3.5, Microsoft Visio 2003

PROFESSIONAL EXPERIENCE:

Confidential, Albany, NY

Sr. Oracle PL/SQL Developer

Responsibilities:

• Involved from the beginning of the project and was responsible for the architecture changes.
• Involved in Effort estimation and preparing the WBS (Work Breakdown structure) plan.
• Gathering the requirements from Disability business users.
• Create new packages, stored procedures to generate XML for Daily, Quarterly and Annual BAR letters.
• Creating packages, stored procedures, triggers etc., using Oracle, PL/SQL
• Making changes to the existing database objects.
• Developed 3 new batch processes.
• Co-ordinate with another team to test the functionality using the new Adobe Live cycle and stream serve.
• Co-ordinate change request team to schedule the batch processes in Argent, Active batch job scheduler.
• Unit Testing the existing process and the new processes.
• Comparing the output of the existing process (generating the reports using Crystal reports 11) and the new process.
• Extensively Used TFS as the source control for the different applications.
• Proficient in using TFS for checking in the code change and then later merging the changes to a different branch to migrate the code to Production.
• Create test case documents.
• Generating the explain plans and tuning the SQLs, if needed.
• Checking the developed code to TFS (Team Foundation Server).
• Implementing the code to testing environments and supporting the QA team in testing the functionality
• Implementing the code to production.
• Extensively used INNOTAS to track the time of the project on a daily basis and for submitting the weekly status.
• Extensively used BLUEPRINT for accessing project requirements.
• Used HP Quality Center as a Defect Tracking system.
• Extensively Used TFS as the source control for the different applications.
• Worked on several .NET batch jobs that process the claims and send out automatic notification about status of the job.

Confidential

Responsibilities:

• Involved from the beginning of the project and was responsible for the architecture changes.
• Involved in Effort estimation and preparing the WBS (Work Breakdown structure) plan.
• Gathering the requirements from DBL business users.
• Create new packages, stored procedures to generate XML for Daily, Quarterly and Annual BAR letters.
• Creating packages, stored procedures, triggers etc., using Oracle, PL/SQL
• Making changes to the existing database objects.
• Developed 3 new batch processes.
• Co-ordinate with another team to test the functionality using the new Adobe Live cycle and stream serve.
• Co-ordinate change request team to schedule the batch processes in Argent, Active batch job scheduler.
• Unit Testing the existing process and the new processes.
• Comparing the output of the existing process (generating the reports using Crystal reports 11) and the new process.
• Create test case documents.
• Generating the explain plans and tuning the SQLs, if needed.
• Checking the developed code to TFS (Team Foundation Server).
• Implementing the code to testing environments and supporting the QA team in testing the functionality
• Implementing the code to production.

Confidential

Responsibilities:

• Gathering the requirements from business and DBL users.
• Effort estimation and preparing the WBS (Work Breakdown structure) plan.
• Helped in preparing the TDS (Technical Design Document) which will be helpful for developing.
• Making changes to the existing process using PL/SQL.
• Creating packages, stored procedures, triggers etc., using Oracle PL/SQL.
• Create an Electronic file using UTL files which will be consumed by the downstream systems.
• Developed several new batch processes.
• Co-ordinate with change request team to schedule the batch processes in Argent, Active batch job scheduler.
• Unit testing the existing and the new processes.
• Create test case documents.
• Generating explain plans and performance tuning the SQLs.
• Integration testing the code with other processes.
• Checking the developed code to TFS.
• Implementing the code to testing environments and supporting the QA team in testing the functionality
• Implementing the code to production.

Environment: Oracle 12c, PL/SQL, VB6, TFS, PL/SQL Developer, Crystal Reports 11, Adobe LiveCycle, Innotas, HP Quality Center, Active Batch.

Confidential, Grand Rapids, MI

Oracle Developer

Responsibilities:

• Gathered requirements from client and translated business details into Technical design document.
• Designed and developed Star Schema model for data warehouse.
• Analyzed impact of proposed system solutions for each line of business and identified risks, priorities, and alternatives.
• Implemented Partition and sub partition concepts to fine tune Data Load and Data retrieving from Fact table with 2.5 Billion records.
• Involved in project planning, coordination and implementation of QA methodology.
• Designed and Developed Water fall ETL approach in PL/SQL to load incoming files efficiently into warehouse.
• Created PL/SQL stored procedures, functions and packages for moving the data from Files to ETL staging area and then to Star Schema.
• Extensively used the advanced features of PL/SQL like records, tables, object types and dynamic SQL.
• Developed and Implemented Encrypting Process for Secure data.
• Performed SQL and PL/SQL tuning and application tuning using various tools like explain plan, SQL trace
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Extensively involved in working with Perl and Unix Programing to load data from HL7 files to tables in the database
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Coordinated with different teams to smoothly migrate the code to QC or Production environments.
• Extensively involved in working with EDI for transferring data from one system to other system.
• Modified n-tier intranet web application using ASP, ASP.NET, MS Visual Studio 2012, MS SQL Server 2008 & TFS.

Confidential, Lexington, KY

Oracle PL SQL Developer

Responsibilities:

• Developed, presented and implemented several Proof of Concepts to save load timings during ETL process; designed, developed and implemented several PL/SQL packages to load more than 1B records from multiple files.
• Humana heavily used Oracle Warehouse Builder for ETL but because of performance issues I had an opportunity to re-write entire ETL process using PL/SQL.
• Created Oracle database objects including tables, views, synonyms, materialized views, partitions and PL/SQL objects such as procedures, functions and packages to implement ETL Data flow.
• Redesigned several sequential jobs to run in parallel; Improved the performance of ETL process by fine tuning queries, creating appropriate indexes and using temp tables.
• Coordinated with the frontend design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Supported c#.programmer regarding the issues with database software’s.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Developed complex reports based on an Oracle views using running totals, sub totals, grand totals and conditional formatting.
• Design and implement Oracle Database indexing and partitioning strategy to process and query large volumes of data.
• Modified intranet web application using ASP, ASP.NET, MS Visual Studio 2012, MS SQL Server 2008 & TFS.
• Developed and implemented common utility package to avoid recoding for auditing, error handling, gathering statistics and index maintenance.
• Prepare detailed design and technical design documents and work with project management teams and business stakeholders to make modifications.
• Resolve production data load problems, support daily/weekly/monthly data loads and track and resolve performance issues.

Confidential, NY

PL/SQL Developer

Responsibilities:

• Gathered the requirement from the client and translated the business details into Technical design document.
• Analyzed impact of proposed system solutions for each line of business and identified risks, priorities, and alternatives.
• Involved in project planning, coordination and implementation of QA methodology.
• Participated in various meetings and discussed Enhancement and Modification Request issues.
• Analyzed manual systems and developed process flows for activities.
• Performed business process mapping/Data mapping for change requests and new requirements.
• Designed competent PL/SQL programs using PL/SQL collections, record types, and Object types.
• Generated PL/SQL Packages, Functions and Procedures to implement the Business Logic.
• Created database triggers for data security.

Confidential, NY

Oracle Developer

Responsibilities:

• Interacted with Subject Matter Experts (SME) to gather Business Requirements for the application, through one-on-one interviews as well as JAD sessions with development teams.
• Involved in gathering requirements through reverse engineering process.
• Analyzed impact of proposed system solutions for each line of business and identified risks, priorities, and alternatives.
• Tuned multiple long running monthly loads to minimize the load time, including a warehouse redesign which reduced load time from 2 Days to 7 hours.
• Developed process to load flat files coming from Up-stream systems into Oracle using External Tables.
• Designed competent PL/SQL programs using PL/SQL collections, record types, and Object types.
• Supported data migration from different tables to data warehouse; designed and developed partition concepts for ETL data loads; maintained legacy, legacy incremental and monthly load processes; created procedures to implement ETL functionality with Oracle for Dimension and fact loads.
• Helped QA team to develop test scripts for the validation of the process. Also performed unit testing and system testing.
• Modified intranet web application using ASP, ASP.NET, MS Visual Studio 2012, MS SQL Server 2008 & TFS.

Confidential

Programmer

Responsibilities:

• Wrote Procedures for conversion of data from one schema to another schema.
• Created database objects like tables, views, synonyms, indexes, rules and defaults.
• Development of Stored Procedures/Functions to meet the business requirements.
• Supported Data stage projects with PL/SQL API’s.
• Well versed with Oracle RDBMS, PL/SQL programming.
• Responsible for developing PL/SQL packages, procedures and functions whenever necessary.
• Handled calls with offsite DB team for discussions and understanding requirements.
• Created change documents for record and tracking.
• Data loading into tables.
• Unit testing of the procedures.