PlSQL_Developer

Sneha Yalawar

Mail: *************@*****.***

Mobile: +1-302-***-****

Summary

Having around 4.7 years of Experience in the areas of Oracle and PL/SQL based applications using Oracle PL/SQL and SQL Technologies.

Good knowledge on SQL * Loader and oracle Supplied Packages Like UTL_FILE, DBMS_SQL etc.

Good understanding of Basic UNIX / LINUX Commands

Excellent team player and proven track record working in various team sizes performing cross-functional roles

Knowledge in Oracle Architecture, Data Dictionary and DBMS Packages.

Substantial development experience in creating stored procedures, PL/SQL Packages, Triggers and Functions. Strong knowledge in Oracle cursor management and exception handling.

Experience in bulk collect, bulk bind operators and collections.

Involved Explain plan and investigate the performance issues.

Work experience on global temporary tables, Analytical Function, table functions, Hierarchical SQL queries, XML types, and pivot and unpivot operators.

Experience in Agile Delivery Methodology.

EXPERIENCE

Worked with Accenture As senior software analyst from Apr’15 to Nov’15.

Worked with Wipro Technology as junior consultant from Feb’12 to Aug ‘14.

Worked in Magna Infotech As Plsql Developer From Feb’11 to Jan ’12.

Worked in Metrofi online services as Database Engineer from Aug’10 to Jan ‘11.

TECHNICAL SKILLS

Languages : SQL, PL/SQL, UNIX shell scripting,

Databases : Oracle, MS Access, Mysql

Tools/Utilities : Sql * Loader, Reports6i, Putty, Toad, Sql developer, MS-Excel

O.S : Linux, UNIX MS-DOS, Windows 98/2000, Windows XP

PROJECTS

Project #

Client : Highmark Inc. USA.

Project : Product Sales and Client Services (PSCS) – AM.

Platforms : Oracle SQL Developer, UNIX, Harvest workbench, Clear Quest

Period : May 2015 – Nov 2015

Description:

Highmark is US based nonprofit Health Care Payer. Product Sales and Client Services(PSCS), mainly responsible for the Sales facing applications including Integrated Client Information System(ICIS), Eclipse, Product Management Development website, Rate Quote, Sales Management Information Systems and Sales Automation Workflow for HHIC. Also, centralized functions for the division will be managed from this area and will include Release Management responsibilities, Configuration Management, Security, Software Upgrades, and Budget and Reconciliation

Responsibilities:

Requirement analysis and working on Enhancement and Defects requests raised by business users.

Developing complex SQL queries and PL/SQL objects that include stored procedures, stored functions, packages, triggers etc.,

Working towards effort reduction by developing PL/SQL procedures to automate any data cleansing process respective to Change Records.

Prepared the test cases and performed the unit testing.

Involved in preparing the deployment and operational manual documents.

Providing incident management; accept the incidents raised by the business users, cleansing the data, reviewing the incidents fixed by peers and releasing for review by business

Project #

Client : FedEx Corporation

Project : FedEx _Ground

Platforms : Oracle SQL Developer, IBM AS/400, MS Excel, unix

Period : Aug 2013 – Aug 2014

Description:

FedEx delivery deals with delivering packages to residential. It has vehicle route plan for delivering the packages. When shipping a package to a customer's home, the recipient wants the package at their door at the time that works best for them i.e. we deliver the packages according to customer convenience. This is possible with day-definite evening and appointment delivery times. FedEx Home Delivery (FHD) serves to residential addresses only.

Responsibilities:

Collected User Requirements by participating in meetings and studying existing System.

Involved in writing Technical Specification Documentation.

Created E-R diagrams, Function Hierarchy diagrams, Process diagrams, Data Flow diagrams.

Involved in modifying various existing packages, procedures, functions and triggers according to the new business needs.

Involved in fixing the CPC issues remotely.

Used SQL LOADER to upload the information into the database.

Interacted with clients to understand their requirements.

Involved in resolving production problems for the applications and ensure all support service level agreement is met.

Project #

Client : NMC Hospitals, Abu Dhabi

Project : NMC

Platforms : Oracle SQL Developer, Microsoft SQL Server Management Studio

Period : Feb 2011 – Feb 2013

Responsibilities:

Database Migration (SQL Server to Oracle).

Developed Procedures, Functions, Packages in Oracle/SQL Server.

Converted close to 200 Procedures to PLSQL from SQL Server.

Requirement gathering from the Business Team.

Convert the functional requirements into technical document as per the business standards.

Worked as per the CR Raised from the end user.

Analyze the Existing code and do the impact analysis.

Created Database Objects like tables, Views, sequences, Synonyms, Stored Procedures, functions, Packages, Cursors, Ref Cursor and Triggers as per the Business requirements.

Used various set operators and pivot operator to retrieve data

Worked on Hierarchical sql queries and global temporary tables.

Involved in modifying various existing packages, Procedures, functions, triggers according to the new business needs

Wrote SQL Queries using Joins, Sub Queries and correlated sub Queries to retrieve data from the database

Involved in explain plan for query optimization.

Project #

Project : ETL (Extract Transferring Loading).

Platforms : Oracle 9i, SQL, SQLPLUS, VI, Linux, Shell Scripting, SQLLOADER

Period : Aug 2010 – Feb 2011

Description: Developed custom ETL Package for Reading employee’s data from flat file In to Staging tables Using Sqlloader and finally transferring data into the actual Table.

Technologies: Oracle 9i, SQL, SQLPLUS, VI, Linux, Shell Scripting, SQLLOADER.

Responsibilities:

Worked on various data sources like flat files, text files, Oracle, ms access databases

I was mainly responsible for resolving the issues in the data loading into main oracle Database from this process.

Sqlloader through data transfer to staging table and loading to the main table.

Create database objects like Tables, Views, Indexes, Procedures, Functions Etc

Resolve the issues in the various data sources.

Education/Certification

B.E (IT) From Jawaharlal Nehru Engineering College (Aurangabad) in the year of 2008.

Certifications : 1Z0-147 Oracle 9i: Program with PL/SQL

1Z0-007 Introduction to Oracle9i: SQL

Contact this candidate