PROFESSIONAL SUMMARY:

• Over 6 Years of software development life cycle experience in Software Design, Development and Implementation of Oracle, SQL and PL/SQL Applications.
• Experience with Data flow diagrams, Data dictionary and Database normalization theory techniques, Entity relation modeling.
• Extensive experience in writing SQL, Stored procedures, Functions, Packages, Database triggers.
• Designed database schema’s using Entity relationship modeling with ER diagrams & database normalization principles.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Analytical functions, Materialized Views, triggers and packages.
• Strong skills in developing applications using Oracle RDBMS 10g/9i.
• Strong experience in Data Warehousing and ETL using Data Stage.
• Experience on Logical & Physical Designing of Databases. Data Modeling, Conceptual Design & Data Architecture.
• Good knowledge on logical and physical Data Modeling using normalizing Techniques.
• Extensive use of Erwin as a modeling tool.
• Having good experience of Working on PL/SQL back end applications development Toad, SQL Plus, and PL/SQL Developer.
• Created Tables, Views, Constraints, Index.
• Able to work on multiple tasks and deliver the results within estimated budget and time with the accuracy to make the project success.
• Implemented production database in all phases of SDLC
• Very familiar with the Waterfall methodology for System development and implementation.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Assisted QA Teams for bug testing, User Acceptance Testing (UAT) & System Integration Testing.
• Good knowledge on Understanding Business Requirements, Identifying Test Scenarios, and Test cases, Test Data Setup, Test Execution and Defect Reporting.
• Experience in working with Teradata Assistant and Data Stage Director
• Extensive experience in using Quality Center for Test management.
• Have worked on projects for clients such as Confidential and Confidential .
• In depth knowledge of the Financial Domain and Life Sciences Domain.
• Involved in all the phases of Software Development Life Cycle (SDLC).
• Proficiency in major components in Hadoop Ecosystem including HDFS, Hadoop Distributed File System and Yarn Resource Management, Hive and Mahout.
• Have involved in querying large datasets with Hive and Spark SQL. Prepare and preprocess large data sets for analysis.
• Explored the design and machine learning algorithms that learn from data or experience, improve their performance and make predictions. Worked on collecting, exploring, preparing and analyzing data with R and Python.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, ETL, Java, Scala, Python, R, C/C++, C#, VB.net, ASP.net, VB.net

Mark up/XML Technologies: HTML, CSS, JavaScript

Databases: Oracle 9i/10G/11G, SQL Server, MySQL, DB2, Teradata

Tools: MS Visio, Erwin, MS Project 2000,Toad, DB2, Informatica, Data Stage, SQL*Plus.

Testing Tools/ Others: TOAD for Oracle, PL/SQL Developer, QC 11, Weka

Version Control: Git, VSS, Atllasian

Windows 98,2000/XP, MS: DOS, UNIX and LINUX.

PROFESSIONAL EXPERIENCE:

Confidential

Associate(PL/SQL/ETL Developer)

Responsibilities:

• Involved in all stages of Software Development Life Cycle (SDLC) of the project using Agile methodology.
• Participated in Daily meetings, review and demo with management and other teams.
• Designed Use Case Diagrams, Class Diagrams and Sequence Diagrams as part of the design.
• Developed PL/SQL stored procedures, packages, and functions for data extraction, transformation, and data loading (ETL).
• Developed SQL scripts to create database objects like tables, views and sequences.
• Worked in Oracle PL/SQL Development I.e. Stored Procedures, Packages, Functions & Triggers using SQL Navigator and Toad as development tools.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Designed the Mapping Technical Specification document based on Functional Requirements.
• Involved in designing ER diagram using VISIO to set the logical and physical relationships of database.
• SQL*Loader was used to load the data from the flat files to database tables.
• Involved in writing, debugging and optimizing PL/SQL code.
• Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views in Development and Production environment using PL/SQL and SQL*Plus.
• Performing Unit, Integration and System testing, and setting up UAT for the project modules.
• Understanding the Business Requirements and Functional Specification.
• Involved in Test Case and Condition Preparation & Test Preparation Review.
• Coordinating with the client for Test Condition, Test Cases, Technical Specification, Design Documents and Functional Specifications.
• Worked closely with end - users and team members to understand business requirements that drive the analysis.

Environment: Oracle 11g, Teradata, LINUX, UNIX, PL/SQL, SQL*PLUS, SQL*Loader , TOAD, Shell Scripting, Datastage, ETL, Microsoft word/excel 2013, XML files, CSV files, flat files, SQL Developer.

Confidential

Senior Software Engineer

Responsibilities:

• Involved in all stages of Software Development Life Cycle (SDLC) of the project using Agile methodology.
• Participated in Daily meetings, review and demo with management and other teams.
• Designed Use Case Diagrams, Class Diagrams and Sequence Diagrams as part of the design.
• Developed PL/SQL stored procedures, packages, and functions for data extraction, transformation, and data loading (ETL).
• Developed SQL scripts to create database objects like tables, views and sequences.
• Worked in Oracle PL/SQL Development I.e. Stored Procedures, Packages, Functions & Triggers using SQL Navigator and Toad as development tools.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Designed the Mapping Technical Specification document based on Functional Requirements.
• Involved in designing ER diagram using VISIO to set the logical and physical relationships of database.
• SQL*Loader was used to load the data from the flat files to database tables.
• Involved in writing, debugging and optimizing PL/SQL code.
• Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views in Development and Production environment using PL/SQL and SQL*Plus.
• Performing Unit, Integration and System testing, and setting up UAT for the project modules.
• Understanding the Business Requirements and Functional Specification.
• Involved in Test Case and Condition Preparation & Test Preparation Review.
• Coordinating with the client for Test Condition, Test Cases, Technical Specification, Design Documents and Functional Specifications.
• Worked closely with end-users and team members to understand business requirements that drive the analysis.

Environment : Oracle 11g, Teradata, LINUX, UNIX, PL/SQL, SQL*PLUS, SQL*Loader , TOAD, Shell Scripting, Datastage, ETL, Microsoft word/excel 2013, XML files, CSV files, flat files, QC 11.SQL, PLSQL, VSS, WinSCP, Putty .

Confidential

Senior Software Engineer

Responsibilities:

• Involved in all stages of Software Development Life Cycle (SDLC) of the project using Agile methodology.
• Participated in Daily meetings, review and demo with management and other teams.
• Designed Use Case Diagrams, Class Diagrams and Sequence Diagrams as part of the design.
• Developed PL/SQL stored procedures, packages, and functions for data extraction, transformation, and data loading (ETL).
• Developed SQL scripts to create database objects like tables, views and sequences.
• Worked in Oracle PL/SQL Development I.e. Stored Procedures, Packages, Functions & Triggers using SQL Navigator and Toad as development tools.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Designed the Mapping Technical Specification document based on Functional Requirements.
• Involved in designing ER diagram using VISIO to set the logical and physical relationships of database.
• SQL*Loader was used to load the data from the flat files to database tables.
• Involved in writing, debugging and optimizing PL/SQL code.
• Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views in Development and Production environment using PL/SQL and SQL*Plus.
• Performing Unit, Integration and System testing, and setting up UAT for the project modules.
• Understanding the Business Requirements and Functional Specification.
• Involved in Test Case and Condition Preparation & Test Preparation Review.
• Coordinating with the client for Test Condition, Test Cases, Technical Specification, Design Documents and Functional Specifications.
• Worked closely with end-users and team members to understand business requirements that drive the analysis.

Environment: Oracle 11g, Teradata, LINUX, UNIX, PL/SQL, SQL*PLUS, SQL*Loader , TOAD, Shell Scripting, Datastage, ETL, Microsoft word/excel 2013, XML files, CSV files, flat files, QC 11.SQL, PLSQL, VSS, WinSCP, Putty .