Mohammed Imran

Mohammed Imran
+91 7829272711(India)
+91-507052711(UAE)
[email protected]
Total years of Experience 14+ years

Total years of relevant experience 14 years
Currently working (Yes/No) Yes
Bench resource (Yes/No) No
Notice Period 30 days
Current location Dubai
Willing to relocate to job site? Yes
Interviews/Offer NA
Certifications (related to job description) Yes
Technical Skills Last Used Total Experience

ETL 2023 14 years
DataStage (8.7/11.5/11.7) 2023 14 years
PLSQL 2023 5 years
Unix 2023 8 years
Company Name Designation Start Date End Date Experience

Innovations Direct Senior ETL Aug 2019 Till Date 3.10 Years
Employment Developer
Services (Client:
Etisalat, Dubai)
IBM India Pvt Ltd, IT Specialist Sept 2009 July 2019 9.10 Years
Bangalore
Magna InfoTech Software Engineer Sept 2008 Jun 2009 10 Months
Pvt Ltd (Client:
IBM, Kolkata)
Supplier Summary:
 Experience in design and development and implementation along with principles of Data
Warehousing and worked on complex transformations using Datastage ETL, having good
experience in Pl/sql and unix.
Professional Summary:
 14+ years of IT industry experience encompassing a wide range of skill set, roles and industry
verticals.
 Extensively used ETL methodology for supporting Data Extraction, Transformation and Loading
processing using IBM InfoSphere Datastage 11.7.1.
 Experience of CDC Management Console.
 Have knowledge of IBM InfoSphere Information Server Manager.
 Have knowledge of ETL Tool Talend.
 Strong database skills and development knowledge
 Extensive experience on Netezza, SQL Developer and DB2, with expertise in SQL standards,
PL/SQL, Stored Procedures.
 Adequate knowledge on Oracle and UNIX
 Experience on Control-M to monitor, trigger and schedule jobs.
 Have strong analytical and proa short solving skills, co-operative, result oriented with a quest to
learn new technologies within short span and undertake challenging tasks.
 Motivation to take independent responsibility Ability to contribute and be a productive team
member.
 Flexible and versatile to adapt to any new environment and work on any project.
 Excellent oral and written communication skills.
 Experience in Agile methodologies.
Education/Certifications:
 B.Sc. in Computer Science, Andhra University. Vizag 2001.
Certifications:
 IBM InfoSphere Datastage V8.0, V8.5.
Technical skills/skill set:
 Operating Systems: Windows 7, 8, 10, Unix and Linux

 Databases : Netezza, DB2, SQL Server
 Languages : SQL, PL/SQL
 ETL : IBM Datastage 11.7.1.
 Other Apps : Control- M, Jira, CDC Console, DENODO, WinSCP, putty, SVN
* If break in service – a debrief on the gap

N/A
Professional Experience:
Innovations Direct Employment services (Client: Etisalat) Dubai Aug 2019 – Present
Senior ETL Developer
Project : Etisalat DWH Operations
Client : Etisalat
Workplace : UAE
Duration : Aug’19 to till date
Role : IT Support Specialist
Environment: Datastage 11.7.1, XML, Control-M, Aginity Workbench (Netezza), Oracle SQL Developer,
PL/SQL, UNIX, CDC Management Console.
Team Size: 5
Description:
Etisalat Group is one of the world’s leading telecom groups in emerging markets. Etisalat’s current
market cap is AED 148 billion ($40.3billion). The company’s consolidated net revenues are at AED 52.4
billion and consolidated net profit at AED 8.6 billion in 2018. Its high credit ratings reflect the company’s
strong balance sheet and proven long-term performance.
Headquartered in Abu Dhabi, Etisalat was established over four decades ago in the UAE as the country’s
first telecommunications service provider. An international blue-chip organization, Etisalat provides
innovative solutions and services to 143 million subscribers in 15 countries across the Middle East, Asia
and Africa.
Responsibilities:
 Monitoring the jobs flow through scheduling Control-M tool.
 Responsible for defect fixes in different production environments.
 Following proper escalation process (Leve1-Contorlroom, Level2-Client team) during production
issues
 Spot fixing the issues during production support time based on timeline and creating tickets
based on the severity.
 Incidents resolving and doing Root Cause Analysis for the problems fix.
 Responsible for process improvements by continuous transition of know-ledge to team
members for reduction of escalations.
 Involved in every phase of the ETL process starting from Analysis to Implementation
 Familiarize the team with the customer needs, specifications, design targets, the development
process, design standards, techniques and tools to support task performance.
 Analyses Design documents and code as per the design document, prepare Unit test cases,
conduct unit testing, capture the Unit test results & Responsible for code deliverables on time.
 Supported DataStage specific problems on call rotation 24/7.
 Monitor the DataStage servers. Kill/assist release job locks, hung processes etc.
 Stop/start services, monitor logs, assigning roles, project permissions, Create/Delete projects,
create/modify environmental parameters etc.
IBM India Pvt ltd, Bangalore Sep 2009 – July 2019

IT Specialist
Project 1 : Chief Information Office (CIO)
Client : IBM Internal
Workplace : IBM, Bangalore
Duration : Oct’17 to July’19
Role : Senior ETL Developer
Environment: Datastage 11.7.1, Data Studio 4.1.2(DB2), UNIX, PL/SQL, Windows 10
Team Size: 5
Description:
Chief Information Office (CIO) Business Transformation and Information Technology is a cross-functional
organization acting as an IT partner to various IBMs Business in creating a single Enterprise Integration
and Governance Model, while accelerating the delivery of business value, improving service quality,
simplifying BT/IT processes and delivering operational efficiency.
Responsibilities:
 Developed and Maintained Standards, Procedures, Guidelines and Best Practices.
 Reviewed all Project Level Data Movement Designs for adherence to Standards and best
Practices.
 Guided the coding and testing of standard data movement reusable components.
 Developed the Archive Files Script to call in the Sequence.
 Ability to understand complex Business Processes and their relationships.
 Developed design specifications for ETL jobs.
 Experience working with a customer to define requirements and translate requirements for
technical implementation.
 Design and implementation of data integration solution for specific business and technical
needs.
 Responsible for Design and development of Stored procedures to load data into user
tables/views.
 Provide Prod/UAT Support after Code Deployment
 Analyzing and fixing data related issues/defects
 Developed new Datastage Jobs for Long running Stored Procedures, so that the Data can load
faster.
 Design and build the various ETL components to extract, transform and load customer data from
different source systems into new target system and transform the conformed data for use by
data consumers.
 Provide reporting of project status to project management and leadership.
Project 2 : SCM Wealth Management Implementation

Client : SIAM Commercial Bank, Thailand
Duration : May’17 to Sept’17
Environment: Datastage 11.5, MYSQL, UNIX, Windows 7
Team Size: 1
Description:
Siam Commercial Bank is the first bank of Thailand, informally established in 1904 as Book Club, and
today it is a universal banking group in Thailand. Per the Bank of Thailand, it is Thailand's fourth largest
commercial bank in terms of total assets, deposits, and loans. The company’s asset management
services focus on mutual funds, provident funds, and private funds, which include equity, fixed income,
and property funds.
Responsibilities:
Practices.
needs.
data consumers.
Project 3 : Daimler AG
Workplace : Mercedes Benz R&D India, Bangalore
Duration : Feb’17 to May’17
Environment: Datastage 11.5, SQL Developer, UNIX, Windows 7
Team Size: 1
Description
Daimler AG is a German multinational automotive corporation. Daimler AG is headquartered in
Stuttgart, Baden-Württemberg, Germany. The Business Partner project is part of the extensive GET ONE
program with a solution to replace heterogeneous Business Partner systems with one European-wide
system that ensures high-quality information (single source of truth) about prospects, customers,
dealers and 3rd parties (e.g., suppliers) across all DFS units.
Responsibilities:
Practices.
 Developed new Data movement Design Patterns where Required.
 Good understanding of different changed data capture approached and techniques.
needs.
data consumers.
 Developed the Automation Deployment Script of Datastage code.
 Responsible for planning and creating release packages of the software and related ETL
components.
 Provided technical mentorship, guidance and supervisory oversight to a team of developers.
Project 4 : FORD Motors

Duration : May’16 to Jan’17
Team Size: 5
Description:
The macro design of SCA-C Release 1.0 had listed all current state components of CDR along with the
components that were to be upgraded, modified, installed, or changed. This document outlines SCA-C
Release 1.0 solution architecture; capturing the processes and components that require further detail or
those identified as being impacted due to the upgrades or migration from Trillium to QualityStage.
The scope identified for the SCA-C solution Release 1.0 is as follows:
• Upgrade MDM from version 10.1 to 11.4 and SQL Server
• Move Cleansing, Standardization, and Matching from Trillium to QualityStage
• Install IGC
• Perform end-to-end SCA-C testing to ensure current functionality is operational
• Turn off existing CDR and go-live with new SCA-C solution
Responsibilities:
• Understanding the business model and customer requirements.
• Preparing Technical Specific Document and mapping Documents by using Functional Specific
Document.
• Developing the flow with the different processes like Extraction, transformation and loading
process.
• Analysis and preparing of test cases to be carry out after the development
• Different levels of testing on each environment as per business requirements.
• Changing the design if the testing team identifies any defects in the code.
• Maintain the defects and the code changes in the Quality center.
• Unit testing of each component, module, unit testing plan, unite testing results, unit testing
status verification, unit test reports as per required templates.
• Involved in peer review of code/UTPs delivered by the team
• Involved in the SIT to identify the defect and resolve it within a time.
• Preproduction deployment of the code after satisfied test results and Business confirmation.
Project 5 : New Look - Atlas

Duration : March’16 to May’16
Team Size: 5
Description:
ATLAS is the name given to the programme as the result of a staff competition. ATLAS is not an acronym
but is a name that they thought encapsulated the idea that the solution being implemented is helping
them navigate to a global presence.
ATLAS is a key programme for New Look; it is part of their 3-year plan and is expected to transform the
potential of retail through providing new business capability and replacing legacy systems which
constrain the business and increase their operating costs.
As New Look’s Systems Integrator Partner, IBM is playing a key role in this transformation, taking
responsibility for managing the end-to-end delivery of the ATLAS programme. Our individual
contributions to the Programme’s success are crucial.
New Look is all about delivering fashion excitement, newness and value. We translate the latest trends
from the catwalk, celebrities, and the streets as fast as we can, providing our customers with fashion
that is always bang on trend. From jeans to evening dresses, shoes to shoulder bags, New Look
understands fashion. Our clothing and footwear collections are regularly award winning and we and are
proud to be among the top womenswear and accessories retailers in the UK. New Look isn't just for the
girls either - we have a fantastic menswear collection as well! With everything under one roof, we pride
ourselves on providing a truly unique offer of up to the minute fashion for all shapes and sizes!”
Responsibilities:
process.
Project 6 : IKEA FBIL

Duration : April’15 to March’16
Environment: Datastage 9.1, Information Analyzer, SQL Developer, UNIX, Windows XP, Clear Case,
BMC Remedy
Team Size: 8
Description
IKEA has developed several data warehouses over the last 10 years. The last attempt was back in
2005/2006 and ended up not delivering the stability nor the flexibility needed. The goal of introducing
an enterprise-wide data warehouse with shared information assets was not fully realized.
A consolidation of several legacy data warehouses will save money while giving the possibility of adding
new capabilities for data quality and traceability which will increase trust in data. Standardizing and
creating re-usable code/ETL will enable scalability and faster time to market. Improved BI governance
will ensure that the envisioned value with the new data warehouse will be realized.
Responsibilities:
• Creating Projects and creating all necessary connections to Oracle
process.
• Generate executable data rules for quality validation in Information Analyzer.
• Checking for the Connectivity of DataStage with Oracle 11g.
• Involved in peer review of code/UTPs delivered by the team
• Involved in the SIT to identify the defect and resolve it within a time.
• Production deployment of the code after satisfied test results and Business confirmation.
• Provide the warranty period, Development after Go-live of the code in production.
Project 7 : Prudential Financials

Duration : Feb’15 to Apr’15
Environment: Datastage 9.1, UNIX, Windows XP
Team Size: 10
Description
Prudential Financial offers a variety of products and services, including Life Insurance, Annuities,
Retirement-related Services, Mutual Funds, Investment Management and Real Estate Services.
Prudential Retirement delivers retirement plan solutions for public, private, and nonprofit organizations.
IBM has been partnering with Prudential Retirement Services since 2001 to support the technology
across all the areas (TRS, PSS & ISS, and Data & Integration Area). Its ultimate objective is to work with
the Prudential Retirements team providing application support, enhancements and testing services.
IBM is involved in different activities with Prudential right from the Planning phase up till the Support
phase along with Project Management.
Responsibilities:
 Involved in Business Requirements Analysis and with the stakeholders.
 Worked closely with Subject Matter Experts on the Requirement analysis, Source/Target data
analysis.
 Prepared the Technical Design Documents and Lower level Design documents for the technical
specs.
 Prepared the Implementation plan for the code migration to QA/Production.
 Co-ordinated the offshore team.
 Performed the End-to-End testing for the jobs/flow.
 Provided code approvals after peer review of the DataStage Jobs, steered Committee meetings
and conducted Impact analysis.
 Tuned DataStage jobs for better performance to bring design parallelism.
 Used CDC (Change Data Capture) Stage to Capture the New records and updated records and
implemented SCD type 2.
 Supported through Production for successful execution.
Project 8 : AT&T GCP-ETL

Duration : Aug’14 to Feb’15
Environment: Datastage 8.5, SQL Developer, Unix, Windows XP
Team Size: 5
Description:
AT&T is one of the Telecom giants in the USA.
GCP is Global Computing Platform, one of the interfaces what AT&T uses and which acts like a junction
for other platforms.
AT&T divides itself into applications.
GCP allows for a consistent data structure and values by shielding the legacy structures from new
demand applications. It provides a logical data model that is independent of the back end data systems.
It provides databases that are based on the approach to building the Enterprise Data Bus is based on the
Fine Grain approach currently being supported by the Tele Management Forum.
The ETL processes aims at maintaining data from other applications in GCP.
Responsibilities:
 Involved in Business Requirements Analysis and with the stakeholders.
 Worked closely with Subject Matter Experts on the Requirement analysis, Source/Target data
analysis.
 Prepared the Technical Design Documents and Lower-level Design documents for the technical
specs.
 Prepared the Implementation plan for the code migration to QA/Production.
 Co-ordinated the offshore team.
 Migrated projects from 8.1 to 8.5.
 Process the files received from the business and ensure that the downstream team is able to
consume the data.
 Performed the End-to-End testing for the jobs/flow.
 Provided code approvals after peer review of the DataStage Jobs, steered Committee meetings
and conducted Impact analysis.
 Tuned DataStage jobs for better performance to bring design parallelism.
 Used CDC (Change Data Capture) Stage to Capture the New records and updated records and
implemented SCD type 2.
 Supported through Production for successful execution.
Project 9 : Wal-Mart Global Replenishment System (GRS) AMS

Duration : Jan’13 to Jul’14
Environment: Datastage 8.5, UNIX, Teradata, Oracle, CA7 Scheduler, Windows XP/7
Team Size: 28
Description:
The Global Replenishment System (GRS) is an exception-driven and integrated system that will provide a
consistent replenishment platform across all countries and formats. This solution allows Replenishment
Managers to concentrate on forecasts, improving in-stock, minimizing risk and improving profits.
As a senior developer, I am responsible for analysis, testing and implementing various defects and work
on enhancements for GRS-Release 2 project for both US and international Wal-Mart stores along with
that AMS oriented Tasks.
Responsibilities:
 Monitoring the jobs flow through scheduling CA7 Mainframe tool.
 Responsible for defect fixes in different production environments and worked as well as
development work from ETL side.
 Following proper escalation process (Leve1-Contorlroom, Level2-onsiteteam&Client team)
during production issues
 Spot fixing the issues during production support time based on timeline and creating tickets
based on the severity.
 Incidents resolving and doing Root Cause Analysis for the problems fix.
 Responsible for process improvements by continuous transition of know-ledge to team
members for reduction of escalations.
 Involved in every phase of the ETL process starting from Analysis to Implementation
 Familiarize the team with the customer needs, specifications, design targets, the development
process, design standards, techniques and tools to support task performance.
 Analyses Design documents and code as per the design document, prepare Unit test cases,
conduct unit testing, capture the Unit test results & Responsible for code deliverables on time.
 Having Translated the Business requirements into ETL Parallel jobs that maximize object reuse,
parallelism, and performance.
 Worked along with Mainframe Team, used CA7 commands for scheduling the DataStage Jobs
and performed the End-to-End testing for the jobs.
 Supported DataStage specific problems on call rotation 24/7.
Project 10 : StoneSoup
Workplace : IBM, Kolkata
Duration : Sept’09 to Dec’13
Environment : Datastage 8.1, Windows XP, UNIX
Role : ETL Developer
Environment: Datastage 8.1, UNIX, Windows XP
Team Size: 6
Description
BDW (Banking Data warehouse) is a solution architecture defined by IBM with detailed banking business
content that can be applied broadly to many different types of initiatives. This is in co-ordinance with
the Financial Services data model (FSDM) and nine-data concepts defined by IBM. M1 tool provides the
logical model for banking data warehouse.
The project was to create a product which deals with commonly used attributes and measures in
banking and seamlessly integrated with financial institution’s existing framework to provide out-of-the-
box data warehouse.
BDW is integrating the logical model into a Physical dimensional model and finally the physical data
warehouse is loaded using target based ETL approach Target Based ETL allows to build components.
Independent of source systems and leverage these components across ALL sources. The three basic
components of the Target Based ETL Approach are Target Data Integration Models, Subject Area Data
Integration Models and Source System Data Integration Models. The entire logical model is divided into
different subject areas like classification, Involved Party, Arrangement, Exposure, collateral and
guarantee, obligor etc.
Responsibilities:
 Developed Parallel Jobs to extract the data from source files to IIW Subject Areas.
 Developed Job sequences and Master Sequence to Integrate tables for the different Subject
Areas of IIW.
 Analyze the Data Modeling and Prepare the Mapping document accordingly.
 Prepare the Test data for Unit testing and perform the unit testing for all the developed Jobs.
 Perform the UTP for developed Jobs.
 Deliver the Assigned tasks within time.
Magna InfoTech Pvt ltd (Client: IBM) Kolkata Sep 2008 – June 2009
ETL Developer
Project : NetApp
Workplace : IBM, Kolkata
Client : Network Appliances (NetApp), U.S
Duration : Sept’08 to June’09
Role : ETL Developer
Environment: Datastage 7.5X2, Oracle 9i, UNIX, Windows XP
Description:
NetApp Inc located at Sunnyvale, CA, USA entered a contract with IBM Corp under its Managed Services
Program (MSP) initiative to provide the following Application Management Services for a period of 4
Years and 10 months from
1-Jan-2008 to 31-10-2012:
 Build, Testing and Deployment of a new Business Intelligence System named EDWNI.
 Level 2 BI Incidence Management and Production Monitoring Support
 Level 3 BI Break-Fix and Enhancement Support
 Testing & QA support for all enhancements and development initiatives
Responsibilities:
 Analyze the tickets and prepare the analysis documents for the tickets and Resolve the Tickets
within the target time and prepare the final document for the resolved tickets.
 Prepare the Ticket Issue Tracker.
 Used Data Stage Director to run and monitor the Data Stage jobs.
 Worked with Datastage Designer and Datastage Manager.
 Created Complex Datastage Jobs and Parallel Routines.
 Perform the Unit Testing for the Resolved Jobs.
 Created Impact analysis documents for performance tuning jobs.
 Extensively interacted with clients for day-to-day work.

Mohammed Imran - ETL Datastage Developer

Uploaded by

Copyright:

Available Formats

Mohammed Imran - ETL Datastage Developer

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Mohammed Imran - ETL Datastage Developer

Uploaded by

Copyright:

Available Formats

Total years of Experience 14+ years

Technical Skills Last Used Total Experience

Company Name Designation Start Date End Date Experience

Technical skills/skill set:

 Operating Systems: Windows 7, 8, 10, Unix and Linux

* If break in service – a debrief on the gap

IBM India Pvt ltd, Bangalore Sep 2009 – July 2019

Project 2 : SCM Wealth Management Implementation

Project 4 : FORD Motors

Project 5 : New Look - Atlas

Project 6 : IKEA FBIL

Project 7 : Prudential Financials

Project 8 : AT&T GCP-ETL

Project 9 : Wal-Mart Global Replenishment System (GRS) AMS

You might also like