Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Nousin Rahman

Syosset,NY

Summary

Data Analyst with 4+ years of experience in data cleansing/wrangling, data manipulation, data extracting, data mapping and modelling, data visualization, descriptive, predictive, and prescriptive methods Skilled in the provision of strategic insight and in the interpretation of data, analysis of results and production of comprehensive reports. Excellent Interpersonal and communication skills, efficient time management and organization skills, ability to handle multiple tasks and work well in a team environment. Experience with data warehousing, ETL processes and database management concepts with tools such Dedicated team player with excellent communication and presentation skills Committed to communicating with senior management to implement improved database, data collection systems, data analytics and other data related strategies, with a successful track record in the utilization of data, visualization tools to optimize statistical efficiency and quality. Injected analytical rigor, scalable data architecture and latest cutting – edge technologies to continually improved and add value for cross-functional business team. Maximize performance by implementing appropriate project management through analysis of details to ensure quality control, legacy system transformation and an understanding of emerging technology. Develop and maintain data warehouse documentation, including data mappings, data modelling, data migration and transformations. Development, Support, Upgrade and Maintenance Data Modelling Tools Expertise includes developing and managing multimillion-dollar enterprise platforms, setting business intelligence roadmap, and advising C-level executives.

Overview

6
6
years of professional experience
1
1
Certificate

Work History

Data/Business Solution Analyst

USAA
08.2022 - 07.2023
  • The project involves enhancing Digital Platforms to support Bank and Enterprise Data. Being a part of MDS (Member Debt Solution) Team I am responsible for creating embedded data sources using Custom SQL queries and publishing them to the Tableau Lab and Server environment
  • Additionally, I maintain and modify Tableau Dashboards to meet Business requirements and implement a data warehouse solution to enable centralized data storage and improved reporting capabilities
  • I also validate data migration, run complex SQL queries, and create dashboards and reports using Tableau, MS Excel and SAS for business stakeholders
  • The project is involved enhancing Digital Platforms to support Bank and Enterprise Data
  • Creating embedded data sources using Custom SQL query and Publishing to the Tableau Lab environment
  • Testing and validating data sources and incorporating that into the Tableau Dashboard
  • Maintaining all the Digital Tableau Dashboards and modifying them to match Business requirements
  • Creating audience files for Business Utilizing SAS and MS Excel
  • Run day-to-day SQL complex queries in Snowflake and CoginitiPro to check data migration from the source table to the target table
  • Validating the data flow from source to target tables to ensure data is loaded per the business rules
  • Implementation of a data warehouse solution enabling centralized data storage and improved reporting capabilities
  • Designed and optimized ETL processes to extract data from various sources, transform it, and load it into the data warehouse
  • Migrating and Publishing the Tableau workbook along with Data sources from LAB to QA and QA to Production for Business usage
  • Digitalizing various applications and analyzing cost effectiveness, based on that create ad hoc reports, tactical and strategic solutions to reveal a success and failure rate to our business
  • Using Descriptive, Predictive and Prescriptive analysis to provide guidance and answer business questions
  • Organized visualization requirement uses case JAD sessions Discover business narratives told by the data and presented them to business stakeholders, and managers at various levels
  • Wrote scripts and indexing strategy for migration to Confidential Redshift from Snowflake and MySQL
  • Environment: Windows 11, Tableau Desktop and Tableau server- 2022.4, Snowflake, SQL 15.0, CoginitiPro, SAS Enterprise 2020, MySQL Server 2, SAS enterprise, CoginitiPro, Jira, Salesforce

Business Data Analyst

Mazolo Properties LLC
01.2021 - 06.2022
  • In this role, I evaluated complex data sets to identify trends and patterns, collaborating with senior management teams to prioritize business requirements and identify opportunities for process improvement
  • I managed over 50 corporate Tableau reports, the reports portal, and BI platform, ensuring effective data collection, analysis, and reporting processes
  • I also worked closely with data engineers to build data warehouse infrastructure using SQL Server and ETL processes, and I utilize Tableau, and Python to generate visualizations and reports for business forecasting and machine learning output validation
  • Evaluated complex data sets to identify, analyze and interpret trends and patterns
  • Collaborated with senior management teams to prioritize business requirements and to locate and define opportunities for process improvement
  • Provided disposed of equipment monthly reports and communicated results to the technology director and accounting controller
  • Involved in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, and structure, and to maintain data efficiently
  • Effectively used data blending feature in Tableau. Executed and tested required queries and reports before publishing
  • Created users, groups, projects, Data connections, and settings as a Tableau administrator. Maintained server activities, user activity, and customized views on Server Analysis
  • Involved in creating ad hoc analysis and reporting requests in a timely manner for BML risk related to fraud Approval using MS Excel by connecting various data sources, based daily, monthly, and yearly.
  • Assisted in designing and building data warehouse infrastructure using SQL Server and ETL processes
  • Worked closely with data engineers to transform and load data from various sources into the data warehouse
  • Created Tableau scorecards, and dashboards using stack bars, bar graphs, scattered plots, geographical maps, and Gantt charts using show me functionality
  • Generated graphs and reports using the plot package in R Studio for analytical models
  • Perform validation on machine learning output utilizing Python libraries such as Pandas, Numpy, Matlibplot
  • Environment: Tableau Desktop 8.2/8.1/8.0, Tableau server/ Administrator, SQL developer, SQL 2008, MS SQL Server 2005/2008/2012, Python, R Studio, Shiny Excel 2013, Machine learning, Quick view.

Data Analyst Associate Data Analyst Associate

Federal Reserve Bank Of New York
07.2020 - 12.2020
  • I had the opportunity to work on two major projects at the Federal Reserve Bank of New York, a prominent financial organization. Being a part of DIT (Department of Information Technology) team one of the projects involved using the Splunk framework to detect, analyze, and investigate computer security incidents
  • The main goal was to enhance the organization's cybersecurity and ensure the stability of the financial system for the benefit of all segments of society
  • The second one replaced their DABS with a centralized claims management system that can be integrated broadly across the enterprise
  • Build the framework on Splunk, and the purpose was to detect, analyze, and investigate computer security incidents
  • Interacted with business and technical staff to drill down for required information. Updated technical documentation to meet financial goals for further future reference
  • Retrieved data from multiple sources and analyzed the data including handling missing values, redundancy in a dataset
  • Validating the current system and identifying field level rationalization from multiple databases. After that planned to load data into salesforce cloud
  • Identified web app oracle fields that needed to be migrated into Salesforce cloud and the potential communication touch point with the claimant
  • Conducted string mapping analysis to IMS, DB2 and VSAM(Virtual System Access Management)
  • Created Data Dictionary for DABS, to modernize current system
  • Extracted data from source database, cleansed it and provided (CSV or similar format) file for every source table that is identified to be migrated during the discovery stage
  • Worked with Fed to confirm the process for testing all regularly scheduled releases by vendors
  • Environment: Splunk, SQL Server Management Studio, PL/SQL, Splunk, DB2, Tableau, Tableau Desktop 8.2/8.1/8.0, Tableau server/ Administrator, SQL developer, SQL 2008, MS SQL Server

Database Administrator

Mozolo Properties LLC
08.2018 - 06.2020
  • Mozolo Properties is Real Estate Company in New York, , I was a part of the Data Assurance Department, responsible for analyzing internal company data to drive business performance. I reported directly to the Director and focused on installing, maintaining, and optimizing database servers while ensuring database security and adherence to standards
  • Additionally, I managed database access, performed performance tuning, and oversaw the installation, upgrade, and management of database applications


  • Installed, upgraded, and maintained the performance of database servers, as well as applications. Developed processes for optimizing database security, set and maintain database standards
  • Managed database access, performance tuning of database systems. Collaborated with team members and data systems to collect data
  • Cleansed, manipulated, and analyzed large sets of raw data utilizing data profiling and data mining tools
  • Created and maintained analytics reporting, data visualizations and ad-hoc to analyze cost effectiveness, high tax rate, potential states, customer preference, future predictions using MS Excel and PowerBI forecasting features
  • Supported Lead Analyst in providing data-driven solutions by Developing Conceptual, Logical and Physical Data Models
  • Conducted business analysis and research to identify key metrics and opportunities for improvement. Presented clear and concise findings along with recommendations to stakeholders
  • Understands business processes and end users and how they translate into actionable data
  • Integrated internal and external systems used by Mozolo, to provide a centralized view of all customer touchpoints
  • Environment: Informatica, DataStage, MySQL, Transact-SQL (T-SQL), Oracle Database, MySQL, SQL Developer, RStudio, App Dynamics, Python, PowerBI, Jupytar Notebook, Anaconda

Junior Data Analyst

Lecturus INC
06.2017 - 04.2018
  • Lecturus INC is an Ecommerce based platform, during this project I was responsible for selecting and extracting samples from a list of the raw datasets, eliminating duplicates, and creating a one-subject-per-row dataset utilizing SQL and SAS
  • Maintained and analyzed historical customer data to understand and predict present and future product trends
  • Established a segmentation for the behavior of customers with PROC FORMAT and PROC SQL based on their credit scores
  • The team was involved in extracting data from the complex data warehouse and analyzing, forecasting to predict future sales trends.
  • Involved in the implementation of required data, documentation, and models to identify and solve problems required for decision processing
  • It helped the decision-makers monitor and analyze the company's financial loan data performance
  • Developed and supported infrastructure to implement Statistical and Economic models. Performed platform capacity planning and management
  • Provided all levels of technical and application support; incident management (Levels 1, 2, and 3); address user, application, and data issues
  • Executed change management processes surrounding new releases of SQL and SAS functionality
  • Provided basic data analysis and data profiling using SSIS (SQL Server Integration Service)
  • Build and maintain data dictionary to keep detailed information about the contents of a dataset, S2T and database.

Education

Bachelor of Technology - Computer Information System (Database Track)

New York City College of Technology
Brooklyn, NY
09.2021

Associate - Applied Science, Computer Information

Queensborough Community College
Bayside, NY
07.2018

Skills

  • Process : Star Schema Modelling, Snowflake Modelling
  • Reporting Tools : Tableau 82,81/80/70 Oracle BI Administration Tools, Oracle BI Answers, Oracle BI Delivers, App Dynamics, Splunk, PowerBI, Looker, SSIS, SSRS
  • Business Intelligence tool : Snowflake, SAP Business Objects, Salesforce
  • Statistical Analysis Tools: SAS, RStudio, Adobe Analytics, Glassbox, Jupyter Notebook, Anaconda
  • Monitoring Tools : Splunk, AWS CloudWatch, ELK (Elastic search, Kibana), App Dynamics Coginiti Pro
  • Scripting & Languages : Python, SQL, PL/SQL, MATLAB, Bash Shell scripting, PowerShell, JSON R, C, Java, VBNET
  • Data Warehouses : Snowflake, DB2, Apache Hive, Oracle Autonomous, Google BigQuery, Oracle Exadata, Teradata Vintage, IBM Netezza Performance Server
  • Databases : MySQL, PostgreSQL, Oracle Database, Microsoft SQL server, SQLite, Lexisnexis, IBM DB2, MS Access, MongoDB, Neo4j
  • Web Tool : HTML, DHTML, JAVA SCRIPT
  • Networking/Protocol : TCP/IP, NIS, NFS, DNS, DHCP, Cisco Routers/Switches, WAN, SMTP, LAN, FTP/TFTP
  • Virtualization : VMware, Windows Hyper-V, Power VM, Virtual box, Citrix Xen, vCenter, vSphere
  • Environment : Linux, Windows, Mac

Certification

  • Oracle Database SQL Certified Associate
  • Certified Microsoft Office Specialist

Timeline

Data/Business Solution Analyst

USAA
08.2022 - 07.2023

Business Data Analyst

Mazolo Properties LLC
01.2021 - 06.2022

Data Analyst Associate Data Analyst Associate

Federal Reserve Bank Of New York
07.2020 - 12.2020

Database Administrator

Mozolo Properties LLC
08.2018 - 06.2020

Junior Data Analyst

Lecturus INC
06.2017 - 04.2018

Bachelor of Technology - Computer Information System (Database Track)

New York City College of Technology

Associate - Applied Science, Computer Information

Queensborough Community College

Similar Profiles

CREATE PROFILE
Nousin Rahman