Developer Software

Neeta Rachchh

SUMMARY

*+ Years of experience in development on Oracle PL/SQL, Oracle design, development, maintenance, testing and implementation.

Excellent command on PL/SQL, Oracle 12c/11g/10g/9i, TOAD, SQL Developer, PL/SQL Developer, UNIX Korn Shell Scripts, SQL*Plus.

Extensive work on SQL, PL/SQL Stored Procedures, Functions, Triggers, Packages, Views.

Thorough understanding of RDBMS, Entity-relationship model and Schemas.

Extensive experience on SQL tuning and Advanced SQL techniques.

Oracle E-business Suite 11i/R12 including database design, development with emphasis on backend stored procedures, functions, triggers.

Oracle Application Forms, Reports, Interfaces development using the Development Suite/tools (like Forms, Reports, PLSQL and SQL*Loader).

Experience on Oracle on UNIX environment.

Experience on Data Warehousing tools. (Business Objects)

Experience with tools like Hummingbird Exceed, Appworx (for Oracle job scheduling), 170 systems (for Oracle User Roles & administration) and Right Fax (for Fax setup in Oracle), PVCS (version control tool).

Extensively worked on Performance tuning of the Code.

Worked on Forms, Forms Personalization, Reports and Oracle Workflows.

Exposure to Data Modeling, Analysis and ETL.

Exposure to C, C++, Java, JSP and JDBC, J2EE.

Exposure to web technologies – XML, XSLT, HTML, DHTML and Java Script.

Thorough knowledge and experience of all phases of Software Development Life Cycle (SDLC) cycle.

Excellent Verbal and written communication skills.

Excellent Presentation & Interpersonal skills and ability to work in a team.

Excellent Analytical and Problem Solving skills.

Pro-actively identify areas of opportunity and work to finding solutions that meet the business needs of the customer.

Worked on Quality Processes and Six Sigma processes to the development projects.

Well conversant with ISO 9001 quality procedures and CMM Level 5 processes while executing the projects.

CERTIFICATIONS

Oracle Certified Associate (OCA)

M

EDUCATION

Bachelor of Engineering in Computer Science, Saurashtra University, India.

Year - 2003.

SKILLS:

Database Oracle 12c/11g/10g/9i, MS SQL Server, MS Access

Languages SQL, PL/SQL, C, C++, COBOL, Java

Oracle E-Business Suite Release 11i, R12

GUI & Tools SQL Developer, PL/SQL Developer, Tool for Oracle Application Developer-(T.O.A.D.), Business Objects, Developer 2000 (Forms 10g, Reports 10g), SQL*Loader, Kintana Tools for Code migration

Web Technologies XML, XSLT, HTML, DHTML

Configuration Tools Visual Source Safe, Kintana

Operating System UNIX, MS DOS, Windows

Third Party Tools SCCS (Source Code control System), PVCS, 170 Systems, CVS Version control system, RightFax

PROJECTS

Prodygee, NJ, USA Nov 2018 –till date

Intelli365 (Predictive Data Analytics System)

Role: Database designer, Database Developer, Tester

Description: Intelli365 is a software product which provides intelligent data analytics and solutions to customers helping them make various decisions which are based on the historical sales data. It uses algorithms to identify previous data patterns. The software helps identifying, analyzing and interpreting trends/ patterns in complex data sets. Software provides a nice user interface to allow user to schedule data load, run analytics, allow user to define different rules and display dashboard for all data loads.

Responsibilites:

Designing and creating Database objects like Tables and integrity constraints for the Sales Data.

Creating Oracle Views which enable users to fetch, review and analyze historical data and help in the decision making process.

Design and Development of PL/SQL Packages, Stored Procedures, and Functions and testing in the Test environment.

Creation of PL/SQL Triggers to handle different functionalities based on Table inter-dependencies.

Use of SQL * Loader for loading the sales data into Oracle tables.

Backup and archiving of the database tables.

Use of Explain Plans for analyzing and tuning queries.

Extensive Performance tuning using Indexes, Database Hints.

Work on Unix Korn Shell scripts.

Creation of Indexes, Sequences, Procedures, and Functions.

Environment: PL/SQL, Oracle SQL, SQL * Loader, PL/SQL Developer, UNIX

Noble Group, CT, USA Aug 2011 –Jan 2012

Collateral Management System

Role: Technical Lead, Software Analyst, Database designer, Senior Software Developer, Tester

Description: An Online Transaction Processing System (OLTP) system designed and developed single handedly from scratch on Oracle is used by the Firm for Credit and Collateral Analysts for day to day analyzing of Trade and Exposure information for each counterparty, Exposure calculations, Margining Counter parties, sending invoices, making Collateral Adjustments and reporting.

Responsibilities:

Single handedly designed, developed and implemented Collateral Management system on Oracle.

Analyzed technical alternatives for implementation and choosing the best technical solution.

Analyzed requirements and created technical specification and creating estimates.

Designed and created Database Tables and Views.

Created Oracle Views on PL/SQL Developer to extract data for the purpose of analyzing the day to day exposure data by Credit and Collateral analysts.

Designed and Developed PL/SQL Stored Procedures, Functions and packages and tested in Test environment and finally implemented in Production environment.

Created PL/SQL Triggers to handle different functionalities based on Table inter-dependencies.

Use of SQL Loader for loading the data.

Performance tuning using Oracle Hints. Brought down execution time of large Views from Minutes to seconds.

Detailed Quality assurance and Testing on Test and Production environment.

Post-implementation support and providing additional functionalities within matter of hours.

Environment: PL/SQL, Oracle 11g, SQL Developer, TOAD

United Parcel Service (UPS), NJ, USA Jun 2010 –Jul 2011

Incentive Administration System

Role: Senior Software Developer, Tester

Description: UPS’s Incentive Administration System is a Software System under Marketing Department of UPS. All of UPS’s Customer Incentive rules are implemented under this project. All of UPS operations use this system for incentive operations. A team of 20 people develops and enhances it.

Responsibilities:

Creation of Oracle PL/SQL Packages to support the new IAS functionalities using large database in 100s of GB size.

Designed and Developed PL/SQL Triggers, Stored Procedures, Functions and Packages and later tested in Unit, System, Integration and Stress Test environments.

Use of Collections, Bulk Collect and FORALL functionalities of Oracle.

Created UNIX korn shell scripts and used SQL Loader to load data from received from DB2 environment to Oracle.

Resolved Oracle Table Deadlock situations by writing separate procedures.

Used advance SQL techniques and worked on SQL tuning.

Performance tuning with use of Oracle Hints.

DBA activities like import/export, creating/maintaining database objects like table, index, sequence, views, procedures, triggers.

Environment: PL/SQL, Oracle 10g, 11g, UNIX, UNIX korn shell, SQL*Loader, PL/SQL Developer

Commerce Insurance, MA, USA Mar 2010 –Jun 2010

Insurance Application

Role: Oracle Developer

Description: Oracle application for Insurance information.

Responsibilities:

Designed and developed Oracle Package to create functionalities to be used by applications.

Created Oracle Views to take data from underlying tables and provided various facility to view and utilize data.

Developed PL/SQL Triggers, Stored Procedures and Functions.

Performance Tuning of the Code.

Testing of the Packages, Views and Triggers.

Environment: PL/SQL, Oracle 10g, SQL Developer, PL/SQL Developer

General Electric (GE), India Jan 2007 –Apr 2009

Shared Sourcing Services

Role: Analyst, Senior Software Developer.

Description: General Electric’s Shared Sourcing Services environment is a global purchasing instance for indirect and direct procurement. 200+ Operating units of GE use this application across the globe.

Responsibilities:

Implementation of New Organization Units of GE on entire Buy-to-Pay Cycle which required knowledge of Oracle Financial architecture and technical expertise in SQL, PL/SQL, Oracle.

Implemented business issue resolutions and Bug fixes through train process.

Extensively worked on PL/SQL packages to develop and maintain new functionalities.

Month-end Processing of PO, Account Payables & General ledger for each Organization Unit of GE which included working with PL/SQL packages, Functions, Procedures.

Implemented Payables Invoice Import Program to create invoices in Oracle Payables from the legacy system for business.

Developed PL/SQL program to validate imported data file for AP invoices import.

Developed an interface for monthly import of journal entries from payroll running on a legacy system by using the Journal Import Interface provided by Oracle General Ledger.

Customized Requisition Approval workflow to add additional Approvers.

Customized reports to meet the client requirement.

Developed a PL/SQL Program to validate data in custom table for tallying PO Header amount with PO line amount and to load all valid PO’s into PO interface tables

Created a Concurrent request set which calls SQL Loader Program and then calls validate script, PO Import program.

Design and developed Custom business areas and user metrics reports for AP, PO and AR using Oracle Discoverer.

Developed PL/SQL Triggers, Stored Procedures, Functions and Packages to replicate data in real time which is used by newly developed security management application.

Used advance SQL techniques and worked on SQL tuning.

Migrated data from extracts prepared in mainframe to Oracle database using SQL Loader.

Created new Tables, integrity constraints (Primary Key/Foreign Key) in Oracle.

Worked on Appworx tool for scheduling jobs (to run PL/SQL programs & packages), 170 systems for implementing User roles & administration, Kintana for Code migration and RightFax tool for Fax setup in Oracle.

Worked on System architecture (SSS).

DBA activities like import/export, creating/maintaining database objects like table, index, sequence, views, DB links, procedure, triggers.

Worked on Form Personalizations.

Environment: PL/SQL, Oracle 9i, Oracle E-Business Suite, UNIX korn shell, SQL*Loader, XML, Oracle Workflow V2.x, SQL*Loader, Forms6i, Reports6i, UNIX and Third party tools (Kintana Tools for Code migration, 170 Systems for user roles, Appworx for scheduling Jobs, PVCS for version Control, Rightfax).

General Electric, India Mar 2005 – Dec 2006

Oracle HR

Role: Senior Software Developer.

Description: The project focus was Implementing HRMS and maintaining/enhancing it for all organization Units of GE Corporate. The project also involved converting legacy person, and other related data, such as assignments, addresses, taxes, elements, payment methods, salary, competencies, contact addresses into Oracle HR.

Responsibilities:

Developed PL/SQL packages in accordance with the interface architecture so as to facilitate the functioning of Inbound and Outbound Interface run for new Organization Units

Worked with HR Interface packages.

Conversion of Legacy Data using API’s

Dealing with Person, Employee etc. tables and managing links among all HRMS tables.

Worked with defining accounting and Descriptive Flex Fields (DFFs), dealing with Key Flex Fields (KFF).

Special Information Types (SIT).

Validated data before loading into Application database using PL/SQL.

Gathered user requirements, and Performed gap analysis.

Worked with business users to identify the report requirements.

Writing SQL Loader scripts and loading the data from legacy system.

Creation of value sets, concurrent programs and registering the forms.

Designed and developed reports using oracle discoverer.

Debugged and enhanced standard workflows, standard reports/modules/alerts.

Performed the system administrator role by setting up the user privileges, assigning responsibilities, registering custom forms and custom reports with applications so that they can be accessed from within the applications.

Preparing test cases and Unit testing.

Communicating with Customers.

Preparing technical specification documents for developers.

Environment: PL/SQL, Oracle Database, DW, Oracle E-Business Suite, SQL*Loader, PVCS as a version Control tool, UNIX.

ING Bank, TCS, India Apr 2004 to Mar 2005

Oracle Development

Role: Software Developer

Description: The project scope is providing development and maintenance of Oracle code for Banking application of ING Bank’s Headquarters.

Responsibilities:

Complete Development and Support activities for the Banking application.

Development of SQL queries which are used to communicate with database.

Writing SQL* Loader scripts and PL/SQL programs for loading.

Development of Stored Procedures and Functions.

Requirement Gathering, Development, Unit Testing.

Bug fixing in PL/SQL packages.

Environment: Oracle PL/SQL, SQL, SQL*Loader

Contact this candidate