DHRITIMAN BISHNU
Technical Lead
Howrah
Summary
14+ years of experience in Oracle and MySQL Database Development. Responsible for Analysis, Design and Implementation of Business Applications. Understanding in Data Warehousing concept and hands-on experience in Data Migration. Knowledgeable on TIBCO Spotfire for analytical dashboard development from/to different data source. Understanding in Oracle, MySQL & PostgreSQL Database, SQL,PL/SQL and Psql. Complex problem-solver with analytical and driven mindset. Dedicated to achieving demanding development objectives according to tight schedules while producing impeccable code. To seek and maintain full-time position that offers professional challenges utilizing interpersonal skills, excellent time management and problem-solving skills.
Overview
17
17
years of professional experience
5
5
years of post-secondary education
Work History
Tech Lead
Skyvera(Crossover)
09.2023 - Current
- Analyzing, documenting and communicating migration details following implementation to take a constructive approach to continuous improvement
- Document, review, and confidently communicate project deliverables to stakeholders and internal team members
- Provide Statistical reports of data received, validated, duplicate data identified, successfully loaded and data with error
- Identify risks that could impact a successful migration
- Provide support within the Data Migration team
- Monitor technical validation of extracted and uploaded data
- Work with Solution, Infrastructure, QA, BRM, CRM and PCC experts and project team to identify, define, collate, document and communicate the data migration requirements.
Tech Lead
Skyvera(Nimzo-I)
04.2023 - 08.2023
- Analyzing, documenting and communicating migration details following implementation to take a constructive approach to continuous improvement
- Document, review, and confidently communicate project deliverables to stakeholders and internal team members
- Provide Statistical reports of data received, validated, duplicate data identified, successfully loaded and data with error
- Identify risks that could impact a successful migration
- Provide support within the Data Migration team
- Monitor technical validation of extracted and uploaded data
- Work with Solution, Infrastructure, QA, BRM, CRM and PCC experts and project team to identify, define, collate, document and communicate the data migration requirements.
Tech Lead
Sterlite Technologies
06.2022 - 03.2023
- Analyzing, documenting and communicating migration details following implementation to take a constructive approach to continuous improvement
- Document, review, and confidently communicate project deliverables to stakeholders and internal team members
- Provide Statistical reports of data received, validated, duplicate data identified, successfully loaded and data with error
- Identify risks that could impact a successful migration
- Provide support within the Data Migration team
- Monitor technical validation of extracted and uploaded data
- Work with Solution, Infrastructure, QA, BRM, CRM and PCC experts and project team to identify, define, collate, document and communicate the data migration requirements.
Project Team Lead
Lohia Jute Press Pvt. Ltd.
01.2021 - 05.2022
- Responsible to lead all Operators, System Administrators and Network Administrators
- Ensured the availability and allocation of operators, team members and overall resource planning and management
- Organized periodic status meeting and discussion with district level Government officers
- Coordination between PFC Operators and Technical Support Staffs
- Responsible for day-to-day DBA activities
- Engaged in Database Design and development of Inventory Management and Issue Tracking System and monitoring
- Engaged in Dashboard development using GDS (Google Data Studio) accessing the in-premises Relational Database.
Project Manager
TCG Digital Solutions Pvt. Ltd.
08.2007 - 09.2020
- Ensured the scope of the project as per the project plan with client or onsite coordinator
- Ensured the availability and allocation of team members and overall resource planning
- Organized periodic status meeting to face the weekly client status meeting effectively
- Monitored all new development requests or change requests and related SLA
- Coordinated and mitigate any network issue with in-house facility department
- Motivated team members to meet any challenge or tightly time bound deliveries
- Maintained client satisfaction to share the status report and frequent communication
- Communicated the progress to higher management
- Gathered the requirements from business users and communicated with team members
- Designed and developed technical solutions that meet business requirements based on functional designs
- Database design, modeling and data integrity and performance tuning of complex SQL queries.
Education
MSc. in Computer Science - Computer Science
Sikkim Manipal University
Sikkim Manipal University 01.2009 - 05.2011
Post Graduate Diploma in Computer Application -
Computer Society of India
Computer Society Of India 11.2001 - 11.2002
Bachelor’s Degree in Commerce - Accountancy
University of Calcutta
Shibpur Dinobondhu College 04.1990 - 05.1992
Skills
Database Development
Analytical Reporting
Experienced in Analytical Reporting using Google Data Studio (GDS), TIBCO Spotfire and MS SSRS. In case of GDS, the cloud based analytical report is able to communicate with In-premises MySQL Database running in Linux server.
Data Migration
Experienced to migrate FMCG based heterogeneous historical data from different source frameworks (i.e., MS Excel Files, Text Files, MS SQL Server) to destination ORACLE and TERADATA databases through ETL process for analytical reporting purpose. Experienced to migrate legacy Telcom data to Oracle BSS to facilitate BRM,CRM,PCC and other Oracle BSS components and reporting database.
Database Development
Programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS). Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modelling and design techniques.
Telecom Nodal Support
Experienced to act as the nodal support personnel to process Corelated and Non-Corelated data.
Dba Activities
Experienced in basic Oracle and MySQL DBA activities (i.e., Installing and Creating Database, User Management & Security, Database Backup, Creating Table, Views, Index etc.)
Domain Knowledge
- Aviation
- Retail
- Shares & Mutual Funds
- Printing & Publications
- Healthcare
- Public Service
- Telecom
Clients Served
- UNITED AIRLINES
- ACQUITY GROUP
- ADITYA BIRLA RETAIL LIMITED
- HALDIA PETROCHEMICALS
- ASSAM RURAL INFRASTRUCTURE AND AGRICULTURAL SERVICES SOCIETY (ARIAS)
- MTN SUDAN
- VODAFONE
Technical Skillset
Oracle 7.3, 9i, 10g, 11g, SQL Server 12.0, MySQL 8.0, Windows 9x/NT/XP/2000/Vista/Windows 10, Ubuntu Linux 20.4, SQL, PL/Sql, TSQL, TOAD, Sqldeveloper, SQL Server Management Studio, Teradata SQL Assistant, Microsoft SSRS, Pentaho ETL Tool, TIBCO Spotfire, Oracle Developer 2000, SQLyog, WinSCP, NetBeans IDE 8.2, PuTTY, Google Data Studio (GDS)
Conversant With
Teradata, PostgreSQL 4.21, MariaDB, Java, JavaScript, Python, Oracle Apex, Teradata SQL Assistant, Microsoft SSRS, PgAdmin 4.0, Informatica ETL Tool 9.6.1
Other Contact Number
+91 7980613912
Personal Information
- Pan Number: AMPPB1223K
- Passport Number: G5224031
- Date of Birth: 06/08/1972
- Marital Status: Married
Training
- CMMi Awareness
- Software Metrics and Testing
- ISO 9000 Awareness
- Project Management Overview
- Networking & Cyber Security
Timeline
Tech Lead
Skyvera(Crossover)
09.2023 - Current
Tech Lead
Skyvera(Nimzo-I)
04.2023 - 08.2023
Tech Lead
Sterlite Technologies
06.2022 - 03.2023
Project Team Lead
Lohia Jute Press Pvt. Ltd.
01.2021 - 05.2022
MSc. in Computer Science - Computer Science
Sikkim Manipal University
01.2009 - 05.2011
Project Manager
TCG Digital Solutions Pvt. Ltd.
08.2007 - 09.2020
Post Graduate Diploma in Computer Application -
Computer Society of India
11.2001 - 11.2002
Bachelor’s Degree in Commerce - Accountancy
University of Calcutta
04.1990 - 05.1992
Similar Profiles
JEEL SHAHJEEL SHAH
Software Engineer at SkyveraSoftware Engineer at Skyvera
Sairaj ChanaganiSairaj Chanagani
System Engineer at SkyveraSystem Engineer at Skyvera
Shailesh SavlaShailesh Savla
SERVICE OPERATION & DELIVERY MANAGER at CrossoverSERVICE OPERATION & DELIVERY MANAGER at Crossover
Manisha BiswasManisha Biswas
Technical CS Specialist- Enterprise Support at AWSTechnical CS Specialist- Enterprise Support at AWS
Rudra Prasad BhattacharjeeRudra Prasad Bhattacharjee
Application Development Senior Analyst at Accenture (Bank of America)Application Development Senior Analyst at Accenture (Bank of America)