Lead Integration Consultant Resume
2.00/5 (Submit Your Rating)
Fort Mills, SC
SUMMARY
- He is a Oracle EBS consultant has over 20 years of experience in R12 Oracle Financials (AP, AR, PO, FA, PA and GL) modules by thoroughly following AIM and SDLC methodology in IT Industries.
- He has experience in design, development and delivery of Tax Solutions on Oracle ERP R11, R12 EB Tax and Fusion Cloud platform Oracle modules.
- He has extensive experience in management reports, regulatory filings, regulatory surveillance results and regulatory examination reports to pre - sales teams for Financials and Pharmaceutical Industry
- He has experience in supporting end-to-end processes for: Order to Cash (O2C) and Procure to Pay (P2P) reporting improvements.
- He has been working in Oracle Cloud Financial modules including SaaS, PaaS and I aaS by throughly following SDLC methodology
- He was responsible for Implementation of Procure to Pay (P2P) and Order to Cash (O2C) Business Processes.
- He is in Philadelphia, PA and willing to relocate to client location and available to start immediately
TECHNICAL SKILLS
- R12 Oracle Financials, Project Accounting, CRM modules
- End-to-End processes for Order to Cash (O2C) and Procure to Pay (P2P) reporting
- Oracle ERP R11, R12 EB Tax, Confidential Tax Engine
- Fusion R13 Cloud platform Oracle modules(AP, PO, AR, GL, FAH, OTL and PA) 19C
- SaaS, PaaS, FBDI, REST, SOAP APIs, VBCS, ODI and Oracle Integration Services
PROFESSIONAL EXPERIENCE
Confidential, Fort Mills, SC
Lead Integration Consultant
Responsibilities:
- Gathered requirements by facilitating JAD sessions among multiple teams for Data mapping and Reporting and documented.
- Architected the Process/Integration touch points using Oracle VBCS Techstack for Oracle API’s and FBDI
- Converted AR Open invoices and Receipts from Oracle EBS to the Oracle Cloud application.
- Converted Open Purchase Orders from Oracle EBS to the Oracle Cloud application.
- Converted AP Open invoices from Oracle EBS to the Oracle Cloud application.
- Created OTBI reports and outbound interfaces in Supply Chain Planning, Demand Management, Supply and Distribution Planning.
- Helped business to run Test Cases and conducted SIT and UAT with business.
- Working on building an interface for new Contracts and Amendments in Subscription Management.
- Built interface for AR invoices from endpoint systems to Oracle AR utilizing REST API.
- Built interface for AP invoices from endpoint system to Oracle AP utilizing REST API.
- Participated in SIT along with multiple teams and coordinated in resolving bug fixes and issues in timely manner.
Confidential, Owings Mills, MD
Lead Integration Architect / Project Manager
Responsibilities:
- Built high level architectural design to Integrate Federal Health Care customers billing details from FACETS System to Oracle Cloud Financials(PaaS) Accounting Hub.
- Blueprinting and designing the FAH based solution that is required to be rolled out to meet the client requirements.
- Design of the event model, line types and mapping sets that would pertain to the FAH based solution.
- Articulated the assembly and integration test plans that would be essential to roll out the FAH based solution to meet the complete gamut of user requirements.
- Design of a comprehensive and integrated reconciliation module to meet the typical needs of business.
- Configured FAH to bring multiple streams to process into GL. performed unit and integration testing; Conducted CRP, UAT and coordinated to deploy code into Production environment.
- Facilitated JAD sessions among multiple teams for Data mapping, Accounts derivation rules and Reporting requirements.
- Architected the Process/Integration touch points using Oracle Fusion Middleware Techstack using Oracle API’s and FBDI).
- Converted AR Open invoices and Receipts from Oracle EBS to the Oracle Cloud application.
- Converted Open Purchase Orders from Oracle EBS to the Oracle Cloud application.
- Converted AP Open invoices from Oracle EBS to the Oracle Cloud application
- Built interface for Time entry from Amdocs to OTL.
- Built interface for Project contracts from Amdocs to Oracle Projects.
- Built interface for AR invoices from DIMS to Oracle AR utilizing REST API.
- Built interface for AP invoices from DIMS EDI to Oracle AP utilizing REST API.
- Provided integration solutions for new FAH processes in accordance with agreed architectural designs and provided development guidance to technical team.
- Developed OTBI reports & BI scheduling; Worked with Oracle through SR’s for product defects/bugs.
- Documented Functional Design MD50 documents for Integration and XML Publisher report needs.
- Coordinated development and testing activities between multiple teams including on-site/off-shore.
Confidential, Charleston, SC
Director Technology Services
Responsibilities:
- Helped building strategic roadmap for Enterprise Business Systems and Business Intelligence applications; Aligned Global and Business teams to oversee projects successful execution.
- Completed business analysis of the client’s current business processes.
- Gathered requirements related to the proposed business practices.
- Guided and directed a team of consultants to set up the solution design and configure the entire set of Oracle Fusion specific core finance (PaaS) modules (AP, AR, GL and FA) across CRP1, CRP2, SIT, UAT and PROD instances.
- Designed and developed inbound and outbound interfaces in Supply Chain Planning, Demand Management, Supply and Distribution Planning applications.
- Prepared Functional Specification (MD50) document for a number of inbound and outbound interfaces.
- Directed a team of consultants to prepare all data points for regression testing of all inbound and outbound interfaces.
- Charted out detailed plans for regression testing of each interface and monitoring the execution thereof to ensure that the results conform to the specifications laid out in the respective design documents.
- Undertook detailed regression testing on all of the core financial modules to ensure that all of the seeded functional flows operate to the complete satisfaction of the end user community and all aberrations are aberrations are resolved or mitigated within the shortest possible time.
- Logged Service Requests with Confidential on all issues that demand immediate attention as well as on all enhancement related issues.
- Conducted unit and integration tests to ensure that the configured solution operates to the satisfaction of the end users.
- Prepared detailed User Productivity Kits (UPKs) on all domains and modules that warrant user training.
- Set up detailed user training sessions and addressing all queries to the satisfaction of all end users.
- Provided functional and technical production support to ensure the quality and timeliness of project deliverables
- Coordinated with offshore teams to ensure project cohesiveness and timely deliverables.
Confidential, Richfield, MN
Oracle and BI Applications
Responsibilities:
- This is Oracle ERP R12 upgrade project. As part of this project I was responsible for Oracle, Financials and Confidential customizations upgrade.
- Prepared upgrade strategy for custom objects, reports and Confidential tools.
- The team consisted of vendors and internal FTE resources. Worked with stakeholders to create user stories, use cases, technical and functional specifications with UI mockups.
- Initiated technical direction for Oracle Financials modules and Confidential upgrade.
- Lead, direct and coordinate all project management activities of this upgrade project including off-shore team.
Confidential, Berwyn, PA
Sr. Technical Solutions Manager
Responsibilities:
- Built roadmap and initiated technical direction for design, development and delivery of Tax Solutions on Oracle ERP R11, R12 EB Tax and Fusion platform Oracle modules.
- Configured and set up R12 Oracle Financials (AP, AR and GL) modules by thoroughly following AIM and SDLC methodology.
- Architected and designed scalable EDI Application solution to file Confidential customer’s tax returns which spawned as a new business unit generated additional $12M revenue.
- Managed all phases of Confidential /ERP software implementations including Concurrent programs by adhering to Oracle AIM and Confidential ’s best practice methodologies.
- Implemented sub ledger accounting (SLA) both for AP and AR, and setting up such event types, journal line definitions and application accounting definitions as are warranted in the circumstances.
- Implemented e- business tax to cater to the specific needs of both of AP and AR. This involved setting up of such tax regimes, tax jurisdictions, tax statuses and tax rates as are appropriate in the circumstances.
- Implemented Oracle CM. This involved setting up of the auto reconciliation feature in CM by leveraging the bank statement open interface.
- Assisted in the determination of an optimum conversion strategy keeping in mind the requirements imposed by the regulatory authorities.
- Participated in the development of design documents, including reviews to ensure proper translation of business functions into technical functions.
- Monitored, tracked and reviewed trouble tickets to ensure the smooth conduct and administration of Finance department’s day to day operations.
- Provided functional and technical production support to ensure the quality and timeliness of project deliverables.
- Coordinated with offshore teams to ensure project cohesiveness
- Devised resolutions for customization and all product enhancements.
- Trained users and ensured smooth and efficient day to day conduct and administration of business.
Confidential, Pittsburgh, PA
Lead EBS Consultant
Responsibilities:
- Converted MS SQL Server based Financial Data Warehouse onto Oracle based Global Data Warehouse star schema table data mapping and loading process.
- Collaborated with cross-functional teams to deliver a $25M Global Profitability solution - Project SMART.
- Built and implemented product margin system for Reynolds Food Packaging ($100M revenue) that improved management’s effectiveness, resulting in annual savings of $200K.
- Converted Financial Data Warehouse into Global Data Warehouse managing teams globally.
- Led the software design process for all elements of the system (source systems analysis, interface / ETL, logical and physical data base design, reporting solutions)
- Worked with EBS team to ensure next generation ETL architecture to meet data integration requirements for downstream reporting by both internal Confidential users and external Partners.
- Inducted into Center Of Excellence team to resolve DW and BI technological and platform related issues and shared product enhancement requests and features to Oracle.
- Worked on Item Master conversion in Oracle Order Management module.
- Worked with project team to validate scope and requirements for incremental releases of existing reports and a planned sunset of legacy reports in favor of a self-service approach.
- Involved in Discoverer 4.1.48 to 10g upgrade, Oracle RAC implementation and Oracle Applications 11.5.8 to 11.5.10 upgrade projects by thoroughly following AIM and SDLC methodology.
- Provided Production Support and Maintenance for Global Data Warehouse and Change Control systems management.
- Helped European and Australian teams in providing reporting solution for RDW.
- Managed a dozen offshore Business Intelligence development and support Team from India.
Confidential, Atlanta, GA
EBS Technical Lead
Responsibilities:
- Led a team of 7 developers and analysts to implement Epic applications for ASH Inc.
- Directed in capturing requirements, architecture, design and implementation of Epic application, resulting in an estimated annual savings of more than $500K.
- Spearheaded integration design, serving as a liaison between the application development, Database administration and infrastructure teams and the business partners in establishing Epic architecture standards.
- Collaborated with project architects for Health Medicaid to remediate the existing MMIS to comply with new HIPAA standards.
- Ensured continuity of on-going operations while developing new HIPAA EDI transactions.
- Brought legacy EDI like provider claims and remittance advices to comply with new HIPAA standards.
- Worked with software vendor Sterling Commerce to resolve HIPAA compliance issues.
- Provided technical support for AHS User groups on EDI applications.
Confidential, Redwood Shores, CA
Principal Consultant
Responsibilities:
- Oversaw multiple product development streams across multiple organizations, which are geographically dispersed, and the core product team.
- Evaluated business requirements, technical solutions, architecture and cross-functional organizational requirements to deliver an industry leading solution while managing multiple priorities within demanding environment.
- Built and executed development and staffing plans across multiple projects and revised, as necessary, to meet changing business and client needs.
- Provided management reports, regulatory filings, regulatory surveillance results and regulatory examination reports to pre-sales teams for Pharmaceutical and Biotechnology Industry.
- Designed and developed EDI application solution by gathering requirements by facilitating user group meetings and workshops.
- Converted legacy system data into Oracle AR, AP, PO, HR and Payroll modules.
- Configured Oracle Financials (AP, AR and GL) modules by following SDLC methodology.
- Responsible for completion of the AIM deliverables Train users to use new requisitions and purchase orders in Oracle Purchasing.
- Implementation of Oracle AP, AR, GL, PO modules, Human Resources Application 11.02
- Customized and implemented Advanced Benefits and Payroll module.
Confidential, Milwaukee, WI
EBS Consultant
Responsibilities:
- Mapped EDI to convert current data formats from legacy financial system to Oracle Financials for Confidential Company.
- Gathered system requirements, performed analysis and wrote system specifications.
- Mapped and executed HIPAA certification program for (837 claims), to bring healthcare providers, clearing houses, and practice software vendors into Oracle Financials.
- Maintained rigorous provider testing schedule, tracking compliance of HIPAA 837 claim submissions to meet ANSI X12 as well as Confidential business requirements.
- Loaded data using Concurrent Programs to AR, AP Interface tables and GL Interface tables by following AIM and SDLC methodology.
- Helped sales team in preparing product demo and SOW on EBS interfaces.
- Post implementation technical support to multiple customers on EBS modules.