Materials Mgmt Analyst II

Experience in custom SharePoint Designer (on premise) / Agile Point Workflow, Forms using InfoPath, custom Web Parts, CSOM PowerShell, Power BI & Automate, Content Types, Timer Jobs, Event Receivers, Master Pages & Page Layouts & Good exposure to CSOM, JSOM, SSOM, JavaScript & jQuery.
Develop end to end Data warehousing application using MS SQL Server.
Proven proficiency at Data Transformations like Lookup, Derived, Split, and Sort, data Conversion, Union All, Merge Join, SCD and OLEDB Command to load data into SQL Server destination
knowledge in AZURE platforms, ADF, Snowflake, logic apps.
Knowledge on power apps and power automate.
Extensively used various SSIS control flow tasks like Loop Containers, SQL Server Agent jobs, Script, FTP, Web service task, Bulk insert task, Transfer job task.
Implement Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
Report and Metrics Publishing using Tableau.
Job Responsibilities:

PERCENT JOB ACTIVITY
60% Support Process & Technical on day-today Deliverables
30% Support Master data creation/extension/changes in SAP
10% Train business/end user on process
100% TotalDesired Candidate:
Bachelors degree in Computer Science, Business or Manufacturing.
Fundamental knowledge of concepts, practices and procedures of data management.
Previous role as SAP MM creation /extension/change and broad knowledge of supply chain and manufacturing business rules.
SQL , Sharepoint , SSISTechnical skill set.
knowledge in AZURE platforms, ADF, Snowflake, logic apps.
Knowledge on power apps and power automate.
Develop Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards working with Business Analysts to streamline any data issue, which involves Unit Testing of all the Reports.
Gather and documented business requirements for analytical reports. Participated in requirements meetings and data mapping sessions to understand business needs. Identified and documented detailed business rules.
Knowledge of overall business practices including manufacturing, supply chain, procurement and data management are essential.
Understanding of Engineering and New Product Introduction (NPI) processes
Generate monthly reports and Data Progress report/Metrics