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