SUMMARY

• Over 7 years of experience in Database Development using SQL and PL/SQL.
• Experience working with Oracle Data Integrator (ODI).
• Experienced in developing stored packages, procedures, functions, Partitions, triggers, and views.
• Extensive work experience in Oracle 11g, 10g & Oracle 9i databases.
• Strong experience with Oracle data warehousing features such materialized views, bitmap indexes, Index Organized Tables.
• Experienced in PLSQL Collections (Associative arrays, nested tables & VARRAY).
• Experience in advanced PL/SQL concepts like Bulk collect, PL/SQL tables and Dynamic SQL for DML operations for better performance.
• Thorough knowledge and experience in using analytical functions.
• Strong working knowledge using cursors and ref cursors.
• Experienced in Database Optimization by making use of various Performance Tuning techniques.
• Proficient in database and SQL tuning using HINTS, EXPLAIN PLAN and TKPROF.
• Very good knowledge and experience in using Oracle in - built packages like UTL FILE, DBMS SQL etc.
• Very good working knowledge in TOAD & SQL Developer.
• Expertise in Database Performance Tuning, Performance Monitoring and Query Optimization using Oracle Hints, Explain plans and Table partitioning.
• Experience in creating SQL loader scripts to load data from flat files into the database.
• Experience in creating UNIX shell scripts to automate the tasks using ‘CRONTAB’.
• Excellent planning, analytical, written, communication and Interpersonal skills.

TECHNICAL SKILLS

Operating Systems: HP-UX, Sun Solaris and Windows 95/98/2000/XP.

RDBMS: Oracle 11g/10g/9i.

Languages: SQL, PL/SQL, UNIX Shell Scripting.

Tools: and Utilities TOAD, PL/SQL Developer, Sql Developer, ODI, Accurev, JIRA

Tuning Tools: TKPROF, EXPLAIN PLAN, SQL Optimizer.

PROFESSIONAL EXPERIENCE

Confidential, Cleveland OH

Sr PL/SQL Developer

Responsibilities:

• Created technical mapping documents as part of data modeling and design.
• Created data stores, interfaces, procedures, packages and scenarios in ODI repositories.
• Developed PL/SQL Procedures and Functions in accordance with the business requirements for extracting legacy data and loading data into database tables as part of data migration.
• Involved in tuning SQL queries.
• Developed test cases and Involved in Unit testing.
• Created complex stored procedures, views, SQL joins and scripts.
• Created high quality and well documented code according to standards.
• Used Accurev for version control of the code.
• Used JIRA for bug tracking and for raising tickets.
• Involved in daily status calls with clients.

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

Confidential, Durham NC

Sr PL/SQL Developer

Responsibilities:

• Developed PL/SQL Procedures and Functions accordance with the business requirements for loading data into database tables.
• Created PL/SQL packages for calculation of metrics statistics across 13 states by including state and domain wise parameters which resulted in reducing the report generation time by almost 90%.
• Developed the SQL code for performance and penalty statistics calculation.
• Involved in tuning SQL queries.
• Executing Daily and Monthly reports in UNIX and automated the 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 the Change Requests
• Monitoring day-to-day Process for different Data Loads and resolving Issues.
• Created complex stored procedures, views, SQL joins and scripts.
• Writing high quality and well documented code according to standards.
• Involved in fine tuning stored procedures by making use of PL/SQL Collections and its BULK FETCH and BULK INSERT features.
• Involved in daily status calls with clients.

Environment: Oracle 11g, SQL*Loader, Shell Scripting, Sun Solaris 5.10, PL/SQL Developer, TOAD, HP Quality Center.

Confidential, Dallas TX

PL/SQL Developer/Production support

Responsibilities:

• Experience in developing various PL/SQL objects like procedures, functions, packages and triggers in accordance with the business needs.
• Involved in interacting with the end-user (client) to gather business requirements and modeling the business requirements.
• Participated in analyzing the requirements for the logical and physical design of the database.
• Involved in tuning and query optimizing SQL queries by using quest control tools and manual by EXPLAIN PLAN.
• PL/SQL Collections were extensively used for high performance of stored procedures.
• Populating the data warehouse tables using SQL*Loader.
• Implemented complex views, procedures, functions, packages and triggers in PL/SQL.
• Performed exception handling for data that did not conform to the required format.
• Responsible for making the merged data in turn available to other clients.
• Implemented PL/SQL scripts in accordance with the necessary Business rules and procedures.
• Developed PL/SQL packages and procedures for the back end processing of the proposed data base design.
• Coded PL/SQL Procedures, Functions and Packages for batch processing of the applications.
• Developed reports using complex queries as per client request as a part of production support.
• Worked upon version change from OSS4.x to OSS5.x, as part of T Mobile customer upgrade and migration procedure.
• Worked on the concepts of Network Management Systems and the functionality of FCAPS.
• Conducted PL/SQL session for co-workers to educate about the latest PL/SQL features, PL/SQL performance tuning.

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

Confidential

PL/SQL Developer/Production support

Responsibilities:

• Worked as an Oracle database administrator in maintaining various Development and Production databases and managing their growth, configuration and performance.
• Developed stored procedures and complex packages using PL/SQL and Shell programs.
• Developed triggers, packages, procedures and functions using PL/SQL.
• Worked on developing stored procedures for database administrative tasks and database triggers to implement database auditing and to store historical data.
• Worked on 24/7 support carrying production pager and supporting the business in off Hours during critical issues.
• Managed replication issues.
• Handling bill cycles as scheduled.
• Ensured to clear the bill run dependencies like Pre Bill Checks, Usage Processing well before bill run.
• Keeping a track of Business SLAs pertaining to account billing and ensuring them by manual intervention if required in any of the processes.
• Monitoring Automated Alerts to check for errors.
• Handling payment issues that are made by customers through various interfaces. Clearing payment errors.
• Responsible for continuous monitoring of the TUXEDO server and billing production servers.
• , Business Induction of new members & preparation of Induction Manual.

Environment: KENAN FX/ARBOR, ROAM6, Oracle 11g/10g, Toad, Sun Solaris, Shell Scripting.

Confidential

Assistant Systems Engineer

Responsibilities:

• Actively participated in gathering Business Requirements.
• Analyzed the current data management procedures in practice and suggested ways for automating the process or improving the existing system.
• Developed stored procedures to pull the data from the distributed systems.
• Involved in Developing and handling the PL/SQL Packages, Procedures and Database Triggers.
• Maintaining daily batch cycle and providing 24/7 support.
• Developing back-end PL/SQL packages, building UNIX shell scripts for data migration and batch processing.
• Defined database requirements and designed data model.
• Integrated the mailing system to alert various group on the status of data pulls and data processing.
• Developed and implemented dozens of automated batch processing jobs, running in numerous development, test and production environments.
• Involved in importing the production data to work environment through TOAD.
• Involved in handling the changes in compiling scripts according to the database changes.
• Made sure that all configurations are in place to avoid the files going into MIU queue.
• Made sure that the error queue is as low as possible.

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

Confidential

Software Engineer Trainee

Responsibilities:

• Maintenance of data in all the tables of the database.
• Using the Pl/Sql procedures pulled out the reports as requested by users.
• Created functions to calculate the aggregate statistics.
• Monitored the daily jobs of Unix Shell scripts.

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