SUMMARY:

• Over 6 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support and Extensive experience in Project Management methodologies, Oracle Business Intelligence Suite Enterprise Edition (OBIEE) and Microsoft SQL Server database management.
• Experience in developing Custom Reports and Various types of Tabular, Matrix, Ad - hoc, Drill-down, Lists, Charts, Parameterized and Cascading Reports with multiple formatting using SQR (Hyperion Structured Query Reporter), Alteryx Designer Tool and SQL Server Reporting Services (SSRS).
• Experience with Oracle SQL and PL/SQL Programming and used Database utility programs like TOAD, DBEAVER and SQL Navigator.
• Experience in deploying created reports in various sources like Reporting servers (Oracle EV4 and Analytics Gallery Server), Share point sites.
• Strong T-SQL experience in creating database objects like Tables, Stored Procedures, DDL/DML Triggers, Views,
• Indexes, Cursors, Functions and User defined data types.
• Experience in Oracle SQL and PL/SQL including all database object: Stored procedures, Stored functions, Packages, TYPE Objects, Triggers, cursors, REF cursors, Parameterized cursors, Views, Materialized Views, PL/SQL collections.
• Experience in Logical Data Modeling, Physical Data Modeling and creating ER Diagrams.
• Excellent communication skills, technically competent with strong problem-solving skills enabling effective interaction with project sponsors, testers and business users.
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery.
• Experience in tuning the application using Explain Plan and SQL Trace to optimize the cost and for higher efficiency.
• Translated the T-SQL procedure, function and views into Oracle's PL/SQL Packages, Procedure, Function and Views.
• Extensive knowledge and experience in ETL tools like SQL Loader, Informatica and DTS packages to transfer the data between different databases.
• Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks.
• Created interactive dashboards using Alteryx Designer Tool.
• Created reports using different data sources in PowerBI.
• Used Erwin tool for data modeling and MS Visio to create the flow chart and to show the process flow.
• Good knowledge and experience with the complete software development lifecycle; experience with agile methodologies (Scrum, XP).
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• Good understanding of Oracle data dictionary and normalization techniques. Experienced in Amazon redshift database usage, Oracle 12c/11g/10g/9i/8i systems.
• Experience in the preparation of Technical Design documents and involved in unit testing, systems integration testing and documented the same.
• Knowledge in Core Java, HTML, XML.
• Quick Learner, excellent problem solving, conflict resolution skills with a strong technical background and good interpersonal and communication skills.
• Able to work in a dynamically changing environment, as part of a team, with minimal direction.

TECHNICAL SKILLS:

Database: Oracle 12c/11g/10g/9i, Amazon Redshift, MS SQL Server 2016/2014/2012/2008 R 2/2008/2005/2000, PostgreSQL, MS Access.

Languages: SQR, PL/SQL, Transact SQL, C, Visual Basic 6.0, VB.net, C#, Java, UNIX Shell Scripting.

ETL Tools: Informatica (PoweCenter 5.1/6.2/7.1/8.6.1/9.1.0, PowerMart5.1, Power Connect/Power Exchange for SAP R/3, IVR, Triton Supranet App designer, Mainframe and Oracle Change Data Capture ( Confidential), AB Initio 1.8 and SQL*Loader.

Data Modeling: Erwin, Visio

ERP: Oracle Applications 11i/R12.

Oracle Tools: Reports 6i/9i, Forms 6i/9i, XML Publisher, Alteryx Designer

DB Utilities: SQR, SQL plus, Oracle SQL Developer, SQL Loader, Toad, EBuilder, SQL Workbench, SQL Query Analyzer, DBeaver, MS office, JIRA

Operating Systems: LINUX, UNIX(AIX), Windows 10/7/2000/XP.

PROFESSIONAL EXPERIENCE:

Sr.Oracle PL/SQL Developer,

Confidential, Norcross, GA

Responsibilities:

• Worked with business analysts and end-users to develop and enhance Oracle reports and formatted output.
• Analyzing identifying various trends in data or process issues that need to be researched and resolved. Writing technical reports detailing procedures, outcomes, and observations and making recommendations.
• Created stored procedures, functions, packages, collections, triggers, object types to implement complex business functionality.
• Collaborate with data architects for data model management and version control.
• Led the database analysis/design phase of the SDLC (Software Development Life Cycle) to implement the financial information processing system for data conversion, data loading, off line reporting, to determine best solutions to meet the requirements and time frame.
• Developed the project requirements in the IVR Triton App designer in various file formats by using appropriate WAV files.
• Added the projects to the IVR Launch entries using Supranet tools and to the Process Scheduler Administration in order to run the developed projects based on the client request based on the cut-off hours
• Designed the Oracle Partition strategies, Exchange Partitions, Performance tuning and data analysis, Data optimization, scrubbing and manipulation of staged data using PL/SQL, AIX packages.
• Used PL/SQL bulk collection and DML (insert/update/delete) methods, wrote Complex SQL queries, structure hierarchy by using analytical functions, data validation using Regular Expressions
• Managed complex programming assignments involving ETL and optimization of high volume transaction system, indexing, partitioning and sub query etc., and maintain data migration among the different systems.
• Created scripts, reports by using SQL and PL/SQL for the bug fixes and pre and post verification script for the data verification.
• Determining tradeoffs, estimates, and overall approach to work as an individual contributor.
• Collaborating with cross-functional teams in management, development, sales, implementation, operations and marketing.
• Provided on-going support for daily transaction data processing, and creation of GL, and all other fees and settlement reports to banks.
• Work with production support for bug fixes to rectify the problem and fix it on the same day.
• Experience in carrying out following administration tasks in day to day activities -Managing Schemas, Roles/Privileges, Database, managing Users, Groups, Folders, Privileges & Deployment groups.
• Code migration activities in across repositories & Environments.
• During the development process, loading the data from production to lower environments like development, testing and preproduction for all the newly added clients
• Regular code backup & restoration of Repository, using GIT Integration within the Oracle tools like SQL developer.
• 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 Stream. Implemented the test Plans for the integration testing.
• Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Navigator.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Developed the shell scripts to automate the jobs by using UNIX cron jobs.
• Coordinated, resolved, and responded to consumer requests in a 5-day turnaround, measurably improving customer satisfaction

Environment: Oracle 12c,10g/11g, Linux/UNIX, Oracle, Oracle HCM, Amazon RedShift, Putty, PL/SQL, SQL developer, ACH, TR,PR File reporting, Ultraedit, Toad, SQL Workbench, JIRA

Confidential, Alpharetta, GA

Responsibilities:

• Worked with business analysts and end-users to develop and enhance Oracle reports and formatted output.
• Analyzing identifying various trends in data or process issues that need to be researched and resolved. Writing technical reports detailing procedures, outcomes, and observations and making recommendations.
• Created stored procedures, functions, packages, collections, triggers, object types to implement complex business functionality.
• Collaborate with data architects for data model management and version control.
• Developed the customized reports using SQR Scripting using modules of people soft/Oracle HCM, set of stored procedures by gathering the required information from database tools like toad/dbeaver into the csv file format.
• Developed the project requirements in the Enterprise tools like Ebuilder.
• Added the projects to the SQR Launch entries using People soft and to the Process Scheduler Administration in order to run the developed projects based on the monthly payroll, pay frequency of the clients.
• Designed the Oracle Partition strategies, Exchange Partitions, Performance tuning and data analysis, Data optimization, scrubbing and manipulation of staged data using PL/SQL, AIX packages.
• Used PL/SQL bulk collection and DML (insert/update/delete) methods.
• Wrote Complex SQL queries, structure hierarchy by using analytical functions, data validation using Regular Expressions
• Good hands on the reporting tool namely Alteryx designer using Amazon redshift, developing the reports in the Alteryx designer using Bulk PL/SQL queries and publishing across the tableau server/Analytics Gallery server by performing query tuning which is available for the end users.
• Created scripts, reports by using SQL and PL/SQL for the bug fixes and pre and post verification script for the data verification.
• Determining tradeoffs, estimates, and overall approach to work as an individual contributor.
• Collaborating with cross-functional teams in management, development, sales, implementation, operations and marketing.
• Writing various Database Triggers .
• Involved in Unit Testing, system testing and integrated testing.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Experience in carrying out following administration tasks in day to day activities -Managing Schemas, Roles/Privileges, Database, managing Users, Groups, Folders, Privileges & Deployment groups.
• Code migration activities in across repositories & Environments.
• During the development process, loading the data from production to lower environments like development, testing and preproduction for all the newly added clients
• Regular code backup & restoration of Repository.
• Monitoring and Managing the Database using AWR and SQL Reports.
• 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.
• Implemented the test Plans for the integration testing.
• Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Navigator.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Developed the shell scripts to automate the jobs by using UNIX.
• Served as a technical expert, development resource.

Environment: Oracle 12c,10g/11g, Linux/UNIX,Oracle Enterprise Ev4 development, Structured Query Reporter(SQR), Oracle HCM,People soft,Amazon RedShift, Alteryx Designer,Analytics Gallery server,PL/SQL, SQL developer, Ultraedit, Toad,Ebuilder, SQL Workbench, SOA, ERP Integration with PeopleSoft, HP ALM, SVN, Bitbucket.

Confidential, Columbus, GA.

Responsibilities:

• Created stored procedures, functions, packages, collections, triggers, object types to implement complex business functionality.
• Designed the Oracle Partition strategies, Exchange Partitions, Performance tuning and data analysis, Data optimization, scrubbing and manipulation of staged data using PL/SQL, AIX packages.
• Used PL/SQL bulk collection and DML (insert/update/delete) methods.
• Expertise in writing Complex SQL queries, structure hierarchy by using analytical functions, data validation using Regular Expressions
• Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Navigator.
• Created scripts, reports by using SQL and PL/SQL for the bug fixes and pre and post verification script for the data verification.
• Good knowledge and experience with the complete software development lifecycle; experience with agile methodologies (Scrum, XP).
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Developed the shell scripts to automate the jobs by using UNIX.
• Experience in Database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete System Development Life Cycle.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Involved in creation of various indexes on relational tables, which are BTREE, BITMAP, FUNCTION BASED. Responsible for SQL tuning using Explain Plan, tkprof utility, optimizer hints.
• Used standard packages like UTL FILE, DMBS SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages for Front End Module.
• 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.
• Assisted with testing existing code and making necessary enhancements for Oracle 11G upgrade. Created database objects such as tables, indexes, views, materialized views, triggers, sequences, synonyms.
• Implemented the test Plans for the integration testing.
• Worked with multiple vendors to facilitate integration of systems during merger. Effectively documented and archived historical data for future auditing purposes. Responsible for production support and troubleshooting production issues. Experience working with huge database size of 5 TB.

Environment: Oracle 10g/11g/12c, UNIX, TSQL, SSIS, SSRS, PL/SQL, SQLPlus, SQL Loader, SQL developer, Bit Bucket, Toad, Erwin, Ebuilder, SQR.

Confidential, Framingham, MA

Responsibilities:

• Use Agile methodology for application development.
• Support in requirements gathering from the end users.
• Update design documents according to the changes made to the application.
• Designed/developed/Modified tables, views, stored procedures, packages and functions.
• Coded PL-SQL packages and procedures to perform data loading, error handling and logging.
• Tuned database SQL statements and procedures by monitoring run times and system statistics
• Involved in developing UNIX shell scripts for Loading Database Tables, running SQL files, Packages and Procedures.
• Created partitioned tables and partitioned indexes to improve the performance of the applications.
• Wrote PL/SQL Database triggers to implement the business rules in the application.
• Implemented all modules logic by using Triggers and Integrity Constraints.
• Good understanding of database objects and ability to triage issues.
• Involved in PL/SQL code review and modification for the development of new requirements.
• Code SQL Stored Procedures and integrated with application
• Involve in Unit Testing for the application developed using test cases

Environment: PL/SQL, Oracle 10g, 11g, Java, Unix shell scripting, Oracle Forms, Erwin, Oracle Reports, AIX, SQL Developer, BI Publisher, Informatica Power Center, Eclipse.

Confidential, Fuquay, NC

Responsibilities:

• Developed user defined functions based on requirements. Developed back end interfaces using PL/SQL Stored Packages, Procedures, Functions, Collections and Triggers. Created PL/SQL procedures and packages.
• Extensive query optimization and performance tuning. Created the integrity constraints and Database Triggers for the data validations. Used PL/SQL Tables and Records in payment generation process. Written Test Plans and Involved in unit testing.
• Created relevant staging tables to load the CSV files, identified the business validation rules. Created SQL Loader script generator application using UNIX shell scripting and PL/SQL.
• Experience in creating the tables and sequences for the experimental data load capture. Loaded the data into the tables using TOAD and SQL*Plus. Created metadata validation lookup tables and pre-populated them using SQL Loader generator application.
• Designed competent PL/SQL programs using PL/SQL collections, Records types, and Object types.
• Developed and automated the interfaces by using the PL/SQL. Developed user defined stages and common templates.
• Tuned several Oracle SQL statements using Explain plan, Auto Trace utilities.
• Involved in implementing table partitions using Range, Hash, Composite techniques.
• Worked on external hints during the SQL optimization to fast up the SQL process.
• Experience in working a variety of analytical functions, RANK, DENSE RANK, LAG, LEAD, and PARTITION OVER.
• Automated Quality Check tasks by creating PL/SQL procedures, cursors, functions and dynamic SQL. Enhanced it with creating exceptions for error handling. Created triggers for auditing purpose and created group, tabular and form reports.
• Database security by authenticating users, using logon triggers. Created materialized view on remote database and automated scheduler of refreshing of materialized view.

Environment: Oracle 10g/11g, PL/SQL, SQLPlus, Informatica ETL, SQL Loader, SQL developer, Toad.