Sr. Oracle Pl/sql Developer Resume
New York, NY
PROFESSIONAL SUMMARY:
- Oracle PL/SQL Developer with around 9+ years of professional experience in Design, Development and Implementation of enterprise Oracle databases applications in both OLTP and Decision Support systems.
- Vast experience in BFSI, SCM, Pharma and Banking Regulatory Reporting domain.
- Expert in designing, developing, testing, and implementing PL/SQL triggers, cursors, stored procedures, packages, functions at database level and reporting level.
- Expertise in Data Modeling using ERWIN, Data mart and OLAP for business analysis using Star & Snowflake schemas for faster and effective querying.
- Experienced in Data Extraction, Transformation and Loading (ETL) processes using SQL Loader, PL/SQL procedures and Informatica PowerCenter.
- Adept at SQL and PL/SQL programming, developing complex code units, database triggers and using the latest features to optimize performance (Bulk Binds, Materialized views, Inline views, Global Temporary Tables).
- Extensive knowledge and understanding of Data Modeling concepts, UML diagrams and various types of Design Patterns.
- Involved in design, development, implementation, data migration, data conversion, testing and documentation of business applications using Oracle technologies.
- Proficient in Dynamic SQL, UNIX shell scripting, Performance Tuning and Query Optimization
- Expertise in Tuning Queries for better performance with large volume of data.
- Performed logical database backup and recovery using Oracle’s EXPORT/IMPORT.
- Adept in key Oracle performance - related features such as Query Optimizer, Execution Plans, Hints, Indexes, Clusters, Partitioning.
- Worked as ORACLE DBA at times.
- Experience in development of complex query reports according to user requirement using Oracle Reports.
- Quick learner with ability to master new concepts and applications.
- Experienced in, Documentation and Implementation in a business environment.
- Extensively experienced in interacting with business analysts and developers to analyze the user requirements, functional specifications and system specifications.
- Hands-on experience in developing Master Detail Forms, Query Find Forms, Multiple canvases using Oracle Forms.
- Performed various types of testing, such as functional, system, regression and user acceptance testing.
- Excellent communication, interpersonal, analytical skills and strong ability to perform as an individual or as part of a team.
BUSINESS/TECHNICAL SKILLS:
Oracle 12c/11g/10g/9i/8i, SQL, PL/SQL, TOAD for Oracle, PL/SQL Developer, SQL Navigator, Erwin Data Modeler, Microsoft VSS, Oracle Forms and Reports 10g/9i/6i, TFS, WinCVS, VersionOne Sprint tracking, XML, Unix Shell Scripts, Powershell scripting, Control-M, HP ALM 12.5, JIRA, Tortoise SVN, Tortoise Git, Jenkins, Confluence, Apache Impala, MS Office Suite, C, C++, Unix, Linux, Windows.
PROFESSIONAL EXPERIENCE:
Confidential, New York, NY
Sr. Oracle PL/SQL Developer
Responsibilities:
- Basel III and Basel IV regulatory reporting application development to bring and trade data from upstream and provide processed results to downstream applications
- On-site lead for BMR Data Mart application
- Requirement gathering and analysis along with application design to meet regulatory reporting expectations
- Document technical and business specifications on intranet Confluence pages
- High level data flow architecture design for big data migration
- Coordination with different teams for data and reporting related issues
- Technical and functional review for the new requirements with the business
- Database Performance tuning using different techniques including hints, partitioned tables and explain plans
- Participate and follow Agile Methodology practices such as Sprint Planning, scrums and coordinating with QA.
- Solution Development using Oracle SQL and PL/SQL by building different database objects including Stored Procedures, Functions, Packages, Views, Sequences, Ref Cursors and Collections
- Unix Shell scripting for batch scheduling and file transfers among different applications
- Application performance and data analysis
- On-site/Off-shore coordination
- Production support on business critical issues
Tools: and Technologies: Oracle 11g, PL/SQL, UNIX, Toad for Oracle v11.6, Control-M, HP ALM 12.5, JIRA, Tortoise SVN, Tortoise Git, Jenkins, Confluence, Apache Impala
Confidential, Morristown, NJ
Sr. Oracle PL/SQL Developer
Responsibilities:
- FDA Transparency reporting application development to present accurate spending information by clients on Health Care Practitioners (HCPs) which comes via CSVs and provide processed results to users for reporting
- Requirement gathering and analysis along with application design to meet regulatory expectations
- Coordination with users and business for data and reporting related issues
- Technical and functional review for the new requirements with the business
- Database Performance tuning using different techniques including hints and explain plans
- Solution Development using Oracle SQL and PL/SQL by building different database objects including Stored Procedures, Functions, Packages, Views, Sequences, Ref Cursors and Collections
- Powershell scripting for scheduling file processing
- Application performance and data analysis
- Production support on business critical issues
Tools: and Technologies: Oracle 12c, PL/SQL, Powershell, Toad for Oracle v11.6, Job Scheduler, Confluence, JIRA, TFS
Confidential, New York, NY
Sr. Oracle PL/SQL Developer/Data Tech Lead
Responsibilities:
- Interacting with end users to gather requirements for features and enhancements which involves building a web-based global analytical tool that allows Credit Rating Analysts at S&P to generate committee packages efficiently for reviews, demonstrate the link between criteria and analysis, work in collaborative manner.
- Solution Development using Oracle SQL and PL/SQL by building different database objects including Stored Procedures, Functions, Packages, Views, Triggers, Sequences, Ref Cursors and Collections.
- Performance Tuning of PL/SQL objects and Views using Indexes and Explain Plan.
- Resolution of defects and incidents raised by end users and client.
- Database Objects’ Migration and movement to different environments along with Production rollout activities.
- Generating XML parsing data from database for Publishing environment using DBMS XMLGEN package.
- Actively participate and follow Agile Methodology practices such as Sprint Planning, coordinating with QA testing and Product owner acceptance.
- Participating in Story sizing and effort estimation sessions and providing inputs.
- Coordinating with offshore team for on-time and quality deliverables.
- Responsible for coordination with the teams whose applications are integrated with the application under development.
- Coordinate with Product owners for user management related issues.
- Communicate with project managers the progress of application development; generate application performance and user usage reports for analysis done by senior management; work with other developers and infrastructure resources.
- Responsible for producing technical documentations and test case documents.
Tools: and Technologies: Oracle 10g/11g, PL/SQL, Erwin, Toad for Oracle v11.6, HP Quality Center v10, XML, VersionOne Sprint Tracking, WinCVS.
Confidential, Somerset, NJ
Sr. Oracle Developer
Responsibilities:
- Gathered the requirements and documented high level documentation for the project.
- Involved in the business requirements gathering and analysis, understanding client’s Data Warehousing requirements and system analysis.
- Designed Logical data model and Physical conceptual data model using Erwin.
- Performed database design, tuning using Oracle Job Scheduler, Oracle Advanced Queuing.
- Applying constraints and writing triggers to apply the business rules.
- Involved in handling Errors and Transaction Processing in the Procedures.
- Created Records, Tables, Objects, Collections (Nested Tables and Arrays), and Error Handling.
- Performed Data Migration using SQL* Loader from flat files into database tables.
- Extensively involved in Writing PL/SQL Stored Procedures, Triggers, Functions, and Packages to meet the business requirements.
- Created custom partition tables for reporting.
- Responsible for SQL tuning using explain plan and optimizer hints.
- Used Ref-cursors and Collections for accessing complex data resulted from joining of large number of tables.
- Handled exceptions for the ease of debugging and displaying the error messages in the application.
- Performed code reviews and acceptance testing of the application.
Tools: and Technologies: Oracle 10g/11g, Oracle Forms 10g, Oracle Reports 10g, PL/SQL, Erwin, UNIX, Shell scripting, SQL*Loader, Oracle SQL Navigator, Toad for Oracle.