Oracle SQL, PL/SQL, Oracle APEX,Forms,Reports, BI Publisher

CV of Narendra Bhatia Page * of *

Narendra Bhatia

***** ****** *** *** *** CERRITOS CA 90703 ● +1-734-***-**** ● **********@*****.*** PROFESSIONAL SUMMARY

About 17 years of experience in Analysis, Design, Development, customizations, and Implementation of client server applications.

Worked in diverse areas of business comprising ERP, Loan Banking, Corporate Banking, Manufacturing, M&E Industries and gained keen insight into functionality requirements, methodology of developing software applications for these areas.

Proficient in analyzing and translating business requirements to technical.

Experience with various technologies such as Oracle SQL, PL/SQL, Oracle Forms, Oracle Reports, Oracle Application Express (Apex) & shell scripting.

Experienced in PL/SQL application fine-tuning and performance tuning of SQL queries by using DBMS_HPROF, Explain Plan & TKProf.

Oracle certified professional (OCP)

Plan and implement backup & recovery strategies Using RMAN & Data pump (expdp/ impdp).

Experience in migration of data from Excel and Flat file to oracle database using SQL Loader.

Development and Implementation Experience of ERP & Banking Software.

Experience in leading and managing teams. Handled multiple roles - Team Lead, Software Developer, Systems Analyst.

Good communication skills, interpersonal skills, self-motivated, quick learner, team player.

Ability to accept challenges & adapt new technologies quickly. TECHNICAL EXPERTISE

Programming Languages: SQL, PL/SQL, shell, XML, Pro* C.

GUI Tools: - Oracle Forms 6i/10g, Oracle Designer, Visual Basic 6.0, Oracle APEX.

Reporting Tool: -Oracle Reports, BI Publisher, Crystal Reports.

Database: - Oracle, MongoDB.

Version control: Visual Source Safe, IBM Rational Clear case.

Others: SQL Loader, Oracle REST Data services (ORDS), RMAN, Putty, WinSCP, TOAD, Eclipse, Unix/Linux, Jira Agile using Kanban.

EDUCATIONAL QUALIFICATIONS:

M. Tech. (Computer Science.), Rajasthan Vidya Peeth University Udaipur. Raj. India. 2007

Master of Science (Mathematics), M.D.S. University, Ajmer. Rajasthan. India. 2003

Post Graduate Diploma in Computer Application, M.D.S. University, Ajmer. Raj. India. 2001

B.Sc. (Mathematics Honors), M.D.S. University, Ajmer. Raj. India. 1999 CV of Narendra Bhatia Page 2 of 5

ORACLE CERTIFICATIONS (Oracle Certified Professional)

Oracle Database SQL Expert (1ZO-047)

Oracle Database 11g: Program with PL/SQL (1Z0-144 Pl/SQL Developer Certified associate)

Oracle Forms: Build Internet Applications (1Z0-141 Oracle form developer certified Professional)

Oracle Database 11g: Advanced PL/SQL (1z0-146)

Oracle Autonomous database Cloud 2019 (1Z0-931)

Oracle Cloud Infrastructure Foundation 2020 Associate (1Z0-1085-20) PROFESSIONAL EXPERIENCE:

Application Developer – Infoshare Systems Inc. USA. Oct. 2019 - Present Client: Los Angeles County, Department of public & Social Services, Norwalk, CA. Los Angeles County is one of the nation's largest counties nearly 10 million residents. The County is charged with providing numerous services that affect the lives of all residents, including law enforcement, tax collection, public health protection, public social services, elections, and flood control.

Project: eTime (Employee Time management Systems)

Responsibilities:

Work with end user to analyze and understand the Business Requirements and translate customer requirements into formal requirements.

Develop new application by create new web pages, classic & Interactive reports by using Oracle Application Express (APEX) & Oracle Reports.

Write oracle PL/SQL program units like packages, procedures, triggers, function etc.

Responsible for performing different level of core technical activities like design, development, unit testing, integration testing, UAT and deployment.

Provide support for existing Oracle EBS applications and work on small enhancements using Oracle BI Publisher.

Migrating Apex 4.2 application & EBS customer Oracle Forms application to Oracle Apex 19.2. Environment: Oracle 12c, SQL, PL/SQL, Linux Oracle Reports, Oracle Apex, Oracle developer /Toad, BI Publisher, Oracle EBS.

Lead Application Developer - IBM India Pvt Ltd., USA. Nov. 2014 - Oct. 2019 Client: ProQuest, Ann arbor Michigan, USA.

ProQuest is Electronic Publisher which provides the customers with Best answers quickly and effectively through its online digital library. It partners with various clients to get content in different formats and reformat the data and store in its own repository. The stored data are historical Newspapers, Journals, Research Materials, Dissertations, and online books. CV of Narendra Bhatia Page 3 of 5

Project: Dissertation, eBook, Canadian Government Publication (CRI) & Research Collections. Responsibilities:

Work with end user to analyze and understand the Business Requirements and translate customer requirements into formal requirements.

Deliver new and complex high-quality solutions to clients in response to varying business requirements using Oracle PL/SQL program units like packages, procedures, triggers, function etc.

Database design & developing UI, Using Oracle Forms, Oracle Reports, Designer & Oracle APEX.

Migrated Oracle Forms/Reports Application to Oracle Application express.

Responsible for performing different level of core technical activities like design, development, unit testing, integration testing, UAT and deployment.

Provide Production support for all Exodus Applications like Dissertation, Early English Book, Canadian Government Publication (CRI) & Research Collections.

Responsible for providing day to day direction to the offshore team to get the assignment complete on scheduled time and provide regular work status to project management and to customer. Environment: Oracle SQL, PL/SQL, Linux /Solaris OS. Oracle Forms 10g, Report 10g, Oracle Designer, Oracle Apex, Oracle developer /Toad. Pro *C, Jira Agile using Kanban Board. Sr. System Engineer - IBM India Pvt Ltd., Kolkata, India. Mar. 2012 - Nov. 2014

Worked for same client (ProQuest) from India, before moving to USA. System Analyst - Nucleus Software Exports Limited, India Jan. 2008 - Mar. 2012 Client (State Bank of India / IndusInd Bank/ Citi bank Singapore) Project: CASH@Will

Nucleus Software is a leading global software powerhouse providing innovative and pioneering products and software solutions since 1986. Its core competence is wholly focused in banking and financial services spanning across solutions in the areas of Core Banking, Retail & Corporate Banking, Credit Cards, Cash Management, Relationship Banking, Financial CRM, Credit Risk & Appraisal, Trade Finance, EAI, Internet Banking, FX, Basel II, Data warehousing and Analytics. Company offers many core & customized products for different services to their clients. CASH@Will is a Cash Management solution designed and developed by Nucleus Software Exports Limited for banks that provide Cash Management Services to their corporate clients. CASH@Will helps banks process cash management transactions like collections, payments, and liquidity management. CASH@Will is a web-based application supporting multi-branch, multi-currency, multi-bank, and multi- language processes.

Responsibilities:

Customization of Industry leading cash management solution for corporate customers Like State Bank of India, Indus Ind. Bank, Citi Bank etc. Utilize in-depth functional knowledge of Cash@will CV of Narendra Bhatia Page 4 of 5

Product along with Technical experience in and technology in conjunction with industry and business skills to deliver solutions to customer.

Involving in application design based on business logics.

Designing & developing Oracle Forms & Reports.

Writing PL SQL program units like packages, procedures, triggers, functions, etc.

Maintaining the technical documentation and product manual creation for customized software and business processes.

Harmonizing with the product development group to fix bugs in core and for making enhancements in product features/ functionalities based on Standard functional requirements.

Translate customer requirements into formal requirements and create design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results.

Establish Quality Procedure for the team and continuously monitor and audit to ensure team meets quality goals.

Environment: Oracle SQL, PL/SQL, Linux OS, Oracle Forms 10g, Report 10g, IBM Rational Clear case. Sr. System Engineer. - Toshiniwal Industries Pvt. Ltd, Ajmer, India Jul. 2007 - Jan. 2008 Client: In House Development

Toshiniwal Industries Private limited. Is an ISO 9001:2000 certified Industry Which manufactures Temperature Detector, Thermocouples & RTD's (Mineral Insulated), Optical Pyrometer, Digital Controllers & Indicators etc. for various clients in India & abroad. Project: - ERP Solution for TIPL

Responsibilities:

Developed in house solution for ERP Application using Oracle SQL, PL/SQL, Oracle forms & Reports 6i.

Accountable for consulting in functional as well as technical aspects of ERP Implementation for end user and project implementation.

Interfacing with the end user for mapping the requirements stipulated.

Involving in application design based on business logic.

Designing & developing forms / reports.

Responsible database backup & recovery.

Responsible for application performance & to tune SQL Queries using Hints, explain Plan & TKProf

Writing PL SQL program units like packages, procedures, triggers, functions, etc.

Maintaining the technical documentation and product manual creation for customized software and business processes.

Environment: Oracle SQL, PL/SQL, Oracle Forms 6i, Report 6i, Visual Source Safe, windows OS. CV of Narendra Bhatia Page 5 of 5

Sr. System Engineer - NCCMS, Chandigarh, India, Dec. 2005 - Jun. 2007 Client: Kapson industries Pvt. ltd Jalandhar, India Kapsons Industries is an ISO 9001:2000 certified Industry with annual turnover 300 Crores which manufactures Electric Motor Stampings, Auto Parts and Die Cast Rotor for various clients in India & abroad such as Crompton Greaves, Khaitan etc.

Project: Suvidha, ERP Solution for Kapson

Responsibilities:

Developed & Implemented ERP (Suvidha) solution for client Kapson Industries using Oracle SQL, PL/SQL, Visual Basic & Crystal report.

Worked on ERP Modules like Sale (Order Acceptance, IPO Acceptance, Dispatch, and Billing), Purchase (Indent preparation, Purchase Order, MRIR, and Quality Control), Store & Production.

Involved in Requirement analysis and creating documents needed to project.

Responsible for Implemented of the project & to provide training to end users.

Responsible database backup & recovery.

Responsible for application performance & to tune SQL Queries using Hints & explain Plan. Environment: Visual Basic 6, Crystal Reports 8.5, Oracle SQL, PL/SQL, Windows NT OS. Programmer - DOEACC center Chandigarh, India Aug. 2003 - May 2005 Client: Rajasthan State Land development Bank, (RSLDB), Jaipur, India The Rajasthan Rajya Sahakari Bhoomi Vikas Bank Ltd. is a pioneer apex institution providing long- term agricultural investment credit to the farmers of the state through 36 Primary Land Development Banks (having 133 branches). To monitor periodical progress, SLDB has set up 7 Regional Offices. This Project divided in four levels: 1) Branch 2) PLDB 3) RO 4) SLDB. Each level has different modules. Main Modules are: Granting membership, Application Form Receipt, Application form detail, Loan Subsidy, Loan postponement, Loan disbursement, Demand notice generation, Loan recovery, settlement schemes, Accidental Insurance, Fixed Deposit, Reimbursement, Debentures etc. Project: Computerization of RSDL Bank.

Responsibilities:

Developed new Lending system for client Rajasthan state Land development bank RSLDB using Oracle SQL, PL/SQL, Oracle forms & Reports 6i.

Environment: Oracle SQL, PL/SQL, Forms 6i, Report 6i, Pro *C Visual Source Safe, windows OS.

Contact this candidate