SUMMARY

• An OCP Certified Professional mainly worked on Production/Application support,developement and enhancements Projects.
• More than 10 years of vast IT experience with production support/enhancement projects in Oracle, Oracle Apps,Business Objects, UNIX,PL/SQL,Oracle Forms/Reports.
• Good expereince in troubleshooting and bug fixing,change request and maintainace of the projects.
• Very strong in data analysis.
• Good in resolving production application tickets and familiar with Remedy system.
• Develop Web applications (Oracle PSP) as per the requirement using Oracle PL/SQL.
• Hands - on experience MS tools and Oracle tools including Apps and API.
• Working knowledge of Data Warehousing concepts.
• Involved in analysis phase of the Application Development Cycle in various projects.
• Customization in various applications using Oracle and custom ERP applications.
• Good working knowledge in UNIX and UNIX shell scripting.
• Good SQL knowledge and extensive working on Oracle tools.
• Extensive working knowledge in tools like TOAD, Oracle SQL Loader, SQL Plus.
• Good exposure to AD-PARALLEL Load strategy.
• Good in Client Interaction, Communication, Requirements Gathering and Analysis.
• Highly experienced in onsite off-shore model.
• Expereince in Data Modelling.
• Strong in Data warehouse concepts.
• Exposure to Seiebel application systems
• Good on Proper and Well-written Documentation of the programs and New Applications developed and / or Customized / Modified.
• Good team player with excellent Interpersonal Skills and Self-starter, capable of Working Independently.
• Worked on migration projects converting MySQL,PHP to Oracle.
• Good in setting project goals and achieving it, Highly Result-Oriented.
• Worked extensively on Production Support Projects in technologies as Oracle PL/SQL, Forms, Reports, XML Publisher, Tableau and Business Objects and is very flexible.
• Works on Rally software and Agile methodology.
• Ready to relocate anywhere in US.
• Exposure to Siebel Call Center 8.1.

TECHNICAL SKILLS

Databases: Oracle 11g/10g / 9i / 8i

Languages: SQL, PL / SQL, PL/SQL pages, Oracle Forms 6i/9i, Oracle Reports,6i/9i

Operating Systems: UNIX, Microsoft Windows XP / NT

Internet Tools: TOAD, SQL*Plus, SQL*Loader,Business Objects 6.5,Version ControlOracle Applications Incentive and compensation module, PHP,XML Publisher,Oracle API,Rally,Putty,WinSCP,ER/Studio,Tableau 7.0,Perforce,Talend DQ/HQ,Delphix,Confio,JIRA,FootPrints,Splunk,Sharepoint,DataHub,AppDynamics,Omniture

Office Tools: MS Word, MS Access, MS Excel,MS Visio

PROFESSIONAL EXPERIENCE

Confidential, San Francisco,CA

Sr Oracle Developer

Responsibilities:

• Analyse the requirements for the complany launch of opening UK site.
• Creating DSDD (Data Service Design Document)
• All package/procedure changes related to existing/new application.
• Pre-populate the production tables through SQL loader when the site is up.
• Post - production support to beta site designed for UK customers.
• Developing code in unix and oracle to support new functionality.
• Co-ordinating with Data Modeller for new changes and implement in DEV/QA environments.
• Production support on International domain as wells as Siebel,Sales and Buy streams.
• Data Loading of all special characeters into database needed for Italy,Switzerland,Sweden and other EU countries.
• Events,Logistics,Content and Help Content refresh of data (authomated process which truncates and reloads related tables fromm production) as per requirement.
• Day to day production updates(inserts/updates or bulk insert/update) through footprint.
• Involve in new european site (.eu site) which just about to launch and in process-requirements gathering/planning phase.
• Help possible database script or data issues during release window on night, co-ordinating with REG,DBA or release teams.
• Tune siebel application queries and modifies database views required to add new functionality for international business.
• Support to UK business users on new functionality.
• Worked with events team to create new events for US and UK site.
• Developed cron jobs in unix and also oracle job scheduler.
• Conversion project (PaidSearch) from MySQL,PHP using using Apache Tomcate 6.0 server to Oracle and resolve all db issues during migration.
• Execute db scripts across environments (about 100 schemas) using internal dbtool.
• Keep QA environement upto date with all db scripts that would go as part of release and resolve issues if any.
• Generate reports for data warehouse using business objects.
• Some exposure to MongoDB and Hadoop.
• Tokenziation of production sensitive data for Dev/QA schemas.
• Helped Reg team to fix database issues during schema creation using delphix.
• Export-Import postcode data for UK/EU countries to production with special language characters and to enhance performance.
• Support QA for database issues on PE environments while duing performance testing.
• Developed code for data warehouse and business objects requirements and resolve data issues between ecommerce and data warehouse.
• Co-ordinate with postcode vendors and help client buy postcode data during UK release and Cross Border Trade project.
• Wrapping package for credit card data.
• Partitioning large tables to enhance performance in production.
• Used sql loader to load the data based on need (for update/insert) in production through 2 to 5 release window.

Environment: PL/SQL, Oracle 10g, Toad,UNIX,Perforce,PHP,MySQL, JIRA,FootPrints

Confidential

Responsibilities:

• Write native sqls to help company initiative to go from Fedex to UPS
• Modifying existing code (package/procedure/functions)
• New tables, seed data population.
• Continuous interaction with business and understanding requirements.
• Involved in complate qa testing.
• Post production support.
• Developed intranet sql queries for business users so they can repeatedly use in stubtext tool.
• Verifying databse errors on splunk during Dev/QA testing.(check ora errors in splunk for last 4 hrs or so)
• Manage versions of all database code in perforce and keep perforce version of database views,functions,packages,procedures,materiazed views up-to-date as per production database.
• Create schema and database objecrs ddl and dml for Golden dataset project, ideal data for QA to do their testing.
• Schema management,keep all dev/qa schemas (data and code) up-to-date as per production.
• Help fix db issues for dev/qa.
• Update sharepoint with all project related documentation and DSDD.
• Clears and monitor space on dev unix box.
• Pullying data from production through LODG database (1 hr lag) for busniess requirements and analyze the requirements.
• Invloved in data modelling work.

Environment: PL/SQL, Oracle 10g, Toad,UNIX,Perforce, JIRA,FootPrints

Confidential

Responsibilities:

• Modification in existing database views
• Performance tuning for existing databse views. Testiing in QA Performance tuning for existing databse views. Testing in Dev and QA environment for functionality and performance.
• Support Siebel release and also ecomm release. Updating release instructions for release and due deligence for all db scripts before handover to DBA. Post production support.
• Understanding new requirements from business and code the views.

Environment: PL/SQL, Oracle 10g, Toad,UNIX,Perforce, JIRA,FootPrints

Confidential, San Jose,CA

Sr. Oracle Developer

Responsibilities:

• Developed pl/sql code as part of Comp Plan Optimization project.The code will help in adding or deleting generic plan elements to/from all IT comp plans attached to the Business Comp Plan if any generic plan element is added in business comp plan through front-end UI.
• Troubleshooting the issues and analysing the impact in the system.
• Bug fixing the reports using xml publisher issues and modifies the report and test it in development and stage environment.
• Change request for any additional enhancement, testing and help in deploying in the production.
• Communicatiing with offshore team for any pending issues in the comp plan optimization project.Sanity testing for the other developemtn activities performed by other developers.
• Other Database activities required in the project.

Environment: Oracle Apps,PL/SQL,Oracle API,XML Publisher, Oracle 10g, UNIX,Java,pl/sql developer

Confidential, San Francisco,CA

Sr Oracle Developer

Responsibilities:

• Involved in analysis of the Source system application.
• Analysing the impact analysis to separate the two database system to reduce the dependencyf credit view application.
• Writing a oracle queue which will enqueue the data from credit view system then dequeue the data and write it to remote database application.
• Complete testing of new application developed and involved in Sit and UAT testing environment.
• Other day to day database related activities.

Environment: PL/SQL., Oracle 10g, Oracle Queue,UNIX,Java,toad

Confidential, Milpitas,CA

Sr Oracle Developer

Responsibilities:

• Involved in complete analysis of the Source system database as well as Target system
• Involved in all transformations from source to target database.
• Interact with business and IT users for the business requirements.
• Good exposure in loading data (Database size—1.5 TB) from source system to stage and then to target system using Ad-Parallel technique.
• Involved in creating all required DB objects including tables, views, synonyms and indexes.
• Partly developed ETL code using PL/SQL for Full Load and Incremental Load based on the requirements for the table.
• Extensive usage of Oracle Toad, SQL Loader and SQL Plus tools in the project.
• Extensive testing of ETL code with millions of data involved and helps QA in resolving defects.
• Helped Business IT in resolving various issues.
• Interact with downstream applications and help them in identifying potential issues that may occur during production.
• Maintain complete Metadata for the project and involved in writing HLD document for the project.
• Worked with offshore team and resolve the issues they faced.
• Part of team who schedules ETL code using Dollar Universe tool.

Environment: PL/SQL., Oracle 10g, UNIX, Dollar Universe,pl/sql developer

Confidential, San Jose,CA

Database Analyst/Developer

Responsibilities:

• Worked as a support analyst from offshore team.
• Purely SOX based approval and huge Finance P1 (Priority 1) application where distributors (all over the world theatre wise) submits POS/Inventory/Claim data along with Promotions.
• Processing of data/ validation of pos data/validation of promotions/posting of data by Financial Analyst with Claim generation. Then claim validation/Memo creation.
• The application is highly important and centralized where multiple chain of Upstream (other application provided data to it) and Downstream (processed data been provided to other application)
• Project involves maintenance of application worldwide (with all 6 regions including US,CANADA,APAC,EMEA,JAPAN,Americas INTL)
• Frequent client communication for the day to day issues in the application. Help them in implementing business requirements and new releases in the application.
• Daily health check of application as well as urgent data-fix as and when required.
• Enhancement and developing new forms and PL/SQL codes for new projects.
• Involved in successful release of database code enhancement / oracle forms as RCA (root cause analysis).
• Excellent client communications (Users and Financial Analyst/business head) and day to day updates regarding the smooth functioning of application.
• Drawing plan and documents for RCAs (Root Cause Analysis) involved in applications and roll-out it in production with quality and extensive testing.
• Understanding new Cisco business and taking new requirements

Environment: PL/SQL., Oracle 10g, UNIX, Dollar Universe,pl/sql developer

Confidential

Oracle Developer

Responsibilities:

• Understanding the enhancements as per new Business requirements to be done in existing application. Mainly worked on Production support of projects including 7 Universe and 150+ reports.
• Involved in day to day maintenance.
• Involved in modifications in Universe as per new/changed Business flow. Modified the existing reports as per the requirement of Business Users.
• Developed new BO reports using Thick client.
• Uploading the Data provided by Business Users by uploading Excel and Text files and the data present in database and doing the analysis.
• Involved in the roll-out or implementation of new BO applications developed.
• Developed Business reports using Personal Data Files.
• Developed n number of Ad-hoc reports includes Cross Tab reports, Charts, graphs and regular tables.
• Managing Data Providers.
• Creating the reports from Excel files using Business Objects and Converted the reports to PDF, Text File format as per the User requirement
• Interacted with Business Users for the Business Reporting Requirements and analysis, Preparing well
• Documentation of requirements about reporting specifications/layouts
• Scheduling of BO 6.5 reports in off-peak timings and ensure the smooth scheduling with refreshed and latest data available to the business users as per their requirements.
• Well Training to the key Business Users about the use of BO tool and use and functionality of new BO reports.

Environment: PL/SQL, Oracle 9i, BO 6.5,toad

Confidential

Software Consultant

Responsibilities:

• Involved in Application analysis, Design, Coding, Testing, Development and Implementation.
• Authored PL/SQL and SQL Scripts required for day to day maintainace in Production support
• Modified Stored Procedures, Stored Functions, Packages as enhancements to existing applications.
• Involved in Maintenance & Enhancements of the existing applications using PL/SQL code.
• Well maintained the Quality of Applications developed as well as customized.
• Consistent interaction with the End Users and implemented reviews/feedback of the application.
• Tune the large Production Database and improved its performance.

Environment: PL/SQL, Oracle 9i, Oracle Forms 6i, Oracle Reports 6i, UNIX, UNIX Shell Scripting

Confidential

Programmer

Responsibilities:

• Develop online application as per the requirement using Oracle PL/SQL
• Involved in Analysis, Design, Coding, Testing, Data conversion, Development and Implementation.
• Support to Post-development to applications using PL/SQL.

Environment: PL/SQL, Oracle 10g, Oracle Forms 6i, Oracle Reports 6i, Windows XP,toad

Confidential

Programmer

Responsibilities:

• Provides the technical support to the users in day to day isues.
• Develop new forms as per requirement and enhance/modify the existing forms as per new logic.
• Develop new reports and/or ad hoc reports as per user requirement

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