Sql Developer
Resume:
VijayRahul Pantham
************@*****.***
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