SUMMARY

• Over 9+ years of professional experience in IT industry as Oracle SQL/PLSQL/ data modeling and Analysis, Design and Modeling.
• 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.
• Working Knowledge on Unix and Windows.
• Expertise with Data Migration, Data Mapping or Table mapping, Data loading and exporting by using Import Export , SQL*Loader and UTL File Utilities .
• Developing reports using Informatica ETL tool.
• 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.
• Worked on Version Control Software.
• Experienced in using Business intelligence tool OBIEE.
• Expertise in Mathematical and Modeling and Numerical Analysis.
• Excellent planning, analytical, written communication and Interpersonal skills.

TECHNICAL SKILLS

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin

Front-end tools: TOAD, SQL Developer, PLSQL Developer.

Databases: Oracle 11g/10g/9i/8i.

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

ETL & BI Tools: Informatica, ETL, Knowledge on OBIEE 11.1.1.7.1 , Knowledge on ODI 12c

Programming: SQL, PL/SQL, T-SQL, UNIX Scripting.

Operating Systems: Windows XP/2003/2000/NT/98/95/7, UNIX.

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Sr Oracle PL/SQL/ Developer

Responsibilities:

• Writing complex packages, SQL, PL/SQL, stored procedures, functions, and triggers.
• Created database objects like tables, views, procedures, packages using Oracle tools like SQL*Plus , SQL Developer, PL/SQL Developer and TOAD.
• UTPLSQL for unit testing plsql packages.
• Merge statement to insert and update existing records.
• Modified and debugged several PL/SQL programs for performance tuning SQL queries using techniques like EXPLAIN PLAN, TKPROF and DBMS PROFILER.
• Worked on Online transaction system, handled high volume of data.
• Work with developers to design and write complex packages to support their needs.
• Experience working in a development and/or production database environment for a large scale, complex application involving on-line and batch environments.
• Work with Database Administrators to implement design changes and new packages.
• Worked with Bulk Collects to improve the performance of multi-row queries by reducing the context switching. Global temporary table to generate the data dynamically for reporting purpose.
• Used Materialized views for by weekly reporting and refreshing on demand.
• Writing SQL*Loader and External table scripts for the DDL's. Fixing bugs in .txt,.csv and. dmo files.
• Created Bat files and run in batch environment.
• Worked with Bulk Collects and for all to improve the performance of multi-row queries by reducing the context switching. Worked on Types and type records.
• Experience in database designs based upon identified business rules and using Oracle 10g/11g or higher.
• Created Database constraints like Primary key and foreign key using RDBMS concepts.
• Experience in performing knowledge transfers to client staff of Oracle database administrator techniques supporting the development of database structure for the new architecture.
• Created indexes on some of the columns on the tables to increase the application's performance.
• Worked on informatica mapping to load data from file to oracle table.
• Writing pl/sql procedures for ETL process.
• Unit testing using UTPLSQL.

Environment: Oracle 12c/11g r4, Informatica, pl/sql developer, GIT, Jenkins, Jira U deploy, UNIX, Putty, SQL Developer, TOAD, Citrix, HTTPS and SSL.

Confidential, Albany, NY

Sr Oracle PL/SQL/ODI Developer

Responsibilities:

• Participated in database design within an existing Oracle database structure.
• Helping Application Development team in preparing technical designs and perform construction activities.
• Writing complex packages, SQL, PL/SQL, stored procedures, functions, and triggers.
• Created database objects like tables, views, procedures, packages using Oracle tools like SQL*Plus , SQL Developer, PL/SQL Developer and TOAD.
• Worked on Online transaction system, handled high volume of data.
• Created SQL*Loader control files for moving the data from Flat Files to staging area tables.
• Loading data into fact tables using complex pl/sql Packages.
• Worked on Star and Snowflake Data Models for Enterprise Data Warehouse.
• Work with developers to design and write complex packages to support their needs.
• Experience working in a development and/or production database environment for a large scale, complex application involving on-line and batch environments.
• Work with Database Administrators to implement design changes and new packages.
• Modified and debugged several PL/SQL programs for performance tuning SQL queries 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. Global temporary table to generate the data dynamically for reporting purpose.
• Used Materialized views for by weekly reporting and refreshing on demand.
• Writing SQL*Loader and External table scripts for the DDL's. Fixing bugs in .txt,.csv and. dmo files. Created Bat files and run in batch environment.
• Worked with Bulk Collects and for all to improve the performance of multi-row queries by reducing the context switching. Worked on Types and type records.
• Experience in database designs based upon identified business rules and using Oracle 10g/11g or higher.
• Created Database constraints like Primary key and foreign key using RDBMS concepts.
• Experience in performing knowledge transfers to client staff of Oracle database administrator techniques supporting the development of database structure for the new architecture.
• Experience Building and Maintaining Oracle Tables.
• Experienced in defining and organizing the ODI project including interfaces, packages, procedures, variables, user defined-functions, and knowledge modules
• Used Microsoft TFS and Visual Studio for Check out/check in the scripts
• Created indexes on some of the columns on the tables to increase the application's performance.
• Convert VB scripting to pl/sql packages.
• Writing pl/sql procedures for ETL process.
• Used SVN to check-in the code.
• Create and used existing PL/SQL stored procedures, packages and views for use in BI Reports on Oracle 11gr2 /12c.

Environment: Oracle 12c/11g r4, ODI 12c, pl/sql developer, SVN, TFS, Quality Center, UNIX, Putty, SQL Developer, TOAD, Citrix, HTTPS and SSL.

Confidential

Sr Oracle PL/SQL/ Developer

Responsibilities:

• Participated in requirement and design sessions.
• Working 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 , SQL Developer, 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.
• Implemented a variety of ODI interfaces, packages, procedures, scenarios for extracting and loading data into target sources
• Experienced in defining and organizing the ODI project including interfaces, packages, procedures, variables, user defined-functions, and knowledge modules
• Used ODI Designer to develop complex interfaces (mappings) to load the data from the various sources into dimensions and facts.
• Implementing ETL in pl/sql procedures.

Environment: Oracle 11g r2/ 12c, ODI 11.1.1,, TOAD, TFS, Quality Center, UNIX, SSH Putty, SQL Developer, TOAD, Citrix, HTTPS and SSL.

Confidential, Pittsburgh, PA

Oracle Data modeler/ PL/SQL Developer

Responsibilities:

• Interacted with the Business Analysts in understanding the business requirements for the project.
• Working on agile environment. With every day status updates
• Gathered the requirements from the users and analyzed their business needs and created SRS documents.
• Involved in SDLC including designing, coding and testing.
• Implemented Oracle ERP as SalesForce ERP.
• Writing Technical design documentation. Data warehouse environment
• 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
• 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 client 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.
• 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.
• Responsible for designing, developing, and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems (Flat files, Oracle) feeds using ODI and CDC.
• Implemented a variety of ODI interfaces, packages, procedures, scenarios for extracting and loading data into target sources
• Developing Slowly Changing Dimensions mappings using Change Data capture (CDC) Type1, Type2 and Type3 as a part of Performance Tuning in ODI.

Environment: ODI 11.1.1, Oracle 11g/10g, PL/SQL, SQL Navigator, UNIX, Windows XP, WINCVS, SSH, SQL Developer, PLSQL Developer, TOAD, PowerBuilder 9.0.

Confidential, Roseland, NJ

Oracle Data modeler/ PL/SQL Developer

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.
• Created logical data model (LDM) and made appropriate changes to make compatible with the business logic.
• 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.
• Extracted data from Flat files and transformed it in accordance with the Business logic mentioned by the client using SQL*Loader . Involved in validating the data while data migration by creating PL/SQL Packages, Procedures, Functions, Triggers.
• Generated XML using the Procedures, Functions and Packages.
• Writing Technical design documentation.
• SQL tuning of queries.
• Worked in agile mereology environment.
• Defined database requirements and designed data model.
• Extracting data from Sql server database to oracle database using Informatica.
• Created Schema Using the XML schema.
• 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.
• Extensively used for all and bulk collect to fetch large volumes of data from table
• Applying constraints and writing triggers to apply the business rules. Involved in handling errors and transaction processing in the procedures.
• Created Indexes for faster retrieval of the customer information and enhance the database performance.
• 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.

Environment: Oracle 11g/10g, PL/SQL, OBIEE, SQL Navigator, UNIX, Windows XP, WINCVS,XMLSpy, SSH, SQL Developer, PLSQL Developer, TOAD, Erwin.