Data Analyst

I worked as a Data Analyst at Progoti Systems Ltd., where I was actively involved in analyzing and interpreting data for their Data & BI Engineering team. During my employment, I contributed to many projects, and created visually engaging data dashboards, Optimized Data Processes, Implemented Data Security Measures, Contributed to Project Success.

Achievement & Responsibilities:
Data Analysis and Customer Experience Enhancement

• Conducted in-depth analysis on intricate datasets to uncover trends and patterns.
• Executed and managed campaigns, including Loyalty Programs.
• Generated target groups (TG) for a variety of user segments.
• Presented data visualizations for informed decisions (15+ Dashboards, 150+ Charts).
• Implemented techniques for Customer Journey Management and Mapping.
• Designed and implemented algorithms to enhance decision-making processes.

Payment System Audits and Financial Accuracy

• Performed audits on the payment system database for Bangladesh Bank.
• Performed reconciliation processes to ensure accuracy and consistency in financial data.

Financial Reporting and Regulatory Compliance

• Prepared and compiled Trust Cum Settlement Report for Bangladesh Bank.
• Generated and submitted Rationalized Input Template (RIT) report for Bangladesh Bank.
• Compiled and presented comprehensive Income Reports.
• Conducted Yearly Bank Closing procedures, ensuring accurate financial records.
• International Monetary Fund (IMF) report.
• Financial Access Survey (FAS) report.
• Unstructured Supplementary Service Data (USSD) report.
• Growth Report.

Data Engineering & Security

• I designed and developed Extract, Transform, Load (ETL) solutions, ensuring seamless data integration and transformation processes.
• Designed and established a Unified Data Analytics Platform (UDAP)
• Implemented dimension and fact tables, managed Slowly Changing Dimensions (SCD), and performed additional Data Engineering tasks to optimize data processing and analysis workflows.
• Developed a Database Audit System leveraging Triggers for data security.
• Designed and implemented Role-Based Access Control (RBAC).
• Established a robust Column Level Security (CLS) system.
• Utilized PostGIS for location-based data tasks, including the generation of locations using latitude and longitude, and implementing Convex Hull algorithms for spatial analysis.

Administration

• Table Partitioning, Sharding, Indexing, Database Performance Improvement.
• Successfully orchestrated the migration of a substantial 10TB data set to AWS RDS.
• Decomposed a normalized database into two separate databases.
• Developed a Point-In-Time Recovery (PITR) mechanism on Master-Slave architecture.

Experienced Projects

• Primary Education Stipend Programme (PESP).
• Padma Multipurpose Bridge.
• Bangladesh Sugar and Food Industries Corporation (BSFIC).
• Social Welfare Disbursement (SWD).
• Super Quick Response (QR).