Ahmed is available for hire

Ahmed Sheraz

Verified Expert in Engineering

Oracle Developer

Lahore City, Punjab, Pakistan

Toptal member since June 18, 2020

Expertise

SQL Database Excel Macros Excel Development VBA Oracle Development Microsoft Access Development C#VB.NET ETL PostgreSQL MySQL

Bio

Ahmed has seven years of experience in Oracle ERP development. He has strong domain knowledge of textile industries and the products he has worked on are used by 5,000+ users. He has extensive knowledge of Oracle Forms and Reports using PL/SQL and has also worked on other databases like MS SQL Server, MySQL, and PostgreSQL.

Portfolio

Azgard 9

Oracle SQL, Oracle Forms, Oracle Reports, Oracle Application Express (APEX)...

Azgard 9

Oracle Forms & Reports, Oracle 11g, Oracle Database, Oracle PL/SQL, Databases...

Style Textile

Oracle 10g, Oracle Database, Oracle Reports, Oracle Forms, Oracle, ETL...

Experience

Oracle PL/SQL - 7 years
Oracle Reports - 7 years
Oracle Forms - 7 years
Oracle SQL - 7 years
Microsoft SQL Server - 3 years
Excel VBA - 3 years
VB.NET WinForms - 2 years
PostgreSQL - 1 year

Availability

Full-time

Preferred Environment

Visual Studio, MySQL, Microsoft SQL Server, PL/SQL, SQL, Microsoft Excel

The most amazing...

...work was a volunteer project that I did for my nearby Mosque. It was a funds collection tracking ERP software built in Oracle Forms and Reports.

Work Experience

Senior Oracle Developer

2020 - PRESENT

Azgard 9

Handled software development with Oracle PL/SQL, Oracle Forms, and Reports.
Designed the WIP Module for Denim Production ERP Software.
Designed automated stock consumption on the basis of the FIFO (First in First out) method.
Led an Oracle development team in the build of the Yarn consumption module.

Technologies: Oracle SQL, Oracle Forms, Oracle Reports, Oracle Application Express (APEX), Database Development, Databases, Stored Procedure, Microsoft Excel, Visual Basic for Applications (VBA)

Oracle Developer

2016 - 2020

Azgard 9

Handled software development with Oracle Forms and Reports.
Designed the inspection and packing module for Denim Rolls barcode stickers.
Developed production and operators wise efficiency reports using Oracle Report Builder.
Supported an ETL process taking data from a flat Excel spreadsheet into a relational database structure.

Technologies: Oracle Forms & Reports, Oracle 11g, Oracle Database, Oracle PL/SQL, Databases, Database Development, Stored Procedure, Microsoft Excel, Visual Basic for Applications (VBA)

Oracle Developer

2014 - 2016

Style Textile

Handled software development with Oracle Forms and Reports.
Migrated SQL Server to Oracle 10g database to integrate an old inventory system to existing ERP software.
Created recursive functions to fetch parent records details.
Supported the day-to-day end-user queries using Oracle tools.

Technologies: Oracle 10g, Oracle Database, Oracle Reports, Oracle Forms, Oracle, ETL, Database Development, Databases, Stored Procedure, Microsoft Excel, Visual Basic for Applications (VBA)

Trainee Oracle Developer

2013 - 2014

Style Textile

Went through the production process of the textile fleece knitwear system.
Understood the existing developed ERP system and documented various forms and reports.
Assisted senior developers by completing tasks assigned to me.
Developed forms and reports for a gate pass system and wrote database procedures.

Technologies: SQL, PL/SQL, Oracle Forms, Oracle Reports, Microsoft Access, Database Development, Databases, Stored Procedure

Experience

Denim Management System (Azgard Nine)

DBUMS is a denim production ERP software that includes modules like ball warping, rope dyeing, re-beaming, sizing, weaving, finishing, inspection and packing, and warehouse dispatch.

The purpose of this software was to ease the development process by taking an analysis of high-level reports generating on the daily entry.

ERP (Style Textile)

A knitwear ERP system contains processes of fabric production starting from yarn, knitting, ecru fabric, dyeing process i.e. inverter, finish fabric, cutting, stitching to packing.

Thousands of data entry is done on a daily basis that helps to provide end to end fabric tracking reports. It also contains a separate report section that contains hundreds of different reports for all modules

Erp (Rainbow Grammar School)

A school management system includes modules like attendance, payroll, accounts and fee collection modules.

Barcode scanners are used to scan employee and student cards to keep records of daily attendances.

Education

2006 - 2011

Bachelor of Science Degree with Honors in Computer Science

University Of Central Punjab - Lahore Pakistan

Certifications

OCTOBER 2019 - PRESENT

SEO (Search Engine Optimization) Certificate

DigiSkills Training Program Pakistan

OCTOBER 2019 - PRESENT

Freelancing Certificate

DigiSkills Training Program Pakistan

Skills

Tools

Oracle Reports, Oracle Forms, Microsoft Access, Microsoft Excel, Visual Studio, Oracle Application Express (APEX), C#.NET WinForms

Languages

SQL, Excel VBA, Stored Procedure, Visual Basic for Applications (VBA), T-SQL (Transact-SQL)

Storage

Oracle SQL, Databases, PL/SQL, Microsoft SQL Server, Oracle PL/SQL, Oracle 11g, Oracle 10g, SQLite, PostgreSQL, MySQL

Paradigms

Database Development, ETL

Platforms

Oracle, Oracle Database

Frameworks

VB.NET WinForms

Other

Excel Macros, Oracle Forms & Reports, Computer Science

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring