Sr. Software Developer
Indiabulls Ventures Ltd.
Skills
SQL, PL/SQL developer in mobile, web and desktop application, Oracle 11g/10gPL/SQL, Informatica, SQL Server2012, SSRS, MySQL 5.1, PostgreSQL 9.3, RDMS, OLAP, OLTP, PL/SQL development, ETL, Talend, Maintaining Reports, Tableau, RequirementGathering, Rest API, Java, Oracle, MySQL, SqlserverDBA Knowledge, OperatingSystem - Mac, Linux, Windows, SoftwareTools - Toad, Workbench, SQLyog, Sql developer, JasperReport, SSIS, Talent, VMWareWorkstation, Eclipse, OtherSkills - CoreJava, Struts, C, C++, ShellScripting, JSP, JQuery, HTML, CSS, ODBC, JDBCconnectivityand issues, Oracle 12c, Control-M, Unix, Jira, PLSQL code, DDL, DML, Cursors, SQL query, dynamic SQL, Query optimization, Exception Handling, Desktop application, Oracle 11g, Postman, TaskTrack, Visual SafeSource, API, SMTP, SMS/EMAIL, XSLT, SQL Server Reporting Services, DB2, Oracle 10g, SQL Server (2012), AS400, sql server, iReport(Jaspersoft3.7.4, database, SQL queries, SQL objects, Oracle database, databases, stored procedures, backups, bash, shell scripts, cron, user management, shell scripting, business logic, PL/SQL, database schema, Data Analysis, Logic
Project history
03/2017
-
06/2019
* Project Details:
Project Name :StockExchange service
Project Duration : Mar 2017 to present
Description : The Indiabulls Group is an Indian conglomerate headquartered in Gurgaon, India. It
was founded by Mr. Sameer Gehlaut (Chairman) in 1999, and operates in sectors spread across housing
finance, real estate & wealth management. The three main independently listed companies of the group are
Indiabulls Housing Finance Limited (IBHFL), Indiabulls Real Estate Limited (IBREL), and Indiabulls
Ventures Limited (IBVL)
Domain :Share marketservice (Mobile app,Desktop application and website)
Technologies :Oracle 11g, Postman, TaskTrack, Visual SafeSource,Tableau, Rest API.
Responsibilities:
- Involved in Enhancement of the product.
- Development andInvolved in new api's implementations.
- Development PLSQL code (Package, Functions, Procedures, Trigger,Collection, etc.) and Enhancement.
- Create table, index, key contain, SQL query and all done activity DDL, DML and DCL.
- Create Cursors, SQL query, dynamic SQL, view Materialized views.
- Developed Email and SMS generate in oracle. (UTL_SMTP, Enqueue-Dequeue)
- Query optimization, Explain Plan, Debug issues and Exception Handling, HTML required (SMS/EMAIL).
- Create Document related to development and Release development.
- Development of the release requirement. Provided support and development till end of the release.
- Development tableau reports and design as per required.
- Providing support to QA team and resolve issue.
- Provide training to new employees and create training documents
- Conducting review meetings within the team.
Project Name :StockExchange service
Project Duration : Mar 2017 to present
Description : The Indiabulls Group is an Indian conglomerate headquartered in Gurgaon, India. It
was founded by Mr. Sameer Gehlaut (Chairman) in 1999, and operates in sectors spread across housing
finance, real estate & wealth management. The three main independently listed companies of the group are
Indiabulls Housing Finance Limited (IBHFL), Indiabulls Real Estate Limited (IBREL), and Indiabulls
Ventures Limited (IBVL)
Domain :Share marketservice (Mobile app,Desktop application and website)
Technologies :Oracle 11g, Postman, TaskTrack, Visual SafeSource,Tableau, Rest API.
Responsibilities:
- Involved in Enhancement of the product.
- Development andInvolved in new api's implementations.
- Development PLSQL code (Package, Functions, Procedures, Trigger,Collection, etc.) and Enhancement.
- Create table, index, key contain, SQL query and all done activity DDL, DML and DCL.
- Create Cursors, SQL query, dynamic SQL, view Materialized views.
- Developed Email and SMS generate in oracle. (UTL_SMTP, Enqueue-Dequeue)
- Query optimization, Explain Plan, Debug issues and Exception Handling, HTML required (SMS/EMAIL).
- Create Document related to development and Release development.
- Development of the release requirement. Provided support and development till end of the release.
- Development tableau reports and design as per required.
- Providing support to QA team and resolve issue.
- Provide training to new employees and create training documents
- Conducting review meetings within the team.
02/2015
-
03/2017
Software Analyst
Qualtech Consultants
* Project Details: 1
Client :Max Life Insuracne
Project Duration : Nov 2016 to Mar 2017
Description : Max Life Insurance, the leading non-bank promoted private life insurer.
Domain : SCOPP Team(Documentation, EmailandSMS)
Technologies :Oracle 11g, XSLT, Bug tracker.
Responsibilities:
- Involved in Enhancement of the product.
- Development PLSQL code (Package, Functions, Procedures, Trigger, Collection, etc.) and Enhancement.
- Create table, index, key contain, SQL query and all done activity DDL, DML and DCL.
- Create Cursors, SQL query, dynamic SQL, view Materialized views.
- Query optimization, Explain Plan, Debug issues and Exception Handling.
- Create Document related to development and Release development.
- Resolve all ticket generated against to the development.
Client :Max Life Insuracne
Project Duration : Nov 2016 to Mar 2017
Description : Max Life Insurance, the leading non-bank promoted private life insurer.
Domain : SCOPP Team(Documentation, EmailandSMS)
Technologies :Oracle 11g, XSLT, Bug tracker.
Responsibilities:
- Involved in Enhancement of the product.
- Development PLSQL code (Package, Functions, Procedures, Trigger, Collection, etc.) and Enhancement.
- Create table, index, key contain, SQL query and all done activity DDL, DML and DCL.
- Create Cursors, SQL query, dynamic SQL, view Materialized views.
- Query optimization, Explain Plan, Debug issues and Exception Handling.
- Create Document related to development and Release development.
- Resolve all ticket generated against to the development.
02/2014
-
01/2015
DBA and developer
Getware Technologies
* Project Details:
Client :PHED
Project Duration : Nov 2016 to Mar 2017
Description : Getware technology provide software solution and software services.
Domain : Jaipur Water Supply Billing System
Technologies : Oracle 10g,PostgreSQL 9.3, Sql server (2008)
Responsibilities:
-Development and enhancement PLSQL code (Package, Functions, Procedures, Trigger, Collection, etc.).
- Create table, index, key contain, SQL query and all done activity DDL, DML and DCL.
- Create Cursors, SQL query, dynamic SQL, view Materialized views.
- Query optimization, Explain Plan, Debug issues and Exception Handling.
- Installing Oracle database and create new database for different clients.
- Export/Import of oracle databases.
- Create Document related to development and Release development.
-On call support 24x7.
Client :PHED
Project Duration : Nov 2016 to Mar 2017
Description : Getware technology provide software solution and software services.
Domain : Jaipur Water Supply Billing System
Technologies : Oracle 10g,PostgreSQL 9.3, Sql server (2008)
Responsibilities:
-Development and enhancement PLSQL code (Package, Functions, Procedures, Trigger, Collection, etc.).
- Create table, index, key contain, SQL query and all done activity DDL, DML and DCL.
- Create Cursors, SQL query, dynamic SQL, view Materialized views.
- Query optimization, Explain Plan, Debug issues and Exception Handling.
- Installing Oracle database and create new database for different clients.
- Export/Import of oracle databases.
- Create Document related to development and Release development.
-On call support 24x7.
07/2012
-
01/2014
Jr. DBA
Data Infocom Pvt. Ltd.
* Project Details: 1
Client :JVVNL
Project Duration : Jul 2012 to Jan 2014
Description : Spot Billing System is defined to replace the existing manual process of capturing the
reading generate the billing for residential. Generating Electricity Bills for consumers and generating
outstanding reports for consumers to ensure that there is no pending bill for consumers and generating
billing for customers for which data is collected using base billing process
Domain : Spot and BaseBillingSystem (Finance project)
Technologies : Oracle 10g, PostgreSQL 9.3.
Responsibilities:
- Maintaining and monitoring Databases and generating customized reports on daily basis.
- Writing new views, trigger, stored procedures on requirement basis and reviewing pre-written ones for
performance and efficiency.
- Generation of daily-customized in ever changing format reports as per requirements from Govt. Officials
on a daily basis.
- Monitoring and Optimization of already written queries on daily basis, optimizing them for efficiency and
speed.
- Responsible for scheduling, automating and monitoring of backups using bash shell scripts and cron jobs
and verifying the backups from time to time by restoring them and testing them.
- Creation of critical sql queries (involving complex joints, initialization).
- Responsible for creation of new databases, user management, sql critical query, shell scripting in Linux.
- Filtering out wrongly generated billing data by testing billing data against business logic, creating a
detailed report on all such data and finally correcting such data to ensure integrity of the data in the
database.
* Project Details: 2
Client :PSEB (Punjab State Electricity Board)
Project Duration : Jul 2012 to Jan 2014
Description : The project involves maintain and optimizing the databases of Punjab State Electricity
Board, looking after the entire state-wide data of electricity consumers.
Domain : Electricity Board Database Support
Technologies : Oracle 10g, Sql server (2008).
Responsibilities:
- Checking the consistency of data in the database immediately as per requirement, by using self-made
procedures, functions only.
- Re-writing the existing PL/SQL functions as per the new business logics provided by the government.
- Constantly monitor and improve the queries to ensure smooth functioning of database-dependent
software.
- Changing the database schema as per new software requirements on a monthly basis.
- Generation of daily-customized in ever changing format reports as per requirements from Govt. Officials
on a daily basis.
Client :JVVNL
Project Duration : Jul 2012 to Jan 2014
Description : Spot Billing System is defined to replace the existing manual process of capturing the
reading generate the billing for residential. Generating Electricity Bills for consumers and generating
outstanding reports for consumers to ensure that there is no pending bill for consumers and generating
billing for customers for which data is collected using base billing process
Domain : Spot and BaseBillingSystem (Finance project)
Technologies : Oracle 10g, PostgreSQL 9.3.
Responsibilities:
- Maintaining and monitoring Databases and generating customized reports on daily basis.
- Writing new views, trigger, stored procedures on requirement basis and reviewing pre-written ones for
performance and efficiency.
- Generation of daily-customized in ever changing format reports as per requirements from Govt. Officials
on a daily basis.
- Monitoring and Optimization of already written queries on daily basis, optimizing them for efficiency and
speed.
- Responsible for scheduling, automating and monitoring of backups using bash shell scripts and cron jobs
and verifying the backups from time to time by restoring them and testing them.
- Creation of critical sql queries (involving complex joints, initialization).
- Responsible for creation of new databases, user management, sql critical query, shell scripting in Linux.
- Filtering out wrongly generated billing data by testing billing data against business logic, creating a
detailed report on all such data and finally correcting such data to ensure integrity of the data in the
database.
* Project Details: 2
Client :PSEB (Punjab State Electricity Board)
Project Duration : Jul 2012 to Jan 2014
Description : The project involves maintain and optimizing the databases of Punjab State Electricity
Board, looking after the entire state-wide data of electricity consumers.
Domain : Electricity Board Database Support
Technologies : Oracle 10g, Sql server (2008).
Responsibilities:
- Checking the consistency of data in the database immediately as per requirement, by using self-made
procedures, functions only.
- Re-writing the existing PL/SQL functions as per the new business logics provided by the government.
- Constantly monitor and improve the queries to ensure smooth functioning of database-dependent
software.
- Changing the database schema as per new software requirements on a monthly basis.
- Generation of daily-customized in ever changing format reports as per requirements from Govt. Officials
on a daily basis.
Local Availability
Only available in these countries:
India
