PROFESSIONAL SUMMARY:

• 7+ years of experience as 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, Informatica, UNIX & Shell Scripting.
• 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.
• Basic knowledge and implementation on Data warehousing and Informatica (PowerCenter 9.6) ETL Tool.
• 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

Operating System: Windows 9x/NT/2000/XP/Vista/7, Unix

PROFESSIONAL EXPERIENCE:

Confidential, Sunnyvale, CA

Professional Programmer Analyst

Responsibilities:

• 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.

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

Confidential, Cincinnati, OH

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.

Environment: 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.

Systems Engineer

Confidential

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