Post Job Free

Resume

Sign in

Demantra techno-functional lead

Location:
Streamwood, IL
Posted:
March 01, 2017

Contact this candidate

Resume:

Arvind Patel 630-***-**** acy2cb@r.postjobfree.com

LinkedIn Streamwood, IL

Oracle Demantra Consultant

Business Process Analysis Solutions Architect IT Implementations

Talented and versatile IT Professional with 14+ years of success in supply chain application management, process improvement initiatives, root cause analysis, designing scalable processes, and the delivery of customized solutions. Expert in QA testing, deployments, issue resolution, integrations, and migrations. Top-flight communicator able to achieve in multidisciplinary and technologically diverse environments. Core competencies include:

Gap Analysis Functional Designs Proofs of Concept

Conference Room Pilot Upgrades/Consolidation Customer Satisfaction

Business Continuity Defect Troubleshooting Coaching/Mentoring

User Experience/Usability Data Transfer Security Continuous Improvement

Career Highlights & Key Projects

Managed 4 Demantra demand management project implementations including legacy system conversion and integration with Oracle ERP (Inventory, Order Management, PO), ASCP, IO, and DW systems.

Led 3 Demantra configuration enhancement, upgrade projects to integrate Demantra & ASCP with centralized IDM and enable supplier collaboration.

Generated $25M in savings by efficiently managing SCM and billing applications through end-of-life planning and retirement.

Delivered $6.5M in procurement savings by enforcing SLAs related to data center consolidation, M&A conversion, and virtualization.

Drove customer satisfaction to a record-breaking 94%.

Served as the technical lead of a warehouse divestiture project using WMS RedPrairie and had accountability for project design and code deliverables including custom data sets, QA testing, and final deployment with all milestones met on time and with zero adverse impact to operations.

Developed a solution to a reporting gap and given a tight turnaround and brokered a solution that satisfied all stakeholders and parties.

Professional Overview

AT&T, East Dundee, IL 2002 to 2016

Senior Technical Architect (2011-2016)

Served as a Techno-functional Lead on multiple high-value projects that enhanced mission-critical Oracle EBS Applications and supply chain tools. Developed unique, successful solutions for business clients by formulating business requirements and creating functional designs. Led teams in the identification and resolution of chronic application performance issues. Implemented solutions in alignment with IT process compliance. Directed hardware and software upgrades, relocations, and server lease rolls for multiple platforms and operating system environments.

Secured $1M+ in project funding by building pilots and authoring proofs of concept clients selected to initiate and fund projects to enhance and customize Demantra implementation.

AT&T, continued:

Carved $300K from annual maintenance and licensing costs by enabling the Oracle Sourcing application for use in the reverse auction process.

Led Quality Assurance teams in the creation of a functional and system integration test plan and the execution of the test plan during project lifecycles.

Created user stories and hosted daily SCRUM calls to deliver AGILE project deliverables on time and within budget.

Enabled Demantra’s publishing of forecast data to ASCP and export MAPE to Inventory Optimization for safety stock calculations.

Developed and implemented secure solutions facilitating Oracle Supply Chain access during the UNIX to LINUX conversion and delivered optimized usability and customer satisfaction.

Created custom solutions including a hook to collect item, product family, price data from EBS inventory item master, and collect shipment and booking history from sales order and purchase order data.

Maintained ownership and accountability for delivering quality product to business through early engagement and managing User Acceptance Testing.

Provided quality control oversight during release upgrades of Oracle ERP system to Oracle R12 resulting in the early identification of software defects and bugs using Oracle SR.

Trained and mentored 100+ technical and non-technical users for multiple applications.

Established corrective actions and process improvements to slash chronic application outages.

Coordinated WMS RedPrairie maintenance including O/S and database server patching, disaster recovery compliance with organizational mandates, and application security.

Consolidated legacy business units into Oracle Planning and Oracle ERP systems including data conversion and migration.

Customized Demantra to support vendor access and collaboration by enabling secure access to Demantra and Oracle Sourcing instance from external sources.

Technical Architect (2007-2011)

Applied project management concepts and methodology in the management of application migrations and database consolidations. Established new procedures to cut resolution delivery times for issues to stay within existing SLAs. Archived structured and unstructured data according to SOX compliance and company policies.

Saved $500K by ensuring minimal downtime during a data center consolidation.

Earned accolades and recognition from end-users for surpassing communication expectations.

Selected to lead a team tasked with assessing process adherence and compliance for all projects enterprise-wide.

Coached and trained end-users ranging from super-users to non-technical support teams, and authored jargon-free user guides, test plans, and training aids.

Delivered $30K+ savings in annual software maintenance and licensing costs by realizing multiple opportunities for budget efficiency and developing a secure confidential data transfer process using PGP encryption.

Served as a subject matter expert during infrastructure upgrade projects and worked in collaboration with DBA, production support, logistics, data center, business client, and third-party vendor teams.

AT&T, continued:

Associate Analyst, Analyst, & Senior Analyst, SBC Communications (2002-2007)

Managed third-party applications and functioned as DBA and project manager as needed. Created and reported performance metrics to Quest Forum TL90000.

Ensured 100% application availability.

Provided vital contributions as part of an assessment team measuring CMM compliance, identified areas for improvement, and made recommendations.

Directed post-merger expansion and consolidations projects according to scheduling, scope, and budget milestones.

Saved up to 70% of company expense on vendor statements of work (app DBA) by enhancing vendor customized scripts.

Negotiated service level agreements with third-party vendors and made recommendations for proposal to secure advantageous contract terms.

Led the migration of a Terabyte database from one data center to another with no downtime.

Education

MS in Computer Science, Northern Illinois University

BS in Computational Mathematics, Northern Illinois University

Masters Diploma in Software Engineering, APTECH Computer Education

BS in Mathematics, M.S. University of Baroda

Professional Development

2017: Big Data Analytics and Six Sigma Certification (in progress)

2016: AT&T Scrum Master Certification, AT&T Security Certification

2014: JDA Red Prairie WMS Product Introduction Training

2013: MobileFrame Developer Training

2011: Oracle Demantra Implementation Training

2009: Oracle ASCP, IO, and Demantra Fundamentals Training

2007: Coursework for Oracle 10g SDBA Certification

2006: Coursework for PMP Exam and Certification

2005: Java Basics, SAS Basics, Object-Oriented Analysis and Design

Technical Proficiencies

Oracle E-Business: Oracle Applications R12, 11i

Oracle ERP Modules: Oracle Demantra, ASCP, Sourcing, IO, INV, PO, OM

Databases: Oracle 11g (11.2.x), Oracle 10g, (10.2.x)

Development Tools: Oracle SQL, PL/SQL, Shell Scripting, Page Personalization, APPWORX, R

General Tools: Toad, SQL Developer, MS Office, MS Visio, MS Project, Rally, BMC Remedy, WebLogic, LDAP, InstallShield, IIS, SharePoint, Disk Share, Documentum, CSP-IDM, DMZ, SSH, Connect:Direct, Hadoop DFS

OS Platforms: Sun Solaris, RHEL 5/6, Windows NT/2000, Linux, HP-UX

Applications: WMS RedPrairie, XelusParts, XelusTrade, Bill Trak Pro, Freight Bill Payment



Contact this candidate