We provide IT Staff Augmentation Services!

Sql Developer Resume Profile

Profile Summary:

  • 10 years of IT Experience as Oracle Developer for System Analysis, Designing, Testing Development Support of Oracle 9i, 10g 11g in Production, Staging, Development environments.
  • Strong experience in key concepts, such as PL SQL Triggers, Procedures, Functions, Cursors, Pipe Row functions.
  • Have worked in fast paced AGILE environment attended daily scrum meeting.
  • Performed performance tuning services for PL/SQL applications.
  • Fine tuned long running pivot/un pivot queries converted them into pipe row functions to avoid huge temporary table space usage. Fine-tuned long running merge queries, reduced timing from hours to minutes.
  • Created database objects like tables, views, sequences, synonyms, indexes using Oracle tools like SQL Plus , SQL Developer, Toad and Oracle MERGE statements, External Tables.
  • Proficient in advance features of Oracle 11g for PL/SQL programming like Using Records and Collections, Bulk Bind, Ref. Cursors, Nested tables and Dynamic SQL.
  • Experienced working with Oracle PL/SQL Functions, Sequences, Indexes, Views, Table Partitioning, Collections, Analytical functions, Materialized Views.
  • Strong knowledge in Oracle utilities like SQL Loader, Export/Import and data pump utilities like EXPDP/IMPDP.
  • Strong knowledge with PL/SQL Wrapper to protect the PL/SQL procedures or packages.
  • Experience in SQL and PL/SQL tuning and query optimization tools like Explain Plan.
  • Making structural changes to the database objects.
  • Exposure knowledge of designing logical physical Data Model in Relational Database Management System.
  • Experience in working high-transacted OLTP systems.
  • Extensive experience with all phases of the Software Development Life Cycle including analysis, Resource Planning, code development, testing, implementing, maintenance, production and operation support.
  • Assisted QA Teams for bug testing, User Acceptance Testing UAT System Integration Testing.
  • Experience in Reports Development and Data Migration from CSV to Oracle Database using SQL Loader through scheduled batch operations.
  • Deep knowledge of System and database architecture: design, modeling and implementation.
  • Ability to write and revise system and operation documentation for complex new and existing programs and systems in accordance with Company and client standards.
  • Proficient problem-solver who envisions business and technical perspectives to develop workable solutions.
  • Good team player and capable of working individually with less supervision.
  • Strong analytical, problem solving organizational abilities.
  • Experience in SQL tuning of medium/large database environments.
  • Fully trained in SIX SIGMA Methodology and Lean Sigma, tools and techniques. Equipped to lead a process improvement project.
  • Good communication and Interpersonal skills, self-motivated, quick learner, team player and Passion for performing challenging tasks, drive to achieve high performance.

Technical Skill Set:

  • RDBMS: Oracle 9i, 10g 11g, MYSQL, Sybase, SQL Server 2005/7.0/6.5, MS -Access
  • Tools Framework: Erwin Data Modeler, TOAD 11.5, PL/SQL Developer, SQL Plus, Eclipse, iReport2.0, Oracle SQL Developer 3.1, DB Visualizer 8.0, Oracle Developer Suites 10g.
  • Programming Languages: SQL, PL/SQL, T-SQL, Core Java, Unix Shell Scripting, JSP/Servlets, VB
  • Mark-up/ Scripting Language: AJAX, JQuery, JSON, JavaScript, HTML 5.0, CSS, XML, XSLT.
  • XML Technologies: XSL/XSLT, SAX/DOM, XPath, DTD, Schema
  • Version/Source Control Systems: CVS, SVN Subversion , Visual SourceSafe VSS , Serena Dimension.
  • IDE: Eclipse 3.x, MyEclipse, Net Beans
  • Application/Web Servers: Tomcat, IBM WebSphere, Weblogic.
  • O/S Environment: Windows 8/7/Vista/XP, UNIX, Linux.
  • Other Tools: Quality Center, SNOW, Test Director.

Professional Experience:

Confidential

Designation: Senior Oracle PL/SQL Developer

Responsibilities:

  • Involved in understanding the requirements from Business and documented Design and technical specification documents
  • Involved in communication with Business, Business BT partners, Offshore Team and Shared Services Stakeholders
  • Planning, Scheduling , Managing and assigning tasks to offshore teams
  • Involved in writing complex stored procedures, functions and triggers as per business need and review the code
  • Responsible to prioritize the activities and delivery
  • Involved in design phase during major enhancement in Clinical Applications and create diagram using Erwin.
  • Mentoring team
  • Responsible for unit testing, integration testing and system testing the application and conducted demos to client
  • Involved in verifying and monitoring DB from Unix via command and shell scripts

Environment: SQL/PLSQL, Oracle 11g, TOAD, SharePoint, Putty, Java, COTs Products, Unix

Confidential

Designation: Senior Oracle PL/SQL Developer

Responsibilities:

  • Involved in Requirement Gathering, Impact Analysis, Design and effort estimation.
  • Involved in writing complex stored procedures to validate the data and code review
  • Involved in test case preparation and validation scripts
  • Involved in data mapping activity as per Business need
  • Planning, Scheduling , Managing and assigning tasks to offshore teams
  • Mentoring the team
  • Involved unit testing, system testing and user acceptance testing.
  • Involved in status reporting, project management and interacting with multiple shared service teams.
  • Involved in verifying and monitoring DB from Unix via command and shell scripts
  • Involved in knowledge transition.

Environment: SQL/PLSQL, Oracle 10g, TOAD, Java, J2EE, Servlets, JSP, Java Script, XML, .Net, Cognos, Serena Dimensions, Weblogic Server, Documentum, Unix

Confidential

Designation: Senior Oracle PL/SQL Developer

Responsibilities:

  • Involved in all development, support and maintenance activities
  • Planning, Scheduling , Managing and assigning tasks to offshore teams
  • Involved in Requirement Gathering, Impact Analysis, Design and effort estimation.
  • Responsible to prioritize the activities and delivery
  • Tune the existing procedures to minimize the execution time during nightly batch job and written complex SQL for Adhoc report requests.
  • Actively involved in writing complex stored procedures to validate the data and code review
  • Mentoring the team
  • Involved in status reporting, project management and interacting with multiple shared service teams.
  • Involved in verifying and monitoring DB from Unix via command and shell scripts
  • Involved in knowledge transition, creation and execution of training plan for new team members.

Environment: Oracle 10g, SQL, PLSQL, Struts, JSP, Servlets, HTML, XML, Java scripting, COGNOS, Unix

Confidential

Designation: Oracle PL/SQL Developer

Responsibilities:

  • Active involvement in analysis of production requirements and problems and preparing solution approach documents.
  • Involved in development of solution for the production problem with detailed testing and test cases.
  • Involved in impact analysis of data fix and provide necessary solution if required.
  • Involved in writing complex stored procedures and tuning SQL queries.
  • Maintain the defect log and status reporting.
  • Involved in verifying and monitoring DB from Unix via command and shell scripts

Environment: Oracle 10g, TOAD, Informatica Power Center, CVS, Quality Center, SNOW, Java, Web Sphere Server, Unix

Confidential

Designation: Oracle PL/SQL Developer

Responsibilities:

  • Involved in PL/SQL programming like Packages, Functions and Procedures for reports.
  • Involved in Jasper Report design and bug fixing.
  • Involved in bug fixing related to Packages, Procedures and Functions.
  • Involved in preparation Analysis and Quality Documents for Reports.
  • Involved in code review, Unit Testing, CIT and SIT.
  • Involved in other activities like, build process.
  • Managed a team.
  • Involved in verifying and monitoring DB from Unix via command and shell scripts

Environment: Oracle 10g, TOAD, Informatica Power Center, CVS, Quality Center, SNOW, Java, Web Sphere Server, Unix

Confidential

Designation: Microsoft SQL Developer

Responsibilities:

  • Communicate with client for enhancements, new requirements and provide effective solutions.
  • Developed procedures, functions in MS SQL Server 2005.
  • Involved in PL/SQL programming like Functions, Procedures and making reports.
  • Wrote complex database queries in T-SQL to fulfill the requirements.

Environment: MS SQL Server 2005, Visual Source safe 6.0, Reporting Services

Confidential

Designation: Oracle PL/SQL Developer

Responsibilities:

  • Liaison with users for enhancements and new requirements.
  • Enhanced and coded new functionality of existing Oracle 9i.
  • All coding was done with PL/SQL on an Oracle 9i database.
  • Wrote complex stored procedures in PL/SQL to be called by Visual Basic and batch processes.
  • Performed Unit testing of the PL/SQL code.

Environment: Oracle 9i, PLSQL Developer, Visual Source safe 6.0, Crystal Reports, VB

Confidential

Designation: Oracle PL/SQL Developer

Responsibilities:

Designed and developed Oracle PL/SQL stored package, procedures, functions and database triggers.

Involved in PL/SQL programming like Functions, Procedures and Triggers.

Wrote complex database queries in SQL to be called by Crystal reports.

Performed Unit testing of the PL/SQL code.

Environment: Oracle 9i, PLSQL Developer, Visual Source safe 6.0, Crystal Reports, VB

Hire Now