Fatehul Islam Email & Phone Number

Philadelphia, Pa, Us

Pennsylvania, United States

1. Been part of production support to work with Business Finance, Customer Service teams tohandle any data issues, data analysis, data verification, change requests, and Ad-hoc /Production report requests.2. Migrated Databases, SSIS packages, cubes, reports, SQL agent jobs, folder structures fromSQL Server 2008R2based servers to SQL Server 2012 based servers (DEV, LAT BCP and PRDetc.) It involved SQL changes based on new change requirements, Software installation,Database backup/Restore, SSIS package configuration files, SSRS report deployments Cubeprocessing, Linked server settings and Agent job settings.3. Created/modified ETL processes to achieve daily monthly loading requirements.4. Created/maintained stored procedures. SSIS packages. Agent job settings to ensure they areapplied with new business rules, including loading additional files, and applying newvalidation logics, by adding/changing Stored Procedures, and SSIS package.5. Built more than 30 production formatted reports with automation process by using SQL,SSRS Agent Jobs and Report Manager.6. Used SSIS control flow such as using Execute SQL Task, File System Task, Script Task,Foreach Loop container and Execute Package Task to create modified daily/monthly ETIprocesses.7. Used SSIS data flow such as using Derived Column. Data Conversion Conditional Split,Lookup, and Row Count, Slowly Changing Dimension for day/monthly ETL,Processes.8. Used SSRS to generate formatted production reports, including drill through drill down,parameterized reports and sub-reports, with Stored Procedures and Expressions. Andfamiliar with dynamic report snapshots. and subscription.9. Used knowledgeable in scheduling and security settings on Report Manager togrant/limit access for business.

Pennsylvania, United States

1.Developed Advanced SQL queries and stored procedures to generate data reports Dug infodatabase details to ensure appropriate data filters, randomizations, and stratifications areapplied based on business requirements. Have successfully delivered 40 data sample reportson time in all 2-month delivery cycles.2. Performed SQL query performance tuning by creating/modifying indexes, setting transactionisolation levels, and changing query structures (used CASE to reduce table scans/seeks, usedCTE and inline calculation to replace sub-query-involved functions used ad-hoc workloadsoption to reduce procedure cache usages used temp tables to reduce repeating retrieving, etc.).3. Successfully reduced queries duration time by 50%-300%4. Built extract, and load (ETL) process to migrate data from multiple types of data sources (SQLServer DB2, Oracle, Sybase, Excel, Flat files, SharePoint, Email Boxes, etc.) to destinationdatabase server by using SSIS packages, VBA, and Export/Import wizard.5. Prepared and updated documentations (Data Analysis Forms, Data Mapping File BusinessRequirement Description Procedure Documentations File, Population Files, Data validationform, etc. to ensure procedures and knowledge are traceable in future cycles.6. Presented excellent work attitude and communication skills with multiple teams anddepartments.