SUMMARY:

• Above 7 Years of Experience in the field of Software Design, Development and Implementation with Proficiency in Oracle and 11gR2, SQL, PL/SQL that includes Complete System Development Life Cycle from Analysis and Design to Implementation.
• Expertise in writing Packages, Stored Procedures, Functions, Views and Database Triggers using SQL and PL/SQL in Oracle.
• Proficient in advance features of Oracle 11g for PL/SQL programming like Using Records and Collections, Bulk Bind, Ref. Cursors, Nested tables and Dynamic SQL.
• Experience working in an Agile development environment.
• Have experience on security setup using Active directory integration.
• Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTP applications.
• Worked with query tools like Toad, SQL*Plus, SQL Developer.
• Exposure to concepts of Data warehouse like Design, Data Modeling, OLTP, ETL and Reporting
• Manipulated Stored Procedures, Triggers, Views, Functions and Packages using TOAD.
• Experience in Performance Tuning & Optimization of SQL statements.
• Experienced in identifying Business requirements, Technical requirements, Database Design, Troubleshooting and writing interfaces between various applications.
• Experience in translating business requirements into creation of Database Objects.
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• Experience in migration and conversion from MS Access/SQL Server to Oracle.
• Strong in writing Stored Procedures and SQL queries.
• Proficient in data loading/extraction using SQL*Loader and Oracle utilities.
• Good understanding of the Oracle database, related utilities and tools.
• Have extensive experience in Performance tuning by analyzing the execution plans of the query.
• Hands on experience in tracking down the bottlenecks in query using trace files.
• Extensive experience in utilizing Collections to boost performance in PL SQL block.
• Participated in all Business Intelligence activities related to data warehouse, ETL and report development methodology.
• Provided technical and analytical expertise in responding to complex, specialized report requests requiring complex business logics and detail - level data analysis.
• Strong Background in implementation of RDBMS and OOPS concepts.
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment.
• Experience in working with quality assurance and version controlling tools
• Excellent analytical and interpersonal skills, oral and written communication skills.
• Ability to work individually as well as in a team with problem solving and troubleshooting capabilities.
• Ability to learn new tools, concepts and environments.
• Ability to explain technical concepts and communicate with users and system administrators at all levels. Strong experience in mentoring team members and writing documentation.

TECHNICAL SKILLS:

Databases: Oracle 12c, Oracle11g2, 11g, Oracle 10g R2, 10g, MS Access.

Languages: SQL, PL/SQL, UNIX Shell Scripting

Operating Systems: Windows 95/98/XP, Windows 8.0/8.1, UNIX

Data Modeling: ERwin r 7.1/7.2/7.3/8.0 , Oracle Designer 12.0 and ER Studio 8.5.3.

ETL Tools: Informatica 7.1.2/8.1

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, ASH, AWR, ADDM

OLTP Tools: Microsoft Analysis Services, Business Objects, and Crystal Reports 9

Tuning Tools: RMAN, ASM, Grid Control, Golden Gate, EXP, IMP, expdpimpdp, Maximo

GUI Tools: Oracle Forms 10g/11g, Reports 10g

Third Party Tools: TOAD, SQL Developer, SQL Loader, SQL Navigator, SQL plusPUTTY, WINSCP

PROFESSIONAL EXPERIENCE:

Confidential, Concord, NH

Sr. Oracle PL/SQL Developer

Responsibilities:

• Created, debugged and modified stored procedures, functions, packages, tables, views, materialized views and SQL scripts using PL/SQL.
• Experience in handling the tasks of designing and maintaining SQL databases and VB6 applications.
• Created UNIX shell scripts to automate table creation, execute procedures by using CRONTAB.
• Involved in performance tuning which included creating indices, table partitioning, SQL hints using explain plan utility.
• Developed a Conceptual model using Erwin based on requirements analysis.
• Involved in developing and maintaining control files for SQL loader to load the data from SQL server to oracle database tables.
• Involved in adding new functionalities suggested by client to existing Forms application using Forms.
• Involved Master-Detail blocks in Forms and Reports, user defined procedures with parameter passing, LOVs, record groups, list items, population of list items with record groups, calling reports through Forms, creating parameter list, passing parameters to reports, creation of visual attributes.
• Worked on queries using Teradata SQL Assistant to connect various ODBC sources.
• Worked with DBAs to help them in data loading process, batch jobs and various administration tasks.
• Responsible for data mapping and creating Run-Books from legacy system to oracle.
• Extensive experience in working with different FTP clients such as WinSCP for extracting data from sources to own destination.
• Created synonyms and make sure that users have executable permissions on all objects.
• Performed re-org for several dimension and fact tables for space release management in data warehouse.
• Developed Functions and Procedures to load data into the core tables.
• Made use of SQL Loader in loading data from upstream to the project staging table.
• Extensively used cursors, sequences and indexes in the procedures.
• Created PL/SQL based ETL process to transfer data from legacy sources to staging area and from staging area to data warehouse.
• Involved in Code Reviews for Logical errors.
• Used Exception Handling to handle runtime & user defined exceptions.
• Participated in weekly meetings with the client and update the status
• Used SQL Loader to load the flat files data into the core database tables.
• Created stored procedures for daily database space monitoring.
• Developed PL/SQL procedures which are used in Informatica Mappings.
• Wrote dynamic SQL queries in different procedures and packages to work on PIVOT function.
• Worked extensively on Exception handling to trouble shoot the PL/SQL code.
• Worked in production support environment which involved in performing operation such as monitoring jobs, performing root cause analysis, troubleshooting the issues, monitoring top activity and long running queries, performance tuning and space management.
• Created and modified several UNIX shell scripts according to the changing needs of the project and client requirements.

Environment: Oracle 10g/11g, SQL*PLUS, SQL LOADER, PL/SQL Developer, SQL* PLUS, EXPDP/IMPDP, UNIX Shell script, Forms 10g/11g, Reports 10g, MS Access, MS office.

Confidential, Jersey City, NJ

Oracle PL/SQL Developer

Responsibilities:

• Analyze the functional & technical requirements of the project.
• Discuss with business users, BA's and Architects to finalize requirements and scope of the project.
• Design the Database and reports for the new enhanced COMPASS.
• Hands-on experience with Oracle APEX 3.2/4.0/4.1 (Oracle Application Express).
• Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin r7.1
• Formulated SQL queries, functions and processes as per customization requirement for APEX.
• Supported APEX applications and conducted performance tuning for PLSQL.
• Contributed with database designs and assisted in increasing response time for APEX reports.
• Designed application framework and developed Oracle APEX Application.
• Provided APEX guidance and support to technical staff on application maintenance and SDLC process.
• Design and provide Database service call to UI team.
• Create new tables, views, materialized views, Packages, Stored Procedures and functions as per requirements.
• Perform code review and make changes/improvements as required.
• Optimize the code to meet SLAs with UI. Used Hints like materialize, parallel, no parallel, etc., to improve the performance.
• Maintain SVN repository, deploy code base to SIT, UAT, dry-run environments as requested.
• Plan production deployment activities, ITSM processes, raise RFCs and coordinate with various teams like DBAs, Unix etc.
• Used PIVOT, UNPIVOT, LISTAGG and many functions in Oracle 11G to transform complex source data as per mappings.
• Built reporting against Single, Multiple Tables, Views, Materialized Views and Complex Custom SQL.
• Created variety of visualizations and dashboards according to business requirement specifications.
• Ability to develop comprehensive test plans, scripts and cases and perform unit and comprehensive testing with system developers to ensure overall functionality and technical quality of deliverables.
• Ability to trouble shoot technical issues and problems, monitor progress against plan, and communicate status to Leads.
• Created tables, Correlated sub queries, Nested Queries, Views for Business Application Development.
• Developed back end interfaces using PL/SQL Packages, Stored Procedures, Collections.
• Involved in optimizing database performance by analyzing database objects, creating indexes, creating materialized views etc.
• Designed Database Triggers for audit and validation purpose
• Migration from Oracle 10g to Oracle 11g.
• Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance bottlenecks using STATSPACK, EXPLAINPLAN, SQLTRACE, TKPROF, ASH, AWR, ADDM, SQL MONITOR and EM12c.
• Worked on Instance Tuning, Memory Tuning and SQL Tuning.
• Performed database Point in Time Recovery and Table Space Point in Time Recovery using Transportable Tablespaces.

Environment: Oracle 11g, PL/SQL, PL/SQL Developer, APEX, UNIX.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in the database design for better understanding the relations, associations and dependencies within the data base.
• Involved in using Visual Source Safe and Clear case for source control.
• Involved in writing functional and technical documents.
• Used the merge statements to select rows from one or more sources for update and insertion into one or moretables.
• Used PL/SQL collections (Nested Tables and Varray) in complex backend packages.
• Coded UNIX shell scripts to call SQL scripts and to manipulate the returned data.
• Developed test plan documents for all back end database modules.
• Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Extensively worked on Explain Plans and various hints for Performance tuning.
• Wrote Database triggers for audit and to implement complex business logic.
• Created bitmap indexes on low cardinality columns as they result in reduced response time for queries and substantial reduction of storage space.
• Generated SQL scripts for crating tables, Views, Primary keys, Indexes, Constraints, Sequences and Synonyms.
• Developed and modified PL/SQL packages, procedures, functions as per customer requirement to make new enhancements or resolve problems.
• Created PL/SQL program units to implement DML, DDL statements using dynamic SQL.
• Wrote complex SQL queries to retrieve information from the database depending on user requirement.
• Wrote control files and loaded the data into oracle database with SQL*Loader
• Used PL/SQL Developer tool to do the backend development.
• Implemented enhancements to the application by creating and modifying the packages, procedures, functions and triggers.
• Analyzing the daily tracked transactions which were been reported and rectifying the errors.
• All the relevant issues were been tracked and their corresponding status were reported to the users and clients.
• Wrote complex oracle SQL using joins, sub queries and correlated sub queries.
• Implemented Materialized View for extracting the data from remote database.
• Handled various Exceptions to trouble-shoot PL/SQL code.

Confidential

Responsibilities:

• Worked on the new CR’s as per client requirement.
• Developed server side COM objects in Visual Basic to implement business rules.
• Developed Data Grid ActiveX user control in Visual Basic 5.0, data access objects using ActiveX Data Objects ADO and Remote Data Service RDS.
• Integrated new down streams step up for sending Benchmark data.
• Involved in writing scripts for inserting & deleting values to & from tables Checking constraints and dependencies of the tables
• Integration of new series, files, indices and constituents.
• Made use of SQL Loader and UNIX Shell Scripts to load the daily data in to Confidential database.
• Involved in code reviews
• Coordinated with Client for any Production Issues and Code Changes
• Attended Project review meetings, Status Reporting, Issue tracking
• Developed SQL scripts for creating database objects such as tables, views, materialized views and sequences.
• Involved in modification of UNIX Shell Scripts.
• Prepared Database Documentation and Requirement specification document which has the requirement details provided by the business users.

Environment: Oracle 10g, PL/SQL, Report Builder 10.1.2.0.2 , Toad 7.5.2.0, UNIX, Perl

Confidential

Database Developer

Responsibilities:

• Managing of database objects like Tables, views, indexes.
• Performed regular Database Maintenance task, checking the disk Defrag procedures in Development environment.
• Participated in business requirement gathering and applying the business logic at the back end database. The business logic involves creating packages, procedures, triggers and tables.
• Used Index Tuning Advisor for Database performance for proper indexes.
• Involved in writing Bulk Collects, Cursors, Ref Cursors, and Exceptions within the various procedures.
• Designed batch jobs which are used in loading data into UNIX shell scripts.
• Involved in Performance Tuning and optimization of the SQL queries.
• Creating Indexes and using hints in the SQL queries. Optimizing the queries using Explain Plan.
• Performed Indexing and Index partitioning on various huge tables to enhance the performance of the database.
• Resolved the issue of mission critical tasks with Severity 1. Achieved in resolving the issues within the given stipulated SLA time.

Environment: SQL, PL/SQL, SQL Loader, Oracle 10g, Oracle Reports, UNIX