PROFESSIONAL SUMMARY:

• Extensive Experience in UNIX Shell Scripting, Job Scheduling .
• Experience in using Oracle built-in packages.
• Exposure to Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Extraction, Data Transformation and Data Loading ETL .
• Experience in production support, creating user cases, requirement matrix ETL development and Business Intelligence solutions.
• Handful Experience on .Net technologies such as ASP.NET and Silverlight Technology.
• Experienced liaison between business users and development teams, to ensure accurate analysis.
• Good knowledge in writing/ debugging of Stored Procedures, Functions, Triggers, Views, Indexes and Sequences.
• Strong expertise in database development using SQL, PL/SQL, T-SQL, SQL PLUS, TOAD, SQL-LOADER.
• Excellent project management, scoping, development life cycle and implementation experience.
• Total 8 years of experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System RDBMS .
• Knowledge in Database Design, System Architecture and Development of Relational/Multi-Dimensional Schemas for Data Warehouse, Data Modeling, Data Migration, development, enhancement, implementation, maintenance and support of applications developed under ORACLE 11g/10g/9i/8i , MS SQL Server 2005/2008.
• Excellent knowledge of Principles of Data Warehouse using Fact Tables, Dimension Tables and Star/Snowflake schema modeling.
• Experience with ETL, Data Mapping, Transformation and Loading from Source to Target Databases in a complex, high-volume environment.
• Created autosys scripts to schedule the jobs.
• Strong Analytical, Organizational, Inter-personal and Communication Skills.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

Sr.Oracle Pl/Sql Developer

Responsibilities:

• Coordinated with the front end Novartis design team to provide them with the necessary Stored Procedures and Packages and the necessary insight into the data.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL TRACE, TKPROF and AUTOTRACE.
• Involved in Novartis logical and physical database layout design.
• Developed UNIX shell scripts to perform a nightly refresh of the test system from Production databases.
• Created Materialized Views and partitioning tables for performance reasons.
• Resolving the issues on priority basis.

Environment: Oracle 10g/11g, SQL Plus, PL/SQL, SQL Loader, TOAD, Windows, UNIX, PUTTY.

Confidential

Sr.Oracle Developer

Responsibilities:

• Used to solve production tickets issued under ITCOE system on day to day basis.
• Created UNIX Scripts for various Applications and made it executable with the Front end code.
• Involved in creating one of the Snap-On application HONDA-EDI from the scratch which involves Packages/Functions/Procedures, Indexes, tables and Unix Scripting.
• Provided 24/7 Support for the team as well as for franchisee's who were on the field on daily basis.
• Simplified Complex UNIX Scripts so as to execute as per the new environment provided.
• Involved In implementation of HTML, CSS, JAVASCRIPT and AJAX.
• Worked with Business Owners closely to gather the information required and implemented each and every user story according to the plan.
• Wrote DDL, DML scripts for creation of Schema, Table space and also involved in Cluster creation and alteration.
• Performed business process mapping/Data mapping for change requests and new requirements.
• Worked in extracting the data through Sql queries and provided output as requested by the User.
• Created PowerPoint presentations to demonstrate project-wide work flow management and to conduct walkthroughs for end-users.
• Involved in Performance tuning of Queries, Indexes and Stored Procedures..
• Interacted with Operations team for scheduling and running the jobs on daily basis.
• Involved in documentation of all the snap-on applications functionally and technically with the team.
• Analyzed impact of proposed system solutions for each line of business and identified risks, priorities, and alternatives.

Environment: Oracle 10g/11g, SQL Plus, PL/SQL, SQL Loader, TOAD, Autosys, HTML, CSS, Windows, UNIX, PUTTY.

Confidential

Sr.Oracle Pl/Sql Developer

Responsibilities:

• Created Stored Procedures to implement various business logic.
• Creating and managing table, Indexes, table spaces, triggers, db links and privileges.
• Improved the performance of ETL process by fine tuning queries, creating appropriate indexes and using temp tables.
• Gathered Requirements to analyze the existing processes and wrote SQL queries accordingly.
• Generated DDL Queries for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges.
• Created and modified SQL Plus, PLSQL and SQL Loader scripts for data conversions.
• Produced SQL reports, data extraction and data loading scripts for various schemas.
• Generated server side PL/SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Worked on asp.net code to some extent, to get the stored procedures work.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Developed complex reports based on an Oracle views using running totals, sub totals, grand totals and conditional formatting.
• Involved in uploading and porting of reports into the web based Real-time Query servers.
• Wrote PL/SQL procedures to generate DDL scripts that created database objects dynamically based on user inputs.
• Worked with Autosys for Job Scheduling and job automation.
• Optimized critical queries to eliminate Full Table scans reduce Disk I/O and Sorts.

Environment: Oracle 10g/11g, SQL Plus, PL/SQL, SQL Loader, Toad, Autosys,, Visual Studio, Windows, UNIX, PUTTY.

Confidential

Sr. Oracle Pl/Sql Developer

Responsibilities:

• Interacted with Subject Matter Experts SME to gather Business Requirements for the application, through one-on-one interviews as well as JAD sessions with development teams.
• Created and analyzed Process Work Flows, Scope Functional Specifications, and was responsible for preparing Software Requirement Specifications SRS and Functional Specification Documents FSD .
• Involved in creating Alerts so that notifications will be sent to user based upon a value range of a metric KPI .
• Involved in gathering requirements through reverse engineering process.
• Involved in data analysis and reporting on ATT Commerce Service Center Application Merchandising data for ATT-mobile online shoppers.
• Creating and managing table, Indexes, table spaces, db links and privileges.
• Loading flat files coming from Up-stream systems into Oracle using SQL Loader.
• Developed Packages and procedures for Extraction, Transformation and Loading processes.
• Analyzed the data from various systems and loaded them into tables in our Oracle system.
• Worked on PL/SQL packages for online application that would transfer data among servers and perform other data transformations, scheduled the packages by creating the corresponding job tasks.
• Created UNIX shell scripts using SQL Loader, SQL Plus and PL/SQL programs that run as nightly interfaces.
• Used Autosys in UNIX environment for scheduling routine tasks.
• Developed the stored procedures using PL/SQL Tables and records to generate the output in XML format.
• Responsible for maintaining the minutes of all the requirement gathering sessions.

Environment: Oracle 9i/10g, XML, Java, J2EE, Java Scripts, Pro C, SQL Plus, PL/SQL, SQL Loader, PL/SQL, Toad, Autosys, MS Office, Windows, UNIX, PUTTY.

Confidential

Oracle Pl/Sql Developer

Responsibilities:

• Involved in project planning, coordination and implementation of QA methodology.
• Participated in various meetings and discussed Enhancement and Modification Request issues.
• Analyzed manual systems and developed process flows for activities.
• Performed business process mapping/Data mapping for change requests and new requirements.
• Used SQL Loader to load data from various sources into an Oracle database.
• Wrote SQL, PL/SQL programs required to retrieve data from the Data repository using cursors and Exception handling.
• Proficiently developed Functional Requirement Documents, Design documents, Test Cases and Project documentation user guides, standard report instructions, demos .
• Responsible for setting up servicing system to ensure all loans report accurately.
• Had thorough understand of highly normalized/back-end intensive data model.
• Created database triggers for data security.
• Generated PL/SQL Packages, Functions and Procedures to implement the Business Logic.
• Worked as a front end .net developer for sometime following MVC pattern for displaying Active Server Pages.
• Developed shell scripts for batch processing and database transactions.
• Implemented Autosys for job scheduling and Sub Version for the version control.
• Developing and Customizing PL/SQL Programs for Oracle Integration.
• Created database objects like Tables, Synonyms, Views, Indexes, and Sequences.
• Validated the data and the joins in the universe by running BO Reports and exporting the output to the Excel spreadsheets and again testing it against the data that was fetched from backend tables using TOAD.
• Application Testing and Documentation of up-gradation Oracle 9i to 10g.
• Analyzing and Tuning Database 10g.

Environment: Oracle 9i/10g, TOAD, SQL, PL/SQL, TKPROF, SQL Loader, Autosys, UNIX Shell Scripting, J2EE, Business Objects XI r2, MS-Windows, UNIX.

Confidential

Oracle Pl/Sql Developer

Responsibilities:

• Worked on Creating and managing table, Indexes, table spaces, triggers, db links.
• Generated DDL Queries for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges.
• Generated server side PL/SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Produced SQL reports, data extraction and data loading scripts for various schemas.
• Generated DDL Queries for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges.
• Involved in code reviews and Production Support and Carried the pager on roaster basis.
• Created and modified SQL Plus, PLSQL and SQL Loader scripts for data conversions.
• Analyzed the existing method for data repository refresh and then developed a new package with tuned queries to improve the performance and reduce the time taken for the refresh.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Developed complex reports based on an Oracle views using running totals, sub totals, grand totals and conditional formatting.
• Involved in uploading and porting of reports into the web based Real-time Query servers.
• Worked with Autosys for Job Scheduling and job automation.
• Fine Tuned procedures for the maximum efficiency in various schemas across databases using Oracle Hints, Explain plans and Trace sessions for Cost based and Rule based Optimization.
• Optimized critical queries to eliminate Full Table scans reduce Disk I/O and Sorts.

Environment: Oracle 9i, SQL Plus, PL/SQL, SQL Loader, Toad, Autosys, HTML, Pro C, Windows, UNIX, PUTTY.

Confidential

Oracle Pl/Sql Developer

Responsibilities:

• As a team member responsible to work as a data modeler.
• Improved and administered the existing Oracle databases and applications.
• Responsible for installation, upgrade, account management, backup/recovery of Oracle databases.
• Coded stored Procedures, Functions, Packages and Database Triggers to support the Forms and Reports functionality.
• Created Views to fulfill the requirement of Reports and Forms.
• Created stored procedures and functions in PL/SQL to increase the performance of Forms on web server.
• Used the Dynamic SQL to create the text file for reading and writing purpose in PL/SQL.
• Created temporary table for report writing using Dynamic SQL.

Environment: Oracle 9i/10g, PL/SQL, Oracle Reports 10g and TOAD, Visual Basic, MS SQL Server, Windows NT.

Confidential

Oracle Pl/Sql Developer

Responsibilities:

• Wrote Procedures for conversion of data from one schema to another schema.
• Created database objects like tables, views, synonyms, indexes, rules and defaults.
• Development of Stored Procedures/Functions to meet the business requirements.
• Implement Oracle discoverer and develop reports for different modules.
• Responsible for registration of reports, forms, functions and menus in development environment.
• Well versed with Oracle RDBMS, Discoverer 4i, Developer 9i, PL/SQL programming.
• Responsible for developing PL/SQL packages, procedures and functions whenever necessary.
• Handled calls with onsite DB team for discussions and understanding requirements.
• Created change documents for record and tracking.
• Data loading into tables.
• Unit testing of the procedures.

Environment: SQL, PL/SQL, Developer 9i, Pentium IV, 3 GHz, 1 GB RAM, 80 GB HDD, Windows 2000, Oracle 9i.