SUMMARY

• Over 8 years of experience in Database development using Oracle, SQL, PL/SQL andOracle Developer Suite
• Substantial development experience in creating Procedures, Packages, Functions, Triggers views, Tables, Indexes, Cursors, PL/SQL Collections,optimizingquery performance and other database objects using SQL, PL/SQL.
• Experienced in backend database development using tools SQL*PLUS,SQL* Loader, Oracle Designer, Oracle TOAD wif good understanding of RDBMS and Normalization Techniques.
• Experienced in environments requiring direct customer interaction during Specifications, Design, and Development and Product Implementation phases.
• Experience in Performance Tuning using EXPLAIN PLAN, SQLTRACE and TKPROF.
• Expert in using ORACLE provided packages like DBMS PROFILER, DBMS SCHEDULER, DBMS ADVANCE REWRITE for better performance.
• Extensive noledge on database for Oracle 8i, 9i, 10g,11g and 12c wif experience in very large - scale database environment and mission critical large OLTP and OLAP systems.
• Good noledge on logical and physical DataModeling using normalizingTechniques.
• Experience in developing/customizingForms and Reports using oracle tools like Oracle Form Builder (10g/6i/5.0) and Oracle Report Builder (10g/6i/5.0)
• Handled DBA activities like Grant/Revoke privileges to database objects
• Extensively worked wif various SQL scripts for relational databases.
• Proficient in key Oracle performance related features such as QueryOptimizer, ExecutionPlans and Indexes.
• Strong experience in Data warehouse concepts,ETL.
• Worked extensively on Ref Cursor, External Tables,Collections and Bulk techniques (FOR ALL, BULK COLLECT) to improve performance.
• Writing scripts for collection of statistics, reorganization of tables and indexes, and creation of indexes for enhancing performance for data access.
• Strong noledge of Data Extraction, Data Mapping, Data Conversion and Data Loading process using UNIX Shell scripting, SQL, PL/SQL and SQL Loader.
• Enforcing data integrity using integrity constraints and database triggers.
• Extensively worked on Triggers for implementing complex data integrity checks and for auditing tables.
• An expert in XML/BI publisher reports having developed reports and Created XML Templates (RTF/XSL-FO) and XML Data Definitions.
• Worked on Importing or extracting data using Import techniques to create SAS datasets from various sources like Excel and flat files.
• Used SAS extensively to analyze clinical data from CRF’s, creating SAS data sets for analysis and report writing for clinical trials (Pre-clinical through Phases IV), and generating reports using PROC Tabulate, PROC Report, Data Null, SAS arrays, PROC SQL and Macros.
• Knowledge in Test Scripts, Test Cases, and SQL QA scripts to perform Unit testing, System Testing and load testing. Seamlessly migrated teh Code from Development to Testing, UAT and Production.

TECHNICAL SKILLS

RDBMS: Oracle 12c/11g/10g/9i/8i, SQL Server, MySQL, MS-Access, db2

Languages: SQL, PL/SQL, SAS, UNIX Shell scripting

Web technologies: XML, HTML, DHTML

Tools: Oracle Enterprise Manager, TOAD, SQL*Plus, SQL* Loader, SQL Developer, PL/SQL Developer, Oracle reports and forms 6i/9i/10g, Discoverer 4i/9i/11g, Erwin, JIRA, Visio, Putty, WinSCP, CVS, ARCH and SVN, SAS/BASE, SAS/MACROS, SAS/ODS, SAS/GRAPH, SAS, SAS/ACCESS, SAS/SQL

Operating Systems: Windows, UNIX, Red Hat Linux 7.0, Sun Solaris.

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

Oracle PL/SQL Developer

Responsibilities:

• Participated in client requirement sessions to analyze and gather business requirements.
• Involved in teh Analysis, Design, Coding and Testing of teh application and participated in discussion meetings about requirements.
• Involved in logical and physical database design.
• Developed ER Diagrams, Data flow diagrams based on teh requirement.
• Developed SQL scripts to create database objects liketables, views and sequences.
• Wrote complex PL/SQL queries and performed data analysis.
• Created and Modified PL/SQLTriggers, Procedures, Functions and packages
• Extensively used for all and bulk collect to fetch large volumes of data from table.
• Used SQL*Loader to load bulk data from various flat files and legacy systems.
• Modified existing codes and developed oracle Forms, PL/SQL packages to perform Certain Specialized functions / enhancement on oracle Application.
• Developed teh forms from teh legacy system data using Oracle Forms 10g.
• Developed SQL and PL/ SQL scripts for transfer of data between databases.
• Used Ref cursors and Collectionsfor accessing complex data resulted from joining of large number of tables.
• Optimized long running application queries, analyzing tables, tuned stored procedures for maximumefficiency in various schemas across databases.
• Worked extensively on performance tuning handling large volume of datasets (>500 million rows).
• Modified and enhanced existing systems to incorporate new functionality and to optimize them for performance.
• Used ORACLE packages DBMS PROFILER, SQL TRACE, and TK PROF reports performing Package performance analysis.
• Worked extensively onperformance tuning and Query Tuning (Generating Plan Table, Explain Plan, optimizer wif Hints, Analyze, Indexing strategy, SQL Trace, TKPROF, AWR and ADDM reports).
• Designed teh PL/SQL Procedures to load data from Flat files and Oracle into teh target Oracle database.
• Developed UNIX shell scripts to automate data extraction using VI editor, SQL scripts and PL/SQL scripts. Scheduled all teh shell scripts in crontab and monitor them by logging them in to a separate table.
• Worked on teh integration on various legacy systems to teh main process which included teh data migrationand maintenance.
• Developed PL/SQL packages to use in SOAP and REST Services.
• Worked on data imports / Exports, Data pumps, SQL Loader.
• Worked on Database Design, Data Modeling, Migration, and Systems Architecture, Planning, Testing Query Optimization and Trouble Shooting.
• Involved in Code Review and User Acceptance Testing (UAT) of teh application.
• Understanding teh process and Interacting wif functional team to resolve teh issues in teh given objects.
• Was responsible to update and maintain all process related documents and coordinate teh effort wifin teams.
• Helped in maintaining an effective documentation process to track teh version control and requirementchanges.

Environment: Oracle 12c, PL/SQL, TOAD, Erwin, Windows XP, RedHat LinuxEE 5.3, SVN.

Confidential, Houston, TX

Oracle Developer

Responsibilities:

• Generated SQL and PL/SQL scripts to install building database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms wif oracle 10gdatabase.
• Created complex functions, stored procedures and packages by using PL/SQL.
• Participated in Designing databases (schemas) to ensure that teh relationship between data is guided bytightly bound Key constraints.
• Responsible working wif user groups, analyzing reported problems, performing root cause analysis andpresenting alternatives to correct teh problem.
• Developed back end interfaces using PL/SQL packages, stored procedures, functions, Object Types, Pipelined functions, Oracle queues and used Collections, Bulk Collects to improve performance by minimizing teh number of context switches between teh PL/SQL and SQL engines.
• Wrote complex SQL queries using Joins, sub queries and inline views to retrieve data from teh database.
• Created programming code using advanced concepts of Records, Collections and Dynamic SQL.
• Created Cursors, Collections and database triggers for maintaining complex integrity constraints and implementing teh complex business rules.
• Worked extensively on Ref Cursor, External Tables and Collections.
• UsedCrystal Reportsto track logins, mouse overs, click-through, session durations and demographical comparisons wif SQL database of customer information.
• Worked on various tables to create Indexes to improve query performance. Also worked on partitioning large tables using Range Partitioning, creating Index Organized Table, Rollback Tablespace.
• Designed and developed complex reports to meet end user requirements and deployed using Oracle Report 10g.
• Developed complex triggers in reports before/after for validation of user input.
• Designed and developed user interfaces using Oracle Forms 10g.
• Converted oracle form application 6i to 10g using migration assistant.
• Performed unit testing and supported integration testing and end user testing.
• Extensively worked on production issues wif effective defect management.
• Proactively tuned SQL queries and performed refinement of teh database design leading to significant improvement of system response time and efficiency.
• Developed SQR’s for loading data from feed file to staging tables.
• Involved in SQL tuning, PL/SQL tuning and Application tuning using various tools like TKPROF, EXPLAIN PLAN etc.
• Design and development of conversions, interfaces, customizations, Custom Forms, Reports and all Technical design and solutions.

Environment: Oracle 10g/11g, Oracle forms/reports 10g, SQL, PL/SQL, SQL*Plus, Toad, MS-SQL Server, Windows NT, HTML, XML.

Confidential

PL/SQL Developer

Responsibilities:

• Responsible for writing database programming to Store/Retrieve teh information from teh database usingSQL.
• Designing and creating schema objects like Database tables, indexes, views, synonyms, and all schemaobjects in Oracle.
• Responsible for managing production, development & test databases and applications.
• Independently Designed and developed subject areas in RPD.
• Mapped different data sources to teh Physical Layer and created teh Business Model and Mapping Layer (design of hierarchies, dimensions, and aggregates, Dynamic Column Naming)
• Wrote Stored Procedures according to specs and control files for input to SQL*Loader utilities for loading data from external files into teh Oracle database.
• Used Oracle UTL file features to create flat files and Procedures for Data Extraction.
• Creation of Users and Granting them privileges and roles.
• Creation of Table space, Data files, Indexes, Rollback Segment and monitoring them.
• Creating databases, objects, roles and privileges.
• Partitioned large tables to increase teh performance.
• Configured scripts to monitor activity wif database.
• Wrote extensive Sub Queries, PL/SQL procedures, functions, triggers and packages.
• Writing Pl/SQL procedures and functions. Writing shell scripts to automate teh data loading.
• Monitoring teh data loading jobs and tuning teh SQL queries.

Environment: Oracle 8i,9i, SQL Server 2000, UNIX (Sun Solaris), Windows (NT/2000/Advanced Server), TOAD, SQL*PLUS, Explain Plan, UNIX Shell Scripting, Quest software tools.

Confidential

SAS Programmer

Responsibilities:

• Analyzed teh requirements and design teh application as per teh requirements of teh users.
• Created and edit check programs to find data discrepancies in raw datasets provided by Data Management Group.
• Supported statisticians and statistical programmers through teh creation of tables, listings, figures, and other clinical data summaries.
• Performed Data analysis, statistical analysis, generated reports, listings and graphs using SAS tools - SAS/Base, SAS/Macros, SAS/Graph, and SAS/SQL.
• Used SAS/ Macro facility to provide reusable programs that can be conveniently used from time to time and, created tables, graphs and listing reports.
• Data migration from Excel, CSV, Tab, DLM and flat files into SAS datasets.
• Analyzed and evaluated clinical data for completeness, correctness and consistency.
• Maintained appropriate documentation surrounding archiving clinical data.

Environment: SAS/BASE, SAS/MACROS, SQL*Plus, SQL*Loader, Toad, UNIX, MS Excel, MS Access, Windows.