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