SUMMARY:

• Over 5 years of expertise in Database Design, Development, Data Profiling and Enhancement and Maintaining using Oracle 12c/11g/10g/9i/8i, Web deployment, Oracle SQL Loader in Windows and UNIX environments. Strong knowledge in Oracle Architecture, Data Dictionary and DBMS Packages.
• Expertise in database performance, data warehouse, ETL, SQL queries, PL/SQL procedures, packages, functions, cursors, triggers, interfaces and data conversion using PL/SQL, SQL*plus, TOAD, and SQL developer.
• Experienced in developing Data Conversions/Migration from Legacy System of various sources (flat files, Oracle, Non - Oracle Database) to Oracle system using Data stage, SQL LOADER, External tables and calling Appropriate Interface tables and API's Informatica.
• Extensive experience in Complex SQL Queries, Analytical functions, Exception Handling etc.
• Improved performance of PL SQL program units by using Bulk collect and Bulk bind (ForAll) features with collections.
• Expert in Query Optimization, Debugging and Tuning for improving performance of the applications using Explain Plan, SQL Trace and TKprof.
• Experience in using several built-in database packages as DBMS JOB, DBMS OUTPUT, UTL FILE and DBMS UTILITY etc.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP.
• Handled large scale Multi-terabyte databases.
• Extensive experience working with DBLinks and creating materialized views, bitmap indexes, Index Organized table, etc.
• Experience in identifying and resolving ETL production root cause issues and debugging, performance tuning of sources, targets, mappings and sessions.
• Experienced in working with various Scheduling tools like Autosys, Control-M, Informatica scheduler.
• Involved in writing various UNIX shell scripts for writing automated scripts for scheduled queue process and pmcmd commands.

TECHNICAL SKILLS:

ETL Tools: IBM Infosphere Datastage and QualityStage Designer 11.7.0.0, Informatica Power Center 9.6/9.5.1/9.1/8.6/8.5/8.1/7.1 (Designer, Workflow Manager, Workflow Monitor, Repository manager and Informatica Server)

Databases: Oracle 12c/11g/10g/9i/8i, MS SQL Server 2008/2005, DB2, Teradata, MySQL

Oracle Tools: TOAD, Oracle Developer, SQL Navigator, SQL*Loader, SQL*PLUS, Oracle 11gQuery Analyzer

Data Modeling tools: Erwin, MS Visio

NoSQL Technology: MongoDB

Operating Systems: Windows XP/NT/2000, MS DOS, UNIX, LINUX, Solaris, Ubuntu

Programming Languages: SQL, PL/SQL, T-SQL, UNIX, Shell scripts, Python, Java, C, C++, HTML, XML, Java script

Scheduling Tools: Autosys(WCC), Control-M

Other Tools: Microsoft Word, Excel, Access, Visio, Outlook, Jira, ServiceNow, WinSCP, File zilla, Putty.

PROFESSIONAL EXPERIENCE:

Confidential, Rockville, MD

Oracle PL/SQL Developer

Responsibilities:

• Involve as a Primary Database Developer during the analysis, planning, design and development stages of projects implementing Oracle 12.2.0.1 (SQL Developer 18.1, IBM Infosphere Data stage).
• Develop Automation scripts for Data Profiling and Validation Develop for the team for the complex Business scenarios.
• Create Data Mapping documents and data transformation rules by collaborating with Application Team, Business Analyst, Conduent (Legacy system) and DOL.
• Ensure complete Analysis of the data is done to set up the codes in Business standards.
• Responsible to communicate with business users and project management to get business requirements and translate to ETL specifications. Design and Develop Data stage Jobs to Extract data from Staging to Target schema in Oracle database.
• Analyze and collaboratively work with Reports team to analyze the requirements and develop the On Demand/ Ad hoc /Periodic Reports.
• Involved in requirements gathering from State and analysis to define functional specifications.
• Developed Role Based Access Control Scripts for different profiles for the Application by analyzing various scenarios.
• Created Views for on demand Reports for different Business Areas for Annual, Weekly basis.
• Analyzed requirements from Business Analyst to create data scripts for new functionalities, according to the specifications from State.
• Created procedures, functions for various Enhancement and Defect CQ’s as part of Release into the Production.
• Debugged the issues and implemented the solution in Production Environment in time critical environment.
• Worked with various teams like Benefits Administration, Cloud, Interface, ODS, Cognos Reports, Deployment, etc. for timely delivery of day to day operations.
• Used %TYPE and %ROWTYPE for anchoring the variables to the database data types.
• Developed various Complex Queries, Views for Generating Reports.
• Created and customized UNIX shell scripts for automating regular maintenance and batch jobs.
• Worked with Dynamic SQL to get the data from external sources depending on the business requirements.
• Worked on queries that take huge amounts of time to run and did performance tuning on it to reduce the cost and time to execute.

Confidential

Database Developer

Responsibilities:

• Involved in requirements gathering and analysis to define functional specifications.
• Developed RDBMS including PL/SQL database backend programming with stored procedures, Functions and packages.
• Continuously monitor the accuracy of the data and the content of the delivered reports.
• Created and Developed data model using modeling Erwin, ERStudio tools.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Converted custom forms using Forms in Installed base for global update of instance.
• Worked with business analysts for formulating the ER diagrams and data flow diagrams.
• Interaction with client / business teams for clarifications / updates.
• Created and used B-tree and Bitmap indexes.
• Created Shell Scripts in Unix for creating SQL reports
• Monitored the daily batches and resolved the long-standing jobs.
• Developed UNIX shell scripts to automate the process of log cleanup.
• Optimized the Oracle PL/SQL queries by Performance Tuning.
• Created Oracle Tables, Views, Constrains, Synonyms, joins while writing complex SQL queries.
• Performance tuning of SQL-queries and database using TKPROF.
• Created Oracle Database Users, Roles and managing Security.
• Scheduled scripts to run using crontab, nohup commands in Unix.
• Analysis and fixing of the defects/bugs in production with high priority.
• Impact Analysis for change requests from client.
• Exchange, altering and modifying partitions.
• Performance tuning of SQL-queries and database.
• Monitoring the database activity, response at regular time intervals.

Confidential

Database Developer

Responsibilities:

• Supported all the UNIX requests for various applications. Sent the timely status reports for the users regarding the failed jobs and done root cause analysis in time constraint environment and took appropriate action.
• Gathered Business Requirements, interacted with the users, project manager and QA team to get a better understanding of the Business Processes.
• Normalized data relations and created relational constraints on objects.
• Involved in Oracle Database Administration.
• Solved user end issues for accessing applications.
• Proficient in archiving and backups. Day to day administration of the Development and Production environment.
• Efficient disk management by clearing old log files and extensive space allocation to various applications upon requirement.
• Monitoring daily loads to collect statistics, security trails and space estimates for new tables.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Responsible for Unit Testing and Integration testing of PL/SQL Packages, Procedures, Functions and Database Triggers.
• Creation of database links for different database connectivity.

Confidential

Junior Programmer

Responsibilities:

• Experience in data analysis & data cleansing.
• Exchange, altering and modifying partitions.
• Improved performance and stability of database systems by adding indexes and disk maintenance.
• Optimized the queries to improve the performance by using explain plan.
• Created Oracle Database Users, Roles and managing Security.
• Scheduled scripts to run using crontab, nohup commands in Unix.
• Analysis and fixing of the defects/bugs in production with high priority.
• Impact Analysis for change requests from client.
• Normalized data relations and created relational constraints on objects.