Sr. Oracle Plsql Developer Resume


SUMMARY


  • Around 5 years of IT Experience as Oracle Developer for System Analysis, Designing, Testing Development & Support of Oracle 9i, 10g, 11g & 12c, MS SQL 2005/2008 in Production, Staging, Development environments.
  • Experience in pharmacy, financial, insurance, health and telecom domain.
  • Expert in creating SQL Queries, PL/SQL package, function, stored procedure, triggers, and cursors.
  • Created database objects like tables, views, sequences, synonyms, indexes using Oracle tools like SQL*Plus, SQL Developer and Toad.
  • Created user interfaces with Oracle APEX interactive reports.
  • Modified the CGIs to generate dynamic content on web pages and web applications.
  • Developed application using JDBC, Servlets, SQL injection, CCS, jQuery, JavaScript, Bootstrap.
  • Created and modified Oracle forms and reports with Oracle Report Builder.
  • Proficient in advance features of Oracle 11g and 12c for PL/SQL programming like Using Records and Collections, Bulk Bind, Ref. Cursors, Varrays, Nested tables and Dynamic SQL.
  • Experience in SQL and PL/SQL tuning and query optimization tools like SQL Trace, TKPROF, Explain Plan, DBMS PROFILER.
  • Strong knowledge in Oracle utilities like SQL*Loader, Export/Import and Data Pump.
  • Extensively used package like DBMS STATS, UTL FILE, DBMS SCHEDULER and UTL MAIL.
  • Hands on experience with Crontab in UNIX environment for scheduling routine tasks.
  • Strong knowledge with PL/SQL Wrapper to protect the PL/SQL procedures or packages.
  • Extensively used Cubes & Rollups for making cross tabular reports.
  • Strong knowledge of Star Schema, Snow Flake Schema, Dimension and Fact table.
  • Expertise in handling errors using Exceptions.
  • Transferred data using data transfer tools like FTP (File Transfer Protocol) and SFTP (Smart FTP)
  • Exposure & knowledge of designing logical & physical Data Model in Relational Database Management System (RDBMS).
  • 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 and maintenance.
  • Documentation of projects for Functional Requirement Spec (FRS), Use Case Spec, ER - Diagram, Test Plan, Test Script & Test Cases.
  • Have worked in fast paced AGILE environment & attended daily scrum meeting.
  • Assisted QA Teams for bug testing, User Acceptance Testing (UAT) & System Integration Testing.
  • Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies.
  • Strong interpersonal and communication skills in dealing with customers.
  • Experience in Facets, Clarity & SOA Arch driven environment.

TECHNICAL SKILLS:


Operating System: LINUX, Sun Solaris 5.10/5.9/5.8, HP-UX 11i 3/11i 2, IBM AIX 5.2/5.3, Windows 7/XP/2000/98

Languages: SQL, PL/SQL, C, C++, UNIX Shell & PERL Scripting, Java Scripting, JAVA and .NET

Database:: Oracle 12C/11g/10g/9i, Netezza 6.0, MS SQL Server 2008/2005, Oracle Enterprise Manager (OEM) 12C/11g, Sybase 15.0.2

Database Tools: SQL*PLUS 11g, Putty beta 0.67, TOAD 12.0, MobaXterm 3.2, SQL Developer 4.1, Erwin 8, VI Editor, Oracle Apex 4.2.3, Data Stage 8.1, Oracle Forms & Reports 10g & 11g

Data Utilities: SQL Loader, Export/Import, Data pump, Explain Plan, Oracle Wrap

Reporting Tools: MS SQL 2008/2005, Oracle Forms & Reports 9i/10g, MicroStrategy, SAS, APEX, Clickview, BI/BO

Other Tools & Web Application: HTML 5, XML 1.0, Filezilla 3.23.0.2, WinSCP 5.1, JavaSE 7, CSS3, SVN 1.3, Notepad++ 7, Beyond Compare 3, Bootstrap

Automation Job/Batch Scheduling Tools: Control - M 7.0, Cybermation 2.0, Autosys 11.3, Cron Jobs, JAMS V6, Oracle Jobs

Quality Assurance: System Testing, Functional Testing, Unit Testing, System Integration Testing (SIT), User Acceptance Testing (UAT), Test Plan, Test Scripts and Test Cases

PM Tools: MS Project 2013, IBM RUP 7.5.1, Requisite Pro 7.1, HP Quality Center, Rally

Methodologies: SDLC & AGILE

Modeling Tools:: MS Visio 2010, MS Office 2010

PROFESSIONAL EXPERIENCE:

Confidential, Detroit, MI


Sr. Oracle PL/SQL Developer/ETL


Responsibilities:


  • Used the provided tech docs to create the code right thru.
  • Designed, created, implemented complex data flows for applications.
  • Created Dataflow diagram, Tech Spec, Dev Test Plan, Code Review Doc, and Prod Rollout Doc.
  • Actively involved in cross platform discussion with DA, DBA, Admins, Reporting, and Web teams, to resolve complex issue.
  • Created stored complex Procedures, Packages, Functions, Materialized Views, External Tables, DB Links, Tables, View, Synonyms, Indexes, Partitions and used triggers for security purposes.
  • Used Wrappers for data security which encrypts the PL/SQL code (hide the customer information).
  • Created the Temporary Tables thru stored procedure for different applications.
  • Loaded data from flat files into Database using SQL*loader.
  • Leveraged Unix framework for automating the execution process and handing the complex logic for generating and delivering the file as per the desired business needs.
  • Used the appropriate indexes, hints, partitions for Performance Tuning and enforced other PLSQL techniques like Bulk Collect/Bind, Set Based Operators.
  • Monitored indexes and analyzed their status for performance tuning and query optimization.
  • Designed and creates jobs in JAMS for scheduling complex data flows to integrate multiple processes.
  • Support apps for development, maintenance and enhancements to provide uninterrupted data.
  • Drill down to the Root Cause of the failure in the process and provide instant long term scale-able fix.
  • Handled various formats of file - XML, htlm, cvs, dat, txt as per the desired need.
  • Involved in Unit Testing, Integration Test and writing the Test plan.
  • Managed, Organized and Traced the progress of the Development and monitor dependent tasks of the team and do a follow-up to track and enforce deliverables in time.

Environment: Oracle 11g, Solaris 5.8, PL/SQL, SQL*PLUS 11g, TOAD 12.0, SQL Developer 4.1, OEM, HTML 5, MS Visio 2010, JAMS V6, SVN 1.3, Notepad++ 7, Beyond Compare 3, Putty Beta 0.67, Filezilla 3.23.0.2

Confidential, Southfield, MI


Oracle PLSQL/Performance Tuning Developer


Responsibilities:


  • Understanding the current requirement and existing environment in terms of data and architecture.
  • Involved in daily stand-ups with Scrum Master in the Agile environment.
  • Extensively worked on SQL & PLSQL procedure, function, packages to take care of ETL process run and managed thru Autosys jobs.
  • Modified, enhanced and developed complex Oracle Forms and Reports.
  • Used Oracle APEX to generate interactive reports to give access to the backend table.
  • Give support to DSS, DWH, Reporting and Analytics teams as and when required.
  • Involved in cross platform discussions and come up with technical suggestions and recommendation to drill down the issues which impacts multiple teams.
  • Working on connectivity between analytical tools like Spotfire with Hadoop cluster thru JDBC.
  • Working with Client's process teams in identifying and documenting necessary reporting requirements to build a reporting architecture.
  • Used advanced PLSQL concepts in Procedure, Package & Functions to move the data effectively as required in various ETL processes.
  • Tuned oracle processes build in PLSQL and drill down to the problem SQL and fixed them accordantly.
  • Suggested the solutions to the performance issues using techniques like Explain Plan and analyzing AWR Reports in coordination to DBA.
  • Responsible for the correct data modeling and successful transfer of data to data lake.
  • Used Vertica to build and working on validation tool for automated validation of source to target data.
  • Working on performance and load balancing scenarios and issues.

Environment: Oracle 12c, SQL Server 2008 - SSIS, SSRS & SSAS, UNIX, HDP 2.X, Big Data, Hive, Hbase, Spotfire, JQuery, HTML 5, CSS, JScript, Bootstrap, Oracle Forms and Reports 11.2, Oracle APEX 4.2

Confidential, Atlanta, GA

Oracle PLSQL/Performance Tuning


Responsibilities:


  • Used advanced PLSQL concepts in Procedure, Package & Functions to move the data effectively as required in various ETL processes.
  • Tuned oracle processes build in PLSQL and drill down to the problem SQL and fixed them accordantly.
  • Responsible for the correct data modeling and successful transfer of data to data lake
  • Working on performance and load balancing scenarios and issues
  • Understanding the current requirement and existing environment in terms of data and architecture.
  • Working as a Scrum Master in the Agile environment
  • Loading data and building the schemas in Hive
  • Working on Hbase on Hadoop cluster.
  • Suggested the Hadoop landscape and strategies to extract the data into HDP from SAP and Non SAP source systems like SQL Server, Custom Database, Vertica and Oracle.
  • Understanding the business challenges and translating them into requirements and developed the architecture for Analytics and Reporting Queries according to Business Requirements.
  • Involved in developing the roadmap for the Hadoop integration in the organizational landscape and fixing any open issues in order to stabilize both the environments before integration.
  • Working on Talend ETL packages and integrated it with the Hadoop platform.

Environment: Oracle 12c, SQL Server 2008 - SSIS, SSRS & SSAS, UNIX, HDP 2.X, Big Data, Hive, Hbase, Spotfire, DB Visualizer, Jquery, HTML 5, CSS, JScript, Bootstrap.

Confidential, Troy, MI


Lead Oracle PL/SQL Developer/Oracle Application Programmer


Responsibilities:


  • Technical assistance to user session to gather & implement requirements in agile environment.
  • Provide technical decisions as lead for deliverables for key projects.
  • Integrated and implemented enterprise MDM, business intelligence(BI) and DWH solutions.
  • Involved in projects to pull the required sources from EPIC and Clarity data to handle patient info.
  • Primarily worked in maintaining the data for backend table using SQL Queries, PL/SQL package, Function, Stored Procedure, and Cursors.
  • Extracted data from Oracle, SQL Server and Clarity using Informatica to load it into a single data warehouse repository.
  • Utilized features like Temporary Table, DB Links, M Views, External Tables, Bulk Collect/Bind, Partitions, Collection Methods, Pragma Autonomous Transaction and Dynamic SQL.
  • Performed SQL and PL/SQL tuning and Application tuning using EXPLAIN PLAN and assisted DBA with AWR Reports.
  • Handled errors using Exception Handling and Java Script validation extensively for the ease of debugging and hence directing user to provide suitable data.
  • Used Oracle HTP.P to deliver embedded HTML5, CSS3, Jquery and Java Script to present web content.
  • Generate UI mockups from paper-and-pencil concepts to actual technical prototypes that convey the interaction model.
  • Used bootstrap framework, CSS3, Jquery, Java Script and HTML5 for responsive website to enhance user experience for button and overall UI.
  • Created ER diagrams and multidimensional data models, reports and diagrams.
  • Applied data cleansing/masking techniques to ensure consistency amongst data sets.
  • Created relational and dimensional model for multiple applications.
  • Developed, managed and organized logical and physical data models using ER-Studio.

Environment: Oracle 11g 12c, IBM AIX 7.1, UNIX, TOAD 10.6, Erwin 8, ER-Studio, Oracle Report and Forms 10g & 11g, Oracle APEX 4.2.3, Jquery, HTML 5, CSS, Java Script, Bootstrap, Remedy, EPIC/Clarity.

Confidential, Grand Rapids, MI


Sr. Oracle PL/SQL Developer


Responsibilities:


  • Generated SQL and PL/SQL scripts to populate datamart on top of the ware house.
  • Wrote SP Transformation for oracle work flow in the ETL processes for ODI.
  • Enhanced & created DB objects like tables, views, sequences, synonyms, indexes.
  • Extensively worked on Nested Tables, Varrays and PL/SQL records.
  • Created Cursors and Ref Cursors to process the required data.
  • Used Bulk Collect and FOR ALL to DML multi-row from table.
  • Created interactive reports with constraints in APEX for users to manipulate the actual tables in DB.
  • Loaded data from various databases using SQL *LOADER utility.
  • Created UNIX shell scripts and scheduled Cron jobs.
  • Modified CGIs in Perl which flashes the processed data on Web.
  • Defined CSS scripts with custom classes and use them in HTML page to deliver on web.
  • Modified the APIs for JDBC connection scripts to pass the data set and invoke proc.
  • Hands on experience in using Integrated Development Environments like Eclipse.
  • Delivered Java Scripts to generate dynamic views thru HTML scripts.
  • Testing and debugging the existing Procedures, Packages and Reports.
  • Involved in Sprint planning for iterations in Agile environment.
  • Created interactive reports in APEX to provide direct access to the tables in DB.
  • Created Oracle Forms and Reports using repeating frame.
  • Assisted in documentation for DevTech Approach, UseCase Spec, Effort Estimation and Design Doc.
  • Created Oracle Forms and Reports, Stored Procs, Functions, and Packages as per the business need.
  • Created automated and manual scripts for satisfying the testing purpose.
  • Drill down the root cause of slow running processes & provided suitable performance technique.
  • Used Oracle packages - DBMS STATS, UTL FILE, DBMS SCHEDULER and UTL MAIL.
  • Wrote Dev Test Plan, Design Doc & Code Review Doc as part of project deliverable.
  • Exposure to Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
  • Worked and involved in projects implementing Facets and SOA Arch.

Environment: Oracle 11g 12c, IBM AIX 7.1, UNIX, MS Office Visio, TOAD 10.6, Putty Beta 0.63, Erwin 8, Oracle Report and Forms 10g & 11g, Oracle APEX 4.2.3, C++, Rally, Trizetto’s 4.7, WinSCP 5.1, Sybase 15.0.2, Sybase Central 4.1

Confidential, Collegeville, PA


Sr. Oracle PL/SQL & Vertica Developer


Responsibilities:


  • Modified and created tables, synonyms, sequences, views, stored procedures and triggers.
  • Compiled Dev Test Plan, Design & Code Review Docs as part of the deliverable to the SDLC artifacts.
  • Fixed performance issues and bugs with packages and stored procedures using DBMS PROFILER.
  • Performed Unit Testing and ensured all the exceptions are handled according to the business logic.
  • Developed complex join queries for Star Schema, Snow Flake Schema, Dimension and Fact table.
  • Created B-tree, Bitmap indexes, Partition table for enhancing the performance.
  • Used Hints and Generate Statistics command to enhance the performance.
  • Created effective ETL work flows using PLSQL objects in ODI.
  • Scrutinize performance of long running scripts Using AWR reports, Explain Plan, SQL Trace, TKPROF.
  • Wrote requirement for the Cybermation Batch Scheduling Process.
  • Used Datastage for simple to complex load to Master Data Management.
  • Wrote Unit Test Cases and Unit Test Scripts for Validated data from SAS to Oracle.
  • Created and modified complex Oracle Reports and Forms.
  • Loaded flat file using SQL*LOADER into database.
  • Used TOAD and Vertica for querying and debugging application.
  • Created and modified the file mover Perl Scripts.
  • Written Cursors and REF Cursors for transaction processing.
  • Implemented database triggers based on the business rules and requirements.
  • Wrote PL/SQL Rappers for maintaining data & code security.
  • Worked in Facets driven Environments.

Environment: UNIX, HP Vertica 7.1.0, Cybermation EST 5.1, Oracle 11g, SQL*Plus 9.2.0.0, Sun Solaris 5.8, Putty Beta 0.60, Oracle Forms and Reports 10g, HPQC, WinCVS 2.0, HTML, MS Visio 2005, Data Stage 8.1

Confidential, Wilmington, DE


Sr. Oracle PL/SQL Developer


Responsibilities:


  • Worked to load OLTP data into the Staging Area and Data Warehouse using transformation.
  • Made structural changes to database objects using Oracle tools like SQL*Plus and TOAD.
  • Leveraged enterprise MDM solutions to enhance the application features.
  • Wrote complex SQL queries, Sub queries and nested loops for faster data retrievals.
  • Extensively used cursors, sequences, indexes in the procedures according to the requirement.
  • Involved in Performance Tuning for the SQL, PL/SQL scripts.
  • Extensive Knowledge and working of Bulk Collect and Bulk Binding for data retrieval.
  • Used various Shell Scripts and Scheduled jobs on Crontab in UNIX environment on a routine basis.
  • Wrote complex Perl Scripts to handle pattern search for heavy data loads.
  • Modify and made tables for the loading of data from different sources using SQL*loader.
  • Used exception methods with PRAGMA EXCEPTION INIT to associate customized exception names.
  • Used SP transformation and designed data flows for the Datastage Application.
  • Handled XML Files for data loading purposes.
  • Used UTL FILE package for automated ETL processes.
  • Organized and managed routine jobs using packages like DBMS SCHEDULER to schedule tasks.
  • Involved in the designing of databases architecture and developed the ER Diagrams with ERWIN.

Environment: UNIX, Oracle 11g, PL/SQL, SQL*PLUS 9.2.0.3, SQL Developer 3.1, Toad 10.6, E, HP-UX 11i v3, IBM AIX 5.2/5.3, IBM RUP 7.5.1, HPQC, WinCVS 2.0, WinSCP 4.1, APEX, Data Stage 8.1, Sybase 11.5.1


Testimonials
best oracle training center in chennai "I did my oracle training in greens technology, Chennai. Now I got placed in Virtusa. I really thank Dinesh for his involvement in my training. His way of teaching is really awesome. I never saw such quality teaching and placements were so fast. Thanks a lot Greens Technologys for your support. I wish dinesh sir all the best for his new IT development venture."

oracle training classes in chennai "I thought I knew oracle until I took this course. My company sent me here against my will. It was definitely worth and I found out how many things I was doing wrong. Dinesh is awesome. but i got a lot inspired by you. I will keep in touch and will always try to learn from you as much as I can. Thanks once again Dinesh for the Best Oracle training !"


Oracle Placement Training in Chennai


Greens Technologys Overall Reviews


Greens Technologys Overall Reviews 5 out of 5 based on 17,981 ratings. 17,981 user reviews.
oracle training chennai """I think this is the best Oracle training course in chennai I have taken so far..Well I am still in the process of learning new things but for me this learning process has become so easy only after I joined this course in greens technologies..as Dinesh is very organized and up to the point.. he knows what he is teaching and makes his point very clear by explaining numerous times. I would definitely recommend anyone who has any passion for Oracle.." ""



Oracle Developer Roles and Responsibility





SQL and PLSQL Practice



Oracle Production Support Resume
Oracle plsql Developer Resume
Oracle plsql Developer Resume 1
Oracle plsql Developer Resume 2
Oracle plsql Developer Resume 3
Oracle plsql Developer Resume 4
Oracle plsql Developer Resume 5
Oracle plsql Developer Resume 6
Oracle plsql Developer Resume 7
Oracle plsql Developer Resume 8
Oracle plsql Developer Resume 9
Oracle ETL plsql resume
Oracle Plsql Developer Resume Profile
plsql ETL Resume
Senior Oracle plsql Resume
Sr.Oracle plsql Developer Resume
Sr.Oracle plsql Resume
Sr.Plsql Developer Resume
Oracle plsql Developer Resume
Oracle plsql Developer Resume