We provide IT Staff Augmentation Services!

Sr. Developer And Analyst Resume

San Jose, CA

SUMMARY:

  • 8 years of experience as Oracle PL/SQL Developer Application Development - Analysis, Design and Implementation of Business Applications.
  • Strong Exposure in writing simple and Complex SQLs, PL/SQL Functions and Procedures, Packages and creation of Oracle Objects - Tables, Functions, Packages, Materialized views, Triggers, Synonyms, User Defined Data Types, Nested Tables and Collections.
  • Proficient in writing complex SQL Queries, stored procedures, Normalization, Database Design, creating Indexes, Functions, Triggers, Sub Queries
  • Proficient in tuning SQL queries using HINTS and EXPLAIN PLAN.
  • Designing and developing application schemas, ER Diagram, Tables (Partitioned Tables, Index Organized Tables, External Tables and Global Temporary Tables), Clusters, Indexes, Views, Materialized views, Triggers, Procedures, Functions and Packages.
  • Experience in advanced PL/SQL concepts like Bulk collect and FORALL. Expertise in Dynamic SQL, Records, Arrays and Exception Handling.
  • Experience in writing UNIX Shell Script.
  • Interacted with business users, collected the requirements, analyze the requirements, design and recommend solutions.
  • Experience in translating business requirements into creation of Database Objects.
  • Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
  • Good ability to quickly grasp and master new concepts and technologies.
  • Strong problem solving & technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction.
  • Involved in all phases of the SDLC from analysis, design, development, testing, implementation, maintenance and support with timely delivery with aggressive timelines.
  • Excellent written and verbal communication skills.
  • Proven proficiency in multi-tasking skills.
  • Oracle Certified Professional - OCP Passed in April 2014

TECHNICAL SKILLS
Database: Oracle 8i, 8i, 10g, 11g
Programming Languages: Oracle SQL, PLSQL, UNIX Shell scripting, Core Java, C, C++
Web Technologies: Servlets, JSP, HTML
ERP: Oracle Application 11i/R12 (AOL)
Operating Systems: Windows (XP/7/200). UNIX (Sun Solaris, HP-UX, Linux)
Tools Toad, Oracle Forms, Reports, PVCS, Microsoft Visio, SQL Developer,
Oracle Workflow Builder, SVN, SQL*PLUS, Kintana, SSH, MS Office

PROFESSIONAL EXPERIENCE
Confidential,San Jose, CA
Cisco Offer Attribution (Config-NPI)
Lead IT Analyst
Leading provider of networking devices that transform how people connect, communicate and collaborate. Worked on Oracle PLSQL, project that adds and incorporates new business rule to the web based Discount System to give multiple product discounts to the partners
Responsibilities
  • Provided Technical Solution for implementing Cisco' Offer Attribution Business process.
  • Acted as a liaison with Program team and development on (but not limited to) requirement gathering, solution designing, technical designing.
  • Participate in the Business Requirement gathering sessions to understand requirements
  • Creating the Functional Specification Document based on the BRD
  • Creating User Training Documents for the Business Users as part of User Training
  • Work with the development to provide technical guidance for designing the applications - table designs, packages structures and overall application design.
  • Writing object types, bulk collect and FORALL insert to load the data using the nested tables.
  • Using Merge statement for incremental loads and WITH statement.
  • Creating packages, procedures, functions, triggers
  • Wrote pipelined table functions to load the data from one table to another tabl.
  • Using hints to tuned the SQL queries.
  • Developed SQL Loader Scripts to load the data from comma separated file into the oracle table
  • Work with QA team to verify/review the test scenarios and test cases
  • Getting all the deliverables completed on time
  • Designing a workflow based business process
  • Automated the process of maintaining the owners of the Technology Group, Business Unit and Product Family.
  • Unit testing of the process that was automated.
  • Coordinated with the cross track team in implementing the solution and resolving any cross track related issues.
  • Developed the SQL queries to fetch the data from the Oracle ERP standard tables of PIM module
  • Work with the business users to complete the BAT and UAT
  • Testing the application for any functional issues.
  • Provided support in end to end testing that involved cross track teams.
Environment: Oracle SQL, PLSQL, Oracle APPS R12, Oracle Concurrent Programs, Oracle Workflow, Oracle 11g, Microsoft Visio, Toad 12, Kintana, SVN

Confidential,San Jose, CA
LSS (Large Scale System) SJPROD Retirement (Oracle 11i to R12 Migration)
Sr. Developer and Analyst
Responsibilities
  • Key Role in analyzing the impact of Oracle R12 migration on existing business process of the service operations like pricing, service-product mapping, service SKU creation.
  • Preparation of Business and Functional Requirement documents (BFD)
  • Designing a new integrated system those are easy to use, reliable, and efficient - Removing the functionality from the legacy systems and integrating them with new tools and process.
  • Worked for Oracle 11i to Oracle R12 migration.
  • Worked on Oracle R12 Form Personalization – BOM Module – (BOM Define Screen)
  • Worked on implementing the custom HOLD on service SKU and products like New Product Hold, CSM Hold, Invoice Hold etc.
  • Writing SQL queries to extract the data from the Oracle R12 tables as per the new logic.
  • Setting up table to table replications from different databases using oracle Golden Gate technology.
  • Providing solution based on the new requirements without impacting existing key processes
  • Working with various cross flow team to get work completed, get firm handshake on data flow to downstream systems, worked with setting up Golden gate replication system and data migration
  • Coordinating with offshore team in conducting daily, weekly meetings, tracking progress of the deliverables.
  • Participate in design review, code review, test scenario review, deployment and delivery of the code.
  • Developed SQL loader scripts for migrating application specific data.
Environment: Oracle R12, Form Personalization, Concurrent Programing, SQL, PLSQL, SQL Tuning, Selectica, UNIX shell Script, Oracle Golden Date, Oracle 11g

Confidential, CA
Integrated Decision Support System (IDSS)
Oracle PL/SQL Developer

Responsibilities:
  • Tuning of the Standard Oracle APIs for BOM Explosion Process by Table partition that reduced the time for BOM explosion process from 40 hours to 20 min.
  • Create Oracle Concurrent Programs with PLSQL and UNIX as executable.
  • Worked on Tuning the SQL programs using Toad SQL Optimizer
  • Implementing Oracle 11i APPS Form enhancement in Oracle INV module.
  • Implementation of all Oracle PLSQL (backend) enhancements that included writing new packages, procedures, triggers, creating new sequences, creating new tables, setting up replication using Oracle Advance Queues in Cisco' custom tools.
  • Participating in the weekly business requirement gathering session.
  • Writing the Functional Requirement documents based on the BRD.
  • Working with the offshore development team for delivering the project within timeline.
  • Fixing the issues raised by client, supporting the application until stability.
  • Guiding the team on complex enhancements.
  • Analyzing the impact on existing database objects like packages, triggers and programs, of Oracle 9i to 11g migration of ODS (Operational Data Services) database
  • Making the PLSQL changes and migrating application specific database objects.
  • Providing solution on migrating the PLSQL program that reside on different database.
  • Involved in the backend migration of SAM, Returns Tool.
  • Responsible for data migration.
  • Worked on generating the Cisco monthly price files used by Cisco Partners for ordering services.
  • Worked on Oracle APPS 11i custom forms. - Product Family Assignment to Service Level.
  • Getting the requirements from the client, analyzing them, preparing the technical specification documents on the basis of the BRDs / FSDs.
  • Coordinating with the offshore team to get the requirements done.
  • Fixing the issues raised by the client at the client side in business hours.
  • Analyzing, Designing, Development, Unit Testing and Deployment of the oracle apps forms enhancements.
  • Responsible for fixing any production support EBF (Emergency Bug Fix) related to PLSQL and UNIX.
  • Responsible for implementing enhancement related to the backend application CDB (Cisco Data Bus).
  • Responsible for deployment process using Kintana, PVCS.
Environment: Oracle PLSQL/SQL, Oracle APPS R11i, Forms6i, 9i, Selectica, Unix shell Script, Core Java, UNIX Shell Script, SQL Loader, Toad, SQL Developer.

Confidential,Hyderabad, INDIA
Developer
Responsibilities
  • Implementation of all Oracle PLSQL (backend) enhancements in OPUS and other tools.
  • Analyzing, Designing, Development, Unit Testing and Deployment of the oracle apps forms enhancements.
  • Setting up of the BT and Publishing in the release environment. BT and Pushing is a completely UNIX based backend application which processes the data of the products in the tables, creates KBS (Knowledge bases) and publishes the KBS.
  • Responsible for fixing any production support EBF (Emergency Bug Fix) related to PLSQL and UNIX.
  • Responsible for deployment process using Kintana, PVCS.
Environment: SQL,PL/SQL, Oracle 9i, UNIX Shell Scripting, JAVA,JSP OPEN CVS, VSS, SQL Developer, Toad,

Hire Now