OBJECTIVE

• Pursuing a challenging career in Software Engineering demanding Database Design/Development/Optimization, Database Administration, Software Testing Automation with Thirteen+ years of Software Engineering Industrial Experience and a Master’s in Software Engineering.

SUMMARY

• 14+ years technical experience in developing Client/Server & Web applications using ORACLE
• Strong experience in back - end programming with Oracle PL/SQL, SQL.
• Strong work experience in UNIX environment.
• Working experience in MS SQLServer and MYSQL.
• Hands on experience in Hadoop File System.
• Working knowledge on Oracle 10g Forms and Reports.
• Proven experience in System Analysis, Database Design and developing Business Rules document based on user’s requirement.
• Developed Test Scripts and Test Case Documents for the projects involved.
• Extensive experience in using SQL Analytics.
• Working Knowledge on .NET, JAVA.
• Well conversant in translating business requirements into creation of database objects: tables, indexes, constraints, packages, stored procedures, functions, and triggers using Oracle PL/SQL tool.
• Extensive experience in Oracle 8i/9i/10g/11g/12c databases and PL/SQL 9i.
• Changed Oracle code wherever necessary and made necessary changes to improve the functions and filled the gaps.
• Used Toad development tools to speed up the development process.
• Experienced in mentoring team members on development and getting things done on time.
• 6+ Years of Health care industry.
• Experience in Dynamic SQL, Records, Arrays and Exception Handling .
• Excellent problem-solving techniques and involved communicating with clients and co-workers.
• Good communication and analytical skills.
• Track issues and fixes.
• Involved in Complete life cycle of projects.
• Software development life cycle experience in the Telecommunication, Engineering, Automobiles and Health Care.
• Proficient in Relational database theory & design; Knowledge of Object-orientation principles.
• Excellent skills in communication, problem solving and logical methodology work well in the team environment or leading a team. Self-motivated, quick learner, able to work well under tight deadlines and rapidly changing priorities

TECHNICAL SKILLS

Platforms: Windows 95/98/NT/2000/XP, UNIX (SunOS 5.7, Solaris 8, HP-UX), LINUX, DOS

Languages: SQL, PL/SQL, SQL*PLUS, C, Pro*C, J2EE/JavaScript, .NET, HTML 5.

Databases: Oracle 7.x/8.x/8i/9i/10g/11g/12c RAC, MySQL, MS SQLServer, MS Access

Application Servers: Apache HTTP Server, Internet Information Server (IIS 5.0)

Source Control Tools: Visual SourceSafe 6.0, PVCS (Version Control), Clear Case, Harvest, GIT

Development Tools: Oracle Enterprise Manager OEM, Tool for Oracle Application Developer (TOAD), PL/SQL Developer, SQL*Loader, Oracle Developer, PL/SQL Developer

Others: MS Office, REMEDY, HARVEST, Rational Clear Quest & Test Track Pro (Change Request Management), Object-oriented Modeling and Design for Database Applications

PROFESSIONAL EXPERIENCE

Confidentia

Software Engineer

Responsibilities:

• Requirements gathering for the projects.
• Sizing the work for each of the projects and prioritizing.
• Created procedures, functions, packages and triggers using Oracle PLSQL.
• Work on assigned defects.
• Used HP- Quality Center tool for defect tracking.
• Production Support.
• Performance Tuning on SQL Queries.
• Used Sub-Version as version control.
• Worked on Hadoop File System.
• Used Control-M to schedule batch processing jobs.
• Co-ordinate with deployment team during Production Deployment.
• Prepare Test documentation.

Environment: Oracle 11g/12C, Unix, SQL, PL/SQL, TOAD, Hadoop, HP-Quality Center. PowerBuilder 11.5

Confidential

Oracle DBA

Responsibilities:

• Created procedures, functions and views using MySQL.
• Responsible for creating install and upgrade scripts using MySQL for the Software.
• Used Oracle’s BugDB for defect tracking.
• Deployments done through Jenkins.
• Prepare Test and Release documentation.
• Used SVN for versioning.

Environment: MYSQL 6.3, Windows XP, Oracle Linux 6.7, JAVA 7, SNMP

Confidential

Sr. Oracle developer/Tester

Responsibilities:

• Development done using SQL and PLSQL scripts with Oracle 11g/12c RAC.
• Created database packages, procedures,tables,triggers using SQL and PLSQL.
• Created Simulators using MS SQLServer for Unit testing the functionality.
• Experience using Jira for defect tracking.
• Used GIT as version control.
• Followed AGILE Methodology.
• Prepared Unit test Documentation.
• Production Support.
• Created scripts using MYSQL for testing OPC Server(developed using LabView).

Environment: Oracle 11g/12c RAC, MS SQLServer 2012, MYSQL 5.0, Javascript, HTML 5, LabView2014

Confidential

Sr. Oracle developer/Tester

Responsibilities:

• Designed and developed database objects including PL/SQL Packages, Procedures, Functions, Triggers to enhance PDI Application based on Requirement documentation.
• Created back end code using PLSQL for 8 screens for the in house PDI
• Modified UNIX Shell Scripts according to the changing needs of the project and client requirements.
• Involved in the continuous enhancements and fixing of production support issues reported in Remedy.
• Co-ordinated with DBA's to create database objects for new enhancement in the application using TOAD.
• Involved in data loading using PL/SQL and SQL*Loader.

Environment: Oracle 11g (R2) Database Oracle Forms 10g, Unix, SQL, PL/SQL, TOAD

Confidential

Oracle Programmer/ Analyst

Responsibilities:

• The ability to store more detailed information about customers and their accounts.
• The ability to positively identify each person on an account when more that one person is listed.
• The ability to bill for non-energy products and services.
• Custom pricing abilities.
• Bills are mailed to valid addresses
• Extensively used of PL/SQL Stored Procedures, Functions, Form Triggers and Packages
• Developed web based front-end screens using Forms 6.0
• Creating SQL,, PL/SQL database objects.
• Written the Interface Stored Procedures for Data Transformation
• Used TOAD, PL/SQL developer tools for faster application design and developments
• Developed procedures using Dynamic SQL, UTL FILE.
• Involved in Testing (Both Unit and Integration Level) and Implementation.
• Tested the entire application in testing environment and exported to Production.
• Done the documentation and provided on-site production support.

Environment: Oracle 8i, Oracle Forms 6i, PL/SQL, SQL Plus, TOAD, Windows 2000 and UNIX