| Trying to reach you for Microsoft BI with SAP - 100% Remote at Remote, Remote, USA |
| Email: [email protected] |
| From: Ajay, Yochana IT [email protected] Reply to: [email protected] H i, I hope you are doing well and having a great day! I wanted to reach out to you regarding a Contract job opportunity as Microsoft BI with SAP 100% Remote . Client has a strong reputation for being one of the leading employers in the industry. After reviewing your qualification and resume, I feel you would be a good fit for this role. I have listed some of the main requirements for this position below for your review. Position Name Microsoft BI with SAP Type of hiring C ontract Location Remote USA Job Description: Microsoft Business Intelligence with SAP Ticketing Tax Data Warehouse SQL Server Microsoft Business Intelligence (SSIS SQL Server Integration Service & SSRS SQL Server Reporting Service, SQL Server & SAP DART) SAP Ticketing - Based on reports (Quarterly, Monthly, and Yearly) Fixing issues on DART/SSIS/SSRS/SQL Server Additional Information: As a team, we work on ETL monthly - SQL tasks and generate flat files for validation by the tax team. These files must be updated promptly on the spreadsheet and secure drive. We also perform reconciliations and validations from our end. ETL tasks are performed on Company Codes. We create SQL tables (stage and facts) every month on SQL Server to compare transactional data and data for Recon, Non-Recon, and Trial Balance files from SAP-DART. Any additions of new profit centers or GL accounts require updating the master tables accordingly. Stage and fact loading, reconciliations, and flat file generation are done using stored procedures. This process must be performed for all company codes to ensure reconciliation. During year-end activities, coordination with the tax team on the PC Hierarchy list is necessary, and the processes are repeated for periods when new Profit Centers/GL Accounts were added. Ensuring no GL account balance mismatches is crucial, as the tax team requires accuracy. We also work on SSRS Reports for all company codes. After the GL Close, SAP DaRT extracts and views need to be manually scheduled and monitored. Process dates/times will be updated. Prior to scheduling, coordination and checks with the LAR contact are required. Transaction Data (TD) Extracts are scheduled for the following company codes Master Data (MD) Extract is scheduled for company codes every month and for the remaining company codes during year-end. Trail balance data extracts are performed for company codes. View files are generated on a monthly basis for the following company codes. Audit requests for previous years are handled. Additionally, she takes care of any tickets related to server configurations, SQL server, and secure share drives for North America and Canada, as well as any other foreseen issues. As part of year-end on the DART end, she updates the Profit Centers/GL accounts to perform extractions and schedule views. After completing all the above processes, she informs the NCI Tax team and TDWH team (both of us) that the views are ready, so we can proceed with the work on the TDWH side. She also performs TDWH year-end activities on the flat files, including zipping and password protecting the files and burning them onto DVDs/flash drives to meet Nestle compliance requirements. Three sets of DVDs need to be prepared once all the year-end processes are complete. Thanks & Regards, Ajay Yochana IT Solutions INC , 23000 Commerce Dr, Farmington hills, MI-48335 Lets Challenge The Status Quo Keywords: cprogramm business intelligence information technology Maryland Michigan Trying to reach you for Microsoft BI with SAP - 100% Remote [email protected] |
| [email protected] View all |
| Tue May 28 19:55:00 UTC 2024 |