Prasanta Paul
Kolkata
Summary
Driven Database Developer with 11 years of experience in full lifecycle development. Goal-oriented team player succeeds working with various colleagues and clients by maintaining communication. Motivated with keen analytical, problem-solving and task management abilities.
Overview
11
11
years of professional experience
Work History
Software Engineering Professional
Lexmark International India Private Limited
07.2018 - Current
- Mainly focusing on in house products development and maintenance
- Design and develop databases made to support various applications while ensuring quality performance, reliability, and security
- Documenting business rules, functional and technical designs, test cases, and user guides in system requirement specifications
- Written PL/SQL scripts for partitioning and indexing database objects like tables, and functions for Oracle databases
- Extensively involved in writing PL/SQL stored procedures, functions and database triggers
- Performing the database design at the object level using array and object types
- Optimized queries for faster data fetching and processing to improve database performance
- Develop and maintain applications using ASP.NET, VB.NET and MVC for implementing business logic in 3-tier application interacting with SQL Server database, Oracle Database and PostgreSQL
- Used the SSIS to migrate databases such as Oracle and SQL Server database, flat files to centralized IT destination
- Involved in Developing, Monitoring and Deploying SSIS packages and successfully created dynamic configuration packages in SSIS.
Technology Analyst
Infosys Limited
06.2013 - 07.2018
- Involved in different GIS projects development and support using technologies like Oracle DB, Oracle Spatial and FME
- Designed several FME workbenches to implement business logics
- Developed database using several PL/SQL objects i.e
- Procedure, Package, Cursor, Trigger, Function etc
- To implement complex business logic
- Optimized queries for faster data fetching and processing to improve database performance.
Education
Bachelor of Technology in Electronics and Communication -
Dr. B.C. Roy Engineering College
Durgapur, West Bengal06.2012
Skills
- Oracle SQL, PL/SQL
- Microsoft SQL Server
- PostgreSQL
- SQL query optimization
- ETL process development
- Safe FME
- Database security
- SQL Performance Tuning
- Database design and development
- Data quality improvement
- Data analysis and modeling
- C#NET
- VBNET
- Microsoft Business Intelligence
- Code Reviewing
- Software Debugging
- Web application development
- MVC
- GitGitHub
- Tomcat
- MS Visual Studio
- Azure Board
Brief Profile
Experienced Database Developer with 11 years of expertise in designing, developing, and implementing data solutions that improve query response times, data accuracy, and security. Skilled in ETL processes, SQL query optimization, and database integration with other applications and systems. Extensive experience with modifying databases, solving issues, and ensuring standards are properly met.
I have specialized in working on requirements backlog to flesh out stories that the team can work on in the future. My responsibilities include working on story refinement, feature and story breakdowns and estimations of tasks, translate designs and wireframes into the high-quality code, code reviews, coding of current items in the iteration as well as working on special customer requests and field calls regarding software issues.
Managed other developers and oversaw the improvement of several applications. Devoted individual with the ability to successfully collaborate with coworkers to produce functional databases and smart solutions. Determined professional working to consistently meet and exceed standards.
Achievements
Lexmark Manager Appreciation Award
- For fixing a critical issue for multiple customers
Infosys Bravo Award
- For exemplified dedication and drive to closure on deliverables
Hobby & Interests
· Playing Cricket
· Playing Football
· Social working and contribution
Languages
English
Bengali
Hindi
Timeline
Software Engineering Professional
Lexmark International India Private Limited
07.2018 - Current
Technology Analyst
Infosys Limited
06.2013 - 07.2018
Bachelor of Technology in Electronics and Communication -
Dr. B.C. Roy Engineering College
Similar Profiles
PALLABI SAHAPALLABI SAHA
SOFTWARE TESTING SPECIALIST at LEXMARK INTERNATIONAL INDIA PVT LTDSOFTWARE TESTING SPECIALIST at LEXMARK INTERNATIONAL INDIA PVT LTD
DIVYA YADAVDIVYA YADAV
Senior Associate – Management Accounts at VISTRA INTERNATIONAL EXPANSION (INDIA) PRIVATE LIMITEDSenior Associate – Management Accounts at VISTRA INTERNATIONAL EXPANSION (INDIA) PRIVATE LIMITED
Sujay Jonas KSujay Jonas K
Logistics Team Leader at Allyn International India Private LimitedLogistics Team Leader at Allyn International India Private Limited
AVIJIT LAHAAVIJIT LAHA
Test Lead at HCL Technologies LtdTest Lead at HCL Technologies Ltd
Banasree DasBanasree Das
Sales Manager at Swarn Wellness Pvt. Ltd.Sales Manager at Swarn Wellness Pvt. Ltd.