Shubhra Prakash Nandi

Shubhra Prakash Nandi

ABOUT ME
Oracle / Mysql developer, PL/SQL, Database design, UNIX Shell scripting, Pro*C developer, C developer
Oracle / Mysql developer, PL/SQL, Database design, UNIX Shell scripting, Pro*C developer, C developer

I have 10+ years of IT experience in Application Development, Systems Integration, Production Support, Application Maintenance and QA projects. I have played the role of Project Manager, Project Lead, Business Analyst, Developer and QA. I have managed complete SDLC for medium sized development projects. I have business domain knowledge in the area of Automotive on-board IT and telematics systems, Pharma Relationship Marketing, Manufacturing Execution Systems and Work and Asset Management. I have actively implemented LEAN practices in Production support projects.

Hindi, English
Kolkata (+05:30)
Joined February 2018
EXPERTISE
8 years experience
I have worked in a multinational IT firm for 10+ years with most of time in Oracle RDBMS domain. I have designed large Oracle databases, ...
I have worked in a multinational IT firm for 10+ years with most of time in Oracle RDBMS domain. I have designed large Oracle databases, done data migration, written large PL/SQL scripts, written Precompiler (Pro*C) programs for a batch application and have used Oracle RDBMS XML packages to handle message transfers for an application.
Oracle PL/SQLPerformance OptimizationDatabase schema, database design
View more
Oracle PL/SQLPerformance OptimizationDatabase schema, database designSQLTesting
View more
10 years experience
I have done complex shell scripting for various projects and to automate big tasks. I have built interfaces to process data from database...
I have done complex shell scripting for various projects and to automate big tasks. I have built interfaces to process data from databases using shell scripts.
7 years experience
I have been deploying Mysql databases for clients for high availability, fault tolerance, performance and design efficiency. I have worke...
I have been deploying Mysql databases for clients for high availability, fault tolerance, performance and design efficiency. I have worked for clients requiring multi-master cluster setup for very heavy data loads.
EMPLOYMENTS
Project Manager
Wipro Technologies
2005-11-01-2016-06-01
In Wipro I have worked in Application Development, Systems Integration, Production Support, Application Maintenance and QA projects. I ha...
In Wipro I have worked in Application Development, Systems Integration, Production Support, Application Maintenance and QA projects. I have played the role of Project Manager, Project Lead, Business Analyst, Developer and QA. I have managed complete SDLC for medium sized development projects. I have business domain knowledge in the area of Automotive on-board IT and telematics systems, Pharma Relationship Marketing, Manufacturing Execution Systems and Work and Asset Management. I have actively implemented LEAN practices in Production support projects.
Oracle
Unix
SOA (Service-Oriented Architecture)
View more
Oracle
Unix
SOA (Service-Oriented Architecture)
Oracle PL/SQL
SOAP Web Services
View more
PROJECTS
GEN 10
Big automobile manufacturer
2015
Developing Integration Gateway platform for one of the world's biggest automobile manufacturers for their vehicle telematics, on-board p...
Developing Integration Gateway platform for one of the world's biggest automobile manufacturers for their vehicle telematics, on-board problem diagnostics, remote assistance, crash reporting, turn by turn navigation and infotainment system. The Integration Platform uses the latest SOA Suite from Oracle Fusion Middleware and connects all of customers systems to provide a uniform interface for all end users to consume IT services. The SOA suite is hosted on Linux platform and uses Agile development methodology and Continuous Integration to achieve high productivity while keeping new functionality and features flowing for the customer thus giving it an edge from its competitors in this high growing and competitive IT space in North America and China.
Linux
Jenkins
Continuous Integration
View more
Linux
Jenkins
Continuous Integration
SOA (Service-Oriented Architecture)
SOAP Web Services
View more
ADS Layer Development
Large Pharmaceutical company
2013
ADS layer project is building an Oracle OLAP database to provision data to external vendors. Client has an operational database called...
ADS layer project is building an Oracle OLAP database to provision data to external vendors. Client has an operational database called IRMA which stores all customer and vendor transaction for its multi-channel integrated marketing platform. Client currently has batch feeds to provision this transactional data to external vendors which is time taking, complex and resource intensive. In order to overcome these challenges client is building the ADS database layer (also known as Provisioning Layer by customer) which can expose the same data to the vendors through database views. Vendors will be able to connect to this database in restricted manner and query the data belonging to them.
Oracle
Oracle PL/SQL
Database schema, database design
View more
Oracle
Oracle PL/SQL
Database schema, database design
View more