English
Parag
Senior Oracle Developer
Pune,MH
Summary
- Dynamic Consultant with 10 years' track record of providing exceptional assistance in client and internal practice development projects. Highly-skilled in conducting client interviews, observing data and developing high impact recommendations. Strong self-motivator with an exceptional work ethic.
- Versatile team player with good analytical, problem solving, communication and inter-personal skills to manage and interact with individuals at all levels. Proven track record of managing and delivering projects following complete SDLC.Managed a small team of developers for a duration of 2 years
- Strong experience in systems Analysis, design and development of complex software systems in Banking, Healthcare, Manufacturing sectors.
- Strong Experience in front-end and back-end development using Forms, Reports 12c/10g/9i/6i, XML Publisher, Workflow Builder, SQL, PL/SQL and Oracle Designer10g for Data modeling.
- Well versed in developing various database objects like Packages, Stored Procedures, Functions, Triggers, and Tables, Indexes, Constraints, Tables, Views, Indexes, Constraints, Sequence, Synonyms, Database link, Views, materialized views,External Tables, Bulk collect, Analytic functions, rank ,DBMS JOB, DBMS SCHEDULER, DBMS ALERT, DBMS SQL, DBMS OUTPUT,Materialized Views in Oracle 12c/11g/10g /9i database.
- Skilled in Application development using Oracle Forms and Reports with knowledge in master-detail blocks, forms triggers, system variables, multiple form applications, menus, alerts and LOV's.
- Good knowledge on Upgrading Oracle Forms Reports.
- Experience in developing Data Conversions/Data Migration ETL from Legacy System of various sources flat files, excel, Oracle, Non-Oracle to Oracle system Using SQL Loader, UTL FILE.
- Proficient in Application and SQL statement tuning using optimizer hints, Explain plan, SQL trace, Auto trace, Parallelism and Partitioning etc.
- Good working and conceptual knowledge of Java, JSP, web services, Pro C, XML and HTML.
- Having experience in using oracle in built packages .
- Well versed with version control tools like PVCS and tortoise SVN etc.
- Experience as MS SQL Server Developer 2012
- Expert in writing parameterized queries for generating tabular reports, formatting report layout, sub-reports using global variables, subtotals, expressions, functions, sorting the data, defining data sources for the reports.
- Experience in parsing of XML's using ORDS.
- Documentation of projects and databases.
- Experience in performance tuning, normalization and denormalization, partitioning of data and indexing of partitioned tables.
- Clear communication and documentation of technical specifications.
- Quick learner of new technologies. Strong interpersonal and communication skills.
- Expert Skills in time management, prioritizing tasks.
Overview
3
3
Languages
3
3
Certifications
6
6
years of post-secondary education
10
10
years of professional experience
Work History
Associate Consultant
Atos-Syntel Europe Ltd
Glasgow , Scotland
2016.09 - Current
- Leveraged on-site observation and personal interviews to identify team and individual strengths.
- Helped team of 6 consultants optimize efficiency of current systems by conducting training sessions.
- Performed code review of all procedures which were migrated from 10g version to latest 12c code
- Was involved in performance tuning of migrated procedures and database object to discard some of the legacy code causing issues in 12c environment
- Was responsible to modify the migrated forms and reports to some accommodate some of the known issues arising as a result of migration from old to new version
- Was involved in trouble shooting some of the unexpected issues arising from application migration to newer version of AIX platform.
- Undertook the responsibility of co ordination with the oracle SR team to sort out uncommon migration issues.
- Was responsible for co ordination with the project DBAs to ensure smooth handshake of frontend and backend migration.
- Was involved in estimation of defect resolving timelines to ensure proper project delivery within stipulated timelines.
- Was a pioneer member in migrating some of the oracle reports in completely new format of BI publisher.
- Was involved in implementing new interface packages required for various application (Adobe reader/excel etc) integration with oracle forms.
- Attended daily Code Review and defect containment meetings with senior analysts.
- Helped the team members solving migration related issues.
Senior Software Engineer
Atos-Syntel Europe Ltd
Pune , Maharashtra
2015.08 - 2016.07
- Built outstanding and dynamic team of software engineers and developers which significantly boosted overall success of organization.
- Was a part of code review team formed for monitoring all the database objects which were migrated from Sybase to Oracle
- Was involved in creating a proper guideline to avoid all the known issues which occurs between database migration from Sybase to oracle.
- Was involved in mentoring the peers who were experiencing the challenges of migration for very first time.
- Was involved in modifying the database object to ensure the legacy functionality remain unaltered by understanding the proper business requirement.
- Created/Altered tables as per client’s requirement
- Performed several DBA related activities like providing Grants and performance tunings.
- Worked closely with other business analysts, development teams and infrastructure specialists to deliver high availability solutions for mission-critical applications.
Senior Software Engineer
Atos-Syntel Europe Ltd
Pune , Maharashtra
2015.02 - 2015.07
- Collaborated with cross-functional development team members to analyze potential system solutions based on evolving client requirements.
- Suggested improvements to team and project workflow.
- Improved system performance by making proactive adjustments and resolving bugs.
- Checked client code for bugs and weaknesses using SQL queries Sub queries and Join condition troubleshooting methods.
- Created Shell scripts on Unix platform which invokes sql loader to load data from flat files to the main tables using pl/sql procedures
Oracle Developer
KPIT (Cummins)
Pune , Maharashtra
2014.09 - 2015.02
- Revised, modularized and updated old code bases to modern development standards, reducing operating costs and improving functionality.
- Wrote complex package in the pl/sql to handle user management transactions and their roles according to functionality of OIM (It was a interface package for local application and oracle OIM ).
- Extensively used TOAD for database access and PL/SQL Development and SQL tuning.
- Used PRAGMA AUTONOMUOS TRANSACTION to avoid mutating problem in database triggers.
- Worked extensively on Exception handling to error handling and tracking.
- Used Optimizer Hints to tune the Sql Queries.
Software Engineer
AurionPro Ltd.
Pune , Maharashtra
2013.03 - 2015.08
- Coordinated with hardware and system engineering leads to gather and develop system requirements.
- Researched, designed and implemented scalable applications for data extraction, analysis, retrieval and indexing.
- Wrote complex stored procedures in the sql server database to accept data from flat files and place the data in proper fact and dimension tables.
- Discussed project progress with customers, collected feedback on different stages and directly addressed concerns.
- Performed regression and system-level testing to verify software quality and function prior to release.
- Involved in various stages of SDLC like low-level design, Coding, Testing.
Software Developer
Eastern Software System
Noida , New Delhi
2011.09 - 2013.02
- Designed intuitive graphical user interfaces using knowledge of Oracle D2K and database design to improve user experience.
- Developed and customized several Oracle Forms and Reports using Forms/Reports builder, Crystal Reports and XML publisher as per client specifications.
- Worked on the XML reports like Pick slip report, Packing slip report, Sales Order Acknowledgement report, Invoice reports, quotation reports, Purchase Order reports and Discoverer reports to make sure they are upgraded from 9i to 10g and displaying the same output as in 9i
- Performance tuning of existing Oracle forms as well as newly created Oracle forms using different built-in as well as User-defined functions and procedures.
- Create Database Objects like Stored Procedures, Views, Triggers and functions.
- Create PL/SQL tables and global variables and also using IN and OUT parameters with TYPE, ROWTYPE, PL/SQL tables and PL/SQL records
Trainee Software Developer
Bakshi mark Pvt. Ltd.
Delhi , New Delhi
2010.12 - 2011.03
- Wrote Sub programs (packages, procedures and functions, PL/SQL Library) using PL/SQL.
- Gathered extensive knowledge in application and DB performance tuning.
- Developed new forms and generating reports.
- Was Involved in creating data modeling and entity relationship diagrams
Project Intern
Apsis technical Solution (College Final Year Project)
Bangalore , Karnataka
2008.02 - 2008.04
- This project was about developing a working model of an automated operation theatre which was supposed to be working on microprocessor programming.
- Wrote assembly language programming ( Microprocessors (8085, 8086) ) for the microcontrollers ( Microcontrollers (8051) , MATLAB ) to operate the motors incorporated in project
- Created a working model of the automated operation theatre.
Education
Bachelor of Engineering - Medical Electronics
Sri Krishna Institute Of Technology
Vishveshwariah Technical Uni,Bangalore,Karnataka 2004.03 - 2008.04
HSC (12th) - Science Education
RRS College
Bihar Intermediate Education Council,Patna,Bihar 2001.03 - 2003.04
SSC (10th) - Primary Education
Vidya Vihar Residential School
C.B.S. E, Purnia, Bihar 2000.01 - 2000.01
Skills
Oracle Database
Languages
Hindi
Multiple Regional Languages
Certification
Oracle Certified Associate.
Interests
Photography/Graphic designing
Working on Software like photoshop and Lightroom
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Personal Information
Name: Parag (Yes, I have a single name. No surname on official documents)
Father’s Name: Mr. Dilip kumar
Nationality: Indian
Marital Status: Married
Permanent address: Lavanya enterprises, near hotel Harsha, Bhatta bazar, Purnia, Bihar-854301
Quote
There is a powerful driving force inside every human being that, once unleashed, can make any vision, dream, or desire a reality.
Tony Robbins
Timeline
Associate Consultant
Atos-Syntel Europe Ltd
2016.09 - Current
Senior Software Engineer
Atos-Syntel Europe Ltd
2015.08 - 2016.07
Senior Software Engineer
Atos-Syntel Europe Ltd
2015.02 - 2015.07
Oracle Developer
KPIT (Cummins)
2014.09 - 2015.02
Software Engineer
AurionPro Ltd.
2013.03 - 2015.08
Software Developer
Eastern Software System
2011.09 - 2013.02
Trainee Software Developer
Bakshi mark Pvt. Ltd.
2010.12 - 2011.03
Project Intern
Apsis technical Solution (College Final Year Project)
2008.02 - 2008.04
Bachelor of Engineering - Medical Electronics
Sri Krishna Institute Of Technology
2004.03 - 2008.04
HSC (12th) - Science Education
RRS College
2001.03 - 2003.04
SSC (10th) - Primary Education
Vidya Vihar Residential School
2000.01 - 2000.01
Oracle Cloud Infrastructure Developer 2020 Certified Associate
Oracle Autonomous Database Cloud 2019 Certified Specialist
Oracle Certified Associate.