Supply Chain Data Analytics & Software Developer

Prachiben Patel

***********.***@*****.*** 732-***-**** 2827 Asbury Avenue Bensalem. PA https://www.linkedin.com/in/prachiben-patel-74ab5420a/

Professional Summary

Experienced Supply Chain & Operation Analyst in healthcare industry with expertise in customer order management and logistic analysis.

Proficient application developer with extensive experience in system design, development, execution, deployment, and testing.

Skilled in software development language including ASP.NET, C#.NET and data analytical tools such as R, SQL, Tableau.

Strong understanding of different methodologies (Agile, Waterfall and Iterative), finance and risk models (Risk Management), operation (six sigma’s, supply chain services), marketing and engineering.

Professional Experience

DEFENCE LOGISTICS AGENCY Philadelphia PA Supply Chain Analyst – Data Management July 2024 - Present

Managed contracts throughout their lifecycle, maintaining compliance, and supporting smooth supplier and vendor operations.

Demonstrated strong understanding of procurement processes, including supplier selection, bid evaluation, and purchase order management, to ensure cost-effective and timely sourcing of materials and services.

Utilized SAS to clean and organize complex data sets for analysis .Conducted statistical analysis and data mining to uncover trends and patterns

Developed and maintained SAS programs to automate data processing tasks

Developed and managed Power BI dashboards to track key supply chain metrics and enhance visibility into procurement and performance data.

Generated customized reports and dashboards with transporting SAS Data into Qlik.

Collaborated with cross-functional teams to identify and address data-related issues.

AMERICAN EAGLE OUTFITTERS INC. Pittsburgh PA Supply Chain Analyst – Data Management April 2022 – July 2024

Managing the domestic and international supply chain data stream identifying exceptions and resolving discrepancies.

Identifying data gaps and research missing transmissions by using reporting and partner systems. Create data where transmissions are unavailable.

Writing and Executing basic SQL queries (knowledge of database structure necessary)

Used Python API’s for extracting daily data from multiple vendors.

Creating and utilized reporting to analyze trends and ensure compliance from our data trading partners.

Implementing supply chain-related integrations (flat files, EDI transactions, XML) with Trading Partners

Actively managing and contributed to data compliance programs and scorecards

Partner with other team members as well as cross-functional partners to support business processes, system solutions and strategic projects.

Challenging conventional thought, offer unique perspectives and conceive innovative solutions.

Writing & executing Test Plans and Test Scripts (both Functional and Data Integrity)

Identifying opportunities to streamline or improve processes through operational or technical solutions.

Utilizing business intelligence reports/dashboards using QlikView, Tableau

Participating in appropriate training and development activities

CenTrak, Inc. Newtown, PA

Supply Chain & Operation Analyst May 2017 - July2021

Managed the contracts by extracting statement of work (SOW) request from SharePoint, transferring data to SAP for partner approval, coordinating with legal department as necessary to sign contracts and generating purchase orders.

Reviewed sales quotes and processed service and hardware orders in time for CenTrak’s 3 business segments.

Maintained demand planning system and software and ensures the correctness of data to support decision making.

Conducted detailed analysis in hardware backorders and project delivery schedule to project monthly hardware revenues

Analyzed open orders by customers to identify potential inventory shortage and schedule hardware deliveries via economic ship mode to meet customer required delivery timeline efficiently.

Managed inventory in warehouse.

Executed regular inventory counts and supply audits to monitor shrinkage and generate insights into purchasing decisions.

Led the development of in-house quoting tool (CPQ - Configure Price Quote) by providing order processing expertise to consultant and monitoring and testing the CPQ tool in SalesForce

Created various dashboards using Tableau and SalesForce to visualize monthly operational metrics

Coordinated with fulfillment team, project management team, sales team, and finance team to improve the quote to cash process by analyzing project completion status and reducing backorders

Cleaned and tested sales and open order data in preparation in the ERP implementation

Reported to regional president daily/weekly and Month over month trends for Next + BYOD metrics, achieved 94% attach rate

Conducted ongoing performance tracking and success metrics for sales consultants to consistently increase operating

Assisted Controller and Accounting Team with research and data analysis

Coordinated and oversaw the consolidation of two RMA departments from company merger Trained and organized the work of six associates.

Resolved service issues in a timely manner, including coordinating and processing returns.

IT-NetworkZ Pvt. Ltd. Nagpur India

.Net Developer December 2014-Jan 2017

Worked closely with members of the development team through the full systems lifecycle including requirements capture, design, development, testing, and deployment.

Developed 3-tier logic for various classes, modules and Web forms in ASP.NET 2.0 using C#.NET as a code behind language.

Designed and developed Web pages using ASP.NET, HTML and JavaScript.

Extensively used windows form applications to create user interfaces by using C#.NET.

Worked on Coding using C#.NET and ADO.NET.

Created web pages using controls like Data grids, Repeaters, Textbox, Button, and Dropdown List etc. All the validations are done using the server and client-side validation controls.

Developed and designed C#. Net pages required for registration.

Extensively used XSLT for transforming the data and XML in Business Layer.

Created Tables and Indexes in SQL server and involved in writing Stored Procedures, Triggers, Functions and Views.

Created derived columns for the present columns for the given requirement.

Implemented different types of constraints on the data tables.

Worked on debugging the ASP.NET code and fixing the bugs.

Education

Penn State Great Valley Malvern, PA

Master of Science in Information Science December 2020; GPA: 3.25

RTMNU University Nagpur, India

Master of Science in Computer Application August 2014; GPA: 3.75

RTMNU University Nagpur, India

Bachelor of Science in Computer Application July 2011; GPA: 3.75

Skills : Logisitics; Reverse Logistics; Management; SAP; SQL; Tableau; Power BI; QlikView; Dynamics 365; Salesforce; .Net Framework, Web API, HTML, JavaScript Oracle ERP, TOAD, Tradestone.

Certifications :

SQL for Data Analysis (LinkedIn Learning)

Contact this candidate