Hasan S Email & Phone Number

United States

United States

New York, Ny, Us

• Developed complex and customized stored procedures and queries for implementing business logic for data extraction, reports, and other client interfaces• Worked with multiple stakeholders to get the requirements and communicated to the team and guided them in implementation and delivery of the project• Identified ways to improve team’s productivity and implemented agile methodology• Helped the team in schema design, complex SQL queries and data cleansing• Supported BI teams to help them implement complex BI systems• Experienced in managing and automating control flow, data flow events• Managed and designed the reporting environment, including data sources, security, and metadata• Analyzed data and performed data cleansing, profiling, and stratification to organize the data• Prepared high level & qualitative analysis to observe patterns and relationships in data and produce reports using with SAS and Tableau visualization• Worked on data mapping, querying the source and target tables in the database using SQL for testing purposes• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop• Analyzed data set using Tableau Desktop and did data reshaping, to extract points of interest for the business• Conducted inventory analysis, draft reports, and handle inventory databases to help managers make good decisions regarding inventory purchases using Excel Pivot Table

Lake Success, Ny, Us

• Designed and developed data warehouse using the Microsoft BI Stack and created Star Schemas for BI applications• Analyzed daily of the data reporting operations. Identified and developed insight to reduce data quality issues and process gaps• Used different types of visualizations Like (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer etc.) in Power BI according to the requirements• Worked on stored procedures for processing business logic in the database• Created calculated fields and parameters along with the appropriate filters and plotted the measures on the respective graphs using Microsoft Power BI data visualization tools• Expert in designing and creation of Power BI storyboards which can give a summarized story of the data about the business.• Published dashboard, reports to online Power BI cloud service for the use of report consumers• Created dashboards and interactive visuals using BI tools and worked with technical teams to ensure the success of BI projects• Created measures, calculated columns, relationships and performed time series analysis using DAX in Power BI• Generated reports from multiple systems and troubleshooted the reporting database environment and reports• Performed Data collection, Data Cleaning, features scaling, features engineering, validation, Visualize, interpret, report findings, and develop strategic uses of data by python libraries like NumPy, Pandas, SciPy, Scikit-Learn• Worked on data profiling and data validation to ensure the accuracy of the data between the warehouse and source systems• Translate business requirements to source to target data mappings, and complete data profiling and data quality assessments• Identified and addressed critical issues, took initiative, and implemented action plans to improve project performance

Boston, Massachusetts, Us

• Researched, developed, and implemented data collection systems and other strategies to optimize statistical efficiency and data quality• Interacted with Business analysts to understand data requirements to ensure high quality data is provided to the customers• Supported data warehousing extraction programs, end-user reports and queries• Involved in analysis, design and documenting business requirements and data specifications.• Worked on numerous ad-hoc data pulls for business analysis and monitoring by writing SQL scripts• Performed verification and validation for accuracy of data in the monthly/quarterly reports• Worked on Advanced SQL skills, fluent in R and/or Python, advanced Microsoft Office skills, particularly Excel and analytical platforms• Converted Scripts from Oracle to Teradata• Developed and executed business reports using the Teradata SQL advanced techniques like rank, row number etc.• Worked with Tableau to create dashboards, stories, and other visual displays to provide clear and insightful comments• Designed and developed 18 corporate dashboards used by the executives and compiled, analyzed, and reported various operational claims data from multiple sources• Designed stunning visualizations using tableau software and publishing and presenting dashboards on web and desktop platforms• Designed and deployed reports with Drill Down, Drill Through and Drop-down menu option and Parameterized and Linked reports using Tableau• Used advanced Microsoft Excel and the XLOOKUP function to efficiently create pivot tables and pivot reporting• Participated in UAT sessions to educate the business users about the reports, dashboards, and the BI System