SUMMARY:

To attain a challenging position in an organization as a lead Oracle Developer by applying Oracle expertise to the design, development, and deployment of database applications that meet business objectives.

TECHNICAL SKILLS:

Database: Oracle

Data Architecture: Data Modelling

Data Modeling Tools:: ERwin

Methodologies/Frameworks:: Agile, Iterative, Waterfall

RDBMS:: Oracle 11g,10g, 9i, SQL Server 2005,2008

Programming languages:: PL/SQL, SQL, T - SQL, UNIX Shell Scripting, Autosys JIL

Tools: Quest Software TOAD, SQL*Plus, PL/SQL Developer, Oracle APEX, Version Control with Subversion (SVN Tortoise), GitHub, CA Autosys

EMPLOYMENT HISTORY:

Confidential, Columbus, OH

Sr. Associate

Responsibilities:

• Involved in all technical reviews with client technical architects.
• Build design document from user stories.
• Deploy Autosys JIL scripts
• Fix bug in HP Quality Center for different environments.
• Developing highly complex applications using Oracle 10g database as back-end with expertise in design and development of Oracle PL/SQL Packages and Procedures. Superior skills in designing and developing Oracle objects such as Tables, Views, Indexes, Stored Procedures and Functions in PL/SQL, Packages in PL/SQL, Materialized Views, and Dynamic SQL.
• Created Stored Program Units like Functions, Triggers and procedures for implementing complex database intensive business rules.
• Worked as a SQL developer to support business applications using Oracle SQL and PL/SQL.
• Created Tables, Indexes, views, Sequences, Synonyms and stored program units.
• Built and maintained SQL scripts, indexes, reports and queries for data analysis and extraction.
• Involved in creating Database Design (Physical and logical) as per the requirement given by business through ErWin Tool
• Generated SQL and PL/SQL scripts to install create and drop database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Developed code in Oracle APEX 4.2 for BIS application which includes several reports and forms

Confidential, Columbus, OH

Sr. Associate

Responsibilities:

• Lead database development team which includes coordination with offshore team and get the deliverables in time and with quality.
• Requirements analysis and working closely with the Business Analysts & business users.
• Involved in all technical reviews with client technical architects.
• Working in Agile methodology to give deliverables to client in minimum amount of time.
• Hands on knowledge with GitHub and Git commands
• Build design document from user stories.
• Attend daily scrum call and represent database team to give all updates about Sprint release.
• Developing highly complex applications using Oracle 10g database as back-end with expertise in design and development of Oracle PL/SQL Packages and Procedures. Superior skills in designing and developing Oracle objects such as Tables, Views, Indexes, Stored Procedures and Functions in PL/SQL, Packages in PL/SQL, Materialized Views, and Dynamic SQL.
• Created Stored Program Units like Functions, Triggers and procedures for implementing complex database intensive business rules.
• Used features like bulk collect to process large amount of data in data base.
• Generated SQL and PL/SQL scripts to install create and drop database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Understanding of the Functional specifications based on that prepared design documents using concepts like Partitioning, Partition pruning, Index by Tables, Bulk Collect, Pipelined Functions, Insert All, Global Temporary tables.
• Tuning of Queries, Packages using Oracle utilities Explain Plan.
• Developing procedures using native dynamic SQL (Execute Immediate), dynamic SQL, Ref cursors.
• Wrote complex SQL queries using joins, sub queries and inline views to retrieve data from the database. Created Partitions on the tables to improve the performance.
• Analyzing business requirements, preparation of source-target mapping documents, conduct unit testing and code walkthroughs to ensure there are no missing elements, and perform integration testing.
• Constructing complex SQL queries with sub-queries, inline views as per the functional needs.

Confidential, Hagerstown, MD

Associate

Responsibilities:

• Requirements analysis and working closely with the Business Analysts & business users.
• Involved in all technical reviews with client technical architects..
• Build design document from user stories.
• Fix bug in Bugzilla and HP Quality Center for different environments.
• Got several client appreciation for tuning & handling production issues quickly and efficiently.
• Developing highly complex applications using Oracle 10g database as back-end with expertise in design and development of Oracle PL/SQL Packages and Procedures. Superior skills in designing and developing Oracle objects such as Tables, Views, Indexes, Stored Procedures and Functions in PL/SQL, Packages in PL/SQL, Materialized Views, and Dynamic SQL.
• Created Stored Program Units like Functions, Triggers and procedures for implementing complex database intensive business rules.
• Used features like bulk collect to process large amount of data in data base.
• Improving SQL and PL/SQL flexibility, usability, and performance, using dynamic SQL.
• Worked as a SQL developer to support business applications using Oracle SQL and PL/SQL.
• Created Tables, Indexes, views, Sequences, Synonyms and stored program units.
• Generated SQL and PL/SQL scripts to install create and drop database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Analyzing business requirements, preparation of source-target mapping documents, conduct unit testing and code walkthroughs to ensure there are no missing elements, and perform integration testing.

Confidential, Hagerstown, MD

Associate

Responsibilities:

• SPOC for all offshore database development activities right from the estimation to release.
• Development and maintenance of legacy application.
• System analyses, Designed Data Base, Coded, tested and tuned procedures in Oracle environment.
• Development activities includes but not limited to writing Packages, Procedures, Functions, Triggers, Cursors, Indexes, Tuning etc.
• Developed code in Oracle APEX 4.2
• Participated in release management and supported to configure, deploy code in various environment
• Got award for outstanding contribution to the project.
• Created Database Objects like Tables and Views as per Client Requirements.
• Actively Participated in different phases of SDLC.
• Created Stored Procedures, Functions, and Triggers to maintain various business rules.
• Extensively worked towards optimizing the Queries to enhance the performance.
• Analyzed Indexes on regular basis.
• Involved in the optimization of Oracle queries.
• Managing Tables, Indexes, Constraints, Views, Sequences, and stored program units.
• Involved in database tuning using Oracle Hints, Optimizers and Indexes for better query performance.
• Implemented Triggers based on the business rules.
• Created SQL Loader Control Files for moving data from Flat Files (Fixed Record Length) to Staging Area Tables.
• Analyzed the existing Stored Procedures, Functions, Triggers and Cursors on performance issues.
• Used various forms of control structures including CASE, DECODE, IF-THEN-ELSE, FOR loops, WHILE loops while developing procedures.
• Worked with Dynamic Queries (SQL).
• Made use of DB LINKS for accessing data across different databases.
• Loading data into the Database using SQL* LOADER.
• Used the Oracle Import/Export utilities for taking the backup of a particular partition data.
• Performed debugging of the PL/SQL codes using the DBMS OUTPUT.

Confidential

Technical Associate

Responsibilities:

• System analyses, Designed Data Base, Coded, tested and tuned procedures in Oracle environment.
• Participated in the whole software life cycle: Analysis, Technical document preparation, coding & unit testing in Oracle environments.
• Development activities includes but not limited to writing Packages, Procedures, Functions, Triggers, Cursors, Indexes, Tuning etc.
• Debug, monitor, and troubleshoot bugs.
• Got award for outstanding contribution to the project. .
• Used features like bulk collect to process large amount of data in data base.
• Improving SQL and PL/SQL flexibility, usability, and performance, using dynamic SQL.
• Worked as a SQL developer to support business applications using Oracle SQL and PL/SQL.
• Created Tables, Indexes, views, Sequences, Synonyms and stored program units.
• Developed Unix Shell Scripts to automate backend jobs, loading data into the database using SQL* Loader.
• Built and maintained SQL scripts, indexes, reports and queries for data analysis and extraction.
• Understanding of the Functional specifications based on that prepared design documents using concepts like Partitioning, Partition pruning, Index by Tables, Bulk Collect, Pipelined Functions, Insert All, Global Temporary tables.
• Wrote complex SQL queries using joins, sub queries and inline views to retrieve data from the database. Created Partitions on the tables to improve the performance. Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data.