Sql Developer

Shashank Gangimalla

ac1v4h@r.postjobfree.com Mobile 404-***-****

Summary:

** ***** ** ** ********** as an Oracle PL/SQL Developer.

Expertise in Software Development Life Cycle (SDLC) of Projects - System study, Analysis, Physical and Logical design, Coding, Testing and implementing business applications.

Expertise in using Oracle 8i/9i/10g /11g and 12c databases.

Hands on experience in preparing User Specification Requirement, Software Requirement and Technical documentation.

Experience in interacting with Business Users.

Proficient in developing and maintaining of packages, functions, application procedures, stored procedures, triggers, tables, indexes, views using Oracle PL/SQL database programming language and maintaining the DDL scripts

Oracle Applications E-Business Suite (Supply Chain Management Modules). XML Publisher reports on Oracle Applications 11i/R12.

Experience in Oracle Apps 11i GL, AP, AR, OM modules.

SQL*Loader, SQL*PLUS, TOAD, SQL Developer and WINSCP3 applications are extensively used to manage the database.

Experience on Oracle BI Publisher Reports.

Working experience in data extraction, transformation and loading operations into oracle using SQL Loader, External tables, DB links, Export/import to read and write the files.

Strong experience in developing SQL/PLSQL Scripts/Programs for Data Analysis, Extraction, Transformation and Loading (ETL) mechanism.

Extensive Experience on Materialized views, Collections like Nested Tables, Objects, Autonomous Transactions, Dynamic SQL, SQL* Loader.

Extensively worked on BULK COLLECTS, BULK INSERTS, and BULK UPDATES & BULK DELETES for loading, updating and deleting huge data

Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, SQL Trace, Explain plan and TKPROF.

Effectively used SQL* Loader to migrate data from Sprint DW to Nextel DW.

Involved in creating scripts for Creates, Alters and Data Modifications and worked with DBA for implementation.

Expertise in Optimization Techniques.

Experienced in Tuning SQL Statements and Procedures for enhancing the load performance in various schemas across databases.

Worked with Large Databases like JP MORGAN /US Bank and Sprint.

Experience in Unix Shell scripting.

Experience in Autosys and d-Series to schedule jobs and for batch monitoring.

Extensive working Experience with CVS, SVN and SYNERGY change management tools.

Experience working in On-Shore/Off-shore Development Models

Experience with JIRA used for Agile methodology.

Experience with ticketing systems (HPMS).

Knowledge of Microsoft Database SQL SERVER.

Knowledge of Javascript, HTML and PL/SQL Web Toolkit.

An excellent technical ability possesses strong oral and written communications skills, analytical and interpersonal skills.

Education:

BS Computer in JNTU India.

Technical Skills:

ETL Tools

Informatica 8.1, DataStage 7.5.x (Enterprise Edition)

Databases

Oracle 12c/11g/10g/9i/6i, SQL Server 2005/2000.

Reports

Oracle Forms 11g/10g/9i/6i, Cognos8.4, Discoverer 11g.

Programming Languages

C, SQL, PL/SQL, Shell Scripting.

Scheduling tools

Control-M, Autosys, d-Series.

Operating System

Windows 9x/NT/2000/XP, UNIX/LINUX.

ERP

Oracle Apps 11i/R12.

Oracle BI

BI Publisher Reports.

Source Control

SVN, CVS.

Others

Toad, SQL Developer, MS Word, MS Excel, MS PowerPoint,HPMS,HP PPM

Professional Summary:

The J.M. Smucker, Orrville, OH Nov’2016 – June’2017

Sr. Oracle Database/EBS Consultant

Automate the running of the manual reservation job to account for newly entered intercompany orders that have an impact to inventory we are short on

Automate the creation of dummy POs for new production not yet posted to IMI inventory that impact inventory we are short on then rerun reservation for those items. A nice-to-have asks is to delete dummy POs in IMI that were created during night batch to reflect schedule production batches that have since been cancelled.

Responsibilities:

Work closely with the User/BA’s to get requirements.

Prepaid Technical Design Documentation.

Extensively work on developing and modifying complex PL/SQL Stored Procedures, Functions, Packages, Cursors and Triggers to implement business rules into the application.

Involved in UAT testing for the application

Working with multiple application.

Modifying and developing database triggers, cursors, procedures, functions and packages to meet business requirements

Extensively involved in performance tuning using Explain Plan, Optimized SQL queries and created Materialized views for better performance.

Working in Agile Methodology.

Participated in daily standup/scrum meeting.

Analyzing the programming requirements, organizing and prioritizing those developments.

Tuning the SQL Queries for the existing applications.

Used the WinSCP3 tool and PUTTY to work in the UNIX environment

Used Embedded SQL’s in UNIX shell scripts.

Used d-Series for the job scheduling.

Working on multiple new and enhancement projects:

Responsibilities:

Create complex reports by using RTF Templates

Expertise in BI(XML) Publisher Reports Creating Data Templates and complex XML Publisher Templates

Development and Customizations of Reports using BI Publisher.

Worked on new/enhancements Discoverer reports.

Performance Tuning of complex SQL queries using Explain Plan to improve the performance of the reports.

Used Discoverer Administrator to create and refresh Business Areas.

Worked on Oracle Apps 11i, AP, OM modules.

Expertise in RTF Template(layout).

Used HPSM portfolio to deploy the code into QA and Production

Involve in Code Reviews and walk through meetings.

Environment: Oracle 12c, Toad, Windows 7, HPUX, Pl/SQL, SQL, SVN, HP Service Manager, d-Series. Discoverer Desktop, Discoverer Administrator, XML/BI Publisher, Oracle Applications E-Business Suite – R12, HP PPM.

Goodyear Tire & Rubber Co, Akron, OH Apr’12 – Nov’2016

Sr. Oracle Database Developer

The UAS is an application for generating various reports to analyze field performance of tires based on returned tires. All Goodyear regions submit data and then utilize the UAS’s analysis capabilities. The UAS has one central Oracle database in Akron, supporting regional or global analysis.

The users use a web-based, single global application via Goodyear Global Web (GGW). Requested reports are sent as e-mail Excel file attachments to the requester. The UAS database also allows a restricted number of users to do ad-hoc reporting.

Worked with multiple application’s (Support and maintenance projects)

Responsibilities:

Extensively work on Production issue reported in UAS.

Prepaid Business requirement/Technical Design Documentation.

Analysis of data to resolve various production and QAT bug fixes

Extensively work on developing and modifying complex PL/SQL Stored Procedures, Functions, Packages, Cursors and Triggers to implement business rules into the application.

Work extensively on Complex SQL scripts which are using for reporting purpose.

Bug fixing and enhancements if needed in production.

Export and import of database objects using Data pump utilities EXPDP and IMPDP.

Migrated data from Flat Files to Oracle database using SQL*Loader and External tables.

User Oracle APEX utility to load one-time historical data.

Modified existing Oracle APEX reports.

Created and managed primary data base objects such as Tables, Indexes, Sequences, and Synonyms, materialized views.

Created PL/SQL program units to include DML, DDL statements using Dynamic SQL.

Force run the job, if a job fails to complete.

Developed user documentation for all the application modules. Also, responsible for writing test plan documents and unit testing for the application modules.

Generated DDL scripts and Created and modified database objects such as tables, views, sequences, functions, synonyms, indexes, packages, stored procedures using SQL Developer tool.

Provides skills and performs tasks related to technical developments.

Used Bulk collect and Forall in stored procedures to improve the performance and make the application to run faster

Developed UNIX Shell scripts to automate table creation, execute procedures

Work closely with the User to get requirements.

Analyzing the programming requirements, organizing and prioritizing those developments.

Troubleshoot and resolve technical issue during development.

Manage change via an established change management process.

Coordinating with the Offshore Resources on an everyday basis.

Involve in Code Reviews and walk through meetings.

Prepared UNIX shell script for the transfer of files from FTP to SFTP.

Environment: Oracle 10g,11g, 12c Oracle Forms 6i,11g, SQL Developer, Windows XP, Pl/SQL, SQL, SVN, HP Service Manager, JIRA.

FRONTIER COMMUNICATIONS, Durham, NC Jun’11 – Apr’12

Oracle Database Developer

Frontier Communication is one of the most reputed telecommunication Company taking on Verizon wired

Phone businesses for almost 13 states now and still expanding. I have worked here primarily for Carrier-to-Carrier Performance information given to Competitive Local Exchange Carriers project. Simultaneously have been working on various other reports like Performance assurance plans for penalty information of the customers.

Responsibilities:

Involved in the reporting for all the eligible states for C2C which contains the performance information.

Generated the reports for C2C in .txt, .html, .csv formats.

Extensively Involved in Performance Tuning the PL/SQL code written for C2C reporting project.

Involved in the reporting for state west reports which contains both performance and penalty information of customers.

Generated state west reports for IL, NV and OH States in excel format.

Extensively used Dynamic SQL.

Implemented new functionalities for existing applications.

Written PL/SQL scripts to create new tables and their corresponding database sequences, synonyms, indexes, and constraints and PL/SQL packages.

Work with the QA teams in resolving the Quality center defects and support them in QA testing activities for QA code drops.

Environment: Oracle 11g, TOAD, Windows XP, Pl/SQL, SQL.

JP MORGAN CHASE, Jersey City, NJ Oct’10 – May’11

Oracle Database Developer

Worked for JP Morgan Chase Investment Banking team, dealing with trading and equity related front end based application. Artemis is JPMC IB’s cross-product (across Equities, Credit and Rates), cross-region (across NA, EMEA, Asia) client profitability platform. It receives trade and revenue details from Nectar and Verve.

Responsibilities:

Involved in the integration of existing V-DMA application, A-DMA application, V-Dashboard and Arachni applications in single web based new DMA system.

Extensively Involved in Performance Tuning the PL/SQL code written for both the V-DMA and A-DMA applications.

Implemented new functionalities for existing applications.

Partitioned large tables to maintain data of few tables.

Created local indexes on partitioned tables to improve the performance.

Involved in resolving most performance issues and bottleneck issues.

Worked on Oracle 11g Database using Sql and Pl/Sql.

Created GTT for the performance.

Worked on Table Partitioning and deploying various methods of indexing like local Indexes and Global Indexes on partitioned tables.

Performed PERFORMANCE TUNING of the tables and queries by using HINTS, defining

INDEXES, PURGING TABLES, set up periodic scheduled maintenance tasks like EXPLAIN PLAN

Written PL/SQL scripts to create new tables and their corresponding database sequences, synonyms, indexes, and constraints.

Performance tuned the whole code to meet the deadline of deployment.

Involved in UAT testing of the application.

Work closely with the testing team to provide them with necessary testing information.

Environment: Oracle 10g, TOAD, Windows XP, Pl/SQL, SQL, SVN.

ELAVON (US BANK), Atlanta, GA Jun’09 – Sept ‘10

Oracle PL/SQL Developer/Cognos Developer

Elavon part of US Bank is implementing Credit card processing system which maintains all day to day card transaction at merchant and Funds the merchant. End-to-end processing solution helps you improve cash flow, minimize your collections risk, and better serve your customers while meeting stringent security standards to protect cardholder data. Extensive cross-border and multi-currency processing eliminates the need for multiple in-country processors as your footprint expands around the world.

This project was initiated to support contact for authorization, settlement, funding, and support for all your Visa®, MasterCard®, and Discover® credit and debit card transactions. In addition, it processes the following over network: PIN debit, Electronic Benefits Transfer (EBT), corporate purchasing cards, Fleet cards, American Express

Responsibilities:

Worked extensively with Business User to gather requirements and implemented those using Stored Procedures.

Extensively worked in developing Cognos reports for the Merchant processing system.

Developed Cognos Framework Models in Oracle.

Worked with High Transaction volume data to increase the Performance of stored procedures Using Explain plan and Hints.

Extensively worked in developing Complex PL/SQL Stored Procedures, Functions, Packages, Cursors and Triggers to implement business rules into the application.

Worked extensively on Complex SQL scripts which were used for reporting purpose.

Extensively involved in performance tuning using Explain Plan,Optimized SQL queries and created Materialized views for better performance.

Worked Extensively In setting up Batch Process Using Autosys Scheduler.

Worked on deploying the code using the version controls tool.

Created reports using Cognos and automated scripts to validate the integrity of the data based on end user needs.

Created standard filters, calculation prompts, and conditions.

Analyze, designed, developed, implemented complex models and reports.

Ensured all artifacts complied with corporate SDLC Policies and guidelines.

Written PL/SQL scripts to create new tables and their corresponding database triggers, sequences, synonyms, indexes, and constraints.

Designed Oracle tables, views, synonyms for the application.

Developed various jobs using stages Oracle enterprise, Lookup, Dataset, Join, Sort, Aggregator, Filter, Modify, Funnel, Peek (debugging stage), Funnel, and RDBMS stages extensively.

Worked with QA team to design test plan and test cases for User Acceptance Testing (UAT).

Developed Views which were used for reporting purpose.

Environment: Oracle 10g, TOAD, Windows XP, Pl/SQL, SQL, Cognos8.4, UNIX. DataStage 8.1, DataStage 7.5.2 (Enterprise Edition), Autosys.

Sprint Nextel Communications, Reston, VA Apr’07 – May’09

Oracle Pl/SQL Developer

Sprint Rate Plan Optimizer (SPO)

This project will implement a rate plan optimization solution integrated into the online shopping and e-care experience, to ensure customers have the right plan and services most closely associated with their needs. This will decrease calls to care Decrease call handle time for care Increase conversion rates for web sales, tele sales, retail Decrease credits in care and retail Increase customer satisfaction Increase customer lifetime value.

C8 NDW Split CARD (UBP Conversion)

This effort will support the eighth conversion effort of the UBP Program. Moving approximately 2M subscribers from P2K to Ensemble.

Roles and Responsibilities:

Responsible for application development using Oracle, SQL, PL/SQL, packages, stored procedures, SQL*Loader and UNIX Shell scripting

Performed PERFORMANCE TUNING of the tables and queries by using HINTS, defining INDEXES Etc...

Partitioned large tables to maintain data of few tables.

Created local indexes on partitioned tables to improve the performance.

Developed UNIX Shell scripts to automate repetitive database processes

Loaded the files for the UBP conversion from P2K (Sprint) to Ensemble (Nextel) using SQL Loader.

Used Embedded SQL’s in UNIX shell scripts.

Used SQL* Loader to migrate data into from Oracle 8i to Oracle 9i.

Environment: Oracle 9i (Version 9.2.0.6.0), SQL, PL/SQL, SQL*Loader, HP-UNIX (9.2.0.7.0), Shell Scripting, TOAD (Version 8.6.1.0), PUTTY (0.55 Release), WinSCP3.

STRS, Ohio Nov’06-Apr’07

Oracle PL/SQL Developer.

Pension & Benefit Planning.

STRS Ohio receives a file monthly of persons who have had a date of death (DOD) reported to Social Security. This file is matched to members, recipients, and beneficiaries in our system. If a match is found, the reported DOD is matched against our system. A non-match condition exists when the DOD is not equal or the DOD is missing in our system.

Responsibilities:

Interact with business analysts to develop modeling techniques and re-structuring strategies

Modifying existing SQL code and performance tuning if necessary.

Wrote Stored Procedure, Package for back end validations

Wrote Procedures using Oracle supplied Packages

Read data from flat files and uploading that data into oracle tables using SQL*loader.

Created test Cases as per the business requirements and executed them.

Provided Test Data to QA team to validate front end application. Also performed unit testing.

Environment: Oracle 9i, 10g, PL/SQL, PL/SQL Developer, Windows XP Pro.

Autarchy Technologies, India Apr'05 – Mar’06

Jr.PL/SQL Developer

E-commerce online system

Aim of this Project is to provide the basic functional elements that involve registering users, login, and purchase items. Users can log in, change their personal account information, view their portfolio, and buy items. This Project consists of Admin Module and Warranty Center Module. Warranty center gives the details about the warranty given on the items. With the help of this the consumer can know how much warranty time is left of the product.

Responsibilities:

Wrote Stored Procedure, Package and Triggers for back end validations.

Involved in team meetings, preparing Meeting minutes.

Code base consists of complex package logic that uses DML and writes all SQL executed to log tables for troubleshooting, and logic that processes logistical data for optimizing selecting a product and its features available across different companies. Measuring and reporting product list using Excel, PL/SQL scripts.

Wrote complex SQL queries using joins and correlated sub queries

Environment: Oracle 9i, (SQL*Plus, PL/SQL Developer), Windows, MS Office 2003 (Excel, Word).

Contact this candidate