Amjad Ali Email & Phone Number

Riyadh, Saudi Arabia

experienced SIS Consultant and Database Administrator with a strong background in implementing and supporting student information systems (SIS) such as Banner SIS, Anthology, and PowerSchool across various educational institutions. With expertise in data warehousing, business intelligence, and reporting, I have successfully designed and built comprehensive data warehouses for both Banner SIS and Oracle EBS Human Resources modules.Key achievements include developing advanced reports using Argos and Jasper Reports, creating insightful dashboards through Oracle BI, and supporting higher management with analytical insights. My proficiency in delivering tailored SIS solutions has been further strengthened through completion of Ellucian's Banner SIS enablement program, Anthology Students enablement program, and PowerSchool SIS Application Specialist learning path.I thrive in helping educational institutions streamline their operations and enhance their decision-making capabilities through data-driven solutions.

Dammam

Experienced Oracle EBS Reporting and Analytics specialist with a proven track record in developing and optimizing reports using Oracle Reports and BI Publisher. Skilled in converting Oracle Reports to BI Publisher for enhanced flexibility and scalability. Proficient in tuning and optimizing SQL queries and PL/SQL routines for improved performance and maintainability.Designed and implemented a payroll system integrating biometric data for accurate attendance and overtime calculations. Developed a data warehouse for Oracle Order to Cash and created insightful dashboards using BI Analytics. Significantly reduced storage size by analyzing and compressing Oracle EBS tables. Customized and personalized Oracle forms in Oracle EBS R12 for enhanced user experience.

Lahore, Punjab, Pakistan

Experienced Oracle Developer and Business Intelligence Analyst with a proven track record in designing, developing, and implementing mission-critical business systems for Descon Chemicals. Successfully delivered comprehensive HRMS, Attendance Management, Leave Application, Payroll, Provident Fund, and Tax Management systems to support the company's diverse operations. Demonstrated expertise in analyzing business requirements, designing efficient data structures, and developing robust Oracle-based solutions. Implemented VPD technology to enhance data security and ensure compliance with privacy regulations. Integrated HR systems with Oracle EBS to streamline procurement processes. Developed student information systems to support the company's technical institute, streamlining admission, student management, class scheduling, and fee administration. Additionally, designed and developed Oracle BI dashboards using Oracle payables data warehouse, providing valuable insights into financial performance.

Lahore, Punjab, Pakistan

Oracle Developer with Off-Shore Experience specializing in Oracle Database development for Landslide Inc., USA. Demonstrated expertise in leveraging Oracle's enhanced features to develop efficient and scalable program routines. Successfully implemented real-time environments using triggers and packages to populate fact tables. Refactored stand-alone procedures and functions into packages for improved modularity and reusability. Enhanced security by implementing Oracle's VPD technology. Proven ability to optimize database performance through database tuning and performance tasks. Technical proficiency includes installing Linux and Oracle 10g with Oracle Label Security option, managing database objects, and utilizing Data Pump for large-scale data import/export operations.

Lahore, Punjab, Pakistan

Skilled Oracle Developer with expertise in data loading and manipulation. Proficient in programming business logic to load data into databases from comma-separated text files. Demonstrated ability to populate CSV files with data from multiple database sources. Leveraged PL/SQL's advanced features, including PL/SQL records and PL/SQL tables, to create efficient and reusable packages, procedures, and functions. Committed to continuous improvement, regularly tuning and optimizing PL/SQL code for enhanced performance.

Lahore, Punjab, Pakistan

Experienced Oracle Developer and Analyst with a proven track record of working across multiple information systems, including Accounts, Payroll, and Production. Demonstrated ability to analyze user requirements and design effective forms and reports for store inventory, gates pass systems, and production systems. Applied SQL performance techniques, such as indexes, proper joins, and Explain Plan, to optimize database performance. Utilized PL/SQL to create packages, procedures, functions, and triggers for backend database tasks. Successfully tuned complex and slow application Forms and Reports. Developed PL/SQL programs to load production machine-generated data into database tables. Implemented automated backup scripts for multiple databases. Leveraged database links for data collection from head office and other units.

Lahore, Punjab, Pakistan

Versatile Oracle Developer and Trainer with a proven track record of designing, developing, and implementing database applications using Oracle 8 and Developer 6i. Successfully delivered Accounts Management Systems and Inventory Control Systems, demonstrating expertise in database design, PL/SQL development, and system implementation. Contributed to financial closing processes by writing backend PL/SQL routines. Demonstrated strong problem-solving skills in troubleshooting business logic issues. Provided effective user training to ensure successful adoption of developed applications.

Multan, Punjab, Pakistan

Oracle Application Developer with a strong background in implementing and optimizing Oracle-based systems. Successfully led the development of a new Accounts Management system using Oracle 8 and Developer 6, replacing an outdated Oracle 6 application. Demonstrated expertise in migrating and loading 10 years of historical data into the new system. Established seamless integration between the Accounts Management system and existing Sales software, enabling efficient generation of Sales Vouchers from General Ledger. Proven ability to optimize and tune General Ledger reports for enhanced performance and user satisfaction.

Lahore, Punjab, Pakistan

Empowered students to achieve Oracle Certified Professional (OCP) certifications in SQL, PL/SQL, Oracle Forms, Oracle Reports, and Database Administration. Passionate about delivering engaging and effective training experiences that equip learners with the skills and knowledge needed to excel in the Oracle ecosystem. SQL and PL/SQL ProgrammingOracle Forms and Reports DevelopmentOracle OCP Certification PreparationTechnical Writing and Documentation

Master Of Computer Sciences, Databases

Bachelor Of Commerce