Arindam Roy Email & Phone Number

Salt Lake City, UT, US

Midvale, UT, US

• Pioneered an automated ETL pipeline leveraging Python, Pandas, cx_Oracle, and SMTP, streamlining data ingestion from NETSTOCK CSV files into Oracle Data Warehouse tables. Employed advanced multiprocessing strategies to.

Midvale, Utah, US

Torrance, CA, US

Fullerton, CA, US

• Assisted more than 500+ international students with their queries and continual transition to the Information System and Decision Science (ISDS) department at California State University, Fullerton.
• Executed statistical analysis using Python on an approx.10% improvement in student examination scores of 160+ students to homework grades to extrapolate the effectiveness of the online virtual teaching system.
• Generated visual reports using Tableau and MS Excel, which acted as guidelines for the ISDS Departmental Committee, which strengthened their decision-making by approximately 40%.
• Responsible for tracking and forecasting of stationery products using the Excel and EDQ models to ensure optimal stock available for departmental use.
• Supported technical assistance to Staff/faculty by resolving IT hardware and software issues raised on the Oracle HCM Cloud system.

Columbus, Indiana, US

• Liaised between business stakeholders and IT teams and been the Single Point of Contact (SPOC) for the ERP WMS cloud transformation project affecting 18+ business units across North-South America and the Asia Pacific.
• Performed Root Cause Analysis, Impact Assessment, and identified the gaps and inconsistencies in the current warehouse processes and provided cost-benefit analysis resulted in approx. 30% improvement in operational.
• Conducted bi-weekly meetings with the Operations Team, QA Team, and End Users to ensure performance efficiency, troubleshooting WMS system-related errors, and assist the Project Manager in updating the project status.
• Translated stakeholder requirements into 10+ different tangible deliverables such as functional specifications, user cases, user stories, workflow/process diagrams, data flow/data model diagrams using MS Visio, and.
• Performed root cause analysis and identified the gaps and inconsistencies in the ETL process from the existing legacy system to cloud transition, resulted in approx. 30% improvement in the data conversion process.
• Collaborated with users to analyze current processes, then partnered with developers to design and implement new features that increased efficiencies by 15% within the supply chain group.

Bangalore, Karnataka, IN

• Managed teams of 100+ technical-functional experts and implemented 9+ ERP / business analytics projects for the fortune 500 manufacturing / retail firms across North-South America, Europe, and Asia-Pacific regions.
• Converted 3+ manufacturing facilities from legacy ERP systems to Oracle ERP systems, from development and training through post-migration for business transformation project and led Business Process Improvement groups.
• Built a Financial prediction model using SQL and Python with approx. 70% accuracy for minimizing the risk of losing money while lending to customers.
• Built an ETL data conversion tool using Oracle EBS, SQL stored procedures, and Unix scripting, which improved data conversion/migration efficiency on Oracle EBS 12.2.3 upgrade project by approx. 70%.
• Created ad-hoc reports using Excel, OBIEE, Power BI, and Tableau per demand/supply chain business requirements to lead functional teams in the development of standards, policy, and procedures.
• Developed Custom Ad-hoc Labels printing solutions resulted in approx. 30% reduction in cycle time when using hand-written labels, approx. 42% reduction in transaction/shipping errors, i.e., approx. 50% improvement in.

Columbus, Indiana, US

• Managed a global team of 100+ employees spread across 3 regions (the United States, India, and Brazil).
• Provided expert ERP techno-functional guidance including configuration review and setup, Order Management Transactions setups, Drop Ship/Back to Back/ RMA/Internal Sales Order Implementations; functional.
• Re-designed the Oracle Mobile Supply Chain Modules from old to new versions and conducted training sessions for 500+ business super users/3rd party vendors, which increased user confidence and resulted in approx. 30%.
• Designed inventory model using Python and SQL to evaluate the optimum purchasing strategy for durable goods, optimal service level for perishable items, reducing the daily average cost of under-ordering and.
• Created and implemented comprehensive unit test plans with cross-functional teams during the SIT and UAT phase for Oracle EBS R12 upgrade, which eliminated a significant number of bugs and improved the overall.
• Designed new Purchase Order Receipt Screen using Oracle MSCA, which can transact receipts and print adhesive labels for the goods, thus improving warehouse productivity by approx. 40%.

IN

• Analyzed and re-designed various custom API's used by B2B & B2C Operations using SQL and Java, thus resulting in approx. 60% improvement in productivity.
• Developed interactive reports regarding supply planning delivery performance across multiple stakeholders using Tableau and KPI's to measure ERP system and supplier performance.
• Streamlined processes and resolving conflicts by hosting a series of meetings/seminars, resulting in approx. 70% decrease in code bugs from development.
• Increased operational efficiency by eliminating the non-value-added activities, optimizing the queries, and managing higher-end corporate clients.

Palo Alto, CA, US

• Leveraged IT project tollgates to reduce cycle time for product cross-references by 85%
• Acted as administrative assistant to the IT manager using Microsoft Excel, Outlook and Visio
• Assisted in the Project Management process by creating project plans using MS Project.
• Performed user acceptance testing for upgrading the internal brand standards website with a 90% pass rate.

Hyderabad, Andhra Pradesh, IN

• Developed an e-Commerce website using Java, and SQL resulted in increased store sales by 5%.
• Restructured relational database using SQL to reduce unwanted data resulted in a 27% increase in performance.
• Created stored procedures by using SQL to automate the insurance premium calculations for 10M+ customers.
• Analyzed key performance indicators, metrics & data patterns in Google Analytics to drive higher customer segmentation.

Gurgaon, Haryana, IN

• Design, configure, troubleshoot TCP/IP and WLAN network infrastructures for corporate clients.
• Consistent top case closer with an average of 100+ cases closed per month during the internship period.
• Handle all initial product support requests and manages the inbound initial Service Requests(phone, e-mail, and web) from both External and Internal Customers.
• Replicate network issues and provide workarounds and solutions to customer/partner base.