SUMMARY

• Having around 8 years of extensive experience in Oracle ERP user requirement study, analysis, solution design, project planning, code development of Reports, Interfaces, Conversions, setup, testing, Upgrade, customization, maintenance, support, and migration in Oracle E Business Suite 11i/R12 modules (ERP Applications R12.1.3,11.5.10).
• Expert in technologies like Oracle SQL, PL/SQL, Reports 10g/6i, XML, packages, triggers, new database features, Oracle 8i/9i/10g/11g/12c with good functional knowledge of configuring and use of Oracle EBS.
• Experience in software development in the area of web and windows applications especially in Analysis, Design, Architecture, Coding, Testing, Implementation, Documentation and Deployment of projects or products in Microsoft Technologies.
• Experience in developing applications on Microsoft .NET platform using C#.NET, ASP.NET, VB.NET, XML, WebServices, JavaScript, HTML, CSS, MS SQL Server.
• Excellent knowledge of Object - Oriented Programming concepts with experience of object-oriented design and programming.
• Strong experience in database design & development, modeling, migration, tuning, and administration using SQL, Views, Stored procedures, and Triggers.
• Expert in creating data dictionary, tables, packages, stored procedures, advanced queries, triggers, views, indexes, and functions for databases using SQL *PLUS, and PL/SQL.
• Exceptionally well organized with Strong Communication, Inter-personnel, Analyzing Skills, and a desire to learn new technologies and tools.
• Excellent skills in Designing and Development of applications using SQL, PL/SQL, Oracle Database 12c, 11g, 10g, 9i, 8i.
• Extensively worked in developing PLSQL packages to load the data from different sources into database, and to load data within database into different tables implementing the business logic rules.
• Experience in processing fixed length files using the Perl scripts.
• Implemented and supported various Oracle e-business suite modules (EBS): Order Management (OM), Account Payable (AP), Account Receivable (AR), General Ledger (GL), Fixed Assets (FA), Purchasing (PO), Inventory (INV), Bills of Material (BOM), Work in Progress (WIP), Shipping (WSH), Advanced Pricing, in store and AOL objects.
• Experience in technical development, Functional and maintenance of Oracle E-Business Suite R12 and 11i.
• Worked as Support Consultant and responsible for the Tickets Handling, Issue Resolution and Enhancements/Customizations to resolve the issue.
• Extensive knowledge with Mainframe COBOL and Micro Focus Visual COBOL.
• Experience in working with tools PL/SQL Developer, TOAD, Visual Studio, WinSCP, ClearCase, Kin tana, Oracle Forms & Reports 10g, BI Publisher, Oracle Workflow Builder and OEM.
• Worked with frontline business users in gathering requirements and translating, documenting them as functional designs
• Worked in creating list, crosstab, and chart reports for the NYS agencies using Cognos Report Studio.
• Developed, tested, and implemented various shell scripts using Perl and PL/SQL procedures, to facilitate the execution of jobs.
• Good experience in programs debugging, issue resolutions and providing new business solutions.
• Experience in writing triggers, packages, procedures, and functions in PL/SQL for data validations and loading.
• Strong analytical, diagnostic, and troubleshooting skills and ability to work in a fast paced and team-oriented environment.
• Excellent communication and interpersonal skills to handle the client meetings and solution discussions.

TECHNICAL SKILLS

Languages: Oracle Applications R12, PL/SQL, SQL, Mainframes, C, C++, C#.Net, ASP.Net, HTML5, CSS3, JavaScript, Micro Focus Visual Cobol, UNIX Shell Scripting, Perl Scripting, DBA (Database Administration), C#.Net (4.5/4.0/3.5/3.0 ), VB.NET (10.0).

Tools: Visual Studio, TOAD, PL/SQL Developer, Cognos 10.2 Framework Manager and Report Studio, WinSCP, APEX (Application Express), Clear Case, Kintana, Oracle Forms & Reports 9i/10g, BI Publisher, OEM, COGNOS SQL Developer, Putty, Oracle Workflow Builder, Microsoft Visual Studio for Visual Cobol 2015.

Enterprise Applications: Oracle E-Business Suite 11.5.10.2, 11.5.8, R12, Oracle SOA Suite (10g, 11g).

ERP Modules: Order Management, Account Payables, Account Receivables, Inventory, Purchasing, Bills of Materials, Shipping, Work in Progress, Advanced Pricing, iStore and AOL

Databases: Oracle 9i, Oracle 10g, Oracle 11g, Oracle 12c, MySQL, MS Access

Operating System: Windows XP/Vista, Windows 7, Windows 10, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential, NY

Sr. IT Programmer

Responsibilities:

• Develop PLSQL packages to load the data from different sources into database, and to load data within database into different tables implementing the business logic rules.
• Develop complex database objects stored procedures, functions, triggers, and SQL queries applying business logic to roll up the data into final tables in the database from which the data is extracted for the reports generation.
• Create data model, packages, query subjects and namespaces using Cognos Framework Manager.
• Develop Visual Studio Dot Net desktop application to perform all the existing A&QI application functions and in corporate additional WEP consumption functions to be used in a LIM Appeal.
• Create C#, Visual Studio desktop application to replace the current dot Net Lottery application and maintain all current functionality of the current dot Net application, all inquiry abilities of the current dot Net application, allow the ability to search the individual by CIN.
• Create Oracle tables, SQL queries and views to pull the data from database into the Dot Net application, apply the data for various functions, display lists, generate reports and update the changes made in the application into the tables.
• Develop C# Visual Studio methods and functions to upload, store and manage the appeal specific files that are currently being stored in the A & QI shared drive.
• Develop C# Visual Studio methods to modify WEP Credit amounts to ensure single use of Credit and store changes and update monthly WEP Credit amounts according to User Inputs.
• Generate Client Intercept Lookup Cognos report to make changes in the Cognos layout and package based on the requirements from A&QI program area for Lottery Intercepts conducted by the New York State Division of Lottery (NYSDOL).
• Worked extensively in generating the data extracts for several reporting purposes. Few of the reports that are using this data are FNS-583(Food and Nutrition Service), Performance Measures and Annual Plan by the department of OTDA (Office of Temporary & Disability Assistance).
• Generate Biennial Accounting Cognos Report to update the report to provide Work Experience Program (WEP) Credit amounts to comply with changes in policy requirements by updating the Cognos layout and package.
• Develop and test the data extraction programs using Mainframe COBOL and Micro Focus Visual COBOL (MF Cobol).
• Test the Cognos reports by analyzing the existing Oracle reports.
• Create and process fixed length files and production environment run books using a shell scripting tool with Perl scripting.
• Schedule and monitor the batch scripts using the Windows scheduler.
• Perform Unit Testing and Functional testing and created unit test specifications, creating test case scenarios, test cases & test Results.
• Perform unit and integrated testing of the developed application using Mainframe COBOL and Micro Focus Visual COBOL (MF Cobol).
• Work with Functional Analysts and customers to understand and validate end-user requirements in accordance with business needs.
• Monitor a 24/7 production schedule of approximately 250 jobs a month and Provide end-user support for assigned applications.
• Communicate with production control staff and resolve any operational problems.
• Create and document technical designs to achieve project requirements.

Environment: Oracle SQL Developer, Oracle Database 10g/11i/12c, SQL*Loader, Microsoft Visual Studio, ASP.NET, C#4.0, Entity Framework, XML, HTML4, CSS 3, .Net Framework 4.5, Test-Driven Development, SharePoint 2010, Office 365, Cognos 10.2 Framework Manager and Report Studio, Perl, Micro Focus COBOL 2.3, Windows XP/7.

Confidential, TX

Sr. Oracle Applications Developer

Responsibilities:

• Experience in several phases of the project like Analysis, Design & Development, Testing, Documentation of Oracle E-Business Suite(EBS) R12 applications.
• Acted as a primary developer for Implementing new interfaces for the client Confidential Inc.
• Implemented the interfaces of Oracle EBS R12 Financial Modules General Ledger, Accounts Payables, Accounts Receivables, Fixed Assets, Inventory.
• Developed PLSQL packages, stored procedures, triggers and functions for the interfaces implemented.
• Created concurrent programs, executables, value sets and lookups required for the input parameters and attached the PLSQL package files to the executables.
• Created a web service in Oracle for the third-party system to transfer data to Oracle by invoking the WADL link generated as part of Inbound interface development.
• Troubleshooted and fixed the issues identified during the testing and support phases for all the interfaces.
• Experience in Integrating Oracle Applications ERP and Importing Data from various legacy systems into Oracle Applications using PL/SQL, SQL*Loader, SQL Plus, UTL FILE and other tools
• Responsible for writing data conversion routines (APIs, Open Interfaces) to load data information from legacy system to Oracle Apps.
• Developed, tested and implemented various batch scripts, scheduled them through the Tivoli workload scheduler.
• Used JIRA tool for bug tracking, issue tracking and status updates.
• Worked on auto generating the batch scripts using PERL.
• Migrating the objects developed from one instance to another instance in the form of LDT files.
• Analyze data quality and report the anomalies to business users using TOAD, PLSQL Developer tools.
• Worked extensively in resolving issues by creating Oracle Service Requests (SRs) and obtaining one of the solutions using Oracle Support/METALINK
• Extensive experience in Unit Testing, System Testing and Integration Testing and developed and executed Test Cases based on the requirement documents.
• Extensive experience in working with both Inbound and Outbound Interfaces.
• Preparation of Technical Design Documents (MD070), installation documents (MD120), test case documents and code development and support for RICE components.
• Involved in developing unit test specifications, creating test case scenarios, test cases & test Results

Environment: Oracle Applications 12.1.3, Oracle SQL Developer, Cognos Framework Manager and Report Studio, Perl, Micro Focus COBOL, Oracle Database 10g, SQL*Loader, JIRA, Putty, WinSCP, Report Builder 10g

Confidential, IL

Sr. Oracle Apps Techno Functional Consultant

Responsibilities:

• Involved in implementing and supporting Oracle Supply Chain Management and Financials Modules: Order Management, Account Receivables (AR), Account Payables (AP), General Ledger (GL) and Fixed Assets (FA).
• Worked as a Team Leader for the support Team and played a vital role in managing team members with the deliverables
• Troubleshooted and fixed the issues in Order management application - Order import, export compliance holds, Pricing, Return Material Authorization issues, sales order workflow issues
• Acted as a primary developer for Implementing break fix /enhancement and new components/reports for the client.
• Enhanced project resolution rate by an average of weekly 10-15 issues reported with a 90% success rate.
• Involved in coordinating between onsite business analysts and offshore support teams.
• Awarded with the ‘On the spot’ award and Best appreciation from the client for the additional effort on developing a concurrent program for a repetitive issue which reduced the time of repetition work by ¾.
• Used FND Loader Utility to download and upload the LDT files from one instance another instance.
• Performed ACMP tool conversions, Setups of AOL Objects, Key and Descriptive Flex fields and various modules
• Functional knowledge of advanced pricing, order management, Quote to Order Process, Shipping, inventory, Purchasing, bills of materials, Quality
• Experience in system cloning activities, providing patch analysis, concurrent manager load balancing and integration between Oracle R12 and touch point systems.
• Worked on Order management, Order fulfillment, Pricing, Defaulting rules and Processing constraints.
• Experience in creating new custom responsibilities and roles which are required for developers
• Responsible for assigning custom concurrent managers and adding concurrent jobs not found to the request group
• Involved in execution of different Test Scenarios and identified gaps in design and development.
• Involved in code migration between instances and migrating the objects developed from one instance to another instance in the form of LDT files.
• Interacted with multiple sources to complete handshaking activities for the full cycle components tested.
• Identifying reusability/Changes in existing integrations flow from Payables to Downstream Systems and highlight gaps if any by working closely with related teams.
• To create a change order based on the changes in the Purchase order from Sanmina.
• To send shipment and Invoice details.
• Inbound to perform Item Issue out
• Developed program to perform Item On-hand conversion
• Developed common code for effective validations which can be used in several packages required.