Having 10+ Years of IT experience in Oracle Development, Administration and Implementation with Proficiency in Oracle 12c/11g/10g/9i/8i.x, SQL, PL/SQL,Oracle CRM,Golden Gate that includes Complete Software Development Life Cycle from Analysis and Design to Implementation and Production Support.
*Strong Analytical and Conceptual skills in database design and development on client/server applications using SQL, PL/SQL, Forms & Reports.
*Expert in the development of Stored Procedures, Functions, Packages, Triggers and D2K Forms & Reports.
*Strong PL/SQL programming skills and expertise with SQL tuning, Performance tuning and Bulk binding techniques.
*Having Sound knowledge in Advanced PL/SQL Programming.
*Controlling migrations of programs, database changes, reference data changes and menu changes through the development life cycle.
*Implements and enforces security for all of the Oracle Databases.
*Proficiency with utilities such as Export, Import, SQL * Loader and External Tables.
*Expertise Knowledge in Oracle Golden Gate replication set up between more number of DBs
*Involved in project planning, scheduling, System design, Functional Specification, Technical Design specification, coding and system test plan.
*Hands-on experience in full Software development life cycle (SDLC): Assessing user's needs analysis, planning, scheduling, systems design, programming, quality assurance, documentation, project implementation, and customer support.
*Experience in the area of analysis, design, development, testing, implementation and Production Support of complex Servers with applications using Oracle Applications (CRM,AOL,SYSAdmin.),JDA Manugistics and Redprairie.
*Having Good Knowledge in Point Of Sale(POS) .
*Expertise in developing and customizing Forms and Reports using Oracle Forms 6i, Reports 6i and developing concurrent programs using SQL, PL/SQL and Unix Shell Scripting.
*Hands on Experience on Redprairie Warehouse Management System Inbound/Outbound Process.
*Developed complex Redprairie Reports and MOCA commands.
*Experience in working with JDA Manugistics Modules like Supply and Transportation Management.
*Developed complex SQL queries for Cognos Reports and Jasper Reports.
*Proficient work experience in Developing IReports 4.0.1 and Cognos.
*Worked with query tools like Toad, SQL*Plus, SQL Developer.
*Extensively used Version control tools PVCS, Kintana.
*Hands on implementation experience in industries like Media and Entertainment, Customer Relationship Management, Communications, Supply Chain Management, Warehouse Management System and Transportation Management.
* Having good experience in interacting and working collaboratively with cross functional teams.
*Involved in preparing the SQL and PL/SQL coding convention and standards.
*Involved in preparing the functional specification, technical documentation, schema
Documents, flow charts and user support documents.
Operating Systems MAC OS,Windows 08/07/Vista/XP/2003
Server/2000/NT/98, UNIX and LINUX
Languages SQL, PL/SQL, C, C++, UNIX Shell Scripting,WebQL
RDBMS Oracle 10g/9i/8i, MySQL.
Applications Oracle Application (CRM)11i,JDA Manugistics and Redprairie
Version control Tools PVCS,Kintana,SVN.
GUI Development Developer 6i/2000, Oracle Applications 11i,Cognos Reports,iReports and Redprairie.
Tools PL/SQL Developer, SQL Loader, SQL Developer, MS Office, TOAD, LextEdit, TWS, Magic, Kintana, PVCS, Oracle Forms and Reports Builder, SecureShell.RADAR,ESPRESSO.
Senior Oracle Developer07/2013
to 03/2014 Company Name – City,
An Apple POS System features the Apple Point-of-Sale application, which runs in all Apple retail stores.
This software automates sales by enabling comprehensive functions vital to the Apple retail marketplace, such as reporting, processing of returns, sales, discounts/exceptions, and receipt printing and configuration.
Widely working on Oracle Object types, Oracle cursor
Management and exception handling.
Responsible for migrating of programs, database changes, reference data changes
Through the development life cycle.
Assisting with impact analysis of any changes made to the database objects.
Applying Rollout and rollback plans on QA Databases before releasing Production.
Implementing and enforcing security for all of the QA Oracle Databases.
Creating users, roles and granted privileges according to the business requirements.
Performing code merge and maintaining QA databases up-to-date with respect to Production and Development environments.
Extensively working on SQL Developer.
Sound knowledge in version control tool SVN.
Good exposure on Radar, Espresso tools.
Coordinating with Offshore team on daily basis.
Creating and monitoring AutoSys jobs.
Performing capacity planning required, creating and maintaining database environments.
Participating in project planning, documentation, testing, and validation procedures.
Maintaining an audit log by setting triggers to fire.
Planning and implementing backup and recovery of the database.
Involving in designing Data flow diagrams, ERD's, Use case diagrams, Process flow diagrams.
to 06/2013 Company Name – City,
Mars Inc.,s an American manufacturer of confectionery, pet food, and other food products.
It is ranked as the 5th largest privately held company in the United States.
Mars operates in six business segments in the U.S.
Like Chocolate, Pet care, Food, Drinks, Pet Food and Snacks.
to 10/2011 Company Name – City
The main objective of CCW is to provide cisco customers with a single integrated, scalable, intuitive workspace to engage with Cisco throughout the purchasing process.
Online Contract Management processes enable internal and external customers to perform data changes on service contracts.
With CCW 4.0, Services are attached to either Major line level and/or attached to Minor line level.
With CCW 6.0 Redesign the Product Upgrade Tool Process and With CCW 7.0 enhance the capabilities surrounding Disti Reseller model by capturing Order BID on the Contract.
CCW Applications are part of Oracle ERP Software Platform and the primary modules are IB, SA.
to 05/2010 Company Name – City
This Synergy enables the next level of Cisco's business growth, by transforming commerce capabilities.
It will accelerate Cisco's ability to provide its customers and partners with a world-class configuration, pricing and user experience for all of Cisco s offerings.
Cisco's customers and partners require new or improved commerce capabilities such as usage-based pricing for software, network-level pricing for services, and a dramatically improved configuration and pricing experience.
to 04/2008 Company Name – City
McGraw-Hill Construction connects people, projects and products across the design and construction industry.
From project and product information to industry news, trends and forecasts, it provides industry players the tools and resources that help them save time, money, and energy.
to 09/2006 Company Name
This system helps a building a system with enterprise-wide connectivity capability to effectively manage and improve the efficiency of process involved in the area of advertisement.
This system can be conceptualized in terms of the following modules.
Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.
Job Titles Held:
Senior Oracle Developer
Lead Oracle DBA
Create a job alert for [job role title] at [location].