• Designed and created ETL code installations, aiding in transitions from one data warehouse to another.• Identified, troubleshot and corrected bugs and bottlenecks.• Analyzed existing SQL queries to identify opportunities for improvements.• Working with SQL Server, Oracle 11g, SQL Developer and TOAD.• Migration experience from Oracle 11g to SQL Server 2019.• Designed and implemented TSQL queries for reporting and complex solution development.• Developed various… Show more • Designed and created ETL code installations, aiding in transitions from one data warehouse to another.• Identified, troubleshot and corrected bugs and bottlenecks.• Analyzed existing SQL queries to identify opportunities for improvements.• Working with SQL Server, Oracle 11g, SQL Developer and TOAD.• Migration experience from Oracle 11g to SQL Server 2019.• Designed and implemented TSQL queries for reporting and complex solution development.• Developed various Drill-through reports, parameterized reports, tabular reports, matrix reports and linked report using SSRS.• Familiar with business intelligence tools such as Power BI.-- Italian ----------------------------------------------------------------------------------------------------• Progettate e create installazioni di codici ETL, aiutando nelle transizioni da un data warehouse all'altro.• Bug e strozzature identificati, risolti e corretti.• Analizzato le query SQL esistenti per identificare opportunità di miglioramento.• Lavorare con SQL Server, Oracle 11g, SQL Developer e TOAD.• Esperienza di migrazione da Oracle 11g a SQL Server 2019.• Domande TSQL progettate e implementate per report e sviluppo di soluzioni complesse.• Sviluppato vari report drill-through, report parametrizzati, report tabulari, report a matrice e report collegati tramite SSRS.• Conoscere strumenti di business intelligence come Power BI. Show less

• Up-to-date higher management with progress of ongoing projects.• Provided technical support using knowledge of complex technology to solve problems and support new projects.• Designed and implemented TSQL queries for reporting and complex solution development.• Implemented Retail pro (retail management software) at ChenOne Stores.• Integrated Retail pro with Sage 300 ERP-- Italian… Show more • Up-to-date higher management with progress of ongoing projects.• Provided technical support using knowledge of complex technology to solve problems and support new projects.• Designed and implemented TSQL queries for reporting and complex solution development.• Implemented Retail pro (retail management software) at ChenOne Stores.• Integrated Retail pro with Sage 300 ERP-- Italian --------------------------------------------------------------------------------------------------• Gestione superiore aggiornata con lo stato di avanzamento dei progetti in corso.• Fornito supporto tecnico utilizzando la conoscenza di tecnologie complesse per risolvere i problemi e supportare nuovi progetti.• Domande TSQL progettate e implementate per report e sviluppo di soluzioni complesse.• Implementato il software di gestione al Retail pro (Retail Management Software) presso ChenOne Stores.• Retail pro integrato con Sage 300 ERP. Show less

• Identified new ideas, products and/or features that improved customer satisfaction, reduced costs and kept the product line in the forefront of industry.• Designed and created SQL databases, tables, indexes, and views, user defined functions, stored procedures, and triggers to support business applications and modified already existing stored procedures, triggers and Views.• Developed Drill-through reports, parameterized reports, tabular reports, matrix reports, linked report and… Show more • Identified new ideas, products and/or features that improved customer satisfaction, reduced costs and kept the product line in the forefront of industry.• Designed and created SQL databases, tables, indexes, and views, user defined functions, stored procedures, and triggers to support business applications and modified already existing stored procedures, triggers and Views.• Developed Drill-through reports, parameterized reports, tabular reports, matrix reports, linked report and periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS), Crystal Report, Power BI and Excel.• Customized and implemented Sage 300 ERP (cash flow and intelligence reporting) modules.• Developed and deployed of warehouse management system and integrated with Sage 300. -- Italian --------------------------------------------------------------------------------------------------• Identificato nuove idee, prodotti e/o funzionalità che hanno migliorato la soddisfazione del cliente, ridotto i costi e mantenuto la linea diprodotti all'avanguardia nel settore.• Progettati e creati database SQL, tabelle, indici e viste, funzioni definite dall'utente, stored procedure e trigger per supportare applicazioniaziendali e modificato stored procedure, trigger e viste già esistenti.• Sviluppato report drill-through, report parametrizzati, report tabulari, report a matrice, report collegati e report periodici basatisull'analisi statistica dei dati da vari intervalli di tempo e suddivisione utilizzando SQL Server Reporting Services (SSRS), Crystal Report,Power BI ed Excel.• Moduli Sage 300 ERP (cash flow and intelligence reporting) personalizzati e implementati.• Sviluppato e implementato il sistema di gestione del magazzino e integrato con Sage 300. Show less

• Creato e quando richiesto modificato, diverse strutture di database, query SQL complesse, sottoquery e sottoquery correlate utilizzandojoin, stored procedure, viste, trigger e funzioni definite dall'utente.• Lavori pianificati e mantenuti giornalmente, settimanalmente e mensilmente utilizzando SQL Server Agent in SSMS.• Sviluppato e modificato diversi tipi di report come Drill-through e Drill-down, sub report, grafici, report a matrice, report collegati e reportperiodici… Show more • Creato e quando richiesto modificato, diverse strutture di database, query SQL complesse, sottoquery e sottoquery correlate utilizzandojoin, stored procedure, viste, trigger e funzioni definite dall'utente.• Lavori pianificati e mantenuti giornalmente, settimanalmente e mensilmente utilizzando SQL Server Agent in SSMS.• Sviluppato e modificato diversi tipi di report come Drill-through e Drill-down, sub report, grafici, report a matrice, report collegati e reportperiodici utilizzando SQL Server Reporting Services (SSRS), Crystal Report, Excel e Power BI.• Creato, testato e implementato prodotti software scalabili, altamente disponibili e modulari.• Implementato e aggiornato Sage 300 (soluzione ERP) di Accpac e gestendo tre società, implementato anche i moduli Sage (IC, cespiti, flussodi cassa, Project Job Costing e Business Intelligence).• Sviluppato e implementato il sistema Point Of Sale (POS) e integrato con ERP Sage 300 (Accpac).• Sviluppato e distribuito Prestige Club (programma fedeltà) per ChenOne e integrato con POS e Sage 300 (Accpac).• Sviluppato e implementato il sistema di pianificazione delle vendite e della domanda e integrato con Sage 300 (Accpac).• Ha lavorato con project manager, sviluppatori, controllo qualità e clienti per risolvere problemi tecnici Show less

Managing all IT related new requirements and issues in ChenOne Stores all over the Pakistan.Development of new Software for ChenOne Stores based on recommendation of Management using VB.NET, VB6, SQL 2008 R2, Crystal Report.Member of SAGE 300 (ERP) implementation team. Implement four modules of SAGE 300 Inventory Control, Business Intelligence, Project and Job costing and Cash Flow. Also Customize these module according to user requirement.Providing IT technical support to All… Show more Managing all IT related new requirements and issues in ChenOne Stores all over the Pakistan.Development of new Software for ChenOne Stores based on recommendation of Management using VB.NET, VB6, SQL 2008 R2, Crystal Report.Member of SAGE 300 (ERP) implementation team. Implement four modules of SAGE 300 Inventory Control, Business Intelligence, Project and Job costing and Cash Flow. Also Customize these module according to user requirement.Providing IT technical support to All Branches of ChenOne Stores. Show less

In Chenab Ltd I handle the different issues in ERP and Design Front-End forms according to changing requirements.