Badges
Certifications
josephengelman has not earned any certificates yet.
Work Experience
Data Engineer
DriveCentric• October 2019 - January 2020
• Applied best practices and established procedures to analyze data and identify trends in customer leads, customer deals, dealership inventory, and email blast performance. • Developed, constructed, tested, and maintained Microsoft SQL Server databases. • Generated reports based on regular datasets for end users, using system tools (such as SSRS) and database and data warehouse queries and scripts. • Performed data definition (DDL), data manipulation (DML), transaction control (TCL), and data control (DCL) actions on data and databases.
Software Developer
Jim's Formal Wear LLC• January 2017 - October 2019
• Promoted from customer care specialist role due to knowledge of data analysis, inventory management systems, and SQL. Diagnosed flaws in the existing rental and resale inventory management systems and provided solutions to counteract inventory tracking blind-spots that enabled the company to make more informed and effective inventory-based decisions. • Engaged with business stakeholders to develop an understanding of their function and operations. Defined how analytics and new web-based applications could be used to solve business problems regarding inventory management, performance management, purchasing control, and department staffing. • Leveraged knowledge from business analysis and of PHP web development to design and program solutions for off-loading antiquated IBM i RPG programs. Created a new web-based warehouse management system (WMS) using the Yii2 Framework, PHP, and SQL. The system provided order fulfillment, inventory management, and report generation. • Used system tools, such as Tableau, to consolidate and analyze structured and unstructured data from diverse sources. Generated actionable insights and solutions for dealer services, inventory management, and product lifecycle management. Delivered results to stakeholders using a combination Tableau Dashboard and LucidChart-enhanced documentation. • Created and maintained IBM Db2 database tables, materialized queries, and views, along with complex functions, scripts, and stored procedures/triggers for database application development use. Ensured data integrity, quality, and proper relationships. Evaluated existing schemas and tables for performance and security improvements. • Assisted the marketing department with the company’s integration to the Shopify online selling platform. Engaged with the stakeholders to determine current blind spots, areas of improvement, and formulate more efficient processes. • Designed, coded, and modified PHP web-applications from development to production according to stakeholder specifications. Deconstructed and rebuilt the existing rental and resale inventory services to handle the company’s integration with Shopify API. This included established cross-connections between the company’s MySQL database and the company’s IBM Db2 database.
Customer Care Specialist
Jim's Formal Wear LLC• January 2016 - December 2016
• Promoted from production team lead role due to leadership and management abilities. As the company expanded from a private wholesaler into the public retail space, managed and trained a mid-size B2C team of customer service representatives in business rules, products, and services. • Diagnosed user experience (UX) and user interface (UI) design issues, assisting the IT department as a quality assurance tester (QAT) for internal and external web-based applications. • Leveraged knowledge of SQL to generate and analyze weekly order replacement reports. Analyzed order fulfillment history to research issues for validity, track error trends, and document warehouse and company replacement percentages. • Assisted the Marketing department, leveraged knowledge of SQL to pull dealer account sets based on various criteria including total volume by price, volume by units, and replacement percentages for email and snail mail targeting campaigns. • Performed data entry and administration for the company’s internal knowledge management system (KMS), customer management system (CMS), and dealer management system (DMS). • Reconciled packing slips and invoices from merchandise manufacturers, submitted approved charges to the accounting department for payment.
Production Team Lead
Jim's Formal Wear LLC• June 2012 - December 2015
• Promoted from team member role due to merchandise knowledge and leadership ability. Managed a mid-sized, centralized team that expanded into several areas during the peak production season, or as production demands increased. The performance led the company to re-define and increase the team lead role functions and responsibilities across all production departments. • Assisted Purchasing Department with annual merchandise buy for all ten service centers by helping to compile and review high-usage product analysis reports. Generated reports monitoring inventory usage statistics on a weekly, monthly, and yearly basis to reduce inventory blind-spots, such as growth trends, product loss, and depreciation of garments. • Increased department efficiency by 66.67% (60 orders/hour to 100 orders/hour). By analyzing existing order fulfillment processes, observed weak areas in the production process and was able to design an optimized order fulfillment process for the department. Applying the technique on other production-related departments, positively decreased the overall warehouse’s minutes/order (MPO). • Performed inventory management control on all merchandise being disbursed from two external services centers that were closed due to profitability. Worked with the Director of Building Services to re-design department layouts within the warehouse to accommodate a large amount of product being received from the two closing service centers. Oversaw mid-size team that received, cataloged, and performed quality inspections on merchandise to determine continued usability and add approved garments to warehouse inventory.
Production Team Member
Jim's Formal Wear LLC• March 2008 - June 2012
• Performed order fulfillment for wholesale and resale garments, performed merchandise quality assurance testing and assisted with managing and maintaining department merchandise inventory. • Increased department efficiency in order fulfillment by 50% (40 orders/hour to 60 orders/hour) by creating the company’s first standardized merchandise coding system dossier. Simplified merchandise coding explanations significantly decreased inter-departmental communication breakdown issues.
Education
American Military University
Database Application Development, AS• October 2017 - Present
Educated in MS Access Database Applications, such as developing entity-relationship diagrams, data models, databases, table structures, and graphical user interfaces (GUI). Examined data development theory, while interacting with relational databases using ANSI standard SQL.
Links
Skills
josephengelman has not updated skills details yet.