Oracle PL/SQL and UNIX Developer. Resume

SUMMARY:

6.1 years of strong work experience in Oracle/UNIX based support project which include analysis work, testing, enhancement and technical support.
6.1 years of strong development experience in shell script and Oracle
Good PLSQL tuning skills.
Experience in MARC - Warehouse Management System product and its functionality.
Strong Experience in leading team and have been working as Onsite-Offshore coordinator from March 2013.
Experience in Oracle development tools such as SQL Navigator, Oracle SQL Developer and SQL PLUS.
Experience in UNIX interface tools such as F-Secure SSH.
Direct interaction with client (US - Nike). Proven verbal and mailing skills.
Strong domain experience and knowledge in Retail-Warehouse which is an embedded part of the Supply chain management.
Experience in LOFTWARE - Printer management server and also have good experience in designing printing labels using design 32 software.
Knowledge in middleware (Integration) integration and host systems.

TECHNICAL SKILLS:

Database: Oracle 9i/10g, SQL Server, MySQL

Development/Productivity Tools: SQL Navigator, Oracle SQL Developer, SQL PLUSF - Secure SSH

ECom Frameworks/Web Technologies: .NET 2.0

Functional Areas: Retail - Warehouse Management and Operation

Other Application: MARC Application and Design 32

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

PROFESSIONAL EXPERIENCE:

Confidential

Oracle PL/SQL and UNIX Developer.

Environment: HP-Unix, Linux, Windows 2003, Windows 2008.

Responsibilities:

Member of Center of Excellence (COE) Team.
Have led 4 members offshore team.
Do possess strong experience in SQL and PLSQL development.
Responsible for PLSQL development and enhancements.
Responsible for UNIX shell script development and automation.
Have developed new packages, procedures, functions, plsql scripts based on client’s requirements making use of advanced PLSQL utilities and concepts, data loading tools, built-in packages, materialized views, etc.
Have tuned and enhanced existing packages, procedures and functions to meet the client’s performance needs and changing demands.
Have worked on various Proof of concepts to accomplish complex tasks.
Have automated reports which are of prime importance to the client’s business through shell scripts.
Have automated UNIX processes that are of prime importance to our WMS operations.
Responsible for monitoring batch jobs and application internal links.
Possess troubleshooting skills and have fixed data issues, bugs that arise during development.
Experience in ticket handling tools such as Kintana & Service Now
Have received recognition and accolades for developing PL SQL procedure that acknowledges the host on the receiving of the critical order interface files.
Responsible for cloning the development and testing instances (database refresh) of the database with production.
Do possess expertise in SQL Navigator (Oracle Development and querying), Oracle SQL Developer, F-Secure SSH tools etc.
Do possess knowledge about Middleware (Integration) systems, Autosys(Job scheduler) and interfaces which are an integral part of this WMS.
Responsible for carrying out Outage activity on development, test and production instances of windows and unix servers for patch applications and server upgrades.
Have worked on SQL-LOADER tool to load bulk data into oracle application tables.
Have worked on IMPORT/EXPORT tools for importing and exporting data especially during data refresh from production to development environments.
Have trained fresher in the Team and prepared training presentation materials for the project for future reference.
Offshore Point of Contact. Have been coordinating Team meetings with the onsite team on a daily basis.
Have been working as Onsite point of contact for offshore team and also co-ordinate works between onsite & offshore.
Have worked in organizing and driving big activity that happens yearly twice which are part of this WMS successfully without any issue.
Have worked in upgrading the Oracle 9i to Oracle 11g version project and have been involved in initial analysis part and Proof of Concept. I have done complete performance testing and unit testing.
Have worked in setting up the application server & report server for this WMS.
Have worked in designing WMS label using Design 23 tool.
Have quite good experience in handling critical situation. Have worked in working stopping issue so I know how to work during pressure time.
I have been very approachable to the entire team and have always helped my team effectively whenever required. I have been very flexible in my work timings according to the needs of the project.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship