SUMMARY:

• 6+ years of profound working experience in SQL, PL/SQL programming, System Analysis, Design, Development, and Support of Oracle Database 12c/11g/10g/9i in Production, Staging, Development, and Testing Environments.
• Experience in data analysis, data modeling, development, testing and documentation of projects.
• Extensively experienced in designing and developing Packages, Stored Procedures, Functions and Triggers using PL/SQL.
• Experience in using several built - in database packages such as DBMS JOB, DBMS OUTPUT, UTL FILE, and DBMS SQL to name a few.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views.
• Efficient in writing Complex SQL Queries, Hierarchical queries, use of analytical functions, Regular Expressions and features in oracle 11g.
• Experience in configuration, development, and testing of AutoSys and other scripts.
• Experience inimporting/exportingdata between different sources like Oracle/Access/Excel etc. using SSIS/DTS utility.
• Extensively experienced in data migration techniques using Oracle External Tables, SQL* Loader, Import/Export, bulk and batch processing.
• Experience with DBA activities like creating users, granting and revoking privileges on database objects and taking backups.
• Used Performance tuning techniques for better performance and execution through suitable Indexes, primary-foreign key constraints.
• Hands on experience in ETL process using different ETL tools and using PLSQL to populate the tables in OLTP and OLAP Data warehousing environment.
• Query optimization, PL/SQL Performance Tuning using Oracle Cost based Optimization techniques, Explain Plan, Trace, Hints & Tkprof.
• Extensive experience in Data Migration, ETL & Content Management, implemented various Extraction, Transformation and Loading architectures involving tools and technologies such as ETL Tools, SQL Loader, PL/SQL, Materialized views.
• Automated Data Loads, Back-up, Recovery, Deployments using Unix Shell Scripts.

TECHNICAL SKILLS:

Operating System: Windows 7/10, Linux, UNIX (Sun Solaris, HP-UX).

DBMS/Databases: Oracle 12c/11g/10g/9i, MS: SQL Server.

Web Technologies: HTML, DHTML, Java Script, XML.

Languages: C, C++, SQL, PL/ SQL.

Scripting Languages: UNIX Shell Scripting

Database Tools: SQL*PLUS, TOAD, SQL*Tool, PL/SQL Developer

Office Packages: MS: Office (Access, Word, Excel, PowerPoint)

Version Control: CVS, SVN, GITHUB

Agile Tools/Methodologies: Jira, RTC, SCRUM

WORK EXPERIENCE:

Confidential, Fortworth, TX

Oracle PL SQL Developer

Responsibilities:

• Worked to Analyze, Design, Development, and testing of the application.
• Good working knowledge in Agile Scrum environments with Bi-weekly Sprints.
• Created the integrity constraints and Database Triggers for enforcing business rules and for data validations.
• DevelopedPL/SQL triggersandmaster tablesfor automatic creation of primary keys.
• Developed highly Complex Stored Procedures, Packages, Functions, Cursors and Materialized Views in PL/SQL Developer, Toad in Oracle 10genvironment.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application
• Involved in the Migration of Databases from SQL Server 2005 to SQL Server 2008.
• Created Dimension and Fact tables using Snowflake and Star schema.
• Worked with Oracle packages like UTL FILE to open, read and write files to OS directories.
• Developed Unix Shell Scripts to process the files on daily basis like renaming the file, extracting data from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
• Optimized the performance of complex SQL queries in Oracle reports as well as queries from the queries.
• Created indexes to large tables for tuning and wrote SQL scripts utilizing indexes to improve performance.
• Created triggers, views on tables and associating appropriate trigger timing and trigger events.
• Coded and debugged the stored Procedures, Packages and Views in Oracle Databases using SQL and PL/SQL, which were called by user-oriented application modules.
• Used Partitioning and Bulking techniques to improve performance while accessing large tables.
• Improved the speed and performance of the code using Ref Cursors, Records and Collections.

Environment: Oracle 11g/12c, SQL, PL/SQL developer, PL/SQL, SQL*PLUS, Ksh, JIRA, ControlM.

Confidential, Omaha, NE

Oracle PL/SQL Developer.

Responsibilities:

• Created Blueprint for the project in MS-Visio.
• Created System Design Document SDD.
• Created automated Jobs in Linux environment using Linux.
• Worked on reconciliation report in Oracle Reports 10g and create a report from scratch.
• Implemented validating package for the inbound data from the response file.
• Created external tables for data interfaces.
• Wrote reconciliation scripts in SQL to analyze the day to day transactions that are happening in the business.
• Involved in the continuous enhancements and fixing of production problems.
• Used PLSQL developer for debugging the packages and stored procedures.
• Created system level functions to standardize many of the business calculations.
• Extensively used Records and Collections.
• Trouble shooting performance issues using Explain Plan and TKPROF.
• Optimized and tuned PL/SQL subprograms to reduce the loading process.
• Wrote shell scripts for loading data from Flat Files to database tables using SQL*Loader.
• Wrote shell scripts to transfer files using FTP to the UNIX servers at one time for daily data processing.
• I have Created the mappings, sessions and Workflows as per requirement of business to implement the logic. Perform the Unit Testing on developed code.
• Extensively used AUTOSYS and DBMS-Scheduler for scheduling the nightly batch jobs

Environment: Linux, MSSQLServer2005/2008, Windows Xp, PLSQL developer, Oracle 10g, AUTOSYS.

Confidential, Birmingham, AL

Oracle PL/SQL Developer

Responsibilities:

• Extensively involved in definition, design and implementation of complex actuarial calculations.
• Involved in analyzing requirements and designing database using normalization techniques.
• Extensively used PL/SQL features such as database triggers for maintaining complex integrity constraints and implementing the complex business rules.
• Used SQL*Loader to load the data into interface tables.
• Developed functions and extensively used ref-cursors in creating packages.
• Developed complex procedures to handle errors and exceptions at database level using PL/SQL.
• Developed Forms based on PL/SQL Stored Procedures to implement complex business functionality.
• Involved in the continuous enhancements and fixing of production problems.
• Designed and developed GUI front-end applications using Oracle Forms for user interaction with the database.
• Used stored procedures and wrote Shell Scripting to automate various processes.
• Used UTL FILE package to write an outbound interface program.
• Review data transformation rules and provide technical suggestions in data transformation logic and pseudo code (PL/SQL).
• Used stored procedures and wrote Shell Scripting to automate various processes.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data
• Performance tuning of SQL statements using SQL server profiler
• Implemented joins and queries (T-SQL) for the business analyst to make reports
• Extensively used T-SQL to create triggers and stored procedures used by the enhancements modules to update the SQL Server database
• Conducted data import and export operations using the DTS wizard
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity
• Reviewed Reporting Requirements and Created Aggregated Tables and Stored Procedures for the Dashboard for Health Management systems

Environment: MS SQL Server 2008/2005, PL/SQL, Oracle10g, Forms and Reports 9i, Erwin 4.x, UNIX Shell Scripting, Toad 8.6, Win OS

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Writing complex stored procedures/triggers and functions using PL/SQL and optimized for maximum performance.
• Involved in the database design and re-structuring of the database.
• Used SQL and PL/SQL stored procedures, functions to implement business logics in Oracle.
• Developed complex procedures to handle errors and exceptions at database level using PL/SQL.
• Optimized the performance using PL/SQL by restructuring the extraction and summarization routines.
• Developed designed and modified operational and financial reports and programs.
• Worked with appropriate decision makers gathering information and specifications for analyzing and reporting on operations.
• Worked with installing, designing and managing MS SQL Server 2008.
• Creating and managing schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity.
• Worked on Stored Procedures and Database Triggers. Worked on large number of business analytical function
• Automating data loading, extraction, report generation using UNIX shell scripting.
• Coordinated with the Quality Assurance/Testing team members to perform system, integration and unit testing.
• Worked with Business Analyst and users to clarify requirements and translate the requirement into technical specifications.
• Created dimensions/fact tables in data models using Erwin. Forward engineer objects and Complete compare data models to keep objects in synch with the database.
• Coordinated with the DBA for migrations of new/updated objects.
• Use Repository Manager to import metadata for sources and targets and the mapping designer to map source to the target.
• Documented the whole process flow, PL/SQL Packages, log files, locations and description, log tables and possible error messages, process codes and description.

Environment: Oracle 9i, SQL Navigator, SQL Server 2008/2005, Windows 2000/XP.