SUMMARY

• Over 9 years of experience in Database and Data Warehouse design, development, Testing, ETL and Reporting using Oracle 10g/11g/12c.
• Over 5 years of Oracle Financials (EBS) techno - functional experience in various Federal and Commercial projects.
• Experience in data modeling, Normalization, data loading, data retrieval, modification and data archival.
• Experience in Medicare/Medicaid healthcare domains (Eligibility & Enrollments and EDI transactional files such as 834/270/271).
• Extensively worked on backend programming using PL/SQL and creating Stored Procedures, Functions, Packages, triggers and reporting queries for large databases up to terabytes.
• Experience in developing complex code units using Bulk Binds, Materialized views, Inline views, Global Temporary Tables to optimize performance.
• Experience in using Explain Plan, gather stats, creation of indexes, SQL TRACE and TKPROF tools for performance tuning.
• Extensively worked with Oracle Utilities like Imports / Exports, SQL * Loader for Data Integration and Migration.
• Hands on experience in Unix shell scripting to schedule and automate data to day jobs.
• Knowledge in DBA skills that includes starting & stopping of databases and listeners.
• Good experience on RICE Components (Reports, Interfaces, Conversions and Extensions) and reporting tools like XML Publisher and Discoverer.
• Knowledge in development and customization of oracle forms using Forms Personalization.
• Oracle financials functional experience in various modules such as Accounts Payables, Accounts Receivables, Budget Execution, Purchasing and General Ledger, Inventory, Order Management and P2P cycle.
• Hands on experience in using the oracle application object library (AOL) and FNDLOAD commands.
• Experience in performing business functional testing and writing test cases for the functional testing.
• Excellent Technical background, communication, interpersonal, analytical skills and presentation skills. Very quick at learning new technologies & frameworks.

TECHNICAL SKILLS

• Oracle 9i/10g/11g/12c, SQL Server
• Java, J2EE, C, SQL, Shell scripts and PL/SQL
• Windows, Red Hat Linux RHEL 5, UNIX
• Informatica
• XML Publisher, Discoverer and Oracle Reports
• SQL Loader, SQL plus, Oracle Forms, Oracle Workflows, Data Loader, JMETER, TOAD, Win SCP, XMLSPY, SQL Navigator, SQL Developer, Oracle Enterprise Manager
• SOAP and WSDL
• Oracle Financials R12, 11i
• Accounts Payables (AP), Accounts Receivables (AR), General Ledger (GL), General Ledger (GL), Inventory, Purchasing (PO), Order Management.

PROFESSIONAL EXPERIENCE

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Creating the PL/SQL packages/procedures, functions, tables, views, various SQL queries and triggers for different business modules in CHAMPS (Eligibility & Enrollment, Managed Care and EDI).
• Worked on 834 and 820 transactions to produce the HIPAA files for managed care providers.
• Attended meetings with business users and functional consultants to gather business requirements for various deliverables.
• Generating the data extracts in different data formats for clients using TOAD, SQL Plus and SQL Developer.
• Tuned the SQL queries/Procedures using Explain plan, TKPROF and Trace utilities.
• Designed/developed tables, views, various SQL queries, stored procedures, function, complex PL/SQL packages for ETL.
• Provided techno functional support for production deliverables to meet the SLA.
• Participated in the design, development and implementation of complex applications, often using new technologies.
• Participated in code reviews as well as in meetings to discuss software solutions and development issues
• Involved in creating the User Interface, writing the business logic component and writing stored procedures
• Prepared user manuals, which helps the end-users in successfully operating the application.

Environment: PL/SQL, Oracle 11g/12c, TOAD, SQL Loader, SQL* Plus, Windows XP, XML, SOAP UI, JIRA, SharePoint, Xshell and Putty, subversion and UNIX.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Gathered the requirements by inquiring the user group and translated the requirements into detail technical and functional specifications
• Participated in the design, development and implementation of complex applications, often using new technologies.
• Interacting with Project Manager and translate the requirements, business rules into technical requirements
• Analyzed query structures of the production (Oracle based) system.
• Participated in code reviews as well as in meetings to discuss software solutions and development issues
• Involved in creating the User Interface, writing the business logic component and writing stored procedures
• Created complex SQL queries, Stored Procedures, functions and database triggers and Views for data analysis.
• Used TOAD to run SQL and PL/SQL code to manipulate the databases in all environments.
• Involved in testing like the Unit testing.
• Testing of procedures and reports for better performance.
• Prepared user manuals, which helps the end-users in successfully operating the application.

Environment: PL/SQL, Oracle 10g, TOAD, SQL Loader, SQL* Plus, Windows XP, XML, SOAP UI, JIRA, SharePoint, Xshell and Putty, subversion and UNIX.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Designed and developed PL/SQL Packages, Stored Procedures, Functions, Triggers and Complex SQL Statements.
• Produced detail design specifications of the system.
• Involved in creation of schema objects like indexes, views, and synonyms.
• Re-wrote PL/SQL stored procedures and optimized data.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL
• Imported data from legacy system to Oracle payable tables using SQL Loader and validate them using procedures
• Writing PL/SQL Programs for implementing validation rules and loading GL data from staging tables to GL Interface Tables and also used Oracle API's for initiating journal import.
• Registered the PL/SQL Packages and procedures as concurrent Programs in oracle financials.
• As Team Member, worked with users through all Software Development Lifecycle (SDLC) phases.
• Developed XML service requests for testing web service functionality using SOAP UI.
• Developed XML Publisher report for AR Aging report.
• Worked on form customizations for budget authority form to disable and rename some of the fields.
• Worked on different financial modules in R12 such as AP, AR, PO, BE and GL for resolving some of the technical issues as technical team member.
• Involved in preparing technical and functional requirement documents for customer requirements.
• Written technical design documents for conversions, extensions, interfaces, and reports.
• Coded, tested, debugged, documented, and maintained programs.
• Created detailed project outlines, application design specifications, and test plans.
• Participating in Daily and Weekly Client Meetings.
• Worked on Unix environment and writing the shell scripts on server.
• Prepared test cases and performed unit/integration/system testing.
• Provided techno functional support for production issues.

Environment: Oracle 11 g, Oracle Financials R12, Forms 10g, Reports 10g, Workflow Developer, Informatica, XML, SOAP UI, Data Loader, SQL Loader, Web Services, UNIX, JIRA, SharePoint, Xshell and Putty.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Schedule meetings and present technical issues to business users and developers.
• Performed discussions with data modeler to update the data model for new requirements.
• Extensively developed complex PL/SQL packages for Invoice Processing.
• Designed/developed tables, views, various SQL queries, stored procedures, functions.
• Involved in PL/SQL code review and modification for the development of new requirements.
• Extensively worked with Dynamic SQL, Composite data types & Global Temporary Tables.
• Designed/developed tables, views, various SQL queries, stored procedures, function, complex PL/SQL packages for ETL.
• Used Pl/SQL tables, array structures as a part of oracle collections.
• Involved in partitioning of very large tables. Used list and range partitioning.
• Associated with DBA in monitoring the performance related issues using Explain plan, SQL Trace and TKPROF utility.
• Written conversion programs for GL journals, AR customers, AP invoices, PO vendors. Developed SQL * Loader programs to load data from flat file to stage tables.
• Written PL/SQL procedures to validate and load the data into the Oracle Interface tables or directly into the Oracle base tables for the respective modules.
• Customized Employee Listing reports, Invoices on Hold reports as per the business requirements using oracle reports.
• Customized Oracle forms for disabling some of the tabs on standard forms using Form Personalization.
• Created customized responsibilities, customized menus, concurrent programs, value sets, request sets and request groups for client requirements.
• Worked extensively on Accounts Payables (AP), Purchase Orders (PO), Budget Execution (BE), Accounts Receivables (AR) and General Ledger (GL) modules.
• Involved in data migration for Equal Employment Opportunity Commission (EEOC).
• Involved in running the UNIX commands and using cron job services.
• Provided techno functional support for production and having knowledge in deploying various scripts form test to QA and QA to production.
• Created custom workflows for some of the modules in oracle financials.
• Generating the data extracts in different data formats for clients using TOAD, SQL Plus and SQL Developer.
• Experience in using METALINK TAR to resolve oracle applications related issues.

Environment: Oracle 11.2.0.2, Oracle Financials R12.0.6, Forms 10g, Reports 10g, Workflow Developer, Informatica, XML, SOAP UI, Data Loader, SQL Loader, Web Services, RHEL 5 Update 6 and JMeter.

Confidential

Oracle Developer

Responsibilities:

• Creating the PL/SQL procedures, functions and triggers for different business modules in NCFMS.
• Involved in creating the oracle concurrent request sets using PL/SQL packages.
• Involved in the New Core Financial Management System (NCFMS) for the Department of Labor (DOL)
• Involved in migration for Department of Labor (DOL).
• Designed/developed tables, views, various SQL queries, stored procedures, function, complex PL/SQL packages for ETL.
• Worked on Supplier conversion from legacy system to Oracle Payables.
• Provided technical support and assistance to team members working on other deliverables for the project.
• Attended meetings with business users and functional consultants to gather business requirements for various deliverables.
• Worked on generating QTP scripts for the test scenarios in Finance modules.
• Developed XML Publisher report for general ledger posting data.
• Developed various discoverer reports in GL, AP and PO modules.
• Customized some of the standard oracle reports (Trial balance report) using oracle reports developer tool.
• Involved in developing the subledger accounting (SLA) for various oracle federal financial modules.
• Developed the workflow in budget execution module for sending the notifications from budget preparer to budget approver.
• Registered Forms and Reports on to Oracle Applications.
• Created customized responsibilities, customized menus by adding the custom forms and custom functions as per the client requirements.
• Involved in running the Unix commands and writing the shell scripts on Unix server.
• Generating the data extracts in different data formats for clients using TOAD, SQL Plus and SQL Developer.
• Tuned the SQL queries/Procedures using Explain plan, TKPROF and Trace utilities.
• Provided techno functional support for production issues in Forms, Reports, PL/SQL Packages/ Procedures.
• Loading large data into database using SQL loader.
• Loading data and setups into any application using Data Loader.

Environment: Oracle Financials R12.0.6, 11.5.9, 11.5.10.2, Forms 10g, Reports 10g, Workflow Developer, Discoverer, XML Publisher, Oracle 11.1.0.6, 11.1.0.7, XML, SOAP UI, Data Loader, SQL Loader, Web Services, RHEL 5 Update 4 and JMeter.