SUMMARY:

• Over 10 Years of experience as Oracle EBS Developer , PL/SQL Developer, BI/XML Publisher Developer .
• Experience in creating functional design (MD70) and technical design (MD50) documents creation.
• Experience in Analysis, Design, Architecture and Development of Software Applications, Business Intelligence projects in the Oracle Suit e of Products.
• Extensive experience in supply chain using EBS and Retek logistics.
• Extensive experience in Oracle Financials 10.6, 11.0.3,11.0.9, 11.0.10, 12.0.6,12.1.3,12.2.3
• Extensive experience in designing, developing and deploying Oracle packages, XML Reports on Oracle EBS.
• Strong experience in developing complex Stored Procedures, Functions, Triggers, Views, Cursors, Joins and Sub queries with ORACLE SQL .
• Strong experience in performance tuning and query optimization using tools like TK - Prof .
• Extensive knowledge of OLAP, OLTP, Normalization and Database Design Concepts.
• Expert in performing ETL operations Informatica and Bulk Insert .
• Experience in developing technical documentation for Oracle EBS, ETL' s and BI reporting based on functional documents and support transition documentation.
• Sound knowledge of software development life cycle (SDLC) with substantial experience with object-oriented analysis and design methodologies.
• Working Experience in designing, implementing, maintaining, and documenting complex database applications, and data warehouse in financial environments
• Flexible, enthusiastic and project-oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.
• Expert in creating Parameterized Reports.
• Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.
• Strong inclination for finishing job before the project deadline.
• Expert skill Pro*C created user exits for Oracle Form 2.3, 4.5.

PROFESSIONAL EXPERIENCE:

Confidential

Oracle EBS Apps Technical Consultant

Responsibilities:

• Worked on Oracle EBS 12.1.3 Version.
• Helped to identify the fields need to be scrambled in PO, INV, OM, GL, AP,AR on the functional design document MD 50.
• Developed database PL/SQL stored procedures to update base table data for PO, INV, OM, GL, AP,AR for scrambling data.
• Developed Data Loader program for FND USERS DISABLE.ddl for disabling all users.

Used: Oracle APPS EBS 12.1.3, Oracle SQL, PL/SQL code in Procedures, Packages and Functions, Oracle 11g, BI Publisher.

Confidential

Oracle EBS Technical Consultant

Responsibilities:

• Worked on Oracle EBS Applications 12.1.3 Cloud/RAC version.
• Coordinated with Oracle Support and Oracle Managed services.
• Implemented in PROD, QA, DEV 12c upgrade of the Oracle Apps Database from 11g.
• Resolved Production issues.
• Developed several reports in BI Publisher for AP and GL.
• Created PL/SQL code to insert and update the base tables for all changed done.
• Created service requests for all bug related issues.
• Resolved Production issues of Oracle EBS Applications.
• Developed Unix shell scripts for promotion into production.
• Supported in resolving tickets.
• Created templates in WebADI for Journals, Invoices.

Used: Oracle EBS Applications 12.1.3, SQL, PL/SQL code in Procedures, Packages and Functions, Oracle 10g, Schell scripts and WebADI.

Confidential, Cranston, RI

Oracle EBS Application Consultant

Responsibilities:

• Worked on Oracle cloud EBS Applications 12.2.3 Cloud/RAC version.
• Coordinated with Oracle Support and Oracle Managed services.
• Installed OBIEE and setup OBIEE on DEV and QA.
• Developed new OBIEE reports using the Discoverer reports.
• Developed new Crystal report for Check free and Cyber shift applications.
• Created service requests for all bug related issues.
• Developed Oracle Projects costing report, Developed Average balances report for Audit using period end balance to date.
• Provided Production support for Oracle EBS Applications for clearing database locks, code dumps and Invalid sessions.
• Supported in resolving tickets.

Used: Oracle EBS 12.2.3, Oracle SQL, OTC, PL/SQL code in Procedures, Packages and Functions, Oracle 11g, OBIEE/XML Publisher, UNIX Schell scripts, Share point, Data Load, Crystal Reports, Discoverer, OBIEE and Windows NT.

Confidential

Oracle Developer

Responsibilities:

• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, SQL Developer.
• Designed and Developed Triggers and Packages using PL/SQL
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines
• Document and communicate changes to the OLTP, OLAP systems and data warehouse teams, including Data Modeling, Database teams
• Developed new forms in Forms 11i.
• Maintained old forms in Forms 10g, 4.5
• Fixed all bugs of the forms and reports.
• Developed PL/SQL stored procedures for back end data retrieval and posting the changes.

Used: Oracle SQL, PL/SQL code in Procedures, Packages and Functions and Oracle 11g, Oracle Forms 10g, Oracle 4.5 forms.

Confidential

Lead Oracle EBS Analyst

Responsibilities:

• Created functional design (MD70), technical design (MD 50) and user documentation for the customized applications development.
• Developed and Designed new Data Models, Data sets and Templates / sub templates on XML Publisher (BI Publisher) for Bank Reconciliation, Amortization report, Orders on hold and several other reports in Account Payables, Purchase Orders and Order Management.
• Developed packages, Procedures and functions, Workflows and reports and interfaces.
• Maintained all old code and upgraded the code.
• Tested Database upgrade from Oracle RDBMS 10g to 11g.
• Tested application upgrade from Oracle EBS Applications 12.0.6 to 12.1.3.
• Developed scripts for ADP journal loading into Journal ledger.
• Updated EDI note with additional columns to BMO bank on pay advises.
• Resolved service requests of user departments AP, AR, PO creation and Tracking, OM, P2P, O2C, SO, FA and Cash Management.
• Resolved production support issues on day to day basis.
• Tested of shell scripts converted from UNIX to Linux migration.
• Extensive integration with supply chain interaction with corporate office and suppliers, dealers and customers.
• Lead a team of 3 developers.
• Supported in resolving tickets.
• Implemented R12.1.3

Used: Oracle EBS 12.1.3, SCM, AP, AR, PO, P2P, O2C, SO, FA, Oracle SQL, PL/SQL code in Procedures, Packages and Functions, Oracle 11g, OBIEE/XML Publisher, UNIX Schell scripts, Share point, WebADI and Windows NT.

Confidential

Lead Oracle Developer

Responsibilities:

• Analyzed requirements and design logical and physical databases using Erwin for OLTP and OLAP.
• Created technical design document for all new programs assigned to my group.
• Verify existing ER diagrams, physical design and prepare gap analysis. Prepare ETL mappings.
• Worked on Java based front end forms and executed back end procedures.
• Developed several DDL, DML script in MS SQL for Emergency room wait times, Surgery Unit and SETP.
• Validated the ETL mappings output with the backend MS SQL outputs.
• Created the PL/SQL code for Wait times, Emergency Room and ATC.
• Developed test scripts for the Business Intelligence reports validation.
• Lead a team of 5 developers.

Used: MS SQL, Java, Oracle SQL, Oracle 10g, UNIX Schell scripts, and Windows NT,OLAP, OLTP,ERWIN, Informatica, HP Quality Centre, ZERA for Bugs.

Confidential

Oracle EBS Developer

Responsibilities:

• Developed packaged procedures to in corporate new logic.
• Developed and tested new materialized views in Oracle Discoverer for GL, AP and AR.
• Maintained customized tax PL/SQL programs for AR and OM.
• Developed RTF templates for XML Publisher.
• Enhancement of RX seeded report of receipts. pt register Document sequence number.
• System Administrator for Discoverer related issues as a second level.
• Liaise with Oracle support through Meta link in resolving the TAR issues.
• Updated documentation of the changed code and saved in Visual source safe.

Used: Java, Oracle PL/SQL Developer, Oracle Discoverer, Oracle Financials 11.0.3, 11.0.9 EBS, XML Publisher, Oracle reports, Oracle 10g, UNIX and Windows NT

Confidential

Lead Developer, Business Intelligence

Responsibilities:

• Managed all vendor supplied resources and permanent staff.
• Verified that mappings meet the Business requirements, User needs and Specifications
• Analyzed project documents to identify requirements in order to extract the conditions to be develop
• Reviewed mappings that covered Functionality of requirement
• Reviewed functional and technical documentation of mappings Scopes, development, implementation
• Tested to see that the mappings able to deliver expected results.
• Interact with Business Analyst in order to pin point problems and solve them
• Communicate project status and issues to the Project stackers.
• Develop and manage BI ETL process, architecture, cubes and complex matrix and relational reports; Enhance/Tune SQL Server’s BI tools performance (Analysis Services/Cubes and Reporting services)
• Effectively communicate organizational information to staff

Used: Financial Applications, MS Project, Business Objects Data Integrator 9.2, Oracle 9I, PL/SQL, Cognos, UNIX and Windows NT.

Confidential

I.T. Project Lead / Specialist, Business Intelligence / Data Warehouse

Responsibilities:

• Developed project estimation, planning and execution.
• Prepared requirement specification for the 311 integrations.
• Prepared the functional design, Technical design.
• Developed code for the integration.
• Developed test plans.
• Tested the code based on the test data.
• Refreshed the environment and test all code.
• Migrated to production environment.
• Monitored technical testing for Tera data-based supply chain System.
• Executed test cases for the Tera data-based supply chain system that uses 128-bit SSL data encryption, currently the highest commercially used data encryption algorithm.
• Verified application modules are developed in accordance to functional specifications
• Worked closely with Business users, Business Analysts and Technical Writers on clarifying business requirements and documenting applications functionality
• Participated in design review meetings to understand and improve technical and functional systems specifications
• Lead a team of 8 onsite, 3 off-shore

Used: MS Project, Hansen Work Management 7.7 based on Oracle 9i, PL/SQL, Windows NT, MPRAS 3.1.2 Supply chain system based on Tera data, UNIX, Linux, MPRAS 3.1.2, MPRAS 3.2.2.

Confidential, Denver, Colorado

Project Lead

Responsibilities:

• Tested all functional and technical specifications against the requirements for developing customized reports and forms in GL INV, PO, OM modules and integrated them with other applications.
• Created Concurrent programs to add new Suppliers and update existing supplier’s data.
• Developed PO Requisition Interface based on Functional design from flat file to PO Interface table using different validations like verifying vendor Id, charge account, code combination Id, Unit of Measure and prepare. Validation is performed using SQL * Loader, validation Procedure, and if any errors occurred can be validated in Error Tables.
• Wrote Technical Documents (TDS) for various custom reports and outbound interfaces developed in FA and AR modules.
• Worked extensively with User Acceptance Testing and developed Unit Test Documents (UTD) for most of the PL/SQL packages developed for conversion process in FA and various custom reports in GL PO and OM.
• Developed SQL* LDR scripts and did SQL tuning of PL/SQL packages.

Used: Oracle Financials 11.0.3, based on Oracle 9i, Oracle Financials 11I, PL/SQL, Windows NT, UNIX and Toad.

Confidential

Technical Consultant

Responsibilities:

• Involved in the migration of Insurance legacy data into Oracle GL module. Developed various PL/SQL packages for data validation for the conversion process. Also, involved in reconciliation of GL data with legacy system.
• Developed Outbound interfaces for extracting data from Oracle GL to Data warehousing systems for the access of the data from end users.
• Wrote shell scripts for the outbound interfaces in GL and registered them as concurrent programs and executed them successfully.
• Worked extensively in developing customized reports based on the client requirement in GL AR, INV, PO, OM modules and integrated them with applications.
• Set up Oracle Inventory and interfaced with the custom developed order entry system.
• Set up of item, UOM, ATP rules, Work calendar and other set up issue.
• Wrote Technical Documents (TDS) for various custom reports and outbound interfaces developed in FA and AR modules.
• Worked extensively with User Acceptance Testing and developed Unit Test Documents (UTD) for most of the PL/SQL packages developed for conversion process in FA and various custom reports in GL AP and AR.
• Involved in writing SQL* LDR scripts and SQL tuning of PL/SQL packages.

Uses: Oracle Financials EBS 10.7, Oracle 9I, Oracle Forms 6i, PL/SQL, PRO*C, Windows NT, UNIX and Toad.