Tahreem Saeed

Worked On ERP modules of HRM ,Production and Finance. Build Forms using Windows Form,C# SQL. Created Reports Using SSRS and Crystal Reports. Modified/Designed SP's and formulated basic coding and scripting to be utilized for reports within the organization. User defined functions, Views, T-sql scripting for complex business logic. Optimized the database by creating various clustered, non-clustered indexes. Generated various Monthly, Quarterly, Bi-Yearly, Yearly reports by different type of reports using SSRS. Scheduled and managed daily/weekly/monthly sales and operational reports based on the business requirements. Set database permission, backup,SQL Server jobs. Configured SSRS Server for reports deployment.

Worked with Process Engineering team on Visual Factory System, CMMS and Energy Monitoring System. Developed different dashboards, production trends, quality graphs and other related reporting as per management need using Sql Server reporting services SSRS & MS Excel. Developed SMS based Alert system on machines parameters and Manufacturing Rework together with automation team using SQL Triggers. Developed Statistical Process Control Charts for foaming department Developed and Implemented Key Performance Indicators (Like OEE, FIFO, DIFOT, FPY etc). Developed production counters using ASP.Net & C#. Developed Data warehouse and Extract & transform data using SQL Functions, Procedures, and Views via open query and linked server using dynamic sql. Created and Scheduled Jobs in SQL to load data in to data warehouse. Developed Email based alert system if any SQL job is failed to execute on time Create, update and delete users from database and Maintains and troubleshoot SSRS Server. Monitor database performance and create indexes where required