Profile cover photo
You're now following
Error following user.
This user does not allow users to follow them.
You are already following this user.
Your membership plan only allows 0 follows. Upgrade here.
Successfully unfollowed
Error unfollowing user.
You have successfully recommended
Error recommending user.
Something went wrong. Please refresh the page and try again.
Email successfully verified.
User Avatar
$4 USD / hour
Flag of INDIA
panchkula, india
$4 USD / hour
It's currently 1:45 PM here
Joined January 5, 2013
0 Recommendations

Ajay T.

@tuliajay

5.0 (1 review)
1.0
1.0
0%
0%
$4 USD / hour
Flag of INDIA
panchkula, india
$4 USD / hour
100%
Jobs Completed
100%
On Budget
100%
On Time
N/A
Repeat Hire Rate

Web & Database Developer

I am Ajay Tuli, MS in Computer Science and have over 10 years of working experience as Programmer / Developer. I have worked in India and US as Computer Programmer. Now I am working as Freelancer. My last employer was IBM India. I have expertise in Technologies like PHP, HTML5, Word Press, Magento, MySQL , Oracle SQL, PL/SQL, Oracle Forms & Reports, Data Modelling using ErWin etc.

Contact Ajay T. about your job

Log in to discuss any details over chat.

Portfolio

3014429
3014418
3014429
3014418

Reviews

Changes saved
Showing 1 - 1 out of 1 reviews
Filter reviews by:
5.0
₹2,500.00 INR
aJAY did a tremendous job with this project. I will certain hire again for future projects. ks Thanks
PHP
Magento
Oracle
MySQL
+1 more
User Avatar
Flag of Pratiksha S.
@pratikshapkl
7 years ago

Experience

Software Engineer

Go Tech Way IT Solutions
Apr 2011 - Present
Go Tech Way IT Solutions is an IT Solution Providing company. My role and responsibilities are as follows : - i. Web and Database Design and Development. ii. Guiding team in different development and testing phases. iii. Interaction with client.

Sr. Application Developer

IBM India Pvt Ltd
Jun 2009 - Mar 2011 (1 year, 9 months)
Client : AKBANK, Turkey (Feb 2010 – March 2011) Project : Application Factory & Credit Factory Position : Team Lead / Sr. Application Developer Technologies : Oracle 10g, PL/SQL, TOAD, Unix Shell Scripting Project Summary : AK Bank is a leading bank in Turkey. Application Factory application starts when a customer approaches bank for different products like account opening, loans, Credit Card, Debit Card etc. Customer's personal information along with product required specific information is fed into this Application Factory application. All the required documents like Identity Proof etc. are scanned and a single automatic customer application is generated and then automatically sent for verification to the Branch and Central Office. Verification of customer submitted documents are done in Credit Factory. After approval, the required products are granted to the customer. A complete customer data is maintained through these application. Responsibilities : • Creation of Data Models both Logical and Physical. • Conversion of Physical Data Model into Database Schema. • Creation / Maintenance of Schema and Tables. • Import and Export of data. • Development of different database objects like Packages, Procedures, Functions, Triggers, Views, Materialized Views etc using PL/SQL. • Worked on performance and tuning of different SQL Queries and PL/SQL programs. • Involved in Unit testing of all programs. • Responsible for providing support during application development, SIT. Client : General Motors, USA (June 2009 – Jan 2010) Project : QIS2 Vehicle Position : Sr. Application Developer Technologies : Oracle 10g, PL/SQL, TOAD, Erwin, Unix Shell Scripting Project Summary : IBM is providing consulting services (design, development, deployment and support) to GM in project QIS2 Vehicle to expand the system to include Vehicle Control Modules. QIS2 stands for Quality Information System v2. QIS2 is a web based reporting system for GM. This system will feed additional and updated data feeds from various other sources. This project also consists of the deployment to all remaining regions not currently in the system. The QIS2 system will not only provide additional regions with the ability to improve GM Powertrain quality, but it will also include Vehicle modules (non-Powertrain) that can be used to improve Vehicle quality. This software provide a common global analysis and reporting system for warranty claims, vehicles, dealers and other early warning quality data. This will reduce GM’s warranty costs and claims frequency while continuing to improve GM’s product quality. Responsibilities : • Creation / Updation of Packages, Procedures, Functions, Views, Materialized Views etc using PL/SQL. • Creation / Maintenance of Schema and Tables. • Import and Export of data. • Worked on performance and tuning of different SQL Queries and PL/SQL programs. • Maintaining Data Models using Erwin • Creation / modification of Unix Shell Scripts. • Involved in Unit testing of all programs. • Responsible for providing support for deployment.

Sr. Oracle Developer

Transcend Global Inc., USA
Dec 2006 - Feb 2009 (2 years, 2 months)
Client : Duty Free Americas, US (September 2008 - December2008) Project : Retail Management System Position : Sr. Oracle Developer Technologies: Oracle 10g, PL/SQL, SQL Loader, TOAD, Windows XP, Unix Shell Scripting Project Summary : Duty Free Americas has retail stores in America, particularly in Boarder Areas and at International Airports. They have interconnected their stores and warehouses through retail management system. Retail Management System is used for invoicing, stock management at stores and warehouses, stock transfer from warehouse to different stores and from one location to another. It is also used to keep track of different orders, goods delivery etc. Responsibilities : • Creation of different interfaces between their existing applications using PL/SQL. • Created Stored Procedures, Triggers, Functions, Views and Packages using PL/SQL. • Worked on performance and tuning of different SQL Queries and PL/SQL programs. • Developed PL/SQL Scripts to write data into flat files and then loaded data from flat files to custom tables through SQL Loader scripts. • Involved in Unit testing of all programs. • Developed Shell scripts for Scheduling and initiating other PL/SQL programs. Client : CIGNA Dental Insurance, US (April 2008 – August 2008) Project : Dental Insurance Position : Sr. Oracle Developer Technologies : Oracle 10g, PL/SQL, Oracle Forms & Reports., SQL Developer, Windows XP, Unix Shell Scripting Project Summary : Cigna Dental is one of the leading insurance companies in US. It provides dental and Health insurances to its customers. I worked on Dental Insurance project. Dental Insurance Software was used to keep record of their past and present customers, their opted insurance coverage, insurance premiums, claims, etc. Responsibilities : • Development of different Forms and Reports using Developer 2000. • Development of different Stored Procedures, Triggers, Functions, Views and Packages using PL/SQL. • Performance tuning of SQL Queries and PL/SQL programs. • Involved in Unit testing of Forms, Reports and PL/SQL programs. • Developed Shell scripts for Scheduling and initiating other PL/SQL programs. Client : FedEx, Newyork, US (September 2007 to March 2008) Project : FedEx Trade Network Position : Sr. Oracle Developer Technologies : Oracle 10g, PL/SQL, Oracle Forms & Reports., TOAD, Unix Shell Scripting Project Summary : FedEx provides services like customs brokerage, international freight forwarding, export documentation, distribution, cargo insurance, and eCommerce and trade facilitation solutions. Trade Network application is used to manage day to day trade business and provide services to their customers. It also keeps track of payment made and due from business customers, tracking of goods etc. Responsibilities : • Development and modification of forms and reports using Forms and Reports 10g. • Created Complex Stored Procedures, Triggers, Functions and packages using PL/SQL • Developed SQL Loader scripts to load data in the custom tables and perform ETL processes. • Analyzed queries using Explain Plan utility to obtain the execution process. Optimized the queries by modifying the data access methods, Index strategies, Join types and operations and providing hints. • Involved in Unit testing of forms and reports developed by other developers. • Developed Shell scripts for Scheduling and initiating other PLSQL programs. Client : Allstate Insurance, US (January 2007 – August 2007) Project : NextGen Release 2 Position : Sr. Oracle Developer Technologies: Oracle 10g, PL/SQL, SQL Loader, TOAD, Windows XP, Unix Shell Scripting Project Summary : Allstate is one of the largest insurance companies based in Illinois. Allstate provides different kinds of insurance services like Health insurance, Auto insurance, Property insurance etc. I developed scripts f or data migration of their software NextGen, from Release 1 to Release 2 and to clone seed data upto 20 million records. This data was used by the QA teams to test the application, and the DBA team to test the performance of servers. Developed Data Migration Validation Package for QA team. Also developed some reports using oracle reports required by QA team. Responsibilities : • Created scripts using SQL and PL/SQL to migrate data from Rel. 1 to Rel. 2. • Worked with control files for SQL loader to load flat data files into Oracle tables. • Created scripts using SQL and PL/SQL to generate bulk data for testing team to test the performance of the application and the same data was used by DBA team to test the server performance. Scripts were also written to migrate data from Release 1 database to Release 2 database. • Involved in performance tuning and query optimization. • Provided production support for existing applications. • Development of certain reports for QA team to validate their tests.

Education

M.Sc. IT

Punjab Technical University, India 1999 - 2001
(2 years)

Contact Ajay T. about your job

Log in to discuss any details over chat.

Verifications

Preferred Freelancer
Identity Verified
Payment Verified
Phone Verified
Email Verified
Facebook Connected

Browse Similar Showcases

Previous User Next User
Invite sent successfully!
Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.