Developer Pl Sql

Manvela Karekar

(***)- ***- **** © ********@*****.***

Work Permit – Green Card

PROFESSIONAL SUMMARY

Nearly Eight (8) plus years of experience as an Oracle PL SQL Developer, Database Developer Analyst

Worked in Support environment.

Experienced with Telecom and Manufacturing industries.

1.2 years of experience onsite Japan.

Ability to design and optimize Oracle stored procedures, packages and functions.

Well experienced in creation of database objects, Tables, Views, Constraints, Indexes, Sequences, Database Triggers, Synonyms, Stored Procedures, Packages, Functions.

Knowledge of Data Modeling Concepts

Experience with all phases of SDLC (analysis, design, code, unit test, system test, implementation, post-implementation).

Developed UNIX shell scripts for calling PL/SQL packages, procedures.

Experience in documenting code fixes and modifications and testing instructions.

Experience with creating technical documentation such as Visio flow-charts.

Excellent creativity and problem solving skills.

Ability to work effectively as a dedicated team member; ability to effectively and accurately communicate with other team members

Provide training to co-workers and develop in their career goals. Comfortable working in production environments.

Ability to work effectively with a diverse project team in a highly visible, fast paced and changing project environment with aggressive timelines.

SOFTWARE TECHNOLOGIES:

Skill Category: Database developer, Support, Testing

Languages: SQL, PL SQL, Forms 9i 6i, Shell Scripting, COBOL, C, Visual Basic, HTML,

JavaScript, VB Script and ASP, JCL and VSAM

Database: Oracle 10g 9i 8i, MS Access, SQL Server 2005, MYSQL

Tools: WEDAT,TOAD, SQL*Loader,SQL Developer, SQL Navigator,MSVisio Enterprise

Architect

Testing tool: UFT 11.50

OS: DOS, UNIX, Windows 9x NT 2000 XP 7

Network: TCP IP

GUI Tools: Forms 9i 6i 6 5 4.5, Reports 9i 6i 6 3 2.5, Enterprise Manager, VB

Crystal Reports 5.0

Application Servers: Oracle Application Server 3.1, 9ias.

Tools: Win CVS, Clear Case, Clear Quest, PL/SQL Developer 7.0, FTP,

COTS (Inventory powered back office automation software for the global telecommunications industry) Crammer 6.0

Application: Retail Commander, RTS SharePoint

PROFESSIONAL EXPERIENCE

RTS Support (Retail Support), AT&T July2014 – Feb2015

Retail Support

Support through Retail Commander application to OPUS Users.

OPUS is an online application used in AT&T retail stores for sales/customer support/ promotions and everyday operations of retail stores.

Responsibilities:

Creating new Site setup through RC.

Adding equipment, Register, OPUS Mobile printer in RC.

Managing existing registers and its peripherals eg. OPUS Mobile printer.

Setting up the data through RC in OPUS Database.

Handling closure and relocations of the stores.

Created User failed login reports monthly and manage daily and weekly reports.

Set store configurable through RTS Remedy or DBA or RC ticket.

Handle emergency situations when store unable to OPEN (Next Day transactions)

Provided queries or data related to sites or peripherals in OPUS database.

Resolving system issues through Remedy system on priority basis.

Environment: WEDAT, BWS Remedy 7.5, Retail Commander, RTS SharePoint.

IMPACT (Imports Planning and Accounting), Cummins India Ltd Jun 2010 – Dec 2011

Oracle Database Developer/ PL/SQL Developer

IMPACT was developed for CUMMINS INDIA Ltd, A subsidiary of CUMMINS USA. A multinational leading in the manufacturing of diesel engines. The project was automation of its import accounting which involved integration of invoice, Bill of Entry and Goods Received Report which interface to Oracle Applications.

Responsibilities:

Experienced with all phases of SDLC (analysis, design, code, unit test, system test, implementation, post-implementation).

Working in production (LIVE) environment in Oracle Databases

Performance tuning of Oracle Databases and User applications by Creating indexes on tables and optimized Stored Procedure queries.

Wrote Complex Business Logic using procedures, packages, triggers, function for programming.

Reduced processing times of SQL queries, night batch jobs by reviewing PL SQL code, modifying database parameters.

Created complicated Custom forms for specific users and assigned those forms to their menus to provide user specific accessibility.

Involved in Developing and handling PL SQL Packages, Procedures and Database Triggers, views and reports. Interfaces to Oracle APPS were PL/SQL packages.

Creation and maintenance of user accounts, user profiles and application specific roles.

Developed unit test cases to test the application, performed unit testing based on the developed cases and the given traditional scenarios.

Giving knowledge transfer with release changes to business users.

Interfaces with users on escalated issues, business requirement gathering, and user acceptance testing sessions.

Performs technical analysis and troubleshoots existing objects to identify and implement resolution to user-report defects.

Resolving system issues through Remedy system on priority basis.

Environment : Oracle 10g, Toad, Oracle Forms6i, Oracle Reports 6i, 24*7 Support, BMC S/w for remedy

Spare Parts Price Management, CDSS,India Sep 2009 – May 2010

Oracle developer

Developed front end with ASP. Web based system for user from different areas –Service Parts, Sourcing, CIL Costing, Engineering and CDS&S will have personalized home pages, which will show the various proposals waiting for their approval. The Intranet pages shows the data from Oracle database to display the part prices, the history of prices and the various part attributes required during process.

Responsibilities:

Design and Develop backend processes and front end through ASP.

Developed PL/SQL packages involving complex business logic.eg calculation of parts prices.

Creation and maintenance of user accounts, user profiles and application specific roles.

Developed unit test cases to test the application, performed unit testing based on the developed cases and the given traditional scenarios.

Coding Debugging, Sorting out their time-to-time technical problems.

Experience with creating technical documentation.

Environment: Oracle 9i, Toad, ASP

CC&B – AIS Database Deployment support, AT&T Aug 2008 – Aug 2009

Oracle production support

CCB-AIS, Application infrastructure support (AIS) project for the client AT&T (US) which catered to deployments for AT&T’s. I was a team that catered to and supported release deployments for all applications/projects for AT&T Customer care and Billing.

Responsibilities:

Release Management/Deployment through CVS (Version control / Configuration management tool).

Deploy added/modified backend packages.

Maintain Data base Library.

Code version control.

Technical support.

Production incident management.

Experience with creating technical documentation.

Involved in Coordinating deployments with various application teams and infrastructure teams for scheduled releases.

Environment: Tools used for deployments were Eclipse (Open source code), Vantive (Incident/Release management tool), and CVS (Version control / Configuration management tool),Unix

21 CN – LIMS, British Telecom (BT) Dec 2006 – July 2008

Oracle Database Developer/ PL/SQL Developer

21 CN – LIMS: 21 CN- 21st Century Network was a visionary transformation initiative of British telecom to upgrade its systems for new technological challenges. LIMS, Logical Inventory Management System. Worked with the module Manage Resource Service (MRS) – Wholesale Line Rental (WLR3 ISDN2e).

Responsibilities:

Involved in development of Life Cycle Management for the product WLR3.

Developed primary database objects such as tables, Indexes and views to implement required functionality.

Wrote PL SQL Packages which includes functionalities to loop through the database. Backend interfaces developed in PL/SQL which flows the product through different stages of ordering such as Provide, Place, Route, Design and Close. Thus automating processes that rely on a detailed knowledge of network inventory, capacity and service configuration information.

Coding Debugging, Sorting out their time-to-time technical problems.

Did production support and bug fixing.

Performs technical analysis and troubleshoots existing objects to identify and implement resolution to user-report defects.

Code deployment through CVS and manage versions of different releases.

Involved in testing for the product WLR3 through COTS product Cramer 6.0. (Cramer is the leading provider of inventory powered back office automation software for the global telecommunications industry.) I was also involved in Testing for different stages of ordering such as Provide, Place, Route, Design and Close. E2E (End to End) order progression testing using Cramer as resource manager. Order linking to various resources during the orders progression.

Environment: Oracle 10g, PL SQL, TOAD, VMWARE, PUTTY and TOAD for database, CVS (Version control / Configuration management tool), Linux

Multi Entity Payroll (MEP), CBS India December 2004 – November 2006

Oracle Database Developer/ PL/SQL Developer

Multi Entity Payroll system customized specifically for Cummins requirements. The system can process payroll for all the CUMMINS entities worldwide.

Responsibilities:

Experienced with all phases of SDLC (analysis, design, code, unit test, system test, implementation, post-implementation).

Involved in Interface development through backend PL/SQL .Interface extracts the data from staging tables into customized Multi Entity Payroll database. Data is used by customized Multi Entity Payroll which calculates the payroll entity wise.

Created Custom and complicated form for specific users and assigned those forms to their menus to provide user specific accessibility. E.g. Employee Screen

Oracle HRMS extracts data in staging tables through nightly concurrent processes which is imported by the interface developed by me through Multi Entity Payroll.

Used SQL*Loader to load data from flat files (excel access) to Oracle database, done ETL processing at initial stage to transfer the data from Sybase.

Developed critical reports such as Pay slip of the Employee, Benefit to Employee (BTE), Form 16 used for Income tax.

Developed unit test cases to test the application, performed unit testing based on the developed cases and the given traditional scenarios, involved in UAT.

Provided user training and production support.

Wrote Complex Business Logic using procedures, packages, triggers, function for programming.

Also Created Tables, Primary and Foreign Constraints, Unique constraints, Check constraints, Views, indexes to bridge the gaps between the old and new application.

Reduced processing times of SQL queries, night batch jobs by reviewing PL SQL code, modifying database parameters.

Created query for Delete bad data from the Tables and maintain Data Integrity.

Creation and maintenance of user accounts, user profiles and application specific roles.

Coding Debugging, Sorting out time-to-time technical problems.

Environment: Oracle 10g 9i, PL SQL, SQL Navigator 4.4, SQL* PLUS, Forms 5, 6, Reports 5, 6.

Worked as Onsite S/W Engineer for Fujitsu Ltd. and Fujisawa corporation in JAPAN during

Aug 2002 – Aug 2003

Environment: Oracle 9i, PL SQL, Forms 6, Reports 6.

Masters Degree Computer Management – 1993-95 'Pune University', INDIA

Bachelors Degree in Science -1991-93 (Statistics, Mathematics), Pune University, INDIA

Main Frame course from Mapels institute, Pune (Aug 09 – Nov 09)

Environment: OS/390 OS for IBM Mainframe.

Languages: COBOL, JCL, VSAM, DB2, CICS

Contact this candidate