We provide IT Staff Augmentation Services!

Oracle Lead Resume

TN

Summary:

  • Around 12 years of experience in Information Technology. 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.
  • Experience in building Datamarts for a Commercial Lending Banking product.
  • Experience in using Crystal Reports for MIS. Reports.
  • Proficient in PL/SQL programming - Stored Procedures, Functions and Packages,SQL tuning, and creation of Oracle Objects - Tables, Views, Materialized Views, Triggers, Synonyms, Database Links, User Defined Data Types, Nested Tables and Collections.
  • Expertise in Query Tuning.
  • Good understanding of oracle Data Dictionary, RDBMS and Normalization Techniques.
  • Involved in project planning and scheduling, System Design, Functional specification, Design specification, Preparation of impact analysis, Coding, System Test Plan, User Acceptance Testing (UAT), Quality Assurance,Code Review.
  • Functional knowledge in individual and group General Ledger, Account Receivables, Banking andTelecom domain.
  • Experience working with Production and Development environment.
  • Experienced in Query Optimization, Debugging, and Tuning and Improvising performance of the applications.
  • Experience in working with Sequence and Indexes.
  • Proficient in working with Hints and Table Partitioning.
  • Hands-on experience with Oracle Reports, SQL, PL/SQL, Open Interfaces, and APIs.
  • Good Understanding of GUI using JavaScript, HTML, DHTML, XML,COLD FUSION 8.0
  • Thorough knowledge in software processes and involved in all phases of development life cycle
  • Involved in developing Forms and Reports using Oracle9i, 10g (ORACLE 10g AS).
  • Involved in preparing Integration test, Database Test for TOAD.
  • Experience in Unit and Integration Testing.
  • Knowledge in UNIX, and Shell Scripting.
  • Knowledge of DB2 Database
  • Strong interpersonal skills, ability to interact with people at all levels. Good communication and presentation skills and a Very Good Team Player

Education:
Bachelors of Science (B. Sc)

TECHNICAL SKILLS:

Operating System

Windows XP/ NT/95/98/2000, UNIX.

Languages

SQL, PL/SQL, UNIX Shell Script, JavaScript, HTML, Cold Fusion.

RDBMS

Oracle 10g, 9i, 8i, SQL server 2000/2005.

GUI

Oracle Pl/Sql Developer Suite, Reports 9/10

Data base tools

TOAD, SQL*Plus, SQL*Loader,Workflow, SQL Navigator.

Work Experience:
Confidential, TN Nov'11-Till Date
Oracle Lead

Project Description : Payment Integrity Dashboard (PI Dashboard)
PI Dashboard is a WEB application for the PAYERs in the Healthcare sector. The Application helps detect potential fraud by way of 3 services the ARS, IFM and the SRA which mark a particular claim as fraudulent based on certain rules. These Claims which become candidate as fraudulent claims and thus helping the PAYER form payment for those claims
My Responsibilities:

  • Designing the DB structure for the entire application.
  • Developed database objects including tables, Indexes, packages and procedures for the application
  • Application Query tuning for better performance by adding hints , moving the business logic to procedures etc.
  • Created SQL*Loader scripts to load data into temporary staging tables
  • Developing package for the Application and Demo data loads.
  • Worked with offshore team member in loading data to staging area. Provided all business rules for the database for loading data.
  • Supported for code integration and system integration testing for this application
  • Involved in handling the changes in compiling scripts according to the database changes

Work Experience:
Confidential, GA Jan'10-Till Oct'2011
Sr. Oracle Pl/Sql Developer

Project Description: RISM - Repository for Information Systems Management
Enterprise WEB application used by all of IT to gain access to their internal applications, dashboards and internal communication. PRISM is internally developed web based tool deployed on Mobility data center (Windward, GA). It supports access to centralized repositories from any company location, for all IT users. The tool contains various modules like financial data management, project management, Application management, time entry, project estimates, prioritization, purchase and work initiation. ATT IT employees heavily use the tool for their day-to-day activities for work estimate, reporting, project management and time entry.
My Responsibilities:

  • Leading a Team of 10 resources.
  • Involved in creating detailed Functional Documentation which includes all Business requirements and Technical specifications.
  • 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, clusters, 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.
  • Prepare the Mapping document which details out the mapping of source to the target data model with application of business rules.
  • Importing and exporting the data into multiple environments..
  • Supported for code integration and system integration testing for this application.
  • Worked with ETL team involved in loading data to staging area. Provided all business rules for the database for loading data.
  • Worked for ETL process of data loading from different sources and data validation process from staging area to catalog database.
  • 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
  • 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

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

Confidential, Atlanta, GA Dec'08-Dec'09
Sr. Oracle Pl/SQL Developer

Project Description:
Confidential, is a company providing MPEG-4[1] video on demand, and interactive television systems to telecommunications network operators and broadcasters. Borneo e-Product application is the backend application which loads the data into the staging area from exposed service data. Earlier the different application business data is exposed directly in UI application. This application is proposed in place of legacy system to improve the performance of current system.

My Responsibilities:

  • Involved in creating detailed Documentation HLD and LLD which includes all Business requirements and technical specifications.
  • Created data mapping files for the data coming from different web services.
  • Worked for designing Logical and Physical data models for staging and E-Product catalog Databasesandstaging database.
  • knowledge and experience in structured systems analysis and design techniques
  • Developed database objects including tables, clusters, Indexes, views, sequences, packages,triggers and procedures to troubleshoot any database problems.
  • Extensively used stored procedures to apply validation logic for the data in staging area to load into catalog Database.
  • Used Explain Plan, HINTS for performance tuning of sql, pl/sql queries.
  • Worked with ETL team and architect to build data model for staging area.
  • Worked with business experts to understand the source data in web service systems.
  • Prepare the Mapping document which details out the mapping of source to the target data model with application of business rules.
  • Importing and exporting the data into multiple environments.
  • Supported for code integration and system integration testing for this application.
  • Worked with Java and J2ee development team and worked for Hibernate mapping and Provided SQL Queries.
  • Worked with ETL team involved in loading data to staging area. Provided all business rules for the database for loading data.
  • Worked for ETL process of data loading from different sources and data validation process from staging area to catalog database.

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

Confidential
Oracle Pl/Sql Developer Sep'06-Nov'08

Project Description:
Confidential, is the world's premier manufacturer, installer and service provider of vertical and horizontal transportation technology. Job sight application is used to manage daily activities of the workers at the construction site.

My 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 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 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.

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

Confidential, Aug'03-Aug'06
Oracle Pl/Sql Developer
Description:
Confidential, is a provider of telecommunications services in the United States and worldwide. Through its subsidiaries, the Company provides communications services and products in the United States and has investments in more than 25 countries. The services and products that the Company offers vary by market, and include: local exchange services, wireless communications, long distance services, Internet services, telecommunications equipment, messaging, paging and directory advertising and publishing. The Company offers its services and products to businesses and consumers, as well as other providers of telecommunication services.
My Responsibilities:

  • Analyzed and overviewed the database design for better understanding the relations, associations and dependencies within the database.
  • Developed database objects including tables, clusters, Indexes, views, sequences, packages,triggers and procedures to troubleshoot any database problems.
  • Developed complex queries on Data Warehousing and developed PL/SQL procedures to give in nice strategic plans to higher level of management.
  • Created SQL*Loader scripts to load data into the temporary staging tables.
  • Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements in Oracle data warehousing.
  • Used Dynamic SQL programming technique to build and process SQL statements "on the fly" at run time.
  • Developed PL/SQL scripts for Data cleansing.
  • Developed UNIX shell scripts that help as a scheduler for data load.
  • Made timely changes and fixes to all the modules on reported problems from the database administrator.
  • Used TOAD, PL/SQL developer tools for faster application development.
  • Performed SQL tuning using Explain Plan, Hints and indexes.

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

Oracle Pl/Sql Developer May'00-Aug'03
Description:
Confidential, is the Business Intelligence (BI) component of the ACBS Product Suite. It is a highly focused Decision Support System (DSS) coupled with operational reporting features. As an extension of the ACBS Product Suite, the DataMart supports the collection, technical analysis, graphical analysis, and ad hoc and fixed reporting of customer and product information for ACBS clients. It incorporates integrated business models with risk/exposure management, profitability analysis, trend analysis, and relationship and product management through base business models. These multi-dimensional models allow end users to navigate, query, and analyze the data loaded and transformed from ACBS. They provide the structures necessary to perform both simple and complex analyses using industry standard business intelligence tools.
My Responsibilities:

  • Analyzed and overviewed the database design for better understanding the relations, associations and dependencies within the database.
  • Data modeling for client specific requirements.
  • Developed database objects including tables, clusters, Indexes, views, sequences, packages,triggers and procedures to troubleshoot any database problems.
  • Developed complex queries on Data Warehousing and developed PL/SQL procedures to give in nice strategic plans to higher level of management.
  • Created SQL*Loader scripts to load data into the temporary staging tables.
  • Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements in Oracle data warehousing.
  • Used Dynamic SQL programming technique to build and process SQL statements "on the fly" at run time.
  • Developed PL/SQL scripts for Data cleansing.
  • Developed UNIX shell scripts that help as a scheduler for data load.
  • Made timely changes and fixes to all the modules on reported problems from the database administrator.
  • Used TOAD, PL/SQL developer tools for faster application development.
  • Performed SQL tuning using Explain Plan, Hints and indexes.

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

Hire Now