Close
Overlay

Amol Patil -

Amol Patil
Send Message
Connect

About Amol Patil

Amol+Patil
Amol Patil and is interested in Software & Services.
Not the person you're looking for?
Find more results for Amol Patil

Location

Categories of Interest

Software & Services

My Interests

Besides working as a software professional i am interested in online business. I have recently started working on affiliate marketing.

Join Date

Amol Patil has joined on Jul 09, 2008

Resume

Amol Patil
Oracle Developer/ DBA

SUMMARY:
7 years of experience in software development involving Object Oriented Design, web applications design, Database Design, Three-tiered/ Multi-tiered Applications, and Client-Server Computing.
Expertise in developing SQL, PL/SQL scripts in Oracle distributed environment.
Expertise in Oracle Stored Procedures, Functions, Packages, Collections (PL/SQL Tables and Varrays), Triggers, Native Dynamic SQL, Table Partitioning.
Expertise in Oracle distributed query performance tuning by using EXPLAIN_PLAN, SQL Trace and TKPROF Utilities provided by oracle.
Extensive experience in writing OS level tools which interact with oracle by using UNIX korn shell and PERL scripting.
Expertise in Oracle Database Administration in Enterprise level Database Administration, Management and Operations.
Extensive experience in Installing, Designing and Managing Oracle 10g/9i Databases on Windows, Linux and Sun Solaris platforms.
Good experience in using Oracle Enterprise Manager, Oracle designer, TOAD, SQL Loader utilities.
Good experience in providing technical support for remote database servers.
Experience in following SDLC (Software Developement Life Cycle).
Experience in providing 24/7 production support.
Experience in making project technical documentation and status report.
Good experience in developing web services with windows IIS and c sharp .Net.
Fundamental experience in Data warehousing (ETL), OLAP and OLTP Data Modeling, Database designing, Data Migration, configuration management and code version control, Oracle Forms 6i, Oracle Reports 6i, HTML, XML.

TECHNICAL SKILLS:

Oracle Products: Oracle 8i/9i/10g, Oracle Developer Suite/2000, Forms (6i/ 5.0), Reports (6i/5.0), Designer 2000, Oracle Application Server, PL/SQL.

Internet Script HTML, XML.
Platform Windows 98/2000/XP, Sun Solaris, Red Hat Linux.
Other Languages C, C++, JAVA, ASP, Adobe Flex.

EDUCATION:
Bachelor of Engineering (B.E.) in Information Technology, Shivaji University, Kolhapur, MH, India.
MCP (Microsoft Certified Professional).

PROFESSIONAL EXPERIENCE:

EPA (Environmental Protection Agency) of US Federal Government, DC. Feb 07 To date
Project: EPASS HSPD-12/FIPS 201-1 compliance badge System
Oracle Developer/ DBA

This EPASS badge system has been designed for EPA of US Federal Government. EPA has its Head Quarter in Washington DC and 10 regional offices all over the US. This is a security application which mainly involves processing of Biometric information. The EPASS Badge System application has three modules:
1) WFMS (Work Flow Management System, which has Oracle based platform).
2) RSA CMS (Card Management System, which has Microsoft SQL Server platform).
3) IDENTIX enrollment workstation (used to capture Biometric information).
Reporting system has been developed using Pl/Sql & Flex.

Responsibilities:
Back End:
Involved in understanding the technical direction of the programming staff from a Back end database design and development perspective.
Understand the cross-functional interaction/ requirements among the various modules.
Performed extensive Pl/Sql programming to create packages, stored procedure, functions, triggers, table partitions.
Involved in Database Administration of Primary WFMS server.
Involved in Database Administration of Standby WFMS server.
Plan and Implements backup and recovery of the oracle databases.
Modifies Oracle instance initialization parameters as necessary.
Create and Maintain Roles and assign necessary privileges to users according to business rules.
Used Oracle Enterprise Manager, TOAD for managing database remotely.
Responsible for technical support for the EPA regional offices EPASS databases.
Allocating system storage and planning future storage requirements for the database.
Implemented Database Backup (Physical and Logical) and Recovery strategy.
Monitoring Alert Logs
Setup standby database for high availability and to protect data against disaster.
Applying database patches as and when required.
Optimization & Analyzing SQL queries for better Performance.
Used Unix Korn Shell Scripts for database administration.
Worked on web services related to Import & Delete feature of Identix software. This Web service moves required data to remotely installed Identix workstations from Oracle database servers. This feature mainly helps in avoiding manual data entry on enrollment workstations.
Worked on web services related to update the oracle database using information from CMS servers.

Environment: Oracle10g, Pl/Sql, SQL *Plus, Oracle Designer 2000, TOAD, C++, c#, Unix korn shell, Flex, Windows 2003 Enterprise edition.

Nortel Networks, Santa Clara, CA Apr 06 Jan 07
Project: Global Sales System
Oracle Developer/ DBA

Nortel Networks located in Santa Clara, California is involved in Optical networking technologies. The Global Sales System application runs on an Oracle based platform with the UI being Oracle Forms 6.0 and uses Oracle Reports 6.0 as a reporting tool. Web reports were created using Pl/Sql, Html, Java & Xml, ASP (Active Server Pages) was used to design portable front end application for point of sales recording.

Responsibilities
Front End:
Used Oracle Forms 6i to create new forms and also maintain existing forms.
Used Reports 6i to create new reports and also maintain existing reports.

Back End:
Involved in understanding the technical direction of the programming staff from a Back end design and development perspective.
Understand the cross-functional interaction/ requirements among the various modules.
Researched on locating the sources of information from the various tables and views.
Performed extensive Pl/Sql programming to create packages, stored procedure, triggers, table partitions etc.
Involved in Database administration using Unix Korn Shell Scripts for performing online backups and exporting database to magnetic tape.
Used Sql*Loader to move data from external file to oracle database.
Involved in performance tuning using explain plan & tkprof.
Used Oracle defined packages like DBMS_JOB, UTL_FILE and DBMS_OUTPUT etc.

Environment: Oracle10g, Pl/Sql, Oracle Application Server, Oracle Designer, Oracle Forms 6i, Oracle Reports 6i, Sql* loader, Unix Korn Shell, SQL *Plus, TOAD.

StateFarm Bank, Bloomington, IL May 05 Apr 06
Oracle Developer/ DBA
StateFarm Bank is US based Insurance and Banking organization to provide the banking and insurance solution to their customers in US. We had 24 oracle databases with 6 Solaris servers supporting those databases. There were three environments namely Development, Model Office and Production. Each environment was supporting 8 instances on a clustered system. StateFarm Uses Clustered technology in which the 8 instances on one Solaris machine can be accessed from other Solaris machine.

Responsibilities:
Back End:
Involved in understanding the technical direction of the programming staff from a Back end design and development perspective.
Understand the cross-functional interaction/ requirements among the various modules.
Monitoring the status of databases, logs, archived redo logs etc
Plans and Implements backup and recovery of the oracle database
Oracle 10g Installation, Configuration.
Applying patches as and when required.
Created recovery catalog. Performed complete and incomplete recovery using RMAN.
Responsible for creating functions, packages, stored procedure, triggers, table partitions using Oracle PL/SQL.
Involved in database tuning by using EXPLAIN_PLAN, SQL Trace and TKPROF Utilities, hints provided by oracle.

Environment: Oracle10g, Pl/Sql, SQL* loader, Sun Solaris, Unix Korn Shell, SQL *Plus, TOAD.

Indus Agro Products Ltd. Kolhapur, India Jun 03 Apr 05
Project: Development of Accounting & Inventory System
Oracle Developer
Indus Agro Products Ltd. is involved in manufacturing and distributing various agriculture products. This software automated the entire Accounting and Inventory for this organization.

Responsibilities:
Involved in analysis of the system.
Responsible for creating functions, packages, stored procedure, triggers using Oracle PL/SQL.
Performed database tuning by using EXPLAIN_PLAN, SQL Trace and TKPROF Utilities, hints provided by oracle
Used Oracle defined packages like DBMS_SQL, DBMS_JOB, UTL_FILE and DBMS_OUTPUT etc.
Involved in Database Administration for performing online backups and exporting database to magnetic tape.

Environment : Oracle 9i, PL/SQL, Oracle Forms 6i, Oracle Reports 6i, SQL *PLUS, windows XP.

Rukmini Steels Pvt. Ltd. Kolhapur, India Jan 02 May 03
Project: Integrated ERP
Oracle Developer
This is a software solution for small scale industries to mange their business more efficiently. Rukmini Steels Pvt. Ltd. India deals in steel trading.

Responsibilities:
Front End:
Participated in analysis and design of database.
Used Oracle Forms to create new forms and also maintain existing forms.
Created new reports using Oracle Reports.

Back End:
Wrote SQL queries and PL/SQL stored procedures and packages as per the requirement.
Responsible for ensuring technical specifications, and code adherence to quality.
Involved in performance tuning using explain plan and tkprof.
Involved in Database Administration using Unix Korn Shell Scripts for performing online backups and exporting database to magnetic tape.

Environment : Oracle 8i, PL/SQL, Oracle Forms, Oracle Reports, UNIX korn shell, Windows 2000.

Warana dudh sangh Ltd, Warananagr, India Jun 01 Dec 02
Project: Dairy Management System.
Oracle Developer
Warana Dudh Sangh Ltd. Warananagar India specializes in the business of milk processing and manufacturing various milk related products. This system covers fat and weight machine interfacing, accounting, and payroll system.

Responsibilities:
Front End:
Participated in gathering requirements for analysis and design.
Created various forms using Oracle Forms.
Used Oracle Reports to maintain existing reports and create new ones.

Back End:
Performed backend coding in Oracle PL/SQL as per the requirement.
Ensured application security using Oracle security features.
Used Sql*Loader to move data from external file to oracle database.
Involved in performance tuning using explain plan & tkprof.

Environment : Oracle 8i, PL/SQL, Oracle Forms and Reports, SQL *PLUS, Windows 2000.




References: Available on request

Quick Profile Summary

Amol Patil
Name: Amol Patil
Link: http://www.salespider.com/p-4981091/amol-patil
Location:

Explore using SaleSpider

Businesses You May Be Interested In

 Business Picture
 Business Picture
 Business Picture
 Business Picture

People you may know from

 Business Picture
 Business Picture
 Business Picture
 Business Picture

Amol Patil’s Business Connections

Find more information on the Company

Share This Profile

Member Spotlight

Carletta Thornbury Icon
Carletta Thornbury
EZ Wealth Solution
Owner

Business Spotlight

Express Those Feelings Icon
Express Those Feelings
Http://expressthosefeelings.com/
»
»
Amol Patil
Who Viewed This Page
458376 views
Last Seen
Thursday August 11, 2016
Top Cities
Delhi 1.7%
Toronto 1.17%
Bangalore 1.1%
Top Browser
Chrome Chrome51.56%
Iphone16.42%
Firefox Firefox14.07%
OS Expand
Windows
42.06%
Android
27.51%
Iphone
16.91%
Device Expand
Desktop
50.37%
Mobile
43.63%
Tablet
5.99%
Language Expand
En-US
64.76%
En-us
17.89%
En-GB
2.84%
spacer pixel