Lokesh Resume Ab

Lokesh Mobile:7558477646
Email :[email protected]
____________________________________________________________
Objective:
To obtain a position that will utilize my skills and knowledge while contributing
in value and growth Of the organization.
Summary:
 Having 3+ year of IT experience into Ab-initio ETL Tool.
 Have been involved in the development and delivering enhancements to the
Extraction, Transformation and Loading process (ETL) of the Enterprise Data
warehouse.
 Gathering business requirements, Identifying Sources, target and
transformation logic as per the functional requirements.
 Have closely worked with EME (Enterprise Metadata Environment), which is
used as repository and familiar with various air commands.
 Have good experience in backend processing and familiar with various
m_commands.
 Good knowledge of Unix Commands and Oracle commands.
 Extensively worked with Ab-Initio GDE Database components, De-partition
components, and Partition components while implementing parallelism
techniques.
 Extensively worked with Transform components such as Reformat, Rollup,
scan, join etc.
 Proficient with various Ab-Initio Parallelism and Multi File System
techniques.
Professional experience:
 Working as a Software Engineer in Tech Mahindra Ltd, Pune Feb 2016 to till
date.
 Worked as Associate Software Engineer in capgemini india pvt
Ltd,Hyderabad from June 2014 to January 2016.
Technical Skills:
Data warehousing Tools Ab Initio 3.1.5
Database Oracle
Operating Systems Windows, UNIX
Educational Qualification:
 Diploma in E.E.E from State Board Technical education and Training.

 Project Summary :
Project #1:
Project Name : SMIP (Smart Metering)

Client : O2 Telefonica
Team Size : 7
Role : ETL Developer
Environment : Abinitio, UNIX, Oracle
Project Description:
Telefónica UK Limited (trading as O2 – stylised as O2) is a telecommunications

services provider in the United Kingdom, owned by the Spanish
multinational Telefónica, and is headquartered in Slough. With 25.3 million
subscribers (as of September 2017), O2 is the second-largest mobile network
operator in the United Kingdom after EE, with Vodafone in third place.
This project aims at building a Master data Model that will be loading
the some atomic tables in SMIP to three centralized master tables satisfying the
business criteria for populating all the fields. Atomic tables have basic information
about telephonic devices called commshubs(same as routers) and master tables
have the details about centralized information related installed devices and
problem cases if devices are not reached to customers.
Roles and Responsibilities:
 Analysis the business requirements.

 Used EME for check in, check out the graphs.
 Used different types of Abinitio components like DEDUP, ROLLUP,
REFORMAT, Filter by Expression, JOIN, SCAN, LOOKUP.
 Uses the multifile system and some of the partition and departition
components to achieve data parallelism.
 Used the sub graphs to increase the clarity of graph and to impose reusable
business restrictions and tested various graphs for their functionalities.
 Implementing phases and check point approach in ETL process to prevent
data loss and prevent uninterrupted data flow against process failures.
PROJECT#2:
VIZIO Network Data Mart
Client : VIZIO, USA
Role : Developer
Team Size :6
Environment: AbIntio , Co-Op System,orcle.
Project Description:
The Project deals with building an Enterprise Data Warehousing to build the
capability to better analyze the Customer Details. VIZIO consumer lending products and
are among the largest providers of electronics. Recap is the new system of record for
the charged off accounts at VIZIO. It replaces VIZIO old and obsolete Recoveries
platform that had limited business functionality and enhancement capabilities. VIZIO
Network Data Mart of VIZIO is Data Warehouse application that extracts the business
data. The data is extracted from OLTPs and/or other business applications and analysis
is done by the business users. The data is loaded into DWH System is used for reporting
purpose.
Roles & Responsibilities:
 Understanding the business requirements and developing graphs were my

major responsibilities in this project.
 Writing DML for Extracting the Data from Source Flat file.
 Extensively used various components like Input, Output (Table/File), Filter
by expression, Rollup, Sort with in groups, Dedup sorted, Reformat and Join.
 Using Partition components for Partition the Data and load it into Different
targets.
 Using Phases and Check Points for Optimizing the Graph
performance.ptimizing/Tuning graphs for better performance and efficiency.
 Involved in Unit Testing.

Lokesh Resume Ab

Uploaded by

Copyright:

Available Formats

Lokesh Resume Ab

Uploaded by

Document Information

Original Description:

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

Lokesh Resume Ab

Uploaded by

Copyright:

Available Formats

Lokesh Mobile:7558477646

Data warehousing Tools Ab Initio 3.1.5

 Diploma in E.E.E from State Board Technical education and Training.

Project Name : SMIP (Smart Metering)

Telefónica UK Limited (trading as O2 – stylised as O2) is a telecommunications

Roles and Responsibilities:

 Analysis the business requirements.

VIZIO Network Data Mart

Client : VIZIO, USA

Environment: AbIntio , Co-Op System,orcle.

Roles & Responsibilities:

 Understanding the business requirements and developing graphs were my

You might also like