Developer Sql
Resume:
RASHMIKANT PATEL
*********@*****.***
SUMMARY
Nearly 7+ years of working experience as an Oracle Forms Reports Developer / Oracle Pl/Sql Developer/Database developeron Oracle 11g/9i/8i,Windows,Unix,SQL Loader
In-depth knowledge of ORACLE architecture.
SQL and PL/SQL procedures, functions, packages, triggers, cursors, view etc.
Good experience in PL/SQL and query optimization.
Experience in Oracle Forms 11g/6i/6, Reports 11g/6i/6 and PL/SQL.
Extensive experience in writing stored procedures, functions and views.
Extensive experience in writing and tuning complex sub queries, SQL, PL/SQL stored procedures,functions, triggers, Bulk Collect,Merge,Ref Cursors.
Involved in all phases of a migration project from Oracle 9i to11G.
Well expreience in Creation of database objects,Tables, Views, Constraints,Indexes, Synonyms, Sequences,databasetriggers,Packages,Functions,StoredProcedures,Function Based Indexes,Collections
Performed various DBA tasks like creating users and grant privileges.
Expertise in the development and customization of Forms 9i/6i/6 and Reports 9i/6i/6
Expert in logical and physical data modeling using case tools like Erwin
Load the data from MS Excel to Oracle Table
Loaded the data using the SQL loader, PL/SQL Developer & UTL files based on file formats.
Conducted Oracle database and SQL code tuning to improve performance of the application, in-line queries, Analytics and Sub-query etc.
Managed performance and tuning of SQL queries and fixed the slow running queries in production.
Experience in evluating and performance testing of database applications,Implemented indexes on tables for better performance on data retrieval from oracle.
Modified database structures including tables,views,triggers,stored procedures to support application enhancement.
Experienced in requirement analysis, coding and testing various modules in a software development life cycle.
Expertise preparing report specifications and database designs to support reporting requirements
Worked with team on customizing the abilities such as previewing, printing and emailing reports.
Excellent interpersonal and communication skills,very good team player,quick learner and capable of working independently.
TechnicalSkills:
Languages : PL/SQL, SQL, Oracle Forms 11g/9i/6i/6.0/5.0
Databases : Oracle 11g/10g/9i/8i, MS access,
Tools: ERwin, SQL*Loader,SQL developer,
OS :UNIX, Windows 9x/NT/2000/XP/7
Application Servers: Oracle Weblogic 11g, 9ias
Network: TCP/IP.
Experience:
AT & T, TX Sep-2013 – Till date
Role: Tier II application support / E2E / BOA support / Oracle developer
Responsibilities:
Responsible for the Inventory provisioning application like INSTAR, ICORE.
Technical analyst in the INSTAR field support team supporting AT&T's IP enabled services.
Managing outages and restoration of our system in support of the users that are provisioning and managing IP based products and services.
These include BVOIP, Ethernet, IPflex, AVPN, EVPN. I manage internal and external customer's experience on a daily basis.
In my primary role I apply my knowledge of the provisioning process, system interfaces, AT&T’s products and the INSTAR system to resolve issues arising during the ordering, order management, provisioning and turn up of service with the customer.
investigate the cause and forward to developers for resolution / work around to resolve the issue.
Handles cases related to Orders provisioning in applications like BBNMS-SE, SOEG-SE, SOEG-CMI, IPOSS
Trobleshooting issues in PLANET application. It’s a before provisioning application.
Supporting SBS service line (HSIA) issues from order management to order provisioning
As E2E manager responsible for Analysis, investigation, troubleshoot and resolve issues of live customers issue.
Managing outages and restoration of our system in support of the users using critical service line HSIA.
Experience to provide services under a SLA as an asset.
Worked on Sev 2 & sev 3 tickets to resolve critical issues.
Environment: Oracle 10g, SQL Developer, putty, unix, Q messenger, AOTS, Windows 7
SynergisticIT,CA sep-2012 – Jun-2013
Oracle Database Developer/ PL/SQL Developer
Responsibilities:
Created query for delete bad data from the tables and maintain Data integrity.
Involved in Creating and handling the database objects like Procedures,Functions,Indexes,Cursors and views in development and production environment in PL/SQL.
Prepared test plans,test cases and requirement.
Developed triggers,tables,creating primary and foreign Constraints,Creating indexes to bridge the gaps between old and new application.
Involved in requirement, analysis, design,testing of the system.
Created simple stored procedure,function,packages. Modify datatypes and updated data to take care of trailing spaces.
Performed database design analysis and design.
Created Custom forms for specific users and assign those forms to their menus to provide user specific accessibility.
Environment: Oracle 10g/9i,SQL * Loader, SQL plus, Forms 9i,reports 9i
Lubi Submersibles Ltd. Jan 2010 -- Apr2012
Oracle Forms reports Developer/ Oracle PL/SQL Developer
Responsibilities:
Conversation and customization of existing modules from oracleforms 6 to 11g
Project Modules: Excise,Payroll,Production,Sales,Purchase
Interfaced with internal Departments like Quality, Project engineering,Production and other end users to understand and write user,functional requirements and detailed design specifications for the software systems,
Extensively used SQL *LOADER to load data from flat files(excel) to Oracle Database.
Created query for delete bad data from the tables and maintain Data Integrity.
Created lots of Triggers for frontend validation.
Extensively used SQL Query, joining tables, SQL functions in Queries, Creation of objects in PL/SQL with the use of cursors,ref cursors and loops,PL/SQL table and record,Function overloading etc.
Written PL/SQL programs,stored procedures,functions and triggers for data validations and business rules,
Generated SQL and PL/SQL scripts to create and drop database objects including tables,views,primary keys,indexes,constraints,sequences,
Worked on performance tuning of the SQL queries to improve data conversion process.
Created the index for increasing the performance of data conversion process
Performed Unit Testing, Integration Testing and Performance Testing.
Prepared and updated design specifications.
Created parameterized reports and customized existing reports. Developed various sub-reports, running totals per period.
Created Master Detail and Cross Tab reports to view the data in an analyzed way; formatted the reports as per the user requirements.
Developed complex SQL queries including Sub queries, correlated queries, and Nested queries, Unions, Intersect and Aliases.
Managed performance and tuning of SQL queries and fixed the slow running queries in production.
Application tuning using explain plan and hints
Provided user training and production support.
Creation,maintenance of PL/SQL packages and procedures including the user of :
CURSORS,Loops,IF-THEN,Error Handling,DBMS_OUTPUT,BULK COLLECT
Support the design and development of new system and redesign of existing systems to fulfill the need of users.
Developed unit test cases to test the applications,performed unit testing based on the developed cases and the given traditional scenarios.
Did production support and bug fixing.
Environment:PL/SQL; SQL; SQL*Plus; Oracle 9i, 11g; Oracle Forms 6,6i, 11g; Unix; Windows 2008; Oracle Reports 6,6i, 11g;
LEGO Technologies Pvt. Ltd. Jul2008 – Dec 2009
Oracle PL/SQL Developer
Developed database for the mortgage clients. Create oracle forms to retrieve data. Generate credit report and store the results in oracle database.
Involved in design, development, coding, testing and implementation of the allocated modules.
Developed forms and reports using Oracle 10g, Forms 6i and Reports 6i
Involved in developing transaction forms and customization of screens,involving a lot of validations at all the levels like field block and form level.
Worked on performance tuning including procedures, functions and SQL statements.
Involved in the database design.
Created procedures, triggers, functions& packagesusing PL/SQL
Extensively used SQL Loader to load data from flat files (Excel) to oracle database.
Performed Unit Testing, Integration Testing and Performance Testing.
Developed a variety of activity reports for users.
Build complex queries using SQL and wrote stored procedures using PLSQL.
Created indexes on tables and optimized queries..
Worked on all phases of conversation and customization development lifecycle, from gathering requirements to testing, implementation, and support.
Successfully involved in inclusion of linked as well as unlinked sub-reports along with the primary reports.
Environment: Oracle 10g, PL/SQL, Oracle forms 6i, reports 6i,SQL* Plus,Windows
Arvind Electro pumps Feb 2007 – May 2008
Oracle PL/SQL Developer / Oracle forms reports Developer
Involved in a large migration project moving from Oracle Forms 3.0 to 5.0 and then 5.0 to 6.
Worked on performance tuning including procedures, functions and SQL statements.
Involved in the database design.
Created procedures, triggers, functions using PL/SQL
Extensively used SQL Loader to load data from flat files (excel) to oracle database.
Performed Unit Testing, Integration Testing and Performance Testing.
Developed a variety of activity reports for users.
Developed PL/SQL stored procedures to automate many manual processes.
Worked with developers for performance tuning of the queries to improve user experience.
Worked on all phases of conversation and customization development lifecycle, from gathering requirements to testing, implementation, and support.
Successfully involved in inclusion of linked as well as unlinked sub-reports along with the primary reports.
Environment: Oracle 8i, MS Excel, Oracle forms 5.0, reports,SQL* Plus
TCS, Ahmadabad Jul2004 – Dec 2006
Oracle Forms Reports Developer/ Oracle Developer/ PL/SQL Developer,
Responsibilities:
Analylize the System Requirements,
Design the database based on the specifications.
Involved in processing huge tables, which have more than 100 million records.
Load raw data into Oracle tables usingSQL* LOADER.
Job involved Querying of large tables, usage of multiple built in functions in SQL for Data refinement as per business rules.
Developed and customized number of forms and reports using Oracle Forms 6/6i and reports 6/6i
Environment: Oracle 8.0, Windows 2000, PL/SQL, SQL and SQL*Plus,Oracle forms/Reports
Education :BS in Science.
Certification : OCP ( Oracle Certified Professional (forms 5.0/6/6i))
Visa Status : US Green Card Holder
Contact this candidate