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.