Summary
Overview
Work History
Education
Skills
Websites
Timeline
Generic

Sayma B. Hasan

Queens

Summary

8 years of Experience in Analyzing, Designing, Tuning, and Developing Client/Server, Business Intelligence solutions using BI Tools, SQL, RDMS, MS SQL SERVER & Data Warehouse/Data Mart Design, Project Development Life cycle.


Experienced in Database design, Creation of Logical and Physical DB Model. Good Understanding of the Requirements and Functionality of the Application & End Clients, Product Backlog, Scrum, Product Ownership, Azure, Software Development Life Cycle (SDLC) methodologies like Agile, JIRA, Scrum, Waterfall, and Project Management Methodologies.


Skilled in Business Intelligence tools - SQL Server 2008 Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS), Visualization tools- Power BI, Tableau.


Experienced in designing and deploying Graphic visualizations with Drill-Down and Drop-down menu option and Parameters, Conversion of Existing Reports into Tableau Dashboard using Tableau, Score cards with executive summary dashboards to display performance monitoring measures with Tableau.


Experienced in Calculated Columns & Measures, Power Query to Pivot & Un-pivot data model for Data cleanup in Power BI and Excel as per requirements.


Experienced in Multi-Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, Data Flow & Control Flow diagrams, Data Mapping Sheet, FACT and Dimensional tables by using modeling tools like ER Studio (Data Architect) & VISIO.


Experienced in Implementation of Data cleanup procedures, T-SQL queries, Stored Procedures, Views, Indexes, Cursors, User Defined Functions (UDF), Relational Database Models and Data Integrity to implement Business Logic and Data Protection, Execution of Packages for Destination.


Excellent in High Level Design of ETL, SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, flat files, Text Format Data, XML) by using multiple transformations provided by SSIS such as Execute SQL Task, Data Flow Task & Active Involvement in migration of legacy data by creating various SSIS packages.


Experienced in developing dataflow using transformations like Slowly Changing Dimension (SCD), Data Conversion, Join, Merge, Union-All, Lookup, Fuzzy lookup, Aggregator, Rank, Filter, and other transformations.

Overview

9
9
years of professional experience

Work History

SQL Database Developer

Vantage Risk
06.2022 - Current
  • Gathering Business Requirements from Underwriters during BRD & User interface sessions, documenting the BRs, Analyzing & Translating requirements through understanding future application’s possible and proposed design of data system and business logic
  • Evaluating the Existing application’s DB data system for integration and proposed appropriate solution
  • Involving in Translating the Business Requirements into Technical Requirements, Designing Database, Implementing Conceptual, Logical & Physical Database Modeling, Database Design, Data Analysis, Scripting, Documentation, and Implementation
  • Creating conceptual, logical, and physical model of application’s database, Established the relationships among entities and referential integrity among schemas in the database through SSMS and ER Studio
  • Writing Scripts for Migration from one application to another application by creating Gap analysis, Data Mapping sheets, added additional Data fields and Wrote scripts to migrate data from one server to different server
  • Rebuilding indexes and Normalized Database, Store Proc, Database development for the application has implemented
  • Creating QA, UAT, Production DB for applications and Implemented Unit test for Correct Data Load in QA, UAT Database
  • Generating Ad-hoc reports in Excel Power (Pivot), PDF, JPG, Power BI for Strategic Planning
  • Working in Snowflake through data role for the data extraction and redesign for the new application database design and wrote scripts for final load
  • This ETL process worked separately on Snowflake, SSMS to complete the migration loading successfully
  • Reviewing Modification in Conceptual, Logical and Physical models, DB design, Scripts as per Client’s Standard and requirements
  • Designing Unpivoting data field to integrate data into new application
  • Implementing data integration processes, including un-pivoting data fields, and extracting data from various sources such as CSV and Excel files
  • Extracting required data from the different sources (CSV files, EXCEL files), Storing data into the Staging
  • Database loaded data to final database using Import & Export Database, Data Analysis and Manipulation & Verification in Data for existing applications
  • Assisting in the design and implementation of conceptual, logical, and physical database models, ensuring data integrity, and establishing relationships among entities as per Erwin Model
  • Writing T-SQL scripting, stored procedures, user-defined functions, cursors, views setup and management of linked servers, Microsoft SQL Server 2018 to Non-SQL-Server databases.

MSBI Developer

BCBSVT
07.2021 - 05.2022
  • Designed & Created the Functional and Technical documents, Report templates and standards for the developers for BRD, Data Mapping Sheet, ETL Packages, Report development & visualization through SQL Server, SSRS, Power BI.
  • Designed conceptual, logical and physical concepts for Data Modeling of database on data architect and excel.
  • Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging & Implemented DAX functions for calculative visualization.
  • Generated Ad-hoc reports in Excel Power (Pivot), Power BI for Strategic Planning
  • Created SSIS packages for ETL to SQL Server instances in SSIS 2012/2014/2016
  • Designed and Executed complex SSIS packages to migrate data from multiple data servers, databases, cubes to create Reports/ Dashboards (SSRS, Power BI)
  • Extracted required data from the different sources (CSV files, oracle, and MS SQL 2000), Storing the data into the Staging Database, loaded data to final database using SSIS Packages and Navigators (Data Flow Tasks) using FTP
  • Experience in working with Azure Data warehouse, creation in T-SQL, Used Azure to maintain Product Backlog Items, User Stories, Tasks and Bugs
  • Prepared Weekly/Monthly/Quarterly reports in MS Excel, PDF, HTML, & XML etc
  • Worked in Creating hierarchies for Dimensional Models like date dimensions and region dimension tables, Browsing the cube for analysis and validation of the data, Processing the cubes and dimensions using the SSIS tasks
  • Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports on SSAS using MDX, DAX and SQL
  • Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers, Microsoft SQL Server 2012/2014/2016 to Non-SQL-Server databases.
  • Designed interactive dashboards in Power BI (Power View) using BRD and implemented data cleansing and manipulation using Power Query and DAX functions
  • Developed SSIS packages for ETL processes in different versions of SSIS (2012/2014/2016) and migrated data from multiple sources to create reports and dashboards (SSRS, Power BI)
  • Extracted data from various sources and loaded it into staging databases using SSIS packages and navigators (data flow tasks)
  • Developed complex reports using SQL Server Reporting Services (SSRS), including drill-down reports, sub reports, and parameterized reports
  • Implemented advanced features of SSRS, such as caching, subscriptions, and data-driven subscriptions for automated report delivery
  • Designed and customized report layouts, formatting, and branding using SSRS report builder
  • Prepared reports in various formats such as MS Excel, PDF, HTML, and XML
  • Conducted proof-of-concept (POC) projects for migrating on-premises BI platforms to Azure Cloud and worked with Azure Data Factory for data loading
  • Proficient in T-SQL programming, stored procedures, user-defined functions, cursors, views, and management of linked servers with Microsoft SQL Server versions 2012/2014/2016.

MSBI Developer

Ciox Health
04.2019 - 07.2021
  • Involved in planning, defining, and designing database using Erwin on business requirement and provided documentation
  • Translating Business Requirements into technical design specifications
  • Designed SSIS Packages to transfer data from various sources such as Text Files, XML Files, Excel, Flat files to SQL Server 2012
  • Involved in building and maintaining SSIS Packages to import and export data from various data sources using BIDS based the design data models
  • Installed and configured and maintained Power BI Report Server
  • Created Power BI dashboard and generated reports using SQL server & Lock objects on the reports
  • Created reports on Power BI Desktop and published them on Power BI Report Server
  • Created access for users to use the Power BI reports on the web and across mobile devices
  • Worked with data transformations slowly changing the dimensions (SCD), aggregates, sorting, multicasting, conditional split, and derived column for SSIS Packages
  • Designed, reviewed, and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints
  • Designed and developed Tabular Model Cubes using SSAS 2012
  • Developed calculated columns and measures using DAX
  • Used Microsoft Power BI Power Query for ETL from external sources and modified data to certain format as required in Excel and created SSIS packages to load excel sheets to database
  • Experienced in T-SQL queries, stored procedures for SSIS packages, SSRS -Tableau -Power BI Reports
  • Created user interface reports using Tableau sheet objects like List Box, Input Box, Buttons, Text Input, Slider, Bookmarks, Charts (Pivot/Straight tables, Pie, Bar, Line etc.) Created and scheduled tasks for reloading and distribution of Data in Tableau
  • Designed, developed, and deployed reports in MS SQL Server environment using SSRS 2012
  • Created reports to retrieve data using Stored Procedures and parameterization
  • Used SQL Server profiler for Auditing & Analyzing the events during run time, scheduled time and stored in script
  • Used SQL Profiler T-SQL Duration template for tracking execution time of TSQL Statements, performance tuning
  • Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software
  • Performed daily tasks including backup and restore by using SQL Server 2012 tools such as SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

SQL Developer

FNB Bank
10.2016 - 04.2019
  • Collected Business Requirements from analyst and translated them as technical specifications, designed database and documents for development
  • Experience in installing, configuring, managing, and monitoring SQL Server 2000 to 2014 Servers
  • Involving in new SQL Server builds on Cluster servers along with the pre-and post-steps and patching on standalone servers
  • Worked extensively on OBIEE Answers to create the Financial Statement reports (Income) and Intelligence Dashboards Financials as per the detailed design requirements
  • Extracted Data and Created Dashboard on Monthly, Quartey, half-yearly, yearly Revenue, Equity, Loan Growth & Reimbursement, Marker Leverage ratio, credit default swap, Average Common Equity tier, Bank Profitability reports through power-bi
  • Developed and implemented ERP customizations, Run, Manage ERP mobile device upgrades and Address validation software
  • Migrated data from other servers (Cosmos) to SQL for using them in creating Dashboards
  • Worked on High Availability technologies log-shipping, failover clustering management, database mirroring
  • Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and reloaded the data into target data sources by performing different kinds of transformations like Conditional Split, Derived Column, Data Conversion, Look Up, and Merge Join as required using SQL Server Integration Services (SSIS)
  • Assisted in designing and implementation of extension to ERP systems on basis of outline specifications
  • Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse
  • Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, Parameterized Reports
  • Generated parameterized queries in SSRS 2008/2012/2014 using data from SSAS Cubes and various heterogeneous data sources
  • Implemented the SQL agent jobs creation while deploying the database instance itself by adding them on to the post deployment scripts
  • Generated ad-hoc reports in Excel Power Pivot and shared them using Power BI to the decision makers of strategic planning
  • Optimized the SSAS tabular model process speed by properly designing data models and optimizing DAX calculations
  • Created Data Source and Dataset using OLAP Cube to create Tabular and Matrix reports as per user requirements
  • Developed Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions, and data source view
  • Created SSIS packages and scheduled the jobs to run automatically to process the cube and load data
  • Interacted with Business Analysts and Users in requirement gathering, built complex queries & stored procedures using PL/SQL
  • Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints on various database objects to obtain the required results
  • Prepared Documentation for the Stored Procedures consuming the greatest amount of CPU resources, taking the longest time to run and which performs the most physical and logical I/O operations using Dynamic Management Views and Functions
  • Created Talend jobs to copy the files from one server to another and utilized Talend FTP components.

SQL Developer

Argus Information and Advisory Service
11.2014 - 04.2016
  • Gathered Business Requirements from SME and User interface sessions and documented the query, business analysis & reporting needs
  • Understood data and business logic with reports
  • Involved in Translating the Business Requirements into Technical Requirements and Dimensional Modeling
  • Created and documented Standard Operating Procedures (SOP) for Enterprise Monitoring
  • Created ad-hoc reports to users in Tableau by connecting various data sources
  • Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and reloaded the data into target data sources by performing different kinds of transformations like Conditional Split, Derived Column, Data Conversion, Look Up, and Merge Join as required using SQL Server Integration Services (SSIS)
  • Assisted in designing and implementation of extension to ERP systems on basis of outline specifications
  • Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently
  • Developed, published customized interactive reports and dashboards, scheduled data refreshes on reports using Tableau Desktop and Serve
  • Generating various Monthly, Quarterly, Bi-Yearly, Yearly, and random ad-hoc reports using SQL Server Reporting Services (SSRS) for various in-house users and for reinsurers and producers
  • Generated parameterized queries in SSRS 2008/2012/2014 using data from SSAS Cubes and various heterogeneous data sources
  • Interacted with Business Analysts and Users in requirement gathering, built complex queries using SQL and wrote stored procedures using PL/SQL
  • Developer Technical designs and testing services in Oracle based financial and ERP applications
  • Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints on various database objects to obtain the required results
  • Prepared Documentation for the Stored Procedures consuming the greatest amount of CPU resources, taking the longest time to run and which performs the most physical and logical I/O operations using Dynamic Management Views and Functions
  • Created Talend jobs to copy the files from one server to another and utilized Talend FTP components
  • Designed and developed the user interface using JavaScript, and XHTML
  • Use Teradata to Understand the historic data in warehouse and for the transfer & load from Teradata to csv file for future data modeling.

Education

Skills

  • RDMS Development and SQL
  • SQL Server Management Studio (SSMS)
  • SQL Server Query Editor, Solution Explorer
  • SQL Server data tools (SSDT), SSIS, SSRS,
  • Azure SQL DB
  • Data Stage, Data Structures, Data Storage and Retrieval, Data Modeling
  • Virtualization on PowerBi, Tableau
  • Requirements Analysis and Design Phases
  • Product/Software Development
  • Process & Technical Documentation
  • SQL Code Validation
  • SQL Continuous Integration & ETL Development
  • Database Management
  • Back-End Development
  • Agile & Scrum Methodologies
  • Documentation Management

Websites

Timeline

SQL Database Developer

Vantage Risk
06.2022 - Current

MSBI Developer

BCBSVT
07.2021 - 05.2022

MSBI Developer

Ciox Health
04.2019 - 07.2021

SQL Developer

FNB Bank
10.2016 - 04.2019

SQL Developer

Argus Information and Advisory Service
11.2014 - 04.2016

Similar Profiles

CREATE PROFILE
Sayma B. Hasan