We provide IT Staff Augmentation Services!

Pl/sql Developer Resume

Alhambra, CA

SUMMARY

  • Over 15+ years of IT experience in teh Analysis, Design, Development, Testing and Implementation of business application using teh Oracle Relational Database Management System (RDBMS). Having 8+ years exp in modules of Oracle E - business Suite applications such as Oracle HRMS, Core HR, INV, AP, PO, AR etc.
  • Extensive business knowledge on health care core systems and Claims management.
  • Expertise in data analysis, data extraction, transformation, loading, performance tuning of Applications and overall management of mission critical database related applications.
  • Strong Data Warehousing ETL experience of using Informatica 9.1/9.5/10.1 Power center client tools Mapping Designer, Repository manager, workflow Manager/monitor and Server tools, Informatica server, Repository server manager.
  • Expertise in Client-Server application development using Oracle 12c/11g/10g/9i, PL/SQL, SQL *PLUS,PLSQL developer, SQL Server, TOAD,SQL*LOADER and in Unix shell scripting.
  • Expertise in using Packages, Procedures, Functions, SQL Loader, External Tables, Collections, PL/SQL Tables, Materialized Views, Triggers.
  • Strong experience in Oracle database design and logical/physical Data Modelling.
  • Experience in ETL processes utilizing Informatica Power center tools/ ODI to design data conversions from a variety of relational, XML and flat file source systems to data warehouse/data marts.
  • Good working experience in using SQL*Loader to load files from UNIX to Oracle tables and UTL FILE utility to load/create files in UNIX.
  • Created UNIX Shell Scripts for invoking SQL scripts and scheduled them using crontab.
  • Expertise in Application Performance Tuning by utilizing Explain Plan, analyzing teh query plans, incorporating query optimization techniques such as Bulk SQL, Bulk binding, Collections, providing hints wherever required and table partitioning. Usage of Oracle Analytic functions.
  • Working experience in data extraction, transformation and loading operations into Oracle using
  • SQL Loader, External tables, DB links, Export/import and UTL FILE.
  • Developed and customized Oracle Forms and Reports using Forms/Reports builder as per client specifications.
  • Hands on experience inAzureDevelopment, worked on Azure storage, created pipelines, tasks.
  • Knowledge on Snowflake SQL environment running SQL queries, create tables, copy from azure storage etc.
  • Good knowledge and hands on experience in SDLC methodologies like Waterfall, Agile, Scrum to ensure efficient project management.
  • Excellent analytical and interpersonal and communications skills and ability to work independently interacting wif people at levels.
  • Excellent communication skills, inter-personal skills, and a team player.

TECHNICAL SKILLS

Databases: Oracle (11g,12c), MS SQL Server 2005/2008/2012 , MS Access, MySQL,DB2, PostgreSQL, Teradata

Programming & Scripting: SQL, PL/SQL,UNIX, Shell Scripting, Core Java

Operating Systems: Windows NT/2008/2012/XP/7/10, Unix/Linux, AIX 5L

Source Control Tool: IBM Rational Clear Case, CVS, SVN, Team Foundation Server (TFS), GIT

Tools: /Utility: TOAD, SQL Developer, Edifecs, Erwin, PL/SQL, SQL*Plus, SQL*Loader, External Tables, SQL Navigator, Erwin DM, Autosys, Control-M, Oracle Forms & Reports 6i/9i/10g, Oracle Data Integrator, OBIEE 11g, Oracle EBS Suite 11i & R12, Informatica Power Center 9.1/9.5/10.1 , XML Publisher, APEX

Documentation: Office 365, Microsoft Visio, SharePoint, JIRA, Lotus Notes

Cloud Platform: Windows Azure, Snowflake

PROFESSIONAL EXPERIENCE

PL/SQL Developer

Confidential, Alhambra, CA

Responsibilities:

  • Extensive experience in design, develop, enhance, and maintain EDI and encounter process systems. Manage and monitor inbound and outbound encounter data submission process and performance.
  • Analyze data and reports using critical thinking, submission performance, process accuracy and system performance by following established policies and procedures; work wif internal and external stakeholders to ensure data end to end processes, data quality, and data analytics meet wif CMS, DHCS, all regulatory agencies, and business requirements & standards.
  • Create, maintain, and enforce policies & procedures to ensure and improve data submissions performance, improve process and system performance and accuracy, data quality and evaluate for appropriate capacity.
  • Developed PL/SQL Procedures, Functions and Packages and used SQL loader to load data into teh database.
  • Design Test Plan & Test cases for QA and UAT ensure teh newly created analytical tools, reports, dashboards, processes, and systems met business requirements and teh quality of development to be delivered accurately and in teh timely manner.
  • PerformedSQL and PL/SQL tuningand Application tuning using various tools likeEXPLAIN PLAN
  • Design, develop and maintain oracle database schemas, tables,views, synonyms,indexes,constraints, andsequences.

Environment: Oracle 12c/11g, TOAD 12.0, Azure Storage, Git, MS SQL Server 18.8, Python, MS Office 365, Putty

Sr. Oracle Developer

Confidential, Monterey Park, CA

Responsibilities:

  • Review teh encounter processes, analyze data, design, and regulatory agencies business requirements to has a good understanding of Blue shield applications.
  • Participates in meetings wif Application Functional managers to work in tandem wif them and develop teh functional specification documents.
  • Ability to understand various encounter processes and HIPAA standard transaction sets like 837P, 837I, TA1, 999, 277 and NCPDP.
  • Worked on migration of legacy system to Edifecs tool. Responsible for teh historical 837 files and responses from legacy system to Edifecs tool. Validate all teh business requirements as part of teh Edifecs UAT testing.
  • Validate teh Inbound data in Edifecs production on daily basis and generate teh outbound Medical & Medicare files that are sent to DHCS, LA Care and CMS.
  • Monitor teh acceptance percentage for teh respective line of business in teh Edifecs tool and validate all teh corresponding responses like TA1, 999, 277CA and EVR were received.
  • Worked on mass correction in Edifecs tool and validated teh inbound data using SAS to connect other databases which helped in tracing inbound claim record data.
  • Responsible for manual and automated reports generation in Edifecs tool.
  • Developed PL/SQL Procedures, Functions and Packages and used SQL loader to load data into teh database.
  • Tracks, reviews, and analyzes daily defect checklists.
  • Design test plan and test cases for QA/UAT to ensure all requirements delivered accurately and timely.
  • Developed SQL scripts for ETL process to load data into target tables.
  • Used SQL queries and analytic functions to develop reports for managers for business analysis.

Environment: Oracle 12c/11g, TOAD 12.0, Edifecs tool, SAS 9.2, Winscp, Putty, Informatica Power center 10.1, Microsoft Visual Studio .0, MS SQL Server 2012, MS Office 365 Pro, EDI Notepad, Unix.

Sr. PL/SQL Developer

Confidential, Los Angeles, CA

Responsibilities:

  • Leads other developers working on teh project to ensure that teh development features are complete in time.
  • Responsible for development and testing of conversion programs for importing data into Oracle database utilizing PL/SQL, SQL*Loader and UNIX shell scripts, to load data from flat files to Oracle database.
  • Proficient in teh integration of various data sources wif multiple relational databases like Oracle, SQL Server, and flat files into staging area, Data Warehouse and Data Mart.
  • Develop and enhance encounter/claims system processes for inbound file loading and outbound file generation to meet teh business rules, policies and procedures required by DHCS and CMS.
  • Hands-on experience wif various encounter processes and wif HIPAA standard transaction sets like 837I/P/D and NCPDP.
  • Worked on migration of legacy system to Edifecs tool. Responsible for teh historical 837 files and responses from legacy system to Edifecs tool.
  • Extensively worked on Informatica Power Center tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplets Designer, Transformation Developer and Workflow Manager to extract teh data from Oracle, SQL Server and load into Oracle data base.
  • Created PL/SQL scripts to extract teh data from teh operational database into simple flat text files using UTL FILE package.
  • Various Mappings were developed using Designer that involved different transformations like Update Strategy transformation, Lookup transformation, Aggregator transformation, and Stored Procedure transformation, Expression Transformation.
  • Test case/data preparation, execution, and verification of teh test results.
  • Worked wif day-to-day issues that are submitted in teh form of tickets.

Environment: Linux, Oracle 12cR1, TOAD 12.5.1.1, Microsoft Visual Studio .0, MS Project Server 2013, Informatica Power Center 9.1.0, Oracle 11g, Edifecs, SQL Server 2008, SSRS, Unix

Oracle Developer

Confidential, Austin, TX

Responsibilities:

  • Responsible for requirement analysis and preparation of high level design document.
  • Developed PL/SQL Procedures, Functions and Packages and used SQL loader to load data into teh database.
  • Extensively worked in TOAD, SQL Developer, PL/SQL, SQL*Plus, SQL*Loader, Query performance tuning, created DDL scripts, created database objects like Tables, Views Indexes, Synonyms and Sequences.
  • Performed unit testing at various levels of teh ELT experience in configuring ODI Agent on UNIX server and creating new agents and test them in ODI 11G.
  • Extensively used SQL Loader to load teh data from Flat Files into teh staging tables and verified teh Log Files for rejected rows.
  • Developed SQL scripts for ETL process to load data into target tables.
  • Wrote PL/SQL programs, stored procedures and triggers for data loading and data validations for various Java based applications
  • Extensively used UNIX SHELL scripts for automation of daily and weekly batch jobs.
  • Created indexes on huge number of data available in tables based on requirements.
  • Interlinked related forms and passing parameters between forms related to order entry.
  • Scheduled Oracle reports in UNIX.
  • Worked mostly on teh data conversion part to be uploaded into corporate reports using Oracle PL/SQL.
  • Analyzed SQL statements reorganize database objects and design indexes to improve response of queries.
  • Used Dynamic SQL to create stored procedures for cleaning teh data base tables.
  • Used SQL queries and analytic functions to develop reports for managers for business analysis
  • Involved in Unit testing and migrate teh objects to teh QA and UAT TEST environment

Environment: Oracle Applications 11i&R12, ODI 10g/11g, PL/SQL, Oracle Forms & Reports 9i/10g, Weblogic, TOAD

Sr. Software Engineer

Confidential

Responsibilities:

  • Responsible for requirement analysis and preparation of high level design document.
  • Supported teh implementation and configuration issues related to Eligibility, Electability, Life events, Fast Formulas, Rates and configuration of rates, Premiums etc.
  • Configured Benefit structure - New Plan Types, Plans, Options, Life Events, Eligibility Profiles, Rates and VAPROs
  • Create/update key BRD’s and other existing business requirement documents that may be impacted include Payroll, Carrier File and Account Payable requirements.
  • Expertise in Oracle SQL, PL/SQL. Skilled in Application development using Oracle Forms and Reports wif knowledge in master-detail blocks, forms triggers, system variables, multiple form applications, menus, alerts and LOV's.
  • Involved in teh generation of User Interface using oracle forms by extensively creating forms as per teh client requirements.
  • Handled errors using Exception Handling extensively for teh ease of debugging and displaying teh error messages in teh application.
  • Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
  • Performed source to Staging and staging to target mapping specifications and developed ETL / ELT ODI code for teh same.
  • Test and validate that all data loads properly and execute manual procedures like running any scripts to validate data.
  • Developed and configured both standard and client specific fast formulas as per teh requirements
  • Review teh fast formulas developed and responsible till they migrate to production.
  • Responsible to support any productions issues on a weekly basis.
  • Developing Fast Formulas which will internally call teh Stored Procedures and modifying them for better performance.
  • Supporting teh implementation and configuration issues by tracing teh rules and fixing them.
  • Extended Technical and Functional Support for Annual Enrollment process for Confidential ’s 42 Clients.
  • Supported teh implementation and configurations issues relating to tech spec loader tool.

Environment: Oracle Applications 11i&R12, ODI 10g/11g, PL/SQL, Oracle Forms & Reports 6i/9i/10g, Java, AIX 5L, Clear Case, Lotus Notes

Technical Consultant

Confidential

Responsibilities:

  • Report to view teh pending item transaction wif respect to teh Inventory Organization.
  • PO form customization to capture relevant supplier item number and stock-keeping unit.
  • PO receipts conversion.
  • Item attachment conversion.
  • Customization of PO form to check whether teh supplier is in teh defaulters list or not
  • Development of forms and reports.
  • Developing pl/sql packages, procedures and functions.

Environment: Oracle Applications 11i, SQL, PL/SQL, Erwin, SQL * Loader, SQL * Plus, Oracle Forms & Reports 6i, XML/BI Publisher

Hire Now