Lead Oracle Ebs Analyst Resume
3.00/5 (Submit Your Rating)
Denver, ColoradO
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 theOracle Suite of Products.
- Extensive experience in supply chain using EBS and Retek logistics.
- 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.
- Extensive experience in Oracle Financials 10.7, 11.0.3,11.0.9, 11.0.10, 12.0.6,12.1.3
- 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.
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 time 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.
- Tested Database upgrade from 10g to 11g.
- Tested 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 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.
- 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.
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.
Confidential
Oracle EBS Developer
Responsibilities:
- Developed packaged procedures to incorporate 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.
Confidential
Lead 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
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 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 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
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.
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.