Senior Associate Resume

SUMMARY

Total IT experience of 14+ years.
Strong technical skills with 6+ years of Oracle PL/SQL, 7+ years of Sybase, 1 year of SQL server and 14+ years of Power Builder.
Developed PB objects, Provided production supports, application troubleshooting and problem resolution.
Expertise in SQL and PL/SQL Programming, developing Database triggers, Functions, Procedures, Packages, Views and Cursors.
Experienced on tools like Jira and Splunk.
Worked on UNIX.
Possess strong ability to quickly adapt to new applications, platforms and languages.
Good Knowledge on PowerBuilder and Sybase skills.
Complete working knowledge in Version Control Systems (ClearCase and GITHUB).

TECHNICAL SKILLS

Client / Server: PowerBuilder (ver. 6.5/7.0/8.0/12.5 )

DBMS: Oracle 8i/9i/10g/11g, Sybase ASE, SQL Server 2012

Version Control: PBNative, ClearCase and GITHUB

Other Tools: Toad, SQL Developer and SQL Advantage

PROFESSIONAL EXPERIENCE

Confidential

Senior Associate

Responsibilities:

Developing the PB, Sybase and PL SQL objects.
Production support, Involved in Analysis, Design and Development.
Designing Tables, Constraints, Views and Indexes.
Developed SQL, triggers, Procedures and Functions accordance with Business Requirements.
Prepared complex query.
Involved in Unit Testing Stored Procedures and Functions.
Performing maintenance enhancements, and bug fixes to existing PowerBuilder application
Used GITHUB version control.
Involved data migration from private bank to Financial system.

Confidential

Senior Developer, Providing Application Maintenance and Support

Responsibilities:

Developing the PB and Sybase objects.
Production support, Involved in Analysis, Design and Development.
Designing Tables, Constraints, Views and Indexes.
Developed SQL, triggers, Procedures and Functions accordance with Business Requirements.
Prepared complex query.
Involved in Unit Testing Stored Procedures and Functions.
Performing maintenance enhancements, and bug fixes to existing PowerBuilder application
Used GITHUB version control.

Confidential

Senior Developer, Providing Application Maintenance and Support

Responsibilities:

Developed PL/SQL Packages using procedures, functions, cursors and exception.
Prepared complex Reports using Rank, Lag, First Value and LISTAGG Analytical functions.
Developed Tables, Constraints, Views and Synonyms and Indexes.
Created SQL*Loader scripts to load data into the temporary staging tables.
Developed PB objects.
Involving in Analysis, Design and Development
Preparing TA Documents and Unit Test Case documents

Confidential

Senior Developer, Providing Application Maintenance and Support

Responsibilities:

Involved in reverse engineering phase.
Creation of business rule extract document, this document will contain all the validations, DML operations and column details for each screen
Discussing with end user to understand the functionalities of the screen.
Helping production support team to fix the issues
Communicate confidently and proactively with customers throughout the project lifecycle.

Confidential

Senior Developer, Providing Application Maintenance and Support

Responsibilities:

Developed PL/SQL Packages, Triggers, Procedures, Views, Materialized Views and Functions accordance with Business Requirements.
Designing Tables, Constraints, Views, Sequence and Indexes.
Production support, Involved in Analysis, Design and Development
Performing maintenance enhancements, and bug fixes to existing PowerBuilder application.
Preparing TA Documents, Unit Test Case, Estimate and Review Report documents for the Enhancements executed by me.
Solving day - to-day problems, providing support to the users.
Used Cleaecase for Version Control of Database Objects