Bhandari S

Sr Oracle PL/SQL Developer - AT&T

Dallas, TX

actayu@r.postjobfree.com - 646-***-****

• Over 7+ years of experience in analysis, design, development, and testing of business applications in OLTP, web based Client/Server architectures.

• Proficient in analyzing the end user requirements and converting them into efficient Technical Solutions.

• Expertise in SQL and PL/SQL programming, developing complex code units, database triggers and using the latest features to optimize performance.

• Strong Knowledge on oracle architecture and database design.

• Excellent conceptual knowledge of Oracle 9i/10g, PL/SQL.

• Experience in Database design using Normalization and E/R Diagrams.

• Extensive experience in database programming using SQL and PL/SQL following industry best practices.

• Expert in creating indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency.

• Strong knowledge in front end development using oracle forms/reports6i/9i/10g.

• Experience in developing forms based on views, tables and procedures in tabular and form layouts.

• Experienced in deploying Customizations, Extensions and Personalization's in Standard and Custom Built Oracle Forms, Self Service Pages (OA Pages), workflows, AME, etc.

• Extensively worked on System Administration responsibilities such as registration of concurrent programs, creation of Users, Responsibilities, Forms, Functions, Menus, Value sets and Flex fields in Oracle Applications

• Expertise in loading data from legacy systems using SQL*Loader.

• Experience in Database modeling and database object definitions using tools like Oracle Designer.

• Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL, PL/SQL and SQL Loader.

• Strong knowledge on OLAP components development.

• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.

• Experience in writing Technical design documents and developing unit test documents.

• Supported integration and end user testing with efficient defect management process.

• Worked in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities.

• Strong Analytical, Problem solving and communication skills.

• Extensively involved in communicating with the onsite users in resolving the issues and contributing my part of technical support to the team.

Willing to relocate: Anywhere

Authorized to work in the US for any employer

WORK EXPERIENCE

Sr Oracle PL/SQL Developer

AT&T - Dallas, TX - June 2015 to Present

Responsibilities:

• Collaborated with the Business analysts and DBA for requirements gathering, business analysis, testing, metrics and project coordination.

• Involved in Compass Decommission project to migrate from Sybase to Oracle.

• Involved in migrating Learning Management data from Sum Total to CornerStone.

• Developed Stored Procedures, Functions, Triggers, Packages and SQL Scripts using PL/SQL.

• Loaded the data into database tables using SQL*loader from text and excel files.

• Developed SMTP_MAIL procedures for automated email system.

• Developed data model, SQL Queries, SQL Query tuning process and Schemas.

• Created SQL*plus reports as per client's various needs, and developed business objects.

• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.

• Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.

• Developed Procedures for efficient error handling process by capturing errors into user managed tables.

• Developed reports for error reporting and send the error messages to legacy system owners.

• Developed batch scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Badging System and invalid data into error tables.

• Worked on production issues and modify code through code optimizations and indexes.

• Used SQL Developer and SQL*Plus for creating PL/SQL (trigger, sequence, stored procedure etc).

• Developed requirement and knowledge Documentation. Environment: Oracle 9i, 11g, PL/SQL, SQL Developer, SQL*loader, Batch Scripting PL/SQL Developer

JP Morgan Chase - Columbus, OH - March 2013 to May 2015 Responsibilities:

• Collaborated with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.

• Involved in logical modeling and physical modeling of application.

• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.

• Involved in creation of Conceptual Modeling covering all the business requirements.

• Loaded the data into database tables using SQL*loader from text and excel files.

• Developed data model, SQL Queries, SQL Query tuning process and Schemas.

• Created SQL*plus reports as per client's various needs, and developed business objects.

• Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.

• Maintain the Oracle 11g RAC environment and troubleshoot performance problems.

• Install & Manage Oracle Application server 11g cluster for Oracle forms & reports for high volume reporting applications.

• Developed SQL scripts, packages and procedures for Business rules check to implement business rules.

• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases. Oracle Developer

CA&L - Lawrence, KS - September 2011 to February 2013 Responsibilities:

• Involved in the Analysis, Design, Coding and Testing of the application.

• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.

• Created SQL*Loader control files for loading the data from flat files to staging area tables.

• Developed SQL scripts to create database objects like tables, views and sequences.

• Used SQL*Loader to load bulk data from various flat files.

• Developed SQL and PL/ SQL scripts for migration of data between databases.

• Designed and developed complex reports to meet end user requirements and deployed using Oracle Report 10g.

• Tune SQL statements using hints for maximum efficiency and performance, create and maintain/modify PL/ SQL packages, mentor others with the creation of complex SQL statements, perform data modeling and create/ maintain and modify complex database triggers and data migration scripts.

• Developed Forms, Menus, Object Libraries, and PL/SQL Library using Oracle Form Builder 6i.

• Developed complex triggers in reports before/after for validation of user input.

• Designed and developed user interfaces using Oracle Forms 10g.

• Involved in logical and physical database design, Identified Fact Tables, Transaction Tables.

• Proactively tuned SQL queries and performed refinement of the database design to leading significant improvement of system response time and efficiency.

• Involved in SQL tuning, PL/SQL tuning and Application tuning using various tools like TKPROF, EXPLAIN PLAN, DBMS_PROFILER, etc.

• Developed UNIX shell scripts in VI Editor with embedded SQL*Loader calls and PL/SQL statements to extract data from the legacy application in the form of flat files and load the extracted data into the new application.

• Created Bitmap indexes on low cardinality columns as they result in reduced response time for queries and substantial reduction of storage space.

• Design and development of conversions, interfaces, customizations, Custom Forms, Reports and all Technical design and solutions.

• Implemented Application Infrastructure policies, procedures and standards, and ensured their continual compliance.

Environment: Oracle 10g, SQL, PLSQL, SQL*Loader, UNIX Shell script, TOAD, Oracle Forms 10g, Reports10g.

Oracle Developer

Mayo Clinic - Rochester, MN - April 2010 to August 2011 Responsibilities:

• Developed views to facilitate easy interface implementation and enforce security on critical customer information.

• Knowledge of Normalization, and data transfer, documentation, preventive maintenance, code review, automation, store procedures and triggers etc.

• Performed exception handling for data that did not conform to the required format.

• Responsible for making the merged data in turn available to other clients.

• Wrote UNIX scripts to automate loading files into database using error handling and notification.

• Involved in implementing the data integrity validation checks through constraints and triggers.

• Involved in developing packages for implementing business logic through procedures and functions.

• Developed and modified procedures, functions, triggers, forms, reports and deployed the changes in the system.

• Developed user interfaces using Oracle Forms.

• Extensively involved in application tuning, SQL tuning, memory tuning and I/O tuning using Explain Plan and SQL trace facilities.

• Performance of the queries is enhanced by executing optimization techniques such as index creation, table partition and coding stored procedures.

• Responsible for creation of new users and setting up privileges and policies for protection of data.

• Used UTI_FILE PACKAGES for writing DBMS_OUTPUT messages to file.

• Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE and DBMS_SQLTUNE.

Environment: Oracle 9i, SQL, PLSQL, SQL*Loader, UNIX Shell script, TOAD, Oracle Forms 9i, Reports9i. Oracle PL/SQL Developer

XLhealth - Baltimore, MD - January 2009 to March 2010 Responsibilities:

• Gathered the requirements from the data analysts and architects and performed technical analysis to reach a viable solution.

• Designed database structures for effective data extraction, validation, run detail notification and error logging.

• Used and PL/SQL stored procedure for data conversion and interfaces processes.

• Designed and developed PL/SQL functions/ stored procedures/ cursors/ triggers/ packages.

• Performed several Automations written in Perl-DBI/DBD and UNIX Shell scripting in an Agile environment. SQL* Loader

• Used Perl to implement reports and new features in the Web GUI.

• Involved in writing complex/ad-hoc queries to generate reports as per client request as a part of production support.

• Involved in optimizing database performance by analyzing database objects, generating statistics, creating indexes, creating materialized views etc.

• Developed Unix Shell Scripts to automate backend jobs, loading data into the Database using SQL* Loader.

• Involved in fine tuning and optimization of different SQL queries to insure faster response time.

• Assisted in designing End User Layouts (EUL's) for Oracle Discoverer Reports based on the user/client requirements.

• Involved in Unit Testing and Performance Testing for reports.

• Used SQL Trace, Analyze, Explain Plan Utilities, and Hints to develop better SQL Queries.

• Worked as Production Support Developer to solve real time issues.

• Resolved Priority Production Support Issues and Defect Fixes. Environment: Oracle 7, Perl, UNIX, shell script, SQL*LOADER, TOAD, SQL*Loader, Toad. ADDITIONAL INFORMATION

TECHNICAL EXPERTISE:

RDBMS/Application Sever

Oracle 11g/10g/9i/8i/, Developer 11g/10g/9i/6i suite (Forms 10g/9i/6i, Reports 10g/9i/6i), Oracle Designer 2000/6i, Discoverer 9i SQL*PLUS, Server Manager/SQL*DBA, Export/Import, SQL*Loader, Erwin, Toad, Oracle Enterprise Manager

Languages SQL, PL/SQL, Unix shell scripting (Bourne shells) Operating System Oracle Enterprise Linux, Red hat Linux, Sun Solaris for SPARC 8.0/2.6, HP UNIX 10.2, IBM AIX 4.1, Windows-2000/NT/98/95, MS-DOS

Tuning Tools TKPROF, EXPLAIN PLAN, STATSPACK,

Languages and Web Technologies SQL, PL/SQL, Java, J2EE, Shell Scripting, XML, HTML/XHTML. Hardware SUN SPARC E5500, HP9000, IBM RS/6000, Dell Power Edge 6400, Intel x86, P-II/P-III/P-IV

Contact this candidate