SUMMARY:

• 6+ years of experience in Design, Development, and Maintenance using Oracle, PL/SQL and Oracle Developer Forms and Reporting.
• Excellent conceptual and working knowledge of Oracle (SQL, PL/SQL)
• Proficient in writing Packages, Stored Procedures, Functions, Views and Database Triggers using SQL and PL/SQL in Oracle.
• Experienced in schema structure design, estimation and optimization of data storage.
• Experienced in performance tuning and optimization of SQL statements.
• Extensive experience in analysis and design of database including ER Diagrams and Normalization techniques.
• Involved in design, review, implementation, testing and release of databases, sign specifications and application software.
• Working Knowledge on Extraction, Transformation and Loading process (ETL).
• Knowledge in design and setup of Backup and Recovery Strategy for various databases.
• Knowledge in Test Scripts, Test Cases, and SQL QA scripts to perform Unit testing, System Testing and Confidential testing.
• Extensive working experience in code migration from development to testing, UAT and production.
• Experienced in analysis, specification, software and database administration, development, maintenance, testing and documentation.
• Excellent analytical and communication skills those are required effectively to work in the field of applications development and maintenance.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, HTML, JavaScript, XML, T - SQL, JSON, ECL, JAVA

Databases: Oracle 12c/11g /10g, MS SQL Server 2012/2010/2008, SSIS, SSRS 2010, HPE Vertica Analytics Platform 7.2, MS Access 2013, MySQL

Database Tools: TOAD, PL/SQL Developer, SQL*Plus, SQL developer, SQL Navigator, DB Visualizer

ETL Tools: SQL*Loader, UTL FILE, Informatica Power Center 9.1/9.5, SSIS (SQL Server Integration Services), DTS

GUI: Visual Studio.NET, Visual Basic 6.0, Forms 9i/10g/11g, Reports 9i/10g/11g, Crystal Reports

Designing/Other Tool: Subversion, GIT, Atlassian JIRA 4.1, Control-M/EM 8, MS-Office

Operating Systems: Windows 10/7/XP, UNIX (Linux)

PROFFESSIONAL EXPERIENCE

Confidential, GA

Sr. Oracle Database Developer

Responsibilities:

• Worked in Agile environment on 3 week sprints.
• Developed and maintaining complex PL/SQL packages for external billing to maintain no gaps and delays in sending customers bills and transaction logs.
• Provided on call production support during production rollout Debug PL/SQL Packages, functions, procedures and triggers according to business problems.
• Worked closely with QA team for Confidential testing every change cycle and importing/coping files from database server to QA server using UNIX scripts.
• Monitoring incoming daily/weekly upstream files on Oracle Loaders.
• Shared sessions with new beginners and peers in an Onshore and Offshore environment.
• Resolved the issue between MUC report and invoice charges due to charge code issue for all impacted customers.
• Provide the detail tax and surcharges to the customer writing complex SQL queries in short notice top maintain business continuity.
• Work on QA code installation, execute the DDLS and DMLS in QA database and deploy the code through Jenkins in QA environment
• Analyze production issues to determine root cause and document any changes made to resolve the issue for audit team.
• Extensively used GTT for uploading files on upstream system and for data validation. Debugged any GTT related issues in PROD environment.
• Verified DW feeds generated on time and sent to EDW daily. In case of errors transmitting any of the files worked on manual CFI.
• Co-ordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Developed Reports to extract the monthly claims/billing information.
• Developed complex procedures and packages to calculate regular/ irregular payments, etc.
• Involved in data modeling team for identifying tables and relations between them.
• Resolved issue occurred due to promo charges difference and Issues related to Macro reports tracked from the invoice package and solved.
• Working on sending daily DML Audit and Bulk Audit Reports to Confidential .
• Worked in 3 week sprint agile environment.
• Working on production issues along side of development.
• Created Ad-hoc ETL processes using GTT.
• Responsible for writing Unit test scripts used by UAT.
• Involved in performance tuning along with the DBA involved.
• Involved in DW designing and modification.

Environment: Oracle 12C, TOAD 13.1, SQL PLUS, PL/ SQL, SQL*Loader, Shell Scripts, SQL Navigator.

Confidential, FL

Sr. Oracle PL/SQL Developer

Responsibilities:

• Developed and maintained complex packages for NGEN Project that provides relations to prioritize individual consumer and retail marketplace.
• Working with an Agile, Scrum methodology to ensure high quality with every sprint release.
• Develop ed and provide d support to all system interfaces and coordinate d with project managers to provide specifications for all core modules.
• Analyze d and ensure d efficient transition of all technical design documents and develop ed various SQL packages to provide support to all application developers.
• Created Logical Flow of Data Conversion including source data analysis, data profiling and data cleansing for the historical data migration from Oracle 9i, Instar and DB2 Databases, CSV Files, Flat Files .
• Developed conversion programs to bring Legacy details into Oracle table using SQL*Loader, PL/SQL Package and populated data into base tables.
• Involved into updating procedures, functions, triggers, and packages based on the change request.
• Developed triggers for error handling and auditing to keep track of changes to the fields of tables when changes are made.
• Wrote Stored Procedures for effective inserts and updates of the data to the tables aimed to reducing the network traffic.
• Developed application and database triggers, functions, procedures, and packages in PL/SQL.
• Extensively used for all and bulk collect to fetch large volumes of data from table.
• Used Ref cursors and Collectionsfor accessing complex data resulted from joining of large number of tables.
• Applying constraints and writing triggers to apply the business rules. Involved in handling errors and transaction processing in the procedures.
• Creation of database objects like tables, views, Indexes on tables, synonyms, materialized views, stored procedures, packages using oracle tools like TOAD.
• Extensively used Global Temporary Tables to Confidential the required data set to increase the performance.
• Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.
• Involved in UAT testing, Bug fixing and Production rollout.
• Provided the 24/7 Application Support for Post-Production Process
• Worked in 3 week sprint agile environment.
• Actively participated in designing database models.
• Responsible for writing Unit test scripts used by UAT.
• Involved in performance tuning along with the DBA involved.
• Setup job automations using ActiveBatch V9.

Environment: Oracle 11g/12C/9i, TOAD, SQL PLUS, PL/ SQL, SQL*Loader, Shell Scripts, SQL Navigator, Toad.

Confidential, CA

Sr. Data Warehouse Developer

Responsibilities:

• Involved in requirements gathering, analysis and design.
• Generated SQL and PL/SQL scripts to create and Drop database objects including: Tables, Views, Primary Keys, Indexes, Constraints, Packages, Sequences, Grants and Synonyms.
• Used performance tuning utilities like EXPLAIN PLAN, SQL Trace and dbms profiler to improve the performance by reducing the run time of queries on the database.
• Created autonomous transactions for error logging and auditing.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
• Responsible for the detail design documentation, development, unit testing and maintenance of internally developed applications.
• For the reporting purpose extensively used SQL Scripts and wrote complex SQL queries using Joins, Sub queries and Group functions.
• Involved in modifying various existing packages, procedures, functions and triggers according to the new business measures.
• Executed PL/SQL blocks using cursors, REF cursors, exception handling, Collections -Nested tables and Index of Table and Dynamic SQL.
• Creating Jobs, Work flows, data flows and scripts in Data Integrator to pull data from the legacy systems and Confidential the data into target database. Writing SQL Statements in DI scripts to modify data. Created initial and delta loads.
• Responsible for creating mapping and transformation specifications based on the business requirements from various business teams and implemented in Data Integrator jobs.
• Worked on Source to Target Mapping design.
• As a part of Administration work, created the Users, groups and assigned the security in The Central Management console.
• Installed the client tools on all the developer machines created their local repositories and added them to central repository. Involved in the Check in, Check out, get operations with other local repositories from Central Repositories.
• As a part of database Administrator Microsoft SQL server 2008 created the users, mapped the users to their respective local repositories and granted the access to their specified groups.
• Validated and executed batch jobs. Tested data flows and scripts against sample data and real data. Creation of initial and incremental Confidential jobs.
• Used Cursors, Native Dynamic SQL and Bulk Collections to implement the Bulk Confidential .
• Used Materialized views in order to improve the performance.
• Trouble shooting performance issues within packages using dbms output
• Developed scripts for validating the UAT deployment for the schema objects.
• Responsible for Documentation of all the project developments and methodologies followed for the defect-fix, as per the standards defined and the system requirements.
• Worked on multiple requirements simultaneously.
• Worked with Enterprise Data Warehouse (EDW) team.
• Involved in creating db links using oracle gateway from Sql Server to Oracle.
• Worked in creating ETL jobs using Business Objects Data Integrator (BODI server).
• Manage/ Monitor ETL jobs per schedule.

Environment: Oracle 11g, Oracle PL/SQL, SQL Navigator, SQL Developer, SQL*Loader, UNIX, MS office 2010 and Toad.

Confidential, Care Health Plan, CA

Sr. Oracle PL/SQL Developer

Responsibilities:

• Meeting with end users, collecting requirements and converting into technicalSpecification.
• Worked with various functional experts to implement their functional knowledge into working procedures.
• Developed various database objects for front end application.
• Involved into updating procedures, functions, triggers, and packages based on the change request.
• Developed data model, SQL Coding, SQL Query tuning process and Schemas.
• Developed application and database triggers, functions, procedures, and packages in PL/SQL.
• Extensively used for all and bulk collect to fetch large volumes of data from table.
• Used Ref cursors and Collectionsfor accessing complex data resulted from joining of large number of tables.
• Applying constraints and writing triggers to apply the business rules. Involved in handling errors and transaction processing in the procedures.
• Extensively used Global Temporary Tables to Confidential the required data set to increase the performance.
• Used BULK COLLECT, BULK INSERT and FORALL to decrease query execution time.
• Reproduce Oracle schema objects includes temporary tables, views, Materialized views, indexes, triggers and procedures, based on customer requirement.
• Worked on production tickets using BMC Foot prints service core (version12.1).
• Developed Complex SQL queries using various Joins, Sub-Queries, Analytical and Group Functions and developed various dynamic SQL’s thorough out the projects.
• Created shell scripts and updated the scripts as per the requirement.
• Loading data using SQL* loader from credentialing department(S&I and OCI) for providers, ancillaries and hospitals and dumping against database and generating reports using OBIEE .
• Loading members from monthly file into database, their processing and assigning providers based on their enrollment for SOA webserver application.
• Automation of medical files and scheduled to run every month using UNIX shell scripting .
• Created test cases and test reports and worked with QA team to validate the data and scenarios.
• Handled various exceptions to troubleshoot PL/SQL code.
• Worked on Production tickets using footprints.
• Wrote UNIX shell scripts for various database objects.
• Worked with Reporting team for generating reports to DHCS.
• Performance tuning for complex queries.

Environment: Oracle 11g, TOAD, PL/ SQL, SQL*Loader, Shell Scripts, SQL Navigator, UNIX, BMC Foot prints service core (version12.1).

Confidential

Sr.PL/SQL Developer

Responsibilities:

• Worked with the Business analysts for requirements gathering, business analysis, testing, metrics and project coordination.
• Involved in designing ER diagram using Erwin, to set the logical and physical relationships of database.
• Developed PL/SQL code for updating payment terms.
• Developed data model, SQL Coding, SQL Query tuning process and Schemas.
• Created SQL*plus reports as per client's various needs, and developed business objects.
• Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
• Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.
• Used Bulk Collections, Indexes, and Materialized Views to improve the query executions.
• Atomized routine jobs using DBMS JOB. On completion of these jobs an email will be sent out automatically with the help of UTL MAIL.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Developing Control files using SQL*Loader to perform bulk data loads into database tables from external data files.
• Involved in creation of Conceptual Modeling covering all the business requirements.
• Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
• Developed custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 10g and Oracle Forms builder 10g respectively.
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Created some oracle objects for OLAP.
• Worked on production support tickets.
• Wrote ad-hoc packages for internal functionalities.
• Created UNIX shell scripts to run SQL*Loader control file as scheduled.
• Performance tuned preexisting queries in OLTP environments.
• Created master detail forms and consolidated reports using Oracle Forms & Reports 10g.

Environment: Oracle 11g, SQL, PLSQL, SQL*Loader, Shell script, SQL developer, Toad, Oracle Forms 10g, Reports10g and MS office 2010.