Resume

Sign in

Pl/Sql Developer

Location:
Fremont, California, United States
Posted:
October 25, 2016

Contact this candidate

Resume:

Name: SRAVANI ADDANKI

Skills: PL SQL DEVELOPER

Phone: 650-***-****

Email: acw8df@r.postjobfree.com

Summary:

Around 5+ years of professional IT experience in Oracle environment in all aspects of Software Development Life Cycle (SDLC) – in Data Modeling, Designing, Developing, and maintaining database related applications.

Extensive knowledge and work experience in System Analysis, design and development of database applications in Client/Server applications using Oracle 10g/9i/8i, SQL, PL/SQL, SQL*Loader.

Expertise in leading a team of 5 resources. Proficient in developing concurrent programs using SQL, PL/SQL and UNIX Shell Scripting.

Experienced in developing Master-Detail and Transaction Forms in Oracle Forms Builder (6i/10g).

Experienced in developing Simple and Matrix reports in Oracle Reports Builder (6i/10g) on Windows and Linux platforms.

Proficient in PL/SQL programming – Stored Procedures, Functions and Packages, SQL tuning, and creation of Oracle Objects – Tables, Views, Materialized Views, Triggers,

Experienced with SQL performance tuning and optimization using execution plans.

Developed complex triggers using PL/SQL for data integrity and enforcing business rules.

Hands-on experience with Oracle Reports, SQL, PL/SQL, Open Interfaces, and APIs.

Strong interpersonal skills, ability to interact with people at all levels. Good communication and presentation skills and a Very Good Team Player.

Ability, willingness, and passion to learn new technologies and acclimatize to diverse work cultures.

Languages: SQL, PL/SQL, UNIX Shell Scripting, C, C++, Java,.NET, HTML, XML, VXML, WML, Visual Basic 6.0

Operating Systems: HP-UNIX, Windows 98/2000/NT/XP, Linux, MS DOS, MAC OS

GUI: Oracle Forms 6i/9i, Oracle Reports 6i/9i, Developer 2K, Discoverer 9i

RDBMS: Oracle 7.3/8/8i/9i/10g, Sybase 11.x, MS Access

Oracle Apps: Financials - Accounts Payable (AP), General Ledger (GL); System Administration

Tools: SQL Developer, Toad, SQL Navigator, SQL*Plus, SQL*Loader, Import, Export, HP Quality Center 9.2, IBM Data Stage 8.1.2, Talend Open Studio 4.1.2.

Modeling Tools: DIA, UML, Rational Rose

Statistical Packages: SPSS, SAS

Web Packages: MS FrontPage, Dreamweaver MX, Photoshop

Servers: ApacheTomcat4.2, IIS

Professional Expérience:

Client: UFCW, Concord, CA Nov 2015- Sep 2016

Role: Oracle Pl/SQL Developer

UFCW offers a variety of careers and great benefits. Proudly serving over 84,000 members and their families from over 155 employers in the grocery and pharmacy industry, we administer health and welfare and pension benefits. With a team of 200 employees in two offices located in Concord and Roseville, the Trust Fund office is fun and fast paced. In business since 1958, this organization is driven on the value of providing the highest level and quality of service to our members. Check out our current job openings and see how you can impact your career and enhance your skill set.

Responsibilities:

•Worked in migrating UFCW claims and benefits tool from Desktop version to Browser Version using PL\SQL Procedures and Functions.

•Recreated many stored procedures to meet the business requirements like claim details, benefits details, pension details and member details etc.

•Supported users with many adhoc SQL reports

•Generated many validation scripts for testing browser version

• Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.

•Processing and filtering member files using UNIX scripting(KORN SHELL)

•Worked on generating different formats file outputs like CSV,XML,EXCEL,TXT using UTL File package

•Good exposure onto Performance tuning activities

Client: State Farm, Bloomington IL June 2014- Aug 2015

Role: Oracle Pl/SQL Developer

State Farm is a group of insurance and financial services companies in the United States. The mission of State Farm is to help people manage the risks of everyday life, recover from the unexpected, and realize their dreams. State Farm is a family of insurance and financial services companies that together serve tens of millions of customers in the U.S

Responsibilities:

•Created data mapping files for the data coming from different web services.

•Worked for designing Logical and Physical data models for Master Data and Transactional Data.

•knowledge and experience in structured systems analysis and design techniques

•Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.

•Worked with ETL team and architect to build data model for staging area.

•Did performance tuning of PL/SQL code of a stored procedure which migrates data from source table with multi-million records to destination table and reduced migration time from over 3 hours to 45 minutes using Bulk Collect and Bulk Bind (FORALL) features with collections. Performed SQL Query tuning by using hints in DML statements.

•Involved in handling the changes in compiling scripts according to the database changes.

•Developed reports using complex queries as per client request as a part of production support

•Performed SQL tuning using Explain Plan, Hints and indexes

•Involved in handling the batch jobs using UNIX shell scripting.

•Responsible for performing code reviews.

•Created SQL*Loader scripts to load data into temporary staging tables.

•Utilized SQL*Loader to load flat files into database tables.

•Created data validation test cases and test scripts for Unit Testing and Integration Testing and documented the same.

Environment: Oracle 11g/10g, SQL, PL/SQL, Toad, Oracle RDBMS, SQL Developer.

Client: ThyssenKrupp, MI

Role: Oracle Pl/SQL Developer Oct 2012- May 2014

Description:

ThyssenKrupp is the world’s premier manufacturing firm with global presence and is organized globally operating business sectors namely Laundry and Home Care, Cosmetics and Toiletries, and Adhesive Technologies. It uses a wide variety of systems such as SAP, Oracle databases, and Business intelligence reporting tools. The central management system application contains the information regarding the company and employees to process to different applications.

Responsibilities:

•Involved in Requirement Analysis, System Design, Preparing Functional Specifications, Preparing Design.

•Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.

•Created SQL*Loader scripts to load/migrate data into the temporary staging tables.

•Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.

•Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.

•Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements

•Developed various complex stored procedures, packages, interfaces and triggers in PL/SQL.

•Created various SQL and PL/SQL scripts for verification of the required functionalities.

•Developed Database Triggers to enforce Data integrity and additional Referential Integrity.

•Developed complex SQL queries for data retrieval from various database objects including tables and views.

•Worked on various backend Procedures and Functions using PL/SQL.

•Developed the forms and Reports as per the requirements.

•Involved in Requirement gathering and creating Dataflow Diagrams, ER diagrams and database diagrams using Oracle Designer.

•Involved in UNIX Shell scripts to automate the loading, balancing and extraction process

•Check the functionality of data in the front-end whether it is displaying properly or not.

•Managing Version Control Tool like Clear Case and Start Team.

•Developed SQL scripts to be used for producing ad hoc reports in Enterprise Data Warehousing & Reporting environment as well as in Oracle Apps as concurrent programs.

Environment: Oracle 9i/10g, PL/SQL, SQL*Loader, TOAD, Java, HTML, MS Office

Client: Hilton Worldwide, TN July 2011 – Sept 2012

Role: PL/SQL Developer

Hilton Worldwide, signifies the company's global breadth and reach, and the logo incorporates key design elements that reflect Hilton's rich heritage, vision for the future and commitment to excellence in service.

Responsibilities:

Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.

Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.

Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements

Developed various complex stored procedures, packages, interfaces and triggers in PL/SQL.

Created various SQL and PL/SQL scripts for verification of the required functionalities.

Development for enhancements using technologies like PL/SQL. Configuration Management of all the files and Process Documentation.

Involved in Shell scripts to automate the loading, balancing and extraction process

Check the functionality of data in the front-end whether it is displaying properly or not.

Used ETL tool to extract the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse using PL/SQL Scripts.

Environment: Oracle 9i, PL/SQL, TOAD and Windows 2000 server

Education Details: Bachelor’s Degree, E.C.E. (2003-2007)



Contact this candidate