Oracle pl/sql developer
Resume:
Ritul Vakharia, B.E.
EDUCATION
Bachelors in Electronics & Communication Engineering, (GTU) India, 2009
POSITION
Manager, Reports Development, Theradex, Mar’20 - Current
●Involved in development of database objects, developing code and validating programs.
●Performed various activities like creating, debugging and modifying database objects and User defined functions and finely tuned them for performance.
●lead database team and worked closely with DBAs.
●Developed and customized existing reports as per specific requirements using Oracle Reports Builder 10g.
●Involved in various design discussions and requirement discussions with the end users.
●Involved in designing star schema data warehouse.
●Involved in Data Posting.
●Created ETL Process control architecture and integrated the same architecture with BI tool Izenda.
●Worked closely with all the application owners to know about the functionality of these applications in a very detail level to understand the data models being used by them.
●Studied various Planning applications to understand the source data for FDW.
●Involved in Tuning Database & Application performance using Explain Plan.
●Involved in the Daily maintenance of the database that involved monitoring the daily run of the scripts as well as troubleshooting in the event of any errors in the entire process.
●Developed and maintained reports and dashboards, using IZENDA BI platform.
Environment: Oracle Database 10g, 11g, Windows 7, UNIX, SQL Developer, SQL, PLSQL, Izenda
Oracle Programmer, Connexus Technology, Jul’16 – Feb’20
Connexus is a consulting company and software solution provider. They provide solution to their client using different technology. I have been working for Theradex to develop web reporting application which helps customers to analyze real time data.
Responsibilities:
●Involved in development of database objects, developing code and validating programs.
●Performed various activities like creating, debugging and modifying data base objects and User defined functions and finely tuned them for performance.
●Developed and customized existing reports as per specific requirements using Oracle Reports Builder 10g.
●Involved in various design discussions and requirement discussions with the end users.
●Involved in designing star schema data warehouse.
●Involved in Data Posting.
●Created ETL Process control architecture and integrated the same architecture with BI tool Izenda.
●Worked closely with all the application owners to know about the functionality of these applications in a very detail level to understand the data models being used by them.
●Studied various Planning applications to understand the source data for FDW.
●Involved in Tuning Database & Application performance using Explain Plan.
●Involved in the Daily maintenance of the database that involved monitoring the daily run of the scripts as well as troubleshooting in the event of any errors in the entire process.
Environment: Oracle Database 10g, 11g, Windows 7, UNIX, SQL Developer, SQL, PLSQL, Izenda
Oracle Developer, Fusion Plus Solutions, Inc., Nov’15 – Jul’16
Responsibilities:
●Involved in all phases of software development including gathering requirements, creating specifications, development of database objects, developing code and validating programs.
●Performed various activities like creating, debugging and modifying data base objects and User defined functions and finely tuned them for performance.
●Developed daily, weekly, monthly CAFM Reports and scheduled using Cron Jobs.
●Developed and customized existing reports as per client specific requirements using Oracle Reports Builder 10g.
●Involved in various design discussions and requirement discussions with the end users.
●Involved in identifying all the Data Models for all the applications.
●Created ETL Process control architecture and integrated the same architecture with reporting applications.
●Worked closely with all the application owners to know about the functionality of these applications in a very detail level to understand the data models being used by them.
●Studied various Planning applications to understand the source data for FDW.
●Created ETL Mapping specifications using functional specifications.
●Created Technical Specifications document based on functional specifications
●Managed the Web servers and Data base servers of Production system, Backup DR and Development system.
●Involved in the migration of data from Archibus to Tririga.
●Golden Gate troubleshooting using Log miner.
●Worked with Golden Gate to replicate data between tables
●Involved in fixing bugs within Packages and Stored Procedures.
●Involved in Tuning Database & Application performance using Explain Plan.
●Involved in the Daily maintenance of the database that involved monitoring the daily run of the scripts as well as troubleshooting in the event of any errors in the entire process.
●Performed Unit Testing and Integration Testing of the Application. Involved in preparing documentation and user support documents.
●Used Perforce for Code check in, GUTS and Buganizer for ticketing system.
Environment: Oracle Database 10g, Windows 7, UNIX, SQL Developer, XML, SQL, PLSQL, Unix Scripting, Perforce, WinSCP, Putty.
System Administrator, URTECHMATE INC., Oct'14- Nov’15
Responsibilities:
●Monitored system operation to detect potential problems.
●Investigate system component suitability for specified purposes and make recommendations regarding component use
●Performed ongoing hardware and software maintenance operations, including installing or upgrading hardware or software
●Configured servers to meet functional specifications
●Defined and analyzed objectives, scopes, issues or organizational impact of information systems
●Developed system engineering, software engineering, system integration or distributed system architectures
●Documented design specifications, installation instructions and other system related information.
●Verified stability, interoperability, portability, security or scalability of system architecture.
●Evaluated current or emerging technologies to consider factors such as cost, portability, compatibility and usability.
●Provided technical guidance or support for the development or troubleshooting of systems.
●Identified system data, hardware or software components required to meet user needs.
●Provided guidelines for implementing secure systems to customers or installation teams.
●Designed and conducted hardware or software tests.
●Established functional or system standards to ensure operational requirements, quality requirements.
●Evaluated existing systems to determine effectiveness and suggested changes
●Researched, tested and verified proper functioning of software patches and fixes
●Completed model and stimulations using manual or automated tools to analyze or predict system performance under different operating conditions
●Trained system users in system operation or maintenance
●Performed security analyses of developed or packaged software components
Assistant Professor, K J Faculty of Engineering and technology, July ‘10 - Mar ‘12
Professor
Responsibilities:
●Taking lectures to different grades of students in Oracle Database.
●Taking lectures to different grades of students in Micro Processor - 8085.
●Responsible to examine the papers and set the examination papers in subjects like Digital Electronics and Micro Processor – 8085
Jr. Engineer, SAHJANAND LASER PVT LTD, Feb’10 – May’10
Sahjanand Laser Pvt Ltd manufactures and markets most advance laser cutting systems in India.
It is the leader in India in the field of CO2 laser technology.
Responsibilities:
●Development of the application Voltage current data Logger in Assembly Language.
●It records different voltage and current at different time interval using microcontroller chips.
●Used SPI interfacing to display result into PC.
●Involved in Review of the Project.
●Involved in documentation of the Project using MS Office tools.
●Involved in QA testing of the Project manually.
Trainee Engineer, E-Infochip Pvt Ltd, Gujarat, India, Oct’09 – Feb’10
Engaged in the concept, design, development and maintenance of different application using different programming language and helped team to deliver project on time.
Responsibilities:
●Involved in Infrared 4 channel Remote Control application. Responsible of transmitter and its functionality and testing.
●Involved in Seven Segment Display Project using VLSI Programming language. Developed in VHDL and run on the hardware.
●Involved in software testing and design of the Zero crossing detector. That detects the transition of the signal from positive and negative.
●Involved in documentation of the projects using MS Office tools.
●Involved in presentation of Project
●Involved in QA testing manually.
SKILLS/CERTIFICATIONS
N/A
AWARDS
N/A
.
LANGUAGES
●Gujarati
●Hindi
●English
AFFILIATIONS
N/A
PUBLICATIONS/PRESENTATIONS
N/A
Signature Date
Contact this candidate