SUMMARY

• Around 8 years of IT experience in developing software applications using Oracle 12c/11i/11g/10g/9i/8i and its products in a variety of applications.
• Programming experience using PL/SQL, SQL, VB, TSQL, Stored Procedures, Functions, Cursors, Constraints, Triggers, Indexes (B - tree Index, Bitmap Index), Views, and Materialized Views using SQL,C,C++, FTP, and IMS.
• Extensive work experience in writing and implementing database objects like Tables, Views, Indexes, Sequences, Synonyms, Stored Procedures, Functions, Exceptions, Triggers and Packages.
• Expertise in working complete System Development Life Cycle (SDLC) such as analysis, design, development, testing, implementation and support with exposure in database.
• Extensive knowledge of Relational Database Management System (RDBMS) Concepts.
• Data cleansingexperience using PL/SQL, SQL Coding, UNIX Shell scripting.
• Modified existing complex queries into easily understandable by using Sub-query and Loop structures.
• Good knowledge in front end development usingoracle forms/reports6i/9i/10g.
• Good understanding of drug safety analytics.
• Excellent knowledge of SQL and UNIX shell scripting.
• Efficient in Creating and Using Cursors and Ref Cursors in processing of data.
• Experience with writing SQL queries for data validation and data integrity testing.
• Experience in Query optimization/Performance tuning like Performance Planning, Instance Tuning.
• Expertise in creating newC/C++, Pro*C Batch Programswith embedded SQL’s, Pl/Sql Procedure calls, Arrays and Dynamic SQL.
• Knowledge of risk management principles and practices.
• Used Collections and Bulk Techniques to improve performance.
• Experience with performance testing for data loading process in DWH environment.
• Extensively worked on Packages, Functions, Procedures and Triggers in PL/SQL.
• Extensively used ETL methodologies for Data Extraction, Transformation and Loading processes.
• Good knowledge of STAR Schema, Snow Flake Schema, FACT Tables and Dimensional Tables.
• Experienced in User Acceptance Testing (UAT), Unit testing, System testing, Integration testing, Development and Production.

TECHNICAL SKILLS

Database: Oracle 12c,11i,11g, 10g, 9i, 8i, SQL Server

Operating System: Windows NT, Windows 95/98/2000, Windows XP

Tools: TOAD, Putty, OWB/ETL, SQL Developer

Languages: SQL, PL/SQL, UNIX Shell Scripting, C, C++, Perl Scripting

DB Utilities: SQL*Loader, Explain Plan, vi Editor, Data pump, Export / Import, Expdp / Impdp

File Transfer: TCP, UDP, FTP, DNS, SMTP, DHCP

Web Technologies: HTML, DHTML, XML, JavaScript, CSS

Other Application: MS Office, Adobe Acrobat Reader/Writer

PROFESSIONAL EXPERIENCE

Confidential, Norwood,MA

Oracle PLSQL Developer

Responsibilities:

• Created and managed users, roles and profiles, monitored databases and user access.
• Used PL/SQL tables to avoid mutating problem in database triggers.
• Used Public Synonyms, read only User Accounts and Database Links for remote database access.
• Handled errors using System defined exceptions and User defined exceptions like INVALID NUMBER, NO DATA FOUND and PRAGMA EXCEPTION INIT.
• Developed Row level and Statement level Triggers for auditing tables in PL/SQL.
• Programed UNIXshellscripts to provide a user interface toOracleformsandreports.
• Used export/import and expdp/impdp database utilities for data transfer.
• Tested Oracle PL/SQL and Stored Procedures, Virtual Basic.
• Created Stored Procedures, Functions and Triggers to maintain various business rules in the Active Data Warehousing Project.
• Created records and nested tables in the procedures for handling data.
• Analyzed the existing Stored Procedures, Functions, Triggers and Cursors thoroughly on Performance issues.
• Automated connection to and data retrieval from team site, exported risk report data in spreadsheet format, and automated data retrieval for continuing operations.
• Extracted data from the Customer Interaction Center and creating separate flat file (text file) to load data into database table using ETL.
• Used BULK COLLECT, and External Tables for improving performance on the Enterprise Data Warehouse.
• Analyzed time consuming SQL and PL/SQL block queries and tuned them to run in less time by using cost based Optimizer hints, Explain plan.
• Worked with different types of Sub-queries and Loop structures which suit according to business logic.
• Worked on Materialized views to improve the performance of distributed queries.
• Performed performance tuning for various report queries using Explain Plan and TKPROF.
• Used partitioning of tables to improve the performance of queries.
• Tested migrated forms and reports by writing test plans and scripts.

Environment: Oracle 12c, 11g/11i, TOAD, SQL*PLUS, VB, Export, Import, SQL server, UNIX, SQL*Loader, Java

Confidential, Boston, MA

Oracle PL/SQL Developer

Responsibilities:

• Involved in writing complex queries to generate reports as per client request as a part of production support.
• Modified Procedures and Functions to suite the improved business requirements.
• Created records and nested tables in the procedures for handling data.
• Developed packages for processing data in the data staging tables according to the Clients requirements.
• Involved in creating Sequences (to generate consequence numbers) and Constraints (to limit the type of data).
• Also analyzed Indexes on regular basis.
• Created stored procedures with cursors to load the data from staging to analysis tables.
• Upgraded the existing database to 12c using either DBUA or the command-line upgrade scripts.
• UsingPackages, Functions, Pro*CDeveloped a massive custom batch program forCredit Card settlementfor transactional data.
• Analyzed business requirements and interfaced for development and enhancement of a system to support multiple business areas including Asset Management and risk management.
• Used %type and %row type for anchoring the variables to the database data types.
• Developed new standard financial reports using Oracle Reportsand also maintained existing financial reports in Reports.
• Used SQL plus and TOAD to develop database applications.

Environment: 12c, 11g/11i, TOAD, SQL*PLUS, VB, Export, Import, SQL server, UNIX, SQL*Loader, Java

Confidential - Richmond, VA

PL/SQL Developer

Responsibilities:

• Gathered and analyzed requirements from business users.
• Used SQL Loader to load data into the database coming from MetaVance and Standby Databases.
• Focused towards Inmate Management System and Reporting as part of Project, to study the existing functionality of the system. Involved in understanding the Flexibility and capability of IMS.
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Services.
• Build and testing of the message flows on Enterprise Messaging Infrastructure.
• MQ programming using eSQL for the transformation of messages and routing to the destination.
• Wrote complex PL/SQL packages for Customer Interfaces, Payment Interfaces and Broker Commissions for Oracle Applications.
• Document and communicate changes to the OLTP, OLAP systems and data warehouse teams, including Data Modeling, ETL and Database teams.
• Created SSIS package to load data from Flat File to Flat File and Flat File to SQL Server 2005 using SlowlyChanging Dimension.
• UsedSparksql to allow running the SQL like queries on Spark data using traditional BI and visualization tools.
• Work on Migrating Oracle Forms and Reportsfor Inmate Management System IMS.
• Created Test Cases, Technical Design Documents, and Install Plans and worked with Release Engineering teams.
• Used Spark SQL toETL the data from different formats, transform it, and expose it for ad-hoc/interactive querying.
• Enhancement in the existing IMS System.
• Understanding the IMS Process and its complexity and providing timely and desired solutions to the Management.
• Used ClearCase, ClearQuest, and Sharepoint for defect creation/resolution, documentation, development tracking and Code repository.
• Supported development, test and the production databases.
• Used SQL Developer to develop code.

Environment: Oracle 9i, PL/SQL, Shell scripts, TOAD, SQL server.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in creating Sequences (to generate consequence numbers) and Constraints (to limit the type of data).
• Planned Index Rebuilding, Index Analyze and Table Analyze on periodic basis.
• Involved in creating users and privilege Management using roles and grants.
• Used Pragma Exception INIT to name the system exceptions that are raised by the program.
• Build and testing of the message flows on Enterprise Messaging Infrastructure.
• MQ programming using eSQL for the transformation of messages and routing to the destination.
• Written Shell scripts to automate loading the files into database using Crontab.
• Made used Sub-query (WITH clause) to make complex SQL statements simple and make them more efficient.
• Used Public Synonyms, read only User Accounts and Database Links for remote database access.
• Used Oracle supported DBMS STATS, DBMS JOB packages to gather the statistics and schedule job respectively.
• Documentation of the completed work.

Environment: Oracle, UNIX Shell Scripting, Export/Import, SQL Developer, SQL*PLUS, TOAD.