SUMMARY

• Over 10 Years of experience as Oracle EBS Developer, PL/SQL Developer, 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 theOracle Suite of Products.
• Extensive experience in supply chain using EBS and Confidential .
• Strong experience in performance tuning and query optimization using tools likeTK - Prof.
• Extensive knowledge ofNormalizationandDatabase DesignConcepts.
• Strong experience in developing complex Stored Procedures, Functions, Triggers, Views, Cursors, Joins and Sub queries withORACLE SQL.
• Extensive experience in designing, developing and deploying Oracle packages, XML Reports on Oracle EBS.
• Expert in performingETLoperations Informatica and Bulk Insert.
• Experience in developing technical documentation forOracle EBS, ETL's andBIreporting based on functional documents and support transition documentation.
• Sound knowledge ofsoftware 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 creatingParameterized 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.

TECHNICAL SKILLS

Development tools used: Oracle Forms, PL/SQL procedures, Functions

Reporting tools used: BI Publisher( XML Publisher) XL templates, RTF templates, Data template, XML Publisher super userOracle Reports.

Scripting languages: Unix shell script for promotion of reports, procedures and forms.

Programming languages used: PL/SQL, PRO*C forOracle Packages, Procedures, Functions, Triggers, Tables, Indexes.

Databases Used: Oracle RDBMS 10g, 11g,DB2 for Databases objects, Synonyms, Indexes.

Operating Systems used: Unix, Linux, Vax VMS and Windows.

Tools: of Database: Toad, SQL Developer

Workflows Manager: Workflow creations and modification.

Alert Manager: Alerts creation and enable and disable.

Data Load tools used: SQL*Loader Loading of data using Control files, More4Apps

ETL tools used: Informatica and Business Objects Creation of mappings, maplets, lookups, libraries.

Platforms used: Windows, Unix, Linux, Sun Solaris, Vax VMS

PROFESSIONAL EXPERIENCE

Confidential

Lead Oracle EBS Analyst

Responsibilities:

• Responsible for showing correct stock online on windmobile.ca, down load of Dealer / customer orders to Oracle EBS, Ship confirmation to the dealers / customers and posting of invoices.
• Maintained all monthly invoices generations and emailing them to customers.
• Monitored all Orders placed through customer service were downloaded and processed. All error orders were fixed and reprocessed which were times critical.
• Managed inventory adjustments of cell phones and accessories over 100 files in a day.
• 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.
• Created packages, Procedures and functions, Workflows and reports and interfaces.
• Maintained all old code and upgraded the code.
• Involved in testing Database upgrade from 10g to 11g.
• Involved in application upgrade from 12.0.6 to 12.1.3.
• Created scripts for ADP journal loading into Journal ledger.
• Updated EDI note with additional columns to BMO on pay advises.
• Resolved service requests of user departments PO, OM, SO, FA and Cash Management.
• Resolved production support issues on day to day basis.
• Involved in testing of shell scripts conversion from UNIX to Linux migration.
• Expert in editing files on word express and uploading to the portals.
• Used share point to share files like documentation, project plan.
• Extensive integration with supply chain interaction with corporate office and suppliers, dealers and customers.
• Lead a team of 3 developers.

Environment: Oracle EBS 12.1.3, Oracle SQL, PL/SQL code in Procedures, Packages and Functions, Oracle 11g, XML Publisher, UNIX Schell scripts, 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 back end 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.

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

Confidential, St. John’s, NL

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 receipt 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.

Environment: Java, Oracle PL/SQL Developer, Oracle Discoverer, Oracle EBS 11i EBS, XML Publisher, Oracle reports, Oracle 10g, UNIX and Windows NT

Confidential

Developer, Business Intelligence

Responsibilities:

• Managed all vendor supplied resources and permanent staff.
• Verified that mappings meets 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 Functionalityof requirement
• Reviewed functional and technical documentation ofmappingsScopes, 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

Environment: FinancialApplications, MS Project,Business Objects Data Integrator 9.2, Oracle9I, PL/SQL, Informatica, Cognos, UNIX and Windows NT.

Confidential

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

Responsibilities:

• Developed project estimation, planning and execution.
• Preparedrequirement specification for the 311 integration.
• Preparedthe functional design, Technical design.
• Developedcode for the integration.
• Developedtest plans.
• Testedthe code based on the test data.
• Refreshedthe environment and test all code.
• Migratedto production environment.
• Monitored technical testing for Terra data based supply chain System.
• Executed test cases for the Terra data based supply chain system that uses 128-bit SSL data encryption, currently the highest commercially used data encryption algorithm.
• Verified application modules are developedinaccordanceto 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

Environment: MS Project,Hansen Work Management 7.7 based on Oracle 9i, PL/SQL,Windows NT MPRAS 3.1.2 Supply chain system based on Terra 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 tableusing 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.

Environment: OracleFinancials 11I 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, OMmodules and integrated them with applications.
• Set up OracleInventoryand 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.

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

Confidential

Programmer Analyst

Responsibilities:

• Involved in the in corporation of VAT Tax in AP, AR, GL and FA module.
• Worked extensively in developing customized reports based on the client requirement in GL AP and AR modules and integrated them with applications.
• Wrote Technical Documents (TDS) for various custom reports and outbound interfaces developed in FA and AR modules.
• Involved in writing SQL* LDR scripts and SQL tuning of PL/SQL packages.

Environment: Oracle Financials EBS 11.5.9, Oracle 8I, PL/SQL, Windows NT, UNIX and Toad.

Confidential, Cincinnati, OH

Programmer Analyst

Responsibilities:

• Customized all forms and reports to the clients requirements.
• Incorporated business rules in the packaged procedures.
• Created new procedures and functions.
• Tested forms, procedures, functions and packages.
• Created test cases and did end to end testing for all the above programs.
• Modified all programs to support Retek RDM 10.0 in terms of field.
• Customized to Walmart.com to customer.

Environment: Retek RDM 9.2, Oracle 8I, PL/SQL, Windows NT, UNIX and Toad.