PROFESSIONAL SUMMARY:

• Working as a Consultant in the current organization with around 7.10 years of IT experience as an Application Developer using SQL, PL/SQL, UNIX technologies.
• Hands on Experience on PL/SQL, Shell scripts Development.
• Hands on experience on application development and deployments.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

SKILLS PROFILE:

Operating System: Windows XP/2003/Seven and Unix.

Environment: Oracle, Unix.

Database: Oracle, Microsoft SQL Server.

Internet Tools: HTML, JSP.

Languages: SQL, PL/SQL, Unix, Shell Scripting.

Other: Oracle PL/SQL Developer, TOAD, Putty, Pivotal Tracker, JIRA, GIT, HP - ALM, BMC Remedy Tool, SQL*Plus, SQL*Loader, Finacle Software

PROFESSIONAL EXPERIENCE:

Confidential

Senior PLSQL Developer

Responsibilities:

• Participate in project planning and analyze Business Requirements.
• We used to follow Kanban methodology.
• Daily meeting and discussions and update the stories in JIRA.
• Involved in Analysis, Design and Development of application.
• Creating and deploying the Release Bundle for every Sprint.
• Creating the Program specs and Release Notes/Instructions.
• Performance tuning, internal code reviews and defect fixing.
• Production release support.

Environment: Oracle, PL/SQL Developer, Unix, Putty, Pivotal Tracker, GIT, HP-ALM

Consultant

Senior Oracle Developer

Responsibilities:

• Participate in project planning sessions with Supervisors, other team members and Onshore Client team members.
• We used to follow Agile methodology.
• Involved in Analysis, Design and Development of application.
• Creating and deploying the Release Bundle for every Sprint.
• Analysis on the existing projects to leverage to fulfil the current requirement and making sure exisitng applications will not be impacted.
• Performance tuning, internal code reviews and defect fixing.
• Stage and Production release support.

Environment: Oracle, PL/SQL Developer, Unix, Putty, Pivotal Tracker, GIT, HP-ALM

Confidential

Oracle Developer

Responsibilities:

• Attending Meetings with Client team members to analyze Business Requirements and translate it into working software.
• We used to follow Agile methodology.
• Involved in Analysis, Design, Development and Performance tuning of application.
• Creating and deploying the Release Bundle for every Sprint.
• Creating the Program specs and Release Notes/Instructions.
• Defect fixing.
• Deployment in lower environments.

Environment: Oracle, PL/SQL Developer, Unix, Putty, Pivotal Tracker

Confidential

Oracle Developer

Responsibilities:

• Participate in project planning sessions with Supervisors, other team members and Onsite/Offshore Client team members to analyze Business Requirements and translate it into working software.
• We used to follow Agile methodology.
• Daily meeting and discussions and update the stories in the Pivotal Tracker.
• Involved in Analysis, Design and Development of application.
• Creating and deploying the Release Bundle for every Sprint.
• Creating the Program specs and Release Notes/Instructions.
• Analysis on the existing projects to leverage to fulfil the current requirement and making sure exisitng applications will not be impacted.
• Performance tuning.
• Internal code reviews.
• Defect fixing.
• Stage and Production release support.

Environment: Oracle, PL/SQL Developer, Unix, Putty, Pivotal Tracker

System Analyst

Confidential

Responsibilities:

• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Client-Server application development using Oracle 11g/10g, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
• Loaded Data into Oracle Tables using SQL Loader.
• Experience in SQL performance tuning
• Create and maintain a unified, multi-tiered reporting system to replace ad-hoc individual reports. Create and maintain essential business systems on corporate intranet.
• Designed and created database tables, views and stored procedures.
• Built and maintained SQL scripts, indexes, reports and queries for data analysis and extraction.

Environment: Oracle, PL/SQL Developer, Unix, SQL*Loader, Putty, JIRA, Filezilla

Software Developer

Confidential

Responsibilities:

• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to Central Server.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Performed SQL and PL/SQL tuning.
• Worked with business users and application developers to identify business needs and provide solutions.
• Created many report scripts as per the Business requirement.

Environment: Oracle, Unix, PL/SQL Developer, Toad, SQL*Loader, Putty, Citrix, Filezilla, Teradata Sql Assistant, BI SAS Reports, BMC Remedy, BSCS, Cognos Reporting Tool.

Software Engineer

Confidential

Responsibilities:

• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Created PL/SQL scripts.
• Maintained documentation for technical systems.
• Maintaining Shell Scripts for invoking SQL scripts and scheduled them using crontab.
• Extracting data from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
• Involved in the continuous enhancements and fixing of production problems.

Environment: TOAD, Putty, SQL*Plus, SQL*Loader, Ftp, Finacle Software, HP Open view.