SUMMARY:

• More than ten years experience as a Oracle Database developer for enterprise application development, maintenance and support to production environment.
• Extensively worked on developing and maintaining stored procedures, functions, packages and triggers using Oracle SQL and PL/SQL.
• Worked on data migration projects to migrate legacy application data to a new system using PL/SQL scripts.
• Developed and upgraded and maintained ETL jobs using Oracle SQL, PL/SQL, SQL Plus and UNIX shell script.
• Worked on OLTP application maintenance and upgrade, enterprise wide Data Warehouse and Data Mart databases.
• Experienced in Production Support ETL jobs.
• Experience in Oracle SQL Query optimization and performance tuning.
• Familiar with routine DBA tasks for creating and altering tables, view, indexes and other DB objects.
• Worked in a team of Business Analysts, Developers and Business Users in defining requirements, mapping rules, validations etc. for data import processes.
• Worked with Data Modeler team to review proposed database changes.
• Worked closely with the user group, developers, QA testers and DBA team.
• Experience in Agile and Waterfall software development, Scrum methodology.
• Participated in Business Continuity Tests, regression testing and code review for production change.
• Worked on complete SDLC using JIRA and Confluence.
• Experience in understanding HIPPA requirments, HL7 data exchange, NCPDP guidelines for Healthcare Industry.
• Familiar with Microsoft SQL Server, T - SQL and SSIS.
• Worked on Microsoft SSRS reports.
• Provided support on user queries related to missing data and data consistency.
• Experience in writing processes and scripts for data cleansing processes.
• Monitoring data-feed jobs for applications on various platforms.
• Excellent verbal and written communication skills and a team player.
• Experience working with remote and offshore/near-shore teams.

TECHNICAL SUMMARY:

RDBMS: Oracle 12c, 11g, 9i, SQL Server

Languages: SQL, PL/SQL, T-SQL

CRM: Salesforce

ERP: Oracle R12 EBS

Reporting tools: SSRS Reports, Actuate, Oracle Discoverer, Salesforce

Version Control: GIT, Bitbucket

FTP: FileZilla, Bitwise SSH

ETL: Microsoft SSIS, IBM Cast Iron, UNIX Shell Scripts, SQLLDR, External tables

Development Tools: TOAD, SQL Developer

Project Management and Service Delivery: JIRA, Confluence

Defect Management and Ticketing: SpiraTeam, JIRA, Salesforce

Analytic: SSAS

PROFESSIONAL EXPERIENCE:

Consultant - BIDW Subject Matter Expert (Data)

Confidential, Pasadena, CA

Responsibilities:

• Responsible for timely completion of ETL processes on a Daily and Weekly basis.
• Developed HL7 Data import ETL jobs from Source Lab's data drop.
• Developed data extraction jobs from Kaiser's source system.
• Working on Auto Order Lab processing, Health Modifier setups etc.
• Involved in a Production Support role

Consultant-Software Engineer

Confidential, San Diego, CA

Responsibilities:

• Worked on Data Extract of pharmacy claims and prior approval for a big health care customer using Oracle SQL, PL/SQL and UNIX shell script.
• Worked on creating a report for DB differences in different environment.
• Documented existing ETL processes for development in Informatica.
• Worked on creating Data Import and incremental data load scripts in PL/SQL.
• Created and documented data profiling SQL scripts to clean up existing application data before migration to new application.
• Created data profiling tasks using Microsoft SSIS.
• Created Import and Export of Bulk Data by Using the bcp Utility.
• Worked with QA team in regression testing, defining test cases and fallback plans.

Database Application Developer

Confidential, Monterey, CA

Responsibilities:

• Worked on data migration and system Integration from legacy system to Salesforce.
• Worked on SQL, PL/SQL code development and enhancement for existing applications including Billing, Payroll and Customer Portal etc.
• Developed and maintained Daily and Monthly Data feed processes to Customer Service web portal.
• Involved in design, build and deploy Data Warehouse and Data Mart on Microsoft SQL Server and SSIS.
• Created reports on Data Warehouse environment using SSRS reporting tool.
• Provided support on various set ups related to Customer, Invoicing, Customer contacts and relationship management, account ownership etc.
• Maintained monthly import of Tax tables for Customer billing using SQLLDR.
• Design and develop PL/SQL stored procedures, packages, job schedule, ad-hoc SQL and PL/SQL blocks.
• Looked after a day-to-day maintenance and upgrade applications including Call delivery, Billing, Payroll and Commissions.
• Involved in ETL process development and monitoring.
• Provided Day to day operational support to Finance, Payroll, Sales and Marketing, Operations department for report management, ad-hoc reporting etc.
• Helped users, troubleshoot and analyze various ways to improve quality and service level.
• Helped DBAs to comply with Data Security and SOX compliance audit etc.
• Monitored ETL processes on Cast Iron.

PL/SQL Developer

Confidential, Los Angeles, CA

Responsibilities:

• Developed and maintained stored procedures to update tables in different schemas. Database triggers to automate insert, update and delete tables in different schemas. Shell Scripts for batch processes. Test, debug and rewrite stored procedures in existing applications Ad-hoc reports for existing applications. Environment: Oracle 9i/10G, Windows 2003, TOAD, SQL Developer

PL/SQL Developer

Confidential, Burbank, CA

Responsibilities:

• Worked on Benefits administration system to customization to suit Client needs.
• Worked on defining Business Rules, Pension Rules, Factor Tables and Look up Columns for generating various calculations such as Vesting Status, Vesting Date, lost year, Break in Service etc.
• Worked on various modules such as Health and Pension Contributions, Payments, work Report and Pension related modules including Pension Application Processing, Participant, Dependent and Beneficiaries.
• Created scripts to execute on different instances including Production, QA and DEV to find difference in various environments.
• Developed stored procedures and packages to export data from multiple tables using joins, unions and sub queries to Temporary Tables for batches running export, import data from external files to staging tables and loading it in actual tables upon validations for Payment Processing, Pension Calculation, and Interest Calculation.
• Tuned SQL queries and improved overall system performance.
• Designed reports using iReport.