Now you can Instantly Chat with Neyaz!
About Me
Masters in Information Technology with 10+ years of experience in IT industry holding US B1 Visa. Having 7+ years of extensive experience in MSBI...
- Hands-on experience on designing, developing and configuring ETL packages using SSIS.
- Worked extensively on data extraction, cleansing/data integration, and loading from different data sources using SSIS.
- Hands-on experience on designing, developing and enhancement of reports using SSRS, Crystal Report and MS Power BI.
- Experience in job scheduling by using SQL Server Agent.
- Experience in scheduling and deploying reports on report manager.
- Hands-on experience in developing complex T-SQL scripts, stored procedures, temporary tables, functions, Views, CTE’s etc.
- Expertise in implementing business logic using Views and Stored Procedures and Proficient at Performance Tuning with a solid knowledge of Optimizing Code.
- Good in problem analyzing, solving and troubleshooting skills.
- Ability to support critical business requirements and timelines.
- Involved in optimization of the query using indexes.
- Good experience using dataflow transformations Lookup, Derived column, Merge, Merge Join, Fuzzy Lookup.
- Good knowledge in developing different types of Reports and deploying, managing reports using SQL Server Reporting Services, Crystal Report and MS Power BI.
- Expertise in implementing reports using Drill Down, Drill through, Sub reports Linked reports.
- Having good Knowledge using Check points, event handlers, exception handling and package Configuration.
- Having knowledge in data ware house and data mart.
- Quick learner and ability to meet tight deadlines and works under pressure
- Has Exposure on Customer Relations, Team Management and Team Building Activities
Skills
Positions
Portfolio Projects
Description
RESPONSIBILITIES:
- Understand client Specification Document.
- Involved in developing the SSIS package as per the client requirement specification document.
- Used transformations like Conditional Split, Data conversion, Derived column, Row count, aggregate, sort, multicast, Union all, script, Lookup and SCD.
- Involved in Sequence Container task, Dataflow task and Execute SQL task.
- Worked on SSIS Package, Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
- Created Complex ETL Packages using SSIS to extract data from Master tables to staging tables with full and incremental load.
- Performed operations like Validation and error handling after Extracting data into SQL Server.
- Involved in Implementing the SQL queries as per the requirement specification document.
- Involved in bug fixing which is raised by the testing team.
- Involved in creating documentation.
- Performed unit testing as per the test case document.
Description
DESCRIPTION:
Red Tag Management System (RTMS) prints tags and sends report to the operators to isolate the devices to control and restrain energy sources using an Energy Control Operating Procedure. The Plant Administrator has the ability to add users and tags to control all isolating devices.
DATA MIGRATION PROCESS DESCRIPTION:
Enterprise Master Data for Functional Location, Plant and Equipment are extracted on a weekly basis or on demand from SAP to CSV file. The source CSV file is then transferred to staging directory in SQL Server Integration Services (SSIS) server for further processing.
Show More Show LessDescription
DESCRIPTION:
SDW is used to collect and send data from many applications to the Coop's data warehouse. It is a data warehousing system performing ETL activities. It receives data from Swedish Stores and Warehouses and other sources. After processing of data, it sends the data to Central Data Warehouse system at Denmark. Denmark receives data from Norway region as well. It receives aggregated Sales data and detailed receipt transaction data from stores. It receives Labor Data from Delivery System. This data is receipt from vendor warehouse to store. It also receives Article and Store master data from ERP. There are around 20 diff source systems and for each source 600 files are received, processed and load into data warehouse.
RESPONSIBILITIES:
- SSIS, SSRS and Crystal Report Applications Support.
- Involved in Database, SSIS, SSRS and Crystal Report bug fixing.
Description
The TPA architecture is based on MSBI technologies, connected with ERP and SAP etc. systems in USA which provides data to be loaded in TPA systems and generate the standard SSRS/Crystal Report/ MS Power BI Report/Excel reports for business users. The sales and customer data is being extracted from the SAP source systems using SSIS. The sales and customer data extracted on a daily, monthly and yearly basis from SAP to CSV file. The source CSV file is then transferred to staging directory in SQL Server Integration Services (SSIS) server for further processing.
TPA is a data warehouse which stores contract and claims information from multiple systems for multiple products to perform financial processing.
Show More Show Less