SUMMARY

• Senior Technical Lead/Oracle Database Developer / Database Engineer / Data Analyst /with more than 16 Years of IT Experience involving extensive experience in providing solutions and developing client/server applications using Oracle Technology to meet business objectives and project goals
• Solid experience with Oracle PL/SQL with Advanced concepts with various UI Integration and large database with different Oracle version like Oracle 8i,9i,10g,11g,12c,19c.
• Solid experience with database creation, SQL script writing, database object creations like tables, views, Procedure, functions, triggers, packages, cursors, table types Nested Tables, Bulk collect & bulk data processing etc.
• Experience with database architecture including design of logical and physical database for new or existing applications
• Experienced in application fine - tuning & database performance fine-tuning using Explain Plan and analysis tools, monitor performance and identify bottlenecks and System Tuning
• Solid experience with Oracle development Tools using Developer 2000 with Oracle Developer Suite 10g, Forms 6i and 9i, Reports 6i and 9i and Oracle Graphics
• Extensive experience supporting system migrations / upgradation and designing solutions for system enhancements for various clients. Integration and implementation of migrating third-party databases to Oracle Database or data sync up between two databases.
• Working experience to design and build ETL & ELT processes to migrate the data between the heterogeneous environment (Oracle, MS Sql, DB2, Flat File like csv, xml, json etc files) using tools like Informatica, Oracle SQL Loader, MS SSIS DTS Packages
• Experience with integration ofOracle databases with Business applications, Data Analysis, Ability to Extract & Massaging meaningful business-related data from OLTP to generate valuable MISreports
• Experience with Data Requirement, Data Analysis, Data Mapping, Data Extraction & Data Management
• Experience in integration of Oracle database with various front-end applications like Java, Angular, Visual Studio etc.
• Experience with working with ERP project and having knowledge on Service Contract Management / Service Supply Chain / Finance domain
• Extensive experience to following SDLC cycle and Agile framework development cycle and Scrum methodology like Tracked and managed product backlog, burndown metrics, velocity, and task breakdown. Protect development team from outside distractions, impediments or team conflicts, and maintain focus on product backlog and project timeline
• Experience in managing projects like prioritizing, estimation, planning and execution for the client’s requirements
• Closely worked with end user and daily interaction with the client for Fine-tuning the Requirements stipulated and Experience of working, coordinating & managing with big team
• Proven ability to work creatively and analytically in a problem-solving environment

TECHNICAL SKILLS

Operating System: Windows 7/8/10, Windows XP, UNIX

Databases: Oracle 19C, Oracle 12C Exadata, Oracle 11g, 10g, 9i, 8x, Microsoft SQL Server

Database Designer Tools: Oracle Designer, ER Win, SQL Loader

Languages: SQL, PL/SQL, Java Script and Java

Development Tools: PL/SQL Developer, Toad, Oracle Developer,Jenkins

ETL Tool: Microsoft SSIS DTS Packages, Informatica Power Center 9.1

Version Manager Tools: GITLab, VSS, PVCS, SVN, Quality Center & Rally

Others: Python (Basic,PANDAS,File Handling,MATPLOTLIB), Tableau 9 (self-learning & implementation)

PROFESSIONAL EXPERIENCE

Confidential

Sr. Oracle Database Developer (PL/SQL)

Responsibilities:

• Working on bug fix and enhancement of application with database changes using Oracle Pl/Sql program
• Working on Performance tuning of application and backend processes
• Analysis of Pl/Sql program trace file and database AWR report to identify the performance bottle neck
• Pl/Sql code changes in Packages / Procedure/ function / Triggers etc. with advance Oracle concepts,
• Designing of Sql scripts for code migration to test & production env
• Creating and modifying Inquiry Reporting
• To communicate with colleague & Support Team for Enhancement.
• To maintain Source code
• Code and Test Results Review
• Identifying project problems and taking preventive/corrective action
• QA/BAT & UAT support and Technical Support to team

Environment: Oracle 19c, Tibco Inquiry Reporting tool, BitBucket, GIT, Jenkins, JIRA,RLM

Confidential

Sr. Oracle Database Developer (PL/SQL)

Responsibilities:

• Working on bug fix and enhancement of application with database changes using Oracle Pl/Sql program
• Working on Performance tuning of application and backend processes
• Analysis of Pl/Sql program trace file and database AWR report to identify the performance bottle neck
• Pl/Sql code changes in Packages / Procedure/ function / Triggers etc. with advance Oracle concepts,
• Designing of Sql scripts for code migration to test & production env
• Editing DB Script & Seed Script using Python scripts
• ETL for JSON files to Oracle database using python scripts
• To communicate with colleague & Support Team for Enhancement.
• To maintain Source code
• Code and Test Results Review
• Identifying project problems and taking preventive/corrective action
• QA/BAT & UAT support and Technical Support to team

Environment: Oracle 19C, Oracle 12C Exadata, GIT, Jenkins, JIRA,JIRA

Confidential, Berkeley, California

Sr. Oracle Database Developer

Responsibilities:

• Teradata to Oracle query Conversion
• Fine tuning existing report queries
• Conversion of complex queries to Store Procedures
• Pl/Sql program Tuning & Performance Tuning
• Working & designing on Tableau report & dashboard
• Worked on Microsoft SSIS DTS Packages
• Design ELT process to push the data from Oracle to Hadoop database Unix Script
• Develop ETL process for heterogeneous data systems like Oracle, Microsoft SQL Server databases, DB2 & Flat Files
• Creation of test case execution report using Python using Oracle Database Connection (cx oracle)
• Extract & Massaging the data to generate valuable MISreports
• Integration Oracle database with JAVA application
• Providing database solution for creating logical & physical database design for new project or enhancement
• To communicate with colleague & Support Team for Enhancement.
• To maintain Source code. Code and Test Results Review
• To study the System and Preparation of the technical documents. Writing New Reports
• Creating new forms and modifying existing forms based on Technical Specifications
• Identifying project problems and taking preventive/corrective action
• QA/BAT & UAT support and Technical Support to team

Environment: Oracle 12C Exadata, Informatica Power Center 9.1, Tableau Report, Hadoop, Python, Microsoft Sql Server, Microsoft SSIS DTS Packages, Java

Confidential, San Jose, California

Technical Lead (Oracle PL/SQL Developer)

Responsibilities:

• Evangelist of agile/scrum principles and methodology
• Managed project scope to ensure delivery was compliant to scope commitment.
• Tracked and managed product backlog, burndown metrics, velocity, and task breakdown and suggested product recommendations.
• Migration of third-party databases to Oracle databases using Oracle SQL developer
• Enhancement & Maintenance of existing Pl/Sql programs
• Pl/Sql code changes in Packages / Procedure/ function / Triggers etc. with advance Oracle concepts,
• Designing of Sql scripts for code migration to test & production env
• Develop ETL process for heterogeneous data systems like Oracle & Flat Files
• Worked with Oracle Golden Gate integration to implement transactional database to data warehouse.
• Data extraction and massaging to build MIS reports and dashboards
• Enhancement /Upgradation of & Maintenance Oracle Forms & Reports
• Integration Oracle database with JAVA application
• Experience designing and architecting systems as a member of a design team
• Providing database solution for creating logical & physical database design for new project or enhancement
• Coordinate with technical leads, business users, senior business and Client management and project managers.
• Addressed problems through risk management and contingency planning.
• Requirement Analysis and Preparation of estimation.
• Review & Writing of technical specification documentation,
• Working on timeline and task allocation with the team
• Design solution for Enhancements / Maintenance / Bug
• Identifying project problems and taking preventive/corrective action.
• Functional and technical support of application to team.
• Planning for KT sessions of application for new team members.
• Design solution for Enhancements / Maintenance / Bug
• QA/BAT & UAT support and Technical Support to team.,Preparation of UAT scenarios and Test Cases Scripts.

Environment: Oracle PL/SQL, TOAD, Informatica Power Center 9.1,Tableau 10.0, UNIX, Java,Python

Confidential

Technical Consultant (Oracle PL/SQL, Forms & Reports)

Responsibilities:

• Work for New Release and for support work.
• Amendments in the existing programs.
• Modifying, Creating PL/SQL Procedures, Functions, Packages,
• Triggers, and SQL Queries.
• SQL queries, SQL Tuning.
• PL/SQL Tuning; Performance Tuning.
• Data Modeling for RAP
• To communicate with the business analyst.
• To communicate with colleague &
• Support Team for Enhancement.
• To maintain Source code.
• To study the System and Preparation of the technical documents. Writing New Reports
• Creating new forms and modifying existing forms based on Technical Specifications.
• Code and Test Results Review.
• Identifying project problems and taking preventive/corrective action.

Environment: Oracle PL/SQL Developer 2000 Forms 10g, Reports 10g

Confidential

Module Lead (Oracle PL/SQL / Informatica Developer)

Responsibilities:

• Working on New Releases.
• Creating and Amendments in the existing Mapping, Lookups, Mapplets, PLSQL Programs (Packages, Procedure, Function)
• Designing Mappings, Workflow, Session.
• Modifying the UNIX scripts.

Environment: Informatica Power Center 7.11, Oracle 9i, Ms Access 97, UNIX, PL/SQL Developer, ERWIN3.5.2. Hummingbird, SCM, Remedy, Mercury Quality Center, Putty SSH Client

Confidential

Sr. Software Engineer (Oracle PL/SQL, Forms & Reports)

Responsibilities:

• Design Data model for new requirements.
• Modifying & Creating PL/SQL Procedures, Functions, Packages,
• Triggers, and SQL Queries.
• SQL queries, SQL Tuning.
• PL/SQL Tuning & Performance Tuning
• Migration of application Developer 4.5 to Developer 6i
• To communicate with the Business Analyst.
• To communicate with colleague & Support Team for Enhancement.
• To maintain Source code.
• Defect prevention activities.
• To study the System and Preparation the Specifications.
• Implementation of assigned work. Identifying project problems and taking preventive/corrective action

Environment: Oracle 9i, Developer 2000 (Forms 6i, Report 6i), PL/SQL Developer, Toad

Confidential

Software Engineer (Oracle PL/SQL, Forms & Reports)

Responsibilities:

• Implementation of one complete life cycle of ERP and system administration
• Functional Design and Database Design.
• Understanding of Finance / Purchase /Sales/Inventory/HR Modules
• Up gradation of ERP system from 2-tier to 3-tier
• Database Administration (Oracle 8i/9i). Technical Support. ERP User Training
• To perform role as a Management - Users interface.
• Generating MIS reports.
• System analysis, System Design and Database Design.
• After Implementation of Application, Check the application is working fine atclient end
• Discuss each issue with developer and give Technical Support.
• Developing queries to load and check the database.Testing the loaded data and documenting the errors and reporting.

Environment: Oracle 9i, Developer 2000 (Forms 6i, Report 6i), Toad,