SUMMARY

• Over 7 years of experience in various phases of Software Development life cycle, including Design, Development and Testing using Oracle Technologies and Data Warehousing.
• Solid experience in translating business requirements into creation ofDatabase Objects.
• Strong technical expertise on databasesOracle (11i/10g/9i/8i)on both Windows NT / UNIX environments.
• Interacted with the business users, collected the requirements, analyze the requirements, design and recommend solutions.
• PreparedBRS (Business Requirement Specifications)document that gives the detailed information about the requirements.
• Expert level skills in SQL, PL/SQL Development (SQL scripts, Functions, Stored procedures, Cursors, TriggersandPackages, Advanced PL/SQL objects, Bulk collections,etc.)
• Developedmaterialized viewsfor data replication in distributed environments
• Extensively used the utilities likeTOAD (9.6.1/9.1/8.5/7.4 ),SQL Developer,SQL*Plus.
• Experienced in working withSQL*Loader, External Tables, Import, Export to extract and load large volumes of data.
• Hands on experience withversioning and change tracking version control tool.
• Partitioned large Tables usingrange partition technique.
• Experience with Oracle Supplied Packages such asDBMS SQL, DBMS JOBandUTL FILE.
• Experienced inExtraction Transformation and Loading (ETL)processes.
• Extensively involved inPerformance tuningin Oracle.
• Good knowledge of key Oracle performance related features such asQuery Optimizer, Execution PlansandIndexes.
• Experience withPerformance Tuningfor Oracle RDBMS usingExplain PlanandHINTS.
• CreatedUNIX Shell Scriptsfor invoking SQL scripts and scheduled them using crontab.
• Experience with PERL Scripting.
• Worked on Production Support, attending production calls, troubleshooting the application and resolving bugs.
• Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels.
• Ability to work in teams and independently with minimal supervision to meet deadlines.
• Strong management, administrative and leadership skills to work in team.

TECHNICAL SKILLS

Operating System: Win XP, Win Vista, UNIX

Databases: Oracle 11,10g, 9i

Languages: SQL, PL\SQL, PSP, UNIX shell scripting, Perl, MOSS 2007, MS - Share point Designer,ASP.NET, C#

Utilities: Export/Import, Explain Plan

Tools: Toad, PL\SQL Developer, SQL* Plus, VSS, Teamsite CMS, Komodo, Clearcase.

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

Lead Developer / Team Lead

Responsibilities:

• Monitoring the successful completion of the jobs daily which were scheduled for accurate flow of data from one application to another.
• Building complexSQL queriesfor the various projects in the group.
• Involved in the continuous enhancements and fixing of production problems.
• Created PL/SQLstored procedures, functions and packagesfor moving the data from staging area to data mart.
• Createdexternal tablesto handle huge volumes of data which is not used frequently.
• Created scripts to createnew tables, views, queriesfor new enhancement in the application using TOAD.
• Createdindexes on the tables for faster retrieval of the data to enhance databaseperformance.
• Debugging the packages, functions, procedures and triggers.
• Tuning the SQL queries for performance improvement.
• Extensively involved in usinghints to direct the optimizerto choose an optimumquery execution plan.
• Creation of database objects liketables, views, materialized views, procedures and packages using oracle tools likeToad
• Partitionedthe fact tables andmaterialized viewsto enhance the performance.
• Preparing, updating and uploading Knowledge Transfer documents in the project share point folders.
• Addressing the issues raised by the users and providing relevant information to them as needed.
• Mentored junior resources in the project creating awareness on project specific applications and company standards.
• Good understanding of database objects and ability to triage issues.
• Proficient at working as a team player with an aim of contributing towards the team's success. Involved in unit testing, systems integration testing and documented the same.
• Involved in PL/SQL code review and modification for the development of new requirements.
• Created and modified severalUNIX shell scriptsaccording to the changing needs of the project and client requirements.
• UsedUNIXshell scripts to automate and systemize the load process at nightly cycles.
• Worked on Production Support, attending production calls, troubleshooting the application and resolving bugs.

Environment: Oracle 11i,10g PL\SQL, UNIX shell scripting, stored procs, functions, index, HPQC, DDL scripts, Toad, IMS, SQL* Plus sequence and triggers, SSH Thick Client and Putty.

Confidential, Plano, TX

Lead Developer / Team Lead

Responsibilities:

• Designed the infrastructure data model to be used for the project.
• Involved in all phases of the SDLC for Designing & giving recommended approach to satisfy the requirements.
• Designed and developed a ‘BDW Data Archival/Retrieval Process’ in Unix Shell scripts and Oracle data warehousing concepts which involves archiving/retrieving historical data to/from offline storage
• Written Unix Scripts and PL\SQL procedures and functions to implement the business rules
• Automated the testing using the DDLs and Procedures to test the loaders.
• Developed database objects includingtables, Indexes, views, sequences, packages, triggers and proceduresto troubleshoot any database problems
• Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements
• CreatedMaterialized Viewsandpartitioning tablesfor performance reasons.
• Resolving the issues on priority basis.
• Responsible for Analyzing and Implementing the Change Requests.
• Involved in handling the changes in compiling scripts according to the database changes.
• Developed procedures usingDynamic SQL.
• Interacted closely with Business Users to gather requirements and helped with the data modeling effort Some of the business benefits reaped out of this project
• Reduces storage cost - As the data gets archived over a defined period of time, it reduces the database storage and the maintenance cost to good extent.
• Improve application performance - Business data queries could be retrieved or processed faster, as only required/relevant data is present in production environment.

Confidential, Plano, TX

Lead Developer / Team Lead

Responsibilities:

• Written PL\SQL procedures and functions to implement the business rules
• Involved in all phases of the SDLC for Designing & giving recommended approach to satisfy the requirements.
• Developedstored procedures to extractthe data from different sources and load it into data warehouse
• Written Perl Modules to parse the input file and populated the data in the backend.
• Interacted closely with Business Users to gather requirements and help with the data modeling effort.
• Operated applications like Universe, WEBI and BO Reports individually.
• CreatedPL/SQL scriptsto extract the data from the operational database into simple flat text files usingUTL FILEpackage.
• Written UNIX shell scripts to read the third party data files and loading into database
• Involved in monitoring the sql performance by the gradual increase of data load in the respective tables and modified the necessary sqls
• Responsible for Analyzing and Implementing the Change Requests.
• Proof of concept tool developed to verify and format forecast response prior to sending through B2B. Establish repeatable Response to forecast process to enable support of additional customers

Environment: Oracle 10g PL\SQL, UNIX shell scripting, NFS mount, stored procs, functions, index, HPQC, DDL scripts, Toad, SQL Navigator, SQL* Plus sequence and triggers.

Confidential, Dallas, TX

Lead Developer / Team Lead

Responsibilities:

• Worked Oracle PSP to bring the progressive results as the user inputs using AJAX.
• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application
• Written Stored Procedures, Functions to display the content from backend in the UI.
• Written Perl-CGI Modules to parse the input file and populated the data in the backend.