Oracle PL/SQL, forms Oracle ERP Technical Lead

SHALINI CHENDLA Email: *******.*******@*****.*** Contact Number: 412-***-****

Summary

** ***** ** ********** ** software application development and production support activities in the areas of client server technologies. Expertise in all the phases of technical analysis, Design, Development, Testing, Implementation and technical documentation of the projects using Oracle (SQL, PL/SQL, Oracle forms/Reports and Oracle ERP)

Skills

• Extensive experience in working with Oracle 12c/11g/10g, Oracle Forms 11g/10g/9I/6i, Oracle Reports 11g/10g on Windows Platforms.

• Expertise in Oracle ERP Inventory, customization of inventory reports, EDI reporting and API to ERP, use of Oracle E-Business Suite applications

• Well versed in Oracle Back-end (server-side) PL/SQL Development i.e., Packages, Stored Procedures, database triggers, Functions and Triggers using SQL Developer, SQL Navigator and Toad as Development tools.

• Good at Dynamic SQL, PL.SQL Collections and SQL Loader

• Experience in oracle server data import/export coordination, validation of schema objects.

• Extensive experience in Technical Design, Analysis, Debugging, Testing and deploying the applications.

• Experience in UNIX based maintenance and support project.

• Experience in leading and supervising technical team in a team oriented environment with strong trouble shooting, analytical, interpersonal, communication skills, mentoring and excellent presentation

• Expertise in Health care, Insurance, Manufacturing functional domains and understand their business to make technology and process related recommendations

• Experience in review and Gap analysis of functional requirement documents and creation of Technical documents and related Test case document.

• Experience in project estimates, resource needs, and timelines.

• Deep understanding of Software Development Cycle (SDLC) and implemented projects using Agile model. Professional Experience

BDSN International, Inc. 07/2017 to 08/2018

Technical Lead (Oracle ERP, Oracle SQL, PL/SQL Development) Clients: CVS Health (Monroeville, PA)

WIPRO Technologies Pvt. Ltd 08/2005 to 07/2017

Technical Lead (Oracle ERP, Oracle SQL, PL/SQL Development) SHALINI CHENDLA Email: *******.*******@*****.*** Contact Number: 412-***-**** Clients: CVS Health (Monroeville, PA), State Street (Boston MA), The Hartford Insurance (Hartford, CT) Projects: Pharmacy Account Receivables Collection, Fund Accounting, Operational Efficiency, Specialty Project Description:

Pharmacy Account Receivables Collection System (SPARCS) application which is an enterprise pharmacy system being developed by CVS Health. Pharmacy Account Receivables Collection system communicates with several other applications for different data flow related to Patient and accounts information. Fund accountings are vendor based applications which calculates the net asset value for the fund. Operational Efficiency project aims to implement a workflow with the goal of automating manual processes, controlling inter- dependencies between processes and providing useful information on process status at all levels. Specialty The Hartford offers a variety of business and specialty risk insurance products through independent agents and brokers. Specialty address large commercial lines business, Supports business segments - RM, IR, Middle Market (key accounts) & SRS, Support other products while the volume is low. Responsibilities:

• Lead for software development team size of 6

• Involved in Analysis, design, technical specification preparation, unit and functional test case preparation, development, testing and deployment support for support requests and enhancements.

• Worked for projects with multiple interfaces, decommission of db links & use of API.

• Involved in Oracle PL/SQ coding and created Views, Packages, Procedures, Functions, Triggers, Indexes and Collections.

• Developed Reports, forms, Menus, Object Libraries and PL/SQL Library using Oracle Forms and Report Builder

• Involved in Oracle ERP Inventory module existing usage of applications or to proposing new alternatives or process changes, providing technical insight during the trouble-shooting of existing issues or during the formulation of enhancements or reporting.

• Involved in developing several pharma EDI and flat file report design, development, scheduling file transfer to SFTP server

• Involved in the continuous improvement enhancements and fixing of production problems.

• Established estimates, resource needs, and timelines.

• Involved in weekly and monthly status tracking, reporting, presenting highlights of the week, effort tracking, project plan and run several status meeting calls with clients.

• Provided support for Business analyst in gathering the requirements for the enhancements project Hinduja TMT Ltd, Bangalore 11/2004 to 10/2005

Sr. Oracle 10g(SQL, PL/SQL) Developer

Client: SAIPA Automobile Manufacturing Company Group Project: Phoenix(Module RPI -Retrospective Price Impact) SHALINI CHENDLA Email: *******.*******@*****.*** Contact Number: 412-***-**** Project Description:

RPI will mainly calculate the Price Impact on Different Parts due to a sudden change in the price of materials. In such cases the parts are issued for the agreed rate and later the rate impact on manufactured part is calculated (some other month). So it is the rate impact in a month as seen in some other month. Depending upon the total loss incurred the Rates with respect to Parts will be changed. Responsibilities:

Module Lead, involved in program specification preparation, pl/sql coding, forms and report development, and test plan preparation, unit testing, implementation and documentation. Satyam Computer Services, Chennai 02/2004 to 11/2004 Oracle 9i (SQL, PL/SQL) Developer

Client: World Bank

Project: Meta Data Management

Project Description: This is ISP Content Type Management System implementation of the content type and input templates. At the core of ePublish and the web content management initiative is the capture of metadata for each content item so that site could be dynamically driven and content could be shared across multiple sites. To capture metadata, ISP has implemented the concept of content types and input templates. The ISP Input templates used to capture content metadata

Responsibilities: As a project team member involved in all oracle support (PL/SQL development) form metadata management. Involved in analysis for attributes of content migration. Hinduja TMT Ltd, Bangalore 11/2000 to 01/2004

Oracle 9i (SQL, PL/SQL) Developer

Client: Ashok Leyland

Project: Ashok Leyland Manufacturing Application (ALMAP) Modules worked: Inwarding, Warehouse, Service and Warranty Ashok Leyland deals in heavy and lightweight commercial vehicles. The project involves converting the legacy code on ES/9000 to ORACLE 8i with client/server architecture. The project also involves enhancements to meet the user’s current requirements. The PMS is an integrated online production management system, which contains various application modules. The main modules include Bill of Materials (BOM), Production Planning System

(PPS), Material Planning System (MPS), Purchase Order System (POS), Work Order System (WOS), Goods In- Warding System, Online Stock System and Work Order System Responsibilities: As a team member involved in program specification preparation by analyzing existing COBOL legacy code, coding, and test plan and documentation, Integration testing of major modules in ALMAP, implementation of modules at client site and user training Technical Skills:

Operating Systems : Windows, UNIX.

Programming Languages : SQL, PL/SQL, VB, Shell Script, Python SHALINI CHENDLA Email: *******.*******@*****.*** Contact Number: 412-***-**** Programming Tools : Oracle E-Business Suite, Quest Software TOAD, Oracle SQL Developer, MS Office, MS Project

Databases : Oracle database (8i, 9i, 10g, 11g, 12c) Tools Case : SQL * Plus, Tortoise SVN, Erwin, PVCS, SCCS Education:

• Master of Science [Materials Science], Mangala Gangotri, Mangalore University.

• Post Graduate Diploma in Computer Applications, St. Aloysius College, Mangalore.

Contact this candidate