SUMMARY

• A motivated and resourceful professional with over 15 years of experience in the customization and integration of the Oracle
• E - Business and Data Warehouse Suite applications. Offering strong technical and functional knowledge
• Coupled with an analytical and problem solving aptitude to provide end-to-end solutions for business process solutions.
• 2 Years of experience in Cloud Technologies
• 6 Years of BIG-5 Consulting Experience
• 10 Years as Lead in 6 Oracle ERP/CRM Implementations
• 6 Full Life cycle implementation Experience
• 9 Years of Data Warehouse Experience
• Experience in Offshore-Onsite model
• Enterprise Resource Planning
• Project/Delivery Management
• Cross-Functional team Management
• Vendor Relationship Management
• System Architect
• Customer Relationship Management
• Establish Processes/Procedures
• Business & Data Analysis
• Change/Release Management

TECHNICAL SKILLS

• Functional Technical Experience in ERP and CRM Modules
• Financials - Accounts Receivables, Accounts Payables, Fixed Assets, Cash Management, General Ledger, Project Accounting (Billing and Costing), and Trade Management (Channel Revenue Management)
• Procure to Pay: Purchasing, Payables.
• Distribution, Supply Chain, Advanced Pricing, Bill of Material Modules, and Warehouse Management: Order Management,Fulfillment, iStore & Inventory.
• CRM Modules: Service Contracts, Oracle Install Base, Field Service, Depot Repair, iSupport, and Counters.Other: EDI, System Administration, TCA Architecture.
• AIM Methodology (BR100, MD50, MD70, MD120), Agile methodology
• RICEW and CEMLI
• OOD (Oracle on demand)/OMCS (Oracle Managed Cloud services)/AWS (Amazon web services): Creating and tracking Service requests, and prioritizing RFCs for migrations.
• Oracle ERP/CRM Configuration, Oracle Workflow customizations, Custom.PLL, Page Personalization
• Oracle PL/SQL, Oracle Discoverer, OBIEE, Oracle Reports 6i, Forms, Tableau
• Data Modeling / Data Warehousing tools: Hyperion, Cognos, Informatica, ODI, Ervin, SQL Data Modeling, Visio.
• Change Management Tools: HP/Mercury-Kintana ITG Change Management Suite
• MS Project Schedule, Visio, MS Office Suite, SharePoint, JAVA/JSP, AJAX, PERL, Shell Scripting, JAVA
• OS - Windows, MS Dos, UNIX.

PROFESSIONAL EXPERIENCE

Confidential, RI

IT ERP Architect Consultant, Oracle Applications

Responsibilities:

• At Schneider Electric, was engaged in Integration of Oracle Financial and Service Cloud Applications; was directly responsible for designing and building of Customizations, System integration with SOA between Oracle Financial Cloud, Oracle EBS, SERVICE MAX, CPQ, People Soft and BI systems.
• Executed 2 G&W Labs acquisitions’ system integrations. Assessed Functional Architecture into Oracle systems, and enhancements to support combined company’s business needs.
• Delivered 6 major implementation projects - Oracle Applications customization, reports, interfaces and conversions for East, West and Central business units;
• consolidation of the same business units when revenue crossed over $100B;
• System integration to multiple 3rd party systems including ADS (a system to page technicians with call details). Executed system integrations for 5 Canon acquisitions - Functional/Technical Architecture, solution design, data conversion into Canon systems, and enhancements.
• Was directly responsible for Canon’s Service Contract Invoice design and development using PL/SQL, Streamserve Design tools, Java, and UNIX scripting. This implementation was a customer facing impacting several hundred Canon Business Solutions’ customers.
• PCI Compliance Project - POC and a design road-map presentation for CBS and subsequent deployment of the same.
• Was directly responsible for the customizations as a result of implementation/acquisition. Involved in over 400+ RICEW element customization.
• Initiated re-engineering process along with Business needs for better approach to reduce execution time, without negatively impacting End User satisfaction: Improved month end closing process by providing root cause, resolution and troubleshooting tools to monitor stuck transactions. Introduced proactive processes to keep these transactions clean which reduced period closing from 10 days to 2 days.
• Worked very closely with CIO, CFO and other executive management in business project direction and provided management reports like companywide metric, competitive analysis dashboard using BI.
• Managed the relationship with external IT vendors, vendor spend, assigned project scope, schedule, risks, changes & quality. Assured for data compliance, certification, regulation, governance & stewardship.
• Developed and managed all stages of the projects - scope, risks, resources, schedules, budgets, change, requirements traceability matrix (RTM), artifacts and responsible for defect tracking, issue resolution and provide metrics
• Provided road maps, project schedules, budget, milestones, sprints, and SLAs. Ensured data quality, and identified and addressed risks.
• Performed Go-Live cutover tasks including system configuration, code migration, data conversion and reconciliation.
• Coordinated with:

Senior Techno Functional Consultant

Confidential, St. Petersburg, FL

Responsibilities:

• DBA teams (internal, as well as OOD/OCMS) for release management tasks and to stay up-to date with Oracle released patches.
• DW/BI teams to create Enterprise Data Management Audit reports to resolve data discrepancies.
• QA teams to cover entire business scenarios, define entire end-to-end test cases, and address their test scripts execution and results.
• Development teams to maintain Standards, and deliver high quality objects in a timely manner.
• Led design meetings with functional and technical members to deliver detailed data mapping for Interfaces and Conversions, and custom processes and programs.
• Instituted a portfolio of end-to-end projects to create Reconciliation & BI Analytical reports.
• Designed reports to provide integrated view of Oracle modules - to server as primary tools that supported the cost and revenue decisions in the Finance and Service areas.
• Directed the design and build of Contract to Cash custom processes – namely Contracts Credit and Rebill process to enhance the integration between Oracle Service Contracts and Oracle AR modules.
• Re-designed the Account Generation Processes (Project Supplier Invoice Account Generation) to convert the process from static to dynamic.
• Defined code conversion for inbound and outbound transactions - integrating transaction interface data file for 810, 850, 855, 856, and 860 using ORACLE e-Commerce Gateway.
• Worked extensively in reconciling the accounting issues between inventory, purchasing, costing, AR, AP, PA, Trade Management and GL.
• Analyzed current Transaction Code and mapping the TC Codes to seeded Oracle Sub Ledger Accounting (SLA), and provided solution to map those which are not covered by seeded SLA.
• Designed a live reporting tool for budget vs actuals, which updates a daily overview every 5 minutes.
• Designed management and month-end control reconciliation reports.
• Involved in customization and developing new Forms/Reports using Oracle Forms/Reports 6i.
• Involved in Conversion, Developing and customizing the Oracle Applications CRM modules including the customization, interface programs, Reports and Forms as per the user and business requirements
• Developed a scripted report which allows data parameter changes to run the report, which in turn can be saved as a spreadsheet and emailed to a customer.
• Authored MD50 documents, prepared the Test Scripts, Conducted Conference Room Pilots (CRPs) & User Training
• Coordinated to setup ERP/CRM modules and responsible for Configuration BR100 document
• Utilized Pivotal Tracker to facilitate stories estimation, workflows, backlogs, track team velocity, reset priories, track bugs & issues and progress reporting to ensure all the stories are accepted and done.
• Conducted Oracle workshops for business units to understand and document customizations.
• Trained the users to perform data profiling as part of customer data/address correction & standardization.
• Led an initiative to create a data warehouse, ETL, and reporting using OBIEE for all the subsidiaries.