AFZAL LODI

Cell: (1-403-***-****), Email: acqxhv@r.postjobfree.com

CAREER OBJECTIVE: To get responsible and challenging position in a reputable organization. Eager to contribute highly applicable business process management skills, analyzing business needs and translating them into executable strategies using latest development tools

SUMMARY

Over 10 years of experience in Software Development, Implementation, Batch Processing, Analysis and Design using latest development tools such as .SAP Business Objects (3x, 4x), PL /SQL, Oracle Databases versions (11g,/10g) and Schedulers

Involved in multiple life cycle implementations of SAP Business Objects, which includes Data modeling, Technical Design Specification, Requirement Gathering, Reports (Crystal, Webi and Oracle) and Dashboard Development

Experience in integration SAP Business Objects with SAP BW, SAP HANA, Oracle and MS SQL

Extensive experience in Business Objects in huge organizations and adapted required processes and best practices

3 full Life Cycle implementations for SAP Business Objects and Reports developments

Expert Understanding of SDLC, Software Development, Data Modeling, Star Schemas and Release procedures

Wide experience in applying business logic using SAP BOBJ, Crystal Reports for Enterprise, SAP Lumira, BO Analysis for OLAP, Dashboards and backend development using Oracle Packages, Procedures, Functions to implement the End to End project

Excellent Technical and user manual documentation skills

Working knowledge of SAP HANA

Advance Debugging, trouble shooting and excellent Application Tuning Experience

Expert in design of Entity Relationship Diagram (ERDs) and Data Flow Diagram (DFDs)

Wide Experience in Data Warehousing and Data Mart Designs

Excellent experience in implementation of Waterfall and Agile methodologies

Excellent experience in software development & providing technical support to users from remote locations

SAP Business Objects Certified Associate

Oracle Certified Professional (OCP)

TECHNICAL PROFILE

Software utilized: SAP BODS (4.x), SAP BOBJ (3x, 4x), BW/BI(7.x),Developer Suite (11G,10g, 9i), SQL, PL/SQL, Developer 2000, Forms, Reports, 9i AS, SQL* Loader, TOAD, UNIX Scripting, Oracle Designer, Oracle Discoverer

Business Applications: Sales and Distribution, Material Management, Migration, Government, inventory, Enrolment, Records Management, Retail, Data Warehousing, Tax, Y2K, Management Information System (MIS)

Operating Systems: Unix, Sun Solaris, Linux, Windows (2000, NT, 98, 95, 3X), DOS, AIX

RDBMS: Oracle (10g, 9i, 8x, 7.x,), MS SQL, SAP HANA

PROFESSIONAL EXPERIENCE

SHELL CANADA Feb 2013 till Date

Position: Senior SAP BI Analyst/Designer

Project: Sales and Distributions & Material Management

Environment: SAP Business Objects (3.x, 4.x), Oracle, SAP BODS.

Extensively worked on requirement analysis and preparation of High-level functional and technical design specification documents for Sales and Distribution

Proposed better solutions to the users to make the project more effective by reusability of the components and cater near future requirements

Perform End to End tasks using SAP Business Objects. Oracle to complete the project in tight deadlines

Developed Crystal reports using features of Crystal Reports such as Cross-Tab Reports, Vertical Reports, Charts, Grouping, sorting, mapping, formulas, database delegates etc

Developed Master Detail reports by linking the details reports from the master using Crystal Reports

Developed Crystal Reports based on tables, views, procedures, Universes & BEX Queries.

Designed and created Universes (UDT and IDT) using joins functions, derived tables, LOVs, Objects, Classes, prompts, hierarchies

Developed complex WEBI Reports using Queries, Vertical/Forms and Cross-Tab Tables, Charts, Ranks, Breaks, complex filters (Report and Query level), Variables and Functions, Merge different data sources and Universe Conditions

Created Packages, Procedures, Functions Nested Tables, Analytical Functions, Exceptions, Loops, DBMS Functions, Collections, Objects and REF Cursors extensively to accomplish certain development tasks.

Created Tables, Views, Materialized Views, Triggers and Constraints

Written Packages for Data warehouse systems in PL/SQL using features such as Bulk Collect and For All to enhance the performance.

Incorporated Object Oriented programing using Collections/Objects for in-memory computation to enhance performance.

Developed PL/SQL scripts for testing the Oracle code by setting up data and parameters to the PL/SQL code

Debugged the PL/SQL code for errors by using debugging techniques

Used Dynamic SQL where required to fulfill the business requirements

Written well-tuned SQL in Packages using performance techniques such as usage of indexes, avoid unnecessary joins, use of functions in the correct areas of SQL, used SQL on Collections etc.

Used Calculations Contexts such as For Each, For All and IN operators to fulfil the desired results

Used aggregate awareness and derived tables for fast processing of the reports.

Resolved Chasm Trap, Fan Trap, Alias and Context loops to resolve the issues and get the correct data

Scheduled the WEBI Reports and generated the report data in the form of required format such as emails to the users based on the scheduling requirement such as specific date and time of execution of Reports through Central Management Console (CMC)

Developed professional and complex Dashboards by applying Themes, Alerts, Dynamic Visibility techniques, Labels with Menus, Pie Charts, Column Charts, Line Charts etc.

Created BI Workspaces using BI Launch Pad to provide for WEBI Reports and Dashboards to the Users/Groups for quick access.

Created dependent and independent batch jobs by using different type of Transformations such as Platform Transformations, Data Integrator Platforms Transformation and Data Quality Transformation to perform complex Extraction, Transformation and Load from Source and Target Systems.

Done Unit and Integrated testing

Focal point of Situation Management

Lead the team on various occasions.

SHELL CANADA Jun 2011 to Jan 2013

Position: SAP BI Analyst/Designer

Project: Finance

Environment: SAP Business Objects (3.x, 4.x),Oracle, SAP BODS

Combine the data from different legacy systems based on Oracle and MS SQL into Central Database base for further processing and reporting for Finance sector

Extensively worked on requirement analysis and preparation of High-level specification document, Functional

Specification document for Finance project

Developed Crystal reports using features of Crystal Reports such as Cross-Tab Reports, Vertical Reports, Charts, Grouping, Sorting based on tables, views and database procedures.

Developed Master Detail reports by linking the details reports from the master using Crystal Reports

Written Packages to populate aggregate dimension and aggregate fact tables

Built SQL scripts to refresh system reference databases and keeping the integrity intact to avoid any referential integrity issues.

Created Packages, Procedures, Functions Nested Tables, Analytical Functions, Exceptions, Loops, DBMS Functions, Collections, Objects and REF Cursors extensively to accomplish certain development tasks.

Created Tables, Views, Triggers, Constraints

Incorporated Object Oriented programing using Collections/Objects for in-memory computation.

Written Packages for Data warehouse systems in Pl/Sql features like Bulk Collect and For All.

Designed and created Universes using joins functions, derived tables, LOVs, Objects, Classes, prompts, hierarchies in Oracle and MS SQL

Resolved Chasm Trap, Fan Trap, Alias and Context loops to get the correct data for the best outputs

Created complex WEBI Reports using queries, tables and charts, breaks and cross-tabs, complex filters (Report level and Query level), Merge & Universe Conditions

Used Calculations Contexts such as For Each, For All and IN operators to fulfil the desired results

Involved with security and implemented row level and object level security

Used aggregate awareness and derived tables for fast processing of the reports.

Used Desktop Intelligence to test the queries for the older versions.

Set up Universe level conditions to restrict data to enhance the reusability

Developed different type of charts such as Pie Chart, BAR Chart, Column Chart, to develop dashboards

Extracted data from Universes and BEX Queries to developed Dashboard/Xcelcius through Query Browser for BOBJ version 4.x and (QAAWS and SAP Netweaver BW Connection) for BOBJ 3.x

Used Object Browser to quickly adjust the components of Dashboards.

Migrated 3.x Universe (UNV) to 4.x Universe and changed the source of the WEBI reports to use the new universe.

Created batch jobs by using different type of Transformations such as Platform Transformations, Data Integrator Platforms Transformation and Data Quality Transformation to perform complex Extraction, Transformation and Load from Source and Target Systems

Used Local Repository for design/development and Central Repository for sharing and version controlling.

Worked on recovery mechanisms to recover the data.

Created dependent and independent Batch jobs using Projects, Jobs, Work Flows, Data Flows Scripts, Functions, Variables, Parameters and Template Tables to implement business logic

Created Datastores for Source schemas and Target schemas for different databases such as SAP BW/BI, Oracle and SQL Servers and file formats.

Defined initial transformation to capture the full load and delta loads to capture the change data records

Done Unit and Integrated testing

Coordinate with Vendors in situations to minimize the downtime in critical situations

SHELL CANADA Sep. 2008 May. 2011

Position: SAP BI Analyst/Developer & Support

Project: Blueprints(Global)

Environment: SAP BW/BI, SAP Business Objects (3.x)

Extensively worked on requirement analysis and preparation of High-level specification document, Functional

Specification document for Finance project

Analyze the reporting requirements with the business and functional users developed the technical specifications documents

Designed and Develop Universes using joins, objects, classes & conditions

Link different universe to the master universe to provide the data as per the requirements

Developed WEBI Reports using Query Filters, Report Filters, Charts, Break, Ranks

Extracted data through Universes to developed Xcelcius charts

Installed the BI Content and extended the content to add custom info objects. Modeled and created the end

to end connectivity using custom data sources, info sources and transformations

Created Info Objects, Info Packages, Info Providers (Info Cubes, Multiproviders, Virtual Providers), Process Chains & Data Store Objects (DSO)

Fix errors occurred in BI (e.g. SID errors, Referential Integrity errors, Dead Lock errors etc).

Monitored BI System periodically to check the performance of the BI and ECC Systems

Created DataSource (Master Data Attributes, Transaction Data and Text) based on flat Files, ECC Tables and Views

Created Open Hub to transfer the data to Non SAP Systems.

Created Bex Queries and worked on Bex Analyser to build Reports using different functions

Created and Monitor batch jobs in ECC using TCodes (SM36 and SM37), BI (Process Chains), Control M

Scheduler & VMS Scheduler

Worked on transports to move the source code into Acceptance and Production Servers

Followed/Maintained the standards of development and naming conventions.

Created Crystal and Oracle Reports based on the design specifications.

Support and resolve the issues for production systems.

SHELL CANADA Sep. 2006 Aug. 2008

Position: SAP BW/BI Analyst/Developer

Project: Stingray (Card Systems)

Environment: SAP BW, ORACLE 10g & 8i, Oracle Developer Suite 10g, TOAD

Created Source systems for various SAP R/3 and CRM instances. Created logical source systems and

Remote users to connect between the systems.

Worked extensively on BEx Query designer. Used Navigational attributes, Filters, Exceptions, Conditions,

Variables, Hiérarchies, etc.

Developed Bex reports on Sales and Distribution, Material Management, Billing, Inventory, Account receivable and general ledger.

Developed the ETL procedure to extract the past years’ worth of data into BW from heterogeneous sources

using generic, cockpit extraction of Sap and Data Stage and XML data sources

Developed and designed formatted, company-wide reporting (Enterprise Reporting) using the BEx Report Designer.

Created database packages, triggers, procedures and functions to accomplish/implement business logic

Debug errors occurs in the batch jobs, escalate the issue to the related team when needed

Written Packages for Data warehouse systems in Pl/Sql using ETL features like Bulk Collect and For All.

Written well-tuned sql and Pl/Sql by properly using Indexes, Pl/Sql tables, Pl/Sql records

Used Nested Tables, Analytical Functions, Exceptions, Loops, DBMS Functions, REF Cursors extensively

Built scenarios and tested the applications for Client Acceptance

Followed the rules of deployment of applications from Development to Test and from Test to Production

Coordinate with the business and the team members

Edmonton Power Corporation (EPCOR) April 2006 till July 2006

Position: BI Developer/Analyst

Project: Energy Validation System & Control, Analysis Reports (CAR)

Environment: Oracle Discoverer, Oracle Pl/Sql

Extensively worked on requirement analysis and preparation of High-level specification document, Function Specification document

Developed PL/SQL Packages to transform and conversion of data in the required formatExtraction the source Data from legacy system into the BW Data warehouse

Created and configured objects in BI System and generated the reports as per design specifications

Scheduled data loads in BW both for delta and full uploads

Created transformations and applied rules as per business requirements.

Uploaded master and transactional data from flat files .

Monitor data loading into the Data Targets

DEPARTMENT OF LEARNING, GOVERNMENT OF SASKATCHWAN November 2005 to March 2006

Position: Analyst/Programmer

Project: IISS & KIDS FIRST

Environment: Developer Suite (10g), PL/SQL, ORACLE 9i, Oracle Discoverer, UNIX Shell Scripting, J2EE

Developed Layouts/Interfaces and incorporated functionalities using Oracle Forms Developer (10g) & Oracle Reports Developer (10g) like Procedure based blocks, View based blocks, Report Objects, PL/SQL Libraries

Used Nested Tables, Analytical Functions, Exceptions, Loops, DBMS Functions, REF Cursors extensively

Developed complicated Matrix, Group Matrix, Tabular and Group Reports using Developer Suite (10g) Reports including extensively used SRWs to achieve the required objective

Adopted parameterized approach and avoid hard coding to make the system flexible

Used Oracle Discoverer for Ad-hoq queries, reports and analyzed data

Created Materialized Views on huge history tables in order to get quick response from the database

Used Star Team for the version controlling of the Objects

Designed Entity Relationship Diagrams (ERDs) & Data Flow Diagrams (DFDs) using Erwin

Built scenarios and tested the applications for Client Acceptance

Identified bugs and troubleshoot the problems in Forms, Packages, Procedures & Libraries

Developed scripts using Solaris for batch processing

IMEX SYSTEMS, CANADA September 2005 to October 2005

Position: Analyst/Developer

Project: Migration of Oracle Text application to Oracle (10g) for Web Deployment (Remote Development)

Environment: Developer Suite (10g), PL/SQL, ORACLE 9i, Oracle Designer, UNIX, VPN, Shell Scripting

Used Oracle Developer Suite (10g) to convert the Text based application into web-based application

Provided alternate solutions present in Oracle Developer Suite 10g against the obsolete functions in

Forms (4.5) and Reports (2.5) like Run Product etc.

Tested the Converted Forms and Reports including the execution of Procedures, Functions & Triggers

Documented the migration procedures/steps following the standard rules of documentation

Deployed the first release of web based application on 9i Application Server

PRAL November 2000 to June 2005

Position: Developer/Analyst

Project: LARGE TAX PAYER UNIT (LTU)

Environment: UNIX, Oracle 9i, PL/SQL, Developer Suite (10g, 9i) Advance Server 2000, Forms 6i, Reports 6i, 9iAS, Developer 2000, TOAD, Shell Scripting, Oracle Discoverer, ETL

Analyzed, Developed and Implemented Tax Return and Tax Receipts Management System using Oracle Developer Suite(10g), Oracle Discoverer, Forms, Reports, PL/SQL, Procedures, Functions, Packages & Triggers

Written quality PL/SQL codes in order to meet Business Requirements and Incorporated Tax Procedures

Provided optimum performance by writing quality and indented Sql as well as used proper index type like

B-tree Indexes, Reverse Key Indexes and Bitmap Indexes

Designed Data Flow Diagram (DFD) and Entity Relationship Diagram (ERD) using Erwin

Developed complicated Matrix, Group Matrix, Tabular and Group Reports using Developer Suite (10g) Reports including extensively used SRWs to achieve the required objective

Implemented very strong user security system module to provide limited/required access to the users

Prepared Technical documentation following the standard rules of documentation

Generated Ad-hoc queries, reports and analyzed data using Oracle Discoverer

Implemented strong Backup strategy to secure confidential data using RMAN & Standby database

Loaded Data from DB2 into ORACLE database through SQL Loader utility

Extensively used Oracle Enterprise Manager (OEM) to monitor Primary database.

Adopted Rapid Application Development (RAD) Life Cycle

Analyzed, Developed and Implemented web based Payroll System for LTU using JSP, HTML, Oracle Forms (9i), Reports (9i), PL/SQL, Database Procedures, Functions, Packages and Triggers

Used TOAD to run & create Sql Scripts, managed schemas and certain database & development operations

Added client side scripting code to JSP pages to provide more interactive user interface

Built Matrix, Group Matrix and Group Reports using Reports (9i) to print Pay Slips, Bank Reconciliation Statements, Allowances and Deductions Record of Staff along with other functionalities

Written Database Packages, Procedures and Functions to meet the Business Requirements

Developed interface for the posting of Payroll using Forms (9i) and written posting routine in PL/SQL

Pinned large important Packages to reside in memory for the faster execution of such Packages

Performed Tuning and managed database to provide maximum output in minimum time

Written Procedures, Functions, Triggers and Packages for ETL

Adopted parameterized and de-normalized approach and avoid hard coding

Written quality Dynamic SQL and performed data migration across databases

Created tables, indexes and managed schemas

Extract data from external sources like Access, Excel & text files using SQL Loader, Shell Scripting

& loaded into Oracle Data Warehousing schemas (ETL) by running certain batch process

Written certain Database Triggers & Procedures to clean the data for targeted repository

INTERNATIONAL BRANDS LIMITED (IBL) March 1999 to October 2000

Position: Developer/Analyst

Project: MANAGEMENT INFORMATION SYSTEM (MIS)

Environment: Forms 6i, Reports 6i, PL/SQL, UNIX, Shell Scripting, Oracle 8i, TOAD, Oracle Discoverer

Adopted Waterfall Life Cycle

Analyzed, Developed and Implemented the MIS System Using Developer 2000, Forms (6i), Reports (6i), PL/SQL, Database Procedures, Functions, Packages, UNIX shell scripting, Oracle Discoverer to provide full functionality to collect the data of every location in compact form.

The said system developed on the concept of Data warehousing

Parameterized and de-normalized approach was adopted

Created Materialized Views for the faster access of data

Introduced Summarized Module and developed Layouts/Interfaces in Forms (6i) and written quality PL/SQL

Code to implement this feature. This feature provides the functionally of reducing the number of records in a

great deal with no effect on the reports output. Due to this feature around 80 GB space got free

Developed Complex Matrix and Group Reports using Oracle Reports (6i) and features like SRWs etc

Built urgently required discount scheme for OXFORD UNIVERSITY PRESS using Dynamic Sql

Load external data from Text files, Excel files and MS Access files using SQL*LOADER

PROFESSIONAL EDUCATION / TRAINING

Two Years Under Grad Work

Associate Degree of Computer Science

Bachelors of Commerce Degree

Two years Diploma in Computer Software

Business Objects Certified Associate

Oracle Certified Professional (OCP)

SAP Business Object Training

SAP Business Objects Data Services

SAP BW-310 and BW-360 courses

ORACLE Database Course, ORA-TECH

Developer 2000 Certificate Course,

Java Certificate Course (SCJP2), ITS Education Campus

Contact this candidate