خورام شهزاد

Responsibilities as ETL Developer
• Worked extensively in Informatica Power Center Repository Manager, Designer, Workflow Manager and Workflow Monitor
• Extensive experience in integrating disparate data sources (flat files, XML, CSV) with multiple relational databases
• Implemented complex business rules in Informatica by creating re-usable transformations, robust mappings/mapplets, utilizing varied transformation logic like lookups, router, filter, expression, aggregator, joiner, update strategy, normalizer and more
• Expertise in performance tuning of the mappings, ETL Environments, procedures, queries and processes
• Expertise in handling and loading high volumes of data into data warehouse in a given load window
• Proficient in implementing ETL QA procedures and Exposure to all stages of Software Development Life Cycle
Responsibilities as Sr. PL/SQL Developer
• Involved in day to day Support activities
Khurram Awan (ks.awan78@gmail.com)
• Provided and developed solutions for automation of business processes.
• Developed complex Packages, Procedures, Functions, Triggers, Ref Cursors using PL/SQL Programming.
• Worked on performance tuning and used EXPLAIN PLAN for tuning the queries
• Worked on Bulk processing, REF cursors, collections, DBMS packages
• Participated in code reviews, unit test plan reviews, and other quality reviews defined by the system development lifecycle (SDLC). Identified and escalated issues that impacted testing progress
• Mentored junior programmers in Oracle database design and development
• Worked on Quality Assurance, Worked on Version control Systems
• Involved in enhancements and maintenance
• Involved in code walk through and review sessions with the development team.
• Involved in production support.

To Provide Technical support of Oracle E-Business Suite modules
General Ledger - GL / AP / AR & CORE HR, PAYROLL
• Development, Extension Customizations, integrations and Personalization of screen and reports (using Oracle FORMS / Oracle REPORT / XML - BI Publisher for Oracle E-Business Suite R12.
• Developing new Reports using XML publisher and Oracle Reports / Discoverer.
•OAF Development.
• Write, debug, database packages, procedures/ Function / Triggers in RDBMS using Oracle Technologies i.e. (SQL, PL/SQL) as per business requirement.
• Carry out user screens / reports Enhancement and personalization based on business requirements.
• Interact with Functional Consultant and business user to clarify requirements and propose/review design requirement.
• Develop detailed technical specification for system configuration, enhancement and to develop reports to meet the user requirements.
• Work with other team to ensure technical deliverables meet user requirements and co-ordinate on-time to complete dependent tasks.
• Coordinate with support team for any issue/system bug reported and coordinate with concern member to provide resolution to meet the user requirements.
• Overall internal and external day-to-day IT operations, providing overall management of technology vendor(s).
• Post implementation of applications, testing and maintenance.

ERP TECHNICAL SUPPORT: Investigate assigned incidents and repair software in all relevant versions as necessary ensuring that all faults are resolved within the applicable SLO.
Active participant of design review to give the necessary inputs to ensure that the design meets the defined performance with regard to specifications knowledge and product robustness if needed.
Perform Enhancement (CRs), Customization and development of Screens / reports for product, Code Review, Testing and providing Technical ERP Support.

• Conduct reviews to assess quality assurance practices in software products.
• Develop, execute and document software testing plans according to system specifications.
• Analyse user's needs and develop logical and physical specifications.
• Develop and implement software and information system testing policies, procedures and scripts.
• Identify and communicate technical problems, processes and solutions.
• Managing the deployment phase of projects/programs of varying complexity.
• Responsible for ITIL Service Support areas of Incident, Problem, Change, Release, Configuration Management and Service Desk.
• Provide user support on different third party and in-house applications on Oracle 9i/10g/11g and SQL Server databases.
• Analyse and prepare statistical Service Desk reports for the top management using Oracle Discoverer Ver-3.1 / 9i / 10g.
• Administering and configuring Oracle Discoverer V3.1 and V9.0.4/10g.
• Implement overall Change/Release Management policy and procedures according to ITIL Methodology in coordination with management and functional/operational team leads.
• Created Test Plans which describes the features and functions to be tested, reported bugs.
• Optimization of SQL queries and Implementation of Standards of PL/SQL Coding.
• Performed white-box testing of PL/SQL Coding.
• Performed Black-box Testing, functional and regression testing to guarantee high quality software products.
• Lead the Team of 3 members several times in the absence of Team Lead/QA Manager.
• Implementation of Software Development Standards.
• Analysis and Bug Fixing of Incident Reports by Client.

The system is a fully functional HRMS/PAYROLL system.
• The Designed Time Management system is fully functional and integrated with HRMS/PAYROLL module of Oracle apps.
• It includes complete cycle, right from new hire to employee termination/retirement.
• All human resources-related activities, like recruiting, performance management, learning, compensation, TM etc are included.
Responsibilities:
• Validating and designing Customized business processes that meet with client requirements.
• Design, developed, customized and configures HR Pay report that best suits with the client requirements.
• Designing and Implementation of elements, fast formulas, balances and setting up standard solutions such as employee liabilities available with business suit.
• PL/SQL programming.
• Building inbound/outbound interfaces between Oracle apps and other legacy systems.
• Design and Testing in Dev and QA instances (Following PDLC).
• Adhoc Reporting as per client’s requirement.
• Analysis and Bug Fixing of Incident Reports by Client.
• Handling Change requests from Clients

It is the biggest Food Production Company in the Middle East . It has Biggest Dairy Forms
in the whole Middle East and Asia. I worked as a Sr. Oracle Developer.

Attended user meeting to gather user requirements for system configuration.
• Worked as a Team Lead with a group of 3 members.
• Worked on PL/SQL stored procedures, Functions and Packages to implement business rules for eligibility review module.
• Maintain Sales and Distribution System (SARAS)
Khurram Awan (ks.awan78@gmail.com)
• Integration of new applications with SARAS.
• Involved in DBA activities like creating tables, indexes, views, synonyms and granting permissions to the users.
• Worked on performance tuning and used EXPLAIN PLAN for tuning the queries.
• Involved in creating different complex joins according user requirements.
• Involved in analysing complex queries and worked on performance tuning.
• Developing required reports using Reports 6i to implement project report requirement.
• Testing database, objects, Forms and Reports created to insure data integrity and application function.
• Logical modelling, Entity Relationship Diagrams (ERD).

Worked as a technical design authority and as a developer for a Manufacturing and Planning System (PACS2005), Attendance System and Job-Log System implemented in Developer 6i with a team of three members with full software development life cycle project responsibilities like designing, development, implementation and maintenance.
• Assisted other team members on various issues on SQL coding, PL/SQL coding in concepts and principal of Planning and Manufacturing operations.
• Creation of Standard and Reusable Components in order to meet Application Standards e.g. Template, Master Libraries providing the Application wide functionality, Leaf Form, LOV form
• Set-up and maintenance of generator environment standards and guidelines.
• Set up and maintenance of a set of supporting functional libraries divided into areas of common processing. A flexible, re-usable series of procedures provided dividends further in the project.
• Module Security definition referenced at form start up and implemented via a table driven security package with roles being dynamically assigned to users at run-time.
• Dynamic toolbar management (with complete integration between keystrokes, menu items, and toolbar buttons) dependent on user access rights to underlying data/functional area.
• key processing - to provide a common key definition
• Inter record, block, form navigation - to ensure common procedures are activated as appropriate
• Messaging using dialogue boxes and severity levels - to provide a common user messaging system with severity levels that will determine program flow.

• Development of Portfolio Management System by fetching data from Tadawal Website into Oracle DB with a team of two members with full software development life cycle project responsibilities like designing, development, implementation and maintenance.
• Development of HRMS
• Creating PL/SQL procedures, functions and triggers to enable global functionality.
• Attend End User Meetings to gather requirements.
• Verifying user requirements, developing a normalized model and designing database.
• Created constraints to help enforce data integrity throughout the data Warehouse.
• Developing user interface for application administration, user inventory/order input, processing and reporting.
• Developing required reports using Reports 6i to implement project report requirement.
• Analyzed, troubleshot and correct data integrity problems.
• Development of Ad hoc reports using Discoverer 10g.
• Development of User Interface for Supply Chain Management system.