SUMMARY

• Over Seven years of experience primarily in Oracle SQL and PL/SQL, UNIX Shell scripting and Solaris production support.
• Proficient in Oracle 11g/ 10g/9i/8i, PL/SQL Developer, Oracle Solaris, HP Quality Center, HP Server Automation Tool and Service Now Incident Management tool.
• Experience in all phases of the project Life cycle - Requirement gathering and Analysis, Database design, Database development, Application development, Test, Implementation and Support.
• Proficient in SQL and PL/SQL programming- Creating Stored procedures, Functions, packages, cursors, ref cursors, Nested Tables, triggers, associative arrays and user defined types.
• Strong Experience in ORACLE 8i/9i/10g/11g Databases, SQL SERVER, PL/SQL, SQL* Loader, Shell Scripts, SQL Plus, Oracle Express Language in windows NT and Unix environment.
• Strong experience in table and Index partitioning.
• Expertise in Performance Tuning of complicated Procedures, Packages and all kind of SQL queries by using SQL Trace, Explain Plan and TkProf.
• Extensively used PL/SQL, Built in Oracle Packages, stored procedures, functions, triggers, cursors, Ref Cursors.
• Experience with various DDL operations like Creation of Indexes, Materialized Views and Partitioning tables.
• Designing, Coding, Testing and implementation of High Availability Distributed System.
• Expertise in performance Tuning of SQL queries and complex procedures to improve performance & decrease response time utilizing Explain Plan and Hints.
• Involved in Data modeling, E/R diagrams, normalization and de-normalization as per business requirements.
• Experience in Data Migration, SQL Loader.
• Expertise in Creating SQL Loader Scripts to load data from flat files into database and exporting data to flat files using UTL FILE package.
• Experience in coding PL/SQL packages using credit and debit logic.
• Extensive experience in developing applications using Oracle Forms and Reports.
• Expert in Incident Management working through critical incidents. Manning command centre and conducting Incident resolution bridge calls.
• Excellent problem solving and decision making skills.
• Proven leadership and organizational abilities.
• Quick learner with ability to master new concepts and applications.

TECHNICAL SKILLS

Operating Systems: Windows NT/2000/XP/7/8/10, Solaris 10, HP-UX 10/11, AIX, Linux

Programming languages: C, C#, Java, PL/SQL programming.

Web Technologies: HTML,XML.

Script Languages: JavaScript, Shell scripting.

Tools: Toad, SQL Developer, OEM, PL/SQL Oracle Developer/2000Oracle Forms/Reports 6i/9i/10g, Autosys, Putty, SQLPlus, CitrixReflections for Unix, HP QC,HP Server Automation

Database: Oracle 11g/10g/9i/8i/8, MS Access 2000, MySQL, MS SQL Server 2012

Others: Object Oriented Designing Methodology, UML, RDBMS Concepts

PROFESSIONAL EXPERIENCE

Confidential, DURHAM, NC

Oracle PL/SQL Developer

Responsibilities:

• Gathering business requirements.
• Conducting walkthroughs, review meetings with junior developers and seeking inputs from them.
• Translate the business requirements into technical requirements, conduct meetings for approvals.
• Understanding the business logic to modify existing SQL Code and Performance Tuning if it requires.
• Involved in writing Data Migration scripts/create table scripts to load database successfully from old schema to new structured schema.
• Altering the database Objects to synchronize it with the new Schema created.
• Involved in updating procedures, functions, triggers and packages based on the change requests.
• Created new Tables, Indexes, views, synonyms and Sequences where needed.
• Created and Modified PL/SQL Triggers, Procedures, Functions and packages.
• Developed ER Diagrams, Data flow diagrams based on the requirement.
• Developed SQL scripts to create database objects like tables, views and sequences.
• Used SQL*Loader to load bulk data from various flat files and legacy systems.
• Used PUTTY & secure shell to connect to UNIX machines.
• Write complex shell scripts for processing of the files and schedule the jobs in Control-M.
• FTP csv files generated from SAS and load data into oracle tables.
• Moved data from various source to Staging area using ETL tool- Informatica.
• Developed several Mappings and Mapplets using Sources, Targets and Transformations.
• Extensively used various types of transformations - Expression, Joiner, Update Strategy, Aggregator, Filter, Sorter, Lookup, Rank and Router.
• Used TortoiseCVS control version for synchronizing the upgrades.

Environment: Oracle 11g (11.1.1.0.0 ), Oracle 11g (11.2.0.1.0 ), SQL, SQL*Plus, PL/SQL, Oracle Reports, Informatica power center, Oracle Business Intelligence, APEX, SQL Developer, Toad, Putty, UNIX Shell Scripting.

Confidential, VA

Oracle PL/SQL Developer

Responsibilities:

• Involved in project planning sessions with project managers, business analysts and team members to analyze business requirements and proposed IT solutions.
• Worked on SDLC Iterative life cycle model and Involved in Web application Design and Development in 3-Tier Architecture using JSP's, Java and Struts.
• Performed SQL and PL/SQL Tuning to improve the performance of SQL queries and PL/SQL code using utilities like SQL Trace, Explain Plan, Hints and Indexes.
• Used PL/SQL collections and Records, Dynamic SQL and Types and Objects.
• Involved in Development of JDBC code to access oracle Database from Java.
• Responsible for Work Break Down/Deliverables of Project from Data Base Team.
• Developed Low Level technical design documents / Data Mapping Documents and procedure signature design to support the Front End .NET / JAVA web based applications.
• Worked on PL/SQL Implicit and Explicit Cursors and used Dynamic SQL.
• Worked on Dynamic creation of Tables and Loading data into them.
• Writing/Creating Generic Stored Procedures, Functions, Database Triggers, Packages, Tables,
• Indexes, Views, Synonyms, Sequences in Oracle 11g.
• Responsible for Purging and archiving the production databases by interacting DBA.
• Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.
• Project Development is done on Iterative and Incremental Software development life cycle methodology.
• Responsible for troubleshooting the errors that occurred when the production group hit a roadblock (Production Support).
• Executed Unix Korn shell scripts, directory structures and I/O file handling in Production.
• Developed reports using complex queries as per client request as a part of production support
• Responsible for performing code reviews and Incident Management working through critical incidents.
• Provided on call support, solved the user issues and made necessary changes.
• Resolving Production Severity Issues in time and meeting the SLA.
• Writing high quality and well documented code according to standards.
• Provide 24/7 on call production support and resolve production issues immediately.

Environment: J2EE, Eclipse, Oracle 11g / 10g PL/SQL, Oracle Performance Tuning, Autosys, Oracle Hints, Unix, Java, Sub Version, Export / Import Utilities, TOAD, SQL Navigator, SQL Server, Query Analyzer, Enterprise Manager.

Confidential, Tampa, FL

Oracle Developer

Responsibilities:

• Wrote Stored Procedures, Functions, Packages and triggers using PL/SQLto implement business rules and processes.
• Used advancedSQLlike analytical functions, aggregate functions for mathematical and statistical calculations.
• OptimizedSQLused in reports to improve performance dramatically.
• Tuned and optimized the complexSQLqueries.
• Had to design database model risk management application.
• Worked with Business users to gather requirements for developing new Reports or changes in the existing Reports.
• Generated fully functional Microsoft Excel Spreadsheets using PL/SQLdirectly from the database.
• Extensively used SQL*Loader scripts to load legacy data into Staging tables and relevant Packages to validate and cleanse data.
• Created Cursors, Collections and DB Triggers.
• CreatedINDEX BY Table Method to Fetch Records in Random Selection.
• Fine-Tuned and optimized number ofSQLqueries and performed code debugging using TOAD.
• Set up batch and production jobs through Tidal.
• Created Shell scripts to access and setup runtime environment, and to run Oracle Stored Procedures, Packages.
• Involved in debugging and Tuning the PL/SQLcode, tuning queries, optimization for the Oracle database.
• Worked with HTML, JavaScript pages in order to create web pages and fix bugs for the Rhapsody web site.
• Extensive testing ETL experience usingInformatica 9.1/8.6.1/8.58.1/7.1/6.2/5.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager) Teradata and Business Objects.
• Worked onInformaticaPower Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Review data transformation rules and provide technical suggestions in data transformation logic and pseudo code (PL/SQL).
• TunedSQLqueries, performed refinement of the database using tools likeEXPLAIN PLAN, andTKPROFto significantly improve the system response, time and efficiency.
• Developedstored procedures, functions and packagesfor updating, inserting and deleting data from the tables.

Environment: Oracle 11g, SQL, SQL*Plus, PL/SQL, Oracle Reports, Informatica power center, Oracle Business Intelligence, APEX, SQL Developer, Toad, Putty, UNIX Shell Scripting.

Confidential, Sherman Oaks, CA

Oracle PL/SQL Database Developer

Responsibilities:

• Interact with Development Teams and Managers to analyze business needs.
• Translate the business requirements into technical requirements, conduct meetings for approvals.
• Transformed data from one server to other servers using tools like Spool, SQL loader and BCP in SQL server.
• Wrote Perl scripts to interact with the database and migrate data from oracle to SQL server database.
• Used Perforce Visual Client P4V, which provides quick and easy access to versioned files through a graphical interface
• Documented the ETL process for future references.
• Created new Tables, Indexes, views, synonyms and Sequences where needed.
• Create complex PL/SQL Packages, Procedures and Functions as per the requirement.
• Developed and created the new database objects including tables, views, indexes, stored procedures and
• Handled different types of predefined and user defined Exceptions.
• Extensively used PL/SQL Collections, Bulk Collect, for all, Table Types, And Record Types.
• Extensively used UTL FILE package to read and write to OS files and create data feeds to downstream systems.
• Move data between different database environments using Import/Export.
• Created Table partitions and materialized views to improve the performance of slow running queries.
• Wrote complex shell scripts for processing of the files.
• Created Test scripts and involved in Unit, Integration and System testing and User Acceptance Testing.
• Wrote FTP scripts for transferring files, FTP checks to ensure complete file transfers.
• Automated the process of migration from oracle to SQL server by using AUTOSYS.
• Used PUTTY to connect to UNIX machines.
• Used Rapid SQL & Toad for Oracle to access DB, write packages, procedures & functions.
• Involved in writing data Migration scripts, Created Upstream Source Relationship documents and batch run books.
• Guide/help team members in resolving technical issues.
• Provide 24/7 on call production support and resolve production issues immediately

Environment: Oracle 9i(9.2.0.1.0), Oracle 10.0.2, SQL, PL/SQL,T-SQL, Rapid SQL 7.6, Toad for Oracle, SQL Server Management Studio, UNIX, Windows NT, Putty for UNIX, Perforce, Autosys.

Confidential

Jr.Oracle Analyst

Responsibilities:

• On call duties for development, staging and production environment.
• Investigating, determining the cause and fixing all production problems.
• Infrastructure Monitoring/Alerting
• Identify potential issues early and before impact with proactive monitoring
• Incident Triage/Team Coordination
• Gathering of diagnostic details including logs, server metrics, and running data gathering scripts
• Incident/RCA Process for Outages.
• Documentation of incident and process adherence including ownership and follow through of SSO RCA and assigned tickets
• Participation on daily Operations call providing synopsis of events and next steps

Environment: Solaris 10,Oracle 9i,HP Quality Center, SQL Plus, Putty, GE Service Now.