Summary:

• Software Engineer with 5 years of experience as Developer/Analyst with active participation in requirements gathering, design, development, testing and implementation
• Worked with client teams to gather requirements and create Business Requirements and Functional Specifications documents
• Partnered with the Business Analysts, Technical Architects and Database Administrators to design technical solutions based on Business Requirements
• Extensive experience in Oracle, Unix shell scripting, PL/SQL
• Worked in all phases of the Software Development Life Cycle SDLC
• Strong knowledge in using Oracle built-in packages, Cursor management, Exception handling
• Extensive experience in writing and debugging Oracle SQL, Dynamic SQL, PL/SQL code i.e. Packages, Stored Procedures, Functions, Triggers, Cursors, Ref Cursors, Constraints, Indexes, Views, Materialized Views, Database Links, Sequences and Synonyms
• Proficiency in using the Oracle Forms and Reports
• Worked with different Source Control tools like ClearCase and Subversion
• Experienced in using Data mining tools like Discovery, to test and correct the data inflow and outflow
• Expertise in writing test scripts and conducting User Acceptance Testing and Quality Assurance Testing
• Hands on experience in using Test automation tools like Quality Center, Mercury Test Director
• Have a reasonable understanding of the ITIL process and have worked on a service support Incidents, Change management procedures, SLA responses
• Worked with Java and Web services teams to implement projects within the given time line.
• Expertise in tracking data flow across various environments using WCC and Autosys Environment
• Experience in debugging the software logs and software tracing using WCC tracing tool
• Performed Testing for various applications involving backend databases, webservices, Java and J2EE.
• Extensive experience in preparing Test strategy, Test plan, Test scripts, Defect metrics, Test result summary and as well maintaining Requirement Traceability matrix
• Competed Oracle Certified Database Associate OCA certification
• Strong technical, problem solving and communication skills
• Have performed production support activities, for many applications interacting with multiple vendors across different European countries
• Strong skills in writing technical and functional documents defined by the business requirements
• Created documents for End user training and support

Technical Skills:

• Databases : Oracle 9i/10g/11g, Ingress, SQL Server
• Programming Languages : Shell Scripting, SQL, PL/SQL, C, JAVA
• Packages : VB
• Operating System : UNIX, Windows
• Technology : OpenRoad
• Data Mining Tools : Discovery
• Text Formatter : TROFF, GROFF
• Testing Tool : Mercury Test Director, HP Quality Center, JMeter
• Source Control Tools : Clear Case, Subversion
• Support Tool : Service Center
• Monitoring Tool : Autosys Workload Control Center
• Web Technologies : XML, HTML, DHTML
• Product : SAP Testing

Work Experience:

Oracle PL/SQL Developer

Confidential

The requirement of this project is to maintain and enhance the billing system at Confidential, which processes monthly bill payments initiated by its customers. Frameworks for extraction and purging are developed as part of the project to facilitate data extraction and database maintenance. This project also covers enhancements to the payment system that handles all payroll related processing for the employees. The project also involves development of Applications for the Internet Services Group to assist customers with making their payment and transactions online.

Responsibilities:

• Created functional specifications and detailed design documents
• Design and develop Packages and Procedures for Extraction and Purge frameworks.
• Perform enhancements to the existing Performance framework
• Work with Testing and Implementation teams to ensure smooth delivery of projects.
• Work with the Online Payment team to capture their database requirements and develop packages, procedures and triggers to meet the requirements.
• Work with the Database Architects to help convert the business requirements to Technical specifications and work on strategies to in-corporate them in existing design.
• Develop Unix shell scripts to automate the database frameworks we developed.
• Developed complex SQL script, Analytical Function using Cursors, Procedures and Triggers
• Perform volume testing with JMeter, to test the response times between Webservices, batches and Database
• Create packages/procedures to extract data and purge data files.
• Help develop extraction architecture as a service to be implemented in different teams.
• Created and tested back out and backup plans for each release.
• Develop Packages, Stored Procedures/Functions to perform purge activities
• Creation and deployment of releases across development and test platforms.
• Author Release notes Document to instruct the DBAs on the order and method of implementing the releases/projects.
• Co-ordinate with the testing and QA teams to ensure smooth delivery of the releases and projects
• Work with the QA team to perform root-cause analysis for issues in the new release
• Identify and fix issues
• Provide Support and Coverage during Staging and Production deployments.

Oracle Test/Support Engineer Confidential

The Requirement of the project is to process orders from different regions that are placed via SROC and Nike.net and place them in a newly created centralized database named Atlas. All the Orders, Claims, Product and Pricing details are updated in Atlas everyday through Batch jobs from UNIX scripts to java triggers to Oracle queries. All the existing data that is present in the previously used ATG database is also migrated to Atlas as part of this release

Responsibilities:

• Develop Packages, Stored Procedures/Functions to develop Atlas Database mirroring the existing ATG System
• Write Procedures to classify the incoming orders based on their regions and place them in different SAP system
• Perform root cause analysis for and test failure and co-ordinate with different teams to resolve the issue
• Create and Maintain Autosys jobs in both production and development Environments
• Create Views based on multiple tables and perform data changes on tables for cancelled and modified orders
• Create multiple jobs in Autosys Environment co-coordinating with offshore team and other technical teams to create a QA Environment to perform testing
• Create Shell scripts and SQL queries to get order report data from Atlas and process them into reports that is used by other systems like SAP and JCAPS for maintenance
• Develop Unix Shell scripts to monitor jobs and run the stored procedures/functions
• Help the various testing teams by tracking the order details through databases, SAP and Idocs that are created.
• Involved in preparation of Test plan and Test scripts with the help of requirement and design document.
• Co-ordinate between different teams to highlight the defects and defect resolution
• Provided Support coverage for the release and performed root cause analysis during the warranty phase
• Worked with different teams to set up the development and test Autosys environments
• Created Work Instruction Manual listing the possible failures and Recovery steps for each and every new job added as part of the project

Oracle PL/SQL Developer

The objective of this project is to facilitate the Loan Modification/Short sale Feasibility study, to verify banks, real estate brokers, and investors in order to assess the amount of bad debt, and find the percentage of loan that can be modified, identify the candidates for short sales and foreclosures. Banks can find out their profit and loss, and take the proper business decision based on the project strategy.

Responsibilities:

• Develop code using Packages, Stored Procedures/Functions as per business needs
• Create Views based on multiple tables and perform data changes
• Perform database tuning and Application Tuning
• Set up mass data in multiple tables and perform mass data transfer
• Developed Unix Shell scripts to monitor jobs and run the stored procedures/functions

Software Engineer, Steria India Ltd, Chennai

Confidential

Confidential department of the bank to develop Sanctions Application which involves obtaining the Sanctions list form the Confidential governments and match it with the existing and new customers of the bank. The accounts with unnatural transactions and illegal accounts were converted as alerts and monitored by the Barclays users, using IBMs Front-end system named Discovery. Based on the actions performed on these Alerts, actions were taken on the customers/bank accounts.

Responsibilities:

• Spearheaded software development process for multiple projects, leading and mentoring a team of developers
• Responsible for Client interactions which includes requirements gathering, weekly status reporting, coordination between client and offshore development team and assisted the testing team in scripting Test Cases for Unit, System and Integration Testing.
• Developed and modified PL/SQL packages to manage the alerts as they traverse through different stages
• Developed complex SQL script, Analytical Function using Cursors, Procedures and Triggers
• Created Requirement Traceability Matrix to trace requirements throughout the development process
• Created Materialized Views and tuned the data.
• Created partitioned tables, partitioned indexes for manageability and scalability.
• Developed Unix shell scripts to analyze data written in XML Files and store them into tables and vice-versa
• Involved in the preparation and authorization of test plan
• Involved in the preparation and execution of test Cases and reporting test results
• Involved in the preparation and maintenance of Requirement Traceability Matrix
• Involved in Functional, Regression and System Integration testing
• Defined test cases, created Test Scripts, analyzed bugs by interacting with the QA team to fix errors
• Tested input data arriving from different countries and standardized them using data mining tools like discovery
• Provided support for implementation and User Acceptance Testing
• Authored User Guide Documents followed by clients for multiple applications
• Received 'Pat on the Back' Award for customer delight, quality and delivery

Software Develope

Confidential

The objective of this project is to add two savings account and two overdraft accounts to the existing product types offered by the Barclays to its customers. The new accounts are available only to customers who are above 18 years of age and could be switched from other similar accounts. Customers could open this account by using website, by phone or by person. The accounts could be switched to other accounts based on various criteria set by the Bank. People requiring the overdraft and Insurance accounts will be offered the type of overdraft account based on the present and future needs.

Responsibilities:

• Worked at the client side and implemented overdraft accounts and letters to the existing accounts of the Bank
• Worked with business end users in gathering and understanding requirements
• Developed PL/SQL queries, stored procedures and Functions to add the new account details to various tables in the database
• Developed Triggers to restrict the minors and personal customers from opening overdraft accounts
• Implemented procedures to alert the customer on various overdraft account options available based on the customers background
• Writing Shell scripts to process the data and create account related information to the process data of the accounts
• Supported multiple systems coordinating and interacting with client teams and multiple vendors across different European countries
• Involved in the preparation and maintenance of Requirement Traceability Matrix
• Involved in Functional, Regression and System Integration testing
• Defined test cases, created Test Scripts, analyzed bugs by interacting with the QA team to fix errors
• Tested input data arriving from different countries and standardized them using data mining tools like discovery
• Conducted Unit testing and coordinated Integration testing.
• Involved in User Acceptance Testing UAT for the final testing of the product.
• Developed and implemented backup and recovery strategies.
• Trained and helped other developers to resolve the technical problems.

Confidential

Confidential System was developed by the Barclays Bank to prevent illegal transaction of money from various countries using the bank resources. Each day there are millions of transactions performed to transfer money from one account to another. The AML system monitors these transactions by the end of the day and alerts the bank on any suspicious activity that happens. Actions are taken on these account holders based on the personal and income details.

Responsibilities:

• Worked with clients to gather requirements and test sanctions software for European countries
• Analyzed, designed and developed Shell scripts and PL/SQL codes
• Developed PL/SQL Functions, Procedures and Packages to implement the various rules using which the transactions were monitored.
• Developed 'instead-of' triggers to stop illegal transactions to being implemented.
• Performed code changes to enhance performance of Unix shell and SQL scripts
• Extracted data from various databases to co-ordinate and limit the number of users accessing the system
• Improved performance of the developed systems and ensured quality by working closely with the testing teams
• Created Test Design Documents that highlights the types of testing that needs to be performed for the project and the necessity of each type
• Involved in the preparation and authorization of test plan
• Involved in the preparation and execution of test Cases and reporting test results
• Involved in the preparation and maintenance of Requirement Traceability Matrix
• Involved in Functional, Regression and System Integration testing
• Defined test cases, created Test Scripts, analyzed bugs by interacting with the QA team to fix errors
• Tested input data arriving from different countries and standardized them using data mining tools like discovery
• Created extensive test plans and related documents and involved in testing and debugging.
• Involved in Production support and release management process.