Hasina Ullah Email & Phone Number

New York, Ny, Us

Arlington, Va, Us

Responsible to analyze, design, develop, troubleshoot, and implement, standard and custom processes in ODI. Develop Extract Transform and Load (ETL) processes for ingesting data to the data Warehouse. Develop and maintain stored procedures, functions, views, materialized view and developing and maintaining complex SQL Queries using Oracle PL/SQL.Develop dashboards and reports using Oracle Analytics Server. Create high level technical design documents. Architect data warehouse environments and customize data models and Oracle Database table structure. Create and maintain the tables in Oracle including PK/FK and indexes.

Mclean, Va, Us

• Creating and updating the pipeline in Azure Data Factory including linked services, datasets, and schedules to the ETL process of supporting the dashboard.• Supported migration of SSIS packages from On-Premises into Azure Cloud environment.• Working on an ETL environment using SSIS to load the data from various data sources including Service Now, Excel files, CSV files into another database for the Warehouse. Loaded the data from the staging database to the production database. • Developing complex SQL Queries including Merge Statement, CTE, subquery, and different types of joins to develop or update stored procedures in SQL Server.• Developing Apache Spark SQL Queries and python code in the Databricks on a Big Data platform. Also, Supporting ETL processes for developing Data Warehouses using Databricks as well.• Creating tables and writing SQL queries in Azure Synapse. Also, writing pyspark code to load parquet files in notebooks including creating tables and writing SQL Queries.• Analyzing the data, creating reports, and providing information for data visualization including creating different types of graphs using Power BI to implement in the dashboard. Also, apply the DAX function to calculated columns, and transform the data including clean and well-structured data using Power BI. • Responsible for maintaining data warehouses and all related extraction, transformation, and loading the data using Power Query in Power BI from various sources.• Publishing the reports into Power BI Service and sharing the dashboards with users. • Used Visual Studio for source control management to develop and update SSIS packages including the process of deployment. Also, Azure Data Factory maintains GitHub for managing and deploying the code.• Developing Apache Spark SQL Queries and python code in the Databricks on a Big Data platform. Also, Supporting ETL processes for developing Data Warehouses using Databricks as well.

Jersey City, Nj, Us

• Working on creating and updating SSIS packages and importing/exporting the data from different source of files including CSV, Excel, and xml into the ClaimSearch database. Also, moving the data from one database to another database.• Writing complex SQL Queries including stored procedure, function, views, CTE, sub query, and different type of joins in SQL Server. • Using FileZilla to transfer the file (FTP) and loading the data into tables through Putty to refresh the data on Tableau. • Visualize and analyze the data using Pandas package and Numpy in Python and understand the dataset with the use of Anaconda.• Approaching and maintaining on data plan architecture to maintain the data quality. • Wrote Apache Spark SQL Queries, python code in the Databricks on a Big Data platform to validate the data for the Madesentry database.• Worked closely with BI team and support on production including analysis and design of integration solutions, data and reporting needs of internal and external stakeholders, and enhancements.• Wrote SQL Queries in Snowflake to validate the data and created the table as necessary.

New York, New York, Us

• Interacting with stake holders, business analysts, and other developers on the refinement and integration of customer data from various sources, ensuring that source data can be integrated and represented properly.• Loading large amount of history files using For Each Container and provides the data into proper case using different types of transformations in SSIS. Also, cleansing the data in database using SSIS Transformation and SQL Queries.• Load the data from different source files and one database to another database for the project of Fan Data Warehouse using SSIS through ETL process. Also, moved the data form one database to another database using Stored Procedure and SQL Queries. • Analyze the data using Pandas package and Numpy in Python and understand the dataset with the use of Anaconda 3.6.• Involve with writing Complex SQL Queries including views, Indexed view (materialized view), CTE, Merge Join, Joins, Union, Union All and also comparing the data for different tables using SQL Servers T-SQL. Created and maintained Stored Procedures and functions.• Highly experienced in whole cycle of SQL Server integration services packages including Developing, Deploying, Scheduling, Troubleshooting and monitoring for performing data transfers and ETL purposes across different servers. Develop and deploy the ETL jobs in SQL Server agent. • Monitoring and maintaining Query Optimization, and Performance Tuning to optimize SQL Server database performance. Create and maintain Clustered, Non-Clustered, and Column store Index for data in the tables for SQL Server database.• Supports the development of reports through ETL process to Power BIEnvironment: SSIS, SQL Server 2017, SQL Server Data Tool 2017, Python Anaconda 3.6, Oracle, and Remote Server.

New York, Ny, Us

• Lead of ETL process development and reconciliation of discrepancies users may find as well supporting analytics team.• SQL Server developer and working on ETL environment using SSIS to load the data from different source including Mainframe, Oracle, Excel, Access, flat file, and one database to another database for the project of Data Warehouse. Load the data from Staging database to production database.• Involve with writing Complex SQL Queries including views, Indexed view(materialized view), CTE, Merge Join, Joins, Union, Union All and also comparing the data for different tables.• Design and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying, and dynamic configuration of SSIS packages.• Expertise in working on all activities related to the development, implementation, administration, and support of ETL processes for large-scale Data Warehouses using SSIS with MS SQL Server.• Archive the tables and created the package for incremental load.• Responsible on SSIS package deployment and added on the scheduler to run the package daily/weekly/monthly and troubleshoot the SSIS Packages.• Responsible for managing the ETL/FTP process and sending the files to DOIIT for Open Data and as well as sending the data files to other applicable NYC agencies from Data Share database through FTP • Supports analytical team, internal and external stakeholders to understand their data and reporting requirements.• Define and build technical and data architectures within the City’s integrated data platform including data and dimensional modeling.• Work with the application developers, and database administrators to make sure database performance, and security.• Supports the development of reports through ETL process to OBIEEEnvironment: Remote Server, SSIS, Visual Studio, SQL Server Database 2012/2008/2005, and Remedy

• Involved in design, code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions.• Scheduled Jobs for executing the stored SSIS packages/Master Packages which were developed to update the database on Daily/Weekly/Monthly basis using SQL Server Agent.• Wrote complex T-SQL Queries to Migrating the data from Fox Pro Database to SQL Server 2012• Created and maintained Stored Procedure, Views, Indexes, UDFs, and create tables including temporary tables and copy tables to perform different type’s implementation.• Performed in designing and developing the database using Constraints Rules, Normalization, and plan. Also, applying the data types.• Loaded the data using SSIS Package tool from different types of source including Excel, Access, flat file, and one database to another database for the project of Health Data Warehouse (HDW). Load the data from development database to Staging and production.• Experienced in extracting and documentation of ETL data mapping using source table and destination base table in SSIS. • Create different format of report including PDF File, Excel, CSV File, and Flat file using SSRS.• Experience working with healthcare, and data sets involved HIPPA with compliance standards.• Analysis and mapping the data using DQ Analyzer.Environment: SSIS, SQL Server 2012, Visual Studio, TFS, and DQ Analyzer.