AWAIS AHMAD

aca5mj@r.postjobfree.com

Mobile # 201-***-****

Talented Business Technology Analyst with more than 7 years of experience in IT industry. I am

working as a part of the team that provides the Business Analytics and Optimization services within

IBM Global Business Services

SUMMARY OF QUALIFICATIONS

• In depth knowledge of creating successful and value driven client’s proposals to win the projects.

• Technical and Functional experience with CRM, BI, Campaign Management and DWH projects

• Expert in creating presentation of software packages for the potential client for new business

opportunities.

• Expert in developing roadmap for the client, based on their business plans.

• Experience in selecting enterprise software packages and also the hardware to meet the specific

requirement of the client.

• Expert in analysing client’s legacy systems and business processes and transform them into new

business processes.

• Expert in solution outline processes including requirement capturing and mapping (to possible

solutions).

• Expert in managing Client–Vendor Define and Design workshops, structured and unstructured

interviews in handling functional and non functional requirements.

• Expert in creating Programs, Target campaigns, control campaigns, offers, segmentation,

incorporating external lists and managing regular and inferred responses in Siebel Campaign

management and IBM Unica Campaign Management.

• Expert in creating test plans, executing UAT and delivering the project.

• Expert in maintaining the quality throughout the SDLC

• Experience facilitating Joint Application Design (JAD) sessions

• In depth knowledge of delivery methodologies: Waterfall and Agile.

• Strong in writing SQL, BI reporting, DWH maintenance and administration.

• Expert in conducting client’s training sessions and persuade them to follow the standard

methodologies.

• Excellent Team player to work in conjunction with testers (QA), developers and other team

members in validation and testing of complex project scenarios and in the maintenance of Quality

Standards of projects.

• Fluent in a broad range of technologies, including business process tools such as MS Project,

Excel, Access, and Visio.

• Strong database integration experience. Worked on analyzing data needs, identifying relational

databases and coordinating the physical and logical modelling.

• Practical experience of IBM’s Global Services CRM Method (IBM CRM Best Practices)

• In-depth knowledge of data modelling, mapping and design using Visio.

• Adept at reducing development costs and providing traceability of projects.

• Skilled in promoting new sales to existing client.

• Excellent communication, analytical, interpersonal, and presentation skills; expert at managing

multiple projects simultaneously.

• Knowledge of the change control process and the ability to analyse change to minimise impact on

requirements and implementation

• Experienced in DataStage development process in a professional environment

• Efficient in incorporation of various data sources such as Oracle and DB2 and Flat files into the

staging area

• Strong Analytical and Problem Solving skills, Multi-Tasking abilities, with proven experience in

utilizing people and process knowledge to assist enterprises in making critical decision.

TECHNICAL SKILLS AND CERTIFICATIONS:

Databases: Oracle, DB2

GUI/Tools: MS Project, Visio, Access, Word, Excel

Platforms: Windows NT/2000/XP, AIX

Defect Tracking: Rational Clear Quest

Testing Tools: Rational Manual Tester

Certifications: Siebel 8.0 Certified Consultant & Siebel Certified Business Analyst, IBM

InfoSphere DataStage v8.1 Certified, IBM Cognos BI Author, IBM Unica Campaign V8.5

PROFESSIONAL EXPERIENCE

Warid Enterprise DWH, BI and Unica Solution Implementation, IBM July 2012 – Present

Providing Business & Technology Consultancy for IBM’s first ever Netezza DWH

implementation in MEA region, I am leading a team of business analysts who is providing

Business consultancy of Netezza DWH, Unica Campaign Management and Cognos BI

related solution implementation to the 2nd largest Mobile Company in Pakistan having largest

base of post paid customers.

I have been involved in the following tasks:

• Liaised with business and functional owners during Define and Design phase workshops

for requirement gathering, gap analysis and solution mapping

• Interfaced with business users to prepare and update Business Process Requirements

(BPR) and Software System Requirements (SSR). Created use cases and test scripts

• Devised extraction, transformation and load schemes for the process

• Execution of marketing activities and Campaigns across multiple channels.

• Created Campaign process flow diagrams using Visio.

• Mapped data between Oracle to Oracle, Oracle to Netezza databases to assist in analysis and

development phases of the project.

• Ensured all processes are complied with corporate SDLC Policies and guidelines

• Utilize skills and business knowledge to migrate the applications to Development and

Production environment.

• Performed GAP analysis of business rules, business and system process flows, user

administration, and requirements

• Involved in understanding the reporting requirements and re-engineering the existing regulatory

reporting process through consolidating regional databases into a global database

• Ensuring delivering business users right requirements within the agreed KPI

• Team up with ETL data architects to design quality reporting solutions

• Kept Updated with the changes in the IT systems that may affect the process and providing the

solution that keeps the process running properly

• Designing BI reports according to the Client’s requirement

• Executed SQL queries for Data analysis, completeness and accuracy

• Monitor all the Running processes during the Support period and keep the client updated on

daily basis

• Performs project management activities including documentation and project tracking

• Experienced with Administration tool i.e NzAdmin.

• Experienced in Reviewing Query History and Database Auditing.

• Created database using existing data model and devised data distribution strategy.

• Performed Administration and Operational Standard Practices (Groom, Statistics, Distribution,

Zone Maps)

• Prepared Netezza Skimmer and Netezza Production for development

• Managed Netezza Migration, Netezza Backup and restore activities

• Prepared Development and Productions Servers (AIX 6.1) for the Development Phase,

Installation Experience Includes

- DB2 Installation Support on AIX

- Cognos 10 Installation Support pn AIX

- InfoSphere DataStage 8.7 Installation Support on AIX

- ODBC/JDBC Installation Support on AIX

- Oracle Client Installation Support on AIX

• Conducted successful UAT and training sessions with the client and getting outstanding feedback

Jan 2012 – June 2012

Wateen DWH, BI and Unica Solution Implementation, IBM

Provided Business & Technology Consultancy for Netezza DWH implementation, I was part of a

team who provided consultancy of Netezza DWH and Cognos BI related solution implementation to

the largest WiMax and LDI service providing company in Pakistan.

I have been involved in the following tasks:

• Worked closely with project managers, business users to formalize a business idea and define

requirements.

• Interacted with the business users and division supervisors to gather the requirements.

• Developed functional documents like Mail and Receipting, New Filings, Status and Copies

business requirement specifications.

• Developed and implemented all multichannel marketing campaigns and flowcharts

• Prepared brief for all campaigns and tracked the progress

• Coordinated with Program Manager to maintain awareness on campaigns

• Developed Business Requirement Document (BRD) and the Design Document

• Created process flow diagrams using Visio

• Devised extraction, transformation and load schemes for the process from different data

sources

• Mapped data between Oracle to Netezza databases to assist in analysis and development

phases of the project.

• Queried relational databases using SQL on a daily basis to resolve operational issues and

assist business and IT in better understanding of business requirements.

• Conducted meetings with all the division supervisors to ensure that all the requirements are

met

• Developed DataStage Jobs and Sequences for the Required Dimensions and Cubes.

• Development of DataStage design concepts, execution, testing and deployment on the client

server

• Implemented the approved suggestions and modified the current process flows

• Utilize skills and business knowledge for the migration of applications to Development and

Production environment.

• Developed test cases and participated in UAT (User Acceptance Testing).

• Monitor, maintain and troubleshoot auto refresh process of DWH & BI tools, systems and

software

• Used Aggregator stages to sum the key performance indicators used in decision

support systems.

• Scheduled job runs using DataStage director, and used DataStage director for

debugging and testing.

• Performed project management activities including documentation and project tracking.

• Experienced with Administration tool i.e NzAdmin.

• Experienced in Reviewing Netezza Query History and Database Auditing.

• Created database using existing data model and devised data distribution strategy.

• Performed Administration and Operational Standard Practices (Groom, Statistics, Distribution,

Zone Maps).

• Performed performance tuning of the jobs by interpreting performance statistics of the jobs

developed.

• Documented ETL test plans, test cases, test scripts, and validations based on design

specifications for unit testing, system testing, functional testing, regression testing, prepared test

data for testing, error handling and analysis

Siebel Opportunity Management, Campaign Management and OBIEE Solution

Feb 2010 – Dec 2011

Implementation, IBM

Worked as a Siebel Technology Consultant and Test Lead in a team of 8 people on the largest CRM solution

implemented in Pakistan with the country’s biggest telecom operator having more than 40 million

subscribers.

• Conducted Define and Design phase workshops for requirement gathering, gap analysis and

solution mapping based on Siebel CRM 7.8 (Marketing and eCommunication Module).

• Worked closely with project managers, business users and developers to formalize a business idea

and define requirements using rational requisite pro

• Designed Operational Level Processes (OLP) for Siebel Opportunity Management.

• Developed Functional Requirements (FR) and Business Rules (BR).

• Developed Solution Design Documents.

• Developed Test Strategy and Test Plan Documents

• Created Requirement Traceability Matrix to make sure the current project requirements are being

met

• Followed IBM Standard procedures to improve the quality of process outputs and reduce

• Perform root cause analysis, develop solution options, and influence the organization to adopt

recommended solutions/trade offs

• Designed Test Cases and conducted System and Integration Testing of developed solution (Using

Rational Testing Suite: Rational ClearQuest Test Manager, Rational Manual Tester, Rational

Functional Tester, and Rational Performance Tester).

• Extensively worked on DataStage jobs splitting to achieve best job performance.

• Developed ETL jobs as per business rules using ETL design document

• Converted complex job designs to different job segments and executed through job sequencer for

better performance and easy maintenance.

• Used DataStage maps to load data from Source to target.

• Enhanced the reusability of the jobs by making and deploying shared containers and multiple

instances of the jobs.

• Imported the data residing in the host systems into the data mart developed in Oracle 10g.

• Performed Unit testing and System Integration testing and eventually initiated UAT by

developing and documenting test cases..

• Worked on troubleshooting, performance tuning and performances monitoring for enhancement

of DataStage jobs and builds across Development, QA and PROD environments.

Business Analyst, T-Mobile Exclusive Dealer Sept 2007 – Dec 2009

Worked as a Business Analyst and Test Manager. Performed the following tasks during my

tenure at T-Mobile

• Executed and performed the business analysis plan by working with the identified

stakeholder.

• Was responsible for creating and reviewing business requirements, functional specifications,

project schedules and other documentation.

• Conducted business analysis activities and supported business analysis communication.

Specified User and System functional requirements focusing on Data Flows

• Assisted effectively in requirements prioritization, performed requirements allocation and

documented requirements traceability.

• Supported verification, quality assurance and development activities which included

reviewing test scenarios and designing.

• Assisted in development of Test Plans and assisted QA team in System testing to ensure the new

system satisfy all User requirements.

College Intern

National University of Computer and Emerging Sciences Professional Training

Program June 2006 – July 2007

Every year National University of Computer and Emerging Sciences organize a professional

training program for the students so they can compete in a saturated IT market after

graduation.

During the training program each individual is out sourced to a company after the interview. I

was assigned to a well known abacus consulting.

Responsibilities:

• Assisted in creating the business analysis plan by working with the identified stakeholder.

• Assisted effectively in requirements prioritization, performed requirements allocation and

documented requirements traceability.

• Supported verification, quality assurance and development activities which included

reviewing test scenarios and designing.

• Performed daily check on different databases and required tables to ensure the availability

of a database after maintenance.

• Performed daily check for proper indexing on the tables.

• Assisted in creating test scripts for UAT.

EDUCATION:

Masters in Electrical Engineering

Stevens Institute of Technology, Hoboken, NJ, USA

Bachelors in Telecommunications Engineering

National University of Computer and Emerging Sciences (FAST-NU), Pakistan

REFERENCES:

Will be furnished upon request

Contact this candidate