SQL Server & Database Expert | 25+ Years of IT Experience Data Modeling | Design & Development | Data Analytics | Performance Tuning | Data Visualization With over 25 years of extensive IT experience, I specialize in SQL Server environments (from SQL Server 2005 to 2019). I deliver high-quality, scalable database solutions that ensure optimal performance, data integrity, and seamless integration. My expertise spans design, modeling, development, implementation, and support of SQL Server systems, with a focus on performance and efficiency. Key Skills & Expertise: T-SQL Proficiency: Creating complex triggers, tables, stored procedures, functions, and views to ensure seamless data management and integrity. Database Management: Extensive experience with normalization and RDBMS, optimizing structure and performance. SQL Server Services: Hands-on with SSIS, SSAS, and SSRS for integration, analysis, and reporting. Performance Tuning: Optimizing performance and query tuning for efficient database operation under heavy load. Data Modeling: Specializing in logical and physical modeling, using tools like Erwin for effective database design. Data Warehousing & ETL: Expertise in data warehouse design, SSIS, Azure Data Factory, and building star schema dimensional models. Business Intelligence & Reporting: Skilled in SSRS and Power BI for interactive dashboards, reports, and visualizations that turn data into actionable insights. Optimization Tools: Familiar with Index Tuning Wizard, SQL Profiler, and Performance Monitor to resolve bottlenecks. Database Administration: Proficient in MySQL and PostgreSQL database development, configuration, troubleshooting, and administration. Additional Expertise: DBA Tasks: Server maintenance, fail-over clustering, replication, backup/restoration, job scheduling, and error handling. Performance Monitoring Tools: SQL Sentry One, Grafana, and Spotlight for SQL Server. Collaboration & Teamwork: Strong in cross-functional collaboration to meet business objectives. Adaptability & Multitasking: Ability to handle multiple projects while adapting to new technologies and client needs. Quick Learner: Fast to pick up new technologies and deliver impactful solutions. Let’s Build Scalable & High-Performing Solutions Together! If you're looking for a results-driven database expert to optimize your SQL Server environment, design robust data models, or create effective BI reports, let’s connect. I'm passionate about helping clients achieve their goals through high-performance database solutions.

Over 18 years of experience in SQL Server development, database architecture, performance tuning, and data integration. Expertise in Power BI Admin/Dashboard/Paginated reports, Crystal Reports, and SSRS, Tableau, SQL, Transact-SQL, Stored procedure, Query Optimization, SSMS, SQL Agent. Proficiency in web development using C# MVC ASP. Net and .NET Core to supporting backend integration.

Is manual data entry and broken reporting slowing your business down? I fix that. I am a BI Engineer and Data Automation specialist with a degree in Computer Science and over 5 years of experience turning messy, manual data tracking into automated, high-performing visual dashboards. Whether your team is wasting hours on repetitive Excel tasks or your database queries are lagging, I engineer the backend pipelines and frontend reports to give you real-time visibility. Core Architecture & Expertise: Business Intelligence: Microsoft Power BI, Tableau, IBM Cognos Analytics, SSRS Data Engineering & ETL: Talend, Informatica, SSIS, Data Modeling Database Optimization: Advanced SQL Programming, Stored Procedures, Dataset Normalization My goal is simple: migrate your manual workflows into seamless, automated data pipelines so you can make decisions based on accurate data, instantly. Let’s connect to discuss your data infrastructure. Click the "Invite" button to get started! Love to hear from you! Hassan

Senior Expert Access/Excel/VBA/SQL Server Developer/Dot.Net Web/MVC/EF/Azure, Troubleshooter, Optimizer, UI Enhancements, etc... I have 34+ years of experience working with Access, Excel, and then integrating them into harmonious fluid applications, whether it be for the Desktop, or on a WAN. I have developed using every version of Microsoft Office and SQL Server since inception. I specialize in Finance and Manufacturing, including CRM, Inventory and Work Order Management, Job Costing, AR, AP, Purchasing and Sales Forecast Automation, etc. I feel those environments are structurally synonymous with most any other scenario. My current experience involves Loan Origination and Servicing. Working in Finance and Manufacturing, I could not afford to make mistakes. My work ethic developed beginning with my father and being in the Military, in the field of Aviation, where a tiny mistake could cost lives. I am detail oriented with an eye for efficient user friendly complete, from the ground up, to the most custom application imaginable. I have proven complex methods that are far more efficient than the conventional developer, regardless of how well they score on a test; I am the person that goes the extra mile(s) to adhere to the rules of development while maintaining a fluid user friendly interface. I develop from the ground up or customize pre-existing systems. Whether I am developing in Access or Excel, I always structure the data for easy possible future migration, regardless of the interface. An interface can be easily replicated, but carelessly stored data can be very costly. My interfaces are fluid and user friendly. They utilize as much as the available functionality permits, by using Drop-down and List Boxes, and applying Event Code to link to related data without having to return to a menu or dashboard. I am extremely fluent in VBA, using various Object Models, i.e. Access, Excel, DAO, ADO, SQL, Class Modules, SQL Server T-SQL, Stored Procedures and Custom Functions and Triggers, SSMS, SSRS, and SSIS, etc. I write code that a lay person can understand. Where this is not possible, I comment the purpose and flow of the Code. I do not implement limitations, as a lot of developers do, that force the Client to always call on the developer every time a little change is needed. I develop in such a way that considers future expansion. The only time I would ever need to be called upon is to implement new functionality. I prefer to teach Clients the basics so that they can make the subtle physical design changes to the interface that they want, without destroying the integrity of the system. Because I follow the rules of development, the system is straight forward and easily understood. Core Skills, Software, and Framework are Microsoft Access, Microsoft Excel, VBA programming, SQL Server, Stored Procedures, Azure SQL Db, Aure Data Factory, M365, PowerAutomate, Dot Net Web Applications, Custom Business Application.

With almost 15+ years of experience in DB development, administration and Data Engineering in the competitive IT environment of with a well-known It organizations like TRG, Financial institute (Askari Leasing Ltd, Pakistan) and then with a software house (Valentia technologies / F3 Technologies) with an international repute, I am much comfortable and confident at the same time to take the challenges of SQL Server traditional as well as out-of-the-box Administration, Development and Data Engineering along with the BI stack and Big Data.  I have successfully deployed many projects as a key database, Data Engineering and multiple SSAS, ADF, Synapse and PowerBI projects to the clients in Dubai and Ireland related to Healthcare and finance. All projects were developed either by me or under my leadership. Writing complex queries, stored procedures, Functions and triggers have been the part of my job. Grip on Service Broker for real Time data synchronization adds to my capabilities to tackle the up-coming challenges with the data.  In Administration, I have successfully implemented many High Availability solutions like SQL Server Fail over Clusters, AlwaysOn Availability Groups, Database Mirroring and Log Shipping.  Experience in working on both Waterfall and Agile development model. Maintaining project backlogs, writing and story pointing of user stories, and maintain the velocity of the team are my specialties. Changes in my roles is the big sign that I am always open for learning new things and enjoy learning new technologies. I have recently completed my training course on Python and machine learning with Python. Skillset includes SQL Server Development and administration, MySQL development, SSRS, SSAS, SSIS, Power BI and Python for Data Engineering and Machine Learning. Technical skills include; MS Fabric (DP-700 certified) Azure Data Fundamentals (DP-900 certified) MCSA - SQL Server 2012 MCITP - Database Developer 2008 MCITP - BI Developer 2008 SQL Server Database Performance Expert Azure Data Factory, BLOB, Data Lake and much more Azure Synapse Python DataBricks AWS Glue, EC2, S3, Athena, RedShift and much more AWS RDS PowerShell PowerQuery Design, Optimize and Secure Cubes in SSAS Design and Deploy optimized subscription based reports Integration Services for ETL and Maintenance Plans Data Synchronization using Service Broker High Availability Solutions with Windows Server Failover Clustering and AlwaysOn DR planning Database Mirroring (SQL Server 2005 / 2008 R2) Query writing and Query Optimization

I am a Senior Data Engineer and Microsoft Business Intelligence Specialist with 17+ years of experience designing, developing, and optimizing enterprise data solutions. I help organizations transform raw data into actionable insights by building scalable databases, modern data pipelines, business intelligence solutions, and automated reporting systems. My expertise covers the complete data lifecycle—from database architecture and ETL development to data warehousing, cloud data platforms, reporting, and business automation. I have successfully delivered enterprise solutions for manufacturing, ERP, healthcare, education, transportation, retail, and finance organizations. What I Can Help You With- • SQL Server database design, development, administration, and performance tuning • Complex T-SQL, stored procedures, views, functions, triggers, and indexing • ETL/ELT development using SSIS and Azure Data Factory • Data warehouse architecture, dimensional modeling, Star & Snowflake Schema • Microsoft Fabric and modern analytics solutions • Interactive Power BI dashboards, DAX, Power Query, KPI reporting, and semantic models • SSRS, RDLC, Crystal Reports, Paginated Reports, and Excel reporting • Azure SQL Database, Azure Managed Instance, and cloud data solutions • Data migration, integration, validation, automation, and performance optimization • ERP reporting and database support ## Core Technical Skills ## Data Engineering: SQL Server (2000–2022), SSIS, SSAS, SSRS, Data Warehousing, Data Modeling, DAX, Power Query, MDX, Query Optimization Cloud: Azure SQL Database, Azure Managed Instance, Azure Data Factory, Microsoft Fabric, OneLake, Power BI Service Development: ASP NOT NET Core, ASP DOT NET MVC, C#, Web API, Entity Framework, HTML5, CSS3, Bootstrap, jQuery ## Professional Experience ## Freelance Data Engineer & Microsoft BI Consultant (2021–Present) Working with international clients through Upwork and Fiverr to deliver SQL Server solutions, Power BI dashboards, ETL pipelines, Azure data integration, Microsoft Fabric analytics, ERP reporting, and database optimization. Raihana Consulting (Affiliated with Mizkan America, USA) | Senior Software Engineer (2011–2021) Designed enterprise SQL Server databases, SSIS packages, SSRS reports, Power BI dashboards, and reporting solutions for Microsoft Dynamics AX ERP. Served as the Lead Engineer for the Mizkan Report Manager Version 4, an enterprise reporting platform built with ASP DOT NET MVC, SQL Server, and SSRS. Ask Bangladesh Ltd. | Software Engineer (2010–2011) Developed ERP and business applications using C#, ASP DOT NET, SQL Server, Entity Framework, and Crystal Reports. IT Bangla Ltd. | Programmer & Technical Faculty (2008–2010) Developed software applications and delivered professional training on SQL Server, DOT NET, and database technologies. ## Selected Projects ## • Mizkan Report Manager for Microsoft Dynamics AX ERP • Executive BI Dashboards for Sales, Finance, Inventory, Production, and Purchasing • Manufacturing ERP Solutions for Textile Industry • Azure SQL Database & Azure Data Factory Integration • Vehicle Storage & Billing Management System • Enterprise SQL Server Data Warehouse Solutions ##Education & Certifications## Bachelor of Business Information Technology – University of Greenwich (UK) Diploma in Enterprise System Analysis and Design (ESAD) – IDB-BISEW ## Certifications ## Microsoft Certified Professional Developer (MCPD) Microsoft Certified Professional (MCP) Red Hat Certified Engineer (RHCE) ## Why Clients Choose Me ## ✔ 17+ years of enterprise data engineering experience ✔ Deep expertise across the Microsoft Data Platform ✔ Strong ERP and enterprise reporting background ✔ High-performance, scalable, and secure solutions ✔ Clear communication, reliable delivery, and long-term support Whether you need SQL Server optimization, Power BI dashboards, ETL pipelines, Azure data integration, Microsoft Fabric implementation, or enterprise reporting, I deliver reliable, scalable solutions that help businesses turn data into measurable value. Let's discuss how I can help your business make better decisions with data.

Ranked in the top 1% on Upwork globally, I’ve built trusted relationships with 80+ clients and received 60+ ⭐⭐⭐⭐⭐ reviews -- all within my first year of active use. With 14+ years of experience in Data Analytics, I operate at the intersection of strategy, analytics, and automation -- uncovering the signal behind the noise and translating it into insights leaders can act on. My work doesn’t just explain what happened; it clarifies why it matters and what to do next. As a Top Rated Plus freelancer, clients rely on me as a true thought partner, not just a technician. From Excel automation and SQL optimization to executive-level dashboards, financial models, and automated reporting systems, I design solutions that are precise, scalable, and decision-ready. Clients hire me when they need data analytics that answer questions like: • Where is our profit actually coming from? • What will revenue look like over the next 3–5 years? • Which marketing channels or business units are driving ROI? • How do we automate reporting so leadership sees the numbers instantly? My models and dashboards are designed for CFOs, founders, and executives who need confidence in their numbers. Core Expertise: ✔️Data Analytics & Engineering: Advanced SQL, Excel, SAS, and Access solutions that transform raw, fragmented data into reliable, analysis-ready assets. ✔️Statistical & Predictive Modeling: Regression, forecasting, and scenario modeling designed to support real business decisions—not academic exercises. ✔️Executive Visualization & BI: Tableau and Power BI dashboards that tell a clear story, highlight trade-offs, and drive alignment at the leadership level. ✔️AI-Driven Analytics & Automation: I embed AI directly into SQL workflows, Excel models, and financial analytics to accelerate insight delivery without sacrificing business context. My approach blends deep analytical reasoning (≈70%) with AI-powered automation (≈30%), ensuring speed and accuracy. ✔️Database & Performance Optimization: Purpose-built data structures and optimized queries that turn databases into high-performance decision engines. 💬 Client Feedback (⭐⭐⭐⭐⭐): (Recent Review from E.H.) "Subomi is the literal best, total icon!! I am genuinely grateful. I love partnering with a smart, hard, competent worker and he is just that! He is a great thought partner, beyond just someone to create models for you. I hired him for multiple projects and hired him additionally after I needed to redo work from someone who wasn't as thorough. He is extremely accurate, thorough, patient, helpful, willing to iterate, and does more than just create the models/chart/KPIs that you need - he helps you tell the story (both written and walking you through it) so you can understand all his assumptions. He makes projects better than what you would do on your own. Also, the work was so good that my bigwig private equity friend who reviewed his work was super impressed." 🌟 Let’s Build Something That Moves the Needle: If you need clarity from complexity, confidence in your numbers, or analytics that actually influence decisions, let’s talk. I don’t just deliver outputs; I deliver understanding, alignment, and results.

More than 5 years of experience using SQL Server for data analysis, advanced queries and reporting solutions. Use of SQL Server and other relational database engines trying to resolve all kinds of problems using data and other data tools. -SSRS -Experience with SQL Server 2005 and later versions -SQL query performance tuning Experience with web development using different technologies but mainly ASP.NET framework to create enterprise application solutions -HTML, CSS and JS -ASP.NET Webforms -ASP.NET Web API -Bootstrap -Enterprise web forms Specialized in Excel VBA Macro development to automate different enterprise tasks and reporting procedures for different companies -VBA advanced programming -User Forms Advanced scripting -Creation of custom functions I focus on creating in challenging software to automate employees tasks for their daily basis and I get exited to resolve all kinds of problems that clients come up.

I automate Excel & Google Sheets using VBA and Apps Script, build real-time dashboards, create custom Microsoft 365 toolbars, and manage Azure & SQL Server as a certified DBA. I specialize in turning slow, manual reporting and operations into fast, automated systems. If your business runs on Excel, Google Sheets, or databases, I build production-grade automation that works at enterprise scale. Here’s what I do best: • Excel Automation using advanced VBA Macros • Google Sheets Automation using Apps Script • Interactive dashboards with live data connections • Custom Microsoft 365 Ribbon & Toolbar development • Workflow automation across files, emails, APIs & databases • Certified Azure & SQL Server DBA services (performance, tuning, backups, migrations)

📝 Overview: I am a Senior Database Developer and Administrator with over 9 years of experience delivering reliable, scalable, and high-performing data solutions across a variety of industries, including Medical, Retail, Insurance, and Online Betting. I have extensive hands-on experience with Microsoft SQL Server (2005–2019), working across the full data lifecycle — from architecture and development to reporting, optimization, and maintenance. My strength lies in bridging technical expertise with business goals, ensuring that your data infrastructure performs optimally, supports analytics, and is future-ready. 🛠️ Services I Offer: ✅SQL Server Development & Tuning 🔹Complex T-SQL scripting (Stored Procedures, Functions, Views) 🔹Query and index optimization 🔹Execution plan analysis ✅ETL Development 🔹SSIS package creation, debugging, and deployment 🔹Data transformation between Oracle, MySQL, and SQL Server ✅Reporting & Business Intelligence 🔹SSRS report development and performance tuning 🔹Power BI dashboards and data modeling ✅Database Administration 🔹Backup/restore, upgrade & migration 🔹Log shipping, replication, and monitoring 🔹Security, user permissions, and audit setup ✅High Availability & Disaster Recovery 🔹Always On Availability Groups 🔹Windows Failover Clustering 🔹Multi-node SQL Server cluster configuration