Resume

Sign in

Sql Developer

Location:
Sunnyvale, CA
Salary:
90000
Posted:
September 17, 2018

Contact this candidate

Resume:

VijayRahul Pantham

ac62qj@r.postjobfree.com

813-***-****)

Professional Summary:

* ***** ** ********** ** Support Analyst.

Experience in Design and maintenance of E-Commerce, Retail, and HealthCare Domains.

Experienced in complete life cycle Implementation of PL/SQL Development.

Proficient in writing complex SQL Queries, PL/SQL Procedures, Normalization, Database Design, creating Indexes, Functions, Triggers, Sub Queries, Collections, Performance Tuning and Query Optimization

Technical areas of experience related to PL/SQL, UNIX.

Created Shell Scripts for invoking SQL scripts and scheduled them using Crontab.

Extensively worked on PL/SQL Object Types, Dynamic SQL, Collections, Autonomous transaction, Materialized Views.

Working experience in data extraction, transformation and loading operations into oracle using SQL Loader, External tables, Export/import, Views.

Strong debugging skills in SQL ad PL/SQL.

Expertise in writing complex queries in MongoDB, Casandra Dev Centre.

Basic knowledge on shell scripting and core java.

Experience in supporting Java applications.

Hands-on experience with POSTMAN Rest API Services

Proficient in unit testing, code migration/deployment, Pre and post production support, customizations and Maintenance.

Prepared BRS (Business Requirement Specifications) document that gives the detailed information about the requirements.

Expertise in working with relational databases such as Oracle 12c/11g/10g/9i.

Experience in Creating Users, Roles and Profiles, Privilege management with role-based security.

Developed and maintained system documents, including technical specifications, data mapping, program logic and flowcharts.

Experience in Requirements Gathering and Preparing Use Cases.

Good analytical and communication skills and ability to work independently.

Good Team player and quick learner, having excellent interpersonal skills.

Expertise in working with Projects in Agile Methodology.

Strong conceptual, business, analytical skills and innovative problem solving abilities.

Worked in 24/7 Production Support projects.

Technical Skills:

Database

Oracle 9i,10g /11g,12C

Language

Oracle SQL, PL/SQL, Basic Shell Scripting

Tools

Toad, Putty, SQL Developer, SQL Navigator, HP Quality Center, Tortoise SVN, Mongo DB, Casandra Dev Centre.

Markit EDM.

Operating System

Windows 9x/NT/2000/XP/Vista/7, Unix

Education Qualifications:

Master of Science in Computer Science Engineering, University of South

Florida, Tampa, Florida, USA. GPA: 3.89 May 2015

Bachelor of Engineering in Electronics and Communication Engineering, Gitam College of Engineering, Visakhapatnam, India. GPA: 4.0 April 2011

Professional Experience:DXC technology Sunnyvale California

Client: Walmart

Role: Professional Programmer Analyst Oct 2016 - present

Responsibilities:

Strong MS SQL and Data Model knowledge and experience of working within financial database implementations.

Analyzing and making modifications on PL/SQL stored procedures, functions and complex SQLs.

Developed database triggers, cursors, procedures/functions and packages using PL/SQL according to business requirement.

Understand and support Java applications for better and improved database response time.

Extensively worked on data mapping, validation, SQL loader and Bulk processing for loading data into Oracle database.

Modified and optimized complex queries for data retrieval and modification

Involved in SQL query tuning. Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements.

Utilize the following technologies: Java, J2EE, Microsoft SQL Server, PL/SQL, and UNIX shell Scripting.

Utilize the following tools: IBM Sterling Order management, Eclipse IDE, Microsoft SQL Server Analytics, Reporting & Integration, JIRA, RAFT and KIBANA.

Analyzing the pattern of recurring support issues and providing them a permanent fix.

Work with the business users for issues and queries in the project.

Involved in requirement analysis, system study, designing, coding, testing, debugging, deployment and post implementation support.

Unit Testing of the application and monitoring the central servers, server maintenance mode tasks, scheduling batch jobs and version controlling.

Provide functional and Technical knowledge to the backup team members both Onshore and Offshore (Project Management).

Helping the team for fixing the problems encountered by the users.

Provided the effective solution to the client by discussing and analyzing the Root Cause Analysis provided by team regarding any reported issue.

Analyze day to day transactions and reporting to regulatory.

Monitor the scheduled jobs.

Analyze the business requests and identify the impact components to be changed

Conducting status meetings and reviews.

Work efficiently to meet targets and developing a level of competency which helps to anticipate issues and solve them in advance.

Environment: Oracle/PL/SQL, Java, UNIX, Sterling Order Management. Markit EDM

Tools: Oracle SQL Developer, IBM Sterling Order Management app console, Eclipse, Putty, Mongo DB, Casandra Dev Centre, J-Meter (JMX), POSTMAN Rest API Services.

DXC technology Cincinnati Ohio.

Client: Kroger Inc. Aug 2015 - Sep 2016

Role: Associate Professional Programmer Analyst

Responsibilities:

Analyzed and modified PL/SQL code as part of development process to change database requirements.

Responsible for debugging, troubleshooting, and tuning PL/SQL stored procedures, functions and Complex SQLs.

Extensively worked on data mapping, validation, SQL loader and Bulk processing for loading data into Oracle database.

Handled tasks like store box failures, keep the servers in central database and bring back to local once box got repaired.

Solving high priority tickets, interacting with users, working on Infra (bugs and issues tracking system) Tickets Involved in Production Support and client interaction.

Modified and optimized complex queries for data retrieval and modification

I have been giving trainings to the new joiners into the team, when doing support also being as a mentor and providing them live support trainings.

Enhancements and coding and taking up support activities like Primary/IC roles.

Skope Log monitors EPRN Health checkups.

Working in Deployment of Staging, UAT and QA Environment.

Unit Testing of the application and monitoring the central Servers, servers maintenance mode tasks, scheduling jobs, Version controlling.

Sending the required reports to client (Used crystal reports, jasper reports from i-report tool).

Have good client interaction and end user communication.

Developed various database objects like views, packages, stored procedures, triggers, functions etc. using TOAD.

Developed SQL*Loader scripts to load the data from external flat files that are exported from external systems.

Involved in developing scenarios for Unit, Integration testing to ensure that all the components work correctly when integrated.

Technologies: Oracle SQL Developer, UNIX

Tools: Oracle SQL Developer, TOAD, JIRA, QC, TWS (Tivoli Workload Scheduler), Team city (For deployment), IBM Web sphere, CSRC, SVN for server’s maintenance.

Role: Systems Engineer, Tata Consultancy Services, India Jul 2011 - Dec2014

Internal Project

Responsibilities:

Preparing PL/SQL scripts for data correction.

Involved in Post Production Monitoring and Resolving production issues.

SQL query preparation for the given user requirement

Perform impact analysis for the enhancements and new requirements.

Created database triggers, cursors, procedures/functions and packages using PL/SQL according to business requirement.

Involved in SQL query tuning. Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements

Understand and support Java applications for better and improved database response time.

Unit test plan preparation and testing.

Develop and direct software system testing and validation procedures, programming, and documentation

Analyzed user needs and software requirements to determine feasibility of design within time and cost constraints

Environment: Oracle/PL/SQL

Academic Exposure: University of South Florida, Tampa, FL Jan 2014 – May2015

Independent Study:

Design and Implementation of outdoor/indoor navigation smart phone application

Performed Java Script Object Notation (JSON) parsing to store the co-ordinates of a particular route.

Used SQL Queries to retrieve the saved routes in the data base to display under recent tab to the user.

Followed Model View Controller architecture pattern

Voluntary Research Helper:

Collected raw data by analyzing an algorithm behavior in different scenarios- walking, running by installing the corresponding application on an IPAD.

Working on Team member Shortest Path Algorithm.

Research Projects:

Analysis of the Communication between Colluding Applications on Modern Smartphone’s

Free-form modeling in 2-D and 3-D using INKSCAPE and BLENDER software,fall 2015

Client/Server Socket connection establishment of inter process communication, spring 2015



Contact this candidate