Sql Oracle
Resume:
Shilpa
***************@*****.***
PROFESSIONAL SUMMARY
Over 8 years of experience in analysis, design, development, testing and deployment of software applications using Oracle8i/9i/10/11g.
Extensive experience in Data warehousing, Data Analysis, Reporting, ETL, Data Modeling, Development, Maintenance, Testing and Documentation.
Expertise includes evaluation of Data Warehouse, Oracle 10g/9i/8i, and MS Access databases on UNIX and Windows environment PL/SQL.
Extensive experience in building Client Server Applications using Oracle, PL/SQL, Stored Procedures, Packages and Database Triggers and working with partitions
Expertise in UNIX shell scripting and job scheduling.
Expertise in design, development and deployment of end user screens and reports using Oracle tools, Oracle Forms 10g/9i/6i/4.5, Reports 10g/9i/6i/2.5.
Experience in developing applications using Oracle APEX 3.2.
Proficient in oracle tools and utilities such as SQL Loader, SQL developer and TOAD.
Involved in the design of Dimension Models, Star Schemas and Snowflake Schemas.
Knowledge of bug fixing informatia 9.1.5 ETL jobs.
Experience in query optimization, Performance Tuning (PL/SQL) using SQL Trace, Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of global temporary tables and table partitioning.
Involved in Unit Testing, Integration testing and Performance Testing.
Experienced in interacting with Business users, Business Analysts, IT leads and developers in analyzing business requirements and translating requirements into functional and technical design specifications.
Proven ability to plan, coordinate and implement SDLC and Agile software development and maintenance projects.
Strong experience in SQL, SQL*PLUS, PL/SQL, back end programming using Packages, Functions, Stored Procedures, Exception handlers, Database triggers, Views, Ref Cursors, Record Types, UTL_FILE and other built in packages.
Able to work within an aggressive and demanding project schedule and environment.
Highly motivated & conceptually strong individual with outstanding oral and excellent communication, analytical and interpersonal skills. Developed C/C++, Pro*C Batch programs using Multithreading Programming for handling large volumes of data for parallel processing/load.
Support modules for implementation using PL/SQL Scripts, UNIX Shell Scripts custom Functions, Procedures and Packages Scripts for RETEK -13 implementation.
EDUCATION
B.Tech in Computer Science Engineering, India.
Oracle Certified Associate (OCA)
Introduction to Oracle SQL 10g
Oracle10g program with PL/SQL
SKILLS
Operating System
HP-UNIX, Linux, Windows 2003
RDBMS
Oracle 10g/9i/8i, MS Access 7.0/2000
Data Warehousing
SQL Developer ETL Processes, InformaticaPowerCenter9.1
Data Modeling
Star-Schema Modeling, Snowflakes Modeling
Programming
C, C++,PL/SQL and UNIX Shell Scripting
Tools
MS Access Reports, Oracle APEX 3.2, MS Office
Version Control
CVS, PVCS
Scheduler
Control M
Web Technologies
ASP, HTML, VBScript
Other Products
SQL*Loader, TOAD, FTP, TKPROF
WORK EXPERIENCE
Client: US Foods Inc, Rosemont, IL Jul 2013 - Present
Position: Sr. Oracle Developer
Description:
US Foods is one of America’s leading foodservice distributors to restaurants, healthcare and hospitality facilities, government operations and educational institutions. I am working with the Data warehouse development team develops many ETL and Reporting applications.
Responsibilities:
Created design documents to be reviewed by architect.
Worked on the bulk uploading of huge amounts of statistical data to the database.
Wrote loader scripts using SQL Loader/External tables to load large tables.
Responsible for developing and modifying several PL/SQL packages procedures, functions, views and triggers using PL/SQL.
Optimized queries by obtaining Explain Plan, analyzing tables, providing hints, and adding Indexes on tables where required
Responsibilities for Linux Migration and Oracle Upgrade.
Performed maintenance work on the database.
Analyzed data integrity problems and provided assistance in giving solutions.
Actively involved in troubleshooting database issues.
Provided SQL and PL/SQL code tuning to improve database response time and performance for several applications
Developed Oracle Stored Procedures, Functions and Packages to effectively incorporate Business rules
Worked extensively with Composite data types, Cursors and Dynamic SQL
Worked with Dynamic SQL, Global Temporary Tables
Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL_FILE, DBMS_SQL, and PL/SQL Collections and used BULK Binding
Created materialized views, Inline Views & normal views where business requirements needed
Worked in Oracle reports and forms version 6i and 10g.
Worked in customization of reports in GL and PO.
Extensively used bulk collection in PL/SQL objects for improving the performing
Developed stored procedures and packages. Extensive work in PL/SQL.
Developed Reports and forms using Oracle Designer.
Worked with development of packages and procedures using PL/SQL and functions using ETL and PL/SQL.
Worked on developing/supporting oracle APEX applications.
Involved in analysis, development, testing, and 24 x 7 production support.
Environment: UNIX, LINUX, Oracle 11g, PL/SQL, SQL*Plus, SQL*Loader, Microsoft Excel, TOAD, APEX 3.2, SQL, PL/SQL Developer, SQL*Loader, Reports6i, Toad, CVS, Java, ASP, HP-UX UNIX.
Client: Virginia Department of Health, Richmond, VA Nov 2011- Jun 2013
Position: Oracle Consultant
Description:
The Historical Database System stores detailed data for certain billing and financial systems scheduled. The company requires maintaining certain types of data for period of up to five years. The Historical Data Repository is to provide the ability to maintain and extract data, and provide some user specified views. The user has capability to generate an invoice in the appropriate format as well as have access to the data for various reporting needs.
Responsibilities:
Defined business requirements and developed Technical Design Document for programming
Designed and Developed back-end routines using Oracle PLSQL, Stored procedures/Packages, Triggers and SQL*loader.
Wrote UNIX Shell scripts to generate daily reports for credit class updates of customers.
Automated jobs through Autosys for creating Mass Adjustment Files to find customer accounts to be charged for late payments.
Worked on range partitioning of history tables in order to improve batch performance.
Implemented modifications to the existing code to add a memo to a customer account through API.
Worked on Pro C* programs and sql scripts to generate full extracts of large tables.
Created daily reports of customer accounts which needed to be notified for adding a memo.
Used advanced SQL and analytical functions in various queries.
Creating new Forms (Developer 2000), Reports (Reports 10g) and writing back end procedures, function, trigger, packages (PL/SQL).
Used package like DBMS_JOB to determine if there are any jobs that are to be performed, or any changes are made to the program or procedure.
Created Parameterized Reports and Customized Existing Reports for presentations using Cross-Tab reports and Sub-reports and Running Totals/Formulas in crystal report.
Used for all and bulk collect to fetch large volumes of data in PL/SQL objects.
Automated repetitive processes by writing shell scripts.
Worked on accessing the application interface that integrates the internal applications with the billing system.
Developed complex procedures to handle errors and exceptions at the database level using PL/SQL.
Used PL/SQL Tables, Ref Cursors to process huge volumes of data and used bulk collect and bulk bind for mass update as performance improvement process
Worked extensively on various bug fixes in Reports 6i, Discoverer 10g, and Forms 6i.
Application Development using Oracle Forms 10g, Oracle Reports 10g
Tested application in Unit Test and deployed applications into the production server.
Consistently coordinated with production support and also responsible for estimating the time factor for several jobs depending upon the data volume size.
The role required extensive interactions with Business Managers and Users
Environment: UNIX, Oracle 9i/10g, PL/SQL, SQL*Plus, SQL*Loader, TOAD, PL/SQL; SQL; SQL LOADER, Toad, Oracle database 10g; Oracle Forms 6i, 10g; Oracle Reports 6i, 10g, Oracle Application Server 10g
Client: AAA Insurance, NJ Feb 2011–Oct2011
Position: Oracle Developer
Responsibilities
Created backend triggers for faster and integral data
Developed custom packages to implement various functional areas
Involved in data loading from legacy system via SQL* loader
Developed schedule jobs via Oracle jobs using DBMS_JOB
Utilized various upgraded Oracle 9i features
Utilized DBMS packages to reuse code and automate scripts, DBMS packages to implement scheduling, Dynamic SQL and extensive usage of Ref Cursors, Explain Plan, Hints to tune queries for better performance and also extensive usage of Indexes and PL/SQL collections and records
Involved in migrating the legacy PL/SQL Applications to the Linux environment
Created synonyms for read only objects to maintain the security and restrict access to specific users
Worked on developing internal user data entry applications using APEX.
Utilized sequences to automate number generation
Used different exception handlers and also created some user defined Exception Handlers
Used Bit map and Function based indexes to improve performance of queries
Developed Transaction Forms which involve a lot of validations at all levels like Field, Block and Form level
Environment: UNIX, LINUX, Oracle 9i/10g, PL/SQL, SQL*Plus, SQL*Loader, TOAD, PL/SQL; SQL; SQL LOADER, Toad, Oracle database 10g; Oracle Forms 6i, 10g; Oracle Reports 6i, 10g, Oracle Application Server 10g and APEX 3.0.1
Client: Bangalore Hospital, India Apr 2008 – Dec 2010
Project: Hospital Management System
Position: Software Programmer
Description:
This project was developed to automate and maintain the hospital. The various modules involved in this project were Patient details, Doctor Details, Scheduling of operations, Appointments, Medical History, Billing, and Availability of rooms and Reports module.
Responsibilities:
Created procedures and functions using PL/SQL.
Create simple, complex create joins, calculated items and conditions.
Analyzed the tables and indexes using SQL and PL/SQL scripts.
Monitoring existing code and doing performance tuning if necessary.
Wrote database triggers for audit and data validation.
Involved in Developing Forms and Reports using Developer/2000.
Developed Stored Procedures, Functions, SQL statements and Packages to accommodate the new term rules (quarter, semester, part of terms and so on) and changes using TOAD.
Developed Laureate Custom Forms and integrated with Banner Forms and Banner Database.
Developed Forms using Oracle Forms 10g for Laureate Employee Training Application (LMS) which also involved analysis, design, development and migration to UNIX box and deployment on web.
Analyzed, designed and developed a process to create various Laureate List Serves for worldwide students and faculty using PL/SQL procedures, DBMS_SCHEDULER, UTL_FILE, Unix Cron jobs.
Expertise in PLSQL attached libraries, Functions, Triggers in Forms. Developed C/C++, Pro*C Batch programs using Multithreading Programming for handling large volumes of data for parallel processing/load.
Environment: Oracle 9i, Developer/2000, Windows, SQL*Plus, PL/SQL
Client: KPSM, India Jul 2006 – Mar 2008
Project: Transaction Management System
Position: Software Developer/Engineering Trainee
Description:
The functionality of this project was to keep track of the transactions between suppliers and various departments. It maintains the stock level and provides the information about suppliers along with the items. It generates Vouchers, Inquiry & Approval letters to suppliers for quotations. It can also generates reports for items list, Suppliers list, Indents based on date, Pending Indents, Purchase Orders based on date, pending Purchase Orders.
Responsibilities:
Involved in system analysis, development, documentation and implementation of the inventory and payroll system
Involved in design of database model(E-R Model)
Migration from MS-Access to Oracle
Wrote SQL Statements, Stored Procedures, Functions, and Packages to accommodate the new business requirements, business rules, and changes using SQL Navigator, SQL* Plus, and TOAD.
Developed a debug methodology for tracing the payment details using Stored Procedures and Functions.
Created indexes on tables and Optimized Stored procedure queries.
Developed procedures to ensure conformity, compliance with standards and lack of redundancy, translating business rules and functionality requirements
Designed, developed modules using Visual Basic 6.0 and Oracle 8i
Involved in writing low-level specifications for screens designed
Environment: Oracle8i, PL/SQL, Visual Basic 6.0, MS-Access, Windows 2003
Contact this candidate