PLSQL Developer

PROFESSIONAL SUMMARY

•Five years of extensive work experience with Oracle 11g, 12c

•One year experience with MS SQL Server

•Experience in all phases of Software Development Life Cycle (SDLC) such as Requirement gathering, Analysis, Development, Testing, Implementation and Support.

•Excellent knowledge of data warehousing concepts like star schema and snowflake schema, data marts used in relational and dimensional modeling

•Rich experience in ETL mappings, analysis and documentation of OLAP requirements.

•Hands on experience in writing, maintaining, testing and debugging codes

•Well-versed in UNIX scripts for executing various concurrent jobs and data migration and set Cron tab for repetitive database processes.

•Experienced in writing SQL queries, understanding requirements, writing functional specifications, writing test specifications and plans.

•Strong development and support knowledge on Oracle, SQL, PL/SQL programming and creating objects such as Stored procedures, packages, functions, triggers, tables, and views

•Rich experience in developing stored procedures using advanced PL/SQL Packages, Index-organized Tables, Collections, Record Types, and Dynamic SQL

•Solid experience in batch processing techniques: bulk collect, bulk bind, FORALL

•Expertise in Optimizing Database performance, Hints, Indexing, Materialized View, Partitioning, Parallel processing, pipelining, managing locking scenarios for multiple users.

•Expert in Performance Tuning, using various Oracle utilities, including Explain plan, hints, SQL_Trace, and DBMS_Profiler to identify bottlenecks and provide solutions

•Great experience in several Oracle provided packages such as UTL_FILE and DBMS_JOB

•Proficient in documenting business rules, functional and technical designs, test cases and user guides

•Excellent writing, presentation, documentation and communication skills

•Highly self-motivated and detail oriented with strong analytical and problem-solving skills and the tenacity to overcome technical challenges

SPECIALTIES, TECNOLOGIES and TOOLS

•DOMAIN: Finance, Insurance, Supply Chain

•TECHNOLOGIES AND TOOLS: Data Warehousing and OLTP systems, Software Testing, Data Validation, SQL, XML, Unix Shell Script, SQL Developer, PL/SQL Developer, TOAD, UNIX, SVN, SQL* PLUS, SQL*Loader, Excel, Salesforce, Beyond Compare, Notepad ++, Jira, Agile/Scrum etc.

EXPERIENCE

COMPANY: SALESFORCE, CA SQL DEVELOPER Dec 2020- Mar 2020

DESCRIPTION: Modularized Personal Engine and Dynamic Engine codes to improve technical performance, scalability and readability and restructured and refactored a set of 100 queries to be more performant; Incorporated new business logic about Sub Region and Company Size into current implementation.

RESPONSIBILITIES:

SQL Server query writing, tuning and performance optimization

Read and understand execution plans and make changes based on said plans

Stored procedure development and review

Index optimization and Performance monitoring

ETL and Data management

Data modeling and design

Data architecture and data analysis

COMPANY: UTICA NATIONAL INSURANCE, NY ORACLE PL/SQL DEVELOPER Mar 2019- Oct 2020

DESCRIPTION: Claim Processing System provides function to support much of the processing and management of customers’ insurance claims. It can handle or support the sharing of information and tracking of communications for business and strategy analysis.

RESPONSIBILITIES:

Responsible for analysis, design, development, and testing of the application.

Analyzed the data needs for customized reports.

Created and modified several views on tables which will be populating Warehouse system.

Involved in creation of aggregate materialized views on Data Warehousing.

Wrote complex queries and sub queries to do analysis work and generate reports to validate the results produced.

Extensively used advanced PL/SQL like Subtypes, Collections, Records, Tables, Object types and Dynamic SQL

Developed Unix Shell Scripts to automate backend jobs

Applied ETL methodologies including data extraction and loading with SQL Loader.

Performed Data Quality Analysis to reconcile and determine cleansing requirements.

Worked with Bulk Collects to improve the performance of multi-row queries

Participated in Functional Testing and Unit Testing.

COMPANY: APPLE, CA ORACLE PL/SQL DEVELOPER Jun 2017- Feb 2019

DESCRIPTION Developed and tested internal web-based timesheet system.

RESPONSIBILITIES:

Participated in design discussions of the desired applications

Suggested design changes for improving database performance and operational efficiency

Developed procedures, and functions to meet business needs

Worked with Python and java script developer to improve the entire process

Created table definitions, indexes, primary and foreign keys, constraints, triggers, functions, views, procedures and data to Oracle using SQL Developer.

Analyzed and designed tables based on small and large database transactions.

Optimized SQL queries tuning by analyzing different query options and indexing strategies.

Extensively worked on cursors and ref-cursors for processing the data.

Extensively used indexes for fine tuning and optimizing SQL and PL/SQL queries.

Developed MINUS process to load incremental internal data into database master table

Made use of WITH clause (CTE) to make complex SQL statements simple and more efficient

Extensively worked on PL/SQL Error/Exception handling.

Created and modified primary database objects, such as Triggers, Procedures, Functions, Packages and bulk collections using PL/SQL.

Developed PL/SQL Views and Materialized Views to enhance read operation.

Involved in performance tuning using HINTS, EXPLAIN PLAN.

Coded complex SQL queries to retrieve data from the database depending on the need

Worked with performance tuning tools like Oracle optimizer, explain plan, and hints

COMPANY: BNP PARIBAS RCC INC, NJ ORACLE PL/SQL DEVELOPER Jan 2017- Apr 2017

DESCRIPTION: Built and tested infrastructure for investment banking ALM Liquidity reporting standalone application.

RESPONSIBILITIES:

Participated in design discussions with the application architects and suggested design changes for improving database performance.

Was involved in all phases of application development: analysis, design, development, and testing.

Developed stored packages, procedures, and functions for data transformation

Designed and developed data loading processes using PL/SQL and UNIX Shell scripts.

Performed Gap Analysis for business requirement, proposed solution, implemented codes, and assisted testing process

Mapped data requirements developing Stored Procedures, Functions, Views, Materialized View and Triggers.

Extensively used MERGE INTO statements to transform data during data loading process

Wrote XML scripts to add parameters and create default view for reporting application

Extensively worked on Partitions and Sub-partitions and developed skills like: creating, truncating, dropping partition/sub-partitions, creating sub-partition template, exchange partitions etc.

Extensively used Dynamic SQL for data loading and reporting purpose

Supported production team by resolving production issue in a timely fashion

Prepared and installed master development scripts for unit testing, QA testing, and UAT testing.

Designed development lifecycle guideline

Documented Technical Specification and detailed data flow process for complicated business requirement.

COMPANY: KENDLE, OH ORACLE PL/SQL DEVELOPER 2015- 2016

DESCRIPTION: Our project focused on solution that reduce cycle time for customers and accelerate the delivery of life-enhancing drugs to market for the benefit of patients worldwide.

RESPONSIBILITIES:

Gathered business requirements

Creating database objects like tables, synonyms, sequences and views.

Created, edited procedures and functions to suite the improved business requirements

Created records and associative array in the procedures for handling of data

Used SQL Loader to load data into the database

Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data

Made use of Bulk Collect feature to process the data from cursor/ Ref Cursor

Used Dynamic SQL with Ref Cursor

Used set operators in PL/SQL like Union, Union all, Intersect and Minus

Performed exception handling for the procedures created

Created indexes for faster retrieval and improved query performance

COMPANY: DISTINGUISHED PROGRAMS, NY SALESFORCE ADMINISTRATOR 2011- 2015

Administrated and monitored the company’s Salesforce CRM application.

Was responsible for setting up new users and resetting user passwords.

Worked extensively on Accounts, Contacts, Leads, Opportunities, Activities, Reports, Dashboards, other standard objects and custom objects for additional fields, page layouts, record types, validation rules, alerts, lead mapping, territory management, account teams etc.

Created workflows, approval processes and developed validation rules.

Set up profiles, roles and implemented record-level and field-level security.

Uploaded/updated data with data loader.

Designed milestones/entitlements.

Involved in various minor enhancements to SFDC application required by business users.

Extensively used Excel for advanced Data Manipulation, Data Analysis and Data Visualization.

Strong experience and proficient in creating PowerPoint presentation.

Served as coordinator between developer and business users and assisted developer in minor update of coding issues involving integration with various other systems of parent company and newly acquired firms.

EDUCATION:

MBA, University at Buffalo, the State University of New York, US - 2011

Management of Information System, Central University of Finance and Economics, China - 2001

CFA (Chartered Financial Analyst) Level 1

CPCU Designation

ARM (Associate of Risk Management) Certificate

Contact this candidate