Rashedul Chowdhury Email & Phone Number

Omaha, Ne, Us

Omaha, Ne, Us

New York, Ny, Us

• Extracted, interpreted, and analyzed data to identify key financial performance metrics and transform raw data into meaningful, actionable information, developed Power BI dashboard to visualize• Used SQL, Excel, R, Python to analyze financial data from various sources and draw accurate and reliable conclusions • Utilize data modeling and evaluation strategies to find patterns and predict unseen instances. Develop ML algorithms to analyze huge volumes of historical data to make predictions• Design machine learning systems and self-running artificial intelligence (AI) software to automate predictive models. Applying theoretical expertise and innovation to create or apply new technology • Investigate available resources to develop more useful project plans, implement correlation analysis to compare financial data. • Automate scripting for database maintenance tasks, Installation, Configuration, Baseline Performance tuning and troubleshooting applications, backup, recovery, Disaster Planning• Reengineer database designs, modify and architect business requirements and design data marts• Experience in batch processing, database monitoring, performance tuning, query optimization• Conduct statistical analysis and interpret results to guide organization's decision-making process • by Selecting appropriate datasets and implementing appropriate ML algorithms.• Migrate MSSQL server to Postgres. To migrate from MSSQL server to Postgres, • Implement automated process for repeatable tasks and increased efficiency by over 1000%• Responsible for daily tasks – reindexing, integrity check, job completion, auditing and encryption• Review and refactor database objects – tables, views, functions, stored procedures, triggers• Create Table Space, users, databases, backup and restore PostgreSQL database using Linux/PGAdmin. Migrate MSSQL Server Databases to PostGreSQLAWS- IAM, S3, Glacier, CloudFront, EC2, RDS, Route53, VPC, Elastic Beanstalk, Disk Management

• Install, configure database software, associated database tools Updating Service packs and Security patches for the Dedicated, Shared, and two nodes Active to Active clustered server environment. • Create and schedule maintenance plan job for Backup and restore using native tools, 3rd party software Idera SQLSafe backup, and Quest’s/Dell’s LiteSpeed Backup. Manage and maintain Idera SQL compliance manager tools for database and server level auditing.• Create Manage and maintain Database Log Shipping, Mirroring, Always On for Database high performance• Monitoring SQL server performance and activity, lock, deadlock, blocking, Trace, Log Viewer, database tuning advisor, show plan and other database inefficiencies using Task Manager, Event viewer, SQL Server Error Log, Perfmon, SQL Profiler, DBCC check consistency, DMV, FogLight, Performance Analyzer, and System Center Operation Manager 2012(OpsMgr) tools. • Performance Tuning, analyze and optimize costly queries to reduce logical disk I/O for effective performance, Worked with Database Engine Tuning Advisor, Query Optimization and troubleshooting• Working on Different Isolation level for better database performance solution.• Work on Tempdb database performance issue for data and log file. Optimize Tempdb performance• Managed day-to-day User activities like creating logins, granting permissions, applying security for users, Linked server, SSAS Cube, and creating user Roles and Role Members to ensure Security.• Ability to run script properly, Rebuilding indexes, Shrink database and update database for space and performance related issue, knowledge of database migration procedure.• Designed and developed various SSIS packages and complex reports using SSIS and SSRS. Import data from heterogeneous sources and dumped it to the destination using ETL terminologies of SSIS.• Managed and maintained Share Point database by backup/restore, disk space and database performance

• Administered, maintained, Installed, configured database software SQL Server Databases, applying Database design best practices and index, Developed & maintained scripts, utility jobs for database maintenance.• Created Logical and Physical design of data warehouse and Operational Database Store in SQL Server 2008.• Integrated and transformed data from different data sources like Oracle, DB2, Excel, and Flat Files to SQL Server 2008R2 using OLE DB connection providers by creating various SSIS packages, and SSRS Report• Involved in creating and modifying tables, tuning up T-SQL queries, Index, Views, Stored Procedures, and Triggers, Developed SQL scripts based on need, Updating Service packs and Security patches.• Debugging Lock, Deadlock, Blocking, Trace, Log Viewer, Database tuning advisor, show plan, SQL Profiler. Monitoring, troubleshooting database performance, error logs, Agent jobs etc.• Created and deployed cubes in star and snowflake schema, worked with dimensions, measures, generating KPI, MDX queries. Assisted developers with SQL issues/questions and table design for optimal performance.

Mumbai, Maharashtra, In

Installed & configured database software, associated database tools and performance monitoring software.Create Agent job, DTS\SSIS job, schedule job, email notification ,Export –Import DTS\SSIS packageCreate, run schedule job, troubleshoot the fail job issue, execute SSIS package, promoted to file systemBackup\Restore database, import\Export, Table\View\Stored Procedure. Utilization of Light speed tool- Backup and restore (3rd party tool) Ability to run script properly, Shrink database, knowledge of database migration procedure.Participated in meetings impacting databases physical design, ongoing issue , and new updated information.Developed & maintained scripts, utility jobs for database maintenance.Monitored data activities (i.e. database status, logs, space utilization, etc.).Administered & maintained SQL Server Databases (Production, Development, and Test Environment)Ensured the availability of the Database Server in a 24X7 environment.Scanned the data pages, Indexes and checked the storage space used by each table.Managed security by defining roles and permission on Table\Database\Server levelMonitored database server performance and if required go for tuning of the TSQL queries, Stored procedures Use SQL Profiler to run trace to find out the error, use database tuning advisor, show planCreate, Configure Link Server for Windows and Oracle environment, Troubleshot DB mail