Chandan Singh
Noida
Summary
Detail-oriented and highly skilled Oracle PL/SQL and Apex Developer with 14 years of experience in designing, developing, and implementing complex database solutions and web applications. Proven ability to bridge the gap between technical expertise and business requirements, resulting in optimized processes and improved efficiency.
Overview
14
14
years of professional experience
1
1
Certification
Work History
Oracle Apex Consultatnt
Digihelic Pvt Ltd
Noida
10.2023 - Current
- Customize Oracle SCM modules according to business requirements, ensuring optimal functionality and efficiency.
- Develop and maintain custom reports and dashboards using Oracle Apex, providing stakeholders with actionable insights into supply chain performance.
- Collaborate with cross-functional teams to identify opportunities for process improvement within the supply chain, leveraging Oracle SCM capabilities.
- Implement data integration solutions to streamline information flow between Oracle SCM and other systems, enhancing data accuracy and accessibility.
- Provide technical support and troubleshooting for Oracle Apex applications and SCM-related issues, ensuring minimal disruption to business operations.
- Development of Bank Page for Middle East Government Bank.
13 Years of Experience in Oracle Apex & PL /SQL
Development
07.2010 - Current
Technical Consultant (E2 Officer)
DGH
Noida
11.2017 - 10.2023
- Translated business requirements into technical solutions by designing and developing Oracle Apex applications.
- Communication with stockholders, business user, products owners for getting requirements.
- Write Business requirement\functional requirement document.
- Lead the new development\enhancement.
- Lead a team of single digit members.
- Active member of development, enhancement, integration and deployment.
- Worked closely with business stakeholders to gather and document requirements and specifications.
- Managed Oracle databases, monitored performance, and tuned SQL queries to improve efficiency.
- Establishment of Database servers /planning / Designing / Development and maintenance of oracle database for DGH in House Applications for DGH & MoPNG.
- New business implementation project, drive the end to end process from business requirement management to integration &configuration and production deployment.
- Ensures adherence to government regulations and guidelines for technological systems and safeguarding of data.
- Trouble shoots and finds solutions for Network/OS/computer systems issues that affect data storage as they arise.
- IT resource Planning and Team management.
- Planning and setting up of new IT infrastructure
- Analyzing new requirements and proposals
- Managing and planning of Data Integrity, Data Recovery and Back up, Hardware devices, Database Performance, Capacity Issues, Database accessibility, Validation checks on data and monitoring Performances.
Technology Analyst
Infosys
Hyderabad
01.2015 - 11.2017
- Worked on Oracle EBS
- Involved in analysing the codes which needs to be tuned / Break Fix / Enhancement
- Developed/Changed PL/SQL packages, procedures, triggers, functions, Indexes and Collections
- Reviewed and implemented new changes in the database
- Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances
- Worked on huge customized relational database
- Attending/Driving monthly/daily calls related to Ariba or other core Applications
- Maintaining critical time sensitive objectives and emphasis on planning skills
- Worked on Tools like TOAD, PL-SQL Developer, Reflection, VRMS, ACRM, HP-QC, REMEDY, PUTTY, ECM
- Trained new hires
- Prepared monthly and weekly report for the business
- Performed Daily/ Weekly/Monthly Calls with Customers on Process updates
Analyst Programmer
Accenture
Hyderabad
07.2010 - 01.2015
- Involved in creating UNIX shell Scripting and Running shell scripts in UNIX for completing daily activities like updating porting-in and porting-out details of the phone numbers.
- Analyzed complex datasets and designed PL/SQL scripts to extract, transform, and load data into data warehouses.
- Writing Business Logic using Oracle PL/SQL.
- Optimized ETL processes for streamlined data flow.
Education
Bachelor of Engineering - Computer Science
GEC,RGPV UNIVERSITY
BHOPAL2009
Skills
- Oracle Apex development
- Oracle SQL and PL/SQL
- Oracle SCM modules (eg, Inventory, Order Management, Procurement)
- Report development and customization
- Data modeling and database design
- JavaScript, HTML, CSS (for frontend development in Apex)
- Oracle Application Express (Apex) , FORMS & REPORTS
- Database BACKUP,Restoration, Migration and Management
- REST API, WEBLOGIC, ORDS
- JSP,CSS,HTML,JAVA,UNIX,JDBC, XML
- Aware of ETL , Data Modelling and Data warehousing
- Tools:TOAD, PL-SQL Developer, Reflection, VRMS, ACRM, HP-QC, REMEDY, PUTTY, ECM
Affiliations
- Travel and Cultural Experiences
- Community Involvement ,Running NGO ARTHH for social cause.
Certification
- SUN CERTIFIED JAVA PROGRAMMER (SCJP) : Certification# “11/05
- DIAT Certified Information Assurance Professional. Completed Training and certification on Cyber Security by DRDO.
Timeline
Oracle Apex Consultatnt
Digihelic Pvt Ltd
10.2023 - Current
Technical Consultant (E2 Officer)
DGH
11.2017 - 10.2023
Technology Analyst
Infosys
01.2015 - 11.2017
13 Years of Experience in Oracle Apex & PL /SQL
Development
07.2010 - Current
Analyst Programmer
Accenture
07.2010 - 01.2015
Bachelor of Engineering - Computer Science
GEC,RGPV UNIVERSITY
Similar Profiles
Jayesh SutharJayesh Suthar
Financial Analyst at Coforge Solutions Pvt Ltd, Client - Nomura Services India Pvt LtdFinancial Analyst at Coforge Solutions Pvt Ltd, Client - Nomura Services India Pvt Ltd
Anita NairAnita Nair
Customer Support Manager at Captivo Consultancy Pvt Ltd/ Smartwise Tech Pvt LtdCustomer Support Manager at Captivo Consultancy Pvt Ltd/ Smartwise Tech Pvt Ltd
Urmila MagdumUrmila Magdum
Project Manager at TEKsyatems Pvt Ltd. C2H Cisco Pvt LtdProject Manager at TEKsyatems Pvt Ltd. C2H Cisco Pvt Ltd
Varsha JasrotiaVarsha Jasrotia
Assistant Manager Talent Acquisition at Deloitte IndiaAssistant Manager Talent Acquisition at Deloitte India
Ayush JainAyush Jain
Software Engineer at Cognizant Technology Solutions, CTSSoftware Engineer at Cognizant Technology Solutions, CTS