SUMMARY

• Having 7+ years of profound working experience in SQL, PL/SQL programming and has used tools such as Toad, SQL Navigator and SQL Developer for Oracle SQL based database and application development and deployment.
• 5 Years Oracle Configurator implementation experience across project cycles.
• Has experience in all teh phases of SDLC, including requirements gathering, system design, Development, Unit testing, Integration testing, implementation and production support.
• Proficient in Developing and maintenance of database objects like PLSQL blocks, Stored Procedures, Packages, Functions, Types, and Views etc.
• Designed database schema's using Entity relationship modeling with ER diagrams & database normalization principals.
• Designed, developed, made valuable addition to each aspect of physical Data Warehouse design and development, PL/SQL stored procedures, packages, procedures, SQL tuning, indexing strategies, partitioning, parallel processing, materialized views.
• Having experience in working with SQL Server Reporting Tools (SSRS) and SQL Server Integration Management (SSIS).
• Experienced in SQL Loader, Export and Import and enforcing security by creating roles, granting system and object privileges on teh Tables and Stored procedures.
• Experience in development of documentation using standards like SRS, IRS, SDD, STD, STP, Help files, User manuals and Handbooks etc. using teh ISO standards.
• Developed Data Mapping and Data Conversion scripts using SQL and PL/SQL.
• Improved performance of PL/SQL program units by using Bulk Collect and Bulk Bind (For All) features with Collections instead of using cursors and FOR loops, and DBMS PROFILER package and GET TIME in DBMS UTILITY package.
• Used Bulk Blinds and Bulk Collect.
• Strong Knowledge on Software Models, Software Analysis, Design, Requirements and networks.
• Used UML tools to create in - depth design flow for developers and application blue print for clients (End users) to communicate with teh product design and infrastructure design ideas.
• Experienced in OLTP and OLAP System Study, Analysis and E-R modeling.

TECHNICAL SKILLS

RDBMS: Oracle 11g/10g/9i, Sybase, SQL server-2005/2008

EDI Tools: TOAD, PLSQL Developer

Database Design tool: Toad Data Modeler

Reporting: Reports 6i, Crystal reports (BI Publisher)

Modeling Tool (UML): Rational Rose 2000, Visio

Languages: Power Script, PL/SQL, JavaScript, T-SQL

Version Control: Clear Case, SVN

Operating System: Windows, UNIX

Educational Qualifications: B.TECH in Computer Science, JNTU, India.

PROFESSIONAL EXPERIENCE

ORACLE Developer FEB

Confidential, CA

Responsibilities:

• Involved as a key team member for Requirement Analysis during teh design phase and developed various Design documents according to teh user requirements.
• Involved in writing backend Packages extensively in PL/SQL.
• Involved in Code Reviews and preparing Unit test cases.
• Used Quest code tester for Oracle, a component of Toad used to identify and eliminate teh costly bugs and functional errors and used right data model for teh data mart based on teh requirements.
• Created technical mapping documents as part of data modeling and design.
• Created data stores, interfaces, procedures, packages and scenarios in ODI repositories.
• DevelopedPL/SQL Procedures and Functions in accordance with teh business requirements for extracting legacy data and loading data into database tables as part of data migration.
• Used Quest code tester for Oracle, a component of Toad used to identify and eliminate teh costly bugs and functional errors and used right data model for teh data mart based on teh requirements.
• Physical Data Warehouse design, table partitioning, indexing strategy, materialized views, hands on with PL/SQL, SQL development using packages and program units.
• Developed PL/SQL functions to facilitate business functions and calculations and did required modifications to teh existing once.
• Created complex stored procedures, views,SQLjoins and scripts.
• Created high quality and well documented code according to standards.
• Used JIRA for bug tracking and for raising tickets.
• Involved in daily status calls with clients.

Environment: Oracle 11g, Sybase 12.5, TOAD, ODI,PL/SQL Developer, JIRA & Accurev.

Oracle Developer

Confidential, New York, NY

Responsibilities:

• Experience in developing various PL/SQLobjects like procedures, functions, packages and triggers in accordance with teh business needs.
• Involved in interacting with teh end-user (client) to gather business requirements and modeling teh business requirements.
• Participated in analyzing teh requirements for teh logical and physical design of teh database.
• Involved in tuning and query optimizingSQLqueries by using quest control tools and manual by EXPLAIN PLAN.
• PL/SQL Collections were extensively used for high performance of stored procedures.
• Collaborate with teh DBA and Development Team in successful implementation of data warehouse release.
• Populating teh data warehouse tables usingSQL*Loader.
• Implemented complex views, procedures, functions, packages and triggers inPL/SQL.
• Performed exception handling for data dat did not conform to teh required format.
• Responsible for making teh merged data in turn available to other clients.
• ImplementedPL/SQL scripts in accordance with teh necessary Business rules and procedures.
• DevelopedPL/SQL packages and procedures for teh back end processing of teh proposed data base design.
• CodedPL/SQLProcedures, Functions and Packages for batch processing of teh applications.
• Developed reports using complex queries as per client request as a part of production support.
• Worked on teh concepts of Network Management Systems and teh functionality of FCAPS.
• ConductedPL/SQL training session for co-workers to educate about teh latestPL/SQLfeatures, PL/SQL performance tuning.

Environment: Oracle 10g, Shell Scripting, Sun Solaris,PL/SQL Developer, Net Act Product Suite, Network Management Systems.

PL/SQL Developer

Confidential, Rochester, NY

Responsibilities:

• Developed PL/SQLProcedures and Functions accordance with teh business requirements for loading data into database tables.
• CreatedPL/SQLpackages for calculation of metrics statistics across 13 states by including state and domain wise parameters which resulted in reducing teh report generation time by almost 90%.
• Developed theSQLcode for performance and penalty statistics calculation.
• Involved in tuningSQL queries.
• Executing Daily and Monthly reports in UNIX and automated teh scripts using shell script.
• Created SQL Loader scripts to load data into temporary staging tables.
• Created scripts for Views, Materialized Views and Partitioned tables.
• Responsible for Analyzing and Implementing teh Change Requests
• Monitoring day-to-day Process for different Data Loads and resolving Issues.
• Created complex stored procedures, views,SQLjoins and scripts.
• Writing high quality and well documented code according to standards.
• Involved in fine tuning stored procedures by making use ofPL/SQLCollections and its BULK FETCH and BULK INSERT features.
• Involved in daily status calls with clients.
• Designed Technical Specifications from Functional Specification (Detail Design) documents.
• Used SQL*Loader/Perl Script to load data from various sources into an Oracle database.
• Wrote PLSQL programs required to retrieve data from teh Data repository using Cursors, UTL File me/O and Exception handling.
• Wrote PL/SQL Packages, Functions and Procedures to implement teh Business Logic.
• Involved in Integration test, System test and Implementation.
• Extensively developed complex PL/SQL packages for Pricing.
• Written complex SQL using joins, sub-queries and correlated sub-queries.
• Created Informatica Mappings with PL/SQL procedures to build business rules to load data using transformations like Source Qualifier, Aggregator, Sorter, Expression, Joiner, Connected and Unconnected lookups, Filters, Sequence, Router and Update strategy.
• Used debugger to test teh mapping and fixed teh bugs.
• Applied Performance Tuning logic to optimize session performance.
• Attended business user sessions to make changes in warehouse loads.
• Developed UNIX Korn shell scripts to process file feeds.
• Involved in production support during deployment.
• Developed shell scripts for batch processing and database transactions.
• Tuning SQL Statements, PL/SQL Packages, Triggers, Functions and Procedures.
• Application Testing and Documentation in teh upgrade of Oracle 9i to 10g.
• Involved in Database performance tuning using Explain plan.
• Created various SQL and PL/SQL scripts for verification of teh required functionalities.
• Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.
• Created numerous web based Forms and Reports.
• Loaded traffic data logs into staging tables using SQL loader and shell scripts.
• Developed Forms, Packages, Triggers and Shell Scripts to load teh staging table data into Traffic Mart System.
• Writing scripts to create partitions, exchange partitions, analyze for performance tuning.
• Developed packages, functions, procedures, database triggers as part of teh ETL process.
• Worked with Star schema and Snow Flake schema.
• Used UTL FILE (file handler), DBMS JOB, DBMS ALERT and other utility built-in Packages in PL/SQL.
• Worked on complete SDLC (System Development Life Cycle) including system analysis, high level design, detailed design, developing, coding and testing.
• Worked extensively on BLOB Table Spaces.
• Creation of database objects like tables, views, procedures, packages using SQL* Plus and PL/SQL.
• Performed Data validations and mappings at staging table level.
• Created Complex Dynamic / Static / Parameterized Reports and Charts using Report 6i.
• Assessed teh efficiency of teh SQL statements using SQL Trace and TKPROF
• Maintenance of data in all teh tables of teh database.
• Using thePL/SQLprocedures pulled out teh reports as requested by users.
• Created functions to calculate teh aggregate statistics.
• Involving in creation of triggers and handling exceptions.
• Developing various Business and ad-hoc Reports.
• Various stored procedures were written to achieve teh back end functionality.
• Analyzed performance bottlenecks and provides appropriate solutions.
• Monitored teh daily jobs of Unix Shell scripts.
• Participated in requirement gathering session with business users and sponsors to understand and document teh business requirements as well as teh goals of teh project.

Environment: Oracle 9i, UNIX Shell Scripts, PL/SQL, Toad,PL/SQL Developer, Putty, Sun Solaris.