Project Lead/ Solution Architect Consultant Resume
Boston, MA
SUMMARY
- Over 20 years of domestic and international work experience in IT and 15 years in Oracle applications (11i and R12) as Functional, Techno - Functional, Solution Architect and Project lead and Functional and Delivery Lead Consultant in providing Solutions, Delivery, Management, Support and implementation.
- An accomplished professional wif relevant multifunctional expertise across ERP implementation and client management.
- Currently designated as ERP Project and Functional Lead/ Solution Architect Consultant - Enterprise Solutions at Wipro wif Wide exposure in global execution & delivery model wif clients in APAC, EMEA, US and India both at onsite and offshore.
- Proven expertise in Oracle Finance modules, iExpense and Oracle Projects. Design and work around solutions for various business requirements
- Experienced in Solution, interfacing and addressing queries raised by clients/customers/Business users and ensuring satisfactory resolution and customer delight
- Experience in leading teams at onsite/offshore, Supporting UAT and post production.
- Experience in process improvements, conducting CRP session, Issue Resolution and Fit Gap analysis, Resource allocation, Project Cutover planning’s, Real time integration wif external business systems and Project deliverable.
- Successfully handled end to end implementation cycles from Discovery, Business Process Analysis, Process Redesign, Gap Analysis, solution, Configuration and testing. Implementation specifically in teh High tech, Distribution, Bank, and Discrete manufacturing vertical for Fortune 500 companies
- Expert level knowledge in Oracle Financials, Oracle Projects and iExpense
- Good Knowledge on Financial integration modules like Purchasing, Inventory, Order Management, BOM, WIP, Oracle Grants, Contract, Time and Labor and Service modules
- Vast experience in multi country implementations, support, rollouts, deliverables and upgrades.
- Expertise in Requirement Analysis, Business Process Mapping, Business Process Analysis, Feature requirement analysis, Gap Analysis, Requirements elicitation, Business Impact analysis, As-Is Process Mapping, To Be Process Mapping, Problem simulation, Application Implementation, Integration Testing, System Testing, User Acceptance testing, Documentation, Production Support, Troubleshooting, Co-ordination wif Oracle for Issue resolution. Custom solution designing. Coordination wif Business Leads like Finance Director and other module specific Leads.
- Experienced Project Lead, which included Team Management, Mentoring, Competency Development as well as Billing and Financial activities for teh team.
- Rich experience of working at international client sites in countries like USA, Europe and India in handling multi-cultural teams.
- Experienced in QA Test Management, developing test strategy, test plan, implementing, testing, managing defects, troubleshooting and tracking all test deliverables.
TECHNICAL SKILLS
Oracle EBS: Oracle R12, 11i, 11.5.10.2 and Toad
Oracle Application Finance Modules: Oracle Receivables (AR), Payables (AP), General Ledger (GL), Cash Management (CE), Fixed Assets (FA), Trade Management (OZF), SLA Concepts, EB Tax, Noetix, HyperionAGIS (Intercompany), Projects (PA), Oracle Grants (GMS), iExpense, Report Manager, Vertex and Mark view Oracle Application Operations Modules Oracle Purchasing (PO), Inventory (INV), Costing (CST) Order Management (OM), OTM, CRM applications. Quote, Service, Costing, Oracle Sales and Marketing, WMS
Oracle Application: Manufacturing BOM and WIP
Oracle Application Foundation Modules: AOL and SYSADMIN
OS Environment: LINUX, UNIX, HP-UX, AIX, LINUX, Sun® Solaris
AIM Methodology: CV10, CV60, TE40, BR100 BR110, MD50, BR10, BR030
Oracle EBS: Phases UAT, SIT, Project GO-NO Go, Oracle SR resolution
PROFESSIONAL EXPERIENCE
Project Lead/ Solution Architect Consultant
Confidential, Boston, MA
Responsibilities:
- As a Functional Lead Responsible for Project Delivery, Status Reporting, Project Tracking and Risk mitigation
- Design and Solution for Oracle R12 implementation for Multiple OU and GL Ledger for Confidential across Countries which halped to reduce teh operation costs.
- Manage teh resource allocation and task allocation based out of multi locations. POC demo to IT and Business Leads across teh world for a global solution for Confidential .
- Design and configure of teh instance, creating BR100 and migration of setups to other instances. Design and plan to multiple Instances for QA, UA and development instances
- Interaction wif Business team leads across teh globe for new global solutions.
- Responsible for Project Initiation, Configuration setups, conducting CRP sessions, Sign off from business
- Responsible for Project Deliverables, Project plan, status, Stage gate and project Cut over plan planning
- Manage and schedule CRP, SIT and UAT sessions, Test Case and migration strategy
- Hands on Experience in Financial modules in Business analysis, Configuration, Real time Integration setups wif other Banks, HR Feed and Sate Street financial systems
Project Lead/ Solution Architect Consultant
Confidential
Responsibilities:
- Gathered business requirements for Oracle Financial modules which includes AP, AR, GL, PA and iExpense
- Design teh process flow diagrams, Conduct a system validation session wif Business owners. Understand teh business process, configure system setups and prepare Configuration Document (BR100), Month End Close Process, Test Script and User Manuals for Oracle Projects and Finance modules.
- Create and maintain OU, LE, Project Organization, Banks, COA, Cross Validations, Security Rules, PA and AR Auto accounting, Sources, Transaction types, Intercompany and Trade Customers
- Configure teh Oracle Applications Setups to meet business requirements for GL, Oracle Projects, iExpense, AR and AP
- Design and implement solution for Account Generator for AP Supplier Invoice and iexpense Invoice related to Project Expenditures. Configure and setup for Bill rate and cost rates for Oracle Project in Costing and Billing. Setup and execute Integration of Costs to projects and Revenue to AR. Worked on Receivable AR Invoice and Receipts.
- Identified and implemented CEMLI Finance objects in R12 and showcased teh business wif AS IS working process
- Design, Configure and implement iExpense System and integrate to projects for Costing and Billing.
- Worked on POC for GL 4-4-5 to Fiscal Month, PA Expenditures, Month End Close Process and COA mapping.
- Design and implement Periodic and Event Alerts for AR and PA modules. AOL setups like DFF, Profiles and request set scheduling.
- Manage Team of onsite and offshore for teh Project deliverable, resource assignment, schedule and manage CRP sessions. Outbound and Inbound data planning for Finance Hyperion and Data warehouse
- Responsible for Project Deliverables, Project plan, status, Stage gate and project Cut over plan planning
- Interaction wif Finance, IT and Business Director for all teh POC and project plans.
- Design and implement for CITI Bank Interface for India Ocean Project. SLA for recoverable account as a Global solution
Solution Architect
Confidential, MN
Responsibilities:
- Gathered business requirements, participated in setups & implementation and test scenarios for Oracle Financial modules
- Redesigned Pre-Auto Invoice solution as a Global solution for Emerson Business units. Worked on Fit Gap Analysis. Gathered requirements through various meeting/discussions/workshops.
- Design and solution for Product Code segment derivation for COGS. Setup Category set and Category Accounts for COGS account of product code segment derivation. Derivation of Product code segment for PO, BOM and WIP transaction.
- Configuring Financial Setups and EPM Global solution for IR ISO and Factory Direct design. Design need to calculate teh transfer price for a cost at teh Intercompany Transactions.
- Solution, Design and implementation for Deferred COGS in SMMC Business unit which is as part of EPM global solution.
- CRP sessions, testing for End to End process and resolving issues created from Finance Business Lead and users.
- Responsible for Team management, Project Deliverables, Cut over plan and Risk mitigation
ERP Functional Analyst
Confidential, Denver, CO
Responsibilities:
- Configuring finance and iexpense project. Design, Solution and implementation for Automation of Financial Month End Close Process (Prerequisite close process, Close and Post close)
- Custom solution and prepare Functional Requirement Specifications documents (Data Migration, Customization, Interfaces and Reports)
- Finalizing teh setups and configuration of teh instance to meet requirements. Designed and executed several Projects, extensions, customizations in Oracle ERP as part ofRevenue Recognitionsolutions. Projects include Blind Agency, Revenue and Cost Recognize by Location segment, Freight Classification and Sold to Location. Designed a solution for REV COGS report to excel upload functionality for Finance team for Revenue and COGS Reconciliation (Average Cost)
- Analysis, Design, Configure, Implementation and support for iexpense system which includes Integration wif Amex transactions, HR data feed from Workday, Mark View and Account Payables. iExpense system is implemented wif Requirement gathering, Business Process flow, Interaction wif other vendors and Training.
- Design and Interaction application data wif external sources like Banks (Lock Box Data/Stuck, Credit and Debit Card payment, NACHA File Data), Amex (Employee Expense Transactions), AR Collectors, Vertex, Oracle (SR for Critical Issue Solution), D&B, Web Method EDI team and CGI (AR invoice printing) for Cash flow and data Interfaces for business issue resolutions.
- Setup, Design, Implement and Troubleshoot for GL, AP, AR, FA, Trade Management, PO (Drop ship and Intercompany Functionality), Credit Card payments/setups in Receivables, iReceivable and iPayments.
- Automation and Redesign for PO Receipts and AP Invoice Processes
- Setup, Monitor and troubleshooting for GL, AR and AP transactions. Creation and maintain of GL Accounting Flex field values, Security and Cross Validation Rules, Auto Post Criteria set, Rollup Groups and Recurring Journals
- Responsible resolving for all critical business process issues and also recommend improvements for teh business process
- Setup and Monitor for Oracle Project Billing for Services provided. Coordinating wif development team for development and testing of custom components
- Extensive testing of data migration components to ensure accuracy. Writing SQL queries on TOAD to address requirements for data-analysis, Fix and Reconciliation
- Preparation of Test scripts and conducting post go-live support, Business/ User training and ensuring smooth period closure
- Proactive monitoring of interfaces to minimize number of exceptions (Revenue and Cost Recognition)
- Management reporting on support tickets movement, nature of issues and timely identify teh root cause and resolution
- Interaction wif Finance Director, Account Manager and External Vendors
Lead Consultant
Confidential, Atlanta, GA
Responsibilities:
- Analyzed previous Claim system of Rheem and designed a New Custom Extension solution which is interfaced to Oracle Trade Management (Claims), Install Base, Service Contracts and Finance. Teh solution is implemented wif custom objects, which integrates wif Oracle Inventory and Finance (AP and Trade management). This extension solution involved design of several ADF custom forms wif complex business logic.
- Involved in study of existing business process, Identify teh required GAPs. Data Mapping, Design and create BRD, Functional, Technical and data flow functionality for custom identified Gap process.
- Responsible for RICEW (Data Templates, Data Mapping, and Business Validations) objects solution for Finance and PO and Inventory modules. Identified teh Gap and Designed Functional design documents and solutions.
- Finalizing teh setups and configuration of teh client instance to meet client requirements for GL, AR Receivable and AP Account Payables Setups.
- Creation and maintain of GL Accounting Flex field values, Security and Cross Validation Rules, Auto Post Criteria set, Rollup Groups and Recurring Journals
- Understand and modify Application Configuration as required (includes system setups, flex-fields, workflow builder, profile options etc.).
- Developing functional specifications for custom enhancements & coordinating wif technical team for final deliverables
- Setup, Monitor and troubleshooting of GL, AR, PO and AP modules.
- Managing offshore team, load balancing and team allocation on deliverables and issue resolution
- Finalizing teh New setups and configuration of teh client instance to meet client requirements
- Coordinating wif development team for development and testing of custom components changed due to Upgrade.
Lead Consultant
Confidential, Mansfield, OH
Responsibilities:
- Involved in all teh process of Confidential project starting from Analysis to GO LIVE. This project included wif modules like Finance, Inventory, Purchasing, CST, OM, BOM and WIP.
- Presentations to client to explain Oracle new architecture and flows
- Responsible for Test integrity, Data Conversions, Interfaces, customizations to ensure no overrides for Oracle 11 migration.
- Finalizing Design and conducting detailed discussions for Solution for RICEW custom components
- Finalizing teh New setups and configuration of teh client instance to meet client requirements
- Managing Deliverables, Milestones, Resource Planning & Work Allocation for onsite and offshore.
- Preparation of CRP scripts and demonstrating Oracle flows to teh client
- Discussions wif client team to understand roles and responsibilities in teh organization to design Menus in teh System Administration module to meet teh SOX requirements
- Responsible for Migration strategies (PVCS and Kintana) and cutover planning for UAT and GO LIVE
- Extensive testing of data migration components to ensure accuracy
- Responsible for Revenue and Cogs reorganization
Techno Functional Consultant
Confidential, Boca Raton FL
Responsibilities:
- Conducting detailed requirement analysis and preparing teh Fit-Gap Analysis documents
- Finalizing Design of teh implementation and conducting detailed discussions for development of custom components
- Preparing Functional Requirement Specifications documents for Approved Supplier List (ASL), IR ISO and Item master and Cost Conversion and Interface.
- Finalizing teh setups and configuration of teh client instance to meet client requirements
- Coordinating wif development team for development and testing of custom components
- Extensive testing of data migration components to ensure accuracy
- Preparation of CRP scripts and demonstrating Oracle flows to teh client
- Co-ordination wif Oracle support for issue resolution
- Proactive monitoring of interfaces to minimize number of exceptions
- Developing functional specifications for custom enhancements & coordinating wif technical team
- Writing SQL queries on TOAD to address client requirements for data-analysis, audit
- Testing of custom enhancements pre-deployment & validation of components
Associate Consultant
Confidential, NY
Responsibilities:
- Configuring various finance and project modules
- Conducting detailed discussions for development of custom components
- Preparing Functional Requirement Specifications documents (Data Migration, Interfaces and Reports)
- Coordinating wif development team for development for all RICE custom components
- Managed as well as participated in cross-functional (Mainframe and Legacy) teams from task initiation through task completion.
- Interaction wif Domain managers to understand teh requirements and convert design document into a IT solutions Conducting
- Co-ordination wif Oracle support for issue resolution
- Functional Support for Oracle issues in Production Environment
- Proactive monitoring of interfaces to minimize number of exceptions and also halp in analysis and approval of data-fixes and patches
- Manage team at Onsite and Offshore and responsible for all deliverables
Project Lead
Confidential
Responsibilities:
- Configuring setups various finance and project modules
- Preparing Functional Requirement Specifications documents for Oracle Projects, Purchasing and iProcurement modules. Finalizing teh setups and configuration of teh instance to meet client requirements
- Designed Functional solution for custom payroll forms (Integrates Oracle Project (PA), HRMS and Custom tables) for breakup of HR details by Project, Department and Business Unit
- User Training/ Support/Maintenance and enhancements.
- Responsible for Design and build Interfaces, Development, Customization and Production Support
- Point of contact for Oracle Application business and IT issues
