SUMMARY

• Senior IT Professional with more than 9+ years of experience in Information Technology Industry with area of expertise being Oracle PL/SQL
• Worked with major clients like Alamo Colleges, Confidential, Confidential, Confidential, Confidential, Confidential etc.
• Determining Database structural requirements by analyzing teh client current systems.
• Maintaining quality of database - dis includes correction of data or adjustment of data as per user requirement after proper validations. dis will be done using SQL queries.
• Develop Database solutions by designing proposed system; defining database physical structure and functional capabilities.
• Involved with business users through teh various phases including user acceptance testing and involveduser trainings in walking through teh application.
• Expertise in creating Database objects such as Tables, Constraints, Indexes, Views, Stored Procedures, Functions and Triggers using Oracle.
• Proficient in SQL and PL/SQL programming like writing Joins, cursors, variables, Ref. cursors, nested tables, associative array, dynamic SQL and nested loops.
• Experienced in developing Reports using Argos 3.x/5.x, and Tableau 8.x.
• Expert level noledge in Argos Reporting and experience in creating Data blocks and creating Excel, Banded and Extract report using Reporting Writing.
• Knowledge in setting up EC2 instances, security groups and Setting up databases in AWS using S3 bucket and configuring instance backups to S3 bucket.
• Worked in AGILE environment and Scrum Methodology.
• Experience in 24X7 Production support including on-call support.
• As a team member, I would make sure teh team to deliver within teh project timelines

TECHNICAL SKILLS

Databases: Oracle 11g/10g, SQL Server 2008, 2012

Languages: PL/SQL, SQL, Shell scripting, HTML, UNIX

Tools: /Utilities: PL/SQL Developer, SQL Server Management Studio, Oracle Forms 6i/10g, Oracle Reports, TOAD, SQL Developer, Jenkins, IntelliJ, Eclipse

Cloud Technology: Amazon Web Services (AWS)

Reporting Tools: Argos, Tableau

Version Control: GIT, SVN

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Senior Database Developer

Responsibilities:

• Interacting with users of different departments to understand teh current (Manual) process followed for creating Banner roles.
• Analyzed teh approval process followed currently and designed teh process to be followed in Banner workflow.
• Responsible for Design, Analyse and Development of teh workflow application.
• Development of Workflow application using HTML and Javascript.
• Created roles in Banner workflow and assigned users to those roles.
• Automated teh process of creating Banner roles using Ellucian Banner Workflow.
• Developed database objects in PL/SQL, i.e. writing Stored Procedures, Packages, and Queries.
• Responsible for teh development of quality Banner Workflow services to be delivered to clients including ‘out-of-box’ as well as custom solutions when gaps are identified.
• Training and mentoring new consultants coming up to speed with Banner Workflow both technically and functionally.

Environment: Oracle 10g/11g, PL/SQL Developer, SQL Developer, Ellucian Banner Workflow, Argos 5.x, Banner 8.x, Putty, HTML, Javascript, Unix, SVN, Forticlient VPN, Groovy Grails, Eclipse

Confidential

Sr. Database Developer

Responsibilities:

• Interacting with users to gather Business requirements and Analyzing, Designing and Developing teh procedures and packages.
• Involved in Understanding teh various Asian and European Capital Markets.
• Created User Guides for teh various market flows and did user trainings to Capital Markets Team (End Users).
• Analyze and Normalize Data of teh relevant business processes.
• Customized and developed Trade Feed screens for various markets using Oracle Forms.
• Developed programs in PL/SQL, i.e. writing Stored Procedures, Packages, and Queries.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• Launching Amazon EC2 Cloud Instances utilizing Amazon Web Services (Linux) and Configuring propelled examples as for applications.
• Validating connections between APR Gloss and external systems.
• Review and Implement improvements to support process.
• Involved in teh implementation of change management process and coordinated Release Cycle.
• Configured Jenkins Jobs for new Linux Servers.
• Successfully supported UAT for teh migration.

Environment: PL/SQL Developer, SQL Developer, Oracle Forms, Python, AWS, TOAD, Putty, UNIX, Linux, SNV, Scrum, Jenkins, IntelliJ, Capital Markets

Confidential

Database Developer

Responsibilities:

• Interacting with users of teh system to gather Business requirements and Analyzing according to requirements.
• Involved in teh designing a prototype of teh report using Argos, based on teh requirements, for teh approval.
• Implementing teh functionality of categorizing teh students into High, Medium and Low Priorities by writing SQL Queries.
• Created custom Database Objects (Tables, Sequences, Views etc.) as per teh requirements of teh user.
• Developed programs in PL/SQL, i.e. writing Stored Procedures, Packages for Implementing teh Email functionality.
• Responsible for taking Backup of Database objects and performing Data Replication activities from DEV to TEST Instances.

Environment: PL/SQL Developer, SQL Developer, TOAD, Banner 8.x, SVN, Secure VPN, Argos, Banner Implementation, Java

Confidential

Database Developer

Responsibilities:

• Involved in gathering system requirements, design, development and testing phases of dis project.
• Developed packages, procedures and functions based on teh requirements.
• Involved in Code Review and verification of coding standards.
• Preparing technical documentation for teh Student service centre(SSC).
• Unit testing of written Stored Procedures and Queries with best execution plan.
• Obtaining teh business process requirements for teh workflow process.
• Implementing workflow in Letter Management process.
• Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements.
• Installed, upgraded, configured, compiled, support of various Modules for Prod, QA, staging and on development.
• Experience with SQL DDL/DML Triggers, Database Migration and Upgrading.
• Responsible for performing Data Replication activities between different database Instances.
• Troubleshoot day-to-day issues associated with SQL.

Environment: Oracle 10g/11g, PL/SQL Developer, SQL Developer, Banner 8.x, Putty, Unix, SVN

Confidential

Database Developer

Responsibilities:

• Involved in gathering requirements, analysis and development of Reports to be developed using Oracle Report Builder.
• INB are forms created using Oracle Forms Builder. These Forms are customized to teh requirements of teh University.
• Involved in writing triggers for teh actions performed on teh forms.
• Involved in designing various forms.
• Involved in Unit testing and deployment of these forms.
• Involved in writing queries for generating reports.
• Created complex stored procedures, User defined functions, cursors.
• Responsible for performing Data Replication activities from DEV to TEST Instances.
• Attending daily SCRUM calls assign and update on stories to team members
• Creating develop tickets for moving code from QA to production using JIRA.

Environment: Oracle 10g/11g, PL/SQL Developer, Oracle Forms 10g, Oracle reports, ARGOS, Banner 8.x, SVN, Secure VPN

Confidential

Database Developer

Responsibilities:

• Preparation of design documents.
• Developed packages and procedures for functionalities.
• Involved in Code Review and verification of coding standards.
• Developed complex programs in PL/SQL, writing Stored Procedures, Packages, Triggers and Queries with best execution plan and experience with testing.
• Experience with tuning complex queries.
• Resolution of critical issues on push to Banner.
• Maintenance of environment stability.
• Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements.
• Installed, upgraded, configured, compiled, support of various Modules for Prod, QA, staging and development.
• Responsible for Database Migration and Upgrading to setup local environment.
• Assisted other teams in stress-testing Mobile App, locating bottlenecks, and recommending possible solutions.
• Troubleshoot day-to-day issues associated with SQL.
• Used TOAD database development tool to interact with database.

Environment: Oracle 10g/11g, PL/SQL Developer, SQL Developer, TOAD, Banner 8.x, Putty, Unix, SVN, Cisco VPN

Confidential

Database Developer

Responsibilities:

• Involved in writing functional and technical documents.
• Discussed and analyzed business functionality with teh client and teh developers.
• Created and maintained PL/SQL scripts for deploying to Prod.
• Coded many generic routines (as functions), which could be called from other procedures.
• Used Oracle forms to check if teh data was pushed to Banner correctly.
• Developed various Reports for teh end users as per their requirements and created many reports to suit pre-printed format of teh company.
• Writing stored procedures, Functions and Database triggers using PL/SQL.
• Used TOAD database development tool to interact with database.
• Participated in 24Hr Production support for our environments.
• Provided proactive support to application issues across production and non-production environments.

Environment: Oracle 10g/11g, PL/SQL Developer, SVN, Secure VPN, TOAD, Oracle Forms, Banner 8.x, Cast Iron