Summary

• Highly skilled Database Administrator with over 5 years of experience in MS SQL Server, SSIS (ETL), SSRS, and Power BI.
• Proficient in designing, managing, and optimizing databases, creating efficient ETL workflows, and developing insightful reports and dashboards.
• Adept at ensuring data integrity, performance tuning, and delivering actionable business intelligence solutions to drive informed decision-making.
• Strong problem-solving skills with a focus on streamlining data processes and improving system performance.

Technical Skills

Database: MS SQL Server, Azure SQL, T-SQL, PostgreSQL
Business Intelligence: SSIS (ETL), SSRS, Power BI
Cloud Technologies: AWS RDS, AWS S3 Bucket, AWS EC2, Azure VM, Azure Blob Storage
Programming Languages & Frameworks: C#, .NET Core, MVC, Python
Version Control: Bitbucket, Git, TFS, SVN
Scrum Master: Jira, Azure DevOps Boards

Projects worked on

Gaming Application (USA-based):

Domain: Online Gaming

Role: Data Analyst

Project Abstract: The project focuses on developing an online gaming portal and mobile application where users can register, deposit funds to play games, and withdraw winnings. Through an intuitive admin portal, clients can manage provider and game data, user accounts, and access interactive reports showcasing cash transactions, user wins and losses, and game performance metrics. By leveraging these reports to analyze accurate data, clients can make informed decisions, driving the success and growth of the gaming platform.

Tools & Technologies: SQL Server Management Studio, SSIS (ETL), Power BI, AWS (RDS, S3 Bucket, EC2)

Responsibilities:

• Design database tables.
• Manage database access.
• Monitor the following:
  o Database Performance
  o Performance Improvement
  o Database Recovery
  o Database Accessibility
• Created Data Warehouse for reporting purposes using SSIS (ETL).
• Analyze and map millions of user records to generate comprehensive reports and insights.
• Developing Power BI Reports to get insights into the whole business on a single page.
• Managed data for more than 600 million transactional records from over 15 different service providers.
• Created a Python script to extract data from the SQL Server and store it in the S3 bucket. Also did Data Manipulation, as needed.
• Created complex stored procedures to perform business logic in less time.
• To ensure superior performance, I worked on indexing and removing unnecessary data while integrating new providers. This
  helped avoid future issues.
• Maintain data quality and the relationship between the tables.
• Set up the process for Database backup and restore.
• Data Security and managing reporting with the live table.
• Provide reporting from the millions of user data and archive the old data as millions of new data get updated daily.
• Managed On-Prem MS SQL Server and AWS RDS MS SQL.

 

Virtual Event Platform (USA-based):
Domain: eCommerce
Role: Data Analyst
Project Abstract: It is a comprehensive software solution that enables organizations to host and manage virtual events seamlessly. This platform leverages cutting-edge technology to create immersive and engaging experiences for participants, regardless of their physical location. By harnessing the power of virtual communication, the platform facilitates connections between people and fosters the development of dynamic digital and hybrid communities on a global scale.
Tools & Technologies: SQL Server 2019, Power BI, SSIS (ETL), Azure VM, Azure Blob Storage
Responsibilities:

• Designed and implemented a data warehouse using a star schema after analyzing the transactional database structure.
• Implemented SSIS (ETL) Packages.
• Created a Power BI Dashboard to summarize all the virtual events and their responses.
• Keep the Database UP and resolve issues if it's Down.
• Performance tuning and optimization through DB.
• Manage Backup and Log files of DB through Azure Blob Storage.
• Created Database design and Table structures.
• Created complex stored procedures for different operations and calculations.

 

Wealth Manager Portal:
Domain: Fintech
Role: SQL Server Developer
Project Abstract: It is an advanced eBanking platform designed to provide clients with an unparalleled experience when engaging in trading activities and financial transactions. This intuitive portal offers a comprehensive suite of features tailored to meet the diverse needs of wealth management clients. From seamless trading execution to secure fund transfers, the platform prioritizes user-friendly interfaces and robust security measures to guarantee a smooth and trustworthy experience.
Tools & Technologies: SQL Server Management Studio, SQL Profiler, Visual Studio, Task Scheduler, Microsoft Excel
Responsibilities:

• Daily stand-up meetings.
• Reconciling and storing the bank transaction data files through certain steps using dynamic T-SQL and stored procedures in the
  data warehouse.
• Checking the consistency in data. Also optimizing the query, if needed.
• Checking for the deadlock and resolution.

 

Credit Card Company (UK-based):
Domain: Fintech
Role: SQL Server Developer
Project Abstract: It is a modular solution designed to protect the entire payment chain, merchant risk management, and fraud detection for card issuers and financial institutions, covering all card payment types e.g., credit, debit, pre-paid, private label, e-wallet, etc., and other payment types such as Cheque, ACH, and wire transfer. Its Pre-Authorization provides high-performance front-end transaction validation as part of the authorization process, enabling transactions to be declined in real time as part of the authorization.
Tools & Technologies: SQL Server 2012, Visual Studio 2019, Redgate Comparison tool
Responsibilities:

• Attend the daily stand-up and biweekly sprint planning meetings meeting.
• Gather business requirements through continuous discussions with the business and data analysts.
• Upgrade database version from lower to higher. Compare lower and higher version databases via the Redgate Comparison Tool.
• Created scripts to migrate database objects like Tables, stored procedures, Views, etc.
• Implemented batching logic for transferring a high amount of data from tables.

 

Fuel Data Warehouse (USA-based):
Domain: Oil & Gas
Role: Data Engineer
Project Abstract: The client requested the transfer of fuel analysis data from multiple branch units and client organizations to their Pre-staging databases. The primary objective was to enhance processing efficiency and reduce the time required for data integration. Initially, handling bulky zip files of approximately 3GB each posed a significant challenge, taking 10 to 11 hours to process. However, with
the implementation of SSIS (SQL Server Integration Services), the processing time was reduced to just 30 minutes, resulting in a substantial improvement in performance and overall efficiency.
Tools & Technologies: SQL Server 2017, SSIS (ETL), GitHub, Jira
Responsibilities:

• Integrated Python scripts within SSIS (ETL) workflows.
• Incorporated SSIS packages into existing desktop applications.
• Deployed and automated SSIS packages using the Integration Catalog.
• Configured automated backup and restore processes on a secondary server.