PL/SQL Developer.

Puskar Garg

Santa Clara CA *****

Cell Phone: 469-***-****

Email: ac4b1x@r.postjobfree.com

PROFESSIONAL SUMMARY:

Over 7 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS) along with Unix shell scripting and Schedulers.

Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.

Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modelling and design techniques.

Expertise in Client-Server application development using Oracle 12c/11g/10g, PL/SQL, SQL*PLUS, and SQL*LOADER.

Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.

Strong experience in ETL.

Good knowledge on logical and physical Data Modelling using normalizing Techniques.

Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).

Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.

Developed materialized views for data replication in distributed environments.

Excellent technical and analytical skills with clear understanding of design goals of ER modelling for OLTP.

Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.

Loaded Data into Oracle Tables using SQL Loader.

Partitioned large Tables using range partition technique.

Experience with Oracle Supplied Packages such as DBMS_SQL,DBMS_JOB and UTL_FILE.

Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.

Worked extensively on Ref Cursor, External Tables and Collections.

Expertise in Dynamic SQL, Collections and Exception handling.

Experience in SQL performance tuning using Cost-Based Optimization (CBO).

Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.

Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS. Created Shell Scripts for invoking SQL scripts and scheduled them using Crontab.

Experience working with Waterfall and AGILE methodology. Have good understanding of project management tools SVN and Github.

Good knowledge of Splunk, deployments in Devops.

Have created tools for production which can help minimizing the risk of changes in production like SafeSQL (internal use).

Excellent interpersonal communication, analytical skills and have an ability to work in a team as well as independently.

Have Production support experience as well and knowledge of Service Now product for production issue tracking system.

EDUCATION

Bachelor Degree in Electronics and Communications, KEC, UPTU, INDIA

TECHNICAL SKILLS:

Databases

Oracle 12c, 11g, 10g (SQL, PL/SQL, Stored Procedures, Triggers)

Programming and Scripting

SQL, PL/SQL, Unix Shell Scripts, Java

Operating Systems

UNIX(LINUX, AIX), MAC OS X, Windows

Database Tools

SQL Developer, MY SQL Workbench

Other Tools

Autosys, Devops, Splunk

PROFESSIONAL EXPERIENCE:

Client: Apple Inc.

Project: eApproval March 2015 – Till now

Role: PL/SQL Developer (Technology Analyst)

Description:

An electronic approval application that handles the creation, routing and approval of electronic purchase requisitions, signature, and check requests. It is used to create, submit, and approve Purchase Requisitions, Expense Reports, Travel Requests, Signature Requests, and other forms required for badge access, security office postings, keys, and lock services.

Responsibilities:

Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.

Worked on SQL*Loader to load data from flat files obtained from various facilities every day.

Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.

Involved in the continuous enhancements and fixing of production problems.

Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.

Developed PL/SQL triggers and master tables for automatic creation of primary keys.

Created PL/SQL stored procedures, functions and packages for moving the data from staging area to different layers

Created scripts to create new tables, views, queries for new enhancement in the application.

Created indexes on the tables for faster retrieval of the data to enhance database performance.

Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.

Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.

Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.

Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.

Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.

Partitioned the fact tables and materialized views to enhance the performance.

Extensively used bulk collection in PL/SQL objects for improving the performing.

Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.

Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.

Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.

Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Environment: Oracle 12c/11g, Unix Shell Scripting, JAVA

Client: Apple Inc.

Project: CaffeMacs May 2014 – Feb 2015

Role: PL/SQL Developer (Technology Analyst)

Description:

An electronic approval application that handles the creation, routing and approval of electronic purchase requisitions, signature, and check requests. It is used to create, submit, and approve Purchase Requisitions, Expense Reports, Travel Requests, Signature Requests, and other forms required for badge access, security office postings, keys, and lock services.

Responsibilities:

Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.

Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.

Created and modified SQL*Plus, PL/SQL and SQL*Loader scripts for data conversions.

Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.

Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.

Designed Data Modeling, Design Specifications and to analyze Dependencies.

Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.

Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.

Created some Custom reports and Forms for the end users to check the details and errors.

Environment: Oracle 12c/11g, Unix Shell Scripting, JAVA

Client: Apple Inc.

Project: eCost Oct 2012 – APR 2014

Role: PL/SQL Developer (Technology Analyst)

Description:

Apple’s financial applications used for costing of Apple's commercial products like iPod, iPhone, iMac, etc. It enables user to see all the parts used in the product in the form of BOM with vendor and manufacturing site information and quantity used to form the product. User can optimize the finished goods cost of the product by analyzing these data based on which user can adjust or negotiate the cost or can create different configurations of the products.

Responsibilities:

Involved in various phases of Software Development Life Cycle (SDLC) of the application like Requirement gathering, Design, Analysis and Code development.

Followed Agile Methodology in analyse, define, and document the application which will support functional and business requirements. Coordinate these efforts with Functional Architects.

Worked on designing the system interfaces between multiple teams starting from designing to implementation using Shell scripts data processing and then loading to application base objects.

Developed and modified a number of Forms and for various modules. Also responsible for following up bugs reported by various users and suggesting possible patches to be applied.

Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.

Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from SQL server database to Oracle database.

Performed Database Administration of all database objects including tables, clusters, indexes, views, sequences packages and procedures.

Involved in Logical & Physical Database Layout Design.

Performance tuning of Oracle Databases and User applications.

Used SQL*Loader as an ETL tool to load data into the staging tables.

Provided user training and production support.

Improved the performance of the application by rewriting the SQL queries.

Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.

Used SVN for version control.

Environment: Oracle 11g, Unix Shell Scripting, JAVA, Objective C, COCOA Framework

Client: Apple Inc.

Project: Espresso Barista APR 2011 – Sep 2012

Role: UI Developer (System Engineer)

Descriptions:

Bug tracking system in Production used by all apple employees across the globe.

Responsibilities:

Involved in requirements gathering, developed the GUI, and wrote business logic code for client side implementation.

Worked in Agile software development environment for planning, estimation & developing and maintaining.

Developed code in Objective C using COCOA Framework.

Used MVC architecture for controller classes.

Coordinated with server side team on JSON parsing inputs and outputs.

Involved in Client Demos.

Managed code using SVN version control.

Worked on Post deployment warranty

Participate in daily project status meeting of the team for providing current status of my work and discussing future applications and issues, and requirements gathering.

Environment: Objective C, COCOA Framework.

Client: NA Oct 2010 – MAR 2011

Role: System Trainee

Description:

This is a focused training program on the basics of programming languages and tools to develop software and making aware about the Software Engineering and various phases of SDLC.

Responsibilities:

Learn various technologies such as C, C++, Oracle SQl, PL/SQL, Unix Shell scripting, Objectice C, COCOA Framework, HTML, CSS, Java, SDLC etc.

Contact this candidate