Home

Jessy - ERP Business Analyst

[email protected]

Location: Algona, Iowa, USA

Relocation: Iowa

Visa: H1B

SUMMARY 7+ years of experience in Infor M3 Cloud Suite Industrial ERP domain, SQL, Snowflake Data Lake, UET, IDO based Reporting, PowerBI reporting, SSRS reporting and basics of web technology using WordPress, Dreamweaver, HTML5, CSS. Highly skilled in analyzing large data sets, data integration, ETL, data validation, data preparation, data quality check, reporting. Worked in Various Infor M3 ERP versions such as Syteline 8, 9 and Cloud (CSI 10). Experience in creating various Process Flow diagrams - activity diagram, product road maps, ER diagrams using MS Visio. Experience in Agile, SDLC and waterfall software methodologies. PROFESSIONAL EXPERIENCE ERP Data Analyst/ Developer (Feb 2020 Present) Methods Machine Tools Inc, Sudbury MA Developed and maintained productive working relationship with customers, team members and project leadership with ERP (Infor Syteline & Cloudsuite Industrial ERP software s) and CRM Business Process solution. Create reports and dashboards using Snowflake Datalake, Power BI reporting tool, Advanced EXCEL, SSRS reporting to solve complex business problems. Worked on implementing new cloud ERP version from Infor M3 (Infor 10/Cloud based platform) from Syteline 8. Implemented and Managed KPI s for Inventory, warehouse Management, vendors Scheduling, production, and shipping Experience in APS (Advanced Planning and Scheduling) and MRP (Material Requirements Planning). Worked on developing and implementing Dashboards with Calculations, Parameters, Maps, Trend Lines, Statistics, and table calculations using PowerBI desktop. Managed large and complex datasets using SQL/T-SQL and Excel to process business KPI s. Visualize and analyze solutions by developing dashboards, scorecards, analytic reports, presentations to find trends and anomalies in data. Worked in various modules of ERP such as Customer, Vendor, Purchase Order, Job Order, Service. Maintained and managed all versions of data models for production, testing and developing databases. Monitored existing inventory levels and cleaned up obsolete and slow-moving data for the new cloud-based ERP system. Analyzed effectively business functions to participate in analysis, design, and implementation. Supported Physical Inventory Management and Year End Process for the business in ERP system. Provided Analytical support for projects, continuous improvement, and cost savings. Interact with IT Manager, other departments and divisions outside technical contractors working on daily operations or ERP problems. Defined business, financial and operations requirements and system goals working with decision makers and end users. ERP Analyst/ Developer (Nov 2019 Jan 2020) Ruri Software Technologies, LLC Client: Methods Machine Tools Inc, Sudbury MA Worked on writing SQL/TSQL queries required for the ERP applications. Performed database and ETL (Extract / Transform / Load) to sustain and advance the Microsoft SQL Server s operational platform. Developed interactive dashboards in Power BI for advanced Data Visualization, Reporting and Data Mining. Data molding to envisage the database structure. Go over the query performance and optimize the code. Created database prompts for computerization, e.g., instant email notifications, etc. Crafted table indexes to help in improving the database s performance. Created and Modified views, several stored procedures, and functions for business requirement. ERP Analyst / Developer (Sept 2018 Nov 2019) Sankhya Solutions Inc, Columbus OH Worked with Syteline version 8 and 9 and was part of an upgrade to version 10. Created database objects such as tables, views, stored procedures, Triggers etc. Hosted various training sessions to interpret users problems, understand the functionality and respond with solutions. Performed referential integrity, domain integrity and column integrity by using the available options such as constraints etc. Created functions to provide custom functionality as per the requirements. Lead and analyzed design sessions in prototyping new systems to enhance business processes, operations, and information process flows. Used complex SQL Queries to perform back-end database testing. Assisted users in resolving problems and answered questions with minimal supervision. Data Analyst (Internship) (Aug 2016 - Jul 2017) Infozub, India Responsible for e-Document, testing and report testing. Coordinated in the analysis and design phase of the project. Worked on writing the code based on the functions and methods of the application. Carried out the debugging and troubleshooting of the program. Prepared the complete documentation of the entire application. Helped in training the users once the application is built and created. TECHNICAL SKILLS Data Visualization and Reporting Power BI, Snowflake DataLake, IDO based Reporting, SSRS Reporting, Tableau Technologies Infor M3, Infor Syteline ERP (Enterprise Resource Planning), XML, Infor CRM Programming Languages SQL/T-SQL, R, and Python Databases Microsoft SQL Server, Snowflake, Oracle, MS Access Modeling Tools MS Office Tools, MS Visio Coursework System Analysis & Design, Business Analytics, ERP, Web Technology, Data Structures, Databases, Basics of Accounts, Finance, Economics, Operations, Networks, Data Analysis RECOGNIZATION & CERTIFICATION Methods Machine Tools Inc Team Recognized me for being amazing every day and helping ERP system to run smoothly Every day. Microsoft certified : Analyzing Data with Power BI Udemy Certified : Business Intelligence Analyst Open Source Academy Certified : Web Developer & Designer EDUCATION Executive MS: Information Technology (May 2021 Dec 2022) University of Cumberlands, Williamsburg, KY MBA: Information Systems (Aug 2016 - May 2018) The University of Toledo, Toledo OH Bachelor of Engineering: Computer Science and Engineering (Jul 2012 - May 2016) Anna University (MCET), TamilNadu, India Keywords: business intelligence rlang information technology golang microsoft Kentucky Massachusetts Ohio