Summary
Skills
Timeline
Work History
Overview
Education
Generic

DEVESH PATEL

Glendale,IL

Summary

Professional, techno-functional developer / analyst. Proven record providing business needs via enhancing performance, creative business solutions in design, development, implementation, testing, and support. Diversified global delivery experience demonstrating strong capability in communication, systems integration, and data integration. Resourceful, creative, innovative, and excellent troubleshooter. Adept in multiple domains. Concomitant prioritization and organizational skills.

Skills

  • Sql, PL/SQL, Python, PHP, C#,, ASPNET, VBNET, JavaScript, ,Java, R, Perl, Ruby
  • Oracle, SQL Server, MySQL, MariaDB
  • OS: Windows, MacOS, iOS, Unix, Linux
  • Docker, Virtual Box, Eclipse, VSS, ISS, Subversion, SQL Developer, VS Studio, VS Code, Git, Gitlab, Citrix, Jira, PowerBuilder
  • SOAP, JSON, XML, Path, HTML5, CSS, jQuery
  • MercuryGate TMS, Serena Version Manger, Cognos Upfront, Trans-Soft, Oracle APEX
  • Complex Problem-Solving
  • Critical Thinking
  • Reading Comprehension
  • Business support software proficiency
  • Web-based software engineering
  • Business process reengineering
  • Systems Analysis
  • Software Development

Timeline

Business Data Specialist

HA International
01.2022 - 01.2023

Data Programmer Analyst

ABS Graphics
01.2021 - 12.2022

Consultant

Independent Consulting
10.2012 - 12.2020

Solution Architect

Chain-Sys
05.2011 - 02.2012

Strategist /Analyst/ Developer

Quebecor / World Color / Quad Graphics
10.2005 - 05.2011

Bachelor of Arts - English

Loyola University Chicago

Work History

Business Data Specialist

HA International
01.2022 - 01.2023
  • Provided SAP data capture workaround to facilitate key forecasting business requirements sought for 2+ years by solving integration issues and data queries by creating SSRS reports for variable period retrieval of forecasting data
  • Generally provided analysis, task automation, data and workflow integration, reducing failure points and ineffective redundancies by 30%.
  • Restructured web application design and workflow to facilitate efficiency, maintenance, and versioning
  • Updated old code bases to modern development standards, improving functionality
  • Analyzed proposed technical solutions based on customer requirements
  • Collaborated with management, internal and development partners regarding software application design status and project progress
  • Interacted with internal customers to understand business needs and translate into requirements and project scope
  • Conducted interviews with key business users to collect information on business processes and user requirements
  • Collaborated with stakeholders to define project objectives and criteria.

Data Programmer Analyst

ABS Graphics
01.2021 - 12.2022
  • Responsible for ETL processes to facilitate data integrity and shipping accuracy
  • Created sql procedures and metadata to transformed complex data sets
  • Reduced data process time for vendor jobs by 75% allowing greater flexibility for scheduling and on-demand jobs
  • Tools utilized include SQL, python, C#, .net
  • As well as postal applications
  • Identified causes of issues within applications and determined which modifications needed to be made
  • Provided technical support using knowledge of complex technology to solve problems and support new projects.

Consultant

Independent Consulting
10.2012 - 12.2020
  • Clients included website development, POC's, BI, Data Analysis
  • Provided estimates for analysis, design, architecture, development, testing, and attendant tools required within budgetary constraints and scope
  • SEO optimization of customer website utilizing links, SERPS, and Google Search Console
  • PoC utilizing Angular Ionic2 and AWS Elastic Beanstalk, EC2, S3
  • WordPress child theme customization for php, data, html, css authentication and security
  • Data Analysis and processing for proprietary trading software with c# and python for options trading algorithm.
  • Analyzed problematic areas to provide recommendations and solutions.
  • Delivered outstanding service to clients to maintain and extend relationship for future business opportunities.

Solution Architect

Chain-Sys
05.2011 - 02.2012
  • Grand Ledge
  • Team Lead for onshore / offshore team to develop complex supply chain integrations for large scale Canon project (One Canon) initial rollout
  • Involved multiple consulting firms and multiple scopes
  • Required MDM, PDH, CDH reorganization of data
  • Required Oracle EBS and third-party data tools integration on tight timeline
  • Only group to complete 100% project scope delivery on time
  • Provided team oversight for SaaS application product deployment and enhancements
  • Data architecture design and project management of complex supply chain and forecasting utilizing custom ETL middleware product
  • Managed project scope, schedule, status, and documentation
  • Created and implemented innovative business solutions to support corporate objectives
  • Worked closely with product teams to define and prioritize partner feature requests.

Strategist /Analyst/ Developer

Quebecor / World Color / Quad Graphics
10.2005 - 05.2011
  • Data mining aggregate truck booking data against cost determining
  • Analysis included trucking routes, scheduling, and back haul cost analysis for scheduling shipping efficiently as per booking which would result in 30% reduction in trucking costs
  • Normalized and analyzed raw data for plants to determine plant viability culminating in retirement of inefficient plants
  • Maintained and enhanced internal MVC based .net web application
  • Helped develop ORM factory for CRUD transactions prior to LINQ
  • Implemented ad hoc query reports functionality which extended application flexibility by decoupling report execution, allowing accounting department to quickly implement and utilize reports without application changes and minimal integration
  • Reduced accounting workload by 20%
  • Supported production environment, provided bug fixes, maintained high availability of several applications
  • Provided quick, creative solutions for issues to prevent production issues with legacy software for interim and transitional periods
  • Created .net application for querying and transforming data set to X12 EDI format for B2B transactions
  • Maintained unsupported legacy software and provided stop gap solutions for IT development and tool resources
  • Managed and/or supported Serena Version Manager, Cognos Upfront, Trans-soft, Mercury Gate, Mercury Edge
  • Created Jasper reports for freight and accounting operations
  • Created Visio documentation for data modeling and BI processes
  • Developed and supported applications in key areas including internal tracking, customer reporting, and bug fixes
  • Maintained QA testing for internal TMS and created test plans, procedures, and scenarios.

Overview

17
17
years of professional experience

Education

Bachelor of Arts - English

Loyola University Chicago
Chicago, IL
05.1992
DEVESH PATEL