Dinker Pal Email & Phone Number

Noida

Data Migration Activity from Old system ( FinnOne ) to New System (FinnOne Neo).• Development of data extraction code from FinnOne and then transform the data according to theFinnOne Neo.• Successfully led the team through all the phases of the data migration activity including planningexecution,monitoring and closure.• Coordinating with cross-functional teams including IT, operations, Compliance and business to ensurealignment and smooth execution.• Participating in… Show more Data Migration Activity from Old system ( FinnOne ) to New System (FinnOne Neo).• Development of data extraction code from FinnOne and then transform the data according to theFinnOne Neo.• Successfully led the team through all the phases of the data migration activity including planningexecution,monitoring and closure.• Coordinating with cross-functional teams including IT, operations, Compliance and business to ensurealignment and smooth execution.• Participating in database design within an existing Oracle database structure.• Helping application development team in preparing technical designs and perform constructionactivities• Writing complex functions and procedures for new packages and update existing packages in anestablished Oracle database using pre-defined business rules.• Performance testing and rewriting of production Code/SQL statements & procedures performing badly,identified by database administrators.• Performance testing and rewriting of production Code/SQL statements & procedures performing badly,identified by database administrators.• Supporting the application through the testing and implementation phases, including product test,stress/load test etc. Show less

Noida Area, India

Pune, Maharashtra, India

This is basically a supply chain management project which is supporting the cummins ltd to maintainall its supply chain activity through all the PDCs and RDCs.• Involved in database development by creating Oracle PL/SQL functions, procedures, triggers, packages,records, and collections.• Creating database objects like SQL queries, tables, joins stored procedures using Oracle utilities likePL/SQL, SQL plus, SQL server.• Involving in performance tuning for complex SQL… Show more This is basically a supply chain management project which is supporting the cummins ltd to maintainall its supply chain activity through all the PDCs and RDCs.• Involved in database development by creating Oracle PL/SQL functions, procedures, triggers, packages,records, and collections.• Creating database objects like SQL queries, tables, joins stored procedures using Oracle utilities likePL/SQL, SQL plus, SQL server.• Involving in performance tuning for complex SQL queries using explain plan tables, collections, and tablepartitions to optimize performance.• Generating SQL and PL/SQL scripts to create and drop database objects including tables, views, primarykeys, indexes, constraints, packages, sequences, grants, and synonyms.• Involving in application enhancements according to user requirements.• Building physical data structures like tables, views, constraints & indexes. Show less

Gurgaon, Haryana, India

Developing complex database processes with PL/SQL containing batch or ETL functionality.• Requirements gathering, design, development, testing, and documentation.• Providing production deployment and production support as needed.• Analyzing and converting business requirements to technical requirements, followed by designing andimplementing the solutions• Involving in application enhancements according to user requirements.• Building physical data structures like tables,… Show more Developing complex database processes with PL/SQL containing batch or ETL functionality.• Requirements gathering, design, development, testing, and documentation.• Providing production deployment and production support as needed.• Analyzing and converting business requirements to technical requirements, followed by designing andimplementing the solutions• Involving in application enhancements according to user requirements.• Building physical data structures like tables, views, constraints & indexes.• Implementing features including materialized views for better performance of summary tables,autonomous transactions, coding dynamic SQL statements.• Created numerous complex queries involving joins, correlated sub-queries diverse businessrequirements.• Created numerous complex queries involving joins, correlated sub-queries diverse businessrequirements.• Assisted in the migration of legacy Oracle applications to newer versions for improved functionality andsecurity. Show less

Gurgaon, Haryana, India

MM Infosystems is ERP bases company which serves all the leading manufacturing companies like BAJAJ,LOHIA, JUSHIN, SPARK MINDA GROUP. My Key Rolls an responsibilities for this projects are..• Designed and developed database schemas, stored procedures, and triggers in Oracle.• Provided production support and resolved issues related to database performance and functionality.• Developed Oracle Forms and Reports to create user-friendly front-end applications for data entry… Show more MM Infosystems is ERP bases company which serves all the leading manufacturing companies like BAJAJ,LOHIA, JUSHIN, SPARK MINDA GROUP. My Key Rolls an responsibilities for this projects are..• Designed and developed database schemas, stored procedures, and triggers in Oracle.• Provided production support and resolved issues related to database performance and functionality.• Developed Oracle Forms and Reports to create user-friendly front-end applications for data entry andreporting• Collaborate with other developers, analysts, and stakeholders to develop database solutions• Create and maintain technical documentation• Implemented the 2-D and 3-D Barcode and embeded in oracle reports.• Provided a solution to generate the QR code using basic informative forms and scan it through universalscanner. Show less

Noida

Eastern Software System is ERP bases company which serves for the manufacturing industry and retailIndustry as well. My Key Rolls and responsibilities are given below.• Build and maintain new Forms using Oracle Forms• Build and maintain new Reports Using Oracle Reports.• Sharing BRD and main design document.• Manage Installation, configuration of Oracle Java, WebLogic and Oracle forms and Reports.• Provided production support and resolved issues related to database… Show more Eastern Software System is ERP bases company which serves for the manufacturing industry and retailIndustry as well. My Key Rolls and responsibilities are given below.• Build and maintain new Forms using Oracle Forms• Build and maintain new Reports Using Oracle Reports.• Sharing BRD and main design document.• Manage Installation, configuration of Oracle Java, WebLogic and Oracle forms and Reports.• Provided production support and resolved issues related to database performance and functionality.• Designed and developed database schemas, stored procedures, and triggers in Oracle.• Created and maintained complex SQL queries for data extraction and reporting purposes. Show less

Master Of Computer Applications (M.C.A.), Computer Science

Intermediate, Science

Bachelor'S Degree, Mathematics