Samir K. Ghosh Email & Phone Number

United States

San Jose, California, United States

Worked for Database Team in ZooberPay Product from September, 2024. ZooberPay is like a remittance product more likely WesternUnion. This app actually helps the NRB (Non Return Bangladeshi) who can send money from abroad to Bangladesh in a legal and safe way. • Designing and developing Data Warehouse systems.• Creating and implementing ETL processes.• Scheduling jobs using crontab for automation.• Writing stored procedures using PL/pgSQL.Environment: PostgreSQL, DBeaver, Shell Scripting

Asa Tower, Shyamoli, Dhaka

Worked for Database Development and Database Administration role as well in ASA IT Department.Responsibilities: • Developed and implemented data archiving and purging processes, increasing storage efficiency by 40%.• Monitored database activity, ensuring optimal performance and data integrity, which resulted in a 30% reduction in downtime.• Enhanced performance by tuning queries and adjusting parameters, improving response time for front-end applications by 25%.• Led seamless data migration from legacy systems to new platforms, reducing transition time by 20%.• Authored stored procedures to meet business requirements, speeding up process automation.• Installed, configured, and managed databases across platforms, ensuring consistent performance.• Strengthened data protection with comprehensive backup and recovery strategies, reducing data loss risk by 15%.• Collaborated with ASA, a client of Ascend Technology Inc., on database administration tasks.Technology Used: SQL Server 2019, SSMS, SQL Stress, T-SQL, mRemoteNG

Dhaka, Bangladesh

Worked for DWH of Data Team in Engineering department for SureCash, TallyKhata product of Progoti System Limited (PSL)Responsibilities:• Led Data Warehouse (DWH) architecture design and implementation for the Data Team in the Engineering department, resulting in optimized data storage and reporting• Designed and developed custom ETL processes, monitored ETL tasks, and improved data extraction efficiency by 20%.• Created dashboard reports that provided actionable insights to business and management teams, enhancing decision-making.• Collaborated with cross-functional teams to gather and analyze business requirements, ensuring data solutions aligned with company goals.• Supported daily, monthly, and ad-hoc reporting tasks, reducing turnaround time for key reports by 15%.• Improved existing data warehouse according to standard DWH concepts, increasing system scalability and reliability.• Improved query optimization and performance tuning of existing processes, resulting in a 50% increase in efficiency across key database operations.• Executed Database Administration tasks, including Master-Slave Replication and PITR (Point In Time Recovery), enhancing data availability and security.• Automated tasks using UNIX Shell and Python scripts, boosting operational efficiency by 25%.• Managed and led the team to successfully deliver multiple projects within deadlines.Environment: PostgresSQL, MySQL, PL/pgSQL, Python, Google Data Studio, DBeaver, SQLyog

Dhaka, Bangladesh

Dhaka, Bangladesh

Gp House, Bashundhara R/A, Dhaka

Worked for the BI-EDW team of Telenor-Grameenphone projectResponsibilities for Development:• Developed change requests (CR) using Oracle ODI, PL/SQL, OBIEE, and Shell scripting, streamlining data integration and reporting processes, which improved system efficiency by 20%.• Designed and scheduled ODI scenarios for Oracle procedures within ODI Load Plans, automating workflows and reducing manual intervention by 25%.• Compiled High-Level Design(HLD) and Low-Level Design (LLD) documents, ensuring clear and accurate system specifications, which decreased implementation errors by 15%.• Authored SOP documentation and detailed PROD deployment steps, leading to smoother deployment processes and reducing production downtime by 10%.• Conducted knowledge transfer (KT) sessions with the Operations and QA teams, ensuring seamless handover and minimizing post-deployment issues by 20%.Environment: Oracle Exadata, OBIEE, ODI, Shell Script, Toad 11/12

Gp House, Dhaka

Worked for the BI-EDW team of Telenor-Grameenphone projectResponsibilities: #Development-----------------• Developed change requests (CR) using Oracle ODI, PL/SQL, OBIEE, and Shell scripting, streamlining data integration and reporting processes, which improved system efficiency by 20%.• Designed and scheduled ODI scenarios for Oracle procedures within ODI Load Plans, automating workflows and reducing manual intervention by 25%.• Compiled High-Level Design(HLD) and Low-Level Design (LLD) documents, ensuring clear and accurate system specifications, which decreased implementation errors by 15%.#Operation-----------------• Supported ad hoc requests for Grameenphone (GP), delivering rapid data insights that improved decision-making speed by 15%.• Executed ETL operational tasks, ensuring smooth data extraction, transformation, and loading, which enhanced data accuracy and reduced processing time by 20%.• Performed SFTP file transfers in a Linux environment, streamlining data flow and reducing file transfer errors by 10%.Environment: Oracle Exadata, OBIEE, ODI, Shell Script, Toad 11/12

Dhaka

Aprosoft Consulting and Training Corp. is a leading service based Offshore Development center (ODC) in Bangladesh. The company basically works as an extended team for its onshore high-profiled clients in US, Canada, Europe, Middle East etc. I've worked for account ADSR and Mead Johnson of Epsilon.Responsibilities as below -• Successfully developed and tested packages, stored procedures, and functions using SQL, PL/SQL Collections, Object Types, and Varray in Oracle, improving database performance by 30% and ensuring seamless execution of critical processes.• Developed and optimized Perl scripts to automate critical tasks, including file loading into Oracle databases and email notifications, reducing manual intervention by 50% and improving operational efficiency across processes.• Developed and optimized Shell scripts for file transfers via SFTP, automated email notifications, job scheduling using crontab, and ETL processes in Netezza, reducing data processing time by 20% and improving operational efficiency.• Enhanced and modified the Connect:Direct server routing process for file transfers, and implemented GPG (Gnu Privacy Guard) encryption and decryption, improving data security and transfer reliability by 15%.• Authored comprehensive technical and deployment steps documentation for PROD, ensuring accurate adherence to BRD (Business Requirement Documents) and FSD (Functional Spec Documents), which reduced deployment errors by 10%.• Designed workflow diagrams for projects using MS-Visio, streamlining project planning and communication, which reduced project timeline delays by 25%.

Dhaka, Bangladesh

Dhaka

• Developed and implemented various forms and reports using Oracle Developer Suite 6i and 10g Forms/Reports to meet client requirements.• Created and optimized stored procedures in Oracle Database 10g PL/SQL, improving system performance and functionality.

Mangaluru, Karnataka, India

Fully funded by Indian Govt. Scholarship for pursuing M.Tech in CSE at NITK Surathkal, Mangalore, Karnataka, India

Dhaka

• Conducted comprehensive unit testing to ensure code reliability and efficiency.• Delivered client training sessions, equipping them with the necessary skills to operate and maintain the developed system effectively.

Masters In Applied Statistics And Data Science (Masds), Data Science

Masters in Data Science

M.Tech In Cse, Computer Science And Engineering

MTech in CSE

B.Sc In Cse, Computer Science And Engineering

BSc in CSE

Higher Secondary Certificate, Science

Secondary School Certificate, Science