Khandaker Zaman

Business Data Analyst Bi Developer @Wintrust Financial Corporation

Rosemont, IL, US

Responsibilities:• Elicited requirements from stakeholders through interviews and facilitated joint application development (JAD) sessions to extract & understand business objectives • Analyzed client\'s business requirements and processes for project scope• Drove the process of collecting and documenting business requirements, developing UI mockups, creating the functional documentation, and assisting with the development of QA test scripts • Utilized configuration tables to update multiple SSIS packages simultaneously.• Create reports and visualizations to users in Tableau and Power BI by connecting to various data sources (MS SQL Server, Oracle, MS Excel, CSV….). • Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.• Configured SQL mail agent for sending automatic emails when SSIS packages fails or succeeds.• Worked on different packages with various types of transformation tool like: Lookup, fuzzy Lookup, derived column, join, merge join, conditional split and slowly changing dimension.• Worked on Master Data Management (MDM) for maintaining the customer information and also for the ETL rules to be applied.• Worked with internal architects and, assisting in the development of current and target state enterprise data architectures• Tune ETL procedures and STAR schemas to optimize load and query Performance.• Worked with project team representatives to ensure that logical and physical data models were developed in line with corporate standards and guidelines.• Designed Tableau and Power BI dashboard which give a visual representation for the users on MTD sales growth, Visual analytics on injuries, dealer location map etc.• Build regular ad-hoc reports using SSRS SQL Server Reporting Services with help of various tools