Data Software Engineer

Name: NAGENDRA BABU

Skills: PL SQL DEVELOPER

Phone: 510-396- 7055

Email: ***********@*****.***

CAREER OBJECTIVE

Quest to work in a professional atmosphere which will help me to impart knowledge about the latest technologies in the world of information by virtue of my sincerity and dedication. I intend to contribute positively towards the growth and prosperity of the company.

Summary

Around 3 years of IT Experience as Oracle Developer for System Analysis, Designing, Testing

Development & Support of Oracle 8i, 9i, 10g & 11g in Production, Staging, Development environments.

Expert in creating SQL Queries, PL/SQL package, function, stored procedure, triggers, and cursors.

Created database objects like tables, views, sequences, synonyms, indexes using Oracle tools like SQL*Plus, SQL Developer and Toad.

Enforced data integrity using integrity constraint and database triggers.

Proficient in advance features of Oracle 11g for PL/SQL programming like Using Records and Collections, Bulk Bind, Ref. Cursors, Nested tables and Dynamic SQL.

Experience in SQL and PL/SQL tuning and query optimization tools like SQL Trace, Explain Plan, and DBMS_PROFILER.

Strong knowledge with PL/SQL Wrapper to protect the PL/SQL procedures or packages.

Strong knowledge of Star Schema, Snow Flake Schema, Dimension and Fact table.

Expertise in handling errors using Exceptions.

Making structural changes to the database objects.

Transferred data using data transfer tools like FTP (File Transfer Protocol) and SFTP (Smart FTP).

Exposure & knowledge of designing logical & physical Data Model in Relational Database Management System (RDBMS).

Strong interpersonal skills, ability to interact with people at all levels. Good communication and presentation skills and a Very Good Team Player.

Documentation of projects for Functional Requirement Spec (FRS), Use case Spec, ER-Diagram, Test Plan, and Test Script & Test Cases.

Assisted QA Teams for bug testing, User Acceptance Testing (UAT) & System Integration Testing.

Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies.

Extensive experience with all phases of the Software Development Life Cycle

TECHNICAL SKILLS

Databases : ORACLE, MySQL, SQL Server.

Administration : Oracle DBA, Server Manager, SQL*Loader, Export.

Operating Systems : Windows, UNIX, Ubuntu.

Programming languages : C, C++, Java, HTML, XML.

Tools : TalenD, Toad, SQL*Plus, SQL Developer.

WORK EXPERIENCE:

COMPUTER SOLUTIONS AND SOFTWARE INTERNATIONAL PVT, INC HYDERABAD

NOV 2014-AUG 2015

Project: VUESoftware

Description: VUE Software offers an end to end distribution platform that allows carriers to drive growth by strategically replacing slow manual processes with fast process automation increasing the overall efficiency of their distribution channels

Role: Software Engineer

Responsibilities:

Participated in Designing databases (schemas) to ensure that the relationship between data is guided by tightly bound Key constraints.

Involved in Business Requirements, System analysis and Design of the Data warehouse application.

Data Analysis primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats.

Designed Physical and Logical Data model and Data flow diagrams.

Involved in the creation of database objects like Tables, Views, Stored Procedures, Functions, Packages, DB triggers, Indexes.

Worked on various tables to create Indexes to improve query performance. Also worked on partitioning large Tables using Range Partitioning, creating Index Organized Table, Rollback Tablespace.

Involved in writing several Queries and Procedures.

Involved in the Database Design (Relational and Dimensional models).

Defined both logical views and physical data structure.

Filtered and Loaded data from different formats of data sources into Database Tables.

Extracted required data from the database tables and exported the data to different sources in different formats.

Worked with several tools to access and perform several operations on database.

Experience in Generating Reports.

Developed Data entry, query and reports request screens and tuned the SQL queries.

Used joins, indexes effectively in where clauses for Query optimization.

NEELSYS INDIA PVT LTD, Hyderabad DEC 2012 – NOV 2014

1)Project: Alto Carrera

Description: Altocarrera is an educational and career readiness platform by NeelSys. This helps educators, administrators, students, and parents maximize success through every stage of the learning life cycle. Altocarrer's personalized learning, academic planning, post-matriculation enrollment, and student support solutions serves millions of students across more than thousands of schools, colleges and universities worldwide.

Role: SQL Analyst

Responsibilities:

Developed Data Flow Diagrams, Entity Relationship Diagrams

Creation of Database Objects: Tables, Stored Procedure, Views, Triggers, Index, and Function.

Expertise in Sql Queries writing.

Taken part in Database design for different modules.

Configured, tuned, Upgraded and maintained database servers.

Experience with PLSQL and MySQL on Linux, Ubuntu and Windows.

Experience in data migration, integration tools like TalenD, Toad.

Creating database users and assigning quotas, roles, privileges and profiles to users.

Database monitoring, job Scheduling, backups and Recovery

Hands on Database Replication, clustering and Mirroring

Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.

Supporting management with different database related decisions.

Ensured 24x7 database availability, reliability and security while in a production environment.

EDUCATION DETAILS

Bachelor’s in Computer’s Engineering (2008-2012).

Pursuing Master's in Computer Science from Northwestern Polytechnic University.

Contact this candidate