SUMMARY

• 13+ Years of experience as Oracle PL/SQL Developer in Oracle 11g, 10g, 9i & 8i versions and IT experience in Software Development/Maintenance & Support Projects
• Strong knowledge on oracle architecture and data base design.
• Strong Data modeling experience using ER diagram, Dimensional data modeling, Logical/Physical Design,
• Star Schema modeling, Snow - flake modeling using tools like Erwin, ERStudio.
• Good knowledge of Data modeling using ETL tools, LAP tools, Star Schema, Snowflake Schema, and Entity-Relationship Diagrams
• Excellent skills in designing and development of applications using Oracle, SQL, PL/SQL Good knowledge on Oracle tools like SQL * PLUS, PL/SQL, SQL and used TOAD in many development projects.
• Experienced in all phases of Software Development Life Cycle (SDLC).
• Excellent SQL skills, experience writing complex queries and working with database objects like tables, views, sequences, synonyms.
• Expertise in developing advanced PL/SQL code through various stored procedures, functions, cursors, triggers, packages and materialized views.
• Experience in Bulk Data loading using Oracle utilities namely SQL* Loader and External Tables.
• Expertise in Query Performance Tuning by Analyzing tables, hints, DBMS Profiler, TKPROF, SQL Trace, Explain Plan, Bulk Collect feature, Materialized Views and Troubleshooting Oracle database issues.
• Expertise with Data Migration, Data Mapping or Table mapping, Data loading and exporting by using Import Export, SQL*Loader and UTL File Utilities.
• Created Database constraints like Primary key and foreign key using RDBMS concepts.
• In depth knowledge of RDBMS concepts, with hands on exposure in the development of relational database environment using SQL, PL/SQL, T-SQL using database tools like Toad, SQL Navigator.
• Experienced in using Business intelligence tool OBIEE.
• Working knowledge of SOX, Health Insurance Portability and Accountability Act (HIPAA), ICD-10, GxP, QMS, GAMP, 21 CFR Part 11 and 21 CFR Part 820 Compliance.
• Adept in leading problem resolution, managing onsite/offshore teams, and implementing creative solutions that meet business, budget, and scalability requirements.

TECHNICAL SKILLS

Databases: Oracle …

Languages: Java, Spring, Hibernate, JSP, SQL, PL/SQL, T-SQL, XML, HTML

GUI: Oracle Forms 6i/9i/10g and Reports 6i/9i/10g, Sales Force

Operating Systems: UNIX, Linux, Windows, Ubuntu

Front-end Tools: TOAD, SQL Developer, PLSQL Developer

ETL & BI Tools: Informatica, ETL. Basic knowledge of SAS, OBIEE.

Applications Development: BMC Remedy/ITSM, ETL, Oracle EBS

Project Management Tools: HP PPM, HP ALM, CA Clarity, MS Project, MS Office, MS Visio

Configuration Management: Borland StarTeam, MS VSS, PVCS, CVS and SVN, JIRA.

Document Management: EMC Documentum & MS SharePoint

PROFESSIONAL EXPERIENCE

Confidential, Newark, DE

Environment: Oracle 11g r2/12c, TOAD, TFS, Quality Center, UNIX, SSH Putty, SQL Developer, TOAD, Citrix, Erwin, OBIEE.

Responsibilities:

• Participated in requirement and design sessions.
• Worked on Agile environment.
• Participated in database design within an existing Oracle database structure.
• Helping Application Development team in preparing technical designs and perform construction activities.
• Work with developers to design and write complex packages to support their needs.
• Perform team lead tasks when necessary.
• Code checking in Team foundation server (TFS) and adding required projects.
• Wrote complex functions and procedures for new packages and update existing packages in an established
• Oracle database using pre-defined business rules.
• Work with Database Administrators to implement design changes and new packages.
• Performance testing and rewriting of production code/SQL statements & procedures performing badly, identified by Database Administrators.
• Provide database support to developers who write code using WCF, WPF and .Net.
• Reviewed and implemented the naming standards for the entities, attributes, alternate keys, and primary keys for the logical model and physical model.
• Created Database constraints like Primary key and foreign key using RDBMS concepts.
• Created database objects like tables, views, procedures, packages using Oracle tools like SQL*Plus, PL/SQL Developer and TOAD.
• Extracted data from Flat files and transformed it in accordance with the Business logic mentioned by the client using SQL*Loader and External tables.
• Converted VB code and SQR reports into PL/SQL packages and discuss with the .net developers to change per their requirement.
• Support the application through the testing and implementation phases, including product test, stress/load test etc.
• Preparing Analysis and testing documents for testers. Functionality testing.
• Experience monitoring and tuning the general performance of the Oracle database.
• Modified and debugged several PL/SQL programs for performance tuning using techniques like EXPLAIN PLAN, TKPROF and DBMS PROFILER.
• Worked with Bulk Collects to improve the performance of multi-row queries by reducing the context switching.
• Extensively used for all and bulk collect to fetch large volumes of data from table SYS CONTEXT to check the information of oracle environment.
• Experience in database designs based upon identified business rules and using Oracle 10g/11g or higher.
• Reverse engineering the exiting data model.
• Understand and meet referential data integrity requirements
• Building UNIX shell scripts for data migration and batch processing

Confidential, Houston, TX

Project Manager

Environment: SAP Quote-to-Cash Modules, Enterprise Data Warehousing (Informatica), Finance, Sales IT, Sales IT Compensation.

Responsibilities:

• Gather requirements for change requests with the Business team and create design documents
• Provide User Access to Business End Users to the Front-end tools after getting the required approvals
• Create PL/SQL packages for implementing Change Requests for adding new functionality to the application
• Created database objects like Tables, Views, Sequences, Synonyms, Stored Procedures, Functions, Packages, Cursor, Ref Cursor and Triggers.
• Wrote complex SQL Statements, Complex Joins, Co-related Sub-queries and SQL Statements with Analytical Functions
• Performed SQL and PL/SQL tuning using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF
• Extensively used Oracle Hints to direct the optimizer to choose an optimum query Execution Plan
• Extensively used Bulk Collection in PL/SQL Objects for improving the performance
• Handled errors using Exception Handling extensively for debugging and maintainability.
• Automated Oracle and Informatica workflows using Unix Cron Utility in Unix Environment.
• Responsible for writing Unix Shell scripts for loading data using SQL*Loader. The Control Files for the tables were created and automated through UNIX shell scripts to perform data load in to Oracle tables.
• Used SQL Loader and PL/SQL scripts to load data into the system application.
• Performed Data Cleansing to weed out erroneous Orders from the DWH tables
• Extensively used Toad to develop Oracle PL/SQL Packages
• Create Procedures and Functions in SQL Server to migrate data from Legacy servers to Oracle Datawarehouse tables
• Worked on Sessions & workflows for variety of loads starting from Source to Target
• Created Mappings using Designer, Extracted the data from the flat files and other RDBMS databases into staging area and loaded onto Data Warehouse
• Create Perl & Shell scripts for automating the business logic
• Deploy the code across the environments to main code consistency and update the same in Clear Case for version control
• Create Test Cases for verification and validation of the Change Requests

Confidential - Grand Rapids, MI

Responsibilities:

• Create Use case documents for the functional requirements for the Change Request
• Daily status calls with the end users during the Requirement Gathering phase to mitigate risks
• Help Developers in translating requirements during coding
• Deploy Code across all environments and upload the code in Dimensions tool for version control
• Gather requirements from End Users and SME's regarding the Change Request and create High Level and Low Design documents
• Create PL/SQL Packages which contains Cursors, Exceptions, Procedures and Functions to load the daily, weekly and monthly data into the database table.
• Performance tune End user SQL queries using Explain plan with TKPROF and Oracle Optimizer hints
• Performance tune DML statements for fetching and loading data into the Oracle database tables using Bulk Binds logic
• Create Range Partitions based on load date and maintain List/Range sub-partitions for different Circuit ID's for Vendors
• Create DML Triggers for updating the audit tables for DML activities on the master tables
• Create Views for Master tables and Materialized views from DWH tables for End User Queries
• Load data from Flat files from Legacy Mainframe Applications using SQL Loader scripts
• Responsible for creating users, granting roles and privilege management
• Perform SQL Testing for verifying proper loading of data in the DWH tables
• Create adhoc PL/SQL blocks for User requirements
• Resolve the database issues of the users whenever in need of
• Create Programmable blocks using SQL Server to migrate data from Legacy applications to Oracle
• Create Unit Test cases for verification and validation for the Change Request
• Created automation scripts in Shell & PERL Scripting
• Create comprehensive documents of the changes made for the end users

ENVIRONMENT: Oracle 11g, Agile, SQL, PL/SQL, SQL Server 2008, Informatica, UNIX Shell Scripting

Confidential - Brea, CA

Responsibilities:

• Interacted with the Business Analysts in understanding the business requirements for the project.
• Gathered the requirements from the users and analyzed their business needs and created SRS documents.
• Involved in SDLC including designing, coding and testing.
• Writing Technical design documentation.
• Created logical data model (LDM) and made appropriate changes to make compatible with the business logic.
• Created Physical Data Model (PDM) for the OLTP application using Erwin 9.0.
• Interacting with business users to analyze the business process and requirements and transforming requirements into Conceptual, logical and Physical Data Models, designing database, documenting and rolling out the deliverables.
• Applying constraints and writing triggers to apply the business rules. Involved in handling errors and transaction processing in the procedures.
• Table Partitioned by creating a table in to smaller level partitions based on date. Usually we do for Saving storage space and Performance issues instead of querying whole big table.
• Created database objects like tables, views, procedures, packages using Oracle tools like SQL*Plus, SQL Developer, PL/SQL Developer and TOAD.
• Defined database requirements and designed data model
• Extensively used Dynamic SQL for calling procedures, Created Forced Views
• Modified and debugged several PL/SQL programs for performance tuning using techniques like EXPLAIN PLAN, TKPROF and DBMS PROFILER
• Worked on performance tuning and used Explain Plan, TKPROF and SQL trace for tuning the queries.
• Writing SQL*Loader scripts for the DDL's. Fixing bugs in .txt,.csv and .dmo files.
• Resolving complex issues and investigating the root cause of the issues.
• Extensively used for all and bulk collect to fetch large volumes of data from table
• Extracted data from Flat files and transformed it in accordance with the Business logic mentioned by the business using SQL*Loader. Involved in validating the data while data migration by creating PL/SQL Packages, Procedures, Functions, Triggers.
• Created Indexes for faster retrieval of the customer information and enhance the database performance.
• Used SYS CONTEXT to check the information of oracle environment.
• Wrote many simple and complex ad-hoc reports using SQL Plus and TOAD for the business users.
• Transformed complex business rules to Oracle PL/SQL.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Developing and maintaining conceptual, logical and physical dimensional data model to ensure the information models are capable of meeting end user and OBIEE developer needs.

Confidential - Boston, MA

Onsite Technical Lead

Environment: Oracle 9i, TOAD, SQL Navigator, Forms, Reports, Erwin, Windows XP, Kintana, Mercury IT/HP PPM.

Responsibilities:

• Analyzed business requirements and coordinated with the business analyst to develop ETL procedures that confirm to the enterprise standards while maintaining consistency across all applications and systems.
• Developed Oracle PL/SQL code based on requests raised by changes in business logic, norms and standards. Developed Unit Test Plans.
• Prepared Business Requirement Specification that gives the comprehensive details about the requirements.
• Resolving complex issues and investigating the root cause of the issues.
• Developed / modified Oracle PL/SQL codes like stored Procedures, Functions, Triggers etc. based on technical and functional specification documents. Used Sub-queries, Merge statements and Joins extensively in stored procedures.
• Developed / modified scripts to create tables, views and executed them using SQL Plus.
• Created SQL*Loader control files for moving the data from Flat Files to staging area tables.
• Used PL/SQL Tables, Ref Cursors to process huge volumes of data and used bulk collect and bulk bind for mass update as performance improvement process and Oracle Objects including Collections, Types and creating objects.
• Prepared the procedures to update the internal structures to reflect the newly loaded data.
• Used batch scripts to loop from database to database, to perform system-wide functions.
• Worked under the supervision of a DBA and created database objects such as tables, views, sequences, synonyms, and table/column constraints, indexes for enhancement.