SHEFALI JAIN

Oracle PL/SQL Developer

203-***-****

ac0hs0@r.postjobfree.com

SUMMARY:

• 5 years’ experience as an Oracle PL/SQL Developer in the analysis, design and implementation of business applications using the Oracle Relational Database Management System (RDBMS).

• 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 modeling and design techniques.

• Expertise in client-server application development using Oracle 12c/11g/10g/9i/8i, PL/SQL, SQL*PLUS, TOAD and SQL*LOADER.

• Developed complex database objects like stored procedures, functions, packages and triggers using SQL and PL/SQL.

• Hands on experience in data conversion, data migration, report generation, and developing interfaces within different modules.

• Experience in dynamic SQL, records and PL/SQL Tables

• Technically proficient in XML/BI Publisher reports, Crystal Reports, RICE components, SQL, PL/SQL, shell scripts, Core Java, JSP, ETL, workflows, Oracle Applications Framework (OAF) pages customization and personalization.

• Experience in ETL techniques, analysis, and reporting using ETL tool such as ODI.

• Experience in importing data from legacy systems to Oracle applications using interfaces, SQL*LOADER, UTL_FILE, standard packaged APIs etc.

• Imparted various corporate trainings related to SQL, PL/SQL, Oracle Apps tools and technologies.

• Familiar with JIRA ticketing application and used Serena VCS, TFS for version control.

•Excellent handling experience of logged Service Requests (SR’s).

• Consistently rated amongst top 20% employees (Top Talent) within the Syntel organization across globe (NYSE listed and ~ 20,000 employees) with numerous performance linked awards.

• Strong expertise in client relationship management, conceptualization of business needs and translation into viable technical solutions.

• Good interpersonal and communication skills, dedicated, result oriented with enthusiasm to learn new technologies, capable of working independently and a great team player.

• Skilled at learning new concepts quickly, thriving under pressure, and communicating ideas in lucid and effective manner.

PROFESSIONAL EXPERIENCE:

TRITON INTERNATIONAL - Purchase, NY July 2016 to Present

Software Engineer II

TAL International Group, Inc. and Triton Container International Limited merger created the world’s largest and most efficient intermodal container leasing company with a container fleet of approximately 4.8 million TEU, resulting in industry cost leadership and an enhanced container supply capability.

•Responsible for ensuring correctness of migrated data from TAL system (TERMS) to Triton system (Trifleet).

• Worked in close liaison with TAL and Triton users.

• Ensured smooth migration and business process implementation through frequent visits to Lexington, KY (onsite).

•Developed Advance billing true up program to true up advance billing differences saving millions of dollars.

• Responsible for migration of Finance and Rental lease contracts and customers.

• Ensured correct billing of the migrated assets.

•Designed and developed AR and AP Interfaces from Trifleet to PeopleSoft.

Technology: Oracle PL/SQL, Java, JIRA ticketing, IntelliJ Idea, Janus, Crystal Reports, TeamCity, Agile methodology, Groovy, Grails

TAL INTERNATIONAL - Purchase, NY June 2015 to July 2016

Application Developer

TAL International is one of the world's oldest and largest lessors of intermodal freight containers. They serve virtually every major shipping line in the world. They have an in-house IT dept. which has developed very efficient systems for billing, leasing and tracking of the containers.

•Responsible for day to day interactions with users for requirement gathering, status updates regarding ongoing developments and discussions about new development.

• Understanding Business requirements and interpreting them into viable technical solutions

• Purchase Accounting, EDS Tax, Trader Depreciation data conversion and interfaces.

• Customizations in REFI Structured Finance system according to user requirements.

Involved in continuous enhancements and fixing of production problems.

•Created reports related to billing, customer, depreciation and tax based on user requirements.

• Developed EDS Day1 module which helps in generation of P&L reports on day1 of the month.

• Documented Functional and Technical requirements.

• Followed agile methodology for meeting the delivery timelines and keeping the project on track.

Technology: Oracle PL/SQL, batch programming, C#, Java, Crystal Reports, Visual Studio 2013/GIT, TFS, Control M

SYNTEL LTD; Pune, India Jan 2012 to Sep 2014

Senior Software Engineer

Humana Oracle PDH:

Humana is a leading healthcare insurance providing organization headquartered in Louisville, KY that deals in selling insurance plans across the US. This project deals with implementation of Oracle PDH (Product Data Hub) by having a central repository of all the plans and benefits. We incorporated business rules by interacting with various third party applications (WODM, PBP feed system, etc.) with the help of web services and Oracle Integration Repository.

Technology: Oracle Apps, Oracle PDH, XML publisher, SQL, PL/SQL, Core Java, JSP, Agile methodology

Gates Corporation:

•Gates North America - Old Reports (12.1.3): Converted RDF reports to XML Publisher reports saving $140 million of client’s expenses for custom formatting tools like Optio.

•Gates China iStore (11.5.9): This project involved iStore module implementation at Gates China, with the scope and requirement to develop new custom forms, JSP pages, custom Pl/SQL code to achieve the business requirement along with new reports development and business logic enhancements.

•Oracle Applications upgrade project from Oracle E-Business Suite 11.5.9 to R12.1.3 for the Financials, Supply Chain and Logistics areas of the Gates USA, Mexico and Canada regions. Focused on new development, customization of AP checks, EFTs, Oracle Forms, Reports, PLSQL procedures, functions and packages, OAF pages, migration automation shell scripts.

•Gates WMS Oracle project involved upgrade from Oracle MSCA (Mobile Supply Chain Application) 11.5.9 to R12.1.3 for Gates USA, Mexico and Canada regions. It included new development of Custom mobile screens in Oracle MSCA framework along with personalization and customization of Out Of The Box (OOTB) – Sub - Inventory, LPN and Label screens.

Technology: Oracle Apps, Oracle Forms, Oracle Reports, SQL, PLSQL, XML Publisher, Oracle Workflow, OAF Framework, UNIX/Shell scripts, Core Java, JSP, Oracle MSCA (Mobile Supply Chain Application)

Golfsmith:

This was an Implementation project for R12.1.2 from 11.0.1 including Modules like Inventory, OM, PIM, AP, AR, CM etc. Golfsmith is a Golf retailer in USA, Canada and UK. It involved Performance tuning, XML BI Publisher reports creation, PIM customizations, RICE components development and SQL*Loader scripts for data conversions

Technology: Oracle Apps, Oracle Forms, Oracle Reports, Oracle PIM, SQL, PLSQL, XML Publisher, UNIX/shell scripts.

EDUCATION:

•Master of Business Administration (Hons.) in Marketing

Sikkim Manipal University; Pune India

•Bachelor of Technology (Hons.) in Computer Sc. Engineering

Rajasthan Technical University, Kota, India

AWARDS / RECOGNITION:

•“Bright Spot Award” for quickly learning OAF and MSCA Framework and resolving a critical issue.

• “Customer Delight Award” for developing complex Accounts Payable (AP) checks, EFTs and AP related Setup for North America, Canada and Mexico regions.

• “Bright Spot award” for effective and efficient management of technical components migration resulting in successful Go-live of Oracle E- Business Suite Upgrade project from 11.5.9 to R12.1.3.

• “Speed Award” Organization level Value award for timely and quality delivery of deliverables.

• "Smart Award" Organization level Value award for better approach towards resolving project related issues.

INTERNAL CERTIFICATION / TRAINING:

• Java and J2EE

• Oracle SQL, PL/SQL

• Oracle Apps Technical

• Oracle Apps Finance and Order Management Functional

• Oracle Fusion HCM

• Agile Level 1 & Level 2 Intra-Company Certification

• C# Training from Learning Tree

• Groovy/Grails Training from Webucator

Contact this candidate