SUMMARY

• Over 10 Years as a Business/Enterprise Architect providing solutions for different Systems/Applications /Products.
• Overall 22+ years of experience as Architect / Manager /SME performing various functions including Analysis, Design, Development, Implementation, Support of enterprise Systems.
• Experience in managing projects involving Oracle Applications with functional and technical experience across all e - business suite ERP modules (cloud, on-premise) including Supply Chain and Core Financials modules.
• Experience in managing Mergers and Acquisitions (M&A’s), Divestitures from functional, technical perspective involving complex integrated architecture and Business/IT alignment etc.
• Experience in dealing with multi-currency, multi-ledger country enablement projects involving usgaap and non-usgaap reporting and intercompany accounting etc.
• Demonstrated strength in team management, communications and achieving cross-functional business objectives.

Confidential

Architect/Manager/SME

Responsibilities:

• Lead in a Solution Architect role to solution various Oracle r12 custom processes, for ex; recognizing cogs at different milestones as opposed to the standard functionality of cogs recognition, country enablement etc. Practiced TOGAF principles on the job for various enterprise architectural processes.
• Partnered with business process owners and business operations to drive process simplification, business process reengineering, enabling new business models and business capabilities.
• Implemented the Country Enablement for Brazil/Russia and resolved the challenges involved therein by maintaining the standard cost in USD, while the ledger currency is the local currency.
• Experience in Configure to Order (CTO), Build to Stock (BTS) manufacturing and Oracle ASCP/Kinaxis/Demantra planning modules. Also participated in authoring/reviewing the cross-functional BRD’s, FSD’s, BR100, providing solutions and management of BAT/UAT cycles.
• Managed manufacturing finance projects end-to-end, including requirements gathering, providing the solutions which include a combination of out-of-the-box and custom functionality. Experienced in all phases of supply chain cycle including Plan(Product, Component), Source(Global/Local, Single/Multi, ODM/EMS), Make (BOMs), Deliver(shipping, logistics, 3PL partners), OM, Inventory Management including SOX controls the management of all these processes. Experience in the supplier onboarding process.
• Architected and built a complete supply chain Reverse Logistics system from grounds-up which processes returns worth $1B/300M in revenue/cogs respectively and suggested business process gaps to decrease the returns and effectively reuse/resell the new-in-box/used products back to the customers.
• Experience in XaaS(software, platform as a service, etc) cloud supply chain tools from e2open(SCP) and integration with the on-premise platforms.
• Experience in costing process for NPI(New Product introduction) and sustaining products using the PLM(Product Lifecycle Management) tool.’
• Managed the supply chain finance processes including cost rollups, period-end processes, spend/savings analysis at Product Family, Business Unit, Business Entity, Commodity levels, Financial planning/forecasting, and analysis (FP&A) using the Hyperion suite of tools/Essbase data. Responsible for fiscal forecast spend/savings Analysis/Reporting close to 3B/Quarter or 10B/Year, for different commodities, suppliers, components etc. Experience in ASC 605/606 standards.
• Solution design the acquisition/ divestiture projects, involving the economic benefit model carving out revenue/cogs separately.
• Experience in Agile (Scrum) and Waterfall model SDLC methodologies.
• Expertise in Enterprise DataWarehouse (EDW), Tableau, SAP Business Objects(BO) Business Intelligence (BI) Analytics, Reporting tools, and design of data warehouse systems. SQL Architect. Worked on Big Data technologies

Confidential

Solution Architect/PM/SME

Responsibilities:

• As a Solution Architect, provided solutions to improve various customer processes (using the use-case, swim lane diagrams for different functional end-to-end scenarios).
• Project Managing the cross-functional teams’ progress/statuses for the deliverables including RTM’s(Requirement Traceability Matrix), BRD’s, FSD’s, TSD’s with various cross functional teams including Make, Deliver, Logistics, Source, and Finance etc.
• Program management responsibilities including tracking the Schedule, Scope, Cost, CR’s, Risks using the PM tools like Propel, MS Project, smartsheets generating complex excel reports (involving stacked, multi-bar, reports for ex), Issues follow-up, preparing weekly consolidated PowerPoint reports.
• Managed a finance expense R12 technical upgrade P2P (AP, GL) project, overseeing the month-end activities, reports reconciliation between sub-ledgers in r12.
• Prepare high-level Project plans for the R12 implementations while working with different cross-functional timelines, PMO, Development etc.

Confidential

PM/SME

Responsibilities:

• Managed on-site and off-shore teams thru the complete life cycles of various projects.
• Author requirement documents; perform fit-gap analysis to identify the gaps between Oracle apps and the business functions for all the RICEW (reports, interfaces, conversions, extensions, workflow) objects. Defined processes and procedures keeping track of SOX internal controls.
• Working on the AR interfaces including the AutoInvoice, AutoLockbox, Tax interface, etc.

Confidential

Systems Analyst

Responsibilities:

• Primarily worked on the support of the P2P applications resolving the workflow issues for the Requisitions, Purchase Orders, Expense reports, and AP Invoices.
• Documenting the requirements from the Business users, working closely with the AP, Procurement Users, and identifying the gaps between the business process and Oracle applications functionality.
• Writing complex ad-hoc SQL's to satisfy the Finance and P2P business ad-hoc requirements.

Confidential

Sr Business Analyst

Responsibilities:

• Authoring BRD’s gathering requirements related to changes in various OM and Receivables (AR) processes. Work involved reconciling within AR and across AR and GL using reports (Aging, Reconciliation reports etc), thereby enabling the periods to be closed in time.
• Worked on an acquisition project (M&A) between partial Confidential and Symantec involving the challenges of Business/IT alignment of core systems like 11i/R12, coming up with an integrated architecture.
• Worked in month-end and quarter-end cycles which involving successful completion of various steps.
• Worked on all the AR interfaces including the Customer Interface, Autoinvoice, Tax interface, GL Interface and Lockbox. Resolved many important AutoLockbox, Vertex Tax related issues. Developed custom reports using Financial Statement Generator (FSG) based on user requirements giving the to-date balances.
• Worked on Pricing module involving (Qualifiers, Modifiers, Pricing Attributes, and Adjustments) for different types of orders.

Confidential

Lead Systems Analyst

Responsibilities:

• Involved in the data migration, validation and reconciliation of Customer and Invoice data from legacy system to Receivables. Optimize the performance of various batch programs. Design, Development, and Support of Customer Interface, AutoInvoice Process, WriteOff’s, Prepayments, Credit Card Process, etc. Involved in development, test, Normalization, and support phases.
• Extensive coding of Complex stored procedures, packages, and triggers using SQL/PLSQL to satisfy the custom Confidential functionality. Worked in Financials (Receivables, Payables, General Ledger) and Oracle Cash Management, Oracle Order Management, Inventory and Purchasing.
• Experience in Revenue Recognition process for different kinds of transactions Credit Memos, Invoices (LIFO, Prorate etc) in different scenarios of at the time of delivery(point of sale), before delivery and after delivery, etc. Customized the format of Dunning letters to be sent to the customer with different levels of severity, invoice printing report, and sales tax summary report.

Confidential

Analyst

Responsibilities:

• Involved in AR to GL reconciliation process while working with business users.
• Worked on improving the processes of order management, billing and credit card applications.

Confidential

Systems Analyst

Responsibilities:

• The Bedrock project involves upgrading from 10.7 to 11i Oracle e-Business suite. Worked extensively on Procure to Pay, Manufacturing (Plan to Build), Order Management applications. Involved in authoring and reviews of BRD’s, FSD’s, MD50/MD70’s, etc. Also worked in Cisco e-Customer module, applying the principles of Oracle TCA (Trading Community Architecture) model.
• Extensive experience in tuning both online (front-end Oracle standard forms) and batch (concurrent programs) process, using different techniques, involving complex SQL's both in a local and distributed environments.

Confidential

Project Lead

Responsibilities:

• Worked on the Sales and Marketing Online products to develop batch concurrent programs in pl/SQL to pull data from various products in single data stores for transactional and reporting purposes using Oracle 9i/8i pl/sql stored procedures, packages, Materialized Views, Fast Refreshable MV's, Forms, Reports. Good experience in Perl, awk, and Unix shell scripting, experience in Java Development
• Performance tuning of the batch programs using explain plan, tkprof, etc using different techniques using the latest Materialized View features of Oracle 9i/8i features.
• Worked on Data Warehousing(EDW) Project which involves building the facts and dimension tables with key Performance Index metrics data. This involved using the best Oracle technology features like rollup, cube, etc.
• Gained functional expertise on the various CRM Modules like sales and marketing intelligence.

Confidential

Systems Analyst

Responsibilities:

• Extensive pl/SQL coding of packages, stored procedures, functions and generation of the SQL-loader scripts to pull data from legacy system to Oracle database warehouse.
• Subsequent generation of Intelligence reports (using Oracle Reports, pl/SQL) on data warehouse for decision support and managerial reporting.

Confidential

Systems Analyst

Responsibilities:

• Design and preparation of software requirements specifications (SRS). Contributed major ideas in different projects in the Analysis and Design phase. Unit (peer testing) and Integration testing of screens and reports.
• Worked on Interbank Reconciliation (IBR) project which is similar to oracle cash management.
• Extensive Coding of pl/SQL procedures, functions, packages, performing basic administrative tasks including backups etc. Used Oracle Designer case tool in preparing the ER Diagrams and to centralize all the functionality in Designer metadata.