PROFESSIONAL SUMMARY:

• Having 11 years of programming experience in IT. Over 8 years of experience as an Oracle PL/SQL Developer and 3 years of experience as T - SQL Developer in Analysis, Design and Implementation of Business Applications using the Relational Database Management System (RDBMS).
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Expertise in Client-Server application development using Oracle 11g/10g/9i PL/SQL, SQL*PLUS, TOAD and Oracle SQL Developer.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views.
• Created Tables,Views, Constraints,DB Links and Index (B Tree, Bitmap and Function Based).
• Partitioning large Tables using range,list partition technique.
• Data Integration and Migration specialist with over 3 years of extensive experience in leading the conversion of multiple legacy data systems from different sources into Oracle databases.
• Worked extensively on Cursors,Ref Cursor and Collections.
• Expertise in Dynamic SQL and Exception handling.
• Experience in SQL and PL/SQL tuning and Query Optimization tools like Oracle Enterprise Manager Cloud Control 13c and AWR reports to quickly locate the bottlenecks in the code with the help of detailed execution plans, and session statistics for each run of a query.
• Worked as technical lead of an offshore team for the design and development of new enterprise web based applications as well as new versions of existing ones written in Java and Oracle PL/SQL.
• Have extensively worked in developing ETL programs for supporting Data Extraction, Transformations and Loading using Informatica Power Center.
• Strong knowledge in Oracle utilities like SQL*Loader, Export/Import and data pump utilities like EXPDP/IMPDP .
• Experience with Oracle Supplied Packages such as DBMS SQL, DBMS JOB and UTL FILE
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

TECHNICAL SKILLS:

Databases: Oracle 9i, 10g, 11g, MySql, MS SQL SERVER 2005/2008

Operating Systems: RHEL 5.x, 6.x and Windows 7/2008/2012.

Programming Languages: SQL,TSQL,PL/SQL and Java

Tools: & Utilities: Oracle SQL Developer, Toad, SQL*Plus, Export/Import,RMAN,Data Pump, Informatica(ETL), SAP Business Objects,Rally,Service Now,Confluence,ACME, GIT, Source Tree, Bitbucket

Tuning Tools: Oracle Enterprise Manager( OEM) Cloud Control 13c, Explain Plan, Statspack

PROFESSIONAL EXPERIENCE:

Confidential - Malvern, PA

PL/SQL Developer

Responsibilities:

• Gathering functional and technical requirements and reviewing them with Business Analysts.
• Developing new functionality and maintaining enhancements as part of the SEI Wealth Platform (SWP) releases using PL/SQL Oracle 11g. Development and code deployment follow SEI’s Agile Development Process.
• Creating Tables, Constraints, Packages, Stored Procedures, Functions, Views and Triggers using PL/SQL for backend implementation using oracle tools like Toad, Oracle SQL Developer and SQL* Plus.
• Analyze, evaluate and discuss business requirements for new and existing applications. Estimate work efforts, impediments and complete code impact analysis.
• Analyzing and resolving issues found during the testing or pre-production phases of the software delivery lifecycle
• Working with SQL and PL/SQL tuning using Query Optimization tools like Oracle Enterprise Manager Cloud Control 13c and AWR reports to quickly locate the bottlenecks in the code with the help of detailed execution plans, and session statistics for each run of a query.
• Responsible for preparing the technical documentation and reviewing the technical design with platform architects to make sure the design meets the platform standards.
• Develop batch framework stored procedures in PL/SQL for generating the data extracts as per the business specifications for sending required data to external tax vendors.
• Develop/enhance the PL/SQL stored procedures for batch jobs to extract the information using complex business logic, and send it to the tax vendors according to the format specifications provided by the business teams.
• Developing/ enhance batch jobs to process the files received from tax vendors via FTP or NDM.
• Use Exception Handling extensively to debug and display the error messages in the application.
• Create and modify complex database triggers to maintain the audit history.
• Use GIT, Source Tree, Bitbucket for file versioning and change requests and commit all the code changes regularly after squashing all the commits.
• Develop and implement batch processing framework for bulk processing projects integrated with Control-M for scheduling jobs.
• Participate in database design and architecture to support application development.
• Extensively used Bulk Collection in PL/SQL objects to improving the performence.
• Identifying and resolving open issues during various testing phases of software development.
• Providing production support and maintenance for multiple SWP releases as needed.
• Analyze and fix pre and post go-live technical issues and other cross functional issues in SWP platform.
• Actively participate in daily scrum meetings and update daily status and progress of development and testing and discuss day-to-day issues
• Worked on Informatica to load data from flat files obtained from various tax vendors.
• Designing and developing SAP Business Object reports using SQL queries and stored procedures.

Environment : Windows,Oracle 11g, SQL*Plus, TOAD, Oracle SQL Developer, Java, SAP Business Object Reports(BOXI), Informatica Power center, Rally, Confluence, Service Now, GIT, Source Tree and Bitbucket.

Confidential

PL/SQL Developer

Responsibilities:

• Developing code based on reading and understanding business and functional requirements following the Agile process.
• Developed Advanced PL/SQL Packages, Procedures, Triggers, Functions, Indexes and Collections to implement business logic using TOAD. Generated server side PL/SQL scripts for data manipulation and validate the materialized views for remote instances.
• Involved in requirement gathering sessions with business analysts, Subject Matter Expert (SME) and Product Manager (PM) to gather functional and technical requirements to build the application.
• Producing high-quality code to meet all project deadlines and ensuring the functionality matches the requirements.
• Providing technical support to project team members and responding to inquiries regarding errors or questions about programs.
• Participate in database design and architecture to support application development.
• Involved in table redesigning with implementation of Partitioning table to make Database faster and easier to maintain.
• Installed and Configured Oracle Enterprise Manager Grid Control 11g.
• Expertise in data Integration and Migration between the homogeneous and hetrogeneous databases.
• Migration of existing data attributes from SQL Server, Oracle into Oracle.
• Used principles of normalization to improve the performance. Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target data structures.
• Involved in the continuous enhancements and fixing of production problems. Designed,implemented and tuned interfaces and batch jobs using PL/SQL.
• Involved in data replication and high availability design scenarios with Oracle Streams.

Environment : Windows, VB 6, Oracle 11g, SQL,PL/SQL,SQL Plus,TOAD, Oracle SQL Developer, Java, Informatica Power center, Rally, Confluence, Service Now, Source Tree and Bitbucket.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Created Tables, Constraints,Packages, Stored Procedures, Functions, Views and Triggers using PL/SQL for backend implementation using oracle tools like Toad, Oracle SQL Developer and SQL* Plus.
• Analyzing and resolving issues found during the testing or pre-production phases of the software delivery lifecycle.
• Worked in production support environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
• Determine the amount of coverage and sent payments to medical facilities or reimbursements to customers.
• Wrote conversion scripts using SQL, PL/SQL Stored Procedures, Functions and Packages to migrate data from SQL server database to Oracle database.
• Performed Database Administration of all database objects including Tables, Indexes, Views, Sequences, Packages and Procedures.
• Upgraded the existing database from Oracle 9i to Oracle 11g.
• Involved in Logical & Physical Database Layout Design.
• Set-up and Design of Backup and Recovery Strategy for various databases.
• Performance tuning of oracle databases and user applications.
• Used SQL*Loader as an ETL tool to load data into the staging tables.
• Provided user training and production support.
• Improved the performance of the application by rewriting the SQL queries.
• Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.

Environment : Java, Oracle 9i SQL, PL/SQL,SQL*Loader, TOAD,Enterprise Manager, Source Tree.

Confidential

Transact-SQL Developer

Responsibilities:

• Prepare software design document containing the data flow, relationship between data objects and map the new attributes to existing structures.
• Prepare design specifications and functional documentations for assigned database tasks and maintain in Confluence tool.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Wrote stored procedures to get the fields required for the reports.
• Created datasets using stored procedures and reports using multi value parameters
• Worked with installing,designing and managing MS SQL Server 2008.
• Installation of SQL client and establishing connectivity to databases
• Managing database security. Creating and assigning appropriate roles and privileges to users depending on the user activity.
• Involved in modifying various existing packages, procedures, functions and triggers according to the Client Requirements.
• Used stored procedures, wrote new stored procedures, modified existing ones, and tuned them such that they perform well.
• Used advanced features of T-SQL in order to design and tune T-SQL to interface with the database and other applications in the most efficient manner and created stored Procedures for the business logic using T-SQL.
• Used indexes to enhance the performance of individual queries and enhance the Stored Procedures.
• Managed all indexing, debugging, optimization and performance tuning using SQL Profile and SQL Server Agent.
• Designed, developed, and tested stored procedures, views and complex queries for Reports distribution.
• Developed database triggers and stored procedures using T-SQL cursors and tables.
• Effectively used views to prevent unauthorized access.
• Tuned SQL queries using execution plans for better performance.

Environment: Windows 2003 Server,.Net, SQL Server 2005/2008,SSMS,SQL,T-SQL,SQL Profile, DBCC, SQL Queries, Stored Procedures, Office, Excel, SSRS.

Confidential

PL/SQL Developer

Responsibilities:

• Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
• Wrote identity for automatic generation of unique keys to support primary and foreign key constraints in data conversions.
• Used DDL and DML for writing triggers, stored procedures to check the data entry and payment verification.
• Worked with installing, designing and managing Oracle 10g/11g.
• Developed and modified triggers, packages, functions and stored procedures for data conversions.
• Running DBCC consistency checks and fixing data corruption in application databases.
• Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Created Triggers, Views for Audit and security purposes.
• Created different types of User-defined functions.

Environment: Windows 2003 Server, Dot Net.,Oracle 11g, TOAD, Enterprise Manager, Source Tree.