| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Mobile: PHONE NUMBER AVAILABLE E-Mail: EMAIL AVAILABLESummaryHighly Proficient with close to 14 years of experience in diversified fields of System Analysis, Application Development, Design, Integration and Testing.Hands on working experience as Oracle PL/SQL DeveloperExperienced in Oracle ERP cycle like, Order to Cash and Procure to Pay and in modules like General Ledger, Account Receivables, Account Payables, Purchase Order, Install Base, Service Agreement and Order Management.Expert in creating Database objects like Tables, Views, Indexes, Procedures, Packages, Collections, Materialized Views, Partitions, Complex Stored Triggers, and User Defined Functions to facilitate efficient data manipulation and consistent data storageExperienced in Oracle Forms and ReportsExperience in Query Optimization & Performance TuningExperienced in UNIX Shell Scripting.Experience in loading data from CSV/TXT formats to Oracle through SQL LoaderDebugging and troubleshooting of errors in ETL jobsHands on in tools like JIRA, GitHubExcellent skills in using Client/Server architecture in implementing Oracle based applicationsExperience in Waterfall, Agile and Iterative SDLC methodologiesConversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development, Testing, and Implementation.An excellent team player with good communication skills and hardworking. Aggressive in acquiring new skills, innovative in programming methodology with excellent debugging skills. Good at client and team interaction and coordination.Technical SkillsOperating System - Windows, UNIXDatabases - Oracle 11g, SQL and PL/SQLOracle ERP - O2C and P2P CycleUser Interface - Developer Suite 10g (Forms & Reports)Tools & Utilities - TOAD, SQL Developer, JIRA, GitHub and SVNEducationMaster of Science in Computer Science from Osmania University, India, 2001.Bachelor of Science in Computer Science from Osmania University, India, 1998.Professional ExperiencePrimo Waters North America 12/2022 till dateSoftware Engineer, Irving, TX, USAPrimo Water is a leading pure-play water solutions provider in North America and Europe. Primo Waters revenue model is its industry leading line-up of innovative water dispensers, which are sold through retail locations and online at various price points. Primo Water delivers sustainable hydration solutions and water filtration units across its 21-country footprint direct to customers, whether at home or to businesses. Primo Water is committed to its water stewardship standards and is proud to partner with the International Bottled Water Association (IBWA) in North America as well as with Watercoolers Europe (WE), which ensure strict adherence to safety, quality, sanitation, and regulatory standards for the benefit of consumer protection.Contributions:Oracle forms development with PL/SQL coding.Coding and Development to meet the new business requirements.Wrote conversion scripts using PLSQL, stored functions, procedures and packages to load data from flat files to oracle tables.Involved in ETL Development using Oracle SQL*Loader and PLSQL.Designed and developed ETL processes to extract and load data from multiple sourcesProvided troubleshooting support for ETL processesPartitioned large tables using range partition techniques.Unit Testing. Supported QA and resolved the defects raised by QA.Providing Functional and Technical support to ApplicationCreating new and customizing existing Oracle APIs as per business requirements.TRACFONE Wireless 06/2020 11/2022Sr. PL/SQL Developer, Hyderabad, IndiaTracFone Wireless, Inc. (TFWI) is an American prepaid, no-contract mobile phone provider. It operates as a mobile virtual network operator (MVNO), holding agreements with the US largest wireless network operators to provide mobile services. As a part of the FCC (a US government agency) sponsored Affordable Connectivity Program (ACP), Tracfone Wireless now offers a free service plan to customers that qualify for ACP under various Tracfone Brands till the program ends.Contribution:Coding and Development to meet the new business requirements.Used Bulk Collections for easy retrieval of data, by reducing context switch between SQL and PLSQL engine.Created PLSQL scripts to extract data from tables into flat text, CSV files using UTL_FILE package.Worked on SQL*Loader to load data into tablesPartitioned tables and created materialized views to enhance the performanceUsed Pragma Autonomous transaction to avoid mutating problems in database triggerDesigned monitoring and alerting mechanisms for ETL jobs that reduced critical incidentsAssisted in the standardization of the ETL process which increased repeatability and reduce manual interventionUnit Testing. Supported QA and resolved the defects raised by QA.Involved in preparing Quality documents like Defect Status Report and Issue Log etc.Johnson Controls 02/2012 10/2019Lead PL/SQL Developer, India, USAJohnson Controls (formerly known as Tyco IS), is a longtime leader in life safety and property protection serving over one million customers across United States and Canada. Delivering industry-leading solutions in buildings and environments where life-safety protection is vital from schools, universities and hospitals to commercial properties, industrial buildings, and government facilities. Johnson Controls currently has its IT applications running on Oracle Applications Release 12.0.4Contribution:Wrote Stored Procedures, Functions, Packages, and triggers using PL/SQL to implement business rules and processes.Used advanced SQL like analytical functions, aggregate functions for mathematical and statistical calculations.Optimized SQL used in reports to improve performance.Worked with Business users to gather requirements for developing new Reports or changes in the existing Reports.Extensively used SQL*Loader scripts to load legacy data into Staging tables and relevant Packages to validate and cleanse data.Created Cursors, Collections and DB Triggers.Worked with Bulk Collects to improve the performance of multi-row queries by reducing the context switching.Set up batch and production jobs through Request SetsInvolved in debugging and tuning the PL/SQL code.Tuned SQL queries using tools like EXPLAIN PLAN, and TKPROF to significantly improve the system response, time, and efficiency.Canon April 2010 January 2012Sr. PL/SQL Developer, Hyderabad, IndiaCanon is one of the world's leading providers of document management and printing for professionals, high speed digital production printers and wide format printing systems for both technical documentation and color display graphics. Canon is also a foremost supplier of document management outsourcing. Canon currently has its IT applications running on Oracle Applications Release 11.5.8Contribution:Designing and preparing technical documents after analyzing functional requirement documents.Coding and development of packages in packages, procedures, cursors, tables, views and functions as per the business requirements.Unit Testing.Supported QA and resolved the defects raised by QA.Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data.Written complex SQLs using joins, sub queries and correlated sub queries.Handled errors using system defined exceptions and user defined exceptions.Creating INDEXES to avoid the need for large-table, full-table scans for fast retrieval of data.Used Collections for accessing complex data resulted from joining of large number of tables.CISCO August 2007 March 2010Estimate to Quote Conversion, Team Lead/Sr. PL/SQL Developer, Hyderabad, IndiaThe Quoting & Ordering; a CSCC application includes the ability to create, view, validate Quotes and submit it to order. On submission for Order, a Sales Order in generated and booked, the quote is converted to a contract and Invoice is generated successfully.An estimate is created by the user in SCC 2.0, to get the service price by providing the minimum data what is available with the user. Estimates can be created by internal or external users. This project focuses on converting an estimate to core quote by validating all the data entered by the user.Contributions:Wrote Technical Specifications based on business requirements to provide account level financial summary reports to the business customersWrote Stored Procedures, Functions, Packages, and triggers using PL/SQL to implement business rules and processes.Extensively used SQL*Loader scripts to load legacy data into Staging tables and relevant Packages to validate and cleanse data.Created Cursors, Collections and DB Triggers.Involved in debugging and tuning the PL/SQL code.Unit Testing. Supported QA and resolved the defects raised by QA.Playing an active role in preparing Quality documents like technical documents, Defect Tracking Form, and Issue Log etc.Involved in creating INDEXES and performance tuning.Used Ref cursors and Collections for accessing complex data resulted from joining of large numberof tables.Worked with Bulk Collects to improve the performance of multi-row queries by reducing the context switching.Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.CISCO February 2007 July 2007Nextlinks Product Interface, PL/SQL Developer, Hyderabad, IndiaCSCC (Cisco Service Contract Centre) Quoting Application uses Nextlink Service to perform an Export Compliance (EC) check on the products of a quote. If a product on the Quote does not exist in Nextlink Database a missing product EC hold is placed on the quote. This increases the Cycle Time of Converting a Quote into Order. To overcome this time latency an extract was developed from C3 to Nextlink to keep the Serviceable Products in syncContribution:Analysis of the specifications provided by the clientsDesign and Development.Created the Table structures.Coding database manipulations, Stored Procedure changes and creating new stored procedures and functions in Oracle.Created Cursors, Collections and DB Triggers.Unit testing. Supported QA and resolved the defects raised by QA.CISCO September 2006 January 2007CIBER B2B 2-Tier web service, PL/SQL Developer, Hyderabad, IndiaCIBER (Contracts, Installed Base and Entitlement Repository) is an Oracle 11i based application housing all of Ciscos Service Contracts and installed base. CIBER supports all sales related Service Contract activities including creating, modifying, renewing, and quoting against Service Contracts. It is also the application Cisco uses to manage Ciscos installed base.Ciscos B2B 2-Tier web service (Business to Business) is a service quoting mechanism for its products via a web service. This component is responsible for three processes which include "Creation of a quote", "Renewal of a quote" and "Add uncovered equipment to existing quote" and this web service component can be accessed by CISCO product distributors and resellers by an ERP system or web portalContribution:Wrote Technical Specifications based on business requirements to provide account level financial summary reports to the business customersWrote Stored Procedures, Functions, Packages, and triggers using PL/SQL to implement business rules and processes.Created the Table structures.Created Cursors, Collections and DB Triggers.Worked with Bulk Collects to improve the performance of multi-row queries by reducing the context switchingUnit testing. Supported QA and resolved the defects raised by QA.Involved in debugging and tuning the PL/SQL code.CISCO January 2004 August 2006QTC-SOM Migration & Support, PL/SQL Developer, Hyderabad, IndiaCisco Systems, Inc. is the worldwide Leader in Networking for the Internet. Ciscos IP networking solutions are the foundation of the Internet and most corporate, education and governments around the world. Cisco provides the broadest line of solutions for transporting data, voice and video within buildings, across campuses or around the world. Cisco has its applications currently running on Oracle Applications Release 11.5.9The Supply Order Manager (SOM) a part of Order Management (OM). An Interface to Create/Update Sales orders on Manufacturer server for each applicable Customer order created on Customer servers. It Replicate changes from Customer Servers to Manufacturing post order creation, Replication of workflow statuses, Replication of apply/release hold changes from Customer servers to Manufacturing server. Synchronizing holds and shipping information from customer server to manufacturing server and back.ContributionWrote Technical Specifications based on business requirements to provide account level financial summary reports to the business customersWrote Stored Procedures, Functions, Packages, and triggers using PL/SQL to implement business rules and processes.Created Cursors, Collections and DB Triggers.Involved in debugging and tuning the PL/SQL code.Unit Testing. Supported QA and resolved the defects raised by QA.Playing an active role in preparing Quality documents like technical documents, Defect Tracking Form, and Issue Log etc.Worked with Bulk Collects to improve the performance of multi-row queries by reducing the context switching. |
