SUMMARY

• Over 8+ years of experience in analysis, design, development and deploying business solutions using Oracle Technologies
• 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.
• Extensively involved in building applications and defining Schema Objects, Users, Roles, Views, Materialized Views and Indexes as per the application requirement
• 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 new features in oracle 11g.
• Effectively made use of PL/SQL features such as Bulk Collections/Exceptions/Inserts, Bulk Binding, Ref - Cursors SQL Types in Bulk Operations for better performance and readability.
• Experience in application development using various advanced features of Oracle like Collections, Table Functions, and Autonomous Transactions, Dynamic SQL, Object types and Records.
• 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.
• 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.
• Performed end user training in effectively utilizing the applications built.

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

PROFESSIONAL EXPERIENCE

Confidential, Fortworth, TX

Sr. Oracle Developer

Responsibilities:

• Effectively involved in meeting with the business analysts and architects in building an efficient database system.
• Good working knowledge in Agile Scrum environments with Bi-weekly Sprints.
• Extensively worked in On-site and Off-Shore model.
• Created the integrity constraints and Database Triggers for enforcing business rules and for data validations.
• 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.
• Projects include planning & designing the migration documents per business rules, executing test scripts for the go-live scenarios.
• 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.
• Extensively used SqlLoader and external tables to process the data from different systems to Data warehouse tables.
• Developed user interface for internal and external applications and ensured usability during technical implementation.
• Extensively Created Staging tables to load the data from legacy and wrote packages to load them from staging tables to respective core tables.
• Wrote complex procedures to handle the errors.
• 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.
• Ensured that issues are solved as per priority and with accurate testing and after executing maximum test scenarios.
• 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.
• Worked with other developers to establish and implement best practices for database design, code development and performance tuning.

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

Confidential, Omaha, NE

Sr. Oracle 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.
• Responsible for building and maintaining strong working relationships with sales and accounting professionals.
• 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.
• Involved in User Acceptance Test with business users.

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

Confidential, Denver, CO

Oracle 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.
• A number of optimization techniques are used to determine the most efficient access plan for SQL quires.
• 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, Birmingham, AL

Oracle 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.