PROFESSIONAL SUMMARY:

• Over 10 years of IT experience in System Study, Design, Development, Testing, Post Implementation maintenance and support of application software. Highly experienced in evaluating and understanding business requirement and mapping them using Oracle Applications.
• Hands on experience in AOL, Oracle D2K, Oracle ODI, Discoverer, PL/SQL, SQL, SQL*PLUS, SQL Developer, TOAD, Oracle Forms 9i/10g, Oracle Reports 9i/10g, Oracle 11g/10g/9i/8i
• Good functional knowledge in Order to Cash (O2C) and Procure to Pay Cycle (P2P)
• Around 7+ years' experience as Senior Oracle Developer with Financial and Distribution modules such as Oracle Financials like (GL - General Ledger, AP-Accounts Payables, AR -Accounts Receivables), Supply Chain (INV-Inventory, PO-Purchasing, OM -Order Management), Oracle Service Contracts (OKS), and Human Resources Management System - (HR, Oracle Advanced Benefits, Payroll and Labor Distribution).
• Proficiency with tools used to support Oracle Applications development including Forms, Reports, Workflow Builder, and XML Publisher.
• Development and Customization of RICE components-Reports, Interfaces, Conversions and extensions related to Oracle Apps Modules - OM, INV in Oracle Application R11i
• Strong knowledge and use of SDLC (Software Development Life Cycle) methodologies, standards, and procedures with experience in promoting database changes from development through production environments.
• Good Knowledge on UNIX and Shell Scripting.
• Experience in using SQL*Loader and UTL FILE packages for data conversion and interfaces.
• Extensively experienced in Oracle PL/SQL Development i.e. Stored Procedures, Packages, Functions & Triggers.
• Proficient in writing SQL and PL/SQL Scripts and other related tools and techniques on Oracle Database.
• Good understanding of RDBMS (Relational Database Management System) concepts (ACID property). Created and maintained Database Objects like Tables, Views, Indexes, Constraints, Sequence, Synonyms, Triggers, Database link, Roles and privileges.
• Excellent in team collaboration, quick adaptation and problem solving with good communication skills.
• Strong Analytical, Problem solving and communication skills.
• Efficient in working under pressure with focus on meeting deadlines on top priority. Comfortable working in a team or as an individual when required.

TECHNICAL EXPERIENCE:

ERP: Oracle Applications R12, 11.5.10, 11.5.07 and 10.7, Oracle SOA Suite 10.1.3.3,10.1.3.4,11gR1, 11g PS1, BPEL Process Manager, Enterprise Service Bus, Web Services Manager, Business Activity Monitoring

Databases: Oracle 10g/9i/8i/7x, MS SQL 2000, Access

Languages: SQL, PL/SQL, C, HTML, CSS, XML, Shell Scripting

Development Tools: Reports 9i/10g, Forms 9i/10g, Discoverer 10g, SQL*Loader, TOAD, SQL*Plus, SQL Developer, XML Publisher Reports, BI Publisher

Operating Systems: Windows XP/NT/2000, UNIX

Others (Knowledge): Salesforce, Informatica (ETL), Zoura, Tableau, Oracle ODI

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Oracle Database/ETL Developer

Responsibilities:

• Design, develop, and maintain the databases or models that can be used in various reporting processes such as Tableau, Business Intelligence and meet the business requirements of end users such as the Business Process Manager or Project Manager.
• Optimize system performance using Oracle performance tuning techniques such as query plan understanding and management, SQL tracing, DB stats, indexing techniques, and AWR reports.
• Design data integration between homogenous and heterogeneous databases such as Oracle and SQL; utilize tools and concepts including, but not limited to, SQL loader, database links, flat files, and Golden Gate.
• Worked in ETL, Data Architecture, Data Modeling, Data analysis and profiling, Metadata Management, Reference Data Management and Master Data Management.
• Well versed with data definition, data manipulation, data transaction scripts, session control scripts, transaction scripts, and system control scripts.
• Worked on migration of legacy database to exadata database.
• Assess current state of data management, identified gaps, provided recommendation and developed roadmap to address gaps for adopting data virtualization.
• Create custom queries or an incident management application to evaluate Key Performance Indicators; generate weekly and monthly reports to analyze trends and database performance.
• Develop key metrics for tests on data and ensure integrity of same on data architecture.
• Review the data deliverables to ensure quality and traceability to requirements and adherence to all quality management plans and standards
• Conduct weekly meetings with business owners and IT teams to discuss incident trends.

Environment: Oracle Database 10g, Oracle ODI 11g, PL/SQL Developer, Winscp, TOAD, Shell Script, UNIX, Service Now, JIRA, Tableau 2019.1, OBIEE.

Confidential, NY

Senior Oracle Developer

Responsibilities:

• Monitoring Remedy tickets and Quality center (QC) for defects.
• Analyzing Remedy tickets and proving solutions within steep timeline.
• Direct communication with client to resolve training related issues.
• Direct communication with client to understand the enhancement requests and PCRs and providing effort estimation and ETA to client.
• Delivering the enhancement requests and PCRs within steep timeline.
• Providing support to all AP, AR and CM custom reports using Oracle Report Builder (10g) and XML Publisher.
• Providing support to interfaces (both Inbound and outbound) with PL/SQL and Informatica for AP, AR, CM modules.
• Validating the data provided by the business using the PL/SQL Package prepared for the Interface Components to ensure the data is at par with the business requirements and therefore sending the erroneous records back to the business for further data cleansing.
• Providing support to extensions for AP, AR, Advanced Collection modules.
• Developing form personalization in receipt workbench and transaction workbench and many other seeded forms.
• Performing configuration changes in Accounts Payables (AP), Accounts Receivables (AR).
• Configuring for custom Sub Ledger Accounting (SLA) during period closure activity.
• Changing Tax setups in E-business Tax to meet customer needs.
• Preparing Technical Design Document, Unit Test script, Internal Quality Assurance (IQA) documents of the objects developed by myself. Performing IQA of the Technical Design Documents (TD) and Development Codes prepared by other project members and correspondingly documenting the points not satisfying the Quality norms.
• Making proper versioning of all the Code deliverables and Functional design Documents (MD50), Technical Design Documents (MD70), Setup Documents (BR100) by uploading it to a version control tool named Serena PVCS Version Manager.
• Migration of custom objects (Database objects and AOL objects) in 5 different environments through HP-PPM and PVCS.
• Taking necessary backups of all the Database objects (e.g. Table scripts, Package Script, Synonyms, and Grants etc), Concurrent Program LDT files of the deliverable codes and preparing Migration Documents illustrating the steps of migration of the Codes in any Environments.
• Performing exhaustive testing of the Interface and Extension Codes prepared/changed by me and other project members to minimize the defect rate and preparing unit test scripts to document the issues faced and methods of their resolutions.
• Ensuring quality deliverables on schedule.
• Currently working on the (data warehousing) data extraction and cleaning for project Mercury.

Environment: Remedy, Oracle Database 10g, Oracle Applications R12 Application Object Library (AOL), Winscp, Putty (FTP), JDeveloper 11g, HPPPM (used for Migration and FD-TD version managing and repository), PVCS (used for code version management), PL/SQL Developer. TOAD, Oracle Report Builder (10g), Microsoft Share point

Confidential, Chicago, IL

Oracle Developer/Forms and Reports Developer

Responsibilities:

• Responsible for analyzing and understanding the legacy system business functionality and preparing the functional and technical documentation/specs.
• Design, program, test and implement custom PL/SQL interfaces used for system integration between internal/external systems.
• Designed and developed Oracle Forms & Reports using Forms6i and Reports 6i as per the requirements of the business logic that has been documented.
• Worked on US Year-end Payroll Process to extract the employee data required for the W-2 generation for the FY-2011.
• Design and develop custom interfaces in PL/SQL (TOAD) and APIs for system integration to third party systems.
• Knowledge in underlying Oracle Applications database architecture including schemas/products, standard application program interfaces (API), data elements, tables, and views as basis for troubleshooting, data conversion and reporting.
• Created request sets, concurrent programs and value sets, and integrated them with various instances of Oracle Applications.
• Develop and maintain the documentation to support the team and business.
• Performed unit testing for the scripts.

Environment: Oracle Applications (11.5.10), Oracle 9i, Oracle HR, Payroll, AP, AR, PO, FA, PL/SQL, VB Scripting, Shell Scripting, SQL*Plus, SQL*Loader, Forms 4.5, Reports 2.5, JAVA/J2EE, Windows NT.

Confidential, Pittsburgh, PA

Oracle SOA/ PLSQL Developer

Responsibilities:

• Extensively involved in writing SQL queries (Sub queries and Join conditions), correlated sub queries, and nested queries for the business application development.
• Developed database triggers, packages, functions, and stored procedures using PL/SQL and maintained the scripts for various data feeds.
• Created Indexes and sequences for faster retrieval of the customer information and enhance the database performance.
• Designed and created complete BPEL and ESB Processes for orchestration using different process activities using Oracle SOA Suite 10.1.3.4.
• Designed and defined exception handling.
• Created Error logger process for error logging and Error Handler Process for resubmitting the error messages to respective processes.
• Created transformation, routing and payload validation using oracle service bus.
• Involved in setting up the Development Environment.
• Deployment of the BPEL process in integration server for integration testing, QA server for QA testing and in Production environment.
• Performed unit testing and involved in integration testing and QA Testing.
• Involved in production and post production activities.

Environment: Oracle9i, Windows NT, SQL *Plus & PL/SQL, TOAD 8.6. Oracle Application Server 10g, Oracle SOA Suite 10.1.3.4, Oracle SOA suite 11g, Oracle 10g Database Enterprise Edition, Developer 10g, BPEL, ESB, BAM, Oracle Applications 11i

Confidential, Miami, FL

Oracle SOA/ PLSQL Developer

Responsibilities:

• Developed and designed several Generic BPEL Processes & OSB Services
• Designed Database Adapters to poll for new records and sync data from multiple systems
• Designed JMS Adapters to actively send and receive messages from various enterprise systems.
• Involved in the configuration of the connection pools and data sources for Database Adapter and on the application server.
• Created Scheduler for BPEL Process.
• Created Fault Policies for Error Handling.
• Created, Configured and Managed Oracle OSB (Oracle Service Bus) Services
• Created Queues, Connection Factories, Multi Data sources and Data sources,
• Configured JMS Queues, Connection pools and connection factories to connect to different databases and publish and receive JMS messages.
• Developed Processes in OSB for routing
• Used BAM for Alerts and Notifications.
• Executed and wrote complex SQL queries to validate data integration
• Responsible for Integration and Unit testing.
• Deployed to multiple environments using ant scripts.
• Other responsibilities include maintaining Security Systems, Active Directory, DNS, WINS, DHCP.

Environment: SOA Suite 10.1.3.5.1, OSB 10.3.1, WLS 10.3.1, BAM 10g, OWSM 10g, Oracle 10g DB.

Confidential

HR Recruiter

Responsibilities:

• Understanding the requirements and providing end to end services in recruitment.
• Holding discussions, understanding the client's requirements and checking of the candidate's profile through Portals, advertisements, head hunting, database etc. to fill the vacancies.
• Screening the profiles, short listing & selecting the candidates in the preliminary rounds.
• Job description, salary payable and dates of recruitment, Source & Shortlist the right candidates.
• Interview the candidate and conduct telephonic interviews with candidates to know their communication skills and technical knowledge.
• Briefing the short-listed candidates about the job profile, salary package, organization etc.
• Put the candidate across to the client for further tests and interviews.
• Follow up with the client and find the status of the candidate.
• Keep in touch with the candidate and ensure that the selected candidate takes up the offer.